Medicare FFS Beneficiary Utilization And Costs
2007-2014 Washington State and Counties
@kaggle.thedevastator_medicare_ffs_beneficiary_utilization_and_costs
2007-2014 Washington State and Counties
@kaggle.thedevastator_medicare_ffs_beneficiary_utilization_and_costs
CREATE TABLE utilization_and_costs_of_health_services_for_medicare__03d75a14 (
"index" BIGINT,
"county" VARCHAR,
"n__to_sort_by_county_and_year" DOUBLE,
"n__to_sort_by_year_and_county" DOUBLE,
"year" BIGINT,
"state_and_county_fips_code" VARCHAR,
"total_actual_costs" VARCHAR,
"total_standardized_costs" VARCHAR,
"total_standardized_risk_adjusted_costs" VARCHAR,
"actual_per_capita_costs" VARCHAR,
"standardized_per_capita_costs" VARCHAR,
"standardized_risk_adjusted_per_capita_costs" VARCHAR,
"ip_actual_costs" VARCHAR,
"ip_actual_costs_as_of_total_actual_costs" VARCHAR,
"ip_per_capita_actual_costs" VARCHAR,
"ip_per_user_actual_costs" VARCHAR,
"ip_standardized_costs" VARCHAR,
"ip_standardized_costs_as_of_total_standardized_costs" VARCHAR,
"ip_per_capita_standardized_costs" VARCHAR,
"ip_per_user_standardized_costs" VARCHAR,
"ip_users_with_a_covered_stay" VARCHAR,
"n__of_beneficiaries_using_ip" VARCHAR,
"ip_covered_stays_per_1000_beneficiaries" BIGINT,
"ip_covered_days_per_1000_beneficiaries" BIGINT,
"pac_ltch_actual_costs" VARCHAR,
"pac_ltch_actual_costs_as_of_total_actual_costs" VARCHAR,
"pac_ltch_per_capita_actual_costs" VARCHAR,
"pac_ltch_per_user_actual_costs" VARCHAR,
"pac_ltch_standardized_costs" VARCHAR,
"pac_ltch_standardized_costs_as_of_total_standardized_costs" VARCHAR,
"pac_ltch_per_capita_standardized_costs" VARCHAR,
"pac_ltch_per_user_standardized_costs" VARCHAR,
"n__pac_ltch_users_with_a_covered_stay" DOUBLE,
"n__of_beneficiaries_using_pac_ltch" VARCHAR,
"pac_ltch_covered_stays_per_1000_beneficiaries" DOUBLE,
"pac_ltch_covered_days_per_1000_beneficiaries" DOUBLE,
"pac_irf_actual_costs" VARCHAR,
"pac_irf_actual_costs_as_of_total_actual_costs" VARCHAR,
"pac_irf_per_capita_actual_costs" VARCHAR,
"pac_irf_per_user_actual_costs" VARCHAR,
"pac_irf_standardized_costs" VARCHAR,
"pac_irf_standardized_costs_as_of_total_standardized_costs" VARCHAR,
"pac_irf_per_capita_standardized_costs" VARCHAR,
"pac_irf_per_user_standardized_costs" VARCHAR,
"n__pac_irf_users_with_a_covered_stay" DOUBLE,
"n__of_beneficiaries_using_pac_irf" VARCHAR,
"pac_irf_covered_stays_per_1000_beneficiaries" DOUBLE,
"pac_irf_covered_days_per_1000_beneficiaries" DOUBLE,
"pac_snf_actual_costs" VARCHAR,
"pac_snf_actual_costs_as_of_total_actual_costs" VARCHAR,
"pac_snf_per_capita_actual_costs" VARCHAR,
"pac_snf_per_user_actual_costs" VARCHAR,
"pac_snf_standardized_costs" VARCHAR,
"pac_snf_standardized_costs_as_of_total_standardized_costs" VARCHAR,
"pac_snf_per_capita_standardized_costs" VARCHAR,
"pac_snf_per_user_standardized_costs" VARCHAR,
"n__pac_snf_users_with_a_covered_stay" BIGINT,
"n__of_beneficiaries_using_pac_snf" VARCHAR,
"pac_snf_covered_stays_per_1000_beneficiaries" BIGINT,
"pac_snf_covered_days_per_1000_beneficiaries" BIGINT,
"pac_hh_actual_costs" VARCHAR,
"pac_hh_actual_costs_as_of_total_actual_costs" VARCHAR,
"pac_hh_per_capita_actual_costs" VARCHAR,
"pac_hh_per_user_actual_costs" VARCHAR,
"pac_hh_standardized_costs" VARCHAR,
"pac_hh_standardized_costs_as_of_total_standardized_costs" VARCHAR,
"pac_hh_per_capita_standardized_costs" VARCHAR,
"pac_hh_per_user_standardized_costs" VARCHAR,
"n__pac_hh_users" DOUBLE,
"n__of_beneficiaries_using_pac_hh" VARCHAR,
"pac_hh_episodes_per_1000_beneficiaries" DOUBLE,
"pac_hh_visits_per_1000_beneficiaries" DOUBLE,
"hospice_actual_costs" VARCHAR,
"hospice_actual_costs_as_of_total_actual_costs" VARCHAR,
"hospice_per_capita_actual_costs" VARCHAR,
"hospice_per_user_actual_costs" VARCHAR,
"hospice_standardized_costs" VARCHAR,
"hospice_standardized_costs_as_of_total_standardized_costs" VARCHAR,
"hospice_per_capita_standardized_costs" VARCHAR,
"hospice_per_user_standardized_costs" VARCHAR,
"n__hospice_users_with_a_covered_stay" DOUBLE,
"n__of_beneficiaries_using_hospice" VARCHAR,
"hospice_covered_stays_per_1000_beneficiaries" DOUBLE,
"hospice_covered_days_per_1000_beneficiaries" DOUBLE,
"op_actual_costs" VARCHAR,
"op_actual_costs_as_of_total_actual_costs" VARCHAR,
"op_per_capita_actual_costs" VARCHAR,
"op_per_user_actual_costs" VARCHAR,
"op_standardized_costs" VARCHAR,
"op_standardized_costs_as_of_total_standardized_costs" VARCHAR,
"op_per_capita_standardized_costs" VARCHAR,
"op_per_user_standardized_costs" VARCHAR,
"n__op_users" BIGINT,
"n__of_beneficiaries_using_op" VARCHAR,
"op_visits_per_1000_beneficiaries" BIGINT,
"fqhc_rhc_actual_costs" VARCHAR,
"fqhc_rhc_actual_costs_as_of_total_actual_costs" VARCHAR,
"fqhc_rhc_per_capita_actual_costs" VARCHAR,
"fqhc_rhc_per_user_actual_costs" VARCHAR,
"fqhc_rhc_standardized_costs" VARCHAR
);
Anyone who has the link will be able to view this.