About this Dataset

Hospital Quarterly Financial & Utilization Report - Sum Of Four Quarters

The summation contains updated data which reflect all corrections made by HCAI audit staff and hospital representatives. Each file consists of one rolling 4th quarter file for the respective calendar year of data. Comparison of the previously released data files with the revised data files may not have a material effect on statewide aggregations, but may have a significant effect on the data for individual hospitals.
Organization: State of California
Last updated: 2023-10-13T18:09:25.473152
Tags: department-of-health-care-access-and-information, expenses, hospital, ogi, quarterly-financial-and-utilization-report, revenues, utilization

Tables

2019 Quarter 3 - Sum Of Four Quarters

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_51a86f32.n_2019_quarter_3_sum_of_four_quarters

302.1 kB
444 rows
133 columns

CREATE TABLE n_2019_quarter_3_sum_of_four_quarters (
  "fac_no" BIGINT,
  "fac_name" VARCHAR,
  "year_qtr" BIGINT,
  "beg_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "op_status" VARCHAR,
  "county_name" VARCHAR,
  "hsa" VARCHAR,
  "hfpa" BIGINT,
  "type_cntrl" VARCHAR,
  "type_hosp" VARCHAR,
  "teach_rurl" VARCHAR,
  "phone" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "zip_code" VARCHAR,
  "ceo" VARCHAR,
  "lic_beds" BIGINT,
  "avl_beds" BIGINT,
  "stf_beds" BIGINT,
  "dis_mcar" BIGINT,
  "dis_mcar_mc" BIGINT,
  "dis_mcal" BIGINT,
  "dis_mcal_mc" BIGINT,
  "dis_cnty" BIGINT,
  "dis_cnty_mc" BIGINT,
  "dis_thrd" BIGINT,
  "dis_thrd_mc" BIGINT,
  "dis_indgnt" BIGINT,
  "dis_oth" BIGINT,
  "dis_tot" BIGINT,
  "dis_ltc" BIGINT,
  "day_mcar" BIGINT,
  "day_mcar_mc" BIGINT,
  "day_mcal" BIGINT,
  "day_mcal_mc" BIGINT,
  "day_cnty" BIGINT,
  "day_cnty_mc" BIGINT,
  "day_thrd" BIGINT,
  "day_thrd_mc" BIGINT,
  "day_indgnt" BIGINT,
  "day_oth" BIGINT,
  "day_tot" BIGINT,
  "day_ltc" BIGINT,
  "vis_mcar" BIGINT,
  "vis_mcar_mc" BIGINT,
  "vis_mcal" BIGINT,
  "vis_mcal_mc" BIGINT,
  "vis_cnty" BIGINT,
  "vis_cnty_mc" BIGINT,
  "vis_thrd" BIGINT,
  "vis_thrd_mc" BIGINT,
  "vis_indgnt" BIGINT,
  "vis_oth" BIGINT,
  "vis_tot" BIGINT,
  "grip_mcar" BIGINT,
  "grip_mcar_mc" BIGINT,
  "grip_mcal" BIGINT,
  "grip_mcal_mc" BIGINT,
  "grip_cnty" BIGINT,
  "grip_cnty_mc" BIGINT,
  "grip_thrd" BIGINT,
  "grip_thrd_mc" BIGINT,
  "grip_indgnt" BIGINT,
  "grip_oth" BIGINT,
  "grip_tot" BIGINT,
  "grop_mcar" BIGINT,
  "grop_mcar_mc" BIGINT,
  "grop_mcal" BIGINT,
  "grop_mcal_mc" BIGINT,
  "grop_cnty" BIGINT,
  "grop_cnty_mc" BIGINT,
  "grop_thrd" BIGINT,
  "grop_thrd_mc" BIGINT,
  "grop_indgnt" BIGINT,
  "grop_oth" BIGINT,
  "grop_tot" BIGINT,
  "bad_debt" BIGINT,
  "cadj_mcar" BIGINT,
  "cadj_mcar_mc" BIGINT,
  "cadj_mcal" BIGINT,
  "cadj_mcal_mc" BIGINT,
  "disp_855" BIGINT,
  "cadj_cnty" BIGINT,
  "cadj_cnty_mc" BIGINT,
  "cadj_thrd" BIGINT,
  "cadj_thrd_mc" BIGINT,
  "char_hb" BIGINT,
  "char_oth" BIGINT,
  "sub_indgnt" BIGINT,
  "tch_allow" BIGINT,
  "tch_supp" BIGINT,
  "ded_oth" BIGINT,
  "ded_tot" BIGINT,
  "cap_mcar" BIGINT,
  "cap_mcal" BIGINT,
  "cap_cnty" BIGINT,
  "cap_thrd" BIGINT,
  "cap_tot" BIGINT,
  "net_mcar" BIGINT
);