AndreaBozzo/ceres-open-data-index huggingface dataset:
Federally Qualified Health Center Wrap Payment and Managed Care Encounter

This table contains an analysis of wrap claims and encounters reported to DHCS. The match percentage is based on the count of wraps received matching to their encounter. A Wrap Payment is a supplemental payment to Federally Qualified Health Centers (FQHC), covering the difference between their per-visit PPS (Per-Visit Payment System) rate and the amount received from managed care plans for services to Medi-Cal managed care members.
Food Affordability

This table contains data on the average cost of a market basket of nutritious food items relative to income for female-headed households with children, for California, its regions, counties, and cities/towns.  The ratio uses data from the U.S. Department of Agriculture 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. 
An adequate, nutritious diet is a necessity at all stages of life. Inadequate diets can impair intellectual performance and have been linked to more frequent school absence and poorer educational achievement in children. Nutrition also plays a significant role in causing or preventing a number of illnesses, such as cardiovascular disease, some cancers, obesity, type 2 diabetes, and anemia.
At least two factors influence the affordability of food and the dietary choices of families – the cost of food and family income. The inability to afford food is a major factor in food insecurity, which has a spectrum of effects including anxiety over food sufficiency or food shortages; reduced quality or desirability of diet; and disrupted eating patterns and reduced food intake.  More information about the data table and a data dictionary can be found in the Attachments.
Fruit and Vegetable Consumption in California Residents, 2012/2013

Percentage of California residents who consumed five or more servings of fruits and vegetables a day. These data are from the 2013 California Dietary Practices Surveys (CDPS), 2012 California Teen Eating, Exercise and Nutrition Survey (CalTEENS), and 2013 California Children’s Healthy Eating and Exercise Practices Survey (CalCHEEPS). These surveys have been discontinued. Adults, adolescents, and children (with parental assistance) were asked about the serving sizes and types of fruits and vegetables they ate over the previous 24 hour period. Child/Adolescent: Fruit and vegetable, beverage, and junk food consumption, along with physical activity, sedentary time, active transport, sport participation, school environment, home neighborhood environment, fruit and vegetable access and availability, household/family rules, weight status, school breakfast/lunch participation, attitudes, and beliefs. Adult: Fruit and vegetable, beverage, and junk food consumption, along with physical activity, sedentary time, worksite environment, school environment, home neighborhood environment, fruit and vegetable access and availability, household/family rules, weight status and weight loss practices, and food security.
Healthcare Payments Data (HPD) Medical Out-of-Pocket Costs and Chronic Conditions

This dataset contains data for the Healthcare Payments Data (HPD): Medical Out-of-Pocket Costs and Chronic Conditions report. The data covers three measurement categories: annual member count, annual median out-of-pocket count, annual median claim count. The annual member count quantify the number of unique individuals who received at least one medical service in the reporting year. Annual median out-of-pocket measurements quantifies the sum of copay, coinsurance, and deductible incurred by members. Annual median claim count measurements quantifies the number of distinct claims or encounters associated with members. Both 25th and 75th percentiles for out-of-pocket cost and claim count are also included. Measures are grouped by payer types, chronic conditions flag, chronic condition types, and chronic condition numbers.
Healthcare Payments Data (HPD) Healthcare Measures

This dataset contains data for the Healthcare Payments Data (HPD) Healthcare Measures report. The data cover three measurement categories: Health conditions, Utilization, and Demographics. The health condition measurements quantify the prevalence of long-term illnesses and major medical events prominent in California’s communities like diabetes and heart failure. Utilization measures convey rates of healthcare system use through visits to the emergency department and different categories of inpatient stays, such as maternity or surgical stays. The demographic measures describe the health coverage and other characteristics (e.g., age) of the Californians included in the data and represented in the other measures. The data include both a count or sum of each measure and a count of the base population so that data users can calculate the percentages, rates, and averages in the visualization.
Measures are grouped by year, age band, sex (assigned sex at birth), payer type, Covered California Region, and county.
Health Facilities State Enforcement Actions

__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

The California Department of Public Health (CDPH), Center for Health Care Quality, Licensing and Certification (L&C) Program licenses more than 30 types of healthcare facilities. The Electronic Licensing Management System (ELMS) is a CDPH data system created to manage state licensing-related data and enforcement actions. 

The “Health Facilities’ State Enforcement Actions” dataset includes summary information for state enforcement actions (state citations or administrative penalties) issued to California healthcare facilities. This file, a sub-set of the ELMS system data, includes state enforcement actions that have been issued from July 1, 1997 through June 30, 2024.  Data are presented for each citation/penalty, and include information about the type of enforcement action, violation category, penalty amount, violation date, appeal status, and facility. 

The “LTC Citation Narrative” dataset contains the full text of citations that were issued to long-term care (LTC) facilities between January 1, 2012 – December 31, 2017.  DO NOT DOWNLOAD in Excel as this file has large blocks of text which may truncate.  For example, Excel 2007 and later display, and allow up to, 32,767 characters in each cell, whereas earlier versions of Excel allow 32,767 characters, but only display the first 1,024 characters.  Please refer to instructions in “E_Citation_Access_DB_How_To_Docs”, about how to download and view data.  

These files enable providers and the public to identify facility non-compliance and quality issues. By making this information available, quality issues can be identified and addressed.  Please refer to the background paper, “About Health Facilities’ State Enforcement Actions” for information regarding California state enforcement actions before using these data.  Data dictionaries and data summary charts are also available.  

__Note:__ The Data Dictionary at the bottom of the dataset incorrectly lists the data column formats as all Text. For proper format labels, please go [here](https://data.chhs.ca.gov/dataset/healthcare-facility-state-enforcement-actions/resource/e38dd6e0-31a6-46f8-a9a0-8f48a410ee74).
Healthcare Payments Data Snapshot

This dataset contains data for the Healthcare Payments Data (HPD) Snapshot visualization. The Enrollment data file contains counts of claims and encounter data collected for California's statewide HPD Program. It includes counts of enrollment records, service records from medical and pharmacy claims, and the number of individuals represented across these records. Aggregate counts are grouped by payer type (Commercial, Medi-Cal, or Medicare), product type, and year. The Medical data file contains counts of medical procedures from medical claims and encounter data in HPD. Procedures are categorized using claim line procedure codes and grouped by year, type of setting (e.g., outpatient, laboratory, ambulance), and payer type. The Pharmacy data file contains counts of drug prescriptions from pharmacy claims and encounter data in HPD. Prescriptions are categorized by name and drug class using the reported National Drug Code (NDC) and grouped by year, payer type, and whether the drug dispensed is branded or a generic.
Healthcare Payments Data (HPD) Services Report

This dataset contains data for the Healthcare Payments Data (HPD) Services report. The term "Services" refers to individual procedures reported on the service lines of healthcare claims in California, categorized using the Restructured Berenson-Eggers Type of Services (BETOS) Classification System (RBCS) from the Centers for Medicare & Medicaid Services (CMS). The data in the report includes three main metrics: Total services, the total member count, and the service rate per 1,000 members. Total services represents the total number of services received by members during the reporting year. The member count reports the total number of unique individuals who received at least one service during the reporting year. The service rate per 1,000 members is calculated by dividing the total number of services during the reporting year by the total sum of monthly member enrollments (provided in the data) and multiplying the result by 12,000. The metrics can be grouped by year, age, sex (assigned at birth), county of residence (including an option for Los Angeles Service Planning Areas, or SPAs), Covered California Region, and payer. 

Users can choose to view the data at two different levels. The most aggregate level groups the data by the eight main RBCS categories: Anesthesia, Durable Medical Equipment (DME), Evaluation and Management (E&M), Imaging, Procedure, Test, Treatment and Other. The second level breaks the eight aggregate RBCS categories into more specific subcategories. Data files are provided for each choice.
Health Care Quality Report Card

The California Health Care Quality Report Cards show the quality of health care for millions of Californians who get their care through medical groups and commercial insurance plans. Quality health care is getting the right care at the right time.

* The Health Plan Report Card data includes the 10 largest Health Maintenance Organizations (HMOs) and the 5 largest Preferred Provider Organizations (PPOs).
* The Medical Group - Commercial Report Card data includes 204 medical groups that have contracts with the HMOs listed in the Health Plan Report Card.
* The Medical Group - Medicare Report Card data includes 186 medical groups that have contracts with the Medicare Advantage plans listed in the Health Plan Report Card and serve Medicare Advantage members.
* The Counties data lists the counties served by each health plan and medical group included in the Report Cards.

Note: This data is maintained by CDII and was formerly created by the CA Office of the Patient Advocate. For more information please visit the [CDII OPA webpage](https://www.cdii.ca.gov/about/divisions/operations-and-policy/about-office-of-patient-advocate)
Health Professional Shortage Areas in California

The Health Resources and Services Administration (HRSA) monitors and creates the geographic Health Professional Shortage Area (HPSA) federal designations for Primary Care, Mental Health, and Dental Health and can update those designations at any time. To avoid outdated information, static HPSA files have been removed from this site. Please visit https://data.hrsa.gov/data/download, select "Health Workforce" from the dropdown, and click "Shortage Areas" to find the updated HPSA files. 
If you have any questions, please use the contact email below to reach out to HCAI's Workforce Data Inbox.
High School Electronic Smoking Device and Tobacco Use Prevalence

This dataset contains two data files 1) High school electronic smoking device use and 2) High school tobacco use. Tobacco use is defined as having used either cigarettes, little cigars or cigarillos, cigars, kreteks (clove cigars), hookah, electronic smoking devices (e.g. e-cigarettes, vape pens, pod mods), or smokeless tobacco (e.g. chew, dip, snuff, snus). See the individual file description for more information on each data file.
 
The California Student Tobacco Survey (CSTS) is an on-going in-school survey of tobacco use among California middle and high school students. The purpose of the survey is to assess the use of, knowledge of, and attitudes toward cigarettes and emerging tobacco products (e.g. e-cigarettes, hookah, cigarillos). The California Tobacco Control Program coordinates statewide tobacco control efforts and funds the California Student Tobacco Survey (CSTS).
HIV/AIDS Cases

This data set includes tables on persons living with HIV/AIDS, newly diagnosed HIV cases and all cause deaths in HIV/AIDS cases by gender, age, race/ethnicity and transmission category.

In all tables, cases are reported as of December 31 of the given year, as reported by December 31, 2024, to allow a minimum of 12 months reporting delay.

Gender is determined by both current gender and sex at birth variables; transgender values are assigned when current gender is identified as "Transgender" or when a discrepancy is identified between a person's sex at birth and their current gender (e.g., cases where sex at birth is "Male" and current gender is "Female" will become Transgender: Male to Female.) Prior to 2003, Asian and Native Hawaiian/Pacific Islanders were classified as one combined group. In order to present these race/ethnicities separately, living cases recorded under this combined classification were split and redistributed according to their expected proportional population representation estimated from post-2003 data.
Hospital Emergency Department - Characteristics by Facility (Pivot Profile)

This dataset contains annual Excel pivot tables that display summaries of the patients treated in each Emergency Department (ED).  The Emergency Department data is sourced from two databases, the ED Treat-and-Release Database and the Inpatient Database (i.e. patients treated in the ED and then formally admitted to the hospital).  The summary data include number of visits, expected payer, discharge disposition, age groups, sex, preferred language spoken, race groups, principal diagnosis groups, and principal external cause of injury/morbidity groups.  The data can also be summarized statewide or for a specific hospital county, ED service level, teaching/rural status, and/or type of control.
Hospital Inpatient - Characteristics by Facility (Pivot Profile)

This dataset contains annual Excel pivot tables that display summaries of the inpatients treated in each hospital.  The summary data include discharges, discharge days, average length of stay, age groups, race groups, sex, expected payer, type of care, do not resuscitate orders, admission source, admission type, discharge disposition, 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 hospital county, bed size grouping, and/or type of control.
Hospitalization Counts and Rates of Selected Adverse Hospital Events by California County

(See Note below regarding 2015 data).  The dataset contains hospitalization counts and rates (age 18+), statewide and by county, for 7 potentially-preventable adverse events that occur during a hospital stay.  They provide a perspective on complications and iatrogenic events and help assess total incidence within a region. The measures, based upon the Agency for Healthcare Research and Quality’s (AHRQ’s) Patient Safety Indicators (PSIs), include: retained surgical item or unretrieved device fragment, iatrogenic pneumothorax, central venous catheter-related blood stream infection, postoperative wound dehiscence, accidental puncture or laceration, transfusion reaction, and perioperative hemorrhage or hematoma.  Note: HCAI is only releasing the first 3 quarters of 2015 data due to a change in the reporting of diagnoses/procedures from ICD-9-CM to ICD-10-CM/PCS effective October 1, 2015, and the inability of the AHRQ software to handle both code sets concurrently.
Hospital Profitability, 2009-2013

The dataset contains income statement information for all licensed, comparable hospitals in the state of California.  Kaiser hospitals, state mental hospitals, psychiatric health facilities, and hospitals with mainly long-term care patients are excluded.  Deductions from Revenue, Net Patient Revenue, Net from Operations (Operating Revenue less Operating Expense), and Net Income for public hospitals has been adjusted for Disproportionate Share intergovernmental transfers for funding the Disproportionate Share Hospital Program. The program gets federal matching funds to pay supplemental payments to hospitals with a disproportionate share of uninsured, underinsured, and Medi-Cal patients.  To link the OSHPD IDs with those from other Departments, like CDPH, please reference the "Licensed Facility Cross-Walk" Open Data table at https://data.chhs.ca.gov/dataset/licensed-facility-crosswalk.
Percent of Household Overcrowding (> 1.0 persons per room) and Severe Overcrowding (> 1.5 persons per room)

This dataset contains two tables on the percent of household overcrowding (> 1.0 persons per room) and severe overcrowding (> 1.5 persons per room) for California, its regions, counties, and cities/towns.  Data is from the U.S. Department of Housing and Urban Development (HUD), Comprehensive Housing Affordability Strategy (CHAS) and U.S. Census American Community Survey (ACS). The table is part of a series of indicators in the Healthy Communities Data and Indicators Project (HCI) of the Office of Health Equity: Healthy Communities Data and Indicators Project of the Office of Health Equity. Residential crowding has been linked to an increased risk of infection from communicable diseases, a higher prevalence of respiratory ailments, and greater vulnerability to homelessness among the poor.  Residential crowding reflects demographic and socioeconomic conditions.  Older-adult immigrant and recent immigrant communities, families with low income and renter-occupied households are more likely to experience household crowding.  A form of residential overcrowding known as "doubling up"—co-residence with family members or friends for economic reasons—is the most commonly reported prior living situation for families and individuals before the onset of homelessness.  More information about the data table and a data dictionary can be found in the About/Attachments section.The household crowding 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 household overcrowding tables 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.
Immunizations in Child Care by Academic Year

This dataset contains immunization status of child care facility enrollees aged 2 years to 4 years 11 months in California in facilities with 10 or more children enrolled. Smaller schools were excluded to help protect privacy. Explanation of the different immunizations is in the attached data dictionary. The California Health and Safety Code Section 120325-75 requires students to provide proof of immunization for school and child care entry. Additionally, California Health and Safety Code Section 120375 and California Code of Regulation Section 6075 require all schools and child care facilities to assess and report annually the immunization status of their enrollees.

The annual child care assessment is conducted each fall to monitor compliance with the California School Immunization law. Results from this assessment are used to measure immunization coverage among children entering licensed child care facilities. This data set presents results from the child care assessment and immunization coverage in licensed child care facilities by county. Not all facilities reported. To review individual child care facility coverage and exemption rates in a separate lookup format, go to the School Lookup page at the Immunization Branch's Shots for School website: http://www.shotsforschool.org/lookup/

See the full PDF reports by year here:https://www.shotsforschool.org/child-care/reporting-data/

See the attached file 'Notes on Methods' for data suppression in the '2016-17 academic year and beyond'.

For earlier years of data: https://www.shotsforschool.org/child-care/reporting-data/
Income Inequality

This table contains data on income inequality.  The primary measure is the Gini index – a measure of the extent to which the distribution of income among families/households within a community deviates from a perfectly equal distribution.  The index ranges from 0.0, when all families (households) have equal shares of income (implies perfect equality), to 1.0 when one family (household) has all the income and the rest have none (implies perfect inequality).  Index data is provided for California and its counties, regions, and large cities/towns. The data is from the U.S. Census Bureau, American Community Survey. The table is part of a series of indicators in the Healthy Communities Data and Indicators Project of the Office of Health Equity. Income is linked to acquiring resources for healthy living. Both household income and the distribution of income across a society independently contribute to the overall health status of a community. On average Western industrialized nations with large disparities in income distribution tend to have poorer health status than similarly advanced nations with a more equitable distribution of income. Approximately 119,200 (5%) of the 2.4 million U.S. deaths in 2000 are attributable to income inequality. The pathways by which income inequality act to increase adverse health outcomes are not known with certainty, but policies that provide for a strong safety net of health and social services have been identified as potential buffers. More information about the data table and a data dictionary can be found in the About/Attachments section.