About this Dataset

Registered Business Locations - San Francisco

NEW! : Use the new Business Account Number lookup tool. SUMMARY This dataset includes the locations of businesses that pay taxes to the City and County of San Francisco. Each registered business may have multiple locations and each location is a single row. The Treasurer & Tax Collector’s Office collects this data through business registration applications, account update/closure forms, and taxpayer filings. Business locations marked as “Administratively Closed” have not filed or communicated with TTX for 3 years, or were marked as closed following a notification from another City and County Department. The data is collected to help enforce the Business and Tax Regulations Code including, but not limited to: Article 6, Article 12, Article 12-A, and Article 12-A-1. http://sftreasurer.org/registration. To learn more about using this dataset watch this video. To update your listing or look up your BAN see this FAQ: Registered Business Locations Explainer
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:33.851868
Tags: business

Tables

Table 1

@usgov.city_of_san_francisco_registered_business_locations_sa_f8d15bc3.table_1

42.01 MB
342,648 rows
37 columns

CREATE TABLE table_1 (
  "uniqueid" VARCHAR,
  "location_id" VARCHAR,
  "business_account_number" BIGINT,
  "ownership_name" VARCHAR,
  "dba_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "source_zipcode" DOUBLE,
  "business_start_date" TIMESTAMP,
  "business_end_date" TIMESTAMP,
  "location_start_date" TIMESTAMP,
  "location_end_date" TIMESTAMP,
  "administratively_closed" VARCHAR,
  "mail_address" VARCHAR,
  "mail_city" VARCHAR,
  "mail_zipcode" VARCHAR,
  "mail_state" VARCHAR,
  "naics_code" VARCHAR,
  "naics_code_description" VARCHAR,
  "naics_code_descriptions_list" VARCHAR,
  "parking_tax" BOOLEAN,
  "transient_occupancy_tax" BOOLEAN,
  "lic_code" VARCHAR,
  "lic_code_description" VARCHAR,
  "lic_code_descriptions_list" VARCHAR,
  "supervisor_district" DOUBLE,
  "neighborhoods_analysis_boundaries" VARCHAR  -- Neighborhoods - Analysis Boundaries,
  "business_corridor" VARCHAR,
  "business_location" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "sf_find_neighborhoods" DOUBLE,
  "current_police_districts" DOUBLE,
  "current_supervisor_districts" DOUBLE,
  "analysis_neighborhoods" DOUBLE,
  "neighborhoods" DOUBLE
);