City Of Tempe 2022 Employee Survey Data

CREATE TABLE table_1 (
  "q1_01_1_i_receive_training" BIGINT  -- Q1–01, , 1, I Receive Training,
  "q1_02_2_there_is_someone_at" BIGINT  -- Q1–02, , 2, There Is Someone At,
  "q1_03_3_i_have_been_mentore" BIGINT  -- Q1–03, , 3, I Have Been Mentore,
  "q1_04_4_i_have_received_fai" BIGINT  -- Q1–04, , 4, I Have Received Fai,
  "q1_05_5_i_am_aware_of_the_c" BIGINT  -- Q1–05, , 5, I Am Aware Of The C,
  "q1_07_7_overall_i_am_satis" BIGINT  -- Q1–07, , 7, Overall, I Am Satis,
  "q2_01_1_city_manager_s_offi" BIGINT  -- Q2–01, , 1, City Manager S Offi,
  "q2_06_6_diversity_equity" BIGINT  -- Q2–06, , 6, Diversity, Equity,,
  "q3_01_1_the_wellness_progra" BIGINT  -- Q3–01, , 1, The Wellness Progra,
  "q3_02_2_city_mediation_serv" BIGINT  -- Q3–02, , 2, City Mediation Serv,
  "q3_03_3_the_safe_haven_proc" BIGINT  -- Q3–03, , 3, The Safe Haven Proc,
  "q3_04_4_tempe_employee_view" BIGINT  -- Q3–04, , 4, Tempe Employee View,
  "q3_05_5_the_director_chief" BIGINT  -- Q3–05, , 5, The Director Chief,
  "q3_06_6_my_physical_work_en" BIGINT  -- Q3–06, , 6, My Physical Work En,
  "q3_07_7_the_city_supports_e" BIGINT  -- Q3–07, , 7, The City Supports E,
  "q3_08_8_overall_i_am_satis" BIGINT  -- Q3–08, , 8, Overall, I Am Satis,
  "q4_01_1_my_immediate_supervi" BIGINT  -- Q4–01, 1, My Immediate Supervi,
  "q4_02_2_i_know_what_is_expec" BIGINT  -- Q4–02, 2, I Know What Is Expec,
  "q4_03_3_i_have_the_materials" BIGINT  -- Q4–03, 3, I Have The Materials,
  "q4_04_4_i_am_comfortable_exp" BIGINT  -- Q4–04, 4, I Am Comfortable Exp,
  "q4_05_5_i_believe_my_opinion" BIGINT  -- Q4–05, 5, I Believe My Opinion,
  "q4_06_6_my_work_is_appreciat" BIGINT  -- Q4–06, 6, My Work Is Appreciat,
  "q4_07_7_my_immediate_supervi" BIGINT  -- Q4–07, 7, My Immediate Supervi,
  "q4_08_8_my_immediate_supervi" BIGINT  -- Q4–08, 8, My Immediate Supervi,
  "q4_09_9_i_receive_constructi" BIGINT  -- Q4–09, 9, I Receive Constructi,
  "q4_10_10_the_work_i_perform" BIGINT  -- Q4–10, 10, The Work I Perform,
  "q4_11_11_my_immediate_superv" BIGINT  -- Q4–11, 11, My Immediate Superv,
  "q4_12_12_my_immediate_superv" BIGINT  -- Q4–12, 12, My Immediate Superv,
  "q4_13_13_within_the_last_30" BIGINT  -- Q4–13, 13, Within The Last 30,
  "q4_14_14_when_i_request_trai" BIGINT  -- Q4–14, 14, When I Request Trai,
  "q4_15_15_the_director_chief" BIGINT  -- Q4–15, 15, The Director Chief,
  "q4_16_16_i_believe_the_direc" BIGINT  -- Q4–16, 16, I Believe The Direc,
  "q4_17_17_as_a_supervisor_i" BIGINT  -- Q4–17, 17, As A Supervisor, I,
  "q4_18_18_as_a_supervisor_my" BIGINT  -- Q4–18, 18, As A Supervisor, My,
  "q4_19_19_conflict_in_my_work" BIGINT  -- Q4–19, 19, Conflict In My Work,
  "q4_20_20_i_believe_assignmen" BIGINT  -- Q4–20, 20, I Believe Assignmen,
  "q4_21_21_i_believe_exception" BIGINT  -- Q4–21, 21, I Believe Exception,
  "q4_22_22_i_believe_poor_job" BIGINT  -- Q4–22, 22, I Believe Poor Job,
  "q4_23_23_as_a_supervisor_i" BIGINT  -- Q4–23, 23, As A Supervisor, I,
  "q4_24_24_i_feel_physically_s" BIGINT  -- Q4–24, 24, I Feel Physically S,
  "q4_25_25_i_am_able_to_discus" BIGINT  -- Q4–25, 25, I Am Able To Discus,
  "q4_26_26_my_immediate_superv" BIGINT  -- Q4–26, 26, My Immediate Superv,
  "q4_27_27_overall_i_am_satis" BIGINT  -- Q4–27, 27, Overall, I Am Satis,
  "q5_01_1_the_city_s_health_ca" VARCHAR  -- Q5–01, 1, The City S Health Ca,
  "q5_07_7_overall_i_am_reason" BIGINT  -- Q5–07, 7, Overall, I Am Reason,
  "q5a_are_you_currently_enrolled" BIGINT  -- Q5a, Are You Currently Enrolled,
  "q6_01_1_i_receive_informat" BIGINT  -- Q6–01, , 1, I Receive Informat,
  "q6_02_2_i_am_comfortable_e" BIGINT  -- Q6–02, , 2, I Am Comfortable E,
  "q6_03_3_generally_communi" BIGINT  -- Q6–03, , 3, Generally, Communi,
  "q6_04_4_generally_communi" BIGINT  -- Q6–04, , 4, Generally, Communi,
  "q6_05_5_with_respect_to_my" BIGINT  -- Q6–05, , 5, With Respect To My,
  "q6_06_6_i_have_adequate_in" BIGINT  -- Q6–06, , 6, I Have Adequate In,
  "q6_07_7_the_director_chief" BIGINT  -- Q6–07, , 7, The Director Chief,
  "q6_08_8_the_director_chief" BIGINT  -- Q6–08, , 8, The Director Chief,
  "q6_09_9_i_am_encouraged_to" BIGINT  -- Q6–09, , 9, I Am Encouraged To,
  "q6_10_10_employees_in_my_d" BIGINT  -- Q6–10, , 10, Employees In My D,
  "q6_11_11_employees_in_my_d" BIGINT  -- Q6–11, , 11, Employees In My D,
  "q6_12_12_overall_i_am_sat" BIGINT  -- Q6–12, , 12, Overall, I Am Sat,
  "q6_13_13_i_am_aware_of_the" BIGINT  -- Q6–13, , 13, I Am Aware Of The,
  "q6_14_14_i_feel_my_departm" BIGINT  -- Q6–14, , 14, I Feel My Departm,
  "q6_15_15_i_feel_the_city_p" BIGINT  -- Q6–15, , 15, I Feel The City P,
  "q7_01_1_my_co_workers_treat" BIGINT  -- Q7–01, , 1, My Co Workers Treat,
  "q7_02_2_conflict_between_co" BIGINT  -- Q7–02, , 2, Conflict Between Co,
  "q7_03_3_overall_i_am_very" BIGINT  -- Q7–03, , 3, Overall, I Am Very,
  "q8_are_you_aware_of_the_counci" BIGINT  -- Q8, Are You Aware Of The Counci,
  "q9_are_you_proud_to_work_for_t" BIGINT  -- Q9, Are You Proud To Work For T,
  "q10_overall_how_satisfied_are" BIGINT  -- Q10, Overall, How Satisfied Are,
  "q11_how_has_the_quality_of_the" BIGINT  -- Q11, How Has The Quality Of The,
  "q12_would_you_recommend_the_ci" BIGINT  -- Q12, Would You Recommend The Ci,
  "q13_does_the_city_s_working_en" BIGINT  -- Q13, Does The City S Working En,
  "q17_02_cit2_court" BIGINT  -- Q17–02, Cit2 Court,
  "q17_03_communit3_development" BIGINT  -- Q17–03, Communit3 Development,
  "q17_04_communit4_services_dep" BIGINT  -- Q17–04, Communit4 Services Dep,
  "q17_05_engineering_and_transp" BIGINT  -- Q17–05, Engineering And Transp,
  "q17_06_fire_medical_rescue_de" BIGINT  -- Q17–06, Fire Medical Rescue De,
  "q17_07_human_services_departm" BIGINT  -- Q17–07, Human Services Departm,
  "q17_08_municipal_utilities_de" BIGINT  -- Q17–08, Municipal Utilities De,
  "q17_09_police_department" BIGINT  -- Q17–09, Police Department,
  "q17_10_human_resources_depart" BIGINT  -- Q17–10, Human Resources Depart,
  "q17_11_information_technolog1" BIGINT  -- Q17–11, Information Technolog1,
  "q17_12_financial_services_dep" BIGINT  -- Q17–12, Financial Services Dep,
  "q17_13_cit13_manager_s_office" BIGINT  -- Q17–13, Cit13 Manager S Office,
  "objectid" BIGINT
);