HP Flint

Flint, MI 48507 · O244552b0d462 · first seen 2026-11-03
3 sourceson 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
HP Flint 2 other
a licence name in capitals, cleaned (derived; record_title.py)
HP FLINT LLC mi-lcc ×2
HYATT PLACE ab-inbevvtinfo ×2
Street
5481 Hill 23 Dr
mi-lccno other value
City
Flint
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48507
mi-lccno other value
Pin
42.94464, -83.72689 map 2 other
mi-lcc
186 m away ab-inbev
76 m away vtinfo
Phone
8104249000 1 other
vtinfo
2486265050 mi-lcc ×2
Licences
mi-lcc L-000466641 · mi-lcc L-000466642
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe3fc058e3268; Of73e68770e0f; O6447cbbafb7c

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-inbevHYATT PLACE
4309275
5481 HILL 23 DR, FLINT, MI, 4850742.94618, -83.726012026-11-122026-11-18
mi-lccHP FLINT LLC
L-000466641
5481 Hill 23 Dr, Flint, MI, 48507248626505042.94464, -83.726892026-11-032026-11-04
mi-lccHP FLINT LLC
L-000466642
5481 Hill 23 Dr, Flint, MI, 48507248626505042.94464, -83.726892026-11-032026-11-04
vtinfoHYATT PLACE
45500820b60c4a45
5481 HILL 23 DR, FLINT, MI, 48507810424900042.94526, -83.726502026-11-142026-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 HYATT PLACEvtinfo HYATT PLACE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 110 m apart · name similarity 1.00
mi-lcc HP FLINT LLCmi-lcc HP FLINT LLC1.00one store listed twicemergedsame street + ZIP · name: identical
ab-inbev HYATT PLACEmi-lcc HP FLINT LLC0.16Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (75% confident; asked as a “same-address” pair)
HP Flint LLC likely Hyatt Place entity at same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records sit at the same street address (0.19 km apart), and HP FLINT LLC is plausibly the legal entity operating the Hyatt Place hotel, so the mi-lcc licence and the AB InBev account likely describe one hotel bar or restaurant, though the shared building leaves some doubt.
pair ba4c74ee0dde07ee0052
mi-lcc HP FLINT LLCvtinfo HYATT PLACE0.16Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (75% confident; asked as a “same-address” pair)
HP Flint LLC operates Hyatt Place at address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 78% confident — HP FLINT LLC is plausibly the legal entity behind the Hyatt Place hotel at the identical street address and ZIP, with the coordinates about 76 m apart, so the names agree; the differing phone numbers weaken this somewhat, but a hotel's licence contact and main line often differ.
pair 5a594d77128b92480e59
mi-lcc HP FLINT LLCvtinfo HYATT PLACE0.16Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “same-address” pair)
HP Flint LLC is Hyatt Place entity, same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 70% confident — HP FLINT LLC at 5481 Hill 23 Dr is very likely the legal entity behind the Hyatt Place hotel at the same address (HP reads as Hyatt Place), with coordinates 76 m apart; the differing phone numbers and the second business at the address lower confidence somewhat.
pair f9bc4f023bafe078ece3

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
HP FLINT LLC — 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/B-Hotel
Rule version 11, computed 2026-11-19 21:40.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
30 within 1 mi · 150 within 3 mi
Off / on premise
5 / 17 within 1 mi · 43 / 68 within 3 mi
Selling alcohol
17 within 1 mi · 84 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.03 mi
Setting
suburban (861 people per sq mi)
People within 3 mi
24,332 (19,027 adults 21+, 10,417 households) from 6 tract(s), tracts within 3 mi
Income
per capita $33,929 · median household ~$61,819 (weighted mean of tract medians)
Age and education
median age ~43.7 · bachelor's or higher 16%
Ethnicity
Hispanic 5% · White 77% · Black 13% · Asian 1%
Adults per alcohol outlet
224
Alcohol spend within 3 mi
$5,451,364 a year ($2,624,007 at home, $2,825,197 away) · $64,134 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-000466642 ↔ vtinfo 45500820b60c4a45Claude judge: samemerged15
2026-11-18 18:58insertab-inbev 4309275 ↔ mi-lcc L-000466641Claude judge: samemerged15
2026-11-18 18:58insertmi-lcc L-000466641 ↔ vtinfo 45500820b60c4a45Claude judge: samemerged15
2026-11-14 20:23insertab-inbev 4309275 ↔ vtinfo 45500820b60c4a45same address and namemerged15
2026-11-03 13:33backfillmi-lcc L-000466641 ↔ mi-lcc L-000466642one store listed twicemerged