home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

7 rows where City = 95 sorted by Location End Date

View and edit SQL

Suggested facets: NAICS Code, NAICS Code Description, Business Location

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
3772 0437346-02-999 Ohm Lighting Llc Ohm Lighting Llc 3312 Benmore Valley Rd Lakeport 95 CA 1 95453 151 07/25/2006   01/01/2012   371 Lakeport Boulevard #355 Lakeport 214 95453 312 CA     0 0           3312 BENMORE VALLEY RD LAKEPORT, CA 95453
51746 0406185-02-999 Baqleh Basem J Basem J Baqleh 1403 Camden Ave Lakeport 95 CA 1 95453 151 01/01/2007   04/20/2009   1403 Camden Ave Lakeport 214 95453 312 CA 4800-4999 12 Transportation and Warehousing 12 0 0           1403 CAMDEN AVE LAKEPORT, CA 95453 (39.033675, -122.931687)
56539 0415153-02-999 Tisell Ray E Tisell Construction 5680 Robin Hill Dr Lakeport 95 CA 1 95453 151 04/01/2007   09/20/2012   5680 Robin Hill Dr Lakeport 214 95453 312 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           5680 ROBIN HILL DR LAKEPORT, CA 95453 (39.108911, -122.894552)
72151 0442242-01-999 Lentz Aaron M Natural Mystic Productions 15195 Bottle Rock Rd Lakeport 95 CA 1 95453 151 09/09/2009   09/09/2009   0 Po Box 1320 Lakeport 214 95453 312 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0           15195 BOTTLE ROCK RD LAKEPORT, CA 95453
91503 0468757-01-999 Mitchell Michael K Trout Ranch Media 2193 Riggs Rd Lakeport 95 CA 1 95453 151 05/01/2012   05/01/2012   2193 Riggs Road Lakeport 214 95453 312 CA     0 0           2193 RIGGS RD LAKEPORT, CA 95453 (39.044926, -122.951905)
164562 1079761-06-161 Golden Gate Senior Fellowship Golden Gate Senior Fellowship 1025 Martin St 2 Lakeport 95 CA 1 95453 151 02/06/2006   02/06/2006   1025 Martin St Spc 2 Lakeport 214 95453 312 CA     0 0            
204164 1161721-09-171 Ross Eppler Light Ray Electric 170 Rainbow Rd Lakeport 95 CA 1 95453 151 09/21/2017   09/21/2017   170 Rainbow Rd Lakeport 214 95453 312 CA 2300-2399 6 Construction 6 0 0            

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