El Michoacano Restaurant

FRESNO, CA 93711 · O595c341a4b7c · first seen 2026-10-08
2 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
El Michoacano Restaurant 2 other
a licence name in capitals, cleaned (derived; record_title.py)
el michoacano restaurant fresno doordash
VILLA JOSE MARIA ca-abc (legal name)
Street
3637-39 W SHAW AVE 1 other
ca-abc
3639 W Shaw Ave doordash
City
FRESNO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
93711
ca-abcno other value
Pin
36.80639, -119.85873 map 1 other
doordash
205 m away ca-abc
Phone
none
no other value
Licences
ca-abc 00506436|41|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe789c314cf35

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-abcEL MICHOACANO RESTAURANT
legal name: VILLA JOSE MARIA
00506436|41|LIC|0
3637-39 W SHAW AVE, FRESNO, CA, 9371136.80822, -119.858562026-10-082026-11-05
doordashel michoacano restaurant fresno
624820
3639 W Shaw Ave, Fresno, CA, 9371136.80639, -119.858732026-10-082026-11-11

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 EL MICHOACANO RESTAURANTdoordash el michoacano restaurant fresno1.00Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
The DoorDash slug matches the licensed restaurant name and city, and 3639 W Shaw Ave falls within the licence's 3637-39 address range, with only one business at that address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records name El Michoacano restaurant at 3637-39 / 3639 W Shaw Ave, Fresno 93711, the California licence is an on-sale eating-place (restaurant) licence matching a restaurant delivery listing, and the building has only one business at that address.
  • Claude Haiku 5.5, prompt v7: same, 85% confident — Both records name El Michoacano restaurant at 3639 W Shaw Ave, Fresno, 93711, the only business held at that address, with a short distance between coordinates; the CA licence is an on-sale eating place (restaurant), consistent with the DoorDash restaurant listing.
pair 653f7d0892291ecaa8d2

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 — CA 41
Rule version 11, computed 2026-11-19 21:42.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
149 within 1 mi · 520 within 3 mi
Off / on premise
39 / 94 within 1 mi · 153 / 310 within 3 mi
Selling alcohol
69 within 1 mi · 270 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.12 mi
Setting
urban (4,583 people per sq mi)
People within 3 mi
129,588 (89,954 adults 21+, 44,133 households) from 25 tract(s), tracts within 3 mi
Income
per capita $38,124 · median household ~$85,549 (weighted mean of tract medians)
Age and education
median age ~35.3 · bachelor's or higher 28%
Ethnicity
Hispanic 48% · White 37% · Black 8% · Asian 11%
Adults per alcohol outlet
332
Alcohol spend within 3 mi
$29,742,047 a year ($13,584,617 at home, $16,143,341 away) · $109,749 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-11 12:56insertca-abc 00506436|41|LIC|0 ↔ doordash 624820Claude judge: samemerged12