About this Dataset

Hospital Emergency Department - Characteristics By Patient County Of Residence

This dataset contains annual hospital emergency department summary data based upon the Patient’s County of Residence. The summary data includes discharge disposition, expected payer, sex and race group.
Organization: State of California
Last updated: 2025-10-23T12:51:55.548073
Tags: department-of-health-care-access-and-information, discharge-disposition, ed, emergency-department, expected-payer, gender, hcai, hospital, patient-county, race-group, sex

Tables

Hospital Emergency Department Characteristics – Disposition By Patient County Of Residence

@usgov.ca_gov_hospital_emergency_department_characteristics_b_7e81004d.hospital_emergency_department_characteristics_disposit_bef5a47c

51.3 kB
14,958 rows
6 columns

CREATE TABLE hospital_emergency_department_characteristics_disposit_bef5a47c (
  "patient_county" VARCHAR,
  "service_year" BIGINT,
  "disposition" VARCHAR,
  "encounters" DOUBLE,
  "annotationcode" DOUBLE,
  "annotationdesc" VARCHAR
);

Hospital Emergency Department Characteristics – Expected Payer By Patient County Of Residence

@usgov.ca_gov_hospital_emergency_department_characteristics_b_7e81004d.hospital_emergency_department_characteristics_expected_d9c4f642

74.56 kB
18,064 rows
6 columns

CREATE TABLE hospital_emergency_department_characteristics_expected_d9c4f642 (
  "patient_county" VARCHAR,
  "service_year" BIGINT,
  "expected_payer" VARCHAR,
  "encounters" DOUBLE,
  "annotationcode" DOUBLE,
  "annotationdesc" VARCHAR
);

Hospital Emergency Department Characteristics – Race Group By Patient County Of Residence

@usgov.ca_gov_hospital_emergency_department_characteristics_b_7e81004d.hospital_emergency_department_characteristics_race_gro_0148e58a

44.83 kB
7,888 rows
6 columns

CREATE TABLE hospital_emergency_department_characteristics_race_gro_0148e58a (
  "patient_county" VARCHAR,
  "service_year" BIGINT,
  "race_group" VARCHAR,
  "encounters" DOUBLE,
  "annotationcode" DOUBLE,
  "annotationdesc" VARCHAR
);

Hospital Emergency Department Characteristics – Sex By Patient County Of Residence

@usgov.ca_gov_hospital_emergency_department_characteristics_b_7e81004d.hospital_emergency_department_characteristics_sex_by_p_1e80d9f9

20.55 kB
2,686 rows
6 columns

CREATE TABLE hospital_emergency_department_characteristics_sex_by_p_1e80d9f9 (
  "patient_county" VARCHAR,
  "service_year" BIGINT,
  "gender" VARCHAR,
  "encounters" BIGINT,
  "annotationcode" VARCHAR,
  "annotationdesc" VARCHAR
);