About this Dataset

SPD 9-11 Customer Satisfaction Survey Data

Background: “In 2006, the Seattle Police Department began surveying members of the public (customers) who had personal contact with an officer after calling 9-1-1. The surveys have been conducted two to four times a year, and a total of 44 surveys have been conducted to date. These surveys have been designed to assess customers’ experiences and satisfaction with the service provided by the Seattle Police Department, and the results of the surveys have been used to assess service delivery; examine differences between precincts; identify strategies and tactics to achieve specific service objectives; and provide feedback to officers, precinct captains, and watch lieutenants. This report presents the results of the September 2019 customer survey and compares the September 2019 survey results to results from the 13 other surveys conducted since March 2016.”

Research Methods. “Similar to the previous surveys, 200 customers who called 9-1-1 and had an officer dispatched to provide assistance were interviewed by telephone for this survey. All of the customers interviewed had called 9-1-1 between August 21 and August 29, 2019, and were randomly selected from lists of 9-1-1 callers who had an officer dispatched to provide assistance, excluding sensitive cases such as domestic violence calls. The interviews were completed between September 3 and September 10, 2019. The interviews were approximately 10 to 12 minutes long. The questionnaire used in the interviews was developed with Department input and approval. During the course of this research, some questions have been added to or deleted from the survey questionnaire to reflect the changing information needs of the Department. However, questions about customers’ overall satisfaction with their experience with the Department after calling 9-1-1, experiences with and opinions of the officer who first visited after the call to 9-1-1, opinions of the Seattle Police Department overall, and satisfaction with the service provided by the 9-1-1 operator have been included in every survey. Since late 2006 and early 2007, the surveys also included questions about customers’ feelings of safety in Seattle.”
Organization: City of Seattle
Last updated: 2024-12-16T22:23:37.980587

Tables

Table 1

@usgov.city_of_seattle_spd_9_11_customer_satisfaction_survey_51abc.table_1

234.15 kB
9,412 rows
78 columns

CREATE TABLE table_1 (
  "id" BIGINT,
  "calldate" VARCHAR,
  "q3_overall_how_satisfied_are_you_with_this_experience__47432e8d" BIGINT  -- Q3-Overall, How Satisfied Are You With This Experience With The Seattle Police Department - From Calling 9- 1-1 On To All Contacts You Had With The Police Department As A Result Of That Call?,
  "q4_how_satisfied_are_you_with_the_assistance_provided__5df5d411" BIGINT  -- Q4-How Satisfied Are You With The Assistance Provided By The 9-1-1 Operator Over The Telephone?,
  "q5_1_the_officer_provided_you_the_information_you_needed" BIGINT  -- Q5.1-The Officer Provided You The Information You Needed.,
  "q5_2_the_officer_clearly_explained_procedures_and_requirements" DOUBLE,
  "q5_3_the_officer_was_professional_and_courteous" BIGINT  -- Q5.3-The Officer Was Professional And Courteous.,
  "q5_4_the_officer_told_you_what_would_happen_next" BIGINT  -- Q5.4-The Officer Told You What Would Happen Next.,
  "q5_5_the_officer_gave_you_tips_on_preventing_future_crimes" BIGINT  -- Q5.5-The Officer Gave You Tips On Preventing Future Crimes.,
  "q5_6_the_officer_provided_information_about_other_crim_e5f02ad6" BIGINT  -- Q5.6-The Officer Provided Information About Other Crimes Or Problems In Your Area.,
  "q5_7_the_officer_referred_you_to_the_seattle_police_de_85ac884c" DOUBLE  -- Q5.7-The Officer Referred You To The Seattle Police Department Website For Crime Prevention Tips Or Information On Other Crimes In Your Area.,
  "q5_8_the_officer_provided_the_assistance_you_needed" DOUBLE  -- Q5.8-The Officer Provided The Assistance You Needed.,
  "q5_9_the_officer_listened_to_your_concerns" DOUBLE  -- Q5.9-The Officer Listened To Your Concerns.,
  "q5_10_the_officer_answered_your_questions" DOUBLE  -- Q5.10-The Officer Answered Your Questions.,
  "q6_1_the_department_is_available_when_you_need_them" BIGINT  -- Q6.1-The Department Is Available When You Need Them.,
  "q6_2_the_department_is_a_good_resource_for_information_4724c193" BIGINT  -- Q6.2-The Department Is A Good Resource For Information About Preventing Crime.,
  "q6_3_the_department_clearly_explains_its_procedures_an_85f277df" DOUBLE  -- Q6.3-The Department Clearly Explains Its Procedures And Requirements.,
  "q6_4_department_personnel_are_professional_and_courteous" BIGINT  -- Q6.4-Department Personnel Are Professional And Courteous.,
  "q6_5_the_department_focuses_on_the_public_safety_issue_36529d52" BIGINT  -- Q6.5-The Department Focuses On The Public Safety Issues That Concern You.,
  "q6_6_the_department_understands_the_issues_affecting_y_c39cbfbf" DOUBLE  -- Q6.6-The Department Understands The Issues Affecting Your Neighborhood.,
  "q6_7_if_you_wanted_to_have_input_into_decisions_about__c602fc22" DOUBLE  -- Q6.7-If You Wanted To Have Input Into Decisions About Policing In Seattle, The Department Would Listen To You.,
  "q7_1_overall_the_police_in_your_neighborhood_do_a_good_job" DOUBLE  -- Q7.1-Overall, The Police In Your Neighborhood Do A Good Job.,
  "q7_2_police_in_your_neighborhood_are_professional_and__614b1801" DOUBLE  -- Q7.2-Police In Your Neighborhood Are Professional And Courteous.,
  "q7_3_police_in_your_neighborhood_are_a_good_resource_f_359f680b" DOUBLE  -- Q7.3-Police In Your Neighborhood Are A Good Resource For Dealing With Crimes Or Other Local Problems.,
  "q7_4_the_police_in_your_neighborhood_help_with_traffic_a7eba4c0" DOUBLE  -- Q7.4-The Police In Your Neighborhood Help With Traffic Safety Such As Speed Enforcement.,
  "q7_5_the_police_in_your_neighborhood_help_keep_your_lo_a934b8f8" DOUBLE  -- Q7.5-The Police In Your Neighborhood Help Keep Your Local Parks Safe.,
  "q7_6_the_police_in_your_neighborhood_focus_on_the_publ_08aeb95e" DOUBLE  -- Q7.6-The Police In Your Neighborhood Focus On The Public Safety Issues That Concern You.,
  "q8_how_satisfied_are_you_with_the_speed_with_which_you_76ab3a3d" DOUBLE  -- Q8-How Satisfied Are You With The Speed With Which Your Call To 9- 1-1 Was Answered By The Operator?,
  "q9_when_you_made_your_call_to_9_1_1_did_your_call_go_t_fb9a78b5" DOUBLE  -- Q9-When You Made Your Call To 9-1-1, Did Your Call Go Through To An Operator The First Time You Dialed, Or Did You Get A Busy Signal And Have To Dial 9-1-1 More Than Once To Reach An Operator?,
  "q10_what_was_the_problem_with_reaching_an_operator" DOUBLE  -- Q10-What Was The Problem With Reaching An Operator?,
  "q11_counting_the_number_of_times_you_dialed_9_1_1_and__b533959c" DOUBLE  -- Q11-Counting The Number Of Times You Dialed 9-1-1 And Got A Busy Signal, How Many Times Altogether Did You Dial 9-1-1 To Reach An Operator?,
  "q12_overall_how_safe_do_you_personally_feel_in_seattle" DOUBLE  -- Q12-Overall, How Safe Do You Personally Feel In Seattle?,
  "q13_did_the_incident_that_caused_you_to_call_9_1_1_mak_1d4af724" DOUBLE  -- Q13-Did The Incident That Caused You To Call 9-1-1 Make You Feel More Safe Than Before, Less Safe, Or About As Safe As Before The Incident Occurred?,
  "q14_did_the_service_you_received_from_the_seattle_poli_dfca9beb" DOUBLE  -- Q14-Did The Service You Received From The Seattle Police Department As A Result Of Your Call To 9- 1-1 Make You Feel More Safe Than Before, Less Safe, Or Do You Feel About As Safe Now As Before You Called 9- 1-1?,
  "q15_and_did_the_contact_you_had_with_the_seattle_polic_036339eb" DOUBLE  -- Q15-And, Did The Contact You Had With The Seattle Police Department As A Result Of Your Call To 9- 1-1 Make You Feel More Favorable Toward The Seattle Police Department, Less Favorable, Or Do You Feel About The Same Toward The Department Now As You Did Be,
  "q16_overall_how_safe_do_you_feel_walking_alone_in_your_2d46971f" DOUBLE  -- Q16-Overall, How Safe Do You Feel Walking Alone In Your Neighborhood During The Day?,
  "q17_and_overall_how_safe_do_you_feel_walking_alone_in__45bfcb72" DOUBLE  -- Q17-And, Overall, How Safe Do You Feel Walking Alone In Your Neighborhood At Night?,
  "q19_would_you_like_to_have_someone_from_the_police_dep_b2b32986" BIGINT  -- Q19-Would You Like To Have Someone From The Police Department Contact You So You Can Discuss Further The Service You Received After Your Call To 9- 1-1?,
  "q21_have_you_ever_been_a_victim_of_crime_in_seattle_an_d52ffd5b" DOUBLE  -- Q21-Have You Ever Been A Victim Of Crime In Seattle And NOT Reported It To The Seattle Police Department?,
  "q22_was_this_during_the_past_year_2_to_5_years_ago_or__40ef994e" DOUBLE  -- Q22-Was This During The Past Year, 2 To 5 Years Ago, Or More Than 5 Years Ago?,
  "wave" BIGINT,
  "q11_1_17_first_hand_experience_for_example_as_a_witnes_c8f08ebb" DOUBLE  -- Q11.1.17-First Hand Experience (for Example, As A Witness Or A Victim),
  "q11_2_17_the_experiences_of_family_friends_or_coworkers" DOUBLE  -- Q11.2.17-The Experiences Of Family, Friends, Or Coworkers,
  "q11_3_17_television" DOUBLE,
  "q11_4_17_radio" DOUBLE,
  "q11_5_17_daily_newspapers_for_example_the_seattle_time_e603b4ae" DOUBLE  -- Q11.5.17-Daily Newspapers (for Example, The Seattle Times Or Seattle PI Online),
  "q11_6_17_neighborhood_newspapers_for_example_the_north_3ca0ef67" DOUBLE  -- Q11.6.17-Neighborhood Newspapers (for Example, The North Seattle Herald- Outlook),
  "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.8.17-Local Blogs (e.g., West Seattle Blog),
  "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.11.17-The Seattle Police Department’s Facebook Page Or Twitter Feeds,
  "q11_12_17_other_social_media_such_as_facebook_or_twitt_743be447" DOUBLE  -- Q11.12.17-Other Social Media Such As Facebook Or Twitter – But Not SPD’s,
  "q5_8_2015_the_officer_told_you_how_to_get_in_touch_wit_81ea7a32" DOUBLE  -- Q5.8.2015-The Officer Told You How To Get In Touch With Him Or Her.,
  "q7_4_2015_the_police_in_your_neighborhood_help_control_184a98b6" DOUBLE  -- Q7.4.2015-The Police In Your Neighborhood Help Control Speeding And Other Traffic Safety Problems.,
  "q6_5_13_the_department_is_a_good_resource_for_dealing__6f5b7b61" DOUBLE  -- Q6.5.13-The Department Is A Good Resource For Dealing With Crimes Or Other Problems In Your Neighborhood.,
  "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.4orig-U.S. Mail Sent To Your Home,
  "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  -- Q6.06-After Your Initial Visit With An Officer, Did A Detective Visit Or Contact You To Follow Up On Your Case?,
  "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.2-The Detective Clearly Explained Procedures And Requirements,
  "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  -- Q7.06.6-The Detective Provided Information About Other Crimes Or Problems In Your Area,
  "q8_06_altogether_how_many_times_did_you_see_or_talk_wi_3863fe25" DOUBLE  -- Q8.06-Altogether, How Many Times Did You See Or Talk With A Police Officer Or Detective In Person About This Matter?,
  "source01" BIGINT,
  "filter" DOUBLE  -- Filter $
);