AndreaBozzo/ceres-open-data-index huggingface dataset:
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.

Tags: california-department-of-health-care-services, dhcs, dua-eligibiles, dual-eligibility, duals, fee-for-service, ffs-medicare, ma, ma-penetration, medicare, medicare-advantage, medicare-ffs, medicare-medicaid-enrollees, mme, part-c, traditional-medicare
Organization: State of California
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.

Tags: california-department-of-public-health, education, educational-attainment, hci, healthy-community-indicator, social-determinants-of-health
Organization: State of California
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.

Tags: cardiac-surgery, deaths, department-of-health-care-access-and-information, elective-pci, healthcare, hospital-quality, measures, pci, pci-mortality, performance-rating, post-pci-cabg-surgery, post-pci-stroke, primary-pci, ratings, risk-adjusted
Organization: State of California
Emergency Department Services Trends

This dataset contains emergency department services utilization data from the Annual Utilization Report of Hospitals dataset.  The summary data includes emergency department level, visits by acuity, available services, and ambulance diversion hours.

Tags: acuity, ambulance-diversion, department-of-health-care-access-and-information, ed, emergency-department, emsa, hcai, hospital, trauma
Organization: State of California
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.

Tags: department-of-health-care-access-and-information, emergency-discharges, hcai, healthcare-encounters, hospitals
Organization: State of California
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.

Tags: california-department-of-health-care-services, community-clinic, dhcs, federally-qualified-health-center, fqhc, free-clinic, indian-health-services, managed-care-encounter, rural-health-clinics, tribal-fqhc-providers, wrap-payment
Organization: State of California
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.

Tags: california-department-of-public-health, food-affordability, food-security, hci, health-community-indicator, healthy-community-indicator, social-determinants-of-health
Organization: State of California
Former Foster Youth Enrolled in Medi-Cal by Month

This dataset contains all former foster youth  enrolled in Medi-Cal. The Medi-Cal Former Foster Youth (FFY) program provides full scope Medi-Cal to individuals up to the age of 26 who were in foster care at age 18 or older.

Tags: 4m, aid-code, california-department-of-health-care-services, dhcs, ffy, former-foster-youth, medi-cal, medi-cal-eligibility
Organization: State of California
Four Quarter Financial Summary Hospital Utilization Charity Care and Bad Debt Summary

This dataset provides the fourth quarter summary roll-up of California hospitals’ financial and utilization data for Charity Care and Bad Debts.

Tags: bad-debt, charity-care, debts, department-of-health-care-access-and-information, hcai, ogi, payer-source, qfur, quarterly-financial-and-utilization-report
Organization: State of California
Fourth Quarter Summary Hospital Utilization Discharges by Payer Source

This dataset provides the fourth quarter summary roll-up of California hospitals’ financial and utilization data for discharges by payer source.

Tags: department-of-health-care-access-and-information, discharges-by-payer-source, hcai, ogi, payer, qfur, quarterly-financial-and-utilization-report
Organization: State of California
Fourth Quarter Summary Hospital Utilization Net Patient Revenue by Payer Source

This dataset provides the fourth quarter summary roll-up of California hospitals’ financial and utilization data for net patient revenue by payer source.

Tags: department-of-health-care-access-and-information, hcai, net-patient-revenue-by-payer-source, ogi, qfur, quarterly-financial-and-utilization-report
Organization: State of California
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.

Tags: adolescent, adult, california-department-of-public-health, child, consumption, fruit, fv, vegetable
Organization: State of California
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.

Tags: apcd, chronic-conditions, department-of-health-care-access-and-information, hcai, health-care-costs, hpd, medical-costs, out-of-pocket-costs, utilization
Organization: State of California
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.

Tags: all-payer-claims-database, apcd, chronic-conditions, department-of-health-care-access-and-information, ed-utilization, enrollment, hcai, health-conditions, healthcare-payments-data, hpd, inpatient-utilization, utilization
Organization: State of California
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).

Tags: 3-2-nursing-hour-per-patient-day, 3-2-nursing-hours-per-patient-day, administrative-penalty, adverse-events, california-department-of-public-health, chcq, citation, facility-non-compliance, failure-to-report-adverse-events, failure-to-report-medical-breach, health-care-deficiency, healthcare-deficiency, hospital-administrative-penalty, hsc-1276-5, hsc-1276-65, hsc-1279-1, hsc-1280-15, hsc-1280-3, hsc-1280-4, hsc-1424, hsc1276-65, licensure-violation, long-term-care-enforcement-action, long-term-care-enforcement-actions, medical-breach-violation, nhppd, non-long-term-care-enforcement-action, non-long-term-care-enforcement-actions, oshpd, patient-safety, privacy-breach-violation, sea, skilled-nursing-facility, snf
Organization: State of California
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.

Tags: all-payer-claims, apcd, department-of-health-care-access-and-information, enrollment, hcai, healthcare-payments-data, hpd, medical-claims, pharmacy-claims
Organization: State of California
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.

Tags: department-of-health-care-access-and-information, department-of-healthcare-access-and-information, hcai, healthcare-claims, healthcare-payments-data, healthcare-services, hpd
Organization: State of California
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.

Tags: dental-health, department-of-health-care-access-and-information, health-professional-shortage-areas, hpsa, mental-health, primary-care, shortage, underserved
Organization: State of California
Health Workforce Education Data

This dataset contains statistically weighted estimates of initial education levels, highest education levels, and initial education locations for 43 key health workforce professions actively licensed in California as of July 1st, 2023. These metrics can be compared by workforce category, license type, time since license issue date (in years), race & ethnicity group, assigned sex at birth, and CHIS region.

Tags: department-of-health-care-access-and-information, health-workforce, rdc, research-data-center
Organization: State of California
Health Workforce Languages Spoken Data

This dataset contains statistically weighted estimates of the languages spoken by 47 key health workforce professions actively licensed in California as of December 3rd, 2024. These metrics can be compared by US Census Bureau language group, Medi-Cal Threshold Language, workforce category, license type, region, county and age.

Tags: department-of-health-care-access-and-information, health-workforce, languages, rdc, research-data-center
Organization: State of California
Health Workforce Race & Ethnicity Data

This dataset contains statistically weighted estimates of the Race & Ethnicity of 47 key health workforce professions actively licensed in California as of December 3rd, 2024. These metrics can be compared by workforce category, license type, region, county and age.

Tags: department-of-health-care-access-and-information, ethnicity, health-workforce, race, rdc, research-data-center
Organization: State of California
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).

Tags: california-department-of-public-health, chew, children, cigarettes, cigars, e-cigarettes, e-cigs, ecigs, electronic-cigarettes, electronic-smoking-device, esd, high-school, hookah, pipe-tobacco, pod-mods, prevalence, smoking, snuff, snus, tcb, tcp, teens, tobacco, tobacco-use, vape, vape-pens, youth-smoking
Organization: State of California