Utilization And Costs Of Health Services For Medicare Fee-for-Service Beneficiaries, Washington State And Counties, 2007-2018

CREATE TABLE table_1 (
  "county" VARCHAR,
  "n__to_sort_by_county_and_year" DOUBLE  -- (To Sort By County And Year),
  "n__to_sort_by_year_and_county" DOUBLE  -- (To Sort By Year And County),
  "year" BIGINT,
  "state_and_county_fips_code" VARCHAR,
  "total_actual_costs" DOUBLE,
  "total_standardized_costs" DOUBLE,
  "total_standardized_risk_adjusted_costs" DOUBLE,
  "actual_per_capita_costs" DOUBLE,
  "standardized_per_capita_costs" DOUBLE,
  "standardized_risk_adjusted_per_capita_costs" DOUBLE,
  "ip_actual_costs" DOUBLE,
  "ip_actual_costs_as_of_total_actual_costs" DOUBLE  -- IP Actual Costs As % Of Total Actual Costs,
  "ip_per_capita_actual_costs" DOUBLE,
  "ip_per_user_actual_costs" DOUBLE,
  "ip_standardized_costs" DOUBLE,
  "ip_standardized_costs_as_of_total_standardized_costs" DOUBLE  -- IP Standardized Costs As % Of Total Standardized Costs,
  "ip_per_capita_standardized_costs" DOUBLE,
  "ip_per_user_standardized_costs" DOUBLE,
  "ip_users_with_a_covered_stay" DOUBLE  -- IP Users (with A Covered Stay),
  "n__of_beneficiaries_using_ip" DOUBLE  -- % Of Beneficiaries Using IP,
  "ip_covered_stays_per_1000_beneficiaries" DOUBLE,
  "ip_covered_days_per_1000_beneficiaries" DOUBLE,
  "pac_ltch_actual_costs" DOUBLE  -- PAC: LTCH Actual Costs,
  "pac_ltch_actual_costs_as_of_total_actual_costs" DOUBLE  -- PAC: LTCH Actual Costs As % Of Total Actual Costs,
  "pac_ltch_per_capita_actual_costs" DOUBLE  -- PAC: LTCH Per Capita Actual Costs,
  "pac_ltch_per_user_actual_costs" DOUBLE  -- PAC: LTCH Per User Actual Costs,
  "pac_ltch_standardized_costs" DOUBLE  -- PAC: LTCH Standardized Costs,
  "pac_ltch_standardized_costs_as_of_total_standardized_costs" DOUBLE  -- PAC: LTCH Standardized Costs As % Of Total Standardized Costs,
  "pac_ltch_per_capita_standardized_costs" DOUBLE  -- PAC: LTCH Per Capita Standardized Costs,
  "pac_ltch_per_user_standardized_costs" DOUBLE  -- PAC: LTCH Per User Standardized Costs,
  "n__pac_ltch_users_with_a_covered_stay" DOUBLE  -- # PAC: LTCH Users (with A Covered Stay),
  "n__of_beneficiaries_using_pac_ltch" DOUBLE  -- % Of Beneficiaries Using PAC: LTCH,
  "pac_ltch_covered_stays_per_1000_beneficiaries" DOUBLE  -- PAC: LTCH Covered Stays Per 1000 Beneficiaries,
  "pac_ltch_covered_days_per_1000_beneficiaries" DOUBLE  -- PAC: LTCH Covered Days Per 1000 Beneficiaries,
  "pac_irf_actual_costs" DOUBLE  -- PAC: IRF Actual Costs,
  "pac_irf_actual_costs_as_of_total_actual_costs" DOUBLE  -- PAC: IRF Actual Costs As % Of Total Actual Costs,
  "pac_irf_per_capita_actual_costs" DOUBLE  -- PAC: IRF Per Capita Actual Costs,
  "pac_irf_per_user_actual_costs" DOUBLE  -- PAC: IRF Per User Actual Costs,
  "pac_irf_standardized_costs" DOUBLE  -- PAC: IRF Standardized Costs,
  "pac_irf_standardized_costs_as_of_total_standardized_costs" DOUBLE  -- PAC: IRF Standardized Costs As % Of Total Standardized Costs,
  "pac_irf_per_capita_standardized_costs" DOUBLE  -- PAC: IRF Per Capita Standardized Costs,
  "pac_irf_per_user_standardized_costs" DOUBLE  -- PAC: IRF Per User Standardized Costs,
  "n__pac_irf_users_with_a_covered_stay" DOUBLE  -- # PAC: IRF Users (with A Covered Stay),
  "n__of_beneficiaries_using_pac_irf" DOUBLE  -- % Of Beneficiaries Using PAC: IRF,
  "pac_irf_covered_stays_per_1000_beneficiaries" DOUBLE  -- PAC: IRF Covered Stays Per 1000 Beneficiaries,
  "pac_irf_covered_days_per_1000_beneficiaries" DOUBLE  -- PAC: IRF Covered Days Per 1000 Beneficiaries,
  "pac_snf_actual_costs" DOUBLE  -- PAC: SNF Actual Costs,
  "pac_snf_actual_costs_as_of_total_actual_costs" DOUBLE  -- PAC: SNF Actual Costs As % Of Total Actual Costs,
  "pac_snf_per_capita_actual_costs" DOUBLE  -- PAC: SNF Per Capita Actual Costs,
  "pac_snf_per_user_actual_costs" DOUBLE  -- PAC: SNF Per User Actual Costs,
  "pac_snf_standardized_costs" DOUBLE  -- PAC: SNF Standardized Costs,
  "pac_snf_standardized_costs_as_of_total_standardized_costs" DOUBLE  -- PAC: SNF Standardized Costs As % Of Total Standardized Costs,
  "pac_snf_per_capita_standardized_costs" DOUBLE  -- PAC: SNF Per Capita Standardized Costs,
  "pac_snf_per_user_standardized_costs" DOUBLE  -- PAC: SNF Per User Standardized Costs,
  "n__pac_snf_users_with_a_covered_stay" DOUBLE  -- # PAC: SNF Users (with A Covered Stay),
  "n__of_beneficiaries_using_pac_snf" DOUBLE  -- % Of Beneficiaries Using PAC: SNF,
  "pac_snf_covered_stays_per_1000_beneficiaries" DOUBLE  -- PAC: SNF Covered Stays Per 1000 Beneficiaries,
  "pac_snf_covered_days_per_1000_beneficiaries" DOUBLE  -- PAC: SNF Covered Days Per 1000 Beneficiaries,
  "pac_hh_actual_costs" DOUBLE  -- PAC: HH Actual Costs,
  "pac_hh_actual_costs_as_of_total_actual_costs" DOUBLE  -- PAC: HH Actual Costs As % Of Total Actual Costs,
  "pac_hh_per_capita_actual_costs" DOUBLE  -- PAC: HH Per Capita Actual Costs,
  "pac_hh_per_user_actual_costs" DOUBLE  -- PAC: HH Per User Actual Costs,
  "pac_hh_standardized_costs" DOUBLE  -- PAC: HH Standardized Costs,
  "pac_hh_standardized_costs_as_of_total_standardized_costs" DOUBLE  -- PAC: HH Standardized Costs As % Of Total Standardized Costs,
  "pac_hh_per_capita_standardized_costs" DOUBLE  -- PAC: HH Per Capita Standardized Costs,
  "pac_hh_per_user_standardized_costs" DOUBLE  -- PAC: HH Per User Standardized Costs,
  "n__pac_hh_users" DOUBLE  -- # PAC: HH Users,
  "n__of_beneficiaries_using_pac_hh" DOUBLE  -- % Of Beneficiaries Using PAC: HH,
  "pac_hh_episodes_per_1000_beneficiaries" DOUBLE  -- PAC: HH Episodes Per 1000 Beneficiaries,
  "pac_hh_visits_per_1000_beneficiaries" DOUBLE  -- PAC: HH Visits Per 1000 Beneficiaries,
  "hospice_actual_costs" DOUBLE,
  "hospice_actual_costs_as_of_total_actual_costs" DOUBLE  -- Hospice Actual Costs As % Of Total Actual Costs,
  "hospice_per_capita_actual_costs" DOUBLE,
  "hospice_per_user_actual_costs" DOUBLE,
  "hospice_standardized_costs" DOUBLE,
  "hospice_standardized_costs_as_of_total_standardized_costs" DOUBLE  -- Hospice Standardized Costs As % Of Total Standardized Costs,
  "hospice_per_capita_standardized_costs" DOUBLE,
  "hospice_per_user_standardized_costs" DOUBLE,
  "n__hospice_users_with_a_covered_stay" DOUBLE  -- # Hospice Users (with A Covered Stay),
  "n__of_beneficiaries_using_hospice" DOUBLE  -- % Of Beneficiaries Using Hospice,
  "hospice_covered_stays_per_1000_beneficiaries" DOUBLE,
  "hospice_covered_days_per_1000_beneficiaries" DOUBLE,
  "op_actual_costs" DOUBLE,
  "op_actual_costs_as_of_total_actual_costs" DOUBLE  -- OP Actual Costs As % Of Total Actual Costs,
  "op_per_capita_actual_costs" DOUBLE,
  "op_per_user_actual_costs" DOUBLE,
  "op_standardized_costs" DOUBLE,
  "op_standardized_costs_as_of_total_standardized_costs" DOUBLE  -- OP Standardized Costs As % Of Total Standardized Costs,
  "op_per_capita_standardized_costs" DOUBLE,
  "op_per_user_standardized_costs" DOUBLE,
  "n__op_users" DOUBLE  -- # OP Users,
  "n__of_beneficiaries_using_op" DOUBLE  -- % Of Beneficiaries Using OP,
  "op_visits_per_1000_beneficiaries" DOUBLE,
  "fqhc_rhc_actual_costs" DOUBLE,
  "fqhc_rhc_actual_costs_as_of_total_actual_costs" DOUBLE  -- FQHC/RHC Actual Costs As % Of Total Actual Costs,
  "fqhc_rhc_per_capita_actual_costs" DOUBLE,
  "fqhc_rhc_per_user_actual_costs" DOUBLE,
  "fqhc_rhc_standardized_costs" DOUBLE,
  "fqhc_rhc_standardized_costs_as_of_total_standardized_costs" DOUBLE  -- FQHC/RHC Standardized Costs As % Of Total Standardized Costs
);