SPD 9-11 Customer Satisfaction Survey Data
City of Seattle
@usgov.city_of_seattle_spd_9_11_customer_satisfaction_survey_51abc
City of Seattle
@usgov.city_of_seattle_spd_9_11_customer_satisfaction_survey_51abc
CREATE TABLE table_1 (
"id" BIGINT,
"calldate" VARCHAR,
"q3_overall_how_satisfied_are_you_with_this_experience__47432e8d" BIGINT,
"q4_how_satisfied_are_you_with_the_assistance_provided__5df5d411" BIGINT,
"q5_1_the_officer_provided_you_the_information_you_needed" BIGINT,
"q5_2_the_officer_clearly_explained_procedures_and_requirements" DOUBLE,
"q5_3_the_officer_was_professional_and_courteous" BIGINT,
"q5_4_the_officer_told_you_what_would_happen_next" BIGINT,
"q5_5_the_officer_gave_you_tips_on_preventing_future_crimes" BIGINT,
"q5_6_the_officer_provided_information_about_other_crim_e5f02ad6" BIGINT,
"q5_7_the_officer_referred_you_to_the_seattle_police_de_85ac884c" DOUBLE,
"q5_8_the_officer_provided_the_assistance_you_needed" DOUBLE,
"q5_9_the_officer_listened_to_your_concerns" DOUBLE,
"q5_10_the_officer_answered_your_questions" DOUBLE,
"q6_1_the_department_is_available_when_you_need_them" BIGINT,
"q6_2_the_department_is_a_good_resource_for_information_4724c193" BIGINT,
"q6_3_the_department_clearly_explains_its_procedures_an_85f277df" DOUBLE,
"q6_4_department_personnel_are_professional_and_courteous" BIGINT,
"q6_5_the_department_focuses_on_the_public_safety_issue_36529d52" BIGINT,
"q6_6_the_department_understands_the_issues_affecting_y_c39cbfbf" DOUBLE,
"q6_7_if_you_wanted_to_have_input_into_decisions_about__c602fc22" DOUBLE,
"q7_1_overall_the_police_in_your_neighborhood_do_a_good_job" DOUBLE,
"q7_2_police_in_your_neighborhood_are_professional_and__614b1801" DOUBLE,
"q7_3_police_in_your_neighborhood_are_a_good_resource_f_359f680b" DOUBLE,
"q7_4_the_police_in_your_neighborhood_help_with_traffic_a7eba4c0" DOUBLE,
"q7_5_the_police_in_your_neighborhood_help_keep_your_lo_a934b8f8" DOUBLE,
"q7_6_the_police_in_your_neighborhood_focus_on_the_publ_08aeb95e" DOUBLE,
"q8_how_satisfied_are_you_with_the_speed_with_which_you_76ab3a3d" DOUBLE,
"q9_when_you_made_your_call_to_9_1_1_did_your_call_go_t_fb9a78b5" DOUBLE,
"q10_what_was_the_problem_with_reaching_an_operator" DOUBLE,
"q11_counting_the_number_of_times_you_dialed_9_1_1_and__b533959c" DOUBLE,
"q12_overall_how_safe_do_you_personally_feel_in_seattle" DOUBLE,
"q13_did_the_incident_that_caused_you_to_call_9_1_1_mak_1d4af724" DOUBLE,
"q14_did_the_service_you_received_from_the_seattle_poli_dfca9beb" DOUBLE,
"q15_and_did_the_contact_you_had_with_the_seattle_polic_036339eb" DOUBLE,
"q16_overall_how_safe_do_you_feel_walking_alone_in_your_2d46971f" DOUBLE,
"q17_and_overall_how_safe_do_you_feel_walking_alone_in__45bfcb72" DOUBLE,
"q19_would_you_like_to_have_someone_from_the_police_dep_b2b32986" BIGINT,
"q21_have_you_ever_been_a_victim_of_crime_in_seattle_an_d52ffd5b" DOUBLE,
"q22_was_this_during_the_past_year_2_to_5_years_ago_or__40ef994e" DOUBLE,
"wave" BIGINT,
"q11_1_17_first_hand_experience_for_example_as_a_witnes_c8f08ebb" DOUBLE,
"q11_2_17_the_experiences_of_family_friends_or_coworkers" DOUBLE,
"q11_3_17_television" DOUBLE,
"q11_4_17_radio" DOUBLE,
"q11_5_17_daily_newspapers_for_example_the_seattle_time_e603b4ae" DOUBLE,
"q11_6_17_neighborhood_newspapers_for_example_the_north_3ca0ef67" DOUBLE,
"q11_7_17_the_spd_blotter_on_the_department_s_web_page" DOUBLE,
"q11_8_17_local_blogs_e_g_west_seattle_blog" DOUBLE,
"q11_9_17_news_outlets_on_the_internet" DOUBLE,
"q11_10_17_email_or_text_messages" DOUBLE,
"q11_11_17_the_seattle_police_department_s_facebook_pag_a9ae8271" DOUBLE,
"q11_12_17_other_social_media_such_as_facebook_or_twitt_743be447" DOUBLE,
"q5_8_2015_the_officer_told_you_how_to_get_in_touch_wit_81ea7a32" DOUBLE,
"q7_4_2015_the_police_in_your_neighborhood_help_control_184a98b6" DOUBLE,
"q6_5_13_the_department_is_a_good_resource_for_dealing__6f5b7b61" DOUBLE,
"q8_11_13_social_media_such_as_facebook_or_twitter_q8_11_13" DOUBLE,
"q8_8_1_the_internet" DOUBLE,
"q8_9_1_email" DOUBLE,
"q8_10_1_text_messages" DOUBLE,
"q8_1orig_email" DOUBLE,
"q8_2orig_text_messaging" DOUBLE,
"q8_3orig_the_seattle_police_department_web_site" DOUBLE,
"q8_4orig_u_s_mail_sent_to_your_home" DOUBLE,
"q8_5orig_neighborhood_meetings_with_the_department" DOUBLE,
"q8_6orig_block_watch_meetings" DOUBLE,
"q8_7orig_newspaper_articles" DOUBLE,
"q8_8orig_radio_or_tv_news_stories" DOUBLE,
"q6_06_after_your_initial_visit_with_an_officer_did_a_d_db78ffdd" DOUBLE,
"q7_06_1_the_detective_provided_you_the_information_you_needed" DOUBLE,
"q7_06_2_the_detective_clearly_explained_procedures_and_a66c4533" DOUBLE,
"q7_06_3_the_detective_was_professional_and_courteous" DOUBLE,
"q7_06_4_the_detective_told_you_what_would_happen_next" DOUBLE,
"q7_06_5_the_detective_gave_you_tips_on_preventing_future_crimes" DOUBLE,
"q7_06_6_the_detective_provided_information_about_other_222ec788" DOUBLE,
"q8_06_altogether_how_many_times_did_you_see_or_talk_wi_3863fe25" DOUBLE,
"source01" BIGINT,
"filter" DOUBLE
);
Anyone who has the link will be able to view this.