Outlets /
The Local Shoppe
MADERA, CA 93637 · O3963c17fd621 · first seen 2026-10-08
3 sourcesoff premisealcohol: licensed2 licences
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 | The Local Shoppe 3 other | a licence name in capitals, cleaned (derived; record_title.py) | AAHIL ENTERPRISES INC ca-abc (legal name) ×2 LOCAL SHOPPE THE ca-abc ×2 the local shoppe madera doordash |
| Street | 1488 S MADERA AVE | ca-abc | no other value |
| City | MADERA | ca-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 93637 | ca-abc | no other value |
| Pin | 36.93860, -120.05673 map 2 other | doordash | 933 m away ca-abc ×2 65 m away ab-inbev |
| Phone | none | no other value | |
| Licences | ca-abc 00452751|21|APP|0 · ca-abc 00452751|21|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Of42d92ca05bb; Ocf7f9bf92757; O9d4326d0eb86
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 |
|---|---|---|---|---|---|---|
| ab-inbev | THE LOCAL SHOPPE 4722807 | 1488 S MADERA AVE, MADERA, CA, 93637 | 36.93885, -120.05607 | 2026-11-11 | 2026-11-11 | |
| ca-abc | LOCAL SHOPPE THE legal name: AAHIL ENTERPRISES INC 00452751|21|APP|0 | 1488 S MADERA AVE, MADERA, CA, 93637 | 36.94697, -120.05609 | 2026-10-08 | 2026-11-05 | |
| ca-abc | LOCAL SHOPPE THE legal name: AAHIL ENTERPRISES INC 00452751|21|LIC|0 | 1488 S MADERA AVE, MADERA, CA, 93637 | 36.94697, -120.05609 | 2026-10-08 | 2026-11-05 | |
| doordash | the local shoppe madera 42325639 | 1488 S Madera Ave, Madera, CA, 93637 | 36.93860, -120.05673 | 2026-10-08 | 2026-11-03 |
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 |
|---|---|---|---|---|---|
| ab-inbev THE LOCAL SHOPPE | ca-abc LOCAL SHOPPE THE | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 903 m apart · name similarity 1.00 |
| ab-inbev THE LOCAL SHOPPE | ca-abc LOCAL SHOPPE THE | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 903 m apart · name similarity 1.00 |
| ab-inbev THE LOCAL SHOPPE | doordash the local shoppe madera | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 65 m apart · name similarity 1.00 |
| ca-abc LOCAL SHOPPE THE | ca-abc LOCAL SHOPPE THE | 1.00 | one licence file | merged | file: 00452751 · same_address |
| ca-abc LOCAL SHOPPE THE | doordash the local shoppe madera | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 933 m apart · name similarity 1.00 |
| ca-abc LOCAL SHOPPE THE | doordash the local shoppe madera | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 933 m apart · name similarity 1.00 |
Attributes
- Channel
- off_premise — ca-licence
- Chain
- none
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- AAHIL ENTERPRISES INC — 1 outlets in the master under this operator
- Licence privileges
- beer_off, wine_off, spirits_off — CA 21
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
"votes": [
[
"ca-licence",
"off_premise",
null
],
[
"doordash-url",
"off_premise",
null
]
]
}Trade area
- Other outlets
- 29 within 1 mi · 247 within 3 mi
- Off / on premise
- 13 / 12 within 1 mi · 85 / 117 within 3 mi
- Selling alcohol
- 16 within 1 mi · 140 within 3 mi
- Nearest
- same channel 0.02 mi · licensed 0.05 mi
- Setting
- suburban (2,358 people per sq mi)
- People within 3 mi
- 66,673 (42,766 adults 21+, 17,317 households) from 14 tract(s), tracts within 3 mi
- Income
- per capita $24,424 · median household ~$64,712 (weighted mean of tract medians)
- Age and education
- median age ~30.0 · bachelor's or higher 11%
- Ethnicity
- Hispanic 82% · White 23% · Black 3% · Asian 1%
- Adults per alcohol outlet
- 303
- Alcohol spend within 3 mi
- $9,605,204 a year ($4,573,716 at home, $5,027,714 away) · $68,122 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-11 12:56 | insert | ab-inbev 4722807 ↔ ca-abc 00452751|21|APP|0 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 4722807 ↔ doordash 42325639 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 4722807 ↔ ca-abc 00452751|21|LIC|0 | same address and name | merged | 12 |
| 2026-11-03 13:33 | backfill | ca-abc 00452751|21|LIC|0 ↔ doordash 42325639 | same address and name | merged | |
| 2026-11-03 13:33 | backfill | ca-abc 00452751|21|APP|0 ↔ doordash 42325639 | same address and name | merged | |
| 2026-10-09 13:59 | backfill | ca-abc 00452751|21|APP|0 ↔ ca-abc 00452751|21|LIC|0 | one licence file | merged |