Outlets /
Blue Magpie
ARCADIA, CA 91007 · O6e2eefd0bb07 · 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.
| Field | Master value | Taken from | What other sources say |
|---|---|---|---|
| Name | Blue Magpie 2 other | the most common name a source states | blue magpie 41 w huntington dr arcadia doordash BLUE MAGPIE LLC ca-abc |
| Street | 41 W HUNTINGTON DR | ca-abc | no other value |
| City | ARCADIA | ca-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 91007 | ca-abc | no other value |
| Pin | 34.14022, -118.03332 map | doordash | no other value |
| Phone | 6263175171 | vtinfo | no other value |
| Licences | ca-abc 00655020|47|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: O6e46e2a5fb53; O84f7205fa52c; O754dead5d4e1
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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ca-abc | BLUE MAGPIE LLC 00655020|47|LIC|0 | 41 W HUNTINGTON DR, ARCADIA, CA, 91007 | 34.14009, -118.03309 | 2026-10-08 | 2026-11-04 | |
| doordash | blue magpie 41 w huntington dr arcadia 35311161 | 41 W Huntington Dr, Arcadia, CA, 91007 | 34.14022, -118.03332 | 2026-10-08 | 2026-10-15 | |
| overture | Blue Magpie 7c8041d0-a082-429f-999c-94370fd3c2d3 | 41 W Huntington Dr, Arcadia, CA, 91007 | 6263175171 | 34.14027, -118.03332 | 2026-11-06 | 2026-11-06 |
| vtinfo | BLUE MAGPIE 538dc23368e85289 | 41 W HUNTINGTON DR, ARCADIA, CA, 91007 | 6263175171 | 34.14028, -118.03327 | 2026-11-12 | 2026-11-12 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ca-abc BLUE MAGPIE LLC | overture Blue Magpie | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 29 m apart · name similarity 1.00 |
| ca-abc BLUE MAGPIE LLC | vtinfo BLUE MAGPIE | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 27 m apart · name similarity 1.00 |
| overture Blue Magpie | vtinfo BLUE MAGPIE | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00 · phone: equal |
| ca-abc BLUE MAGPIE LLC | doordash blue magpie 41 w huntington dr arcadia | 0.43 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “same-address” pair) The names match (Blue Magpie LLC and the 'blue magpie' slug) at the identical address 41 W Huntington Dr, Arcadia 91007, and our data holds only one business at that address. Other Claude answers on this pair:
pair 9b9665fc17e50c86d713 |
Attributes
- Channel
- on_premise · restaurant — ca-licence
- Chain
- none
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- BLUE MAGPIE LLC — 1 outlets in the master under this operator
- Licence privileges
- beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47
Rule version 9, computed 2026-11-17 18:22.
Every vote behind these (raw)
{
"votes": [
[
"ca-licence",
"on_premise",
"restaurant"
],
[
"doordash-url",
"on_premise",
"restaurant"
],
[
"overture-category",
"on_premise",
"restaurant"
]
]
}Trade area
- Other outlets
- 183 within 1 mi · 868 within 3 mi
- Off / on premise
- 40 / 108 within 1 mi · 182 / 531 within 3 mi
- Selling alcohol
- 94 within 1 mi · 426 within 3 mi
- Nearest
- same channel 0.12 mi · licensed 0.05 mi
- Setting
- urban (5,191 people per sq mi)
- People within 3 mi
- 146,767 (112,817 adults 21+, 52,440 households) from 32 tract(s), tracts within 3 mi
- Income
- per capita $52,551 · median household ~$106,859 (weighted mean of tract medians)
- Age and education
- median age ~42.6 · bachelor's or higher 50%
- Ethnicity
- Hispanic 30% · White 26% · Black 3% · Asian 41%
- Adults per alcohol outlet
- 264
- Alcohol spend within 3 mi
- $42,880,195 a year ($18,917,976 at home, $23,945,650 away) · $100,422 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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-12 14:25 | insert | ca-abc 00655020|47|LIC|0 ↔ vtinfo 538dc23368e85289 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | overture 7c8041d0-a082-429f-999c-94370fd3c2d3 ↔ vtinfo 538dc23368e85289 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | ca-abc 00655020|47|LIC|0 ↔ overture 7c8041d0-a082-429f-999c-94370fd3c2d3 | same address and name | merged | 11 |
| 2026-11-02 23:02 | backfill | ca-abc 00655020|47|LIC|0 ↔ doordash 35311161 | Claude judge: same | merged |