home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

8 rows where Business Corridor = 7

View and edit SQL

Suggested facets: Business Account Number, Ownership Name, Street Address, Business Start Date, Mail Address, NAICS Code, NAICS Code Description, 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
35368 0366901-02-001 Martinez Moises E M Electric Co 14 Cypress St San Francisco 1 CA 1 94110 18 05/22/2003   10/05/2011   14 Cypress Street San Francisco 1 94110 37 CA 2300-2399 6 Construction 6 0 0     9 8 Mission 12 Lower 24th Street 7 14 CYPRESS ST San Francisco, CA 94110 (37.752138, -122.416803)
39158 0366901-01-001 Martinez Moises Moises Martinez 14 Cypress St San Francisco 1 CA 1 94110 18 05/22/2003   05/22/2003   14 Cypress Street San Francisco 1 94110 37 CA 2300-2399 6 Construction 6 0 0     9 8 Mission 12 Lower 24th Street 7 14 CYPRESS ST San Francisco, CA 94110 (37.752138, -122.416803)
48320 0399250-02-001 Doles Amesia A La Bodega Flora 11 Lilac St San Francisco 1 CA 1 94110 18 07/01/2006   06/02/2014   11 Lilac St San Francisco 1 94110 37 CA 4400-4599 3 Retail Trade 3 0 0     9 8 Mission 12 Lower 24th Street 7 11 LILAC ST San Francisco, CA 94110 (37.752134, -122.41786)
76382 0449583-01-001 Zones Isaac A Isaac Zones Music & Comm Lead 10 1/2 Balmy St San Francisco 1 CA 1 94110 18 06/01/2010 11/04/2016 06/01/2010 11/04/2016             0 0     9 8 Mission 12 Lower 24th Street 7 10 1 2 BALMY ST San Francisco, CA 94110 (37.752204, -122.412431)
110734 0488726-01-001 Bearbarella Productions Llc Bearbarella Productions Llc 9 Balmy St San Francisco 1 CA 1 94110 18 04/01/2014   04/01/2014   9 Balmy St San Francisco 1 94110 37 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0     9 8 Mission 12 Lower 24th Street 7 9 BALMY ST San Francisco, CA 94110 (37.752472, -122.412456)
111211 0489192-01-001 Alchemy Spoon Llc Parts And Labor 11 Lilac St San Francisco 1 CA 1 94110 18 04/30/2014   04/30/2014   11 Lilac St San Francisco 1 94110 37 CA     0 0     9 8 Mission 12 Lower 24th Street 7 11 LILAC ST San Francisco, CA 94110 (37.752134, -122.41786)
168882 1086792-08-161 Salt Pt Co Llc Salt Pt Meat Share 9 Cypress St San Francisco 1 CA 1 94110 18 08/04/2016   08/04/2016   9 Cypress St San Francisco 1 94110 37 CA 7220-7229 8 Food Services 8 0 0     9 8 Mission 12 Lower 24th Street 7  
190155 1133422-01-171 Salt Pt Co Llc Salt Pt Butchery & Provisions 9 Cypress St San Francisco 1 CA 1 94110 18 08/05/2016   08/05/2016   9 Cypress St San Francisco 1 94110 37 CA 7220-7229 8 Food Services 8 0 0     9 8 Mission 12 Lower 24th Street 7  

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