Outlets /
Los Tres Hermanos Restaurant
San Fernando, CA 91340 · O4d4da541df1b · first seen 2026-10-08
3 sourceson premise · restaurantalcohol: licensed1 licence
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 | Los Tres Hermanos Restaurant 2 other | the most common name a source states | LOS HERMANOS MEXICAN FOODS INC ca-abc (legal name) los tres hermanos san fernando doordash |
| Street | 1047-49 SAN FERNANDO RD 1 other | ca-abc | 1049 San Fernando Rd doordashoverture ×2 |
| City | SAN FERNANDO | ca-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 91340 | ca-abc | no other value |
| Pin | 34.28299, -118.44147 map | doordash | no other value |
| Phone | 8188374600 | overture | no other value |
| Licences | ca-abc 00521623|47|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Ode6b5a81fc34; Ocfc281851349
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 | LOS TRES HERMANOS RESTAURANT legal name: LOS HERMANOS MEXICAN FOODS INC 00521623|47|LIC|0 | 1047-49 SAN FERNANDO RD, SAN FERNANDO, CA, 91340 | 34.28260, -118.44122 | 2026-10-08 | 2026-11-13 | |
| doordash | los tres hermanos san fernando 253408 | 1049 San Fernando Rd, San Fernando, CA, 91340 | 34.28299, -118.44147 | 2026-10-08 | 2026-11-13 | |
| overture | Los Tres Hermanos Restaurant 59bd695d-ec30-4be5-bf31-cf6ab4fdf717 | 1049 San Fernando Rd, San Fernando, CA, 91340 | 8188374600 | 34.28301, -118.44154 | 2026-11-13 | 2026-11-13 |
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 LOS TRES HERMANOS RESTAURANT | doordash los tres hermanos san fernando | 0.75 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (90% confident; asked as a “near” pair) The DoorDash slug 'los tres hermanos' plus its city matches the licensed restaurant's name, and 1049 San Fernando Rd falls within the licence's 1047-49 address range in the same ZIP, with only one bus Other Claude answers on this pair:
pair 8b752ecfb71858d84356 |
| doordash los tres hermanos san fernando | overture Los Tres Hermanos Restaurant | 0.75 | same address and name | merged | address similarity 1.00 · names match with these kind-of-place words set aside: restaurant · name Jaro-Winkler 0.90 · same street + ZIP · pins 8 m apart · name similarity 0.75 |
Attributes
- Channel
- on_premise · restaurant — ca-licence
- Chain
- none
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- LOS HERMANOS MEXICAN FOODS INC — 1 outlets in the master under this operator
- Licence privileges
- beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47
Rule version 7, computed 2026-11-16 17:17.
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
- 144 within 1 mi · 568 within 3 mi
- Off / on premise
- 28 / 83 within 1 mi · 164 / 323 within 3 mi
- Selling alcohol
- 84 within 1 mi · 295 within 3 mi
- Nearest
- same channel 0.04 mi · licensed 0.04 mi
- Setting
- urban (7,852 people per sq mi)
- People within 3 mi
- 222,006 (162,324 adults 21+, 58,157 households) from 58 tract(s), tracts within 3 mi
- Income
- per capita $29,786 · median household ~$89,912 (weighted mean of tract medians)
- Age and education
- median age ~36.9 · bachelor's or higher 16%
- Ethnicity
- Hispanic 81% · White 16% · Black 3% · Asian 6%
- Adults per alcohol outlet
- 548
- Alcohol spend within 3 mi
- $41,757,682 a year ($18,922,025 at home, $22,816,982 away) · $141,073 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-13 14:10 | insert | doordash 253408 ↔ overture 59bd695d-ec30-4be5-bf31-cf6ab4fdf717 | same address and name | merged | 15 |
| 2026-11-02 23:02 | backfill | ca-abc 00521623|47|LIC|0 ↔ doordash 253408 | Claude judge: same | merged |