Pubs in Philadelphia: list of 94 free CSV

How many pubs are in Philadelphia?

OpenStreetMap lists 94 named pubs inside the Philadelphia city boundary (369 km²), extract of 11 Nov 2026. 51% of the records list a website and 52% a phone number; 45 named pubs have no website on the public record.

Examples on the list: 2637brew, A Man Full of Trouble, American Sardine Bar.

Edited on the map in the 90 days before the extract: 6 records, including Con Murphy's, Gaul & Co. Malt House, Human Robot, Human Robot Girard.

94named pubs
51%list a website
45no website listed
45neighbourhoods
Download all 94 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 94 pubs, A to Z

on the map recordmissing from the recordPicked from 42 neighbourhoods; filter below to search all 94

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

Pubs in Philadelphia, OpenStreetMap extract of 11 Nov 2026.
Business Street and area Website Phone Hours
2637brew 2637 West Girard Avenue, Fairmount 2637brew.com
A Man Full of Trouble 125 Spruce Street, Society Hill
American Sardine Bar 1800 Federal Street, Point Breeze americansardinebar.com +1 215-334-2337
Bar Ly 101 North 11th Street, Chinatown +1 215-922-2688
CJ & Ecks 384 Shurs Lane, Roxborough +1-215-487-9601
Con Murphy's 1700 Benjamin Franklin Parkway, Logan Square conmurphyspub.com +1 267-687-1128
Craft Hall 901 North Delaware Avenue, Northern Liberties mainstaybrewing.com +1 267-297-2072
Dawson Street Pub Wissahickon, no street on record
Dock Street Brewery South 2118 Washington Avenue, Graduate Hospital dockstreetbeer.com +1 215-337-3103
Fergie's Pub 1214 Sansom Street, Gayborhood fergies.com +1 215-928-8118
Frankford Hall 1210 Frankford Avenue, Fishtown frankfordhall.com +1-215-634-3338
Franklin's Pub East Falls, no street on record
Gaul & Co. Malt House 2619 East Indiana Avenue, Port Richmond gaulandco.com
Germantown Biergarten Eastwick, no street on record
Good Dog Bar 224 South 15th Street, Rittenhouse Square gooddogbar.com +1 215-985-9600
Green Room 1940 Green Street, Spring Garden greenroomphiladelphia.com +1 215-241-6776
Hilltown Tavern Fairmount 795 North 24th Street, Fairmount hilltownfairmount.com +1 267-519-9580
JD's Loungenot edited since 2012 Olney, no street on record
Kelliann's Bar & Grill 1549 Spring Garden Street, Spring Garden kellianns.com +1 215-563-6990
Khyber Pass Pub 56 South 2nd Street, Old City khyberpasspub.com +1-215-238-5888
Kitchen at Bala 5004 City Avenue, Pencoyd kitchenatbala.com +1-215-877-9843
Leneghans Pub 7412 Frankford Avenue, Northeast Philadelphia
Local 44 4333 Spruce Street, Spruce Hill local44beerbar.com +1 215-222-2337
Loft Lounge Wissahickon, no street on record
Manayunk Brewing Company 4120 Main Street, Manayunk manayunkbrewery.com +1-215-482-8220
Mcdanielsnot edited since 2015 Whitman, no street on record
McDuff's Tavern 3608 Rhawn Street, Holmesburg +12156240412
Mermaid Inn 7376 Germantown Avenue, Saint Martins themermaidinn.net +1-215-247-9797
Millcreek Tavern 4200 Chester Avenue, Southwest Schuylkill
Mt Airy Taproom Allen Lane, no street on record mountairytaproom.com +1-267-766-6668
O'Mare's 10253 Bustleton Avenue, Far Northeast Philadelphia
Oneal's Pub 611 South 3rd Street, Queen Village onealspub.com +1 215-574-9495
Paddy Whacks 150 South Street, Queen Village paddywhackspub.com +1 215-464-7544
Prime Fusion Afro Grill and Lounge 2425 Grays Ferry Avenue, Schuylkill primefusionlounge.com +1 267 324-5614
Prohibition Taproom 501 North 13th Street, Chinatown theprohibitiontaproom.com +1 215-238-1818
Pub Webb 1527 Cecil B Moore Avenue, North Central pubwebb.com +1 267-687-8256
Reuben's Marc 8129-8131 Stenton Avenue, East Mount Airy
Rotten Ralph's Pub & Eatery 201 Chestnut Street, Old City rottenralphspub.com +1 215-925-2440
Sammy's Sports Bar 5000 Market Street, West Philadelphia +1-215-729-0265
Second District Brewing Company 1939 South Bancroft Street, South Philadelphia seconddistrictbrewing.com +1 215-575-5900
The Dandelion 124 South 18th Street, Rittenhouse Square thedandelionpub.com +1 215 558 2500
The Post 129 South 30th Street, Fitler Square thepostphl.com +1-215-867-8067
The Wishing Well 767 South 9th Street, Bella Vista wishingwellphilly.com
Throwbaxx Bar and Grille Germany Hill, no street on record
Tir na nOg 1600 Arch Street, Center City tirnanogphilly.com +1 267-514-1700
Triangle Tavern 1340 South 10th Street, Passyunk Square
United States Hotel Bar & Grill 4439 Main Street, Manayunk ushotelmanayunk.com +1-267-335-5796
Varga 941 Spruce Street, Washington Square West vargabar.com +1 215-627-5200
Victory Beer Hall 1100 Pattison Avenue, Packer Park
Wissahickon Brewing Co 1526 North American Street, Ludlow wissahickonbrew.com

Download the full CSV (94 rows)

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

3 more records have no name on the map and are left out of the list.

Pubs in Philadelphia with no website listed

36 of 93 named non-chain pubs; 12 below, the rest in the filter or the CSV.

  • A Man Full of Trouble125 Spruce Street, Society Hill
  • Bar Ly101 North 11th Street, Chinatown, phone listed
  • CJ & Ecks384 Shurs Lane, Roxborough, phone listed
  • Hilltown Tavern326 Roxborough Avenue, Roxborough
  • McDuff's Tavern3608 Rhawn Street, Holmesburg, phone listed
  • Millcreek Tavern4200 Chester Avenue, Southwest Schuylkill
  • Pitchers Pub4326 Main Street, Manayunk, phone listed
  • Reuben's Marc8129-8131 Stenton Avenue, East Mount Airy
  • Sammy's Sports Bar5000 Market Street, West Philadelphia, phone listed
  • The Irish Pub2005 Walnut Street, Rittenhouse Square
  • Triangle Tavern1340 South 10th Street, Passyunk Square
  • Victory Beer Hall1100 Pattison Avenue, Packer Park

Show all of themEvery kind of business in Philadelphia without a website

Where they are

Map of the 94 pubs inside the Philadelphia boundary; most sit around Manayunk, Old City, Fairmount.
website listedno website, or social page only

Busiest streets

  • Main Street, Manayunk3
  • West Girard Avenue, Fairmount3

By neighbourhood

Black: website listed.

33 more neighbourhoods in the filter above.

By ZIP code

  • 191308
  • 191066
  • 191035
  • 191075
  • 191475
  • 191234
  • 191043
  • 191273
  • 191463
  • 191022

Chains and non-chain businesses

1% of the records are branches of a chain or brand; 96 are not.

What the records hold

97 map records.
FieldRecordsShare
Street address7173%
Website (own site)4951%
Phone on file5052%
Email on file (not shown)33%
Opening hours3940%
Chain or brand branch11%
Edited since January 20247375%

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

Why other sites show a different number

  • Coverage. 97 mapped; Google Maps holds more.
  • Boundary. 369 km² (map); metro searches count more.
  • Names. 1 branches each count once; 3 unnamed left out.

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.49 to $0.64 for 94 to 240 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 2 searches into Search phrases, one per line; the neighbourhood searches catch businesses a citywide search misses.
    1. pubs in Philadelphia, PA
    2. pubs in Manayunk, Philadelphia, PA
  3. Set Country: United States; US state: Pennsylvania.
  4. Set Maximum leads to 300.
  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 19130, Philadelphia, PA
  2. pubs in 19106, Philadelphia, PA
  3. pubs in 19103, Philadelphia, PA
  4. pubs in 19107, Philadelphia, PA
  5. pubs in 19147, Philadelphia, PA
  6. pubs in 19123, Philadelphia, PA
  7. pubs in 19104, Philadelphia, PA
  8. pubs in 19127, Philadelphia, PA
  9. pubs in 19146, Philadelphia, PA
  10. pubs in 19102, Philadelphia, PA
  11. pubs in 19128, Philadelphia, PA
  12. pubs in 19139, Philadelphia, PA

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 San Francisco13740%
Pubs in Chicago10463%
Pubs in Denver9832%
Pubs in Milwaukee9049%
Pubs in Phoenix6338%
Pubs in Washington, DC6287%
Pubs in Minneapolis6077%

Every city for pubs

More lists in Philadelphia

All Philadelphia lists

How Philadelphia compares: the local digital gap in Philadelphia, 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 Philadelphia?

At least 97: that is how many OpenStreetMap has inside the Philadelphia city boundary, 94 with a name (extract of 11 Nov 2026). 1 are chain branches. Google Maps usually lists more, because more owners add themselves there.

Which part of Philadelphia has the most pubs?

Manayunk (9), then Old City (6) and Fairmount (5); the busiest street is Main Street, Manayunk (3). 45 neighbourhoods have at least one.

How many pubs in Philadelphia have no website?

45 of the 94 named pubs have no website on their map record; 36 of them are not chain branches.

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

Run Google Maps Business Lead & Email Finder with the search "pubs in Philadelphia, PA" plus 1 neighbourhood searches such as "pubs in Manayunk, Philadelphia, PA". One run costs about $0.49 to $0.64 ($0.40 start fee (4 GB run) included), plus platform usage, for 94 to 240 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