About this Dataset

The Fracture Liaison Service Database (FLS-DB) Jan To December 2019

The data documents FLS level compliance with defined clinical standards for secondary fracture prevention. Details of these standards can be found in the FLS-DB audit report. The audit was initiated to measure primarily against NICE technology assessments and guidance on osteoporosis, and the National Osteoporosis Society clinical standards for FLSs. Data was extracted from the FLS database in September 2020, and covers patients diagnosed with a fragility fracture within the NHS between January and December 2019.
Publisher name: Healthcare Quality Improvement Partnership
Last updated: 2024-06-13T04:27:07Z
Tables

2019 Clinical Audit Data Barnadised

@ukgov.the_fracture_liaison_service_database_fls_db_jan_to_de_3656cb4b.n_2019_clinical_audit_data_barnadised
93.67 kB
39 rows
83 columns
CREATE TABLE n_2019_clinical_audit_data_barnadised (
  "fls_name" VARCHAR,
  "number_of_cases_submitted" BIGINT,
  "uploaded_in_bulk_y_n" VARCHAR  -- Uploaded In Bulk (Y/N),
  "number_of_fields_out_of_29_with_20_or_more_missing_data" BIGINT  -- Number Of Fields (out Of 29) With 20% Or More Missing Data,
  "number_of_fields_out_of_29_with_50_or_more_missing_data" BIGINT  -- Number Of Fields (out Of 29) With 50% Or More Missing Data,
  "from_nhfd_hip" BIGINT  -- From NHFD - Hip,
  "from_nhfd_non_hip" BIGINT  -- From NHFD - Non-hip,
  "from_fls_db_hip" VARCHAR  -- From FLS-DB - Hip,
  "from_fls_db_non_hip" BIGINT  -- From FLS-DB - Non-hip,
  "fls_db_case_identification_hip" VARCHAR  -- FLS-DB Case Identification % - Hip,
  "fls_db_case_identification_non_hip" DOUBLE  -- FLS-DB Case Identification % - Non-hip,
  "diagnosis_to_fls_assessment_within_7_days_n" VARCHAR  -- Diagnosis To FLS Assessment Within 7 Days (n),
  "diagnosis_to_fls_assessment_within_7_days" VARCHAR  -- Diagnosis To FLS Assessment Within 7 Days (%),
  "diagnosis_to_fls_assessment_within_30_days_n" VARCHAR  -- Diagnosis To FLS Assessment Within 30 Days (n),
  "diagnosis_to_fls_assessment_within_30_days" VARCHAR  -- Diagnosis To FLS Assessment Within 30 Days (%),
  "diagnosis_to_fls_assessment_within_90_days_n" VARCHAR  -- Diagnosis To FLS Assessment Within 90 Days (n),
  "diagnosis_to_fls_assessment_within_90_days" VARCHAR  -- Diagnosis To FLS Assessment Within 90 Days (%),
  "diagnosis_to_fls_assessment_91_days_or_more_n" VARCHAR  -- Diagnosis To FLS Assessment 91 Days Or More (n),
  "diagnosis_to_fls_assessment_91_days_or_more" VARCHAR  -- Diagnosis To FLS Assessment 91 Days Or More (%),
  "diagnosis_to_fls_assessment_days_missing_n" VARCHAR  -- Diagnosis To FLS Assessment (days)Missing (n),
  "diagnosis_to_fls_assessment_days_missing" VARCHAR  -- Diagnosis To FLS Assessment (days)Missing (%),
  "time_to_dxa_scan_from_fracture_diagnosis_within_7_days_n" VARCHAR  -- Time To DXA Scan From Fracture Diagnosis Within 7 Days (n),
  "time_to_dxa_scan_from_fracture_diagnosis_within_7_days" VARCHAR  -- Time To DXA Scan From Fracture Diagnosis Within 7 Days (%),
  "time_to_dxa_scan_from_fracture_diagnosis_within_30_days_n" VARCHAR  -- Time To DXA Scan From Fracture Diagnosis Within 30 Days (n),
  "time_to_dxa_scan_from_fracture_diagnosis_within_30_days" VARCHAR  -- Time To DXA Scan From Fracture Diagnosis Within 30 Days (%),
  "time_to_dxa_scan_from_fracture_diagnosis_within_90_days_n" VARCHAR  -- Time To DXA Scan From Fracture Diagnosis Within 90 Days (n),
  "time_to_dxa_scan_from_fracture_diagnosis_within_90_days" VARCHAR  -- Time To DXA Scan From Fracture Diagnosis Within 90 Days (%),
  "time_to_dxa_scan_from_fracture_diagnosis_within_91_day_ec464ff9" VARCHAR  -- Time To DXA Scan From Fracture Diagnosis Within 91 Days Or More(n),
  "time_to_dxa_scan_from_fracture_diagnosis_within_91_day_f02921da" VARCHAR  -- Time To DXA Scan From Fracture Diagnosis Within 91 Days Or More(%),
  "time_to_dxa_scan_from_fracture_diagnosis_days_missing_n" VARCHAR  -- Time To DXA Scan From Fracture Diagnosis Days Missing (n),
  "time_to_dxa_scan_from_fracture_diagnosis_days_missing" VARCHAR  -- Time To DXA Scan From Fracture Diagnosis Days Missing (%),
  "total_dxa_recommended" BIGINT,
  "number_of_cases_submitted_n" BIGINT  -- Number Of Cases Submitted (n),
  "q4_01_bone_therapy_recommended_after_index_fracture_tr_63c3e272" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Treated (oral Bisphosphonates , Denosumab, Zolendronate) (n),
  "q4_01_bone_therapy_recommended_after_index_fracture_tr_41445d31" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Treated (oral Bisphosphonates , Denosumab, Zolendronate) (%),
  "q4_01_bone_therapy_recommended_after_index_fracture_in_3c5761ab" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Inappropriate (n),
  "q4_01_bone_therapy_recommended_after_index_fracture_in_8cc7ffeb" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Inappropriate (%),
  "q4_01_bone_therapy_recommended_after_index_fracture_in_1d7a393a" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Informed Decline (n),
  "q4_01_bone_therapy_recommended_after_index_fracture_in_8a31400f" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Informed Decline (%),
  "q4_01_bone_therapy_recommended_after_index_fracture_re_3fe0ffa1" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture -Referred To GP To Decide Prescription (n),
  "q4_01_bone_therapy_recommended_after_index_fracture_re_4c9de572" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Referred To GP To Decide Prescription (%),
  "q4_01_bone_therapy_recommended_after_index_fracture_re_a98fa517" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture -Referred For Further Clinical Opinion(n),
  "q4_01_bone_therapy_recommended_after_index_fracture_re_4fd40006" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Referred For Further Clinical Opinion (%),
  "q4_01_bone_therapy_recommended_after_index_fracture_do_ae1ac06b" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture -Don't Know (n),
  "q4_01_bone_therapy_recommended_after_index_fracture_don_t_know" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Don't Know (%),
  "q4_01_bone_therapy_recommended_after_index_fracture_missing_n" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture -Missing (n),
  "q4_01_bone_therapy_recommended_after_index_fracture_missing" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Missing (%),
  "q4_01_bone_therapy_recommended_after_index_fracture_al_266eb7e1" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Alendronate (n),
  "q4_01_bone_therapy_recommended_after_index_fracture_al_345df7e9" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Alendronate (%),
  "q4_01_bone_therapy_recommended_after_index_fracture_ri_3496569e" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Risedronate (n),
  "q4_01_bone_therapy_recommended_after_index_fracture_ri_cf4176ec" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Risedronate (%),
  "q4_01_bone_therapy_recommended_after_index_fracture_ib_3ff2ceb5" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Ibandronate (n),
  "q4_01_bone_therapy_recommended_after_index_fracture_ib_6411f849" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Ibandronate (%),
  "q4_01_bone_therapy_recommended_after_index_fracture_ra_6cea0954" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Raloxifene (n),
  "q4_01_bone_therapy_recommended_after_index_fracture_raloxifene" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Raloxifene (%),
  "q4_01_bone_therapy_recommended_after_index_fracture_te_3c55738d" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Teriparatide (n),
  "q4_01_bone_therapy_recommended_after_index_fracture_te_1d2b6520" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Teriparatide (%),
  "q4_01_bone_therapy_recommended_after_index_fracture_st_aef7a0ed" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Strontium (n),
  "q4_01_bone_therapy_recommended_after_index_fracture_strontium" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Strontium (%),
  "q4_01_bone_therapy_recommended_after_index_fracture_de_922c579c" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Denosumab (n),
  "q4_01_bone_therapy_recommended_after_index_fracture_denosumab" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Denosumab (%),
  "q4_01_bone_therapy_recommended_after_index_fracture_zo_989cb5b7" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Zoledronate (n),
  "q4_01_bone_therapy_recommended_after_index_fracture_zo_e8f2442e" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Zoledronate (%),
  "q4_01_bone_therapy_recommended_after_index_fracture_ot_b53e3549" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Other Hormone Therapies (n),
  "q4_01_bone_therapy_recommended_after_index_fracture_ot_5b6b9618" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Other Hormone Therapies (%),
  "q4_01_bone_therapy_recommended_after_index_fracture_ac_40399cda" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Activated Vitamin D (n),
  "q4_01_bone_therapy_recommended_after_index_fracture_ac_2789ee1e" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Activated Vitamin D (%),
  "q4_01_bone_therapy_recommended_after_index_fracture_to_2d105bef" VARCHAR  -- Q4.01 Ð Bone Therapy Recommended After Index Fracture - Total Recommended Bone Therapy(n),
  "number_of_cases_submitted_n_1" BIGINT  -- Number Of Cases Submitted (n).1,
  "q5_01_falls_risk_assessment_performed_by_fls_not_done_n" VARCHAR  -- Q5.01 Falls Risk Assessment Performed By FLS - Not Done (n),
  "q5_01_falls_risk_assessment_performed_by_fls_not_done" VARCHAR  -- Q5.01 Falls Risk Assessment Performed By FLS - Not Done (%),
  "q5_01_falls_risk_assessment_performed_by_fls_falls_ris_ac4a1a74" VARCHAR  -- Q5.01 Falls Risk Assessment Performed By FLS - Falls Risk Assessment Done/referred/ Recommended (n),
  "q5_01_falls_risk_assessment_performed_by_fls_falls_ris_7b8da6f2" VARCHAR  -- Q5.01 Falls Risk Assessment Performed By FLS - Falls Risk Assessment Done/referred/ Recommended (%),
  "q5_01_falls_risk_assessment_performed_by_fls_not_recorded_n" VARCHAR  -- Q5.01 Falls Risk Assessment Performed By FLS - Not Recorded (n),
  "q5_01_falls_risk_assessment_performed_by_fls_not_recorded" VARCHAR  -- Q5.01 Falls Risk Assessment Performed By FLS - Not Recorded (%),
  "q5_01_falls_risk_assessment_performed_by_fls_missing_n" VARCHAR  -- Q5.01 Falls Risk Assessment Performed By FLS - Missing (n),
  "q5_01_falls_risk_assessment_performed_by_fls_missing" VARCHAR  -- Q5.01 Falls Risk Assessment Performed By FLS - Missing (%),
  "total_patient_records_n" VARCHAR  -- Total Patient Records (n),
  "patients_followed_up_of_those_prescribed_bone_therapy__62b43a35" VARCHAR  -- Patients Followed-up (of Those Prescribed Bone Therapy Or Referred For Further Clinical Opinion Or To GP) (n),
  "patients_followed_up_of_those_prescribed_bone_therapy__dece13dc" VARCHAR  -- Patients Followed-up (of Those Prescribed Bone Therapy Or Referred For Further Clinical Opinion Or To GP) (%),
  "total_recommended_bone_therapy_n" VARCHAR  -- Total Recommended Bone Therapy (n),
  "proportion_of_patients_with_a_valid_bone_therapy_recom_3614a7d4" VARCHAR  -- Proportion Of Patients With A Valid Bone Therapy Recommendation, Reported As Starting Treatment Within 4 Months Of Index Fracture By FLS From January To June 2016 (n),
  "proportion_of_patients_with_a_valid_bone_therapy_recom_4d6e3c7a" VARCHAR  -- Proportion Of Patients With A Valid Bone Therapy Recommendation, Reported As Starting Treatment Within 4 Months Of Index Fracture By FLS From January To June 2016 (%)
);