Dataset: SF Assessor Historical Secured Property Tax Rolls

About this Dataset

SF Assessor Historical Secured Property Tax Rolls

Content

This data set includes the Office of the Assessor-Recorder’s secured property tax roll spanning from July 1, 2007 to June 30, 2018. It includes all legally disclosable information, including location of property, value of property, the unique property identifier, and specific property characteristics. The data is used to accurately and fairly appraise all taxable property in the City and County of San Francisco. The Office of the Assessor-Recorder makes no representation or warranty that the information provided is accurate and/or has no errors or omissions.

This dataset is updated annually after the roll is closed and certified. This typically happens by August of each year.

Context

This is a dataset hosted by the city of San Francisco. The organization has an open data platform found here and they update their information according the amount of data that is brought in. Explore San Francisco's Data using Kaggle and all of the data sources available through the San Francisco organization page!

Update Frequency: This dataset is updated annually.

Acknowledgements

This dataset is maintained using Socrata's API and Kaggle's API. Socrata has assisted countless organizations with hosting their open data and has been an integral part of the process of bringing more data to the public.

Cover photo by Gus Ruballo on Unsplash
Unsplash Images are distributed under a unique Unsplash License.

Tables

Assessor Historical Secured Property Tax Rolls

@kaggle.san_francisco_sf_assessor_historical_secured_property_tax_rolls.assessor_historical_secured_property_tax_rolls

214.21 MB
2666117 rows
54 columns


CREATE TABLE assessor_historical_secured_property_tax_rolls (
  "closed_roll_year" BIGINT,
  "property_location" VARCHAR,
  "parcel_number" VARCHAR,
  "block" VARCHAR,
  "lot" VARCHAR,
  "volume_number" BIGINT,
  "use_code" VARCHAR,
  "use_definition" VARCHAR,
  "property_class_code" VARCHAR,
  "property_class_code_definition" VARCHAR,
  "year_property_built" DOUBLE,
  "number_of_bathrooms" BIGINT,
  "number_of_bedrooms" BIGINT,
  "number_of_rooms" DOUBLE,
  "number_of_stories" DOUBLE,
  "number_of_units" BIGINT,
  "zoning_code" VARCHAR,
  "construction_type" VARCHAR,
  "lot_depth" DOUBLE,
  "lot_frontage" DOUBLE,
  "property_area" BIGINT,
  "basement_area" DOUBLE,
  "lot_area" DOUBLE,
  "lot_code" VARCHAR,
  "tax_rate_area_code" DOUBLE,
  "percent_of_ownership" DOUBLE,
  "exemption_code" VARCHAR,
  "exemption_code_definition" VARCHAR,
  "status_code" VARCHAR,
  "misc_exemption_value" BIGINT,
  "homeowner_exemption_value" DOUBLE,
  "current_sales_date" TIMESTAMP,
  "assessed_fixtures_value" BIGINT,
  "assessed_improvement_value" BIGINT,
  "assessed_land_value" BIGINT,
  "assessed_personal_property_value" BIGINT,
  "assessor_neighborhood_district" DOUBLE,
  "assessor_neighborhood_code" VARCHAR,
  "assessor_neighborhood" VARCHAR,
  "supervisor_district" DOUBLE,
  "analysis_neighborhood" VARCHAR,
  "the_geom" VARCHAR,
  "row_id" VARCHAR,
  "sf_find_neighborhoods_2" DOUBLE,
  "current_police_districts_2" DOUBLE,
  "current_supervisor_districts_2" DOUBLE,
  "analysis_neighborhoods_2" DOUBLE,
  "delete_supervisor_districts_2" DOUBLE,
  "delete_fire_prevention_districts_2" DOUBLE,
  "delete_current_police_districts_2" DOUBLE,
  "delete_zip_codes_2" DOUBLE,
  "delete_neighborhoods_2" DOUBLE,
  "delete_police_districts_2" DOUBLE,
  "neighborhoods" DOUBLE
);