Canyon City Barbeque

AZUSA, CA 91702 · O1a339f44009f · first seen 2026-10-08
6 sourceson premise · restaurantchain: City Barbequealcohol: 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
Canyon City Barbeque 2 other
a source's own spelling of the licence name (record_title.py)
canyon city bbq azusa doordash
CANYON CITY FOODS INC ca-abc (legal name)
Street
347 N SAN GABRIEL AVE
ca-abcno other value
City
AZUSA
ca-abcno other value
State
CA
ca-abcno other value
ZIP
91702
ca-abcno other value
Pin
34.12793, -117.90907 map 2 other
doordash
88 m away ab-inbev
96 m away ca-abc
Phone
6268154227
vtinfono other value
Licences
ca-abc 00403936|41|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O4f31678e5dfa; O59713dc3e853; O464261dc5a81; O6fa8639814b7; O64d9e85754b3

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-inbevCANYON CITY BARBEQUE
1341273
347 N SAN GABRIEL AVE, AZUSA, CA, 9170234.12715, -117.908932026-11-112026-11-11
ca-abcCANYON CITY BARBEQUE
legal name: CANYON CITY FOODS INC
00403936|41|LIC|0
347 N SAN GABRIEL AVE, AZUSA, CA, 9170234.12708, -117.908922026-10-082026-11-11
doordashcanyon city bbq azusa
29501829
347 N San Gabriel Ave, Azusa, CA, 9170234.12793, -117.909072026-10-082026-11-10
inspectionsCANYON CITY BARBEQUE
inspections|la|FA0059120|PR0035072
347 N SAN GABRIEL AVE, Azusa, CA, 917022026-11-192026-11-19
overtureCanyon City Barbeque
5d72c8dd-8f00-4f3f-8d7b-b8688ada71fc
347 N San Gabriel Ave, Azusa, CA, 91702626815422734.12795, -117.909292026-11-062026-11-11
vtinfoCANYON CITY BARBEQUE
4fd3eccf6303a8da
347 N SAN GABRIEL AVE, AZUSA, CA, 91702626815422734.12790, -117.909142026-11-132026-11-13

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 CANYON CITY BARBEQUEca-abc CANYON CITY BARBEQUE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · name similarity 1.00
ab-inbev CANYON CITY BARBEQUEinspections CANYON CITY BARBEQUE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ab-inbev CANYON CITY BARBEQUEoverture Canyon City Barbeque1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 94 m apart · name similarity 1.00
ab-inbev CANYON CITY BARBEQUEvtinfo CANYON CITY BARBEQUE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 86 m apart · name similarity 1.00
ca-abc CANYON CITY BARBEQUEinspections CANYON CITY BARBEQUE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc CANYON CITY BARBEQUEoverture Canyon City Barbeque1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 102 m apart · name similarity 1.00
ca-abc CANYON CITY BARBEQUEvtinfo CANYON CITY BARBEQUE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 94 m apart · name similarity 1.00
inspections CANYON CITY BARBEQUEoverture Canyon City Barbeque1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
inspections CANYON CITY BARBEQUEvtinfo CANYON CITY BARBEQUE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
overture Canyon City Barbequevtinfo CANYON CITY BARBEQUE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 15 m apart · name similarity 1.00 · phone: equal
ca-abc CANYON CITY BARBEQUEdoordash canyon city bbq azusa0.68Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
Same street address and ZIP, and the slug 'canyon city bbq azusa' is Canyon City Barbeque plus the appended city, with only one business recorded at that address.
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 95% confident — Canyon City BBQ same address, same name.
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records sit at 347 N San Gabriel Ave, Azusa 91702, with the DoorDash slug 'canyon city bbq azusa' matching the California licensee's DBA 'Canyon City Barbecue' (legal entity Canyon City Foods Inc), and the licence type is an eating-place restaurant that fits the barbecue storefront; only one business is held at that address.
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records give the same street address, city and ZIP, and the names match (Canyon City Barbeque vs canyon city bbq azusa); the only business at that address is the same restaurant, with coordinates about 96 m apart.
pair 2f7638637f422fb28a94

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
City Barbeque — overture-brand
Alcohol
licensed — a licence or TTB permit on file
Operator
CANYON CITY FOODS 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",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
90 within 1 mi · 579 within 3 mi
Off / on premise
36 / 45 within 1 mi · 152 / 346 within 3 mi
Selling alcohol
59 within 1 mi · 305 within 3 mi
Nearest
same channel 0.09 mi · licensed 0.07 mi
Setting
urban (4,823 people per sq mi)
People within 3 mi
136,381 (101,127 adults 21+, 41,023 households) from 30 tract(s), tracts within 3 mi
Income
per capita $35,859 · median household ~$96,591 (weighted mean of tract medians)
Age and education
median age ~36.5 · bachelor's or higher 27%
Ethnicity
Hispanic 62% · White 26% · Black 4% · Asian 14%
Adults per alcohol outlet
330
Alcohol spend within 3 mi
$30,775,436 a year ($13,864,334 at home, $16,897,086 away) · $100,573 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-19 20:37insertca-abc 00403936|41|LIC|0 ↔ inspections inspections|la|FA0059120|PR0035072same address and namemerged17
2026-11-19 20:37insertab-inbev 1341273 ↔ inspections inspections|la|FA0059120|PR0035072same address and namemerged17
2026-11-19 20:37insertinspections inspections|la|FA0059120|PR0035072 ↔ overture 5d72c8dd-8f00-4f3f-8d7b-b8688ada71fcsame address and namemerged17
2026-11-19 20:37insertinspections inspections|la|FA0059120|PR0035072 ↔ vtinfo 4fd3eccf6303a8dasame address and namemerged17
2026-11-13 14:10insertca-abc 00403936|41|LIC|0 ↔ vtinfo 4fd3eccf6303a8dasame address and namemerged15
2026-11-13 14:10insertab-inbev 1341273 ↔ vtinfo 4fd3eccf6303a8dasame address and namemerged15
2026-11-13 14:10insertoverture 5d72c8dd-8f00-4f3f-8d7b-b8688ada71fc ↔ vtinfo 4fd3eccf6303a8dasame address and namemerged15
2026-11-11 12:56insertca-abc 00403936|41|LIC|0 ↔ doordash 29501829Claude judge: samemerged12
2026-11-11 12:56insertab-inbev 1341273 ↔ overture 5d72c8dd-8f00-4f3f-8d7b-b8688ada71fcsame address and namemerged12
2026-11-11 12:56insertab-inbev 1341273 ↔ ca-abc 00403936|41|LIC|0same address and namemerged12
2026-11-06 18:13insertca-abc 00403936|41|LIC|0 ↔ overture 5d72c8dd-8f00-4f3f-8d7b-b8688ada71fcsame address and namemerged11