31:[] 2f:{"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"},{"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"},{"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"},{"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"},{"id":105,"value":"HyperGrid(selectedData, { columnWidth: 110 })","pinned":false,"hidden":false,"mode":"ojs"},{"id":120,"value":"html``","pinned":false,"hidden":false,"mode":"ojs"},{"id":59,"value":"md`## Data handling`","pinned":false,"hidden":false,"mode":"ojs"},{"id":26,"value":"selectedData = getZIPHistory(selectedZip)","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"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"},{"id":115,"value":"ZIPOverride = searchParams.get(\"zipcode\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":114,"value":"searchParams = new URLSearchParams(location.search)","pinned":false,"hidden":false,"mode":"ojs"},{"id":49,"value":"md`## Utilities`","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":93,"value":"md`## Constants`","pinned":false,"hidden":false,"mode":"ojs"},{"id":86,"value":"STORAGE_KEY = \"ILCovidHistoricalZip\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":45,"value":"md`## Imports`","pinned":false,"hidden":false,"mode":"ojs"},{"id":40,"value":"Papa = require(\"papaparse\")","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":14,"value":"import { select } from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":5,"value":"import { graphql } from \"@eads/covid-19-graphql-helpers\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":101,"value":"import { HyperGrid } from \"@chicagoreporter/hypergrid\"","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}