About this Dataset

Pre-2012 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: 2024-11-27T01:01:17.114475
Tags: department-of-health-care-access-and-information, expenses, hospital, ogi, quarterly-financial-and-utilization-report, revenues, utilization

Tables

1995 Quarter 4 - Sum Of Four Quarters

@usgov.ca_gov_pre_2012_hospital_quarterly_financial_utilizati_308222c5.n_1995_quarter_4_sum_of_four_quarters

250.34 kB
573 rows
85 columns

CREATE TABLE n_1995_quarter_4_sum_of_four_quarters (
  "fac_no" VARCHAR  -- FAC NO.,
  "year" DOUBLE,
  "qtr" VARCHAR,
  "fac_name" VARCHAR,
  "city" VARCHAR,
  "hsa" DOUBLE,
  "hfpa" DOUBLE,
  "peer" VARCHAR,
  "toc" DOUBLE,
  "bg_date" VARCHAR,
  "ed_date" VARCHAR,
  "lic_beds" DOUBLE,
  "avl_beds" DOUBLE,
  "stf_beds" DOUBLE,
  "dis_mcar" DOUBLE,
  "dis_mcal" DOUBLE,
  "dis_cnty" DOUBLE,
  "dis_thrd" DOUBLE,
  "dis91oth" DOUBLE,
  "dis_oth" DOUBLE,
  "dis_tot" DOUBLE,
  "dis_ltc" DOUBLE,
  "day_mcar" DOUBLE,
  "day_mcal" DOUBLE,
  "day_cnty" DOUBLE,
  "day_thrd" DOUBLE,
  "day91oth" DOUBLE,
  "day_oth" DOUBLE,
  "day_tot" DOUBLE,
  "day_ltc" DOUBLE,
  "vis_mcar" DOUBLE,
  "vis_mcal" DOUBLE,
  "vis_cnty" DOUBLE,
  "vis_thrd" DOUBLE,
  "vis91oth" DOUBLE,
  "vis_oth" DOUBLE,
  "vis_tot" DOUBLE,
  "tot_exp" DOUBLE,
  "inp_exp" DOUBLE,
  "out_exp" DOUBLE,
  "phy_comp" DOUBLE,
  "gri_mcar" DOUBLE,
  "gri_mcal" DOUBLE,
  "gri_cnty" DOUBLE,
  "gri_thrd" DOUBLE,
  "gri_oth" DOUBLE,
  "gri_tot" DOUBLE,
  "gro_mcar" DOUBLE,
  "gro_mcal" DOUBLE,
  "gro_cnty" DOUBLE,
  "gro_thrd" DOUBLE,
  "gro_oth" DOUBLE,
  "gro_tot" DOUBLE,
  "ded_mcar" DOUBLE,
  "ded_mcal" DOUBLE,
  "ded_disp" DOUBLE,
  "ded_cnty" DOUBLE,
  "ded_thrd" DOUBLE,
  "ded_bd" DOUBLE,
  "ded_hb" DOUBLE,
  "ded_91ch" DOUBLE,
  "ded_char" DOUBLE,
  "ded_gift" DOUBLE,
  "ded_rest" DOUBLE,
  "ded_tch" DOUBLE,
  "ded_clin" DOUBLE,
  "ded91oth" DOUBLE,
  "ded_oth" DOUBLE,
  "ded_tot" DOUBLE,
  "net_mcar" DOUBLE,
  "net_mcal" DOUBLE,
  "net_cnty" DOUBLE,
  "net_thrd" DOUBLE,
  "net91oth" DOUBLE,
  "net_oth" DOUBLE,
  "net_tot" DOUBLE,
  "othoprev" DOUBLE,
  "nonoprex" DOUBLE,
  "capital" DOUBLE,
  "assets" DOUBLE,
  "disp_tfr" DOUBLE,
  "puripdis" DOUBLE,
  "puripday" DOUBLE,
  "puripexp" DOUBLE,
  "puriprev" DOUBLE
);

1996 Quarter 4 - Sum Of Four Quarters

@usgov.ca_gov_pre_2012_hospital_quarterly_financial_utilizati_308222c5.n_1996_quarter_4_sum_of_four_quarters

241.67 kB
564 rows
77 columns

CREATE TABLE n_1996_quarter_4_sum_of_four_quarters (
  "fac_no" VARCHAR  -- FAC NO.,
  "year" DOUBLE,
  "qtr" DOUBLE,
  "fac_name" VARCHAR,
  "city" VARCHAR,
  "hsa" DOUBLE,
  "hfpa" DOUBLE,
  "toc" DOUBLE,
  "bg_date" DOUBLE,
  "ed_date" VARCHAR,
  "lic_beds" DOUBLE,
  "avl_beds" DOUBLE,
  "stf_beds" DOUBLE,
  "dis_mcar" DOUBLE,
  "dis_mcal" DOUBLE,
  "dis_cnty" DOUBLE,
  "dis_thrd" DOUBLE,
  "dis_oth" DOUBLE,
  "dis_tot" DOUBLE,
  "dis_ltc" DOUBLE,
  "day_mcar" DOUBLE,
  "day_mcal" DOUBLE,
  "day_cnty" DOUBLE,
  "day_thrd" DOUBLE,
  "day_oth" DOUBLE,
  "day_tot" DOUBLE,
  "day_ltc" DOUBLE,
  "vis_mcar" DOUBLE,
  "vis_mcal" DOUBLE,
  "vis_cnty" DOUBLE,
  "vis_thrd" DOUBLE,
  "vis_oth" DOUBLE,
  "vis_tot" DOUBLE,
  "tot_exp" DOUBLE,
  "inp_exp" DOUBLE,
  "out_exp" DOUBLE,
  "phy_comp" DOUBLE,
  "gri_mcar" DOUBLE,
  "gri_mcal" DOUBLE,
  "gri_cnty" DOUBLE,
  "gri_thrd" DOUBLE,
  "gri_oth" DOUBLE,
  "gri_tot" DOUBLE,
  "gro_mcar" DOUBLE,
  "gro_mcal" DOUBLE,
  "gro_cnty" DOUBLE,
  "gro_thrd" DOUBLE,
  "gro_oth" DOUBLE,
  "gro_tot" DOUBLE,
  "ded_mcar" DOUBLE,
  "ded_mcal" DOUBLE,
  "ded_disp" DOUBLE,
  "ded_cnty" DOUBLE,
  "ded_thrd" DOUBLE,
  "ded_bd" DOUBLE,
  "ded_hb" DOUBLE,
  "ded_char" DOUBLE,
  "ded_rest" DOUBLE,
  "ded_tch" DOUBLE,
  "ded_clin" DOUBLE,
  "ded_oth" DOUBLE,
  "ded_tot" DOUBLE,
  "net_mcar" DOUBLE,
  "net_mcal" DOUBLE,
  "net_cnty" DOUBLE,
  "net_thrd" DOUBLE,
  "net_oth" DOUBLE,
  "net_tot" DOUBLE,
  "othoprev" DOUBLE,
  "nonoprex" DOUBLE,
  "capital" DOUBLE,
  "assets" DOUBLE,
  "disp_tfr" DOUBLE,
  "puripdis" DOUBLE,
  "puripday" DOUBLE,
  "puripexp" DOUBLE,
  "puriprev" DOUBLE
);

1997 Quarter 4 - Sum Of Four Quarters

@usgov.ca_gov_pre_2012_hospital_quarterly_financial_utilizati_308222c5.n_1997_quarter_4_sum_of_four_quarters

241.6 kB
556 rows
78 columns

CREATE TABLE n_1997_quarter_4_sum_of_four_quarters (
  "fac_no" VARCHAR  -- FAC NO.,
  "year" DOUBLE,
  "qtr" DOUBLE,
  "fac_name" VARCHAR,
  "city" VARCHAR,
  "hsa" DOUBLE,
  "hfpa" DOUBLE,
  "toc" DOUBLE,
  "bg_date" DOUBLE,
  "ed_date" VARCHAR,
  "lic_beds" DOUBLE,
  "avl_beds" DOUBLE,
  "stf_beds" DOUBLE,
  "dis_mcar" DOUBLE,
  "dis_mcal" DOUBLE,
  "dis_cnty" DOUBLE,
  "dis_thrd" DOUBLE,
  "dis_oth" DOUBLE,
  "dis_tot" DOUBLE,
  "dis_ltc" DOUBLE,
  "day_mcar" DOUBLE,
  "day_mcal" DOUBLE,
  "day_cnty" DOUBLE,
  "day_thrd" DOUBLE,
  "day_oth" DOUBLE,
  "day_tot" DOUBLE,
  "day_ltc" DOUBLE,
  "vis_mcar" DOUBLE,
  "vis_mcal" DOUBLE,
  "vis_cnty" DOUBLE,
  "vis_thrd" DOUBLE,
  "vis_oth" DOUBLE,
  "vis_tot" DOUBLE,
  "tot_exp" DOUBLE,
  "inp_exp" DOUBLE,
  "out_exp" DOUBLE,
  "phy_comp" DOUBLE,
  "gri_mcar" DOUBLE,
  "gri_mcal" DOUBLE,
  "gri_cnty" DOUBLE,
  "gri_thrd" DOUBLE,
  "gri_oth" DOUBLE,
  "gri_tot" DOUBLE,
  "gro_mcar" DOUBLE,
  "gro_mcal" DOUBLE,
  "gro_cnty" DOUBLE,
  "gro_thrd" DOUBLE,
  "gro_oth" DOUBLE,
  "gro_tot" DOUBLE,
  "ded_mcar" DOUBLE,
  "ded_mcal" DOUBLE,
  "ded_disp" DOUBLE,
  "ded_cnty" DOUBLE,
  "ded_thrd" DOUBLE,
  "ded_bd" DOUBLE,
  "ded_hb" DOUBLE,
  "ded_char" DOUBLE,
  "ded_rest" DOUBLE,
  "ded_tch" DOUBLE,
  "ded_clin" DOUBLE,
  "ded_cap" DOUBLE,
  "ded_oth" DOUBLE,
  "ded_tot" DOUBLE,
  "net_mcar" DOUBLE,
  "net_mcal" DOUBLE,
  "net_cnty" DOUBLE,
  "net_thrd" DOUBLE,
  "net_oth" DOUBLE,
  "net_tot" DOUBLE,
  "othoprev" DOUBLE,
  "nonoprex" DOUBLE,
  "capital" DOUBLE,
  "assets" DOUBLE,
  "disp_tfr" DOUBLE,
  "puripdis" DOUBLE,
  "puripday" DOUBLE,
  "puripexp" DOUBLE,
  "puriprev" DOUBLE
);

1998 Quarter 4 - Sum Of Four Quarters

@usgov.ca_gov_pre_2012_hospital_quarterly_financial_utilizati_308222c5.n_1998_quarter_4_sum_of_four_quarters

237.11 kB
543 rows
78 columns

CREATE TABLE n_1998_quarter_4_sum_of_four_quarters (
  "fac_no" VARCHAR  -- FAC NO.,
  "year" DOUBLE,
  "qtr" DOUBLE,
  "fac_name" VARCHAR,
  "city" VARCHAR,
  "hsa" DOUBLE,
  "hfpa" DOUBLE,
  "toc" DOUBLE,
  "bg_date" DOUBLE,
  "ed_date" VARCHAR,
  "lic_beds" DOUBLE,
  "avl_beds" DOUBLE,
  "stf_beds" DOUBLE,
  "dis_mcar" DOUBLE,
  "dis_mcal" DOUBLE,
  "dis_cnty" DOUBLE,
  "dis_thrd" DOUBLE,
  "dis_oth" DOUBLE,
  "dis_tot" DOUBLE,
  "dis_ltc" DOUBLE,
  "day_mcar" DOUBLE,
  "day_mcal" DOUBLE,
  "day_cnty" DOUBLE,
  "day_thrd" DOUBLE,
  "day_oth" DOUBLE,
  "day_tot" DOUBLE,
  "day_ltc" DOUBLE,
  "vis_mcar" DOUBLE,
  "vis_mcal" DOUBLE,
  "vis_cnty" DOUBLE,
  "vis_thrd" DOUBLE,
  "vis_oth" DOUBLE,
  "vis_tot" DOUBLE,
  "tot_exp" DOUBLE,
  "inp_exp" DOUBLE,
  "out_exp" DOUBLE,
  "phy_comp" DOUBLE,
  "gri_mcar" DOUBLE,
  "gri_mcal" DOUBLE,
  "gri_cnty" DOUBLE,
  "gri_thrd" DOUBLE,
  "gri_oth" DOUBLE,
  "gri_tot" DOUBLE,
  "gro_mcar" DOUBLE,
  "gro_mcal" DOUBLE,
  "gro_cnty" DOUBLE,
  "gro_thrd" DOUBLE,
  "gro_oth" DOUBLE,
  "gro_tot" DOUBLE,
  "ded_mcar" DOUBLE,
  "ded_mcal" DOUBLE,
  "ded_disp" DOUBLE,
  "ded_cnty" DOUBLE,
  "ded_thrd" DOUBLE,
  "ded_bd" DOUBLE,
  "ded_hb" DOUBLE,
  "ded_char" DOUBLE,
  "ded_rest" DOUBLE,
  "ded_tch" DOUBLE,
  "ded_clin" DOUBLE,
  "ded_cap" DOUBLE,
  "ded_oth" DOUBLE,
  "ded_tot" DOUBLE,
  "net_mcar" DOUBLE,
  "net_mcal" DOUBLE,
  "net_cnty" DOUBLE,
  "net_thrd" DOUBLE,
  "net_oth" DOUBLE,
  "net_tot" DOUBLE,
  "othoprev" DOUBLE,
  "nonoprex" DOUBLE,
  "capital" DOUBLE,
  "assets" DOUBLE,
  "disp_tfr" DOUBLE,
  "puripdis" DOUBLE,
  "puripday" DOUBLE,
  "puripexp" DOUBLE,
  "puriprev" DOUBLE
);

1999 Quarter 4 - Sum Of Four Quarters

@usgov.ca_gov_pre_2012_hospital_quarterly_financial_utilizati_308222c5.n_1999_quarter_4_sum_of_four_quarters

222.61 kB
528 rows
78 columns

CREATE TABLE n_1999_quarter_4_sum_of_four_quarters (
  "fac_no" BIGINT  -- FAC NO.,
  "year" BIGINT,
  "qtr" BIGINT,
  "fac_name" VARCHAR,
  "city" VARCHAR,
  "hsa" BIGINT,
  "hfpa" BIGINT,
  "toc" VARCHAR,
  "bg_date" BIGINT,
  "ed_date" VARCHAR,
  "lic_beds" BIGINT,
  "avl_beds" BIGINT,
  "stf_beds" BIGINT,
  "dis_mcar" BIGINT,
  "dis_mcal" BIGINT,
  "dis_cnty" BIGINT,
  "dis_thrd" BIGINT,
  "dis_oth" BIGINT,
  "dis_tot" BIGINT,
  "dis_ltc" BIGINT,
  "day_mcar" BIGINT,
  "day_mcal" BIGINT,
  "day_cnty" BIGINT,
  "day_thrd" BIGINT,
  "day_oth" BIGINT,
  "day_tot" BIGINT,
  "day_ltc" BIGINT,
  "vis_mcar" BIGINT,
  "vis_mcal" BIGINT,
  "vis_cnty" BIGINT,
  "vis_thrd" BIGINT,
  "vis_oth" BIGINT,
  "vis_tot" BIGINT,
  "tot_exp" BIGINT,
  "inp_exp" BIGINT,
  "out_exp" BIGINT,
  "phy_comp" BIGINT,
  "gri_mcar" BIGINT,
  "gri_mcal" BIGINT,
  "gri_cnty" BIGINT,
  "gri_thrd" BIGINT,
  "gri_oth" BIGINT,
  "gri_tot" BIGINT,
  "gro_mcar" BIGINT,
  "gro_mcal" BIGINT,
  "gro_cnty" BIGINT,
  "gro_thrd" BIGINT,
  "gro_oth" BIGINT,
  "gro_tot" BIGINT,
  "ded_mcar" BIGINT,
  "ded_mcal" BIGINT,
  "ded_disp" BIGINT,
  "ded_cnty" BIGINT,
  "ded_thrd" BIGINT,
  "ded_bd" BIGINT,
  "ded_hb" BIGINT,
  "ded_char" BIGINT,
  "ded_rest" BIGINT,
  "ded_tch" BIGINT,
  "ded_clin" BIGINT,
  "ded_cap" BIGINT,
  "ded_oth" BIGINT,
  "ded_tot" BIGINT,
  "net_mcar" BIGINT,
  "net_mcal" BIGINT,
  "net_cnty" BIGINT,
  "net_thrd" BIGINT,
  "net_oth" BIGINT,
  "net_tot" BIGINT,
  "othoprev" BIGINT,
  "nonoprex" BIGINT,
  "capital" BIGINT,
  "assets" BIGINT,
  "disp_tfr" BIGINT,
  "puripdis" BIGINT,
  "puripday" BIGINT,
  "puripexp" BIGINT,
  "puriprev" BIGINT
);