2d:null 2e:["$","title",null,{"children":"Mapping Police Violence: Data | Ian Johnson | Observable"}] 33:[{"id":"f4d5e0a06bc1a509094a3458a926bdf2352cc44335d1829f43ab74878766334fe5b54edb5cc20bc2f0593c8b2056b9701f4a08defbd1b4863e7019e6fc9985eb","href":"https://static.observableusercontent.com/files/f4d5e0a06bc1a509094a3458a926bdf2352cc44335d1829f43ab74878766334fe5b54edb5cc20bc2f0593c8b2056b9701f4a08defbd1b4863e7019e6fc9985eb","name":"Mapping Police Violence - 2013-2019 Police Killings.csv","type":"text/csv","lastModified":1591303016651.977,"size":5031601}] 31:{"id":"c222a8f17cc9cfe6","slug":"mapping-police-violence-data","title":"Mapping Police Violence: Data","thumbnail":"25ad0022da693c5fd7596069efbb4c34164e61cbe0bc31e2e747ff159913eec3","access_level":"public","create_time":"$D2020-06-04T20:19:03.794Z","update_time":"$D2020-06-06T05:26:48.304Z","view_time":null,"first_public_time":"$D2020-06-04T20:48:48.868Z","has_unpublished_edits":null,"fork":false,"stars":3,"starred":false,"owner":{"type":"team","id":"cce0fa6e063d2bee","login":"enjalot","name":"Ian Johnson","avatar_url":"https://avatars-next.observableusercontent.com/549bdb0c368027004b51c4e95459e9c224331e0fec9c4cc97d181f83e55ab7f9","tier":"starter_2024"},"version":57,"publish_version":57,"role":null,"authored":false,"authors":[{"type":"individual","id":"595405df3c534894","login":"enjalot","name":"Ian Johnson","avatar_url":"https://avatars-next.observableusercontent.com/549bdb0c368027004b51c4e95459e9c224331e0fec9c4cc97d181f83e55ab7f9","tier":null}],"members":[{"type":"individual","id":"595405df3c534894","login":"enjalot","name":"Ian Johnson","avatar_url":"https://avatars-next.observableusercontent.com/549bdb0c368027004b51c4e95459e9c224331e0fec9c4cc97d181f83e55ab7f9","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"title":"Mapping Police Violence: Data","cells":[{"id":0,"value":"md`# Mapping Police Violence: Data\n\nThis notebook is intended to serve as a starting point for working with the [Mapping Police Violence](https://mappingpoliceviolence.org/) database. \n\nThe Excell database was downloaded from the website on June 4th 2020 and uploaded as a CSV file to this notebook. It contains data from 2013-2019.\n\nThe first 20 minutes of this talk by the creator of the project, [Samuel Singwey](https://twitter.com/samswey) gives important context around this data. The second 20 minutes is a powerful Q&A with members of the EYEO community of data visualizers, designers and artists.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2,"value":"html`\n

Eyeo 2017 - Sam Sinyangwe from Eyeo Festival on Vimeo.

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"md`## The Data\nYou can see the raw data as JSON here:\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"data = {\n let text = await FileAttachment(\"Mapping Police Violence - 2013-2019 Police Killings.csv\").text()\n return d3.csvParse(text, d3.autoType)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":33,"value":"byAgency = d3.nest()\n .key(d => d[\"Agency responsible for death\"] ? d[\"Agency responsible for death\"].split(\", \")[0] : \"\") // TODO: deal with multiple agencies\n .rollup(leaves => leaves.length)\n .entries(data)\n .sort( (a,b) => b.value - a.value)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"table(byAgency)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"value":"md`## Further work\n\n[Mapping Police Violence](https://mappingpoliceviolence.org/) has a number of powerful visualizations already, these can serve as great starting points for more interactives and new perspectives.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":30,"value":"md`### References and libraries`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":43,"value":"import { table } from \"@gampleman/table\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"d3 = require(\"d3@5\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1","titling":"auto"}} 32:"$31:body"