home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

20 rows where Business Corridor = 6 sorted by Mail Address

View and edit SQL

Suggested facets: Business Account Number, Ownership Name, DBA Name, Street Address, Source Zipcode, Business Start Date, Location Start Date, Location End Date, Mail Address, Mail City, Mail Zipcode, NAICS Code, NAICS Code Description, Parking Tax, 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
36008 0368946-01-001 Kobayashi Yoshiko Jo Ha Kyu Japanese Translation 81 Frank Norris St 702 San Francisco 1 CA 1 94109 24 12/31/2006 03/31/2017 12/14/2007 03/31/2017             0 0     3 1 Nob Hill 17 Lower Polk 6 81 FRANK NORRIS ST San Francisco, CA 94109 (37.789208, -122.42008)
161494 1074285-05-161 Cloudtek, Inc. Cloudtek, Inc. 106 Austin St San Francisco 1 CA 1 94109 24 05/31/2016   05/31/2016   106 Austin St San Francisco 1 94109 7 CA 5100-5199 15 Information 15 0 0     3 1 Nob Hill 17 Lower Polk 6 106 AUSTIN ST SAN FRANCISCO, CA 94109 (37.789153, -122.420504)
108336 0486432-01-001 106 Fern Street Llc 106 Fern Street Llc 106 Fern St San Francisco 1 CA 1 94109 24 01/13/2014   01/13/2014   106 Fern St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 1     3 1 Nob Hill 17 Lower Polk 6 106 FERN ST San Francisco, CA 94109 (37.788212, -122.420325)
152651 1057426-03-161 Essential Hydro, Llc Essential Hydro, Llc 106 Fern St Apt 3 San Francisco 1 CA 1 94109 24 01/01/2016   01/01/2016   106 Fern St 3 Apt San Francisco 1 94109 7 CA 4400-4599 3 Retail Trade 3 0 0     3 1 Nob Hill 17 Lower Polk 6 106 FERN ST SAN FRANCISCO, CA 94109 (37.788212, -122.420325)
28382 0344363-01-001 Sf American Taxicab Inc American Taxi Cab 120 Willow St San Francisco 1 CA 1 94109 24 02/08/2001   01/01/2003   120 Willow St San Francisco 1 94109 7 CA 4800-4999 12 Transportation and Warehousing 12 0 0     6 3 Tenderloin 11 Lower Polk 6 120 WILLOW ST San Francisco, CA 94109 (37.783512, -122.419701)
29639 0349103-01-001 Sf Global Automobile Sales Inc Global Automobile Sales 120 Willow St San Francisco 1 CA 1 94109 24 08/11/2001   01/01/2003   120 Willow St San Francisco 1 94109 7 CA 4400-4599 3 Retail Trade 3 0 0     6 3 Tenderloin 11 Lower Polk 6 120 WILLOW ST San Francisco, CA 94109 (37.783512, -122.419701)
58521 0418428-01-001 Pastrana Reynaldo A & V Shuttle 120 Willow St San Francisco 1 CA 1 94109 24 06/01/2007   06/01/2007   120 Willow St San Francisco 1 94109 7 CA     0 0     6 3 Tenderloin 11 Lower Polk 6 120 WILLOW ST San Francisco, CA 94109 (37.783512, -122.419701)
58523 0418434-01-001 Yambao Jr Jose Jyj Shuttle 120 Willow St San Francisco 1 CA 1 94109 24 06/01/2007   06/01/2007   120 Willow St San Francisco 1 94109 7 CA     0 0     6 3 Tenderloin 11 Lower Polk 6 120 WILLOW ST San Francisco, CA 94109 (37.783512, -122.419701)
58761 0418843-01-001 Mayo Darrell M&v Shuttle 120 Willow St San Francisco 1 CA 1 94109 24 06/05/2007   06/05/2007   120 Willow St San Francisco 1 94109 7 CA     0 0     6 3 Tenderloin 11 Lower Polk 6 120 WILLOW ST San Francisco, CA 94109 (37.783512, -122.419701)
59252 0418842-01-001 Asfaw Fecade M&v Shuttle 120 Willow St San Francisco 1 CA 1 94109 24 06/01/2007   06/01/2007   120 Willow St San Francisco 1 94109 7 CA     0 0     6 3 Tenderloin 11 Lower Polk 6 120 WILLOW ST San Francisco, CA 94109 (37.783512, -122.419701)
113305 0910551-01-001 American Airporter Shuttle In American Airporter Shuttle Inc 120 Willow St San Francisco 1 CA 1 94109 24 01/02/1992   01/01/2003   120 Willow St San Francisco 1 94109 7 CA 4800-4999 12 Transportation and Warehousing 12 0 0     6 3 Tenderloin 11 Lower Polk 6 120 WILLOW ST San Francisco, CA 94109 (37.783512, -122.419701)
84394 0460304-03-001 Antonov Roman Eco-Taxi Cab Co 120 Willow St San Francisco 1 CA 1 94109 24 11/25/2013   11/25/2013   120 Willow Street San Francisco 1 94109 7 CA 4800-4999 12 Transportation and Warehousing 12 0 0     6 3 Tenderloin 11 Lower Polk 6 120 WILLOW ST San Francisco, CA 94109 (37.783512, -122.419701)
84395 0460304-04-001 Antonov Roman Roman Antonov 120 Willow St San Francisco 1 CA 1 94109 24 11/25/2013   11/25/2013   120 Willow Street San Francisco 1 94109 7 CA 4800-4999 12 Transportation and Warehousing 12 0 0     6 3 Tenderloin 11 Lower Polk 6 120 WILLOW ST San Francisco, CA 94109 (37.783512, -122.419701)
41288 0383184-01-001 Sf Cycles Inc Sf Cycles Inc 90 Cedar St San Francisco 1 CA 1 94109 24 01/31/2008   12/31/2008 01/09/2016 1441 Bush St San Francisco 1 94109 7 CA 8100-8139 5 Certain Services 5 0 0     6 3 Tenderloin 11 Lower Polk 6 90 CEDAR ST San Francisco, CA 94109 (37.78645, -122.419173)
27073 0339716-04-001 Kharsa Shadi N City Handyman 81 Cedar St San Francisco 1 CA 1 94109 24 03/02/2011   03/02/2011   1932 Irving St #23 San Francisco 1 94122 15 CA     0 0     6 3 Tenderloin 11 Lower Polk 6 81 CEDAR ST San Francisco, CA 94109 (37.786478, -122.418944)
101171 0479114-01-002 Scone Wild Llc Scone Wild Llc 80 Fern St San Francisco 1 CA 1 94109 24 05/07/2013   06/08/2013   335 Jersey St San Francisco 1 94114 43 CA 7220-7229 8 Food Services 8 0 0     3 1 Nob Hill 17 Lower Polk 6 80 FERN ST San Francisco, CA 94109 (37.788216, -122.420298)
74190 0446211-02-001 Gaucho's Table Llc Nucha 80 Fern St San Francisco 1 CA 1 94109 24 02/05/2010   05/18/2013 10/08/2014 47 Scott St San Francisco 1 94117 80 CA 7220-7229 8 Food Services 8 0 0     3 1 Nob Hill 17 Lower Polk 6 80 FERN ST San Francisco, CA 94109 (37.788216, -122.420298)
217450 0385982-11-001 Pacific Coast Farmers' Market Fern Alley Farmers' Market 80 Fern St San Francisco 1 CA 1 94109 24 04/30/2005   05/11/2013 03/11/2016 5060 Commercial Circle A Concord 42 94520 68 CA     0 0     3 1 Nob Hill 17 Lower Polk 6 80 FERN ST San Francisco, CA 94109 (37.788216, -122.420298)
96578 0474292-01-001 Simply Parking Llc Simply Parking Llc 80 Hemlock St San Francisco 1 CA 1 94104 1 01/01/2013   01/01/2013   80 Hemlock St San Francisco 1 94109 7 CA     1 0     3 1 Nob Hill 17 Lower Polk 6 80 HEMLOCK ST San Francisco, CA 94104 (37.787332, -122.419715)
22534 0322120-04-001 Achilles Philip American Rent A Car 120 Willow St San Francisco 1 CA 1 94109 24 01/01/1999   01/01/2003   819 Ellis St 3rd Fl San Francisco 1 94109 7 CA 5600-5699 16 Administrative and Support Services 16 0 0     6 3 Tenderloin 11 Lower Polk 6 120 WILLOW ST San Francisco, CA 94109 (37.783512, -122.419701)

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