Hospital Complication Rates for Hip and Knee Replacement Patients

$199 / year

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.

Complexity

This hospital compare dataset 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. It assesses a broad set of healthcare activities that affect patients’ well-being. The outcome of the measures captures eight different complications, each within a specific and clinically meaningful time period, during which the outcome can be attributed to the hospital that performed the procedure.

The dataset provides information on the quality of care hospitals are providing to their patients, and inform providers of opportunities to improve care and strengthen incentives for quality improvement. This data allows patients and consumers to better select hospitals at which to have their surgical procedure, and directly compare performance measure information related to hip and knee related procedures. The dataset identifies health care complication rates of over 4,000 hospitals, including acute care hospitals, critical access hospitals, children’s hospitals, VA Medical Centers, and hospital outpatient departments.

Date Created

2015-05-31

Last Modified

2018-01-26

Version

2018-01-26

Update Frequency

Quarterly

Temporal Coverage

2013-2016

Spatial Coverage

United States

Source

John Snow Labs => Medicare.gov

Source License URL

John Snow Labs Standard License

Source License Requirements

N/A

Source Citation

N/A

Keywords

Hip Knee Complication Measures, Hip Knee Serious Complications, Total Knee Arthroplasty Procedures, TKA Surgery Complications, Recovery From Hip Surgery, Hip Joint Conditions

Other Titles

Hospital Complication Rates for Hip Surgery and Knee Replacement Patients, Hospital Complication Rates for Recovery From Hip and Knee Replacement Patients, Hospital Complication Rates for Hip Joint and Knee Replacement Patients

Name Description Type Constraints
Provider_IDCenter for Medicare & Medicaid Services (CMS) certification number (CCN). Identification number of the facility within the CMS dataset. The CCN for providers and suppliers is a 6 digit number. The first 2 digits identify the State in which the provider is located. The last 4 digits identify the type of facility.stringrequired : 1
Hospital_NameThe name of the hospital (also referred to as the provider)stringrequired : 1
AddressThe main address of the hospitalstringrequired : 1
CityThe city in the mailing address of the hospitalstringrequired : 1
StateThe full name of the state in the mailing address of the hospital.stringrequired : 1
State_AbbreviationThe two-letter abbreviations of the state in the mailing address of the hospital. This includes information on hospitals in: All 50 states, District of Columbia (DC), Puerto Rico (PR), Virgin Islands (VA), Canada, Mexico (MX), American Samoa (AS), Guam (GU), and Commonwealth of the Northern Marianas Islands (MP)stringrequired : 1
ZIP_CodeThe postal Zip code in the mailing address of the hospitalintegerrequired : 1 level : Nominal
CountyThe county where the hospital is locatedstring-
Phone_NumberThe main phone number of the hospitalintegerrequired : 1 level : Nominal
Measure_NameThe name of the Patient Safety Indicators (PSIs).PSIs are the measures of serious complications set by the Agency for Healthcare Research and Quality.stringrequired : 1
Measure_IDThe identification (ID) of the Patient Safety Indicators (PSIs). PSIs are the measures of serious complications set by the Agency for Healthcare Research and Quality.stringrequired : 1
Compared_to_NationalThe hospital’s interval estimate is compared to the national hip/knee complication rate.If the interval estimate includes the national observed hip/knee complication rate, the hospital’s performance is in the “no different than national rate” category. If the entire interval estimate is below the national observed hip/knee complication rate, then the hospital is performing “better than national rate”.If the entire interval estimate is above the national observed hip/knee complication rate, its performance is “worse than national rate”.Hospitals with fewer than 25 eligible cases are placed into a separate category that indicates that the hospital doesn't have enough cases to reliably tell how well the hospital is performing.string-
DenominatorThe number of admissions with a complication expected based on the nation’s performance with that hospital’s case mix.integerlevel : Ratio
ScoreThe overall score for serious complications is based on how often adult patients had certain serious, but potentially preventable, complications related to medical or surgical inpatient hospital care.numberlevel : Ratio
Lower_EstimateLower interval estimate of the hospital’s hip/knee complication rate within an applicable time periodnumberlevel : Nominal
Higher_EstimateHigher interval estimate of the hospital’s hip/knee complication rate within an applicable time periodnumberlevel : Nominal
FootnoteFootnote describes an additional piece of information given separately for the compiled data.string-
Measure_Start_DateThe first day the data measures were collected. Complications were measured within specific times because complications over a longer period may be impacted by factors outside the hospitals’ control like other complicating illnesses, patients’ own behavior, or care provided to patients after discharge. The date format is YYY-MM-DD.daterequired : 1
Measure_End_DateThe last day the data measures were collected. The date format is YYY-MM-DD.daterequired : 1
ICD10_CodeThe International Classification of Diseases ICD-10 code/codes for the specific measure.stringrequired : 1
ICD10_DescriptionDescription used by physicians and other healthcare providers to classify and code all diagnoses, symptoms and procedures recorded in conjunction with hospital care.stringrequired : 1
HCPCS_CodeThe Healthcare Common Procedure Coding System (HCPCS) code/codes for the specific measure.string-
HCPCS_DescriptionDescription of the Level II of the HCPCS standardized coding system that is used primarily to identify products, supplies, and services not included in the CPT codes, such as ambulance services and durable medical equipment, prosthetics, orthotics, and supplies (DMEPOS) when used outside a physician's office.string-
LatitudeIdentifies the geographical location Latitude.-
LongitudeIdentifies the geographical location Longitude.-
Provider_IDHospital_NameAddressCityStateState_AbbreviationZIP_CodeCountyPhone_NumberMeasure_NameMeasure_IDCompared_to_NationalDenominatorScoreLower_EstimateHigher_EstimateFootnoteMeasure_Start_DateMeasure_End_DateICD10_CodeICD10_DescriptionHCPCS_CodeHCPCS_DescriptionLatitudeLongitude
360098LAKE HEALTH7590 AUBURN ROADCONCORDOhioOH44077LAKE4409539600Pressure soresPSI_3_ULCERNo Different than the National Rate49400.080.512014-07-012015-09-30I96Gangrene, not elsewhere classified
450210ETMC CARTHAGE409 WEST COTTAGECARTHAGETexasTX75633PANOLA936933841Pressure soresPSI_3_ULCERNo Different than the National Rate2020.240.992014-07-012015-09-30I96Gangrene, not elsewhere classified
240206RED LAKE HOSPITAL APO BOX 497REDLAKEMinnesotaMN56671BELTRAMI2186793912Pressure soresPSI_3_ULCERNo Different than the National Rate370.251.022014-07-012015-09-30I96Gangrene, not elsewhere classified
070029BRISTOL HOSPITALBREWSTER RDBRISTOLConnecticutCT6010HARTFORD8605853000Pressure soresPSI_3_ULCERNo Different than the National Rate20790.140.712014-07-012015-09-30I96Gangrene, not elsewhere classified
170166MORTON COUNTY HOSPITAL445 N HILLTOPELKHARTKansasKS67950MORTON6206972141Pressure soresPSI_3_ULCERNo Different than the National Rate1580.240.992014-07-012015-09-30I96Gangrene, not elsewhere classified
030074SELLS HOSPITALHIGHWAY 86, AT TOPAWA ROADSELLSArizonaAZ85634PIMA5203627003Pressure soresPSI_3_ULCERNo Different than the National Rate460.251.022014-07-012015-09-30I96Gangrene, not elsewhere classified
230132HURLEY MEDICAL CENTERONE HURLEY PLAZAFLINTMichiganMI48503GENESEE8102579000Pressure soresPSI_3_ULCERWorse than the National Rate37952.051.582.512014-07-012015-09-30I96Gangrene, not elsewhere classified
010032WEDOWEE HOSPITAL209 NORTH MAIN STREETWEDOWEEAlabamaAL36278RANDOLPH2563572111Pressure soresPSI_3_ULCERNo Different than the National Rate1500.2512014-07-012015-09-30I96Gangrene, not elsewhere classified
180080BAPTIST HEALTH CORBINONE TRILLIUM WAYCORBINKentuckyKY40701KNOX6065281212Pressure soresPSI_3_ULCERNo Different than the National Rate26210.430.972014-07-012015-09-30I96Gangrene, not elsewhere classified
010095HALE COUNTY HOSPITAL508 GREEN STREETGREENSBOROAlabamaAL36744HALE3346243024Pressure soresPSI_3_ULCERNo Different than the National Rate1910.240.982014-07-012015-09-30I96Gangrene, not elsewhere classified