MARIACHIS

TURLOCK, CA 95382 · O18e9910bb929 · first seen 2026-10-08
4 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
MARIACHIS 4 other
the most common name a source states
DELGADO MENDOZA MARIA Y ca-abc (legal name)
MARIACHI'S MEXICAN RESTAURANT ca-abc
mariachi's restaurant and cantina turlock doordash
Mariachis Mexican Restaurant overture
Street
2669 GEER RD 1 other
ca-abc
2669 Geer Road doordash
City
TURLOCK
ca-abcno other value
State
CA
ca-abcno other value
ZIP
95382
ca-abcno other value
Pin
37.51741, -120.84988 map 1 other
doordash
117 m away ca-abc
Phone
2096327662
vtinfono other value
Licences
ca-abc 00650391|47|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oeab44daaaf63; Oe9fa19feb950; Od592e5771f41

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-abcMARIACHI'S MEXICAN RESTAURANT
legal name: DELGADO MENDOZA MARIA Y
00650391|47|LIC|0
2669 GEER RD, TURLOCK, CA, 9538237.51815, -120.848952026-10-082026-11-13
doordashmariachi's restaurant and cantina turlock
23870276
2669 Geer Road, Turlock, CA, 9538237.51741, -120.849882026-10-082026-11-13
overtureMariachis Mexican Restaurant
750b39ae-9e79-46f8-85bf-8a2f04e6bbd4
2669 Geer Rd, Turlock, CA, 95382209632766237.51739, -120.849782026-11-062026-11-13
vtinfoMARIACHIS
caf59e862d0eec7c
2669 GEER RD, TURLOCK, CA, 95382209632766237.51745, -120.849962026-11-132026-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
ca-abc MARIACHI'S MEXICAN RESTAURANToverture Mariachis Mexican Restaurant1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 112 m apart · name similarity 1.00
ca-abc MARIACHI'S MEXICAN RESTAURANTdoordash mariachi's restaurant and cantina turlock0.66Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
The street address and ZIP match exactly, the names agree (Mariachi's restaurant), the licence is for a restaurant, which fits the DoorDash listing, and only one business is recorded at that address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records give 2669 Geer Road, Turlock CA 95382, and the names align (Mariachi's restaurant), with a 0.1 km coordinate gap; the California licence is an on-sale eating place, matching a restaurant listing, and no other business is at the address.
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records give 2669 Geer Road, Turlock, ZIP 95382, with coordinates about 0.12 km apart, and the only business at that address in the data is a Mariachi's restaurant (the DoorDash slug 'mariachi's restaurant and cantina turlock' matches the CA ABC 'MARIACHI'S MEXICAN RESTAURANT' with an on-sale eating place licence).
  • Claude Haiku 5.5, prompt v4: same, 85% confident — Both records give the same street address, city and ZIP (2669 Geer Road, Turlock 95382), it is the only business at that address, and the names Mariachi's Mexican Restaurant and Mariachi's Restaurant and Cantina both describe one Mariachi's restaurant, with the CA licence being an on-sale eating-place licence matching a restaurant.
pair 43d445bfa2263a30b88b
doordash mariachi's restaurant and cantina turlockoverture Mariachis Mexican Restaurant0.61same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: cantina, mexican, restaurant · name Jaro-Winkler 0.80 · same street + ZIP · pins 8 m apart · name similarity 0.61
ca-abc MARIACHI'S MEXICAN RESTAURANTvtinfo MARIACHIS0.41same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: mexican, restaurant · name Jaro-Winkler 0.86 · same street + city + state · pins 119 m apart · name similarity 0.41
doordash mariachi's restaurant and cantina turlockvtinfo MARIACHIS0.41same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: cantina, restaurant · name Jaro-Winkler 0.64 · same street + city + state · pins 8 m apart · name similarity 0.41
overture Mariachis Mexican Restaurantvtinfo MARIACHIS0.41same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: mexican, restaurant · name Jaro-Winkler 0.86 · same street + city + state · pins 16 m apart · name similarity 0.41 · phone: equal

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
Rule version 7, computed 2026-11-16 17:15.
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
90 within 1 mi · 376 within 3 mi
Off / on premise
24 / 63 within 1 mi · 109 / 231 within 3 mi
Selling alcohol
48 within 1 mi · 214 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.05 mi
Setting
suburban (2,705 people per sq mi)
People within 3 mi
76,472 (53,546 adults 21+, 26,632 households) from 15 tract(s), tracts within 3 mi
Income
per capita $38,020 · median household ~$88,249 (weighted mean of tract medians)
Age and education
median age ~35.8 · bachelor's or higher 26%
Ethnicity
Hispanic 45% · White 49% · Black 2% · Asian 5%
Adults per alcohol outlet
249
Alcohol spend within 3 mi
$18,319,239 a year ($8,356,506 at home, $9,955,328 away) · $85,206 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 23870276 ↔ vtinfo caf59e862d0eec7csame address and namemerged15
2026-11-13 14:10insertoverture 750b39ae-9e79-46f8-85bf-8a2f04e6bbd4 ↔ vtinfo caf59e862d0eec7csame address and namemerged15
2026-11-13 14:10insertca-abc 00650391|47|LIC|0 ↔ vtinfo caf59e862d0eec7csame address and namemerged15
2026-11-12 17:29insertdoordash 23870276 ↔ overture 750b39ae-9e79-46f8-85bf-8a2f04e6bbd4same address and namemerged14
2026-11-06 18:13insertca-abc 00650391|47|LIC|0 ↔ overture 750b39ae-9e79-46f8-85bf-8a2f04e6bbd4same address and namemerged11
2026-11-02 23:02backfillca-abc 00650391|47|LIC|0 ↔ doordash 23870276Claude judge: samemerged