Public Safety For All Community Survey Results

CREATE TABLE table_1 (
  "timestamp" VARCHAR,
  "language" VARCHAR,
  "n__language_english_nonenglish" VARCHAR  -- [Language] English NonEnglish,
  "does_the_somerville_police_department_treat_people_in__61202d9b" DOUBLE  -- Does The Somerville Police Department Treat People In Your Neighborhood With Respect?,
  "do_the_somerville_police_department_officers_in_your_n_b6e8ed9b" DOUBLE  -- Do The Somerville Police Department Officers In Your Neighborhood Make You Feel Safe?,
  "how_often_do_you_see_somerville_police_officers_in_you_a8337a83" DOUBLE  -- How Often Do You See Somerville Police Officers In Your Neighborhood?,
  "have_you_ever_had_a_personal_encounter_with_an_somervi_b96323c7" VARCHAR  -- Have You Ever Had A Personal Encounter With An Somerville Police Officer?,
  "n__encounter_type_traffic_stop" DOUBLE  -- [Encounter Type] Traffic Stop,
  "n__encounter_type_request_for_assistance" DOUBLE  -- [Encounter Type] Request For Assistance,
  "n__encounter_type_casual_encounter" DOUBLE  -- [Encounter Type] Casual Encounter,
  "n__encounter_type_court" DOUBLE  -- [Encounter Type] Court,
  "n__encounter_type_at_the_police_station" DOUBLE  -- [Encounter Type] At The Police Station,
  "n__encounter_type_other" DOUBLE  -- [Encounter Type] Other,
  "was_your_encounter_a_positive_or_negative_experience" DOUBLE  -- Was Your Encounter A Positive Or Negative Experience?,
  "have_you_ever_been_treated_inappropriately_verbally_or_6a48670a" VARCHAR  -- Have You Ever Been Treated Inappropriately (verbally Or Physically) By A Somerville Police Officer?,
  "n__suggestions_a_more_transparency_and_communication_t_b3d86697" DOUBLE  -- [Suggestions] A. More Transparency And Communication Through Sharing Information And Data,
  "n__suggestions_b_more_community_policing" DOUBLE  -- [Suggestions] B. More Community Policing,
  "n__suggestions_c_more_training_within_the_department_o_bea978c3" DOUBLE  -- [Suggestions] C. More Training Within The Department On Culture And Diversity,
  "n__suggestions_d_add_more_social_workers_to_response_teams" DOUBLE  -- [Suggestions] D. Add More Social Workers To Response Teams,
  "n__suggestions_e_add_more_mental_health_professionals__537d808e" DOUBLE  -- [Suggestions] E. Add More Mental Health Professionals To Response Teams,
  "n__suggestions_f_hold_more_community_events_or_convers_b7b3fad3" DOUBLE  -- [Suggestions] F. Hold More Community Events Or Conversations To Maintain Dialog,
  "n__suggestions_g_increase_police_presence_to_promote_safety" DOUBLE  -- [Suggestions] G. Increase Police Presence To Promote Safety,
  "n__suggestions_h_community_education_on_police_policie_139446f5" DOUBLE  -- [Suggestions] H. Community Education On Police Policies And Best Practices,
  "n__suggestions_i_community_driven_process_to_develop_n_ab7a077b" DOUBLE  -- [Suggestions] I. Community Driven Process To Develop New Programs,
  "n__suggestions_j_collaborate_with_community_organizations" DOUBLE  -- [Suggestions] J. Collaborate With Community Organizations,
  "n__suggestions_k_make_sure_youth_have_a_voice_within_t_6e8a1d89" DOUBLE  -- [Suggestions] K. Make Sure Youth Have A Voice Within The Police Department,
  "n__suggestions_l_work_with_community_organizations_for_79e66af6" DOUBLE  -- [Suggestions] L. Work With Community Organizations For Emergency Responses,
  "n__suggestions_m_training_on_how_to_respond_to_mental__865b371a" DOUBLE  -- [Suggestions] M. Training On How To Respond To Mental Health Crises,
  "n__suggestions_n_i_prefer_an_alternative_response_that_cb28d12a" DOUBLE  -- [Suggestions] N. I Prefer An Alternative Response That Does Not Involve Police,
  "n__suggestions_other" DOUBLE  -- [Suggestions] Other,
  "n__safety_in_your_home" DOUBLE  -- [Safety] In Your Home,
  "n__safety_walking_alone_in_your_neighborhood_during_the_day" DOUBLE  -- [Safety] Walking Alone In Your Neighborhood During The Day,
  "n__safety_walking_alone_in_your_neighborhood_at_night" DOUBLE  -- [Safety] Walking Alone In Your Neighborhood At Night,
  "n__safety_in_the_city_overall" DOUBLE  -- [Safety] In The City Overall,
  "n__safety_when_you_are_in_a_park_alone" DOUBLE  -- [Safety] When You Are In A Park Alone,
  "n__safety_walking_to_from_my_child_s_school_if_applicable" DOUBLE  -- [Safety] Walking To/from My Child’s School (if Applicable),
  "n__safety_when_driving" DOUBLE  -- [Safety] When Driving,
  "n__safety_when_biking" DOUBLE  -- [Safety] When Biking,
  "n__change_safety_in_your_neighborhood_during_the_day" DOUBLE  -- [Change] Safety In Your Neighborhood During The Day,
  "n__change_safety_in_your_neighborhood_at_night" DOUBLE  -- [Change] Safety In Your Neighborhood At Night,
  "n__change_safety_in_the_city_overall" DOUBLE  -- [Change] Safety In The City Overall,
  "n__concerns_animal_complaints" DOUBLE  -- [Concerns] Animal Complaints,
  "n__concerns_credit_card_and_atm_fraud" DOUBLE  -- [Concerns] Credit Card And ATM Fraud,
  "n__concerns_destruction_vandalism_of_property" DOUBLE  -- [Concerns] Destruction/Vandalism Of Property,
  "n__concerns_domestic_violence" DOUBLE  -- [Concerns] Domestic Violence,
  "n__concerns_garbage" DOUBLE  -- [Concerns] Garbage,
  "n__concerns_graffiti" DOUBLE  -- [Concerns] Graffiti,
  "n__concerns_gun_violence" DOUBLE  -- [Concerns] Gun Violence,
  "n__concerns_housing_security" DOUBLE  -- [Concerns] Housing Security,
  "n__concerns_illegal_drug_activity" DOUBLE  -- [Concerns] Illegal Drug Activity,
  "n__concerns_my_child_walking_to_school_on_their_own" DOUBLE  -- [Concerns] My Child Walking To School On Their Own,
  "n__concerns_people_violating_traffic_rules_traffic_safety" DOUBLE  -- [Concerns] People Violating Traffic Rules/Traffic Safety,
  "n__concerns_theft_and_burglaries" DOUBLE  -- [Concerns] Theft And Burglaries,
  "n__concerns_walking_in_the_city" DOUBLE  -- [Concerns] Walking In The City,
  "n__concerns_violent_crime" DOUBLE  -- [Concerns] Violent Crime,
  "n__concerns_other" DOUBLE  -- [Concerns] Other,
  "n__ward_ward_1" DOUBLE  -- [Ward] Ward 1,
  "n__ward_ward_2" DOUBLE  -- [Ward] Ward 2,
  "n__ward_ward_3" DOUBLE  -- [Ward] Ward 3,
  "n__ward_ward_4" DOUBLE  -- [Ward] Ward 4,
  "n__ward_ward_5" DOUBLE  -- [Ward] Ward 5,
  "n__ward_ward_6" DOUBLE  -- [Ward] Ward 6,
  "n__ward_ward_7" DOUBLE  -- [Ward] Ward 7,
  "how_old_are_you" VARCHAR  -- How Old Are You?,
  "age_group_median" DOUBLE,
  "how_long_have_you_lived_in_somerville" VARCHAR  -- How Long Have You Lived In Somerville?,
  "race_ethnicity_census" VARCHAR,
  "race_white_nonwhite" VARCHAR,
  "gender" VARCHAR,
  "n__describe_yourself_employed_in_somerville" DOUBLE  -- [Describe Yourself] Employed In Somerville,
  "n__describe_yourself_english_language_learner" DOUBLE  -- [Describe Yourself] English Language Learner,
  "n__describe_yourself_essential_worker" DOUBLE  -- [Describe Yourself] Essential Worker,
  "n__describe_yourself_housing_impacted_by_covid_19" DOUBLE  -- [Describe Yourself] Housing Impacted By COVID-19,
  "n__describe_yourself_immigrant" DOUBLE  -- [Describe Yourself] Immigrant,
  "n__describe_yourself_individual_or_family_impacted_by__f755a520" DOUBLE  -- [Describe Yourself] Individual Or Family Impacted By Substance Use Disorder,
  "n__describe_yourself_parent_guardian_of_children_under_18" DOUBLE  -- [Describe Yourself] Parent/Guardian Of Children Under 18,
  "n__describe_yourself_financially_impacted_by_covid_19" DOUBLE  -- [Describe Yourself] Financially Impacted By COVID-19,
  "n__describe_yourself_lgbtqia" DOUBLE  -- [Describe Yourself] LGBTQIA+,
  "n__describe_yourself_person_with_disabilities" DOUBLE  -- [Describe Yourself] Person With Disabilities,
  "n__describe_yourself_senior" DOUBLE  -- [Describe Yourself] Senior,
  "n__describe_yourself_somerville_business_owner" DOUBLE  -- [Describe Yourself] Somerville Business Owner,
  "n__describe_yourself_veteran" DOUBLE  -- [Describe Yourself] Veteran,
  "n__describe_yourself_youth_student" DOUBLE  -- [Describe Yourself] Youth/student,
  "n__describe_yourself_other" DOUBLE  -- [Describe Yourself] Other,
  "gender_lgbtqia" VARCHAR  -- Gender LGBTQIA+
);