U.S. Bars and Pubs Database

Explore 97,738 selected bars, pubs, beer gardens, and nightclubs across the United States in one downloadable location database. Build maps and directories, compare territories, and research...

Ready for your workflow

Flexible data delivery

Delivered files
UTF-8 CSV, JSON, SQLite, schemas, samples, statistics, documentation, and tier-specific ZIP bundles.
Updates
Current release 2.0.0 dated October 19, 2026. Update eligibility follows the selected license.
Preview sample data
Choose your licensePurchase once. Download immediately.
Secure checkout
Usage RightsInternal organizational research, operations, development, and decision-making. No customer-facing publication or bulk dataset handoff. Formats: CSV, JSON, SQLite.
$50.00
Master RightsAll Publication rights, plus raw or transformed dataset handoff within a genuine client project. Standalone dataset resale requires a separate addendum. Formats: CSV, JSON, SQLite.Current update offer$12.50For eligible earlier Master purchases
$200.00
Records
97,738
Version
2.0.0
Release date
Oct 19, 2026
Before you choose
Explore the samples

Current release story

Latest update

Version 2.0.0 October 19, 2026 Build #183

U.S. Bars and Pubs Database 2.0.0

A documented, fixed-vintage directory of 97,738 bar and pub venue locations across the 50 states and Washington, DC.

Read the update announcement Release questions and guidance
U.S. Bars and Pubs Database List

U.S. Bars and Pubs Database v.2.0.0

97,738 Bars and Pubs

U.S. Bars and Pubs Database catalog icon U.S. Bars and Pubs Database Download
U.S. Bars and Pubs Database artwork
Explore 97,738 selected bars, pubs, beer gardens, and nightclubs across the United States in one downloadable location database. Build maps and directories, compare territories, and research local markets using names, addresses, coordinates, and available contact details. Choose the Usage, Publication, or Master license and work with CSV, JSON, or SQLite data.
97,738 Bars and Pubs Records
SAMPLE DATA TABLE STRUCTURE RECORD INFO
Restaurants Drink Recipes Recipes Restaurant Profiles Starbucks

License Database Purchase Options

PUBLICATION

Publication Rights

$100.00

Publish and build for clients

All Usage rights, plus customer-facing websites, apps, reports and client projects without bulk dataset handoff.

Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.

Read the complete Oddity Software Publication License

Choose this package above

MASTER

Master Rights

$200.00

Client dataset handoff

All Publication rights, plus raw or transformed dataset handoff within a genuine client project. Standalone dataset resale requires a separate addendum.

Current Master update offer$12.50For an eligible earlier Master purchase. The fee is checked again when a new release is available.

Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.

Read the complete Oddity Software Master License

Choose this package above

Table Schema Database Field Statistics

Release structure

U.S. Bars and Pubs Database

Review the published tables, record coverage, and field names included with release 2.0.0.

Database
#9
Version
2.0.0
Format
XML schema

Data dictionary

Tables and fields

Release-defined structure
TableRecordsFields
venuesvenue_id, venue_name, brand_name, physical_address, city, state, state_code, postal_code, country, phone, website, social_links, venue_type, operating_status, existence_confidence, latitude, longitude, source_vintage, legacy_match_status, legacy_id, legacy_biz_name, legacy_e_address, legacy_e_city, legacy_e_state, legacy_e_postal, legacy_e_zip_full, legacy_e_country, legacy_loc_county, legacy_loc_area_code, legacy_loc_FIPS, legacy_loc_MSA, legacy_loc_PMSA, legacy_loc_TZ, legacy_loc_DST, legacy_loc_LAT_centroid, legacy_loc_LAT_poly, legacy_loc_LONG_centroid, legacy_loc_LONG_poly, legacy_web_url, legacy_web_meta_title, legacy_web_meta_desc, legacy_web_meta_keys, legacy_biz_phone

Release at a glance

What is inside this database

97,738 source-reported-open U.S. bars, pubs, beer gardens, and nightclubs across 50 states and DC. Point-in-time directory; coverage is not exhaustive and operating status is not live.

97,738Records in this release
43Fields per record
0Duplicate records
90,238Rejected source rows

Geographic coverage

This release represents 51 state or territory codes. The 12 largest totals are shown below.

  • TX8,813
  • CA8,564
  • NY7,263
  • FL6,877
  • IL5,439
  • PA4,388
  • WI4,319
  • OH4,111
  • NC2,793
  • MI2,701
  • WA2,271
  • GA2,079

Venue Type

Showing the 12 largest groups from 20 represented values.

  • Bar39,072
  • Sports Bar15,951
  • Pub10,728
  • Cocktail Bar9,366
  • Wine Bar5,307
  • Dance Club4,597
  • Dive Bar4,309
  • Beer Bar2,420
  • Irish Pub2,187
  • Beer Garden1,109
  • Gay Bar894
  • Tiki Bar575

Table and column statistics

Select a table to review its schema, record total and fields. Distinct and missing-value counts appear where measured.

venues97,738 records · 43 fields
venue_id
Distinct
97,738
Missing
0 (0.0%)
venue_name
Distinct
83,241
Missing
0 (0.0%)
brand_name
Distinct
1,566
Missing
92,433 (94.6%)
physical_address
Distinct
85,666
Missing
1,475 (1.5%)
city
Distinct
9,855
Missing
32 (0.0%)
state
Distinct
51
Missing
0 (0.0%)
state_code
Distinct
51
Missing
0 (0.0%)
postal_code
Distinct
39,881
Missing
1,220 (1.2%)
country
Distinct
1
Missing
0 (0.0%)
phone
Distinct
86,565
Missing
9,400 (9.6%)
website
Distinct
72,177
Missing
22,081 (22.6%)
social_links
Distinct
73,260
Missing
0 (0.0%)
venue_type
Distinct
20
Missing
0 (0.0%)
operating_status
Distinct
1
Missing
0 (0.0%)
existence_confidence
Distinct
22,164
Missing
0 (0.0%)
latitude
Distinct
97,217
Missing
0 (0.0%)
longitude
Distinct
97,271
Missing
0 (0.0%)
source_vintage
Distinct
1
Missing
0 (0.0%)
legacy_match_status
Distinct
2
Missing
0 (0.0%)
legacy_id
Distinct
7,611
Missing
90,127 (92.2%)
legacy_biz_name
Distinct
6,965
Missing
90,127 (92.2%)
legacy_e_address
Distinct
7,536
Missing
90,127 (92.2%)
legacy_e_city
Distinct
2,715
Missing
90,127 (92.2%)
legacy_e_state
Distinct
51
Missing
90,127 (92.2%)
legacy_e_postal
Distinct
4,579
Missing
90,127 (92.2%)
legacy_e_zip_full
Distinct
7,099
Missing
90,540 (92.6%)
legacy_e_country
Distinct
1
Missing
90,127 (92.2%)
legacy_loc_county
Distinct
951
Missing
90,127 (92.2%)
legacy_loc_area_code
Distinct
241
Missing
90,128 (92.2%)
legacy_loc_FIPS
Distinct
1,332
Missing
90,128 (92.2%)
legacy_loc_MSA
Distinct
245
Missing
94,438 (96.6%)
legacy_loc_PMSA
Distinct
73
Missing
94,965 (97.2%)
legacy_loc_TZ
Distinct
7
Missing
90,128 (92.2%)
legacy_loc_DST
Distinct
3
Missing
90,127 (92.2%)
legacy_loc_LAT_centroid
Distinct
4,501
Missing
90,128 (92.2%)
legacy_loc_LAT_poly
Distinct
7,590
Missing
90,127 (92.2%)
legacy_loc_LONG_centroid
Distinct
4,539
Missing
90,128 (92.2%)
legacy_loc_LONG_poly
Distinct
7,600
Missing
90,127 (92.2%)
legacy_web_url
Distinct
1,306
Missing
96,354 (98.6%)
legacy_web_meta_title
Distinct
3
Missing
97,734 (100.0%)
legacy_web_meta_desc
Distinct
1
Missing
97,737 (100.0%)
legacy_web_meta_keys
Distinct
1
Missing
97,737 (100.0%)
legacy_biz_phone
Distinct
7,608
Missing
90,127 (92.2%)

Inspect the data

Representative sample data

Switch tables to review representative fields and rows from every table advertised for this release.

venuesDownload this sample CSV
venue_idvenue_namebrand_namephysical_addresscitystatestate_codepostal_codecountryphonewebsitesocial_linksvenue_typeoperating_statusexistence_confidencelatitudelongitudesource_vintagelegacy_match_statuslegacy_idlegacy_biz_namelegacy_e_addresslegacy_e_citylegacy_e_statelegacy_e_postallegacy_e_zip_fulllegacy_e_countrylegacy_loc_countylegacy_loc_area_codelegacy_loc_FIPSlegacy_loc_MSAlegacy_loc_PMSAlegacy_loc_TZlegacy_loc_DSTlegacy_loc_LAT_centroidlegacy_loc_LAT_polylegacy_loc_LONG_centroidlegacy_loc_LONG_polylegacy_web_urllegacy_web_meta_titlelegacy_web_meta_desclegacy_web_meta_keyslegacy_biz_phone
DB9-2.0.0-000001Akutan RoadhouseKQA BoardwalkAkutanAlaskaAK99603US+19076980000["https://www.facebook.com/160318874033088"]PubOpen0.958355367183685354.1326318-165.7877012026-09-23.1unmatched
DB9-2.0.0-000002907 Alehouse1148 N Muldoon RdAnchorageAlaskaAK99504US+19079294000http://www.firetapalehouse.com["https://www.facebook.com/550184738187750"]Sports BarOpen0.972216188907623361.2289546-149.74107332026-09-23.1unmatched
DB9-2.0.0-000003907 Alehouse & Grill8001 Old Seward HwyAnchorageAlaskaAK99518US+19078684000http://907ale.com/["https://www.facebook.com/133606357187160"]Sports BarOpen0.999532044380903361.1481093-149.86329762026-09-23.1unmatched
DB9-2.0.0-000004A Sip of Tea809 E Loop RdAnchorageAlaskaAK99501US+19072155169http://www.leystrykava.com/["https://www.facebook.com/848993504968562"]BarOpen0.751019060611724961.2306449-149.8735412026-09-23.1unmatched
DB9-2.0.0-000005Al's Alaskan Inn7830 Old Seward HwyAnchorageAlaskaAK99518US+19073446223http://www.alsalaskaninnandhideoutlounge.com/["https://www.facebook.com/128759900798809"]BarOpen0.990219295024871861.1496382-149.86460542026-09-23.1matched_unique_corroborated357Al's Alaskan Inn7830 Old Seward HwyAnchorageAK9951899518-3234USAAnchorage907020200380PST-1Y61.159361.150006-149.8844-149.864343http://www.alsalaskaninn.com(907) 344-6223
DB9-2.0.0-000006American Legion Jack Henry Post 1840 W Fireweed LnAnchorageAlaskaAK99503-2508US+19072725242https://alaskapost1.org[]Sports BarOpen0.941009214222431261.198314-149.89956422026-09-23.1unmatched
DB9-2.0.0-000007Anchorage, Alaska Bills Backer Bar5227 Old Seward HwyAnchorageAlaskaAK99518-1454US+19074404861["https://www.facebook.com/100810027990592"]BarOpen0.839328289031982461.172891-149.8674022026-09-23.1unmatched
DB9-2.0.0-000008Applebee's7611 Debarr RdAnchorageAlaskaAK99504US9073327753http://www.applebees.com/[]Sports BarOpen0.919912219047546461.210025-149.7388022026-09-23.1unmatched
DB9-2.0.0-000009Avenue Bar338 W 4th AveAnchorageAlaskaAK99501-2321US+19072726124http://www.avenuebarak.com/["https://www.facebook.com/296687714299"]Dive BarOpen0.990219295024871861.2184926-149.88888252026-09-23.1matched_unique_corroborated374Avenue Bar338 W 4th AveAnchorageAK9950199501-2321USAAnchorage907020200380PST-1Y61.216961.218410-149.8682-149.888208(907) 272-6124
DB9-2.0.0-000010Barry's Baranof Lounge1166 Gambell StAnchorageAlaskaAK99501US+19072769042https://www.chamberofcommerce.com/.../680610-barrys-baranof-lounge["https://www.facebook.com/1022030020983094"]Cocktail BarOpen0.958338141441345261.2110625-149.87134652026-09-23.1matched_unique_corroborated378Barry's Baranof Lounge1166 Gambell StAnchorageAK9950199501-4626USAAnchorage907020200380PST-1Y61.216961.211020-149.8682-149.871174(907) 276-9042
DB9-2.0.0-000011Billiard Palace3400 C StAnchorageAlaskaAK99503US(907) 562-4251http://poolalaska.com[]Sports BarOpen0.990219295024871861.1890495-149.88716922026-09-23.1unmatched
DB9-2.0.0-000012Blarney Stone Pub645 G StAnchorageAlaskaAK99501US+19072436827https://blarneystonealaska.com/["https://www.facebook.com/112896931733187"]Irish PubOpen0.813635349273681661.2157109-149.895262026-09-23.1unmatched
DB9-2.0.0-000013Buckaroo club2811 Spenard RdAnchorageAlaskaAK99503US+19075619251https://buckaroo-club.hub.biz/["https://www.facebook.com/341797104020"]Dive BarOpen0.990219295024871861.1947376-149.9050892026-09-23.1matched_unique_corroborated392Buckaroo Club2811 Spenard RdAnchorageAK9950399503-3601USAAnchorage907020200380PST-1Y61.187761.195121-149.8890-149.905304(907) 561-9251
DB9-2.0.0-000014Buffalo Wild WingsBuffalo Wild Wings3400 C StreetAnchorageAlaskaAK99503US+19075639464https://www.buffalowildwings.com/locations/us/ak/anchorage/3400-c-street/sports-bar-933/["https://www.facebook.com/109133308940476"]Sports BarOpen0.990219295024871861.1891559-149.88728412026-09-23.1unmatched
DB9-2.0.0-000015Buzzbizz Studios3300 C StAnchorageAlaskaAK99503US(907) 272-2899http://www.buzzbizz.biz/["https://www.twitter.com/buzzbizz"]BarOpen0.919912219047546461.1905871-149.88707942026-09-23.1unmatched
DB9-2.0.0-000016Cabin Tavern264 Muldoon RdAnchorageAlaskaAK99504US+19073380862https://www.openingtimes.co/cabin-tavern-anchorage-ak["https://www.facebook.com/225266684244722"]PubOpen0.990219295024871861.2210185-149.73420562026-09-23.1matched_unique_corroborated393Cabin Tavern264 Muldoon RdAnchorageAK9950499504-1502USAAnchorage907020200380PST-1Y61.201661.221099-149.7414-149.733804(907) 338-9905
DB9-2.0.0-000017Carousel Lounge3206 Spenard RdAnchorageAlaskaAK99503US+19072066001http://www.carouselalaska.com["https://www.facebook.com/185793165536889"]Dive BarOpen0.999039699643850361.1908611-149.90744862026-09-23.1unmatched
DB9-2.0.0-000018Carpentiers Cocktail335 Boniface PkwyAnchorageAlaskaAK99504US+19073333691["https://www.facebook.com/149277651774437"]Cocktail BarOpen0.958338141441345261.2221291-149.77797232026-09-23.1unmatched
DB9-2.0.0-000019Chilkoot Charlie's2435 Spenard RdAnchorageAlaskaAK99503US+19072721010http://www.koots.com["https://www.facebook.com/136024556606370"]BarOpen0.972216188907623361.1981788-149.90509852026-09-23.1unmatched
DB9-2.0.0-000020Chilkoot Charlie'sSpenard RdAnchorageAlaskaAK99517US+19072791692http://www.koots.com/["https://www.facebook.com/518026095381326"]BarOpen0.955405652523040861.17986-149.937682026-09-23.1unmatched

Each row represents one listed venue location. The 97,738 released rows are within the 50 states and DC and were reported open in the source snapshot. Coverage is not exhaustive, operating status is not live, and a missing legacy record match is not evidence that a location is new.

Designed for business research, directory applications, mapping, and market analysis. Review permitted uses.

Need a closer fit?

Data shaped around your project.

Tell us your topic, geography, and required fields. We can help find a match or scope a custom package.
Discuss your data needs Explore the catalog

A clear path from download to project

Get more from your data

Understand the files, check the sample coverage, and choose the license that fits your use.

Database guides and examples Working with file formats Samples and record counts Licenses and permitted use Ask about this database

Oddity Support

How can we help?

Browse all Help topics

Oddity Data Updates

Know when fresh data arrives.

Receive occasional notices about new and substantially updated database releases. No third-party mailing list.

Oddity Software

Details