Outlets /
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.
| Field | Master value | Taken from | What 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-joes | no other value |
| State | CA | trader-joes | no other value |
| ZIP | 94403 | trader-joes | no other value |
| Pin | 37.53543, -122.29828 map 1 other | trader-joes | 77 m away ubereats |
| Phone | 6502861509 | trader-joes | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ca-abc | TRADER JOES 245 legal name: TRADER JOES COMPANY 00475366|21|LIC|0 | 45 HILLSDALE BLVD, SAN MATEO, CA, 94403 | 2026-10-08 | 2026-11-12 | ||
| overture | Trader Joe's 35403454-f380-4b95-b08d-21b7e0fe27fe | 45 W Hillsdale Blvd, San Mateo, CA, 94403 | 6502861509 | 37.53554, -122.29834 | 2026-11-06 | 2026-11-12 |
| trader-joes | Trader Joe's 245 | 45 W Hillsdale Blvd, San Mateo, CA, 94403 | 6502861509 | 37.53543, -122.29828 | 2026-10-08 | 2026-11-12 |
| ubereats | Trader Joe's hMJjebDdU4yTzo_sOftXfg | 45 W Hillsdale Blvd, CA, 94403 ZIP lookup: San Mateo, CA | 37.53603, -122.29871 | 2026-10-10 | 2026-11-12 | |
| vtinfo | TRADER JOES 4a45343d935f1ce5 | 45 W HILLSDALE BLVD, SAN MATEO, CA, 94403 | 6502861509 | 37.53543, -122.29829 | 2026-11-12 | 2026-11-14 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ca-abc TRADER JOES 245 | overture Trader Joe's | 1.00 | street written two ways | merged | name Jaro-Winkler 1.00 · matched on zip · name similarity 1.00 · street similarity 0.93 |
| ca-abc TRADER JOES 245 | vtinfo TRADER JOES | 1.00 | street written two ways | merged | name Jaro-Winkler 1.00 · matched on city · name similarity 1.00 · street similarity 0.93 |
| overture Trader Joe's | trader-joes Trader Joe's | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00 · phone: equal |
| overture Trader Joe's | ubereats Trader Joe's | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 64 m apart · name similarity 1.00 |
| overture Trader Joe's | vtinfo TRADER JOES | 1.00 | same address and name | merged | address 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's | ubereats Trader Joe's | 1.00 | same address and name | merged | address similarity 1.00 · same street + ZIP · pins 77 m apart · name similarity 1.00 |
| trader-joes Trader Joe's | vtinfo TRADER JOES | 1.00 | same address and name | merged | address 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's | vtinfo TRADER JOES | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 76 m apart · name similarity 1.00 |
| ca-abc TRADER JOES 245 | trader-joes Trader Joe's | 0.51 | Claude judge: same | merged | 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:
pair 0287fd1e9aa104c84d69 |
| ca-abc TRADER JOES 245 | ubereats Trader Joe's | 0.51 | Claude judge: same | merged | 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:
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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-12 14:25 | insert | ca-abc 00475366|21|LIC|0 ↔ vtinfo 4a45343d935f1ce5 | street written two ways | merged | 12 |
| 2026-11-12 14:25 | insert | ubereats hMJjebDdU4yTzo_sOftXfg ↔ vtinfo 4a45343d935f1ce5 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | trader-joes 245 ↔ vtinfo 4a45343d935f1ce5 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | overture 35403454-f380-4b95-b08d-21b7e0fe27fe ↔ vtinfo 4a45343d935f1ce5 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | ca-abc 00475366|21|LIC|0 ↔ overture 35403454-f380-4b95-b08d-21b7e0fe27fe | street written two ways | merged | 11 |
| 2026-11-06 18:13 | insert | overture 35403454-f380-4b95-b08d-21b7e0fe27fe ↔ ubereats hMJjebDdU4yTzo_sOftXfg | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | overture 35403454-f380-4b95-b08d-21b7e0fe27fe ↔ trader-joes 245 | same address and name | merged | 11 |
| 2026-11-02 23:02 | backfill | ca-abc 00475366|21|LIC|0 ↔ ubereats hMJjebDdU4yTzo_sOftXfg | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00475366|21|LIC|0 ↔ trader-joes 245 | Claude judge: same | merged | |
| 2026-10-10 14:03 | backfill | trader-joes 245 ↔ ubereats hMJjebDdU4yTzo_sOftXfg | same address and name | merged |