MAINE STREET

Hamtramck, MI 48212 · O0bfb7b17970c · first seen 2026-10-08
5 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
MAINE STREET 5 other
the most common name a source states
MAINE STREET RESTAURANT, L.L.C. mi-lcc (legal name) ×2
MAIN STREET RESTAURANT vtinfo
Maine Street Restaurant overture
Maine Street Restaurant & Spirits ubereats
maine street restaurant hamtramck doordash
Street
11650 Joseph Campau St 3 other
mi-lcc
11650 J0SEPH CAMPAU ST vtinfo
11650 Joseph Campau Ave overture
11650 Joseph Campau Avenue doordash
City
Hamtramck
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48212
mi-lccno other value
Pin
42.40305, -83.06165 map 1 other
ubereats
67 m away mi-lcc ×2
Phone
3133680500
vtinfono other value
Licences
mi-lcc L-000113313 · mi-lcc L-000113315
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oab5bc7c01f71; O66990e6eb83b; O7480a47e006c; O9fb3c6f250e9; O4bc6685002ff

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
doordashmaine street restaurant hamtramck
215005
11650 Joseph Campau Avenue, Hamtramck, MI, 4821242.40304, -83.061682026-10-082026-11-03
mi-lccMAINE STREET
legal name: MAINE STREET RESTAURANT, L.L.C.
L-000113313
11650 Joseph Campau St, Hamtramck, MI, 48212313368050042.40245, -83.061612026-11-032026-11-12
mi-lccMAINE STREET
legal name: MAINE STREET RESTAURANT, L.L.C.
L-000113315
11650 Joseph Campau St, Hamtramck, MI, 48212313368050042.40245, -83.061612026-11-032026-11-12
overtureMaine Street Restaurant
f0b50883-f583-4a4d-8739-074652943cc5
11650 Joseph Campau Ave, Hamtramck, MI, 48212313368050042.40301, -83.061692026-11-062026-11-06
ubereatsMaine Street Restaurant & Spirits
Z1eDwvktXRGBQ8NlV-QUAA
11650 Joseph Campau St, Hamtramck, MI, 4821242.40305, -83.061652026-10-082026-10-08
vtinfoMAIN STREET RESTAURANT
0e9f2babf2dfb332
11650 J0SEPH CAMPAU ST, HAMTRAMCK, MI, 48212313368050042.40305, -83.061722026-11-112026-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
doordash maine street restaurant hamtramckoverture Maine Street Restaurant1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 4 m apart · name similarity 1.00
mi-lcc MAINE STREETmi-lcc MAINE STREET1.00one store listed twicemergedsame street + ZIP · name: identical
doordash maine street restaurant hamtramckubereats Maine Street Restaurant & Spirits0.80street written two waysmergedname Jaro-Winkler 0.93 · matched on zip · pins 3 m apart · name similarity 0.80 · street similarity 0.85
overture Maine Street Restaurantubereats Maine Street Restaurant & Spirits0.80street written two waysmergedname Jaro-Winkler 0.93 · matched on zip · pins 5 m apart · name similarity 0.80 · street similarity 0.85
doordash maine street restaurant hamtramckvtinfo MAIN STREET RESTAURANT0.74street written two waysmergedname Jaro-Winkler 0.98 · matched on city · pins 3 m apart · name similarity 0.74 · street similarity 0.79
overture Maine Street Restaurantvtinfo MAIN STREET RESTAURANT0.74street written two waysmergedname Jaro-Winkler 0.98 · matched on city · pins 5 m apart · name similarity 0.74 · street similarity 0.79
doordash maine street restaurant hamtramckmi-lcc MAINE STREET0.68Claude judge: samemerged
Claude Opus 5.5, prompt v9 said same (96% confident; asked as a “near” pair)
The names match: the DoorDash slug 'maine street restaurant hamtramck' is the licence's trade name 'Maine Street' (legal name Maine Street Restaurant LLC) with the city appended, at the same street nu
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v8: same, 94% confident — Same distinctive name 'Maine Street' at the same street number on Joseph Campau in Hamtramck (Avenue vs St), only one business at the address, coordinates 67 m apart.
pair e7f6a8e0c7871becc6cf
mi-lcc MAINE STREETubereats Maine Street Restaurant & Spirits0.65same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: restaurant, spirits · name Jaro-Winkler 0.82 · same street + ZIP · pins 67 m apart · matched through the licence's legal name: MAINE STREET RESTAURANT, L.L.C. · name similarity 0.65
mi-lcc MAINE STREETubereats Maine Street Restaurant & Spirits0.65same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: restaurant, spirits · name Jaro-Winkler 0.82 · same street + ZIP · pins 67 m apart · matched through the licence's legal name: MAINE STREET RESTAURANT, L.L.C. · name similarity 0.65

Attributes

Channel
on_premise · restaurant — ubereats-type
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
MAINE STREET RESTAURANT, L.L.C. — 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 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
 "ue_location": [
  "PHYSICAL"
 ],
 "votes": [
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
134 within 1 mi · 494 within 3 mi
Off / on premise
22 / 69 within 1 mi · 143 / 215 within 3 mi
Selling alcohol
61 within 1 mi · 261 within 3 mi
Nearest
same channel 0.04 mi · licensed 0.03 mi
Setting
urban (4,053 people per sq mi)
People within 3 mi
114,605 (79,421 adults 21+, 40,915 households) from 52 tract(s), tracts within 3 mi
Income
per capita $21,635 · median household ~$42,264 (weighted mean of tract medians)
Age and education
median age ~34.0 · bachelor's or higher 19%
Ethnicity
Hispanic 2% · White 25% · Black 56% · Asian 12%
Adults per alcohol outlet
303
Alcohol spend within 3 mi
$17,493,520 a year ($8,706,429 at home, $8,776,896 away) · $66,769 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-12 17:29insertmi-lcc L-000113315 ↔ ubereats Z1eDwvktXRGBQ8NlV-QUAAsame address and namemerged14
2026-11-12 17:29insertmi-lcc L-000113313 ↔ ubereats Z1eDwvktXRGBQ8NlV-QUAAsame address and namemerged14
2026-11-12 14:25insertdoordash 215005 ↔ mi-lcc L-000113313Claude judge: samemerged12
2026-11-11 12:56insertdoordash 215005 ↔ vtinfo 0e9f2babf2dfb332street written two waysmerged12
2026-11-11 12:56insertoverture f0b50883-f583-4a4d-8739-074652943cc5 ↔ vtinfo 0e9f2babf2dfb332street written two waysmerged12
2026-11-06 18:13insertoverture f0b50883-f583-4a4d-8739-074652943cc5 ↔ ubereats Z1eDwvktXRGBQ8NlV-QUAAstreet written two waysmerged11
2026-11-06 18:13insertdoordash 215005 ↔ overture f0b50883-f583-4a4d-8739-074652943cc5same address and namemerged11
2026-11-03 14:30backfilldoordash 215005 ↔ ubereats Z1eDwvktXRGBQ8NlV-QUAAstreet written two waysmerged
2026-11-03 13:33backfillmi-lcc L-000113313 ↔ mi-lcc L-000113315one store listed twicemerged