About this Dataset

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:

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.
Selected Data - Fiscal Year: Hospital reports with report periods ending within a given fiscal year (July-June) are grouped together.
Organization: State of California
Last updated: 2025-07-23T20:40:53.317788
Tags: alos, assets, average-length-of-stay, beds, cost-center, department-of-health-care-access-and-information, discharges, discharges-by-payer-source, equity, expenses, financial-ratios, fte, hospital, income-statement, labor, liabilities, net-income, ogi, per-adjusted-patient-day, productive-hours, revenue, uncompensated-care-costs

Tables

2012 - 2017 CY Hospital Annual Selected File (Machine-Readable Format)

@usgov.ca_gov_hospital_annual_financial_selected_pivot_tables_d0fdd.n_2012_2017_cy_hospital_annual_selected_machine_readab_f3c9bd18

3.31 MB
578350 rows
35 columns


CREATE TABLE n_2012_2017_cy_hospital_annual_selected_machine_readab_f3c9bd18 (
  "fac_no" BIGINT,
  "fac_name" VARCHAR,
  "beg_date" VARCHAR,
  "end_date" VARCHAR,
  "day_per" BIGINT,
  "data_ind" VARCHAR,
  "audit_ind" VARCHAR,
  "county" VARCHAR,
  "hsa" BIGINT,
  "hfpa" BIGINT,
  "type_cntrl" VARCHAR,
  "type_care" VARCHAR,
  "type_hosp" VARCHAR,
  "teach_rurl" VARCHAR,
  "phone" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "zip_code" VARCHAR,
  "ceo" VARCHAR,
  "ceo_title" VARCHAR,
  "web_site" VARCHAR,
  "owner" VARCHAR,
  "rpt_prep" VARCHAR,
  "org_name" VARCHAR,
  "er_desig" DOUBLE,
  "mcar_pro" VARCHAR,
  "mcal_pro" VARCHAR,
  "reg_mcal" VARCHAR,
  "bed_lic" DOUBLE,
  "bed_avl" DOUBLE,
  "bed_stf" DOUBLE,
  "variable" VARCHAR,
  "amount" DOUBLE,
  "web_site_26adaa" VARCHAR,
  "org_name_079c89" VARCHAR
);

Data Dictionary - 2023 CY Hospital Annual Selected File (April 2025 Extract)

@usgov.ca_gov_hospital_annual_financial_selected_pivot_tables_d0fdd.n__dictionary_2023_cy_hospital_annual_selected_april_2_4d1e30dc

5.25 KB
246 rows
4 columns


CREATE TABLE n__dictionary_2023_cy_hospital_annual_selected_april_2_4d1e30dc (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);