The Boiling Crab

BURBANK, CA 91502 · O376c16918d4e · first seen 2026-10-08
2 sourceson premise · restaurantalcohol: licensed2 licences

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 2 other
a licence name in capitals, cleaned (derived; record_title.py)
THE BOILING CRAB OPERATIONS LLC ca-abc (legal name) ×2
dup - The Boiling Crab ubereats
Street
140 E PALM AVE 1 other
ca-abc
140 E Palm Ave #210 ubereats
City
BURBANK
ca-abcno other value
State
CA
ca-abcno other value
ZIP
91502
ca-abcno other value
Pin
34.18166, -118.31123 map
ubereatsno other value
Phone
none
no other value
Licences
ca-abc 00671635|47|LIC|0 · ca-abc 00671635|58|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ofadaf3da0a9e; Oc529e0328014

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 OPERATIONS LLC
00671635|47|LIC|0
140 E PALM AVE, BURBANK, CA, 9150234.18158, -118.311422026-10-082026-11-05
ca-abcTHE BOILING CRAB
legal name: THE BOILING CRAB OPERATIONS LLC
00671635|58|LIC|0
140 E PALM AVE, BURBANK, CA, 9150234.18158, -118.311422026-10-082026-11-05
ubereatsdup - The Boiling Crab
hoTaAwKqS3CkNV0HbrztVw
140 E Palm Ave #210, Burbank, CA, 9150234.18166, -118.311232026-10-102026-11-03

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 THE BOILING CRABca-abc THE BOILING CRAB1.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 86 m apart · name similarity 1.00
ab-inbev THE BOILING CRABca-abc THE BOILING CRAB1.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 86 m apart · name similarity 1.00
ca-abc BOILING CRABca-abc THE BOILING CRAB1.00one store listed twiceheld duplicate-bridges-sourcessame street + ZIP · name: identical
ca-abc THE BOILING CRABubereats The Boiling Crab1.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 56 m apart · name similarity 1.00
ca-abc THE BOILING CRABvtinfo THE BOILING CRAB1.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 28 m apart · name similarity 1.00
ca-abc THE BOILING CRABubereats The Boiling Crab1.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 56 m apart · name similarity 1.00
ca-abc THE BOILING CRABvtinfo THE BOILING CRAB1.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 28 m apart · name similarity 1.00
ab-inbev THE BOILING CRABubereats dup - The Boiling Crab0.76same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 0.95 · same street + ZIP · pins 68 m apart · name similarity 0.76
ca-abc BOILING CRABubereats dup - The Boiling Crab0.76same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 0.95 · same street + ZIP · pins 20 m apart · name similarity 0.76
ca-abc BOILING CRABubereats dup - The Boiling Crab0.76same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 0.95 · same street + ZIP · pins 20 m apart · name similarity 0.76
ubereats dup - The Boiling Crabvtinfo THE BOILING CRAB0.76same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 0.95 · same street + ZIP · pins 26 m apart · name similarity 0.76
ca-abc THE BOILING CRABca-abc THE BOILING CRAB1.00one licence filemergedfile: 00671635 · same_address
ca-abc THE BOILING CRABubereats dup - The Boiling Crab0.76Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (80% confident; asked as a “near” pair)
Both records are The Boiling Crab at 140 E Palm Ave, Burbank 91502, and the names agree, so the shared building and one-sided suite number do not split them; the 'dup' Uber Eats listing is a second li
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 75% confident — The Uber Eats listing 'dup - The Boiling Crab' matches the ca-abc licensee name The Boiling Crab at the same street address, city and ZIP, and the 'dup' label marks it as a duplicate listing. The suite #210 appears only in B, and the building is shared with another business, so the suite leaves some doubt.
pair aa92cd476920cf8ba30c
ca-abc THE BOILING CRABubereats dup - The Boiling Crab0.76Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (82% confident; asked as a “near” pair)
The names agree ('The Boiling Crab') at the same street address and ZIP, so the second business in the building is ruled out by name; the suite named on one side only and the 'dup' prefix do not point
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 80% confident — Both records name The Boiling Crab at 140 E Palm Ave, Burbank, 91502, and the ABC record is a restaurant licence, which fits an Uber Eats restaurant listing; the building is shared and only the Uber Eats record gives suite #210, so the match rests on the matching name and address rather than a confirmed suite.
pair c36a7765cf383ee75743

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
THE BOILING CRAB OPERATIONS LLC — 4 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47; CA 58 (add-on: follows the base licence)
Rule version 9, computed 2026-11-17 18:21.
Every vote behind these (raw)
{
 "ue_location": [
  "DEFAULT"
 ],
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
307 within 1 mi · 880 within 3 mi
Off / on premise
52 / 210 within 1 mi · 178 / 557 within 3 mi
Selling alcohol
157 within 1 mi · 433 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.02 mi
Setting
urban (5,166 people per sq mi)
People within 3 mi
146,057 (113,275 adults 21+, 57,580 households) from 37 tract(s), tracts within 3 mi
Income
per capita $54,081 · median household ~$101,481 (weighted mean of tract medians)
Age and education
median age ~41.1 · bachelor's or higher 46%
Ethnicity
Hispanic 22% · White 62% · Black 3% · Asian 11%
Adults per alcohol outlet
261
Alcohol spend within 3 mi
$45,109,297 a year ($20,038,654 at home, $25,051,863 away) · $103,938 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-14 20:23updateubereats hoTaAwKqS3CkNV0HbrztVw ↔ vtinfo 5d29f9fcb412479asame address and nameheld: same-source-conflict15
2026-11-14 20:23updateca-abc 00671635|58|LIC|0 ↔ vtinfo 5d29f9fcb412479asame address and nameheld: same-source-conflict15
2026-11-14 20:23updateca-abc 00671635|47|LIC|0 ↔ vtinfo 5d29f9fcb412479asame address and nameheld: same-source-conflict15
2026-11-12 14:25insertubereats hoTaAwKqS3CkNV0HbrztVw ↔ vtinfo 5d29f9fcb412479asame address and nameheld: same-source-conflict12
2026-11-12 14:25insertca-abc 00671635|58|LIC|0 ↔ vtinfo 5d29f9fcb412479asame address and nameheld: same-source-conflict12
2026-11-12 14:25insertca-abc 00671635|47|LIC|0 ↔ vtinfo 5d29f9fcb412479asame address and nameheld: same-source-conflict12
2026-11-11 12:56insertab-inbev 4036735 ↔ ubereats hoTaAwKqS3CkNV0HbrztVwsame address and nameheld: same-source-conflict12
2026-11-11 12:56insertab-inbev 4036735 ↔ ca-abc 00671635|58|LIC|0same address and nameheld: same-source-conflict12
2026-11-11 12:56insertab-inbev 4036735 ↔ ca-abc 00671635|47|LIC|0same address and nameheld: same-source-conflict12
2026-11-05 17:26backfillca-abc 00572044|41|LIC|0 ↔ ca-abc 00671635|47|LIC|0one store listed twiceheld: duplicate-bridges-sources
2026-11-03 13:33backfillca-abc 00572044|41|LIC|0 ↔ ubereats hoTaAwKqS3CkNV0HbrztVwsame address and nameheld: same-source-conflict
2026-11-03 13:33backfillca-abc 00572044|58|LIC|0 ↔ ubereats hoTaAwKqS3CkNV0HbrztVwsame address and nameheld: same-source-conflict
2026-11-03 13:33backfillca-abc 00671635|58|LIC|0 ↔ ubereats VnjesBHOTA6YDn86dOIvuwsame address and nameheld: same-source-conflict
2026-11-03 13:33backfillca-abc 00671635|47|LIC|0 ↔ ubereats VnjesBHOTA6YDn86dOIvuwsame address and nameheld: same-source-conflict
2026-11-02 23:02backfillca-abc 00671635|58|LIC|0 ↔ ubereats hoTaAwKqS3CkNV0HbrztVwClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00671635|47|LIC|0 ↔ ubereats hoTaAwKqS3CkNV0HbrztVwClaude judge: samemerged
2026-10-09 13:59backfillca-abc 00671635|47|LIC|0 ↔ ca-abc 00671635|58|LIC|0one licence filemerged