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.

FieldMaster valueTaken fromWhat 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-abcno other value
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94109
ca-abcno other value
Pin
37.79681, -122.42389 map
ubereatsno 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.

SourceNameAddressPhoneCoordinatesFirst seenUpdated
ab-inbevPUNJ LIQUORS
4576199
2301 VAN NESS AVE, SAN FRANCISCO, CA, 9410937.79682, -122.423782026-11-132026-11-13
ca-abcPUNJ LIQUORS
legal name: PUNJ ENTERPRISE INC
00628240|21|LIC|0
2301 VAN NESS AVE, SAN FRANCISCO, CA, 9410937.79672, -122.423792026-10-082026-11-13
ca-abcPUNJ LIQUORS
legal name: PUNJ ENTERPRISE INC
00628240|86|LIC|0
2301 VAN NESS AVE, SAN FRANCISCO, CA, 9410937.79672, -122.423792026-10-082026-11-13
overturePunj Liquor
2f6b1551-3028-46a3-bb73-56d61cbcc937
2301 Van Ness Ave, San Francisco, CA, 94109707688797937.79681, -122.423822026-11-062026-11-13
ubereatsPunj Liquor van ness
eCyBQkTbV1albCgSJMXA_A
2301 Van Ness Ave, San Francisco, CA, 9410937.79681, -122.423892026-11-022026-11-13
vtinfoPUNJ LIQUORS
c7efa14ff4652ec5
2301 VAN NESS AVE, SAN FRANCISCO, CA, 94109925727121437.79674, -122.424052026-11-112026-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
ab-inbev PUNJ LIQUORSca-abc PUNJ LIQUORS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · name similarity 1.00
ab-inbev PUNJ LIQUORSca-abc PUNJ LIQUORS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · name similarity 1.00
ab-inbev PUNJ LIQUORSvtinfo PUNJ LIQUORS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 26 m apart · name similarity 1.00
ca-abc PUNJ LIQUORSca-abc PUNJ LIQUORS1.00one licence filemergedfile: 00628240 · same_address
ca-abc PUNJ LIQUORSvtinfo PUNJ LIQUORS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 23 m apart · name similarity 1.00
ca-abc PUNJ LIQUORSvtinfo PUNJ LIQUORS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 23 m apart · name similarity 1.00
ab-inbev PUNJ LIQUORSoverture Punj Liquor0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 4 m apart · name similarity 0.65
ca-abc PUNJ LIQUORSoverture Punj Liquor0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 10 m apart · name similarity 0.65
ca-abc PUNJ LIQUORSoverture Punj Liquor0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 10 m apart · name similarity 0.65
overture Punj Liquorvtinfo PUNJ LIQUORS0.65same address and namemergedaddress 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 LIQUORSubereats Punj Liquor van ness0.47Claude judge: samemerged
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:
  • Claude Haiku 5.5, prompt v7: same, 95% confident — Both records sit at 2301 Van Ness Ave, San Francisco 94109 with coordinates about 13 m apart, the only business at that address is a liquor store licence, and the names 'Punj Liquors' and 'Punj Liquor van ness' match.
pair 85d6384fd4f4a29c0c29
ca-abc PUNJ LIQUORSubereats Punj Liquor van ness0.47Claude judge: samemerged
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:
  • Claude Opus 5.5, prompt v12: same, 95% confident — Punj Liquor same address
  • Claude Haiku 5.5, prompt v9: same, 93% confident — Both records are at 2301 Van Ness Ave, San Francisco 94109 with a very short distance, and the names clearly match (PUNJ LIQUORS licensed off-sale store vs. Uber Eats 'Punj Liquor van ness'), with no other businesses at the address and a single off-sale store licence.
  • Claude Haiku 5.5, prompt v7: same, 95% confident — Both records sit at 2301 Van Ness Ave, San Francisco 94109 with coordinates about 13 m apart, the only business at that address is a liquor store, and the names Punj Liquors and Punj Liquor van ness match, with the CA licence being an off-sale store licence.
  • Claude Haiku 5.5, prompt v4: same, 93% confident — Both records are at 2301 Van Ness Ave, San Francisco 94109, and the names match (Punj Liquors / Punj Liquor van ness); the CA record's only premises licence is an off-sale liquor store licence, with a tasting add-on that doesn't change the business type, and no other business is held at that address.
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”).
WhenEventPairRuleDecisionRule version
2026-11-13 17:47insertab-inbev 4576199 ↔ overture 2f6b1551-3028-46a3-bb73-56d61cbcc937same address and namemerged15
2026-11-13 17:47insertab-inbev 4576199 ↔ vtinfo c7efa14ff4652ec5same address and namemerged15
2026-11-13 17:47insertab-inbev 4576199 ↔ ca-abc 00628240|86|LIC|0same address and namemerged15
2026-11-13 17:47insertab-inbev 4576199 ↔ ca-abc 00628240|21|LIC|0same address and namemerged15
2026-11-11 12:56insertoverture 2f6b1551-3028-46a3-bb73-56d61cbcc937 ↔ vtinfo c7efa14ff4652ec5same address and namemerged12
2026-11-11 12:56insertca-abc 00628240|86|LIC|0 ↔ vtinfo c7efa14ff4652ec5same address and namemerged12
2026-11-11 12:56insertca-abc 00628240|21|LIC|0 ↔ vtinfo c7efa14ff4652ec5same address and namemerged12
2026-11-06 18:13insertca-abc 00628240|86|LIC|0 ↔ overture 2f6b1551-3028-46a3-bb73-56d61cbcc937same address and namemerged11
2026-11-06 18:13insertca-abc 00628240|21|LIC|0 ↔ overture 2f6b1551-3028-46a3-bb73-56d61cbcc937same address and namemerged11
2026-11-02 23:02backfillca-abc 00628240|21|LIC|0 ↔ ubereats eCyBQkTbV1albCgSJMXA_AClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00628240|86|LIC|0 ↔ ubereats eCyBQkTbV1albCgSJMXA_AClaude judge: samemerged
2026-10-09 13:59backfillca-abc 00628240|21|LIC|0 ↔ ca-abc 00628240|86|LIC|0one licence filemerged