BAG O CRAB

Clovis, CA 93611 · O0e7375c78f32 · first seen 2026-10-08
4 sourceson premise · restaurantalcohol: licensed2 licences

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
BAG O CRAB 3 other
the most common name a source states
bag o' crab clovis doordashoverture ×2
OCEANVIEW CLOVIS LLC ca-abc (legal name) ×2
Bag O Crab Clovis ubereats
Street
1805 HERNDON AVE 2 other
ca-abc
1805 Herndon Ave B overture
1805 Herndon Avenue ubereats
City
CLOVIS
ca-abcno other value
State
CA
ca-abcno other value
ZIP
93611
ca-abcno other value
Pin
36.83896, -119.68376 map 1 other
ubereats
175 m away ca-abc ×2
Phone
none 1 other
5593218009 overture
Licences
ca-abc 00678981|41|APP|0 · ca-abc 00678981|41|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O8ccd97099f66; O8060c0e935a3; O3cc61786f539; O8adad4af7fba

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-abcBAG O CRAB
legal name: OCEANVIEW CLOVIS LLC
00678981|41|APP|0
1805 HERNDON AVE, CLOVIS, CA, 9361136.83741, -119.683402026-10-082026-11-05
ca-abcBAG O CRAB
legal name: OCEANVIEW CLOVIS LLC
00678981|41|LIC|0
1805 HERNDON AVE, CLOVIS, CA, 9361136.83741, -119.683402026-10-152026-11-05
doordashbag o' crab clovis
46601825
1805 Herndon Ave, Clovis, CA, 9361136.83894, -119.683802026-10-082026-10-26
overtureBag O' Crab Clovis
2273777c-9768-428f-8f2f-d04428a3a5cf
1805 Herndon Ave B, Clovis, CA, 93611559321800936.83894, -119.683752026-11-182026-11-18
ubereatsBag O Crab Clovis
PT34lcV8UuSl227YqEGF4A
1805 Herndon Avenue, Clovis, CA, 9361136.83896, -119.683762026-10-262026-10-26

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 BAG O CRABca-abc BAG O CRAB1.00one licence filemergedfile: 00678981 · same_address
ca-abc BAG O CRABdoordash bag o' crab clovis1.00same address and namemergedaddress similarity 1.00 · same street + city + state · name similarity 1.00
ca-abc BAG O CRABdoordash bag o' crab clovis1.00same address and namemergedaddress similarity 1.00 · same street + city + state · name similarity 1.00
doordash bag o' crab clovisoverture Bag O' Crab Clovis1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 5 m apart · name similarity 1.00 · street similarity 0.92
doordash bag o' crab clovisubereats Bag O Crab Clovis1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · pins 4 m apart · name similarity 1.00
overture Bag O' Crab Clovisubereats Bag O Crab Clovis1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 3 m apart · name similarity 1.00 · street similarity 0.92
ca-abc BAG O CRABubereats Bag O Crab Clovis0.74Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (88% confident; asked as a “near” pair)
The two records share a distinctive name, Bag O Crab, and the same street address and ZIP. The Uber Eats listing just adds the city to the name, and the restaurant licence fits the restaurant listing.
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 93% confident — Same distinctive name, same address
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are at 1805 Herndon Avenue, Clovis, 93611, and the names match (BAG O CRAB vs Bag O Crab Clovis); the California licence is an active eating-place on-sale licence, which is the restaurant's own licence beside its Uber Eats listing, so it is one operation.
  • Claude Haiku 5.5, prompt v7: same, 85% confident — Both records name Bag O Crab at 1805 Herndon Avenue, Clovis, 93611, and the California licence is an active restaurant (eating place) licence that fits an Uber Eats restaurant listing. The building is shared with two other businesses, but the names agree, and the 175 m geocode gap is ordinary geocoding noise.
  • Claude Haiku 5.5, prompt v4: same, 85% confident — Both records give 1805 Herndon Avenue, Clovis, 93611, and the names match (BAG O CRAB vs Bag O Crab Clovis). The active ABC licence is an on-sale eating-place restaurant, which fits a restaurant listed on Uber Eats. The building holds three businesses, so the name match carries the decision, and no suite is given on either side.
pair 34fefb7dcd99f10336e6
ca-abc BAG O CRABubereats Bag O Crab Clovis0.74Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (90% confident; asked as a “near” pair)
Same distinctive name 'Bag O Crab' at the identical street address and ZIP in Clovis. The Uber Eats name just appends the city, and the restaurant licence fits a seafood restaurant listing.
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 92% confident — Same restaurant name at same address
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records sit at 1805 Herndon Avenue, Clovis, ZIP 93611, and the names match (BAG O CRAB and Bag O Crab Clovis), with the California licence being an active eating-place licence that fits a restaurant listing on Uber Eats; the shared building (three businesses at the address) and the pending application add some doubt, but the name match is strong.
  • Claude Haiku 5.5, prompt v7: same, 86% confident — The ABC restaurant licence for BAG O CRAB at 1805 Herndon Ave, Clovis, matches the Uber Eats listing 'Bag O Crab Clovis' at the same street address and ZIP, with the names agreeing despite the shared building.
  • Claude Haiku 5.5, prompt v4: same, 85% confident — Both records give 1805 Herndon Avenue, Clovis, CA 93611 with a matching Bag O Crab name, and the ABC licence is an active on-sale restaurant licence that fits a seafood restaurant; the shared building with 3 businesses is offset by the name agreement, though no suite numbers are given to confirm the premises.
pair 0b9e9fd8dea1e6468097

Attributes

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

Trade area

Other outlets
110 within 1 mi · 469 within 3 mi
Off / on premise
34 / 74 within 1 mi · 122 / 305 within 3 mi
Selling alcohol
46 within 1 mi · 233 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.06 mi
Setting
urban (3,820 people per sq mi)
People within 3 mi
108,002 (74,731 adults 21+, 37,201 households) from 24 tract(s), tracts within 3 mi
Income
per capita $44,566 · median household ~$105,637 (weighted mean of tract medians)
Age and education
median age ~37.2 · bachelor's or higher 37%
Ethnicity
Hispanic 32% · White 55% · Black 2% · Asian 13%
Adults per alcohol outlet
319
Alcohol spend within 3 mi
$29,182,493 a year ($13,003,209 at home, $16,168,117 away) · $124,712 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-18 18:58insertdoordash 46601825 ↔ overture 2273777c-9768-428f-8f2f-d04428a3a5cfstreet written two waysmerged15
2026-11-18 18:58insertoverture 2273777c-9768-428f-8f2f-d04428a3a5cf ↔ ubereats PT34lcV8UuSl227YqEGF4Astreet written two waysmerged15
2026-11-02 23:02backfillca-abc 00678981|41|APP|0 ↔ ubereats PT34lcV8UuSl227YqEGF4AClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00678981|41|LIC|0 ↔ ubereats PT34lcV8UuSl227YqEGF4AClaude judge: samemerged
2026-10-26 01:00backfilldoordash 46601825 ↔ ubereats PT34lcV8UuSl227YqEGF4Asame address and namemerged
2026-10-17 21:00backfillca-abc 00678981|41|LIC|0 ↔ doordash 46601825same address and namemerged
2026-10-17 21:00backfillca-abc 00678981|41|APP|0 ↔ doordash 46601825same address and namemerged
2026-10-15 19:05backfillca-abc 00678981|41|APP|0 ↔ ca-abc 00678981|41|LIC|0one licence filemerged