Mcaddys

TROY, NY 12180 · O10a9a39cb7a2 · first seen 2026-10-08
5 sourceson premise · restaurantalcohol: 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
Mcaddys 3 other
a licence name in capitals, cleaned (derived; record_title.py)
MCADDY'S PUB ny-slaoverture ×2
LJAAA CORP ny-sla (legal name)
mcaddy's troy doordash
Street
452 BROADWAY
ny-slano other value
City
TROY
ny-slano other value
State
NY
ny-slano other value
ZIP
12180
ny-slano other value
Pin
42.73114, -73.68838 map
doordashno other value
Phone
5183658229 1 other
vtinfo
5183260588 overture
Licences
ny-sla 0370-24-204434
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O83f60b35d537; Oe1e93de0fe10; O84fbee22da74; O70866caf6436

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-inbevMCADDYS
4103986
452 BROADWAY, TROY, NY, 1218042.73111, -73.688082026-11-112026-11-11
doordashmcaddy's troy
827391
452 Broadway, Troy, NY42.73114, -73.688382026-10-082026-11-14
ny-slaMCADDY'S PUB
legal name: LJAAA CORP
0370-24-204434
452 BROADWAY, TROY, NY, 1218042.73104, -73.688302026-11-022026-11-05
overtureMcAddy's Pub
d07d66c1-77b3-465b-b172-3d9e724c71ea
452 Broadway, Troy, NY, 12180518326058842.73116, -73.688352026-11-062026-11-06
vtinfoMCADDYS
3a47915c180a7958
452 BROADWAY, TROY, NY, 12180518365822942.73125, -73.688242026-11-122026-11-14

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 MCADDYSdoordash mcaddy's troy1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 25 m apart · name similarity 1.00
ab-inbev MCADDYSvtinfo MCADDYS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 20 m apart · name similarity 1.00
doordash mcaddy's troyvtinfo MCADDYS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 16 m apart · name similarity 1.00
ny-sla MCADDY'S PUBoverture McAddy's Pub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 14 m apart · name similarity 1.00
ab-inbev MCADDYSny-sla MCADDY'S PUB0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 20 m apart · name similarity 0.64
ab-inbev MCADDYSoverture McAddy's Pub0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 23 m apart · name similarity 0.64
doordash mcaddy's troyny-sla MCADDY'S PUB0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + city + state · pins 13 m apart · name similarity 0.64
doordash mcaddy's troyoverture McAddy's Pub0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + city + state · pins 3 m apart · name similarity 0.64
ny-sla MCADDY'S PUBvtinfo MCADDYS0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + city + state · pins 23 m apart · name similarity 0.64
overture McAddy's Pubvtinfo MCADDYS0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + city + state · pins 13 m apart · name similarity 0.64 · phone: differs

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
LJAAA CORP — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — NY 0370
Rule version 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
216 within 1 mi · 430 within 3 mi
Off / on premise
31 / 110 within 1 mi · 86 / 197 within 3 mi
Selling alcohol
136 within 1 mi · 283 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.03 mi
Setting
suburban (2,971 people per sq mi)
People within 3 mi
84,015 (60,289 adults 21+, 35,803 households) from 25 tract(s), tracts within 3 mi
Income
per capita $39,012 · median household ~$67,471 (weighted mean of tract medians)
Age and education
median age ~34.2 · bachelor's or higher 36%
Ethnicity
Hispanic 9% · White 68% · Black 13% · Asian 6%
Adults per alcohol outlet
212
Alcohol spend within 3 mi
$20,913,185 a year ($9,820,820 at home, $11,082,937 away) · $73,638 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-14 20:23insertdoordash 827391 ↔ ny-sla 0370-24-204434same address and namemerged15
2026-11-14 20:23insertdoordash 827391 ↔ overture d07d66c1-77b3-465b-b172-3d9e724c71easame address and namemerged15
2026-11-14 20:23insertab-inbev 4103986 ↔ doordash 827391same address and namemerged15
2026-11-14 20:23insertdoordash 827391 ↔ vtinfo 3a47915c180a7958same address and namemerged15
2026-11-12 14:25insertny-sla 0370-24-204434 ↔ vtinfo 3a47915c180a7958same address and namemerged12
2026-11-12 14:25insertoverture d07d66c1-77b3-465b-b172-3d9e724c71ea ↔ vtinfo 3a47915c180a7958same address and namemerged12
2026-11-12 14:25insertab-inbev 4103986 ↔ vtinfo 3a47915c180a7958same address and namemerged12
2026-11-11 12:56insertab-inbev 4103986 ↔ ny-sla 0370-24-204434same address and namemerged12
2026-11-11 12:56insertab-inbev 4103986 ↔ overture d07d66c1-77b3-465b-b172-3d9e724c71easame address and namemerged12
2026-11-06 18:13insertny-sla 0370-24-204434 ↔ overture d07d66c1-77b3-465b-b172-3d9e724c71easame address and namemerged11