Mobil Oil

Macomb, MI 48042 · O16368d9a1cd8 · first seen 2026-11-03
4 sourcesoff premise · predictedalcohol: 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
Mobil Oil 1 other
a licence name in capitals, cleaned (derived; record_title.py)
LAKESIDE MOBIL mi-lccsnap ×2
Street
46900 North Ave
mi-lccno other value
City
Macomb
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48042
mi-lccno other value
Pin
42.64363, -82.87659 map 1 other
snap
59 m away vtinfo
Phone
5869498449 1 other
vtinfo
5869484716 mi-lcc
Licences
mi-lcc L-000210916
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O9685d995624a; O76a5ab86aad6; O61fb5adf52d4

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-inbevMOBIL OIL
3357308
46900 NORTH AVE, MACOMB, MI, 4804242.64394, -82.876572026-11-112026-11-18
mi-lccLAKESIDE MOBIL
L-000210916
46900 North Ave, Macomb, MI, 48042586948471642.64367, -82.876582026-11-032026-11-04
snapLakeside Mobil
snap|us|910372
46900 North Ave, Macomb, MI, 4804242.64363, -82.876592026-11-192026-11-19
vtinfoMOBIL OIL
03ebd382eab90253
46900 NORTH AVE, MACOMB, MI, 48042586949844942.64375, -82.875892026-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 MOBIL OILvtinfo MOBIL OIL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 60 m apart · name similarity 1.00
mi-lcc LAKESIDE MOBILsnap Lakeside Mobil1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00
ab-inbev MOBIL OILmi-lcc LAKESIDE MOBIL0.38Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “same-address” pair)
Mobil gas station same address; Lakeside Mobil is its name
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records sit at the same street address (about 0.03 km apart) in Macomb, MI, and the only two businesses there are these two names, which share the Mobil brand: 'MOBIL OIL' from the ab-inbev account likely corresponds to the licensed station 'LAKESIDE MOBIL' filed with the Michigan LCC.
pair c8cf86a9218aafe4d25e
mi-lcc LAKESIDE MOBILvtinfo MOBIL OIL0.38Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (75% confident; asked as a “same-address” pair)
Mobil station same address; Lakeside Mobil is its trade name.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 60% confident — Both records sit at the same street address with nearly identical coordinates (0.057 km apart) and both carry the Mobil name, which suggests one gas station, with the VIP listing using the brand name; the differing phone numbers and the two-business count at the address keep this from being certain.
pair acf5eadd4832c59517e8

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_off, wine_off — MI Retail - Off Premises/Specially Designated Merchant
Rule version 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
12 within 1 mi · 201 within 3 mi
Off / on premise
3 / 5 within 1 mi · 57 / 95 within 3 mi
Selling alcohol
7 within 1 mi · 111 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.07 mi
Setting
suburban (2,458 people per sq mi)
People within 3 mi
69,491 (50,892 adults 21+, 26,308 households) from 16 tract(s), tracts within 3 mi
Income
per capita $43,682 · median household ~$99,272 (weighted mean of tract medians)
Age and education
median age ~38.8 · bachelor's or higher 30%
Ethnicity
Hispanic 5% · White 76% · Black 11% · Asian 3%
Adults per alcohol outlet
454
Alcohol spend within 3 mi
$19,410,528 a year ($8,744,545 at home, $10,657,703 away) · $173,308 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-19 20:37insertmi-lcc L-000210916 ↔ snap snap|us|910372same address and namemerged17
2026-11-18 18:58insertab-inbev 3357308 ↔ mi-lcc L-000210916Claude judge: samemerged15
2026-11-18 18:58insertmi-lcc L-000210916 ↔ vtinfo 03ebd382eab90253Claude judge: samemerged15
2026-11-12 14:25insertab-inbev 3357308 ↔ vtinfo 03ebd382eab90253same address and namemerged12