2c:null 2d:["$","title",null,{"children":"COVID-2019 Stats (Country/State selection) | Ilia Naryzhny | Observable"}] 32:T542,data = { return confirmed.map(c => { function findLocation(d) { return d["Country/Region"]==c["Country/Region"] && d["Province/State"] == c["Province/State"]; }; var d = deaths.find(findLocation); var r = recovered.find(findLocation); var ts = d3.keys(c).map(i=> {return {date : new Date(i), confirmed: +c[i], deaths: +d[i], recovered: +r[i]};}) .filter(d => !isNaN(d.date) && d.confirmed>0) .map(d=> { d.dr = d.deaths / d.confirmed; d.active = d.confirmed - d.deaths - d.recovered; d.r = Infinity; return d; }); ts.reduce(function(prev, cur) { cur.r = prev==null?Infinity : cur.confirmed / prev.confirmed; return cur; }, null); var last3 = ts.length>3?ts.slice(ts.length-3):ts; var today = ts.length>0?ts[ts.length-1]:{}; var avgr = d3.mean(last3.map(f("r"))); return { country : c["Country/Region"], state: c["Province/State"], ts: ts, confirmed: today.confirmed, deaths: today.deaths, recovered: today.recovered, active: today.active, dr: today.dr, r: today.r, avgr: avgr, last3: last3 } }); //return d3.keys(c).map(d => new Date(d)).filter(d => !isNaN(d)); }33:[] 30:{"id":"957a5aecf1f6c6c0","slug":"covid-2019-stats-country-state-selection","title":"COVID-2019 Stats (Country/State selection)","thumbnail":"d1496bac5a2faef89f9d253d327b178d814d7de823d0e61a7c75cf010e34077c","access_level":"public","create_time":"$D2020-03-18T19:38:48.512Z","update_time":"$D2020-08-25T06:15:59.814Z","view_time":null,"first_public_time":"$D2020-03-19T00:52:34.697Z","has_unpublished_edits":null,"fork":false,"stars":1,"starred":false,"owner":{"type":"team","id":"57e6b6a6a6a292f4","login":"phantomydn","name":"Ilia Naryzhny","avatar_url":"https://avatars-next.observableusercontent.com/39fe61d9856e2acdf2c3dd618697d2f0bade9a476b54e60cfcd328939a14ebd3","tier":"starter_2024"},"version":189,"publish_version":189,"role":null,"authored":false,"authors":[{"type":"individual","id":"73e04c112f9de8c0","login":"phantomydn","name":"Ilia Naryzhny","avatar_url":"https://avatars-next.observableusercontent.com/39fe61d9856e2acdf2c3dd618697d2f0bade9a476b54e60cfcd328939a14ebd3","tier":null}],"members":[{"type":"individual","id":"73e04c112f9de8c0","login":"phantomydn","name":"Ilia Naryzhny","avatar_url":"https://avatars-next.observableusercontent.com/39fe61d9856e2acdf2c3dd618697d2f0bade9a476b54e60cfcd328939a14ebd3","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":3,"collection":null,"type":"notebook","body":{"titling":"auto","title":"COVID-2019 Stats (Country/State selection)","cells":[{"id":0,"value":"md`# COVID-2019 Stats (Country/State selection)\nSelect Country/Region:`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":51,"value":"viewof country = DOM.select(d3.keys(geo).sort(d3.ascessing))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":64,"value":"md`Select State/Province if applicable:`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":60,"value":"viewof state = DOM.select(geo[country].sort(d3.ascessing))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":136,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":71,"value":"prepData = data.find(function(d) {return d.country==country && d.state == state;}).ts;","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":102,"value":"{ \n var c = prepData[prepData.length-1];\n var r = [];\n for(var i=0; iCurrent Statistics \n

Cases: ${c.confirmed}
Deaths: ${c.deaths}
Recovered: ${c.recovered}
Death Rate: ${Math.round(c.deaths / c.confirmed * 10000) /100}%
Doubling of cases: every ${Math.round(Math.log(2) / Math.log(last3))} days

`;\n\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":69,"value":"c3({\n size: {\n height: 640\n },\n data : {\n json : prepData,\n keys: {\n x: 'date', // it's possible to specify 'x' when category axis\n value: ['confirmed', 'active', 'recovered', 'deaths'],\n }\n },\n axis: {\n x: {\n type: 'timeseries'\n },\n y: {\n min: 0\n }\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":154,"value":"tabulator(data.filter(d=>d.confirmed>0), {\n paginationSize: 20,\n columns: [\n {title:\"Country/Region\", field: \"country\"},\n {title:\"State/Province\", field: \"state\"},\n {title:\"Confirmed\", field: \"confirmed\"},\n {title:\"Deaths\", field: \"deaths\"},\n {title:\"Recovered\", field: \"recovered\"},\n {title:\"Active\", field: \"active\"},\n {title:\"Death Rate(%)\", field: \"dr\", formatter:function(cell) {return \"\"+(Math.round(cell.getValue()*10000) / 100)+\"%\";}},\n {title:\"Daily Growth\", field: \"avgr\", formatter: function(cell) {return (Math.round((cell.getValue()-1)*10000) /100)+\"%\"}},\n {title:\"Doubling\", field: \"avgr\", formatter: function(cell){return Math.round(Math.log(2) / Math.log(cell.getValue()))}}\n ]\n })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":26,"value":"confirmed = d3.csv(\"https://raw.githubusercontent.com/bumbeishvili/covid19-daily-data/master/time_series_19-covid-Confirmed.csv\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":30,"value":"deaths = d3.csv(\"https://raw.githubusercontent.com/bumbeishvili/covid19-daily-data/master/time_series_19-covid-Deaths.csv\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":32,"value":"recovered = d3.csv(\"https://raw.githubusercontent.com/bumbeishvili/covid19-daily-data/master/time_series_19-covid-Recovered.csv\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":35,"value":"geo = d3.nest().key(f(\"Country/Region\")).rollup(d => d.map(p=>p[\"Province/State\"])).object(confirmed)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"d3 = require(\"d3\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":67,"value":"import {c3} from \"@mbostock/c3\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":152,"value":"$$ = require(\"jquery\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":150,"value":"tabulator = {\n await require(\"jqueryui\");\n await require(\"jquery.tabulator\");\n const cssUrl = \"https://cdnjs.cloudflare.com/ajax/libs/tabulator/3.5.3/css/tabulator.min.css\"\n const link=html``;\n\n\n if (window._tabLink) window._tabLink.remove();\n document.body.append(window._tabLink = link);\n return function(data, spec) {\n const div = html`

`;\n if(!spec) spec = {};\n spec.data = data;\n if(!spec.columns && data[0]) {\n //Generate columns\n const sample = data[0];\n spec.columns = [];\n Object.keys(sample).forEach(c=> {\n spec.columns.push({title:c, field:c});\n console.log(c);\n });\n }\n if(!spec.pagination) spec.pagination = \"local\";\n if(!spec.paginationSize) spec.paginationSize = 10;\n $(div).tabulator(spec);\n console.log(div);\n return div;\n };\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":36,"value":"function f(name) {return function(d) {return d[name];}}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1"}} 31:"$30:body"