home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

5 rows where Mail City = 91

View and edit SQL

Suggested facets: Business Account Number, Ownership Name, Source Zipcode, Business Start Date, Location Start Date, Mail Address, Supervisor District, Neighborhoods - Analysis Boundaries

Link rowid Location Id Ownership Name DBA Name Street Address City State Source Zipcode Business Start Date Business End Date Location Start Date Location End Date Mail Address Mail City Mail Zipcode Mail State NAICS Code NAICS Code Description Parking Tax Transient Occupancy Tax LIC Code LIC Code Description Supervisor District Neighborhoods - Analysis Boundaries Business Corridor Business Location
997 0141547-01-001 Blaine H Terrence Union-Hyde Apartments 1954 Hyde St San Francisco 1 CA 1 94109 24 01/01/1980   01/01/1980 03/30/2015 4370 Alpine Rd #201 Portola Vally 91 94028 136 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Russian Hill 5   1954 HYDE ST San Francisco, CA 94109 (37.799, -122.419028)
1009 0141547-02-001 Blaine H Terrence Marina Court Apartments 3445 Pierce St San Francisco 1 CA 1 94123 3 01/01/1980   05/01/1981 03/30/2015 4370 Alpine Rd #201 Portola Vally 91 94028 136 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2   3445 PIERCE ST San Francisco, CA 94123 (37.802126, -122.439839)
1022 0141547-03-001 Blaine H Terrence The Franciscan Apts 2290 Francisco St San Francisco 1 CA 1 94123 3 01/01/1980   01/01/1980   4370 Alpine Rd #201 Portola Vally 91 94028 136 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2   2290 FRANCISCO ST San Francisco, CA 94123 (37.800944, -122.442736)
21320 0317010-01-001 Blaine Gregory Etal 290 Alhambra St Apts 290 Alhambra St San Francisco 1 CA 1 94123 3 06/04/1998   06/04/1998   4370 Alpine Rd Ste 201 Portola Vally 91 94028 136 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2   290 ALHAMBRA ST San Francisco, CA 94123 (37.801176, -122.441091)
24375 0329910-01-001 Blaine, Timothy Et Al Marina Pierce Apartments 3330 Pierce St San Francisco 1 CA 1 94123 3 10/01/1999   10/01/1999   4370 Alpine Rd Ste 201 Portola Vally 91 94028 136 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2   3330 PIERCE ST San Francisco, CA 94123 (37.8008, -122.43957)

Advanced export

JSON shape: default, array

CSV options:

CREATE TABLE "Registered_Business_Locations_-_San_Francisco" (
"Location Id" TEXT,
  "Business Account Number" INTEGER,
  "Ownership Name" TEXT,
  "DBA Name" TEXT,
  "Street Address" TEXT,
  "City" INTEGER,
  "State" INTEGER,
  "Source Zipcode" INTEGER,
  "Business Start Date" TEXT,
  "Business End Date" REAL,
  "Location Start Date" TEXT,
  "Location End Date" REAL,
  "Mail Address" TEXT,
  "Mail City" INTEGER,
  "Mail Zipcode" INTEGER,
  "Mail State" TEXT,
  "NAICS Code" INTEGER,
  "NAICS Code Description" INTEGER,
  "Parking Tax" INTEGER,
  "Transient Occupancy Tax" INTEGER,
  "LIC Code" REAL,
  "LIC Code Description" REAL,
  "Supervisor District" INTEGER,
  "Neighborhoods - Analysis Boundaries" INTEGER,
  "Business Corridor" INTEGER,
  "Business Location" TEXT
,
FOREIGN KEY ("Neighborhoods - Analysis Boundaries") REFERENCES [Neighborhoods - Analysis Boundaries](id),
    FOREIGN KEY ("NAICS Code Description") REFERENCES [NAICS Code Description](id),
    FOREIGN KEY ("NAICS Code") REFERENCES [NAICS Code](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("Mail Zipcode") REFERENCES [Mail Zipcode](id),
    FOREIGN KEY ("Source Zipcode") REFERENCES [Source Zipcode](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("Supervisor District") REFERENCES [Supervisor District](id),
    FOREIGN KEY ("Business Corridor") REFERENCES [Business Corridor](id),
    FOREIGN KEY ("Mail City") REFERENCES [Mail City](id))
Powered by Datasette · Query took 13.658ms · Data source: data.sfgov.org