ROYAL WINERY LLC

HARRISBURG, PA 17112 · O1175bfe8f5cb · first seen 2026-11-03
2 sourcesoff premise · liquor_storealcohol: licensed2 licences

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 WINERY LLC 1 other
the most common name a source states
Royal Winery overture
Street
5790 DEVONSHIRE RD
ttbno other value
City
HARRISBURG
ttbno other value
State
PA
ttbno other value
ZIP
17112
ttbno other value
Pin
40.30444, -76.78630 map 1 other
overture
117 m away ttb ×2
Phone
7178575544
overtureno other value
Licences
ttb PA-S-20295 · ttb PA-W-21438
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O8f3af17329c7; O83810b76774a

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
overtureRoyal Winery
aadf666f-c8ce-4dfc-85b6-413a8905a1c1
5790 Devonshire Rd, Harrisburg, PA, 17112717857554440.30444, -76.786302026-11-062026-11-06
ttbROYAL WINERY LLC
PA-S-20295
5790 DEVONSHIRE RD, HARRISBURG, PA, 1711240.30344, -76.786752026-11-032026-11-06
ttbROYAL WINERY LLC
PA-W-21438
5790 DEVONSHIRE RD, HARRISBURG, PA, 1711240.30344, -76.786752026-11-032026-11-06

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
overture d3709c43-4e6e-4ba9-a2d2-992d0ddd2021ttb ROYAL WINERY LLC1.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 116 m apart · name similarity 1.00
overture d3709c43-4e6e-4ba9-a2d2-992d0ddd2021ttb ROYAL WINERY LLC1.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 116 m apart · name similarity 1.00
overture Royal Wineryttb ROYAL WINERY LLC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 117 m apart · name similarity 1.00
overture Royal Wineryttb ROYAL WINERY LLC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 117 m apart · name similarity 1.00
ttb ROYAL WINERY LLCttb ROYAL WINERY LLC1.00one store listed twicemergedsame street + ZIP · name: identical

Attributes

Channel
off_premise · liquor_store — name
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
ROYAL WINERY LLC — 1 outlets in the master under this operator
Licence privileges
none
Rule version 7, computed 2026-11-16 17:14.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
26 within 1 mi · 118 within 3 mi
Off / on premise
16 / 6 within 1 mi · 54 / 50 within 3 mi
Selling alcohol
8 within 1 mi · 36 within 3 mi
Nearest
same channel 0.61 mi · licensed 1.25 mi
Setting
suburban (2,075 people per sq mi)
People within 3 mi
58,672 (43,540 adults 21+, 23,457 households) from 10 tract(s), tracts within 3 mi
Income
per capita $41,972 · median household ~$88,540 (weighted mean of tract medians)
Age and education
median age ~39.7 · bachelor's or higher 34%
Ethnicity
Hispanic 10% · White 60% · Black 17% · Asian 13%
Adults per alcohol outlet
1,177
Alcohol spend within 3 mi
$15,731,582 a year ($7,224,989 at home, $8,499,807 away) · $425,178 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-09 23:07.

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-06 18:13insertoverture d3709c43-4e6e-4ba9-a2d2-992d0ddd2021 ↔ ttb PA-S-20295same address and nameheld: same-source-conflict11
2026-11-06 18:13insertoverture aadf666f-c8ce-4dfc-85b6-413a8905a1c1 ↔ ttb PA-S-20295same address and namemerged11
2026-11-06 18:13insertoverture d3709c43-4e6e-4ba9-a2d2-992d0ddd2021 ↔ ttb PA-W-21438same address and nameheld: same-source-conflict11
2026-11-06 18:13insertoverture aadf666f-c8ce-4dfc-85b6-413a8905a1c1 ↔ ttb PA-W-21438same address and namemerged11
2026-11-03 13:33backfillttb PA-S-20295 ↔ ttb PA-W-21438one store listed twicemerged