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_hip" VARCHAR,
  "total_submitted_non_hip_non_spine" VARCHAR,
  "percentage_submitted_spine" VARCHAR,
  "percentage_submitted_hip" VARCHAR,
  "percentage_submitted_non_hip_non_spine" VARCHAR,
  "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" DOUBLE,
  "percentage_receiving_a_falls_assessment_all_patients" VARCHAR,
  "percentage_receiving_a_falls_assessment_under_75" VARCHAR,
  "percentage_receiving_a_falls_assessment_over_75" DOUBLE,
  "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,
  "referred_for_clinical_opinion" VARCHAR,
  "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_pati_aeb9ca72" VARCHAR,
  "number_of_patients_due_follow_up_non_hip_fracture_pati_68a6c28e" VARCHAR,
  "percentage_of_patients_due_follow_up_non_hip_fracture" VARCHAR,
  "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,
  "total_number_of_patients_receiving_oral_bisphosphonates" VARCHAR,
  "oral_bisphosphonates_c35c3a" VARCHAR,
  "total_number_of_patients_receiving_zoledronate_1" VARCHAR,
  "zoledronate_71589c" VARCHAR,
  "total_number_of_patients_receiving_denosumab_1" VARCHAR,
  "denosumab_c4c590" VARCHAR,
  "total_number_of_patients_receiving_raloxifene_1" VARCHAR,
  "raloxifene_50c78e" VARCHAR,
  "total_number_of_patients_receiving_teriparatide_1" VARCHAR,
  "teriparatide_eb5656" VARCHAR,
  "total_number_of_patients_receiving_romosozumab_1" VARCHAR,
  "romosozumab_a00e25" VARCHAR,
  "total_number_of_patients_referred_to_gp" DOUBLE,
  "referred_to_gp_463667" DOUBLE,
  "total_number_of_patients_referred_for_clinical_opinion_1" DOUBLE,
  "referred_for_clinical_opinion_1" DOUBLE,
  "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,
  "total_number_of_patients_receiving_zoledronate_2" VARCHAR,
  "zoledronate_3faddb" VARCHAR,
  "total_number_of_patients_receiving_denosumab_2" VARCHAR,
  "denosumab_336d11" VARCHAR,
  "total_number_of_patients_receiving_raloxifene_2" VARCHAR,
  "raloxifene_319351" VARCHAR,
  "total_number_of_patients_receiving_teriparatide_2" VARCHAR,
  "teriparatide_1" VARCHAR,
  "total_number_of_patients_receiving_romosozumab_2" VARCHAR,
  "romosozumab_1" VARCHAR,
  "total_number_of_patients_referred_to_gp_1" DOUBLE
);