Royal Farm

FREDERICKSBURG, VA 22408 · O108948e43f47 · first seen 2026-10-08
4 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 overture
royal farms fredericksburg doordash
Street
5301 Jefferson Davis Highway 1 other
doordash
5301 JEFFERSON DAVIS HWY ab-inbevoverturevtinfo ×3
City
Fredericksburg
doordashno other value
State
VA
doordashno other value
ZIP
22408
doordashno other value
Pin
38.24923, -77.49962 map
doordashno other value
Phone
5403704253 1 other
vtinfo
5406843358 overture
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O30ebccb8e5a4; Of7ab0c57bd39; O64f483fcd865

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
4295212
5301 JEFFERSON DAVIS HWY, FREDERICKSBURG, VA, 2240838.24929, -77.499752026-11-122026-11-12
doordashroyal farms fredericksburg
1138516
5301 Jefferson Davis Highway, Fredericksburg, VA, 2240838.24923, -77.499622026-10-082026-11-13
overtureRoyal Farms
7a3427bf-82b1-4e96-a3b7-b6cc8909b676
5301 Jefferson Davis Hwy, Fredericksburg, VA, 22408540684335838.24916, -77.499152026-11-132026-11-13
vtinfoROYAL FARM
660560a0281eedce
5301 JEFFERSON DAVIS HWY, FREDERICKSBURG, VA, 22408540370425338.24936, -77.499072026-11-172026-11-18

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 60 m apart · name similarity 1.00
doordash royal farms fredericksburgoverture Royal Farms1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 42 m apart · name similarity 1.00
ab-inbev ROYAL FARMdoordash royal farms fredericksburg0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · pins 13 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 55 m apart · name similarity 0.64
doordash royal farms fredericksburgvtinfo ROYAL FARM0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · pins 50 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 23 m apart · name similarity 0.64 · phone: differs

Attributes

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

Trade area

Other outlets
90 within 1 mi · 224 within 3 mi
Off / on premise
19 / 53 within 1 mi · 56 / 133 within 3 mi
Selling alcohol
48 within 1 mi · 110 within 3 mi
Nearest
same channel 0.04 mi · licensed 0.28 mi
Setting
suburban (1,936 people per sq mi)
People within 3 mi
54,734 (39,931 adults 21+, 20,707 households) from 12 tract(s), tracts within 3 mi
Income
per capita $46,277 · median household ~$103,518 (weighted mean of tract medians)
Age and education
median age ~38.0 · bachelor's or higher 38%
Ethnicity
Hispanic 16% · White 57% · Black 19% · Asian 4%
Adults per alcohol outlet
360
Alcohol spend within 3 mi
$16,222,503 a year ($7,282,573 at home, $8,932,744 away) · $146,149 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-17 17:19insertoverture 7a3427bf-82b1-4e96-a3b7-b6cc8909b676 ↔ vtinfo 660560a0281eedcesame address and namemerged15
2026-11-17 17:19insertdoordash 1138516 ↔ vtinfo 660560a0281eedcesame address and namemerged15
2026-11-17 17:19insertab-inbev 4295212 ↔ vtinfo 660560a0281eedcesame address and namemerged15
2026-11-13 14:10insertab-inbev 4295212 ↔ overture 7a3427bf-82b1-4e96-a3b7-b6cc8909b676same address and namemerged15
2026-11-13 14:10insertdoordash 1138516 ↔ overture 7a3427bf-82b1-4e96-a3b7-b6cc8909b676same address and namemerged15
2026-11-12 14:25insertab-inbev 4295212 ↔ doordash 1138516same address and namemerged12