Third Rail

SAN FRANCISCO, CA 94107 · O42cd302d8e33 · first seen 2026-10-08
3 sourceson premise · baralcohol: 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
Third Rail 2 other
a source's own spelling of the licence name (record_title.py)
THE THIRD RAIL ca-abcvtinfo ×3
THE THIRD RAIL BAR LLC ca-abc (legal name) ×2
Street
628 20TH ST
ca-abcno other value
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94107
ca-abcno other value
Pin
37.76061, -122.38815 map
overtureno other value
Phone
4152527966
vtinfono other value
Licences
ca-abc 00527943|48|LIC|0 · ca-abc 00527943|58|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of46e1eaf4364; O45413d758c94; O9476d5f9d749

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
ca-abcTHE THIRD RAIL
legal name: THE THIRD RAIL BAR LLC
00527943|48|LIC|0
628 20TH ST, SAN FRANCISCO, CA, 9410737.76059, -122.387852026-10-082026-11-05
ca-abcTHE THIRD RAIL
legal name: THE THIRD RAIL BAR LLC
00527943|58|LIC|0
628 20TH ST, SAN FRANCISCO, CA, 9410737.76059, -122.387852026-10-082026-11-05
overtureThird Rail
29bc320d-b384-4f57-83ae-c299e8975b46
628 20th St, San Francisco, CA, 94107415252796637.76061, -122.388152026-11-062026-11-06
vtinfoTHE THIRD RAIL
7244709831880bd4
628 20TH ST, SAN FRANCISCO, CA, 94107415252796637.76066, -122.388142026-11-122026-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
ca-abc THE THIRD RAILca-abc THE THIRD RAIL1.00one licence filemergedfile: 00527943 · same_address
ca-abc THE THIRD RAILoverture Third Rail1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 26 m apart · name similarity 1.00
ca-abc THE THIRD RAILvtinfo THE THIRD RAIL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 27 m apart · name similarity 1.00
ca-abc THE THIRD RAILoverture Third Rail1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 26 m apart · name similarity 1.00
ca-abc THE THIRD RAILvtinfo THE THIRD RAIL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 27 m apart · name similarity 1.00
overture Third Railvtinfo THE THIRD RAIL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 6 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
on_premise · bar — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
THE THIRD RAIL BAR LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 48; CA 58 (add-on: follows the base licence)
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "bar"
  ],
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
248 within 1 mi · 4,980 within 3 mi
Off / on premise
34 / 146 within 1 mi · 617 / 3,089 within 3 mi
Selling alcohol
138 within 1 mi · 2,987 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.01 mi
Setting
urban (13,381 people per sq mi)
People within 3 mi
378,327 (325,032 adults 21+, 180,265 households) from 118 tract(s), tracts within 3 mi
Income
per capita $93,844 · median household ~$141,445 (weighted mean of tract medians)
Age and education
median age ~40.5 · bachelor's or higher 58%
Ethnicity
Hispanic 19% · White 37% · Black 7% · Asian 32%
Adults per alcohol outlet
109
Alcohol spend within 3 mi
$163,193,082 a year ($69,833,934 at home, $93,306,471 away) · $54,616 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-12 14:25insertca-abc 00527943|58|LIC|0 ↔ vtinfo 7244709831880bd4same address and namemerged12
2026-11-12 14:25insertoverture 29bc320d-b384-4f57-83ae-c299e8975b46 ↔ vtinfo 7244709831880bd4same address and namemerged12
2026-11-12 14:25insertca-abc 00527943|48|LIC|0 ↔ vtinfo 7244709831880bd4same address and namemerged12
2026-11-06 18:13insertca-abc 00527943|48|LIC|0 ↔ overture 29bc320d-b384-4f57-83ae-c299e8975b46same address and namemerged11
2026-11-06 18:13insertca-abc 00527943|58|LIC|0 ↔ overture 29bc320d-b384-4f57-83ae-c299e8975b46same address and namemerged11
2026-10-09 13:59backfillca-abc 00527943|48|LIC|0 ↔ ca-abc 00527943|58|LIC|0one licence filemerged