LOST Rockin Crawfish - SAN PABLO

San Pablo, CA 94806 · O18c1a681a9cf · first seen 2026-10-08
4 sourceson premise · restaurantalcohol: 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
LOST Rockin Crawfish - SAN PABLO 3 other
the most common name a source states
ROCKIN CRAWFISH ca-abcoverture ×2
RCSP25 LLC ca-abc (legal name)
the rockin' crawfish san pablo doordash
Street
2300 EL PORTAL DR 2 other
ca-abc
2300 El Portal Dr, 1 ubereats
2300 El Portal Drive doordash
City
SAN PABLO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94806
ca-abcno other value
Pin
37.96605, -122.34325 map 1 other
ubereats
80 m away ca-abc
Phone
5102304874
overtureno other value
Licences
ca-abc 00672011|41|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O7ed6ed5820b4; O93ac88d67057; O6f16090efd93

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
ca-abcROCKIN CRAWFISH
legal name: RCSP25 LLC
00672011|41|LIC|0
2300 EL PORTAL DR, SAN PABLO, CA, 9480637.96676, -122.343402026-10-082026-11-05
doordashthe rockin' crawfish san pablo
90161
2300 El Portal Drive, San Pablo, CA, 9480637.96597, -122.343032026-10-082026-11-12
overtureRockin Crawfish
2977b285-114d-4196-a792-7e208402ff76
2300 El Portal Dr, San Pablo, CA, 94806510230487437.96597, -122.343362026-11-062026-11-06
ubereatsLOST Rockin Crawfish - SAN PABLO
RDkIEp5DTJ2D16mcJ4Zr0w
2300 El Portal Dr, 1, San Pablo, CA, 9480637.96605, -122.343252026-10-312026-10-31

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
ca-abc ROCKIN CRAWFISHdoordash the rockin' crawfish san pablo1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 94 m apart · name similarity 1.00
ca-abc ROCKIN CRAWFISHoverture Rockin Crawfish1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 88 m apart · name similarity 1.00
doordash the rockin' crawfish san pablooverture Rockin Crawfish1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 29 m apart · name similarity 1.00
doordash the rockin' crawfish san pabloubereats LOST Rockin Crawfish - SAN PABLO0.85street written two waysmergedname Jaro-Winkler 0.92 · matched on zip · pins 22 m apart · name similarity 0.85 · street similarity 0.92
ca-abc ROCKIN CRAWFISHubereats LOST Rockin Crawfish - SAN PABLO0.53Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (80% confident; asked as a “near” pair)
The names match ('Rockin Crawfish' in both) at the same street address and ZIP, and our data holds only one business at that address; the restaurant licence fits a crawfish restaurant's Uber Eats list
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 85% confident — Same restaurant name at same address; LOST prefix is listing label
  • Claude Haiku 5.5, prompt v9: same, 86% confident — Both records are at 2300 El Portal Dr, San Pablo 94806, and the names match (ROCKIN CRAWFISH restaurant licence vs. the Uber Eats listing 'LOST Rockin Crawfish - SAN PABLO'), with only one business at the address, so the restaurant licence and its delivery listing are one outlet.
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records sit at 2300 El Portal Dr, San Pablo 94806, the CA ABC record is an active on-sale eating-place licence for Rockin Crawfish, and the Uber Eats listing is the same restaurant brand (LOST Rockin Crawfish), with the only building-level business and a 0.08 km distance supporting the match.
  • Claude Haiku 5.5, prompt v4: same, 88% confident — Both records share the same street address, city and ZIP (2300 El Portal Dr, San Pablo 94806), the name 'Rockin Crawfish' matches the Uber Eats listing 'LOST Rockin Crawfish - SAN PABLO', and no other business is recorded at that address, so this is one restaurant with a delivery listing.
pair 0dea20c269d7332c5dcb

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
RCSP25 LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off — CA 41
Rule version 7, computed 2026-11-16 17:15.
Every vote behind these (raw)
{
 "ue_location": [
  "PHYSICAL"
 ],
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
103 within 1 mi · 558 within 3 mi
Off / on premise
33 / 53 within 1 mi · 173 / 287 within 3 mi
Selling alcohol
61 within 1 mi · 283 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.08 mi
Setting
urban (5,086 people per sq mi)
People within 3 mi
143,800 (104,709 adults 21+, 47,368 households) from 27 tract(s), tracts within 3 mi
Income
per capita $38,149 · median household ~$93,185 (weighted mean of tract medians)
Age and education
median age ~36.5 · bachelor's or higher 27%
Ethnicity
Hispanic 52% · White 18% · Black 13% · Asian 14%
Adults per alcohol outlet
369
Alcohol spend within 3 mi
$34,682,859 a year ($15,697,350 at home, $18,970,344 away) · $122,123 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:25insertdoordash 90161 ↔ ubereats RDkIEp5DTJ2D16mcJ4Zr0wstreet written two waysmerged12
2026-11-12 14:25insertdoordash 90161 ↔ overture 2977b285-114d-4196-a792-7e208402ff76same address and namemerged12
2026-11-12 14:25insertca-abc 00672011|41|LIC|0 ↔ doordash 90161same address and namemerged12
2026-11-06 18:13insertca-abc 00672011|41|LIC|0 ↔ overture 2977b285-114d-4196-a792-7e208402ff76same address and namemerged11
2026-11-02 23:02backfillca-abc 00672011|41|LIC|0 ↔ ubereats RDkIEp5DTJ2D16mcJ4Zr0wClaude judge: samemerged