Blufin Sushi

Grosse Pointe Farms, MI 48236 · O0b21fcfec2b7 · first seen 2026-10-08
4 sourceson premise · restaurantalcohol: 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
Blufin Sushi 3 other
a source's own spelling of the licence name (record_title.py)
BLUFIN SUSHI BAR LLC mi-lcc (legal name) ×2
BLUE FINN SUSHI ab-inbev
blufin sushi grosse pointe farms doordash
Street
18584 Mack Ave 1 other
mi-lcc
18584 Mack Avenue doordash
City
Grosse Pointe Farms 1 other
mi-lcc
GROSSE POINTE ab-inbev
State
MI
mi-lccno other value
ZIP
48236
mi-lccno other value
Pin
42.41182, -82.91242 map
doordashno other value
Phone
5174014552 1 other
overture
3133320050 mi-lcc ×2
Licences
mi-lcc L-000205393 · mi-lcc L-000207545
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O80b63f316c05; O55c22b5fe3c0; O74aea87af2c2; Of33d82c5400c

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-inbevBLUE FINN SUSHI
3331118
18584 MACK AVE, GROSSE POINTE, MI, 4823642.41192, -82.912572026-11-112026-11-12
doordashblufin sushi grosse pointe farms
215529
18584 Mack Avenue, Grosse Pointe Farms, MI, 4823642.41182, -82.912422026-10-082026-11-13
mi-lccBLUFIN SUSHI
legal name: BLUFIN SUSHI BAR LLC
L-000205393
18584 Mack Ave, Grosse Pointe Farms, MI, 48236313332005042.41193, -82.912562026-11-032026-11-05
mi-lccBLUFIN SUSHI
legal name: BLUFIN SUSHI BAR LLC
L-000207545
18584 Mack Ave, Grosse Pointe Farms, MI, 48236313332005042.41193, -82.912562026-11-032026-11-05
overtureBlufin Sushi
f234ecef-ca85-4555-b3fa-732f0e24251c
18584 Mack Ave, Grosse Pointe Farms, MI, 48236517401455242.41182, -82.912462026-11-062026-11-06

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
doordash blufin sushi grosse pointe farmsmi-lcc BLUFIN SUSHI1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 17 m apart · name similarity 1.00
doordash blufin sushi grosse pointe farmsmi-lcc BLUFIN SUSHI1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 17 m apart · name similarity 1.00
doordash blufin sushi grosse pointe farmsoverture Blufin Sushi1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 3 m apart · name similarity 1.00
mi-lcc BLUFIN SUSHImi-lcc BLUFIN SUSHI1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc BLUFIN SUSHIoverture Blufin Sushi1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00 · phone: differs
mi-lcc BLUFIN SUSHIoverture Blufin Sushi1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00 · phone: differs
ab-inbev BLUE FINN SUSHImi-lcc BLUFIN SUSHI0.57Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “near” pair)
Spelling variant of sushi restaurant, same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 65% confident — Both records sit at 18584 Mack Ave (about 1 m apart) and both are sushi bars with near-identical names, 'BLUE FINN SUSHI' vs 'BLUFIN SUSHI' (legal 'BLUFIN SUSHI BAR LLC'), so the likely outlet is the same, though the spelling gap leaves some doubt in a shared building.
pair 1f735ac5dceaa07f3aa3

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
BLUFIN SUSHI BAR 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/Class C
Rule version 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
68 within 1 mi · 374 within 3 mi
Off / on premise
21 / 39 within 1 mi · 108 / 189 within 3 mi
Selling alcohol
30 within 1 mi · 222 within 3 mi
Nearest
same channel 0.05 mi · licensed 0.07 mi
Setting
urban (3,844 people per sq mi)
People within 3 mi
108,686 (76,943 adults 21+, 41,321 households) from 34 tract(s), tracts within 3 mi
Income
per capita $44,564 · median household ~$90,258 (weighted mean of tract medians)
Age and education
median age ~38.3 · bachelor's or higher 40%
Ethnicity
Hispanic 2% · White 41% · Black 52% · Asian 1%
Adults per alcohol outlet
345
Alcohol spend within 3 mi
$27,979,631 a year ($12,745,468 at home, $15,222,516 away) · $125,469 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-12 17:29insertab-inbev 3331118 ↔ mi-lcc L-000207545Claude judge: samemerged14
2026-11-12 14:25insertdoordash 215529 ↔ overture f234ecef-ca85-4555-b3fa-732f0e24251csame address and namemerged12
2026-11-12 14:25insertdoordash 215529 ↔ mi-lcc L-000205393same address and namemerged12
2026-11-12 14:25insertdoordash 215529 ↔ mi-lcc L-000207545same address and namemerged12
2026-11-06 18:13insertmi-lcc L-000205393 ↔ overture f234ecef-ca85-4555-b3fa-732f0e24251csame address and namemerged11
2026-11-06 18:13insertmi-lcc L-000207545 ↔ overture f234ecef-ca85-4555-b3fa-732f0e24251csame address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000205393 ↔ mi-lcc L-000207545one store listed twicemerged