30:T4ac,vegalite({ "title": "Daily new confirmed COVID-19 cases", "width": "container", "transform": [ {"filter": "datum." + metadata.columnNames.date + " > " + startDateDatetime }, { "frame": [-3, 3], "window": [ { "field": metadata.columnNames["daily-cases"], "op": "mean", "as": "rolling_mean" } ] } ], "data": { "values": data }, "layer": [ { "mark": { "type": "point", "opacity": 0.9 , "tooltip": true}, "encoding": { "x": { "title": "Date", "field": metadata.columnNames.date, "type": "temporal" }, "y": { "title": "New cases", "field": metadata.columnNames["daily-cases"], "type": "quantitative" } } }, { "mark": { "color": "blue", "opacity": 0.3, "size": 3, "type": "line", "tooltip": true }, "encoding": { "x": { "field": metadata.columnNames.date, "type": "temporal" }, "y": { "field": "rolling_mean", "type": "quantitative" } } } ] } )31:T4dd,vegalite({ "title": "Daily new confirmed COVID-19 deaths", "width": "container", "transform": [ {"filter": "datum." + metadata.columnNames.date + " > " + startDateDatetime }, { "frame": [-3, 3], "window": [ { "field": metadata.columnNames["daily-deaths"], "op": "mean", "as": "rolling_mean" } ] } ], "data": { "values": data }, "layer": [ { "mark": { "type": "point", "color": "#dd9999", "opacity": 0.9 , "tooltip": true}, "encoding": { "x": { "title": "Date", "field": metadata.columnNames.date, "type": "temporal" }, "y": { "title": "New deaths", "field": metadata.columnNames["daily-deaths"], "type": "quantitative" } } }, { "mark": { "color": "red", "opacity": 0.3, "size": 3, "type": "line", "tooltip": true }, "encoding": { "x": { "field": metadata.columnNames.date, "type": "temporal" }, "y": { "field": "rolling_mean", "type": "quantitative" } } } ] } )32:T55e,dataSources = [({ title: "Country data compiled by the ECDPC ", notes: "Worldwide time series data by the European Center for Disease Prevention and Control, compiled by Our World in Data", url: "https://api.edelweissdata.com/datasets/b55b229d-6338-4e41-a507-0cf4d3297b54/versions/latest/data", metadataUrl: "https://api.edelweissdata.com/datasets/b55b229d-6338-4e41-a507-0cf4d3297b54/versions/latest/metadata", rowProcessingFunction: row => row.data, initialSelection: "Germany" }), { title: "German state data", notes: "Data by the Germany Robert Koch Insitute. ", url: "https://api.edelweissdata.com/datasets/8dde2785-8a2a-4847-80b8-982a691954d6/versions/latest/data", metadataUrl: "https://api.edelweissdata.com/datasets/8dde2785-8a2a-4847-80b8-982a691954d6/versions/latest/metadata", rowProcessingFunction: (row => row.data), initialSelection: "Berlin" }, { title: "US state data", notes: "State level data from The New York Times, based on reports from state and local health agencies.", url: "https://api.edelweissdata.com/datasets/72421b77-78e8-4fad-9e3b-33956585e515/versions/latest/data", metadataUrl: "https://api.edelweissdata.com/datasets/72421b77-78e8-4fad-9e3b-33956585e515/versions/latest/metadata", rowProcessingFunction: (row => row.data), initialSelection: "New York" }, ]33:[] 2e:{"title":"COVID-19 dashboard by country","cells":[{"id":261,"value":"md`# COVID-19 dashboard by country`","pinned":false,"hidden":false,"mode":"ojs"},{"id":0,"value":"html`

COVID-19 in ${selectedCountry}

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":304,"value":"viewof selectedDataSourceIndex = \n select({title: \"Data source\", \n options: \n _.map(dataSources, (source, index) => ({label: source.title, value: index}) )})\n \n ","pinned":false,"hidden":false,"mode":"ojs"},{"id":207,"value":"viewof selectedCountry = select({title: \"Region to display\", options: countries, value: country ? country : dataSource.initialSelection})","pinned":false,"hidden":false,"mode":"ojs"},{"id":50,"value":"html`

${data[data.length-1].total_cases}\n

Total confirmed cases\n

\n \n

${populationInMillion ? ((Math.round(populationInMillion * 10) / 10) + \" Million\") : \"no data\"}\n

Population\n

${data[data.length-1].total_deaths}\n

Total confirmed deaths\n

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":105,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":110,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":31,"value":"vegalite({\n \"title\": \"Total confirmed COVID-19 cases\",\n \n \"width\": \"container\",\n \"data\": {\n \"values\": data\n },\n \"transform\": [\n {\"filter\": \"datum.\" + metadata.columnNames.date + \" > \" + startDateDatetime }\n ],\n \"mark\": {\n \"type\": \"line\", \"tooltip\": true\n },\n \"encoding\": {\n \"x\": {\n \"field\": metadata.columnNames.date,\n \"type\": \"temporal\"\n },\n \"y\": {\n \"field\": metadata.columnNames[\"total-cases\"],\n \"type\": \"quantitative\",\n \"scale\": {\n \"type\": \"linear\"\n }\n },\n \"color\": {\n \"value\": \"#8888dd\"\n }\n }\n })","pinned":false,"hidden":false,"mode":"ojs"},{"id":62,"value":"vegalite({\n \"title\": \"Total confirmed COVID-19 deaths\",\n \"width\": \"container\",\n \"data\": {\n \"values\": data\n },\n \"transform\": [\n {\"filter\": \"datum.\" + metadata.columnNames.date + \" > \" + startDateDatetime }\n ],\n \"mark\": {\n \"type\": \"line\", \"tooltip\": true\n },\n \"encoding\": {\n \"x\": {\n \"field\": metadata.columnNames.date,\n \"type\": \"temporal\"\n },\n \"y\": {\n \"field\": metadata.columnNames[\"total-deaths\"],\n \"type\": \"quantitative\",\n \"scale\": {\n \"type\": \"linear\"\n }\n },\n \"color\": {\n \"value\": \"#dd8888\"\n }\n }\n })","pinned":false,"hidden":false,"mode":"ojs"},{"id":174,"value":"md`The daily graphs contain the data points as circles and a 6-day sliding average as a line`","pinned":false,"hidden":false,"mode":"ojs"},{"id":117,"value":"viewof graphStartDateSlider = slider({\n min: 0, \n max: (moment().diff(moment(\"2020-01-01\"), 'days')),\n value: 60,\n step: 1,\n display: value => moment(\"2020-01-01\").add(value, \"days\").format(\"YYYY-MM-DD\"),\n description: \"Date of graph start\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":90,"value":"md`This example dashboard demonstrates using [EdelweissData for COVID-19](https://douglasconnect.github.com/covid-19). The data shown is published by Our World in Data and is based on the daily data releases by the European Center for Disease Prevention and Control. The entire dataset can be seen [here](https://edelweissdata.com/dataexplorer?dataset=b55b229d-6338-4e41-a507-0cf4d3297b54%3A1&q=%7B%7D), more information about the dataset can be found at [Our World In Data](https://ourworldindata.org/coronavirus-source-data).`","pinned":false,"hidden":false,"mode":"ojs"},{"id":86,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":94,"value":"md`## Source code`","pinned":true,"hidden":false,"mode":"ojs"},{"id":2,"value":"country = {\n const params = new URLSearchParams(location.search);\n const country = params.get(\"country\");\n return country ? country : \"Germany\";\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":13,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":307,"value":"dataSource = dataSources[selectedDataSourceIndex]","pinned":true,"hidden":false,"mode":"ojs"},{"id":310,"value":"metadata = fetch(dataSource.metadataUrl)\n .then(response => {\n if (!response.ok) throw new Error(response.status);\n return response.json();})","pinned":false,"hidden":false,"mode":"ojs"},{"id":179,"value":"countryQuery = ({\"condition\": {\n \"and\": [\n {\n \"gt\": [\n {\n \"column\": [\n \"date\"\n ]\n },\n moment().subtract(2, \"days\").format(\"YYYY-MM-DD\")\n ]\n }\n ]\n }})","pinned":false,"hidden":false,"mode":"ojs"},{"id":184,"value":"countries =\n metadata.regions","pinned":false,"hidden":false,"mode":"ojs"},{"id":22,"value":"query = ({\"condition\": {\n \"and\": [\n {\n \"exactSearch\": [\n {\n \"column\": [\n metadata.columnNames.region\n ]\n },\n selectedCountry\n ]\n }\n ]\n }})","pinned":false,"hidden":false,"mode":"ojs"},{"id":25,"value":"fetchOptions = ({\n method: 'POST', // *GET, POST, PUT, DELETE, etc. \n redirect: 'follow', // manual, *follow, error\n body: JSON.stringify(query) // body data type must match \"Content-Type\" header\n })","pinned":false,"hidden":false,"mode":"ojs"},{"id":19,"value":"// fetch the data from the edelweiss REST api (latest will make sure we get the newest dataset, updated daily)\nraw_data = fetch(dataSource.url, fetchOptions)\n .then(response => {\n if (!response.ok) throw new Error(response.status);\n return response.json();})","pinned":false,"hidden":false,"mode":"ojs"},{"id":36,"value":"data = raw_data.results.map(dataSource.rowProcessingFunction)","pinned":false,"hidden":false,"mode":"ojs"},{"id":138,"value":"graphStartDate = \n{ let date = moment(\"2020-01-01\")\n date.add(graphStartDateSlider, \"days\")\n return date\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":278,"value":"startDateDatetime =\"datetime(\" + graphStartDate.year() + \", \" + (graphStartDate.month()) + \", \" + graphStartDate.date() + \")\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":224,"value":"sparql = `SELECT ?population {\n ?country wdt:P31 wd:Q6256 ;\n wdt:P298 \"` + data[0].iso_code + `\";\n wdt:P1082 ?population.\n }`","pinned":false,"hidden":false,"mode":"ojs"},{"id":218,"value":"// Make sure you initialize wbk with a sparqlEndpoint\npopulationResult = \n fetch(`https://query.wikidata.org/sparql?query=${encodeURIComponent(sparql)}`, {headers: {accept: \"application/sparql-results+json\"}}).then(response => response.json() )","pinned":false,"hidden":false,"mode":"ojs"},{"id":237,"value":"populationInMillion = \n {\n var result = undefined\n try {\n result = parseInt(populationResult.results.bindings[0].population.value) / 1000000\n }\n catch (err) {\n console.log(\"Could not retrieve population\")\n }\n \n return result\n }","pinned":false,"hidden":false,"mode":"ojs"},{"id":52,"value":"html`\n \n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":39,"value":"vegalite = require(\"@observablehq/vega-lite\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":113,"value":"moment = require(\"moment\");","pinned":true,"hidden":false,"mode":"ojs"},{"id":115,"value":"import {slider, select, checkbox} from \"@jashkenas/inputs\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":127,"value":"_ = require(\"lodash\");","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W33","stdlib":"1","titling":"auto"}