2d:null 2e:["$","title",null,{"children":"Covid Charts : Global | alastairorchard | Observable"}] 33:T43c,viewof covidMap = { // You'll often see Leaflet examples initializing a map like L.map('map'), // which tells the library to look for a div with the id 'map' on the page. // In Observable, we instead create a div from scratch in this cell, so it's // completely self-contained. let container = DOM.element('div', { style: `width:${width}px;height:${width}px`}); // Note that I'm yielding the container pretty early here: this allows the // div to be placed on the page. This is important, because Leaflet uses // the div's .offsetWidth and .offsetHeight to size the map. If I were // to only return the container at the end of this method, Leaflet might // get the wrong idea about the map's size. yield container; // Now we create a map object and add a layer to it. let map = L.map(container).setView([50,12], 5); let osmLayer = L.tileLayer(map_styles[map_styling].url, { attribution: map_styles[map_styling].attribution }).addTo(map); let covidLayer = L.heatLayer(covid_heatmap, {minOpacity :0.5}, {raduis:3}, {blur:10}).addTo(map); } 34:T58f,function getDataBy({ dataKey, date, selectedContinents, order, minimumPopulation }) { return ( final_world_data .filter(d => d) .filter(d => d.iso_code !== 'OWID_WRL') // Filter out countries with populations under 1 million .filter(d => d.population > parseInt(minimumPopulation)) .filter(d => { return d.date === getIsoDate(date); }) .filter(d => d[dataKey]) .filter(d => { const country = countries.find(c => c.iso3 === d.iso_code); const continent = continents.find((c, i) => { if (!country) { return false; } return c.id === country.continentCode; }); if (!continent) { return false; } return selectedContinents.includes(continent.id); }) .map(d => { const country = countries.find(c => c.iso3 === d.iso_code); const continent = continents.find(c => c.id === country.continentCode); const name = country.shortName || country.name; return { name, id: country.iso3, value: d[dataKey], fill: continent.fill, colour: continent.colour || 'white' }; }) .filter(d => d.value !== "0.0") .sort(function(a, b) { const mod = order === 'desc' ? -1 : 1; return mod * (a.value - b.value); }) ); }35:[] 31:{"id":"26a05f97081b4f59","slug":"covid-charts-global","title":"Covid Charts : Global","thumbnail":"a314dec7709db9d01f5ed0448cd394a4f498465572f8f8752e76e0f71b284970","access_level":"public","create_time":"$D2020-10-29T07:05:20.989Z","update_time":"$D2020-12-13T09:44:27.571Z","view_time":null,"first_public_time":"$D2020-10-29T10:09:08.446Z","has_unpublished_edits":null,"fork":{"id":"3070e772c5e3eb4c","slug":"covid-charts","title":"Covid Charts","owner":{"id":"bcbd34b126c1c773","login":"alastairorchard","name":""}},"stars":1,"starred":false,"owner":{"type":"team","id":"bcbd34b126c1c773","login":"alastairorchard","name":"","avatar_url":"https://avatars-next.observableusercontent.com/323fd2061169ea2bd69b7ab108d92e1d575c6ee8e03abf6a96428e2dd691eef9","tier":"starter_2024"},"version":6124,"publish_version":6124,"role":null,"authored":false,"authors":[{"type":"individual","id":"4be011186b558e8a","login":"alastairorchard","name":"","avatar_url":"https://avatars-next.observableusercontent.com/323fd2061169ea2bd69b7ab108d92e1d575c6ee8e03abf6a96428e2dd691eef9","tier":null}],"members":[{"type":"individual","id":"4be011186b558e8a","login":"alastairorchard","name":"","avatar_url":"https://avatars-next.observableusercontent.com/323fd2061169ea2bd69b7ab108d92e1d575c6ee8e03abf6a96428e2dd691eef9","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"title":"Covid Charts : Global","cells":[{"id":0,"value":"md`# Covid Charts : Global`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":923,"value":"md`\nI'm building an automated notebook to replace an excel spreadsheet that is laborious to maintain, but it's become too large so I'm splitting it up. This fork looks at the [global](https://observablehq.com/@alastairorchard/covid-charts-global) picture. Other views are available at the following links :`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5910,"value":"md`\n- [The original notebook](https://observablehq.com/@alastairorchard/covid-charts)\n- [Countries & Regions](https://observablehq.com/@alastairorchard/covid-charts-countries-regions)\n- [Italy](https://observablehq.com/@alastairorchard/covid-charts-italy)\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2123,"value":"md `Shout out to my bro @dunstan and his colleagues on the Observable team, as well as to all the talented folks from whom I imported code!`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5901,"value":"toc('h1, h2, h3, h4', 'Table of Contents')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5921,"value":"md`## Global Bubble Chart`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4612,"value":"bubbleChartEnd = {\n const svg = d3\n .create(\"svg\")\n .attr('id', 'bubble-chart')\n .attr(\"viewBox\", [0, 0, width, bubbleHeight])\n .attr(\"font-size\", 12)\n .attr(\"font-weight\", 'bold')\n .attr(\"font-family\", \"sans-serif\")\n .attr(\"text-anchor\", \"middle\");\n\n renderBubbleChart(svg, data);\n\n return svg.node();\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4966,"value":"md`\nThese radio-buttons change the data displayed by all the charts in the workbook :`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4624,"value":"viewof category = radio({\n title: 'Data Type',\n options: categories.map(c => ({\n label: c.title,\n value: c.key\n })),\n value: 'cases'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4628,"value":"viewof dataKey = radio({\n title: 'Data View',\n // description: 'Please select your preferred contact method',\n options: dataSources\n .filter(c => c.category === category)\n .map(c => ({\n label: c.title,\n value: c.key\n })),\n value: `total_${category}`\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4728,"value":"viewof minimumPopulation = radio({\n title: 'Population',\n options: [\n { label: 'All countries', value: 0 },\n { label: 'At least 1 million', value: 1000000 },\n { label: 'At least 10 million', value: 10000000 }\n ],\n value: 1000000\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5918,"value":"md`## Situation Table`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4971,"value":"md`\nYou can use this filter to narrow the data set used by all the charts :`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4307,"value":"viewof table_start = text({\n title: \"Filter Results from\",\n min: 1,\n max: andon.length - 2,\n step:1,\n value: 1\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4324,"value":"viewof table_end = text({\n title: \"...to\",\n // description: \"use these values to filter the data set\",\n value: 5,\n min: 1,\n max: andon.length - 1,\n step:1,\n value: 10\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4355,"value":"viewof table_size = radio({\n options: [\n { label: 'Compact', value: 'compact' },\n { label: 'Extended', value: 'extended' },\n ],\n value: 'compact',\n})\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3989,"value":"viewof dashboard = {\n if ((table_end - table_start) > 1) {\n if (table_size === \"compact\") {\n var tablet = table(compact_andon_ordered.slice(table_start-1,table_end))\n}\n else\n{\n var tablet = table(andon_ordered.slice(table_start-1,table_end))\n}\n return tablet\n }\n else\n {\n return \"invalid range\"\n }\n \n }","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5944,"value":"md`## Manual Override`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5134,"value":"md`\nType in a comma separated list of countries like the example below to override the countries shown in the charts`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5136,"value":"md`\nExample : Italy,France,Spain,Germany,United Kingdom,United States`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5105,"value":"viewof manualList = text({\n title: \"Country List Manual Override\",\n value: \"\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4538,"value":"chart = {\n const svg = d3.select(DOM.svg(width, height));\n\n svg.append(\"g\")\n .call(xAxis);\n\n svg.append(\"g\")\n .call(yAxis);\n \n const group = svg.append(\"g\")\n .selectAll(\"g\")\n .data(joy_data_to_chart)\n .join(\"g\")\n .attr(\"transform\", d => `translate(0,${y(d.location) + 1})`);\n\n group.append(\"path\")\n .attr(\"fill\", \"#ddd\")\n .attr(\"opacity\", \"75%\")\n .attr(\"d\", d => area(d.values));\n\n group.append(\"path\")\n .attr(\"fill\", \"none\")\n .attr(\"stroke\", \"black\")\n .attr(\"d\", d => line(d.values));\n\n return svg.node();\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5975,"value":"viewof country_scale_type = radio({\n title: 'Scale',\n options: [\n { label: 'Shared', value: 'shared' },\n { label: 'Independent', value: 'independent' },\n ],\n value: 'independent',\n})\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5972,"value":"viewof country_chart_matrix = vl.markLine()\n .data(data_to_chart)\n.title(null)\n .encode(\n vl.x().fieldT(\"date\")\n .title(null),\n vl.y().fieldQ(vl.repeat(\"repeat\")),\n // .title(null),\n vl.color().fieldN(\"location\") \n .legend(null),\n \n vl.row().fieldN(\"location\")\n .title(null)\n\n )\n .width((width / 8)-10)\n .height(100)\n .resolve({\n axis: { x: 'independent' },\n scale: { y: country_scale_type }})\n .repeat([\"new_cases\", \"total_cases\", \"new_deaths\", \"total_deaths\"])\n .columns(4)\n .render()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5941,"value":"md`## Situation Chart`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4250,"value":"viewof country_dist_type = radio({\n options: [\n { label: 'Linear', value: 'linear' },\n { label: 'Log', value: 'log' },\n ],\n value: 'linear',\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5337,"value":"viewof curveType = radio({\n options: [\n { label: 'Area', value: 'Area' },\n { label: 'Line', value: 'Line' },\n ],\n value: 'Line',\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4921,"value":"country_chart = {\n const brush = vl.selectInterval().encodings('x');\n const x = vl.x().fieldT('date').title(null);\n \n const base = vl[\"mark\" + curveType]()\n.encode(\n vl.x().fieldT(\"date\")\n .scale({domain: [\"2020-02-01\",Date()]})\n .axis({grid: false, tickSize: 6, labelColor: '#929292' })\n .title(null),\n vl.y().sum(dataKey).scale({type: country_dist_type})\n .title(null),\n vl.color().fieldN(\"location\"),\n vl.tooltip(['location'])\n )\n .height(width*0.6)\n .width(width*0.8);\n \n return vl.data(data_to_chart.filter(d => +d[dataKey] > 0 )) \n .title(dataKey + \" by Country \" + \" (\" + country_dist_type + \" scale) - zoom using the lower chart\")\n \n .vconcat(\n base.encode(x.scale({domain: brush})),\n base.select(brush).height(width*0.1).width(width*0.8)\n )\n .render()\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5938,"value":"md`## Mortality`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3352,"value":"cases_to_death_ratio_chart = {\n const brush = vl.selectInterval().encodings('x');\n const x = vl.x().fieldT('date').title(null);\n \n const base = vl[\"mark\" + curveType]()\n.encode(\n vl.x().fieldT(\"date\")\n .scale({domain: [\"2020-02-01\",Date()]})\n .axis({grid: false, tickSize: 6, labelColor: '#929292' })\n .title(null),\n vl.y().fieldQ(\"total_ratio\")\n .title(null),\n vl.color().fieldN(\"location\"),\n vl.tooltip(['location'])\n )\n .height(width*0.6)\n .width(width*0.8);\n \n return vl.data(ratio_deaths_to_cases.filter(d => +d[\"total_ratio\"] > 0))\n .title(\"Total % Mortality (linear scale) - zoom using the lower chart\")\n \n .vconcat(\n base.encode(x.scale({domain: brush})),\n base.select(brush).height(width*0.1).width(width*0.8)\n )\n .render()\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5935,"value":"md`## Testing`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5187,"value":"tests_to_cases_ratio_chart = {\n const brush = vl.selectInterval().encodings('x');\n const x = vl.x().fieldT('date').title(null);\n \n const base = vl[\"mark\" + curveType]()\n.encode(\n vl.x().fieldT(\"date\")\n .scale({domain: [\"2020-02-01\",Date()]})\n .axis({grid: false, tickSize: 6, labelColor: '#929292' })\n .title(null),\n vl.y().fieldQ(\"new_ratio\")\n .title(null),\n vl.color().fieldN(\"location\"),\n vl.tooltip(['location'])\n )\n .height(width*0.6)\n .width(width*0.8);\n \n return vl.data(ratio_tests_to_cases.filter(d => +d[\"new_ratio\"] > 0))\n .title(\"Percentage of Tests Positive (linear scale) - zoom using the lower chart\")\n \n .vconcat(\n base.encode(x.scale({domain: brush})),\n base.select(brush).height(width*0.1).width(width*0.8)\n )\n .render()\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5924,"value":"md`## Case Map`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4689,"value":"viewof map_styling = select({\n title: 'Choose a map styling',\n options: [\n {value: 'cartoLight', label: 'cartoLight'},\n {value: 'stamen', label: 'Stamen (no street names)'},\n {value: 'openStreetMap', label: 'OpenStreetMap (with street names)'},\n ],\n value: 'cartoLight'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4686,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4695,"value":"md`Coordinates are only available for European countries and their overseas territories...`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5928,"value":"md`## Global Zone Comparison`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5616,"value":"viewof N = {\n const form = html``;\n form.i.oninput = () => form.value = form.i.valueAsNumber;\n form.i.oninput();\n return form;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5519,"value":"temperate_zone_chart = {\n const brush = vl.selectInterval().encodings('x');\n const x = vl.x().fieldT('date').title(null);\n \n const base = vl.markArea()\n.encode(\n vl.x().fieldT(\"date\")\n .scale({domain: [\"2020-02-01\",Date()]})\n .axis({grid: false, tickSize: 6, labelColor: '#929292' })\n .title(null),\n vl.y().mean('new_deaths')\n .title(null),\n vl.color().fieldN(\"location\"),\n vl.tooltip(['location'])\n )\n .height(width*0.6)\n .width(width*0.8);\n \n return vl.data(temperateZoneData.filter(d => +d.new_deaths > 0)) \n .title(\"Deaths per Temperate Zone - zoom using the lower chart\")\n \n .vconcat(\n base.encode(x.scale({domain: brush})),\n base.select(brush).height(width*0.1).width(width*0.8)\n )\n .render()\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5529,"value":"tropical_zone_chart2 = {\n const brush = vl.selectInterval().encodings('x');\n const x = vl.x().fieldT('date').title(null);\n \n const base = vl.markArea()\n.encode(\n vl.x().fieldT(\"date\")\n .scale({domain: [\"2020-02-01\",Date()]})\n .axis({grid: false, tickSize: 6, labelColor: '#929292' })\n .title(null),\n vl.y().mean('new_deaths')\n .title(null),\n vl.color().fieldN(\"location\"),\n vl.tooltip(['location'])\n )\n .height(width*0.6)\n .width(width*0.8);\n \n return vl.data(tropicalZoneData.filter(d => +d.new_deaths > 0 && +d.new_deaths < 1000)) \n .title(\"Deaths per Tropical Zone - zoom using the lower chart\")\n \n .vconcat(\n base.encode(x.scale({domain: brush})),\n base.select(brush).height(width*0.1).width(width*0.8)\n )\n .render()\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5932,"value":"md`## Streamgraph`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5322,"value":"md`\nI've recently added this fantastic streamgraph from @attharmirza because it so beautifully shows how the pandemic is playing out across the globe. It all ends when the chart shrinks back to a point. I'll link it up to the other controls on the page when I have a chance, but for now it's just ripped straight from his notebook`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5327,"value":"{\n let colors = \"\";\n\n for (let i = 0; i < regions.length; i++) {\n i < regions.length - 1\n ? (colors =\n colors +\n `✦ ${\n regions[i]\n }, `)\n : (colors =\n colors +\n ` and ✦ ${\n regions[i]\n }`);\n }\n\n return md`The chart is arranged into **regions** from West to East, with the U.S. pulled out to make trends easier to see. Here's the color scheme: ${colors}.`;\n \n }\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5332,"value":"streamgraph","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1646,"value":"md`# Appendix`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5954,"value":"md`## Data Handling`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1650,"value":"md`Here is where I try to clean up the various csv files that I suck into the notebook from repositories around the net. First the source files :`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1726,"value":"state_data_us = d3.csv(\"https://api.covidtracking.com/v1/states/daily.csv\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2137,"value":"regional_data_eu = d3.csv(\"https://raw.githubusercontent.com/ec-jrc/COVID-19/master/data-by-region/jrc-covid-19-all-days-by-regions.csv\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3536,"value":"world_data = d3.csv('https://covid.ourworldindata.org/data/owid-covid-data.csv')\n/*, ({date, iso_code, location, continent, new_cases, total_cases, new_deaths, total_deaths, new_cases_per_million, total_cases_per_million, new_deaths_per_million, total_deaths_per_million}) => ({\n iso_code: iso_code,\n continent: continent,\n country: location,\n date: date,\n new_cases: new_cases,\n total_cases: total_cases,\n new_deaths: new_deaths,\n total_deaths: total_deaths,\n new_cases_per_million: new_cases_per_million, \n total_cases_per_million: total_cases_per_million, \n new_deaths_per_million: new_deaths_per_million, \n total_deaths_per_million: total_deaths_per_million\n }))\n */","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1663,"value":"md`Then the filtered ones :`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2374,"value":"filtered_regional_data_eu = Array.from(d3.group(regional_data_eu, d => d.Region))\n .map(([, rows]) => process_data(rows)).flat()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2057,"value":"md`...and finalized :`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1731,"value":"final_regional_data_us = {\n var matrix = new Array;\n for (var i = 0; i<(state_data_us.length);i++)\n {\n matrix[i] = {country: 'United States',\n date: state_data_us[i].date.slice(0,4)+\"-\"+state_data_us[i].date.slice(4,6)+\"-\"+state_data_us[i].date.slice(6,8),\n region: state_data_us[i]['state'],\n lat:\"\",\n long:\"\",\n new_cases: state_data_us[i]['positiveIncrease'],\n total_cases: state_data_us[i]['positive'],\n new_deaths: state_data_us[i]['deathIncrease'],\n total_deaths: state_data_us[i]['death']\n }\n }\n return matrix\n }","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2376,"value":"final_regional_data_eu = filtered_regional_data_eu.filter(d => d.region !==\"NOT SPECIFIED\" && d.date > \"1973-01-01\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3353,"value":"ratio_deaths_to_cases = {\n var matrix = new Array;\n for (var i = 0; i<(data_to_chart.length);i++)\n {\n matrix[i] = {location: data_to_chart[i].location,\n date: data_to_chart[i].date,\n new_ratio: ((data_to_chart[i].new_deaths)/(data_to_chart[i].new_cases))*100,\n total_ratio: ((data_to_chart[i].total_deaths)/(data_to_chart[i].total_cases))*100\n }\n }\n return matrix\n }","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5190,"value":"ratio_tests_to_cases = {\n\n \n \n var matrix = new Array;\n for (var i = 0; i<(data_to_chart.length);i++)\n {\n if (data_to_chart[i].new_tests == 0) {\n var NR = NaN}\n else\n {\n var NR = ((data_to_chart[i].new_cases)/(data_to_chart[i].new_tests))*100\n }\n if (data_to_chart[i].total_tests == 0) {\n var TR = NaN}\n else\n {\n var TR = ((data_to_chart[i].total_cases)/(data_to_chart[i].total_tests))*100\n }\n matrix[i] = {location: data_to_chart[i].location,\n date: data_to_chart[i].date,\n region: data_to_chart[i].region,\n lat:data_to_chart[i].lat,\n long:data_to_chart[i].long,\n new_ratio: NR,\n total_ratio: TR\n }\n }\n return matrix\n }","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1322,"value":"covid_heatmap = {\n var matrix = new Array;\n for (var i = 0; i<(final_regional_data_global.length);i++)\n {\n matrix[i] = [final_regional_data_global[i].lat, final_regional_data_global[i].long, final_regional_data_global[i].new_cases*0.1]}\n \n return matrix\n }","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2908,"value":"md`Finally, all the charts in the notebook point to these combined arrays :`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2318,"value":"final_regional_data_global = d3.merge([final_regional_data_eu,final_regional_data_us])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3559,"value":"final_world_data = world_data.filter(d => d.date > \"2020-02-01\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4035,"value":"grouped_world_data = Array.from(d3.group(final_world_data, d => d.location))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5350,"value":"md`## Zone Comparisons`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":6110,"value":"import {tropicalZoneData, temperateZoneData} from '@alastairorchard/covid-charts'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4783,"value":"md`## Dashboard`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5962,"value":"import {andon, andon_ordered, compact_andon, compact_andon_ordered} from '@alastairorchard/covid-charts'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4116,"value":"country_list = {\n if(manualList.length === 0) {\nreturn andon_country_list}\n {\n return d3.csvParse(manualList).columns}\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5119,"value":"andon_country_list = andon_ordered.slice(table_start-1,table_end).map(d => d.Country)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4168,"value":"data_to_chart = {\n var matrix = new Array;\n var k = 0;\n for (var i = 0; i d.CountryName == \"Italy\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4648,"value":"md`## Bubble Chart`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4657,"value":"import {renderBubbleChart, order, date, endDate, getIsoDate, countries, continents, selectedContinents, categories, dataSources} from '@unkleho/covid-19-bubble-chart-with-d3-render'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4643,"value":"data = getDataBy({\n dataKey,\n date,\n selectedContinents,\n minimumPopulation,\n order,\n country_list\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4721,"value":"mostRecentCovidData = final_world_data.filter(d => d.date === getIsoDate(endDate))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4652,"value":"bubbleHeight = {\n if (width > 450) {\n // console.log(screen);\n return 450;\n }\n\n return width}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4723,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4567,"value":"md`## Joy Plot`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4555,"value":"height = ((joy_data_to_chart.length * 25) + 100)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4549,"value":"yAxis = g => g\n .attr(\"transform\", `translate(${margin.left},0)`)\n .call(d3.axisLeft(y).tickSize(0).tickPadding(4))\n .call(g => g.select(\".domain\").remove())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4584,"value":"xAxis = g => g\n .attr(\"transform\", `translate(0,${height - margin.bottom})`)\n .call(d3.axisBottom(x)\n .ticks(width / 80)\n .tickSizeOuter(0))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4529,"value":"y = d3.scalePoint()\n .domain(joy_data_to_chart.map(d => d.location))\n .range([margin.top, height - margin.bottom])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4589,"value":"x = d3.scaleTime()\n .domain(d3.extent(joy_data.dates))\n .range([margin.left, width - margin.right])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4509,"value":"joy_data = {\n const data = final_world_data.filter(d => d.location !== \"World\");\n const dates = Array.from(d3.group(data, d => d.date).keys()).sort(d3.ascending);\n return {\n dates: dates,//.map(d => new Date(d)),\n series: d3.groups(data, d => d.location).map(([location, values]) => {\n const value = new Map(values.map(d => [d.date, d.new_cases]));\n return {location, values: dates.map(d => value.get(d))};\n })\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4574,"value":"joy_data_to_chart = {\n var matrix = new Array;\n var k = 0;\n for (var i = 0; i {\n const output = data.map((d, i) => ({\n country: d.CountryName,\n date: d.Date,\n region: d.Region,\n lat: d.lat,\n long: d.lon,\n new_cases: Math.max(d.CumulativePositive - (data[i - 1] ? data[i - 1].CumulativePositive : 0), 0),\n total_cases: d.CumulativePositive,\n new_deaths: Math.max(d.CumulativeDeceased - (data[i - 1] ? data[i - 1].CumulativeDeceased : 0), 0),\n total_deaths: d.CumulativeDeceased,\n }));\n\n// Object.assign(output, data[0], {\n \n ['Date', 'CumulativePositive', 'CumulativeDeceased'].forEach(key => delete output[key]);\n\n return output;\n};","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2750,"value":"firstBy = thenBy.firstBy","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2747,"value":"thenBy = require('https://bundle.run/thenby@1.3.4')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"d3 = require(\"d3@5\", \"d3-array@2\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"//import { vl } from \"@vega/vega-lite-api\"\nvl = {\n const [vega, vegalite, api, tooltip] = await Promise.all([\n 'vega@5.15',\n 'vega-lite@4.13.1',\n 'vega-lite-api@0.12.0',\n 'vega-tooltip@0.23.2'\n ].map(module => require(module)));\n\n const options = {\n config: {\n // vega-lite default configuration\n config: {\n view: {continuousWidth: 400, continuousHeight: 300},\n mark: {tooltip: null}\n }\n },\n init: view => {\n // initialize tooltip handler\n view.tooltip(new tooltip.Handler().call);\n // enable horizontal scrolling for large plots\n if (view.container()) view.container().style['overflow-x'] = 'auto';\n },\n view: {\n // view constructor options\n loader: vega.loader({baseURL: 'https://cdn.jsdelivr.net/npm/vega-datasets@1/'}),\n renderer: 'canvas'\n }\n };\n \n return api.register(vega, vegalite, options);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"md`## Imports`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4507,"value":"import {line, margin, area} from '@d3/ridgeline-plot'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4369,"value":"import {table, defaultHumanize} from '@awendland/fancy-table'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":50,"value":"import {filter, filteri, take, taker} from \"@mbostock/manipulating-flat-arrays\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":575,"value":"import {thumbnail} from \"@observablehq/vega-lite-chart-types\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":701,"value":"import { radio, select, autoSelect, worldMapCoordinates, slider, text } from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2629,"value":"import {printTable} from '@uwdata/data-utilities'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4283,"value":"import {rangeSlider} from '@mootari/range-slider'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5286,"value":"import {streamgraph,gray,regions,color,codesHighlight,crosswalk} from '@attharmirza/the-coronavirus-pandemic-ends-when-this-chart-shrinks-agai'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1316,"value":"L = {\n const L = await require('leaflet');\n if (!L._css) {\n document.head.appendChild(L._css = html`\n \n \n `);\n }\n await require('leaflet.markercluster@1.4.1').catch(() => L.markerClusterGroup);\n await require('leaflet.heat').catch(() => L.heatLayer);\n return L;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1434,"value":"leafletCSS = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1395,"value":"map_styles = ({\n 'stamen': {\n url: 'https://stamen-tiles-{s}.a.ssl.fastly.net/watercolor/{z}/{x}/{y}.png', \n attribution: 'Map tiles by Stamen Design, CC BY 3.0 — Map data © OpenStreetMap'\n },\n 'openStreetMap': {\n url: 'https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png',\n attribution: '© OpenStreetMap'\n },\n 'cartoLight': {\n url: 'https://cartodb-basemaps-{s}.global.ssl.fastly.net/light_all/{z}/{x}/{y}{r}.png',\n attribution: '© OpenStreetMap | © CartoDB'\n },\n \n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5897,"value":"import {toc} from \"@tomshanley/indented-toc\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W35","stdlib":"1","titling":"auto"}} 32:"$31:body"