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.

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 - 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-abcno other value
State
CA
ca-abcno other value
ZIP
95401
ca-abcno other value
Pin
38.45288, -122.77005 map
ubereatsno other value
Phone
7075262891
vtinfono 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.

SourceNameAddressPhoneCoordinatesFirst seenUpdated
ab-inbevROTTEN ROBBIE
3105028
2515 GUERNEVILLE RD, SANTA ROSA, CA, 9540138.45293, -122.770512026-11-112026-11-11
ca-abcROTTEN ROBBIE 40
legal name: ROBINSON OIL CORPORATION
00480198|20|LIC|0
2515 GUERNEVILLE RD, SANTA ROSA, CA, 9540138.45266, -122.770422026-10-082026-11-06
doordashrotten robbie santa rosa
25579493
2515 Guerneville Road, Santa Rosa, CA, 9540138.45299, -122.770112026-10-082026-11-06
overtureRotten Robbie
32b4e9e0-bcd1-4d93-bd2f-41277cc84c64
2515 Guerneville Rd, Santa Rosa, CA, 95401707526289138.45290, -122.769962026-11-062026-11-06
ubereatsRotten Robbie - 2515 Guerneville Road
Vrzb7HObWGSv8W5F7K4mwg
2515 Guerneville Road, Santa Rosa, CA, 9540138.45288, -122.770052026-11-102026-11-11
vtinfoROTTEN ROBBIE
2d6a84d578ad693d
2515 GUERNEVILLE RD, SANTA ROSA, CA, 95401707526289138.45281, -122.770052026-11-122026-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 rosa1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 35 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 48 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 42 m apart · name similarity 1.00
doordash rotten robbie santa rosaoverture 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
doordash rotten robbie santa rosavtinfo ROTTEN ROBBIE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 21 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 13 m apart · name similarity 1.00 · phone: equal
ca-abc ROTTEN ROBBIE 40doordash rotten robbie santa rosa0.78Claude judge: samemerged
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:
  • Claude Opus 5.5, prompt v12: same, 90% confident — Rotten Robbie station same address
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records give the same street address, city and ZIP at 2515 Guerneville Road, Santa Rosa, with only one business at that address; the DoorDash slug 'rotten robbie santa rosa' matches the California ABC trade name 'ROTTEN ROBBIE 40' (legal entity Robinson Oil Corporation), and the coordinates are within 45 m.
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records give the same street address, city and ZIP, with coordinates about 45 m apart, and the DoorDash slug 'rotten robbie santa rosa' matches the California ABC DBA 'ROTTEN ROBBIE 40' as the only business at that address, with the off-sale licence fitting a store selling take-away alcohol.
  • Claude Haiku 5.5, prompt v4: same, 90% confident — Both records give the same street address, city and ZIP, and the DoorDash name 'rotten robbie santa rosa' matches the California ABC DBA 'ROTTEN ROBBIE 40' for an active off-sale store; only one business is held at that address, so the match is strong.
pair 0a0fa9c4a793c690e0ed
doordash rotten robbie santa rosaubereats Rotten Robbie - 2515 Guerneville Road0.47Claude 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 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:
  • Claude Opus 5.5, prompt v12: same, 93% confident — Rotten Robbie same address both listings
  • Claude Haiku 5.5, prompt v9: same, 93% confident — Both records are the same Rotten Robbie store at 2515 Guerneville Road, Santa Rosa, ZIP 95401, with coordinates about 13 m apart and no competing business at that address.
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records give the same street address, city and ZIP, the coordinates are 13 m apart, the names match as Rotten Robbie, and only one business is recorded at that address.
pair 4bc006c9a246e3dd7445
ca-abc ROTTEN ROBBIE 40ubereats Rotten Robbie - 2515 Guerneville Road0.44Claude judge: samemerged
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:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — The California ABC off-sale beer and wine licence at 2515 Guerneville Rd, Santa Rosa is for Rotten Robbie 40, and the Uber Eats listing is Rotten Robbie at the identical street address and ZIP, with coordinates about 40 m apart and no conflicting suite numbers or other businesses at the address.
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”).
WhenEventPairRuleDecisionRule version
2026-11-12 14:25insertab-inbev 3105028 ↔ vtinfo 2d6a84d578ad693dsame address and namemerged12
2026-11-12 14:25insertdoordash 25579493 ↔ vtinfo 2d6a84d578ad693dsame address and namemerged12
2026-11-12 14:25insertoverture 32b4e9e0-bcd1-4d93-bd2f-41277cc84c64 ↔ vtinfo 2d6a84d578ad693dsame address and namemerged12
2026-11-11 12:56insertca-abc 00480198|20|LIC|0 ↔ ubereats Vrzb7HObWGSv8W5F7K4mwgClaude judge: samemerged12
2026-11-11 12:56insertdoordash 25579493 ↔ ubereats Vrzb7HObWGSv8W5F7K4mwgClaude judge: samemerged12
2026-11-11 12:56insertab-inbev 3105028 ↔ doordash 25579493same address and namemerged12
2026-11-11 12:56insertab-inbev 3105028 ↔ overture 32b4e9e0-bcd1-4d93-bd2f-41277cc84c64same address and namemerged12
2026-11-06 18:13insertdoordash 25579493 ↔ overture 32b4e9e0-bcd1-4d93-bd2f-41277cc84c64same address and namemerged11
2026-11-02 23:02backfillca-abc 00480198|20|LIC|0 ↔ doordash 25579493Claude judge: samemerged