Mela Watermelon Water Retailers
United States · 10,008 locations
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.
More about this list
Name, address, phone, website and the locator's own store details.
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.
Need just some of them? Ask in your own words.
●Where the rows are
≡Sample Data Preview
| store name | address | city | state | zip | phone | website | brand | store id | phone source | website source | status | directions url | brand locator store id | brand locator url | country as published | updated date | src priority | is chain | chain name | chain store count | overture place id | overture name | overture category | overture brand | overture match meters | naics code | naics title | sic code | sic title | industry source | geo precision | county | county fips | county note | address quality | country | latitude | longitude | source |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Blue Pants Tap Room | 500 Lanier Rd Ste 1A | Madison | AL | 35758 | Mela Watermelon Water | u20587-31613024 | Listed | https://www.google.com/maps/dir/?api=1&destination=34.68456828,-86.73851421 | 31613024 | https://melawater.com/pages/find-store | United States | 2026-10-16 | 0 | N | source | Madison County | 01089 | complete | US | 34.68456828 | -86.73851421 | Mela Watermelon Water store locator | |||||||||||||||||
| Reed Exhibitions | 201 Merritt 7 Ste 1 | Norwalk | CT | 06851 | (203) 840-4800 | http://www.reedexpo.com | Mela Watermelon Water | u20587-31615297 | Overture Maps place | Overture Maps place | Listed | https://www.google.com/maps/dir/?api=1&destination=41.15026742,-73.42611203 | 31615297 | https://melawater.com/pages/find-store | United States | 2026-10-16 | 0 | N | 5c99f49a-11b7-4838-92af-f37db9804de8 | Reed Exhibitions | event_or_party_service | 17 | source | Western Connecticut Planning Region | 09190 | complete | US | 41.15026742 | -73.42611203 | Mela Watermelon Water store locator | |||||||||
| Ky Tn Section Awwa | 3801 Springhurst Blvd Ste 201 | Louisville | KY | 40241 | Mela Watermelon Water | u20587-31611538 | Listed | https://www.google.com/maps/dir/?api=1&destination=38.30336276,-85.55941402 | 31611538 | https://melawater.com/pages/find-store | United States | 2026-10-16 | 0 | N | source | Jefferson County | 21111 | ZIP 40241 spans 2 counties; assigned to the county holding 98% of its land area | complete | US | 38.30336276 | -85.55941402 | Mela Watermelon Water store locator | ||||||||||||||||
| Cvs Pharmacy #2292 | 986 Main St | Fishkill | NY | 12524 | (845) 896-2067 | https://www.cvs.com | Mela Watermelon Water | u20587-31613279 | Overture Maps place | Overture Maps place | Listed | https://www.google.com/maps/dir/?api=1&destination=41.53066804,-73.90751211 | 31613279 | https://melawater.com/pages/find-store | United States | 2026-10-16 | 0 | Y | Cvs Pharmacy | 103 | ea0b308e-8d27-41be-b931-96676fcdfa69 | Cvs Pharmacy | pharmacy | 117 | 456110 | Pharmacies and Drug Retailers | 5912 | Drug Stores and Proprietary Stores | Overture category of the matched place | source | Dutchess County | 36027 | complete | US | 41.53066804 | -73.90751211 | Mela Watermelon Water store locator | ||
| Waterbird Spirits | 201 W Water St | Charlottesville | VA | 22902 | Mela Watermelon Water | u20587-31611266 | Listed | https://www.google.com/maps/dir/?api=1&destination=38.03016231,-78.48071286 | 31611266 | https://melawater.com/pages/find-store | United States | 2026-10-16 | 0 | N | source | Charlottesville city | 51540 | ZIP 22902 spans 3 counties; assigned to the county holding 4% of its land area | complete | US | 38.03016231 | -78.48071286 | Mela Watermelon Water store locator |
{}What's in each row
| Field | What it is | Rows filled |
|---|---|---|
| brand | The brand whose store locator lists the store | 100% |
| store | Store id (unique per place in this file) | 100% |
| store | Store name as the brand's locator lists it | 100% |
| address | Street address | 100% |
| city | City | 100% |
| state | State or province code (US always; outside the US where the locator gives one) | 100% |
| zip | ZIP or postal code | 100% |
| country | Two-letter country code | 100% |
| latitude | Latitude | 100% |
| longitude | Longitude | 100% |
| phone | Store phone | 73% |
| phone | Where the phone came from: the brand's store locator, or the matched Overture place | 73% |
| website | Store website | 68% |
| website | Where the website came from: the brand's store locator, or the matched Overture place | 68% |
| status | Listed | 100% |
| directions | Google Maps directions link | 100% |
| brand | The store's id on the brand's locator | 100% |
| brand | The brand's store locator page | 100% |
| country | The country as the locator wrote it, where it differs from the code | 100% |
| source | Source of the row | 100% |
| updated | Date the brand's locator was read | 100% |
| src_ | Another field the brand's locator publishes for the store: priority | 100% |
| is | Y when 5 or more stores in these brand lists carry the same store name | 100% |
| chain | Chain name | 30% |
| chain | Stores with that chain name across these brand lists | 30% |
| overture | Overture Maps place id of the matched place (join key to Overture data) | 75% |
| overture | Name of the matched Overture place | 75% |
| overture | Overture category of the matched place | 75% |
| overture | Brand of the matched Overture place | 23% |
| overture | Distance between the store and the matched Overture place, in metres | 75% |
| naics | NAICS 2022 code | 50% |
| naics | NAICS title | 50% |
| sic | SIC code | 50% |
| sic | SIC title | 50% |
| industry | Where the industry code came from | 50% |
| geo_ | How the map point was set | 100% |
| county | US county (from the store's coordinates) | 100% |
| county_ | US county FIPS code | 100% |
| county_ | Set when the ZIP spans counties | 18% |
| address_ | complete, no house number, po box, missing city or zip or missing | 100% |
Rows filled is measured on every row of the delivered file.
✓Where this data comes from
Each row names the public source it came from, so any record can be checked against where it was published.
October 16, 2026
Snapshot built
40 fields
Columns in the file
Fill measured
On every row of the delivered file
How we build and date every file: methodology.
Using ChatGPT, Claude or an API?
No setup needed. Ask ChatGPT or Claude your question about the Mela Watermelon Water Retailers and give it this page: it can open https://locationlists.com/find?dataset=mela-watermelon-water-retailers with the filters you need and show you the count and price.
Using ChatGPT or Claude? Tell it to answer from locationlists.com/find — no account, no connector.
How assistants ask
No connector needed. Any AI assistant can answer from this site with a web link, no connector, no account: open https://locationlists.com/find with the question as query parameters.
If a question needs filtering, distance, drive time, combining lists or a price, open a /find link: either put the question itself in q=, or build the structured link. The answer does not need an API, a connector or an account.
Simplest, the question itself: https://locationlists.com/find?q=<the question in plain words>
Or set the parts yourself: https://locationlists.com/find?dataset=<slug>&state=<ST>&city=<city>&county=<county>&zip=<zip>&near=<place or zip>&radius=<miles>&drive=<minutes>&where=<column>:<op>:<value>&total=<rows>
Leave out what the question does not need. Use radius for straight-line miles or drive for minutes of driving (5 to 60), not both; near can name several places separated by | to reach from any of them. To ask about several lists at once, use datasets with two or more names, or category with a kind of business. To compare two lists, add relate=nearest and the other list with b. in front of its parameters. To count by area, use areas=county (or zip, state, metro). To keep only places whose county, ZIP code, metro area or state meets a Census figure, add area_where (for example county:population>1000000); with areas, per=100000 gives counts per 100,000 residents.
Links an assistant can open, each showing how many rows match, a few 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 - In plain words: "Mela Watermelon Water Retailers in California": https://locationlists.com/find?q=Mela+Watermelon+Water+Retailers+in+California
- In plain words: "Mela Watermelon Water Retailers within 25 miles of Los Angeles, CA": https://locationlists.com/find?q=Mela+Watermelon+Water+Retailers+within+25+miles+of+Los+Angeles%2C+CA
Optional: connect for repeat use or wallet payments:
Read https://locationlists.com/skill.md and follow the instructions to connect LocationLists. Then show me the Mela Watermelon Water Retailers list.Your assistant will walk you through setup and show you the price before you pay.
For developers
Every step below has a no-connector equivalent: https://locationlists.com/find?dataset=mela-watermelon-water-retailers with the same filters as query parameters.
- Connect your agent to
https://locationlists.com/mcp(no key, no signup). - Call
count_locationswithdataset: "mela-watermelon-water-retailers"and any filter — it is free, and returns how many rows match and what they cost. - Fetch the rows with
query_locations: $0.99 per 100 rows from this dataset. Above 5,004 rows, buying the whole file is cheaper.
Paid in USDC over x402 — the agent gets an HTTP 402 with the exact price, signs, and retries. Money moves only after rows are delivered, so a failed or empty query costs nothing. Setup for Claude, Cursor and VS Code
?Frequently Asked 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.