Hospital Financial Quarterly Aggregate Report

CREATE TABLE table_1 (
  "license_number" BIGINT,
  "hospital_name" VARCHAR,
  "city" VARCHAR,
  "year" BIGINT,
  "quarter" BIGINT,
  "licensed_beds" BIGINT,
  "acute_care_medicare_discharges" BIGINT,
  "acute_care_medicaid_discharges" BIGINT,
  "acute_care_self_pay_discharges" BIGINT,
  "acute_care_commercial_discharges" BIGINT,
  "acute_care_other_discharges" BIGINT,
  "acute_care_total_discharges" BIGINT,
  "swing_bed_medicare_discharges1" BIGINT,
  "swing_bed_medicaid_discharges" BIGINT,
  "swing_bed_self_pay_discharges" BIGINT,
  "swing_bed_commercial_discharges" BIGINT,
  "swing_bed_other_discharges" BIGINT,
  "swing_bed_total_discharges" BIGINT,
  "snf_medicare_discharges" BIGINT,
  "snf_medicaid_discharges" BIGINT,
  "snf_self_pay_discharges" BIGINT,
  "snf_commercial_discharges" BIGINT,
  "snf_other_discharges" BIGINT,
  "snf_total_discharges" BIGINT,
  "psych_rehab_cdu_medicare_discharges" BIGINT,
  "psych_rehab_cdu_medicaid_discharges" BIGINT,
  "psych_rehab_cdu_self_pay_discharges" BIGINT,
  "psych_rehab_cdu_commercial_discharges" BIGINT,
  "psych_rehab_cdu_other_discharges" BIGINT,
  "psych_rehab_cdu_total_discharges" BIGINT,
  "total_medicare_discharges" BIGINT,
  "total_medicaid_discharges" BIGINT,
  "total_self_pay_discharges" BIGINT,
  "total_commercial_discharges" BIGINT,
  "total_other_discharges" BIGINT,
  "total_discharges" BIGINT,
  "acute_care_medicare_patient_days" BIGINT,
  "acute_care_medicaid_patient_days" BIGINT,
  "acute_care_self_pay_patient_days" BIGINT,
  "acute_care_commercial_patient_days" BIGINT,
  "acute_care_other_patient_days" BIGINT,
  "acute_care_total_patient_days" BIGINT,
  "swing_bed_medicare_patient_days" BIGINT,
  "swing_bed_medicaid_patient_days" BIGINT,
  "swing_bed_self_pay_patient_days" BIGINT,
  "swing_bed_commercial_patient_days" BIGINT,
  "swing_bed_other_patient_days" BIGINT,
  "swing_bed_total_patient_days" BIGINT,
  "snf_medicare_patient_days" BIGINT,
  "snf_medicaid_patient_days" BIGINT,
  "snf_self_pay_patient_days" BIGINT,
  "snf_commercial_patient_days" BIGINT,
  "snf_other_patient_days" BIGINT,
  "snf_total_patient_days" BIGINT,
  "psych_rehab_cdu_medicare_patient_days" BIGINT,
  "psych_rehab_cdu_medicaid_patient_days" BIGINT,
  "psych_rehab_cdu_self_pay_patient_days" BIGINT,
  "psych_rehab_cdu_commercial_patient_days" BIGINT,
  "psych_rehab_cdu_other_patient_days" BIGINT,
  "psych_rehab_cdu_total_patient_days" BIGINT,
  "total_medicare_patient_days" BIGINT,
  "total_medicaid_patient_days" BIGINT,
  "total_self_pay_patient_days" BIGINT,
  "total_commercial_patient_days" BIGINT,
  "total_other_patient_days" BIGINT,
  "total_patient_days" BIGINT,
  "total_inpatient_surgeries" BIGINT,
  "total_births" BIGINT,
  "total_newborn_days" BIGINT,
  "number_of_admissions_from_er" BIGINT,
  "emergency_room_visits" BIGINT,
  "outpatient_surgery_visits" BIGINT,
  "observation_visits" BIGINT,
  "home_health_visits" BIGINT,
  "all_other_visits" BIGINT,
  "total_outpatient_visits" BIGINT,
  "acute_medicare_inpatient_revenue" BIGINT,
  "acute_medicaid_inpatient_revenue" BIGINT,
  "acute_self_pay_inpatient_revenue" BIGINT,
  "acute_other_inpatient_revenue" BIGINT,
  "acute_total_inpatient_revenue" BIGINT,
  "acute_medicare_outpatient_revenue" BIGINT,
  "acute_medicaid_outpatient_revenue" BIGINT,
  "acute_self_pay_outpatient_revenue" BIGINT,
  "acute_commercial_inpatient_revenue" BIGINT,
  "acute_commercial_outpatient_revenue" BIGINT,
  "acute_other_outpatient_revenue" BIGINT,
  "acute_total_outpatient_revenue" BIGINT,
  "swing_bed_medicare_revenue" BIGINT,
  "swing_bed_medicaid_revenue" BIGINT,
  "swing_bed_self_pay_revenue" BIGINT,
  "swing_bed_commercial_revenue" BIGINT,
  "swing_bed_other_revenue" BIGINT,
  "swing_bed_total_revenue" BIGINT,
  "snf_medicare_revenue" BIGINT,
  "snf_medicaid_revenue" BIGINT,
  "snf_self_pay_revenue" BIGINT,
  "snf_commercial_revenue" BIGINT,
  "snf_other_revenue" BIGINT,
  "snf_total_revenue" BIGINT
);