BP Gas Station

Troy, MI 48098 · O1ee59fe68be5 · first seen 2026-11-03
3 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
BP Gas Station 2 other
a licence name in capitals, cleaned (derived; record_title.py)
MARATHON/ LIV&SQ LAKE ab-inbevvtinfo ×2
SQUARE LAKE-LIVERNOIS BUSINESS, INC. mi-lcc (legal name) ×2
Street
5977 Livernois Rd
mi-lccno other value
City
Troy
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48098
mi-lccno other value
Pin
42.60618, -83.14980 map
mi-lccno other value
Phone
2488288125
vtinfono other value
Licences
mi-lcc L-000188811 · mi-lcc L-000502903
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of626f6e80639; O46ed072e9e9f; O85e3e529d6ee

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-inbevMARATHON/ LIV&SQ LAKE
4042529
5977 LIVERNOIS RD, TROY, MI, 4809842.60579, -83.149822026-11-112026-11-12
mi-lccBP GAS STATION
legal name: SQUARE LAKE-LIVERNOIS BUSINESS, INC.
L-000188811
5977 Livernois Rd, Troy, MI, 48098248828812542.60618, -83.149802026-11-032026-11-18
mi-lccBP GAS STATION
legal name: SQUARE LAKE-LIVERNOIS BUSINESS, INC.
L-000502903
5977 Livernois Rd, Troy, MI, 48098248828812542.60618, -83.149802026-11-032026-11-18
vtinfoMARATHON/ LIV&SQ LAKE
3c80f54425ef3394
5977 LIVERNOIS RD, TROY, MI, 48098248828812542.60615, -83.150142026-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
ab-inbev MARATHON/ LIV&SQ LAKEvtinfo MARATHON/ LIV&SQ LAKE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 47 m apart · name similarity 1.00
mi-lcc BP GAS STATIONmi-lcc BP GAS STATION1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc BP GAS STATIONvtinfo MARATHON/ LIV&SQ LAKE0.33Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “same-address” pair)
Same phone and address; gas station rebrand
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records sit at 5977 Livernois Rd, Troy, MI 48098 with an identical phone number and coordinates about 27 m apart, and the vtinfo name 'LIV&SQ LAKE' echoes the licence's legal name 'SQUARE LAKE-LIVERNOIS BUSINESS', so the BP vs Marathon name difference most likely reflects a brand change at one gas station.
pair 392c2d9a5818959240c5
mi-lcc BP GAS STATIONvtinfo MARATHON/ LIV&SQ LAKE0.33Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “same-address” pair)
Same phone and address; gas station brand naming differs
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records sit at 5977 Livernois Rd, Troy, 27 m apart, with the identical phone number, and the only other business counted at that address is this same station. The brand names differ (BP on the Michigan licence, Marathon on the VIP listing), which is plausible for a gas station that changed brand, so the shared address and phone point to one outlet.
pair 2cd98f57a3be6ebfe17d

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
SQUARE LAKE-LIVERNOIS BUSINESS, INC. — 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:32.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
20 within 1 mi · 261 within 3 mi
Off / on premise
6 / 9 within 1 mi · 57 / 155 within 3 mi
Selling alcohol
12 within 1 mi · 113 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.03 mi
Setting
suburban (2,598 people per sq mi)
People within 3 mi
73,446 (54,916 adults 21+, 26,592 households) from 17 tract(s), tracts within 3 mi
Income
per capita $62,012 · median household ~$142,387 (weighted mean of tract medians)
Age and education
median age ~44.3 · bachelor's or higher 65%
Ethnicity
Hispanic 2% · White 65% · Black 3% · Asian 25%
Adults per alcohol outlet
482
Alcohol spend within 3 mi
$25,812,658 a year ($11,119,198 at home, $14,683,936 away) · $226,427 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-18 18:58insertmi-lcc L-000188811 ↔ vtinfo 3c80f54425ef3394Claude judge: samemerged15
2026-11-18 18:58insertmi-lcc L-000502903 ↔ vtinfo 3c80f54425ef3394Claude judge: samemerged15
2026-11-12 14:25insertab-inbev 4042529 ↔ vtinfo 3c80f54425ef3394same address and namemerged12
2026-11-03 13:33backfillmi-lcc L-000188811 ↔ mi-lcc L-000502903one store listed twicemerged