Harpoon Louie's

SAN FRANCISCO, CA 94105 · O4f71da858b31 · first seen 2026-10-08
4 sourceson premise · restaurantalcohol: 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
Harpoon Louie's 4 other
a licence name in capitals, cleaned (derived; record_title.py)
55 LOUIE'S SF LLC ca-abc (legal name) ×2
HARPOON LOUIES ca-abc ×2
LOUIES BAR ab-inbevvtinfo ×2
Louie's Bar overture
Street
55 STEVENSON ST 1 other
ca-abc
55 ab-inbev
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94105
ca-abcno other value
Pin
37.78963, -122.39966 map
overtureno other value
Phone
4152869577
vtinfono other value
Licences
ca-abc 00531054|47|LIC|0 · ca-abc 00531054|58|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ob4b5ce374181; Obd2d61364c15; Oa0945814a6ad; O99425d0391e1

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-inbevLOUIES BAR
4641338
55, SAN FRANCISCO, CA, 9410537.78965, -122.399672026-11-132026-11-13
ca-abcHARPOON LOUIES
legal name: 55 LOUIE'S SF LLC
00531054|47|LIC|0
55 STEVENSON ST, SAN FRANCISCO, CA, 9410537.78960, -122.399712026-10-082026-11-18
ca-abcHARPOON LOUIES
legal name: 55 LOUIE'S SF LLC
00531054|58|LIC|0
55 STEVENSON ST, SAN FRANCISCO, CA, 9410537.78960, -122.399712026-10-082026-11-18
overtureLouie's Bar
001a549e-7bf5-4439-a543-0280f4996528
55 Stevenson St, San Francisco, CA, 94105415286957737.78963, -122.399662026-11-132026-11-18
vtinfoLOUIES BAR
4303972cb047ac86
55 STEVENSON ST, SAN FRANCISCO, CA, 94105415286957737.78956, -122.399572026-11-112026-11-18

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 LOUIES BARvtinfo LOUIES BAR1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “proximity” pair)
Same bar name, same street number and ZIP
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records are named LOUIES BAR in San Francisco ZIP 94105 with the same street number 55, and their coordinates are about 13 m apart; the ab-inbev record gives only the number, but the exact name match and close location support one outlet, though the building also holds another business.
pair 71658840aa68fd5022b2
ca-abc HARPOON LOUIESca-abc HARPOON LOUIES1.00one licence filemergedfile: 00531054 · same_address
overture Louie's Barvtinfo LOUIES BAR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 11 m apart · name similarity 1.00 · phone: equal
ca-abc HARPOON LOUIESvtinfo LOUIES BAR0.54one name contains the other, same addressmergedjudge: None · pair_id: e1c6d5d2f76d2c8d9d03 · person: None · rule: names contained at one address · stratum: near
ca-abc HARPOON LOUIESvtinfo LOUIES BAR0.54one name contains the other, same addressmergedjudge: None · pair_id: 7e7398d82be999969141 · person: None · rule: names contained at one address · stratum: near

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
55 LOUIE'S SF LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47; CA 58 (add-on: follows the base licence)
Rule version 11, computed 2026-11-19 21:41.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
2,173 within 1 mi · 5,268 within 3 mi
Off / on premise
213 / 1,331 within 1 mi · 679 / 3,294 within 3 mi
Selling alcohol
1,240 within 1 mi · 3,272 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.00 mi
Setting
urban (13,517 people per sq mi)
People within 3 mi
382,191 (336,598 adults 21+, 196,267 households) from 129 tract(s), tracts within 3 mi
Income
per capita $106,981 · median household ~$148,228 (weighted mean of tract medians)
Age and education
median age ~39.4 · bachelor's or higher 65%
Ethnicity
Hispanic 16% · White 46% · Black 6% · Asian 28%
Adults per alcohol outlet
103
Alcohol spend within 3 mi
$183,421,676 a year ($78,138,806 at home, $105,225,223 away) · $56,058 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”).
WhenEventPairRuleDecisionRule version
2026-11-18 18:58insertab-inbev 4641338 ↔ vtinfo 4303972cb047ac86Claude judge: samemerged15
2026-11-16 14:56insertca-abc 00531054|58|LIC|0 ↔ vtinfo 4303972cb047ac86one name contains the other, same addressmerged15
2026-11-16 14:56insertca-abc 00531054|47|LIC|0 ↔ vtinfo 4303972cb047ac86one name contains the other, same addressmerged15
2026-11-13 14:10insertoverture 001a549e-7bf5-4439-a543-0280f4996528 ↔ vtinfo 4303972cb047ac86same address and namemerged15
2026-10-09 13:59backfillca-abc 00531054|47|LIC|0 ↔ ca-abc 00531054|58|LIC|0one licence filemerged