San Miguel Market & Deli

SAN MIGUEL, CA 93451 · O118e2559064f · first seen 2026-10-08
4 sourcesoff premisealcohol: licensed3 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
San Miguel Market & Deli 3 other
the most common name a source states
SAN MIGUEL MARKET AND DELI ab-inbevca-abc ×2
TAQUERIA SAN MIGUEL AND MARKETS INC. ca-abc (legal name) ×2
ROMAN PABLO ca-abc (legal name)
Street
1299 MISSION ST 3 other
ca-abc
1285 MISSION ST ca-abc
1299 MISSION ST 2 ab-inbev
1299 MISSION ST UT 2 ca-abc
City
SAN MIGUEL
ca-abcno other value
State
CA
ca-abcno other value
ZIP
93451
ca-abcno other value
Pin
35.75133, -120.69656 map 1 other
overture
59 m away ab-inbev
Phone
8054672800
overtureno other value
Licences
ca-abc 00560532|41|LIC|0 · ca-abc 00645785|20|LIC|0 · ca-abc 00665135|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Obffda3a522f9; O5165a03b3912; Ocde25b0de0ff; Oc9b29874d9b3; O4e0db7a60225

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-inbevSAN MIGUEL MARKET AND DELI
3638757
1299 MISSION ST 2, SAN MIGUEL, CA, 9345135.75080, -120.696512026-11-112026-11-11
ca-abcSAN MIGUEL MARKET & DELI
legal name: ROMAN PABLO
00560532|41|LIC|0
1299 MISSION ST, SAN MIGUEL, CA, 9345135.75138, -120.696422026-10-082026-11-06
ca-abcSAN MIGUEL MARKET & DELI
legal name: TAQUERIA SAN MIGUEL AND MARKETS INC.
00645785|20|LIC|0
1299 MISSION ST UT 2, SAN MIGUEL, CA, 9345135.75138, -120.696422026-10-082026-11-06
ca-abcSAN MIGUEL MARKET AND DELI
legal name: TAQUERIA SAN MIGUEL AND MARKETS INC.
00665135|21|LIC|0
1285 MISSION ST, SAN MIGUEL, CA, 9345135.75122, -120.696442026-10-082026-11-19
overtureSan Miguel Market & Deli
df2c681e-5386-4c79-9769-4e68b8117a4a
1299 Mission St, San Miguel, CA, 93451805467280035.75133, -120.696562026-11-062026-11-06
snapSan Miguel Market & Deli
snap|us|1159328
1299 Mission St, San Miguel, CA, 9345135.75139, -120.696702026-11-192026-11-19

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 SAN MIGUEL MARKET AND DELIca-abc SAN MIGUEL MARKET & DELI1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 65 m apart · name similarity 1.00 · street similarity 0.91
ab-inbev SAN MIGUEL MARKET AND DELIca-abc SAN MIGUEL MARKET & DELI1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 65 m apart · name similarity 1.00 · street similarity 0.86
ab-inbev SAN MIGUEL MARKET AND DELIca-abc SAN MIGUEL MARKET AND DELI1.00Claude judge: samemerged both outlets held a record of one source, each naming the same business
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “proximity” pair)
Identical distinctive name, adjacent numbers, 47 m.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 75% confident — Both records carry the identical name 'SAN MIGUEL MARKET AND DELI' in the same city and ZIP, and their coordinates are only about 47 m apart, which supports one market. The street numbers differ (1299 with suite 2 versus 1285) and only one record names a suite, so the address mismatch leaves some doubt.
pair 41a519d2374bdaac2bbf
ab-inbev SAN MIGUEL MARKET AND DELIoverture San Miguel Market & Deli1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 59 m apart · name similarity 1.00 · street similarity 0.91
ab-inbev SAN MIGUEL MARKET AND DELIsnap San Miguel Market & Deli1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 68 m apart · name similarity 1.00 · street similarity 0.91
ca-abc SAN MIGUEL MARKET & DELIca-abc SAN MIGUEL MARKET & DELI1.00one store listed twicemergedname Jaro-Winkler 1.00 · matched on zip · pins 0 m apart · name: identical · name similarity 1.00 · street: variant · street similarity 0.77
ca-abc SAN MIGUEL MARKET & DELIoverture San Miguel Market & Deli1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00
ca-abc SAN MIGUEL MARKET & DELIsnap San Miguel Market & Deli1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 26 m apart · name similarity 1.00
ca-abc SAN MIGUEL MARKET & DELIoverture San Miguel Market & Deli1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 15 m apart · name similarity 1.00 · street similarity 0.77
ca-abc SAN MIGUEL MARKET & DELIsnap San Miguel Market & Deli1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 26 m apart · name similarity 1.00 · street similarity 0.77
overture San Miguel Market & Delisnap San Miguel Market & Deli1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 14 m apart · name similarity 1.00

Attributes

Channel
off_premise — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
TAQUERIA SAN MIGUEL AND MARKETS INC. — 4 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — CA 20; CA 21
Rule version 11, computed 2026-11-19 21:40.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
12 within 1 mi · 21 within 3 mi
Off / on premise
5 / 6 within 1 mi · 6 / 6 within 3 mi
Selling alcohol
11 within 1 mi · 20 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
rural (none people per sq mi)
People within 3 mi
3,260 (2,000 adults 21+, 1,107 households) from 1 tract(s), the nearest tract
Income
per capita $29,326 · median household ~$76,324 (weighted mean of tract medians)
Age and education
median age ~31.1 · bachelor's or higher 17%
Ethnicity
Hispanic 56% · White 44% · Black 1% · Asian 4%
Adults per alcohol outlet
none
Alcohol spend within 3 mi
$702,784 a year ($329,994 at home, $372,434 away) · none 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:37updateab-inbev 3638757 ↔ ca-abc 00665135|21|LIC|0Claude judge: samemerged17
2026-11-19 20:37insertab-inbev 3638757 ↔ snap snap|us|1159328street written two waysmerged17
2026-11-19 20:37insertca-abc 00645785|20|LIC|0 ↔ snap snap|us|1159328street written two waysmerged17
2026-11-19 20:37insertoverture df2c681e-5386-4c79-9769-4e68b8117a4a ↔ snap snap|us|1159328same address and namemerged17
2026-11-19 20:37insertca-abc 00560532|41|LIC|0 ↔ snap snap|us|1159328same address and namemerged17
2026-11-12 17:29insertab-inbev 3638757 ↔ ca-abc 00665135|21|LIC|0Claude judge: sameheld: same-source-conflict14
2026-11-11 12:56insertab-inbev 3638757 ↔ ca-abc 00560532|41|LIC|0street written two waysmerged12
2026-11-11 12:56insertab-inbev 3638757 ↔ ca-abc 00645785|20|LIC|0street written two waysmerged12
2026-11-11 12:56insertab-inbev 3638757 ↔ overture df2c681e-5386-4c79-9769-4e68b8117a4astreet written two waysmerged12
2026-11-06 18:13insertca-abc 00645785|20|LIC|0 ↔ overture df2c681e-5386-4c79-9769-4e68b8117a4astreet written two waysmerged11
2026-11-06 18:13insertca-abc 00560532|41|LIC|0 ↔ overture df2c681e-5386-4c79-9769-4e68b8117a4asame address and namemerged11
2026-11-05 17:57backfillca-abc 00560532|41|LIC|0 ↔ ca-abc 00645785|20|LIC|0one store listed twicemerged