Trader Joe's

San Mateo, CA 94403 · O87c903222028 · first seen 2026-10-08
5 sourcesoff premise · grocerychain: Trader Joe'salcohol: 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
Trader Joe's 3 other
the most common name a source states
TRADER JOES vtinfo
TRADER JOES 245 ca-abc
TRADER JOES COMPANY ca-abc (legal name)
Street
45 W Hillsdale Blvd 1 other
trader-joes
45 HILLSDALE BLVD ca-abc
City
San Mateo
trader-joesno other value
State
CA
trader-joesno other value
ZIP
94403
trader-joesno other value
Pin
37.53543, -122.29828 map 1 other
trader-joes
77 m away ubereats
Phone
6502861509
trader-joesno other value
Licences
ca-abc 00475366|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ocd15ae4ce8ff; Oc2f996176f80; Oe560f97e15a3; O8b91a1eb68cb

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 245
legal name: TRADER JOES COMPANY
00475366|21|LIC|0
45 HILLSDALE BLVD, SAN MATEO, CA, 944032026-10-082026-11-12
overtureTrader Joe's
35403454-f380-4b95-b08d-21b7e0fe27fe
45 W Hillsdale Blvd, San Mateo, CA, 94403650286150937.53554, -122.298342026-11-062026-11-12
trader-joesTrader Joe's
245
45 W Hillsdale Blvd, San Mateo, CA, 94403650286150937.53543, -122.298282026-10-082026-11-12
ubereatsTrader Joe's
hMJjebDdU4yTzo_sOftXfg
45 W Hillsdale Blvd, CA, 94403
ZIP lookup: San Mateo, CA
37.53603, -122.298712026-10-102026-11-12
vtinfoTRADER JOES
4a45343d935f1ce5
45 W HILLSDALE BLVD, SAN MATEO, CA, 94403650286150937.53543, -122.298292026-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 245overture Trader Joe's1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · name similarity 1.00 · street similarity 0.93
ca-abc TRADER JOES 245vtinfo TRADER JOES1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · name similarity 1.00 · street similarity 0.93
overture Trader Joe'strader-joes Trader Joe's1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00 · phone: equal
overture Trader Joe'subereats Trader Joe's1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 64 m apart · name similarity 1.00
overture Trader Joe'svtinfo TRADER JOES1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 13 m apart · name similarity 1.00 · phone: equal
trader-joes Trader Joe'subereats Trader Joe's1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · pins 77 m apart · name similarity 1.00
trader-joes Trader Joe'svtinfo TRADER JOES1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 1 m apart · name similarity 1.00 · phone: equal
ubereats Trader Joe'svtinfo TRADER JOES1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 76 m apart · name similarity 1.00
ca-abc TRADER JOES 245trader-joes Trader Joe's0.51Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
The same chain, Trader Joe's #245, is at 45 Hillsdale Blvd in San Mateo with ZIP 94403 on both records, the only difference being the 'W' direction prefix, and A's off-sale licence is consistent with
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records are at 45 Hillsdale Blvd, San Mateo 94403 (the W prefix is just a directional variant), with the California ABC off-sale licence under TRADER JOES 245 matching Trader Joe's store locator entry, and no other business is held at that address.
  • Claude Haiku 5.5, prompt v4: same, 93% confident — Both records are at 45 Hillsdale Blvd, San Mateo 94403 with one business at that address, and the ABC licence name 'TRADER JOES 245' matches the chain's Trader Joe's store at the same address, with the store number reflected in the licence name; the single off-sale licence fits a grocery store.
pair 0287fd1e9aa104c84d69
ca-abc TRADER JOES 245ubereats Trader Joe's0.51Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
The California licence for Trader Joe's #245 at 45 Hillsdale Blvd and the Uber Eats Trader Joe's at 45 W Hillsdale Blvd share the street number, street and ZIP 94403, and the data holds only one busin
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records are the same Trader Joe's store at 45 Hillsdale Blvd, San Mateo 94403 (ABC licence under 'TRADER JOES 245' and Uber Eats 'Trader Joe's' with matching street, city and ZIP), the only business at that address, and the off-sale liquor licence fits a grocery store selling to take away.
  • Claude Haiku 5.5, prompt v4: same, 92% confident — Both records place Trader Joe's at 45 Hillsdale Blvd (W Hillsdale in B), ZIP 94403, with the ABC record's store number 245 being a chain-store identifier, an off-sale liquor licence fitting a grocery, and only one business at that address in the data.
pair 0e581150f9bd0ef2b032

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_off, wine_off, spirits_off — CA 21
Rule version 7, computed 2026-11-16 17:18.
Every vote behind these (raw)
{
 "ue_location": [
  "ITEMLESS_STORE"
 ],
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "chain-locator",
   "off_premise",
   "grocery"
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
216 within 1 mi · 1,005 within 3 mi
Off / on premise
47 / 137 within 1 mi · 160 / 640 within 3 mi
Selling alcohol
107 within 1 mi · 536 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.09 mi
Setting
urban (5,830 people per sq mi)
People within 3 mi
164,845 (126,855 adults 21+, 64,243 households) from 41 tract(s), tracts within 3 mi
Income
per capita $99,482 · median household ~$187,730 (weighted mean of tract medians)
Age and education
median age ~40.6 · bachelor's or higher 66%
Ethnicity
Hispanic 17% · White 42% · Black 2% · Asian 34%
Adults per alcohol outlet
236
Alcohol spend within 3 mi
$70,042,141 a year ($29,264,164 at home, $40,761,122 away) · $130,432 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:25insertca-abc 00475366|21|LIC|0 ↔ vtinfo 4a45343d935f1ce5street written two waysmerged12
2026-11-12 14:25insertubereats hMJjebDdU4yTzo_sOftXfg ↔ vtinfo 4a45343d935f1ce5same address and namemerged12
2026-11-12 14:25inserttrader-joes 245 ↔ vtinfo 4a45343d935f1ce5same address and namemerged12
2026-11-12 14:25insertoverture 35403454-f380-4b95-b08d-21b7e0fe27fe ↔ vtinfo 4a45343d935f1ce5same address and namemerged12
2026-11-06 18:13insertca-abc 00475366|21|LIC|0 ↔ overture 35403454-f380-4b95-b08d-21b7e0fe27festreet written two waysmerged11
2026-11-06 18:13insertoverture 35403454-f380-4b95-b08d-21b7e0fe27fe ↔ ubereats hMJjebDdU4yTzo_sOftXfgsame address and namemerged11
2026-11-06 18:13insertoverture 35403454-f380-4b95-b08d-21b7e0fe27fe ↔ trader-joes 245same address and namemerged11
2026-11-02 23:02backfillca-abc 00475366|21|LIC|0 ↔ ubereats hMJjebDdU4yTzo_sOftXfgClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00475366|21|LIC|0 ↔ trader-joes 245Claude judge: samemerged
2026-10-10 14:03backfilltrader-joes 245 ↔ ubereats hMJjebDdU4yTzo_sOftXfgsame address and namemerged