The Crabby Crab

SHERMAN OAKS, CA 91403 · O115653a7e37e · 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
The Crabby Crab 4 other
the most common name a source states
CLOUD GROUP INC ca-abc (legal name)
CRABBY CRAB vtinfo
The Crabby Crab 4457 Van Nuys Blvd toast
the crabby crab los angeles doordash
Street
4457 VAN NUYS BLVD 1 other
ca-abc
4457 Van Nuys Boulevard doordash
City
SHERMAN OAKS 1 other
ca-abc
Los Angeles doordashoverture ×2
State
CA
ca-abcno other value
ZIP
91403
ca-abcno other value
Pin
34.15263, -118.44908 map
toastno other value
Phone
8187892722
vtinfono other value
Licences
ca-abc 00514151|47|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O71c95aab777f; O4e79ce6b0a47; O315d49d5f4ff; O2f429d019b19

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-abcTHE CRABBY CRAB
legal name: CLOUD GROUP INC
00514151|47|LIC|0
4457 VAN NUYS BLVD, SHERMAN OAKS, CA, 9140334.15260, -118.448762026-10-082026-11-12
doordashthe crabby crab los angeles
87517
4457 Van Nuys Boulevard, Los Angeles, CA, 91403
ZIP lookup: Sherman Oaks, CA
34.15269, -118.448922026-10-082026-11-12
overtureThe Crabby Crab
4a9b70fa-3e38-4709-a131-89e42ec5c76a
4457 Van Nuys Blvd, Los Angeles, CA, 91403
ZIP lookup: Sherman Oaks, CA
818789272234.15262, -118.449012026-11-062026-11-12
toastThe Crabby Crab 4457 Van Nuys Blvd
legal name: The Crabby Crab
29383e88-1bf7-4d4e-9170-0b376c345b32
4457 Van Nuys Blvd., Sherman Oaks, CA, 91403818789272234.15263, -118.449082026-11-062026-11-12
vtinfoCRABBY CRAB
c7f880a58e2f3356
4457 VAN NUYS BLVD, SHERMAN OAKS, CA, 91403818789272234.15263, -118.449072026-11-122026-11-13

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 THE CRABBY CRABoverture The Crabby Crab1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 23 m apart · name similarity 1.00
ca-abc THE CRABBY CRABtoast The Crabby Crab 4457 Van Nuys Blvd1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 29 m apart · matched through the licence's legal name: The Crabby Crab · name similarity 1.00
ca-abc THE CRABBY CRABvtinfo CRABBY CRAB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 28 m apart · name similarity 1.00
doordash the crabby crab los angelesoverture The Crabby Crab1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · name similarity 1.00
overture The Crabby Crabtoast The Crabby Crab 4457 Van Nuys Blvd1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · matched through the licence's legal name: The Crabby Crab · name similarity 1.00 · phone: equal
overture The Crabby Crabvtinfo CRABBY CRAB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00 · phone: equal
toast The Crabby Crab 4457 Van Nuys Blvdvtinfo CRABBY CRAB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 1 m apart · matched through the licence's legal name: The Crabby Crab · name similarity 1.00 · phone: equal
ca-abc THE CRABBY CRABdoordash the crabby crab los angeles0.57Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
The records share the distinctive name 'The Crabby Crab' and the same street address and ZIP (Sherman Oaks is part of Los Angeles), and only one business is known at that address.
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 95% confident — Same name and address; Sherman Oaks is in LA.
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records name The Crabby Crab at 4457 Van Nuys Boulevard, ZIP 91403, with coordinates about 18 m apart, and no other business is held at that address, so the California on-sale restaurant licence and the DoorDash listing describe one outlet (the city difference is just Sherman Oaks versus Los Angeles addressing).
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records share the same street address and ZIP (4457 Van Nuys Blvd, 91403), the name 'The Crabby Crab' matches the DoorDash slug, the coordinates are about 18 m apart, and the only business at that address is the restaurant holding the active on-sale eating place licence.
  • Claude Haiku 5.5, prompt v4: same, 90% confident — Both records give the same street address and ZIP 91403 (Sherman Oaks is in Los Angeles), the name THE CRABBY CRAB matches the DoorDash slug, only one business is held at that address, and the active on-sale eating place licence fits a restaurant listed on a delivery app.
pair 1c11ef2cc1cc5df8b650

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
CLOUD GROUP INC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47
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
274 within 1 mi · 1,006 within 3 mi
Off / on premise
53 / 178 within 1 mi · 185 / 642 within 3 mi
Selling alcohol
115 within 1 mi · 474 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.03 mi
Setting
urban (6,171 people per sq mi)
People within 3 mi
174,484 (139,844 adults 21+, 74,655 households) from 47 tract(s), tracts within 3 mi
Income
per capita $70,423 · median household ~$109,197 (weighted mean of tract medians)
Age and education
median age ~40.1 · bachelor's or higher 53%
Ethnicity
Hispanic 29% · White 57% · Black 5% · Asian 7%
Adults per alcohol outlet
294
Alcohol spend within 3 mi
$60,846,956 a year ($26,757,006 at home, $34,068,022 away) · $128,099 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-13 19:03insertoverture 4a9b70fa-3e38-4709-a131-89e42ec5c76a ↔ vtinfo c7f880a58e2f3356same address and namemerged15
2026-11-12 14:25insertca-abc 00514151|47|LIC|0 ↔ vtinfo c7f880a58e2f3356same address and namemerged12
2026-11-12 14:25inserttoast 29383e88-1bf7-4d4e-9170-0b376c345b32 ↔ vtinfo c7f880a58e2f3356same address and namemerged12
2026-11-12 14:25insertca-abc 00514151|47|LIC|0 ↔ toast 29383e88-1bf7-4d4e-9170-0b376c345b32same address and namemerged12
2026-11-12 14:25insertoverture 4a9b70fa-3e38-4709-a131-89e42ec5c76a ↔ toast 29383e88-1bf7-4d4e-9170-0b376c345b32same address and namemerged12
2026-11-06 18:13insertca-abc 00514151|47|LIC|0 ↔ overture 4a9b70fa-3e38-4709-a131-89e42ec5c76asame address and namemerged11
2026-11-06 18:13insertdoordash 87517 ↔ overture 4a9b70fa-3e38-4709-a131-89e42ec5c76asame address and namemerged11
2026-11-02 23:02backfillca-abc 00514151|47|LIC|0 ↔ doordash 87517Claude judge: samemerged