The Boiling Crab

Tustin, CA 92780 · O745932e149f7 · first seen 2026-10-08
5 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 3 other
the most common name a source states
BOILING CRAB ab-inbevca-abc ×2
the boiling crab tustin doordash
TRC TUSTIN LLC ca-abc (legal name)
Street
13451 NEWPORT AVE 1 other
ca-abc
13451 Newport Avenue ubereats
City
TUSTIN
ca-abcno other value
State
CA
ca-abcno other value
ZIP
92780
ca-abcno other value
Pin
33.74446, -117.81634 map 1 other
ubereats
83 m away ca-abc
Phone
7146562264
overtureno other value
Licences
ca-abc 00677532|47|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ob70dfdcf11c0; Od1d02cd4c09f; Oa5183a6a22f6; Obbbb60423f9a

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
ab-inbevBOILING CRAB
4979862
13451 NEWPORT AVE, TUSTIN, CA, 9278033.74460, -117.816182026-11-112026-11-11
ca-abcBOILING CRAB
legal name: TRC TUSTIN LLC
00677532|47|LIC|0
13451 NEWPORT AVE, TUSTIN, CA, 9278033.74376, -117.816642026-10-082026-11-06
doordashthe boiling crab tustin
48511135
13451 Newport Ave, Tustin, CA, 9278033.74446, -117.816182026-10-082026-11-06
overtureThe Boiling Crab
f4fa172e-5503-45ca-9c2a-4581dd32a20d
13451 Newport Ave, Tustin, CA, 92780714656226433.74444, -117.816172026-11-062026-11-06
ubereatsThe Boiling Crab
PZwfVUAeX0m5UbsMbJvPlQ
13451 Newport Avenue, Tustin, CA, 9278033.74446, -117.816342026-10-282026-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
ab-inbev BOILING CRABca-abc BOILING CRAB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 103 m apart · name similarity 1.00
ab-inbev BOILING CRABdoordash the boiling crab tustin1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
ab-inbev BOILING CRABoverture The Boiling Crab1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 18 m apart · name similarity 1.00
ab-inbev BOILING CRABubereats The Boiling Crab1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 22 m apart · name similarity 1.00
ca-abc BOILING CRABdoordash the boiling crab tustin1.00same address and namemergedaddress similarity 1.00 · same street + city + state · name similarity 1.00
ca-abc BOILING CRABoverture The Boiling Crab1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 87 m apart · name similarity 1.00
ca-abc BOILING CRABubereats The Boiling Crab1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · name similarity 1.00
doordash the boiling crab tustinoverture The Boiling Crab1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 2 m apart · name similarity 1.00
doordash the boiling crab tustinubereats The Boiling Crab1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · pins 14 m apart · name similarity 1.00
overture The Boiling Crabubereats The Boiling Crab1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00

Attributes

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

Trade area

Other outlets
215 within 1 mi · 951 within 3 mi
Off / on premise
49 / 141 within 1 mi · 200 / 592 within 3 mi
Selling alcohol
128 within 1 mi · 493 within 3 mi
Nearest
same channel 0.03 mi · licensed 0.05 mi
Setting
urban (7,594 people per sq mi)
People within 3 mi
214,722 (155,537 adults 21+, 69,553 households) from 39 tract(s), tracts within 3 mi
Income
per capita $50,347 · median household ~$124,661 (weighted mean of tract medians)
Age and education
median age ~37.4 · bachelor's or higher 43%
Ethnicity
Hispanic 49% · White 33% · Black 1% · Asian 20%
Adults per alcohol outlet
315
Alcohol spend within 3 mi
$60,472,550 a year ($26,451,997 at home, $33,998,198 away) · $122,414 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:56insertab-inbev 4979862 ↔ ubereats PZwfVUAeX0m5UbsMbJvPlQsame address and namemerged12
2026-11-11 12:56insertab-inbev 4979862 ↔ ca-abc 00677532|47|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 4979862 ↔ doordash 48511135same address and namemerged12
2026-11-11 12:56insertab-inbev 4979862 ↔ overture f4fa172e-5503-45ca-9c2a-4581dd32a20dsame address and namemerged12
2026-11-06 18:13insertoverture f4fa172e-5503-45ca-9c2a-4581dd32a20d ↔ ubereats PZwfVUAeX0m5UbsMbJvPlQsame address and namemerged11
2026-11-06 18:13insertca-abc 00677532|47|LIC|0 ↔ overture f4fa172e-5503-45ca-9c2a-4581dd32a20dsame address and namemerged11
2026-11-06 18:13insertdoordash 48511135 ↔ overture f4fa172e-5503-45ca-9c2a-4581dd32a20dsame address and namemerged11
2026-10-28 02:02backfilldoordash 48511135 ↔ ubereats PZwfVUAeX0m5UbsMbJvPlQsame address and namemerged
2026-10-28 02:02backfillca-abc 00677532|47|LIC|0 ↔ ubereats PZwfVUAeX0m5UbsMbJvPlQsame address and namemerged
2026-10-27 01:03backfillca-abc 00677532|47|LIC|0 ↔ doordash 48511135same address and namemerged