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.

FieldMaster valueTaken fromWhat 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-abcno other value
State
CA
ca-abcno other value
ZIP
90250
ca-abcno other value
Pin
33.90388, -118.35294 map
ubereatsno other value
Phone
3106790202
overtureno 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.

SourceNameAddressPhoneCoordinatesFirst seenUpdated
ab-inbevMI CALIFORNIA MEXICAN RES
49550
14047 HAWTHORNE BLVD, HAWTHORNE, CA, 9025033.90395, -118.352822026-11-132026-11-16
ca-abcMI CALIFORNIA RESTAURANT
00381324|47|LIC|0
14047 HAWTHORNE BLVD, HAWTHORNE, CA, 9025033.90399, -118.352802026-10-082026-11-06
ca-abcMI CALIFORNIA RESTAURANT
00381324|58|LIC|0
14047 HAWTHORNE BLVD, HAWTHORNE, CA, 9025033.90399, -118.352802026-10-082026-11-06
doordashmi california hawthorne
985968
14047 Hawthorne Boulevard, Hawthorne, CA, 9025033.90385, -118.352912026-10-082026-11-06
inspectionsMI CALIFORNIA
inspections|la|FA0305294|PR0263262
14047 HAWTHORNE BLVD, Hawthorne, CA, 9025033.90399, -118.352802026-11-192026-11-20
overtureMi California
935099e4-b516-4362-8c4a-83c5eb6905c2
14047 Hawthorne Blvd, Hawthorne, CA, 90250310679020233.90381, -118.352972026-11-062026-11-06
ubereatsMi California
0y8FTaDRXjKU106YZbWc9g
14047 Hawthorne Blvd Hawthorne, CA33.90388, -118.352942026-10-222026-10-22

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
ca-abc MI CALIFORNIA RESTAURANTca-abc MI CALIFORNIA RESTAURANT1.00one licence filemergedfile: 00381324 · same_address
doordash mi california hawthorneinspections MI CALIFORNIA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
doordash mi california hawthorneoverture Mi California1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00
inspections MI CALIFORNIAoverture Mi California1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
doordash mi california hawthorneubereats Mi California0.69Claude judge: samemerged
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:
  • Claude Haiku 5.5, prompt v9: same, 95% confident — Both records name Mi California at 14047 Hawthorne Blvd in Hawthorne, CA, with coordinates about 4 meters apart and only one business at the address, so they are the same outlet listed on two delivery platforms.
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records name Mi California at the same street address in Hawthorne, CA, with coordinates about 4 meters apart and no other business at that address in the data, so they describe one outlet listed on two delivery apps.
pair 8653a38d98bc7b727720
ca-abc MI CALIFORNIA RESTAURANTdoordash mi california hawthorne0.69Claude judge: samemerged
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:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records sit at 14047 Hawthorne Blvd in Hawthorne, CA 90250 with a 19 m distance, the only business at that address, and the names 'MI CALIFORNIA RESTAURANT' and 'mi california hawthorne' match; the CA licence is an on-sale eating-place (restaurant) licence matching a restaurant's delivery listing.
  • Claude Haiku 5.5, prompt v7: same, 80% confident — Both records sit at 14047 Hawthorne Blvd, Hawthorne, ZIP 90250, with the only business at that address and a 0.019 km distance; the DoorDash slug 'mi california hawthorne' matches the CA ABC restaurant 'MI CALIFORNIA RESTAURANT', though the ABC licence is an eating-place restaurant rather than a store, which is a minor mismatch in type.
  • Claude Haiku 5.5, prompt v4: same, 80% confident — The DoorDash slug 'mi california hawthorne' matches the ABC record's name 'MI CALIFORNIA RESTAURANT' in the same city (Hawthorne, CA), and the ABC record is a restaurant with a full bar, which fits a DoorDash listing; the DoorDash record has no street address, so this rests on a distinctive name plus city match rather than an address match.
pair 14c4668dc0b7745556e8
ca-abc MI CALIFORNIA RESTAURANTinspections MI CALIFORNIA0.69same address and namemergedaddress 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 RESTAURANToverture Mi California0.69same address and namemergedaddress 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 RESTAURANTubereats Mi California0.69Claude judge: samemerged
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:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records sit at 14047 Hawthorne Blvd in Hawthorne, CA, with a single business at that address, and the names match (MI CALIFORNIA RESTAURANT vs Mi California); the licence is an on-sale eating-place licence for the same restaurant that Uber Eats lists.
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records sit at 14047 Hawthorne Blvd, Hawthorne CA, with coordinates about 18 m apart, the only business at that address in the data, and the names match (MI CALIFORNIA RESTAURANT is the same restaurant as Uber Eats' Mi California); the CA licence is an on-sale restaurant licence, which fits a restaurant listing on a delivery app.
pair 56b57335c1376b4c9b74
ca-abc MI CALIFORNIA RESTAURANTdoordash mi california hawthorne0.69Claude judge: samemerged
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:
  • Claude Haiku 5.5, prompt v7: same, 80% confident — Both records sit at 14047 Hawthorne Blvd, Hawthorne 90250 with matching coordinates, and the only business at that address is the MI California restaurant; the DoorDash slug 'mi california hawthorne' matches the restaurant name, and the CA licence is an active on-sale eating-place licence that fits a restaurant listed for delivery.
pair e53e42b65dfe182fffd7
ca-abc MI CALIFORNIA RESTAURANTinspections MI CALIFORNIA0.69same address and namemergedaddress 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 RESTAURANToverture Mi California0.69same address and namemergedaddress 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 RESTAURANTubereats Mi California0.69Claude judge: samemerged
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:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records sit at 14047 Hawthorne Blvd, Hawthorne CA, with the name 'Mi California' matching the CA-ABC 'MI CALIFORNIA RESTAURANT' licence, the only business at that address, and the on-sale eating-place licence is the same operation's licence beside its Uber Eats listing.
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records give 14047 Hawthorne Blvd in Hawthorne, CA with nearly identical coordinates (0.018 km apart), the only business at that address is the same, and the names match (MI CALIFORNIA RESTAURANT vs Mi California), so they describe one restaurant.
pair 7ce813e21fe2a238cefa
ab-inbev MI CALIFORNIA MEXICAN RESdoordash mi california hawthorne0.59one name contains the other, same addressmergedjudge: None · pair_id: b7dedd4e7e07976b6af6 · person: None · rule: names contained at one address · stratum: near
ab-inbev MI CALIFORNIA MEXICAN RESca-abc MI CALIFORNIA RESTAURANT0.55one name contains the other, same addressmergedjudge: None · pair_id: 51042280dacd932b25da · person: None · rule: names contained at one address · stratum: near
ab-inbev MI CALIFORNIA MEXICAN RESca-abc MI CALIFORNIA RESTAURANT0.55one name contains the other, same addressmergedjudge: 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”).
WhenEventPairRuleDecisionRule version
2026-11-19 20:37insertca-abc 00381324|58|LIC|0 ↔ inspections inspections|la|FA0305294|PR0263262same address and namemerged17
2026-11-19 20:37insertca-abc 00381324|47|LIC|0 ↔ inspections inspections|la|FA0305294|PR0263262same address and namemerged17
2026-11-19 20:37insertdoordash 985968 ↔ inspections inspections|la|FA0305294|PR0263262same address and namemerged17
2026-11-19 20:37insertinspections inspections|la|FA0305294|PR0263262 ↔ overture 935099e4-b516-4362-8c4a-83c5eb6905c2same address and namemerged17
2026-11-16 14:56insertab-inbev 49550 ↔ ca-abc 00381324|58|LIC|0one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 49550 ↔ ca-abc 00381324|47|LIC|0one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 49550 ↔ doordash 985968one name contains the other, same addressmerged15
2026-11-12 17:29insertca-abc 00381324|58|LIC|0 ↔ overture 935099e4-b516-4362-8c4a-83c5eb6905c2same address and namemerged14
2026-11-12 17:29insertca-abc 00381324|47|LIC|0 ↔ overture 935099e4-b516-4362-8c4a-83c5eb6905c2same address and namemerged14
2026-11-06 18:13insertca-abc 00381324|58|LIC|0 ↔ doordash 985968Claude judge: samemerged11
2026-11-06 18:13insertca-abc 00381324|58|LIC|0 ↔ ubereats 0y8FTaDRXjKU106YZbWc9gClaude judge: samemerged11
2026-11-06 18:13insertca-abc 00381324|47|LIC|0 ↔ ubereats 0y8FTaDRXjKU106YZbWc9gClaude judge: samemerged11
2026-11-06 18:13insertca-abc 00381324|47|LIC|0 ↔ doordash 985968Claude judge: samemerged11
2026-11-06 18:13insertdoordash 985968 ↔ ubereats 0y8FTaDRXjKU106YZbWc9gClaude judge: samemerged11
2026-11-06 18:13insertdoordash 985968 ↔ overture 935099e4-b516-4362-8c4a-83c5eb6905c2same address and namemerged11
2026-10-09 13:59backfillca-abc 00381324|47|LIC|0 ↔ ca-abc 00381324|58|LIC|0one licence filemerged