ROTTEN ROBBIE

CAMPBELL, CA 95008 · O14c7f28e46ac · first seen 2026-10-08
5 sourcesoff premise · conveniencechain: Lula Conveniencealcohol: 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
ROTTEN ROBBIE 3 other
the most common name a source states
ROBINSON OIL CORPORATION ca-abc (legal name)
Rotten Robbie - 370 E. Hamilton Ave. ubereats
ROTTEN ROBBIE 3 ca-abc
Street
370 E HAMILTON AVE
ca-abcno other value
City
CAMPBELL
ca-abcno other value
State
CA
ca-abcno other value
ZIP
95008
ca-abcno other value
Pin
37.29402, -121.94330 map
ubereatsno other value
Phone
4083783611
vtinfono other value
Licences
ca-abc 00373722|20|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Od29cf857c36e; Off68d9f57159; Oa6066fa51840; O429cf11b22c2

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-inbevROTTEN ROBBIE
2144598
370 E HAMILTON AVE, CAMPBELL, CA, 9500837.29424, -121.943282026-11-112026-11-16
ca-abcROTTEN ROBBIE 3
legal name: ROBINSON OIL CORPORATION
00373722|20|LIC|0
370 E HAMILTON AVE, CAMPBELL, CA, 9500837.29414, -121.943092026-10-082026-11-11
overtureRotten Robbie
d34197e4-b1be-4c7e-b903-275948a81315
370 E Hamilton Ave, Campbell, CA, 95008408378361137.29406, -121.943252026-11-132026-11-16
ubereatsRotten Robbie - 370 E. Hamilton Ave.
aJcFEjdUW8K2RmZPYUJTMA
370 E. Hamilton Ave., Campbell, CA, 9500837.29402, -121.943302026-11-072026-11-07
vtinfoROTTEN ROBBIE
d64320a986e04b9d
370 E HAMILTON AVE, CAMPBELL, CA, 95008408378361137.29398, -121.943282026-11-112026-11-16

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 ROTTEN ROBBIEoverture Rotten Robbie1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 20 m apart · name similarity 1.00
ab-inbev ROTTEN ROBBIEvtinfo ROTTEN ROBBIE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 29 m apart · name similarity 1.00
overture Rotten Robbievtinfo ROTTEN ROBBIE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 9 m apart · name similarity 1.00 · phone: equal
ab-inbev ROTTEN ROBBIEca-abc ROTTEN ROBBIE 30.80one name contains the other, same addressmergedjudge: None · pair_id: d4ae40401a244dfcf315 · person: None · rule: names contained at one address · stratum: near
ca-abc ROTTEN ROBBIE 3vtinfo ROTTEN ROBBIE0.80one name contains the other, same addressmergedjudge: None · pair_id: 60fbbc9de8390ebf834a · person: None · rule: names contained at one address · stratum: near
ca-abc ROTTEN ROBBIE 3ubereats Rotten Robbie - 370 E. Hamilton Ave.0.46Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
Both records are Rotten Robbie at the same street address, 370 E Hamilton Ave, Campbell 95008, which our data shows has only one business. The CA licence is off-sale beer and wine, consistent with a c
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records sit at 370 E Hamilton Ave, Campbell 95008 with matching coordinates within about 23 metres, the only business at that address, and the Uber Eats name 'Rotten Robbie' matches the California off-sale licence name 'ROTTEN ROBBIE 3' for the same premises.
pair 953abd923df2d1f3a785
ab-inbev ROTTEN ROBBIEubereats Rotten Robbie - 370 E. Hamilton Ave.0.46one name contains the other, same addressmergedjudge: None · pair_id: 504e704746826a465916 · person: None · rule: names contained at one address · stratum: near
ubereats Rotten Robbie - 370 E. Hamilton Ave.vtinfo ROTTEN ROBBIE0.46one name contains the other, same addressmergedjudge: None · pair_id: 5bc1df60316342747bed · person: None · rule: names contained at one address · stratum: near

Attributes

Channel
off_premise · convenience — ca-licence
Chain
Lula Convenience — ubereats-parent
Alcohol
licensed — a licence or TTB permit on file
Operator
ROBINSON OIL CORPORATION — 23 outlets in the master under this operator
Licence privileges
beer_off, wine_off — CA 20
Rule version 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "ubereats-type",
   "off_premise",
   "convenience"
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
232 within 1 mi · 1,208 within 3 mi
Off / on premise
44 / 145 within 1 mi · 264 / 748 within 3 mi
Selling alcohol
131 within 1 mi · 650 within 3 mi
Nearest
same channel 0.04 mi · licensed 0.02 mi
Setting
urban (8,645 people per sq mi)
People within 3 mi
244,426 (186,171 adults 21+, 94,616 households) from 51 tract(s), tracts within 3 mi
Income
per capita $83,918 · median household ~$154,290 (weighted mean of tract medians)
Age and education
median age ~39.4 · bachelor's or higher 57%
Ethnicity
Hispanic 24% · White 42% · Black 3% · Asian 28%
Adults per alcohol outlet
286
Alcohol spend within 3 mi
$94,654,214 a year ($40,173,514 at home, $54,452,638 away) · $145,398 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-16 14:56insertubereats aJcFEjdUW8K2RmZPYUJTMA ↔ vtinfo d64320a986e04b9done name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 2144598 ↔ ubereats aJcFEjdUW8K2RmZPYUJTMAone name contains the other, same addressmerged15
2026-11-16 14:56insertca-abc 00373722|20|LIC|0 ↔ vtinfo d64320a986e04b9done name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 2144598 ↔ ca-abc 00373722|20|LIC|0one name contains the other, same addressmerged15
2026-11-13 14:10insertoverture d34197e4-b1be-4c7e-b903-275948a81315 ↔ vtinfo d64320a986e04b9dsame address and namemerged15
2026-11-13 14:10insertab-inbev 2144598 ↔ overture d34197e4-b1be-4c7e-b903-275948a81315same address and namemerged15
2026-11-11 12:56insertca-abc 00373722|20|LIC|0 ↔ ubereats aJcFEjdUW8K2RmZPYUJTMAClaude judge: samemerged12
2026-11-11 12:56insertab-inbev 2144598 ↔ vtinfo d64320a986e04b9dsame address and namemerged12