The Fracture Liaison Service Database (FLS-DB) January To December 2023

CREATE TABLE fls_db_2023_clinical_data_definitions (
  "data_field_position" VARCHAR,
  "column_a" VARCHAR,
  "column_b" VARCHAR,
  "column_c" VARCHAR,
  "column_d" VARCHAR,
  "column_e" VARCHAR,
  "column_f" VARCHAR,
  "column_g" VARCHAR,
  "column_h" VARCHAR,
  "column_i" VARCHAR,
  "column_j" VARCHAR,
  "column_k" VARCHAR,
  "column_l" VARCHAR,
  "column_m" VARCHAR,
  "column_n" VARCHAR,
  "column_o" VARCHAR,
  "column_p" VARCHAR,
  "column_q" VARCHAR,
  "column_r" VARCHAR,
  "column_s" VARCHAR,
  "column_t" VARCHAR,
  "column_u" VARCHAR,
  "column_v" VARCHAR,
  "column_w" VARCHAR,
  "column_x" VARCHAR,
  "column_y" VARCHAR,
  "column_z" VARCHAR,
  "column_aa" VARCHAR,
  "column_ab" VARCHAR,
  "column_ac" VARCHAR,
  "column_ad" VARCHAR,
  "column_ae" VARCHAR,
  "column_af" VARCHAR,
  "column_ag" VARCHAR,
  "column_ah" VARCHAR,
  "column_ai" VARCHAR,
  "column_aj" VARCHAR,
  "column_ak" VARCHAR,
  "column_al" VARCHAR,
  "column_am" VARCHAR,
  "column_an" VARCHAR,
  "column_ao" VARCHAR,
  "column_ap" VARCHAR,
  "column_aq" VARCHAR,
  "column_ar" VARCHAR,
  "column_as" VARCHAR,
  "column_at" VARCHAR,
  "column_au" VARCHAR,
  "column_av" VARCHAR,
  "column_aw" VARCHAR,
  "column_ax" VARCHAR,
  "column_ay" VARCHAR,
  "column_az" VARCHAR,
  "column_ba" VARCHAR,
  "column_bb" VARCHAR,
  "column_bc" VARCHAR,
  "column_bd" VARCHAR,
  "column_be" VARCHAR,
  "column_bf" VARCHAR,
  "column_bg" VARCHAR,
  "column_bh" VARCHAR,
  "column_bi" VARCHAR,
  "column_bj" VARCHAR,
  "column_bk" VARCHAR,
  "column_bl" VARCHAR,
  "column_bm" VARCHAR,
  "column_bn" VARCHAR,
  "column_bo" VARCHAR,
  "column_bp" VARCHAR,
  "column_bq" VARCHAR,
  "column_br" VARCHAR,
  "column_bs" VARCHAR,
  "column_bt" VARCHAR,
  "column_bu" VARCHAR,
  "column_bv" VARCHAR,
  "column_bw" VARCHAR,
  "column_bx" VARCHAR,
  "column_by" VARCHAR,
  "column_bz" VARCHAR,
  "column_ca" VARCHAR,
  "column_cb" VARCHAR,
  "column_cc" VARCHAR,
  "column_cd" VARCHAR,
  "column_ce" VARCHAR,
  "column_cf" VARCHAR,
  "column_cg" VARCHAR,
  "column_ch" VARCHAR,
  "column_ci" VARCHAR,
  "column_cj" VARCHAR,
  "column_ck" VARCHAR,
  "column_cl" VARCHAR,
  "column_cm" VARCHAR,
  "column_cn" VARCHAR,
  "column_co" VARCHAR,
  "column_cp" VARCHAR,
  "column_cq" VARCHAR,
  "column_cr" VARCHAR,
  "column_cs" VARCHAR,
  "column_ct" VARCHAR,
  "column_cu" VARCHAR
);

CREATE TABLE fls_db_2023_clinical_dataset_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" VARCHAR  -- 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" VARCHAR  -- 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" DOUBLE  -- 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" DOUBLE  -- 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,
  "referred_for_clinical_opinion" VARCHAR  -- Referred For Clinical Opinion %,
  "total_number_of_patients_referred_for_clinical_opinion" VARCHAR,
  "number_of_patients_due_follow_up_non_hip_fracture" VARCHAR  -- 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" VARCHAR  -- Number Of Patients Due Follow Up (non-hip Fracture Patients) (over 75),
  "percentage_of_patients_due_follow_up_non_hip_fracture" VARCHAR  -- 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,
  "total_number_of_patients_receiving_oral_bisphosphonates" VARCHAR,
  "oral_bisphosphonates_c35c3a" VARCHAR  -- Oral Bisphosphonates %,
  "total_number_of_patients_receiving_zoledronate_1" VARCHAR,
  "zoledronate_71589c" VARCHAR  -- Zoledronate %,
  "total_number_of_patients_receiving_denosumab_1" VARCHAR,
  "denosumab_c4c590" VARCHAR  -- Denosumab %,
  "total_number_of_patients_receiving_raloxifene_1" VARCHAR,
  "raloxifene_50c78e" VARCHAR  -- Raloxifene %,
  "total_number_of_patients_receiving_teriparatide_1" VARCHAR,
  "teriparatide_eb5656" VARCHAR  -- Teriparatide %,
  "total_number_of_patients_receiving_romosozumab_1" VARCHAR,
  "romosozumab_a00e25" VARCHAR  -- Romosozumab %,
  "total_number_of_patients_referred_to_gp" DOUBLE,
  "referred_to_gp_463667" DOUBLE  -- Referred To GP %,
  "total_number_of_patients_referred_for_clinical_opinion_1" DOUBLE,
  "referred_for_clinical_opinion_1" DOUBLE  -- Referred For Clinical Opinion %.1,
  "number_of_patients_due_follow_up_at_1_year" DOUBLE,
  "number_adherent_to_bone_therapy_at_12_months" VARCHAR,
  "percentage_of_patients_adherent_to_bone_therapy_at_12_months" VARCHAR,
  "total_number_of_patients_receiving_bisphosphonates_1" VARCHAR,
  "oral_bisphosphonates_73577f" DOUBLE  -- Oral Bisphosphonates %,
  "total_number_of_patients_receiving_zoledronate_2" VARCHAR,
  "zoledronate_3faddb" VARCHAR  -- Zoledronate %,
  "total_number_of_patients_receiving_denosumab_2" VARCHAR,
  "denosumab_336d11" VARCHAR  -- Denosumab %,
  "total_number_of_patients_receiving_raloxifene_2" VARCHAR,
  "raloxifene_319351" VARCHAR  -- Raloxifene %,
  "total_number_of_patients_receiving_teriparatide_2" VARCHAR,
  "teriparatide_1" VARCHAR  -- Teriparatide %.1,
  "total_number_of_patients_receiving_romosozumab_2" VARCHAR,
  "romosozumab_1" VARCHAR  -- Romosozumab %.1,
  "total_number_of_patients_referred_to_gp_1" DOUBLE
);