Bill Shell

Burton, MI 48519 · O5275e6a7f999 · first seen 2026-11-03
4 sourcesoff premise · predictedalcohol: 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
Bill Shell 2 other
a licence name in capitals, cleaned (derived; record_title.py)
Bill LLC snapmi-lcc (legal name) ×3
SHELL GAS STATION mi-lcc ×2
Street
2514 S Belsay Rd
mi-lccno other value
City
Burton
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48519
mi-lccno other value
Pin
42.99043, -83.59447 map 1 other
snap
417 m away mi-lcc ×2
Phone
8107430070
vtinfono other value
Licences
mi-lcc L-000218720 · mi-lcc L-000484198
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ofcb479f6106b; Oa03efeefd165; Oa2303df9408d; Ocdab16162b4a

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-inbevBILL SHELL
3360944
2514 S BELSAY RD, BURTON, MI, 4851942.99028, -83.594502026-11-122026-11-14
mi-lccSHELL GAS STATION
legal name: BILL LLC
L-000218720
2514 S Belsay Rd, Burton, MI, 48519810743007042.99418, -83.594702026-11-032026-11-18
mi-lccSHELL GAS STATION
legal name: BILL LLC
L-000484198
2514 S Belsay Rd, Burton, MI, 48519810743007042.99418, -83.594702026-11-032026-11-18
snapBill LLC
snap|us|842494
2514 S Belsay Rd, Burton, MI, 4851942.99043, -83.594472026-11-192026-11-19
vtinfoBILL SHELL
f838ff77a84a7553
2514 S BELSAY RD, BURTON, MI, 48519810743007042.99061, -83.594892026-11-142026-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 BILL SHELLvtinfo BILL SHELL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 49 m apart · name similarity 1.00
mi-lcc SHELL GAS STATIONmi-lcc SHELL GAS STATION1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc SHELL GAS STATIONsnap Bill LLC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 417 m apart · matched through the licence's legal name: BILL LLC · name similarity 1.00
mi-lcc SHELL GAS STATIONsnap Bill LLC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 417 m apart · matched through the licence's legal name: BILL LLC · name similarity 1.00
ab-inbev BILL SHELLmi-lcc SHELL GAS STATION0.54Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “near” pair)
Bill LLC Shell station, same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records sit at 2514 S Belsay Rd, Burton MI 48519, and the names line up: Record A's 'BILL SHELL' matches Record B's legal name 'BILL LLC' plus its 'SHELL GAS STATION' trade name, though the address is shared with two other businesses, which lowers confidence somewhat.
pair 2a13a1980bdb106dc45c
ab-inbev BILL SHELLmi-lcc SHELL GAS STATION0.54Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “near” pair)
Bill Shell matches Bill LLC Shell station, same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 72% confident — Both records give the same street address in Burton, MI 48519, and the names overlap strongly: AB InBev's 'BILL SHELL' matches the Michigan licence's legal entity 'BILL LLC' and its trade name 'SHELL GAS STATION', which is consistent with one Shell gas station run by Bill LLC. The building is shared with two other businesses and the coordinates are about 0.43 km apart, which lowers confidence somewhat.
pair 6cf184511a1477321e82
mi-lcc SHELL GAS STATIONvtinfo BILL SHELL0.54Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “near” pair)
Same address, phone equal, Bill name matches.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records sit at 2514 S Belsay Rd, Burton, MI with the identical phone number, and A's legal entity BILL LLC matches the 'BILL' in B's name 'BILL SHELL', which also echoes A's 'SHELL GAS STATION' trade name, so they look like one gas-station operation, though the address is shared by three businesses.
pair b6a9ed0487b903ec42e2
mi-lcc SHELL GAS STATIONvtinfo BILL SHELL0.54Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “near” pair)
Equal phone, same address, Bill LLC Shell
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records share the exact street address, ZIP and phone number, and Record A's legal entity 'BILL LLC' matches the 'BILL' in Record B's name 'BILL SHELL', which points to one Shell gas station operation; the three businesses at the address lowers confidence somewhat.
pair 57b42092aff244610d81

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
BILL 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 11, computed 2026-11-20 23:34.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
4 within 1 mi · 142 within 3 mi
Off / on premise
2 / 1 within 1 mi · 47 / 68 within 3 mi
Selling alcohol
4 within 1 mi · 69 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.27 mi
Setting
suburban (1,018 people per sq mi)
People within 3 mi
28,786 (21,374 adults 21+, 11,656 households) from 8 tract(s), tracts within 3 mi
Income
per capita $34,039 · median household ~$75,124 (weighted mean of tract medians)
Age and education
median age ~40.2 · bachelor's or higher 24%
Ethnicity
Hispanic 3% · White 76% · Black 13% · Asian 1%
Adults per alcohol outlet
305
Alcohol spend within 3 mi
$6,951,453 a year ($3,267,907 at home, $3,679,685 away) · $99,306 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-000484198 ↔ snap snap|us|842494same address and namemerged17
2026-11-19 20:37insertmi-lcc L-000218720 ↔ snap snap|us|842494same address and namemerged17
2026-11-18 18:58insertmi-lcc L-000218720 ↔ vtinfo f838ff77a84a7553Claude judge: samemerged15
2026-11-18 18:58insertab-inbev 3360944 ↔ mi-lcc L-000484198Claude judge: samemerged15
2026-11-18 18:58insertmi-lcc L-000484198 ↔ vtinfo f838ff77a84a7553Claude judge: samemerged15
2026-11-18 18:58insertab-inbev 3360944 ↔ mi-lcc L-000218720Claude judge: samemerged15
2026-11-14 20:23insertab-inbev 3360944 ↔ vtinfo f838ff77a84a7553same address and namemerged15
2026-11-03 13:33backfillmi-lcc L-000218720 ↔ mi-lcc L-000484198one store listed twicemerged