Lewis Grocery

LIVERMORE, CA 94551 · O4a47b5b25f40 · 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
Lewis Grocery
a source's own spelling of the licence name (record_title.py)no other value
Street
242 NORTH L ST 1 other
ca-abc
242 N L ST ab-inbevoverturevtinfo ×3
City
LIVERMORE
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94550 1 other
ca-abc
94551 ab-inbevoverturevtinfo ×3
Pin
37.68426, -121.77222 map 1 other
overture
575 m away ca-abc
Phone
9254499219
vtinfono other value
Licences
ca-abc 00541084|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oee76ec5f08f5; Oc87547323acf; Ob9837dc2778d

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-inbevLEWIS GROCERY
2351729
242 N L ST, LIVERMORE, CA, 9455137.68418, -121.772642026-11-112026-11-13
ca-abcLEWIS GROCERY
00541084|21|LIC|0
242 NORTH L ST, LIVERMORE, CA, 9455037.67914, -121.773132026-10-082026-11-13
overtureLewis Grocery
028d81b1-80dc-43b8-9d91-e7f494900301
242 N L St, Livermore, CA, 94551925449921937.68426, -121.772222026-11-062026-11-13
vtinfoLEWIS GROCERY
9e505fc33aced37e
242 N L ST, LIVERMORE, CA, 94551925449921937.68426, -121.772232026-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
ab-inbev LEWIS GROCERYca-abc LEWIS GROCERY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 562 m apart · name similarity 1.00
ab-inbev LEWIS GROCERYoverture Lewis Grocery1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 38 m apart · name similarity 1.00
ab-inbev LEWIS GROCERYvtinfo LEWIS GROCERY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 37 m apart · name similarity 1.00
ca-abc LEWIS GROCERYoverture Lewis Grocery1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 575 m apart · name similarity 1.00
ca-abc LEWIS GROCERYvtinfo LEWIS GROCERY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 575 m apart · name similarity 1.00
overture Lewis Groceryvtinfo LEWIS GROCERY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 1 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 11, computed 2026-11-19 21:41.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
239 within 1 mi · 464 within 3 mi
Off / on premise
45 / 162 within 1 mi · 112 / 240 within 3 mi
Selling alcohol
156 within 1 mi · 321 within 3 mi
Nearest
same channel 0.23 mi · licensed 0.11 mi
Setting
suburban (2,618 people per sq mi)
People within 3 mi
74,026 (54,837 adults 21+, 26,764 households) from 16 tract(s), tracts within 3 mi
Income
per capita $72,787 · median household ~$164,714 (weighted mean of tract medians)
Age and education
median age ~41.4 · bachelor's or higher 51%
Ethnicity
Hispanic 23% · White 59% · Black 2% · Asian 15%
Adults per alcohol outlet
170
Alcohol spend within 3 mi
$27,490,628 a year ($11,629,027 at home, $15,853,237 away) · $85,375 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:10insertca-abc 00541084|21|LIC|0 ↔ vtinfo 9e505fc33aced37esame address and namemerged15
2026-11-13 14:10insertoverture 028d81b1-80dc-43b8-9d91-e7f494900301 ↔ vtinfo 9e505fc33aced37esame address and namemerged15
2026-11-13 14:10insertab-inbev 2351729 ↔ vtinfo 9e505fc33aced37esame address and namemerged15
2026-11-11 12:56insertab-inbev 2351729 ↔ ca-abc 00541084|21|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 2351729 ↔ overture 028d81b1-80dc-43b8-9d91-e7f494900301same address and namemerged12
2026-11-06 18:13insertca-abc 00541084|21|LIC|0 ↔ overture 028d81b1-80dc-43b8-9d91-e7f494900301same address and namemerged11