Outlets /
Trader Joe's
San Francisco, CA 94118 · O4c77dec8db71 · 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 4 other | the most common name a source states | Trader Joe's 100 snap TRADER JOES vtinfo TRADER JOES 100 ca-abc TRADER JOES COMPANY ca-abc (legal name) |
| Street | 3 Masonic Ave | trader-joes | no other value |
| City | San Francisco | trader-joes | no other value |
| State | CA | trader-joes | no other value |
| ZIP | 94118 | trader-joes | no other value |
| Pin | 37.78337, -122.44787 map 2 other | trader-joes | 102 m away ca-abc 50 m away snap |
| Phone | 4153469964 | trader-joes | no other value |
| Licences | ca-abc 00333381|21|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Od00a8d2d07e2; Oca68d3640c30; Ob419fccb9ca2; Od61c562561f9
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 100 legal name: TRADER JOES COMPANY 00333381|21|LIC|0 | 3 MASONIC AVE, SAN FRANCISCO, CA, 94118 | 37.78256, -122.44731 | 2026-10-08 | 2026-11-06 | |
| overture | Trader Joe's 12e82b4a-40f7-49ad-a054-dd5fa7ac909e | 3 Masonic Ave, San Francisco, CA, 94118 | 4153469964 | 37.78337, -122.44787 | 2026-11-06 | 2026-11-06 |
| snap | Trader Joe's 100 snap|us|339540 | 3 Masonic Ave, San Francisco, CA, 94118 | 37.78341, -122.44730 | 2026-11-19 | 2026-11-19 | |
| trader-joes | Trader Joe's 100 | 3 Masonic Ave, San Francisco, CA, 94118 | 4153469964 | 37.78337, -122.44787 | 2026-10-08 | 2026-11-06 |
| vtinfo | TRADER JOES b3eb7a97e5104bfb | 3 MASONIC AVE, SAN FRANCISCO, CA, 94118 | 4153469964 | 37.78334, -122.44776 | 2026-11-11 | 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 100 | overture Trader Joe's | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 103 m apart · matched through the licence's legal name: TRADER JOES COMPANY · name similarity 1.00 |
| ca-abc TRADER JOES 100 | snap Trader Joe's 100 | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 94 m apart · name similarity 1.00 |
| ca-abc TRADER JOES 100 | vtinfo TRADER JOES | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 95 m apart · matched through the licence's legal name: TRADER JOES COMPANY · name similarity 1.00 |
| 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 0 m apart · name similarity 1.00 · phone: equal |
| 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 11 m apart · name similarity 1.00 · phone: equal |
| 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 11 m apart · name similarity 1.00 · phone: equal |
| ca-abc TRADER JOES 100 | trader-joes Trader Joe's | 0.51 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (97% confident; asked as a “near” pair) Both records place a Trader Joe's (store #100) at the same street address and ZIP, 3 Masonic Ave 94118, with an active off-sale licence, and only one business is listed at that address. Other Claude answers on this pair:
pair 29a8e214178c7e2c468b |
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 — 209 outlets in the master under this operator
- Licence privileges
- beer_off, wine_off, spirits_off — CA 21
Rule version 11, computed 2026-11-19 21:41.
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
- 615 within 1 mi · 5,728 within 3 mi
- Off / on premise
- 117 / 406 within 1 mi · 779 / 3,644 within 3 mi
- Selling alcohol
- 417 within 1 mi · 3,595 within 3 mi
- Nearest
- same channel 0.09 mi · licensed 0.09 mi
- Setting
- urban (17,643 people per sq mi)
- People within 3 mi
- 498,842 (433,050 adults 21+, 245,800 households) from 156 tract(s), tracts within 3 mi
- Income
- per capita $103,787 · median household ~$148,822 (weighted mean of tract medians)
- Age and education
- median age ~40.6 · bachelor's or higher 66%
- Ethnicity
- Hispanic 15% · White 47% · Black 4% · Asian 29%
- Adults per alcohol outlet
- 120
- Alcohol spend within 3 mi
- $233,400,587 a year ($99,336,528 at home, $133,990,425 away) · $64,906 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-19 20:37 | insert | ca-abc 00333381|21|LIC|0 ↔ snap snap|us|339540 | same address and name | merged | 17 |
| 2026-11-11 12:56 | insert | ca-abc 00333381|21|LIC|0 ↔ vtinfo b3eb7a97e5104bfb | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | trader-joes 100 ↔ vtinfo b3eb7a97e5104bfb | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | overture 12e82b4a-40f7-49ad-a054-dd5fa7ac909e ↔ vtinfo b3eb7a97e5104bfb | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | ca-abc 00333381|21|LIC|0 ↔ overture 12e82b4a-40f7-49ad-a054-dd5fa7ac909e | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | overture 12e82b4a-40f7-49ad-a054-dd5fa7ac909e ↔ trader-joes 100 | same address and name | merged | 11 |
| 2026-11-02 23:02 | backfill | ca-abc 00333381|21|LIC|0 ↔ trader-joes 100 | Claude judge: same | merged |