Blue Nile

Ferndale, MI 48220 · O1fadd79c01d7 · first seen 2026-10-08
5 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
Blue Nile 3 other
a source's own spelling of the licence name (record_title.py)
FESELE ENTERPRISES, INC. mi-lcc (legal name) ×2
The Blue Nile ubereats
the blue nile ethiopian restaurant ferndale doordash
Street
545 W 9 Mile Rd 2 other
mi-lcc
545 W Nine Mile Rd overture
545 West Nine Mile Road doordash
City
Ferndale
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48220
mi-lccno other value
Pin
42.46024, -83.14186 map
ubereatsno other value
Phone
2485476699
overtureno other value
Licences
mi-lcc L-000117738 · mi-lcc L-000124973
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O515e19c3de14; Oc12fbc528579; O2529c247981c; Oc5a483c5fc09; O46cca033d899

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
doordashthe blue nile ethiopian restaurant ferndale
551233
545 West Nine Mile Road, Ferndale, MI, 4822042.46015, -83.141892026-10-082026-10-20
inspectionsBLUE NILE
inspections|mi|SFE-4063-037468
545 W 9 MILE RD, Ferndale, MI, 4822042.46035, -83.141432026-11-202026-11-20
mi-lccBLUE NILE
legal name: FESELE ENTERPRISES, INC.
L-000117738
545 W 9 Mile Rd, Ferndale, MI, 48220248547669942.46039, -83.141342026-11-032026-11-05
mi-lccBLUE NILE
legal name: FESELE ENTERPRISES, INC.
L-000124973
545 W 9 Mile Rd, Ferndale, MI, 48220248547669942.46039, -83.141342026-11-032026-11-05
overtureBlue Nile
1a02faeb-03b9-4e9a-99c3-0e57cba9b054
545 W Nine Mile Rd, Ferndale, MI, 48220248547669942.46033, -83.141992026-11-182026-11-18
ubereatsThe Blue Nile
YE4aCxBtX-2-Cs96X0etPw
545 W 9 Mile Rd, Ferndale, MI, 4822042.46024, -83.141862026-10-142026-11-02

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
inspections BLUE NILEmi-lcc BLUE NILE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00
inspections BLUE NILEmi-lcc BLUE NILE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00
inspections BLUE NILEoverture Blue Nile1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 46 m apart · name similarity 1.00 · street similarity 0.80
inspections BLUE NILEubereats The Blue Nile1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 38 m apart · name similarity 1.00
mi-lcc BLUE NILEmi-lcc BLUE NILE1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc BLUE NILEoverture Blue Nile1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 54 m apart · name similarity 1.00 · street similarity 0.80
mi-lcc BLUE NILEubereats The Blue Nile1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
mi-lcc BLUE NILEoverture Blue Nile1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 54 m apart · name similarity 1.00 · street similarity 0.80
mi-lcc BLUE NILEubereats The Blue Nile1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
overture Blue Nileubereats The Blue Nile1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 15 m apart · name similarity 1.00 · street similarity 0.80
doordash the blue nile ethiopian restaurant ferndalemi-lcc BLUE NILE0.48Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (95% confident; asked as a “near” pair)
Blue Nile same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records give the same Ferndale, MI address (545 W Nine Mile Rd, ZIP 48220) with coordinates about 52 m apart, and the DoorDash listing 'the blue nile ethiopian restaurant' matches the Michigan licence trade name 'BLUE NILE' at that single business address.
pair 2ff74954adf9ca546982
doordash the blue nile ethiopian restaurant ferndaleubereats The Blue Nile0.48Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
Both records name The Blue Nile at the same address, 545 W 9 Mile Rd, Ferndale 48220 (10 m apart), and the address holds only one business; the DoorDash slug simply adds the descriptor and the city.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 93% confident — Both records are The Blue Nile at 545 W 9 Mile Rd in Ferndale, MI (ZIP 48220), with coordinates about 10 m apart and no other business at that address in the data, so it is one restaurant listed on two delivery apps.
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records give the same address in Ferndale, MI (545 W 9 Mile Rd, ZIP 48220) with coordinates about 0.01 km apart, only one business is at that address, and the names match as The Blue Nile restaurant.
pair 8f89b5f4928e28367c10

Attributes

Channel
on_premise · restaurant — ubereats-type
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
FESELE ENTERPRISES, INC. — 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 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
 "ue_location": [
  "PHYSICAL"
 ],
 "votes": [
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
189 within 1 mi · 703 within 3 mi
Off / on premise
33 / 102 within 1 mi · 170 / 377 within 3 mi
Selling alcohol
97 within 1 mi · 370 within 3 mi
Nearest
same channel 0.04 mi · licensed 0.04 mi
Setting
urban (5,658 people per sq mi)
People within 3 mi
159,977 (127,168 adults 21+, 71,733 households) from 52 tract(s), tracts within 3 mi
Income
per capita $47,980 · median household ~$84,679 (weighted mean of tract medians)
Age and education
median age ~38.9 · bachelor's or higher 44%
Ethnicity
Hispanic 3% · White 49% · Black 41% · Asian 2%
Adults per alcohol outlet
343
Alcohol spend within 3 mi
$47,276,286 a year ($21,699,248 at home, $25,556,067 away) · $127,429 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-20 22:08insertinspections inspections|mi|SFE-4063-037468 ↔ overture 1a02faeb-03b9-4e9a-99c3-0e57cba9b054street written two waysmerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-4063-037468 ↔ mi-lcc L-000117738same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-4063-037468 ↔ mi-lcc L-000124973same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-4063-037468 ↔ ubereats YE4aCxBtX-2-Cs96X0etPwsame address and namemerged17
2026-11-18 18:58insertmi-lcc L-000117738 ↔ overture 1a02faeb-03b9-4e9a-99c3-0e57cba9b054street written two waysmerged15
2026-11-18 18:58insertmi-lcc L-000124973 ↔ overture 1a02faeb-03b9-4e9a-99c3-0e57cba9b054street written two waysmerged15
2026-11-18 18:58insertoverture 1a02faeb-03b9-4e9a-99c3-0e57cba9b054 ↔ ubereats YE4aCxBtX-2-Cs96X0etPwstreet written two waysmerged15
2026-11-12 17:29insertdoordash 551233 ↔ mi-lcc L-000117738Claude judge: samemerged14
2026-11-03 13:33backfillmi-lcc L-000124973 ↔ ubereats YE4aCxBtX-2-Cs96X0etPwsame address and namemerged
2026-11-03 13:33backfillmi-lcc L-000117738 ↔ ubereats YE4aCxBtX-2-Cs96X0etPwsame address and namemerged
2026-11-03 13:33backfillmi-lcc L-000117738 ↔ mi-lcc L-000124973one store listed twicemerged
2026-11-02 23:02backfilldoordash 551233 ↔ ubereats YE4aCxBtX-2-Cs96X0etPwClaude judge: samemerged