The Black Sheep

Philadelphia, PA 19103 · O12a0ecee1f93 · first seen 2026-11-13
2 sourceson premise · baralcohol: alcohol

Golden record

One value per field, each taken from one source by a stated precedence (licence and chain locator first for the address, delivery apps for the pin). Where another source says something else, it is listed beside it.

FieldMaster valueTaken fromWhat other sources say
Name
The Black Sheep 2 other
a licence name in capitals, cleaned (derived; record_title.py)
BLACK SHEEP ab-inbev
The Black Sheep Pub & Restaurant overture
Street
247 S 17TH ST
ab-inbevno other value
City
PHILADELPHIA
ab-inbevno other value
State
PA
ab-inbevno other value
ZIP
19103
ab-inbevno other value
Pin
39.94846, -75.16932 map
overtureno other value
Phone
2155459473
overtureno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oca814250d40c

Carries

Products seen on this outlet’s shelf in store-level catalogs.

No store-level catalog lists this outlet. Shelf data comes from DoorDash, Meijer, Binny’s, ABC and Spec’s store catalogs; most outlets have none yet.

Sources

Every source record folded into this outlet, as the source states it.

SourceNameAddressPhoneCoordinatesFirst seenUpdated
ab-inbevBLACK SHEEP
2663120
247 S 17TH ST, PHILADELPHIA, PA, 1910339.94865, -75.169302026-11-132026-11-13
overtureThe Black Sheep Pub & Restaurant
ef2dce51-6a64-4343-9bef-7fd91a459591
247 S 17th St, Philadelphia, PA, 19103215545947339.94846, -75.169322026-11-132026-11-13

Matching

Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.

Record ARecord BName matchRuleDecisionEvidence
ab-inbev BLACK SHEEPoverture The Black Sheep Pub & Restaurant0.55same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pub, restaurant · name Jaro-Winkler 0.81 · same street + ZIP · pins 21 m apart · name similarity 0.55

Attributes

Channel
on_premise · bar — overture-category
Chain
none
Alcohol
alcohol — channel bar
Operator
none
Licence privileges
none
Rule version 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
1,286 within 1 mi · 3,698 within 3 mi
Off / on premise
148 / 803 within 1 mi · 417 / 2,279 within 3 mi
Selling alcohol
555 within 1 mi · 1,321 within 3 mi
Nearest
same channel 0.03 mi · licensed 0.06 mi
Setting
urban (16,753 people per sq mi)
People within 3 mi
473,683 (367,566 adults 21+, 224,912 households) from 140 tract(s), tracts within 3 mi
Income
per capita $54,134 · median household ~$81,710 (weighted mean of tract medians)
Age and education
median age ~34.0 · bachelor's or higher 55%
Ethnicity
Hispanic 10% · White 47% · Black 28% · Asian 11%
Adults per alcohol outlet
278
Alcohol spend within 3 mi
$152,923,654 a year ($69,367,823 at home, $83,480,955 away) · $115,676 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-17 01:05.

History

Every change to a link of these records, newest first (kept since 2026-11-06; earlier links appear once, as “backfill”).
WhenEventPairRuleDecisionRule version
2026-11-13 19:03insertab-inbev 2663120 ↔ overture ef2dce51-6a64-4343-9bef-7fd91a459591same address and namemerged15