Plumbing Locations
31,192 US plumbing businesses, from national chains to single independent shops, with address, phone, website and map coordinates.
Buy the whole list — 31,192 rows · $162.51
Over 10,000 rows, we build the file after you pay and email you the link, about 2 minutes later.
Or ask for the part you need: an area, a distance, a condition. Counts and previews are free, and each answer shows its exact price.
Sample data
| name | address | city | state | zip | phone | website | overture id | brand | brand id | wikidata | category | category path | basic category | social | operating status | confidence | source dataset | source record id | source ids | source updated | data license | location type | location type confidence | location type basis | latitude | longitude | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ERS Backflow Testing, L.L.C. | 983 101st St | Roberts | WI | 54023 | (715) 441-8758 | http://www.erstesting.com/ | b406ed01-3913-4564-bf99-65e9f7473abf | backflow_service | |services_and_business|home_service|plumbing|backflow_service| | home_service | open | 0.92 | Microsoft | 1970324838185289 | Microsoft:1970324838185289|Overture-signals:0a90115f-efc7-4e31-94ca-a7d3a1527106 | 2026-08-10 | Overture Maps Foundation, CDLA-Permissive-2.0 | unknown | name: no premises word; website: none in its path; category: backflow_service names a business, not premises | 45.004555 | -92.59478 | ||||||
| Affordable Plumbing Pasadena | 1632 Corson St #G7 | Pasadena | CA | 91106 | (626) 225-0311 | http://www.plumbingservicespasadena.com/ | 74c10983-a4f5-460f-81f0-c11e727f1a33 | plumbing | |services_and_business|home_service|plumbing| | home_service | open | 0.92 | Microsoft | 1125899909229388 | Microsoft:1125899909229388|Overture-signals:7d085ab7-5c4e-48e9-98d6-52f34be660c5 | 2026-08-10 | Overture Maps Foundation, CDLA-Permissive-2.0 | unknown | name: no premises word; website: none in its path; category: plumbing names a business, not premises | 34.151533 | -118.116524 | ||||||
| G&M Mechanical LLC | 3300 Noel C Conaway Rd | Guyton | GA | 31312 | (912) 444-0934 | d47f758a-687d-44dd-9af3-c7124ede765a | plumbing | |services_and_business|home_service|plumbing| | home_service | open | 0.92 | Microsoft | 1970324839423789 | Microsoft:1970324839423789|Overture-signals:08468704-41bf-4c96-80e5-f4378fd099ef | 2026-08-10 | Overture Maps Foundation, CDLA-Permissive-2.0 | unknown | name: no premises word; website: blank; category: plumbing names a business, not premises | 32.195475 | -81.271587 |
What's in each row
| Field | What it is |
|---|---|
| overture_ | Map data id for the place, stable across monthly releases |
| name | Business name |
| brand | Brand or chain name, when the place belongs to one |
| brand_ | Our id for that brand (its Wikidata id where one exists) |
| wikidata | Wikidata id of the brand |
| category | Kind of place, from the map data |
| category_ | The category with every broader category above it |
| basic_ | A broader, simpler category |
| address | Street address |
| city | City |
| state | State (two-letter code) |
| zip | ZIP code |
| phone | Phone number |
| website | Website |
| Email address | |
| social | Social media page |
| latitude | Latitude |
| longitude | Longitude |
| operating_ | Whether the place is open, where the source says; closed places are left out of the list |
| confidence | How sure the map data is that the place exists (0 to 1) |
| source_ | Which source contributed the record |
| source_ | The record's id in that source |
| source_ | Every source record merged into this row |
| source_ | When the source last updated the record |
| data_ | The license the row is published under |
| location_ | Kind of premises: store, office, branch, warehouse and so on, read from the name, website and category |
| location_ | How sure the location type is (0 to 1) |
| location_ | What the location type was read from |
Source & license
Open map data from the Overture Maps Foundation, release of August 2026, refreshed monthly. Closed and low-confidence places are removed and duplicates within 50 meters merged. Contains data from Overture Maps Foundation (https://overturemaps.org), Places theme, licensed CDLA-Permissive-2.0 (https://cdla.dev/permissive-2-0/); some sources are Apache-2.0. See https://docs.overturemaps.org/attribution/.
Using ChatGPT, Claude or an API?
Ask this list a question with a link
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.
Open one of these to see how many places match, a few preview rows and the price for just those rows:
- The whole list: add a city, state, ZIP code or distance:
https://locationlists.com/find?dataset=plumbing-locations
Ask in ChatGPT or Claude
Copy this and paste it in:
Every answer shows its exact price before you pay, by card, no account; the whole list is $162.51, we email the file when it's built (about 2 minutes). Counts, previews and comparisons with other lists are free.
For developers
Dataset slug plumbing-locations. Machine-readable record: dataset.json. Without a connector, every one of these answers comes from a link: https://locationlists.com/find?dataset=plumbing-locations. Works in every MCP tool and the x402 query API like any other dataset (count_locations, get_sample, query_locations, relate_locations, count_by_area, cotenancy).