About this Dataset

CalHHS Data De-Identification Guidelines Reference Dataset

These datasets are part of the California Health and Human Services Agency (CalHHS) Data De-Identification Guidelines (DDG) in the "State and County Population Projections" Appendix. The DDG assists CalHHS departments in evaluating data for public release while ensuring the privacy of individuals represented in the data. California population estimates serve as a foundation for the population-based scoring assessments outlined in the DDG.
Organization: State of California
Last updated: 2025-10-23T12:50:27.764178
Tags: agency, california-health-and-human-services-agency, chhs, ddg, de-identification, hipaa, phi

Tables

Data Dictionary - Detailed Ethnicity By County (2020 US Census)

@usgov.ca_gov_calhhs_de_identification_guidelines_reference.data_dictionary_detailed_ethnicity_by_county_2020_us_census

4.51 kB
5 rows
4 columns

CREATE TABLE data_dictionary_detailed_ethnicity_by_county_2020_us_census (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - Ethnicity And Race By County (2020 US Census)

@usgov.ca_gov_calhhs_de_identification_guidelines_reference.data_dictionary_ethnicity_and_race_by_county_2020_us_census

4.53 kB
5 rows
4 columns

CREATE TABLE data_dictionary_ethnicity_and_race_by_county_2020_us_census (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - Population By County (2020 US Census)

@usgov.ca_gov_calhhs_de_identification_guidelines_reference.data_dictionary_population_by_county_2020_us_census

4.1 kB
3 rows
4 columns

CREATE TABLE data_dictionary_population_by_county_2020_us_census (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Detailed Ethnicity By County (2020 US Census)

@usgov.ca_gov_calhhs_de_identification_guidelines_reference.detailed_ethnicity_by_county_2020_us_census

11.57 kB
1,229 rows
5 columns

CREATE TABLE detailed_ethnicity_by_county_2020_us_census (
  "geography_type" VARCHAR,
  "geography" VARCHAR,
  "ethnicity_region" VARCHAR,
  "ethnicity" VARCHAR,
  "population" BIGINT
);

Detailed Race By County (2020 US Census)

@usgov.ca_gov_calhhs_de_identification_guidelines_reference.detailed_race_by_county_2020_us_census

106.06 kB
11,254 rows
8 columns

CREATE TABLE detailed_race_by_county_2020_us_census (
  "geography_type" VARCHAR,
  "geography" VARCHAR,
  "omb_race" VARCHAR,
  "race_region" VARCHAR,
  "race" VARCHAR,
  "population_alone" DOUBLE,
  "population_alone_or_in_any_combination" DOUBLE,
  "annotation_code" DOUBLE
);

Ethnicity And Race By County (2020 US Census)

@usgov.ca_gov_calhhs_de_identification_guidelines_reference.ethnicity_and_race_by_county_2020_us_census

17.85 kB
4,307 rows
5 columns

CREATE TABLE ethnicity_and_race_by_county_2020_us_census (
  "geography_type" VARCHAR,
  "geography" VARCHAR,
  "ethnicity" VARCHAR,
  "race" VARCHAR,
  "population" BIGINT
);

Population By County (2020 US Census)

@usgov.ca_gov_calhhs_de_identification_guidelines_reference.population_by_county_2020_us_census

3.96 kB
59 rows
3 columns

CREATE TABLE population_by_county_2020_us_census (
  "geography_type" VARCHAR,
  "geography" VARCHAR,
  "population" BIGINT
);