AndreaBozzo/ceres-open-data-index huggingface dataset:
Adults with Diabetes Per 100 (LGHC Indicator)

This is a source dataset for a Let's Get Healthy California indicator at "https://letsgethealthy.ca.gov/. This table displays the prevalence of diabetes in California. It contains data for California only. The data are from the California Behavioral Risk Factor Surveillance Survey (BRFSS). The California BRFSS is an annual cross-sectional health-related telephone survey that collects data about California residents regarding their health-related risk behaviors, chronic health conditions, and use of preventive services.  The BRFSS is conducted by Public Health Survey Research Program of California State University, Sacramento under contract from CDPH. This prevalence rate does not include pre-diabetes, or gestational diabetes. This is based on the question: "Has a doctor, or nurse or other health professional ever told you that you have diabetes?" The sample size for 2014 was 8,832. NOTE: Denominator data and weighting was taken from the California Department of Finance, not U.S. Census. Values may therefore differ from what has been published in the national BRFSS data tables by the Centers for Disease Control and Prevention (CDC) or other federal agencies.
MHS Dashboard Adult Demographic Datasets

The following datasets are based on the adult (age 21 and over) beneficiary population and consist of aggregate MHS 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.
AHRQ Pediatric Quality Indicators for California Hospitals

The Pediatric Quality Indicators (PDIs), developed by the federal Agency for Healthcare Research and Quality (AHRQ), identify potential quality and patient safety issues specific to the pediatric inpatient population. HCAI will report hospital-level results on five PDIs - Accidental Puncture or Laceration, Neonatal Blood Stream Infection, Postoperative Respiratory Failure, Postoperative Sepsis, and Central Venous Catheter-Related Blood Stream Infection. The results were generated with the AHRQ software version 2024. This dataset does not include complications acquired in outpatient settings.
Ambulatory Surgery - Characteristics by Facility (Pivot Profile)

This dataset contains annual Excel pivot tables that display summaries of the patients treated in each hospital-based and freestanding Ambulatory Surgery Clinic licensed by the California Department of Public Health (CDPH).  The summary data includes discharge disposition, expected payer, preferred language spoken, age groups, race groups, sex, principal diagnosis groups, principal procedure groups, and principal external cause of injury/morbidity groups.  The data can also be summarized statewide or for a specific facility county, type of control, and/or type of license (hospital or clinic).  Note: Physician-owned ambulatory surgery clinics do not report their data to HCAI and, therefore, are not included in the statewide frequencies.
Annual Miles Traveled

This table contains data on the annual miles traveled by place of occurrence and by mode of transportation (vehicle, pedestrian, bicycle), for California, its regions, counties, and cities/towns.  The ratio uses data from the California Department of Transportation, the U.S. Department of Transportation, and the U.S. Census Bureau. The table is part of a series of indicators in the Healthy Communities Data and Indicators Project of the Office of Health Equity. 
Miles traveled by individuals and their choice of mode – car, truck, public transit, walking or bicycling – have a major impact on mobility and population health. Miles traveled by automobile offers extraordinary personal mobility and independence, but it is also associated with air pollution, greenhouse gas emissions linked to global warming, road traffic injuries, and sedentary lifestyles. Active modes of transport – bicycling and walking alone and in combination with public transit – offer opportunities for physical activity, which has many documented health benefits.  More information about the data table and a data dictionary can be found in the About/Attachments section.
Asthma Deaths by County

This dataset contains counts and rates (per 1,000,000 residents) of asthma deaths among Californians statewide and by county. The data are stratified by age group (all ages, 0-17, 18+) and reported for 3-year periods. The data are derived from the California Death Statistical Master Files, which contain information collected from death certificates. All deaths with asthma coded as the underlying cause of death (ICD-10 CM J45 or J46) are included.
Asthma ED Visit Rates (LGHC Indicator)

This is a source dataset for a Let's Get Healthy California indicator at https://letsgethealthy.ca.gov/.

This dataset contains counts and rates (per 10,000 residents) of asthma (ICD9-CM, 493.0-493.9) emergency department visits among California residents by County and age group (all ages, 0-17, 18+). The data are derived from the Department of Health Care Access and Information emergency department databases. 

These data include emergency department visits from all licensed hospitals in California. These data are based only on primary discharge diagnosis codes (ICD9-CM).

Starting in 2019, HCAI classified non-Hispanic individuals who identified with two or more races as "Multiracial." Previously these were assigned to a single other race.

NOTE: Rates are calculated from the total number of Asthma ED Visits (not the unique number of individuals).
Behavioral Health and Workforce

The dataset contains a ratio of the number of patient encounters (i.e., Inpatient Hospitalizations and Emergency Department visits) with a behavioral health diagnosis, per healthcare provider license with a specialty in behavioral health. The ratio is categorized based on the values of the Numerator to Denominator. Larger ratios may indicate a greater need for providers specializing in behavioral health. Smaller ratios may indicate a lower need for providers specializing in behavioral health. The dataset also contains the numbers of the top ten behavioral health diagnoses, by diagnosis category, that were present during the encounters. The table is broken down by county, and it is limited to hospital Inpatient and Emergency Department settings.
California Adults Who Met Physical Activity Guidelines for Americans, 2013

This dataset is from the 2013 California Dietary Practices Survey of Adults. This survey has been discontinued. Adults were asked a series of eight questions about their physical activity practices in the last month. These questions were borrowed from the Behavior Risk Factor Surveillance System. Data displayed in this table represent California adults who met the aerobic recommendation for physical activity, as defined by the 2008 U.S. Department of Health and Human Services Physical Activity Guidelines for Americans and Objectives 2.1 and 2.2 of Healthy People 2020.

The California Dietary Practices Surveys (CDPS) (now discontinued) was the most extensive dietary and physical activity assessment of adults 18 years and older in the state of California. CDPS was designed in 1989 and was administered biennially in odd years up through 2013.  The CDPS was designed to monitor dietary trends, especially fruit and vegetable consumption, among California adults for evaluating their progress toward meeting the 2010 Dietary Guidelines for Americans and the Healthy People 2020 Objectives. For the data in this table, adults were asked a series of eight questions about their physical activity practices in the last month. Questions included: 1) During the past month, other than your regular job, did you participate in any physical activities or exercise such as running, calisthenics, golf, gardening or walking for exercise?  2) What type of physical activity or exercise did you spend the most time doing during the past month?  3) How many times per week or per month did you take part   n this activity during the past month?  4) And when you took part in this activity, for how many minutes or hours did you usually keep at it?  5) During the past month, how many times per week or per month did you do physical activities or exercises to strengthen your muscles? Questions 2, 3, and 4 were repeated to collect a second activity. Data were collected using a list of participating CalFresh households and random digit dial, approximately 1,400-1,500 adults (ages 18 and over) were interviewed via phone survey between the months of June and October. Demographic data included gender, age, ethnicity, education level, income, physical activity level, overweight status, and food stamp eligibility status. Data were oversampled for low-income adults to provide greater sensitivity for analyzing trends among our target population.
California Statewide Inpatient Mortality Rates

The dataset contains risk-adjusted mortality rates, and number of deaths and cases for 6 medical conditions treated (Acute Stroke, Acute Myocardial Infarction, Heart Failure, Gastrointestinal Hemorrhage, Hip Fracture and Pneumonia) and 6 procedures performed (Abdominal Aortic Aneurysm Repair, Carotid Endarterectomy, Craniotomy, Esophageal Resection, Pancreatic Resection, Percutaneous Coronary Intervention) in California hospitals. The 2014 and 2015 IMIs were generated using AHRQ Version 5.0, while the 2012 and 2013 IMIs were generated using AHRQ Version 4.5.  The differences in the statistical method employed and inclusion and exclusion criteria using different versions can lead to different results. Users should not compare trends of mortality rates over time.  However, many hospitals showed consistent performance over years; “better” performing hospitals may perform better and “worse” performing hospitals may perform worse consistently across years. This dataset does not include conditions treated or procedures performed in outpatient settings. Please refer to hospital table for hospital rates: https://data.chhs.ca.gov/dataset/california-hospital-inpatient-mortality-rates-and-quality-ratings
CalWORKs Welfare-to-Work Monthly Activities

CalWORKs Welfare-to-Work (WTW) Monthly Activity Report.  These data provide detailed counts of CalWORKs WTW enrollees, including exemptions and the type of activity individuals are enrolled in as part of their WTW plan requirements.  In addition to activities, the data include information on clients' nonparticipation status, supportive service participation, and postemployment/job-retention service participation.  These items are categorized by adults in two-parent families, adults in all other families, as well as a grand total.  See the WTW 25 and WTW 25A reports posted on the California Department of Social Services' Research and Data Reports homepage (http://www.cdss.ca.gov/inforesources/Research-and-Data/CalWORKs-Data-Tables) for more information.
Case Mix Index

The Case Mix Index (CMI) is the average relative DRG weight of a hospital’s inpatient discharges, calculated by summing the Medicare Severity-Diagnosis Related Group (MS-DRG) weight for each discharge and dividing the total by the number of discharges.  The CMI reflects the diversity, clinical complexity, and resource needs of all the patients in the hospital.  A higher CMI indicates a more complex and resource-intensive case load.  Although the MS-DRG weights, provided by the Centers for Medicare & Medicaid Services (CMS), were designed for the Medicare population, they are applied here to all discharges regardless of payer.  Note: It is not meaningful to add the CMI values together.
CA Surgeon Risk-Adjusted Operative Mortality Rates for Coronary Artery Bypass Graft (CABG) Surgery

This dataset provides performance ratings for California Surgeons for Risk-Adjusted Operative Mortality Rates for Coronary Artery Bypass Graft (CABG) Surgery from 2011 to 2018. It also includes the number of isolated CABG surgery cases and deaths that each surgeon performed as well as the location of hospitals where the surgeon performed CABG surgery.
CA Wellness Plan Data Reference Guide

The purpose of the California Wellness Plan (CWP) Data Reference Guide (Reference Guide) is to provide access to the lowest-level data for each CWP Objective; lowest-level data source, instructions to access data, and additional details are described. Some CWP Objectives do not have program leads, data sources, baselines, and/or targets, but are included because they were a result of CDPH program or partner input and were felt to be important to the reduction of chronic disease incidence, prevalence, and health disparities. Agencies, programs and/or partners identified with an objective may be either data stewards and/or engaged in activities to achieve the target, but may not have adequate resources for statewide activities.  Developmental Objectives will be updated as information becomes available. 

Background: The California Wellness Plan, California's Chronic Disease Prevention and Health Promotion Plan was released February 2014 by the California Department of Public Health (CDPH).  The overarching goal of CWP is Equity in Health and Wellbeing; additional CWP Goals include: 1) Healthy Communities, 2) Optimal Health Systems Linked with Community Prevention, 3) Accessible and Usable Health Information, and 4) Prevention  Sustainability and Capacity. All CWP objectives fall under the framework of Let's Get Healthy California Task Force priorities. [California Wellness Plan](https://archive.cdph.ca.gov/programs/cdcb/Documents/CDPH-CAWellnessPlan2014%20(Agency%20Approved)%20FINAL%202-27-14(Protected)%20rev%20(8).pdf)

Green text in the “Objective” column indicates updates that were made to the California Wellness Plan objectives in 2016.
Community Care Licensing Facilities

## Community Care Licensing Division
The Community Care Licensing Division’s (CCLD) mission is to promote the health, safety, and quality of life of each person in community care through the administration of an effective collaborative regulatory enforcement system. This is accomplished by:

* Promoting strategies to increase voluntary compliance
* Providing technical assistance to and consulting with care providers
* Working collaboratively with clients, their families, advocates, care providers, placement agencies, related programs and regulatory agencies, and others involved in community care
* Training staff in all aspects of the licensing process
* Educating the public about CCLD and community care options
* Promoting continuous improvement and efficiency throughout the community care licensing system
Health Care Personnel Influenza Vaccination

Health and Safety Code section 1288.7(a) requires California acute care hospitals to offer influenza vaccine free of charge to all healthcare providers (HCP) or sign a declination form if a HCP chooses not to be vaccinated. Hospitals must report HCP influenza vaccination data to the California Department of Public Health (CDPH), including the percentage of HCP vaccinated. CDPH is required to make this information public on an annual basis [Health and Safety Code section 1288.8 (b)].

California acute care hospitals are required to offer free influenza vaccine to HCP. Hospital HCP must receive an annual vaccine or sign a declination form. Hospitals collect vaccination data for all HCP physically working in the hospital for at least one day during influenza season, regardless of clinical responsibility or patient contact. Hospitals report HCP vaccination rates to the California Department of Public Health (CDPH) and CDPH publishes the hospital results annually. CDPH reports data separately for hospital employees, licensed independent practitioners such as physicians, other contract staff, and trainees and volunteers (Health and Safety Code section 1288.7-1288.8).

Detailed information about the variables included in each dataset are described in the accompanying data dictionaries for the year of interest.

For general information about NHSN, surveillance definitions, and reporting requirements for HCP influenza vaccination, please visit: https://www.cdc.gov/nhsn/hps/vaccination/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 personnel influenza vaccinations in California hospitals, please visit: https://www.cdph.ca.gov/Programs/CHCQ/HAI/Pages/HealthcarePersonnelInfluenzaVaccinationReportingInCA_Hospitals.aspx
COVID-19 Skilled Nursing Facility Data

__Note:__ This web page provides data on health facilities only. To file a complaint against a facility, please see: https://www.cdph.ca.gov/Programs/CHCQ/LCP/Pages/FileAComplaint.aspx

Skilled Nursing Facility (SNF) testing and case data for the COVID-19 response.  For details on the  SNF COVID-19 data, please visit this site: https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx

Please note that values of less than eleven (11) are masked (shown as blank) in accordance with de-identification guidelines. This means the cumulative sum in this dataset will not match the totals from the dashboard due to data artifact from small cell size suppression.
CHDP Summary Of All Health Assessments By Funding Source SFY 2008-2014

The Child Health and Disability Prevention (CHDP) annual report for state fiscal years (SFY) specified in the title provides an aggregate level data drawn from the Confidential Screening/Billing Report (PM-160) form used for fee-for-service (FFS) reimbursement of services, and/or for reporting preventive health assessment services.  The display of the data in this report is intended to provide a detailed view of the health assessments provided to CHDP eligible children and youth as reported to the California Department of Health Care Services (DHCS) during SFY 2008-12.  CHDP eligible children and youth are those whose gross family incomes are at or below 200 percent of the federal poverty level, age restriction for full-scope Medi-Cal of less than 21 years of age, presumptive eligibility (the Gateway process), or children and youth with no health insurance for health assessments who must be less than 19 years of age.  CHDP children and youth receive health assessments and screenings according to the age-based CHDP Periodicity Schedule or when assessments and screenings are considered medically necessary. Note: Empty Cells represent values that are not shown to protect confidentiality of the individuals summarized in the data.
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.
Chemicals in Cosmetics

These data reflect information that has been reported to the California Safe Cosmetics Program (CSCP) in the California Department of Public Health (CDPH). The primary purpose of the CSCP is to collect information on hazardous and potentially hazardous ingredients in cosmetic products sold in California and to make this information available to the public.   

For all cosmetic products sold in California, the California Safe Cosmetics Act (“the Act”) requires the manufacturer, packer, and/or distributor named on the product label to provide to the CSCP a list of all cosmetic products that contain any ingredients known or suspected to cause cancer, birth defects, or other developmental or reproductive harm.     

To assist companies with reporting, CDPH has compiled a list of reportable ingredients based on lists and reports available from the authoritative scientific bodies cited in the Act to cause cancer or reproductive harm; it is meant to serve as guidance and is not all-inclusive. Companies with reportable ingredients in their products must submit information to the California Safe Cosmetics Program if the company:   

*	Has annual aggregate sales of cosmetic products of one million dollars or more, and 
*	Has sold cosmetic products in California on or after January 1, 2007.   

The data table consists of: label names of cosmetic/personal care products, company/manufacturer names, product brand names, product categories, Chemical Abstracts Service registry numbers (CAS#) of the reported chemical ingredients, names of reported chemical ingredients, the number of reported chemicals for each product, and dates of reporting, product discontinuation or reformulation if applicable.   

All products containing carcinogens or developmental or reproductive toxicants may not be included due to companies failing to report.

List of reportable ingredients: www.cdph.ca.gov/ReportableIngredientsList
Child Health and Disability Prevention  (CHDP) Program, Number Of Immunizations By Age SFY 2008-2014

The Child Health and Disability Prevention (CHDP) annual report for state fiscal years (SFY) 2008-14 provides an aggregate level data drawn from the Confidential Screening/Billing Report (PM-160) form used for fee-for-service (FFS) reimbursement of services, and/or for reporting preventive health assessment services.  The display of the data in this report is intended to provide a detailed view of the health assessments provided to CHDP eligible children and youth as reported to the California Department of Health Care Services (DHCS) during SFY 2008-14.  CHDP eligible children and youth are those whose gross family incomes are at or below 200 percent of the federal poverty level, age restriction for full-scope Medi-Cal of less than 21 years of age, presumptive eligibility (the Gateway process), or children and youth with no health insurance for health assessments who must be less than 19 years of age.  CHDP children and youth receive immunizations against specific infectious diseases according to the age-based CHDP Periodicity Schedule or when assessments and screenings are considered medically necessary.
Child Health and Disability Prevention (CHDP), Children Served and Amounts Paid By Age, SFY 2008-14

The Child Health and Disability Prevention (CHDP) annual report for state fiscal year (SFY) 2008-12 provides an aggregate level data drawn from the Confidential Screening/Billing Report (PM-160) form used for fee-for-service (FFS) reimbursement of services, and/or for reporting preventive health assessment services.  The display of the data in this report is intended to provide a detailed view of the health assessments provided to CHDP eligible children and youth as reported to the California Department of Health Care Services (DHCS) during SFY 2008-12.  CHDP eligible children and youth are those whose gross family incomes are at or below 200 percent of the federal poverty level, age restriction for full-scope Medi-Cal of less than 21 years of age, presumptive eligibility (the Gateway process), or children and youth with no health insurance for health assessments who must be less than 19 years of age.  CHDP children and youth receive health assessment services according to the age-based CHDP Periodicity Schedule or when assessments are considered medically necessary.