Excel · dataset · 2024
Pre-2012 Hospital Annual Financial Data - Selected Data & Pivot Tables
Listed in California Open Data
On an annual basis (individual hospital fiscal year), individual hospitals and hospital systems report detailed facility-level data on services capacity, inpatient/outpatient utilization, patients, revenues and expenses by type and payer, balance sheet and income statement.
Description
Due to the large size of the complete dataset, a selected set of data representing a wide range of commonly used data items, has been created that can be easily managed and downloaded.
The selected data file includes general hospital information, utilization data by payer, revenue data by payer, expense data by natural expense category, financial ratios, and labor information. There are two groups of data contained in this dataset: 1) Selected Data - Calendar Year: To make it easier to compare hospitals by year, hospital reports with report periods ending within a given calendar year are grouped together.
Read the rest (1 more)
The Pivot Tables for a specific calendar year are also found here. 2) Selected Data - Fiscal Year: Hospital reports with report periods ending within a given fiscal year (July-June) are grouped together.
Links
Get the data
- data.chhs.ca.gov /dataset/hospital-annual-financial-data-selected-data-pivot-tab… ↗
Post-2011 Hospital Annual Financial Data - Selected Data & Pivot Tables
download · from data ca gov
- Individual Facility Report Search (SIERA) siera.oshpd.ca.gov/FinancialDisclosure.aspx ↗
download · from data ca gov
- Data Importing Instructions for Excel data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/34fcad07… ↗
download · from data ca gov
- 2000 and After CY Documentation data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/dce072e9… ↗
download · from data ca gov
- data.chhs.ca.gov /dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/f71cccc9… ↗
2011 CY Hospital Annual Selected File (October 2013 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/8bf0b2d5… ↗
2011 - 2012 FY Hospital Annual Selected File (October 2013 Extract)
download · from data ca gov
- 2011 Pivot Table Hospital Annual Selected File data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/19864eaa… ↗
download · from data ca gov
- data.chhs.ca.gov /dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/9e2449da… ↗
2010 CY Hospital Annual Selected File (September 2012 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/9e3bfac5… ↗
2010 - 2011 FY Hospital Annual Selected File (September 2012 Extract)
download · from data ca gov
- 2010 Pivot Table Hospital Annual Selected File data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/e913dd01… ↗
download · from data ca gov
- data.chhs.ca.gov /dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/23ae8b1b… ↗
2009 CY Hospital Annual Selected File (September 2011 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/9787d182… ↗
2009 - 2010 FY Hospital Annual Selected File (September 2011 Extract)
download · from data ca gov
- 2009 Pivot Table Hospital Annual Selected File data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/eae4947f… ↗
download · from data ca gov
- data.chhs.ca.gov /dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/07c7b5fb… ↗
2008 CY Hospital Annual Selected File (September 2010 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/32ad7f37… ↗
2008 - 2009 FY Hospital Annual Selected File (September 2010 Extract)
download · from data ca gov
- 2008 Pivot Table Hospital Annual Selected File data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/a8870d38… ↗
download · from data ca gov
- data.chhs.ca.gov /dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/3b026828… ↗
2007 CY Hospital Annual Selected File (September 2009 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/43d9e2f2… ↗
2007 - 2008 FY Hospital Annual Selected File (September 2009 Extract)
download · from data ca gov
- 2007 Pivot Table Hospital Annual Selected File data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/7201f4f2… ↗
download · from data ca gov
- data.chhs.ca.gov /dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/0bed9b78… ↗
2006 CY Hospital Annual Selected File (September 2008 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/8b081121… ↗
2006 - 2007 FY Hospital Annual Selected File (September 2008 Extract)
download · from data ca gov
- 2006 Pivot Table Hospital Annual Selected File data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/1c15b40e… ↗
download · from data ca gov
- data.chhs.ca.gov /dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/6a5f25c4… ↗
2005 CY Hospital Annual Selected File (September 2007 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/699be01c… ↗
2005 - 2006 FY Hospital Annual Selected File (September 2007 Extract)
download · from data ca gov
- 2005 Pivot Table Hospital Annual Selected File data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/932d32b7… ↗
download · from data ca gov
- data.chhs.ca.gov /dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/541bb079… ↗
2004 CY Hospital Annual Selected File (September 2006 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/b69f5f93… ↗
2004 - 2005 FY Hospital Annual Selected File (September 2006 Extract)
download · from data ca gov
- 2004 Pivot Table Hospital Annual Selected File data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/0b6b6531… ↗
download · from data ca gov
- data.chhs.ca.gov /dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/a4406aff… ↗
2003 CY Hospital Annual Selected File (September 2005 Extract)
download · from data ca gov
- 2003 Pivot Table Hospital Annual Selected File data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/7f53ab64… ↗
download · from data ca gov
- data.chhs.ca.gov /dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/1ae948ee… ↗
2002 CY Hospital Annual Selected File (October 2004 Extract)
download · from data ca gov
- data.chhs.ca.gov /dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/78f47de5… ↗
2002 - 2003 FY Hospital Annual Selected File (October 2004 Extract)
download · from data ca gov
- 2002 Pivot Table Hospital Annual Selected File data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/8e1f9291… ↗
download · from data ca gov
- data.chhs.ca.gov /dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/149da5cf… ↗
2001 CY Hospital Annual Selected File (September 2004 Extract)
download · from data ca gov
- 2001 - 2002 FY Hospital Annual Selected File data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/a565364e… ↗
download · from data ca gov
- 2001 Pivot Table Hospital Annual Selected File data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/8e685212… ↗
download · from data ca gov
- data.chhs.ca.gov /dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/58f06dd2… ↗
2000 CY Partial (7/1/99 - 6/29/00) Hospital Annual Selected File
download · from data ca gov
- data.chhs.ca.gov /dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/51e9a632… ↗
2000 CY Partial (6/30/00 - 12/31/00) Hospital Annual Selected File
download · from data ca gov
- 2000 Pivot Table Hospital Annual Selected File data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/31cf99a1… ↗
download · from data ca gov
- data.chhs.ca.gov /dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/5bf5d940… ↗
1995 - 1999 Documentation Hospital Annual Selected File
download · from data ca gov
- data.chhs.ca.gov /dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/db10e1dc… ↗
1995 - 1999 (Combined) CY Hospital Annual Selected File
download · from data ca gov
- data.chhs.ca.gov /dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/5e6ef1d6… ↗
1997 - 1999 Documentation Hospital Annual Selected File
download · from data ca gov
- 1999 CY Hospital Annual Selected File data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/6e68e6fc… ↗
download · from data ca gov
- 1999 Pivot Table Hospital Annual Selected File data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/5f37da14… ↗
download · from data ca gov
- 1998 CY Hospital Annual Selected File data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/d2fab61a… ↗
download · from data ca gov
- 1998 Pivot Table Hospital Annual Selected File data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/b59cc50c… ↗
download · from data ca gov
- 1997 CY Hospital Annual Selected File data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/30906ab3… ↗
download · from data ca gov
- 1997 Pivot Table Hospital Annual Selected File data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/6be71d83… ↗
download · from data ca gov
- 1996 CY Hospital Annual Selected File data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/b41b791e… ↗
download · from data ca gov
- 1996 Pivot Table Hospital Annual Selected File data.chhs.ca.gov/dataset/88024cf8-0882-4a4b-b1e2-46804249f033/resource/b83c9b50… ↗
download · from data ca gov
Where it is published
- California Open Data dataset page data.ca.gov/dataset/pre-2012-hospital-annual-financial-data-selected-data-… ↗
landing page · from data ca gov
Documentation and papers
- Publisher page hcai.ca.gov ↗
documentation · from data ca gov
Catalogue records · 1
- CKAN API data.ca.gov/api/3/action/package_show?id=2ce6dc53-c069-4c75-ad20-df05c4ca3… ↗
metadata API · from data ca gov
Topics
- Stated by source
- Health and Human Services
- From keywords
- Economics & Finance · Medicine & Health · Social Science
Provenance · 1 source records, 11 field assertions
| Source | Key | Last seen | Raw |
|---|---|---|---|
| California Open Data | 2ce6dc53-c069-4c75-ad20-df05c4ca3d31 | 11 d ago | JSON v1 |
| Field | Assertion | Extractor | Evidence |
|---|---|---|---|
| access_level | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| concepts[field].local:field:economics-finance | mapping · data ca gov | connector:data_ca_gov@1.0.0 | |
| concepts[field].local:field:medicine-health | mapping · data ca gov | connector:data_ca_gov@1.0.0 | |
| concepts[field].local:field:social-science | mapping · data ca gov | connector:data_ca_gov@1.0.0 | |
| concepts[topic].ckan_group:data_ca_gov:health-human-services | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| created_date | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| description | source · data ca gov | connector:data_ca_gov@1.0.0 | /notes |
| license_text | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| publication_date | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| title | source · data ca gov | connector:data_ca_gov@1.0.0 | /title |
| updated_date | source · data ca gov | connector:data_ca_gov@1.0.0 |