Magpie's Grill

LA CANADA FLINTRIDGE, CA 91011 · O2552ef7167e1 · first seen 2026-10-08
5 sourceson premise · restaurantalcohol: 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
Magpie's Grill 2 other
a source's own spelling of the licence name (record_title.py)
MAGPIES GRILL ab-inbevvtinfo ×2
MAGPIE GRILL ca-abc
Street
1438 FOOTHILL BLVD
ca-abcno other value
City
LA CANADA FLINTRIDGE
ca-abcno other value
State
CA
ca-abcno other value
ZIP
91011
ca-abcno other value
Pin
34.20841, -118.20985 map
overtureno other value
Phone
8187902348
vtinfono other value
Licences
ca-abc 00449246|47|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O789e35e8d3f9; O8c4e31a1aa3e; Of60b932361bb; O736e6f900b2d

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-inbevMAGPIES GRILL
536722
1438 FOOTHILL BLVD, LA CANADA FLINTRIDGE, CA, 9101134.20870, -118.209652026-11-112026-11-19
ca-abcMAGPIE GRILL
00449246|47|LIC|0
1438 FOOTHILL BLVD, LA CANADA FLINTRIDGE, CA, 9101134.20860, -118.209402026-10-082026-11-19
inspectionsMAGPIE'S GRILL
inspections|la|FA0306587|PR0264692
1438 FOOTHILL BLVD, La Canada Flintridge, CA, 910112026-11-192026-11-19
overtureMagpie's Grill
d3ef304c-b71e-4ba8-bcc0-5d98dc52766e
1438 Foothill Blvd, La Canada Flintridge, CA, 91011818790234834.20841, -118.209852026-11-062026-11-19
vtinfoMAGPIES GRILL
b5f8140e3699c01f
1438 FOOTHILL BLVD, LA CANADA FLINTRIDGE, CA, 91011818790234834.20847, -118.209642026-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 MAGPIES GRILLinspections MAGPIE'S GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ab-inbev MAGPIES GRILLoverture Magpie's Grill1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 37 m apart · name similarity 1.00
ab-inbev MAGPIES GRILLvtinfo MAGPIES GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 25 m apart · name similarity 1.00
inspections MAGPIE'S GRILLoverture Magpie's Grill1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
inspections MAGPIE'S GRILLvtinfo MAGPIES GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
overture Magpie's Grillvtinfo MAGPIES GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 20 m apart · name similarity 1.00 · phone: equal
ab-inbev MAGPIES GRILLca-abc MAGPIE GRILL0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 26 m apart · name similarity 0.65
ca-abc MAGPIE GRILLinspections MAGPIE'S GRILL0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · name similarity 0.65
ca-abc MAGPIE GRILLoverture Magpie's Grill0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 46 m apart · name similarity 0.65
ca-abc MAGPIE GRILLvtinfo MAGPIES GRILL0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · pins 26 m apart · name similarity 0.65

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47
Rule version 11, computed 2026-11-19 21:40.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

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:37insertca-abc 00449246|47|LIC|0 ↔ inspections inspections|la|FA0306587|PR0264692same address and namemerged17
2026-11-19 20:37insertab-inbev 536722 ↔ inspections inspections|la|FA0306587|PR0264692same address and namemerged17
2026-11-19 20:37insertinspections inspections|la|FA0306587|PR0264692 ↔ overture d3ef304c-b71e-4ba8-bcc0-5d98dc52766esame address and namemerged17
2026-11-19 20:37insertinspections inspections|la|FA0306587|PR0264692 ↔ vtinfo b5f8140e3699c01fsame address and namemerged17
2026-11-12 14:25insertca-abc 00449246|47|LIC|0 ↔ vtinfo b5f8140e3699c01fsame address and namemerged12
2026-11-12 14:25insertab-inbev 536722 ↔ vtinfo b5f8140e3699c01fsame address and namemerged12
2026-11-12 14:25insertoverture d3ef304c-b71e-4ba8-bcc0-5d98dc52766e ↔ vtinfo b5f8140e3699c01fsame address and namemerged12
2026-11-11 12:56insertab-inbev 536722 ↔ ca-abc 00449246|47|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 536722 ↔ overture d3ef304c-b71e-4ba8-bcc0-5d98dc52766esame address and namemerged12
2026-11-06 18:13insertca-abc 00449246|47|LIC|0 ↔ overture d3ef304c-b71e-4ba8-bcc0-5d98dc52766esame address and namemerged11