AndreaBozzo/ceres-open-data-index huggingface dataset:
Chronic Conditions Experienced by Californians with Original Medicare, 2021

The dataset contains information about the prevalence of chronic conditions among Original Medicare beneficiaries as well as about the spending and co-occurring conditions for those with each condition. The data are available for California and for the rest of the United States, overall and by demographic and geographic groups. Additionally, the data are available for each of 19 California geographic regions overall and by demographic and geographic groups. The data represent Medicare beneficiaries who are in the Original Medicare program. Medicare offers health care coverage for older adults and certain individuals with disabilities. The Original Medicare program is Parts A and B of Medicare, administered by the U.S. Centers for Medicare & Medicaid Services. The analysis excludes enrollees of the Medicare Advantage program, administered by private insurers, because Medicare Advantage data are incomplete.
Clostridioides difficile infections (CDI) in California Hospitals

California Health and Safety Code section 1288.55(a)(1) requires general acute care hospitals to report all cases of Clostridioides difficile infections (CDI) identified in their facilities to the California Department of Public Health (CDPH). CDI data are submitted by hospitals to the Centers for Disease Control and Prevention (CDC) National Healthcare Safety Network (NHSN). 

CDPH downloads California hospital CDI data from NHSN and analyzes the data to describe prevention progress in an annual public report of healthcare-associated infections CDPH publishes annual CDI data reported by each California hospital in the datasets below. 

The following datasets include the number of CDI reported by each California hospital in the specified reporting year. Beginning in 2016 for each California hospital, the annual CDI dataset includes the number of CDI that were predicted to occur in each hospital based on its specific facility-level characteristics. The observed (reported) number of CDI are then compared to the predicted number of CDI in a ratio called the Standardized Infection Ratio or SIR. The SIR is a metric that summarizes an individual hospital’s CDI prevention progress compared with the national baseline and California state-specific prevention goals. 

Detailed information about the variables included in each dataset are described in the accompanying data dictionaries for the year of interest.

For more information about the SIR and NHSN’s statistical models that are used to calculate the predicted number of CDI for each hospital, please review “NHSN’s Guide to the SIR”: https://www.cdc.gov/nhsn/ps-analysis-resources/index.html 

For general information about NHSN, surveillance definitions, and reporting requirements for CDI, please visit: https://www.cdc.gov/nhsn/index.html 

To link the CDPH facility IDs with those from other Departments, including OSHPD, please reference the "Licensed Facility Cross-Walk" Open Data table at: https://data.chhs.ca.gov/dataset/licensed-facility-crosswalk.

For information about healthcare-associated infection prevention progress in California hospitals and statewide prevention goals, please visit: https://www.cdph.ca.gov/Programs/CHCQ/HAI/Pages/HAIreport.aspx
Contraceptive Care Use for Women by Program, Contraceptive Type, and Age Group

The use of Most or Moderately effective contraceptive (M/M) or Long-Acting Reversible Contraceptive (LARC) types by program, contraceptive type, age group, and year of interest, for 2014-2016. This data was compiled for the Measure CCW: Contraceptive Care – All Women Ages 15-44, as part of the Maternal and Infant Health Initiative, Contraceptive Care Quality grant.
Contraceptive Care Use for Women by Race/Ethnicity, Contraceptive Type, and Age Group

The use of Most or Moderately effective contraceptive (M/M) or Long-Acting Reversible Contraceptive (LARC) types by race/ethnicity, contraceptive type, age group, and year of interest, for 2014-2016. This data was compiled for the Measure CCW: Contraceptive Care – All Women Ages 15-44, as part of the Maternal and Infant Health Initiative, Contraceptive Care Quality grant.
Counts and Status of California Work Opportunity and Responsibility to Kids (CalWORKs) Applications

This report includes data on the number of applications requested or restored and cases added during the month.  This dataset is a selected subset of the entire report, available on the California Department of Social Services, Research and Data Reports (RADR) website at http://www.cdss.ca.gov/research/.  CalWORKs is a welfare program that gives cash aid and services to eligible needy California families.  The program serves all 58 counties in the state and is operated locally by county welfare departments.  If a family has little or no cash and needs housing, food, utilities, clothing or medical care, they may be eligible to receive immediate short-term help.  Families that apply and qualify for ongoing assistance receive benefits each month to help pay for housing, food and other necessary expenses.  Monthly CalWORKs data is collected from the counties through submission of the CA 237CW CalWORKs Cash Grant Movement Report, which is used to report statistical information on CalWORKs caseload movement for Two Parent Families, Zero Parent Families, All Other Families, Temporary Assistance for Needy Families (TANF) Timed-Out Cases and Safety Net/Fleeing Felon/Long-Term Sanction Cases (SN/FF/LTS).

NOTE: The presence of "-999" in data cells indicates that the number of applications is too small to be displayed and has been suppressed in order to protect individual clients' confidentiality.
COVID-19 Blueprint for a Safer Economy Data Chart (ARCHIVED)

__Note__: Blueprint has been retired as of June 15, 2021. This dataset will be kept up for historical purposes, but will no longer be updated.

California has a new blueprint for reducing COVID-19 in the state with revised criteria for loosening and tightening restrictions on activities. Every county in California is assigned to a tier based on its test positivity and adjusted case rate for tier assignment. Additionally, a new health equity metric took effect on October 6, 2020. In order to advance to the next less restrictive tier, each county will need to meet an equity metric or demonstrate targeted investments to eliminate disparities in levels of COVID-19 transmission, depending on its size. The California Health Equity Metric is designed to help guide counties in their continuing efforts to reduce COVID-19 cases in all communities and requires more intensive efforts to prevent and mitigate the spread of COVID-19 among Californians who have been disproportionately impacted by this pandemic.

Please see https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/COVID19CountyMonitoringOverview.aspx for more information.

Also, in lieu of a Data Dictionary, please refer to the detailed explanation of the data columns in Appendix 1 of the above webpage.

Because this data is in machine-readable format, the merged headers at the top of the source spreadsheet have not been included:

- The first 8 columns are under the header "County Status as of Tier Assignment"

-  The next 3 columns are under the header "Current Data Week Tier and Metric Tiers for Data Week"

-  The next 4 columns are under the header "Case Rate Adjustment Factors"

-  The next column is under the header "Small County Considerations"

-  The last 5 columns are under the header "Health Equity Framework Parameters"
COVID-19 Hospital Data (ARCHIVED)

This dataset is not being updated as hospitals are no longer mandated to report COVID Hospitalizations to CDPH.

Data is from the California COVID-19 State Dashboard at https://covid19.ca.gov/state-dashboard/

__Note:__ Hospitalization counts include all patients diagnosed with COVID-19 during their stay. This does not necessarily mean they were hospitalized because of COVID-19 complications or that they experienced COVID-19 symptoms.

__Note:__ Cumulative totals are not available due to the fact that hospitals report the total number of patients each day (as opposed to new patients).
COVID-19 Post-Vaccination Infection Data (ARCHIVED)

__Note:__ This dataset is no longer being updated due to the end of the COVID-19 Public Health Emergency.

The California Department of Public Health (CDPH) is identifying vaccination status of COVID-19 cases, hospitalizations, and deaths by analyzing the state immunization registry and registry of confirmed COVID-19 cases. Post-vaccination cases are individuals who have a positive SARS-Cov-2 molecular test (e.g. PCR) at least 14 days after they have completed their primary vaccination series.

Tracking cases of COVID-19 that occur after vaccination is important for monitoring the impact of immunization campaigns. While COVID-19 vaccines are safe and effective, some cases are still expected in persons who have been vaccinated, as no vaccine is 100% effective. For more information, please see https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/Post-Vaccine-COVID19-Cases.aspx

Post-vaccination infection data is updated monthly and includes data on cases, hospitalizations, and deaths among the unvaccinated and the vaccinated. Partially vaccinated individuals are excluded. To account for reporting and processing delays, there is at least a one-month lag in provided data (for example data published on 9/9/22 will include data through 7/31/22). 

Notes:

*  On September 9, 2022, the post-vaccination data has been changed to compare unvaccinated with those with at least a primary series completed for persons age 5+. These data will be updated monthly (first Thursday of the month) and include at least a one month lag.

*  On February 2, 2022, the post-vaccination data has been changed to distinguish between vaccination with a primary series only versus vaccinated and boosted. The previous dataset has been uploaded as an archived table. Additionally, the lag on this data has been extended to 14 days.

*  On November 29, 2021, the denominator for calculating vaccine coverage has been changed from age 16+ to age 12+ to reflect new vaccine eligibility criteria. The previous dataset based on age 16+ denominators has been uploaded as an archived table.
MHS Dashboard Children and Youth Demographic Datasets

The following datasets are based on the children and youth (under age 21) beneficiary population and consist of aggregate Mental Health Service data derived from Medi-Cal claims, encounter, and eligibility systems.  These datasets were developed in accordance with California Welfare and Institutions Code (WIC) § 14707.5 (added as part of Assembly Bill 470 on 10/7/17).  Please contact BHData@dhcs.ca.gov for any questions or to request previous years’ versions of these datasets. Note: The Performance Dashboard AB 470 Report Application Excel tool development has been discontinued.  Please see the Behavioral Health reporting data hub at <a href='https://behavioralhealth-data.dhcs.ca.gov/' target='_blank' rel='nofollow ugc noopener noreferrer'>https://behavioralhealth-data.dhcs.ca.gov/</a> for access to dashboards utilizing these datasets and other behavioral health data.
COVID-19 Probable Cases (ARCHIVED)

__Note:__ This dataset is no longer being updated due to the end of the COVID-19 Public Health Emergency.

__Note:__ On 2/16/22, 17,467 cases based on at-home positive test results were excluded from the probable case counts. Per national case classification guidelines, cases based on at-home positive results are now classified as “suspect” cases. The majority of these cases were identified between November 2021 and February 2022. 

CDPH tracks both probable and confirmed cases of COVID-19 to better understand how the virus is impacting our communities. Probable cases are defined as individuals with a positive antigen test that detects the presence of viral antigens. Antigen testing is useful when rapid results are needed, or in settings where laboratory resources may be limited. Confirmed cases are defined as individuals with a positive molecular test, which tests for viral genetic material, such as a PCR or polymerase chain reaction test. Results from both types of tests are reported to CDPH.

Due to the expanded use of antigen testing, surveillance of probable cases is increasingly important. The proportion of probable cases among the total cases in California has increased.  To provide a more complete picture of trends in case volume, it is now more important to provide probable case data in addition to confirmed case data. The Centers for Disease Control and Prevention (CDC) has begun publishing probable case data for states. 

Testing data is updated weekly. Due to small numbers, the percentage of probable cases in the first two weeks of the month may change. Probable case data from San Diego County is not included in the statewide table at this time. 

For more information, please see https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/Probable-Cases.aspx
COVID-19 Variant Data (ARCHIVED)

__Note:__ This dataset is no longer being updated due to the end of the COVID-19 Public Health Emergency.

The California Department of Public Health (CDPH) is identifying ​the prevalence of circulating SARS-CoV-2 variants by analyzing ​CDPH Genomic Surveillance Data and ​CalREDIE, CDPH's communicable disease reporting and surveillance system. Viruses mutate into new strains or variants over time. Some variants emerge and then disappear. Other variants become common and circulate for a long time. Several specialized laboratories statewide sequence the genomes of a fraction of all positive COVID-19 tests to determine which variants are circulating. Sequencing and reporting of variant results takes several days after a test is identified as a positive for COVID-19. Not all ​viruses from positive COVID-19 tests are ​sequenced. Knowing what variants are circulating in California informs public health and clinical action.

Note: There is a natural reporting lag in these data due to the time commitment to complete whole genome sequencing; therefore, a 14 day lag is applied to these datasets to allow for data completeness. Please note that more recent data should be used with caution.

For more information, please see: https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/COVID-Variants.aspx
COVID-19 Time-Series Metrics by County and State (ARCHIVED)

__Note__: This COVID-19 data set is no longer being updated as of December 1, 2023. Access current COVID-19 data on the CDPH respiratory virus dashboard (https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/Respiratory-Viruses/RespiratoryDashboard.aspx) or in open data format (https://data.chhs.ca.gov/dataset/respiratory-virus-dashboard-metrics). 

As of August 17, 2023, data is being updated each Friday.

For death data after December 31, 2022, California uses Provisional Deaths from the Center for Disease Control and Prevention’s National Center for Health Statistics (NCHS) National Vital Statistics System (NVSS). Prior to January 1, 2023, death data was sourced from the COVID-19 registry. The change in data source occurred in July 2023 and was applied retroactively to all 2023 data to provide a consistent source of death data for the year of 2023. 

As of May 11, 2023, data on cases, deaths, and testing is being updated each Thursday. Metrics by report date have been removed, but previous versions of files with report date metrics are archived below.

All metrics include people in state and federal prisons, US Immigration and Customs Enforcement facilities, US Marshal detention facilities, and Department of State Hospitals facilities. Members of California's tribal communities are also included.

The "Total Tests" and "Positive Tests" columns show totals based on the collection date. There is a lag between when a specimen is collected and when it is reported in this dataset. As a result, the most recent dates on the table will temporarily show NONE in the "Total Tests" and "Positive Tests" columns. This should not be interpreted as no tests being conducted on these dates. Instead, these values will be updated with the number of tests conducted as data is received.
Data Brief: Avoidable Emergency Department Visits Vary Widely Across California

The data includes a broader range of geographic units of analysis than have previously been made available in HPD public reports, in addition to other measures.

- Geography: County, Covered California Region, Public Health Region, California Assembly District, California Senate District, California Congressional District
- Demographics: Age Band, Sex
- Payer Type: Commercial, Medi-Cal, Medicare
- Measures: Prevalence of 23 chronic conditions, total emergency department (ED) visits, avoidable ED visits
Dental Utilization Measures and Sealant Data by County, Ethnicity, & Age Calendar Year 2013 to 2023

This dataset shows use of Medi-Cal dental benefits by Medi-Cal members displayed by county, ethnicity, age groups and calendar year (2013, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, and 2023). This information consists of members receiving dental services in the following categories: Annual Dental Visit, Exams/Oral Health Evaluations, Use of Diagnostic Services, Use of Dental Treatment Services, Use of Preventive Services, Use of Restorative Services, Treatment/Prevention for Caries, and Use of Sealants. The Medi-Cal members were continuously enrolled in either Dental Managed Care or the Dental Fee-for-Service delivery system for at least 3 months during each measure year.
Dental Utilization Measures and Sealant Data by Ethnicity and Age Calendar Year 2013 to 2023

This dataset shows use of Medi-Cal dental benefits by Medi-Cal members displayed by ethnicity, age groups, and calendar year (for 2013, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, and 2023). This information consists of members receiving dental services in the following categories: Annual Dental Visit, Exams/Oral Health Evaluations, Use of Diagnostic Services, Use of Dental Treatment Services, Use of Preventive Services, Use of Restorative Services, Treatment/Prevention for Caries, and Use of Sealants. The Medi-Cal members were continuously enrolled in either Dental Managed Care or the Dental Fee-for-Service delivery system for at least 3 months during each measure year.
Disproportionate Share Hospital (DSH) Eligibility for State Fiscal Years 2010-2024

The data contains a list of hospitals in California that meet the Disproportionate Share Hospital (DSH) eligibility criteria.  DSH is a special program which is aimed at making up the short-fall for hospitals when care is provided to an uninsured or underinsured patient and to Medi-Cal beneficiaries.  A hospital which provides a certain amount of uncompensated care is designated as a disproportionate share hospital.
Dual Medi-Cal Enrollment and Medicare Advantage Enrollment in the Medicare Population in California Counties

This data set accompanies the Profile of the California Medicare Population chartbook, published by the Office of Medicare Innovation and Integration in February 2022, and available at (https://www.dhcs.ca.gov/services/Documents/OMII-Medicare-Databook-February-18-2022.pdf). The three data files in this data set were analyzed from federal administrative data (the Medicare Master Beneficiary Summary File) for beneficiary characteristics as of March 2021. These datasets include: Medicare enrollment, Medicare Advantage enrollment (and its converse fee-for-service Medicare enrollment), dual Medi-Cal eligibility and enrollment (and its converse Medicare-only enrollment), by county. Medicare Savings Program enrollees were considered Medicare-only and not dually enrolled in Medi-Cal. All Medicare Part C beneficiaries, including PACE, Cal MediConnect and Special Needs Plans, were considered to have Medicare Advantage.

DHCS partnered with The SCAN Foundation and ATI Advisory in 2021 and 2022 to develop a series of chartbooks that provide information about Medicare beneficiaries in California. This work is supported by a grant from The SCAN Foundation to advance a coordinated and easily navigated system of high-quality services for older adults that preserve dignity and independence. For more information, visit www.TheSCANFoundation.org.
Educational Attainment

This table contains data on the percent of population age 25 and up with a four-year college degree or higher for California, its regions, counties, county subdivisions, cities, towns, and census tracts. Greater educational attainment has been associated with health-promoting behaviors including consumption of fruits and vegetables and other aspects of healthy eating, engaging in regular physical activity, and refraining from excessive consumption of alcohol and from smoking. Completion of formal education (e.g., high school) is a key pathway to employment and access to healthier and higher paying jobs that can provide food, housing, transportation, health insurance, and other basic necessities for a healthy life. Education is linked with social and psychological factors, including sense of control, social standing and social support. These factors can improve health through reducing stress, influencing health-related behaviors and providing practical and emotional support.  More information on the data table and a data dictionary can be found in the Data and Resources section.  The educational attainment table is part of a series of indicators in the Healthy Communities Data and Indicators Project (HCI) of the Office of Health Equity. The goal of HCI is to enhance public health by providing data, a standardized set of statistical measures, and tools that a broad array of sectors can use for planning healthy communities and evaluating the impact of plans, projects, policy, and environmental changes on community health. The creation of healthy social, economic, and physical environments that promote healthy behaviors and healthy outcomes requires coordination and collaboration across multiple sectors, including transportation, housing, education, agriculture and others. Statistical metrics, or indicators, are needed to help local, regional, and state public health and partner agencies assess community environments and plan for healthy communities that optimize public health. More information on HCI can be found here: https://www.cdph.ca.gov/Programs/OHE/CDPH%20Document%20Library/Accessible%202%20CDPH_Healthy_Community_Indicators1pager5-16-12.pdf  

The format of the educational attainment table is based on the standardized data format for all HCI indicators. As a result, this data table contains certain variables used in the HCI project (e.g., indicator ID, and indicator definition). Some of these variables may contain the same value for all observations.
Elective Percutaneous Coronary Intervention (PCI) Program Reports

This dataset contains the location of California hospitals that are certified to perform elective percutaneous coronary interventions (PCIs) without on-site cardiac surgery.  The data provides performance ratings for three outcome measures: mortality, post-PCI stroke, and post-PCI emergency coronary artery bypass graft surgery.  It includes the number of cases, adverse events and risk-adjusted rates for certified hospitals compared to the overall observed statewide rates.
Emergency Department Volume and Capacity

This dataset provides the Emergency Department ratio of encounters and treatment stations to represent the ED Burden. Smaller ratios indicate fewer ED visits per available treatment station and less burden. Larger ratios of ED visits per available treatment station indicate greater burden. The encounters are broken down by health-related conditions: Active COVID-19, Asthma, Cancer, Cardiac, COPD, COVID-19 History, Diabetes, Homeless, Hypertension, Mental Health, Obesity, Pneumonia, Respiratory, Sepsis, Stroke, and Substance Abuse.