Royal Farm

North Wales, PA 19454 · O61ddbcec8e10 · first seen 2026-10-08
5 sourcesoff premise · conveniencechain: 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 north wales doordash
Street
467 North Sumneytown Pike 2 other
ubereats
467 N SUMNEYTOWN PKE ab-inbevvtinfo ×2
467 N Sumneytown Pike overture
City
North Wales
ubereatsno other value
State
PA
ubereatsno other value
ZIP
19454
ubereatsno other value
Pin
40.21677, -75.29144 map 2 other
ubereats
3.8 km away ab-inbev
61 m away overture
Phone
2676136032
vtinfono other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ofdd6f8013703; Oc2dcbefc06ed; Ob0e946377af1; Ob088f973686e

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
4440918
467 N SUMNEYTOWN PKE, NORTH WALES, PA, 1945440.22310, -75.247512026-11-122026-11-15
doordashroyal farms north wales
1753385
467 North Sumneytown Pike, North Wales, PA, 1945440.21681, -75.291402026-10-082026-10-28
overtureRoyal Farms
fc4a0328-5983-4b60-b422-f2546c83e319
467 N Sumneytown Pike, North Wales, PA, 19454267613603240.21684, -75.290732026-11-062026-11-06
ubereatsRoyal Farms
G5h0vlZ6So2bVe6v_f4XCQ
467 North Sumneytown Pike, North Wales, PA, 1945440.21677, -75.291442026-10-112026-10-27
vtinfoROYAL FARM
aa317aca2136081a
467 N SUMNEYTOWN PKE, NORTH WALES, PA, 19454267613603240.21670, -75.291072026-11-152026-11-15

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 + ZIP · pins 3766 m apart · name similarity 1.00
doordash royal farms north walesoverture Royal Farms1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 57 m apart · name similarity 1.00
doordash royal farms north walesubereats Royal Farms1.00same address and namemergedaddress similarity 1.00 · same street + city + state · pins 6 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 61 m apart · name similarity 1.00
doordash royal farms north walesvtinfo ROYAL FARM0.64street written two waysmergedname Jaro-Winkler 0.98 · matched on city · pins 30 m apart · name similarity 0.64 · street similarity 0.97
overture Royal Farmsvtinfo ROYAL FARM0.64street written two waysmergedname Jaro-Winkler 0.98 · matched on city · pins 33 m apart · name similarity 0.64 · street similarity 0.97
ubereats Royal Farmsvtinfo ROYAL FARM0.64street written two waysmergedname Jaro-Winkler 0.98 · matched on city · pins 33 m apart · name similarity 0.64 · street similarity 0.97

Attributes

Channel
off_premise · convenience — ubereats-type conflicting evidence
Chain
Royal Farms — ubereats-parent
Alcohol
alcohol — listed as carrying Boston Beer, Bud Light (AB InBev), Diageo Beer Company +7 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": [
  [
   "ubereats-type",
   "off_premise",
   "convenience"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
29 within 1 mi · 190 within 3 mi
Off / on premise
9 / 15 within 1 mi · 47 / 94 within 3 mi
Selling alcohol
14 within 1 mi · 68 within 3 mi
Nearest
same channel 0.05 mi · licensed 0.95 mi
Setting
suburban (2,602 people per sq mi)
People within 3 mi
73,562 (56,155 adults 21+, 28,836 households) from 17 tract(s), tracts within 3 mi
Income
per capita $60,590 · median household ~$122,334 (weighted mean of tract medians)
Age and education
median age ~43.9 · bachelor's or higher 54%
Ethnicity
Hispanic 4% · White 71% · Black 7% · Asian 15%
Adults per alcohol outlet
814
Alcohol spend within 3 mi
$24,573,749 a year ($10,770,447 at home, $13,794,578 away) · $356,141 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-15 16:24insertubereats G5h0vlZ6So2bVe6v_f4XCQ ↔ vtinfo aa317aca2136081astreet written two waysmerged15
2026-11-15 16:24insertdoordash 1753385 ↔ vtinfo aa317aca2136081astreet written two waysmerged15
2026-11-15 16:24insertoverture fc4a0328-5983-4b60-b422-f2546c83e319 ↔ vtinfo aa317aca2136081astreet written two waysmerged15
2026-11-15 16:24insertab-inbev 4440918 ↔ vtinfo aa317aca2136081asame address and namemerged15
2026-11-06 18:13insertoverture fc4a0328-5983-4b60-b422-f2546c83e319 ↔ ubereats G5h0vlZ6So2bVe6v_f4XCQsame address and namemerged11
2026-11-06 18:13insertdoordash 1753385 ↔ overture fc4a0328-5983-4b60-b422-f2546c83e319same address and namemerged11
2026-10-27 01:03backfilldoordash 1753385 ↔ ubereats G5h0vlZ6So2bVe6v_f4XCQsame address and namemerged