2e:null 2f:["$","title",null,{"children":"ixmaps - COVID-19 weekly new cases and fatalities - incidence last 20 weeks | gjrichter | Observable"}] 34:T424,theme = ixmaps.layer("generic") .data({ name: "CONFIRMED" }) .binding({ position: "Lat|Long", value: fields }) .style({ type: "CHART|SYMBOL|SEQUENCE|PLOT|LINES|AREA|BOX|GRID|COLOR|DIFFERENCE|SUM|FIXSIZE|NOCLIP|NOLEGEND", colorscheme: [ "rgba(200,150,150,1)"], fillopacity: "0.2", symbols: [ "circle"], values: [ "0", "1"], label: label, xaxis: xaxis, normalsizevalue: "2", scale: "0.08", rangescale: "1", minvalue: "0", maxvalue: "2000", align: "23right", linewidth: "10", bordercolor: "none", boxopacity: "0.01", titlefield: "Country/Region", valuescale: "1", valuedecimals: "0" }) .meta({ title: "COVID-19 - cases incidence/week
last 20 weeks", snippet: "fonte: JHU CCSE", splash: "loading and aggregating data ...
this may take a bit ...
please give me some time ..." }) .define() 35:T440,theme_f = ixmaps.layer("generic") .data({ name: "FATALITIES" }) .binding({ position: "Lat|Long", value: fields_f }) .style({ type: "CHART|SYMBOL|SEQUENCE|PLOT|LINES|LOLLIPOP|DIFFERENCE|SUM|BOX|BOTTOMTITLE|GRID|RIGHT|RECT|FIXSIZE|NOLEGEND", colorscheme: [ "rgba(120, 120, 120,0.5)"], fillopacity: "0.1", symbols: [ "circle"], values: [ "0", "1"], label: label_f, xaxis: xaxis_f, normalsizevalue: "2", scale: "0.08", rangescale: "1", minvalue: "0", maxvalue: "20", align: "23right", linewidth: "10", bordercolor: "none", boxopacity: "0.01", titlefield: "Country/Region", valuescale: "1", valuedecimals: "0" }) .meta({ title: "COVID-19 - fatality incidence/week
last 20 weeks", snippet: "fonte: JHU CCSE", splash: "loading and aggregating data ...
this may take a bit ...
please give me some time ..." }) .define() 36:[] 32:{"id":"cfac0eec43016115","slug":"ixmaps-covid-19-weekly-new-cases-and-fatalities-incidence-l","title":"ixmaps - COVID-19 weekly new cases and fatalities - incidence last 20 weeks","thumbnail":"96e9d81624ef3ce5626cf07910660d22d19ebe2bead69e9fa1874d7767decdca","access_level":"public","create_time":"$D2021-11-06T07:56:51.756Z","update_time":"$D2022-10-12T07:36:31.082Z","view_time":null,"first_public_time":"$D2022-05-18T17:20:24.461Z","has_unpublished_edits":null,"fork":{"id":"63c843c4ab61e971","slug":"ixmaps-covid-19-weekly-new-cases-and-fatalities-last-20-week","title":"ixmaps - COVID-19 weekly new cases and fatalities - last 20 weeks","owner":{"id":"ab0359f3bbecf78a","login":"gjrichter","name":""}},"stars":0,"starred":false,"owner":{"type":"team","id":"ab0359f3bbecf78a","login":"gjrichter","name":"","avatar_url":"https://avatars-next.observableusercontent.com/1dd94096da79a76babfe37a3431edc30377043a898592a3437e913920b189ed3","tier":"starter_2024"},"version":1022,"publish_version":1022,"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 new cases and fatalities - incidence last 20 weeks","cells":[{"id":352,"value":"md`# ixmaps - COVID-19 weekly new cases and fatalities - incidence last 20 weeks`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":964,"value":"map = ixmaps.embed(\"mymap\", { \n mapCdn: \"https://gjrichter.github.io/ixmaps\",\n width: \"100%\",\n height: \"840px\",\n legend: 1},\n map => map\n .view([50.064191736659104,12.94189453125],6)\n .options({\n objectScaling: \"1.7\",\n normalSizeScale: \"55000000\",\n dynamicScalePow: \"2\",\n panhidden: \"false\", \n featurescaling: \"dynamic\",\n objectscaling: \"dynamic\",\n flushChartDraw: \"50000\",\n mapopacity: \"1\",\n basemapopacity: \"1\"\n })\n .legend(legend) \n .setData(confirmed_7,{type:\"jsonDB\",name:\"CONFIRMED\"})\n .setData(fatalities_7,{type:\"jsonDB\",name:\"FATALITIES\"})\n .layer(theme_f)\n .layer(theme)\n ); ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":626,"value":"The above map shows new Covid-19 cases and fatalities accumulated by weeks for the last 20 weeks. 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\n> **Note**: every curve has its own scale to fit best into the plot. New cases are usually 100 times the fatalities. Here they are plotted with different scales into the same area to see the the ratio and dependency of both, before and after the vaccination campaign. \n \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 new COVID-19 cases 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_confirmed_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":902,"value":"Let's import the data into a Data Object to process it","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":812,"value":"rawdata_country = Data.import({\"source\":rawdata,\"type\":\"json\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":744,"value":"rawdata_f = 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":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":835,"value":"rawdata_f_country = Data.import({\"source\":rawdata_f,\"type\":\"json\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":907,"value":"The second data we need is the popolation per country, so we can calculate the incidence ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":801,"value":"pop = d3.csv(\"https://s3.eu-west-1.amazonaws.com/data.ixmaps.com/World/API_SP.POP.TOTL_DS2_en_csv_v2_1926760.csv\");","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":805,"value":"Inputs.Table(pop)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":910,"value":"Lets create a lookup tabel with key = country name and value = population","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":807,"value":"popA = Data.import({\"source\":pop,\"type\":\"json\"}).lookupArray(\"2019\",\"Country Name\");\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":915,"value":"We correct some country names to match the COVID data, \nand exclude countries with population less than 1.000.000 ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":854,"value":"{\n popA[\"US\"] = popA[\"United States\"];\n popA[\"Russia\"] = popA[\"Russian Federation\"];\n popA[\"Czechia\"] = popA[\"Czech Republic\"];\n \n for (var i in popA){\n if (popA[i] < 1000000){\n popA[i] = null;\n }\n }\n return popA;\n}\n ","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) with 7 days cumulativ incidenc.\n\nSo we first first calculate the roling mean over 7 days. Than we keep every 7th record beginning with the last.\n> The functions \\_\\_mean\\_7() and \\_\\_every\\_7() are defined in the appendix.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":435,"value":"confirmed_7 = __every_7(__mean_7(rawdata_country))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":733,"value":"Inputs.Table(confirmed_7.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":928,"value":"get an array of the colum names, it will be usefull to process the table","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":445,"value":"columnsA = confirmed_7.columnNames();","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":933,"value":"**calculate the incidence**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":840,"value":"{\n for (var i = 4; i *! we use the variables defined above in 'processing'*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":987,"value":"$34","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1005,"value":"$35","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":980,"value":"legend = \"

COVID-19
new cases / fatalities
last 20 weeks

7 days cumulative incidence (cases per 100.000)

The two curves have different scales:
cases: 0-1000, fatalities: 0-10

data: 2019 Novel Coronavirus COVID-19 (2019-nCoV) Data Repository by Johns Hopkins CSSE

last updated: \"+actual_date+\"

\"","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":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":"$W36","stdlib":"1","titling":"auto"}} 33:"$32:body"

COVID-19 new cases / fatalities last 20 weeks

7 days cumulative incidence (cases per 100.000)

The two curves have different scales: cases: 0-1000, fatalities: 0-10

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

COVID-19
new cases / fatalities
last 20 weeks

The two curves have different scales:
cases: 0-1000, fatalities: 0-10

data: 2019 Novel Coronavirus COVID-19 (2019-nCoV) Data Repository by Johns Hopkins CSSE

last updated: \"+actual_date+\"