MAGPIES GRILL

LA CANADA FLINTRIDGE, CA 91011 · O736e6f900b2d · first seen 2026-10-08
4 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
MAGPIES GRILL 2 other
the most common name a source states
MAGPIE GRILL ca-abc
Magpie's Grill overture
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

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-11
ca-abcMAGPIE GRILL
00449246|47|LIC|0
1438 FOOTHILL BLVD, LA CANADA FLINTRIDGE, CA, 9101134.20860, -118.209402026-10-082026-11-06
overtureMagpie's Grill
d3ef304c-b71e-4ba8-bcc0-5d98dc52766e
1438 Foothill Blvd, La Canada Flintridge, CA, 91011818790234834.20841, -118.209852026-11-062026-11-06
vtinfoMAGPIES GRILL
b5f8140e3699c01f
1438 FOOTHILL BLVD, LA CANADA FLINTRIDGE, CA, 91011818790234834.20847, -118.209642026-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 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
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 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 7, computed 2026-11-16 17:18.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
81 within 1 mi · 249 within 3 mi
Off / on premise
19 / 55 within 1 mi · 61 / 157 within 3 mi
Selling alcohol
51 within 1 mi · 144 within 3 mi
Nearest
same channel 0.37 mi · licensed 0.10 mi
Setting
suburban (2,591 people per sq mi)
People within 3 mi
73,245 (53,580 adults 21+, 26,032 households) from 15 tract(s), tracts within 3 mi
Income
per capita $74,500 · median household ~$156,010 (weighted mean of tract medians)
Age and education
median age ~44.2 · bachelor's or higher 63%
Ethnicity
Hispanic 13% · White 56% · Black 1% · Asian 24%
Adults per alcohol outlet
370
Alcohol spend within 3 mi
$26,166,319 a year ($11,105,263 at home, $15,053,378 away) · $180,457 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: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