Name: Crisis Data
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Crisis Data

Data representing crisis contacts made by officers of the Seattle Police Department. Data is denormalized to represent the one to many relationship between the record and the reported disposition of the contact.

USE CAUTION WHEN COUNTING
Organization: City of Seattle
Last updated: 2024-12-16T22:28:09.448173
Tags: cit, crisis, police, use-of-force

Tables

Table 1

@usgov.city_of_seattle_crisis_data_bc34e.table_1

3.79 MB
100,592 rows
25 columns

CREATE TABLE table_1 (
  "template_id" BIGINT,
  "reported_date" TIMESTAMP,
  "reported_time" VARCHAR,
  "occurred_date_time" VARCHAR  -- Occurred Date / Time,
  "call_type" VARCHAR,
  "initial_call_type" VARCHAR,
  "final_call_type" VARCHAR,
  "disposition" VARCHAR,
  "use_of_force_indicator" VARCHAR,
  "subject_veteran_indicator" VARCHAR,
  "cit_officer_requested" VARCHAR,
  "cit_officer_dispatched" VARCHAR,
  "cit_officer_arrived" VARCHAR,
  "officer_id" VARCHAR,
  "officer_gender" VARCHAR,
  "officer_race" VARCHAR,
  "officer_year_of_birth" BIGINT,
  "officer_years_of_experience" BIGINT,
  "cit_certified_indicator" VARCHAR,
  "officer_bureau_desc" VARCHAR,
  "officer_precinct_desc" VARCHAR,
  "officer_squad_desc" VARCHAR,
  "precinct" VARCHAR,
  "sector" VARCHAR,
  "beat" VARCHAR
);