Mario's Restr

HUNTINGTON BEACH, CA 92648 · O04da6e4c5ed9 · first seen 2026-10-08
5 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
Mario's Restr 3 other
a licence name in capitals, cleaned (derived; record_title.py)
MARIO'S MEXICAN FOOD & CANTINA ca-abcovertureubereats ×3
MARIOS RESTR ab-inbevvtinfo ×2
MARIOS FOODS INC ca-abc (legal name)
Street
18603 MAIN ST
ca-abcno other value
City
HUNTINGTON BEACH
ca-abcno other value
State
CA
ca-abcno other value
ZIP
92648
ca-abcno other value
Pin
33.69313, -117.99266 map 3 other
ubereats
158 m away ab-inbev
177 m away ca-abc
143 m away vtinfo
Phone
7148425811
vtinfono other value
Licences
ca-abc 00271564|47|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O87108e036ed3; Od93588e429ad; Ob34a2b58c897; O0ddde869b7ec

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-inbevMARIOS RESTR
45852
18603 MAIN ST, HUNTINGTON BEACH, CA, 9264833.69245, -117.991172026-11-112026-11-11
ca-abcMARIO'S MEXICAN FOOD & CANTINA
legal name: MARIOS FOODS INC
00271564|47|LIC|0
18603 MAIN ST, HUNTINGTON BEACH, CA, 9264833.69159, -117.992202026-10-082026-11-19
overtureMario's Mexican Food & Cantina
b5a07749-3e8a-4688-9aae-c92a7ebcedde
18603 Main St, Huntington Beach, CA, 92648714842581133.69319, -117.992572026-11-062026-11-19
ubereatsMario's Mexican Food & Cantina
i7amRSMSTXK0skrqEi4cUg
18603 Main St, Huntington Beach, CA, 9264833.69313, -117.992662026-10-212026-11-19
vtinfoMARIOS RESTR
54d91b77ffc0f4e5
18603 MAIN ST, HUNTINGTON BEACH, CA, 92648714842581133.69231, -117.991472026-11-122026-11-14

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
ab-inbev MARIOS RESTRvtinfo MARIOS RESTR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 32 m apart · name similarity 1.00
ca-abc MARIO'S MEXICAN FOOD & CANTINAoverture Mario's Mexican Food & Cantina1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 181 m apart · name similarity 1.00
ca-abc MARIO'S MEXICAN FOOD & CANTINAubereats Mario's Mexican Food & Cantina1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · name similarity 1.00
overture Mario's Mexican Food & Cantinaubereats Mario's Mexican Food & Cantina1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · name similarity 1.00
ca-abc MARIO'S MEXICAN FOOD & CANTINAvtinfo MARIOS RESTR0.42Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “same-address” pair)
Mario's restaurant same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records sit at 18603 Main St, Huntington Beach, ZIP 92648, the only business at that address, and the names agree closely: 'Mario's Mexican Food & Cantina' with legal entity 'Marios Foods Inc' on the CA licence matches 'MARIOS RESTR' on the VIP brand finder. The California licence is an eating-place (restaurant) licence, which fits a restaurant that carries spirits brands, so it is one operation.
pair 26d967ac425986436d75

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
MARIOS 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 11, computed 2026-11-19 21:39.
Every vote behind these (raw)
{
 "ue_location": [
  "DEFAULT"
 ],
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
118 within 1 mi · 1,007 within 3 mi
Off / on premise
30 / 75 within 1 mi · 219 / 644 within 3 mi
Selling alcohol
57 within 1 mi · 547 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.08 mi
Setting
urban (6,287 people per sq mi)
People within 3 mi
177,759 (139,203 adults 21+, 68,264 households) from 40 tract(s), tracts within 3 mi
Income
per capita $59,239 · median household ~$122,041 (weighted mean of tract medians)
Age and education
median age ~43.9 · bachelor's or higher 47%
Ethnicity
Hispanic 20% · White 57% · Black 1% · Asian 18%
Adults per alcohol outlet
254
Alcohol spend within 3 mi
$59,962,058 a year ($26,140,591 at home, $33,797,117 away) · $109,420 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 00271564|47|LIC|0 ↔ vtinfo 54d91b77ffc0f4e5Claude judge: samemerged17
2026-11-12 14:25insertab-inbev 45852 ↔ vtinfo 54d91b77ffc0f4e5same address and namemerged12
2026-11-06 18:13insertca-abc 00271564|47|LIC|0 ↔ overture b5a07749-3e8a-4688-9aae-c92a7ebceddesame address and namemerged11
2026-11-06 18:13insertoverture b5a07749-3e8a-4688-9aae-c92a7ebcedde ↔ ubereats i7amRSMSTXK0skrqEi4cUgsame address and namemerged11
2026-10-21 22:03backfillca-abc 00271564|47|LIC|0 ↔ ubereats i7amRSMSTXK0skrqEi4cUgsame address and namemerged