Rotten Robbie

Campbell, CA 95008 · O0ea8d7d8366f · first seen 2026-10-08
7 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 4 other
a source's own spelling of the licence name (record_title.py)
ROTTEN ROBBIE 3 ca-abcsnap ×2
ROBINSON OIL CORPORATION ca-abc (legal name)
ROTTEN ROBBIE #3 ca-tobacco
Rotten Robbie - 370 E. Hamilton Ave. ubereats
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; O6b72d51249bf; O14c7f28e46ac

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-20
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-20
ca-tobaccoROTTEN ROBBIE #3
ca-tobacco|091205706
370 E HAMILTON AVE, Campbell, CA, 9500837.29414, -121.943092026-11-202026-11-22
overtureRotten Robbie
d34197e4-b1be-4c7e-b903-275948a81315
370 E Hamilton Ave, Campbell, CA, 95008408378361137.29406, -121.943252026-11-132026-11-20
snapRotten Robbie 3
snap|us|1115293
370 E Hamilton Ave, Campbell, CA, 9500837.29424, -121.943202026-11-192026-11-20
ubereatsRotten Robbie - 370 E. Hamilton Ave.
aJcFEjdUW8K2RmZPYUJTMA
370 E. Hamilton Ave., Campbell, CA, 9500837.29402, -121.943302026-11-072026-11-20
vtinfoROTTEN ROBBIE
d64320a986e04b9d
370 E HAMILTON AVE, CAMPBELL, CA, 95008408378361137.29398, -121.943282026-11-112026-11-20

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 ROBBIEca-tobacco ROTTEN ROBBIE #31.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
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 ROBBIEsnap Rotten Robbie 31.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 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
ca-abc ROTTEN ROBBIE 3ca-tobacco ROTTEN ROBBIE #31.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc ROTTEN ROBBIE 3overture Rotten Robbie1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 17 m apart · name similarity 1.00
ca-abc ROTTEN ROBBIE 3snap Rotten Robbie 31.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 14 m apart · name similarity 1.00
ca-tobacco ROTTEN ROBBIE #3overture Rotten Robbie1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-tobacco ROTTEN ROBBIE #3snap Rotten Robbie 31.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-tobacco ROTTEN ROBBIE #3vtinfo ROTTEN ROBBIE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
overture Rotten Robbiesnap Rotten Robbie 31.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 20 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
snap Rotten Robbie 3vtinfo ROTTEN ROBBIE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 30 m apart · name similarity 1.00
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 v9: same, 90% confident — Both records sit at 370 E Hamilton Ave, Campbell CA 95008, and the Uber Eats listing 'Rotten Robbie' matches the California off-sale store licence filed as 'ROTTEN ROBBIE 3' under legal entity ROBINSON OIL CORPORATION, with coordinates about 23 m apart; the suite-number field is absent, so the single-building concern is minor.
  • 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 11, computed 2026-11-20 23:32.
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"
  ]
 ]
}

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-20 22:08insertca-abc 00373722|20|LIC|0 ↔ ca-tobacco ca-tobacco|091205706same address and namemerged17
2026-11-20 22:08insertab-inbev 2144598 ↔ ca-tobacco ca-tobacco|091205706same address and namemerged17
2026-11-20 22:08insertca-tobacco ca-tobacco|091205706 ↔ snap snap|us|1115293same address and namemerged17
2026-11-20 22:08insertab-inbev 2144598 ↔ snap snap|us|1115293same address and namemerged17
2026-11-20 22:08insertca-tobacco ca-tobacco|091205706 ↔ vtinfo d64320a986e04b9dsame address and namemerged17
2026-11-20 22:08insertsnap snap|us|1115293 ↔ vtinfo d64320a986e04b9dsame address and namemerged17
2026-11-20 22:08insertca-tobacco ca-tobacco|091205706 ↔ overture d34197e4-b1be-4c7e-b903-275948a81315same address and namemerged17
2026-11-20 22:08insertca-abc 00373722|20|LIC|0 ↔ overture d34197e4-b1be-4c7e-b903-275948a81315same address and namemerged17
2026-11-20 22:08insertoverture d34197e4-b1be-4c7e-b903-275948a81315 ↔ snap snap|us|1115293same address and namemerged17
2026-11-19 20:37insertca-abc 00373722|20|LIC|0 ↔ snap snap|us|1115293same address and namemerged17
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