2d:null 2e:["$","title",null,{"children":"ixmaps - COVID-19 weekly fatalities | gjrichter | Observable"}] 33:T4d1,theme = () => { return { "layer": "World Mercator", "field": fields, "field100": "", "style": { "type": "CHART|SYMBOL|SEQUENCE|PLOT|LINES|AREA|LOLLIPOP|BOX|GRID|TITLE|COLOR|DIFFERENCE|SUM|FIXSIZE|NOLEGEND", "colorscheme": [ "155", "rgba(150,150,150,1)", "rgba(50, 50, 50,1)"], "fillopacity": "0.3", "shadow": "false", "dbtable": "CONFIRMED", "datacache": "false", "lookupfield": "Lat|Long", "symbols": [ "circle"], "units": "", "label": label, "xaxis": xaxis, "normalsizevalue": "2", "scale": "0.05", "rangescale": "0.5", "minvalue": "0", "maxvalue": "auto", "align": "23right", "linewidth": "30", "bordercolor": "none", "boxopacity": "0", "titlefield": "Country/Region", "titleupper": "1:10000000", "textcolor": "rgba(200, 0, 90,1)", "name": "new_cases_curves_2", "title": "COVID-19 - new cases/day
last 56 days", "snippet": "fonte: JHU CCSE" } } }34:T48a,project = () => { return { "$schema": "https://gjrichter.github.io/ixmaps/schema/ixmaps/v1.json", "map": { "map": "../../maps/svg/maps/generic/mercator.svg", "attribution": "iXMaps", "basemap": "ArcGIS - Light Gray Base", "legend": "

COVID-19
fatalities by week

Moving average over 7 days. Every curve has its own scale to fit into the plot space

data: 2019 Novel Coronavirus COVID-19 (2019-nCoV) Data Repository by Johns Hopkins CSSE
last updated: "+actual_date+"

", "item": "html", "scaleParam": { "objectScaling": "1.7", "normalSizeScale": "55000000", "dynamicScalePow": "2" }, "options": { "featurescaling": "dynamic", "objectscaling": "dynamic", "flushChartDraw": "50000", "mapopacity": "1", "basemapopacity": "1" }, "center": { "lat": "38.134556577054134", "lng": "12.304687500000002" }, "zoom": "2" }, "themes": [ theme() ], } }35:[] 31:{"id":"68e69d7af2a967cd","slug":"ixmaps-covid-19-weekly-fatalities","title":"ixmaps - COVID-19 weekly fatalities","thumbnail":"0ce36bb6cc2eae561c5563c7621f68a54544ecd2c131de66222495889feb4d91","access_level":"public","create_time":"$D2021-10-31T08:53:42.068Z","update_time":"$D2021-11-03T09:27:19.618Z","view_time":null,"first_public_time":"$D2021-11-03T09:22:02.975Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"ab0359f3bbecf78a","login":"gjrichter","name":"","avatar_url":"https://avatars-next.observableusercontent.com/1dd94096da79a76babfe37a3431edc30377043a898592a3437e913920b189ed3","tier":"starter_2024"},"version":866,"publish_version":866,"role":null,"authored":false,"authors":[{"type":"individual","id":"921009d8ff1c586f","login":"gjrichter","name":"","avatar_url":"https://avatars-next.observableusercontent.com/1dd94096da79a76babfe37a3431edc30377043a898592a3437e913920b189ed3","tier":null}],"members":[{"type":"individual","id":"921009d8ff1c586f","login":"gjrichter","name":"","avatar_url":"https://avatars-next.observableusercontent.com/1dd94096da79a76babfe37a3431edc30377043a898592a3437e913920b189ed3","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"title":"ixmaps - COVID-19 weekly fatalities","cells":[{"id":352,"value":"md`# ixmaps - COVID-19 weekly fatalities`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":453,"value":"","pinned":true,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":626,"value":"The above map shows Covid-19 deaths week by week for the last 52 weeks (one year), smoothed by a 7 days roling average. It is realized with the iXMaps framework and an visualization project described below.\nIt features the iXMaps ability to create line plots on map position. \n\nThe data comes from the Johns Hopkins University CSSE and is published with daily updates on GitHub.\n\nIn the following we show the raw data, the data preparation process and the definition of the iXmaps project to create the above interactive map.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":419,"value":"---\n# Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":641,"value":"The data contains the accumulated COVID-19 deaths for all countries and days since febrary 2020. Here we load the data from it's GitHub repository","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":409,"value":"rawdata = d3.csv(\"https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_deaths_global.csv\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":414,"value":"Inputs.Table(rawdata)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":528,"value":"---\n## processing","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":577,"value":"We want to show smoothed data (7 days roling mean) of one year by 52 weekly accumulated data.\n\nWe use two processing functions defines in the appendix\n- **__mean_7()** calculates the roling mean over 7 days.\n- **__every_7()** removes 6 by 7 days from the table ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":650,"value":"> *first of all, the data is imported into a Data object (Data.import(...)) which defines some data manipulation methods*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":435,"value":"confirmed_7 = __every_7(__mean_7(Data.import({\"source\":rawdata,\"type\":\"json\"})))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":778,"value":"Inputs.Table(confirmed_7.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":744,"value":"For the visualizzation we need only the last 53 data columns of the above table. We create a sub table with the first 4 *.slice(0,4)* and the last 53 *sclice(-53)* columns. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":445,"value":"columns = confirmed_7.columnNames();","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":785,"value":"final = confirmed_7.subtable({\"fields\":columns.slice(0,4).concat(columns.slice(-91))});","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":792,"value":"Inputs.Table(final.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":808,"value":"This is our final data.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":584,"value":"---\nNow we crate **variables** to **configure the visualizzation theme** which define the **data fields** to use.\n\nFrom the above array with the column names of our result table we clone the data fields, label and xaxis for the visualizzation theme.\n\nThe fields defines the **data columns** for the visualizzation as one \"|\" separated string","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":449,"value":"fields = columns.slice(-91).join(\"|\");","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":769,"value":"**Label** and **xaxis** are arrays with the data column names","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":472,"value":"label = columns.slice(-90);","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":477,"value":"xaxis =columns.slice(-90);","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":588,"value":"We transform the xaxis values in something readable.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":481,"value":"{\nfor ( var i=1; i < xaxis.length-1; i++ ){\n\t\t\txaxis[i] = (xaxis.length-i)%53?\" \":new Date(xaxis[i]).toLocaleDateString();\n\t\t}\n\t\txaxis[0] = new Date(xaxis[0]).toLocaleDateString();\n\t\txaxis[xaxis.length-1] = new Date(xaxis[xaxis.length-1]).toLocaleDateString();\n return xaxis;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":592,"value":"The last column name gives us the last updated text for the legend","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":495,"value":" actual_date = new Date(xaxis[xaxis.length-1]).toLocaleDateString();","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":555,"value":"---\n# Visualization project","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":596,"value":"An iXMaps project consists of map specifications and one or more theme definitions. \n\nHere we define first the theme and than the project that includes the theme.\n\n> *! we use the variables defined above during the data processing*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":547,"value":"$33","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":661,"value":"
The project defines the map, the legend and the interactive behavior.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":575,"value":"$34","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":601,"value":"
To initialize the interactive visualization, we use the below function of the iXMaps API to wait for the platform loaded into an iframe (top of page) to be ready and use the returned map handle to load the data and the project","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":572,"value":"{\n ixmaps.waitForMap('map1',map => {\n map.setData(final,{type:\"jsonDB\",name:\"CONFIRMED\"});\n map.loadProject(project());\n }) \n return project();\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":610,"value":"That's it!","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":516,"value":"--- \n### helper functions","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":432,"value":"\t__mean_7 = function(table) {\n\t\t\n\t\t// make mean of 7 days\n\t\tvar records = table.records;\n\t\tfor ( var r=0; r=10; c--){\n\t\t\t\trecords[r][c] = ((Number(records[r][c])+\n\t\t\t\t\t\t\t\t Number(records[r][c-1])+\n\t\t\t\t\t\t\t\t Number(records[r][c-2])+\n\t\t\t\t\t\t\t\t Number(records[r][c-3])+\n\t\t\t\t\t\t\t\t Number(records[r][c-4])+\n\t\t\t\t\t\t\t\t Number(records[r][c-5])+\n\t\t\t\t\t\t\t\t Number(records[r][c-6]))/7).toFixed(2);\n\t\t\t}\n\t\t}\n\t\tvar columns = table.columnNames();\n\t\ttable.column(columns[4]).remove();\n\t\ttable.column(columns[5]).remove();\n\t\ttable.column(columns[6]).remove();\n\t\ttable.column(columns[7]).remove();\n\t\ttable.column(columns[8]).remove();\n\t\ttable.column(columns[9]).remove();\n\t\t\n\t\treturn table;\n }; \n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":691,"value":"\t__every_7 = function(table) {\n\t\t\n\t\t// remove columns to get a table with data every 28 day\n var columnsA = table.columnNames();\n\n // skip first 4 columns \n columnsA.shift();\n columnsA.shift();\n columnsA.shift();\n columnsA.shift();\n\n var len = columnsA.length;\n for (var i = 0; i < len; i++) {\n if ( i%7 ){\n table.column(columnsA[len-1-i]).remove();\n }\n }\n\t\n\t\treturn table;\n };","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":503,"value":"---\n### Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":507,"value":"ixmaps = require('https://gjrichter.github.io/ixmaps/ui/js/htmlgui_api.js')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":510,"value":"Inputs = require(\"@observablehq/inputs@0.7.21/dist/inputs.umd.min.js\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":513,"value":"Data = require('https://gjrichter.github.io/data.js/data.js')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W35","stdlib":"1","titling":"auto"}} 32:"$31:body"

COVID-19 fatalities by week

Moving average over 7 days. Every curve has its own scale to fit into the plot space

data: 2019 Novel Coronavirus COVID-19 (2019-nCoV) Data Repository by Johns Hopkins CSSElast updated: "+actual_date+"

COVID-19
fatalities by week

data: 2019 Novel Coronavirus COVID-19 (2019-nCoV) Data Repository by Johns Hopkins CSSE
last updated: "+actual_date+"