About this Dataset

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

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 Royal Osteoporosis Society clinical standards for FLSs. Data was extracted from the FLS database in June
Publisher name: Healthcare Quality Improvement Partnership
Last updated: 2024-06-14T04:01:28Z

Tables

FLS-DB 2022 Clinical Data Barnadised

@ukgov.fracture_liaison_service_database_fls_db_jan_to_december_2022.fls_db_2022_clinical_data_barnadised

98.87 KB
380 rows
96 columns


CREATE TABLE fls_db_2022_clinical_data_barnadised (
  "flscode" VARCHAR,
  "fls_name" VARCHAR,
  "data_completeness" DOUBLE,
  "total_submitted" DOUBLE,
  "total_submitted_spine" VARCHAR,
  "total_submitted_hip" VARCHAR,
  "total_submitted_non_hip_non_spine" DOUBLE,
  "percentage_submitted_spine" VARCHAR,
  "percentage_submitted_hip" VARCHAR,
  "percentage_submitted_non_hip_non_spine" DOUBLE,
  "total_submitted_under_75" DOUBLE,
  "total_submitted_over_75" DOUBLE,
  "estimated_caseload" DOUBLE,
  "percentage_of_estimated_caseload_submitted_all_patients" DOUBLE,
  "percentage_of_estimated_caseload_submitted_under_75" DOUBLE,
  "percentage_of_estimated_caseload_submitted_over_75" DOUBLE,
  "number_assessed_within_90_days_all_patients" VARCHAR,
  "percentage_assessed_within_90_days" VARCHAR,
  "number_dxa_within_90_days_all_patients" VARCHAR,
  "percentage_dxa_within_90_days_all_patients" VARCHAR,
  "number_receiving_a_falls_assessment_all_patients" VARCHAR,
  "number_receiving_a_falls_assesment_under_75" VARCHAR,
  "number_receiving_a_falls_assessment_over_75" VARCHAR,
  "percentage_receiving_a_falls_assessment_all_patients" VARCHAR,
  "percentage_receiving_a_falls_assessment_under_75" VARCHAR,
  "percentage_receiving_a_falls_assessment_over_75" VARCHAR,
  "number_of_patients_with_a_treatment_recommendation_all_976cd8e5" DOUBLE,
  "number_of_patients_with_a_treatment_recommendation_under_75" VARCHAR,
  "number_of_patients_with_a_treatment_recommendation_over_75" DOUBLE,
  "percentage_of_patients_with_a_treatment_recommendation_bda8d2d7" DOUBLE,
  "percentage_of_patients_with_a_treatment_recommendation_267bd252" VARCHAR,
  "percentage_of_patients_with_a_treatment_recommendation_over_75" DOUBLE,
  "oral_bisphosphonates" VARCHAR,
  "total_number_of_patients_receiving_bisphosphonates" VARCHAR,
  "zoledronate" VARCHAR,
  "total_number_of_patients_receiving_zoledronate" VARCHAR,
  "denosumab" VARCHAR,
  "total_number_of_patients_receiving_denosumab" VARCHAR,
  "raloxifene" VARCHAR,
  "total_number_of_patients_receiving_raloxifene" VARCHAR,
  "teriparatide" VARCHAR,
  "total_number_of_patients_receiving_teriparatide" VARCHAR,
  "romosozumab" VARCHAR,
  "total_number_of_patients_receiving_romosozumab" VARCHAR,
  "referred_to_gp" VARCHAR,
  "total_number_of_patients_referred_to_a_gp" VARCHAR,
  "number_of_patients_due_follow_up_non_hip_fracture" DOUBLE,
  "number_of_patients_due_follow_up_non_hip_fracture_pati_aeb9ca72" VARCHAR,
  "number_of_patients_due_follow_up_non_hip_fracture_pati_68a6c28e" DOUBLE,
  "number_of_patients_due_follow_up_non_hip_fracture_1" DOUBLE,
  "percentage_of_patients_due_follow_up_non_hip_fracture" DOUBLE,
  "number_of_patients_due_follow_up_all_patients" DOUBLE,
  "number_of_patients_started_strength_and_balance_non_hi_3d367dee" VARCHAR,
  "number_of_patients_started_strength_and_balance_non_hi_4c6915cb" VARCHAR,
  "number_of_patients_started_strength_and_balance_non_hi_acc2db7f" VARCHAR,
  "percentage_of_patients_started_strength_and_balance_no_b92dec6a" VARCHAR,
  "percentage_of_patients_started_strength_and_balance_no_5c0d3d08" VARCHAR,
  "percentage_of_patients_started_strength_and_balance_no_3cf1f3c4" VARCHAR,
  "number_of_patients_due_follow_up_hip_fracture_patients" VARCHAR,
  "number_of_patients_followed_up_all_fractures" VARCHAR,
  "number_of_patients_followed_up_hip_fractures" VARCHAR,
  "number_of_patients_followed_up_non_hip_fractures" VARCHAR,
  "percentage_of_patients_followed_up_all_fractures" VARCHAR,
  "percentage_of_patients_followed_up_hip_fractures" VARCHAR,
  "percentage_of_patients_followed_up_non_hip_fractures" VARCHAR,
  "number_of_patients_commenced_bone_therapy_by_1st_follow_up" VARCHAR,
  "percentage_of_patients_commenced_bone_therapy_by_1st_follow_up" VARCHAR,
  "number_of_patients_due_follow_up_at_1_year" VARCHAR,
  "number_adherent_to_bone_therapy_at_12_months" VARCHAR,
  "percentage_of_patients_adherent_to_bone_therapy_at_12_months" VARCHAR,
  "unnamed_70" VARCHAR,
  "unnamed_71" VARCHAR,
  "unnamed_72" VARCHAR,
  "unnamed_73" VARCHAR,
  "unnamed_74" VARCHAR,
  "unnamed_75" VARCHAR,
  "unnamed_76" VARCHAR,
  "unnamed_77" VARCHAR,
  "unnamed_78" VARCHAR,
  "unnamed_79" VARCHAR,
  "unnamed_80" VARCHAR,
  "unnamed_81" VARCHAR,
  "unnamed_82" VARCHAR,
  "unnamed_83" VARCHAR,
  "unnamed_84" VARCHAR,
  "unnamed_85" VARCHAR,
  "unnamed_86" VARCHAR,
  "unnamed_87" VARCHAR,
  "unnamed_88" VARCHAR,
  "unnamed_89" VARCHAR,
  "unnamed_90" VARCHAR,
  "unnamed_91" VARCHAR,
  "unnamed_92" VARCHAR,
  "unnamed_93" VARCHAR,
  "unnamed_94" VARCHAR,
  "unnamed_95" VARCHAR
);

FLS-DB 2022 Organisational Data

@ukgov.fracture_liaison_service_database_fls_db_jan_to_december_2022.fls_db_2022_organisational_data

150.88 KB
56 rows
101 columns


CREATE TABLE fls_db_2022_organisational_data (
  "geo_st_george_s_hospital_yes_st_george_s_hospital_geo__b5219d74" VARCHAR,
  "non_hip_inpatient_fragility_fracture_on_orthopaedic_tr_5f435ba4" VARCHAR,
  "non_hip_inpatient_fractures_on_non_orthopaedic_trauma__6b8c5431" VARCHAR,
  "orthopaedic_trauma_fracture_outpatient_clinics_e_g_wri_b04c5e8c" VARCHAR,
  "presenting_with_a_clinical_vertebral_fracture" VARCHAR,
  "opportunistic_radiological_vertebral_fractures_age_ran_7e4fd1cf" VARCHAR,
  "fls_visits_the_orthopaedic_trauma_ward" VARCHAR,
  "ward_emergency_room_admissions_lists" VARCHAR,
  "seen_by_orthogeriatric_service_not_fls" VARCHAR,
  "fracture_clinic_lists" VARCHAR,
  "it_systems" VARCHAR,
  "trauma_lists_fls_visits_the_orthopaedic_trauma_ward" VARCHAR,
  "ward_emergency_room_admissions_discharge_lists" VARCHAR,
  "radiology" VARCHAR,
  "seen_by_orthogeriatric_service" VARCHAR,
  "other_it_systems" VARCHAR,
  "fracture_clinic_attended_fls_visits_the_orthopaedic_tr_a07a956b" VARCHAR,
  "using_clinic_lists" VARCHAR,
  "other_it_systems_1" VARCHAR,
  "emergency_department_lists" VARCHAR,
  "referral_from_emergency_department_visits_spine_clinic_1e676725" VARCHAR,
  "screening_general_radiology_reports" VARCHAR,
  "fracture_clinic_lists_1" VARCHAR,
  "emergency_department_lists_other_short_of_staff_no_ser_9018d16e" VARCHAR,
  "serum_phosphate" VARCHAR,
  "serum_alkaline_phosphate" VARCHAR,
  "serum_25oh_vitamin_d" VARCHAR,
  "serum_parathyroid_hormone" VARCHAR,
  "full_blood_count" VARCHAR,
  "esr" VARCHAR,
  "liver_function" VARCHAR,
  "thyroid_function" VARCHAR,
  "c_reactive_protein" VARCHAR,
  "liver_function_tests" VARCHAR,
  "renal_function_tests" VARCHAR,
  "coeliac_disease_screen" VARCHAR,
  "serum_electrophoresis" VARCHAR,
  "urine_electrophoresis_for_bence_jones_protein" VARCHAR,
  "serum_free_light_chains" VARCHAR,
  "testosterone_sex_hormone_binding_globulin" VARCHAR,
  "spot_urinary_calcium" VARCHAR,
  "n_24_hour_urinary_calcium_dxa_available_on_site_fls_sp_3cf9cf9b" VARCHAR,
  "clinician_speciality" VARCHAR,
  "delegated_to_primary_care_physician_written_material" VARCHAR,
  "calcium_and_vitamin_d_supplementation_advice" VARCHAR,
  "oral_bisphosphonates" VARCHAR,
  "denosumab" VARCHAR,
  "intravenous_bisphosphonates" VARCHAR,
  "teriparatide" VARCHAR,
  "romosozumab" VARCHAR,
  "further_education_programmes_resources" VARCHAR,
  "clinic_follow_up_by_appropriate_specialist_if_abnormal_eca5acf1" VARCHAR,
  "fls_prescribes" VARCHAR,
  "orthogeriatrician_prescribes" VARCHAR,
  "trauma_prescribes" VARCHAR,
  "metabolic_bone_disease_osteoporosis_specialist_prescri_ba88897b" VARCHAR,
  "assessment_of_continence_and_toileting" VARCHAR,
  "assessment_of_a_history_of_falls" VARCHAR,
  "number_of_falls_in_the_last_12_months" VARCHAR,
  "assessment_for_fear_of_falling" VARCHAR,
  "assessment_of_a_history_of_blackouts_or_syncope" VARCHAR,
  "review_of_all_medications_and_combinations_of_medicati_40628981" VARCHAR,
  "assessment_of_gait_and_balance_and_mobility" VARCHAR,
  "a_requirement_to_check_lying_and_standing_bp" VARCHAR,
  "pulse_check_for_rhythm_and_rate" VARCHAR,
  "an_evaluation_of_vision" VARCHAR,
  "assessment_of_home_hazards_ask_about_gait_problems" VARCHAR,
  "timed_up_and_go" VARCHAR,
  "berg_balance" VARCHAR,
  "chair_rise" VARCHAR,
  "short_physical_performance_battery_patient" VARCHAR,
  "primary_care_physician" VARCHAR,
  "orthopaedic_surgeon_or_clinician_responsible_for_fracture_care" VARCHAR,
  "falls_service" VARCHAR,
  "service_that_referred_to_fls_date_and_type_of_fracture" VARCHAR,
  "fracture_risk_score" VARCHAR,
  "dxa_bmd" VARCHAR,
  "primary_osteoporosis_risk_factors" VARCHAR,
  "secondary_causes_of_osteoporosis_if_applicable" VARCHAR,
  "fall_risk_factors" VARCHAR,
  "current_drug_treatment_recommendations_if_applicable" VARCHAR,
  "medication_compliance_review" VARCHAR,
  "follow_up_plan" VARCHAR,
  "lifestyle_health_risk_factor_assessment_specialist_nur_2df24b7a" VARCHAR,
  "medication_persistence" VARCHAR,
  "medication_adverse_effects" VARCHAR,
  "residential_status" VARCHAR,
  "post_fracture_mobility" VARCHAR,
  "started_a_programme_of_strength_and_balance_exercise" VARCHAR,
  "recurrent_fractures" VARCHAR,
  "recurrent_falls_prescription_review" VARCHAR,
  "telephone_interview" VARCHAR,
  "telemed_video_consultation" VARCHAR,
  "postal_questionnaire" VARCHAR,
  "clinic_review_face_to_face" VARCHAR,
  "clinic_review_remote" VARCHAR,
  "dxa_longer_than_every_3_years_0_no_what_should_happen__0a88c583" VARCHAR,
  "bone_health_card" VARCHAR,
  "strong_bones_after_50_staying_on_treatment" VARCHAR,
  "strong_bones_after_50_fracture_liaison_services_explained" VARCHAR
);