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

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 (spine),
  "total_submitted_hip" VARCHAR  -- Total Submitted (hip),
  "total_submitted_non_hip_non_spine" DOUBLE  -- Total Submitted (non-hip, Non Spine),
  "percentage_submitted_spine" VARCHAR  -- Percentage Submitted (spine),
  "percentage_submitted_hip" VARCHAR  -- Percentage Submitted (hip),
  "percentage_submitted_non_hip_non_spine" DOUBLE  -- Percentage Submitted (non-hip, Non-spine),
  "total_submitted_under_75" DOUBLE  -- Total Submitted (under 75),
  "total_submitted_over_75" DOUBLE  -- Total Submitted (over 75),
  "estimated_caseload" DOUBLE,
  "percentage_of_estimated_caseload_submitted_all_patients" DOUBLE  -- Percentage Of Estimated Caseload Submitted (all Patients),
  "percentage_of_estimated_caseload_submitted_under_75" DOUBLE  -- Percentage Of Estimated Caseload Submitted (under 75),
  "percentage_of_estimated_caseload_submitted_over_75" DOUBLE  -- Percentage Of Estimated Caseload Submitted (over 75),
  "number_assessed_within_90_days_all_patients" VARCHAR  -- Number Assessed Within 90 Days (all Patients),
  "percentage_assessed_within_90_days" VARCHAR,
  "number_dxa_within_90_days_all_patients" VARCHAR  -- Number DXA Within 90 Days (all Patients),
  "percentage_dxa_within_90_days_all_patients" VARCHAR  -- Percentage DXA Within 90 Days (all Patients),
  "number_receiving_a_falls_assessment_all_patients" VARCHAR  -- Number Receiving A Falls Assessment (all Patients),
  "number_receiving_a_falls_assesment_under_75" VARCHAR  -- Number Receiving A Falls Assesment (under 75),
  "number_receiving_a_falls_assessment_over_75" VARCHAR  -- Number Receiving A Falls Assessment (over 75),
  "percentage_receiving_a_falls_assessment_all_patients" VARCHAR  -- Percentage Receiving A Falls Assessment (all Patients),
  "percentage_receiving_a_falls_assessment_under_75" VARCHAR  -- Percentage Receiving A Falls Assessment (under 75),
  "percentage_receiving_a_falls_assessment_over_75" VARCHAR  -- Percentage Receiving A Falls Assessment (over 75),
  "number_of_patients_with_a_treatment_recommendation_all_976cd8e5" DOUBLE  -- Number Of Patients With A Treatment Recommendation (all Patients),
  "number_of_patients_with_a_treatment_recommendation_under_75" VARCHAR  -- Number Of Patients With A Treatment Recommendation (under 75),
  "number_of_patients_with_a_treatment_recommendation_over_75" DOUBLE  -- Number Of Patients With A Treatment Recommendation (over 75),
  "percentage_of_patients_with_a_treatment_recommendation_bda8d2d7" DOUBLE  -- Percentage Of Patients With A Treatment Recommendation (all Patients),
  "percentage_of_patients_with_a_treatment_recommendation_267bd252" VARCHAR  -- Percentage Of Patients With A Treatment Recommendation (under 75),
  "percentage_of_patients_with_a_treatment_recommendation_over_75" DOUBLE  -- Percentage Of Patients With A Treatment Recommendation (over 75),
  "oral_bisphosphonates" VARCHAR  -- Oral Bisphosphonates - %,
  "total_number_of_patients_receiving_bisphosphonates" VARCHAR,
  "zoledronate" VARCHAR  -- Zoledronate - %,
  "total_number_of_patients_receiving_zoledronate" VARCHAR,
  "denosumab" VARCHAR  -- Denosumab - %,
  "total_number_of_patients_receiving_denosumab" VARCHAR,
  "raloxifene" VARCHAR  -- Raloxifene - %,
  "total_number_of_patients_receiving_raloxifene" VARCHAR,
  "teriparatide" VARCHAR  -- Teriparatide - %,
  "total_number_of_patients_receiving_teriparatide" VARCHAR,
  "romosozumab" VARCHAR  -- Romosozumab - %,
  "total_number_of_patients_receiving_romosozumab" VARCHAR,
  "referred_to_gp" VARCHAR  -- Referred To GP - %,
  "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),
  "number_of_patients_due_follow_up_non_hip_fracture_pati_aeb9ca72" VARCHAR  -- Number Of Patients Due Follow Up (non-hip Fracture Patients) (under 75),
  "number_of_patients_due_follow_up_non_hip_fracture_pati_68a6c28e" DOUBLE  -- Number Of Patients Due Follow Up (non-hip Fracture Patients) (over 75),
  "number_of_patients_due_follow_up_non_hip_fracture_1" DOUBLE  -- Number Of Patients Due Follow Up (non-hip Fracture).1,
  "percentage_of_patients_due_follow_up_non_hip_fracture" DOUBLE  -- Percentage Of Patients Due Follow Up (non-hip Fracture),
  "number_of_patients_due_follow_up_all_patients" DOUBLE  -- Number Of Patients Due Follow Up (all Patients),
  "number_of_patients_started_strength_and_balance_non_hi_3d367dee" VARCHAR  -- Number Of Patients Started Strength And Balance (non Hip Fracture),
  "number_of_patients_started_strength_and_balance_non_hi_4c6915cb" VARCHAR  -- Number Of Patients Started Strength And Balance (non-hip Fracture) (under 75),
  "number_of_patients_started_strength_and_balance_non_hi_acc2db7f" VARCHAR  -- Number Of Patients Started Strength And Balance (non-hip Fracture) (over 75),
  "percentage_of_patients_started_strength_and_balance_no_b92dec6a" VARCHAR  -- Percentage Of Patients Started Strength And Balance (non Hip Fracture),
  "percentage_of_patients_started_strength_and_balance_no_5c0d3d08" VARCHAR  -- Percentage Of Patients Started Strength And Balance (non-hip Fracture) (under 75),
  "percentage_of_patients_started_strength_and_balance_no_3cf1f3c4" VARCHAR  -- Percentage Of Patients Started Strength And Balance (non-hip Fracture) (over 75),
  "number_of_patients_due_follow_up_hip_fracture_patients" VARCHAR  -- Number Of Patients Due Follow Up (Hip Fracture Patients),
  "number_of_patients_followed_up_all_fractures" VARCHAR  -- Number Of Patients Followed Up (all Fractures),
  "number_of_patients_followed_up_hip_fractures" VARCHAR  -- Number Of Patients Followed Up (hip Fractures),
  "number_of_patients_followed_up_non_hip_fractures" VARCHAR  -- Number Of Patients Followed Up (non-hip Fractures),
  "percentage_of_patients_followed_up_all_fractures" VARCHAR  -- Percentage Of Patients Followed Up (all Fractures),
  "percentage_of_patients_followed_up_hip_fractures" VARCHAR  -- Percentage Of Patients Followed Up (hip Fractures),
  "percentage_of_patients_followed_up_non_hip_fractures" VARCHAR  -- Percentage Of Patients Followed Up (non-hip Fractures),
  "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: 70,
  "unnamed_71" VARCHAR  -- Unnamed: 71,
  "unnamed_72" VARCHAR  -- Unnamed: 72,
  "unnamed_73" VARCHAR  -- Unnamed: 73,
  "unnamed_74" VARCHAR  -- Unnamed: 74,
  "unnamed_75" VARCHAR  -- Unnamed: 75,
  "unnamed_76" VARCHAR  -- Unnamed: 76,
  "unnamed_77" VARCHAR  -- Unnamed: 77,
  "unnamed_78" VARCHAR  -- Unnamed: 78,
  "unnamed_79" VARCHAR  -- Unnamed: 79,
  "unnamed_80" VARCHAR  -- Unnamed: 80,
  "unnamed_81" VARCHAR  -- Unnamed: 81,
  "unnamed_82" VARCHAR  -- Unnamed: 82,
  "unnamed_83" VARCHAR  -- Unnamed: 83,
  "unnamed_84" VARCHAR  -- Unnamed: 84,
  "unnamed_85" VARCHAR  -- Unnamed: 85,
  "unnamed_86" VARCHAR  -- Unnamed: 86,
  "unnamed_87" VARCHAR  -- Unnamed: 87,
  "unnamed_88" VARCHAR  -- Unnamed: 88,
  "unnamed_89" VARCHAR  -- Unnamed: 89,
  "unnamed_90" VARCHAR  -- Unnamed: 90,
  "unnamed_91" VARCHAR  -- Unnamed: 91,
  "unnamed_92" VARCHAR  -- Unnamed: 92,
  "unnamed_93" VARCHAR  -- Unnamed: 93,
  "unnamed_94" VARCHAR  -- Unnamed: 94,
  "unnamed_95" VARCHAR  -- Unnamed: 95
);

CREATE TABLE fls_db_2022_organisational_data (
  "geo_st_george_s_hospital_yes_st_george_s_hospital_geo__b5219d74" VARCHAR  -- GEO. St George's Hospital,yes,St George's Hospital,,,GEO. St George's Hospital,SW ICS,Aug-05,Per Patient Tariff,,8,Nurse~band 8a~1,,No,,,1700000,Hip Fracture (including Inpatient Fractures),
  "non_hip_inpatient_fragility_fracture_on_orthopaedic_tr_5f435ba4" VARCHAR  -- Non-hip Inpatient Fragility Fracture On Orthopaedic/trauma Wards,
  "non_hip_inpatient_fractures_on_non_orthopaedic_trauma__6b8c5431" VARCHAR  -- Non-hip Inpatient Fractures On Non-orthopaedic/trauma Ward (including Inpatient Fractures),
  "orthopaedic_trauma_fracture_outpatient_clinics_e_g_wri_b04c5e8c" VARCHAR  -- Orthopaedic/trauma Fracture Outpatient Clinics (e.g. Wrist Fractures),
  "presenting_with_a_clinical_vertebral_fracture" VARCHAR,
  "opportunistic_radiological_vertebral_fractures_age_ran_7e4fd1cf" VARCHAR  -- Opportunistic Radiological Vertebral Fractures,Age Range,,,NHFD Lists,
  "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  -- Trauma Lists,,FLS Visits The Orthopaedic/trauma Ward,
  "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  -- Fracture Clinic Attended,,FLS Visits The Orthopaedic/trauma Clinic,
  "using_clinic_lists" VARCHAR,
  "other_it_systems_1" VARCHAR,
  "emergency_department_lists" VARCHAR,
  "referral_from_emergency_department_visits_spine_clinic_1e676725" VARCHAR  -- Referral From Emergency Department,,Visits Spine Clinic/reviews Letters,
  "screening_general_radiology_reports" VARCHAR,
  "fracture_clinic_lists_1" VARCHAR,
  "emergency_department_lists_other_short_of_staff_no_ser_9018d16e" VARCHAR  -- Emergency Department Lists,,Other,short Of Staff,No,,Serum Calcium,
  "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  -- Urine Electrophoresis (for Bence Jones Protein),
  "serum_free_light_chains" VARCHAR,
  "testosterone_sex_hormone_binding_globulin" VARCHAR  -- Testosterone/ Sex Hormone Binding Globulin,
  "spot_urinary_calcium" VARCHAR,
  "n_24_hour_urinary_calcium_dxa_available_on_site_fls_sp_3cf9cf9b" VARCHAR  -- 24 Hour Urinary Calcium,DXA Available On Site,FLS Specialist Practitioner,
  "clinician_speciality" VARCHAR,
  "delegated_to_primary_care_physician_written_material" VARCHAR  -- Delegated To Primary Care Physician,,Written Material,
  "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  -- Clinic Follow-up By Appropriate Specialist If Abnormalities Are Identified On Blood Tests,FLS Recommends Therapy To Orthogeriatrician And/or Primary Care Physician,
  "fls_prescribes" VARCHAR,
  "orthogeriatrician_prescribes" VARCHAR,
  "trauma_prescribes" VARCHAR,
  "metabolic_bone_disease_osteoporosis_specialist_prescri_ba88897b" VARCHAR  -- Metabolic Bone Disease / Osteoporosis Specialist Prescribes,Yes,A Formal Assessment Of Cognition,
  "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  -- Review Of All Medications And Combinations Of Medications That Increase Falls Risk,
  "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  -- Short Physical Performance Battery,,Patient,
  "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  -- DXA – BMD,
  "primary_osteoporosis_risk_factors" VARCHAR,
  "secondary_causes_of_osteoporosis_if_applicable" VARCHAR  -- Secondary Causes Of Osteoporosis (if Applicable),
  "fall_risk_factors" VARCHAR,
  "current_drug_treatment_recommendations_if_applicable" VARCHAR  -- Current Drug Treatment Recommendations (if Applicable),
  "medication_compliance_review" VARCHAR,
  "follow_up_plan" VARCHAR,
  "lifestyle_health_risk_factor_assessment_specialist_nur_2df24b7a" VARCHAR  -- Lifestyle/health Risk-factor Assessment,Specialist Nurse,Medication Adherence,
  "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  -- DXA,Longer Than Every 3 Years,0,No,What Should Happen If You Or Someone You Know Experiences A Fragility Fracture?,
  "bone_health_card" VARCHAR,
  "strong_bones_after_50_staying_on_treatment" VARCHAR  -- Strong Bones After 50 - Staying On Treatment,
  "strong_bones_after_50_fracture_liaison_services_explained" VARCHAR  -- Strong Bones After 50: Fracture Liaison Services Explained
);