About this Dataset

San Francisco Population And Demographic Census Data

A. SUMMARY This dataset contains population and demographic estimates and associated margins of error obtained and derived from the US Census. The data is presented over multiple years and geographies. The data is sourced primarily from the American Community Survey. B. HOW THE DATASET IS CREATED The raw data is obtained from the census API. Some estimates as published as-is and some are derived. C. UPDATE PROCESS New estimates and years of data are appended to this dataset. To request additional census data for San Francisco, email support@datasf.org D. HOW TO USE THIS DATASET The dataset is long and contains multiple estimates, years and geographies. To use this dataset, you can filter by the overall segment which contains information about the source, years, geography, demographic category and reporting segment. For census data used in specific reports, you can filter to the reporting segment. To use a subset of the data, you can create a filtered view. More information of how to filter data and create a view can be found here
Organization: City of San Francisco
Last updated: 2022-09-09T08:03:47.737418
Tags: census

Tables

Table 1

@usgov.city_of_san_francisco_san_francisco_population_and_dem_8ea013d1.table_1

1019.76 KB
31127 rows
32 columns


CREATE TABLE table_1 (
  "source" VARCHAR,
  "num_years" BIGINT,
  "start_year" BIGINT,
  "end_year" BIGINT,
  "derived" BOOLEAN,
  "derived_details" VARCHAR,
  "geography" VARCHAR,
  "geography_id_name" VARCHAR,
  "geography_id" VARCHAR,
  "geography_name" VARCHAR,
  "demographic_category" VARCHAR,
  "demographic_category_label" VARCHAR,
  "min_age" BIGINT,
  "max_age" BIGINT,
  "unit" VARCHAR,
  "estimate" DOUBLE,
  "se" DOUBLE,
  "moe" DOUBLE,
  "cv" DOUBLE,
  "reliable" BOOLEAN,
  "upper_ci" DOUBLE,
  "lower_ci" DOUBLE,
  "acs_table" VARCHAR,
  "acs_code" VARCHAR,
  "acs_label" VARCHAR,
  "acs_concept" VARCHAR,
  "pums_variables" VARCHAR,
  "overall_segment" VARCHAR,
  "reporting_segment" VARCHAR,
  "row_identifier" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);