2d:null 2e:["$","title",null,{"children":"Excess mortality during COVID-19 | Roger Veciana i Rovira | Observable"}] 33:T81d,chart = { const context = this ? this.getContext("2d") : DOM.context2d(width, height); context.clearRect(0, 0, context.canvas.width, context.canvas.height); context.globalAlpha = 1; context.lineWidth = 3; context.font = "20px Helvetica"; let posLabel = 0; if(dataUntilCurrentDate.length > 0 && dataUntilCurrentDate[0].dates.length > 0){ let i = 0; let currDate = new Date(dataUntilCurrentDate[0].dates[i]) let currDate2; while(currDate <= date){ currDate = new Date(dataUntilCurrentDate[0].dates[i]); currDate2 = new Date(dataUntilCurrentDate[0].dates[i+1]); for(let countryIdx=0; countryIdx{ const data = new Array(d.length * (frontYear - 2015)); const dates = new Array(d.length * (frontYear - 2015)); d.forEach((c,i)=>{ const [cYear, cMonth, cDay] = c.Date.split("-"); if(frontYear > 2015){ data[i] = c['deaths_2015_all_ages']!==""?parseInt(c['deaths_2015_all_ages']):-999; dates[i] = `2015-${cMonth}-${cDay}`; } if(frontYear > 2016){ data[i+d.length] = c['deaths_2016_all_ages']!==""?parseInt(c['deaths_2016_all_ages']):-999; dates[i+d.length] = `2016-${cMonth}-${cDay}`; } if(frontYear > 2017){ data[i+2*d.length] = c['deaths_2017_all_ages']!==""?parseInt(c['deaths_2017_all_ages']):-999; dates[i+2*d.length] = `2017-${cMonth}-${cDay}`; } if(frontYear > 2018){ data[i+3*d.length] = c['deaths_2018_all_ages']!==""?parseInt(c['deaths_2018_all_ages']):-999; dates[i+3*d.length] = `2018-${cMonth}-${cDay}`; } if(frontYear > 2019){ data[i+4*d.length] = c['deaths_2019_all_ages']!==""?parseInt(c['deaths_2019_all_ages']):-999; dates[i+4*d.length] = `2019-${cMonth}-${cDay}`; } if(parseInt(cMonth) < date.getMonth() + 1 || (parseInt(cMonth) === date.getMonth() + 1 && parseInt(cDay) <= date.getDate())){ switch(frontYear){ case 2015: data.push(c['deaths_2015_all_ages']); dates.push(`2015-${cMonth}-${cDay}`); break; case 2016: data.push(c['deaths_2016_all_ages']); dates.push(`2016-${cMonth}-${cDay}`); break; case 2017: data.push(c['deaths_2017_all_ages']); dates.push(`2017-${cMonth}-${cDay}`); break; case 2018: data.push(c['deaths_2018_all_ages']); dates.push(`2018-${cMonth}-${cDay}`); break; case 2019: data.push(c['deaths_2019_all_ages']); dates.push(`2019-${cMonth}-${cDay}`); break; case 2020: data.push(c['Deaths, 2020, all ages']); dates.push(`2020-${cMonth}-${cDay}`); break; } } }); return {dates,data}; })35:T57e,function autoSelect(config = {}) { const { value, title, description, disabled, autocomplete = "off", placeholder, size, options, list = "options", onAdd } = Array.isArray(config) ? { options: config } : config; const optionsSet = new Set(options); const form = input({ type: "text", title, description, attributes: { disabled }, action: fm => { fm.value = fm.input.value = value || ""; fm.onsubmit = e => e.preventDefault(); fm.input.oninput = function(e) { e.stopPropagation(); fm.value = fm.input.value; if (!fm.value || optionsSet.has(fm.value)) if(!selectedCountries.includes(fm.value)){ mutable selectedCountries = selectedCountries.length === maxCountries ? [...selectedCountries] : [...selectedCountries, fm.value]; } fm.dispatchEvent(new CustomEvent("input")); }; }, form: html` ` }); form.output.remove(); return form; }36:[{"id":"ca535f7d7b5d8ba3040bcabbcec696f9967f254b9ab8bac2cdbd0d7173a0e1fb60f5c5fd610f3f531e4a99782f64b1a689de01f5a608075e2a87e6330d350d35","href":"https://static.observableusercontent.com/files/ca535f7d7b5d8ba3040bcabbcec696f9967f254b9ab8bac2cdbd0d7173a0e1fb60f5c5fd610f3f531e4a99782f64b1a689de01f5a608075e2a87e6330d350d35","name":"excess-mortality-raw-death-count-latest@1.csv","type":"text/csv","lastModified":1609072884809.378,"size":108227}] 31:{"id":"61bec57fa05a914b","slug":"excess-mortality-during-covid-19","title":"Excess mortality during COVID-19","thumbnail":"6918f078331a34ac24d5db813934f6a8c7148f97c2c6c65bcf54b9197047f707","access_level":"public","create_time":"$D2020-12-20T18:40:00.957Z","update_time":"$D2020-12-27T12:41:59.076Z","view_time":null,"first_public_time":"$D2020-12-27T12:43:30.973Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"84c194f738aa2fd0","login":"rveciana","name":"Roger Veciana i Rovira","avatar_url":"https://avatars-next.observableusercontent.com/3d41fc7154bfd9017ccebf2744e03c955d78bc31819f90c700dd263c3f301e07","tier":"starter_2024"},"version":644,"publish_version":644,"role":null,"authored":false,"authors":[{"type":"individual","id":"4c469cbe1fd30687","login":"rveciana","name":"Roger Veciana i Rovira","avatar_url":"https://avatars-next.observableusercontent.com/3d41fc7154bfd9017ccebf2744e03c955d78bc31819f90c700dd263c3f301e07","tier":null}],"members":[{"type":"individual","id":"4c469cbe1fd30687","login":"rveciana","name":"Roger Veciana i Rovira","avatar_url":"https://avatars-next.observableusercontent.com/3d41fc7154bfd9017ccebf2744e03c955d78bc31819f90c700dd263c3f301e07","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":2,"collection":null,"type":"notebook","body":{"title":"Excess mortality during COVID-19","cells":[{"id":0,"value":"md`# Excess mortality during COVID-19\n\n* Data source: https://ourworldindata.org/grapher/excess-mortality-raw-death-count\n* Idea: https://www.reddit.com/r/dataisbeautiful/comments/kg66b2/oc_deaths_per_week_2020_vs_previous_years/?utm_source=share&utm_medium=ios_app&utm_name=iossmf\n* Visualization based on: https://observablehq.com/@rveciana/monthly-mean-co-sub-2-sub-concentration-at-mauna-loa `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":21,"value":"viewof selectedCountry = autoSelect({\n options: countries.filter(d=>!selectedCountries.includes(d)) ,\n placeholder: selectedCountries.length === maxCountries?\"Remove a country to add another\":\"Select country to add\",\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":88,"value":"{\n if(selectedCountries.length === 0){\n return html`Select some country to see the data`;\n }\n \n const form = html``;\n selectedCountries.forEach(d=>{\n form[`delete_${replaceNames(d)}`].onclick = () => {\n mutable selectedCountries = selectedCountries.filter(c => c!== d);\n };\n })\n \n \n \n return form;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":223,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":564,"value":"viewof dataI = Scrubber(Array.from({length: 365 * 6}, (_, i) => i), {delay: 50})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":287,"value":"date = new Date(2015, 0, dataI)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":240,"value":"frontDayOfYear = dataI%365","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":246,"value":"frontYear = 2015 + Math.floor(dataI/365)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":236,"value":"xPos = function(date){\n let day = daysIntoYear(date) - frontDayOfYear;\n return {x: width/2 + (width/3) * Math.sin(2*Math.PI * day/365),\n alpha: 0.66 + Math.cos(2*Math.PI * day/365)/3}\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":243,"value":"daysIntoYear = function(date){\n return (Date.UTC(date.getFullYear(), date.getMonth(), date.getDate()) - Date.UTC(date.getFullYear(), 0, 0)) / 24 / 60 / 60 / 1000;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":263,"value":"minDeaths = selectedData.flatMap(d=>d).reduce((acc, d)=>{\n const minDate = Math.min(d['Deaths, 2020, all ages'], d['deaths_2015_all_ages'], d['deaths_2016_all_ages'], d['deaths_2017_all_ages'], d['deaths_2018_all_ages'], d['deaths_2019_all_ages']);\n return minDated).reduce((acc, d)=>{\n const maxDate = Math.max(d['Deaths, 2020, all ages'], d['deaths_2015_all_ages'], d['deaths_2016_all_ages'], d['deaths_2017_all_ages'], d['deaths_2018_all_ages'], d['deaths_2019_all_ages']);\n return maxDate>acc?maxDate:acc;}\n ,0)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":542,"value":"scaleInterval = {\n if(maxDeaths < 1000){\n return 100;\n } else if(maxDeaths < 5000) {\n return 500; \n } else if(maxDeaths < 10000) {\n return 1000; \n } else if(maxDeaths < 20000) {\n return 2000; \n } else {\n return 5000; \n }\n\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":259,"value":"scaleY = d3.scaleLinear()\n .domain([maxDeaths, minDeaths])\n .range([-200, 200])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":298,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":214,"value":"selectedData = selectedCountries.map(country=>getCountryData(country));","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"value":"mutable selectedCountries = [\"Austria\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":492,"value":"countriesEmojis = selectedCountries.map(d=>{\n const base_image = new Image();\n base_image.src = getEmojiImage(d);\n return base_image;\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":284,"value":"monthPos = function(i){\n let result = new Date('1999-12-31');\n result.setDate(result.getDate() + months[i].d);\n let iniInt = frontDayOfYear-92<0?frontDayOfYear-92+365:frontDayOfYear-92;\n let endInt = frontDayOfYear+91>365?frontDayOfYear+91-365:frontDayOfYear+91;\n let condition;\n if(endInt > iniInt){\n condition = iniInt<=months[i].d && endInt>=months[i].d;\n } else {\n condition = iniInt<=months[i].d || endInt>=months[i].d;\n }\n if (condition){\n return xPos(result).x;\n }\n return -9999;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":281,"value":"months = [{d:1, t:\"Jan\"}, {d:32, t:\"Feb\"}, {d:60, t:\"Mar\"}, {d:91, t:\"Apr\"}, {d:121, t:\"May\"}, {d:152, t:\"Jun\"}, {d:182, t:\"Jul\"}, {d:213, t:\"Aug\"}, {d:244, t:\"Sep\"}, {d:274, t:\"Oct\"}, {d:301, t:\"Nov\"}, {d:335, t:\"Des\"}]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"countries = data.reduce((acc, d) => acc.includes(d.Entity) ? acc : [...acc, d.Entity], [])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":204,"value":"data = FileAttachment(\"excess-mortality-raw-death-count-latest@1.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"d3 = require(\"https://d3js.org/d3.v6.min.js\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":256,"value":"colorScale = [d3.interpolateHsl(\"rgb(23, 72, 170)\", \"rgb(117, 18, 130)\"),\n d3.interpolateHsl(\"rgb(255, 72, 17)\", \"rgb(100, 18, 30)\"),\n d3.interpolateHsl(\"rgb(229,245,224)\", \"rgb(49,163,84)\"),\n d3.interpolateHsl(\"rgb(255, 255, 255)\", \"rgb(0,0,0)\"),\n d3.interpolateHsl(\"rgb(239,237,245)\", \"rgb(117,107,177)\")]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":555,"value":"maxCountries = 5","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":41,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":212,"value":"function getCountryData(country){\n const countryData = data.filter(d=>d.Entity === country);\n \n return countryData;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":228,"value":"width = 600","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":231,"value":"height = 500","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":113,"value":"//https://observablehq.com/@mbostock/html-in-markdown\nfunction clone(elements) {\n return elements.map(e => e.cloneNode(true));\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":450,"value":"function replaceNames(country){\n\n return country.replace(\"Czechia\", \"czech_republic\")\n .replace(\"Germany\", \"de\")\n .replace(\"England & Wales\", \"england\")\n .replace(\"France\", \"fr\")\n .replace(\"Italy\", \"it\")\n .replace(\"New Zealand\", \"new_zealand\")\n .replace(\"Northern Ireland\", \"Ireland\")\n .replace(\"South Korea\", \"kr\")\n .replace(\"Spain\", \"es\")\n .replace(\"United States\", \"us\")\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":197,"value":"function getEmoji(country){\n return emoji[replaceNames(country).toLowerCase()]() \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":488,"value":"function getEmojiImage(country){\n\n const d = {}\n Object.keys(ghEmojis).map(emojiName=>{\n const cleanName = emojiName\n .replace('+', 'plus')\n .replace('-', 'minus')\n d[cleanName] = () => ghEmojis[emojiName]\n })\n return d[replaceNames(country).toLowerCase()]();\n\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":70,"value":"import {emoji, ghEmojis} from '@asg017/emojis'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":44,"value":"import {input} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":630,"value":"import {Scrubber} from \"@mbostock/scrubber\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W36","stdlib":"1","titling":"auto"}} 32:"$31:body"