Shamrock Liquor #2

Palmdale, CA 93550 · O0c464facf656 · first seen 2026-10-08
6 sourcesoff premise · liquor_storealcohol: 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
Shamrock Liquor #2 4 other
a source's own spelling of the licence name (record_title.py)
SHAMROCK LIQUOR 2 ab-inbevca-abcvtinfo ×3
MAIDA EDWAR HAWASH ca-abc (legal name)
SHAMROCK LIQUOR & DELI #2 inspections
Shamrock Liquor Number 2 overture
Street
1475 E PALMDALE BLVD 1 other
ca-abc
1475 E PALMDALE BLVD STE B ab-inbevvtinfo ×2
City
PALMDALE
ca-abcno other value
State
CA
ca-abcno other value
ZIP
93550
ca-abcno other value
Pin
34.57989, -118.10348 map
overtureno other value
Phone
6612651860
vtinfono other value
Licences
ca-abc 00342510|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ob80dce095dba; O9fd6be072860; Oca52aed6ad55; O175cf37063ee; Ode7bce5e46e3

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-inbevSHAMROCK LIQUOR 2
4016157
1475 E PALMDALE BLVD STE B, PALMDALE, CA, 9355034.57970, -118.103202026-11-112026-11-11
ca-abcSHAMROCK LIQUOR 2
legal name: MAIDA EDWAR HAWASH
00342510|21|LIC|0
1475 E PALMDALE BLVD, PALMDALE, CA, 9355034.57968, -118.103412026-10-082026-11-06
inspectionsSHAMROCK LIQUOR & DELI #2
inspections|la|FA0242859|PR0191051
1475 E PALMDALE BLVD, Palmdale, CA, 935502026-11-192026-11-19
overtureShamrock Liquor Number 2
2aae7957-9dd4-4bec-964c-a8d4d59379ac
1475 E Palmdale Blvd, Palmdale, CA, 93550661265186034.57989, -118.103482026-11-062026-11-06
snapShamrock Liquor #2
snap|us|1278146
1475 E Palmdale Blvd, Palmdale, CA, 9355034.57997, -118.103302026-11-192026-11-19
vtinfoSHAMROCK LIQUOR 2
fe17c6b1c4f20f10
1475 E PALMDALE BLVD STE B, PALMDALE, CA, 93550661265186034.57992, -118.103372026-11-142026-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 SHAMROCK LIQUOR 2ca-abc SHAMROCK LIQUOR 21.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 19 m apart · name similarity 1.00
ab-inbev SHAMROCK LIQUOR 2overture Shamrock Liquor Number 21.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 33 m apart · name similarity 1.00
ab-inbev SHAMROCK LIQUOR 2snap Shamrock Liquor #21.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 31 m apart · name similarity 1.00
ab-inbev SHAMROCK LIQUOR 2vtinfo SHAMROCK LIQUOR 21.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 29 m apart · name similarity 1.00
ca-abc SHAMROCK LIQUOR 2overture Shamrock Liquor Number 21.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 25 m apart · name similarity 1.00
ca-abc SHAMROCK LIQUOR 2snap Shamrock Liquor #21.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 34 m apart · name similarity 1.00
ca-abc SHAMROCK LIQUOR 2vtinfo SHAMROCK LIQUOR 21.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 27 m apart · name similarity 1.00
overture Shamrock Liquor Number 2snap Shamrock Liquor #21.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 18 m apart · name similarity 1.00
overture Shamrock Liquor Number 2vtinfo SHAMROCK LIQUOR 21.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 10 m apart · name similarity 1.00 · phone: equal
snap Shamrock Liquor #2vtinfo SHAMROCK LIQUOR 21.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00
ab-inbev SHAMROCK LIQUOR 2inspections SHAMROCK LIQUOR & DELI #20.81same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.90 · same street + ZIP · name similarity 0.81
ca-abc SHAMROCK LIQUOR 2inspections SHAMROCK LIQUOR & DELI #20.81same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.90 · same street + ZIP · name similarity 0.81
inspections SHAMROCK LIQUOR & DELI #2overture Shamrock Liquor Number 20.81same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.90 · same street + ZIP · name similarity 0.81
inspections SHAMROCK LIQUOR & DELI #2snap Shamrock Liquor #20.81same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.90 · same street + ZIP · name similarity 0.81
inspections SHAMROCK LIQUOR & DELI #2vtinfo SHAMROCK LIQUOR 20.81same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.90 · same street + ZIP · name similarity 0.81

Attributes

Channel
off_premise · liquor_store — 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:40.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
73 within 1 mi · 282 within 3 mi
Off / on premise
15 / 50 within 1 mi · 74 / 170 within 3 mi
Selling alcohol
31 within 1 mi · 138 within 3 mi
Nearest
same channel 0.06 mi · licensed 0.23 mi
Setting
urban (3,103 people per sq mi)
People within 3 mi
87,732 (57,484 adults 21+, 25,343 households) from 18 tract(s), tracts within 3 mi
Income
per capita $23,993 · median household ~$65,898 (weighted mean of tract medians)
Age and education
median age ~31.7 · bachelor's or higher 12%
Ethnicity
Hispanic 67% · White 22% · Black 14% · Asian 3%
Adults per alcohol outlet
414
Alcohol spend within 3 mi
$14,136,656 a year ($6,741,798 at home, $7,388,539 away) · $101,703 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:37insertinspections inspections|la|FA0242859|PR0191051 ↔ snap snap|us|1278146same address and namemerged17
2026-11-19 20:37insertca-abc 00342510|21|LIC|0 ↔ inspections inspections|la|FA0242859|PR0191051same address and namemerged17
2026-11-19 20:37insertab-inbev 4016157 ↔ inspections inspections|la|FA0242859|PR0191051same address and namemerged17
2026-11-19 20:37insertinspections inspections|la|FA0242859|PR0191051 ↔ overture 2aae7957-9dd4-4bec-964c-a8d4d59379acsame address and namemerged17
2026-11-19 20:37insertinspections inspections|la|FA0242859|PR0191051 ↔ vtinfo fe17c6b1c4f20f10same address and namemerged17
2026-11-19 20:37insertca-abc 00342510|21|LIC|0 ↔ snap snap|us|1278146same address and namemerged17
2026-11-19 20:37insertab-inbev 4016157 ↔ snap snap|us|1278146same address and namemerged17
2026-11-19 20:37insertoverture 2aae7957-9dd4-4bec-964c-a8d4d59379ac ↔ snap snap|us|1278146same address and namemerged17
2026-11-19 20:37insertsnap snap|us|1278146 ↔ vtinfo fe17c6b1c4f20f10same address and namemerged17
2026-11-14 20:23insertca-abc 00342510|21|LIC|0 ↔ vtinfo fe17c6b1c4f20f10same address and namemerged15
2026-11-14 20:23insertab-inbev 4016157 ↔ vtinfo fe17c6b1c4f20f10same address and namemerged15
2026-11-14 20:23insertoverture 2aae7957-9dd4-4bec-964c-a8d4d59379ac ↔ vtinfo fe17c6b1c4f20f10same address and namemerged15
2026-11-11 12:56insertab-inbev 4016157 ↔ ca-abc 00342510|21|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 4016157 ↔ overture 2aae7957-9dd4-4bec-964c-a8d4d59379acsame address and namemerged12
2026-11-06 18:13insertca-abc 00342510|21|LIC|0 ↔ overture 2aae7957-9dd4-4bec-964c-a8d4d59379acsame address and namemerged11