Rotten Robbie

Healdsburg, CA 95448 · O0de731f03270 · first seen 2026-10-08
7 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
a source's own spelling of the licence name (record_title.py)
ROTTEN ROBBIE 63 ca-abcsnap ×2
ROBINSON OIL CORPORATION ca-abc (legal name)
ROTTEN ROBBIE #63 ca-tobacco
Rotten Robbie - 535 Healdsburg Ave. ubereats
Street
535 HEALDSBURG AVE
ca-abcno other value
City
HEALDSBURG
ca-abcno other value
State
CA
ca-abcno other value
ZIP
95448
ca-abcno other value
Pin
38.61557, -122.87223 map 1 other
ubereats
238 m away ca-abc
Phone
7074331468
vtinfono other value
Licences
ca-abc 00422662|20|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oeab9c336e26c; Ob5592ea76a01; O7a5cdcfd44c8; O61dde0a29b18; O517eede395bb; O451658e276df

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
2777292
535 HEALDSBURG AVE, HEALDSBURG, CA, 9544838.61554, -122.872042026-11-112026-11-19
ca-abcROTTEN ROBBIE 63
legal name: ROBINSON OIL CORPORATION
00422662|20|LIC|0
535 HEALDSBURG AVE, HEALDSBURG, CA, 9544838.61346, -122.871802026-10-082026-11-19
ca-tobaccoROTTEN ROBBIE #63
ca-tobacco|091264264
535 HEALDSBURG AVE, Healdsburg, CA, 954482026-11-202026-11-20
overtureRotten Robbie
f9560cc4-b15f-47ec-bb79-cd514b9707a5
535 Healdsburg Ave, Healdsburg, CA, 95448707433146838.61559, -122.872222026-11-132026-11-19
snapRotten Robbie 63
snap|us|1114842
535 Healdsburg Ave, Healdsburg, CA, 9544838.61559, -122.872002026-11-192026-11-19
ubereatsRotten Robbie - 535 Healdsburg Ave.
C8Q9Weu-Xc6z4DBtzNFvaQ
535 Healdsburg Ave., Healdsburg, CA, 9544838.61557, -122.872232026-11-032026-11-19
vtinfoROTTEN ROBBIE
3a2d2fddf48657b5
535 HEALDSBURG AVE, HEALDSBURG, CA, 95448707433146838.61555, -122.872262026-11-132026-11-19

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 ROBBIEca-abc ROTTEN ROBBIE 631.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 232 m apart · name similarity 1.00
ab-inbev ROTTEN ROBBIEca-tobacco ROTTEN ROBBIE #631.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · 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 16 m apart · name similarity 1.00
ab-inbev ROTTEN ROBBIEsnap Rotten Robbie 631.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 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 19 m apart · name similarity 1.00
ca-abc ROTTEN ROBBIE 63ca-tobacco ROTTEN ROBBIE #631.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc ROTTEN ROBBIE 63overture Rotten Robbie1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 240 m apart · name similarity 1.00
ca-abc ROTTEN ROBBIE 63snap Rotten Robbie 631.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 238 m apart · name similarity 1.00
ca-abc ROTTEN ROBBIE 63vtinfo ROTTEN ROBBIE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 236 m apart · name similarity 1.00
ca-tobacco ROTTEN ROBBIE #63overture Rotten Robbie1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-tobacco ROTTEN ROBBIE #63snap Rotten Robbie 631.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-tobacco ROTTEN ROBBIE #63vtinfo ROTTEN ROBBIE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
overture Rotten Robbiesnap Rotten Robbie 631.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 19 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 6 m apart · name similarity 1.00 · phone: equal
snap Rotten Robbie 63vtinfo ROTTEN ROBBIE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 23 m apart · name similarity 1.00
ab-inbev ROTTEN ROBBIEubereats Rotten Robbie - 535 Healdsburg Ave.0.49Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “near” pair)
Rotten Robbie same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 93% confident — Both records name Rotten Robbie at 535 Healdsburg Ave in Healdsburg, CA 95448, coordinates are about 17 m apart, and no other business is held at that address, so they are one store listed by the AB InBev finder and Uber Eats.
pair 23ebdac30e4ee7bc5e5b
ca-abc ROTTEN ROBBIE 63ubereats Rotten Robbie - 535 Healdsburg Ave.0.48Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
The ABC off-sale licence for Rotten Robbie #63 and the Uber Eats listing for Rotten Robbie share the same street address and ZIP, and no other business is recorded at that address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records give the same street address and ZIP (535 Healdsburg Ave, 95448), the only business at that address in the data, and the Uber Eats listing 'Rotten Robbie' matches the ABC off-sale store licence held under 'ROTTEN ROBBIE 63' and the legal entity Robinson Oil, so they describe one store selling through its delivery listing.
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records sit at 535 Healdsburg Ave, Healdsburg, CA 95448, the only business held at that address, and the names match as Rotten Robbie (the ABC record's '63' is a store number); the Uber Eats listing is the same storefront with a 0.24 km coordinate gap, and the ABC licence is an off-sale store licence consistent with a convenience store.
pair d878aa34e49118bedae6

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 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "ubereats-type",
   "off_premise",
   "convenience"
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

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-20 22:08insertca-abc 00422662|20|LIC|0 ↔ vtinfo 3a2d2fddf48657b5same address and namemerged17
2026-11-20 22:08insertca-abc 00422662|20|LIC|0 ↔ overture f9560cc4-b15f-47ec-bb79-cd514b9707a5same address and namemerged17
2026-11-20 22:08insertsnap snap|us|1114842 ↔ vtinfo 3a2d2fddf48657b5same address and namemerged17
2026-11-20 22:08insertoverture f9560cc4-b15f-47ec-bb79-cd514b9707a5 ↔ snap snap|us|1114842same address and namemerged17
2026-11-20 22:08insertca-abc 00422662|20|LIC|0 ↔ ca-tobacco ca-tobacco|091264264same address and namemerged17
2026-11-20 22:08insertca-tobacco ca-tobacco|091264264 ↔ vtinfo 3a2d2fddf48657b5same address and namemerged17
2026-11-20 22:08insertca-tobacco ca-tobacco|091264264 ↔ overture f9560cc4-b15f-47ec-bb79-cd514b9707a5same address and namemerged17
2026-11-20 22:08insertca-tobacco ca-tobacco|091264264 ↔ snap snap|us|1114842same address and namemerged17
2026-11-20 22:08insertab-inbev 2777292 ↔ ca-abc 00422662|20|LIC|0same address and namemerged17
2026-11-20 22:08insertab-inbev 2777292 ↔ snap snap|us|1114842same address and namemerged17
2026-11-20 22:08insertab-inbev 2777292 ↔ ca-tobacco ca-tobacco|091264264same address and namemerged17
2026-11-19 20:37insertca-abc 00422662|20|LIC|0 ↔ snap snap|us|1114842same address and namemerged17
2026-11-13 14:10insertab-inbev 2777292 ↔ vtinfo 3a2d2fddf48657b5same address and namemerged15
2026-11-13 14:10insertoverture f9560cc4-b15f-47ec-bb79-cd514b9707a5 ↔ vtinfo 3a2d2fddf48657b5same address and namemerged15
2026-11-13 14:10insertab-inbev 2777292 ↔ overture f9560cc4-b15f-47ec-bb79-cd514b9707a5same address and namemerged15
2026-11-12 17:29insertab-inbev 2777292 ↔ ubereats C8Q9Weu-Xc6z4DBtzNFvaQClaude judge: samemerged14
2026-11-06 18:13insertca-abc 00422662|20|LIC|0 ↔ ubereats C8Q9Weu-Xc6z4DBtzNFvaQClaude judge: samemerged11