About this 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.
Organization: State of California
Last updated: 2025-10-23T12:53:36.222247
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

Tables

Languages Spoken By Patients And Hospital-Based Providers Data Dictionary

@usgov.ca_gov_languages_spoken_by_patients_and_hospital_based_8520afa2.languages_spoken_by_patients_and_hospital_based_provid_d0181758

4.28 kB
7 rows
4 columns

CREATE TABLE languages_spoken_by_patients_and_hospital_based_provid_d0181758 (
  "field_title" VARCHAR,
  "field_name" VARCHAR,
  "data_type" VARCHAR,
  "description" VARCHAR
);

Languages Spoken By Patients And Hospital-Based Providers Dataset

@usgov.ca_gov_languages_spoken_by_patients_and_hospital_based_8520afa2.languages_spoken_by_patients_and_hospital_based_providers

17.84 kB
1,703 rows
7 columns

CREATE TABLE languages_spoken_by_patients_and_hospital_based_providers (
  "county" VARCHAR,
  "language" VARCHAR,
  "medical_threshold_language" VARCHAR,
  "language_group" VARCHAR,
  "hosp_provider_percent" DOUBLE,
  "patient_encounters_percent" DOUBLE,
  "patient_enc_to_prov_lic_ratio" VARCHAR
);