Outlets /
CASA DE ONDA
COSTA MESA, CA 92627 · O04b5d4c4fbdc · 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 | CASA DE ONDA 2 other | the most common name a source states | AJP MEXICAN BAR LLC ca-abc (legal name) ×2 casa de onda 1870 harbor blvd costa mesa doordash |
| Street | 1870 HARBOR BLVD 1 other | ca-abc | 1870 HARBOR BLVD STE 209 ab-inbevvtinfo ×2 |
| City | COSTA MESA | ca-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 92627 | ca-abc | no other value |
| Pin | 33.64261, -117.91812 map 2 other | overture | 81 m away ca-abc ×2 74 m away ab-inbev |
| Phone | 9496122349 | vtinfo | no other value |
| Licences | ca-abc 00619141|47|LIC|0 · ca-abc 00619141|47|LIC|1 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: O85db0536ea67; Obf7da7e21797; O6757e49f26f9; O265eba73512f; Oe54e15c851d2
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 | CASA DE ONDA 4913731 | 1870 HARBOR BLVD STE 209, COSTA MESA, CA, 92627 | 33.64244, -117.91889 | 2026-11-11 | 2026-11-11 | |
| ca-abc | CASA DE ONDA legal name: AJP MEXICAN BAR LLC 00619141|47|LIC|0 | 1870 HARBOR BLVD, COSTA MESA, CA, 92627 | 33.64295, -117.91889 | 2026-10-08 | 2026-11-05 | |
| ca-abc | CASA DE ONDA legal name: AJP MEXICAN BAR LLC 00619141|47|LIC|1 | 1870 HARBOR BLVD, COSTA MESA, CA, 92627 | 33.64295, -117.91889 | 2026-10-08 | 2026-11-05 | |
| doordash | casa de onda 1870 harbor blvd costa mesa 37186645 | 1870 Harbor Blvd, Costa Mesa, CA | 2026-10-08 | 2026-11-11 | ||
| overture | Casa de Onda 4445098b-2201-4474-9583-ad60a4641a17 | 1870 Harbor Blvd, Costa Mesa, CA, 92627 | 9496122349 | 33.64261, -117.91812 | 2026-11-06 | 2026-11-06 |
| vtinfo | CASA DE ONDA 74513d2a257ac7a6 | 1870 HARBOR BLVD STE 209, COSTA MESA, CA, 92627 | 9496122349 | 33.64270, -117.91829 | 2026-11-12 | 2026-11-14 |
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 |
|---|---|---|---|---|---|
| ab-inbev CASA DE ONDA | ca-abc CASA DE ONDA | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 57 m apart · name similarity 1.00 |
| ab-inbev CASA DE ONDA | ca-abc CASA DE ONDA | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 57 m apart · name similarity 1.00 |
| ab-inbev CASA DE ONDA | overture Casa de Onda | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 74 m apart · name similarity 1.00 |
| ab-inbev CASA DE ONDA | vtinfo CASA DE ONDA | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 62 m apart · name similarity 1.00 |
| ca-abc CASA DE ONDA | ca-abc CASA DE ONDA | 1.00 | one licence file | merged | file: 00619141 · same_address |
| ca-abc CASA DE ONDA | overture Casa de Onda | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 81 m apart · name similarity 1.00 |
| ca-abc CASA DE ONDA | vtinfo CASA DE ONDA | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 62 m apart · name similarity 1.00 |
| ca-abc CASA DE ONDA | overture Casa de Onda | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 81 m apart · name similarity 1.00 |
| ca-abc CASA DE ONDA | vtinfo CASA DE ONDA | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 62 m apart · name similarity 1.00 |
| overture Casa de Onda | vtinfo CASA DE ONDA | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 19 m apart · name similarity 1.00 · phone: equal |
| ca-abc CASA DE ONDA | doordash casa de onda 1870 harbor blvd costa mesa | 0.54 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (90% confident; asked as a “near” pair) The distinctive name 'Casa de Onda' and the street address 1870 Harbor Blvd, Costa Mesa match exactly; the DoorDash slug repeats both, so the restaurant licence and the delivery listing are one operat Other Claude answers on this pair:
pair e7accff7213ae0c98e47 |
| ca-abc CASA DE ONDA | doordash casa de onda 1870 harbor blvd costa mesa | 0.54 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (90% confident; asked as a “near” pair) The distinctive name 'Casa de Onda' matches at the same street address in Costa Mesa, so this is the same restaurant despite the shared building. Other Claude answers on this pair:
pair 4d41012620cf1cdb73ab |
Attributes
- Channel
- on_premise · restaurant — ca-licence
- Chain
- none
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- AJP MEXICAN BAR LLC — 1 outlets in the master under this operator
- Licence privileges
- beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47
Rule version 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
"votes": [
[
"ca-licence",
"on_premise",
"restaurant"
],
[
"doordash-url",
"on_premise",
"restaurant"
],
[
"overture-category",
"on_premise",
"restaurant"
]
]
}Trade area
- Other outlets
- 320 within 1 mi · 1,066 within 3 mi
- Off / on premise
- 73 / 206 within 1 mi · 214 / 653 within 3 mi
- Selling alcohol
- 187 within 1 mi · 676 within 3 mi
- Nearest
- same channel 0.02 mi · licensed 0.02 mi
- Setting
- urban (5,701 people per sq mi)
- People within 3 mi
- 161,199 (128,226 adults 21+, 65,307 households) from 38 tract(s), tracts within 3 mi
- Income
- per capita $76,904 · median household ~$132,094 (weighted mean of tract medians)
- Age and education
- median age ~41.0 · bachelor's or higher 53%
- Ethnicity
- Hispanic 28% · White 62% · Black 1% · Asian 7%
- Adults per alcohol outlet
- 189
- Alcohol spend within 3 mi
- $60,740,645 a year ($26,125,772 at home, $34,595,243 away) · $89,720 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-12 14:25 | insert | ab-inbev 4913731 ↔ vtinfo 74513d2a257ac7a6 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | ca-abc 00619141|47|LIC|0 ↔ vtinfo 74513d2a257ac7a6 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | ca-abc 00619141|47|LIC|1 ↔ vtinfo 74513d2a257ac7a6 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | overture 4445098b-2201-4474-9583-ad60a4641a17 ↔ vtinfo 74513d2a257ac7a6 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ca-abc 00619141|47|LIC|0 ↔ doordash 37186645 | Claude judge: same | merged | 12 |
| 2026-11-11 12:56 | insert | ca-abc 00619141|47|LIC|1 ↔ doordash 37186645 | Claude judge: same | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 4913731 ↔ overture 4445098b-2201-4474-9583-ad60a4641a17 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 4913731 ↔ ca-abc 00619141|47|LIC|0 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 4913731 ↔ ca-abc 00619141|47|LIC|1 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | ca-abc 00619141|47|LIC|0 ↔ overture 4445098b-2201-4474-9583-ad60a4641a17 | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | ca-abc 00619141|47|LIC|1 ↔ overture 4445098b-2201-4474-9583-ad60a4641a17 | same address and name | merged | 11 |
| 2026-10-09 13:59 | backfill | ca-abc 00619141|47|LIC|0 ↔ ca-abc 00619141|47|LIC|1 | one licence file | merged |