2e:null 2f:["$","title",null,{"children":"Historical Illinois COVID-19 ZIP code data | COVID-19 in Illinois | Observable"}] 34:[] 32:{"id":"fd88eba00121b178","slug":"historical-illinois-covid-19-zip-code-data","title":"Historical Illinois COVID-19 ZIP code data","thumbnail":"8fc2d253f28f30cf7c2cd8066334aa8c58c9d9a581215b7ea2ced1de3067712a","access_level":"public","create_time":"$D2020-08-04T03:10:13.037Z","update_time":"$D2020-12-28T18:35:33.792Z","view_time":null,"first_public_time":"$D2020-08-04T05:06:45.336Z","fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"5075b334a430cb7e","login":"chicagoreporter","name":"COVID-19 in Illinois","avatar_url":null,"tier":"pro_2024"},"version":139,"publish_version":139,"role":null,"authored":false,"authors":[{"type":"individual","id":"69810cd3cf4bf30c","login":"eads","name":"David Eads","avatar_url":"https://avatars-next.observableusercontent.com/ed73f86cbd46170a17e3bb2a06a1939ef04e5dc379b856148b769d7ac41ab78b","tier":null}],"members":[{"type":"team","id":"5075b334a430cb7e","login":"chicagoreporter","name":"COVID-19 in Illinois","avatar_url":null,"tier":"pro_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":8,"collection":{"id":"c294315e1393fcd9","slug":"illinois-coronavirus-data","title":"Tracking COVID-19 in Illinois","owner":{"id":"5075b334a430cb7e","login":"chicagoreporter","name":"COVID-19 in Illinois"}},"type":"notebook","body":{"title":"Historical Illinois COVID-19 ZIP code data","cells":[{"id":0,"value":"md`# Historical Illinois COVID-19 ZIP code data\n\nTaken from daily snapshots of Illinois Department of Health counts by ZIP code.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"viewof selectedZip = {\n const selectBox = select({\n title: \"Select a ZIP\",\n options: zipList,\n value: ZIPOverride || window.localStorage.getItem(STORAGE_KEY)\n });\n\n selectBox.onchange = e => {\n window.localStorage.setItem(STORAGE_KEY, e.target.value);\n };\n return selectBox;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":81,"value":"md`**${selectedZip}** has **${selectedData.length}** historical measurements. This dataset includes: \n\n*below_moe_threshold*: If true, this the margin of error for this population estimate is below 10%. In cases where this is false, consider excluding the ZIP from your analysis. \n\n*tested*: New daily tests,\n\n*tested_change*: Day-over change in total tested,\n\n*cases*: Total cases to date,\n\n*cases_change*: New daily cases,\n\n*cases_per_capita*: Total cases per capita to date, based on Illinois state case data and census population estimates`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":56,"value":"{\n const button = DOM.download(\n serialize(selectedData),\n `il-covid19-historical-counts-zipcode-${selectedZip}.csv`,\n `Download historical COVID data for ${selectedZip}`\n );\n return html`\n ${button}\n \n `;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":105,"value":"HyperGrid(selectedData, { columnWidth: 110 })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":120,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":59,"value":"md`## Data handling`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":26,"value":"selectedData = getZIPHistory(selectedZip)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"getZIPHistory = zipcode => {\n const query = `\n query getZIPHistory($zipcode: String!) {\n zipcode_testing_results_change(where: {zipcode:{_eq:$zipcode}}, order_by: {date: desc}) {\n date\n zipcode\n cases_per_capita\n confirmed_cases\n confirmed_cases_change\n total_tested\n total_tested_change\n below_moe_threshold\n }\n }\n `;\n return graphql({\n query,\n operation: \"getZIPHistory\",\n variables: {\n zipcode\n }\n }).then(data =>\n data.zipcode_testing_results_change.map(r => ({\n zipcode: r.zipcode,\n date: r.date,\n tested: r.total_tested,\n tested_change: r.total_tested_change,\n cases: r.confirmed_cases,\n cases_change: r.confirmed_cases_change,\n cases_per_capita: r.cases_per_capita,\n below_moe_threshold: r.below_moe_threshold\n }))\n );\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"zipList = {\n const zipQuery = `query {\n zipcode_testing_results(distinct_on: [zipcode]) {\n zipcode\n }\n }`;\n return graphql({\n query: zipQuery\n }).then(data => data.zipcode_testing_results.map(d => d.zipcode));\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":115,"value":"ZIPOverride = searchParams.get(\"zipcode\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":114,"value":"searchParams = new URLSearchParams(location.search)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":49,"value":"md`## Utilities`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"function serialize(data) {\n let s = Papa.unparse(data);\n return new Blob([s], { type: \"text/csv\" });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":93,"value":"md`## Constants`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":86,"value":"STORAGE_KEY = \"ILCovidHistoricalZip\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":45,"value":"md`## Imports`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":40,"value":"Papa = require(\"papaparse\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":113,"value":"// Because MS browsers just don't support this\nURLSearchParams = require('https://bundle.run/@ungap/url-search-params@0.2.0')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"import { select } from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"import { graphql } from \"@eads/covid-19-graphql-helpers\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":101,"value":"import { HyperGrid } from \"@chicagoreporter/hypergrid\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 33:"$32:body"