Red Wagon Shop

Troy, MI 48083 · O2438524d77e1 · first seen 2026-10-08
4 sourceson premise · restaurantalcohol: 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
Red Wagon Shop 2 other
a licence name in capitals, cleaned (derived; record_title.py)
RW TROY, LLC mi-lcc ×2
red wagon of troy troy doordash
Street
1613 Livernois Rd 1 other
mi-lcc
1613 Livernois Road doordash
City
Troy
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48083
mi-lccno other value
Pin
42.54876, -83.14741 map
doordashno other value
Phone
2484049999 1 other
vtinfo
2485057778 mi-lcc ×2
Licences
mi-lcc L-000446297 · mi-lcc L-000446298
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe895a04f8ee7; O57ca0006ba45; O4147949980c4; O71455159e429

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-inbevRED WAGON SHOP
2763502
1613 LIVERNOIS RD, TROY, MI, 4808342.54876, -83.147442026-11-112026-11-18
doordashred wagon of troy troy
23402334
1613 Livernois Road, Troy, MI, 4808342.54876, -83.147412026-10-082026-11-18
mi-lccRW TROY, LLC
L-000446297
1613 Livernois Rd, Troy, MI, 48083248505777842.54845, -83.147082026-11-032026-11-18
mi-lccRW TROY, LLC
L-000446298
1613 Livernois Rd, Troy, MI, 48083248505777842.54845, -83.147082026-11-032026-11-18
vtinfoRED WAGON SHOP
5e060df7676260d4
1613 LIVERNOIS RD, TROY, MI, 48083248404999942.54876, -83.147442026-11-122026-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 RED WAGON SHOPdoordash red wagon of troy troy1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 3 m apart · name similarity 1.00
ab-inbev RED WAGON SHOPvtinfo RED WAGON SHOP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 0 m apart · name similarity 1.00
doordash red wagon of troy troyvtinfo RED WAGON SHOP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 3 m apart · name similarity 1.00
mi-lcc RW TROY, LLCmi-lcc RW TROY, LLC1.00one store listed twicemergedsame street + ZIP · name: identical
ab-inbev RED WAGON SHOPmi-lcc RW TROY, LLC0.19Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “same-address” pair)
RW Troy LLC matches Red Wagon at same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 72% confident — Both records sit at 1613 Livernois Rd, Troy, MI 48083, about 45 m apart, and 'RW TROY, LLC' reads as the licensed legal entity behind the 'Red Wagon Shop' trade name, but the building holds three businesses, so the address alone is not conclusive.
pair f3aa86081e532547e8d8
ab-inbev RED WAGON SHOPmi-lcc RW TROY, LLC0.19Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (75% confident; asked as a “same-address” pair)
RW Troy LLC matches Red Wagon Shop initials, Troy address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 75% confident — Both records sit at the same street address, city and ZIP, with coordinates about 45 m apart, and the MI licence entity 'RW TROY, LLC' reads as the legal name of the Red Wagon Shop; the shared building with three businesses lowers confidence somewhat.
pair 6e1c17b1eebd3d41c149
mi-lcc RW TROY, LLCvtinfo RED WAGON SHOP0.19Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “same-address” pair)
RW = Red Wagon, same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 72% confident — The Michigan licence holder RW TROY, LLC at 1613 Livernois Rd plausibly is the entity behind the Red Wagon Shop listing at the same street address and ZIP, since 'RW' matches 'Red Wagon'; the phone numbers differ and the building holds three businesses, which keeps confidence moderate rather than high.
pair e8477197f8de5f94890e
mi-lcc RW TROY, LLCvtinfo RED WAGON SHOP0.19Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (75% confident; asked as a “same-address” pair)
RW Troy LLC matches Red Wagon initials, same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: unsure, 55% confident — Both records are at 1613 Livernois Rd, Troy, but the building holds three businesses and the phones differ; 'RW TROY, LLC' could be the legal entity behind 'Red Wagon Shop' (RW initials), but the names do not state that link outright.
pair 030aef66ffd6d102b62b

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
RW TROY, LLC — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — MI Retail - Off Premises/Specially Designated Distributor; MI Retail - Off Premises/Specially Designated Merchant
Rule version 10, computed 2026-11-18 20:35.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ]
 ]
}

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-18 18:58insertab-inbev 2763502 ↔ mi-lcc L-000446297Claude judge: samemerged15
2026-11-18 18:58insertmi-lcc L-000446297 ↔ vtinfo 5e060df7676260d4Claude judge: samemerged15
2026-11-18 18:58insertab-inbev 2763502 ↔ mi-lcc L-000446298Claude judge: samemerged15
2026-11-18 18:58insertmi-lcc L-000446298 ↔ vtinfo 5e060df7676260d4Claude judge: samemerged15
2026-11-18 18:58insertab-inbev 2763502 ↔ doordash 23402334same address and namemerged15
2026-11-18 18:58insertdoordash 23402334 ↔ vtinfo 5e060df7676260d4same address and namemerged15
2026-11-12 14:25insertab-inbev 2763502 ↔ vtinfo 5e060df7676260d4same address and namemerged12
2026-11-03 13:33backfillmi-lcc L-000446297 ↔ mi-lcc L-000446298one store listed twicemerged