Outlets /
ROTTEN ROBBIE
SANTA ROSA, CA 95401 · O18e3ba4bfd00 · 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 - 2515 Guerneville Road ubereats ROTTEN ROBBIE 40 ca-abc rotten robbie santa rosa doordash |
| Street | 2515 GUERNEVILLE RD 1 other | ca-abc | 2515 Guerneville Road doordashubereats ×2 |
| City | SANTA ROSA | ca-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 95401 | ca-abc | no other value |
| Pin | 38.45288, -122.77005 map | ubereats | no other value |
| Phone | 7075262891 | vtinfo | no other value |
| Licences | ca-abc 00480198|20|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: O94cacaed56a0; O4b04be931407; O920c1fc23dd2; Oe01f620ecfb3; O3a5c6c7d352b
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 3105028 | 2515 GUERNEVILLE RD, SANTA ROSA, CA, 95401 | 38.45293, -122.77051 | 2026-11-11 | 2026-11-11 | |
| ca-abc | ROTTEN ROBBIE 40 legal name: ROBINSON OIL CORPORATION 00480198|20|LIC|0 | 2515 GUERNEVILLE RD, SANTA ROSA, CA, 95401 | 38.45266, -122.77042 | 2026-10-08 | 2026-11-06 | |
| doordash | rotten robbie santa rosa 25579493 | 2515 Guerneville Road, Santa Rosa, CA, 95401 | 38.45299, -122.77011 | 2026-10-08 | 2026-11-06 | |
| overture | Rotten Robbie 32b4e9e0-bcd1-4d93-bd2f-41277cc84c64 | 2515 Guerneville Rd, Santa Rosa, CA, 95401 | 7075262891 | 38.45290, -122.76996 | 2026-11-06 | 2026-11-06 |
| ubereats | Rotten Robbie - 2515 Guerneville Road Vrzb7HObWGSv8W5F7K4mwg | 2515 Guerneville Road, Santa Rosa, CA, 95401 | 38.45288, -122.77005 | 2026-11-10 | 2026-11-11 | |
| vtinfo | ROTTEN ROBBIE 2d6a84d578ad693d | 2515 GUERNEVILLE RD, SANTA ROSA, CA, 95401 | 7075262891 | 38.45281, -122.77005 | 2026-11-12 | 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 rosa | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 35 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 48 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 42 m apart · name similarity 1.00 |
| doordash rotten robbie santa rosa | overture Rotten Robbie | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 17 m apart · name similarity 1.00 |
| doordash rotten robbie santa rosa | vtinfo ROTTEN ROBBIE | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 21 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 13 m apart · name similarity 1.00 · phone: equal |
| ca-abc ROTTEN ROBBIE 40 | doordash rotten robbie santa rosa | 0.78 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (92% confident; asked as a “near” pair) Both records are Rotten Robbie at the same street address, 2515 Guerneville Rd, Santa Rosa 95401, and our data holds only one business there; the DoorDash slug simply appends the city to the chain nam Other Claude answers on this pair:
pair 0a0fa9c4a793c690e0ed |
| doordash rotten robbie santa rosa | ubereats Rotten Robbie - 2515 Guerneville Road | 0.47 | 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 street address 2515 Guerneville Road, Santa Rosa 95401, 13 m apart, and they are the only business our data holds there. Other Claude answers on this pair:
pair 4bc006c9a246e3dd7445 |
| ca-abc ROTTEN ROBBIE 40 | ubereats Rotten Robbie - 2515 Guerneville Road | 0.44 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “same-address” pair) Same chain name, Rotten Robbie, at the identical street address and ZIP (0.04 km apart), with only one business recorded at that address. Other Claude answers on this pair:
pair da2818f281873686048a |
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
- 37 within 1 mi · 654 within 3 mi
- Off / on premise
- 16 / 19 within 1 mi · 206 / 256 within 3 mi
- Selling alcohol
- 23 within 1 mi · 478 within 3 mi
- Nearest
- same channel 0.06 mi · licensed 0.06 mi
- Setting
- suburban (2,967 people per sq mi)
- People within 3 mi
- 83,899 (62,477 adults 21+, 29,646 households) from 16 tract(s), tracts within 3 mi
- Income
- per capita $41,302 · median household ~$93,971 (weighted mean of tract medians)
- Age and education
- median age ~39.1 · bachelor's or higher 24%
- Ethnicity
- Hispanic 46% · White 45% · Black 3% · Asian 6%
- Adults per alcohol outlet
- 130
- Alcohol spend within 3 mi
- $21,857,425 a year ($9,891,055 at home, $11,955,884 away) · $45,631 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 14:25 | insert | ab-inbev 3105028 ↔ vtinfo 2d6a84d578ad693d | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | doordash 25579493 ↔ vtinfo 2d6a84d578ad693d | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | overture 32b4e9e0-bcd1-4d93-bd2f-41277cc84c64 ↔ vtinfo 2d6a84d578ad693d | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ca-abc 00480198|20|LIC|0 ↔ ubereats Vrzb7HObWGSv8W5F7K4mwg | Claude judge: same | merged | 12 |
| 2026-11-11 12:56 | insert | doordash 25579493 ↔ ubereats Vrzb7HObWGSv8W5F7K4mwg | Claude judge: same | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 3105028 ↔ doordash 25579493 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 3105028 ↔ overture 32b4e9e0-bcd1-4d93-bd2f-41277cc84c64 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | doordash 25579493 ↔ overture 32b4e9e0-bcd1-4d93-bd2f-41277cc84c64 | same address and name | merged | 11 |
| 2026-11-02 23:02 | backfill | ca-abc 00480198|20|LIC|0 ↔ doordash 25579493 | Claude judge: same | merged |