About this Dataset

National Diabetes Inpatient Audit (NaDIA) - 2018

The information available from this webpage comes from the National Diabetes Inpatient Audit. The National Diabetes Inpatient Audit is a snapshot audit of diabetes inpatient care. During September and October 2018, hospitals across England and Wales collected data on the characteristics of the hospital, including participation, staffing levels and care improvement initiatives. 2018 was a designated NaDIA Quality Improvement Collaborative (QIC) year. To reduce the burden on QIC participants, the NaDIA 2018 collection undertook the Hospital Characteristics (HC) survey only. # Making clinical audit data transparent In his transparency and open data letter to Cabinet Ministers on 7 July 2011, the Prime Minister made a commitment to make clinical audit data available from the national audits within the National Clinical Audit and Patient Outcomes Programme. # What information is being made available? National Diabetes Inpatient Audit data for 2018 is available at hospital site level for: * Audit participation * Measures of staffing levels and care improvement initiatives. These data do not list individual patient information nor do they contain any patient identifiable data. # Using and interpreting the data Data from the National Diabetes Inpatient Audit should not be looked at in isolation when assessing standards of care. # Accessing the data The data are being made available on the data.gov website. Each year a data file from the National Diabetes Inpatient Audit will be made available in CSV format. Hospitals are identified by name and their national code. # What does the data cover? The audit looks at the following areas: * Participation in the audit * Inpatient staffing levels * Take-up of care improvement initiatives # What period does the data cover? This report covers hospital characteristics during September and October 2018. The audit report was published on 9 May 2019. Historic data is available for previous audit years (2010-2013, 2015-2017) where survey questions were comparable.
Publisher name: NHS Digital
Last updated: 2024-09-14T12:26:45Z

Tables

NaDIA 2018 - Hospital Characteristics Report - Open Data

@ukgov.national_diabetes_inpatient_audit_nadia_2018.nadia_2018_hospital_characteristics_report_open_data

29.23 KB
185 rows
25 columns


CREATE TABLE nadia_2018_hospital_characteristics_report_open_data (
  "hospital_name" VARCHAR,
  "hospital_id" VARCHAR,
  "audit_year" BIGINT,
  "hospital_beds" VARCHAR,
  "diabetes_patients_ba_2017" VARCHAR,
  "disn_hours" VARCHAR,
  "dsn_hours" VARCHAR,
  "specialist_diabetes_dietitian_hours" VARCHAR,
  "non_specialist_dietitian_hours" VARCHAR,
  "podiatrist_hours" VARCHAR,
  "pharmacist_hours" VARCHAR,
  "consultant_hours" VARCHAR,
  "n_7_day_disn_cover" VARCHAR,
  "n_7_day_diabetes_physician_access" VARCHAR,
  "regular_diabetes_mortality_and_morbidity_meetings" VARCHAR,
  "regular_ward_nurse_diabetes_training" VARCHAR,
  "systems_tools_to_increase_foot_exams" VARCHAR,
  "established_mdft" VARCHAR,
  "using_electronic_patient_record" VARCHAR,
  "using_electronic_prescribing" VARCHAR,
  "using_remote_blood_glucose_monitoring" VARCHAR,
  "successfully_applied_for_mdft_transformation_funding" VARCHAR,
  "successfully_applied_for_disn_transformation_funding" VARCHAR,
  "used_mdft_transformation_funding_to_fund_additional_posts" VARCHAR,
  "used_disn_transformation_funding_to_fund_additional_posts" VARCHAR
);

NaDIA 2018 - Hospital Characteristics Report - Open Data Field List

@ukgov.national_diabetes_inpatient_audit_nadia_2018.nadia_2018_hospital_characteristics_report_open_field_list

3.73 KB
25 rows
3 columns


CREATE TABLE nadia_2018_hospital_characteristics_report_open_field_list (
  "data_field_name" VARCHAR,
  "data_field_type" VARCHAR,
  "data_field_notes" VARCHAR
);

NaDIA 2018 - Hospital Characteristics Responses - Open Data

@ukgov.national_diabetes_inpatient_audit_nadia_2018.nadia_2018_hospital_characteristics_responses_open_data

96.34 KB
241 rows
91 columns


CREATE TABLE nadia_2018_hospital_characteristics_responses_open_data (
  "provider_code" VARCHAR,
  "provider_name" VARCHAR,
  "participation_2010" VARCHAR,
  "participation_2011" VARCHAR,
  "participation_2012" VARCHAR,
  "participation_2013" VARCHAR,
  "participation_2015" VARCHAR,
  "participation_2016" VARCHAR,
  "participation_2017" VARCHAR,
  "participation_2018" VARCHAR,
  "hospital_beds_2010" DOUBLE,
  "hospital_beds_2011" DOUBLE,
  "hospital_beds_2012" DOUBLE,
  "hospital_beds_2013" DOUBLE,
  "hospital_beds_2015" DOUBLE,
  "hospital_beds_2016" DOUBLE,
  "hospital_beds_2017" DOUBLE,
  "hospital_beds_2018" DOUBLE,
  "disn_wte_2015" DOUBLE,
  "disn_wte_2016" DOUBLE,
  "disn_wte_2017" DOUBLE,
  "disn_wte_2018" DOUBLE,
  "dsn_wte_2015" DOUBLE,
  "dsn_wte_2016" DOUBLE,
  "dsn_wte_2017" DOUBLE,
  "dsn_wte_2018" DOUBLE,
  "specialist_diabetes_dietician_wte_2015" DOUBLE,
  "specialist_diabetes_dietician_wte_2016" DOUBLE,
  "specialist_diabetes_dietician_wte_2017" DOUBLE,
  "specialist_diabetes_dietician_wte_2018" DOUBLE,
  "non_specialist_dietician_wte_2015" DOUBLE,
  "non_specialist_dietician_wte_2016" DOUBLE,
  "non_specialist_dietician_wte_2017" DOUBLE,
  "non_specialist_dietician_wte_2018" DOUBLE,
  "podiatrist_wte_2015" DOUBLE,
  "podiatrist_wte_2016" DOUBLE,
  "podiatrist_wte_2017" DOUBLE,
  "podiatrist_wte_2018" DOUBLE,
  "diabetes_specialist_pharmacist_wte_2015" DOUBLE,
  "diabetes_specialist_pharmacist_wte_2016" DOUBLE,
  "diabetes_specialist_pharmacist_wte_2017" DOUBLE,
  "diabetes_specialist_pharmacist_wte_2018" DOUBLE,
  "diabetes_consultant_wte_2015" DOUBLE,
  "diabetes_consultant_wte_2016" DOUBLE,
  "diabetes_consultant_wte_2017" DOUBLE,
  "diabetes_consultant_wte_2018" DOUBLE,
  "disn_7_day_cover_2015" VARCHAR,
  "disn_7_day_cover_2016" VARCHAR,
  "disn_7_day_cover_2017" VARCHAR,
  "disn_7_day_cover_2018" VARCHAR,
  "diabetes_physician_7_day_cover_2016" VARCHAR,
  "diabetes_physician_7_day_cover_2017" VARCHAR,
  "diabetes_physician_7_day_cover_2018" VARCHAR,
  "m_m_meeting_held_2017" VARCHAR,
  "m_m_meeting_held_2018" VARCHAR,
  "ward_nurse_training_2013" VARCHAR,
  "ward_nurse_training_2015" VARCHAR,
  "ward_nurse_training_2016" VARCHAR,
  "ward_nurse_training_2017" VARCHAR,
  "ward_nurse_training_2018" VARCHAR,
  "tools_systems_to_increase_foot_exams_2015" VARCHAR,
  "tools_systems_to_increase_foot_exams_2016" VARCHAR,
  "tools_systems_to_increase_foot_exams_2017" VARCHAR,
  "tools_systems_to_increase_foot_exams_2018" VARCHAR,
  "mdft_2010" VARCHAR,
  "mdft_2011" VARCHAR,
  "mdft_2012" VARCHAR,
  "mdft_2013" VARCHAR,
  "mdft_2015" VARCHAR,
  "mdft_2016" VARCHAR,
  "mdft_2017" VARCHAR,
  "mdft_2018" VARCHAR,
  "epr_2013" VARCHAR,
  "epr_2015" VARCHAR,
  "epr_2016" VARCHAR,
  "epr_2017" VARCHAR,
  "epr_2018" VARCHAR,
  "electronic_prescribing_2013" VARCHAR,
  "electronic_prescribing_2015" VARCHAR,
  "electronic_prescribing_2016" VARCHAR,
  "electronic_prescribing_2017" VARCHAR,
  "electronic_prescribing_2018" VARCHAR,
  "remote_bgm_2013" VARCHAR,
  "remote_bgm_2015" VARCHAR,
  "remote_bgm_2016" VARCHAR,
  "remote_bgm_2017" VARCHAR,
  "remote_bgm_2018" VARCHAR,
  "transformation_funding_application_successful_mdfts" VARCHAR,
  "transformation_funding_application_successful_disns" VARCHAR,
  "transformation_funding_used_for_additional_posts_mdfts" VARCHAR,
  "transformation_funding_used_for_additional_posts_disns" VARCHAR
);

NaDIA 2018 - Hospital Characteristics Responses - Open Data Field List

@ukgov.national_diabetes_inpatient_audit_nadia_2018.nadia_2018_hospital_characteristics_responses_open_field_list

5.92 KB
89 rows
3 columns


CREATE TABLE nadia_2018_hospital_characteristics_responses_open_field_list (
  "data_field_name" VARCHAR,
  "data_field_type" VARCHAR,
  "data_field_notes" VARCHAR
);