Public Safety For All Community Survey Results

CREATE TABLE table_1 (
  "timestamp" VARCHAR,
  "language" VARCHAR,
  "n__language_english_nonenglish" VARCHAR,
  "does_the_somerville_police_department_treat_people_in__61202d9b" DOUBLE,
  "do_the_somerville_police_department_officers_in_your_n_b6e8ed9b" DOUBLE,
  "how_often_do_you_see_somerville_police_officers_in_you_a8337a83" DOUBLE,
  "have_you_ever_had_a_personal_encounter_with_an_somervi_b96323c7" VARCHAR,
  "n__encounter_type_traffic_stop" DOUBLE,
  "n__encounter_type_request_for_assistance" DOUBLE,
  "n__encounter_type_casual_encounter" DOUBLE,
  "n__encounter_type_court" DOUBLE,
  "n__encounter_type_at_the_police_station" DOUBLE,
  "n__encounter_type_other" DOUBLE,
  "was_your_encounter_a_positive_or_negative_experience" DOUBLE,
  "have_you_ever_been_treated_inappropriately_verbally_or_6a48670a" VARCHAR,
  "n__suggestions_a_more_transparency_and_communication_t_b3d86697" DOUBLE,
  "n__suggestions_b_more_community_policing" DOUBLE,
  "n__suggestions_c_more_training_within_the_department_o_bea978c3" DOUBLE,
  "n__suggestions_d_add_more_social_workers_to_response_teams" DOUBLE,
  "n__suggestions_e_add_more_mental_health_professionals__537d808e" DOUBLE,
  "n__suggestions_f_hold_more_community_events_or_convers_b7b3fad3" DOUBLE,
  "n__suggestions_g_increase_police_presence_to_promote_safety" DOUBLE,
  "n__suggestions_h_community_education_on_police_policie_139446f5" DOUBLE,
  "n__suggestions_i_community_driven_process_to_develop_n_ab7a077b" DOUBLE,
  "n__suggestions_j_collaborate_with_community_organizations" DOUBLE,
  "n__suggestions_k_make_sure_youth_have_a_voice_within_t_6e8a1d89" DOUBLE,
  "n__suggestions_l_work_with_community_organizations_for_79e66af6" DOUBLE,
  "n__suggestions_m_training_on_how_to_respond_to_mental__865b371a" DOUBLE,
  "n__suggestions_n_i_prefer_an_alternative_response_that_cb28d12a" DOUBLE,
  "n__suggestions_other" DOUBLE,
  "n__safety_in_your_home" DOUBLE,
  "n__safety_walking_alone_in_your_neighborhood_during_the_day" DOUBLE,
  "n__safety_walking_alone_in_your_neighborhood_at_night" DOUBLE,
  "n__safety_in_the_city_overall" DOUBLE,
  "n__safety_when_you_are_in_a_park_alone" DOUBLE,
  "n__safety_walking_to_from_my_child_s_school_if_applicable" DOUBLE,
  "n__safety_when_driving" DOUBLE,
  "n__safety_when_biking" DOUBLE,
  "n__change_safety_in_your_neighborhood_during_the_day" DOUBLE,
  "n__change_safety_in_your_neighborhood_at_night" DOUBLE,
  "n__change_safety_in_the_city_overall" DOUBLE,
  "n__concerns_animal_complaints" DOUBLE,
  "n__concerns_credit_card_and_atm_fraud" DOUBLE,
  "n__concerns_destruction_vandalism_of_property" DOUBLE,
  "n__concerns_domestic_violence" DOUBLE,
  "n__concerns_garbage" DOUBLE,
  "n__concerns_graffiti" DOUBLE,
  "n__concerns_gun_violence" DOUBLE,
  "n__concerns_housing_security" DOUBLE,
  "n__concerns_illegal_drug_activity" DOUBLE,
  "n__concerns_my_child_walking_to_school_on_their_own" DOUBLE,
  "n__concerns_people_violating_traffic_rules_traffic_safety" DOUBLE,
  "n__concerns_theft_and_burglaries" DOUBLE,
  "n__concerns_walking_in_the_city" DOUBLE,
  "n__concerns_violent_crime" DOUBLE,
  "n__concerns_other" DOUBLE,
  "n__ward_ward_1" DOUBLE,
  "n__ward_ward_2" DOUBLE,
  "n__ward_ward_3" DOUBLE,
  "n__ward_ward_4" DOUBLE,
  "n__ward_ward_5" DOUBLE,
  "n__ward_ward_6" DOUBLE,
  "n__ward_ward_7" DOUBLE,
  "how_old_are_you" VARCHAR,
  "age_group_median" DOUBLE,
  "how_long_have_you_lived_in_somerville" VARCHAR,
  "race_ethnicity_census" VARCHAR,
  "race_white_nonwhite" VARCHAR,
  "gender" VARCHAR,
  "n__describe_yourself_employed_in_somerville" DOUBLE,
  "n__describe_yourself_english_language_learner" DOUBLE,
  "n__describe_yourself_essential_worker" DOUBLE,
  "n__describe_yourself_housing_impacted_by_covid_19" DOUBLE,
  "n__describe_yourself_immigrant" DOUBLE,
  "n__describe_yourself_individual_or_family_impacted_by__f755a520" DOUBLE,
  "n__describe_yourself_parent_guardian_of_children_under_18" DOUBLE,
  "n__describe_yourself_financially_impacted_by_covid_19" DOUBLE,
  "n__describe_yourself_lgbtqia" DOUBLE,
  "n__describe_yourself_person_with_disabilities" DOUBLE,
  "n__describe_yourself_senior" DOUBLE,
  "n__describe_yourself_somerville_business_owner" DOUBLE,
  "n__describe_yourself_veteran" DOUBLE,
  "n__describe_yourself_youth_student" DOUBLE,
  "n__describe_yourself_other" DOUBLE,
  "gender_lgbtqia" VARCHAR
);