Outlets /
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.
| Field | Master value | Taken from | What 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-inbev | no other value |
| City | PHILADELPHIA | ab-inbev | no other value |
| State | PA | ab-inbev | no other value |
| ZIP | 19103 | ab-inbev | no other value |
| Pin | 39.94846, -75.16932 map | overture | no other value |
| Phone | 2155459473 | overture | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | BLACK SHEEP 2663120 | 247 S 17TH ST, PHILADELPHIA, PA, 19103 | 39.94865, -75.16930 | 2026-11-13 | 2026-11-13 | |
| overture | The Black Sheep Pub & Restaurant ef2dce51-6a64-4343-9bef-7fd91a459591 | 247 S 17th St, Philadelphia, PA, 19103 | 2155459473 | 39.94846, -75.16932 | 2026-11-13 | 2026-11-13 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ab-inbev BLACK SHEEP | overture The Black Sheep Pub & Restaurant | 0.55 | same address and name | merged | address 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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-13 19:03 | insert | ab-inbev 2663120 ↔ overture ef2dce51-6a64-4343-9bef-7fd91a459591 | same address and name | merged | 15 |