Pre-2012 Hospital Quarterly Financial & Utilization Report - Sum Of Four Quarters by US Government | Finance and Economics

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

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

217.39 KB
528 rows
78 columns


CREATE TABLE n_1999_quarter_4_sum_of_four_quarters (
  "fac_no" BIGINT,
  "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
);

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

231.55 KB
543 rows
78 columns


CREATE TABLE n_1998_quarter_4_sum_of_four_quarters (
  "fac_no" VARCHAR,
  "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
);

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

235.94 KB
556 rows
78 columns


CREATE TABLE n_1997_quarter_4_sum_of_four_quarters (
  "fac_no" VARCHAR,
  "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
);

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

236.01 KB
564 rows
77 columns


CREATE TABLE n_1996_quarter_4_sum_of_four_quarters (
  "fac_no" VARCHAR,
  "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
);

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

244.47 KB
573 rows
85 columns


CREATE TABLE n_1995_quarter_4_sum_of_four_quarters (
  "fac_no" VARCHAR,
  "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
);