The Boiling Crab

ALHAMBRA, CA 91801 · O303ec734fbdc · first seen 2026-11-11
2 sourceson premise · predictedalcohol: alcohol

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
a licence name in capitals, cleaned (derived; record_title.py)no other value
Street
33 W MAIN ST
ab-inbevno other value
City
ALHAMBRA
ab-inbevno other value
State
CA
ab-inbevno other value
ZIP
91801
ab-inbevno other value
Pin
34.09484, -118.12768 map
ab-inbevno other value
Phone
6263005898
vtinfono other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oebdd7b607cde

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-inbevTHE BOILING CRAB
3942155
33 W MAIN ST, ALHAMBRA, CA, 9180134.09484, -118.127682026-11-112026-11-11
vtinfoTHE BOILING CRAB
39b945bbfcddf871
33 W MAIN ST, ALHAMBRA, CA, 91801626300589834.09509, -118.127742026-11-122026-11-14

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 CRABvtinfo THE BOILING CRAB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 29 m apart · name similarity 1.00

Attributes

Channel
unknown
Chain
none
Alcohol
alcohol — listed as carrying Bud Light (AB InBev), Heineken USA, Michelob Ultra (AB InBev) by the supplier's own store finder or locator
Operator
none
Licence privileges
none
Rule version 9, computed 2026-11-17 18:21.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
158 within 1 mi · 1,118 within 3 mi
Off / on premise
25 / 103 within 1 mi · 190 / 705 within 3 mi
Selling alcohol
93 within 1 mi · 546 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.02 mi
Setting
urban (8,745 people per sq mi)
People within 3 mi
247,245 (195,571 adults 21+, 86,720 households) from 62 tract(s), tracts within 3 mi
Income
per capita $48,427 · median household ~$102,352 (weighted mean of tract medians)
Age and education
median age ~43.4 · bachelor's or higher 42%
Ethnicity
Hispanic 31% · White 16% · Black 2% · Asian 51%
Adults per alcohol outlet
358
Alcohol spend within 3 mi
$66,537,077 a year ($29,650,059 at home, $36,859,851 away) · $121,640 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-12 14:25insertab-inbev 3942155 ↔ vtinfo 39b945bbfcddf871same address and namemerged12