Outlets /
Mi California Restaurant
HAWTHORNE, CA 90250 · O07d226897428 · first seen 2026-10-08
6 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 | Mi California Restaurant 3 other | a licence name in capitals, cleaned (derived; record_title.py) | MI CALIFORNIA inspectionsovertureubereats ×3 mi california hawthorne doordash MI CALIFORNIA MEXICAN RES ab-inbev |
| Street | 14047 HAWTHORNE BLVD 2 other | ca-abc | 14047 Hawthorne Blvd Hawthorne ubereats 14047 Hawthorne Boulevard doordash |
| City | HAWTHORNE | ca-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 90250 | ca-abc | no other value |
| Pin | 33.90388, -118.35294 map | ubereats | no other value |
| Phone | 3106790202 | overture | no other value |
| Licences | ca-abc 00381324|47|LIC|0 · ca-abc 00381324|58|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Odd867bc26c3a; Oef865c4d54b3; O2673145862ad; O7e6a111a4426; Oa7fc49ec8e20; Oabfcefed98c9
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 |
|---|---|---|---|---|---|---|
| ab-inbev | MI CALIFORNIA MEXICAN RES 49550 | 14047 HAWTHORNE BLVD, HAWTHORNE, CA, 90250 | 33.90395, -118.35282 | 2026-11-13 | 2026-11-16 | |
| ca-abc | MI CALIFORNIA RESTAURANT 00381324|47|LIC|0 | 14047 HAWTHORNE BLVD, HAWTHORNE, CA, 90250 | 33.90399, -118.35280 | 2026-10-08 | 2026-11-06 | |
| ca-abc | MI CALIFORNIA RESTAURANT 00381324|58|LIC|0 | 14047 HAWTHORNE BLVD, HAWTHORNE, CA, 90250 | 33.90399, -118.35280 | 2026-10-08 | 2026-11-06 | |
| doordash | mi california hawthorne 985968 | 14047 Hawthorne Boulevard, Hawthorne, CA, 90250 | 33.90385, -118.35291 | 2026-10-08 | 2026-11-06 | |
| inspections | MI CALIFORNIA inspections|la|FA0305294|PR0263262 | 14047 HAWTHORNE BLVD, Hawthorne, CA, 90250 | 33.90399, -118.35280 | 2026-11-19 | 2026-11-20 | |
| overture | Mi California 935099e4-b516-4362-8c4a-83c5eb6905c2 | 14047 Hawthorne Blvd, Hawthorne, CA, 90250 | 3106790202 | 33.90381, -118.35297 | 2026-11-06 | 2026-11-06 |
| ubereats | Mi California 0y8FTaDRXjKU106YZbWc9g | 14047 Hawthorne Blvd Hawthorne, CA | 33.90388, -118.35294 | 2026-10-22 | 2026-10-22 |
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 |
|---|---|---|---|---|---|
| ca-abc MI CALIFORNIA RESTAURANT | ca-abc MI CALIFORNIA RESTAURANT | 1.00 | one licence file | merged | file: 00381324 · same_address |
| doordash mi california hawthorne | inspections MI CALIFORNIA | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 |
| doordash mi california hawthorne | overture Mi California | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00 |
| inspections MI CALIFORNIA | overture Mi California | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 |
| doordash mi california hawthorne | ubereats Mi California | 0.69 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair) The DoorDash slug 'mi california hawthorne' is the name 'Mi California' with the city appended, both records give 14047 Hawthorne Blvd, the coordinates are 4 m apart, and only one business is recorded Other Claude answers on this pair:
pair 8653a38d98bc7b727720 |
| ca-abc MI CALIFORNIA RESTAURANT | doordash mi california hawthorne | 0.69 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair) The DoorDash slug 'mi california hawthorne' is the name 'Mi California' with the city appended, it sits at the same street address as the licensed restaurant MI CALIFORNIA RESTAURANT, and only one bus Other Claude answers on this pair:
pair 14c4668dc0b7745556e8 |
| ca-abc MI CALIFORNIA RESTAURANT | inspections MI CALIFORNIA | 0.69 | same address and name | merged | address similarity 1.00 · names match with these kind-of-place words set aside: restaurant · name Jaro-Winkler 0.91 · same street + ZIP · name similarity 0.69 |
| ca-abc MI CALIFORNIA RESTAURANT | overture Mi California | 0.69 | same address and name | merged | address similarity 1.00 · names match with these kind-of-place words set aside: restaurant · name Jaro-Winkler 0.91 · same street + ZIP · pins 25 m apart · name similarity 0.69 |
| ca-abc MI CALIFORNIA RESTAURANT | ubereats Mi California | 0.69 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair) The records share a distinctive name, 'Mi California' (Restaurant), and the same street address, 14047 Hawthorne Blvd, 18 m apart, and only one business is known at that address. Other Claude answers on this pair:
pair 56b57335c1376b4c9b74 |
| ca-abc MI CALIFORNIA RESTAURANT | doordash mi california hawthorne | 0.69 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair) The DoorDash slug 'mi california hawthorne' is the name 'Mi California' with the city appended, and it matches the licensed restaurant at the same street address and ZIP, only 19 m apart, with just on Other Claude answers on this pair:
pair e53e42b65dfe182fffd7 |
| ca-abc MI CALIFORNIA RESTAURANT | inspections MI CALIFORNIA | 0.69 | same address and name | merged | address similarity 1.00 · names match with these kind-of-place words set aside: restaurant · name Jaro-Winkler 0.91 · same street + ZIP · name similarity 0.69 |
| ca-abc MI CALIFORNIA RESTAURANT | overture Mi California | 0.69 | same address and name | merged | address similarity 1.00 · names match with these kind-of-place words set aside: restaurant · name Jaro-Winkler 0.91 · same street + ZIP · pins 25 m apart · name similarity 0.69 |
| ca-abc MI CALIFORNIA RESTAURANT | ubereats Mi California | 0.69 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair) The two records share the same distinctive name ('Mi California'), the same street address at 14047 Hawthorne Blvd, and coordinates 18 m apart, with only one business known at that address; the restau Other Claude answers on this pair:
pair 7ce813e21fe2a238cefa |
| ab-inbev MI CALIFORNIA MEXICAN RES | doordash mi california hawthorne | 0.59 | one name contains the other, same address | merged | judge: None · pair_id: b7dedd4e7e07976b6af6 · person: None · rule: names contained at one address · stratum: near |
| ab-inbev MI CALIFORNIA MEXICAN RES | ca-abc MI CALIFORNIA RESTAURANT | 0.55 | one name contains the other, same address | merged | judge: None · pair_id: 51042280dacd932b25da · person: None · rule: names contained at one address · stratum: near |
| ab-inbev MI CALIFORNIA MEXICAN RES | ca-abc MI CALIFORNIA RESTAURANT | 0.55 | one name contains the other, same address | merged | judge: None · pair_id: a1423be652d44ce4bd5e · person: None · rule: names contained at one address · stratum: near |
Attributes
- Channel
- on_premise · restaurant — ca-licence
- Chain
- none
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- none
- Licence privileges
- beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47; CA 58 (add-on: follows the base licence)
Rule version 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
"ue_location": [
"PHYSICAL"
],
"votes": [
[
"ca-licence",
"on_premise",
"restaurant"
],
[
"ubereats-type",
"on_premise",
"restaurant"
],
[
"doordash-url",
"on_premise",
"restaurant"
],
[
"overture-category",
"on_premise",
"restaurant"
]
]
}Trade area
- Other outlets
- 212 within 1 mi · 1,550 within 3 mi
- Off / on premise
- 59 / 122 within 1 mi · 343 / 911 within 3 mi
- Selling alcohol
- 87 within 1 mi · 698 within 3 mi
- Nearest
- same channel 0.04 mi · licensed 0.06 mi
- Setting
- urban (10,070 people per sq mi)
- People within 3 mi
- 284,717 (209,746 adults 21+, 97,284 households) from 68 tract(s), tracts within 3 mi
- Income
- per capita $45,245 · median household ~$102,977 (weighted mean of tract medians)
- Age and education
- median age ~37.4 · bachelor's or higher 33%
- Ethnicity
- Hispanic 48% · White 24% · Black 14% · Asian 14%
- Adults per alcohol outlet
- 300
- Alcohol spend within 3 mi
- $73,937,167 a year ($33,037,465 at home, $40,870,904 away) · $105,776 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-19 20:37 | insert | ca-abc 00381324|58|LIC|0 ↔ inspections inspections|la|FA0305294|PR0263262 | same address and name | merged | 17 |
| 2026-11-19 20:37 | insert | ca-abc 00381324|47|LIC|0 ↔ inspections inspections|la|FA0305294|PR0263262 | same address and name | merged | 17 |
| 2026-11-19 20:37 | insert | doordash 985968 ↔ inspections inspections|la|FA0305294|PR0263262 | same address and name | merged | 17 |
| 2026-11-19 20:37 | insert | inspections inspections|la|FA0305294|PR0263262 ↔ overture 935099e4-b516-4362-8c4a-83c5eb6905c2 | same address and name | merged | 17 |
| 2026-11-16 14:56 | insert | ab-inbev 49550 ↔ ca-abc 00381324|58|LIC|0 | one name contains the other, same address | merged | 15 |
| 2026-11-16 14:56 | insert | ab-inbev 49550 ↔ ca-abc 00381324|47|LIC|0 | one name contains the other, same address | merged | 15 |
| 2026-11-16 14:56 | insert | ab-inbev 49550 ↔ doordash 985968 | one name contains the other, same address | merged | 15 |
| 2026-11-12 17:29 | insert | ca-abc 00381324|58|LIC|0 ↔ overture 935099e4-b516-4362-8c4a-83c5eb6905c2 | same address and name | merged | 14 |
| 2026-11-12 17:29 | insert | ca-abc 00381324|47|LIC|0 ↔ overture 935099e4-b516-4362-8c4a-83c5eb6905c2 | same address and name | merged | 14 |
| 2026-11-06 18:13 | insert | ca-abc 00381324|58|LIC|0 ↔ doordash 985968 | Claude judge: same | merged | 11 |
| 2026-11-06 18:13 | insert | ca-abc 00381324|58|LIC|0 ↔ ubereats 0y8FTaDRXjKU106YZbWc9g | Claude judge: same | merged | 11 |
| 2026-11-06 18:13 | insert | ca-abc 00381324|47|LIC|0 ↔ ubereats 0y8FTaDRXjKU106YZbWc9g | Claude judge: same | merged | 11 |
| 2026-11-06 18:13 | insert | ca-abc 00381324|47|LIC|0 ↔ doordash 985968 | Claude judge: same | merged | 11 |
| 2026-11-06 18:13 | insert | doordash 985968 ↔ ubereats 0y8FTaDRXjKU106YZbWc9g | Claude judge: same | merged | 11 |
| 2026-11-06 18:13 | insert | doordash 985968 ↔ overture 935099e4-b516-4362-8c4a-83c5eb6905c2 | same address and name | merged | 11 |
| 2026-10-09 13:59 | backfill | ca-abc 00381324|47|LIC|0 ↔ ca-abc 00381324|58|LIC|0 | one licence file | merged |