Pubs in San Francisco: list of 137 free CSV

How many pubs are in San Francisco?

OpenStreetMap lists 137 named pubs inside the San Francisco city boundary (601 km²), extract of 11 Nov 2026. 40% of the records list a website and 35% a phone number; 82 named pubs have no website on the public record. The biggest clusters are around Chinatown (14), Mission (13), Tenderloin (13).

Examples on the list: 15 Romolo, 21st Amendment Brewery, After Hours SF.

Edited on the map in the 90 days before the extract: 6 records, including Magnolia SF, Casa Barajas / Chug Pub, Flanahan's Pub, Mission Bar.

137named pubs
40%list a website
82no website listed
22neighbourhoods
Download all 137 as CSV Get emails, phones and ratings

Data © OpenStreetMap contributors, ODbL, extract of 11 Nov 2026. The CSV is under the same licence.

50 of the 137 pubs, A to Z

on the map recordmissing from the recordPicked from 22 neighbourhoods; filter below to search all 137

Showing a sample of 50. Change a filter to search all 137.

Pubs in San Francisco, OpenStreetMap extract of 11 Nov 2026.
Business Street and area Website Phone Hours
15 Romolonot edited since 2019 15 Romolo Place, North Beach 15romolo.com +1 415 398 1359
21st Amendment Brewery 563 2nd Street, Mission Bay 21st-amendment.com +1 415-369-0900
After Hours SF 3044 Taraval Street, Parkside
Afterwork Bar 409 Gough Street, Civic Center afterworkbarsf.com
Atlas Tap Room 606 Mission Street, Financial District atlastaproom.com +1-415-513-2571
Barebottle Taproomnot edited since 2022 Bernal Heights, no street on record barebottle.com +1 415 9268617
Bistro Gambrinus 1813 Fulton Street, Haight-Ashbury beerandgrill.com +1 415-221-7777
Bottle Club Pubnot edited since 2022 555 Geary Street, Tenderloin bottleclubpub.com +1 415 4232582
Buckshotnot edited since 2012 3848 Geary Boulevard, Inner Richmond
Casa Barajas / Chug Pub 1849 Lincoln Way, Inner Sunset +1 415-242-9931
Cellar Doornot edited since 2013 3131 Fillmore Street, Marina District
Cellarmaker 3191 Mission Street, Bernal Heights
Churchill 198 Church Street, Castro District churchillsf.com +1 415 5709198
Cigar Bar 850 Montgomery Street, Chinatown cigarbarandgrill.com +1 415 3980850
Danny Coyle's 668 Haight Street, Western Addition dannycoyles.com +1 415 5588375
Durty Nelly's 2328 Irving Street, Inner Sunset +1-415-664-2555
Elixir 3200 16th Street, Mission elixirsf.com +1 415 5521633
Fat Beli Delinot edited since 2012 Portola, no street on record
Flanahan's Pub 3805 Noriega Street, Outer Sunset
Golden Gate Tap Room 449 Powell Street, Chinatown ggtaproom.com +1 415 6779999
Harper & Rye 1695 Polk Street, Nob Hill
Hi Tops 2247 Market Street, Castro District hitopsbar.com
Hotel Utah Saloon 500 4th Street, Mission Bay hotelutah.com +1 415 546 6300
Irish Bank 10 Mark Lane, Chinatown theirishbank.com +1 415 7887152
Johnny Foley's Irish Housenot edited since 2022 243 O'Farrell Street, Tenderloin johnnyfoleys.com +1 415 9540777
Judnich'snot edited since 2012 Portola, no street on record
Kennedy's Irish Pub & Curry House 1040 Columbus Avenue, North Beach kennedyscurry.com
Kilowattnot edited since 2022 3160 16th Street, Mission kilowattbar.com +1 415 861 2595
Noren Izakayanot edited since 2022 1701 Powell Street, North Beach norenizakaya.com +1 415 2919268
Pops 2800 24th Street, Potrero Hill popssf.com
Royal Exchange 301 Sacramento Street, Financial District royalexchange.com +1 415-956-1710
San Francisco Brewing Co. Marina District, no street on record sfbrewingco.com +1 415 4842337
Shannon Armsnot edited since 2016 915 Taraval Street, Parkside
Shovels Barnot edited since 2022 460 Larkin Street, Civic Center shovelsbar.com +1 415 8298979
Southside Spirit House 575 Howard Street, Financial District southsidesf.com +1-415-543-5874
St. Mary's Pub 3845 Mission Street, Glen Park stmaryspub.com +1 415-529-1325
Standard Deviant 280 14th Street, Mission standarddeviantbrewing.com +1 415 5902550
Sutter Pub & Restaurant 700 Sutter Street, Tenderloin sutterpubsf.com +1 415 4005840
The Dubliner 3838 24th Street, Noe Valley
The Laughing Monk 1785 Fulton Street, Haight-Ashbury fulton.laughingmonk.com +1-415-638-6667
The Mad Dog in the Fog 1568 Haight Street, Haight-Ashbury social page
The Nag's Head 5346 Geary Boulevard, Richmond District
The Peaks 1316 Castro Street, Noe Valley
The Plough and the Starsnot edited since 2021 116 Clement Street, Inner Richmond
Thriller Social Club 508 4th Street, Mission Bay thrillersocialclub.com +1 415 706 6568
Tonic 2360 Polk Street, Nob Hill tonicbar-sf.com
Toronado 547 Haight Street, Western Addition toronado.com +1-415-863-2276
Two Pitchers Brewing Company 3821 Noriega Street, Outer Sunset twopitchers.com +1-510-999-4939
Verdi Club 2424 Mariposa Street, Potrero Hill verdiclub.net +1-415-861-9199
Woods Polk Stationnot edited since 2015 2255 Polk Street, Nob Hill

Download the full CSV (137 rows)

Also as Excel, GeoJSON, KML (maps and spreadsheets; same rows, same licence).

Pubs in San Francisco with no website listed

54 of 137 named non-chain pubs; 12 below, the rest in the filter or the CSV. 1 more only list a social page (website_is_social_page = yes).

  • After Hours SF3044 Taraval Street, Parkside
  • Aub Zam Zam1633 Haight Street, Haight-Ashbury
  • Azucar Lounge299 9th Street, Civic Center
  • Blackbird2124;2126 Market Street, Castro District
  • Cafe Tosca242 Columbus Avenue, Chinatown
  • Casa Barajas / Chug Pub1849 Lincoln Way, Inner Sunset, phone listed
  • Cellarmaker3191 Mission Street, Bernal Heights
  • Durty Nelly's2328 Irving Street, Inner Sunset, phone listed
  • Irish Times500 Sacramento Street, Financial District, phone listed
  • Shotwell's3349 20th Street, Mission, phone listed
  • The Napper Tandy3200 24th Street, Mission, phone listed
  • The Pig & Whistle2801 Geary Boulevard, Haight-Ashbury, phone listed

Show all of themEvery kind of business in San Francisco without a website

Where they are

Map of the 137 pubs inside the San Francisco boundary; most sit around Chinatown, Mission, Tenderloin.
website listedno website, or social page only

Busiest streets

  • Haight Street, Haight-Ashbury6
  • Haight Street, Western Addition6
  • Polk Street, Nob Hill5
  • Columbus Avenue, Chinatown4
  • Geary Street, Tenderloin4
  • Polk Street, Tenderloin3
  • Powell Street, North Beach3

By neighbourhood

Black: website listed.

10 more neighbourhoods in the filter above.

By ZIP code

  • 941037
  • 941097
  • 941176
  • 941226
  • 941105
  • 941144
  • 941334
  • 941073
  • 941022
  • 941112

What the records hold

137 map records.
FieldRecordsShare
Street address11584%
Website (own site)5439%
Social or directory page only11%
Phone on file4835%
Email on file (not shown)1914%
Opening hours5339%
Edited since January 20248159%

Half the records were last edited in Apr 2025 or later.

Why other sites show a different number

  • Coverage. 137 mapped; Google Maps holds more.
  • Boundary. 601 km² (map); metro searches count more.
  • Names. No branches.

Get the complete list with emails, phones and ratings

Businesses to contact, not customer enquiries ("leads" for your own business are a different product).

Suggested source for this list

Google Maps Business Lead & Email Finder

It searches Google Maps for the same category and city and can add emails from each business website.

  • Emails
  • Phone numbers
  • Websites
  • Star ratings
  • Review counts
  • Social profiles
  • no opening hours

One run: about $0.54 to $1.35 for 137 to 960 rows ($0.99 per 1,000 + $0.40 start fee (4 GB run)), plus platform usage ($0.80/hour).

Free plan prices; it includes $5 a month (Apify pricing).

How to run it, step by step

  1. Open Google Maps Business Lead & Email Finder on the Apify Store and sign in or create a free Apify account.
  2. Paste these 8 searches into Search phrases, one per line; the neighbourhood searches catch businesses a citywide search misses.
    1. pubs in San Francisco, CA
    2. pubs in Chinatown, San Francisco, CA
    3. pubs in Mission, San Francisco, CA
    4. pubs in Tenderloin, San Francisco, CA
    5. pubs in Haight-Ashbury, San Francisco, CA
    6. pubs in Financial District, San Francisco, CA
    7. pubs in North Beach, San Francisco, CA
    8. pubs in Nob Hill, San Francisco, CA
  3. Set Country: United States.
  4. Set Maximum leads to 1,000.
  5. Start it and download the results as CSV or Excel.

Open on the Apify Store What this source returns

Or search by ZIP code (12 searches)
  1. pubs in 94103, San Francisco, CA
  2. pubs in 94109, San Francisco, CA
  3. pubs in 94117, San Francisco, CA
  4. pubs in 94122, San Francisco, CA
  5. pubs in 94110, San Francisco, CA
  6. pubs in 94114, San Francisco, CA
  7. pubs in 94133, San Francisco, CA
  8. pubs in 94107, San Francisco, CA
  9. pubs in 94102, San Francisco, CA
  10. pubs in 94111, San Francisco, CA
  11. pubs in 94116, San Francisco, CA
  12. pubs in 94118, San Francisco, CA

Other ways to build or enrich it

Prices on the Free plan: per 1,000 results plus a start fee per GB of run memory, plus Apify platform usage.
SourceWhat it addsPrice
Google Maps Business Lead Finder with Email & Social Links a second Google Maps route with a different set of columns $0.99 per 1,000 + $0.10/GB start
Yelp Business Search & Review Scraper Yelp listings with ratings and review counts $0.99 per 1,000 + $0.10/GB start
Google Maps Restaurant Menu & Popular Dish Extractor adds menus and popular dishes to each place $0.99 per 1,000 + $0.10/GB start
Website Contact Page Email & Phone Crawler reads the websites in the free CSV and returns the emails and phone numbers published there $0.99 per 1,000 + $0.10/GB start
Facebook Business Page Finder by Keyword & City finds the Facebook pages of businesses that have no website $0.99 per 1,000 + $0.10/GB start

Pubs in other cities

CityNamedWebsite listed
Pubs in New York City39063%
Pubs in Seattle19982%
Pubs in Portland18774%
Pubs in Chicago10463%
Pubs in Denver9832%
Pubs in Philadelphia9451%
Pubs in Milwaukee9049%
Pubs in Phoenix6338%
Pubs in Washington, DC6287%
Pubs in Minneapolis6077%

Every city for pubs

More lists in San Francisco

All San Francisco lists

How San Francisco compares: the local digital gap in San Francisco, every kind of business with and without a website on the map.

Embed this list

Show this free list on your own site: paste the code into any page. It is a small static card with no scripts, cookies or tracking, and it updates when the list does.

Preview the card

The card credits OpenStreetMap contributors (ODbL) and links back to this list on getalistof.com.

Questions

How many pubs are there in San Francisco?

At least 137: that is how many OpenStreetMap has inside the San Francisco city boundary, 137 with a name (extract of 11 Nov 2026). None are tagged as chain branches. Google Maps usually lists more, because more owners add themselves there.

Which part of San Francisco has the most pubs?

Chinatown (14), then Mission (13) and Tenderloin (13); the busiest street is Haight Street, Haight-Ashbury (6). 22 neighbourhoods have at least one.

How many pubs in San Francisco have no website?

82 of the 137 named pubs have no website on their map record; 54 of them are not chain branches. Another 1 list only a social media page as their website.

How do I get phone numbers and emails for pubs in San Francisco?

Run Google Maps Business Lead & Email Finder with the search "pubs in San Francisco, CA" plus 7 neighbourhood searches such as "pubs in Chinatown, San Francisco, CA". One run costs about $0.54 to $1.35 ($0.40 start fee (4 GB run) included), plus platform usage, for 137 to 960 rows.

Sources

Using the list: credit OpenStreetMap contributors and keep changed copies under the ODbL; follow the outreach rules where you send. Licence and limits.

Map extract 11 Nov 2026Next refresh after 6 Dec 2026Data © OpenStreetMap contributors, ODbL