Trader Joe's

COSTA MESA, CA 92627 · O349a10df27aa · first seen 2026-10-08
4 sourcesoff premise · grocerychain: Trader Joe'salcohol: 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
Trader Joe's 3 other
the most common name a source states
TRADER JOES 35 ca-abc ×2
TRADER JOES COMPANY ca-abc (legal name) ×2
TRADER JOES vtinfo
Street
640 W 17th St
trader-joesno other value
City
Costa Mesa
trader-joesno other value
State
CA
trader-joesno other value
ZIP
92627
trader-joesno other value
Pin
33.63679, -117.92458 map 1 other
trader-joes
146 m away ca-abc ×2
Phone
9496425134 1 other
trader-joes
9496425968 vtinfo
Licences
ca-abc 00321989|21|LIC|0 · ca-abc 00321989|42|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ob157fe308568; Oc29edd120e8e; O7997848cf05b; O4739a0229f5e

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-abcTRADER JOES 35
legal name: TRADER JOES COMPANY
00321989|21|LIC|0
640 W 17TH ST, COSTA MESA, CA, 9262733.63622, -117.926002026-10-082026-11-06
ca-abcTRADER JOES 35
legal name: TRADER JOES COMPANY
00321989|42|LIC|0
640 W 17TH ST, COSTA MESA, CA, 9262733.63622, -117.926002026-10-082026-11-06
overtureTrader Joe's
8f9130e5-e7f0-4764-a709-79a7cb6e65df
640 W 17th St, Costa Mesa, CA, 92627949642513433.63671, -117.924742026-11-062026-11-06
trader-joesTrader Joe's
35
640 W 17th St, Costa Mesa, CA, 92627949642513433.63679, -117.924582026-10-082026-11-06
vtinfoTRADER JOES
34966637a32d2147
640 W 17TH ST, COSTA MESA, CA, 92627949642596833.63667, -117.924942026-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
ca-abc TRADER JOES 35ca-abc TRADER JOES 351.00one licence filemergedfile: 00321989 · same_address
ca-abc TRADER JOES 35overture Trader Joe's1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 130 m apart · matched through the licence's legal name: TRADER JOES COMPANY · name similarity 1.00
ca-abc TRADER JOES 35vtinfo TRADER JOES1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 110 m apart · matched through the licence's legal name: TRADER JOES COMPANY · name similarity 1.00
ca-abc TRADER JOES 35overture Trader Joe's1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 130 m apart · matched through the licence's legal name: TRADER JOES COMPANY · name similarity 1.00
ca-abc TRADER JOES 35vtinfo TRADER JOES1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 110 m apart · matched through the licence's legal name: TRADER JOES COMPANY · name similarity 1.00
overture Trader Joe'strader-joes Trader Joe's1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 17 m apart · name similarity 1.00 · phone: equal
overture Trader Joe'svtinfo TRADER JOES1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 20 m apart · name similarity 1.00 · phone: differs
trader-joes Trader Joe'svtinfo TRADER JOES1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 36 m apart · name similarity 1.00 · phone: differs
ca-abc TRADER JOES 35trader-joes Trader Joe's0.52Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
The licensee name 'TRADER JOES 35' matches the Trader Joe's locator store at the identical address 640 W 17th St, Costa Mesa 92627, with only one business at that address; the active off-sale general
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: different, 60% confident — The addresses, city, ZIP and coordinates (0.15 km apart) match and the names agree, but the ABC premises also holds an active on-sale public premises (bar) licence, which the rules treat as a separate business from a market, so this is likely a different outlet at the same address.
pair bcbee773be78ad1aee1f
ca-abc TRADER JOES 35trader-joes Trader Joe's0.52Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
Both records are Trader Joe's at the identical address 640 W 17th St, Costa Mesa 92627, the only business our data holds there, and the off-sale licence fits the store; the 42 on-sale licence is the s
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 80% confident — The ABC record's DBA 'TRADER JOES 35' matches the chain store at the same street address and ZIP, the only business held at that address, and the off-sale market licence fits a grocery store. The on-sale bar licence on the same premises is an unexplained doubt, so confidence is moderate.
pair 6e7eac5c073cdee9fb6f

Attributes

Channel
off_premise · grocery — ca-licence
Chain
Trader Joe's — chain-locator
Alcohol
licensed — a licence or TTB permit on file
Operator
TRADER JOES COMPANY — 210 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_off — CA 21; CA 42
Rule version 7, computed 2026-11-16 17:16.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "chain-locator",
   "off_premise",
   "grocery"
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
306 within 1 mi · 903 within 3 mi
Off / on premise
66 / 195 within 1 mi · 176 / 542 within 3 mi
Selling alcohol
184 within 1 mi · 598 within 3 mi
Nearest
same channel 0.03 mi · licensed 0.12 mi
Setting
urban (5,135 people per sq mi)
People within 3 mi
145,202 (115,587 adults 21+, 58,886 households) from 34 tract(s), tracts within 3 mi
Income
per capita $74,839 · median household ~$129,316 (weighted mean of tract medians)
Age and education
median age ~40.8 · bachelor's or higher 52%
Ethnicity
Hispanic 28% · White 62% · Black 1% · Asian 6%
Adults per alcohol outlet
193
Alcohol spend within 3 mi
$54,198,118 a year ($23,365,510 at home, $30,814,824 away) · $90,481 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:25inserttrader-joes 35 ↔ vtinfo 34966637a32d2147same address and namemerged12
2026-11-12 14:25insertoverture 8f9130e5-e7f0-4764-a709-79a7cb6e65df ↔ vtinfo 34966637a32d2147same address and namemerged12
2026-11-12 14:25insertca-abc 00321989|21|LIC|0 ↔ vtinfo 34966637a32d2147same address and namemerged12
2026-11-12 14:25insertca-abc 00321989|42|LIC|0 ↔ vtinfo 34966637a32d2147same address and namemerged12
2026-11-06 18:13insertca-abc 00321989|21|LIC|0 ↔ overture 8f9130e5-e7f0-4764-a709-79a7cb6e65dfsame address and namemerged11
2026-11-06 18:13insertca-abc 00321989|42|LIC|0 ↔ overture 8f9130e5-e7f0-4764-a709-79a7cb6e65dfsame address and namemerged11
2026-11-06 18:13insertoverture 8f9130e5-e7f0-4764-a709-79a7cb6e65df ↔ trader-joes 35same address and namemerged11
2026-11-02 23:02backfillca-abc 00321989|21|LIC|0 ↔ trader-joes 35Claude judge: samemerged
2026-11-02 23:02backfillca-abc 00321989|42|LIC|0 ↔ trader-joes 35Claude judge: samemerged
2026-10-09 13:59backfillca-abc 00321989|21|LIC|0 ↔ ca-abc 00321989|42|LIC|0one licence filemerged