Bag O' Crab

SANTA ROSA, CA 95401 · O455c08c227d3 · first seen 2026-10-08
5 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
Bag O' Crab 4 other
a licence name in capitals, cleaned (derived; record_title.py)
BAG O CRAB ab-inbevca-abcvtinfo ×3
Bag O' Crab - Santa Rosa overture
bag o' crab santa rosa doordash
SEAHOUSE SR INC ca-abc (legal name)
Street
1901 MENDOCINO AVE 1 other
ca-abc
1901 Mendocino Avenue doordash
City
SANTA ROSA
ca-abcno other value
State
CA
ca-abcno other value
ZIP
95401
ca-abcno other value
Pin
38.45919, -122.71756 map
doordashno other value
Phone
5555555555 1 other
vtinfo
7078437267 overture
Licences
ca-abc 00644453|41|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ocea0f9f1b1b5; O93213dd5deae; Oea72f8a31db2; Ob7f4f4eb771f

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-inbevBAG O CRAB
4605961
1901 MENDOCINO AVE, SANTA ROSA, CA, 9540138.45914, -122.717632026-11-112026-11-11
ca-abcBAG O CRAB
legal name: SEAHOUSE SR INC
00644453|41|LIC|0
1901 MENDOCINO AVE, SANTA ROSA, CA, 9540138.45915, -122.717232026-10-082026-11-06
doordashbag o' crab santa rosa
24683530
1901 Mendocino Avenue, Santa Rosa, CA, 9540138.45919, -122.717562026-10-082026-11-06
overtureBag O' Crab - Santa Rosa
49102062-10d1-4171-8043-d2564d9df4a6
1901 Mendocino Ave, Santa Rosa, CA, 95401707843726738.45914, -122.717642026-11-062026-11-06
vtinfoBAG O CRAB
665a8f2c226532b6
1901 MENDOCINO AVE, SANTA ROSA, CA, 95401555555555538.45914, -122.717642026-11-122026-11-14

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 BAG O CRABca-abc BAG O CRAB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 35 m apart · name similarity 1.00
ab-inbev BAG O CRABdoordash bag o' crab santa rosa1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · name similarity 1.00
ab-inbev BAG O CRABvtinfo BAG O CRAB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 1 m apart · name similarity 1.00
ca-abc BAG O CRABdoordash bag o' crab santa rosa1.00same address and namemergedaddress similarity 1.00 · same street + city + state · name similarity 1.00
ca-abc BAG O CRABvtinfo BAG O CRAB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 36 m apart · name similarity 1.00
doordash bag o' crab santa rosaoverture Bag O' Crab - Santa Rosa1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · name similarity 1.00
doordash bag o' crab santa rosavtinfo BAG O CRAB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 9 m apart · name similarity 1.00

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
SEAHOUSE SR INC — 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:21.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
148 within 1 mi · 1,016 within 3 mi
Off / on premise
47 / 82 within 1 mi · 321 / 457 within 3 mi
Selling alcohol
87 within 1 mi · 705 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.02 mi
Setting
urban (4,111 people per sq mi)
People within 3 mi
116,225 (87,973 adults 21+, 44,788 households) from 27 tract(s), tracts within 3 mi
Income
per capita $49,091 · median household ~$100,610 (weighted mean of tract medians)
Age and education
median age ~40.9 · bachelor's or higher 32%
Ethnicity
Hispanic 41% · White 50% · Black 2% · Asian 5%
Adults per alcohol outlet
125
Alcohol spend within 3 mi
$34,046,723 a year ($15,279,211 at home, $18,752,542 away) · $48,225 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:25insertab-inbev 4605961 ↔ vtinfo 665a8f2c226532b6same address and namemerged12
2026-11-12 14:25insertca-abc 00644453|41|LIC|0 ↔ vtinfo 665a8f2c226532b6same address and namemerged12
2026-11-12 14:25insertdoordash 24683530 ↔ vtinfo 665a8f2c226532b6same address and namemerged12
2026-11-11 12:56insertab-inbev 4605961 ↔ ca-abc 00644453|41|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 4605961 ↔ doordash 24683530same address and namemerged12
2026-11-06 18:13insertdoordash 24683530 ↔ overture 49102062-10d1-4171-8043-d2564d9df4a6same address and namemerged11
2026-10-18 21:02backfillca-abc 00644453|41|LIC|0 ↔ doordash 24683530same address and namemerged