Outlets /
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.
| Field | Master value | Taken from | What 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-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 93611 | ca-abc | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ca-abc | BAG O CRAB legal name: OCEANVIEW CLOVIS LLC 00678981|41|APP|0 | 1805 HERNDON AVE, CLOVIS, CA, 93611 | 36.83741, -119.68340 | 2026-10-08 | 2026-11-05 | |
| ca-abc | BAG O CRAB legal name: OCEANVIEW CLOVIS LLC 00678981|41|LIC|0 | 1805 HERNDON AVE, CLOVIS, CA, 93611 | 36.83741, -119.68340 | 2026-10-15 | 2026-11-05 | |
| doordash | bag o' crab clovis 46601825 | 1805 Herndon Ave, Clovis, CA, 93611 | 36.83894, -119.68380 | 2026-10-08 | 2026-10-26 | |
| overture | Bag O' Crab Clovis 2273777c-9768-428f-8f2f-d04428a3a5cf | 1805 Herndon Ave B, Clovis, CA, 93611 | 5593218009 | 36.83894, -119.68375 | 2026-11-18 | 2026-11-18 |
| ubereats | Bag O Crab Clovis PT34lcV8UuSl227YqEGF4A | 1805 Herndon Avenue, Clovis, CA, 93611 | 36.83896, -119.68376 | 2026-10-26 | 2026-10-26 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ca-abc BAG O CRAB | ca-abc BAG O CRAB | 1.00 | one licence file | merged | file: 00678981 · same_address |
| ca-abc BAG O CRAB | doordash bag o' crab clovis | 1.00 | same address and name | merged | address similarity 1.00 · same street + city + state · name similarity 1.00 |
| ca-abc BAG O CRAB | doordash bag o' crab clovis | 1.00 | same address and name | merged | address similarity 1.00 · same street + city + state · name similarity 1.00 |
| doordash bag o' crab clovis | overture Bag O' Crab Clovis | 1.00 | street written two ways | merged | name Jaro-Winkler 1.00 · matched on zip · pins 5 m apart · name similarity 1.00 · street similarity 0.92 |
| doordash bag o' crab clovis | ubereats Bag O Crab Clovis | 1.00 | same address and name | merged | address similarity 1.00 · same street + ZIP · pins 4 m apart · name similarity 1.00 |
| overture Bag O' Crab Clovis | ubereats Bag O Crab Clovis | 1.00 | street written two ways | merged | name Jaro-Winkler 1.00 · matched on zip · pins 3 m apart · name similarity 1.00 · street similarity 0.92 |
| ca-abc BAG O CRAB | ubereats Bag O Crab Clovis | 0.74 | Claude judge: same | merged | 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:
pair 34fefb7dcd99f10336e6 |
| ca-abc BAG O CRAB | ubereats Bag O Crab Clovis | 0.74 | Claude judge: same | merged | 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:
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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-18 18:58 | insert | doordash 46601825 ↔ overture 2273777c-9768-428f-8f2f-d04428a3a5cf | street written two ways | merged | 15 |
| 2026-11-18 18:58 | insert | overture 2273777c-9768-428f-8f2f-d04428a3a5cf ↔ ubereats PT34lcV8UuSl227YqEGF4A | street written two ways | merged | 15 |
| 2026-11-02 23:02 | backfill | ca-abc 00678981|41|APP|0 ↔ ubereats PT34lcV8UuSl227YqEGF4A | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00678981|41|LIC|0 ↔ ubereats PT34lcV8UuSl227YqEGF4A | Claude judge: same | merged | |
| 2026-10-26 01:00 | backfill | doordash 46601825 ↔ ubereats PT34lcV8UuSl227YqEGF4A | same address and name | merged | |
| 2026-10-17 21:00 | backfill | ca-abc 00678981|41|LIC|0 ↔ doordash 46601825 | same address and name | merged | |
| 2026-10-17 21:00 | backfill | ca-abc 00678981|41|APP|0 ↔ doordash 46601825 | same address and name | merged | |
| 2026-10-15 19:05 | backfill | ca-abc 00678981|41|APP|0 ↔ ca-abc 00678981|41|LIC|0 | one licence file | merged |