2c:null 2d:["$","title",null,{"children":"COVID-19 dashboard by country | Daniel Bachler | Observable"}] 32: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" } } } ] } )33: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" } } } ] } )34: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" }, ]35:[] 30:{"id":"ca50a9c557951370","slug":"covid-19-dashboard","title":"COVID-19 dashboard by country","thumbnail":"68bc6c8320449bc0d1c2113e4de5d76fa5a220b85e84071b7f9a46ba0798ce1b","access_level":"public","create_time":"$D2020-04-29T13:31:03.751Z","update_time":"$D2020-06-05T16:58:46.858Z","view_time":null,"first_public_time":"$D2020-04-29T19:48:37.886Z","has_unpublished_edits":null,"fork":false,"stars":3,"starred":false,"owner":{"type":"team","id":"06e54191865d69b8","login":"danyx","name":"Daniel Bachler","avatar_url":"https://avatars-next.observableusercontent.com/872b63ff84951b97aaf3e8a0ee3bacbeaed9371a037583c8df3968bc81211304","tier":"starter_2024"},"version":330,"publish_version":330,"role":null,"authored":false,"authors":[{"type":"individual","id":"439eeaf56f71bbf5","login":"danyx","name":"Daniel Bachler","avatar_url":"https://avatars-next.observableusercontent.com/872b63ff84951b97aaf3e8a0ee3bacbeaed9371a037583c8df3968bc81211304","tier":null}],"members":[{"type":"individual","id":"439eeaf56f71bbf5","login":"danyx","name":"Daniel Bachler","avatar_url":"https://avatars-next.observableusercontent.com/872b63ff84951b97aaf3e8a0ee3bacbeaed9371a037583c8df3968bc81211304","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"COVID-19 dashboard by country","cells":[{"id":261,"value":"md`# COVID-19 dashboard by country`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":0,"value":"html`

COVID-19 in ${selectedCountry}

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":207,"value":"viewof selectedCountry = select({title: \"Region to display\", options: countries, value: country ? country : dataSource.initialSelection})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":94,"value":"md`## Source code`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":13,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":307,"value":"dataSource = dataSources[selectedDataSourceIndex]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":184,"value":"countries =\n metadata.regions","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":36,"value":"data = raw_data.results.map(dataSource.rowProcessingFunction)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":278,"value":"startDateDatetime =\"datetime(\" + graphStartDate.year() + \", \" + (graphStartDate.month()) + \", \" + graphStartDate.date() + \")\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"html`\n \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"value":"vegalite = require(\"@observablehq/vega-lite\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":113,"value":"moment = require(\"moment\");","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":115,"value":"import {slider, select, checkbox} from \"@jashkenas/inputs\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":127,"value":"_ = require(\"lodash\");","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W35","stdlib":"1"}} 31:"$30:body"