ROTTEN ROBBIE

MILPITAS, CA 95035 · O37eaa686f03c · first seen 2026-10-08
5 sourcesoff premise · 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 3 other
the most common name a source states
ROBINSON OIL CORPORATION ca-abc (legal name)
ROTTEN ROBBIE #66 ca-abc
rotten robbie milpitas doordash
Street
1787 S MAIN ST 1 other
ca-abc
1787 South Main Street doordash
City
MILPITAS
ca-abcno other value
State
CA
ca-abcno other value
ZIP
95035
ca-abcno other value
Pin
37.40495, -121.90348 map 1 other
doordash
137 m away ab-inbev
Phone
4089349850
vtinfono other value
Licences
ca-abc 00609588|20|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc70c3805fd2b; O88eb32892c07; O69257e812494; O99f79355f17d

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
4400445
1787 S MAIN ST, MILPITAS, CA, 9503537.40613, -121.903012026-11-112026-11-11
ca-abcROTTEN ROBBIE #66
legal name: ROBINSON OIL CORPORATION
00609588|20|LIC|0
1787 S MAIN ST, MILPITAS, CA, 9503537.40510, -121.902962026-10-082026-11-05
doordashrotten robbie milpitas
24650814
1787 South Main Street, Milpitas, CA, 9503537.40495, -121.903482026-10-082026-11-06
overtureRotten Robbie
2ebb84c5-ec55-4466-9d8e-253f6d54fc4d
1787 S Main St, Milpitas, CA, 95035408934985037.40492, -121.903202026-11-062026-11-06
vtinfoROTTEN ROBBIE
978339c3d1d60326
1787 S MAIN ST, MILPITAS, CA, 95035408934985037.40482, -121.903682026-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 milpitas1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 137 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 136 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 158 m apart · name similarity 1.00
doordash rotten robbie milpitasoverture Rotten Robbie1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 25 m apart · name similarity 1.00
doordash rotten robbie milpitasvtinfo ROTTEN ROBBIE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 23 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 44 m apart · name similarity 1.00 · phone: equal
ca-abc ROTTEN ROBBIE #66doordash rotten robbie milpitas0.78Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
Same chain name (Rotten Robbie, with the city appended to the DoorDash slug) at the same street address, 1787 S Main St, Milpitas 95035, with only one business at that address and the records 49 m apa
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records sit at 1787 S Main St, Milpitas CA 95035 (about 49 m apart), the only business at that address is a Rotten Robbie store, and the ABC off-sale licence matches the DoorDash listing for the same store, though the ABC name carries a store number while the DoorDash slug does not.
  • Claude Haiku 5.5, prompt v4: unsure, 60% confident — Both records name Rotten Robbie in Milpitas, but the DoorDash record has no street address and Rotten Robbie is a multi-location chain, so the slug and city cannot confirm that it is the #66 store at 1787 S Main St.
pair 64fec37fc4b9461cb77d

Attributes

Channel
off_premise · convenience — ca-licence
Chain
none
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:21.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
135 within 1 mi · 978 within 3 mi
Off / on premise
31 / 83 within 1 mi · 144 / 663 within 3 mi
Selling alcohol
44 within 1 mi · 411 within 3 mi
Nearest
same channel 0.06 mi · licensed 0.31 mi
Setting
urban (6,298 people per sq mi)
People within 3 mi
178,073 (141,405 adults 21+, 61,533 households) from 34 tract(s), tracts within 3 mi
Income
per capita $76,967 · median household ~$187,327 (weighted mean of tract medians)
Age and education
median age ~37.2 · bachelor's or higher 61%
Ethnicity
Hispanic 15% · White 14% · Black 2% · Asian 68%
Adults per alcohol outlet
343
Alcohol spend within 3 mi
$69,404,197 a year ($29,009,871 at home, $40,375,388 away) · $168,457 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 4400445 ↔ vtinfo 978339c3d1d60326same address and namemerged12
2026-11-12 14:25insertoverture 2ebb84c5-ec55-4466-9d8e-253f6d54fc4d ↔ vtinfo 978339c3d1d60326same address and namemerged12
2026-11-12 14:25insertdoordash 24650814 ↔ vtinfo 978339c3d1d60326same address and namemerged12
2026-11-11 12:56insertab-inbev 4400445 ↔ overture 2ebb84c5-ec55-4466-9d8e-253f6d54fc4dsame address and namemerged12
2026-11-11 12:56insertab-inbev 4400445 ↔ doordash 24650814same address and namemerged12
2026-11-06 18:13insertca-abc 00609588|20|LIC|0 ↔ doordash 24650814Claude judge: samemerged11
2026-11-06 18:13insertdoordash 24650814 ↔ overture 2ebb84c5-ec55-4466-9d8e-253f6d54fc4dsame address and namemerged11