Hip Knee Joint Conditions and Complication Rates

**Overview**
This data package contains information about Average Inpatient Length of Stay for Joint Replacement from 1992-2010 and Discharge Status for Adults and Quality Measures National Statistics of Agency for Healthcare Research and Quality (AHRQ). It also provides information about Principal Diagnoses from 2010-2011 and Trends in Hip and Knee Joint Replacement Procedures from 1991-2010.

**Description**
This data package contains the "The average length of stay for all hip and knee replacements among inpatients that have shown a remarkable decline of at least 50% from 1992 through 2010 from nearly 5 days to just under 4 days. Hip and knee procedures, involve replacement or revision procedures anywhere from the pelvis to the head of the femur and its socket. It can either be replaced or revised to restore movement of the hips and knees that are damaged by osteoarthritis, late-stage degenerative bone and cartilage disease, or other injuries and disease conditions. Most adults with total hip and revision hip replacements are routinely discharged home, but 20% to 30% are discharged to long-term care. Slightly higher rates of persons age 65 years and older go to long-term care. Hip Knee Joint Procedures Quality Measures National Statistics Agency for Healthcare Research and Quality (AHRQ) identifies national statistics outcomes for procedures arthroplasty knee and hip replacement, total and partial; sourced from the AHRQ and the National Hospital Admissions (NHA).

The dataset provides information on health care use, access, outcomes, and costs related to arthroplasty knee and hip, total and partial, procedures. Hospital Complication Rates for Hip and Knee Replacement Patients reports risk-standardized complication measures for elective primary total hip arthroplasty (THA) and/or total knee arthroplasty (TKA) procedures. The goal of the measures is to improve the quality of care delivered to patients undergoing elective primary THA and/or TKA procedures. Hospitalization and Discharge for Arthritis and Rheumatoid Conditions estimates 6.7 million hospitalizations that are associated with a diagnosis of Arthritis and Other Rheumatic Condition (AORC) or 17.3% of all hospitalizations in 2011. Discharge from the hospital to long-term care or home health care occurs more often among AORC-associated hospitalizations than is found among hospitalizations for all causes. Principal Diagnoses Hip and Knee Joint Replacement United States Bone and Joint Initiative (USBJI) provides the associated diagnoses related to cases of total hip replacements, partial hip replacements and total knee replacements done in the United States from 2010 to 2011.

This dataset can be used to provide preventive management for musculoskeletal conditions associated with hip, knee and joint replacement procedures to reduce the incidences of physical disability. State Complication Rates for Hip and Knee Replacement Patients includes state-level data for the hip/knee complication measure, the AHRQ measures of serious complications, and 30-day death rates. Trends in Hip and Knee Joint Replacement Procedures USBJI shows the trend over the last 2 decades (1991-2010) in terms of the growing cases of hip and knee joint replacement procedures that translate to more funding from the United States government for the growing elderly population. The multiple associations of health providers treating musculoskeletal diseases realized the work had only begun, and the USBJI, a part of the Global Alliance for Musculoskeletal Health, was created.

**Benefits**
- Useful for medical care staff and providers, patients, consumers and hospitals. hip knee joint conditions and complication rates database is available on the national hospital discharge survey (nhds), nationwide inpatient sample (nis) and healthcare cost and utilization project (hcup), agency for healthcare research and quality, national hospital admissions, cpi inflation calculator, bureau of labor statistics, united states department of labor and medicare.gov websites in raw form, whereas a jsl customer gets it in clean and normalized form ready to use in one place and create his own custom reports. easy to comprehend for the customers who are unfamiliar with the medical terminologies as all abbreviated terms are replaced with full form, unlike hip knee joint conditions and complication rates original datasets which are full of abbreviations.

**License Information**
The use of John Snow Labs datasets is free for personal and research purposes. For commercial use please subscribe to the [Data Library](https://www.johnsnowlabs.com/marketplace/) on John Snow Labs website. The subscription will allow you to use all John Snow Labs datasets and data packages for commercial purposes.

**Included Datasets**
- [Average Inpatient Length of Stay for Joint Replacement USBJI 1992-2010](https://www.johnsnowlabs.com/marketplace/average-inpatient-length-of-stay-for-joint-replacement-usbji-1992-2010)
- The average length of stay for all hip and knee replacements among inpatients has shown a remarkable decline of at least 50% from 1992 through 2010 from nearly 5 days to just under 4 days, which is shown in this dataset.
- [Discharge Status for Adults 18-65 Hip and Knee Replacements USBJI 2010](https://www.johnsnowlabs.com/marketplace/discharge-status-for-adults-18-65-hip-and-knee-replacements-usbji-2010)
- Most adults with total hip and revision hip replacements are routinely discharged home, but 20% to 30% are discharged to long-term care. Slightly higher rates of persons age 65 years and older go to long-term care. Among patients who undergo a partial hip replacement, nearly half (45%) go to long-term care, with three out of five who are 65 years and older with a partial hip replacement doing so. This dataset showcases about this study results.
- [Hip Knee Joint Procedures Quality Measures National Statistics AHRQ](https://www.johnsnowlabs.com/marketplace/hip-knee-joint-procedures-quality-measures-national-statistics-ahrq)
- This dataset identifies national statistics outcomes for procedures arthroplasty knee and hip replacement, total and partial; sourced from the Agency for Healthcare Research and Quality (AHRQ) and the National Hospital Admissions (NHA).
- [Hospital Complication Rates for Hip and Knee Replacement Patients](https://www.johnsnowlabs.com/marketplace/hospital-complication-rates-for-hip-and-knee-replacement-patients)
- This dataset includes provider data for the hip/knee complication measure, the Agency for Healthcare Research and Quality (AHRQ) measures of serious complications, and 30-day death rates. It has also been enriched with ICD-10 and HCPCS codes with their descriptions.
- [Hospitalization and Discharge for Arthritis and Rheumatoid Conditions](https://www.johnsnowlabs.com/marketplace/hospitalization-and-discharge-for-arthritis-and-rheumatoid-conditions)
- This dataset is from the Healthcare Cost and Utility Project (HCUP) 2011 Nationwide Inpatient Sample (NIS), which estimates 6.7 million hospitalizations that are associated with a diagnosis of Arthritis and Other Rheumatic Condition (AORC) or 17.3% of all hospitalizations that year.
- [Inpatient Arthroplasty Procedures by Type and Sex USBJI 2010-2011](https://www.johnsnowlabs.com/marketplace/inpatient-arthroplasty-procedures-by-type-and-sex-usbji-2010-2011)
- This dataset is provided for both of the two national hospital discharge databases for comparison purposes. Although they vary slightly in the number of cases, overall they provide relatively consistent estimates of inpatient joint replacement procedures. Data comes from the National Hospital Discharge Survey (NHDS) and the Nationwide Inpatient Sample (NIS).
- [Mean Total Hospital Charges Hip Knee Joint Replacement USBJI 1998-2011](https://www.johnsnowlabs.com/marketplace/mean-total-hospital-charges-hip-knee-joint-replacement-usbji-1998-2011)
- This dataset discusses that in spite of shorter hospital stays, mean hospital charges from 1998 through 2011 steadily increased for all hip replacements. Data is from CPI Inflation Calculator, Bureau of Labor Statistics and the United States Department of Labor.
- [National Complication Rates for Hip and Knee Replacement Patients](https://www.johnsnowlabs.com/marketplace/national-complication-rates-for-hip-and-knee-replacement-patients)
- This dataset includes national-level data for the hip/knee complication measure, the Agency for Healthcare Research and Quality (AHRQ) measures of serious complications, and 30-day death rates. It has also been enriched with ICD-10 and HCPCS codes with their descriptions.
- [Principal Diagnoses Hip and Knee Joint Replacement USBJI 2010-2011](https://www.johnsnowlabs.com/marketplace/principal-diagnoses-hip-and-knee-joint-replacement-usbji-2010-2011)
- This dataset provides the associated diagnoses related to cases of total hip replacements, partial hip replacements and total knee replacements done in the United States from 2010 to 2011. This dataset can be used to provide preventive management for musculoskeletal conditions associated with hip, knee and joint replacement procedures to reduce the incidences of physical disability.
- [State Complication Rates for Hip and Knee Replacement Patients](https://www.johnsnowlabs.com/marketplace/state-complication-rates-for-hip-and-knee-replacement-patients)
- This dataset includes state-level data for the hip/knee complication measure, the Agency for Healthcare Research and Quality (AHRQ) measures of serious complications, and 30-day death rates. It has also been enriched with ICD-10 and HCPCS codes with their descriptions.
- [Trends in Hip and Knee Joint Replacement Procedures USBJI 1991-2010](https://www.johnsnowlabs.com/marketplace/trends-in-hip-and-knee-joint-replacement-procedures-usbji-1991-2010)
- This dataset shows the trend over the last 2 decades in terms of the growing cases of hip and knee joint replacement procedures that translate to more funding from the United States government for the growing elderly population. As the US population continues to age in the next 25 years, Hip and Knee Joint replacement and revision procedures will increase because they are most prevalent in the older segments of the population.

**Data Engineering Overview**
**We deliver high-quality data**
- Each dataset goes through 3 levels of quality review
- 2 Manual reviews are done by domain experts
- Then, an automated set of 60+ validations enforces every datum matches metadata & defined constraints
- Data is normalized into one unified type system
- All dates, unites, codes, currencies look the same
- All null values are normalized to the same value
- All dataset and field names are SQL and Hive compliant
- Data and Metadata
- Data is available in both CSV and Apache Parquet format, optimized for high read performance on distributed Hadoop, Spark & MPP clusters
- Metadata is provided in the open Frictionless Data standard, and its every field is normalized & validated
- Data Updates
- Data updates support replace-on-update: outdated foreign keys are deprecated, not deleted

**Our data is curated and enriched by domain experts**

Each dataset is manually curated by our team of doctors, pharmacists, public health & medical billing experts:
- Field names, descriptions, and normalized values are chosen by people who actually understand their meaning
- Healthcare & life science experts add categories, search keywords, descriptions and more to each dataset
- Both manual and automated data enrichment supported for clinical codes, providers, drugs, and geo-locations
- The data is always kept up to date – even when the source requires manual effort to get updates
- Support for data subscribers is provided directly by the domain experts who curated the data sets
- Every data source’s license is manually verified to allow for royalty-free commercial use and redistribution.

**Need Help?**
If you have questions about our products, contact us at [[e-mail]](mailto:[e-mail]).