Rotten Robbie

Hayward, CA 94545 · O442f770d0487 · first seen 2026-10-08
3 sourcesoff premise · conveniencechain: Lula Conveniencealcohol: alcohol chain

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 2 other
the most common name a source states
Rotten Robbie - 27814 Hesperian Blvd. ubereats
rotten robbie hayward doordash
Street
27814 Hesperian Blvd. 1 other
ubereats
27814 Hesperian Boulevard doordash
City
Hayward
ubereatsno other value
State
CA
ubereatsno other value
ZIP
94545
ubereatsno other value
Pin
37.62487, -122.09269 map
ubereatsno other value
Phone
5107826993
overtureno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O46656da2efe5; O7fa07d73bbd2

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
doordashrotten robbie hayward
25579491
27814 Hesperian Boulevard, Hayward, CA, 9454537.62496, -122.092692026-10-082026-10-19
overtureRotten Robbie
c7350948-44a0-45f7-b756-f0c99077a967
27814 Hesperian Blvd, Hayward, CA, 94545510782699337.62497, -122.092772026-11-062026-11-06
ubereatsRotten Robbie - 27814 Hesperian Blvd.
vYesaR6sWc-MBrk031JdiQ
27814 Hesperian Blvd., Hayward, CA, 9454537.62487, -122.092692026-10-172026-11-02

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
doordash rotten robbie haywardoverture Rotten Robbie1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00
doordash rotten robbie haywardubereats Rotten Robbie - 27814 Hesperian Blvd.0.48Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
Both records name Rotten Robbie at 27814 Hesperian Blvd, Hayward 94545, and they sit 0.01 km apart with only one business on record at that address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records give the same street address (27814 Hesperian Blvd, Hayward, ZIP 94545) with coordinates about 10 m apart, the names match as Rotten Robbie, and no other business is held at that address, so they describe one storefront listed on two apps.
pair ec46a443413f8cdf6711

Attributes

Channel
off_premise · convenience — ubereats-type
Chain
Lula Convenience — ubereats-parent
Alcohol
alcohol_chain — Lula Convenience: licensed at 115 of 220 outlets in licence states
Operator
none
Licence privileges
none
Rule version 9, computed 2026-11-17 18:21.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ubereats-type",
   "off_premise",
   "convenience"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
41 within 1 mi · 513 within 3 mi
Off / on premise
11 / 20 within 1 mi · 135 / 304 within 3 mi
Selling alcohol
21 within 1 mi · 265 within 3 mi
Nearest
same channel 0.36 mi · licensed 0.36 mi
Setting
urban (4,909 people per sq mi)
People within 3 mi
138,804 (106,920 adults 21+, 41,873 households) from 31 tract(s), tracts within 3 mi
Income
per capita $44,499 · median household ~$116,091 (weighted mean of tract medians)
Age and education
median age ~39.9 · bachelor's or higher 34%
Ethnicity
Hispanic 40% · White 13% · Black 7% · Asian 36%
Adults per alcohol outlet
402
Alcohol spend within 3 mi
$36,206,594 a year ($15,801,011 at home, $20,391,682 away) · $136,115 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-06 18:13insertdoordash 25579491 ↔ overture c7350948-44a0-45f7-b756-f0c99077a967same address and namemerged11
2026-11-02 23:02backfilldoordash 25579491 ↔ ubereats vYesaR6sWc-MBrk031JdiQClaude judge: samemerged