California Hospital Emergency Department Patient Summaries by Facility

Annual Excel pivot tables summarize patients treated in California Emergency Departments. Data includes number of visits, expected payer, discharge disposition, age groups, sex, preferred language, race groups, principal diagnosis groups, and principal external cause of injury groups. The State of California aggregates this data from the ED Treat-and-Release and Inpatient Databases.

Use Cases

• Analyze expected payer distributions across different principal diagnosis groups to understand healthcare financing.
• Model discharge disposition outcomes based on patient age groups, sex, and race groups.
• Investigate geographic patterns by summarizing principal external cause of injury groups by hospital county or rural status.
• Compare ED service levels by volume of visits segmented by preferred language and principal diagnosis groups.

Strengths

• Data is sourced from two official state databases: the ED Treat-and-Release Database and the Inpatient Database.
• Summaries can be filtered by multiple dimensions including hospital county, ED service level, teaching/rural status, and type of control.
• The dataset was last updated in November 2025, indicating recent maintenance.

Limitations

• The specific number of rows, columns, and total records is unknown, limiting assessment of scale.
• Data is provided as annual Excel pivot tables, which may require transformation for direct analytical use.
• The license is listed as 'other-license-specified', requiring users to review terms before use.

Provenance

Source

State of California, Department of Health Care Access and Information (HCAI).

Collection Method

Aggregated from the ED Treat-and-Release Database and the Inpatient Database.

Time Range

Annual data; specific years not stated.

Freshness

Annual updates; last updated November 2025.

Geography

State of California, USA; can be summarized statewide or by hospital county.