ROTTEN ROBBIE

SANTA CLARA, CA 95054 · O11a7d41a573e · first seen 2026-10-08
6 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
the most common name a source states
ROBINSON OIL CORPORATION ca-abc (legal name)
Rotten Robbie - 3471 Lafayette St. ubereats
ROTTEN ROBBIE 33 ca-abc
rotten robbie santa clara doordash
Street
3471 LAFAYETTE ST 1 other
ca-abc
3471 Lafayette Street doordash
City
SANTA CLARA
ca-abcno other value
State
CA
ca-abcno other value
ZIP
95054
ca-abcno other value
Pin
37.38369, -121.95027 map 2 other
ubereats
62 m away ab-inbev
86 m away ca-abc
Phone
4089885407
vtinfono other value
Licences
ca-abc 00373724|20|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc5ff740fbc6a; Obee107888c2f; O4f62a1ce9d6f; O2cd4a8aafdb0; O1a584ad42f4c

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
2353912
3471 LAFAYETTE ST, SANTA CLARA, CA, 9505437.38356, -121.950952026-11-112026-11-11
ca-abcROTTEN ROBBIE 33
legal name: ROBINSON OIL CORPORATION
00373724|20|LIC|0
3471 LAFAYETTE ST, SANTA CLARA, CA, 9505437.38387, -121.951222026-10-082026-11-11
doordashrotten robbie santa clara
24650774
3471 Lafayette Street, Santa Clara, CA, 9505437.38372, -121.950272026-10-082026-11-11
overtureRotten Robbie
66f4a81b-6344-40d6-a8f4-a2d15b7e91ea
3471 Lafayette St, Santa Clara, CA, 95054408988540737.38357, -121.950582026-11-062026-11-11
ubereatsRotten Robbie - 3471 Lafayette St.
j1vt_IokXHCCISZj4GVsjg
3471 Lafayette St, Santa Clara, CA, 9505437.38369, -121.950272026-11-072026-11-07
vtinfoROTTEN ROBBIE
7f6c96efb4dbd9a6
3471 LAFAYETTE ST, SANTA CLARA, CA, 95054408988540737.38367, -121.950032026-11-112026-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
ab-inbev ROTTEN ROBBIEdoordash rotten robbie santa clara1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 62 m apart · 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 33 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 83 m apart · name similarity 1.00
doordash rotten robbie santa claraoverture Rotten Robbie1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 31 m apart · name similarity 1.00
doordash rotten robbie santa claravtinfo ROTTEN ROBBIE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 22 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 50 m apart · name similarity 1.00 · phone: equal
ab-inbev ROTTEN ROBBIEca-abc ROTTEN ROBBIE 330.78Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (94% confident; asked as a “near” pair)
Rotten Robbie name and address match
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records sit at 3471 Lafayette St, Santa Clara 95054 with matching brand name Rotten Robbie (ab-inbev 'ROTTEN ROBBIE' vs CA licence trade name 'ROTTEN ROBBIE 33'), the only business at that address, and the CA record holds an active off-sale store licence, so this is one store.
pair 3346b92f3fca1bb736a0
ca-abc ROTTEN ROBBIE 33doordash rotten robbie santa clara0.78Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
Both records are Rotten Robbie at 3471 Lafayette St, Santa Clara 95054, the only business our data holds at that address, and the DoorDash slug simply appends the city to the chain name.
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 92% confident — Rotten Robbie same address, store licence matches.
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records sit at 3471 Lafayette Street, Santa Clara 95054, with the same chain name 'Rotten Robbie' (the CA licence is the DBA 'ROTTEN ROBBIE 33' under legal entity Robinson Oil), the DoorDash slug names the same city, and only one business is held at that address, so this is one off-sale store on two listings.
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records sit at 3471 Lafayette Street, Santa Clara 95054, with coordinates about 85 m apart, and the only business at that address is Rotten Robbie, whose DoorDash slug matches the ABC record's DBA; the CA off-sale licence fits a store selling to take away.
  • Claude Haiku 5.5, prompt v4: unsure, 60% confident — Both records are Rotten Robbie stores in Santa Clara, but the DoorDash record has no street address and Rotten Robbie is a multi-location chain, so the address cannot be confirmed as the same premises.
pair 07fbaf7cbd5a9e16901f
doordash rotten robbie santa claraubereats Rotten Robbie - 3471 Lafayette St.0.50Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
Both records name Rotten Robbie at the same street address, 3471 Lafayette St, Santa Clara 95054, only 3 m apart, and our data holds just one business at that address.
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 93% confident — Rotten Robbie at identical address.
  • Claude Haiku 5.5, prompt v9: same, 93% confident — Both records name Rotten Robbie at 3471 Lafayette Street, Santa Clara, CA 95054, with near-identical coordinates (0.003 km apart) and no competing business at the address, so they are one storefront listed on two delivery apps.
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records are Rotten Robbie at the same street address (3471 Lafayette St, Santa Clara, ZIP 95054) with coordinates about 3 m apart, and no other business is held at that address, so they are one storefront listed on two delivery apps.
pair 13c4cce5a36a8d22c9e1
ca-abc ROTTEN ROBBIE 33ubereats Rotten Robbie - 3471 Lafayette St.0.49Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
Both records are Rotten Robbie at the identical address, 3471 Lafayette St, Santa Clara 95054, about 0.09 km apart, and our data holds only one business at that address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 92% confident — Both records give the same street address, city and ZIP (3471 Lafayette St, Santa Clara 95054), the coordinates are 0.086 km apart, only one business is held at that address, and the Rotten Robbie name matches, with the store number 33 being the only difference.
pair 88a2959acf77f3855600

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"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
107 within 1 mi · 885 within 3 mi
Off / on premise
15 / 65 within 1 mi · 120 / 582 within 3 mi
Selling alcohol
45 within 1 mi · 439 within 3 mi
Nearest
same channel 0.18 mi · licensed 0.05 mi
Setting
urban (4,604 people per sq mi)
People within 3 mi
130,185 (105,081 adults 21+, 52,330 households) from 25 tract(s), tracts within 3 mi
Income
per capita $92,794 · median household ~$184,328 (weighted mean of tract medians)
Age and education
median age ~34.3 · bachelor's or higher 67%
Ethnicity
Hispanic 17% · White 25% · Black 2% · Asian 53%
Adults per alcohol outlet
239
Alcohol spend within 3 mi
$57,811,782 a year ($24,140,876 at home, $33,654,619 away) · $131,390 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 17:29insertab-inbev 2353912 ↔ ca-abc 00373724|20|LIC|0Claude judge: samemerged14
2026-11-11 12:56insertca-abc 00373724|20|LIC|0 ↔ ubereats j1vt_IokXHCCISZj4GVsjgClaude judge: samemerged12
2026-11-11 12:56insertdoordash 24650774 ↔ ubereats j1vt_IokXHCCISZj4GVsjgClaude judge: samemerged12
2026-11-11 12:56insertoverture 66f4a81b-6344-40d6-a8f4-a2d15b7e91ea ↔ vtinfo 7f6c96efb4dbd9a6same address and namemerged12
2026-11-11 12:56insertdoordash 24650774 ↔ vtinfo 7f6c96efb4dbd9a6same address and namemerged12
2026-11-11 12:56insertab-inbev 2353912 ↔ vtinfo 7f6c96efb4dbd9a6same address and namemerged12
2026-11-11 12:56insertab-inbev 2353912 ↔ overture 66f4a81b-6344-40d6-a8f4-a2d15b7e91easame address and namemerged12
2026-11-11 12:56insertab-inbev 2353912 ↔ doordash 24650774same address and namemerged12
2026-11-06 18:13insertca-abc 00373724|20|LIC|0 ↔ doordash 24650774Claude judge: samemerged11
2026-11-06 18:13insertdoordash 24650774 ↔ overture 66f4a81b-6344-40d6-a8f4-a2d15b7e91easame address and namemerged11