Red Wagon Wine Shop 2

Rochester Hills, MI 48307 · O185065270c3b · first seen 2026-11-03
4 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
Red Wagon Wine Shop 2 3 other
a licence name in capitals, cleaned (derived; record_title.py)
INDY KIDS, INC. mi-lcc (legal name) ×2
RED WAGON WINE SHOPPE mi-lcc ×2
Red Wagon Shoppe overture
Street
2940 & 2944 S Rochester Rd 1 other
mi-lcc
2940 S ROCHESTER RD ab-inbevoverturevtinfo ×3
City
Rochester Hills 1 other
mi-lcc
ROCHESTER ab-inbevvtinfo ×2
State
MI
mi-lccno other value
ZIP
48307
mi-lccno other value
Pin
42.63690, -83.13239 map
overtureno other value
Phone
2488529307
vtinfono other value
Licences
mi-lcc L-000134401 · mi-lcc L-000134402
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oa372b80f9955; O54203c68607b; O2d3e7700ca76; O840b763ea2ad

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 WINE SHOP 2
2535099
2940 S ROCHESTER RD, ROCHESTER, MI, 48307
ZIP lookup: Rochester Hills, MI
42.63673, -83.131842026-11-112026-11-12
mi-lccRED WAGON WINE SHOPPE
legal name: INDY KIDS, INC.
L-000134401
2940 & 2944 S Rochester Rd, Rochester Hills, MI, 48307248852930742.63696, -83.131852026-11-032026-11-05
mi-lccRED WAGON WINE SHOPPE
legal name: INDY KIDS, INC.
L-000134402
2940 & 2944 S Rochester Rd, Rochester Hills, MI, 48307248852930742.63696, -83.131852026-11-032026-11-05
overtureRed Wagon Shoppe
9f98bae5-3195-4348-a46e-9d8d75ca93b3
2940 S Rochester Rd, Rochester Hills, MI, 48307248852930742.63690, -83.132392026-11-182026-11-18
vtinfoRED WAGON WINE SHOP 2
408a656c3f442acb
2940 S ROCHESTER RD, ROCHESTER, MI, 48307
ZIP lookup: Rochester Hills, MI
248852930742.63661, -83.132372026-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 RED WAGON WINE SHOP 2vtinfo RED WAGON WINE SHOP 21.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 46 m apart · name similarity 1.00
mi-lcc RED WAGON WINE SHOPPEmi-lcc RED WAGON WINE SHOPPE1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc RED WAGON WINE SHOPPEoverture Red Wagon Shoppe0.81street written two waysmergedname Jaro-Winkler 0.95 · matched on zip · pins 44 m apart · name similarity 0.81 · street similarity 0.85
mi-lcc RED WAGON WINE SHOPPEoverture Red Wagon Shoppe0.81street written two waysmergedname Jaro-Winkler 0.95 · matched on zip · pins 44 m apart · name similarity 0.81 · street similarity 0.85
ab-inbev RED WAGON WINE SHOP 2mi-lcc RED WAGON WINE SHOPPE0.68Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “near” pair)
Red Wagon Wine Shop name and address match.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records name the same wine shop (RED WAGON WINE SHOP 2 vs RED WAGON WINE SHOPPE) at 2940 S Rochester Rd, ZIP 48307, with coordinates about 26 m apart and no other businesses at the address; the 2944 suite in B is a minor address variant of the same storefront.
pair 4122572d53f370400278

Attributes

Channel
off_premise · liquor_store — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
INDY KIDS, INC. — 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": [
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
80 within 1 mi · 274 within 3 mi
Off / on premise
24 / 44 within 1 mi · 71 / 141 within 3 mi
Selling alcohol
30 within 1 mi · 142 within 3 mi
Nearest
same channel 0.06 mi · licensed 0.01 mi
Setting
suburban (2,490 people per sq mi)
People within 3 mi
70,390 (52,249 adults 21+, 27,429 households) from 17 tract(s), tracts within 3 mi
Income
per capita $54,736 · median household ~$116,954 (weighted mean of tract medians)
Age and education
median age ~41.8 · bachelor's or higher 57%
Ethnicity
Hispanic 4% · White 69% · Black 4% · Asian 17%
Adults per alcohol outlet
365
Alcohol spend within 3 mi
$23,310,106 a year ($10,271,374 at home, $13,029,200 away) · $163,008 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-18 18:58insertmi-lcc L-000134401 ↔ overture 9f98bae5-3195-4348-a46e-9d8d75ca93b3street written two waysmerged15
2026-11-18 18:58insertmi-lcc L-000134402 ↔ overture 9f98bae5-3195-4348-a46e-9d8d75ca93b3street written two waysmerged15
2026-11-12 17:29insertab-inbev 2535099 ↔ mi-lcc L-000134402Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 2535099 ↔ vtinfo 408a656c3f442acbsame address and namemerged12
2026-11-03 13:33backfillmi-lcc L-000134401 ↔ mi-lcc L-000134402one store listed twicemerged