NACAP Pulmonary Rehabilitation 2021 Organisational Audit

CREATE TABLE table_1 (
  "region" VARCHAR,
  "integrated_care_system_ics" VARCHAR  -- Integrated Care System (ICS),
  "trust_name" VARCHAR,
  "pulmonary_rehabilitation_pr_service_name" VARCHAR  -- Pulmonary Rehabilitation (PR) Service Name,
  "pr_offered_to_people_with_copd_with_the_following_self_713a13f0" VARCHAR  -- PR Offered To People With COPD With The Following Self-reported Medical Research Council (MRC) Grades: 1,
  "pr_offered_to_people_with_copd_with_the_following_self_0a9cef7b" VARCHAR  -- PR Offered To People With COPD With The Following Self-reported MRC Grade: 2,
  "pr_offered_to_people_with_copd_with_the_following_self_5bde352c" VARCHAR  -- PR Offered To People With COPD With The Following Self-reported MRC Grade: 3,
  "pr_offered_to_people_with_copd_with_the_following_self_5f028c88" VARCHAR  -- PR Offered To People With COPD With The Following Self-reported MRC Grade: 4,
  "pr_offered_to_people_with_copd_with_the_following_self_16d7ccfe" VARCHAR  -- PR Offered To People With COPD With The Following Self-reported MRC Grade: 5,
  "pr_offered_to_people_with_copd_who_have_previously_com_7157db1d" VARCHAR  -- PR Offered To People With COPD Who Have Previously Completed A PR Programme,
  "pr_offered_to_people_discharged_from_hospital_with_a_d_35bc51ac" VARCHAR  -- PR Offered To People Discharged From Hospital With A Diagnosis Of Acute Exacerbation Of COPD (AECOPD),
  "pr_offered_to_people_with_long_term_conditions_other_than_copd" VARCHAR,
  "programme_structure" VARCHAR,
  "typical_duration_of_centre_based_pr_programme_s_4_weeks" VARCHAR  -- Typical Duration Of Centre-based PR Programme(s): 4 Weeks,
  "typical_duration_of_centre_based_pr_programme_s_5_weeks" VARCHAR  -- Typical Duration Of Centre-based PR Programme(s): 5 Weeks,
  "typical_duration_of_centre_based_pr_programme_s_6_weeks" VARCHAR  -- Typical Duration Of Centre-based PR Programme(s): 6 Weeks,
  "typical_duration_of_centre_based_pr_programme_s_7_weeks" VARCHAR  -- Typical Duration Of Centre-based PR Programme(s): 7 Weeks,
  "typical_duration_of_centre_based_pr_programme_s_8_weeks" VARCHAR  -- Typical Duration Of Centre-based PR Programme(s): 8 Weeks,
  "typical_duration_of_centre_based_pr_programme_s_more_t_d29891a0" VARCHAR  -- Typical Duration Of Centre-based PR Programme(s): More Than 8 Weeks,
  "number_of_supervised_centre_based_pr_sessions_people_a_bac2197f" VARCHAR  -- Number Of Supervised Centre-based PR Sessions People Are Expected To Attend Per Week: 1,
  "number_of_supervised_centre_based_pr_sessions_people_a_c85d5504" VARCHAR  -- Number Of Supervised Centre-based PR Sessions People Are Expected To Attend Per Week: 2,
  "number_of_supervised_centre_based_pr_sessions_people_a_697780c8" VARCHAR  -- Number Of Supervised Centre-based PR Sessions People Are Expected To Attend Per Week: 3,
  "number_of_supervised_centre_based_pr_sessions_people_a_53ab73cb" VARCHAR  -- Number Of Supervised Centre-based PR Sessions People Are Expected To Attend Per Week: More Than 3,
  "home_based_pr_programme_offered" VARCHAR,
  "all_people_attending_home_based_pr_programme_are_offer_6040f436" VARCHAR  -- All People Attending Home-based PR Programme Are Offered Initial And Discharge Assessments,
  "people_attending_home_based_pr_programme_are_offered_s_0b0dfecf" VARCHAR  -- People Attending Home-based PR Programme Are Offered Supervised PR Sessions In Their Homes,
  "typical_duration_of_home_based_pr_programme_4_weeks" VARCHAR  -- Typical Duration Of Home-based PR Programme: 4 Weeks,
  "typical_duration_of_home_based_pr_programme_5_weeks" VARCHAR  -- Typical Duration Of Home-based PR Programme: 5 Weeks,
  "typical_duration_of_home_based_pr_programme_6_weeks" VARCHAR  -- Typical Duration Of Home-based PR Programme: 6 Weeks,
  "typical_duration_of_home_based_pr_programme_7_weeks" VARCHAR  -- Typical Duration Of Home-based PR Programme: 7 Weeks,
  "typical_duration_of_home_based_pr_programme_8_weeks" VARCHAR  -- Typical Duration Of Home-based PR Programme: 8 Weeks,
  "typical_duration_of_home_based_pr_programme_more_than_8_weeks" VARCHAR  -- Typical Duration Of Home-based PR Programme: More Than 8 Weeks,
  "number_of_supervised_home_based_pr_sessions_offered_per_week_1" VARCHAR  -- Number Of Supervised Home-based PR Sessions Offered Per Week: 1,
  "number_of_supervised_home_based_pr_sessions_offered_per_week_2" VARCHAR  -- Number Of Supervised Home-based PR Sessions Offered Per Week: 2,
  "number_of_supervised_home_based_pr_sessions_offered_per_week_3" VARCHAR  -- Number Of Supervised Home-based PR Sessions Offered Per Week: 3,
  "number_of_supervised_home_based_pr_sessions_offered_pe_78d9342a" VARCHAR  -- Number Of Supervised Home-based PR Sessions Offered Per Week: More Than 3,
  "people_sent_information_about_pr_programme_prior_to_th_bb45bae5" VARCHAR  -- People Sent Information About PR Programme Prior To Their Initial Assessment,
  "funded_transport_available" VARCHAR,
  "measures_of_exercise_capacity_used_at_assessments_or_r_40095bd8" VARCHAR  -- Measures Of Exercise Capacity Used At Assessments Or Referred To As Outcome Measures: Endurance Shuttle Walk Test (ESWT),
  "measures_of_exercise_capacity_used_at_assessments_or_r_3b59df39" VARCHAR  -- Measures Of Exercise Capacity Used At Assessments Or Referred To As Outcome Measures: Incremental Shuttle Walk Test (ISWT),
  "measures_of_exercise_capacity_used_at_assessments_or_r_50d62e76" VARCHAR  -- Measures Of Exercise Capacity Used At Assessments Or Referred To As Outcome Measures: Sit-to-stand (STS),
  "measures_of_exercise_capacity_used_at_assessments_or_r_92a7f054" VARCHAR  -- Measures Of Exercise Capacity Used At Assessments Or Referred To As Outcome Measures: Six Minute Walk Test (6MWT),
  "if_6mwt_number_of_sites_that_use_a_30_metre_course_to__d6ed2b51" VARCHAR  -- If 6MWT, Number Of Sites That Use A 30-metre Course To Conduct The 6MWT,
  "muscle_strength_is_measured_at_assessment" VARCHAR,
  "measures_collected_at_initial_and_discharge_assessment_0e628075" VARCHAR  -- Measures Collected At Initial And Discharge Assessment Include: Activities Of Daily Living Scale,
  "measures_collected_at_initial_and_discharge_assessment_b65f9354" VARCHAR  -- Measures Collected At Initial And Discharge Assessment Include: Hospital Anxiety And Depression Scores,
  "measures_collected_at_initial_and_discharge_assessment_027d7838" VARCHAR  -- Measures Collected At Initial And Discharge Assessment Include: Knowledge Gained During Education,
  "measures_collected_at_initial_and_discharge_assessment_c9099d37" VARCHAR  -- Measures Collected At Initial And Discharge Assessment Include: Other Psychological Status Scores,
  "measures_collected_at_initial_and_discharge_assessment_99c55f90" VARCHAR  -- Measures Collected At Initial And Discharge Assessment Include: Patient Satisfaction,
  "measures_collected_at_initial_and_discharge_assessment_351d460a" VARCHAR  -- Measures Collected At Initial And Discharge Assessment Include: Patient Experience,
  "measures_collected_at_initial_and_discharge_assessment_af1cba46" VARCHAR  -- Measures Collected At Initial And Discharge Assessment Include: Physical Activity,
  "measures_collected_at_initial_and_discharge_assessment_953975b2" VARCHAR  -- Measures Collected At Initial And Discharge Assessment Include: None Of These Measures Are Collected,
  "aerobic_training_is_offered_as_part_of_the_pr_programme" VARCHAR,
  "types_of_aerobic_training_offered_as_part_of_pr_progra_3db82a88" VARCHAR  -- Types Of Aerobic Training Offered As Part Of PR Programme: Cycling,
  "types_of_aerobic_training_offered_as_part_of_pr_progra_d8a4d2c0" VARCHAR  -- Types Of Aerobic Training Offered As Part Of PR Programme: Walking,
  "types_of_aerobic_training_offered_as_part_of_pr_programme_other" VARCHAR  -- Types Of Aerobic Training Offered As Part Of PR Programme: Other,
  "aerobic_training_is_individually_prescribed" VARCHAR,
  "method_s_used_to_prescribe_aerobic_training_borg_or_pe_defd31a5" VARCHAR  -- Method(s) Used To Prescribe Aerobic Training: Borg Or Perceived Exertion Scores,
  "method_s_used_to_prescribe_aerobic_training_endurance__0928d90f" VARCHAR  -- Method(s) Used To Prescribe Aerobic Training: Endurance Shuttle Walking Test (ESWT) Level From ISWT,
  "method_s_used_to_prescribe_aerobic_training_from_six_m_4d4f9994" VARCHAR  -- Method(s) Used To Prescribe Aerobic Training: From Six-minute Walk Test (6MWT),
  "method_s_used_to_prescribe_aerobic_training_from_incre_bb7ca68f" VARCHAR  -- Method(s) Used To Prescribe Aerobic Training: From Incremental Shuttle Walk Test (ISWT),
  "intensity_of_aerobic_exercise_prescription_used" VARCHAR,
  "resistance_training_is_offered_during_pr_programme" VARCHAR,
  "resistance_training_is_individually_prescribed" VARCHAR,
  "method_s_used_to_prescribe_resistance_training_borg_or_e18787b6" VARCHAR  -- Method(s) Used To Prescribe Resistance Training: Borg Or Perceived Exertion Scores,
  "method_s_used_to_prescribe_resistance_training_measure_6fd93b50" VARCHAR  -- Method(s) Used To Prescribe Resistance Training: Measurement Of 1RM Or Strength,
  "method_s_used_to_prescribe_resistance_training_other" VARCHAR  -- Method(s) Used To Prescribe Resistance Training: Other,
  "people_are_advised_to_do_unsupervised_home_exercise_du_52e21eaf" VARCHAR  -- People Are Advised To Do Unsupervised Home Exercise During Their PR Programme As Part Of Centre-based Programme,
  "people_are_advised_to_do_unsupervised_home_exercise_du_2cac2993" VARCHAR  -- People Are Advised To Do Unsupervised Home Exercise During Their PR Programme As Part Of Home-based Programme,
  "number_of_hours_of_education_scheduled_during_a_centre_d2559304" DOUBLE  -- Number Of Hours Of Education Scheduled During A Centre-based PR Programme,
  "number_of_hours_of_education_scheduled_during_a_home_b_b0352c41" DOUBLE  -- Number Of Hours Of Education Scheduled During A Home-based PR Programme,
  "method_of_providing_education_both_centre_and_home_bas_da02c1c3" VARCHAR  -- Method Of Providing Education (both Centre And Home-based Programmes): CD,
  "method_of_providing_education_both_centre_and_home_bas_818764e3" VARCHAR  -- Method Of Providing Education (both Centre And Home-based Programmes): DVD,
  "method_of_providing_education_both_centre_and_home_bas_18c7ac87" VARCHAR  -- Method Of Providing Education (both Centre And Home-based Programmes): Face-to-face Group Education Sessions,
  "method_of_providing_education_both_centre_and_home_bas_4c061d0e" VARCHAR  -- Method Of Providing Education (both Centre And Home-based Programmes): Virtual Group Sessions,
  "method_of_providing_education_both_centre_and_home_bas_ecc7d5c0" VARCHAR  -- Method Of Providing Education (both Centre And Home-based Programmes): Information On Dedicated Website,
  "method_of_providing_education_both_centre_and_home_bas_929ba94a" VARCHAR  -- Method Of Providing Education (both Centre And Home-based Programmes): Written Handouts,
  "method_of_providing_education_both_centre_and_home_bas_2deb4299" VARCHAR  -- Method Of Providing Education (both Centre And Home-based Programmes): Telephone,
  "method_of_providing_education_both_centre_and_home_bas_0170a966" VARCHAR  -- Method Of Providing Education (both Centre And Home-based Programmes): Other,
  "staff_involved_in_delivery_of_face_to_face_or_virtual__7baf52ae" VARCHAR  -- Staff Involved In Delivery Of Face-to-face Or Virtual Group Education Sessions : Clinical Psychologist,
  "staff_involved_in_delivery_of_face_to_face_or_virtual__946285a1" VARCHAR  -- Staff Involved In Delivery Of Face-to-face Or Virtual Group Education Sessions : Dietician,
  "staff_involved_in_delivery_of_face_to_face_or_virtual__a73ec584" VARCHAR  -- Staff Involved In Delivery Of Face-to-face Or Virtual Group Education Sessions: Exercise Physiologist,
  "staff_involved_in_delivery_of_face_to_face_or_virtual__8c74d16c" VARCHAR  -- Staff Involved In Delivery Of Face-to-face Or Virtual Group Education Sessions: Fitness Instructor,
  "staff_involved_in_delivery_of_face_to_face_or_virtual__99d31b5a" VARCHAR  -- Staff Involved In Delivery Of Face-to-face Or Virtual Group Education Sessions: Health Care/therapy Assistant,
  "staff_involved_in_delivery_of_face_to_face_or_virtual__59ff64d6" VARCHAR  -- Staff Involved In Delivery Of Face-to-face Or Virtual Group Education Sessions: Health Psychologist,
  "staff_involved_in_delivery_of_face_to_face_or_virtual__b4139113" VARCHAR  -- Staff Involved In Delivery Of Face-to-face Or Virtual Group Education Sessions: Occupational Therapist,
  "staff_involved_in_delivery_of_face_to_face_or_virtual__f704dd32" VARCHAR  -- Staff Involved In Delivery Of Face-to-face Or Virtual Group Education Sessions: Pharmacist,
  "staff_involved_in_delivery_of_face_to_face_or_virtual__3f2e6066" VARCHAR  -- Staff Involved In Delivery Of Face-to-face Or Virtual Group Education Sessions: Physiotherapist,
  "staff_involved_in_delivery_of_face_to_face_or_virtual__e70f610d" VARCHAR  -- Staff Involved In Delivery Of Face-to-face Or Virtual Group Education Sessions: Registered Nurse,
  "staff_involved_in_delivery_of_face_to_face_or_virtual__85144fc3" VARCHAR  -- Staff Involved In Delivery Of Face-to-face Or Virtual Group Education Sessions: Respiratory Physician,
  "staff_involved_in_delivery_of_face_to_face_or_virtual__3cf47883" VARCHAR  -- Staff Involved In Delivery Of Face-to-face Or Virtual Group Education Sessions: Respiratory Physiologist,
  "staff_involved_in_delivery_of_face_to_face_or_virtual__e7602eac" VARCHAR  -- Staff Involved In Delivery Of Face-to-face Or Virtual Group Education Sessions: Social Worker,
  "staff_involved_in_delivery_of_face_to_face_or_virtual__a5314f80" VARCHAR  -- Staff Involved In Delivery Of Face-to-face Or Virtual Group Education Sessions: Technical Instructor,
  "staff_involved_in_delivery_of_face_to_face_or_virtual__2c07c56c" VARCHAR  -- Staff Involved In Delivery Of Face-to-face Or Virtual Group Education Sessions: Volunteer,
  "staff_involved_in_delivery_of_face_to_face_or_virtual__90b8a63a" VARCHAR  -- Staff Involved In Delivery Of Face-to-face Or Virtual Group Education Sessions: Other,
  "topics_covered_in_face_to_face_or_virtual_group_educat_aa364c97" VARCHAR  -- Topics Covered In Face-to-face Or Virtual Group Education Sessions: Advance Directives,
  "topics_covered_in_face_to_face_or_virtual_group_educat_f4ff53be" VARCHAR  -- Topics Covered In Face-to-face Or Virtual Group Education Sessions: Anatomy, Physiology, Pathology—in Health And In Chronic Respiratory Disease,
  "topics_covered_in_face_to_face_or_virtual_group_educat_168d2602" VARCHAR  -- Topics Covered In Face-to-face Or Virtual Group Education Sessions: Anxiety Management And Relaxation,
  "topics_covered_in_face_to_face_or_virtual_group_educat_f3af70e0" VARCHAR  -- Topics Covered In Face-to-face Or Virtual Group Education Sessions: Benefits System And Welfare Rights,
  "topics_covered_in_face_to_face_or_virtual_group_educat_0f424d29" VARCHAR  -- Topics Covered In Face-to-face Or Virtual Group Education Sessions: Chest Clearance Techniques
);