21:null 22:["$","title",null,{"children":"Confirmed daily deaths due to COVID-19 VS Internal Mobility By Country | Raphael Charriez | Observable"}] 27:T5cd,html``28:T41b,timeseries = countries.map(location => ({ location, daysWalkingMobilityData: daysRange.map(date => { let m = rawDataAppleMobility.find(d=> d.region === countriesMapping[location] && d.transportation_type === "walking") return m ? parseInt(m[dateFormat(date)]) : 0 }), daysData: daysRange.map(date => rawDataEcdcIndexed[[location, dateFormat(date)]]), })).map(d => ({ ...d, maxDeathsPerDay: d3.max(d.daysData, t => t ? +t.new_deaths : 0), totalDeaths: d3.max(d.daysData, t => t ? +t.total_deaths : 0) })).map(d => ({ ...d, firstDay: d.maxDeathsPerDay == 0 ? Infinity : d.daysData.findIndex(d => d && d.new_deaths > 0), daysSinceMax: d.maxDeathsPerDay == 0 ? Infinity : d.daysData.length - d.daysData.map(t => t ? +t.new_deaths : 0).lastIndexOf(+d.maxDeathsPerDay), lastValue: d.daysData[d.daysData.length-1] ? d.daysData[d.daysData.length-1].new_deaths / d.maxDeathsPerDay : 0, })).map(d => ({ ...d, lastValue3dAvg: avg(d.daysData.slice(d.daysData.length - 3).map(t => t ? t.new_deaths / d.maxDeathsPerDay : 0)), }))29:[{"id":"d90203b5a4169b0f7d40f62c57bbe4e9b9c094afbb0b3729629f56aa7d492ea1401f876add805995a79a07968bc83014fcc7f0d428059421a272060ddc300ebb","href":"https://static.observableusercontent.com/files/d90203b5a4169b0f7d40f62c57bbe4e9b9c094afbb0b3729629f56aa7d492ea1401f876add805995a79a07968bc83014fcc7f0d428059421a272060ddc300ebb","name":"Screen Shot 2020-04-26 at 5.14.34 PM.png","type":"image/png","lastModified":1587888891886.172,"size":432343},{"id":"71fa71fa1899418b11fb853d6c5a5ef284e1e446b07d96077180522d78e1dbf212bd8f720a27ad734980b7395c31dfd6d4367f4a6fb0ab91d628946a0617c27a","href":"https://static.observableusercontent.com/files/71fa71fa1899418b11fb853d6c5a5ef284e1e446b07d96077180522d78e1dbf212bd8f720a27ad734980b7395c31dfd6d4367f4a6fb0ab91d628946a0617c27a","name":"owid-covid-data.csv","type":"text/csv","lastModified":1607204134982.917,"size":2785100},{"id":"81e78ac0540fa0fb9d162f8d16174fed59c4737f9e86be12def22bf776001e56fbad404cfc7aa31fc7f22321a3e12be88f1e3d4cb278c73614eda132ad3c77f4","href":"https://static.observableusercontent.com/files/81e78ac0540fa0fb9d162f8d16174fed59c4737f9e86be12def22bf776001e56fbad404cfc7aa31fc7f22321a3e12be88f1e3d4cb278c73614eda132ad3c77f4","name":"applemobilitytrends-2020-12-04 (1).csv","type":"text/csv","lastModified":1607202976222.193,"size":323855}] 25:{"id":"de12d04d5ff6541c","slug":"peaks-in-confirmed-daily-deaths-due-to-covid-19-so-far","title":"Confirmed daily deaths due to COVID-19 VS Internal Mobility By Country","thumbnail":"e267e40bc08d590590f3ae15d994550d8b1ca17ac935b79618f809641aa1f71a","access_level":"public","create_time":"$D2020-04-25T23:00:06.226Z","update_time":"$D2020-12-05T22:08:28.536Z","view_time":null,"first_public_time":"$D2020-04-25T23:03:15.253Z","has_unpublished_edits":null,"fork":{"id":"7755645eb7da2ba5","slug":"peaks-in-confirmed-daily-deaths-due-to-covid-19-so-far","title":"Peaks in confirmed daily deaths due to COVID-19 so far","owner":{"id":"8219cd6ab84b2e09","login":"antejan","name":""}},"stars":0,"starred":false,"owner":{"type":"team","id":"cdff20d7c9d4b9fc","login":"raphaelcharriez","name":"Raphael Charriez","avatar_url":"https://avatars-next.observableusercontent.com/596a18931b25ef1c8954a143f55d83839ea295055211880959f2d75fddd2e864","tier":"starter_2024"},"version":544,"publish_version":544,"role":null,"authored":false,"authors":[{"type":"individual","id":"1d94c972250a551e","login":"raphaelcharriez","name":"Raphael Charriez","avatar_url":"https://avatars-next.observableusercontent.com/596a18931b25ef1c8954a143f55d83839ea295055211880959f2d75fddd2e864","tier":null}],"members":[{"type":"individual","id":"1d94c972250a551e","login":"raphaelcharriez","name":"Raphael Charriez","avatar_url":"https://avatars-next.observableusercontent.com/596a18931b25ef1c8954a143f55d83839ea295055211880959f2d75fddd2e864","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Confirmed daily deaths due to COVID-19 VS Internal Mobility By Country","cells":[{"id":0,"value":"md`# Confirmed daily deaths due to COVID-19 VS Internal Mobility By Country \n\nGot inspired by @Antejan visualization, and adapted it to grasp the effect of mobility limitations (measured from apple map # of walking itinerary requests) on # of Covid Deaths by Country.\n\nData ECDC via [OurWorldInData.org](https://ourworldindata.org/coronavirus-source-data) (last update ${rawDataEcdc[rawDataEcdc.length - 1].date}).\n\nMobility Data via [Apple Mobility Open Data](https://www.apple.com/covid19/mobility) (2 days lag)\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":368,"value":"viewof filterCountries = select({\n title: \"Filter countries\",\n options: [\n {label: \"All countries with confirmed cases\", value: 0},\n {label: \"1000+ deaths\", value: 1000},\n {label: \"5000+ deaths\", value: 5000},\n {label: \"10000+ deaths\", value: 10000},\n {label: \"50000+ deaths\", value: 50000},\n ],\n value: 5000\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":330,"value":"viewof sortByMetric = select({\n title: \"Sort by\",\n options: [\n {label: \"Days since max value\", value: \"daysSinceMax\"},\n {label: \"Day of first value\", value: \"firstDay\"},\n {label: \"Sum values\", value: \"totalDeaths\"},\n {label: \"Alphabetically\", value: \"location\"},\n ],\n value: \"totalDeaths\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":300,"value":"html`

${legend({\n color: d3.scaleSequential([0.01, 1], colorInterpolator),\n tickFormat: \"%\",\n title: 'COVID-19 death cases relative to country\\'s highest'\n})}

${legend({\n color: d3.scaleSequential([0.01, 1], mobilityColorInterpolator),\n tickFormat: \"%\",\n title: '# of Apple Maps Request Relative to Top in Feb 01'\n})}

`\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":94,"value":"html`\n

\n ${renderLegend()}\n ${sortedTimeSeries.map(renderCountry)}\n

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":226,"value":"md`---\n### Rendering`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":248,"value":"renderLegend = () => html`\n

\n ${daysRange.map((date) => `\n

${dateFormatNice(date)}

\n `)}\n

Total

${countryData.daysData.map((dayData, i) => renderDay(dayData, countryData, countryData.daysWalkingMobilityData[i]))}

${numFormat(countryData.totalDeaths)}

${countryData.location}

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":142,"value":"renderDay = (dayData, countryData, mobilityData) => {\n const isMax = dayData && dayData.new_deaths > 0 && (dayData.new_deaths == countryData.maxDeathsPerDay);\n const frac = (dayData ? dayData.new_deaths : 0) / countryData.maxDeathsPerDay;\n return html`\n \n

\n\n\n`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":302,"value":"colorInterpolator = d3.interpolateRgbBasis(['#fef4b3', '#ffa579', '#e15483'])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":435,"value":"mobilityColorInterpolator = d3.interpolateRgbBasis([\"#FFE39F\", \"#EBDDA0\", \"#D9D7A1\", \"#C7D1A1\", \"#B6CAA2\", \"#A7C3A2\", \"#98BBA2\", \"#8AB3A2\", \"#7DABA2\", \"#71A3A2\", \"#669BA1\", \"#5B92A1\", \"#528AA0\", \"#48819F\", \"#40789F\", \"#38709E\", \"#31679D\", \"#2B5E9C\", \"#25549A\", \"#1F4B99\"])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":139,"value":"color = (d) => d ? colorInterpolator(d) : '#badad0'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":437,"value":"mobilityColor = (d) => d ? mobilityColorInterpolator(d) : '#F5F8FA'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"$27","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":230,"value":"md`---\n### Data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"rawDataEcdc = d3.csvParse(await FileAttachment(\"owid-covid-data.csv\").text())\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":508,"value":"rawDataEcdcIndexed = rawDataEcdc.reduce((a,row) => {\n a[[row.location, row.date]] = row\n return a \n},{})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":439,"value":"rawDataAppleMobility = d3.csvParse(await FileAttachment(\"applemobilitytrends-2020-12-04 (1).csv\").text())\n\n//d3.csv(`https://covid19-static.cdn-apple.com/covid19-mobility-data/2008HotfixDev38/v3/en-us/applemobilitytrends-${dateFormat(new Date().addDays(-2))}.csv`)\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":40,"value":"dateRange = [new Date('2020-01-31'), d3.max(rawDataEcdc, d => new Date(d.date))]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":60,"value":"daysRange = d3.timeDays.apply(null, dateRange)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":46,"value":"countries = [...rawDataEcdc.reduce((s, d) => (s.add(d.location),s), new Set())]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":443,"value":"exceptions = new Object({\"United Kingdom\" : \"UK\", \"South Korea\": \"Republic of Korea\"});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":445,"value":"countriesMapping = countries.reduce((d, v) => ({...d, [v]: exceptions[v] ? exceptions[v] : v,}), {});\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":35,"value":"$28","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":344,"value":"sortedTimeSeries = timeseries\n .filter(d => d.totalDeaths >= filterCountries)\n .sort(sorters[sortByMetric])\n .sort((a, b) => a.location === 'World' ? -1 : b.location === 'World' ? 1 : 0)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":351,"value":"sorters = ({\n daysSinceMax: (a, b) => a.daysSinceMax - b.daysSinceMax,\n lastValue: (a, b) => b.lastValue - a.lastValue,\n lastValue3dAvg: (a, b) => b.lastValue3dAvg - a.lastValue3dAvg,\n totalDeaths: (a, b) => b.totalDeaths - a.totalDeaths,\n location: (a, b) => a.location > b.location ? 1 : -1,\n firstDay: (a, b) => a.firstDay - b.firstDay,\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":232,"value":"md`---\n### Helpers`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":77,"value":"dateFormat = d3.timeFormat(\"%Y-%m-%d\")\t","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":209,"value":"dateFormatNice = d3.timeFormat(\"%b\")\t","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":121,"value":"formatLocale = d3.formatLocale({\n thousands: '',\n grouping: [3]\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":111,"value":"numFormat = formatLocale.format(\",\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":412,"value":"avg = arr => arr.length === 0 ? 0 : arr.reduce((a, b) => a + (b || 0), 0) / arr.length","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":441,"value":"Date.prototype.addDays = function(days) {\n var dat = new Date(this.valueOf())\n dat.setDate(dat.getDate() + days);\n return dat;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":234,"value":"md`---\n### Imports`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"d3 = require(\"d3@5\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":294,"value":"import {legend} from \"@d3/color-legend\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":297,"value":"import {select} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W29","stdlib":"1"}} 26:"$25:body"