Baselight
Sign In

Hospital Quarterly Financial & Utilization Report - Sum Of Four Quarters

State of California

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_51a86f32

Loading...
Loading...

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

2013 Quarter 1 - Sum Of Four Quarters (Rev 7/15)

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_51a86f32.n_2013_quarter_1_sum_of_four_quarters_rev_7_15
  • 324.98 kB
  • 447 rows
  • 121 columns
Loading... 
CREATE TABLE n_2013_quarter_1_sum_of_four_quarters_rev_7_15 (
  "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" VARCHAR,
  "ceo" VARCHAR,
  "lic_beds" DOUBLE,
  "avl_beds" BIGINT,
  "stf_beds" BIGINT,
  "dis_mcar" BIGINT,
  "dis_mcar_mc" BIGINT,
  "dis_mcal" BIGINT,
  "dis_mcal_mc" BIGINT,
  "dis_cnty" VARCHAR,
  "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" VARCHAR,
  "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" VARCHAR,
  "vis_oth" BIGINT,
  "vis_tot" BIGINT,
  "grip_mcar" BIGINT,
  "grip_mcar_mc" BIGINT,
  "grip_mcal" BIGINT,
  "grip_mcal_mc" BIGINT,
  "grip_cnty" VARCHAR,
  "grip_cnty_mc" BIGINT,
  "grip_thrd" BIGINT,
  "grip_thrd_mc" BIGINT,
  "grip_indgnt" VARCHAR,
  "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" 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" BIGINT
);

2013 Quarter 2 - Sum Of Four Quarters (Rev 7/15)

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_51a86f32.n_2013_quarter_2_sum_of_four_quarters_rev_7_15
  • 322.84 kB
  • 446 rows
  • 121 columns
Loading... 
CREATE TABLE n_2013_quarter_2_sum_of_four_quarters_rev_7_15 (
  "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" 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" VARCHAR,
  "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" VARCHAR,
  "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" VARCHAR,
  "grip_cnty_mc" BIGINT,
  "grip_thrd" BIGINT,
  "grip_thrd_mc" BIGINT,
  "grip_indgnt" VARCHAR,
  "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" BIGINT,
  "char_hb" BIGINT,
  "char_oth" BIGINT,
  "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" BIGINT
);

2013 Quarter 3 - Sum Of Four Quarters (Rev 7/15)

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_51a86f32.n_2013_quarter_3_sum_of_four_quarters_rev_7_15
  • 322.79 kB
  • 446 rows
  • 121 columns
Loading... 
CREATE TABLE n_2013_quarter_3_sum_of_four_quarters_rev_7_15 (
  "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" 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" VARCHAR,
  "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" VARCHAR,
  "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" VARCHAR,
  "grip_cnty_mc" BIGINT,
  "grip_thrd" BIGINT,
  "grip_thrd_mc" BIGINT,
  "grip_indgnt" VARCHAR,
  "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" BIGINT,
  "char_hb" BIGINT,
  "char_oth" BIGINT,
  "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" BIGINT
);

2013 Quarter 4 - Sum Of Four Quarters (Rev 7/15)

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_51a86f32.n_2013_quarter_4_sum_of_four_quarters_rev_7_15
  • 322.42 kB
  • 444 rows
  • 122 columns
Loading... 
CREATE TABLE n_2013_quarter_4_sum_of_four_quarters_rev_7_15 (
  "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" 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" VARCHAR,
  "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" BIGINT,
  "cadj_cnty_mc" BIGINT,
  "cadj_thrd" VARCHAR,
  "cadj_thrd_mc" BIGINT,
  "char_hb" BIGINT,
  "char_oth" BIGINT,
  "sub_indgnt" VARCHAR,
  "tch_allow" BIGINT,
  "tch_supp" VARCHAR,
  "ded_oth" VARCHAR,
  "ded_tot" VARCHAR,
  "cap_mcar" VARCHAR,
  "cap_mcal" BIGINT,
  "cap_cnty" BIGINT,
  "cap_thrd" VARCHAR,
  "cap_tot" VARCHAR,
  "net_mcar" BIGINT
);

2014 Quarter 1 - Sum Of Four Quarters (Rev 7/15)

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_51a86f32.n_2014_quarter_1_sum_of_four_quarters_rev_7_15
  • 318.18 kB
  • 438 rows
  • 121 columns
Loading... 
CREATE TABLE n_2014_quarter_1_sum_of_four_quarters_rev_7_15 (
  "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" 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" VARCHAR,
  "cadj_mcar" BIGINT,
  "cadj_mcar_mc" BIGINT,
  "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" BIGINT,
  "sub_indgnt" VARCHAR,
  "tch_allow" BIGINT,
  "tch_supp" VARCHAR,
  "ded_oth" VARCHAR,
  "ded_tot" VARCHAR,
  "cap_mcar" VARCHAR,
  "cap_mcal" BIGINT,
  "cap_cnty" BIGINT,
  "cap_thrd" VARCHAR,
  "cap_tot" BIGINT,
  "net_mcar" BIGINT
);

2014 Quarter 2 - Sum Of Four Quarters (Rev 7/15)

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_51a86f32.n_2014_quarter_2_sum_of_four_quarters_rev_7_15
  • 322.29 kB
  • 442 rows
  • 121 columns
Loading... 
CREATE TABLE n_2014_quarter_2_sum_of_four_quarters_rev_7_15 (
  "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" VARCHAR,
  "ceo" VARCHAR,
  "lic_beds" DOUBLE,
  "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" VARCHAR,
  "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" 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" VARCHAR,
  "cap_tot" BIGINT,
  "net_mcar" BIGINT
);

2014 Quarter 3 - Sum Of Four Quarters (Rev 7/15)

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_51a86f32.n_2014_quarter_3_sum_of_four_quarters_rev_7_15
  • 321.73 kB
  • 444 rows
  • 121 columns
Loading... 
CREATE TABLE n_2014_quarter_3_sum_of_four_quarters_rev_7_15 (
  "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" 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" VARCHAR,
  "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" VARCHAR,
  "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" BIGINT,
  "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" BIGINT,
  "net_mcar" VARCHAR
);

2014 Quarter 4 - Sum Of Four Quarters (Rev 7/15)

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_51a86f32.n_2014_quarter_4_sum_of_four_quarters_rev_7_15
  • 321.06 kB
  • 446 rows
  • 121 columns
Loading... 
CREATE TABLE n_2014_quarter_4_sum_of_four_quarters_rev_7_15 (
  "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" VARCHAR,
  "ceo" VARCHAR,
  "lic_beds" DOUBLE,
  "avl_beds" BIGINT,
  "stf_beds" BIGINT,
  "dis_mcar" BIGINT,
  "dis_mcar_mc" BIGINT,
  "dis_mcal" BIGINT,
  "dis_mcal_mc" BIGINT,
  "dis_cnty" VARCHAR,
  "dis_cnty_mc" BIGINT,
  "dis_thrd" BIGINT,
  "dis_thrd_mc" BIGINT,
  "dis_indgnt" BIGINT,
  "dis_oth" VARCHAR,
  "dis_tot" BIGINT,
  "dis_ltc" BIGINT,
  "day_mcar" BIGINT,
  "day_mcar_mc" BIGINT,
  "day_mcal" BIGINT,
  "day_mcal_mc" BIGINT,
  "day_cnty" VARCHAR,
  "day_cnty_mc" BIGINT,
  "day_thrd" BIGINT,
  "day_thrd_mc" BIGINT,
  "day_indgnt" BIGINT,
  "day_oth" VARCHAR,
  "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" VARCHAR,
  "grip_cnty_mc" BIGINT,
  "grip_thrd" BIGINT,
  "grip_thrd_mc" BIGINT,
  "grip_indgnt" BIGINT,
  "grip_oth" VARCHAR,
  "grip_tot" BIGINT,
  "grop_mcar" BIGINT,
  "grop_mcar_mc" BIGINT,
  "grop_mcal" BIGINT,
  "grop_mcal_mc" BIGINT,
  "grop_cnty" VARCHAR,
  "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" VARCHAR,
  "cadj_cnty_mc" VARCHAR,
  "cadj_thrd" VARCHAR,
  "cadj_thrd_mc" VARCHAR,
  "char_hb" BIGINT,
  "char_oth" BIGINT,
  "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
);

2015 Quarter 1 - Sum Of Four Quarters (Rev 4/16)

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_51a86f32.n_2015_quarter_1_sum_of_four_quarters_rev_4_16
  • 333.36 kB
  • 448 rows
  • 133 columns
Loading... 
CREATE TABLE n_2015_quarter_1_sum_of_four_quarters_rev_4_16 (
  "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" 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" VARCHAR,
  "dis_cnty_mc" BIGINT,
  "dis_thrd" BIGINT,
  "dis_thrd_mc" BIGINT,
  "dis_indgnt" BIGINT,
  "dis_oth" VARCHAR,
  "dis_tot" BIGINT,
  "dis_ltc" BIGINT,
  "day_mcar" BIGINT,
  "day_mcar_mc" BIGINT,
  "day_mcal" BIGINT,
  "day_mcal_mc" BIGINT,
  "day_cnty" VARCHAR,
  "day_cnty_mc" BIGINT,
  "day_thrd" BIGINT,
  "day_thrd_mc" BIGINT,
  "day_indgnt" BIGINT,
  "day_oth" VARCHAR,
  "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" VARCHAR,
  "grip_cnty_mc" BIGINT,
  "grip_thrd" BIGINT,
  "grip_thrd_mc" BIGINT,
  "grip_indgnt" VARCHAR,
  "grip_oth" VARCHAR,
  "grip_tot" BIGINT,
  "grop_mcar" BIGINT,
  "grop_mcar_mc" BIGINT,
  "grop_mcal" BIGINT,
  "grop_mcal_mc" BIGINT,
  "grop_cnty" VARCHAR,
  "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" BIGINT,
  "disp_855" VARCHAR,
  "cadj_cnty" VARCHAR,
  "cadj_cnty_mc" VARCHAR,
  "cadj_thrd" VARCHAR,
  "cadj_thrd_mc" BIGINT,
  "char_hb" BIGINT,
  "char_oth" BIGINT,
  "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
);

2015 Quarter 2 - Sum Of Four Quarters (Rev 4/16)

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_51a86f32.n_2015_quarter_2_sum_of_four_quarters_rev_4_16
  • 329.92 kB
  • 447 rows
  • 133 columns
Loading... 
CREATE TABLE n_2015_quarter_2_sum_of_four_quarters_rev_4_16 (
  "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" 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" VARCHAR,
  "dis_tot" BIGINT,
  "dis_ltc" BIGINT,
  "day_mcar" BIGINT,
  "day_mcar_mc" BIGINT,
  "day_mcal" BIGINT,
  "day_mcal_mc" BIGINT,
  "day_cnty" VARCHAR,
  "day_cnty_mc" BIGINT,
  "day_thrd" BIGINT,
  "day_thrd_mc" BIGINT,
  "day_indgnt" BIGINT,
  "day_oth" VARCHAR,
  "day_tot" BIGINT,
  "day_ltc" BIGINT,
  "vis_mcar" BIGINT,
  "vis_mcar_mc" BIGINT,
  "vis_mcal" BIGINT,
  "vis_mcal_mc" BIGINT,
  "vis_cnty" VARCHAR,
  "vis_cnty_mc" BIGINT,
  "vis_thrd" BIGINT,
  "vis_thrd_mc" BIGINT,
  "vis_indgnt" BIGINT,
  "vis_oth" VARCHAR,
  "vis_tot" BIGINT,
  "grip_mcar" BIGINT,
  "grip_mcar_mc" BIGINT,
  "grip_mcal" BIGINT,
  "grip_mcal_mc" BIGINT,
  "grip_cnty" VARCHAR,
  "grip_cnty_mc" BIGINT,
  "grip_thrd" BIGINT,
  "grip_thrd_mc" BIGINT,
  "grip_indgnt" VARCHAR,
  "grip_oth" VARCHAR,
  "grip_tot" BIGINT,
  "grop_mcar" BIGINT,
  "grop_mcar_mc" BIGINT,
  "grop_mcal" BIGINT,
  "grop_mcal_mc" BIGINT,
  "grop_cnty" VARCHAR,
  "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" BIGINT,
  "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" VARCHAR,
  "cap_cnty" BIGINT,
  "cap_thrd" VARCHAR,
  "cap_tot" VARCHAR,
  "net_mcar" VARCHAR
);

2015 Quarter 3 - Sum Of Four Quarters (Rev 4/16)

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_51a86f32.n_2015_quarter_3_sum_of_four_quarters_rev_4_16
  • 329.28 kB
  • 446 rows
  • 133 columns
Loading... 
CREATE TABLE n_2015_quarter_3_sum_of_four_quarters_rev_4_16 (
  "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" 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" VARCHAR,
  "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" VARCHAR,
  "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" VARCHAR,
  "vis_tot" BIGINT,
  "grip_mcar" BIGINT,
  "grip_mcar_mc" BIGINT,
  "grip_mcal" BIGINT,
  "grip_mcal_mc" BIGINT,
  "grip_cnty" VARCHAR,
  "grip_cnty_mc" BIGINT,
  "grip_thrd" BIGINT,
  "grip_thrd_mc" BIGINT,
  "grip_indgnt" BIGINT,
  "grip_oth" VARCHAR,
  "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" VARCHAR,
  "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" VARCHAR,
  "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" BIGINT,
  "cap_cnty" BIGINT,
  "cap_thrd" BIGINT,
  "cap_tot" BIGINT,
  "net_mcar" BIGINT
);

2015 Quarter 4 - Sum Of Four Quarters (Rev 4/16)

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_51a86f32.n_2015_quarter_4_sum_of_four_quarters_rev_4_16
  • 332.49 kB
  • 446 rows
  • 133 columns
Loading... 
CREATE TABLE n_2015_quarter_4_sum_of_four_quarters_rev_4_16 (
  "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" VARCHAR,
  "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" VARCHAR,
  "dis_tot" DOUBLE,
  "dis_ltc" DOUBLE,
  "day_mcar" DOUBLE,
  "day_mcar_mc" DOUBLE,
  "day_mcal" DOUBLE,
  "day_mcal_mc" DOUBLE,
  "day_cnty" VARCHAR,
  "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" VARCHAR,
  "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" VARCHAR,
  "cadj_cnty_mc" VARCHAR,
  "cadj_thrd" DOUBLE,
  "cadj_thrd_mc" DOUBLE,
  "char_hb" DOUBLE,
  "char_oth" VARCHAR,
  "sub_indgnt" VARCHAR,
  "tch_allow" DOUBLE,
  "tch_supp" VARCHAR,
  "ded_oth" VARCHAR,
  "ded_tot" VARCHAR,
  "cap_mcar" VARCHAR,
  "cap_mcal" DOUBLE,
  "cap_cnty" DOUBLE,
  "cap_thrd" DOUBLE,
  "cap_tot" DOUBLE,
  "net_mcar" DOUBLE
);

2016 Quarter 1 - Sum Of Four Quarters

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_51a86f32.n_2016_quarter_1_sum_of_four_quarters
  • 331.79 kB
  • 446 rows
  • 133 columns
Loading... 
CREATE TABLE n_2016_quarter_1_sum_of_four_quarters (
  "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" VARCHAR,
  "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" VARCHAR,
  "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" VARCHAR,
  "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" VARCHAR,
  "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" VARCHAR,
  "cadj_cnty_mc" VARCHAR,
  "cadj_thrd" DOUBLE,
  "cadj_thrd_mc" DOUBLE,
  "char_hb" DOUBLE,
  "char_oth" VARCHAR,
  "sub_indgnt" VARCHAR,
  "tch_allow" DOUBLE,
  "tch_supp" VARCHAR,
  "ded_oth" VARCHAR,
  "ded_tot" VARCHAR,
  "cap_mcar" DOUBLE,
  "cap_mcal" DOUBLE,
  "cap_cnty" DOUBLE,
  "cap_thrd" DOUBLE,
  "cap_tot" DOUBLE,
  "net_mcar" DOUBLE
);

2016 Quarter 2 - Sum Of Four Quarters

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_51a86f32.n_2016_quarter_2_sum_of_four_quarters
  • 333.87 kB
  • 446 rows
  • 133 columns
Loading... 
CREATE TABLE n_2016_quarter_2_sum_of_four_quarters (
  "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" VARCHAR,
  "cadj_cnty_mc" DOUBLE,
  "cadj_thrd" VARCHAR,
  "cadj_thrd_mc" DOUBLE,
  "char_hb" DOUBLE,
  "char_oth" DOUBLE,
  "sub_indgnt" VARCHAR,
  "tch_allow" DOUBLE,
  "tch_supp" VARCHAR,
  "ded_oth" VARCHAR,
  "ded_tot" VARCHAR,
  "cap_mcar" DOUBLE,
  "cap_mcal" VARCHAR,
  "cap_cnty" DOUBLE,
  "cap_thrd" DOUBLE,
  "cap_tot" VARCHAR,
  "net_mcar" DOUBLE
);

2016 Quarter 3 - Sum Of Four Quarters

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_51a86f32.n_2016_quarter_3_sum_of_four_quarters
  • 332.43 kB
  • 446 rows
  • 133 columns
Loading... 
CREATE TABLE n_2016_quarter_3_sum_of_four_quarters (
  "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" DOUBLE,
  "cadj_mcal" VARCHAR,
  "cadj_mcal_mc" VARCHAR,
  "disp_855" VARCHAR,
  "cadj_cnty" VARCHAR,
  "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" VARCHAR,
  "cap_mcar" DOUBLE,
  "cap_mcal" DOUBLE,
  "cap_cnty" DOUBLE,
  "cap_thrd" DOUBLE,
  "cap_tot" DOUBLE,
  "net_mcar" VARCHAR
);

2016 Quarter 4 - Sum Of Four Quarters

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_51a86f32.n_2016_quarter_4_sum_of_four_quarters
  • 324.34 kB
  • 447 rows
  • 133 columns
Loading... 
CREATE TABLE n_2016_quarter_4_sum_of_four_quarters (
  "fac_no" BIGINT,
  "fac_name" VARCHAR,
  "year_qtr" VARCHAR,
  "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" 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" VARCHAR,
  "cap_mcar" BIGINT,
  "cap_mcal" BIGINT,
  "cap_cnty" BIGINT,
  "cap_thrd" BIGINT,
  "cap_tot" BIGINT,
  "net_mcar" VARCHAR
);

2017 Quarter 1 - Sum Of Four Quarters

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_51a86f32.n_2017_quarter_1_sum_of_four_quarters
  • 325.82 kB
  • 448 rows
  • 133 columns
Loading... 
CREATE TABLE n_2017_quarter_1_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" 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" 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" BIGINT,
  "cap_tot" BIGINT,
  "net_mcar" BIGINT
);

2017 Quarter 2 - Sum Of Four Quarters

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_51a86f32.n_2017_quarter_2_sum_of_four_quarters
  • 326.54 kB
  • 448 rows
  • 133 columns
Loading... 
CREATE TABLE n_2017_quarter_2_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" 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" BIGINT,
  "cadj_cnty_mc" VARCHAR,
  "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" BIGINT
);

2017 Quarter 3 - Sum Of Four Quarters

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_51a86f32.n_2017_quarter_3_sum_of_four_quarters
  • 302.49 kB
  • 448 rows
  • 133 columns
Loading... 
CREATE TABLE n_2017_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" BIGINT,
  "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
);

2017 Quarter 4 - Sum Of Four Quarters

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_51a86f32.n_2017_quarter_4_sum_of_four_quarters
  • 324.49 kB
  • 450 rows
  • 133 columns
Loading... 
CREATE TABLE n_2017_quarter_4_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" 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" VARCHAR,
  "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" BIGINT,
  "cap_tot" BIGINT,
  "net_mcar" BIGINT
);

2018 Quarter 1 - Sum Of Four Quarters

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_51a86f32.n_2018_quarter_1_sum_of_four_quarters
  • 322.64 kB
  • 447 rows
  • 133 columns
Loading... 
CREATE TABLE n_2018_quarter_1_sum_of_four_quarters (
  "fac_no" BIGINT,
  "fac_name" VARCHAR,
  "year_qtr" VARCHAR,
  "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" 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" VARCHAR,
  "cap_cnty" BIGINT,
  "cap_thrd" BIGINT,
  "cap_tot" VARCHAR,
  "net_mcar" VARCHAR
);

2018 Quarter 2 - Sum Of Four Quarters

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_51a86f32.n_2018_quarter_2_sum_of_four_quarters
  • 323.73 kB
  • 445 rows
  • 133 columns
Loading... 
CREATE TABLE n_2018_quarter_2_sum_of_four_quarters (
  "fac_no" BIGINT,
  "fac_name" VARCHAR,
  "year_qtr" VARCHAR,
  "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" VARCHAR,
  "cap_cnty" BIGINT,
  "cap_thrd" VARCHAR,
  "cap_tot" VARCHAR,
  "net_mcar" BIGINT
);

2018 Quarter 3 - Sum Of Four Quarters

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_51a86f32.n_2018_quarter_3_sum_of_four_quarters
  • 329.92 kB
  • 446 rows
  • 133 columns
Loading... 
CREATE TABLE n_2018_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" 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" 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" VARCHAR,
  "cap_cnty" BIGINT,
  "cap_thrd" BIGINT,
  "cap_tot" BIGINT,
  "net_mcar" VARCHAR
);

2018 Quarter 4 - Sum Of Four Quarters

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_51a86f32.n_2018_quarter_4_sum_of_four_quarters
  • 323.75 kB
  • 446 rows
  • 133 columns
Loading... 
CREATE TABLE n_2018_quarter_4_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" 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" 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" VARCHAR,
  "cap_cnty" BIGINT,
  "cap_thrd" BIGINT,
  "cap_tot" VARCHAR,
  "net_mcar" BIGINT
);

2019 Quarter 2 - Sum Of Four Quarters

@usgov.ca_gov_hospital_quarterly_financial_utilization_report_51a86f32.n_2019_quarter_2_sum_of_four_quarters
  • 322.61 kB
  • 446 rows
  • 133 columns
Loading... 
CREATE TABLE n_2019_quarter_2_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" 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" 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" VARCHAR,
  "cap_cnty" BIGINT,
  "cap_thrd" VARCHAR,
  "cap_tot" VARCHAR,
  "net_mcar" BIGINT
);

Share link

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