The Boiling Crab

Alhambra, CA 91801 · O82e1673cb6ff · first seen 2026-10-08
3 sourceson premise · restaurantchain: The Boiling 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
The Boiling Crab 1 other
the most common name a source states
THE BOILING CRAB ALHAMBRA MAIN LLC ca-abc (legal name)
Street
129 W MAIN ST 1 other
ca-abc
121 W. Main St ubereats
City
ALHAMBRA
ca-abcno other value
State
CA
ca-abcno other value
ZIP
91801
ca-abcno other value
Pin
34.09453, -118.12850 map
ubereatsno other value
Phone
6263005898
overtureno other value
Licences
ca-abc 00621033|41|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc155d5550fab; O9740905bae8c

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 BOILING CRAB
legal name: THE BOILING CRAB ALHAMBRA MAIN LLC
00621033|41|LIC|0
129 W MAIN ST, ALHAMBRA, CA, 9180134.09457, -118.128262026-10-082026-11-06
overtureThe Boiling Crab
1f89ac32-c6f0-4aa8-bfd8-fd81be7ae3fe
129 W Main St, Alhambra, CA, 91801626300589834.09448, -118.128592026-11-062026-11-06
ubereatsThe Boiling Crab
0Ad4OHLFXy2iNyNG3ndqvA
121 W. Main St, Alhambra, CA, 9180134.09453, -118.128502026-10-212026-11-11

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 BOILING CRABoverture The Boiling Crab1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 32 m apart · name similarity 1.00
ca-abc THE BOILING CRABubereats The Boiling Crab1.00Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (85% confident; asked as a “proximity” pair)
Both records name The Boiling Crab on W Main St in Alhambra, 22 m apart. The street numbers 129 and 121 differ only slightly, likely one storefront spanning both numbers, and our data holds only one b
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 80% confident — Both records carry the same name, The Boiling Crab, in the same city and ZIP on W Main St, with coordinates about 22 m apart and only one business at the address; the house numbers differ (129 vs 121), which is a minor discrepancy that likely reflects address entry or geocoding, not a second premises.
pair f81e46b04a827376eed3

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
The Boiling Crab — ubereats-parent
Alcohol
licensed — a licence or TTB permit on file
Operator
THE BOILING CRAB ALHAMBRA MAIN 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:23.
Every vote behind these (raw)
{
 "ue_location": [
  "PHYSICAL"
 ],
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
161 within 1 mi · 1,115 within 3 mi
Off / on premise
27 / 103 within 1 mi · 190 / 703 within 3 mi
Selling alcohol
94 within 1 mi · 545 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
urban (8,616 people per sq mi)
People within 3 mi
243,600 (192,644 adults 21+, 85,432 households) from 61 tract(s), tracts within 3 mi
Income
per capita $48,079 · median household ~$101,636 (weighted mean of tract medians)
Age and education
median age ~43.3 · bachelor's or higher 42%
Ethnicity
Hispanic 31% · White 16% · Black 2% · Asian 51%
Adults per alcohol outlet
353
Alcohol spend within 3 mi
$65,201,388 a year ($29,085,802 at home, $36,088,906 away) · $119,416 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-11 12:56insertca-abc 00621033|41|LIC|0 ↔ ubereats 0Ad4OHLFXy2iNyNG3ndqvAClaude judge: samemerged12
2026-11-06 18:13insertca-abc 00621033|41|LIC|0 ↔ overture 1f89ac32-c6f0-4aa8-bfd8-fd81be7ae3fesame address and namemerged11