Outlets /
Lucky Baldwins Delirium Pub
SIERRA MADRE, CA 91024 · O07106039148e · first seen 2026-10-08
6 sourceson premise · restaurantchain: Lucky Baldwin's Pubalcohol: 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 | Lucky Baldwins Delirium Pub 4 other | a licence name in capitals, cleaned (derived; record_title.py) | DP ALES INC ca-abc (legal name) ×2 LUCKY BALDWINS DELIRIUM CAFE ab-inbevvtinfo ×2 Lucky Baldwin's Pub overture lucky baldwins sierra madre doordash |
| Street | 21 KERSTING CT 1 other | ca-abc | 21 Kersting Court doordash |
| City | SIERRA MADRE | ca-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 91024 1 other | ca-abc | 91029 inspections |
| Pin | 34.16215, -118.05330 map | doordash | no other value |
| Phone | 6263551140 | vtinfo | no other value |
| Licences | ca-abc 00424353|41|APP|0 · ca-abc 00424353|41|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: O97d9fb157add; Oaf8a3f21f47d; O25c00f70c02a; Ofdb58c2f1ef8; Oc0dc8da1980a; Oa5bbeba3e211
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 | LUCKY BALDWINS DELIRIUM CAFE 2933479 | 21 KERSTING CT, SIERRA MADRE, CA, 91024 | 34.16213, -118.05299 | 2026-11-11 | 2026-11-12 | |
| ca-abc | LUCKY BALDWINS DELIRIUM PUB legal name: DP ALES INC 00424353|41|APP|0 | 21 KERSTING CT, SIERRA MADRE, CA, 91024 | 34.16231, -118.05290 | 2026-10-08 | 2026-11-05 | |
| ca-abc | LUCKY BALDWINS DELIRIUM PUB legal name: DP ALES INC 00424353|41|LIC|0 | 21 KERSTING CT, SIERRA MADRE, CA, 91024 | 34.16231, -118.05290 | 2026-10-08 | 2026-11-05 | |
| doordash | lucky baldwins sierra madre 84878 | 21 Kersting Court, Sierra Madre, CA, 91024 | 34.16215, -118.05330 | 2026-10-08 | 2026-11-02 | |
| inspections | LUCKY BALDWINS DELIRIUM PUB inspections|la|FA0022956|PR0012434 | 21 KERSTING CT, Sierra Madre, CA, 91029 | 2026-11-19 | 2026-11-19 | ||
| overture | Lucky Baldwin's Pub 99c7770b-b479-4f90-b063-534ba0c8b065 | 21 Kersting Ct, Sierra Madre, CA, 91024 | 6263551140 | 34.16212, -118.05326 | 2026-11-06 | 2026-11-06 |
| vtinfo | LUCKY BALDWINS DELIRIUM CAFE fed2b5b0b6d8ca4f | 21 KERSTING CT, SIERRA MADRE, CA | 6263551140 | 34.16233, -118.05305 | 2026-11-11 | 2026-11-19 |
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 LUCKY BALDWINS DELIRIUM CAFE | vtinfo LUCKY BALDWINS DELIRIUM CAFE | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 23 m apart · name similarity 1.00 |
| ca-abc LUCKY BALDWINS DELIRIUM PUB | ca-abc LUCKY BALDWINS DELIRIUM PUB | 1.00 | one licence file | merged | file: 00424353 · same_address |
| ca-abc LUCKY BALDWINS DELIRIUM PUB | inspections LUCKY BALDWINS DELIRIUM PUB | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · name similarity 1.00 |
| ca-abc LUCKY BALDWINS DELIRIUM PUB | inspections LUCKY BALDWINS DELIRIUM PUB | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · name similarity 1.00 |
| doordash lucky baldwins sierra madre | overture Lucky Baldwin's Pub | 0.77 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.96 · same street + ZIP · pins 5 m apart · name similarity 0.77 |
| ab-inbev LUCKY BALDWINS DELIRIUM CAFE | ca-abc LUCKY BALDWINS DELIRIUM PUB | 0.72 | same address and name | merged | address similarity 1.00 · names match with these kind-of-place words set aside: cafe, pub · name Jaro-Winkler 0.90 · same street + ZIP · pins 22 m apart · name similarity 0.72 |
| ab-inbev LUCKY BALDWINS DELIRIUM CAFE | ca-abc LUCKY BALDWINS DELIRIUM PUB | 0.72 | same address and name | merged | address similarity 1.00 · names match with these kind-of-place words set aside: cafe, pub · name Jaro-Winkler 0.90 · same street + ZIP · pins 22 m apart · name similarity 0.72 |
| ab-inbev LUCKY BALDWINS DELIRIUM CAFE | inspections LUCKY BALDWINS DELIRIUM PUB | 0.72 | same address and name | merged | address similarity 1.00 · names match with these kind-of-place words set aside: cafe, pub · name Jaro-Winkler 0.90 · same street + city + state · name similarity 0.72 |
| ca-abc LUCKY BALDWINS DELIRIUM PUB | vtinfo LUCKY BALDWINS DELIRIUM CAFE | 0.72 | same address and name | merged | address similarity 1.00 · names match with these kind-of-place words set aside: cafe, pub · name Jaro-Winkler 0.90 · same street + city + state · pins 14 m apart · name similarity 0.72 |
| ca-abc LUCKY BALDWINS DELIRIUM PUB | vtinfo LUCKY BALDWINS DELIRIUM CAFE | 0.72 | same address and name | merged | address similarity 1.00 · names match with these kind-of-place words set aside: cafe, pub · name Jaro-Winkler 0.90 · same street + city + state · pins 14 m apart · name similarity 0.72 |
| inspections LUCKY BALDWINS DELIRIUM PUB | vtinfo LUCKY BALDWINS DELIRIUM CAFE | 0.72 | same address and name | merged | address similarity 1.00 · names match with these kind-of-place words set aside: cafe, pub · name Jaro-Winkler 0.90 · same street + city + state · name similarity 0.72 |
| ca-abc LUCKY BALDWINS DELIRIUM PUB | doordash lucky baldwins sierra madre | 0.59 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (88% confident; asked as a “near” pair) Both records name Lucky Baldwin's at 21 Kersting Ct, Sierra Madre 91024, the only business our data holds at that address, so the licensed restaurant/pub and the DoorDash listing are one operation. Other Claude answers on this pair:
pair 5c775c30c924f29fd2d3 |
| ca-abc LUCKY BALDWINS DELIRIUM PUB | doordash lucky baldwins sierra madre | 0.59 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (88% confident; asked as a “near” pair) Both records give the same street address, 21 Kersting Ct, Sierra Madre, and the same Lucky Baldwin's name, and only one business is known at that address, so this is one restaurant/pub. Other Claude answers on this pair:
pair 5a07dfcab6f2134d1fa1 |
| ab-inbev LUCKY BALDWINS DELIRIUM CAFE | doordash lucky baldwins sierra madre | 0.58 | Claude judge: same | merged | Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “near” pair) Lucky Baldwins distinctive name, same address Other Claude answers on this pair:
pair 08975245a34fec774c26 |
Attributes
- Channel
- on_premise · restaurant — ca-licence
- Chain
- Lucky Baldwin's Pub — overture-brand
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- DP ALES INC — 1 outlets in the master under this operator
- Licence privileges
- beer_on, beer_off, wine_on, wine_off — CA 41
Rule version 11, computed 2026-11-19 21:40.
Every vote behind these (raw)
{
"votes": [
[
"ca-licence",
"on_premise",
"restaurant"
],
[
"doordash-url",
"on_premise",
"restaurant"
],
[
"overture-category",
"on_premise",
"bar"
]
]
}Trade area
- Other outlets
- 32 within 1 mi · 642 within 3 mi
- Off / on premise
- 3 / 23 within 1 mi · 150 / 396 within 3 mi
- Selling alcohol
- 20 within 1 mi · 312 within 3 mi
- Nearest
- same channel 0.03 mi · licensed 0.03 mi
- Setting
- urban (3,878 people per sq mi)
- People within 3 mi
- 109,648 (84,419 adults 21+, 41,380 households) from 24 tract(s), tracts within 3 mi
- Income
- per capita $60,171 · median household ~$117,206 (weighted mean of tract medians)
- Age and education
- median age ~43.0 · bachelor's or higher 56%
- Ethnicity
- Hispanic 25% · White 34% · Black 4% · Asian 37%
- Adults per alcohol outlet
- 270
- Alcohol spend within 3 mi
- $35,741,288 a year ($15,609,115 at home, $20,118,685 away) · $114,189 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-19 20:37 | insert | inspections inspections|la|FA0022956|PR0012434 ↔ vtinfo fed2b5b0b6d8ca4f | same address and name | merged | 17 |
| 2026-11-19 20:37 | insert | ab-inbev 2933479 ↔ inspections inspections|la|FA0022956|PR0012434 | same address and name | merged | 17 |
| 2026-11-19 20:37 | insert | ca-abc 00424353|41|LIC|0 ↔ inspections inspections|la|FA0022956|PR0012434 | same address and name | merged | 17 |
| 2026-11-19 20:37 | insert | ca-abc 00424353|41|APP|0 ↔ inspections inspections|la|FA0022956|PR0012434 | same address and name | merged | 17 |
| 2026-11-12 17:29 | insert | ab-inbev 2933479 ↔ doordash 84878 | Claude judge: same | merged | 14 |
| 2026-11-12 17:29 | insert | ca-abc 00424353|41|LIC|0 ↔ vtinfo fed2b5b0b6d8ca4f | same address and name | merged | 14 |
| 2026-11-12 17:29 | insert | ca-abc 00424353|41|APP|0 ↔ vtinfo fed2b5b0b6d8ca4f | same address and name | merged | 14 |
| 2026-11-12 17:29 | insert | ab-inbev 2933479 ↔ ca-abc 00424353|41|LIC|0 | same address and name | merged | 14 |
| 2026-11-12 17:29 | insert | ab-inbev 2933479 ↔ ca-abc 00424353|41|APP|0 | same address and name | merged | 14 |
| 2026-11-11 12:56 | insert | ab-inbev 2933479 ↔ vtinfo fed2b5b0b6d8ca4f | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | doordash 84878 ↔ overture 99c7770b-b479-4f90-b063-534ba0c8b065 | same address and name | merged | 11 |
| 2026-11-02 23:02 | backfill | ca-abc 00424353|41|APP|0 ↔ doordash 84878 | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00424353|41|LIC|0 ↔ doordash 84878 | Claude judge: same | merged | |
| 2026-10-09 13:59 | backfill | ca-abc 00424353|41|APP|0 ↔ ca-abc 00424353|41|LIC|0 | one licence file | merged |