Outlets /
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.
| Field | Master value | Taken from | What 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-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 95054 | ca-abc | no other value |
| Pin | 37.38369, -121.95027 map 2 other | ubereats | 62 m away ab-inbev 86 m away ca-abc |
| Phone | 4089885407 | vtinfo | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | ROTTEN ROBBIE 2353912 | 3471 LAFAYETTE ST, SANTA CLARA, CA, 95054 | 37.38356, -121.95095 | 2026-11-11 | 2026-11-11 | |
| ca-abc | ROTTEN ROBBIE 33 legal name: ROBINSON OIL CORPORATION 00373724|20|LIC|0 | 3471 LAFAYETTE ST, SANTA CLARA, CA, 95054 | 37.38387, -121.95122 | 2026-10-08 | 2026-11-11 | |
| doordash | rotten robbie santa clara 24650774 | 3471 Lafayette Street, Santa Clara, CA, 95054 | 37.38372, -121.95027 | 2026-10-08 | 2026-11-11 | |
| overture | Rotten Robbie 66f4a81b-6344-40d6-a8f4-a2d15b7e91ea | 3471 Lafayette St, Santa Clara, CA, 95054 | 4089885407 | 37.38357, -121.95058 | 2026-11-06 | 2026-11-11 |
| ubereats | Rotten Robbie - 3471 Lafayette St. j1vt_IokXHCCISZj4GVsjg | 3471 Lafayette St, Santa Clara, CA, 95054 | 37.38369, -121.95027 | 2026-11-07 | 2026-11-07 | |
| vtinfo | ROTTEN ROBBIE 7f6c96efb4dbd9a6 | 3471 LAFAYETTE ST, SANTA CLARA, CA, 95054 | 4089885407 | 37.38367, -121.95003 | 2026-11-11 | 2026-11-14 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ab-inbev ROTTEN ROBBIE | doordash rotten robbie santa clara | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 62 m apart · name similarity 1.00 |
| ab-inbev ROTTEN ROBBIE | overture Rotten Robbie | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 33 m apart · name similarity 1.00 |
| ab-inbev ROTTEN ROBBIE | vtinfo ROTTEN ROBBIE | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 83 m apart · name similarity 1.00 |
| doordash rotten robbie santa clara | overture Rotten Robbie | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 31 m apart · name similarity 1.00 |
| doordash rotten robbie santa clara | vtinfo ROTTEN ROBBIE | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 22 m apart · name similarity 1.00 |
| overture Rotten Robbie | vtinfo ROTTEN ROBBIE | 1.00 | same address and name | merged | address 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 ROBBIE | ca-abc ROTTEN ROBBIE 33 | 0.78 | Claude judge: same | merged | 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:
pair 3346b92f3fca1bb736a0 |
| ca-abc ROTTEN ROBBIE 33 | doordash rotten robbie santa clara | 0.78 | Claude judge: same | merged | 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:
pair 07fbaf7cbd5a9e16901f |
| doordash rotten robbie santa clara | ubereats Rotten Robbie - 3471 Lafayette St. | 0.50 | Claude judge: same | merged | 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:
pair 13c4cce5a36a8d22c9e1 |
| ca-abc ROTTEN ROBBIE 33 | ubereats Rotten Robbie - 3471 Lafayette St. | 0.49 | Claude judge: same | merged | 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:
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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-12 17:29 | insert | ab-inbev 2353912 ↔ ca-abc 00373724|20|LIC|0 | Claude judge: same | merged | 14 |
| 2026-11-11 12:56 | insert | ca-abc 00373724|20|LIC|0 ↔ ubereats j1vt_IokXHCCISZj4GVsjg | Claude judge: same | merged | 12 |
| 2026-11-11 12:56 | insert | doordash 24650774 ↔ ubereats j1vt_IokXHCCISZj4GVsjg | Claude judge: same | merged | 12 |
| 2026-11-11 12:56 | insert | overture 66f4a81b-6344-40d6-a8f4-a2d15b7e91ea ↔ vtinfo 7f6c96efb4dbd9a6 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | doordash 24650774 ↔ vtinfo 7f6c96efb4dbd9a6 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 2353912 ↔ vtinfo 7f6c96efb4dbd9a6 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 2353912 ↔ overture 66f4a81b-6344-40d6-a8f4-a2d15b7e91ea | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 2353912 ↔ doordash 24650774 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | ca-abc 00373724|20|LIC|0 ↔ doordash 24650774 | Claude judge: same | merged | 11 |
| 2026-11-06 18:13 | insert | doordash 24650774 ↔ overture 66f4a81b-6344-40d6-a8f4-a2d15b7e91ea | same address and name | merged | 11 |