BHAM SHELL, INC.

Birmingham, MI 48009 · O341ada18b267 · first seen 2026-11-03
5 sourcesoff premise · conveniencechain: Shellalcohol: 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
BHAM SHELL, INC. 1 other
the most common name a source states
SHELL ab-inbevovertureshellvtinfo ×4
Street
33588 WOODWARD AVE 1 other
shell
33588 Woodward Avenue overture
City
BIRMINGHAM
shellno other value
State
MI
shellno other value
ZIP
48009
shellno other value
Pin
42.53580, -83.20261 map 1 other
shell
53 m away mi-lcc ×2
Phone
2485942111
shellno other value
Licences
mi-lcc L-000256544 · mi-lcc L-000267268
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of79785ab374c; O703503fe65c6; O79e98213c731; Oa5e2e8570017; O56ed2c74ddb9

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-inbevSHELL
3864282
33588 WOODWARD AVE, BIRMINGHAM, MI, 4800942.53557, -83.203002026-11-112026-11-13
mi-lccBHAM SHELL, INC.
L-000256544
33588 Woodward Ave, Birmingham, MI, 48009248594211142.53586, -83.203252026-11-032026-11-13
mi-lccBHAM SHELL, INC.
L-000267268
33588 Woodward Ave, Birmingham, MI, 48009248594211142.53586, -83.203252026-11-032026-11-13
overtureShell
91c65720-3239-4ca0-ac19-21c141a11cb3
33588 Woodward Avenue, Birmingham, MI, 48009248594211142.53580, -83.202612026-11-132026-11-13
shellShell
10087094
33588 WOODWARD AVE, BIRMINGHAM, MI, 48009248594211142.53580, -83.202612026-11-102026-11-13
vtinfoSHELL
9fb3264588b3da7f
33588 WOODWARD AVE, BIRMINGHAM, MI, 48009248594211142.53578, -83.202622026-11-122026-11-13

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 SHELLoverture Shell1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 41 m apart · name similarity 1.00
ab-inbev SHELLshell Shell1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 41 m apart · name similarity 1.00
ab-inbev SHELLvtinfo SHELL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 39 m apart · name similarity 1.00
mi-lcc BHAM SHELL, INC.mi-lcc BHAM SHELL, INC.1.00one store listed twicemergedsame street + ZIP · name: identical
overture Shellshell Shell1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 1 m apart · name similarity 1.00 · phone: equal
overture Shellvtinfo SHELL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 2 m apart · name similarity 1.00 · phone: equal
shell Shellvtinfo SHELL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 2 m apart · name similarity 1.00 · phone: equal
ab-inbev SHELLmi-lcc BHAM SHELL, INC.0.58Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “near” pair)
Shell and Bham Shell Inc at same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 75% confident — Both records give the same street address and ZIP, with coordinates about 38 m apart, and the name 'BHAM SHELL, INC.' is a Birmingham-prefixed version of the Shell brand in the AB InBev record, though the building holds four other businesses, so the name match carries most of the weight.
pair 2066de74a8b3dfb137c4

Attributes

Channel
off_premise · convenience — chain-locator
Chain
Shell — chain-locator
Alcohol
licensed — a licence or TTB permit on file
Operator
BHAM SHELL, INC. — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — MI Retail - Off Premises/Specially Designated Distributor Resort; MI Retail - Off Premises/Specially Designated Merchant
Rule version 7, computed 2026-11-16 17:16.
Every vote behind these (raw)
{
 "votes": [
  [
   "chain-locator",
   "off_premise",
   "convenience"
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

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-13 14:10insertoverture 91c65720-3239-4ca0-ac19-21c141a11cb3 ↔ vtinfo 9fb3264588b3da7fsame address and namemerged15
2026-11-13 14:10insertoverture 91c65720-3239-4ca0-ac19-21c141a11cb3 ↔ shell 10087094same address and namemerged15
2026-11-13 14:10insertab-inbev 3864282 ↔ overture 91c65720-3239-4ca0-ac19-21c141a11cb3same address and namemerged15
2026-11-12 17:29insertab-inbev 3864282 ↔ mi-lcc L-000267268Claude judge: samemerged14
2026-11-12 14:25insertshell 10087094 ↔ vtinfo 9fb3264588b3da7fsame address and namemerged12
2026-11-12 14:25insertab-inbev 3864282 ↔ vtinfo 9fb3264588b3da7fsame address and namemerged12
2026-11-11 12:56insertab-inbev 3864282 ↔ shell 10087094same address and namemerged12
2026-11-03 13:33backfillmi-lcc L-000256544 ↔ mi-lcc L-000267268one store listed twicemerged