2d:null 2e:["$","title",null,{"children":"COVID Utilities | Thomas Ballinger | Observable"}] 33:T61d,getStates = field => { const data = src.filter(d => d.lastDay); const m_month = Math.max.apply(null, data.map(d => d.month)); const m_fips = Math.max.apply(null, data.map(d => d.fips)); const states = new Array(m_fips); for(let i = 0; i <= m_fips; i++) { const row = data.find(d => d.fips === i); if (row) states[i] = row.state; } const matrix = new Array(m_fips + 1).fill(null); for(let i = 0; i <= m_fips; i++) { matrix[i] = new Array(m_month + 1); } data.forEach(d => matrix[d.fips][d.month] = { cases: d.cases, deaths: d.deaths, newcases: d.cases, newdeaths: d.deaths }); const result = matrix.map((d, i) => { const row = new Object(); row.state = states[i]; for(let m = 0; m < d.length; m++) { const mdata = d[m]; if (mdata && m > 0) { const prev = d[m - 1]; if (prev) { mdata.newcases = mdata.cases - prev.cases; mdata.newdeaths = mdata.deaths - prev.deaths; } } const ycode = 20 + Math.floor(m / 12); const mcode = m - Math.floor(m / 12) * 12 + 1; row[`${ycode}-${String(mcode).padStart(2, "0")}`] = mdata ? mdata[field] : 0; } return row; }).filter(d => d.state); const total = {state: "Total"}; result.columns = Object.keys(result[0]); const months = result.columns.slice(1); for(let month of months) { let sum = 0; for(let row of result) sum += row[month]; total[month] = sum; } result.unshift(total) return result; }34:[] 31:{"id":"41f39c3fec66debd","slug":"covid-utilities","title":"COVID Utilities","thumbnail":"f3f6c08b8b9828a3b555aa510fc88ed9bbb6150a382027d6c102863392eb8ff9","access_level":"public","create_time":"$D2020-11-24T03:01:45.118Z","update_time":"$D2020-11-24T03:01:45.118Z","view_time":null,"first_public_time":"$D2020-11-24T03:02:54.163Z","has_unpublished_edits":null,"fork":{"id":"df2f4b85689c53df","slug":"covid-utilities","title":"COVID Utilities","owner":{"id":"4d412f762b1c1ef6","login":"analyzer2004","name":"Eric Lo"}},"stars":0,"starred":false,"owner":{"type":"team","id":"99d0de2d65d767e9","login":"ballingt-personal","name":"Thomas Ballinger","avatar_url":"https://avatars-next.observableusercontent.com/8ad92a493f85feedf6531556fe220dd29149c2e77f7de99419eb9ad4a60dc179","tier":"starter_2024"},"version":446,"publish_version":446,"role":null,"authored":false,"authors":[{"type":"individual","id":"f4a1ec06e8e5f9ad","login":"ballingt-personal","name":"Thomas Ballinger","avatar_url":"https://avatars-next.observableusercontent.com/8ad92a493f85feedf6531556fe220dd29149c2e77f7de99419eb9ad4a60dc179","tier":null}],"members":[{"type":"individual","id":"f4a1ec06e8e5f9ad","login":"ballingt-personal","name":"Thomas Ballinger","avatar_url":"https://avatars-next.observableusercontent.com/8ad92a493f85feedf6531556fe220dd29149c2e77f7de99419eb9ad4a60dc179","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"COVID Utilities","cells":[{"id":0,"value":"md`# COVID Utilities\n\nMiscellaneous utilities for processing COVID-19 data.\n\n## getStates(field)\nAggregate and convert NTY's COVID-19 us_states.csv into data table foramts.\n- \\`field\\` - field name: cases, deaths, newcases, newdeath`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":387,"value":"viewof field = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":287,"value":"printTable(getStates(field))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":224,"value":"$33","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":289,"value":"src = { \n const data = await d3.csv(\"https://raw.githubusercontent.com/nytimes/covid-19-data/master/us-states.csv\", d => {\n const date = d3.timeParse('%Y-%m-%d')(d.date);;\n const y = date.getFullYear(), m = date.getMonth();\n const ldy = new Date(y, m + 1, 0); \n return {\n date: date,\n lastDay: date.getTime() === ldy.getTime(),\n month: (y - 2020) * 12 + m,\n state: d.state,\n fips: +d.fips,\n cases: +d.cases,\n deaths: + d.deaths\n }\n });\n \n const last = data[data.length - 1].date.getTime(); \n for(let i = data.length - 1; i > 0; i--) {\n const row = data[i];\n if (row.date.getTime() === last)\n row.lastDay = true;\n else\n break;\n }\n \n return data;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":327,"value":"import {printTable} from \"@uwdata/data-utilities\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2,"value":"d3 = require(\"d3@6\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 32:"$31:body"