home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

4 rows where Mail City = 53

View and edit SQL

Suggested facets: Business Account Number, Ownership Name, Street Address, City, 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
431 0084652-02-999 B & B Landscape Cont Inc B & B Landscape Cont Inc 450 Phelan Ave San+jose 26 CA 1 95112 49 08/24/2005   08/24/2005   Po Box 1127 Pebble Beach 53 93953 84 CA     0 0           450 PHELAN AVE SAN JOSE, CA 95112 (37.315997, -121.86199)
57671 0416834-01-001 Woytak Lidia & Lillian 1041 Washington St Apts 1041 Washington St San Francisco 1 CA 1 94108 9 04/01/2007   04/01/2007   Po Box 844 Pebble Beach 53 93953 84 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17   1041 WASHINGTON ST San Francisco, CA 94108 (37.794645, -122.410441)
57672 0416834-02-001 Woytak Lidia & Lillian 550 Leavenworth St Apts 550 Leavenworth St San Francisco 1 CA 1 94109 24 04/01/2007   04/01/2007   Po Box 844 Pebble Beach 53 93953 84 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Tenderloin 11   550 LEAVENWORTH ST San Francisco, CA 94109 (37.786218, -122.414741)
146647 1044673-11-151 Woytak Family Trust 1041 Washington St 1041 Washington St San Francisco 1 CA 1 94108 9 01/01/2014   01/01/2014   Po Box 844 Pebble Beach 53 93953 84 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           1041 WASHINGTON ST SAN FRANCISCO, CA 94108 (37.794645, -122.410441)

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