ROBUSTO'S CIGAR BAR & BISTRO

Sterling Heights, MI 48313 · O05f6225a053b · first seen 2026-11-03
5 sourceson premise · baralcohol: 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
ROBUSTO'S CIGAR BAR & BISTRO 4 other
the most common name a source states
RARE CO LLC mi-lcc (legal name) ×2
RUBUSTOS CIGAR BAR & BISTRO ab-inbevvtinfo ×2
Robusto's Cigar Bar and Bistro overture
Robustos Cigar Bar And Bistro toast
Street
12170 Hall Rd
mi-lccno other value
City
Sterling Heights
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48313
mi-lccno other value
Pin
42.62557, -83.00707 map 2 other
toast
79 m away mi-lcc ×2
79 m away ab-inbev
Phone
5869998488
vtinfono other value
Licences
mi-lcc L-000402331 · mi-lcc L-000402332
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe4a5eb714d10; Obad4ffec75bb; Oaa241d669b44; Oc02b50cd5d94; O2d8a71122c3e; O15285a37f84b

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-inbevRUBUSTOS CIGAR BAR & BISTRO
4133781
12170 HALL RD, STERLING HEIGHTS, MI, 4831342.62628, -83.007112026-11-112026-11-12
mi-lccROBUSTO'S CIGAR BAR & BISTRO
legal name: RARE CO LLC
L-000402331
12170 Hall Rd, Sterling Heights, MI, 48313586999848842.62626, -83.007302026-11-032026-11-12
mi-lccROBUSTO'S CIGAR BAR & BISTRO
legal name: RARE CO LLC
L-000402332
12170 Hall Rd, Sterling Heights, MI, 48313586999848842.62626, -83.007302026-11-032026-11-12
overtureRobusto's Cigar Bar and Bistro
951e9f8b-f91a-42ed-b281-5a8de72f225d
12170 Hall Rd, Sterling Heights, MI, 48313586999848842.62562, -83.007182026-11-062026-11-12
toastRobustos Cigar Bar And Bistro
6ad7e6c5-3f87-47da-af86-8ed861008ff3
12170 Hall Rd, Sterling Heights, MI, 48313586999848842.62557, -83.007072026-11-062026-11-12
vtinfoRUBUSTOS CIGAR BAR & BISTRO
946b20a325a0c83b
12170 HALL RD, STERLING HEIGHTS, MI, 48313586999848842.62558, -83.007072026-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
mi-lcc ROBUSTO'S CIGAR BAR & BISTROoverture 22c79c9b-ac6e-4723-9f2f-9bbb3bdaf7611.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 78 m apart · matched through the licence's legal name: RARE CO LLC · name similarity 1.00
mi-lcc ROBUSTO'S CIGAR BAR & BISTROoverture 22c79c9b-ac6e-4723-9f2f-9bbb3bdaf7611.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 78 m apart · matched through the licence's legal name: RARE CO LLC · name similarity 1.00
ab-inbev RUBUSTOS CIGAR BAR & BISTROvtinfo RUBUSTOS CIGAR BAR & BISTRO1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 78 m apart · name similarity 1.00
mi-lcc ROBUSTO'S CIGAR BAR & BISTROmi-lcc ROBUSTO'S CIGAR BAR & BISTRO1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc ROBUSTO'S CIGAR BAR & BISTROoverture 5f8226f3-cf4d-4b79-952e-9d5e8c1cd0d51.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 721406 m apart · name similarity 1.00 · phone: equal
mi-lcc ROBUSTO'S CIGAR BAR & BISTROoverture Robusto's Cigar Bar and Bistro1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 71 m apart · name similarity 1.00 · phone: equal
mi-lcc ROBUSTO'S CIGAR BAR & BISTROtoast Robustos Cigar Bar And Bistro1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 79 m apart · name similarity 1.00 · phone: equal
mi-lcc ROBUSTO'S CIGAR BAR & BISTROoverture 5f8226f3-cf4d-4b79-952e-9d5e8c1cd0d51.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 721406 m apart · name similarity 1.00 · phone: equal
mi-lcc ROBUSTO'S CIGAR BAR & BISTROoverture Robusto's Cigar Bar and Bistro1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 71 m apart · name similarity 1.00 · phone: equal
mi-lcc ROBUSTO'S CIGAR BAR & BISTROtoast Robustos Cigar Bar And Bistro1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 79 m apart · name similarity 1.00 · phone: equal
overture 5f8226f3-cf4d-4b79-952e-9d5e8c1cd0d5toast Robustos Cigar Bar And Bistro1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 721362 m apart · name similarity 1.00 · phone: equal
overture Robusto's Cigar Bar and Bistrotoast Robustos Cigar Bar And Bistro1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 10 m apart · name similarity 1.00 · phone: equal
ab-inbev RUBUSTOS CIGAR BAR & BISTROmi-lcc ROBUSTO'S CIGAR BAR & BISTRO0.78same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.97 · same street + ZIP · pins 15 m apart · name similarity 0.78
ab-inbev RUBUSTOS CIGAR BAR & BISTROmi-lcc ROBUSTO'S CIGAR BAR & BISTRO0.78same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.97 · same street + ZIP · pins 15 m apart · name similarity 0.78
ab-inbev RUBUSTOS CIGAR BAR & BISTROoverture Robusto's Cigar Bar and Bistro0.78same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.97 · same street + ZIP · pins 73 m apart · name similarity 0.78
ab-inbev RUBUSTOS CIGAR BAR & BISTROtoast Robustos Cigar Bar And Bistro0.78same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.97 · same street + ZIP · pins 79 m apart · name similarity 0.78
mi-lcc ROBUSTO'S CIGAR BAR & BISTROvtinfo RUBUSTOS CIGAR BAR & BISTRO0.78same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.97 · same street + city + state · pins 78 m apart · name similarity 0.78 · phone: equal
mi-lcc ROBUSTO'S CIGAR BAR & BISTROvtinfo RUBUSTOS CIGAR BAR & BISTRO0.78same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.97 · same street + city + state · pins 78 m apart · name similarity 0.78 · phone: equal
overture Robusto's Cigar Bar and Bistrovtinfo RUBUSTOS CIGAR BAR & BISTRO0.78same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.97 · same street + city + state · pins 10 m apart · name similarity 0.78 · phone: equal
toast Robustos Cigar Bar And Bistrovtinfo RUBUSTOS CIGAR BAR & BISTRO0.78same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.97 · same street + city + state · pins 1 m apart · name similarity 0.78 · phone: equal

Attributes

Channel
on_premise · bar — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
RARE CO LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — MI Retail - Off Premises/Specially Designated Merchant; MI Retail - On Premises/Class C
Rule version 7, computed 2026-11-16 17:14.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

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-12 14:25insertmi-lcc L-000402332 ↔ vtinfo 946b20a325a0c83bsame address and namemerged12
2026-11-12 14:25insertmi-lcc L-000402331 ↔ vtinfo 946b20a325a0c83bsame address and namemerged12
2026-11-12 14:25inserttoast 6ad7e6c5-3f87-47da-af86-8ed861008ff3 ↔ vtinfo 946b20a325a0c83bsame address and namemerged12
2026-11-12 14:25insertoverture 951e9f8b-f91a-42ed-b281-5a8de72f225d ↔ vtinfo 946b20a325a0c83bsame address and namemerged12
2026-11-12 14:25insertab-inbev 4133781 ↔ vtinfo 946b20a325a0c83bsame address and namemerged12
2026-11-11 12:56insertab-inbev 4133781 ↔ toast 6ad7e6c5-3f87-47da-af86-8ed861008ff3same address and namemerged12
2026-11-11 12:56insertab-inbev 4133781 ↔ overture 951e9f8b-f91a-42ed-b281-5a8de72f225dsame address and namemerged12
2026-11-11 12:56insertab-inbev 4133781 ↔ mi-lcc L-000402332same address and namemerged12
2026-11-11 12:56insertab-inbev 4133781 ↔ mi-lcc L-000402331same address and namemerged12
2026-11-09 15:32updateoverture 951e9f8b-f91a-42ed-b281-5a8de72f225d ↔ toast 6ad7e6c5-3f87-47da-af86-8ed861008ff3same address and namemerged11
2026-11-09 15:32updatemi-lcc L-000402332 ↔ overture 951e9f8b-f91a-42ed-b281-5a8de72f225dsame address and namemerged11
2026-11-09 15:32updatemi-lcc L-000402331 ↔ overture 951e9f8b-f91a-42ed-b281-5a8de72f225dsame address and namemerged11
2026-11-06 18:13insertoverture 951e9f8b-f91a-42ed-b281-5a8de72f225d ↔ toast 6ad7e6c5-3f87-47da-af86-8ed861008ff3same address and nameheld: same-source-conflict11
2026-11-06 18:13insertoverture 5f8226f3-cf4d-4b79-952e-9d5e8c1cd0d5 ↔ toast 6ad7e6c5-3f87-47da-af86-8ed861008ff3same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000402332 ↔ toast 6ad7e6c5-3f87-47da-af86-8ed861008ff3same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000402331 ↔ toast 6ad7e6c5-3f87-47da-af86-8ed861008ff3same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000402332 ↔ overture 951e9f8b-f91a-42ed-b281-5a8de72f225dsame address and nameheld: same-source-conflict11
2026-11-06 18:13insertmi-lcc L-000402332 ↔ overture 22c79c9b-ac6e-4723-9f2f-9bbb3bdaf761same address and nameheld: same-source-conflict11
2026-11-06 18:13insertmi-lcc L-000402332 ↔ overture 5f8226f3-cf4d-4b79-952e-9d5e8c1cd0d5same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000402331 ↔ overture 951e9f8b-f91a-42ed-b281-5a8de72f225dsame address and nameheld: same-source-conflict11
2026-11-06 18:13insertmi-lcc L-000402331 ↔ overture 22c79c9b-ac6e-4723-9f2f-9bbb3bdaf761same address and nameheld: same-source-conflict11
2026-11-06 18:13insertmi-lcc L-000402331 ↔ overture 5f8226f3-cf4d-4b79-952e-9d5e8c1cd0d5same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000402331 ↔ mi-lcc L-000402332one store listed twicemerged