About this Dataset

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.
Organization: State of California
Last updated: 2025-10-23T12:51:43.270442
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

Tables

Data Dictionary - 2010 Hospital Emergency Department - Characteristics By Facility (Pivot Profile)

@usgov.ca_gov_hospital_emergency_department_characteristics_b_fecfb6d6.n__dictionary_2010_hospital_emergency_department_chara_d7e13e50

3.38 kB
7 rows
4 columns

CREATE TABLE n__dictionary_2010_hospital_emergency_department_chara_d7e13e50 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2011 Hospital Emergency Department - Characteristics By Facility (Pivot Profile)

@usgov.ca_gov_hospital_emergency_department_characteristics_b_fecfb6d6.n__dictionary_2011_hospital_emergency_department_chara_02526b02

3.38 kB
7 rows
4 columns

CREATE TABLE n__dictionary_2011_hospital_emergency_department_chara_02526b02 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2012 Hospital Emergency Department - Characteristics By Facility (Pivot Profile)

@usgov.ca_gov_hospital_emergency_department_characteristics_b_fecfb6d6.n__dictionary_2012_hospital_emergency_department_chara_b4f3a2a7

3.38 kB
7 rows
4 columns

CREATE TABLE n__dictionary_2012_hospital_emergency_department_chara_b4f3a2a7 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2013 Hospital Emergency Department - Characteristics By Facility (Pivot Profile)

@usgov.ca_gov_hospital_emergency_department_characteristics_b_fecfb6d6.n__dictionary_2013_hospital_emergency_department_chara_dd3c7ba8

3.38 kB
7 rows
4 columns

CREATE TABLE n__dictionary_2013_hospital_emergency_department_chara_dd3c7ba8 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2018 Hospital Emergency Department - Characteristics By Facility (Pivot Profile)

@usgov.ca_gov_hospital_emergency_department_characteristics_b_fecfb6d6.n__dictionary_2018_hospital_emergency_department_chara_997c7895

3.36 kB
7 rows
4 columns

CREATE TABLE n__dictionary_2018_hospital_emergency_department_chara_997c7895 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2019 Hospital Emergency Department - Characteristics By Facility (Pivot Profile)

@usgov.ca_gov_hospital_emergency_department_characteristics_b_fecfb6d6.n__dictionary_2019_hospital_emergency_department_chara_74465b84

3.36 kB
7 rows
4 columns

CREATE TABLE n__dictionary_2019_hospital_emergency_department_chara_74465b84 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2021 Hospital Emergency Department - Characteristics By Facility (Pivot Profile)

@usgov.ca_gov_hospital_emergency_department_characteristics_b_fecfb6d6.n__dictionary_2021_hospital_emergency_department_chara_50dee028

3.36 kB
7 rows
4 columns

CREATE TABLE n__dictionary_2021_hospital_emergency_department_chara_50dee028 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2022 Hospital Emergency Department - Characteristics By Facility (Pivot Profile)

@usgov.ca_gov_hospital_emergency_department_characteristics_b_fecfb6d6.n__dictionary_2022_hospital_emergency_department_chara_78d90ed9

3.36 kB
7 rows
4 columns

CREATE TABLE n__dictionary_2022_hospital_emergency_department_chara_78d90ed9 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2023 Hospital Emergency Department - Characteristics By Facility (Pivot Profile)

@usgov.ca_gov_hospital_emergency_department_characteristics_b_fecfb6d6.n__dictionary_2023_hospital_emergency_department_chara_f9c55813

3.36 kB
7 rows
4 columns

CREATE TABLE n__dictionary_2023_hospital_emergency_department_chara_f9c55813 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);