Baselight

Hospital Annual Financial Data - Selected Data & Pivot Tables

State of California

@usgov.ca_gov_hospital_annual_financial_selected_pivot_tables_92074

Loading...
Loading...

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: 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.
Organization: State of California
Last updated: 2024-11-27T00:53:57.249432
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_92074.n_2012_2017_cy_hospital_annual_selected_machine_readab_f3c9bd18
  • 3.31 MB
  • 578350 rows
  • 35 columns
Loading...

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
);

Share link

Anyone who has the link will be able to view this.