U.S. City Open Data Census
Powered by Open Data Census
Open crime data helps communities make informed judgements about public safety, as well as providing transparency into how local police power is being exercised. For U.S. City Open Data Census purposes, crime report data should include at a minimum the following elements: date, time, location, incident type, and narrative information — best would be exact date, location, and type of crime, but per day per street or postal/zip code are acceptable for Census purposes. (More info)
| Question | Answer | Comment |
|---|---|---|
| Openly licensed | Yes | |
| Available in bulk | Yes | |
| Up-to-date | Yes | As per https://data.seattle.gov/Public-Safety/Seattle-Police-Department-Police-Report-Incident/7ais-f98f, "This information is published within 6 to 12 hours after the report is filed into the system." |
| Available free online | Yes | |
| Available free of charge | Yes | |
| In an open format | CSV, RDF, TSV, XML | |
| findable | 4 | |
| findable_steps | 1. Google "seattle crime data", 2. Click the "Public Data Sets - Police" search result (https://www.seattle.gov/police/information-and-data/public-data-sets), 3. Click the "Police Reports" link on that page | |
| licence_url | See "Licensing and Attribution" under "About this Dataset" at https://data.seattle.gov/Public-Safety/Seattle-Police-D | |
| Collected by government | Yes | As per https://data.seattle.gov/Public-Safety/Seattle-Police-Department-Police-Report-Incident/7ais-f98f |
| usability | 3 | |
| collector_name | City of Seattle, Department of Information Technology, Seattle Police Department | As per https://data.seattle.gov/Public-Safety/Seattle-Police-Department-Police-Report-Incident/7ais-f98f |
| characteristics | Date and time, Location (may be coordinates or addresses; addresses may be at the block level, such as “5XX Main Street”), Incident type, Narrative information | Not sure what is meant by "Narrative information" but there is a Summarized Offense Description column that may satisfy. |
| location | https://data.seattle.gov/Public-Safety/Seattle-Police-D - Data portal with table preview, metadata, and options to export and visualize, https://data.seattle.gov/api/views/7ais-f98f/rows.csv?a - CSV file of "based on initial police reports taken by officers when responding to incidents around the city" going back as far as 1990 but with the bulk of incidents from 2008 onward. |
