Bag O Crab

Sunnyvale, CA 94087 · O0ddfa05c08c5 · first seen 2026-10-08
3 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 2 other
the most common name a source states
bag o crab 108 e el camino real sunnyvale doordash
SY HOUSE INC ca-abc (legal name)
Street
108 E EL CAMINO REAL
ca-abcno other value
City
SUNNYVALE
ca-abcno other value
State
CA
ca-abcno other value
ZIP
95124 1 other
ca-abc
94087 overture
Pin
37.36687, -122.03194 map 1 other
doordash
178 m away ca-abc
Phone
4082124710
overtureno other value
Licences
ca-abc 00671312|41|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of9d0a17bfbaa; O76c3d8059b67

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: SY HOUSE INC
00671312|41|LIC|0
108 E EL CAMINO REAL, SUNNYVALE, CA, 95124
ZIP lookup: San Jose, CA
37.36808, -122.033252026-10-082026-11-17
doordashbag o crab 108 e el camino real sunnyvale
34765291
108 E El Camino Real, Sunnyvale, CA37.36687, -122.031942026-10-082026-11-16
overtureBag O Crab
3467bc0a-84cc-4983-99be-77dc093e7e24
108 E El Camino Real, Sunnyvale, CA, 94087408212471037.36689, -122.032042026-11-062026-11-17

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 CRABoverture Bag O Crab1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 171 m apart · name similarity 1.00
ca-abc BAG O CRABdoordash bag o crab 108 e el camino real sunnyvale0.43one name contains the other, same addressmergedjudge: None · pair_id: 445458ed410a7fc83d9f · person: None · rule: names contained at one address · stratum: same-address

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
SY HOUSE 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:20.
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
255 within 1 mi · 991 within 3 mi
Off / on premise
34 / 184 within 1 mi · 172 / 626 within 3 mi
Selling alcohol
136 within 1 mi · 469 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.01 mi
Setting
urban (8,554 people per sq mi)
People within 3 mi
241,864 (187,616 adults 21+, 93,719 households) from 52 tract(s), tracts within 3 mi
Income
per capita $105,592 · median household ~$199,183 (weighted mean of tract medians)
Age and education
median age ~36.8 · bachelor's or higher 73%
Ethnicity
Hispanic 15% · White 30% · Black 2% · Asian 50%
Adults per alcohol outlet
400
Alcohol spend within 3 mi
$106,547,454 a year ($44,291,064 at home, $62,230,523 away) · $227,180 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-17 17:19insertca-abc 00671312|41|LIC|0 ↔ doordash 34765291one name contains the other, same addressmerged15
2026-11-06 18:13insertca-abc 00671312|41|LIC|0 ↔ overture 3467bc0a-84cc-4983-99be-77dc093e7e24same address and namemerged11