Community Survey: 2023 Survey Data

CREATE TABLE table_1 (
  "id" BIGINT,
  "q1a_the_overall_quality_of_life_in_the_city_of_bloomington" DOUBLE,
  "q1b_bloomington_as_a_place_to_live" DOUBLE,
  "q1c_bloomington_as_a_place_to_raise_children" DOUBLE,
  "q1d_bloomington_as_a_place_to_visit" DOUBLE,
  "q1e_your_neighborhood_as_a_place_to_live" DOUBLE,
  "q1f_bloomington_as_a_place_to_retire" DOUBLE,
  "q1g_bloomington_as_a_place_to_work" DOUBLE,
  "q1h_bloomington_as_a_place_to_grow_a_business" DOUBLE,
  "q2a_recommend_living_in_bloomington_to_someone_who_asks" DOUBLE,
  "q2b_remain_in_bloomington_for_the_next_five_years" DOUBLE,
  "q3a_overall_opportunities_for_education_and_enrichment" DOUBLE,
  "q3b_quality_of_overall_natural_environment_in_bloomington" DOUBLE,
  "q3c_overall_image_or_reputation_of_bloomington" DOUBLE,
  "q3d_health_and_wellness_opportunities_in_bloomington" DOUBLE,
  "q3e_overall_ease_of_getting_to_the_places_you_usually_visit" DOUBLE,
  "q3f_sense_of_community" DOUBLE,
  "q3g_overall_built_environment_of_bloomington_including_015f464f" DOUBLE  -- Q3g Overall "built Environment" Of Bloomington (including Overall Design Of Buildings, Parks, And Transportation Systems),
  "q3h_overall_economic_health_of_bloomington" DOUBLE,
  "q4a_opportunities_to_attend_cultural_arts_music_activities" DOUBLE,
  "q4b_opportunities_to_participate_in_religious_or_spiri_9a40ae51" DOUBLE  -- Q4b Opportunities To Participate In Religious Or Spiritual Events And Activities,
  "q4c_opportunities_to_volunteer" DOUBLE,
  "q4d_air_quality" DOUBLE,
  "q4e_adult_educational_opportunities" DOUBLE,
  "q4f_openness_and_acceptance_of_the_community_toward_pe_cd61360b" DOUBLE  -- Q4f Openness And Acceptance Of The Community Toward People Of Diverse Backgrounds,
  "q4g_recreational_opportunities" DOUBLE,
  "q4h_opportunities_to_participate_in_social_events_and__611d9445" DOUBLE  -- Q4h Opportunities To Participate In Social Events And Activities,
  "q4i_fitness_opportunities" DOUBLE,
  "q4j_opportunities_to_participate_in_community_matters" DOUBLE,
  "q4k_k_12_education" DOUBLE,
  "q4l_overall_appearance" DOUBLE,
  "q4m_overall_quality_of_business_and_service_establishm_cb1561d3" DOUBLE  -- Q4m Overall Quality Of Business And Service Establishments In Bloomington,
  "q4n_availability_of_affordable_food" DOUBLE,
  "q4o_entertainment_downtown" DOUBLE,
  "q4p_public_places_where_people_want_to_spend_time" DOUBLE,
  "q4q_cleanliness_of_the_city" DOUBLE,
  "q4r_neighborliness_of_residents_in_bloomington" DOUBLE,
  "q4s_shopping_opportunities_outside_downtown" DOUBLE,
  "q4t_shopping_opportunities_downtown" DOUBLE,
  "q4u_availability_of_affordable_health_care" DOUBLE,
  "q4v_variety_of_housing_options" DOUBLE,
  "q4w_entertainment_outside_downtown" DOUBLE,
  "q4x_cost_of_living_in_bloomington" DOUBLE,
  "q4y_employment_opportunities" DOUBLE,
  "q4z_availability_of_affordable_mental_health_care" DOUBLE,
  "q4aa_availability_of_affordable_child_care_preschool" DOUBLE,
  "q4bb_availability_of_affordable_housing" DOUBLE,
  "q4cc_sustainability" DOUBLE,
  "q5a_in_your_neighborhood_during_the_day" DOUBLE,
  "q5b_in_bloomington_s_downtown_area_during_the_day" DOUBLE,
  "q5c_in_your_neighborhood_at_night" DOUBLE,
  "q5d_in_bloomington_s_downtown_area_at_night" DOUBLE,
  "q6a_availability_of_paths_and_walking_trails" DOUBLE,
  "q6b_ease_of_walking" DOUBLE,
  "q6c_ease_of_travel_by_car" DOUBLE,
  "q6d_ease_of_travel_by_bicycle" DOUBLE,
  "q6e_traffic_flow_on_major_streets" DOUBLE,
  "q6f_ease_of_travel_by_public_transportation" DOUBLE,
  "q6g_ease_of_public_parking" DOUBLE,
  "q6h_cost_of_public_parking" DOUBLE,
  "q7_what_is_one_thing_you_like_most_about_the_city_of_b_a78f9dee" DOUBLE  -- Q7 What Is One Thing You Like Most About The City Of Bloomington?,
  "q8_what_is_one_thing_you_like_least_about_the_city_of__ace13ca9" DOUBLE  -- Q8 What Is One Thing You Like Least About The City Of Bloomington?,
  "q9a_made_efforts_to_make_your_home_more_energy_efficient" DOUBLE,
  "q9b_made_efforts_to_conserve_water" DOUBLE,
  "q9c_observed_a_code_violation_or_other_hazard_in_the_c_a7954ad9" DOUBLE  -- Q9c Observed A Code Violation Or Other Hazard In The City Of Bloomington (weeds, Scattered Trash, Etc.),
  "q9d_attended_an_event_meeting_or_convention_at_the_blo_6c395ae8" DOUBLE  -- Q9d Attended An Event, Meeting Or Convention At The Bloomington/Monroe Convention Center,
  "q9e_stocked_supplies_in_preparation_for_an_emergency" DOUBLE,
  "q9f_campaigned_or_advocated_for_an_issue_cause_or_candidate" DOUBLE  -- Q9f Campaigned Or Advocated For An Issue, Cause Or Candidate,
  "q9g_you_or_a_household_member_reported_a_crime_to_the__7f94d8e6" DOUBLE  -- Q9g You Or A Household Member Reported A Crime To The Police In The City Of Bloomington,
  "q9h_you_or_a_household_member_were_a_victim_of_a_crime_83535353" DOUBLE  -- Q9h You Or A Household Member Were A Victim Of A Crime In The City Of Bloomington,
  "q10a_talked_to_or_visited_with_your_immediate_neighbors" DOUBLE,
  "q10b_walked_or_biked_instead_of_driving" DOUBLE,
  "q10c_attended_an_event_offered_by_the_city_of_bloomington" DOUBLE,
  "q10d_done_a_favor_for_a_neighbor" DOUBLE,
  "q10e_carpooled_with_other_adults_or_children_instead_o_ed57df6b" DOUBLE  -- Q10e Carpooled With Other Adults Or Children Instead Of Driving Alone,
  "q10f_volunteered_your_time_to_some_group_activity_in_b_3b1753bc" DOUBLE  -- Q10f Volunteered Your Time To Some Group/activity In Bloomington,
  "q10g_used_bus_or_other_public_transportation_instead_of_driving" DOUBLE,
  "q10h_participated_in_religious_or_spiritual_activities" DOUBLE,
  "q10i_watched_online_or_on_television_a_local_public_me_49fa656b" DOUBLE  -- Q10i Watched (online Or On Television) A Local Public Meeting Of Local Elected Officials (like City Council Or County Commissioners, Advisory Boards, Town Halls, Etc.),
  "q10j_voted_in_your_most_recent_local_election" DOUBLE,
  "q11a_the_city_of_bloomington" DOUBLE,
  "q11b_monroe_county_government" DOUBLE,
  "q11c_indiana_state_government" DOUBLE,
  "q11d_the_federal_government" DOUBLE,
  "q12a_the_job_city_government_does_at_welcoming_citizen_3c082e48" DOUBLE  -- Q12a The Job City Government Does At Welcoming Citizen Involvement,
  "q12b_the_value_of_services_for_the_taxes_paid_to_the_city" DOUBLE,
  "q12c_the_overall_direction_that_the_city_is_taking" DOUBLE,
  "q12d_generally_acting_in_the_best_interest_of_the_community" DOUBLE,
  "q12e_overall_confidence_in_city_government" DOUBLE,
  "q12f_being_honest_transparent" DOUBLE,
  "q12g_treating_all_residents_fairly" DOUBLE,
  "q12h_listening_to_public_concern" DOUBLE,
  "q13a_fire_services" DOUBLE,
  "q13b_ambulance_or_emergency_medical_services" DOUBLE,
  "q13c_farmers_market" DOUBLE,
  "q13d_lotus_festival" DOUBLE,
  "q13e_fourth_street_arts_fair" DOUBLE,
  "q13f_garbage_collection" DOUBLE,
  "q13g_trails" DOUBLE,
  "q13h_police_services" DOUBLE
);