Outlets /
ROTTEN RALPHS
Philadelphia, PA 19106 · O5ac711b6ed92 · first seen 2026-10-09
5 sourceson premise · restaurantalcohol: 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 | ROTTEN RALPHS 3 other | the most common name a source states | Rotten Ralph S toast (legal name) Rotten Ralph S 201 Chestnut St toast Rotten Ralph's Pub and Eatery overture |
| Street | 201 Chestnut St | ubereats | no other value |
| City | Philadelphia | ubereats | no other value |
| State | PA | ubereats | no other value |
| ZIP | 19106 | ubereats | no other value |
| Pin | 39.94849, -75.14423 map | ubereats | no other value |
| Phone | 2159252440 | vtinfo | no other value |
| Licences | none on file | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Oc45dcc6fbc60; Oabd434261d0f; O6c395faf7186; O9871c7a02d3a
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 | ROTTEN RALPHS 2661501 | 201 CHESTNUT ST, PHILADELPHIA, PA, 19106 | 39.94848, -75.14434 | 2026-11-11 | 2026-11-12 | |
| overture | Rotten Ralph's Pub and Eatery de565fed-62c3-406e-83b4-7097d4c1d6f2 | 201 Chestnut St, Philadelphia, PA, 19106 | 2159252440 | 39.94848, -75.14413 | 2026-11-13 | 2026-11-13 |
| toast | Rotten Ralph S 201 Chestnut St legal name: Rotten Ralph S 87f72a13-5092-48bc-8d73-12ae965b727b | 201 Chestnut St, Philadelphia, PA, 19106 | 2159252440 | 39.94842, -75.14412 | 2026-11-06 | 2026-11-12 |
| ubereats | Rotten Ralphs nntRBAx1QpyH9q7hnKXXIg | 201 Chestnut St, Philadelphia, PA, 19106 | 39.94849, -75.14423 | 2026-10-09 | 2026-11-12 | |
| vtinfo | ROTTEN RALPHS fcc70767abec6f55 | 201 CHESTNUT ST, PHILADELPHIA, PA, 19106 | 2159252440 | 39.94842, -75.14412 | 2026-11-11 | 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 ROTTEN RALPHS | ubereats Rotten Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 10 m apart · name similarity 1.00 |
| ab-inbev ROTTEN RALPHS | vtinfo ROTTEN RALPHS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 20 m apart · name similarity 1.00 |
| ubereats Rotten Ralphs | vtinfo ROTTEN RALPHS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 12 m apart · name similarity 1.00 |
| ab-inbev ROTTEN RALPHS | overture Rotten Ralph's Pub and Eatery | 0.60 | same address and name | merged | address similarity 1.00 · names match with these kind-of-place words set aside: eatery, pub · name Jaro-Winkler 0.71 · same street + ZIP · pins 18 m apart · name similarity 0.60 |
| overture Rotten Ralph's Pub and Eatery | ubereats Rotten Ralphs | 0.60 | same address and name | merged | address similarity 1.00 · names match with these kind-of-place words set aside: eatery, pub · name Jaro-Winkler 0.71 · same street + ZIP · pins 8 m apart · name similarity 0.60 |
| overture Rotten Ralph's Pub and Eatery | vtinfo ROTTEN RALPHS | 0.60 | same address and name | merged | address similarity 1.00 · names match with these kind-of-place words set aside: eatery, pub · name Jaro-Winkler 0.71 · same street + city + state · pins 7 m apart · name similarity 0.60 · phone: equal |
| ab-inbev ROTTEN RALPHS | toast Rotten Ralph S 201 Chestnut St | 0.57 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.96 · same street + ZIP · pins 20 m apart · matched through the licence's legal name: Rotten Ralph S · name similarity 0.57 |
| toast Rotten Ralph S 201 Chestnut St | ubereats Rotten Ralphs | 0.57 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.96 · same street + ZIP · pins 12 m apart · matched through the licence's legal name: Rotten Ralph S · name similarity 0.57 |
| toast Rotten Ralph S 201 Chestnut St | vtinfo ROTTEN RALPHS | 0.57 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.96 · same street + city + state · pins 0 m apart · matched through the licence's legal name: Rotten Ralph S · name similarity 0.57 · phone: equal |
Attributes
- Channel
- on_premise · restaurant — overture-category
- Chain
- none
- Alcohol
- alcohol — Toast menu lists 64 alcoholic drinks: 'Miller Lite Can', 'Miller Highlife Can', 'Michelob Ultra Can'
- Operator
- none
- Licence privileges
- none
Rule version 7, computed 2026-11-16 17:17.
Every vote behind these (raw)
{
"ue_location": [
"DEFAULT"
],
"votes": [
[
"overture-category",
"on_premise",
"restaurant"
]
]
}Trade area
- Other outlets
- 822 within 1 mi · 3,574 within 3 mi
- Off / on premise
- 74 / 515 within 1 mi · 416 / 2,184 within 3 mi
- Selling alcohol
- 339 within 1 mi · 1,304 within 3 mi
- Nearest
- same channel 0.01 mi · licensed 0.21 mi
- Setting
- urban (15,817 people per sq mi)
- People within 3 mi
- 447,208 (348,092 adults 21+, 210,129 households) from 127 tract(s), tracts within 3 mi
- Income
- per capita $54,854 · median household ~$85,310 (weighted mean of tract medians)
- Age and education
- median age ~34.3 · bachelor's or higher 54%
- Ethnicity
- Hispanic 16% · White 49% · Black 23% · Asian 11%
- Adults per alcohol outlet
- 267
- Alcohol spend within 3 mi
- $147,026,016 a year ($66,403,574 at home, $80,552,279 away) · $112,664 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 14:10 | insert | overture de565fed-62c3-406e-83b4-7097d4c1d6f2 ↔ vtinfo fcc70767abec6f55 | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | overture de565fed-62c3-406e-83b4-7097d4c1d6f2 ↔ ubereats nntRBAx1QpyH9q7hnKXXIg | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | ab-inbev 2661501 ↔ overture de565fed-62c3-406e-83b4-7097d4c1d6f2 | same address and name | merged | 15 |
| 2026-11-12 14:25 | insert | toast 87f72a13-5092-48bc-8d73-12ae965b727b ↔ vtinfo fcc70767abec6f55 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | toast 87f72a13-5092-48bc-8d73-12ae965b727b ↔ ubereats nntRBAx1QpyH9q7hnKXXIg | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | ab-inbev 2661501 ↔ toast 87f72a13-5092-48bc-8d73-12ae965b727b | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 2661501 ↔ vtinfo fcc70767abec6f55 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ubereats nntRBAx1QpyH9q7hnKXXIg ↔ vtinfo fcc70767abec6f55 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 2661501 ↔ ubereats nntRBAx1QpyH9q7hnKXXIg | same address and name | merged | 12 |