Rancho San Miguel Market

GREENFIELD, CA 93927 · O0697574b269c · first seen 2026-10-08
4 sourcesoff premisechain: Rancho San Miguel Marketsalcohol: 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
Rancho San Miguel Market 3 other
a licence name in capitals, cleaned (derived; record_title.py)
PAQ INC ca-abc (legal name) ×2
RANCHO SAN MIGUEL MARKETS ab-inbevoverture ×2
Rancho San Miguel 25 snap
Street
500 WALNUT AVE
ca-abcno other value
City
GREENFIELD
ca-abcno other value
State
CA
ca-abcno other value
ZIP
93927
ca-abcno other value
Pin
36.33006, -121.24584 map 3 other
overture
166 m away ca-abc ×2
157 m away ab-inbev
233 m away snap
Phone
8316743591
overtureno other value
Licences
ca-abc 00514212|21|APP|0 · ca-abc 00514212|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O62522465d9e5; O9f89f3a34db7; O1f04df958590; O232486fe14e7

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-inbevRANCHO SAN MIGUEL MARKETS
3448562
500 WALNUT AVE, GREENFIELD, CA, 9392736.32880, -121.245062026-11-132026-11-13
ca-abcRANCHO SAN MIGUEL MARKET
legal name: PAQ INC
00514212|21|APP|0
500 WALNUT AVE, GREENFIELD, CA, 9392736.32913, -121.244402026-10-082026-11-13
ca-abcRANCHO SAN MIGUEL MARKET
legal name: PAQ INC
00514212|21|LIC|0
500 WALNUT AVE, GREENFIELD, CA, 9392736.32913, -121.244402026-10-082026-11-13
overtureRancho San Miguel Markets
911314e9-9bd8-43b4-b6a9-76ce1d857e8b
500 Walnut Ave, Greenfield, CA, 93927831674359136.33006, -121.245842026-11-062026-11-13
snapRancho San Miguel 25
snap|us|1057425
500 Walnut Ave, Greenfield, CA, 9392736.32806, -121.246602026-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 RANCHO SAN MIGUEL MARKETSoverture Rancho San Miguel Markets1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 157 m apart · name similarity 1.00
ca-abc RANCHO SAN MIGUEL MARKETca-abc RANCHO SAN MIGUEL MARKET1.00one licence filemergedfile: 00514212 · same_address
ab-inbev RANCHO SAN MIGUEL MARKETSca-abc RANCHO SAN MIGUEL MARKET0.79same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 70 m apart · name similarity 0.79
ab-inbev RANCHO SAN MIGUEL MARKETSca-abc RANCHO SAN MIGUEL MARKET0.79same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 70 m apart · name similarity 0.79
ca-abc RANCHO SAN MIGUEL MARKEToverture Rancho San Miguel Markets0.79same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 166 m apart · name similarity 0.79
ca-abc RANCHO SAN MIGUEL MARKEToverture Rancho San Miguel Markets0.79same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 166 m apart · name similarity 0.79
ca-abc RANCHO SAN MIGUEL MARKETsnap Rancho San Miguel 250.71same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: market · name Jaro-Winkler 0.73 · same street + ZIP · pins 231 m apart · name similarity 0.71
ca-abc RANCHO SAN MIGUEL MARKETsnap Rancho San Miguel 250.71same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: market · name Jaro-Winkler 0.73 · same street + ZIP · pins 231 m apart · name similarity 0.71
ab-inbev RANCHO SAN MIGUEL MARKETSsnap Rancho San Miguel 250.70same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: markets · name Jaro-Winkler 0.72 · same street + ZIP · pins 161 m apart · name similarity 0.70
overture Rancho San Miguel Marketssnap Rancho San Miguel 250.70same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: markets · name Jaro-Winkler 0.72 · same street + ZIP · pins 233 m apart · name similarity 0.70

Attributes

Channel
off_premise — ca-licence
Chain
Rancho San Miguel Markets — overture-brand
Alcohol
licensed — a licence or TTB permit on file
Operator
PAQ INC — 26 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 11, computed 2026-11-19 21:39.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
41 within 1 mi · 44 within 3 mi
Off / on premise
18 / 19 within 1 mi · 18 / 20 within 3 mi
Selling alcohol
28 within 1 mi · 30 within 3 mi
Nearest
same channel 0.10 mi · licensed 0.08 mi
Setting
suburban (760 people per sq mi)
People within 3 mi
21,489 (13,116 adults 21+, 4,805 households) from 3 tract(s), tracts within 3 mi
Income
per capita $22,096 · median household ~$85,319 (weighted mean of tract medians)
Age and education
median age ~29.1 · bachelor's or higher 8%
Ethnicity
Hispanic 95% · White 16% · Black 1% · Asian 1%
Adults per alcohol outlet
423
Alcohol spend within 3 mi
$3,212,965 a year ($1,484,783 at home, $1,726,888 away) · $103,644 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:37insertab-inbev 3448562 ↔ snap snap|us|1057425same address and namemerged17
2026-11-19 20:37insertoverture 911314e9-9bd8-43b4-b6a9-76ce1d857e8b ↔ snap snap|us|1057425same address and namemerged17
2026-11-19 20:37insertca-abc 00514212|21|LIC|0 ↔ snap snap|us|1057425same address and namemerged17
2026-11-19 20:37insertca-abc 00514212|21|APP|0 ↔ snap snap|us|1057425same address and namemerged17
2026-11-13 14:10insertab-inbev 3448562 ↔ ca-abc 00514212|21|LIC|0same address and namemerged15
2026-11-13 14:10insertab-inbev 3448562 ↔ ca-abc 00514212|21|APP|0same address and namemerged15
2026-11-13 14:10insertab-inbev 3448562 ↔ overture 911314e9-9bd8-43b4-b6a9-76ce1d857e8bsame address and namemerged15
2026-11-06 18:13insertca-abc 00514212|21|LIC|0 ↔ overture 911314e9-9bd8-43b4-b6a9-76ce1d857e8bsame address and namemerged11
2026-11-06 18:13insertca-abc 00514212|21|APP|0 ↔ overture 911314e9-9bd8-43b4-b6a9-76ce1d857e8bsame address and namemerged11
2026-10-09 13:59backfillca-abc 00514212|21|APP|0 ↔ ca-abc 00514212|21|LIC|0one licence filemerged