San Francisco Data

Close
Author
OpenData
Description
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. Locations with the mailing address “Administratively Closed” were administratively closed by TTX after 3 years of inactivity, and should be excluded when pulling data about COVID closures. 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 update your listing or look up your BAN see this FAQ: https://support.datasf.org/help/registered-business-faqs
Category
Economy and Community
Tags
business
Rating
Current value: 0 out of 5
Data Provided By
City and County of San Francisco
Source Link
http://www.sfgov.org
License
Public Domain Dedication and License
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

Location Id
ttxid
Business Account Number
certificate_number
Ownership Name
ownership_name
DBA Name
dba_name
Street Address
full_business_address
City
city
State
state
Source Zipcode
business_zip
Business Start Date
dba_start_date
Business End Date
dba_end_date
Location Start Date
location_start_date
Location End Date
location_end_date
Mail Address
mailing_address_1
Mail City
mail_city
Mail Zipcode
mail_zipcode
Mail State
mail_state
NAICS Code
naic_code
NAICS Code Description
naic_code_description
Parking Tax
parking_tax
Transient Occupancy Tax
transient_occupancy_tax
LIC Code
lic
LIC Code Description
lic_code_description
Supervisor District
supervisor_district
Neighborhoods - Analysis Boundaries
neighborhoods_analysis_boundaries
Business Corridor
business_corridor
Business Location
location
UniqueID
uniqueid
SF Find Neighborhoods
:@computed_region_6qbp_sg9q
Current Police Districts
:@computed_region_qgnn_b9vv
Current Supervisor Districts
:@computed_region_26cr_cadq
Analysis Neighborhoods
:@computed_region_ajp5_b2md
Neighborhoods
:@computed_region_jwn9_ihcz

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.