The Fracture Liaison Service Database (FLS-DB) Jan To June 2016

CREATE TABLE the_fracture_liaison_service_database_fls_db_jan_to_june_2016 (
  "fls_name" VARCHAR,
  "number_of_cases_submitted" BIGINT,
  "uploaded_in_bulk_y_n" VARCHAR,
  "number_of_fields_out_of_29_with_20_or_more_missing_data" BIGINT,
  "number_of_fields_out_of_29_with_50_or_more_missing_data" BIGINT,
  "from_nhfd_hip" BIGINT,
  "from_nhfd_non_hip" BIGINT,
  "from_fls_db_hip" VARCHAR,
  "from_fls_db_non_hip" BIGINT,
  "fls_db_case_identification_hip" VARCHAR,
  "fls_db_case_identification_non_hip" DOUBLE,
  "diagnosis_to_fls_assessment_within_7_days_n" VARCHAR,
  "diagnosis_to_fls_assessment_within_7_days" VARCHAR,
  "diagnosis_to_fls_assessment_within_30_days_n" VARCHAR,
  "diagnosis_to_fls_assessment_within_30_days" VARCHAR,
  "diagnosis_to_fls_assessment_within_90_days_n" VARCHAR,
  "diagnosis_to_fls_assessment_within_90_days" VARCHAR,
  "diagnosis_to_fls_assessment_91_days_or_more_n" VARCHAR,
  "diagnosis_to_fls_assessment_91_days_or_more" VARCHAR,
  "diagnosis_to_fls_assessment_days_missing_n" VARCHAR,
  "diagnosis_to_fls_assessment_days_missing" VARCHAR,
  "time_to_dxa_scan_from_fracture_diagnosis_within_7_days_n" VARCHAR,
  "time_to_dxa_scan_from_fracture_diagnosis_within_7_days" VARCHAR,
  "time_to_dxa_scan_from_fracture_diagnosis_within_30_days_n" VARCHAR,
  "time_to_dxa_scan_from_fracture_diagnosis_within_30_days" VARCHAR,
  "time_to_dxa_scan_from_fracture_diagnosis_within_90_days_n" VARCHAR,
  "time_to_dxa_scan_from_fracture_diagnosis_within_90_days" VARCHAR,
  "time_to_dxa_scan_from_fracture_diagnosis_within_91_day_ec464ff9" VARCHAR,
  "time_to_dxa_scan_from_fracture_diagnosis_within_91_day_f02921da" VARCHAR,
  "time_to_dxa_scan_from_fracture_diagnosis_days_missing_n" VARCHAR,
  "time_to_dxa_scan_from_fracture_diagnosis_days_missing" VARCHAR,
  "total_dxa_recommended" BIGINT,
  "number_of_cases_submitted_n" BIGINT,
  "q4_01_bone_therapy_recommended_after_index_fracture_tr_63c3e272" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_tr_41445d31" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_in_3c5761ab" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_in_8cc7ffeb" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_in_1d7a393a" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_in_8a31400f" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_re_3fe0ffa1" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_re_4c9de572" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_re_a98fa517" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_re_4fd40006" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_do_ae1ac06b" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_don_t_know" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_missing_n" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_missing" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_al_266eb7e1" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_al_345df7e9" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_ri_3496569e" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_ri_cf4176ec" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_ib_3ff2ceb5" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_ib_6411f849" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_ra_6cea0954" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_raloxifene" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_te_3c55738d" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_te_1d2b6520" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_st_aef7a0ed" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_strontium" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_de_922c579c" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_denosumab" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_zo_989cb5b7" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_zo_e8f2442e" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_ot_b53e3549" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_ot_5b6b9618" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_ac_40399cda" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_ac_2789ee1e" VARCHAR,
  "q4_01_bone_therapy_recommended_after_index_fracture_to_2d105bef" VARCHAR,
  "number_of_cases_submitted_n_1" BIGINT,
  "q5_01_falls_risk_assessment_performed_by_fls_not_done_n" VARCHAR,
  "q5_01_falls_risk_assessment_performed_by_fls_not_done" VARCHAR,
  "q5_01_falls_risk_assessment_performed_by_fls_falls_ris_ac4a1a74" VARCHAR,
  "q5_01_falls_risk_assessment_performed_by_fls_falls_ris_7b8da6f2" VARCHAR,
  "q5_01_falls_risk_assessment_performed_by_fls_not_recorded_n" VARCHAR,
  "q5_01_falls_risk_assessment_performed_by_fls_not_recorded" VARCHAR,
  "q5_01_falls_risk_assessment_performed_by_fls_missing_n" VARCHAR,
  "q5_01_falls_risk_assessment_performed_by_fls_missing" VARCHAR,
  "total_patient_records_n" VARCHAR,
  "patients_followed_up_of_those_prescribed_bone_therapy__62b43a35" VARCHAR,
  "patients_followed_up_of_those_prescribed_bone_therapy__dece13dc" VARCHAR,
  "total_recommended_bone_therapy_n" VARCHAR,
  "proportion_of_patients_with_a_valid_bone_therapy_recom_3614a7d4" VARCHAR,
  "proportion_of_patients_with_a_valid_bone_therapy_recom_4d6e3c7a" VARCHAR
);