31:Tbb3,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:frameEnd}], { x1: 'x1', x2: 'x2', fill: .4, strokeWidth: 1.5, }), Plot.gridX({ strokeDasharray: 1, }), Plot.gridY({ strokeDasharray: 1 }), Plot.ruleX(yearMarks,{ 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: lastDay, 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:T44f,header = { return htl.html` ` }33:[{"id":"363af5da1f790986393d2dee934325f4a34d1a20294c4cb97f3e0827617286c1445d3aebc1c7246d3eea44f5fadda50b77d27951974f5a69d8d4504d8a38196c","href":"https://static.observableusercontent.com/files/363af5da1f790986393d2dee934325f4a34d1a20294c4cb97f3e0827617286c1445d3aebc1c7246d3eea44f5fadda50b77d27951974f5a69d8d4504d8a38196c","name":"tidy.csv","type":"text/csv","lastModified":1678420990935.884,"size":1011857},{"id":"b6a7619622481fb70d53469af4c43724919e484c34939473ceb611efeefd932c5ba0448b1478ad33a0bdc8af62ff335a694225f4349b031262c7bb8fb3fd866a","href":"https://static.observableusercontent.com/files/b6a7619622481fb70d53469af4c43724919e484c34939473ceb611efeefd932c5ba0448b1478ad33a0bdc8af62ff335a694225f4349b031262c7bb8fb3fd866a","name":"primera.csv","type":"text/csv","lastModified":1678420990935.884,"size":206852}] 2f:{"title":"Años de Covid-19 en Bolivia","cells":[{"id":1806,"value":"htl.html`\n

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 por Mauricio Foronda, Gabriel Weise y Diego Acevedo`)}\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2245,"value":"textBox('✨ Actualizado diariamente ✨', [10, 7], \"#fff\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":2265,"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 = {\n const spa = d3.json(\"https://cdn.jsdelivr.net/npm/d3-time-format@3/locale/es-MX.json\").then(locale => {\n d3.timeFormatDefaultLocale(locale)})\n const raw = await aq.loadCSV('https://raw.githubusercontent.com/mauforonda/super_magic_covid_middleware/master/docs/complete.csv')\n return raw.\n filter(d => op.includes(['casos', 'decesos'], d.tipo)).\n fold(departamentos, {as: ['departamento', 'valor']}).\n rename(aq.names(['fecha'])).\n derive({dateString: aq.escape(d => d3.utcFormat('%-d de %B, %Y')(d.fecha))})\n}","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":1814,"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":1836,"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":1823,"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:lastDay, x2:frameEnd}], {\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":1852,"value":"desktop = width > 1000","pinned":false,"hidden":false,"mode":"ojs"},{"id":982,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":2214,"value":"lastDay = aq.agg(tidy, op.max('fecha'))","pinned":false,"hidden":false,"mode":"ojs"},{"id":2220,"value":"frameEnd = new Date(lastDay.getTime() + (1e3 * 60 * 60 * 24 * 22))","pinned":false,"hidden":false,"mode":"ojs"},{"id":2196,"value":"yearMarks = {\n const allYears = aq.agg(\n tidy.filter(d => op.month(d.fecha) >= 2 && op.utcdate(d.fecha) > 10).\n derive({y: d => op.year(d.fecha)}),\n op.array_agg_distinct('y')\n )\n return allYears.slice(1,).map(y => {return new Date(y, 2, 10)})\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1935,"value":"textBox = (text, padding=[7, 5], bg=\"#eef0f2\") => {\n return html`\n

${text}

\n `\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2167,"value":"years = ((aq.agg(tidy, op.max('fecha')) - aq.agg(tidy, op.min('fecha'))) / (1e3 * 60 * 60 * 24)) / 365","pinned":false,"hidden":false,"mode":"ojs"},{"id":2015,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":1190,"value":"html`\n \n\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1750,"value":"🖤","pinned":false,"hidden":false,"mode":"md"}],"files":"$W33","stdlib":"1","titling":"auto"}