AndreaBozzo/ceres-open-data-index huggingface dataset:
Languages Spoken by Patients and Hospital-Based Providers in California

The dataset contains percentages of languages spoken for patient encounters in an inpatient setting, the emergency room, and hospital-based ambulatory surgery centers as well as languages spoken by the hospital-based workforce. There are also patient encounter-to-provider license ratios for each language by county. The patient encounter to provider license ratio can serve as an indicator for patient demand or need for services from a provider in a specific language. Smaller ratios indicate fewer patient encounters per provider license and less demand. Larger ratios of patient encounters per provider license indicate greater need for services in that language. This analysis features 45 languages that overlap between the patient-level data and health workforce data. These languages are grouped into the following language groups: African Languages, Asian and Pacific Islander Languages, European Languages, Middle Eastern Languages, Navajo Language, Spanish Language, and Sign Languages.

Tags: ambulatory-surgery, california-department-of-health-care-access-and-information, department-of-health-care-access-and-information, emergency-department, hcai, health-workforce, inpatient-hospitalizations, language, preferred-language-spoken, rdc, research-data-center
Organization: State of California
Lanterman-Petris-Short Act Data

Lanterman-Petris-Short (LPS) dataset contains the number of persons detained or admitted and treated involuntarily pursuant to several sections of the LPS Act in each county and stratified by data elements. This dataset also contains data elements for Senate Bill (SB) 929 and Senate Bill (SB) 43.

Tags: behavioral-health, california-department-of-health-care-services, dhcs, lanterman-petris-short-act, lps
Organization: State of California
Licensed Bed Classification and Designations Trends

This dataset contains information by licensed facility including number of patient days, hospital discharges, licensed bed days, and intra-hospital transfer from critical care by the six licensed bed classifications, including General Acute Care, Chemical Dependency Recovery, Acute Psychiatric, Skilled Nursing, Intermediate Care, and Intermediate Care/Developmentally Disabled.  The General Acute Care classification is further defined by bed designation categories that include Medical/Surgical (includes GYN/DOU), Perinatal (includes LDRP, excludes nursery), Pediatric Acute, Intensive Care, Coronary Care, Acute Respiratory Care, Burn Center, Intensive Care Newborn Nursery, and Rehabilitation Center bed designations.  2015 data are preliminary, are as reported and have not been audited.  See the Healthcare Facility Bed Types and Counts dataset for complimentary information at: https://chhs.data.ca.gov/Facilities-and-Services/Healthcare-Facility-Bed-Types-And-Counts/f9pb-6m2b

Tags: beds, burn, ccu, days, department-of-health-care-access-and-information, discharges, hospital, ic, icdd, icu, licensed-beds, nicu, perinatal, psychiatric, rehab
Organization: State of California
Licensed and Certified Healthcare Facility Crosswalk

The California Department of Public Health (CDPH), Center for Health Care Quality, Licensing and Certification (L&C) Program licenses and certifies 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.

This dataset provides a California healthcare facilities interdepartmental crosswalk using the Department of Health Care Access and Information (HCAI) assigned licensed facility identification numbers linked with matched California Department of Public Health (CDPH), Licensing and Certification facility lists based on license number housed in the Electronic Licensing Management System (ELMS) and/or the CMS Certification Number (CCN) from the Federal Automated Survey Process Environment (ASPEN) databases. This is not a comprehensive matched list, facility identification numbers that did not match are also included from both the HCAI and CDPH lists. Facility Status or Facility Level designations may explain some HCAI non-matches, for additional information contact HCAI directly. Please contact CDPH directly for more information regarding un-matched facility identifiers that do not have corresponding OSHPD identifiers.

Tags: branch, california-health-and-human-services-agency, clinic, consolidated, cross-walk, crosswalk, distinct-part, facility, facility-list, health-facilities, healthcare-facilities, hha, home-health, hospice, hospitals, licensed-facility, nursing-homes, parent, skilled-nursing, skilled-nursing-homes, snf, suspense, xwalk
Organization: State of California
Living Wage

This table contains data on the living wage and the percent of families with incomes below the living wage for California, its counties, regions and cities/towns.  Living wage is the wage needed to cover basic family expenses (basic needs budget) plus all relevant taxes; it does not include publicly provided income or housing assistance.  The percent of families below the living wage was calculated using data from the [Living Wage Calculator](http://livingwage.mit.edu/) and 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. The living wage is the wage or annual income that covers the cost of the bare necessities of life for a worker and his/her family. These necessities include housing, transportation, food, childcare, health care, and payment of taxes.  Low income populations and non-white race/ethnic have disproportionately lower wages, poorer housing, and higher levels of food insecurity.  More information about the data table and a data dictionary can be found in the About/Attachments section.

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

Tags: age-group, department-of-health-care-access-and-information, discharge-disposition, ed, ed-admit, ed-pivot, ed-visit, emergency-department, emergency-room, er, expected-payer, gender, hcai, hospital, preferred-language, principal-cause-of-injury, principal-cause-of-morbidity, principal-diagnosis-group, race-group, sex
Organization: State of California
Major Diagnostic Categories Summary

This dataset provides the adjusted length of stay, type of care, discharges with valid charges, charges by hospital, licensure of bed, and Major Diagnostic Category (MDC).

Tags: adjusted-length-of-stay, charges, department-of-health-care-access-and-information, discharges, hcai, inpatient-discharge-data, major-diagnostic-category, mdc, valid-charges
Organization: State of California
Managed Care Performance Monitoring Dashboard Report

This report contains data regarding enrollment demographics, utilization of services, grievances, state fair hearings, provider ratios, encounter completeness, Healthcare Effectiveness Data and Information Set (HEDIS) rates, and  medical audit findings.

Tags: california-department-of-health-care-services, demographics, dhcs, encounter, enrollment, grievances, hedis, provider-ratio, state-fair-hearing, utilization
Organization: State of California
Medi-Cal Birth Statistics, by Select Characteristics and California Resident Hospital Births

California Birth Report totals by Birth Characteristics to inform the public, stakeholders, and researchers.

The DHCS Medi-Cal Birth Statistics tables present the descriptive statistics for California resident births that occurred in a hospital setting, including data on maternal characteristics, delivery methods, and select birth outcomes such as low birthweight and preterm delivery. Tables also include key comorbidities and health behaviors known to influence birth outcomes, such as hypertension, diabetes, substance use, pre-pregnancy weight, and smoking during pregnancy. 

DHCS additionally presents birth statistics for women participating in the Medi-Cal Fee-For-Service (FFS) and managed care delivery systems, as well as births financed by private insurance, births financed by other public funding sources, and births among uninsured mothers. Medi-Cal data reflect mothers that were deemed as Medi-Cal certified eligible.

__Note:__ Data for maternal comorbidities including hypertension, diabetes, and substance use have been provisionally omitted among calendar years 2020-2022 for the time being.

Tags: aid-category, birth-characteristics, births, birthweight-range, birthweight-status, calendar-year, california-department-of-health-care-services, certified-eligible, delivery-system, dhcs, ethnicity, geographic-region, medi-cal, method-of-delivery, payer-type, race, resident-births, singleton-births
Organization: State of California
Medi-Cal Managed Care Capitation Rates – County Organized Health Systems (COHS) Model

__This page is considered archival. please refer to the new data landing page at [Medi-Cal Managed Care Capitation Rates by Managed Care Plan Models](https://data.chhs.ca.gov/dataset/medi-cal-managed-care-capitation-rates-by-managed-care-plan-models-consolidated).__

This dataset displays reimbursement rates paid to Medi-Cal Managed Care health plans in the COHS model, by State Fiscal Year. The COHS serve beneficiaries in 22 counties. In the COHS model counties, the Department of Health Care Services (DHCS) contracts with a health plan created by the county Board of Supervisors.  In a COHS county, all Medi-Cal members are enrolled in the same managed care health plan.

Tags: california-department-of-health-care-services, cohs, county-organized-health-systems, county-organized-health-systems-model, county-organized-health-systems-rates, dhcs, managed-care-rates, medi-cal-managed-care, medi-cal-managed-care-capitation-rates
Organization: State of California
Medi-Cal Managed Care Capitation Rates - Geographic Managed Care (GMC)

__This page is considered archival. please refer to the new data landing page at [Medi-Cal Managed Care Capitation Rates by Managed Care Plan Models](https://data.chhs.ca.gov/dataset/medi-cal-managed-care-capitation-rates-by-managed-care-plan-models-consolidated).__

Medi-Cal Managed Care Capitation Rates – Geographic Managed Care (GMC) by State Fiscal Year. Medi- Cal managed care health plans in the Sacramento and San Diego counties.

Tags: california-department-of-health-care-services, dhcs, geographic-managed-care, gmc, gmc-rates, managed-care-rates, medi-cal-managed-care, medi-cal-managed-care-capitation-rates
Organization: State of California
Medi-Cal Managed Care Capitation Rates – Regional Model/Rural Expansion

__This page is considered archival. please refer to the new data landing page at [Medi-Cal Managed Care Capitation Rates by Managed Care Plan Models](https://data.chhs.ca.gov/dataset/medi-cal-managed-care-capitation-rates-by-managed-care-plan-models-consolidated).__

This dataset displays reimbursement rates paid to Medi-Cal Managed Care health plans in the Regional model, by State Fiscal Year. The Regional Model serves beneficiaries in 28 rural counties: Alpine, Amador, Butte, Calaveras, Colusa, Del Norte, El Dorado, Glenn, Humboldt, Inyo, Imperial, Lake, Lassen, Mariposa, Mendocino, Modoc, Mono, Nevada, Placer, Plumas, San Benito, Sierra, Siskiyou, Sutter, Tehama, Trinity, Tuolumne, and Yuba. The Department of Health Care Services (DHCS) contracts with two Commercial plans to provide services in each county. San Benito is the only exception where beneficiaries can choose either the managed care plan or (fee-for-service) Medi-Cal.

Tags: california-department-of-health-care-services, dhcs, managed-care-rates, medi-cal-managed-care, medi-cal-managed-care-capitation-rates, regional-model, regional-model-rates, rm, rural-expansion, rural-expansion-rate
Organization: State of California
Healthcare Workforce Geography Crosswalk

This dataset identifies which census tracts comprise the various geographies used to study the healthcare workforce.  Medical Service Study Areas (MSSA) are sub-county geographies used to study medical service in California.  Registered Nurse (RN) Areas, which can cross county lines, are used to study the RN workforce.  These custom geographies are approved by the California Healthcare Workforce Policy Commission.

Tags: area, department-of-health-care-access-and-information, geography, hpsa, map, medical, mssa, rnsa, service, shape, shortage, study, underserved
Organization: State of California
Medi-Cal Managed Care Capitation Rates – Two-Plan Model

__This page is considered archival. please refer to the new data landing page at [Medi-Cal Managed Care Capitation Rates by Managed Care Plan Models](https://data.chhs.ca.gov/dataset/medi-cal-managed-care-capitation-rates-by-managed-care-plan-models-consolidated).__

This dataset displays reimbursement rates paid to Medi-Cal Managed Care health plans in Two-Plan model counties for State Fiscal Years 2015-16 to 2019-20 . In Two-Plan model counties, the Department of Health Care Services (DHCS) contracts with a local initiative (county organized) and a commercial plan.

Tags: california-department-of-health-care-services, dhcs, managed-care-rates, medi-cal-managed-care, medi-cal-managed-care-capitation-rates, two-plan, two-plan-model, two-plan-rates
Organization: State of California
Mental and Behavioral Health Diagnoses in Emergency Department and Inpatient Discharges by Healthy Places Index Ranking

This dataset provides counts and percentages of diagnoses broken down by each patient’s Healthy Places Index percentile ranking (based on ZIP code of residence). Healthcare encounters are categorized into four diagnosis groups: mental health disorders, substance use disorders, co-occurring disorders, and all other diagnoses. To view and interact with a fully functioning version of the HPI map and data used in these HCAI analyses of behavioral health, please click the link to visit https://map.healthyplacesindex.org/.

Tags: department-of-health-care-access-and-information, emergency-discharges, healthcare-encounters, healthy-places-index, hospitals, inpatient-discharges, mental-health-disorder, substance-use-disorders
Organization: State of California
Modeling Data for California's Nursing Workforce

This dataset contains the output of HCAI’s Supply and Demand Model for California’s Nursing Workforce. It includes the estimated supply and demand for providers in Full-Time Equivalent (FTE) for each role or role group included in the model for the years 2022-2023. These metrics can be compared by role, region, county, and year. For in-depth details on our modeling methodology, see our online comprehensive methodology documentation  at https://hcai.ca.gov/wp-content/uploads/2025/05/Public-Modeling-Methodology-v.1.1_5-2025.pdf. 

Additional documentation is also provided on HCAI’s use of Lightcast data within the Supply & Demand model.

Tags: demand, department-of-health-care-access-and-information, health-workforce, modeling, nursing, rdc, research-data-center, supply
Organization: State of California
Modified Retail Food Environment Index

This table contains data on the modified retail food environment index for California, its regions, counties, cities, towns, and census tracts.   An adequate, nutritious diet is a necessity at all stages of life. Pregnant women and their developing babies, children, adolescents, adults, and older adults depend on adequate nutrition for optimum development and maintenance of health and functioning. 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. Peoples’ food choices and their likelihood of being overweight or obese are also influenced by their food environment: the foods available in their neighborhoods including stores, restaurants, schools, and worksites.  

The modified retail food environment index 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 modified retail food environment 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, fast-food, food, food-desert, hci, healthy-community-indicator, healthy-food, modified-retail-food-environment-index, social-determinants-of-health
Organization: State of California
Mortality Following Hip Fracture Repair in California Hospitals

This dataset contains risk-adjusted mortality rates, expected mortality rates, observed mortality rates, quality ratings, and the number of deaths and cases for hip fracture repair performed in California hospitals. This dataset does not include the procedure performed in outpatient settings.

Tags: 30-day-deaths, 30-day-mortality, department-of-health-care-access-and-information, healthcare-quality, hip-fracture-repair, hospital-mortality, hospital-quality
Organization: State of California
Notice of Inaction (NOI) Report

This dataset includes monthly counts of Notice of Inaction (NOI) sent to Medi-Cal applicants whose pending application is reaching 45 days due to an improper delay by the county that is processing the application. A NOI is not issued when the application delay is due to the applicant failing to provide requested information to the county, which is considered a proper delay. The monthly counts include the total Medi-Cal and Covered California applications received and the total number/percentage of Medi-Cal applications pending 45 days, including both proper and improper application processing delays.  Data Sources: California Healthcare Eligibility, Enrollment and Retention System (CalHEERS) and Statewide Automated Welfare Systems (SAWS).

Tags: applicant, application-processing, applications-pending-45-days, california-department-of-health-care-services, county-applications, county-inaction, covered-ca, covered-california, dhcs, improper-delay, inaction, medi-cal, medi-cal-inaction, noi, notice-of-inaction, total-medi-cal-applications, total-noi-sent
Organization: State of California
Number of Cancer Surgeries (Volume) Performed in California Hospitals

The dataset contains the number (volume) for 11 types of cancer (bladder, breast, brain, colon, esophagus, liver, lung, pancreas, prostate, rectum, and stomach) surgeries performed in California hospitals.  Data are reported for January – September 2015 due to coding changes from ICD-9-CM to ICD-10-CM/PCS for procedures, which began 10/1/2015. Comparisons across years should be made with caution since previous years’ results are based on 12 months of data, while this analysis is based on 9 months of data. The 2015 data may differ from previous years due to the coding change.  For all types of cancer surgeries, except breast cancer, the dataset contains surgeries performed in the inpatient hospital setting.  For breast cancer surgeries, this dataset includes procedures performed in inpatient and outpatient settings.

Tags: bladder, brain, breast, cancer, cancer-treatment, colon, department-of-health-care-access-and-information, esophagus, healthcare-outcomes, liver, lung, pancreas, prostate, rectum, stomach, surgery, volume
Organization: State of California
Number of Weight Loss Surgeries Performed in California Hospitals

The dataset contains the number for five types of weight loss (bariatric) surgeries (Open Roux-en-Y gastric bypass, laparoscopic Roux-en-Y gastric bypass , laparoscopic adjustable gastric banding, vertical sleeve gastrectomy , and biliopancreatic diversion ) performed in California hospitals.  The 2015 Data are reported for January-September due to coding changes from ICD-9-CM to ICD-10-CM/PCS, which began October 1, 2015. Caution should be taken before making comparisons  across years  since previous years' results are based on 12 months of data, while results for year 2015 are based on 9 months of data. This dataset does not include surgeries performed in outpatient settings.

Tags: bariatric-surgery, bariatric-surgery-procedures, biliopancreatic-diversion, bpd, department-of-health-care-access-and-information, gastric-bypass, lap-band, lap-rygb, laparoscopic-adjustable-gastric-banding, metabolic-surgery, morbid-obesity, obesity, open-rygb, roux-en-y-gastric-bypass, rygb, stomach-stapling, vertical-sleeve-gastrectomy, vsg, weight-loss, weight-loss-surgery, weight-reduction
Organization: State of California