La Esperanza Food Center

MADERA, CA 93638 · O76aed9144535 · first seen 2026-10-08
4 sourcesoff premisealcohol: 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
La Esperanza Food Center 3 other
the most common name a source states
la esperanza madera doordash
LA ESPERANZA MARKET ab-inbev
RAMIREZ VAZQUEZ INC ca-abc (legal name)
Street
823 E CLEVELAND AVE 1 other
ca-abc
823 East Cleveland Avenue doordash
City
MADERA
ca-abcno other value
State
CA
ca-abcno other value
ZIP
93638
ca-abcno other value
Pin
36.97503, -120.05704 map 2 other
doordash
57 m away ab-inbev
57 m away ca-abc
Phone
5596740411
overtureno other value
Licences
ca-abc 00401635|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oebc2fa881b98; O8b7998d4499d; Oe139d830f0db

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-inbevLA ESPERANZA MARKET
535867
823 E CLEVELAND AVE, MADERA, CA, 9363836.97459, -120.056702026-11-112026-11-11
ca-abcLA ESPERANZA FOOD CENTER
legal name: RAMIREZ VAZQUEZ INC
00401635|21|LIC|0
823 E CLEVELAND AVE, MADERA, CA, 9363836.97452, -120.057132026-10-082026-11-06
doordashla esperanza madera
1492887
823 East Cleveland Avenue, Madera, CA, 9363836.97503, -120.057042026-10-082026-11-06
overtureLa Esperanza Food Center
d847c4f9-6746-41fb-b087-c8b369a55369
823 E Cleveland Ave, Madera, CA, 93638559674041136.97502, -120.056912026-11-062026-11-06

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 LA ESPERANZA FOOD CENTERoverture La Esperanza Food Center1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 58 m apart · name similarity 1.00
ab-inbev LA ESPERANZA MARKETdoordash la esperanza madera0.72same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.95 · same street + ZIP · pins 57 m apart · name similarity 0.72
ca-abc LA ESPERANZA FOOD CENTERdoordash la esperanza madera0.58Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (88% confident; asked as a “near” pair)
Both records sit at the same street address (823 E Cleveland Ave, Madera 93638), and the DoorDash slug 'la esperanza madera' agrees with the licensed off-sale market 'La Esperanza Food Center', so the
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 80% confident — Both records give the same street address in Madera (823 E Cleveland Ave, 93638), 57 m apart, and the distinctive name 'La Esperanza' matches between the ABC licence 'La Esperanza Food Center' and the DoorDash listing 'la esperanza madera'; the shared building with one other business is outweighed by the name agreement.
  • Claude Haiku 5.5, prompt v4: same, 85% confident — The DoorDash slug 'la esperanza madera' matches the ABC DBA 'LA ESPERANZA FOOD CENTER' on the same street address, ZIP and city, and the distinctive name agrees; the second business at the address does not carry this name, so the names support one outlet.
pair 609e2b7daa2b382e9e7e
ab-inbev LA ESPERANZA MARKETca-abc LA ESPERANZA FOOD CENTER0.48Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “near” pair)
La Esperanza names agree at same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 70% confident — Both records share the distinctive name 'La Esperanza' at the same street address with coordinates 39 m apart, and 'Market' and 'Food Center' are generic grocery descriptors, though the building holds two businesses so the match rests on the name alone.
pair 3936dc75caf96396005e

Attributes

Channel
off_premise — ca-licence conflicting evidence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
RAMIREZ VAZQUEZ INC — 2 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 7, computed 2026-11-16 17:18.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
83 within 1 mi · 267 within 3 mi
Off / on premise
33 / 40 within 1 mi · 99 / 126 within 3 mi
Selling alcohol
46 within 1 mi · 150 within 3 mi
Nearest
same channel 0.07 mi · licensed 0.03 mi
Setting
suburban (2,104 people per sq mi)
People within 3 mi
59,487 (38,180 adults 21+, 15,249 households) from 13 tract(s), tracts within 3 mi
Income
per capita $23,640 · median household ~$61,846 (weighted mean of tract medians)
Age and education
median age ~29.9 · bachelor's or higher 10%
Ethnicity
Hispanic 84% · White 21% · Black 2% · Asian 1%
Adults per alcohol outlet
253
Alcohol spend within 3 mi
$8,136,866 a year ($3,913,695 at home, $4,219,975 away) · $53,887 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-12 17:29insertab-inbev 535867 ↔ ca-abc 00401635|21|LIC|0Claude judge: samemerged14
2026-11-11 12:56insertab-inbev 535867 ↔ doordash 1492887same address and namemerged12
2026-11-06 18:13insertca-abc 00401635|21|LIC|0 ↔ overture d847c4f9-6746-41fb-b087-c8b369a55369same address and namemerged11
2026-11-02 23:02backfillca-abc 00401635|21|LIC|0 ↔ doordash 1492887Claude judge: samemerged