home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

8 rows where City = 139

View and edit SQL

Suggested facets: Source Zipcode, Mail Address, Mail City, Mail Zipcode, Mail State, 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
6264 0121685-02-999 Ringling Bros-Barnum Etc Inc Ringling Bros-Barnum Etc Inc 8607 Westwood Center Dr Vienna 139 VA 5 22182 220 01/01/1980 12/31/2013 02/25/2008 12/31/2013             0 0           8607 WESTWOOD CENTER DR VIENNA, VA 22182 (38.92903, -77.245816)
9572 0152122-02-999 Projection Video Services Inc Projection Presentation Tech. 5803 Rolling Road 207 Vienna 139 VA 5 22152 313 07/01/1985   11/16/1998   5803 Rolling Rd Ste 200 Springfield 267 22152 586 VA     0 0           5803 ROLLING ROAD VIENNA, VA 22152 (38.793863, -77.245944)
63460 0427642-01-999 Yeske Buie Inc Yeske Buie Inc 301 Maple Ave West 600 Vienna 139 VA 5 22180 1346 01/01/2008   08/11/2010   301 Maple Avenue West #600 Vienna 837 22180 2003 VA 5210-5239 11 Financial Services 11 0 0           301 MAPLE AVE WEST VIENNA, VA 22180 (38.897502, -77.270335)
140528 1034435-07-151 Pipaya Partners Llc Pipaya Partners Llc 8227 Old Courthouse Rd 215 Vienna 139 VA 5 22182 220 04/16/2015   04/16/2015   8227 Old Courthouse Rd 215 Vienna 837 22182 1214 VA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           8227 OLD COURTHOUSE RD VIENNA, VA 22182 (38.913195, -77.230079)
204006 1143973-04-171 True Influence, Llc True Influence, Llc 8000 Towers Crescent Dr Fl 13 Vienna 139 VA 5 22182 220 03/07/2016   03/07/2016   8000 Towers Crescent Dr 13 Fl Vienna 837 22182 1214 VA 5100-5199 15 Information 15 0 0            
209861 0414475-01-999 Feld Entertainment Inc Feld Entertainment Inc 8607 Westwood Ctr Dr Vienna 139 VA 5 22182 220 03/07/2007   03/07/2007   800 Feld Way Palmetto 1667 34221 3051 FL 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0           8607 WESTWOOD CTR DR VIENNA, VA 22182 (38.92903, -77.245816)
210746 0455983-01-999 Digney York Assoc - Calif Lp Digney York Assoc - Calif Lp 1919 Gallows Rd 950 Vienna 139 VA 5 22182 220 02/02/2011   02/02/2011   1919 Gallows Rd Ste #950 Vienna 837 22182 1214 VA 2300-2399 6 Construction 6 0 0           1919 GALLOWS RD VIENNA, VA 22182 (38.91304, -77.227971)
222267 1120397-09-161 Cra, Inc. Cra, Inc. 8614 Westwood Center Dr 200 Vienna 139 VA 5 22182 220 09/01/2016   09/01/2016   8614 Westwood Center Dr 200 Vienna 837 22182 1214 VA     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 14.496ms · Data source: data.sfgov.org