Elvira's Grill

CLAREMONT, CA 91711 · O1cc6ededee41 · 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.

FieldMaster valueTaken fromWhat other sources say
Name
Elvira's Grill 3 other
the most common name a source states
ELVIRA'S MEXICAN BAR AND GRILL ca-abc ×2
ELVIRAS GRILL ab-inbevvtinfo ×2
MAZARIEGOS DE TORRES SANDRA E ca-abc (legal name) ×2
Street
415 W FOOTHILL BLVD 2 other
ca-abc
415 W FOOTHILL BLVD STE 100 ab-inbevvtinfo ×2
415 W Foothill Blvd #100 overture
City
CLAREMONT
ca-abcno other value
State
CA
ca-abcno other value
ZIP
91711
ca-abcno other value
Pin
34.10813, -117.72105 map
ubereatsno other value
Phone
9093993300
vtinfono other value
Licences
ca-abc 00578270|47|LIC|0 · ca-abc 00578270|77|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O3db6f9aad1e2; O63742922bcf9; O7dec8117ed25; Ofebe7190c979; O8b965479bd00

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-inbevELVIRAS GRILL
4043086
415 W FOOTHILL BLVD STE 100, CLAREMONT, CA, 9171134.10801, -117.721362026-11-112026-11-11
ca-abcELVIRA'S MEXICAN BAR AND GRILL
legal name: MAZARIEGOS DE TORRES SANDRA E
00578270|47|LIC|0
415 W FOOTHILL BLVD, CLAREMONT, CA, 917112026-10-082026-11-05
ca-abcELVIRA'S MEXICAN BAR AND GRILL
legal name: MAZARIEGOS DE TORRES SANDRA E
00578270|77|LIC|0
415 W FOOTHILL BLVD, CLAREMONT, CA, 917112026-10-082026-11-05
overtureElvira's Grill
3131cc6e-91df-42b5-9482-b87ccdf59dfb
415 W Foothill Blvd #100, Claremont, CA, 91711909399330034.10792, -117.720842026-11-062026-11-06
ubereatsElvira's Grill
11K4OeTNQsm8sDvP31uQCg
415 W Foothill Blvd, Claremont, CA, 9171134.10813, -117.721052026-10-262026-11-03
vtinfoELVIRAS GRILL
5fa9499d29e03f0b
415 W FOOTHILL BLVD STE 100, CLAREMONT, CA, 91711909399330034.10812, -117.721032026-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 ELVIRAS GRILLoverture Elvira's Grill1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 49 m apart · name similarity 1.00
ab-inbev ELVIRAS GRILLubereats Elvira's Grill1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 32 m apart · name similarity 1.00
ab-inbev ELVIRAS GRILLvtinfo ELVIRAS GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 33 m apart · name similarity 1.00
ca-abc ELVIRA'S MEXICAN BAR AND GRILLca-abc ELVIRA'S MEXICAN BAR AND GRILL1.00one licence filemergedfile: 00578270 · same_address
overture Elvira's Grillubereats Elvira's Grill1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 31 m apart · name similarity 1.00
overture Elvira's Grillvtinfo ELVIRAS GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 29 m apart · name similarity 1.00 · phone: equal
ubereats Elvira's Grillvtinfo ELVIRAS GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 2 m apart · name similarity 1.00
ca-abc ELVIRA'S MEXICAN BAR AND GRILLubereats Elvira's Grill0.65Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
Both records are at 415 W Foothill Blvd, Claremont 91711, under matching distinctive names (Elvira's Mexican Bar and Grill / Elvira's Grill), and only one business is recorded at that address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records sit at 415 W Foothill Blvd, Claremont 91711, and no other business is held at that address; the ABC licence is an eating-place restaurant licence, matching the restaurant 'Elvira's Grill' on Uber Eats despite the slightly different name.
  • Claude Haiku 5.5, prompt v4: same, 90% confident — Both records are at 415 W Foothill Blvd, Claremont 91711, the only business our data holds at that address, and the California licence is an on-sale eating-place (restaurant) licence, which fits 'Elvira's Grill'; the names share the distinctive 'Elvira's' core.
pair 5aed0f4e356af48ccad8
ca-abc ELVIRA'S MEXICAN BAR AND GRILLubereats Elvira's Grill0.65Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
Same distinctive name (Elvira's) at the identical street address and ZIP, with only one business recorded there; the restaurant licence fits a grill listed on Uber Eats.
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v9: same, 94% confident — The two records have the same street address and ZIP, no other business is known at that address, and 'Elvira's Grill' is a short form of the distinctive name 'Elvira's Mexican Bar and Grill', the restaurant on the licence.
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records sit at 415 W Foothill Blvd, Claremont 91711, and the names match closely (Elvira's Mexican Bar and Grill vs Elvira's Grill), with no other business at that address and the California licence is an eating-place restaurant that fits a restaurant listing on Uber Eats.
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records sit at 415 W Foothill Blvd, Claremont 91711, and no other business is held at that address; the ABC licence is an on-sale eating place (restaurant with full bar) matching a restaurant listing named Elvira's Grill, so it is the same single operation.
  • Claude Haiku 5.5, prompt v4: same, 90% confident — Both records are at 415 W Foothill Blvd, Claremont 91711, and no other business is held at that address; the California licence is an eating-place (restaurant) licence, which fits the 'Elvira's Grill' restaurant listing on Uber Eats, so the names are one restaurant under different spellings.
pair 02a579b6c028afa79a48
ab-inbev ELVIRAS GRILLca-abc ELVIRA'S MEXICAN BAR AND GRILL0.59same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, grill, mexican · name Jaro-Winkler 0.71 · same street + ZIP · name similarity 0.59
ab-inbev ELVIRAS GRILLca-abc ELVIRA'S MEXICAN BAR AND GRILL0.59same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, grill, mexican · name Jaro-Winkler 0.71 · same street + ZIP · name similarity 0.59
ca-abc ELVIRA'S MEXICAN BAR AND GRILLoverture Elvira's Grill0.59same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, grill, mexican · name Jaro-Winkler 0.71 · same street + ZIP · name similarity 0.59
ca-abc ELVIRA'S MEXICAN BAR AND GRILLvtinfo ELVIRAS GRILL0.59same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, grill, mexican · name Jaro-Winkler 0.71 · same street + city + state · name similarity 0.59
ca-abc ELVIRA'S MEXICAN BAR AND GRILLoverture Elvira's Grill0.59same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, grill, mexican · name Jaro-Winkler 0.71 · same street + ZIP · name similarity 0.59
ca-abc ELVIRA'S MEXICAN BAR AND GRILLvtinfo ELVIRAS GRILL0.59same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, grill, mexican · name Jaro-Winkler 0.71 · same street + city + state · name similarity 0.59

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47; CA 77
Rule version 7, computed 2026-11-16 17:15.
Every vote behind these (raw)
{
 "ue_location": [
  "DEFAULT"
 ],
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
93 within 1 mi · 470 within 3 mi
Off / on premise
14 / 61 within 1 mi · 135 / 256 within 3 mi
Selling alcohol
64 within 1 mi · 304 within 3 mi
Nearest
same channel 0.07 mi · licensed 0.08 mi
Setting
urban (4,598 people per sq mi)
People within 3 mi
130,003 (95,379 adults 21+, 42,459 households) from 28 tract(s), tracts within 3 mi
Income
per capita $41,605 · median household ~$103,849 (weighted mean of tract medians)
Age and education
median age ~38.5 · bachelor's or higher 38%
Ethnicity
Hispanic 49% · White 34% · Black 8% · Asian 11%
Adults per alcohol outlet
313
Alcohol spend within 3 mi
$32,973,640 a year ($14,732,849 at home, $18,225,954 away) · $108,110 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-09 23:07.

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-12 17:29insertca-abc 00578270|77|LIC|0 ↔ vtinfo 5fa9499d29e03f0bsame address and namemerged14
2026-11-12 17:29insertca-abc 00578270|47|LIC|0 ↔ vtinfo 5fa9499d29e03f0bsame address and namemerged14
2026-11-12 17:29insertab-inbev 4043086 ↔ ca-abc 00578270|77|LIC|0same address and namemerged14
2026-11-12 17:29insertab-inbev 4043086 ↔ ca-abc 00578270|47|LIC|0same address and namemerged14
2026-11-12 17:29insertca-abc 00578270|77|LIC|0 ↔ overture 3131cc6e-91df-42b5-9482-b87ccdf59dfbsame address and namemerged14
2026-11-12 17:29insertca-abc 00578270|47|LIC|0 ↔ overture 3131cc6e-91df-42b5-9482-b87ccdf59dfbsame address and namemerged14
2026-11-12 14:25insertubereats 11K4OeTNQsm8sDvP31uQCg ↔ vtinfo 5fa9499d29e03f0bsame address and namemerged12
2026-11-12 14:25insertab-inbev 4043086 ↔ vtinfo 5fa9499d29e03f0bsame address and namemerged12
2026-11-12 14:25insertoverture 3131cc6e-91df-42b5-9482-b87ccdf59dfb ↔ vtinfo 5fa9499d29e03f0bsame address and namemerged12
2026-11-11 12:56insertab-inbev 4043086 ↔ overture 3131cc6e-91df-42b5-9482-b87ccdf59dfbsame address and namemerged12
2026-11-11 12:56insertab-inbev 4043086 ↔ ubereats 11K4OeTNQsm8sDvP31uQCgsame address and namemerged12
2026-11-06 18:13insertoverture 3131cc6e-91df-42b5-9482-b87ccdf59dfb ↔ ubereats 11K4OeTNQsm8sDvP31uQCgsame address and namemerged11
2026-11-02 23:02backfillca-abc 00578270|47|LIC|0 ↔ ubereats 11K4OeTNQsm8sDvP31uQCgClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00578270|77|LIC|0 ↔ ubereats 11K4OeTNQsm8sDvP31uQCgClaude judge: samemerged
2026-10-09 13:59backfillca-abc 00578270|47|LIC|0 ↔ ca-abc 00578270|77|LIC|0one licence filemerged