Outlets /
PUNJ LIQUORS
SAN FRANCISCO, CA 94109 · O0926a5ff65ca · first seen 2026-10-08
5 sourcesoff premise · liquor_storealcohol: 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.
| Field | Master value | Taken from | What other sources say |
|---|---|---|---|
| Name | PUNJ LIQUORS 3 other | the most common name a source states | PUNJ ENTERPRISE INC ca-abc (legal name) ×2 Punj Liquor overture Punj Liquor van ness ubereats |
| Street | 2301 VAN NESS AVE | ca-abc | no other value |
| City | SAN FRANCISCO | ca-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 94109 | ca-abc | no other value |
| Pin | 37.79681, -122.42389 map | ubereats | no other value |
| Phone | 9257271214 1 other | vtinfo | 7076887979 overture |
| Licences | ca-abc 00628240|21|LIC|0 · ca-abc 00628240|86|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: O8acb37e7ae8a; Od85d388e800e; O5246a81e1950; O8346c8f75a2a; O0c4c547128de
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 |
|---|---|---|---|---|---|---|
| ab-inbev | PUNJ LIQUORS 4576199 | 2301 VAN NESS AVE, SAN FRANCISCO, CA, 94109 | 37.79682, -122.42378 | 2026-11-13 | 2026-11-13 | |
| ca-abc | PUNJ LIQUORS legal name: PUNJ ENTERPRISE INC 00628240|21|LIC|0 | 2301 VAN NESS AVE, SAN FRANCISCO, CA, 94109 | 37.79672, -122.42379 | 2026-10-08 | 2026-11-13 | |
| ca-abc | PUNJ LIQUORS legal name: PUNJ ENTERPRISE INC 00628240|86|LIC|0 | 2301 VAN NESS AVE, SAN FRANCISCO, CA, 94109 | 37.79672, -122.42379 | 2026-10-08 | 2026-11-13 | |
| overture | Punj Liquor 2f6b1551-3028-46a3-bb73-56d61cbcc937 | 2301 Van Ness Ave, San Francisco, CA, 94109 | 7076887979 | 37.79681, -122.42382 | 2026-11-06 | 2026-11-13 |
| ubereats | Punj Liquor van ness eCyBQkTbV1albCgSJMXA_A | 2301 Van Ness Ave, San Francisco, CA, 94109 | 37.79681, -122.42389 | 2026-11-02 | 2026-11-13 | |
| vtinfo | PUNJ LIQUORS c7efa14ff4652ec5 | 2301 VAN NESS AVE, SAN FRANCISCO, CA, 94109 | 9257271214 | 37.79674, -122.42405 | 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 |
|---|---|---|---|---|---|
| ab-inbev PUNJ LIQUORS | ca-abc PUNJ LIQUORS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · name similarity 1.00 |
| ab-inbev PUNJ LIQUORS | ca-abc PUNJ LIQUORS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · name similarity 1.00 |
| ab-inbev PUNJ LIQUORS | vtinfo PUNJ LIQUORS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 26 m apart · name similarity 1.00 |
| ca-abc PUNJ LIQUORS | ca-abc PUNJ LIQUORS | 1.00 | one licence file | merged | file: 00628240 · same_address |
| ca-abc PUNJ LIQUORS | vtinfo PUNJ LIQUORS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 23 m apart · name similarity 1.00 |
| ca-abc PUNJ LIQUORS | vtinfo PUNJ LIQUORS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 23 m apart · name similarity 1.00 |
| ab-inbev PUNJ LIQUORS | overture Punj Liquor | 0.65 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 4 m apart · name similarity 0.65 |
| ca-abc PUNJ LIQUORS | overture Punj Liquor | 0.65 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 10 m apart · name similarity 0.65 |
| ca-abc PUNJ LIQUORS | overture Punj Liquor | 0.65 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 10 m apart · name similarity 0.65 |
| overture Punj Liquor | vtinfo PUNJ LIQUORS | 0.65 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · pins 22 m apart · name similarity 0.65 · phone: differs |
| ca-abc PUNJ LIQUORS | ubereats Punj Liquor van ness | 0.47 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (97% confident; asked as a “near” pair) Both records carry the same distinctive name, Punj Liquor(s), at the same street address and ZIP, 2301 Van Ness Ave 94109, with only one business known at that address and an active off-sale licence. Other Claude answers on this pair:
pair 85d6384fd4f4a29c0c29 |
| ca-abc PUNJ LIQUORS | ubereats Punj Liquor van ness | 0.47 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (97% confident; asked as a “near” pair) Same distinctive name (Punj Liquor/Liquors) at the identical street address and ZIP, an off-sale liquor store licence, and only one business known at the address. Other Claude answers on this pair:
pair 2c1997b2e72ee7963f6b |
Attributes
- Channel
- off_premise · liquor_store — ca-licence
- Chain
- none
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- PUNJ ENTERPRISE INC — 2 outlets in the master under this operator
- Licence privileges
- beer_on, beer_off, wine_on, wine_off, spirits_on, spirits_off — CA 21; CA 86
Rule version 7, computed 2026-11-16 17:14.
Every vote behind these (raw)
{
"ue_location": [
"GROCERY_STORE"
],
"votes": [
[
"ca-licence",
"off_premise",
null
],
[
"overture-category",
"off_premise",
null
]
]
}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-13 17:47 | insert | ab-inbev 4576199 ↔ overture 2f6b1551-3028-46a3-bb73-56d61cbcc937 | same address and name | merged | 15 |
| 2026-11-13 17:47 | insert | ab-inbev 4576199 ↔ vtinfo c7efa14ff4652ec5 | same address and name | merged | 15 |
| 2026-11-13 17:47 | insert | ab-inbev 4576199 ↔ ca-abc 00628240|86|LIC|0 | same address and name | merged | 15 |
| 2026-11-13 17:47 | insert | ab-inbev 4576199 ↔ ca-abc 00628240|21|LIC|0 | same address and name | merged | 15 |
| 2026-11-11 12:56 | insert | overture 2f6b1551-3028-46a3-bb73-56d61cbcc937 ↔ vtinfo c7efa14ff4652ec5 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ca-abc 00628240|86|LIC|0 ↔ vtinfo c7efa14ff4652ec5 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ca-abc 00628240|21|LIC|0 ↔ vtinfo c7efa14ff4652ec5 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | ca-abc 00628240|86|LIC|0 ↔ overture 2f6b1551-3028-46a3-bb73-56d61cbcc937 | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | ca-abc 00628240|21|LIC|0 ↔ overture 2f6b1551-3028-46a3-bb73-56d61cbcc937 | same address and name | merged | 11 |
| 2026-11-02 23:02 | backfill | ca-abc 00628240|21|LIC|0 ↔ ubereats eCyBQkTbV1albCgSJMXA_A | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00628240|86|LIC|0 ↔ ubereats eCyBQkTbV1albCgSJMXA_A | Claude judge: same | merged | |
| 2026-10-09 13:59 | backfill | ca-abc 00628240|21|LIC|0 ↔ ca-abc 00628240|86|LIC|0 | one licence file | merged |