2f:null 30:["$","title",null,{"children":"COVID-19 Germany, weekly vs total, show retroactive effect of incoming data | Harald | Observable"}] 35:T5be,counties = (trace) => { return [ trace('Deutschland', 'gray'), trace('Nordrhein-Westfalen', 'blue'), //trace('Baden-Württemberg', 'green'), //trace('Bayern', 'cyan'), //trace('Berlin', 'darkred'), //trace('Brandenburg', 'orange'), //trace('Bremen', 'darkcyan'), //trace('Hamburg', 'darkblue'), //trace('Hessen', 'black'), //trace('Mecklenburg-Vorpommern', 'brown'), //trace('Niedersachsen', 'red'), //trace('Rheinland-Pfalz', 'gray'), //trace('Saarland', 'lightred'), //trace('Sachsen', 'darkmagenta'), //trace('Sachsen-Anhalt', 'darkbrown'), //trace('Schleswig-Holstein', 'darkmagenta'), //trace('Thüringen', 'darkgreen'), trace('StädteRegion Aachen', 'magenta'), //trace('LK Heinsberg', 'green'), //trace('SK Köln', 'brown'), //trace('SK Düsseldorf', 'red'), //trace('SK Heidelberg', 'green'), //trace('LK Marburg-Biedenkopf', 'cyan'), //trace('SK München', 'cyan'), //trace('LK Göttingen', 'black'), //trace('LK Gütersloh', 'brown'), //trace('LK Warendorf', 'orange'), ]; }36:T96e,progressionPlot_days = { let container = DOM.element('div'); [ "cases", "deaths", ].map( function(value) { let div = DOM.element('div'); let info = ' Meldungen von ' + start + " bis " + until; let title = ValueLabel[value]+' bezogen auf ' + Datum; let period = averageDays; let startMoment = moment(start); var max_x = 0; var max_y = 0; let trace = (where, color) => { var xx; var pop; try { xx = progression[where]; pop = population[+xx.id]; } catch { xx = progression[""]; pop = 1; } let curve = { name: where, type: 'scatter', mode: 'lines+markers', line: { width: 1 }, marker: { color: color, size: 3, line: { width: 0 } }, //x: xx[value]/pop*100000, //x: xx[value].map((x) => x/pop*100000).slice(offset, xx.length), x: xx.times.slice(period, xx.length).map(x => moment(x).diff(startMoment, "days")), y: xx[value].map((x, i) => Math.max(0, x - xx[value][i-period])/pop*100000).slice(period, xx.length), text: xx.times.slice(period, xx.length) }; debugger; max_x = curve.x.reduce((r, x) => Math.max(r, x), max_x); max_y = curve.y.reduce((r, y) => Math.max(r, y), max_y); return curve; }; //debugger; Plotly.newPlot( div, counties(trace), { xaxis: { title: 'Tage seit ' + start, //title: title + ' / 100k' + ' ' + info, //type: 'log', range: [0, 4] //type: 'linear', autorange: false, range: [0, max_x] }, yaxis: { title: 'neue ' + title + ' in ' + period + ' Tagen' + ' / 100k', //type: 'log', range: [0, 4], type: 'linear', autorange: false, range: [0, max_y], }, //width: 850, //height: 600, hovermode: 'closest', title: '' + title + '' + ' ' + info, /* shapes: [ { type: 'line', xref: 'paper', x0: 0, y0: 50.0, x1: 1, y1: 50.0, line:{ color: 'rgb(255, 0, 0)', width: 1, dash:'dot' } } ], */ } ); container.append(div); }) return container }37:T8a7,progressionPlot_growth = { let container = DOM.element('div'); [ "cases", //"deaths", ].map( function(value) { let div = DOM.element('div'); let info = ' Meldungen von ' + start + " bis " + until; let title = ValueLabel[value]+' bezogen auf ' + Datum; let period = averageDays; var max_x = 0; var max_y = 0; let trace = (where, color) => { var xx; var pop; try { xx = progression[where]; pop = population[+xx.id]; } catch { xx = progression[""]; pop = 1; } let curve = { name: where, type: 'scatter', mode: 'lines+markers', line: { width: 1 }, marker: { color: color, size: 3, line: { width: 0 } }, //x: xx[value]/pop*100000, x: xx[value].map((x) => x/pop*100000).slice(period, xx.length), y: xx[value].map((x, i) => Math.max(0, x - xx[value][i-period])/pop*100000).slice(period, xx.length), text: xx.times.slice(period, xx.length) }; max_x = curve.x.reduce((r, x) => Math.max(r, x), max_x); max_y = curve.y.reduce((r, y) => Math.max(r, y), max_y); //debugger; return curve; }; Plotly.newPlot( div, counties(trace), { xaxis: { title: title + ' / 100k', //type: 'log', range: [0, 4] type: 'linear', autorange: false, range: [0, max_x] }, yaxis: { title: 'neue ' + title + ' in ' + period + ' Tagen' + ' / 100k', //type: 'log', range: [0, 4] type: 'linear', autorange: false, range: [0, max_y] }, //width: 850, //height: 600, hovermode: 'closest', title: '' + title + '' + ' ' + info, /* shapes: [ { type: 'line', xref: 'paper', x0: 0, y0: 50.0, x1: 1, y1: 50.0, line:{ color: 'rgb(255, 0, 0)', width: 1, dash:'dot' } } ], */ } ); container.append(div); }) return container }38:Tbe8,md`#### Erkrankungsbeginn statt Meldedatum, Überlastung der Meldekette Die Kurve verwendet normalerweise (oben einstellbar) das Erkrankungs-Datum (Spalte "Refdatum") statt des Melde-Datums! Es scheint mir sinnvoller zu sein, als das Melde-Datum, da die Meldung von der Überlastung der Gesundheitsämter und Testkapazitäten begrenzt wird. Bei höherer Überlastung ist die Anzahl der Meldungen im Prinzip konstant und stattdessen wird die Meldeverzögerung immer größer. Das bedeutet, dass die aktuell gemeldeten Zahlen sich zunehmend immer mehr auf die Vergangenheit verteilen. Vergleicht man die Kurven bezogen auf das Meldedatum mit denen bezogen auf den Erkrankungsbeginn, dann wird der große Unterschied deutlich. #### welche Werte wofür? Für eine Betrachtung des Infektionsgeschehens (wieviel wird übertragen? Auswirkungen von Maßnahmen) ist der Infektionszeitpunkt maßgeben, bzw. eigentlich der Zeitraum der Infektiosität, da man das nicht genau weiß, ist als nächstbestes der Erkrankungsbeginn ein gutes Datum, da die Infektiosität hierzu eine gute Korrelation hat. Bei der Beurteilung der Überforderung der Gesundheitsämter ist dagegen die Meldung entscheidend, denn die Ämter müssen sich mit jedem neuen Fall befassen und der Erkrankungszeitpunkt spielt eine geringe Rolle. Bei den Toten ist das Meldedatum passender, da müsste eigentlich die jeweilige Meldeverzögerung abgezogen werden. #### Stark fallende Kurve am Ende durch Meldeverzug Die stark fallenden Zahlen am Ende der Kurve entstehen vermutlich vor allem durch den Meldeverzug. Selbst wenn der Meldeverzug durch das Erkrankungs-Datum weitgehend herausgerechnet ist, so sind für das Ende der Kurve die zugehörigen Zahlen noch nicht ermittelt und gemeldet, so dass die Kurve vermeintlich stark sinkt. Die Zahlen nach dem letzten Knick sind also bedeutungslos. Die Zahlen vor dem Knick ändern sich zwar auch noch werden aber mit zunehmendem Abstand immer stabiler. Leider konterkariert das teilweise den Zweck der Auswertung, da eigentlich die Steigung vor allem am Ende zeigen soll, wie der Wachstumsfaktor sich gerade entwickelt. Sowohl das Ende, aber auch die Steigung vor dem lezten Knick sind noch in Bewegung. Wenn man die Änderungen der Kurve über mehrere Tage verfolgt (Animation), sieht man wie die Kurve sich zunehmend stabilisiert. Das gibt einen guten Eindruck davon, auf welche Steigung die Kurve sich zu bewegt. Ich denke, dass das sogenannte "NowCast" des RKI in etwa dasselbe macht und diese Kurve dann extrapoliert auf das aktuelle Datum. Fraglich ist, warum in manchen Situationen die Meldezahlen trotz Überlastung nicht konstant sind, sondern steigen (z.B. heute 2020-12-26). Eine Annahme wäre, dass bei vielen Clustern auch das überlastete Test- und Meldesystem noch starke Steigungen verarbeiten kann. Im wesentlichen ist vermutlich nur die Nachverfolgung der vielen Einzelfälle begrenzt, die Erfassung der Cluster funktioniert aber noch, was darauf hindeutet, dass die Test-Kapazitäten noch nicht an der Grenze sind. `39:T80d,f_progression = (use_date, until = "2999-01-01 23:59:59") => { var regions = {}; var region_de = { name: "Deutschland", id: AGS_de, times: {}, cases: {}, deaths: {} }; data.forEach( function(row) { var datum = row[use_date]; if(datum >= start && row["Meldedatum"] <= until) { ["Landkreis", "Bundesland"] .forEach( function(index) { var name = row[index]; var region = regions[name]; if( ! region ) { regions[name] = region = { name: "", id: "", times: {}, cases: {}, deaths: {} }; } region.name = name; //let cases = +row.AnzahlFall-row.AnzahlTodesfall-row.AnzahlGenesen; let cases = row.NeuerFall >= 0 ? +row.AnzahlFall : 0; //let deaths = +row.AnzahlTodesfall; let deaths = row.NeuerTodesfall >= 0 ? +row.AnzahlTodesfall : 0; if(index == "Landkreis") { region.id = row.IdLandkreis; } else { region.id = row.IdBundesland; region_de.times[datum] = datum; region_de.cases[datum] = (region_de.cases[datum] || 0) + cases; region_de.deaths[datum] = (region_de.deaths[datum] || 0) + deaths; } region.times[datum] = datum; region.cases[datum] = (region.cases[datum] || 0) + cases; region.deaths[datum] = (region.deaths[datum] || 0) + deaths; }) } }); regions[region_de.name] = region_de; var sorted = {}; sorted[""] = { name: "---", id: "0", times: [], cases: [], deaths: [] }; Object.keys(regions).sort().forEach( function(name) { var region = regions[name]; var times = Object.keys(region.times).sort(); var cases = [0]; var deaths = [0]; times.forEach( function(datum) { cases.push(cases[cases.length-1] + region.cases[datum]) deaths.push(deaths[deaths.length-1] + region.deaths[datum]) }); cases.shift(); deaths.shift(); sorted[name] = { name: region.name, id: region.id, times: times, cases: cases, deaths: deaths } }) return sorted }3a:T5f8,data_json_loaded = { // https://services7.arcgis.com/mOBPykOjAyBO2ZKk/arcgis/rest/services/RKI_COVID19/FeatureServer/0/query?where=Meldedatum%20%3E%3D%20TIMESTAMP%20%272020-12-01%2000%3A00%3A00%27%20AND%20Meldedatum%20%3C%3D%20TIMESTAMP%20%272099-01-01%2000%3A00%3A00%27&outFields=*&outSR=4326&f=json var outFields = "*" // ["IdBundesland", "Bundesland", "IdLandkreis", "Landkreis", "Meldedatum", "Refdatum", "AnzahlFall", "AnzahlTodesfall"].join(",") ; var now = moment() var result = []; var offset = 0; var nrecords = 1000; while(true) { var chunk = await d3.json("https://services7.arcgis.com/mOBPykOjAyBO2ZKk/arcgis/rest/services/RKI_COVID19/FeatureServer/0/query?where="+whereClause+"&outSR=4326&outFields="+outFields+"&f=json&resultOffset="+offset); //var chunk = await d3.json("https://services7.arcgis.com/mOBPykOjAyBO2ZKk/arcgis/rest/services/RKI_COVID19/FeatureServer/0/query?where="+whereClause+"&outSR=4326&outFields="+outFields+"&f=json&resultOffset="+offset+"&resultCount="+nrecords); //return chunk; var complete = ! chunk.exceededTransferLimit; chunk = chunk.features.map(row => { row = row.attributes; row.Meldedatum = dateToString(row.Meldedatum); row.Refdatum = dateToString(row.Refdatum); return row }) Array.prototype.push.apply(result, chunk); yield result; offset = result.length; if(complete) break; //if(result.length > dataLength) break; } //result = result.map(row => { return row }) return result }3b:[] 33:{"id":"bcba0fca259fe833","slug":"covid-19-germany-weekly-vs-total-show-retroactive-effect-of","title":"COVID-19 Germany, weekly vs total, show retroactive effect of incoming data","thumbnail":"b3c4fba586e791be7395419985526eadfc524fa69aae4e398efb15cbaed23395","access_level":"public","create_time":"$D2020-10-27T15:35:37.804Z","update_time":"$D2022-01-18T19:26:16.707Z","view_time":null,"first_public_time":"$D2020-10-27T15:36:55.964Z","has_unpublished_edits":null,"fork":true,"stars":2,"starred":false,"owner":{"type":"team","id":"c155a46382863b73","login":"hg42","name":"Harald","avatar_url":"https://avatars-next.observableusercontent.com/4fc595eea08a023454e6048812f4f8c0a0d98d5b69679c5c78b2b6ca3b4c7076","tier":"starter_2024"},"version":2459,"publish_version":2459,"role":null,"authored":false,"authors":[{"type":"individual","id":"c544b14706a06a31","login":"hg42","name":"Harald","avatar_url":"https://avatars-next.observableusercontent.com/4fc595eea08a023454e6048812f4f8c0a0d98d5b69679c5c78b2b6ca3b4c7076","tier":null}],"members":[{"type":"individual","id":"c544b14706a06a31","login":"hg42","name":"Harald","avatar_url":"https://avatars-next.observableusercontent.com/4fc595eea08a023454e6048812f4f8c0a0d98d5b69679c5c78b2b6ca3b4c7076","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"COVID-19 Germany, weekly vs total, show retroactive effect of incoming data","cells":[{"id":79,"value":"md`# COVID-19 Germany, weekly vs total, show retroactive effect of incoming data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":91,"value":"$35","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":406,"value":"viewof first = select({\n title: \"Beginn der Kurve\",\n options: [\n \"2020-01-01\",\n \"2020-07-20\",\n \"2020-07-27\",\n \"2020-08-03\",\n \"2020-09-01\",\n \"2020-10-01\",\n \"2020-11-01\",\n \"2020-12-01\",\n \"2020-12-15\",\n first_history_std\n ],\n value: first_history_std\n})\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1715,"value":" start = dateToString(stringToDate(first).subtract(averageDays, \"days\"))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1608,"value":"//loaded = Math.round((data_json_loaded.length / data_json_length)*100)\nviewof loaded = \nslider({\n min: 0, \n max: data_json_length, \n step: 1, \n value: data_json_loaded.length,\n title: \"Meldungen im Zeitraum: \" + data_json_length + \", davon geladen: \" + Math.round((data_json_loaded.length / data_json_length)*100) + \"%\", \n //description: \"\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1740,"value":"ready ? md`### Daten geladen` : md`### bitte warten...`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":93,"value":"//DatenStand = data[0].Datenstand //? moment(data[0].Datenstand, \"DD.MM.yyyy\").format(time_format) : \"loading...\"\nDatenStand = data.map(x => x.Meldedatum).reduce((max, val) => val > max ? val : max)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":572,"value":"viewof use_date = radio({\n title: 'Datum der',\n options: [\n { label: DatumLabel['Refdatum'], value: 'Refdatum' },\n { label: DatumLabel['Meldedatum'], value: 'Meldedatum' },\n ],\n value: 'Refdatum'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":810,"value":"viewof days_back = \nslider({\n min: -days_back_max, \n max: 0, \n step: 1, \n value: animate && ready ? days_back_animate : 0,\n title: \"Anzahl Melde-Tage am Ende nicht berücksichtigen\", \n description: \"Rückwirkung der Meldungen auf die Vergangenheit sichtbar machen, da gemeldete Daten sich auf einen Erkrankungsbeginn in der Vergangenheit beziehen\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":754,"value":"until = moment(DatenStand, time_format).add((animate == \"animate\" ? days_back_animate : days_back)+1, \"day\").add(24*60*60-1, \"seconds\").format(time_format)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":849,"value":"viewof animate = button({value: \"Animieren\", description: \"\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":262,"value":"html`(see point data by mouse-over, zoom by dragging a frame, reset view by double click, use toolbar visible while hovering a chart)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1080,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":97,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2320,"value":"Anzahl_Faelle_Kurve = data.reduce((count, x) => count + (x.NeuerFall >= 0 ? x.AnzahlFall : 0), 0)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2256,"value":"nicht_zurueckdatiert = data.reduce((count, x) => count + (x.IstErkrankungsbeginn ? 0 : x.NeuerFall >= 0 ? x.AnzahlFall : 0), 0)\n//nicht_zurückdatiert = data.filter(x => ! x.IstErkrankungsbeginn)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2323,"value":"nicht_zurueckdatiert_prozent = Math.round(nicht_zurueckdatiert/Anzahl_Faelle_Kurve*100)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":522,"value":"$38","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1619,"value":"ready = data_json_loaded.length >= data_json_length","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1704,"value":"averageDays = 7","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1540,"value":"days_back_max = 2*7","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2242,"value":"days_history_std = 3*7","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2247,"value":"first_history_std = dateToString(moment().subtract(days_history_std, \"days\"))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2353,"value":"today = dateToString(moment())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2375,"value":"end = \"2099-01-01\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1628,"value":"tick = 1000","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":839,"value":"days_back_animate = {\n animate;\n if(ready)\n for(let d = -days_back_max; d <= 0; d++) {\n yield Promises.tick(tick, d)\n }\n else\n yield Promises.tick(tick, 0)\n\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":990,"value":"md`Einwohner Deutschland = ${population[AGS_de]}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1006,"value":"md`Einwohner NRW = ${population[5]}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1004,"value":"md`Einwohner Aachen = ${population[5334]}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1012,"value":"example_DE = progression['Deutschland']","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":443,"value":"example_NRW = progression['Nordrhein-Westfalen']","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":436,"value":"example_Aachen = progression['StädteRegion Aachen']","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":631,"value":"progression = f_progression(use_date, until)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":66,"value":"$39","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":47,"value":"md`## Data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1550,"value":"Datum = DatumLabel[use_date]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1559,"value":"DatumLabel = ({ Meldedatum: \"Meldung\", Refdatum: \"Erkrankung\" })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2199,"value":"ValueLabel = ({ cases: \"Fälle\", deaths: \"Tote\" })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":730,"value":"time_format = \"yyyy-MM-DD\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1512,"value":"time_format_data = \"yyyy/MM/DD HH:mm:ss\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":986,"value":"AGS_de = 0","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2380,"value":"whereClause = \"Meldedatum%20%3E%3D%20TIMESTAMP%20%27\"+start+\"%2000%3A00%3A00%27%20AND%20Meldedatum%20%3C%3D%20TIMESTAMP%20%27\"+end+\"%2000%3A00%3A00%27\"\n//whereClause = \"1=1\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1924,"value":"letzte_Eintraege_Aachen = data.filter((e) =>\n e.Landkreis == 'StadtRegion Aachen'\n &&\n moment(until).diff(moment(e.Meldedatum), \"days\") < 14\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1993,"value":"letzte_Eintraege_Aachen_table = letzte_Eintraege_Aachen.map((e) => {\n var o = {};\n [\"Refdatum\", \"Meldedatum\", \"AnzahlFall\", \"AnzahlTodesfall\", \"AnzahlGenesen\", \"NeuerFall\", \"NeuerTodesfall\", \"Neugenesen\", \"IstErkrankungsbeginn\", \"Altersgruppe\", \"Geschlecht\"].forEach((f) => o[f] = e[f])\n return o;\n}).slice().sort((a,b) => a.Meldedatum a.Refdatum { /* do something */ })\n .render(); \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2026,"value":"html`\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1463,"value":"/*\ndata = data_csv_arcgis.map(row => {\n row.Meldedatum = convertDateFromData(row.Meldedatum)\n row.Refdatum = convertDateFromData(row.Refdatum)\n return row\n})\n*/\ndata = ready ? data_json_loaded : [data_json_loaded[0]]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1601,"value":"$3a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1597,"value":"data_json_length = (await d3.json(\"https://services7.arcgis.com/mOBPykOjAyBO2ZKk/arcgis/rest/services/RKI_COVID19/FeatureServer/0/query?where=\"+whereClause+\"&outFields=*&returnCountOnly=true&outSR=4326&f=json\")).count","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":462,"value":"population = {\n var values = {};\n values[AGS_de] = 0;\n population_bundeslaender.forEach( function(row) {\n values[+row.LAN_ew_AGS] = +row.LAN_ew_EWZ;\n });\n population_kreise.forEach( function(row) {\n var ewz = +row.EWZ;\n values[+row.AGS] = ewz;\n values[AGS_de] += ewz;\n });\n return values;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":434,"value":"population_bundeslaender = d3.csv('https://opendata.arcgis.com/datasets/5dc2fc92850241c3be3d704aa0945d9c_2.csv')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":432,"value":"population_kreise = d3.csv('https://opendata.arcgis.com/datasets/b2e6d8854d9744ca88144d30bef06a76_1.csv')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"md`# Functions`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1514,"value":"convertDateFromData = (time_str) => moment(time_str, time_format_data).format(time_format)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1455,"value":"stringToDate = (time_str) => moment(time_str, time_format) ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1457,"value":"dateToString = (time_ms) => moment(time_ms).format(time_format)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1486,"value":"md`# Libraries`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":102,"value":"Plotly = require(\"https://cdn.plot.ly/plotly-latest.min.js\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"d3 = require(\"d3@5\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"import {printTable} from '@uwdata/data-utilities'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1972,"value":"import {SVGTable} from '@analyzer2004/svgtable'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2002,"value":"html`SVGTable example`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":617,"value":"import {\n button,\n checkbox,\n radio,\n select,\n slider,\n} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":683,"value":"moment = require(\"moment\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W3b","stdlib":"1","titling":"auto"}} 34:"$33:body"