CHARLIES TRIO CAFE

Alhambra, CA 91801 · O00c7650ce8d2 · first seen 2026-10-08
5 sourceson premise · restaurantalcohol: 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
CHARLIES TRIO CAFE 3 other
the most common name a source states
(dupe) Charlies Trio Cafe ubereats
Charlie's Trio Cafe overture
FATA CHARLES ANTHONY ca-abc (legal name)
Street
43-45 WEST MAIN ST 4 other
ca-abc
43 W MAIN ST ab-inbevvtinfo ×2
47 W Main St ubereats
47 W Main St #3510 overture
47 West Main Street ubereats
City
ALHAMBRA
ca-abcno other value
State
CA
ca-abcno other value
ZIP
91801
ca-abcno other value
Pin
34.09500, -118.12794 map 1 other
ubereats
52 m away ca-abc
Phone
6262844943
vtinfono other value
Licences
ca-abc 00332825|47|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O92696acd2367; O91bb20727f33; Ob0b81101b8ad; O299c47a25bfe; O305863a61580

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-inbevCHARLIES TRIO CAFE
2211336
43 W MAIN ST, ALHAMBRA, CA, 9180134.09484, -118.127682026-11-112026-11-12
ca-abcCHARLIES TRIO CAFE
legal name: FATA CHARLES ANTHONY
00332825|47|LIC|0
43-45 WEST MAIN ST, ALHAMBRA, CA, 9180134.09499, -118.127372026-10-082026-11-12
overtureCharlie's Trio Cafe
a794e509-325a-451f-8671-cdeec973082e
47 W Main St #3510, Alhambra, CA, 91801626284494334.09485, -118.127952026-11-062026-11-12
ubereats(dupe) Charlies Trio Cafe
3PQzAUPVQ-ekGxxp4uXJzA
47 W Main St, Alhambra, CA, 9180134.09500, -118.127942026-10-252026-11-12
ubereatsCharlies Trio Cafe
JhVs8ylQT0CSiRgtM7HVJQ
47 West Main Street, Alhambra, CA, 9180134.09489, -118.127942026-10-312026-11-12
vtinfoCHARLIES TRIO CAFE
8bee68b1b8c7761f
43 W MAIN ST, ALHAMBRA, CA, 91801626284494334.09496, -118.127582026-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 CHARLIES TRIO CAFEca-abc CHARLIES TRIO CAFE1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (95% confident; asked as a “proximity” pair)
Identical name and address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 93% confident — Both records carry the identical name CHARLIES TRIO CAFE at the same street number on W Main St in Alhambra 91801, with coordinates 32 m apart; the CA licence is an on-sale eating-place licence, which fits a cafe, and the same-name match outweighs the shared-building count.
pair 3cdf9243f2d3a1020212
ab-inbev CHARLIES TRIO CAFEvtinfo CHARLIES TRIO CAFE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
ca-abc CHARLIES TRIO CAFEubereats Charlies Trio Cafe1.00Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (85% confident; asked as a “near” pair)
The two records share a distinctive independent name, Charlies Trio Cafe, in the same city and ZIP. The addresses are adjacent (43-45 versus 47 West Main St), which is consistent with one restaurant w
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 88% confident — Same distinctive name, adjacent street numbers.
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records carry the same name (Charlies Trio Cafe) on the same West Main Street in Alhambra 91801, about 54 m apart, and the CA licence is an eating-place restaurant that matches the restaurant's Uber Eats listing; the 43-45 vs 47 street number mismatch and the two businesses counted at the address leave some doubt.
  • Claude Haiku 5.5, prompt v7: same, 80% confident — The names match exactly (Charlies Trio Cafe), the ABC licence is an on-sale eating-place restaurant consistent with a cafe, and the coordinates are about 54 m apart, though the street numbers differ (43-45 vs 47) in a building shared with another business.
  • Claude Haiku 5.5, prompt v4: same, 75% confident — The names are identical (Charlies Trio Cafe), the city and ZIP match, and the ABC eating-place licence fits a restaurant listed on Uber Eats; the only conflict is the street number (43-45 vs 47 West Main), which is adjacent and plausibly a numbering difference, though the shared building with two businesses leaves some doubt.
pair 44dda1e1ab512bf47c62
overture Charlie's Trio Cafeubereats Charlies Trio Cafe1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 4 m apart · name similarity 1.00
overture Charlie's Trio Cafeubereats (dupe) Charlies Trio Cafe0.81same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.96 · same street + ZIP · pins 16 m apart · name similarity 0.81

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47
Rule version 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
 "ue_location": [
  "DEFAULT"
 ],
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
157 within 1 mi · 1,118 within 3 mi
Off / on premise
25 / 101 within 1 mi · 190 / 704 within 3 mi
Selling alcohol
92 within 1 mi · 545 within 3 mi
Nearest
same channel 0.01 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,863 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 17:29insertab-inbev 2211336 ↔ ca-abc 00332825|47|LIC|0Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 2211336 ↔ vtinfo 8bee68b1b8c7761fsame address and namemerged12
2026-11-06 18:13insertoverture a794e509-325a-451f-8671-cdeec973082e ↔ ubereats 3PQzAUPVQ-ekGxxp4uXJzAsame address and namemerged11
2026-11-06 18:13insertoverture a794e509-325a-451f-8671-cdeec973082e ↔ ubereats JhVs8ylQT0CSiRgtM7HVJQsame address and namemerged11
2026-11-02 23:02backfillca-abc 00332825|47|LIC|0 ↔ ubereats JhVs8ylQT0CSiRgtM7HVJQClaude judge: samemerged