Shaking Crab

Bronx, NY 10462 · O051787975206 · first seen 2026-10-08
4 sourceson premise · restaurantchain: Shaking Crabalcohol: 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
Shaking Crab 3 other
a licence name in capitals, cleaned (derived; record_title.py)
SC WHITE PLAINS LLC ny-sla (legal name)
Shaking Crab (Bronx) overture
shaking crab bronx doordash
Street
2179 WHITE PLAINS RD 1 other
ny-sla
2179 WHITE PLAINS ROAD inspections
City
BRONX
ny-slano other value
State
NY
ny-slano other value
ZIP
10462
ny-slano other value
Pin
40.85596, -73.86785 map
doordashno other value
Phone
9146772903 1 other
overture
3477012939 inspections
Licences
ny-sla 0340-22-108273
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O24365934ac4f; Ofc5027c57615; O59d067ad0242

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
doordashshaking crab bronx
29189851
2179 White Plains Rd, Bronx, NY, 1046240.85596, -73.867852026-10-082026-11-03
inspectionsSHAKING CRAB
inspections|nyc|50176132
2179 WHITE PLAINS ROAD, Bronx, NY, 10462347701293940.85575, -73.867662026-11-192026-11-19
ny-slaSHAKING CRAB
legal name: SC WHITE PLAINS LLC
0340-22-108273
2179 WHITE PLAINS RD, BRONX, NY, 1046240.85596, -73.867652026-11-022026-11-05
overtureShaking Crab (Bronx)
d1477247-9868-4aaf-b10a-56a044d0b53f
2179 White Plains Rd, Bronx, NY, 10462914677290340.85590, -73.868022026-11-062026-11-06

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
ny-sla SHAKING CRABoverture 693bee25-6655-4580-8daa-458a8239d5891.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 22 m apart · matched through the licence's legal name: SC WHITE PLAINS LLC · name similarity 1.00
doordash shaking crab bronxinspections SHAKING CRAB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 28 m apart · name similarity 1.00
doordash shaking crab bronxny-sla SHAKING CRAB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
doordash shaking crab bronxoverture Shaking Crab (Bronx)1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
inspections SHAKING CRABny-sla SHAKING CRAB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 23 m apart · name similarity 1.00

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
Shaking Crab — overture-brand
Alcohol
licensed — a licence or TTB permit on file
Operator
SC WHITE PLAINS LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — NY 0340
Rule version 11, computed 2026-11-20 23:31.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
378 within 1 mi · 3,652 within 3 mi
Off / on premise
60 / 225 within 1 mi · 675 / 1,893 within 3 mi
Selling alcohol
175 within 1 mi · 1,958 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.02 mi
Setting
urban (39,689 people per sq mi)
People within 3 mi
1,122,167 (806,009 adults 21+, 425,954 households) from 284 tract(s), tracts within 3 mi
Income
per capita $26,473 · median household ~$51,678 (weighted mean of tract medians)
Age and education
median age ~36.6 · bachelor's or higher 22%
Ethnicity
Hispanic 56% · White 12% · Black 32% · Asian 5%
Adults per alcohol outlet
411
Alcohol spend within 3 mi
$211,078,306 a year ($101,920,290 at home, $109,030,839 away) · $107,748 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-19 20:37insertinspections inspections|nyc|50176132 ↔ ny-sla 0340-22-108273same address and namemerged17
2026-11-19 20:37insertdoordash 29189851 ↔ inspections inspections|nyc|50176132same address and namemerged17
2026-11-06 18:13insertny-sla 0340-22-108273 ↔ overture 693bee25-6655-4580-8daa-458a8239d589same address and nameheld: same-source-conflict11
2026-11-06 18:13insertdoordash 29189851 ↔ overture d1477247-9868-4aaf-b10a-56a044d0b53fsame address and namemerged11
2026-11-03 13:33backfilldoordash 29189851 ↔ ny-sla 0340-22-108273same address and namemerged