Royal Farm

Philadelphia, PA 19124 · O462643dcf4b2 · first seen 2026-10-08
5 sourceson premise · restaurantchain: Royal Farmsalcohol: 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
Royal Farm 2 other
a licence name in capitals, cleaned (derived; record_title.py)
Royal Farms overtureubereats ×2
royal farms philadelphia doordash
Street
2501 Church St
ubereatsno other value
City
Philadelphia
ubereatsno other value
State
PA
ubereatsno other value
ZIP
19124
ubereatsno other value
Pin
40.00252, -75.08125 map 1 other
ubereats
112 m away ab-inbev
Phone
2159927539
vtinfono other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O744207bd0edf; Ofc154fdb5992; Oc6a6f1684647; Ob119245e6ed3

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-inbevROYAL FARM
4016700
2501 CHURCH ST, PHILADELPHIA, PA, 1912440.00156, -75.081652026-11-122026-11-12
doordashroyal farms philadelphia
1075977
2501 Church St, Philadelphia, PA, 1912440.00241, -75.081312026-10-082026-11-06
overtureRoyal Farms
415783a6-fc7c-42f4-8e62-29b99e433c45
2501 Church St, Philadelphia, PA, 19124215992753940.00241, -75.081232026-11-062026-11-06
ubereatsRoyal Farms
o-teBcQgRMGN_b7wC1WNFA
2501 Church St, Philadelphia, PA, 1912440.00252, -75.081252026-11-092026-11-09
vtinfoROYAL FARM
7cec131e1452dba3
2501 CHURCH ST, PHILADELPHIA, PA, 19124215992753940.00262, -75.080882026-11-122026-11-14

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 ROYAL FARMvtinfo ROYAL FARM1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 135 m apart · name similarity 1.00
doordash royal farms philadelphiaoverture Royal Farms1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00
doordash royal farms philadelphiaubereats Royal Farms1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 14 m apart · name similarity 1.00
overture Royal Farmsubereats Royal Farms1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · name similarity 1.00
ab-inbev ROYAL FARMdoordash royal farms philadelphia0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 98 m apart · name similarity 0.64
ab-inbev ROYAL FARMoverture Royal Farms0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 101 m apart · name similarity 0.64
ab-inbev ROYAL FARMubereats Royal Farms0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 112 m apart · name similarity 0.64
doordash royal farms philadelphiavtinfo ROYAL FARM0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · pins 43 m apart · name similarity 0.64
overture Royal Farmsvtinfo ROYAL FARM0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · pins 38 m apart · name similarity 0.64 · phone: equal
ubereats Royal Farmsvtinfo ROYAL FARM0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · pins 33 m apart · name similarity 0.64

Attributes

Channel
on_premise · restaurant — doordash-url conflicting evidence
Chain
Royal Farms — ubereats-parent
Alcohol
alcohol — listed as carrying Boston Beer, Bud Light (AB InBev), Diageo Beer Company +6 more by the supplier's own store finder or locator
Operator
none
Licence privileges
none
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
135 within 1 mi · 946 within 3 mi
Off / on premise
43 / 55 within 1 mi · 221 / 520 within 3 mi
Selling alcohol
67 within 1 mi · 375 within 3 mi
Nearest
same channel 0.30 mi · licensed 0.14 mi
Setting
urban (10,641 people per sq mi)
People within 3 mi
300,869 (209,600 adults 21+, 112,820 households) from 66 tract(s), tracts within 3 mi
Income
per capita $26,799 · median household ~$56,071 (weighted mean of tract medians)
Age and education
median age ~34.9 · bachelor's or higher 20%
Ethnicity
Hispanic 40% · White 29% · Black 26% · Asian 7%
Adults per alcohol outlet
557
Alcohol spend within 3 mi
$57,452,747 a year ($27,696,300 at home, $29,726,823 away) · $152,800 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-12 14:25insertubereats o-teBcQgRMGN_b7wC1WNFA ↔ vtinfo 7cec131e1452dba3same address and namemerged12
2026-11-12 14:25insertoverture 415783a6-fc7c-42f4-8e62-29b99e433c45 ↔ vtinfo 7cec131e1452dba3same address and namemerged12
2026-11-12 14:25insertdoordash 1075977 ↔ vtinfo 7cec131e1452dba3same address and namemerged12
2026-11-12 14:25insertab-inbev 4016700 ↔ ubereats o-teBcQgRMGN_b7wC1WNFAsame address and namemerged12
2026-11-12 14:25insertab-inbev 4016700 ↔ overture 415783a6-fc7c-42f4-8e62-29b99e433c45same address and namemerged12
2026-11-12 14:25insertab-inbev 4016700 ↔ doordash 1075977same address and namemerged12
2026-11-12 14:25insertab-inbev 4016700 ↔ vtinfo 7cec131e1452dba3same address and namemerged12
2026-11-09 14:23insertoverture 415783a6-fc7c-42f4-8e62-29b99e433c45 ↔ ubereats o-teBcQgRMGN_b7wC1WNFAsame address and namemerged11
2026-11-09 14:23insertdoordash 1075977 ↔ ubereats o-teBcQgRMGN_b7wC1WNFAsame address and namemerged11
2026-11-06 18:13insertdoordash 1075977 ↔ overture 415783a6-fc7c-42f4-8e62-29b99e433c45same address and namemerged11