Outlets /
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.
| Field | Master value | Taken from | What 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-lcc | no other value |
| State | MI | mi-lcc | no other value |
| ZIP | 48220 | mi-lcc | no other value |
| Pin | 42.46024, -83.14186 map | ubereats | no other value |
| Phone | 2485476699 | overture | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| doordash | the blue nile ethiopian restaurant ferndale 551233 | 545 West Nine Mile Road, Ferndale, MI, 48220 | 42.46015, -83.14189 | 2026-10-08 | 2026-10-20 | |
| inspections | BLUE NILE inspections|mi|SFE-4063-037468 | 545 W 9 MILE RD, Ferndale, MI, 48220 | 42.46035, -83.14143 | 2026-11-20 | 2026-11-20 | |
| mi-lcc | BLUE NILE legal name: FESELE ENTERPRISES, INC. L-000117738 | 545 W 9 Mile Rd, Ferndale, MI, 48220 | 2485476699 | 42.46039, -83.14134 | 2026-11-03 | 2026-11-05 |
| mi-lcc | BLUE NILE legal name: FESELE ENTERPRISES, INC. L-000124973 | 545 W 9 Mile Rd, Ferndale, MI, 48220 | 2485476699 | 42.46039, -83.14134 | 2026-11-03 | 2026-11-05 |
| overture | Blue Nile 1a02faeb-03b9-4e9a-99c3-0e57cba9b054 | 545 W Nine Mile Rd, Ferndale, MI, 48220 | 2485476699 | 42.46033, -83.14199 | 2026-11-18 | 2026-11-18 |
| ubereats | The Blue Nile YE4aCxBtX-2-Cs96X0etPw | 545 W 9 Mile Rd, Ferndale, MI, 48220 | 42.46024, -83.14186 | 2026-10-14 | 2026-11-02 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| inspections BLUE NILE | mi-lcc BLUE NILE | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00 |
| inspections BLUE NILE | mi-lcc BLUE NILE | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00 |
| inspections BLUE NILE | overture Blue Nile | 1.00 | street written two ways | merged | name Jaro-Winkler 1.00 · matched on zip · pins 46 m apart · name similarity 1.00 · street similarity 0.80 |
| inspections BLUE NILE | ubereats The Blue Nile | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 38 m apart · name similarity 1.00 |
| mi-lcc BLUE NILE | mi-lcc BLUE NILE | 1.00 | one store listed twice | merged | same street + ZIP · name: identical |
| mi-lcc BLUE NILE | overture Blue Nile | 1.00 | street written two ways | merged | name Jaro-Winkler 1.00 · matched on zip · pins 54 m apart · name similarity 1.00 · street similarity 0.80 |
| mi-lcc BLUE NILE | ubereats The Blue Nile | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 |
| mi-lcc BLUE NILE | overture Blue Nile | 1.00 | street written two ways | merged | name Jaro-Winkler 1.00 · matched on zip · pins 54 m apart · name similarity 1.00 · street similarity 0.80 |
| mi-lcc BLUE NILE | ubereats The Blue Nile | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 |
| overture Blue Nile | ubereats The Blue Nile | 1.00 | street written two ways | merged | name 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 ferndale | mi-lcc BLUE NILE | 0.48 | Claude judge: same | merged | 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:
pair 2ff74954adf9ca546982 |
| doordash the blue nile ethiopian restaurant ferndale | ubereats The Blue Nile | 0.48 | Claude judge: same | merged | 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:
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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-20 22:08 | insert | inspections inspections|mi|SFE-4063-037468 ↔ overture 1a02faeb-03b9-4e9a-99c3-0e57cba9b054 | street written two ways | merged | 17 |
| 2026-11-20 22:08 | insert | inspections inspections|mi|SFE-4063-037468 ↔ mi-lcc L-000117738 | same address and name | merged | 17 |
| 2026-11-20 22:08 | insert | inspections inspections|mi|SFE-4063-037468 ↔ mi-lcc L-000124973 | same address and name | merged | 17 |
| 2026-11-20 22:08 | insert | inspections inspections|mi|SFE-4063-037468 ↔ ubereats YE4aCxBtX-2-Cs96X0etPw | same address and name | merged | 17 |
| 2026-11-18 18:58 | insert | mi-lcc L-000117738 ↔ overture 1a02faeb-03b9-4e9a-99c3-0e57cba9b054 | street written two ways | merged | 15 |
| 2026-11-18 18:58 | insert | mi-lcc L-000124973 ↔ overture 1a02faeb-03b9-4e9a-99c3-0e57cba9b054 | street written two ways | merged | 15 |
| 2026-11-18 18:58 | insert | overture 1a02faeb-03b9-4e9a-99c3-0e57cba9b054 ↔ ubereats YE4aCxBtX-2-Cs96X0etPw | street written two ways | merged | 15 |
| 2026-11-12 17:29 | insert | doordash 551233 ↔ mi-lcc L-000117738 | Claude judge: same | merged | 14 |
| 2026-11-03 13:33 | backfill | mi-lcc L-000124973 ↔ ubereats YE4aCxBtX-2-Cs96X0etPw | same address and name | merged | |
| 2026-11-03 13:33 | backfill | mi-lcc L-000117738 ↔ ubereats YE4aCxBtX-2-Cs96X0etPw | same address and name | merged | |
| 2026-11-03 13:33 | backfill | mi-lcc L-000117738 ↔ mi-lcc L-000124973 | one store listed twice | merged | |
| 2026-11-02 23:02 | backfill | doordash 551233 ↔ ubereats YE4aCxBtX-2-Cs96X0etPw | Claude judge: same | merged |