Royal Farm

FREDERICKSBURG, VA 22406 · O0fe9e1e7aa7e · 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
1221 Warrenton Road 1 other
doordash
1221 WARRENTON RD ab-inbevoverturevtinfo ×3
City
Fredericksburg
doordashno other value
State
VA
doordashno other value
ZIP
22406
doordashno other value
Pin
38.37181, -77.52772 map 2 other
doordash
171 m away ab-inbev
389 m away vtinfo
Phone
5409074527
vtinfono other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O63518ca68fd0; O7b4c46c10f4f; Of77016e43bd7

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
4016697
1221 WARRENTON RD, FREDERICKSBURG, VA, 2240638.37190, -77.529682026-11-132026-11-13
doordashroyal farms fredericksburg
1138601
1221 Warrenton Road, Fredericksburg, VA, 2240638.37181, -77.527722026-10-082026-11-15
overtureRoyal Farms
c662bbb3-fbe3-41ca-974b-c3349a94673c
1221 Warrenton Rd, Fredericksburg, VA, 22406540907452738.37156, -77.527952026-11-132026-11-13
vtinfoROYAL FARM
1a5c10bf56fcdcdd
1221 WARRENTON RD, FREDERICKSBURG, VA, 22406540907452738.37449, -77.524862026-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 510 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 + city + state · pins 34 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 171 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 155 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 389 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 423 m apart · name similarity 0.64 · phone: equal

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 +4 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
21 within 1 mi · 89 within 3 mi
Off / on premise
6 / 12 within 1 mi · 20 / 51 within 3 mi
Selling alcohol
9 within 1 mi · 32 within 3 mi
Nearest
same channel 0.13 mi · licensed 0.99 mi
Setting
suburban (768 people per sq mi)
People within 3 mi
21,701 (16,742 adults 21+, 8,333 households) from 3 tract(s), tracts within 3 mi
Income
per capita $54,985 · median household ~$121,102 (weighted mean of tract medians)
Age and education
median age ~43.0 · bachelor's or higher 40%
Ethnicity
Hispanic 14% · White 53% · Black 22% · Asian 6%
Adults per alcohol outlet
507
Alcohol spend within 3 mi
$7,115,675 a year ($3,105,826 at home, $4,007,032 away) · $215,627 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:19insertdoordash 1138601 ↔ vtinfo 1a5c10bf56fcdcddsame address and namemerged15
2026-11-17 17:19insertoverture c662bbb3-fbe3-41ca-974b-c3349a94673c ↔ vtinfo 1a5c10bf56fcdcddsame address and namemerged15
2026-11-17 17:19insertab-inbev 4016697 ↔ vtinfo 1a5c10bf56fcdcddsame address and namemerged15
2026-11-14 20:23insertab-inbev 4016697 ↔ doordash 1138601same address and namemerged15
2026-11-14 20:23insertdoordash 1138601 ↔ overture c662bbb3-fbe3-41ca-974b-c3349a94673csame address and namemerged15
2026-11-13 14:10insertab-inbev 4016697 ↔ overture c662bbb3-fbe3-41ca-974b-c3349a94673csame address and namemerged15