Windsor Distributing Inc.

HAMBURG, PA 19526 · O38161d1a6d51 · first seen 2026-10-08
5 sourcesoff premisealcohol: licensed1 licence

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
Windsor Distributing Inc. 4 other
a source's own spelling of the licence name (record_title.py)
WINDSOR DISTRIBUTING CO ab-inbevvtinfo ×2
GLEN J. & DIANA L. COCK ttb (legal name)
WINDSOR DISTRIBUTING COMPANY ttb
windsor distributing inc. hamburg doordash
Street
800 S 4th St 1 other
doordash
800 S Fourth St overture
City
Hamburg
doordashno other value
State
PA
doordashno other value
ZIP
19526
doordashno other value
Pin
40.54399, -75.97945 map 2 other
doordash
117 m away ab-inbev
78 m away ttb
Phone
6105622474
vtinfono other value
Licences
ttb PA-P-5721
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O9d630252efc7; O46acb569d97b; Odcd5b641d71f; O38dcb3098fd6

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-inbevWINDSOR DISTRIBUTING CO
2697108
800 S 4TH ST, HAMBURG, PA, 1952640.54337, -75.978332026-11-132026-11-13
doordashwindsor distributing inc. hamburg
41946949
800 S 4th St, Hamburg, PA, 1952640.54399, -75.979452026-10-082026-11-05
overtureWindsor Distributing Inc.
a4a2b2fa-0d0b-4614-aea0-546ebfa59c36
800 S Fourth St, Hamburg, PA, 19526610562247440.54391, -75.979432026-11-062026-11-06
ttbWINDSOR DISTRIBUTING COMPANY
legal name: GLEN J. & DIANA L. COCK
PA-P-5721
800 S 4TH ST, HAMBURG, PA, 1952640.54428, -75.978622026-11-032026-11-05
vtinfoWINDSOR DISTRIBUTING CO
d7252bfaeecf42a6
800 S 4TH ST, HAMBURG, PA, 19526610562247440.54397, -75.979452026-11-162026-11-17

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 WINDSOR DISTRIBUTING COdoordash windsor distributing inc. hamburg1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 117 m apart · name similarity 1.00
ab-inbev WINDSOR DISTRIBUTING COoverture Windsor Distributing Inc.1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 111 m apart · name similarity 1.00
ab-inbev WINDSOR DISTRIBUTING COttb WINDSOR DISTRIBUTING COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 105 m apart · name similarity 1.00
ab-inbev WINDSOR DISTRIBUTING COvtinfo WINDSOR DISTRIBUTING CO1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 115 m apart · name similarity 1.00
doordash windsor distributing inc. hamburgoverture Windsor Distributing Inc.1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00
doordash windsor distributing inc. hamburgttb WINDSOR DISTRIBUTING COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 78 m apart · name similarity 1.00
doordash windsor distributing inc. hamburgvtinfo WINDSOR DISTRIBUTING CO1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 3 m apart · name similarity 1.00
overture Windsor Distributing Inc.ttb WINDSOR DISTRIBUTING COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 80 m apart · name similarity 1.00
overture Windsor Distributing Inc.vtinfo WINDSOR DISTRIBUTING CO1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 6 m apart · name similarity 1.00 · phone: equal
ttb WINDSOR DISTRIBUTING COMPANYvtinfo WINDSOR DISTRIBUTING CO1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 79 m apart · name similarity 1.00

Attributes

Channel
off_premise — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
none
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
19 within 1 mi · 54 within 3 mi
Off / on premise
9 / 10 within 1 mi · 24 / 27 within 3 mi
Selling alcohol
6 within 1 mi · 17 within 3 mi
Nearest
same channel 0.04 mi · licensed 0.80 mi
Setting
rural (158 people per sq mi)
People within 3 mi
4,456 (3,247 adults 21+, 2,047 households) from 1 tract(s), tracts within 3 mi
Income
per capita $35,026 · median household ~$55,446 (weighted mean of tract medians)
Age and education
median age ~38.2 · bachelor's or higher 22%
Ethnicity
Hispanic 10% · White 89% · Black 2% · Asian 0%
Adults per alcohol outlet
180
Alcohol spend within 3 mi
$1,075,007 a year ($520,730 at home, $554,119 away) · $59,723 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-16 14:56insertoverture a4a2b2fa-0d0b-4614-aea0-546ebfa59c36 ↔ vtinfo d7252bfaeecf42a6same address and namemerged15
2026-11-16 14:56insertdoordash 41946949 ↔ vtinfo d7252bfaeecf42a6same address and namemerged15
2026-11-16 14:56insertab-inbev 2697108 ↔ vtinfo d7252bfaeecf42a6same address and namemerged15
2026-11-16 14:56insertttb PA-P-5721 ↔ vtinfo d7252bfaeecf42a6same address and namemerged15
2026-11-13 17:47insertab-inbev 2697108 ↔ overture a4a2b2fa-0d0b-4614-aea0-546ebfa59c36same address and namemerged15
2026-11-13 17:47insertab-inbev 2697108 ↔ doordash 41946949same address and namemerged15
2026-11-13 17:47insertab-inbev 2697108 ↔ ttb PA-P-5721same address and namemerged15
2026-11-06 18:13insertdoordash 41946949 ↔ overture a4a2b2fa-0d0b-4614-aea0-546ebfa59c36same address and namemerged11
2026-11-06 18:13insertoverture a4a2b2fa-0d0b-4614-aea0-546ebfa59c36 ↔ ttb PA-P-5721same address and namemerged11
2026-11-04 18:12backfilldoordash 41946949 ↔ ttb PA-P-5721same address and namemerged