home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

5 rows where Business Corridor = 8 sorted by Business Start Date

View and edit SQL

Suggested facets: Source Zipcode, Mail Zipcode, NAICS Code, NAICS Code Description, Transient Occupancy Tax, Supervisor District, Neighborhoods - Analysis Boundaries, Business Location

Business Corridor

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
53606 0409804-01-001 Mndaweni Mpho M Mndaweni Mpho M 21 Godeus St San Francisco 1 CA 1 94110 18 01/01/2007   01/01/2007   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     9 8 Bernal Heights 19 Mission Street 8 21 GODEUS ST San Francisco, CA 94110 (37.742732, -122.421455)
149830 1050444-01-161 Carey Jennifer Kingston Street 121 Kingston St San Francisco 1 CA 1 94110 18 08/01/2015   08/01/2015   121 Kingston St San Francisco 1 94110 37 CA 7210-7219 9 Accommodations 9 0 1     9 8 Bernal Heights 19 Mission Street 8 121 KINGSTON ST SAN FRANCISCO, CA 94110 (37.741578, -122.421915)
174427 1101336-08-161 Manuel Pacheco Uber 29 Godeus St Unit A San Francisco 1 CA 1 94110 18 08/08/2016   08/08/2016   29 Godeus St A Unit San Francisco 1 94110 37 CA 4800-4999 12 Transportation and Warehousing 12 0 0     9 8 Bernal Heights 19 Mission Street 8  
173920 1100105-08-161 Karoly Farkas Karoly Farkas 22 Leo St Apt A San Francisco 1 CA 1 94112 28 08/29/2016   08/29/2016   22 Leo St A Apt San Francisco 1 94112 20 CA 4800-4999 12 Transportation and Warehousing 12 0 0     11 Outer Mission 35 Mission Street 8  
190336 1126732-11-161 Benett John Aa Backflow Testing 127 Kingston St San Francisco 1 CA 1 94110 18 11/08/2016   11/08/2016   127 Kingston St San Francisco 1 94110 37 CA 2200-2299 2300-2399 47 Multiple 13 0 0     9 8 Bernal Heights 19 Mission Street 8  

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 20.75ms · Data source: data.sfgov.org