31:Tbef,casePlot = (departamento, tipo, upsideDown=false) => { const dataSlice = tidy.filter(aq.escape(d => d.departamento == departamento && d.tipo == tipo)) const vacunasSlice = vacunas.filter(aq.escape(d => d.departamento == departamento)) const maxVacuna = aq.agg(vacunasSlice, op.max('percapita')) const maxData = aq.agg(dataSlice, op.max('valor')) const colors = plotColors[tipo] const lineOptions = { x: 'fecha', y: 'valor', curve: 'basis' } return Plot.plot({ width: width, height: desktop ? 30 : 20, marginRight: 0, marginLeft: 20, marginBottom: 0, marginTop: 0, style: { background: plotColors.background, color: plotColors.frame }, y: { axis: null, tickFormat: d => d == 0 ? '' : d3.format('.0f')(d), tickSize: 0, label: null, reverse: upsideDown ? true : false }, x: { tickSize: 0, label: null, axis: null, ticks: 4 }, color: { range: [plotColors.background, plotColors.vacunas], domain: [0, .4], interpolate: d3.interpolateRgb.gamma(2.2) }, marks: [ Plot.ruleX(vacunasSlice, { x: 'fecha', stroke: 'ceiled', strokeWidth: 1.5, }), Plot.barX([{x1:op.datetime(2022,9,7), x2:op.datetime(2023,2,25)}], { x1: 'x1', x2: 'x2', fill: .4, strokeWidth: 1.5, }), Plot.gridX({ strokeDasharray: 1, }), Plot.gridY({ strokeDasharray: 1 }), Plot.ruleX([new Date(2021,2,10),new Date(2022,2,10)],{ strokeWidth: 5, stroke: '#fff' }), Plot.areaY(dataSlice, { ...lineOptions, fill: colors.fill, fillOpacity: 1. }), Plot.line(dataSlice, { ...lineOptions, stroke: colors.stroke, strokeWidth: desktop ? .7 : .3 }), upsideDown ? Plot.text([departamento], { fill: plotColors.title, fontFamily: 'Playfair Display', fontSize: desktop ? 12 : 10, fillOpacity: .7, frameAnchor: 'bottom-right', lineAnchor: 'bottom', textAnchor: 'end', dy: -5, dx: -5, }) : null, Plot.text([maxData], { fill: colors.stroke, fontFamily: 'Playfair Display', fontSize: desktop ? 12 : 10, fillOpacity: .7, frameAnchor: upsideDown ? 'bottom-left' : 'top-left', lineAnchor: upsideDown ? 'bottom' : 'top', textAnchor: 'start', dy: upsideDown ? -5 : 5, dx: -15, text: d => d3.format('.0f')(d) }), Plot.ruleY([0], { x1: op.datetime(2020,2,10), x2: op.datetime(2023,2,3), stroke: plotColors.title, strokeWidth: .2, }), Plot.ruleX(dataSlice, { x: 'fecha', title: d => `${d.valor} ${tipo}\n${d.dateString}`, strokeOpacity: 0, strokeWidth: 1, }) ], tooltip: { 'stroke-opacity': .5, stroke: '#000', 'stroke-width': 1., } }) }32:T424,header = { return htl.html` ` }33:[{"id":"ffad40f332d56af7d6caf90f9105c928c2a75b0445acafcbb5ff5200ddd0f98906ce35a25047c7403d7686f5df07c56fb4ab5c7225d2548b194a75d1c51224fa","href":"https://static.observableusercontent.com/files/ffad40f332d56af7d6caf90f9105c928c2a75b0445acafcbb5ff5200ddd0f98906ce35a25047c7403d7686f5df07c56fb4ab5c7225d2548b194a75d1c51224fa","name":"casos.csv","type":"text/csv","lastModified":1677910461023.649,"size":939709},{"id":"b6a7619622481fb70d53469af4c43724919e484c34939473ceb611efeefd932c5ba0448b1478ad33a0bdc8af62ff335a694225f4349b031262c7bb8fb3fd866a","href":"https://static.observableusercontent.com/files/b6a7619622481fb70d53469af4c43724919e484c34939473ceb611efeefd932c5ba0448b1478ad33a0bdc8af62ff335a694225f4349b031262c7bb8fb3fd866a","name":"primera.csv","type":"text/csv","lastModified":1677938678365.073,"size":206852},{"id":"363af5da1f790986393d2dee934325f4a34d1a20294c4cb97f3e0827617286c1445d3aebc1c7246d3eea44f5fadda50b77d27951974f5a69d8d4504d8a38196c","href":"https://static.observableusercontent.com/files/363af5da1f790986393d2dee934325f4a34d1a20294c4cb97f3e0827617286c1445d3aebc1c7246d3eea44f5fadda50b77d27951974f5a69d8d4504d8a38196c","name":"tidy.csv","type":"text/csv","lastModified":1677952037393.816,"size":1011857}] 2f:{"title":"3 años de Covid-19 en Bolivia","cells":[{"id":1801,"value":"htl.html`\n

3 años de Covid-19 en Bolivia

\n ${header}\n

\n ${boliviaPlot('casos')} \n ${departamentos.map(d => depPlot(d))}\n ${boliviaPlot('decesos')}\n

\n\n ${textBox(`Datos recolectados diariamente por Mauricio Foronda, Gabriel Weise y Diego Acevedo`)}\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1800,"value":"textBox('✨ una versión al día ✨', [14, 7], '#fff')","pinned":false,"hidden":false,"mode":"ojs"},{"id":974,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":1742,"value":"_dependencias_","pinned":false,"hidden":false,"mode":"md"},{"id":6,"value":"import { aq, op } from '@uwdata/arquero'","pinned":false,"hidden":false,"mode":"ojs"},{"id":1071,"value":"import {Plot} from \"@mkfreeman/plot-tooltip\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1531,"value":"import {Legend} from \"@d3/color-legend\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1746,"value":"_datos_","pinned":false,"hidden":false,"mode":"md"},{"id":985,"value":"tidy = aq.fromCSV(await FileAttachment(\"tidy.csv\").text())","pinned":false,"hidden":false,"mode":"ojs"},{"id":1408,"value":"vacunas = {\n const data = await aq.fromCSV(await FileAttachment(\"primera.csv\").text())\n return data.derive({\n ceiled : d => d.percapita > .4 ? .4 : d.percapita\n })\n \n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":568,"value":"departamentos = ['Santa Cruz', 'La Paz', 'Cochabamba', 'Oruro', 'Potosí', 'Chuquisaca', 'Tarija', 'Beni', 'Pando']","pinned":false,"hidden":false,"mode":"ojs"},{"id":1799,"value":"bolivia = {\n const depTotal = tidy.\n groupby(['tipo', 'fecha', \"dateString\"]).\n rollup({valor: op.sum('valor')})\n const cumSum = depTotal.\n groupby('tipo').\n derive({\n cumulativo: aq.rolling(d => op.sum(d.valor))\n })\n return cumSum\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1748,"value":"_el gráfico_","pinned":false,"hidden":false,"mode":"md"},{"id":1798,"value":"plotColors = ({\n background: '#eef0f2',\n frame: '#908d94',\n vacunas: '#c6d6d6',\n title: '#000',\n casos: {fill: '#c58883', stroke: '#944231'},\n decesos: {fill: '#99a7c9', stroke: '#52689e'}\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1153,"value":"depPlot = (departamento) => {\n const casos = casePlot(departamento, 'casos')\n const decesos = casePlot(departamento, 'decesos', true)\n return html`\n

\n ${casos}\n ${decesos}\n

\n `\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1796,"value":"boliviaPlot = (tipo) => {\n const dataSlice = bolivia.filter(aq.escape(d => d.tipo == tipo))\n const max = aq.agg(dataSlice, op.max('cumulativo'))\n return Plot.plot({\n width:width,\n height: desktop ? 30 : 20,\n marginLeft: 20,\n marginRight: 0,\n style: {\n background: plotColors.background,\n color: plotColors.frame\n },\n x: {\n axis: null\n },\n y: {\n axis: null\n },\n color: {\n range: [plotColors.background, plotColors[tipo].fill]\n },\n marks: [\n Plot.barX([{x1:op.datetime(2023,2,3), x2:op.datetime(2023,2,25)}], {\n x1: 'x1',\n x2: 'x2',\n fill: max,\n strokeWidth: 2,\n }),\n Plot.ruleX(dataSlice, {\n x: 'fecha',\n stroke: 'cumulativo',\n strokeWidth: 2,\n title: d => `${d.cumulativo} ${tipo}\\n${d.dateString}`,\n })\n ]\n })\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1795,"value":"desktop = width > 1000","pinned":false,"hidden":false,"mode":"ojs"},{"id":982,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":1793,"value":"textBox = (text, padding=[7, 5], bg=\"#eef0f2\") => {\n return html`\n

${text}

\n `\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1792,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":1190,"value":"html`\n \n\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1790,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":1750,"value":"🖤","pinned":false,"hidden":false,"mode":"md"}],"files":"$W33","stdlib":"1","titling":"auto"}