About this Dataset

Seattle Police PDRs

A list of all public data requests made to the Seattle Police Department 2016 to December 2020. Requester names have been anonymized. Request summaries have been redacted to remove personally identifiable information (e.g. names, addresses, phone numbers, etc.) entered by the requester.
Organization: City of Seattle
Last updated: 2024-12-16T22:22:33.266974
Tags: pdr, police, public-records

Tables

Table 1

@usgov.city_of_seattle_seattle_police_pdrs_8afa0.table_1

5 MB
37,952 rows
11 columns

CREATE TABLE table_1 (
  "assigned_staff" VARCHAR,
  "completed_closed" BOOLEAN,
  "create_date" VARCHAR,
  "days_open" DOUBLE,
  "request_status" VARCHAR,
  "summary" VARCHAR,
  "customer" VARCHAR,
  "spd_sub_type" VARCHAR,
  "close_date" VARCHAR,
  "reference_no" VARCHAR,
  "total_time_spent_h" DOUBLE  -- Total Time Spent (h)
);