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.
Complete Metadata
| @type | dcat:Dataset |
|---|---|
| accessLevel | public |
| contactPoint |
{
"fn": "Department of Health Care Access and Information, Healthcare Analytics Branch",
"@type": "vcard:Contact",
"hasEmail": "mailto:dataandreports@hcai.ca.gov"
}
|
| description | 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. |
| distribution |
[
{
"@type": "dcat:Distribution",
"title": "2014 Hospital Emergency Department - Characteristics by Facility (Pivot Profile)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"description": "This data table contains the annual Excel pivot table that displays 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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/6d0c3448-6635-45ad-bd16-16eaf9e55ef7/resource/001c5eaa-e108-43bb-8d8c-cfcb35873ed2/download/2014-emergency-department-pivot.xlsm"
},
{
"@type": "dcat:Distribution",
"title": "2013 Hospital Emergency Department - Characteristics by Facility (Pivot Profile)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"description": "This data table contains the annual Excel pivot table that displays 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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/6d0c3448-6635-45ad-bd16-16eaf9e55ef7/resource/b6224ed5-1e6f-46e5-9ed9-06d9f8827693/download/2013-emergency-department-pivot.xlsm"
},
{
"@type": "dcat:Distribution",
"title": "2012 Hospital Emergency Department - Characteristics by Facility (Pivot Profile)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"description": "This data table contains the annual Excel pivot table that displays 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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/6d0c3448-6635-45ad-bd16-16eaf9e55ef7/resource/c7e89e77-8729-40a5-a616-d1cd41e7e689/download/2012-emergency-department-pivot.xlsm"
},
{
"@type": "dcat:Distribution",
"title": "2015 Hospital Emergency Department - Characteristics by Facility (Pivot Profile)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"description": "This data table contains the annual Excel pivot table that displays 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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/6d0c3448-6635-45ad-bd16-16eaf9e55ef7/resource/f421a0fd-4feb-49a6-bfa6-c56df178d4c5/download/2015-emergency-department-pivot.xlsm"
},
{
"@type": "dcat:Distribution",
"title": "2016 Hospital Emergency Department - Characteristics by Facility (Pivot Profile)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"description": "This data table contains the annual Excel pivot table that displays 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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/6d0c3448-6635-45ad-bd16-16eaf9e55ef7/resource/fc9e5961-211c-4be3-bb5a-1966a36e32b5/download/2016-ed-pivot-table_20181210.xlsx"
},
{
"@type": "dcat:Distribution",
"title": "2021 Hospital Emergency Department - Characteristics by Facility (Pivot Profile)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"description": "This data table contains the annual Excel pivot table that displays 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 and principal diagnosis 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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/6d0c3448-6635-45ad-bd16-16eaf9e55ef7/resource/2ed730f2-0dcd-4d4e-9503-422d704ed969/download/2021-ed-pivot-table.xlsm"
},
{
"@type": "dcat:Distribution",
"title": "2020 Hospital Emergency Department - Characteristics by Facility (Pivot Profile)",
"format": "XLSM",
"mediaType": "application/vnd.ms-excel.sheet.macroEnabled.12",
"description": "This data table contains the annual Excel pivot table that displays 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 and principal diagnosis 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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/6d0c3448-6635-45ad-bd16-16eaf9e55ef7/resource/34bdefc5-8eab-462a-a717-46fbe03e031b/download/2020-ed-pivot-table_20210706.xlsm"
},
{
"@type": "dcat:Distribution",
"title": "2024 Hospital Emergency Department - Characteristics by Facility (Pivot Profile)",
"format": ".xlsx",
"mediaType": "application/octet-stream",
"description": "This data table contains the annual Excel pivot table that displays 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 and principal diagnosis 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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/6d0c3448-6635-45ad-bd16-16eaf9e55ef7/resource/3ae901c1-c276-4376-8374-015f9a8fa973/download/2024-ed-pivot-table.xlsm"
},
{
"@type": "dcat:Distribution",
"title": "2019 Hospital Emergency Department - Characteristics by Facility (Pivot Profile)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"description": "This data table contains the annual Excel pivot table that displays 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 and principal diagnosis 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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/6d0c3448-6635-45ad-bd16-16eaf9e55ef7/resource/4a7e0519-7659-4790-a149-23499948dae3/download/2019-ed-pivot-table_20201013.xlsm"
},
{
"@type": "dcat:Distribution",
"title": "2022 Hospital Emergency Department - Characteristics by Facility (Pivot Profile)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"description": "This data table contains the annual Excel pivot table that displays 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 and principal diagnosis 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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/6d0c3448-6635-45ad-bd16-16eaf9e55ef7/resource/5ed6b01c-7dc4-42e4-af06-df27aac128c6/download/2022-ed-pivot-table.xlsm"
},
{
"@type": "dcat:Distribution",
"title": "2023 Hospital Emergency Department - Characteristics by Facility (Pivot Profile)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"description": "This data table contains the annual Excel pivot table that displays 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 and principal diagnosis 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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/6d0c3448-6635-45ad-bd16-16eaf9e55ef7/resource/906bad02-7ad7-46a7-82f3-b0a890b01e8e/download/2023-ed-pivot-table.xlsm"
},
{
"@type": "dcat:Distribution",
"title": "2007 Hospital Emergency Department - Characteristics by Facility (Pivot Profile)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"description": "This data table contains the annual Excel pivot table that displays 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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/6d0c3448-6635-45ad-bd16-16eaf9e55ef7/resource/156c5462-1af4-4078-8dc2-3680b37c699e/download/2007-ed-pivot-table_20200403.xlsx"
},
{
"@type": "dcat:Distribution",
"title": "2005 Hospital Emergency Department - Characteristics by Facility (Pivot Profile)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"description": "This data table contains the annual Excel pivot table that displays 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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/6d0c3448-6635-45ad-bd16-16eaf9e55ef7/resource/1ff0a1f2-3c3b-469a-a25f-50e61e3bf683/download/2005-ed-pivot-table_20200402.xlsx"
},
{
"@type": "dcat:Distribution",
"title": "2006 Hospital Emergency Department - Characteristics by Facility (Pivot Profile)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"description": "This data table contains the annual Excel pivot table that displays 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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/6d0c3448-6635-45ad-bd16-16eaf9e55ef7/resource/234adba0-85b7-491a-995b-b5d2dca567ba/download/2006-ed-pivot-table_20200402.xlsx"
},
{
"@type": "dcat:Distribution",
"title": "2011 Hospital Emergency Department - Characteristics by Facility (Pivot Profile)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"description": "This data table contains the annual Excel pivot table that displays 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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/6d0c3448-6635-45ad-bd16-16eaf9e55ef7/resource/33b0cfb3-cfd4-4dbb-a53e-77eed1a8fb15/download/2011-ed-pivot-table_20200406.xlsm"
},
{
"@type": "dcat:Distribution",
"title": "2017 Hospital Emergency Department - Characteristics by Facility (Pivot Profile)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"description": "This data table contains the annual Excel pivot table that displays 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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/6d0c3448-6635-45ad-bd16-16eaf9e55ef7/resource/997d64de-06db-4317-8952-6b19aa9d538a/download/2017-ed-pivot-table20180718.xlsm"
},
{
"@type": "dcat:Distribution",
"title": "2008 Hospital Emergency Department - Characteristics by Facility (Pivot Profile)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"description": "This data table contains the annual Excel pivot table that displays 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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/6d0c3448-6635-45ad-bd16-16eaf9e55ef7/resource/b292c93b-0c59-4918-96ed-d15cad2721b9/download/2008-ed-pivot-table_20200403.xlsx"
},
{
"@type": "dcat:Distribution",
"title": "2018 Hospital Emergency Department - Characteristics by Facility (Pivot Profile)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"description": "This data table contains the annual Excel pivot table that displays 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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/6d0c3448-6635-45ad-bd16-16eaf9e55ef7/resource/be91a8c0-914d-48cc-9ea8-c89d1c875721/download/2018-ed-pivot-table.xlsx"
},
{
"@type": "dcat:Distribution",
"title": "2009 Hospital Emergency Department - Characteristics by Facility (Pivot Profile)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"description": "This data table contains the annual Excel pivot table that displays 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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/6d0c3448-6635-45ad-bd16-16eaf9e55ef7/resource/c159bb5f-9e91-4cf5-a962-7cf877571e15/download/2009-ed-pivot-table_20200403.xlsx"
},
{
"@type": "dcat:Distribution",
"title": "2010 Hospital Emergency Department - Characteristics by Facility (Pivot Profile)",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"description": "This data table contains the annual Excel pivot table that displays 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.",
"downloadURL": "https://data.chhs.ca.gov/dataset/6d0c3448-6635-45ad-bd16-16eaf9e55ef7/resource/f48a3b53-e701-431a-8c0b-e6c1fd9b3030/download/2010-ed-pivot-table_20200406.xlsm"
},
{
"@type": "dcat:Distribution",
"title": "All resource data",
"format": "ZIP",
"mediaType": "application/zip",
"downloadURL": "https://data.chhs.ca.gov/dataset/6d0c3448-6635-45ad-bd16-16eaf9e55ef7/resource/c5cce1b6-2a82-4c1a-988d-01fe72d8e5ac/download/hospital-emergency-department-characteristics-by-facility-pivot-profile-59afzk6p.zip"
}
]
|
| identifier | 7ec24d03-c552-40d8-b1ca-bf6108687532 |
| issued | 2018-03-14T17:30:21.947466 |
| keyword |
[
"ED",
"ED Pivot",
"ED admit",
"ED visit",
"ER",
"Emergency Department",
"age group",
"department of health care access and information",
"discharge disposition",
"emergency room",
"expected payer",
"gender",
"hcai",
"hospital",
"preferred language",
"principal cause of injury",
"principal cause of morbidity",
"principal diagnosis group",
"race group",
"sex"
]
|
| license | http://www.opendefinition.org/licenses/cc-by |
| modified | 2025-11-07T01:34:38.357081 |
| publisher |
{
"name": "Department of Health Care Access and Information",
"@type": "org:Organization"
}
|
| theme |
[
"Health and Human Services"
]
|
| title | Hospital Emergency Department - Characteristics by Facility (Pivot Profile) |
