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.93 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  -- Diabetes Patients (BA 2017),
  "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  -- 7 Day DISN Cover?,
  "n_7_day_diabetes_physician_access" VARCHAR  -- 7 Day Diabetes Physician Access?,
  "regular_diabetes_mortality_and_morbidity_meetings" VARCHAR  -- Regular Diabetes Mortality And Morbidity Meetings?,
  "regular_ward_nurse_diabetes_training" VARCHAR  -- Regular Ward Nurse Diabetes Training?,
  "systems_tools_to_increase_foot_exams" VARCHAR  -- Systems/tools To Increase Foot Exams?,
  "established_mdft" VARCHAR  -- Established MDFT?,
  "using_electronic_patient_record" VARCHAR  -- Using Electronic Patient Record?,
  "using_electronic_prescribing" VARCHAR  -- Using Electronic Prescribing?,
  "using_remote_blood_glucose_monitoring" VARCHAR  -- Using Remote Blood Glucose Monitoring?,
  "successfully_applied_for_mdft_transformation_funding" VARCHAR  -- Successfully Applied For MDFT Transformation Funding?,
  "successfully_applied_for_disn_transformation_funding" VARCHAR  -- Successfully Applied For DISN Transformation Funding?,
  "used_mdft_transformation_funding_to_fund_additional_posts" VARCHAR  -- Used MDFT Transformation Funding To Fund Additional Posts?,
  "used_disn_transformation_funding_to_fund_additional_posts" VARCHAR  -- Used DISN Transformation Funding To Fund Additional Posts?
);

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.82 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  -- Data Field Notes*
);

NaDIA 2018 - Hospital Characteristics Responses - Open Data

@ukgov.national_diabetes_inpatient_audit_nadia_2018.nadia_2018_hospital_characteristics_responses_open_data

98.65 kB
241 rows
91 columns

CREATE TABLE nadia_2018_hospital_characteristics_responses_open_data (
  "provider_code" VARCHAR,
  "provider_name" VARCHAR,
  "participation_2010" VARCHAR  -- Participation? - 2010,
  "participation_2011" VARCHAR  -- Participation? - 2011,
  "participation_2012" VARCHAR  -- Participation? - 2012,
  "participation_2013" VARCHAR  -- Participation? - 2013,
  "participation_2015" VARCHAR  -- Participation? - 2015,
  "participation_2016" VARCHAR  -- Participation? - 2016,
  "participation_2017" VARCHAR  -- Participation? - 2017,
  "participation_2018" VARCHAR  -- Participation? - 2018,
  "hospital_beds_2010" DOUBLE  -- Hospital Beds - 2010,
  "hospital_beds_2011" DOUBLE  -- Hospital Beds - 2011,
  "hospital_beds_2012" DOUBLE  -- Hospital Beds - 2012,
  "hospital_beds_2013" DOUBLE  -- Hospital Beds - 2013,
  "hospital_beds_2015" DOUBLE  -- Hospital Beds - 2015,
  "hospital_beds_2016" DOUBLE  -- Hospital Beds - 2016,
  "hospital_beds_2017" DOUBLE  -- Hospital Beds - 2017,
  "hospital_beds_2018" DOUBLE  -- Hospital Beds - 2018,
  "disn_wte_2015" DOUBLE  -- DISN WTE - 2015,
  "disn_wte_2016" DOUBLE  -- DISN WTE - 2016,
  "disn_wte_2017" DOUBLE  -- DISN WTE - 2017,
  "disn_wte_2018" DOUBLE  -- DISN WTE - 2018,
  "dsn_wte_2015" DOUBLE  -- DSN WTE - 2015,
  "dsn_wte_2016" DOUBLE  -- DSN WTE - 2016,
  "dsn_wte_2017" DOUBLE  -- DSN WTE - 2017,
  "dsn_wte_2018" DOUBLE  -- DSN WTE - 2018,
  "specialist_diabetes_dietician_wte_2015" DOUBLE  -- Specialist Diabetes Dietician WTE - 2015,
  "specialist_diabetes_dietician_wte_2016" DOUBLE  -- Specialist Diabetes Dietician WTE - 2016,
  "specialist_diabetes_dietician_wte_2017" DOUBLE  -- Specialist Diabetes Dietician WTE - 2017,
  "specialist_diabetes_dietician_wte_2018" DOUBLE  -- Specialist Diabetes Dietician WTE - 2018,
  "non_specialist_dietician_wte_2015" DOUBLE  -- Non-specialist Dietician WTE - 2015,
  "non_specialist_dietician_wte_2016" DOUBLE  -- Non-specialist Dietician WTE - 2016,
  "non_specialist_dietician_wte_2017" DOUBLE  -- Non-specialist Dietician WTE - 2017,
  "non_specialist_dietician_wte_2018" DOUBLE  -- Non-specialist Dietician WTE - 2018,
  "podiatrist_wte_2015" DOUBLE  -- Podiatrist WTE - 2015,
  "podiatrist_wte_2016" DOUBLE  -- Podiatrist WTE - 2016,
  "podiatrist_wte_2017" DOUBLE  -- Podiatrist WTE - 2017,
  "podiatrist_wte_2018" DOUBLE  -- Podiatrist WTE - 2018,
  "diabetes_specialist_pharmacist_wte_2015" DOUBLE  -- Diabetes Specialist Pharmacist WTE - 2015,
  "diabetes_specialist_pharmacist_wte_2016" DOUBLE  -- Diabetes Specialist Pharmacist WTE - 2016,
  "diabetes_specialist_pharmacist_wte_2017" DOUBLE  -- Diabetes Specialist Pharmacist WTE - 2017,
  "diabetes_specialist_pharmacist_wte_2018" DOUBLE  -- Diabetes Specialist Pharmacist WTE - 2018,
  "diabetes_consultant_wte_2015" DOUBLE  -- Diabetes Consultant WTE - 2015,
  "diabetes_consultant_wte_2016" DOUBLE  -- Diabetes Consultant WTE - 2016,
  "diabetes_consultant_wte_2017" DOUBLE  -- Diabetes Consultant WTE - 2017,
  "diabetes_consultant_wte_2018" DOUBLE  -- Diabetes Consultant WTE - 2018,
  "disn_7_day_cover_2015" VARCHAR  -- DISN 7 Day Cover - 2015,
  "disn_7_day_cover_2016" VARCHAR  -- DISN 7 Day Cover - 2016,
  "disn_7_day_cover_2017" VARCHAR  -- DISN 7 Day Cover - 2017,
  "disn_7_day_cover_2018" VARCHAR  -- DISN 7 Day Cover - 2018,
  "diabetes_physician_7_day_cover_2016" VARCHAR  -- Diabetes Physician 7 Day Cover - 2016,
  "diabetes_physician_7_day_cover_2017" VARCHAR  -- Diabetes Physician 7 Day Cover - 2017,
  "diabetes_physician_7_day_cover_2018" VARCHAR  -- Diabetes Physician 7 Day Cover - 2018,
  "m_m_meeting_held_2017" VARCHAR  -- M&M Meeting Held - 2017,
  "m_m_meeting_held_2018" VARCHAR  -- M&M Meeting Held - 2018,
  "ward_nurse_training_2013" VARCHAR  -- Ward Nurse Training - 2013,
  "ward_nurse_training_2015" VARCHAR  -- Ward Nurse Training - 2015,
  "ward_nurse_training_2016" VARCHAR  -- Ward Nurse Training - 2016,
  "ward_nurse_training_2017" VARCHAR  -- Ward Nurse Training - 2017,
  "ward_nurse_training_2018" VARCHAR  -- Ward Nurse Training - 2018,
  "tools_systems_to_increase_foot_exams_2015" VARCHAR  -- Tools/systems To Increase Foot Exams - 2015,
  "tools_systems_to_increase_foot_exams_2016" VARCHAR  -- Tools/systems To Increase Foot Exams - 2016,
  "tools_systems_to_increase_foot_exams_2017" VARCHAR  -- Tools/systems To Increase Foot Exams - 2017,
  "tools_systems_to_increase_foot_exams_2018" VARCHAR  -- Tools/systems To Increase Foot Exams - 2018,
  "mdft_2010" VARCHAR  -- MDFT? - 2010,
  "mdft_2011" VARCHAR  -- MDFT? - 2011,
  "mdft_2012" VARCHAR  -- MDFT? - 2012,
  "mdft_2013" VARCHAR  -- MDFT? - 2013,
  "mdft_2015" VARCHAR  -- MDFT? - 2015,
  "mdft_2016" VARCHAR  -- MDFT? - 2016,
  "mdft_2017" VARCHAR  -- MDFT? - 2017,
  "mdft_2018" VARCHAR  -- MDFT? - 2018,
  "epr_2013" VARCHAR  -- EPR? - 2013,
  "epr_2015" VARCHAR  -- EPR? - 2015,
  "epr_2016" VARCHAR  -- EPR? - 2016,
  "epr_2017" VARCHAR  -- EPR? - 2017,
  "epr_2018" VARCHAR  -- EPR? - 2018,
  "electronic_prescribing_2013" VARCHAR  -- Electronic Prescribing? - 2013,
  "electronic_prescribing_2015" VARCHAR  -- Electronic Prescribing? - 2015,
  "electronic_prescribing_2016" VARCHAR  -- Electronic Prescribing? - 2016,
  "electronic_prescribing_2017" VARCHAR  -- Electronic Prescribing? - 2017,
  "electronic_prescribing_2018" VARCHAR  -- Electronic Prescribing? - 2018,
  "remote_bgm_2013" VARCHAR  -- Remote BGM? - 2013,
  "remote_bgm_2015" VARCHAR  -- Remote BGM? - 2015,
  "remote_bgm_2016" VARCHAR  -- Remote BGM? - 2016,
  "remote_bgm_2017" VARCHAR  -- Remote BGM? - 2017,
  "remote_bgm_2018" VARCHAR  -- Remote BGM? - 2018,
  "transformation_funding_application_successful_mdfts" VARCHAR  -- Transformation Funding Application Successful - MDFTs?,
  "transformation_funding_application_successful_disns" VARCHAR  -- Transformation Funding Application Successful - DISNs?,
  "transformation_funding_used_for_additional_posts_mdfts" VARCHAR  -- Transformation Funding Used For Additional Posts - MDFTs?,
  "transformation_funding_used_for_additional_posts_disns" VARCHAR  -- Transformation Funding Used For Additional Posts - DISNs?
);

NaDIA 2018 - Hospital Characteristics Responses - Open Data Field List

@ukgov.national_diabetes_inpatient_audit_nadia_2018.nadia_2018_hospital_characteristics_responses_open_field_list

6.06 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  -- Data Field Notes*
);