2b:null 2c:["$","title",null,{"children":"Criminal cases in the Cuyahoga County Court of Common Pleas in Ohio, 2016-2021 | Hails | Observable"}] 31:[] 2f:{"id":"e37a87ca777bf6af","slug":null,"title":"Criminal cases in the Cuyahoga County Court of Common Pleas in Ohio, 2016-2021","thumbnail":"5d0036d88aac9d21f59161f2fade571b89184401430f50a74c28ccd7714d4b68","access_level":"public","create_time":"$D2022-10-21T04:17:03.803Z","update_time":"$D2022-10-21T04:27:50.482Z","view_time":null,"first_public_time":"$D2022-10-21T04:17:03.803Z","has_unpublished_edits":null,"fork":{"id":"c4abcf91d5a58105","slug":"criminal-cases-ohio-courts-data-release","title":"Criminal cases in the Cuyahoga County Court of Common Pleas in Ohio, 2016-2021","owner":{"id":"2b9b6b7a2611ae8b","login":"themarshallproject","name":"The Marshall Project"}},"stars":0,"starred":false,"owner":{"type":"team","id":"d3aa6c530c4dc73c","login":"whatuphails","name":"Hails","avatar_url":"https://avatars-next.observableusercontent.com/ec715591b949562f1bddcdca673ca4b49af0212c426ea6e224135e6f5729a419","tier":"starter_2024"},"version":440,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"8d6e062de2c4a92d","login":"whatuphails","name":"Hails","avatar_url":"https://avatars-next.observableusercontent.com/ec715591b949562f1bddcdca673ca4b49af0212c426ea6e224135e6f5729a419","tier":null}],"members":[{"type":"individual","id":"8d6e062de2c4a92d","login":"whatuphails","name":"Hails","avatar_url":"https://avatars-next.observableusercontent.com/ec715591b949562f1bddcdca673ca4b49af0212c426ea6e224135e6f5729a419","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Criminal cases in the Cuyahoga County Court of Common Pleas in Ohio, 2016-2021","cells":[{"id":0,"value":"# Criminal cases in the Cuyahoga County Court of Common Pleas in Ohio, 2016-2021\n\n_Ilica Mahajan, Anna Flagg, David Eads_","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":39,"value":"The Marshall Project scraped years of criminal case records for [Testify](https://testify.news), our on-going investigation into the criminal court system in Cleveland, OH and the surrounding county.\n\nIn this notebook, you can download or explore selected columns from the data we scraped. We will be releasing more columns and data in the future, see the [changelog](#changelog) for details.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":206,"value":"The data includes cases filed from 2016 to 2021. \n\nThe currently available columns are:\n\n - `case_year`: The year the criminal case number was assigned by the clerk's office. This is derived from the case number. For example, `CR-16-XXXXX` was a case filed in 2016.\n - `arresting_agency`: The agency on the record as having conducted the original arrest.\n - `judge`: The final judge assigned to preside over the case.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":244,"value":"Contact [Ilica Mahajan](mailto:imahajan@themarshallproject.org) with questions or requests about the data release and this notebook. If you use or appreciate The Marshall Project's open data releases, please [support our work](https://themarshallproject.org/donate).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":43,"value":"## Download the data:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":73,"value":"{\n const div = DOM.element(\"div\");\n const button = downloadButton(selected_data);\n\n return button;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"viewof checkboxes = Inputs.checkbox(\n [\"case_year\", \"judge\", \"arresting_agency\"],\n {\n label: \"What columns would you like?\",\n value: [\"case_year\", \"judge\", \"arresting_agency\"]\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":190,"value":"## Search","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":194,"value":"A searchable view of the data we have released so far. The search bar will filter the table below based on the judge, case year, or arresting agency you enter. We will be adding more columns in the future.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":91,"value":"viewof search = Inputs.search(dt, {})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":88,"value":"Inputs.table(search, {\n width: { case_year: 200 },\n format: { case_year: (d) => d.toFixed(0) }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":199,"value":"## Counts: Select one","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":163,"value":"viewof select = Inputs.select([\"arresting_agency\", \"judge\", \"case_year\"], {\n label: \"Select one\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":301,"value":"Inputs.table(\n dt.params({ select }).groupby(select).count().orderby(aq.desc(\"count\")),\n {\n format: {\n count: bar(\n d3.max(dt.params({ select }).groupby(select).count(), (d) => d.count)\n )\n },\n width: { count: barWidth }\n }\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":439,"value":"map = {\n const container = yield htl.html`

`;\n const map = L.map(container).setView([37.774, -122.423], 13);\n L.tileLayer(\"https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png\", {\n attribution: \"© OpenStreetMap contributors\"\n }).addTo(map);\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":144,"value":"## CHANGELOG","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"changelog","database":"$undefined"},{"id":147,"value":"### v1.0 (May 10, 2022)\n\nInitial release of the data. Includes cases filed from 2016 to 2021.\n\nColumns included: \n\n- case_year\n- judge\n- arresting_agency","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":27,"value":"## Imports and helpers","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":421,"value":"barWidth = 500","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":85,"value":"selected_data = dt.select(checkboxes).objects()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"cases_judges = graphql({\n operationName: \"MyQuery\",\n query: `\nquery MyQuery {\n cases {\n case_year\n judge\n arresting_agency\n }\n}\n`\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":35,"value":"dt = aq.from(cases_judges.cases)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":47,"value":"downloadButton = (data, filename = \"data.csv\") => {\n const csv = new Blob([d3.csvFormat(data)], { type: \"text/csv\" });\n const size = (csv.size / 1024).toFixed(0);\n\n const button = DOM.download(\n csv,\n filename,\n `Download ${filename} (~${size} KB)`\n );\n return button;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"function graphql(payload, headers = {}) {\n headers[\"content-type\"] = \"application/json\";\n return fetch(\"https://ohiocourts.hasura.app/v1/graphql\", {\n body: JSON.stringify(payload),\n headers: headers,\n method: \"POST\",\n mode: \"cors\"\n })\n .then((response) => {\n return response.json();\n })\n .then((jsonData) => {\n return jsonData.data;\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":308,"value":"function bar(max) {\n const barPadding = 90;\n\n return (x) => htl.html`\n

${x.toLocaleString()}

\n\n\n\n\n`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W31","stdlib":"1"}} 30:"$2f:body"