# Mela Watermelon Water Retailers — partial U.S.: 29 states location dataset

All 10,008 locations in partial U.S.: 29 states, as one CSV: 40 fields per record, 29 states, file built October 16, 2026. $49 one-time, with up to 10 real rows free before you buy.

Canonical URL: https://locationlists.com/data/mela-watermelon-water-retailers

10,008 stores that carry Mela Watermelon Water (10,008 in the US): every store on Mela Watermelon Water's own store locator on melawater.com. Name, address, phone, website and the locator's own store details.

## The figures

- Records: 10,008 locations
- States: 29
- Coverage: partial U.S.: 29 states
- Fields: 40
- Price: $49 one-time, CSV download, commercial license (https://locationlists.com/license)
- Snapshot built on October 16, 2026. Not rebuilt on a schedule.
- File last modified: 2026-10-16

The file has all 10,008 locations across 29 states in one download. Building the same list by searching one area at a time tends to miss places, and a missed place looks like a gap in coverage that is not really there.

## Fields

- `brand`: The brand whose store locator lists the store
- `storeId`: Store id (unique per place in this file)
- `storeName`: Store name as the brand's locator lists it
- `address`: Street address
- `city`: City
- `state`: State or province code (US always; outside the US where the locator gives one)
- `zip`: ZIP or postal code
- `country`: Two-letter country code
- `latitude`: Latitude
- `longitude`: Longitude
- `phone`: Store phone
- `phoneSource`: Where the phone came from: the brand's store locator, or the matched Overture place
- `website`: Store website
- `websiteSource`: Where the website came from: the brand's store locator, or the matched Overture place
- `status`: Listed
- `directionsUrl`: Google Maps directions link
- `brandLocatorStoreId`: The store's id on the brand's locator
- `brandLocatorUrl`: The brand's store locator page
- `countryAsPublished`: The country as the locator wrote it, where it differs from the code
- `source`: Source of the row
- `updatedDate`: Date the brand's locator was read
- `src_priority`: Another field the brand's locator publishes for the store: priority
- `isChain`: Y when 5 or more stores in these brand lists carry the same store name
- `chainName`: Chain name
- `chainStoreCount`: Stores with that chain name across these brand lists
- `overturePlaceId`: Overture Maps place id of the matched place (join key to Overture data)
- `overtureName`: Name of the matched Overture place
- `overtureCategory`: Overture category of the matched place
- `overtureBrand`: Brand of the matched Overture place
- `overtureMatchMeters`: Distance between the store and the matched Overture place, in metres
- `naicsCode`: NAICS 2022 code
- `naicsTitle`: NAICS title
- `sicCode`: SIC code
- `sicTitle`: SIC title
- `industrySource`: Where the industry code came from
- `geo_precision`: How the map point was set
- `county`: US county (from the store's coordinates)
- `county_fips`: US county FIPS code
- `county_note`: Set when the ZIP spans counties
- `address_quality`: complete, no_house_number, po_box, missing_city_or_zip or missing

## Ask this list a question with a link

No connector and no account; each link answers with the matching count, preview rows and the price for just that part.

- [Only California, the state with the most](https://locationlists.com/find?dataset=mela-watermelon-water-retailers&state=CA)
- [Within 25 miles of Los Angeles, CA, the busiest area](https://locationlists.com/find?dataset=mela-watermelon-water-retailers&near=Los+Angeles+CA&radius=25)
- [Within a 30-minute drive of Los Angeles, CA](https://locationlists.com/find?dataset=mela-watermelon-water-retailers&near=Los+Angeles+CA&drive=30)
- [Only rows where isChain is Y](https://locationlists.com/find?dataset=mela-watermelon-water-retailers&where=isChain%3Aeq%3AY)
- [Every Drinks & Hydration list combined, within 25 miles of Huntington Park, CA](https://locationlists.com/find?category=drinks-and-hydration&near=Huntington+Park+CA&radius=25)
- [Each one's nearest Skypop Retailers, in California, with miles](https://locationlists.com/find?dataset=mela-watermelon-water-retailers&state=CA&relate=nearest&k=1&b.dataset=skypop-retailers&b.state=CA)
- [The whole list: add a city, state, ZIP code or distance](https://locationlists.com/find?dataset=mela-watermelon-water-retailers)

## The same dataset, for machines

- Record as JSON: https://locationlists.com/data/mela-watermelon-water-retailers/dataset.json
- Free sample, up to 10 real rows: https://locationlists.com/data/mela-watermelon-water-retailers/sample.csv or https://locationlists.com/data/mela-watermelon-water-retailers/sample.json
- Buy link (opens Stripe Checkout): https://locationlists.com/data/mela-watermelon-water-retailers/buy

## Questions

### Where does this data come from?

From Mela Watermelon Water's own store locator on melawater.com. We read every store on its map on 2026-10-16. A store the map shows twice (same name and address) is one row.

### What is one row?

One store on the brand's locator, with the brand's own tags for it (storeType) and any custom fields the locator shows.

### Does it include stores outside the US?

No. Every store in this list is in the US.

### Where do websites and phones come from?

From the brand's locator where it gives them. Otherwise from the Overture Maps place at the same spot with the same name. phoneSource and websiteSource say which.

### How complete are phones and websites?

7,270 of the 10,008 stores have a phone, and 6,751 of the 10,008 have a website.