Baselight

Medicare FFS Beneficiary Utilization And Costs

2007-2014 Washington State and Counties

@kaggle.thedevastator_medicare_ffs_beneficiary_utilization_and_costs

Loading...
Loading...

About this Dataset

Medicare FFS Beneficiary Utilization And Costs


Medicare FFS Beneficiary Utilization and Costs

2007-2014 Washington State and Counties

By Health [source]


About this dataset

This dataset contains info on the number of Medicare Fee-for-Service Beneficiaries (FFS) receiving healthcare services from hospitals, physicians, and other providers, as well as their associated charges and payments. It provides in-depth, detailed demographics like age group, gender, all kinds of race/ethinicity data and geographical regions. This information can be used to better understand existing health disparities among Medicare FFS beneficiaries across the U.S., examine trends in utilization over time to identify areas where changes are needed within the system or research a wide range of policy issues in healthcare

More Datasets

For more datasets, click here.

Featured Notebooks

  • 🚨 Your notebook can be here! 🚨!

How to use the dataset

This dataset provides a look into Medicare Fee-for-Service beneficiaries in health services being utilized by those enrolled in the Medicare program. The information included can help to paint a picture of how Medicare recipients are using health services, such as hospital and physician visits, laboratory tests and procedures, prescription drugs and imaging services.

In order to make the most use of this data set for research or analysis purposes, there are several key pieces of information that should be taken into account. This includes examining both utilization data (such as the numbers of recommended specific procedures) as well as cost components (such as fee schedules). Specifics within this data set include the average estimated Submitted Charges for each procedure code from nationwide claims from 2011 to 2018.

When looking at utilization portion of this dataset it is important to consider:
• Total number of services provided for each condition identified by ICD-9 or ICD10 code
• Average total service minutes per beneficiary / patient with national average levels listed across five years throughout the period previously mentioned • Percentage change across accessed service types over time period wherein 2011 have been viewed versus more recent statistics • Top five provider specialty types who render service • Number of facilities providing care on annual basis along with percentages utilizing Rural Health Centers grouped together categories including but not exclusive not limited to metropolitan areas; counties; Congressional Districts ; Regions; states plus other geographic entities • Age groups who have used these facilities based on gender plus new acute admissions reported same time frame

A secondary component yet equally important component regarding fees associated with different medical therapies should be considered additionally when uses dataset  which includes:

• Amounts charged by certain facilities based upon current expenses related dates whether patient purchased generic version or brand-name medication due its additional costs relates most significantly towards said medication choices National level along with regional percentage splits relating drug alternatives utilized per given month Actual recharge associated calculated mechanism/formulae , sometimes may refer UPFS methodology Those charges represent sum total averages against whom paid expense examples include: Part B drugs recipients outpatient surgeries & facility visits Note future amounts collected depend upon patients Choice whether require certain distinct E&M codes sometimes need submit ancillary components( diagnoses codes ) separate selections meant cater both facility site & practitioner’s overall needs Sometimes technology assigns relative value unit ( RVU ) defining severity factors linked coding differing specialties so their respective fields well documented Finally analyzing any detail reporting requirements varying specialties

Research Ideas

  • Analyze various patterns in health services utilization by Medicare beneficiaries to provide insight into the most commonly used services and ways to improve care.
  • Track the number of Medicare beneficiaries using each type of health service in order to identify potential underserved populations or areas with high usage levels that necessitate additional coverage or resources.
  • Identify regional differences in provider use rates and payment amounts for specific types of health services, which can help inform efforts to improve equity and access across different geographical regions

Acknowledgements

If you use this dataset in your research, please credit the original authors.
Data Source

License

License: Open Database License (ODbL) v1.0

  • You are free to:
    • Share - copy and redistribute the material in any medium or format.
    • Adapt - remix, transform, and build upon the material for any purpose, even commercially.
  • You must:
    • Give appropriate credit - Provide a link to the license, and indicate if changes were made.
    • ShareAlike - You must distribute your contributions under the same license as the original.
    • Keep intact - all notices that refer to this license, including copyright notices.
    • No Derivatives - If you remix, transform, or build upon the material, you may not distribute the modified material.
    • No additional restrictions - You may not apply legal terms or technological measures that legally restrict others from doing anything the license permits.

Columns

Acknowledgements

If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit Health.

Tables

Utilization And Costs Of Health Services For Medicare, 03d75a14

@kaggle.thedevastator_medicare_ffs_beneficiary_utilization_and_costs.utilization_and_costs_of_health_services_for_medicare__03d75a14
  • 466.51 KB
  • 320 rows
  • 208 columns
Loading...

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
);

Share link

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