GUS BBQ

CLAREMONT, CA 91711 · O1b120c4bd9a2 · 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.

FieldMaster valueTaken fromWhat other sources say
Name
GUS BBQ 3 other
the most common name a source states
GUS'S BBQ ca-abcoverture ×2
gus's barbecue claremont doordash
GUS'S BBQ 2 INC. ca-abc (legal name)
Street
500 W 1ST ST 1 other
ca-abc
500 West 1st Street doordash
City
CLAREMONT
ca-abcno other value
State
CA
ca-abcno other value
ZIP
91711
ca-abcno other value
Pin
34.09441, -117.72095 map
doordashno other value
Phone
9094450931
vtinfono other value
Licences
ca-abc 00592001|47|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O71d8b6d16694; O287d66f61b8e; Ocde0f1a77291

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-abcGUS'S BBQ
legal name: GUS'S BBQ 2 INC.
00592001|47|LIC|0
500 W 1ST ST, CLAREMONT, CA, 9171134.09451, -117.720732026-10-082026-11-05
doordashgus's barbecue claremont
456535
500 West 1st Street, Claremont, CA, 9171134.09441, -117.720952026-10-082026-11-06
overtureGus's BBQ
ea4c9c93-30ef-4c6d-9640-b5f3bfca60df
500 W 1st St, Claremont, CA, 91711909445093134.09442, -117.721002026-11-062026-11-06
vtinfoGUS BBQ
4ab68cf22fb0ecd2
500 W 1ST ST, CLAREMONT, CA, 91711909445093134.09448, -117.721352026-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
ca-abc GUS'S BBQoverture Gus's BBQ1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 27 m apart · name similarity 1.00
ca-abc GUS'S BBQvtinfo GUS BBQ0.63same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.97 · same street + city + state · pins 57 m apart · name similarity 0.63
overture Gus's BBQvtinfo GUS BBQ0.63same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.97 · same street + city + state · pins 33 m apart · name similarity 0.63 · phone: equal
ca-abc GUS'S BBQdoordash gus's barbecue claremont0.50Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
Both records are Gus's BBQ at 500 W 1st St, Claremont 91711, about 23 m apart, with only one business known at the address; the DoorDash slug simply adds the city to the licensed restaurant's name.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records sit at 500 W 1st St, Claremont CA 91711 with coordinates about 23 m apart, the only business at that address is in our data, and the names match (Gus's BBQ / Gus's Barbecue); the CA licence is an active on-sale eating-place licence for the same restaurant.
pair d6a675d6edd4293d555e

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
GUS'S BBQ 2 INC. — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47
Rule version 7, computed 2026-11-16 17:15.
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
122 within 1 mi · 816 within 3 mi
Off / on premise
13 / 89 within 1 mi · 208 / 493 within 3 mi
Selling alcohol
71 within 1 mi · 445 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
urban (5,896 people per sq mi)
People within 3 mi
166,706 (121,336 adults 21+, 52,884 households) from 36 tract(s), tracts within 3 mi
Income
per capita $36,471 · median household ~$93,101 (weighted mean of tract medians)
Age and education
median age ~37.2 · bachelor's or higher 31%
Ethnicity
Hispanic 58% · White 29% · Black 7% · Asian 10%
Adults per alcohol outlet
272
Alcohol spend within 3 mi
$38,048,796 a year ($17,265,635 at home, $20,765,825 away) · $85,311 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:25insertoverture ea4c9c93-30ef-4c6d-9640-b5f3bfca60df ↔ vtinfo 4ab68cf22fb0ecd2same address and namemerged12
2026-11-12 14:25insertca-abc 00592001|47|LIC|0 ↔ vtinfo 4ab68cf22fb0ecd2same address and namemerged12
2026-11-06 18:13insertca-abc 00592001|47|LIC|0 ↔ doordash 456535Claude judge: samemerged11
2026-11-06 18:13insertca-abc 00592001|47|LIC|0 ↔ overture ea4c9c93-30ef-4c6d-9640-b5f3bfca60dfsame address and namemerged11