Ernie's General Store

STOCKTON, CA 95215 · O5855a7f57440 · first seen 2026-10-08
4 sourcesoff premise · conveniencealcohol: 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
Ernie's General Store 2 other
a source's own spelling of the licence name (record_title.py)
ERNIES GENERAL STORE ab-inbevca-abcvtinfo ×3
GIANNECCHINI ERNEST P ca-abc (legal name)
Street
4407 E WATERLOO RD
ca-abcno other value
City
STOCKTON
ca-abcno other value
State
CA
ca-abcno other value
ZIP
95215
ca-abcno other value
Pin
37.98767, -121.24646 map 1 other
overture
147 m away ab-inbev
Phone
2099312850
vtinfono other value
Licences
ca-abc 00053128|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O7cf31645a2dd; O6364e4bda47e; O8c4bcbeb8543

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-inbevERNIES GENERAL STORE
2014197
4407 E WATERLOO RD, STOCKTON, CA, 9521537.98810, -121.244872026-11-122026-11-12
ca-abcERNIES GENERAL STORE
legal name: GIANNECCHINI ERNEST P
00053128|21|LIC|0
4407 E WATERLOO RD, STOCKTON, CA, 952152026-10-082026-11-12
overtureErnie's General Store
83eb40d9-36f9-48ae-9c91-bdb64e73d9e3
4407 E Waterloo Rd, Stockton, CA, 95215209931285037.98767, -121.246462026-11-062026-11-12
vtinfoERNIES GENERAL STORE
d59ff84bc5b37903
4407 E WATERLOO RD, STOCKTON, CA, 95215209931285037.98760, -121.246432026-11-122026-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
ab-inbev ERNIES GENERAL STOREca-abc ERNIES GENERAL STORE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ab-inbev ERNIES GENERAL STOREoverture Ernie's General Store1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 147 m apart · name similarity 1.00
ab-inbev ERNIES GENERAL STOREvtinfo ERNIES GENERAL STORE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 147 m apart · name similarity 1.00
ca-abc ERNIES GENERAL STOREoverture Ernie's General Store1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc ERNIES GENERAL STOREvtinfo ERNIES GENERAL STORE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · name similarity 1.00
overture Ernie's General Storevtinfo ERNIES GENERAL STORE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 7 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
off_premise · convenience — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
33 within 1 mi · 343 within 3 mi
Off / on premise
9 / 20 within 1 mi · 129 / 181 within 3 mi
Selling alcohol
17 within 1 mi · 197 within 3 mi
Nearest
same channel 0.04 mi · licensed 0.04 mi
Setting
suburban (2,971 people per sq mi)
People within 3 mi
83,991 (56,669 adults 21+, 24,401 households) from 18 tract(s), tracts within 3 mi
Income
per capita $25,208 · median household ~$68,797 (weighted mean of tract medians)
Age and education
median age ~32.7 · bachelor's or higher 12%
Ethnicity
Hispanic 60% · White 19% · Black 8% · Asian 15%
Adults per alcohol outlet
286
Alcohol spend within 3 mi
$14,182,200 a year ($6,698,153 at home, $7,477,696 away) · $71,627 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 14:25insertoverture 83eb40d9-36f9-48ae-9c91-bdb64e73d9e3 ↔ vtinfo d59ff84bc5b37903same address and namemerged12
2026-11-12 14:25insertab-inbev 2014197 ↔ vtinfo d59ff84bc5b37903same address and namemerged12
2026-11-12 14:25insertca-abc 00053128|21|LIC|0 ↔ vtinfo d59ff84bc5b37903same address and namemerged12
2026-11-12 14:25insertab-inbev 2014197 ↔ overture 83eb40d9-36f9-48ae-9c91-bdb64e73d9e3same address and namemerged12
2026-11-12 14:25insertab-inbev 2014197 ↔ ca-abc 00053128|21|LIC|0same address and namemerged12
2026-11-06 18:13insertca-abc 00053128|21|LIC|0 ↔ overture 83eb40d9-36f9-48ae-9c91-bdb64e73d9e3same address and namemerged11