Pub Locations
16,532 US pub businesses, from national chains to single independent shops, with address, phone, website and map coordinates.
Buy the whole list — 16,532 rows · $87.96
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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| The Wild Rover | 2620 Broadway | Redwood City | CA | 94063 | (650) 363-2620 | http://thewildroverpub.com/ | 76330d83-5954-431a-bb2e-69cb14d31063 | irish_pub | |food_and_drink|alcoholic_beverage_venue|bar|pub|irish_pub| | bar | thewildroverrwc@gmail.com | https://www.facebook.com/729579893563972 | open | 0.99 | meta | 729579893563972 | meta:729579893563972|Overture-signals:9065c6f3-53a6-468f-bfc7-951b2ed11b78 | 2026-08-10 | Overture Maps Foundation, CDLA-Permissive-2.0 | unknown | name: no premises word; website: none in its path; category: irish_pub names a business, not premises | 37.486517 | -122.233826 | ||||
| Tj's Irish Pub | 12020 Fort Caroline Rd | Jacksonville | FL | 32225 | (904) 997-8944 | http://Tjsirishpub.com/ | 17c73489-3575-408c-b678-3a5c3cf6f8ce | irish_pub | |food_and_drink|alcoholic_beverage_venue|bar|pub|irish_pub| | bar | tjsirishpub@gmail.com | https://www.facebook.com/125966620752769 | open | 0.974 | meta | 125966620752769 | meta:125966620752769|Overture-signals:67b601e5-bcc1-495b-a2d1-0035ee9eb683 | 2026-08-10 | Overture Maps Foundation, CDLA-Permissive-2.0 | unknown | name: no premises word; website: none in its path; category: irish_pub names a business, not premises | 30.37899 | -81.508148 | ||||
| Pub 178 | 178 Cedar Ln | Teaneck | NJ | 07666 | (201) 692-0016 | http://www.pub178.com/ | 49ee8fe3-f33c-4e8d-971e-e93a7ba677b7 | irish_pub | |food_and_drink|alcoholic_beverage_venue|bar|pub|irish_pub| | bar | irishpub178@gmail.com | https://www.facebook.com/531776746679322 | open | 0.99 | meta | 531776746679322 | meta:531776746679322|Overture-signals:37b67912-a5ae-405c-b64f-a7763780a61e | 2026-08-10 | Overture Maps Foundation, CDLA-Permissive-2.0 | unknown | name: no premises word; website: none in its path; category: irish_pub names a business, not premises | 40.885784 | -74.012691 |
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=pub-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 $87.96, we email the file when it's built (about 2 minutes). Counts, previews and comparisons with other lists are free.
For developers
Dataset slug pub-locations. Machine-readable record: dataset.json. Without a connector, every one of these answers comes from a link: https://locationlists.com/find?dataset=pub-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).