Outlets /
TRES MUCHACHOS
COSTA MESA, CA 92627 · O3c5873db1e8e · first seen 2026-10-08
4 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 | TRES MUCHACHOS 3 other | the most common name a source states | WINEHILL SHOPNDRINK LLC ca-abc (legal name) ×2 TRES MUCHACHOS FISH N CHIPS vtinfo Tres Muchachos FishNChips ubereats |
| Street | 333 E 17TH ST 2 other | ca-abc | 333 E 17th St #14 overture 333 E 17TH ST STE 14 vtinfo |
| City | COSTA MESA | ca-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 92627 | ca-abc | no other value |
| Pin | 33.63213, -117.91428 map 1 other | ubereats | 60 m away overture |
| Phone | 9492207811 | vtinfo | no other value |
| Licences | ca-abc 00614479|41|APP|0 · ca-abc 00614479|41|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Offc581b74bc6; O958276c45f7e; O9e0442272d92; O5db8fd5d7b22
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 |
|---|---|---|---|---|---|---|
| ca-abc | TRES MUCHACHOS legal name: WINEHILL SHOPNDRINK LLC 00614479|41|APP|0 | 333 E 17TH ST, COSTA MESA, CA, 92627 | 33.63228, -117.91433 | 2026-10-08 | 2026-11-16 | |
| ca-abc | TRES MUCHACHOS legal name: WINEHILL SHOPNDRINK LLC 00614479|41|LIC|0 | 333 E 17TH ST, COSTA MESA, CA, 92627 | 33.63228, -117.91433 | 2026-10-08 | 2026-11-16 | |
| overture | Tres Muchachos b84172a3-d021-4133-877a-3c920d64932a | 333 E 17th St #14, Costa Mesa, CA, 92627 | 9492207811 | 33.63198, -117.91489 | 2026-11-06 | 2026-11-16 |
| ubereats | Tres Muchachos FishNChips eiT8TFGlQKWjdSa0nmshWg | 333 E 17th St, Costa Mesa, CA, 92627 | 33.63213, -117.91428 | 2026-10-30 | 2026-11-16 | |
| vtinfo | TRES MUCHACHOS FISH N CHIPS 06c3b137edc78891 | 333 E 17TH ST STE 14, COSTA MESA, CA, 92627 | 9492207811 | 33.63195, -117.91432 | 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 |
|---|---|---|---|---|---|
| ca-abc TRES MUCHACHOS | ca-abc TRES MUCHACHOS | 1.00 | one licence file | merged | file: 00614479 · same_address |
| ca-abc TRES MUCHACHOS | overture Tres Muchachos | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 62 m apart · name similarity 1.00 |
| ca-abc TRES MUCHACHOS | overture Tres Muchachos | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 62 m apart · name similarity 1.00 |
| ca-abc TRES MUCHACHOS | ubereats Tres Muchachos FishNChips | 0.69 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (80% confident; asked as a “near” pair) Both records carry the distinctive name 'Tres Muchachos' at the same street address and ZIP. The CA record is a restaurant licence and the Uber Eats 'Tres Muchachos FishNChips' listing is a restaurant Other Claude answers on this pair:
pair f507bc0c54474c377215 |
| ca-abc TRES MUCHACHOS | ubereats Tres Muchachos FishNChips | 0.69 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (80% confident; asked as a “near” pair) The distinctive name 'Tres Muchachos' matches the restaurant licence at the same street address, so the Uber Eats 'Tres Muchachos FishNChips' listing is the same restaurant even though seven businesse Other Claude answers on this pair:
pair 91ec3600cb3ef217dd61 |
| ubereats Tres Muchachos FishNChips | vtinfo TRES MUCHACHOS FISH N CHIPS | 0.55 | one name contains the other, same address | merged | judge: None · pair_id: 546d6d0f9bcc41635797 · person: None · rule: names contained at one address · stratum: near |
| ca-abc TRES MUCHACHOS | vtinfo TRES MUCHACHOS FISH N CHIPS | 0.54 | one name contains the other, same address | merged | judge: None · pair_id: 09bdbd965cf5a757b416 · person: None · rule: names contained at one address · stratum: near |
| ca-abc TRES MUCHACHOS | vtinfo TRES MUCHACHOS FISH N CHIPS | 0.54 | one name contains the other, same address | merged | judge: None · pair_id: 739d57b9e421bb7781c8 · 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
- WINEHILL SHOPNDRINK LLC — 1 outlets in the master under this operator
- Licence privileges
- beer_on, beer_off, wine_on, wine_off — CA 41
Rule version 7, computed 2026-11-16 17:16.
Every vote behind these (raw)
{
"ue_location": [
"DEFAULT"
],
"votes": [
[
"ca-licence",
"on_premise",
"restaurant"
],
[
"ubereats-type",
"on_premise",
"restaurant"
],
[
"overture-category",
"on_premise",
"restaurant"
]
]
}Trade area
- Other outlets
- 300 within 1 mi · 991 within 3 mi
- Off / on premise
- 55 / 202 within 1 mi · 192 / 595 within 3 mi
- Selling alcohol
- 166 within 1 mi · 653 within 3 mi
- Nearest
- same channel 0.01 mi · licensed 0.01 mi
- Setting
- urban (4,859 people per sq mi)
- People within 3 mi
- 137,383 (110,288 adults 21+, 57,091 households) from 32 tract(s), tracts within 3 mi
- Income
- per capita $79,874 · median household ~$132,076 (weighted mean of tract medians)
- Age and education
- median age ~41.0 · bachelor's or higher 54%
- Ethnicity
- Hispanic 28% · White 63% · Black 1% · Asian 5%
- Adults per alcohol outlet
- 169
- Alcohol spend within 3 mi
- $53,039,266 a year ($22,822,439 at home, $30,199,877 away) · $81,100 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-16 14:56 | insert | ca-abc 00614479|41|LIC|0 ↔ vtinfo 06c3b137edc78891 | one name contains the other, same address | merged | 15 |
| 2026-11-16 14:56 | insert | ca-abc 00614479|41|APP|0 ↔ vtinfo 06c3b137edc78891 | one name contains the other, same address | merged | 15 |
| 2026-11-16 14:56 | insert | ubereats eiT8TFGlQKWjdSa0nmshWg ↔ vtinfo 06c3b137edc78891 | one name contains the other, same address | merged | 15 |
| 2026-11-06 18:13 | insert | ca-abc 00614479|41|LIC|0 ↔ overture b84172a3-d021-4133-877a-3c920d64932a | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | ca-abc 00614479|41|APP|0 ↔ overture b84172a3-d021-4133-877a-3c920d64932a | same address and name | merged | 11 |
| 2026-11-02 23:02 | backfill | ca-abc 00614479|41|APP|0 ↔ ubereats eiT8TFGlQKWjdSa0nmshWg | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00614479|41|LIC|0 ↔ ubereats eiT8TFGlQKWjdSa0nmshWg | Claude judge: same | merged | |
| 2026-10-09 13:59 | backfill | ca-abc 00614479|41|APP|0 ↔ ca-abc 00614479|41|LIC|0 | one licence file | merged |