About this Dataset

National Joint Registry Annual Report 2019

The National Joint Registry (NJR) for England, Wales, Northern Ireland, the Isle of Man and Guernsey, collects information on hip, knee, ankle, elbow and shoulder joint replacement surgery and monitors the performance of joint replacement implants. The NJR started collecting data in April 2003 and submission for NHS organisations has been mandatory since April 2011. The NJR is hosted by the Healthcare Quality Improvement Partnership (HQIP) and overseen by a Steering Committee (NJRSC), which is designated as an NHS England (NHS E) ‘Expert Committee’. The NJRSC Chairman reports directly to the NHS E Medical Director. NJR core services are managed under two contracts held with: NEC Software Solutions: for collection and management of data and technology and the University of Bristol: for provision of statistical support and analysis of data, to support NJR outcome monitoring, research activity and publications. The NJR management team, hosted by the Healthcare Improvement Quality Partnership (HQIP), is responsible for overall operational and contract management of the NJR and for supporting the work of the NJRSC and its sub-committees. Hip, knee, ankle, elbow and shoulder joint replacements have become more common and are generally highly successful operations that bring many patients improved mobility and relief from pain. Many thousands of such operations take place in the UK each year. A wide range of implants can be used in the joint replacement operations. The registry helps to monitor the performance of these implants and the effectiveness of different types of surgery, improving clinical standards and benefiting patients, clinicians and the orthopaedic sector as a whole. The NJR currently collects data on all hip, knee, ankle, elbow and shoulder joint replacements across both the NHS, and the independent healthcare sector.
Publisher name: Healthcare Quality Improvement Partnership
Last updated: 2024-06-14T04:02:57Z

Tables

Data Field Descriptors

@ukgov.national_joint_registry_annual_report_2019.data_field_descriptors

15.02 KB
8 rows
17 columns


CREATE TABLE data_field_descriptors (
  "n__field_description_national_joint_registry_annual_re_90738a77" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR
);

NJR Annual Report 2019 Transparency Data

@ukgov.national_joint_registry_annual_report_2019.njr_annual_report_2019_transparency_data

35.29 KB
398 rows
22 columns


CREATE TABLE njr_annual_report_2019_transparency_data (
  "trust_company" VARCHAR,
  "compliance" VARCHAR,
  "hospital" VARCHAR,
  "no_of_procedures_2018" DOUBLE,
  "no_of_consultants_2018" DOUBLE,
  "consent_rate_2018" VARCHAR,
  "linkability_2018" VARCHAR,
  "average_asa_grade_2018" DOUBLE,
  "percentage_male_patients_2018" VARCHAR,
  "average_age_at_operation_2018" DOUBLE,
  "outliers_90_day_mortality_hip" VARCHAR,
  "outliers_hip_revision_rate_since_2009" DOUBLE,
  "outliers_hip_revision_rate_since_2014" DOUBLE,
  "outliers_90_day_mortality_knees" VARCHAR,
  "outliers_knee_revision_rate_since_2009" DOUBLE,
  "outliers_knee_revision_rate_since_2014" DOUBLE,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "revision_rate_since_2009_5" DOUBLE,
  "revision_rate_since_2014_6" DOUBLE,
  "revision_rate_since_2009_5_1" DOUBLE,
  "revision_rate_since_2014_6_1" DOUBLE
);