COVID-19 Equity Metrics (PAUSED) by US Government | Finance and Economics

About this Dataset

COVID-19 Equity Metrics (PAUSED)

Note: This dataset is on hiatus.

CDPH strives to respond equitably to the COVID-19 pandemic and is therefore interested in how different communities are impacted. Collecting and reporting health equity data helps to identify health disparities and improve the state’s response. To that end, CDPH tracks cases, deaths, and testing by race and ethnicity as well as other social determinants of health, such as income, crowded housing, and access to health insurance.

During the response, CDPH used a health equity metric, defined as the positivity rate in the most disproportionately-impacted communities according to the Healthy Places Index. The purpose of this metric was to ensure California reopened its economy safely by reducing disease transmission in all communities. This metric is tracked and reported in comparison to statewide positivity rate. More information is available at https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/CaliforniaHealthEquityMetric.aspx.

Data completeness is also critical to addressing inequities. CDPH reports data completeness by race and ethnicity, sexual orientation, and gender identity to better understand missingness in the data.

Health equity data is updated weekly. Data may be suppressed based on county population or total counts.

For more information on California’s commitment to health equity, please see https://covid19.ca.gov/equity/
Organization: State of California
Last updated: 2024-11-27T00:47:20.586360
Tags: california-department-of-public-health, cases, covid, covid-19, covid19, crowded-housing, data-completeness, deaths, ethnicity, health-equity, health-insurance, healthy-places-index, income, race, testing

Tables

COVID-19 Race-Ethnicity Timeseries

@usgov.ca_gov_covid_19_equity_metrics_paused_3bbf3.covid_19_race_ethnicity_timeseries

32.07 KB
3164 rows
8 columns


CREATE TABLE covid_19_race_ethnicity_timeseries (
  "date" TIMESTAMP,
  "location" VARCHAR,
  "location_level" VARCHAR,
  "demog" VARCHAR,
  "demog_cat" VARCHAR,
  "metric_cat" VARCHAR,
  "metric" VARCHAR,
  "value" DOUBLE
);

COVID-19 Demographic Rate Cumulative

@usgov.ca_gov_covid_19_equity_metrics_paused_3bbf3.covid_19_demographic_rate_cumulative

87.05 KB
2978 rows
15 columns


CREATE TABLE covid_19_demographic_rate_cumulative (
  "date" TIMESTAMP,
  "county" VARCHAR,
  "demographic_set" VARCHAR,
  "demographic_set_category" VARCHAR,
  "metric" VARCHAR,
  "metric_value" DOUBLE,
  "metric_value_per_100k" DOUBLE,
  "applied_suppression" VARCHAR,
  "population_percentage" DOUBLE,
  "metric_total_percentage" DOUBLE,
  "metric_value_30_days_ago" DOUBLE,
  "metric_value_per_100k_30_days_ago" DOUBLE,
  "metric_value_per_100k_delta_from_30_days_ago" DOUBLE,
  "metric_total_percentage_30_days_ago" DOUBLE,
  "metric_value_percentage_delta_from_30_days_ago" DOUBLE
);

COVID-19 Health Equity Metric POS 30 Day By CNT

@usgov.ca_gov_covid_19_equity_metrics_paused_3bbf3.covid_19_health_equity_metric_pos_30_day_by_cnt

76.81 KB
3540 rows
6 columns


CREATE TABLE covid_19_health_equity_metric_pos_30_day_by_cnt (
  "county" VARCHAR,
  "date" TIMESTAMP,
  "metric" VARCHAR,
  "metric_value" DOUBLE,
  "metric_value_30_days_ago" DOUBLE,
  "metric_value_diff" DOUBLE
);

COVID-19 Demographic Data Completeness

@usgov.ca_gov_covid_19_equity_metrics_paused_3bbf3.covid_19_demographic_data_completeness

3.3 MB
148478 rows
10 columns


CREATE TABLE covid_19_demographic_data_completeness (
  "county" VARCHAR,
  "sogi_category" VARCHAR,
  "metric" VARCHAR,
  "missing" DOUBLE,
  "not_missing" DOUBLE,
  "total" DOUBLE,
  "percent_complete" DOUBLE,
  "percent_complete_30_days_prior" DOUBLE,
  "percent_complete_30_days_diff" DOUBLE,
  "report_date" TIMESTAMP
);

COVID-19 Case Rate By Social Det

@usgov.ca_gov_covid_19_equity_metrics_paused_3bbf3.covid_19_case_rate_by_social_det

287.91 KB
8148 rows
10 columns


CREATE TABLE covid_19_case_rate_by_social_det (
  "date" TIMESTAMP,
  "social_det" VARCHAR,
  "social_tier" VARCHAR,
  "sort" DOUBLE,
  "cases_7dayavg_7daysago" DOUBLE,
  "population" BIGINT,
  "case_rate_per_100k" DOUBLE,
  "state_case_rate_per_100k" DOUBLE,
  "case_rate_per_100k_30_days_ago" DOUBLE,
  "rate_diff_30_days" DOUBLE
);