A & D Liquor

Sylmar, CA 91342 · O25e36f181cb7 · first seen 2026-10-08
7 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
A & D Liquor 4 other
a source's own spelling of the licence name (record_title.py)
A & D Liquor Store ubereats ×3
A and D Liquor Store overture
A&D LIQUOR inspections
MACHHOUR YOUSEF NAIM ca-abc (legal name)
Street
11994 FOOTHILL BLVD 1 other
ca-abc
11960 FOOTHILL BLVD ab-inbevovertureubereatsvtinfo ×6
City
LAKEVIEW TERRACE 2 other
ca-abc
SYLMAR ab-inbevoverturesnapubereatsvtinfo ×7
Lake View Terrace inspections
State
CA
ca-abcno other value
ZIP
91342
ca-abcno other value
Pin
34.27612, -118.39715 map 3 other
ubereats
60 m away ab-inbev
75 m away overture
64 m away vtinfo
Phone
8188969101
vtinfono other value
Licences
ca-abc 00647759|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oac98bfd5cc4f; O6fe079917a00; Oe8fd9c4c6092; Oa1325176ec74; O593340412850; O7baba8a9472a; O2dcfb8a662f6; O5b8eeeda8acc

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-inbevA & D LIQUOR
530728
11960 FOOTHILL BLVD, SYLMAR, CA, 9134234.27559, -118.397272026-11-112026-11-19
ca-abcA & D LIQUOR
legal name: MACHHOUR YOUSEF NAIM
00647759|21|LIC|0
11994 FOOTHILL BLVD, LAKEVIEW TERRACE, CA, 91342
ZIP lookup: Sylmar, CA
34.27629, -118.397082026-10-082026-11-19
inspectionsA&D LIQUOR
inspections|la|FA0333756|PR0294501
11994 FOOTHILL BLVD, Lake View Terrace, CA, 91342
ZIP lookup: Sylmar, CA
2026-11-192026-11-19
overtureA and D Liquor Store
0ad1d43c-47c8-453c-9a70-e34b2784d5e4
11960 Foothill Blvd, Sylmar, CA, 91342818896910134.27571, -118.397802026-11-062026-11-19
snapA & D Liquor
snap|us|1103273
11994 Foothill Blvd, Sylmar, CA, 9134234.27630, -118.397402026-11-192026-11-19
ubereatsA & D Liquor Store
DFoXBYsYTiS81mdJzLQnCw
11960 Foothill Blvd, Sylmar, CA, 9134234.27612, -118.397152026-11-022026-11-19
ubereatsA & D Liquor Store
FMdebCyBQymZ74oHSR1_zw
11960 Foothill Blvd, Sylmar, CA, 9134234.27612, -118.397152026-10-272026-11-19
ubereatsA & D Liquor Store
XhtRTKwRRXORbRDynxgnNQ
11960 Foothill Blvd, Sylmar, CA, 9134234.27612, -118.397152026-11-142026-11-19
vtinfoA & D LIQUOR
3f17f21a9e0eee75
11960 FOOTHILL BLVD, SYLMAR, CA, 91342818896910134.27585, -118.397762026-11-122026-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 A & D LIQUORoverture A and D Liquor Store1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 50 m apart · name similarity 1.00
ab-inbev A & D LIQUORubereats A & D Liquor Store1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 60 m apart · name similarity 1.00
ab-inbev A & D LIQUORubereats A & D Liquor Store1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 60 m apart · name similarity 1.00
ab-inbev A & D LIQUORubereats A & D Liquor Store1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 60 m apart · name similarity 1.00
ab-inbev A & D LIQUORvtinfo A & D LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 54 m apart · name similarity 1.00
ca-abc A & D LIQUORinspections A&D LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc A & D LIQUORsnap A & D Liquor1.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 A & D LIQUORubereats A & D Liquor Store1.00Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (80% confident; asked as a “proximity” pair)
The distinctive independent name 'A & D Liquor' matches, with the same ZIP and coordinates 20 m apart; the small street-number gap (11994 vs 11960) and the Sylmar/Lakeview Terrace city labels are cons
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 80% confident — The names are nearly identical (A & D Liquor / A & D Liquor Store), the ZIPs match, the coordinates are about 20 m apart, and no other business is held at either address; the street numbers differ (11994 vs 11960), which keeps this from being certain.
pair 87660eca908ef9af1cc4
ca-abc A & D LIQUORubereats A & D Liquor Store1.00Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (80% confident; asked as a “proximity” pair)
A distinctive matching name, 'A & D Liquor', sits on the same Foothill Blvd block in the same ZIP only 20 m apart, so the 11994 vs 11960 street numbers look like address variation rather than a second
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 80% confident — The names match closely (A & D Liquor vs A & D Liquor Store), both are on Foothill Blvd in ZIP 91342, and the coordinates are only 0.02 km apart, though the street numbers differ (11994 vs 11960) and the Uber Eats city is Sylmar while the CA-ABC record says Lakeview Terrace.
pair 730a605a2dcff6d16f71
inspections A&D LIQUORsnap A & D Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
overture A and D Liquor Storeubereats A & D Liquor Store1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 75 m apart · name similarity 1.00
overture A and D Liquor Storeubereats A & D Liquor Store1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 75 m apart · name similarity 1.00
overture A and D Liquor Storeubereats A & D Liquor Store1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 75 m apart · name similarity 1.00
overture A and D Liquor Storevtinfo A & D LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 16 m apart · name similarity 1.00 · phone: equal
ubereats A & D Liquor Storeubereats A & D Liquor Store1.00one store listed twicemergedsame street + ZIP · name: identical
ubereats A & D Liquor Storeubereats A & D Liquor Store1.00one store listed twicemergedsame street + ZIP · name: identical
ubereats A & D Liquor Storevtinfo A & D LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 64 m apart · name similarity 1.00
ubereats A & D Liquor Storevtinfo A & D LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 64 m apart · name similarity 1.00
ubereats A & D Liquor Storevtinfo A & D LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 64 m apart · name similarity 1.00

Attributes

Channel
off_premise · liquor_store — ca-licence conflicting evidence
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)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

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|FA0333756|PR0294501 ↔ snap snap|us|1103273same address and namemerged17
2026-11-19 20:37insertca-abc 00647759|21|LIC|0 ↔ inspections inspections|la|FA0333756|PR0294501same address and namemerged17
2026-11-19 20:37insertca-abc 00647759|21|LIC|0 ↔ snap snap|us|1103273same address and namemerged17
2026-11-14 20:23insertubereats XhtRTKwRRXORbRDynxgnNQ ↔ vtinfo 3f17f21a9e0eee75same address and namemerged15
2026-11-14 20:23insertab-inbev 530728 ↔ ubereats XhtRTKwRRXORbRDynxgnNQsame address and namemerged15
2026-11-14 20:23insertoverture 0ad1d43c-47c8-453c-9a70-e34b2784d5e4 ↔ ubereats XhtRTKwRRXORbRDynxgnNQsame address and namemerged15
2026-11-14 20:23insertubereats DFoXBYsYTiS81mdJzLQnCw ↔ ubereats XhtRTKwRRXORbRDynxgnNQone store listed twicemerged15
2026-11-12 14:25insertubereats FMdebCyBQymZ74oHSR1_zw ↔ vtinfo 3f17f21a9e0eee75same address and namemerged12
2026-11-12 14:25insertab-inbev 530728 ↔ vtinfo 3f17f21a9e0eee75same address and namemerged12
2026-11-12 14:25insertoverture 0ad1d43c-47c8-453c-9a70-e34b2784d5e4 ↔ vtinfo 3f17f21a9e0eee75same address and namemerged12
2026-11-12 14:25insertubereats DFoXBYsYTiS81mdJzLQnCw ↔ vtinfo 3f17f21a9e0eee75same address and namemerged12
2026-11-11 12:56insertca-abc 00647759|21|LIC|0 ↔ ubereats DFoXBYsYTiS81mdJzLQnCwClaude judge: samemerged12
2026-11-11 12:56insertca-abc 00647759|21|LIC|0 ↔ ubereats FMdebCyBQymZ74oHSR1_zwClaude judge: samemerged12
2026-11-11 12:56insertab-inbev 530728 ↔ overture 0ad1d43c-47c8-453c-9a70-e34b2784d5e4same address and namemerged12
2026-11-11 12:56insertab-inbev 530728 ↔ ubereats DFoXBYsYTiS81mdJzLQnCwsame address and namemerged12
2026-11-11 12:56insertab-inbev 530728 ↔ ubereats FMdebCyBQymZ74oHSR1_zwsame address and namemerged12
2026-11-06 18:13insertoverture 0ad1d43c-47c8-453c-9a70-e34b2784d5e4 ↔ ubereats DFoXBYsYTiS81mdJzLQnCwsame address and namemerged11
2026-11-06 18:13insertoverture 0ad1d43c-47c8-453c-9a70-e34b2784d5e4 ↔ ubereats FMdebCyBQymZ74oHSR1_zwsame address and namemerged11
2026-11-03 13:33backfillubereats DFoXBYsYTiS81mdJzLQnCw ↔ ubereats FMdebCyBQymZ74oHSR1_zwone store listed twicemerged