Broderick Roadhouse

WALNUT CREEK, CA 94596 · O5a744c9d7f96 · first seen 2026-10-08
3 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
Broderick Roadhouse 2 other
a licence name in capitals, cleaned (derived; record_title.py)
broderick roadhouse walnut creek doordash
BRODERICK WC ca-abc
Street
1548 BONANZA ST 1 other
ca-abc
1548 Bonanza Street doordash
City
WALNUT CREEK
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94596
ca-abcno other value
Pin
37.89980, -122.06223 map
doordashno other value
Phone
9259456960
vtinfono other value
Licences
ca-abc 00572534|47|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O8b9c9ecb6b58; O92d7eff5ec0f

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
ca-abcBRODERICK WC
00572534|47|LIC|0
1548 BONANZA ST, WALNUT CREEK, CA, 9459637.89977, -122.061972026-10-082026-11-11
doordashbroderick roadhouse walnut creek
175297
1548 Bonanza Street, Walnut Creek, CA, 9459637.89980, -122.062232026-10-082026-11-10
vtinfoBRODERICK ROADHOUSE
579baf2f5550ec3f
1548 BONANZA ST, WALNUT CREEK, CA, 94596925945696037.89978, -122.062242026-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
doordash broderick roadhouse walnut creekvtinfo BRODERICK ROADHOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 3 m apart · name similarity 1.00
ca-abc BRODERICK WCdoordash broderick roadhouse walnut creek0.49Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
The records share one street address, the name 'Broderick' with 'WC' standing for Walnut Creek, and a restaurant licence that matches Broderick Roadhouse, and our data holds only one business at that
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 86% confident — Both records sit at 1548 Bonanza St, Walnut Creek 94596, the only business held at that address, and the 'BRODERICK WC' ABC licence (active on-sale restaurant with full bar) matches the DoorDash slug 'broderick roadhouse walnut creek'; the name is a plausible abbreviation of the same operation.
pair 62651d6657617fe54f6c

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:42.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
302 within 1 mi · 508 within 3 mi
Off / on premise
43 / 213 within 1 mi · 105 / 313 within 3 mi
Selling alcohol
205 within 1 mi · 354 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
urban (3,609 people per sq mi)
People within 3 mi
102,035 (82,102 adults 21+, 45,585 households) from 24 tract(s), tracts within 3 mi
Income
per capita $84,854 · median household ~$149,498 (weighted mean of tract medians)
Age and education
median age ~44.6 · bachelor's or higher 68%
Ethnicity
Hispanic 13% · White 64% · Black 2% · Asian 16%
Adults per alcohol outlet
231
Alcohol spend within 3 mi
$44,580,033 a year ($19,036,361 at home, $25,530,168 away) · $125,578 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:25insertdoordash 175297 ↔ vtinfo 579baf2f5550ec3fsame address and namemerged12
2026-11-11 12:56insertca-abc 00572534|47|LIC|0 ↔ doordash 175297Claude judge: samemerged12