Pre-2012 Hospital Annual Financial Data - Selected Data & Pivot Tables

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.

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. 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.

Data and Resources

Field Value
accessLevel public
catalog_@context https://project-open-data.cio.gov/v1.1/schema/catalog.jsonld
catalog_conformsTo https://project-open-data.cio.gov/v1.1/schema
catalog_describedBy https://project-open-data.cio.gov/v1.1/schema/catalog.json
identifier 3ae40bb9-fa69-4d38-bc8d-10569fee9f17
issued 2018-08-16T17:29:37.259310
modified 2022-04-22T15:23:28.502715
publisher Department of Health Care Access and Information
resource-type Dataset
source_datajson_identifier true
source_hash 5bee62055ef116d3abf8a27586eb067fee7ab2e8
source_schema_version 1.1
theme {"Health and Human Services"}
Groups
  • AmeriGEOSS
  • National Provider
  • North America
Tags
  • alos
  • amerigeo
  • amerigeoss
  • assets
  • average-length-of-stay
  • beds
  • ckan
  • cost-center
  • department-of-health-care-access-and-information
  • discharges
  • discharges-by-payer
  • equity
  • expenses
  • financial-ratios
  • fte
  • geo
  • geoss
  • hospital
  • income-statement
  • labor
  • liabilities
  • national
  • net-income
  • north-america
  • ogi
  • per-adjusted-patient-day
  • productive-hours
  • revenue
  • uncompensated-care
  • united-states
isopen False
license_id notspecified
license_title License not specified
maintainer Accounting and Reporting Systems Section
maintainer_email dataandreports@hcai.ca.gov
metadata_created 2025-11-22T12:23:03.408300
metadata_modified 2025-11-22T12:23:03.408305
notes 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. 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. 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.
num_resources 53
num_tags 30
title Pre-2012 Hospital Annual Financial Data - Selected Data & Pivot Tables