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.

FieldMaster valueTaken fromWhat 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-abcno other value
State
CA
ca-abcno other value
ZIP
91340
ca-abcno other value
Pin
34.28299, -118.44147 map
doordashno other value
Phone
8188374600
overtureno 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.

SourceNameAddressPhoneCoordinatesFirst seenUpdated
ca-abcLOS TRES HERMANOS RESTAURANT
legal name: LOS HERMANOS MEXICAN FOODS INC
00521623|47|LIC|0
1047-49 SAN FERNANDO RD, SAN FERNANDO, CA, 9134034.28260, -118.441222026-10-082026-11-13
doordashlos tres hermanos san fernando
253408
1049 San Fernando Rd, San Fernando, CA, 9134034.28299, -118.441472026-10-082026-11-13
overtureLos Tres Hermanos Restaurant
59bd695d-ec30-4be5-bf31-cf6ab4fdf717
1049 San Fernando Rd, San Fernando, CA, 91340818837460034.28301, -118.441542026-11-132026-11-13

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 LOS TRES HERMANOS RESTAURANTdoordash los tres hermanos san fernando0.75Claude judge: samemerged
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:
  • Claude Haiku 5.5, prompt v7: same, 85% confident — Both records name Los Tres Hermanos at 1049 San Fernando Rd in San Fernando, CA 91340, with the only business at that address and coordinates about 49 m apart; the CA licence is an active on-sale restaurant, and a DoorDash listing of that restaurant is one storefront, so this is one operation.
  • Claude Opus 5.5, prompt v3: same, 70% confident — The DoorDash slug 'los tres hermanos san fernando' matches the licensed restaurant name and its city, San Fernando, and this appears to be an independent restaurant rather than a multi-location chain, though the DoorDash record has no street address.
pair 8b752ecfb71858d84356
doordash los tres hermanos san fernandooverture Los Tres Hermanos Restaurant0.75same address and namemergedaddress 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”).
WhenEventPairRuleDecisionRule version
2026-11-13 14:10insertdoordash 253408 ↔ overture 59bd695d-ec30-4be5-bf31-cf6ab4fdf717same address and namemerged15
2026-11-02 23:02backfillca-abc 00521623|47|LIC|0 ↔ doordash 253408Claude judge: samemerged