Outlets /
JUDAH NINTH AVE LIQUORS
SAN FRANCISCO, CA 94122 · O720a7c3d1f17 · first seen 2026-10-08
5 sourcesoff premise · liquor_storealcohol: licensed1 licence123 products on the shelf
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 | JUDAH NINTH AVE LIQUORS 4 other | the most common name a source states | JUDAH 9TH AVE LIQUORS ca-abc Judah Ninth Avenue Liquors overture judah ninth avenue liquors san francisco doordash JUDAH RETAIL LLC ca-abc (legal name) |
| Street | 1400 9TH AVE 1 other | ca-abc | 1400 9th Avenue doordash |
| City | SAN FRANCISCO | ca-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 94122 | ca-abc | no other value |
| Pin | 37.76206, -122.46604 map 1 other | doordash | 96 m away ab-inbev |
| Phone | 4157597240 | vtinfo | no other value |
| Licences | ca-abc 00607402|21|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Ocdae18c0044e; Ode013cf9ead3; O878c83965f66; O7b44f6b2d325
Carries
Products seen on this outlet’s shelf in store-level catalogs.
123products placed
543listings
420listings with no product match yet
doordashfrom
Sources
Every source record folded into this outlet, as the source states it.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | JUDAH NINTH AVE LIQUORS 2015048 | 1400 9TH AVE, SAN FRANCISCO, CA, 94122 | 37.76120, -122.46605 | 2026-11-11 | 2026-11-12 | |
| ca-abc | JUDAH 9TH AVE LIQUORS legal name: JUDAH RETAIL LLC 00607402|21|LIC|0 | 1400 9TH AVE, SAN FRANCISCO, CA, 94122 | 37.76212, -122.46610 | 2026-10-08 | 2026-11-05 | |
| doordash | judah ninth avenue liquors san francisco 1868935 | 1400 9th Avenue, San Francisco, CA, 94122 | 37.76206, -122.46604 | 2026-10-08 | 2026-11-03 | |
| overture | Judah Ninth Avenue Liquors afd4d566-2a75-451c-a408-1485f8cd3308 | 1400 9th Ave, San Francisco, CA, 94122 | 4157597240 | 37.76210, -122.46608 | 2026-11-06 | 2026-11-06 |
| vtinfo | JUDAH NINTH AVE LIQUORS 8c8962c70dc8b874 | 1400 9TH AVE, SAN FRANCISCO, CA, 94122 | 4157597240 | 37.76193, -122.46595 | 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 |
|---|---|---|---|---|---|
| ab-inbev JUDAH NINTH AVE LIQUORS | vtinfo JUDAH NINTH AVE LIQUORS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 82 m apart · name similarity 1.00 |
| doordash judah ninth avenue liquors san francisco | overture Judah Ninth Avenue Liquors | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00 |
| ab-inbev JUDAH NINTH AVE LIQUORS | doordash judah ninth avenue liquors san francisco | 0.77 | Claude judge: same | merged | Claude Opus 5.5, prompt v9 said same (97% confident; asked as a “near” pair) Same distinctive name (DoorDash slug with the city appended) at the identical street address and ZIP, and no other business is recorded at that address. Other Claude answers on this pair:
pair 06ca797e0d546940aa6e |
| ab-inbev JUDAH NINTH AVE LIQUORS | ca-abc JUDAH 9TH AVE LIQUORS | 0.69 | Claude judge: same | merged | Claude Opus 5.5, prompt v12 said same (97% confident; asked as a “near” pair) Same name variant, same address, liquor store licence. Other Claude answers on this pair:
pair 2b8984402711ecaff99a |
| ca-abc JUDAH 9TH AVE LIQUORS | doordash judah ninth avenue liquors san francisco | 0.53 | Claude judge: same | merged | Claude Opus 5.5, prompt v3 said same (97% confident; asked as a “near” pair) The two records share the same street address and ZIP, and the names match once '9th' is read as 'ninth' and the city appended to the DoorDash slug is dropped; only one business is known at this addre Other Claude answers on this pair:
pair afb4859d6e5c2e586aca |
Attributes
- Channel
- off_premise · liquor_store — ca-licence
- Chain
- none
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- JUDAH RETAIL LLC — 1 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)
{
"votes": [
[
"ca-licence",
"off_premise",
null
],
[
"doordash-url",
"off_premise",
null
],
[
"overture-category",
"off_premise",
null
]
]
}Trade area
- Other outlets
- 270 within 1 mi · 2,860 within 3 mi
- Off / on premise
- 38 / 182 within 1 mi · 494 / 1,765 within 3 mi
- Selling alcohol
- 168 within 1 mi · 2,006 within 3 mi
- Nearest
- same channel 0.10 mi · licensed 0.01 mi
- Setting
- urban (16,531 people per sq mi)
- People within 3 mi
- 467,389 (392,093 adults 21+, 204,558 households) from 125 tract(s), tracts within 3 mi
- Income
- per capita $101,068 · median household ~$163,020 (weighted mean of tract medians)
- Age and education
- median age ~41.2 · bachelor's or higher 67%
- Ethnicity
- Hispanic 14% · White 46% · Black 4% · Asian 31%
- Adults per alcohol outlet
- 195
- Alcohol spend within 3 mi
- $208,347,951 a year ($87,945,495 at home, $120,342,329 away) · $103,811 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-09 23:07.
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 17:29 | insert | ab-inbev 2015048 ↔ ca-abc 00607402|21|LIC|0 | Claude judge: same | merged | 14 |
| 2026-11-12 14:25 | insert | ab-inbev 2015048 ↔ doordash 1868935 | Claude judge: same | merged | 12 |
| 2026-11-12 14:25 | insert | ab-inbev 2015048 ↔ vtinfo 8c8962c70dc8b874 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | doordash 1868935 ↔ overture afd4d566-2a75-451c-a408-1485f8cd3308 | same address and name | merged | 11 |
| 2026-10-30 17:27 | backfill | ca-abc 00607402|21|LIC|0 ↔ doordash 1868935 | Claude judge: same | merged |