Hospital Quarterly Financial & Utilization Report - Complete Data Set by US Government | Finance and Economics

About this Dataset

Hospital Quarterly Financial & Utilization Report - Complete Data Set

On a quarterly basis (every three months), individual hospitals and hospital systems report summary facility-level data on services capacity, revenues and expenses by payer, and utilization by payer. The complete database contains all of the data reported by hospitals. Data for the current year are available by individual calendar quarters. Once the 4th quarter of the current year is posted, then the prior year quarters will be rolled into one spreadsheet file which combines all the Quarterly data for that year.
Organization: State of California
Last updated: 2023-08-25T21:22:03.159422
Tags: department-of-health-care-access-and-information, discharges-by-payer-source, expenses, hospital, ogi, quarterly-financial-and-utilization-report, revenues, utilization

Tables

2019 Quarter 4 - Complete Data Set (4/10/20)

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_a156bafa.n_2019_quarter_4_complete_data_set_4_10_20

277.9 KB
435 rows
133 columns


CREATE TABLE n_2019_quarter_4_complete_data_set_4_10_20 (
  "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
);

2019 Quarter 3 - Complete Data Set (1/10/20)

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_a156bafa.n_2019_quarter_3_complete_data_set_1_10_20

278.65 KB
437 rows
133 columns


CREATE TABLE n_2019_quarter_3_complete_data_set_1_10_20 (
  "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
);

2019 Quarter 2 - Complete Data Set (10/10/19)

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_a156bafa.n_2019_quarter_2_complete_data_set_10_10_19

296.59 KB
437 rows
133 columns


CREATE TABLE n_2019_quarter_2_complete_data_set_10_10_19 (
  "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" BIGINT,
  "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" VARCHAR,
  "cadj_mcar" BIGINT,
  "cadj_mcar_mc" VARCHAR,
  "cadj_mcal" VARCHAR,
  "cadj_mcal_mc" VARCHAR,
  "disp_855" VARCHAR,
  "cadj_cnty" VARCHAR,
  "cadj_cnty_mc" BIGINT,
  "cadj_thrd" VARCHAR,
  "cadj_thrd_mc" BIGINT,
  "char_hb" BIGINT,
  "char_oth" VARCHAR,
  "sub_indgnt" VARCHAR,
  "tch_allow" BIGINT,
  "tch_supp" VARCHAR,
  "ded_oth" VARCHAR,
  "ded_tot" VARCHAR,
  "cap_mcar" VARCHAR,
  "cap_mcal" VARCHAR,
  "cap_cnty" BIGINT,
  "cap_thrd" BIGINT,
  "cap_tot" VARCHAR,
  "net_mcar" BIGINT
);

2018 Quarter 4 - Complete Data Set (4-11-2019)

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_a156bafa.n_2018_quarter_4_complete_data_set_4_11_2019

301.8 KB
440 rows
133 columns


CREATE TABLE n_2018_quarter_4_complete_data_set_4_11_2019 (
  "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" BIGINT,
  "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" VARCHAR,
  "cadj_mcar" BIGINT,
  "cadj_mcar_mc" VARCHAR,
  "cadj_mcal" VARCHAR,
  "cadj_mcal_mc" VARCHAR,
  "disp_855" VARCHAR,
  "cadj_cnty" VARCHAR,
  "cadj_cnty_mc" BIGINT,
  "cadj_thrd" VARCHAR,
  "cadj_thrd_mc" VARCHAR,
  "char_hb" BIGINT,
  "char_oth" VARCHAR,
  "sub_indgnt" VARCHAR,
  "tch_allow" BIGINT,
  "tch_supp" VARCHAR,
  "ded_oth" VARCHAR,
  "ded_tot" VARCHAR,
  "cap_mcar" BIGINT,
  "cap_mcal" VARCHAR,
  "cap_cnty" BIGINT,
  "cap_thrd" VARCHAR,
  "cap_tot" VARCHAR,
  "net_mcar" VARCHAR
);

2018 Quarter 3 - Complete Data Set (1/10/19)

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_a156bafa.n_2018_quarter_3_complete_data_set_1_10_19

297.97 KB
442 rows
133 columns


CREATE TABLE n_2018_quarter_3_complete_data_set_1_10_19 (
  "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" BIGINT,
  "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" VARCHAR,
  "cadj_mcar" BIGINT,
  "cadj_mcar_mc" VARCHAR,
  "cadj_mcal" VARCHAR,
  "cadj_mcal_mc" VARCHAR,
  "disp_855" VARCHAR,
  "cadj_cnty" VARCHAR,
  "cadj_cnty_mc" BIGINT,
  "cadj_thrd" VARCHAR,
  "cadj_thrd_mc" BIGINT,
  "char_hb" BIGINT,
  "char_oth" VARCHAR,
  "sub_indgnt" VARCHAR,
  "tch_allow" BIGINT,
  "tch_supp" VARCHAR,
  "ded_oth" VARCHAR,
  "ded_tot" BIGINT,
  "cap_mcar" BIGINT,
  "cap_mcal" VARCHAR,
  "cap_cnty" BIGINT,
  "cap_thrd" VARCHAR,
  "cap_tot" VARCHAR,
  "net_mcar" BIGINT
);

2018 Quarter 2 - Complete Data Set (10/10/18)

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_a156bafa.n_2018_quarter_2_complete_data_set_10_10_18

299.59 KB
439 rows
133 columns


CREATE TABLE n_2018_quarter_2_complete_data_set_10_10_18 (
  "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" BIGINT,
  "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" VARCHAR,
  "cadj_mcar" BIGINT,
  "cadj_mcar_mc" VARCHAR,
  "cadj_mcal" VARCHAR,
  "cadj_mcal_mc" VARCHAR,
  "disp_855" VARCHAR,
  "cadj_cnty" VARCHAR,
  "cadj_cnty_mc" BIGINT,
  "cadj_thrd" VARCHAR,
  "cadj_thrd_mc" BIGINT,
  "char_hb" BIGINT,
  "char_oth" VARCHAR,
  "sub_indgnt" VARCHAR,
  "tch_allow" BIGINT,
  "tch_supp" VARCHAR,
  "ded_oth" VARCHAR,
  "ded_tot" VARCHAR,
  "cap_mcar" BIGINT,
  "cap_mcal" BIGINT,
  "cap_cnty" BIGINT,
  "cap_thrd" VARCHAR,
  "cap_tot" VARCHAR,
  "net_mcar" VARCHAR
);

2018 Quarter 1 - Complete Data Set (7/13/18)

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_a156bafa.n_2018_quarter_1_complete_data_set_7_13_18

296.36 KB
436 rows
133 columns


CREATE TABLE n_2018_quarter_1_complete_data_set_7_13_18 (
  "fac_no" BIGINT,
  "fac_name" VARCHAR,
  "year_qtr" BIGINT,
  "beg_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "op_status" VARCHAR,
  "county_name" VARCHAR,
  "hsa" BIGINT,
  "hfpa" BIGINT,
  "type_cntrl" VARCHAR,
  "type_hosp" VARCHAR,
  "teach_rurl" VARCHAR,
  "phone" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "zip_code" BIGINT,
  "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" VARCHAR,
  "cadj_mcar" BIGINT,
  "cadj_mcar_mc" BIGINT,
  "cadj_mcal" VARCHAR,
  "cadj_mcal_mc" VARCHAR,
  "disp_855" VARCHAR,
  "cadj_cnty" VARCHAR,
  "cadj_cnty_mc" BIGINT,
  "cadj_thrd" VARCHAR,
  "cadj_thrd_mc" VARCHAR,
  "char_hb" BIGINT,
  "char_oth" VARCHAR,
  "sub_indgnt" VARCHAR,
  "tch_allow" BIGINT,
  "tch_supp" VARCHAR,
  "ded_oth" VARCHAR,
  "ded_tot" VARCHAR,
  "cap_mcar" BIGINT,
  "cap_mcal" BIGINT,
  "cap_cnty" BIGINT,
  "cap_thrd" BIGINT,
  "cap_tot" BIGINT,
  "net_mcar" VARCHAR
);

2017 Quarter 4 - Complete Data Set (4/13/18)

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_a156bafa.n_2017_quarter_4_complete_data_set_4_13_18

305.72 KB
442 rows
133 columns


CREATE TABLE n_2017_quarter_4_complete_data_set_4_13_18 (
  "fac_no" BIGINT,
  "fac_name" VARCHAR,
  "year_qtr" BIGINT,
  "beg_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "op_status" VARCHAR,
  "county_name" VARCHAR,
  "hsa" BIGINT,
  "hfpa" BIGINT,
  "type_cntrl" VARCHAR,
  "type_hosp" VARCHAR,
  "teach_rurl" VARCHAR,
  "phone" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "zip_code" BIGINT,
  "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" VARCHAR,
  "cadj_mcar" VARCHAR,
  "cadj_mcar_mc" VARCHAR,
  "cadj_mcal" VARCHAR,
  "cadj_mcal_mc" VARCHAR,
  "disp_855" VARCHAR,
  "cadj_cnty" VARCHAR,
  "cadj_cnty_mc" BIGINT,
  "cadj_thrd" VARCHAR,
  "cadj_thrd_mc" VARCHAR,
  "char_hb" BIGINT,
  "char_oth" VARCHAR,
  "sub_indgnt" VARCHAR,
  "tch_allow" BIGINT,
  "tch_supp" VARCHAR,
  "ded_oth" VARCHAR,
  "ded_tot" VARCHAR,
  "cap_mcar" BIGINT,
  "cap_mcal" VARCHAR,
  "cap_cnty" BIGINT,
  "cap_thrd" VARCHAR,
  "cap_tot" VARCHAR,
  "net_mcar" VARCHAR
);

2017 Quarter 3 - Complete Data Set (1/12/18)

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_a156bafa.n_2017_quarter_3_complete_data_set_1_12_18

294.42 KB
440 rows
133 columns


CREATE TABLE n_2017_quarter_3_complete_data_set_1_12_18 (
  "fac_no" BIGINT,
  "fac_name" VARCHAR,
  "year_qtr" BIGINT,
  "beg_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "op_status" VARCHAR,
  "county_name" VARCHAR,
  "hsa" BIGINT,
  "hfpa" BIGINT,
  "type_cntrl" VARCHAR,
  "type_hosp" VARCHAR,
  "teach_rurl" VARCHAR,
  "phone" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "zip_code" BIGINT,
  "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" VARCHAR,
  "cadj_mcar" BIGINT,
  "cadj_mcar_mc" BIGINT,
  "cadj_mcal" VARCHAR,
  "cadj_mcal_mc" BIGINT,
  "disp_855" VARCHAR,
  "cadj_cnty" BIGINT,
  "cadj_cnty_mc" BIGINT,
  "cadj_thrd" VARCHAR,
  "cadj_thrd_mc" BIGINT,
  "char_hb" BIGINT,
  "char_oth" VARCHAR,
  "sub_indgnt" VARCHAR,
  "tch_allow" BIGINT,
  "tch_supp" VARCHAR,
  "ded_oth" VARCHAR,
  "ded_tot" BIGINT,
  "cap_mcar" BIGINT,
  "cap_mcal" VARCHAR,
  "cap_cnty" BIGINT,
  "cap_thrd" VARCHAR,
  "cap_tot" VARCHAR,
  "net_mcar" BIGINT
);

2017 Quarter 2 - Complete Data Set (11/02/17)

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_a156bafa.n_2017_quarter_2_complete_data_set_11_02_17

301.05 KB
444 rows
133 columns


CREATE TABLE n_2017_quarter_2_complete_data_set_11_02_17 (
  "fac_no" BIGINT,
  "fac_name" VARCHAR,
  "year_qtr" BIGINT,
  "beg_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "op_status" VARCHAR,
  "county_name" VARCHAR,
  "hsa" BIGINT,
  "hfpa" BIGINT,
  "type_cntrl" VARCHAR,
  "type_hosp" VARCHAR,
  "teach_rurl" VARCHAR,
  "phone" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "zip_code" BIGINT,
  "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" VARCHAR,
  "cadj_mcar" BIGINT,
  "cadj_mcar_mc" VARCHAR,
  "cadj_mcal" VARCHAR,
  "cadj_mcal_mc" VARCHAR,
  "disp_855" VARCHAR,
  "cadj_cnty" VARCHAR,
  "cadj_cnty_mc" VARCHAR,
  "cadj_thrd" BIGINT,
  "cadj_thrd_mc" BIGINT,
  "char_hb" BIGINT,
  "char_oth" VARCHAR,
  "sub_indgnt" VARCHAR,
  "tch_allow" BIGINT,
  "tch_supp" VARCHAR,
  "ded_oth" VARCHAR,
  "ded_tot" VARCHAR,
  "cap_mcar" BIGINT,
  "cap_mcal" BIGINT,
  "cap_cnty" BIGINT,
  "cap_thrd" BIGINT,
  "cap_tot" BIGINT,
  "net_mcar" VARCHAR
);

2017 Quarter 1 - Complete Data Set (7/14/17)

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_a156bafa.n_2017_quarter_1_complete_data_set_7_14_17

306.87 KB
446 rows
133 columns


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

2016 Quarter 4 - Complete Data Set (4/14/17)

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_a156bafa.n_2016_quarter_4_complete_data_set_4_14_17

304.95 KB
446 rows
133 columns


CREATE TABLE n_2016_quarter_4_complete_data_set_4_14_17 (
  "fac_no" BIGINT,
  "fac_name" VARCHAR,
  "year_qtr" BIGINT,
  "beg_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "op_status" VARCHAR,
  "county_name" VARCHAR,
  "hsa" BIGINT,
  "hfpa" BIGINT,
  "type_cntrl" VARCHAR,
  "type_hosp" VARCHAR,
  "teach_rurl" VARCHAR,
  "phone" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "zip_code" BIGINT,
  "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" VARCHAR,
  "cadj_mcar" VARCHAR,
  "cadj_mcar_mc" VARCHAR,
  "cadj_mcal" VARCHAR,
  "cadj_mcal_mc" VARCHAR,
  "disp_855" VARCHAR,
  "cadj_cnty" BIGINT,
  "cadj_cnty_mc" BIGINT,
  "cadj_thrd" VARCHAR,
  "cadj_thrd_mc" VARCHAR,
  "char_hb" BIGINT,
  "char_oth" VARCHAR,
  "sub_indgnt" VARCHAR,
  "tch_allow" BIGINT,
  "tch_supp" VARCHAR,
  "ded_oth" VARCHAR,
  "ded_tot" VARCHAR,
  "cap_mcar" BIGINT,
  "cap_mcal" BIGINT,
  "cap_cnty" BIGINT,
  "cap_thrd" VARCHAR,
  "cap_tot" VARCHAR,
  "net_mcar" VARCHAR
);

Hospital Quarterly Financial & Utilization Report - Complete Data Set

About this Dataset