31:T8d7,Plot.plot({ title: "Casos de DENGUE en CABA", subtitle: "Notificaciones por semana epidemiológica, brotes 22/23, 23/24 y 24/25", caption: "Datos de BA Salud", x: { tickFormat: (d) => d3.utcFormat("%d-%b")(d) }, width: width, marginTop: 100, height: 600, y: { label: "Casos notificados" }, marks: [ Plot.lineY( xlsCasosPorDia.filter( (d) => d.fecha > new Date(2022, 11, 1) && d.fecha < new Date(2023, 7, 1) ), { x: "fecha", y: "total", stroke: "silver", curve: "basis" } ), Plot.lineY( xlsCasosPorDia.filter( (d) => d.fecha > new Date(2023, 11, 1) && d.fecha < new Date(2024, 7, 1) ), { x: (d) => d3.utcYear.offset(d.fecha, -1), y: "total", stroke: "silver", fill: "#00000010", curve: "basis" } ), Plot.lineY( xlsCasosPorDia.filter((d) => d.fecha > new Date(2024, 10, 1)), { x: (d) => d3.utcYear.offset(d.fecha, -2), y: "total", stroke: "red", strokeWidth: 3, curve: "basis" } ), Plot.text( xlsCasosPorDia.filter((d) => d.fecha > new Date(2024, 10, 1)), Plot.selectLast({ x: (d) => d3.utcYear.offset(d.fecha, -2), y: "total", text: (d) => "Casos\n2025", dy: -20, dx: 25, fontSize: 16, fill: "red" }) ), Plot.dot( xlsCasosPorDia.filter((d) => d.fecha > new Date(2024, 10, 1)), Plot.selectLast({ x: (d) => d3.utcYear.offset(d.fecha, -2), y: "total", r: 4, fill: "red" }) ), Plot.textX([0], { y: 2200, x: (d) => new Date(2023, 3, 7), text: (d) => "Brote\n 2023", fill: "#888", fontSize: 16 }), Plot.textX([0], { y: 4300, x: (d) => new Date(2023, 2, 24), text: (d) => "Brote\n 2024", fill: "#444", fontSize: 16 }), Plot.ruleX([new Date()], { x: (d) => d3.utcYear.offset(d, -2), stroke: "purple", strokeDasharray: "2 2" }), Plot.text(["Hoy"], { text: (d) => d, x: (d) => d3.utcYear.offset(d, -2), y: 0, dx: 4, textAnchor: "start" }) ] })32:T5020,33:T577,Plot.plot({ width: width, height: 600, title: "Temperaturas en CABA", subtitle: "Promedio 14 días", caption: "Datos de covidstats.com.ar", color: { legend: true, domain: ["2020 a 2022", 2023, 2024], range: ["#eaeaea", "#bbb", "red"], type: "categorical", tickFormat: (d) => d }, y: { domain: d3.extent(climaHistorico, (d) => d.temp) }, x: { ticks: 12, tickFormat: (d) => d3.timeFormat("%b")(d3.timeDay.offset(new Date(2024, 0, 0), d)) }, marks: [ Plot.ruleY([0]), Plot.areaY( climaHistorico.filter((d) => d.anio != 2024), Plot.windowY( Plot.groupX( { y1: "max", y2: "min" }, { x: "dia", y: "temp", k: 14, fill: "#eaeaea" } ) ) ), Plot.lineY( climaHistorico.filter((d) => d.anio > 2022), Plot.windowY({ x: "dia", y: "temp", stroke: "anio", k: 7 }) ), // Plot.ruleX([d3.utcDay.count(d3.utcYear(now), now) - 1], { // stroke: "orange" // }), Plot.ruleX([105], { stroke: "orange" }), Plot.lineY( xlsCasosPorDia.filter( (d) => d.fecha < new Date(2024, 0, 1) && d.fecha > new Date(2023, 0, 1) ), { x: (d) => +d3.timeFormat("%j")(d.fecha), y: (d) => d.total / 150 + 8, stroke: "purple", strokeWidth: muestraBrote ? 1 : 0, strokeDasharray: "6 2" } ) ] })34:T404,Plot.plot({ width: width, height: 600, title: "Humedad en CABA", subtitle: "Promedio 14 días", caption: "Datos de covidstats.com.ar", color: { legend: true, domain: ["2020 a 2022", 2023, 2024], range: ["#eaeaea", "#bbb", "red"], type: "categorical", tickFormat: (d) => d }, y: { domain: d3.extent(climaHistorico, (d) => d.hum), tickFormat: (d) => d + "%" }, x: { ticks: 8, tickFormat: (d) => d3.timeFormat("%b")(d3.timeDay.offset(new Date(2024, 0, 0), d)) }, marks: [ Plot.ruleY([0]), Plot.areaY( climaHistorico.filter((d) => d.anio != 2024), Plot.windowY( Plot.groupX( { y1: "max", y2: "min" }, { x: "dia", y: "hum", k: 14, fill: "#eaeaea" } ) ) ), Plot.lineY( climaHistorico.filter((d) => d.anio > 2022), Plot.windowY({ x: "dia", y: "hum", stroke: "anio", k: 7 }) ) // Plot.ruleX([d3.utcDay.count(d3.utcYear(now), now) - 1], { // stroke: "orange" // }) ] })35:T432,chart = { const svg = d3.select(DOM.svg(width, height)); svg .append("rect") .attr("width", width) .attr("height", height) .attr("fill", "white"); svg.append("g").call(xAxis); svg.append("g").call(yAxis); const group = svg .append("g") .selectAll("g") .data(data.series) .join("g") .attr("transform", (d) => `translate(0,${y(d.denominacion) + 1})`); group .append("path") .attr("fill", "silver") //(d,i)=>colorea(i)) .attr("fill-opacity", transparencia) .attr("d", (d) => area(d[variable])); group .append("path") .attr("fill", "none") .attr("stroke", (d, i) => colorea(i)) .attr("d", (d) => line(d[variable])); group .append("g") .selectAll("circle") .data((d) => d.casosPico) .join("circle") .attr("r", 2) .attr("cx", (d) => x(data.dates[d])) .attr("cy", function (d) { return z(d3.select(this.parentNode).datum()[variable][d]) + 1; }) .attr("fill", "red") .attr("stroke-width", 0.5) .attr("stroke", "black"); return svg.node(); }36:Tc43,Plot.plot({ title: "Casos de DENGUE en CABA", subtitle: "Notificaciones por semana epidemiológica, brotes 22/23 y 23/24", caption: "Datos de BA Salud", x: { tickFormat: (d) => d3.utcFormat("%d-%b")(d) }, width: width, marginTop: 100, height: 600, y: { label: "Casos notificados" }, marks: [ Plot.lineY( xlsCasosPorDia.filter( (d) => d.fecha > new Date(2022, 11, 1) && d.fecha < new Date(2023, 8, 1) ), { x: "fecha", y: "total", stroke: "silver", fill: "#00000010", curve: "basis" } ), // Plot.lineY( // xlsCasosPorDia.filter((d) => d.fecha > new Date(2023, 11, 1)), // { // x: (d) => d3.utcYear.offset(d.fecha, -1), // y: "total", // stroke: "orange", // strokeWidth: 1 // // strokeDasharray: "4,2" // } // ), Plot.lineY( xlsCasosPorDia .filter( (d) => d.fecha > new Date(2023, 11, 1) && d.fecha < new Date(2024, 7, 1) ) .slice(0, -1), { x: (d) => d3.utcYear.offset(d.fecha, -1), y: "total", stroke: "red", strokeWidth: 3, curve: "basis" } ), Plot.rectY( desinsectacion, Plot.binX( { y: "count" }, { x: (d) => d3.utcYear.offset(d.DIA, -1), fill: "green", opacity: 0.7 } ) ), Plot.textX([0], { y: 1000, x: (d) => new Date(2023, 2, 1), text: (d) => "Fumigaciones", fill: "green", fontSize: 16 }), // Plot.lineY( // xlsCasosPorDia // .filter((d) => d.fecha > new Date(2023, 10, 10)) // .slice(0, -1), // { // x: (d) => d3.utcDay.offset(d3.utcYear.offset(d.fecha, -1), 56), // y: "total", // stroke: "red", // strokeWidth: 1, // strokeDasharray: "1,4" // } // ), Plot.text( xlsCasosPorDia .filter( (d) => d.fecha > new Date(2023, 11, 1) && d.fecha < new Date(2024, 7, 1) ) .slice(0, -1), Plot.selectLast({ x: (d) => d3.utcYear.offset(d.fecha, -1), y: "total", text: (d) => "Casos\n2024", dy: -20, dx: 25, fontSize: 16, fill: "red" }) ), Plot.dot( xlsCasosPorDia .filter( (d) => d.fecha > new Date(2023, 11, 1) && d.fecha < new Date(2024, 7, 1) ) .slice(0, -1), Plot.selectLast({ x: (d) => d3.utcYear.offset(d.fecha, -1), y: "total", r: 4, fill: "red" }) ), // Plot.ruleY([xlsCasosPorDia[xlsCasosPorDia.length - 2]], { // y: "total", // x1: (d) => d3.utcYear.offset(d.fecha, -1), // x2: (d) => d3.utcYear.offset(d3.utcMonth.offset(d.fecha, 2), -1), // stroke: "red", // strokeWidth: 0.5, // strokeDasharray: "1,4" // }), Plot.textX([0], { y: 2200, x: (d) => new Date(2023, 2, 30), text: (d) => "Brote\n 2023", fill: "black", fontSize: 16 }) ] })37:T4f5,dataLoadedCABAready = d3 .groups( dataLoadedCABA.filter((d) => d.ano == 2024), (d) => d.departamento_residencia ) .map((d) => { var casos = d3.range(semanas).map((e, i) => { var dat = d[1].filter((ee) => ee.semana_epidemiologica == i)[0]; return dat ? dat.n_confirmados_probables_fis + dat.n_confirmados_por_laboratorio : 0; }); var fallecidos = d3.range(semanas).map((e, i) => { var dat = d[1].filter((ee) => ee.semana_epidemiologica == i)[0]; return dat ? dat.n_fallecidos_confirmados_por_laboratorio : 0; }); var internados = d3.range(semanas).map((e, i) => { var dat = d[1].filter((ee) => ee.semana_epidemiologica == i)[0]; return dat ? dat.n_internados_fecha_internacion + dat.n_internados_uti_fecha_internacion : 0; }); return { denominacion: d[0], casos: casos, fallecidos: fallecidos, internados: internados, casosPico: detectPeaks(casos, { lookaround: 20, // the number of neighbors to compare to on each side sensitivity: 1, // sensitivity, in terms of standard deviations above the mean coalesce: 5 // coalesce together peaks within this distance of each other }) }; })38:T88b,Plot.plot({ title: "Casos de Dengue 2023/2024", subtitle: "Casos notificados (gris claro) y confirmados por laboratorio (gris oscuro)", caption: "Datos de BA Salud", marginLeft: 70, marginRight: 70, height: 400, y: { label: null, domain: [ "[0,10)", "[10,20)", "[20,30)", "[30,40)", "[40,50)", "[50,60)", "[60,70)", "[70,80)", "[80,90)", "[90,100)", "[100,110)", "[110,120]" ] }, x: { tickFormat: "d", label: "Casos confirmados" }, marks: [ Plot.barX( xlsCasos2.filter( (d) => d.fecha_inicio_semana_epidemiologica > new Date(2023, 9, 1) ), Plot.groupY( { x: "sum" }, { x: "n_notificaciones", y: "grupo_etario", fill: "silver" //sort: { y: "x", reverse: true } } ) ), Plot.barX( xlsCasos2.filter( (d) => d.fecha_inicio_semana_epidemiologica > new Date(2023, 9, 1) ), Plot.groupY( { x: "sum" }, { x: "n_confirmados_por_laboratorio", y: "grupo_etario", fill: "gray" //sort: { y: "x", reverse: true } } ) ), Plot.textX( xlsCasos2.filter( (d) => d.fecha_inicio_semana_epidemiologica > new Date(2023, 9, 1) ), Plot.groupY( { x: "sum", text: (d) => d3.format("d")(d3.sum(d, (dd) => dd.n_confirmados_por_laboratorio)) }, { x: "n_confirmados_por_laboratorio", y: "grupo_etario", //sort: { y: "x", reverse: true }, textAnchor: "start", dx: 4 } ) ), Plot.textX( xlsCasos2.filter( (d) => d.fecha_inicio_semana_epidemiologica > new Date(2023, 9, 1) ), Plot.groupY( { x: "sum", text: (d) => d3.format("d")(d3.sum(d, (dd) => dd.n_notificaciones)) }, { x: "n_notificaciones", y: "grupo_etario", //sort: { y: "x", reverse: true }, textAnchor: "start", dx: 4 } ) ), Plot.ruleX([0]) ] })39:[{"id":"2fda8538e33d8ac348013a13dc7b0e14076d97f5307e8b207fde5e139eae43e9fbedf2cc1c4cff4898ec380166d918cb72ded42b6be2df9ac1ed7fa9f3f4f1ad","href":"https://static.observableusercontent.com/files/2fda8538e33d8ac348013a13dc7b0e14076d97f5307e8b207fde5e139eae43e9fbedf2cc1c4cff4898ec380166d918cb72ded42b6be2df9ac1ed7fa9f3f4f1ad","name":"Temperaturas 2023 - Pivot Table 1@2.csv","type":"text/csv","lastModified":1710184730772.163,"size":8598},{"id":"50cd9ee61b167bcd096a4ef2dea325f0abef7988ff06db491aa96ad663e2ee9919813d49381e10de9b10f7d261b5552687035b5941a2654f71cb352e589f1321","href":"https://static.observableusercontent.com/files/50cd9ee61b167bcd096a4ef2dea325f0abef7988ff06db491aa96ad663e2ee9919813d49381e10de9b10f7d261b5552687035b5941a2654f71cb352e589f1321","name":"Desinsectaciones de enero a marzo 24.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1718890951852.575,"size":351111},{"id":"1e0571cefdff21c44eddef89940195d4b065ce2fd81ac475e9e91813e3536303f880dd94d66efcbe18b1f3681fdb4bee0c5801b1720a5e0ce7d785cf887976f4","href":"https://static.observableusercontent.com/files/1e0571cefdff21c44eddef89940195d4b065ce2fd81ac475e9e91813e3536303f880dd94d66efcbe18b1f3681fdb4bee0c5801b1720a5e0ce7d785cf887976f4","name":"casos_dengue@14.csv","type":"text/csv","lastModified":1737120501062.905,"size":1155},{"id":"70ef287f5db9164e254b193f356716bd842cf3d6377b18ea0cee2493768ec7c62e5649adb6ab141a99d49a793200c1ddb8f5f911c2b9ae6561b11dfa779eabac","href":"https://static.observableusercontent.com/files/70ef287f5db9164e254b193f356716bd842cf3d6377b18ea0cee2493768ec7c62e5649adb6ab141a99d49a793200c1ddb8f5f911c2b9ae6561b11dfa779eabac","name":"casos_dengue@47.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1733490019103.71,"size":307679},{"id":"1e0571cefdff21c44eddef89940195d4b065ce2fd81ac475e9e91813e3536303f880dd94d66efcbe18b1f3681fdb4bee0c5801b1720a5e0ce7d785cf887976f4","href":"https://static.observableusercontent.com/files/1e0571cefdff21c44eddef89940195d4b065ce2fd81ac475e9e91813e3536303f880dd94d66efcbe18b1f3681fdb4bee0c5801b1720a5e0ce7d785cf887976f4","name":"casos_dengue@13.csv","type":"text/csv","lastModified":1736873834857.202,"size":1155},{"id":"8936c6496512068e3486af64aaf7cbf968eb669f316a8e1682ec05617cc57753fda6c4b9c4bbf64293afa6dbb8cb0a61e6df682c88dba63206e58746c40e754a","href":"https://static.observableusercontent.com/files/8936c6496512068e3486af64aaf7cbf968eb669f316a8e1682ec05617cc57753fda6c4b9c4bbf64293afa6dbb8cb0a61e6df682c88dba63206e58746c40e754a","name":"casos_dengue@16.csv","type":"text/csv","lastModified":1738194628080.999,"size":1567},{"id":"8936c6496512068e3486af64aaf7cbf968eb669f316a8e1682ec05617cc57753fda6c4b9c4bbf64293afa6dbb8cb0a61e6df682c88dba63206e58746c40e754a","href":"https://static.observableusercontent.com/files/8936c6496512068e3486af64aaf7cbf968eb669f316a8e1682ec05617cc57753fda6c4b9c4bbf64293afa6dbb8cb0a61e6df682c88dba63206e58746c40e754a","name":"casos_dengue@17.csv","type":"text/csv","lastModified":1739972575572.382,"size":1567},{"id":"8936c6496512068e3486af64aaf7cbf968eb669f316a8e1682ec05617cc57753fda6c4b9c4bbf64293afa6dbb8cb0a61e6df682c88dba63206e58746c40e754a","href":"https://static.observableusercontent.com/files/8936c6496512068e3486af64aaf7cbf968eb669f316a8e1682ec05617cc57753fda6c4b9c4bbf64293afa6dbb8cb0a61e6df682c88dba63206e58746c40e754a","name":"casos_dengue@15.csv","type":"text/csv","lastModified":1737672588332.042,"size":1567},{"id":"8936c6496512068e3486af64aaf7cbf968eb669f316a8e1682ec05617cc57753fda6c4b9c4bbf64293afa6dbb8cb0a61e6df682c88dba63206e58746c40e754a","href":"https://static.observableusercontent.com/files/8936c6496512068e3486af64aaf7cbf968eb669f316a8e1682ec05617cc57753fda6c4b9c4bbf64293afa6dbb8cb0a61e6df682c88dba63206e58746c40e754a","name":"casos_dengue@18.csv","type":"text/csv","lastModified":1743167615516.347,"size":1567},{"id":"7d363296b1679e0f6005168e401830369d1064184406d0fb58631a5fda80f9d8fd23a4ee9b7df12b22d11f761382d0969ca5d32388a9ba243c9a7fea7a27035c","href":"https://static.observableusercontent.com/files/7d363296b1679e0f6005168e401830369d1064184406d0fb58631a5fda80f9d8fd23a4ee9b7df12b22d11f761382d0969ca5d32388a9ba243c9a7fea7a27035c","name":"casos_dengue@19.csv","type":"text/csv","lastModified":1747858029134.903,"size":7069},{"id":"3455e45d7220d64edd207a2684714d45069de04a29d4dc65cdb656f59c49818cc66be5a494dc4999f31b3ded462d17cc16fc7cd3b0df41f3fa8e6939816d94f1","href":"https://static.observableusercontent.com/files/3455e45d7220d64edd207a2684714d45069de04a29d4dc65cdb656f59c49818cc66be5a494dc4999f31b3ded462d17cc16fc7cd3b0df41f3fa8e6939816d94f1","name":"casos_dengue@20.csv","type":"text/csv","lastModified":1753916455608.88,"size":7941},{"id":"7d363296b1679e0f6005168e401830369d1064184406d0fb58631a5fda80f9d8fd23a4ee9b7df12b22d11f761382d0969ca5d32388a9ba243c9a7fea7a27035c","href":"https://static.observableusercontent.com/files/7d363296b1679e0f6005168e401830369d1064184406d0fb58631a5fda80f9d8fd23a4ee9b7df12b22d11f761382d0969ca5d32388a9ba243c9a7fea7a27035c","name":"casos_dengue-19.csv","type":"text/csv","lastModified":1753916561840.173,"size":7069},{"id":"3455e45d7220d64edd207a2684714d45069de04a29d4dc65cdb656f59c49818cc66be5a494dc4999f31b3ded462d17cc16fc7cd3b0df41f3fa8e6939816d94f1","href":"https://static.observableusercontent.com/files/3455e45d7220d64edd207a2684714d45069de04a29d4dc65cdb656f59c49818cc66be5a494dc4999f31b3ded462d17cc16fc7cd3b0df41f3fa8e6939816d94f1","name":"casos_dengue-20.csv","type":"text/csv","lastModified":1753916594432.234,"size":7941}] 2f:{"title":"Monitor de Dengue CABA","cells":[{"id":1027,"value":"# Monitor de Dengue CABA\n### 2023 - 2024 | Último dato: ${d3.timeFormat(\"%d-%b-%Y\")(ultimafecha)}\nFuente: https://data.buenosaires.gob.ar/dataset/reporte-epidemiologico-de-dengue?__no_cache__=True\n","pinned":false,"hidden":false,"mode":"md"},{"id":1845,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":1136,"value":"Plot.plot({\n title: \"Casos por habitante por comuna\",\n color: { scheme: \"Reds\" },\n marginLeft: 100,\n height: 600,\n x: {\n tickFormat: (d) => d - 0.5\n },\n y: {\n label: null,\n domain: [\n \"COMUNA 1\",\n \"COMUNA 2\",\n \"COMUNA 3\",\n \"COMUNA 4\",\n \"COMUNA 5\",\n \"COMUNA 6\",\n \"COMUNA 7\",\n \"COMUNA 8\",\n \"COMUNA 9\",\n \"COMUNA 10\",\n \"COMUNA 11\",\n \"COMUNA 12\",\n \"COMUNA 13\",\n \"COMUNA 14\",\n \"COMUNA 15\",\n \"SIN DATOS\"\n ]\n },\n marks: [\n Plot.cell(\n xlsCasos2.filter((d) => d.ano == 2024),\n Plot.binX(\n { fill: \"sum\" },\n {\n x: \"semana_epidemiologica\",\n fill: (d) =>\n (d.n_notificaciones /\n poblacionCaba.get(d.departamento_residencia)) *\n 1e5,\n y: \"departamento_residencia\"\n }\n )\n )\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1170,"value":"$32","pinned":false,"hidden":false,"mode":"html"},{"id":1553,"value":"viewof semanaAnimada = Scrubber(d3.range(semanas), {\n loopDelay: 5000,\n delay: 300,\n format: (d) =>\n d3.timeFormat(\"%d-%B\")(d3.utcWeek.offset(new Date(2024, 0, 1), d))\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1633,"value":"viewof muestraBrote = Inputs.toggle({ label: \"Muestra brote\" })","pinned":false,"hidden":false,"mode":"ojs"},{"id":1298,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":1399,"value":"$34","pinned":false,"hidden":false,"mode":"ojs"},{"id":1174,"value":"chart2 = {\n const svg = d3.select(\"svg#mapaComunas\");\n\n // aca voy a pintar las comunas\n const comunas = svg.selectAll(\"#comunas .comuna\");\n\n comunas.each(function (d) {\n d3.select(this).datum(dataComunas.filter((e) => e.comuna == this.id)[0]);\n });\n\n comunas\n // .style(\"opacity\", (d) =>\n // opacidadFondo(+d[variable].replace(\"%\", \"\").replace(\",\", \".\"))\n // )\n .style(\"fill\", (d) => {\n console.log(coloreaRojo(d.cantidad));\n return coloreaRojo(d.cantidad);\n });\n\n // aca voy a cambiar los titulos de las comunas\n const textosComunas = svg.selectAll(\"#textosComunas tspan\");\n\n textosComunas.each(function (d) {\n d3.select(this).datum(dataComunas.filter((e) => e.comuna == this.id)[0]);\n });\n\n // textosComunas.text((d) =>\n // d3\n // .format(\".2%\")(+d[variable].replace(\"%\", \"\").replace(\",\", \".\") / 100)\n // .replace(\".00\", \"\")\n // );\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1185,"value":"coloreaRojo = d3.scaleLinear().range([\"#fff\", \"red\"]).domain([0, 0.002])","pinned":false,"hidden":false,"mode":"ojs"},{"id":1181,"value":"dataComunas = d3\n .rollups(\n xlsCasos2\n .filter((d) => d.ano == 2024)\n .filter((d) => d.semana_epidemiologica == semanaAnimada + 1),\n (v) => {\n return {\n cantidad:\n d3.sum(v, (vv) => vv.n_notificaciones) /\n poblacionCaba.get(v[0].departamento_residencia),\n comuna: comunasPorID.get(v[0].departamento_residencia)\n };\n },\n (d) => d.departamento_residencia\n )\n .map((d) => d[1])","pinned":false,"hidden":false,"mode":"ojs"},{"id":1176,"value":"textosComunasPorID = new Map([\n [\"textC1\", \"COMUNA 01\"],\n [\"textC2\", \"COMUNA 02\"],\n [\"textC3\", \"COMUNA 03\"],\n [\"textC4\", \"COMUNA 04\"],\n [\"textC5\", \"COMUNA 05\"],\n [\"textC6\", \"COMUNA 06\"],\n [\"textC7\", \"COMUNA 07\"],\n [\"textC8\", \"COMUNA 08\"],\n [\"textC9\", \"COMUNA 09\"],\n [\"textC10\", \"COMUNA 10\"],\n [\"textC11\", \"COMUNA 11\"],\n [\"textC12\", \"COMUNA 12\"],\n [\"textC13\", \"COMUNA 13\"],\n [\"textC14\", \"COMUNA 14\"],\n [\"textC15\", \"COMUNA 15\"]\n])","pinned":false,"hidden":false,"mode":"ojs"},{"id":1178,"value":"comunasPorID = new Map([\n [\"COMUNA 1\", \"COMUNA01\"],\n [\"COMUNA 2\", \"COMUNA02\"],\n [\"COMUNA 3\", \"COMUNA03\"],\n [\"COMUNA 4\", \"COMUNA04\"],\n [\"COMUNA 5\", \"COMUNA05\"],\n [\"COMUNA 6\", \"COMUNA06\"],\n [\"COMUNA 7\", \"COMUNA07\"],\n [\"COMUNA 8\", \"COMUNA08\"],\n [\"COMUNA 9\", \"COMUNA09\"],\n [\"COMUNA 10\", \"COMUNA10\"],\n [\"COMUNA 11\", \"COMUNA11\"],\n [\"COMUNA 12\", \"COMUNA12\"],\n [\"COMUNA 13\", \"COMUNA13\"],\n [\"COMUNA 14\", \"COMUNA14\"],\n [\"COMUNA 15\", \"COMUNA15\"]\n])","pinned":false,"hidden":false,"mode":"ojs"},{"id":959,"value":"xlsCasosPorDia[xlsCasosPorDia.length - 2]","pinned":false,"hidden":false,"mode":"ojs"},{"id":14,"value":"$35","pinned":false,"hidden":false,"mode":"ojs"},{"id":894,"value":"$36","pinned":false,"hidden":false,"mode":"ojs"},{"id":535,"value":"viewof variable = Inputs.select([\"casos\", \"fallecidos\"], {\n label: \"Seleccionar indice\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":445,"value":"viewof transparencia = Range([0, 1], {step: 0.1,value: 0.8, label: \"transparencia\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":159,"value":"viewof overlap = Range([0, 30], {value: 8, step:0.5, label: \"Superposición\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":397,"value":"fechaInicioView = \"2024-01-01\"\n//viewof fechaInicioView = Range([0, 600], {value: 0, step:10, label: \"Fecha de Inicio\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":503,"value":"colorea = d3.scaleOrdinal()\n.range([\"#003f5c\",\"#bc5090\"])","pinned":false,"hidden":false,"mode":"ojs"},{"id":43,"value":"height = data.series.length * 40","pinned":false,"hidden":false,"mode":"ojs"},{"id":45,"value":"margin = ({ top: 250, right: 10, bottom: 70, left: 150 })","pinned":false,"hidden":false,"mode":"ojs"},{"id":38,"value":"x = d3.scaleTime()\n .domain([new Date(fechaInicioView),d3.max(data.dates)])\n .range([ margin.left, width - margin.right])","pinned":false,"hidden":false,"mode":"ojs"},{"id":48,"value":"y = d3.scalePoint()\n .domain(data.series.map(d => d.denominacion))\n .range([margin.top, height - margin.bottom])","pinned":false,"hidden":false,"mode":"ojs"},{"id":67,"value":"z = d3.scaleLinear()\n .domain([0, d3.max(data.series, d => d3.max(d[variable]))]).nice()\n .range([0, -overlap * y.step()])","pinned":false,"hidden":false,"mode":"ojs"},{"id":52,"value":"xAxis = g => g\n .attr(\"transform\", `translate(0,${height - margin.bottom})`)\n .call(d3.axisBottom(x)\n .ticks(width / 80)\n .tickSizeOuter(0))","pinned":false,"hidden":false,"mode":"ojs"},{"id":54,"value":"yAxis = g => g\n .attr(\"transform\", `translate(${margin.left},0)`)\n .call(d3.axisLeft(y).tickSize(0).tickPadding(4))\n .call(g => g.select(\".domain\").remove())\n .call(g => g.selectAll(\".tick text\")\n .attr(\"fill\", (d,i)=>colorea(i)))","pinned":false,"hidden":false,"mode":"ojs"},{"id":57,"value":"area = d3\n .area()\n .curve(d3.curveLinear)\n .defined((d, i) => !isNaN(d) && data.dates[i] > new Date(fechaInicioView))\n .x((d, i) => x(data.dates[i]))\n .y0(0)\n .y1((d) => z(d))","pinned":false,"hidden":false,"mode":"ojs"},{"id":110,"value":"line = area.lineY1()","pinned":false,"hidden":false,"mode":"ojs"},{"id":682,"value":"semanas = d3.max(\n dataLoadedCABA.filter((d) => d.ano == 2024),\n (d) => d.semana_epidemiologica\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":638,"value":"$37","pinned":false,"hidden":false,"mode":"ojs"},{"id":595,"value":"dataLoadedCABA = xlsCasos2.filter((d) => d.ano == 2024)\n// d3.csvParse(\n// file.replaceAll(\",\", \"-\").replaceAll(\";\", \",\"),\n// d3.autoType\n// )","pinned":false,"hidden":false,"mode":"ojs"},{"id":737,"value":"dataSemanalTotal = d3\n .rollups(\n dataLoadedCABA,\n (v) => {\n return {\n casos: d3.sum(v, (vv) => vv.n_notificaciones),\n fis: d3.sum(v, (vv) => vv.n_confirmados_probables_fis),\n lab: d3.sum(v, (vv) => vv.n_confirmados_por_laboratorio),\n internados: d3.sum(\n v,\n (vv) =>\n vv.n_internados_fecha_internacion +\n vv.n_internados_uti_fecha_internacion\n ),\n\n fallecidos: d3.sum(\n v,\n (vv) => vv.n_fallecidos_confirmados_por_laboratorio\n ),\n SE: v[0].semana_epidemiologica,\n año: v[0].ano\n };\n },\n (d) => d.semana_epidemiologica + \"-\" + d.ano\n )\n .map((d) => d[1])","pinned":false,"hidden":false,"mode":"ojs"},{"id":742,"value":"fechaInicioDataset = d3.min(\n dataLoadedCABA,\n (d) => d.fecha_inicio_semana_epidemiologica\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":859,"value":"ultimafecha = d3.max(xlsCasosPorDia, (d) => d.fecha)","pinned":true,"hidden":false,"mode":"ojs"},{"id":778,"value":"fechas = d3.utcWeek.range(\n new Date(fechaInicio),\n d3.max(dataLoadedCABA, (d) => d.fecha_inicio_semana_epidemiologica),\n 1\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":307,"value":"fechaInicio = \"2024-01-01\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":5,"value":"data = {\n const dates = d3.timeWeek.range(\n new Date(fechaInicio),\n d3.max(dataLoadedCABA, (d) => d.fecha_inicio_semana_epidemiologica),\n 1\n );\n return {\n dates: dates,\n series: Object.values(dataLoadedCABAready).sort((a, b) =>\n d3.descending(a.casos[a.casos.length - 1], b.casos[b.casos.length - 1])\n )\n };\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":345,"value":"import { movingAverage } from \"@d3/moving-average\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":443,"value":"import {Toggle, Range} from \"@observablehq/inputs\"\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":451,"value":"import {detectPeaks} from '@yurivish/peak-detection'\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":499,"value":"esp2 = d3.timeFormatDefaultLocale(espTime)","pinned":false,"hidden":false,"mode":"ojs"},{"id":496,"value":"espTime = d3.json(\n \"https://raw.githubusercontent.com/d3/d3-time-format/master/locale/es-ES.json\"\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":900,"value":"xlsCasosPorDia = d3\n .rollups(\n xlsCasos2,\n (v) => {\n return {\n fecha: v[0].fecha_inicio_semana_epidemiologica,\n total: d3.sum(v, (vv) => vv.n_notificaciones),\n anio: v[0].ano,\n temporada:\n v[0].fecha_inicio_semana_epidemiologica < new Date(2023, 11, 1)\n ? 2023\n : 2024\n };\n },\n (d) => d.fecha_inicio_semana_epidemiologica\n )\n .map((d) => d[1])\n .concat(dengue2025)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1728,"value":"xlsCasosPorComuna = d3.rollup(\n xlsCasos2,\n (v) => d3.sum(v, (vv) => vv.n_notificaciones),\n (d) => d.departamento_residencia\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1747,"value":"xlsCasosPorComunaEneAbr = d3.rollup(\n xlsCasos2.filter((d) => d.ano == 2024 && 13 > d.semana_epidemiologica),\n (v) => d3.sum(v, (vv) => vv.n_notificaciones),\n (d) => d.departamento_residencia\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1847,"value":"dengue2025 = FileAttachment(\"casos_dengue-20.csv\")\n .arrayBuffer()\n .then((buffer) => {\n // Intentamos decodificar con ISO-8859-1, una codificación común en archivos en español.\n const text = new TextDecoder(\"iso-8859-1\").decode(buffer);\n return d3.dsvFormat(\";\").parse(text);\n })\n.then((importedData) => {\n return importedData.map((row) => {\n // Make a copy of the row to avoid modifying the original\n const transformedRow = {};\n\n // // // Add or modify fields as needed\n transformedRow.anio = +row[\"ï»¿ano\"];\n transformedRow.temporada = 2025;\n transformedRow.total = +row.n_confirmados;\n\n transformedRow.fecha = d3.utcParse(\"%Y-%m-%d\")(\n row.fecha_inicio_semana_epidemiologica\n );\n\n return transformedRow;\n });\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":1030,"value":"workbook = FileAttachment(\"casos_dengue@47.xlsx\").xlsx()","pinned":true,"hidden":false,"mode":"ojs"},{"id":1031,"value":"workbook.sheetNames","pinned":true,"hidden":false,"mode":"ojs"},{"id":1032,"value":"data1 = workbook.sheet(0, {\n headers: true\n // range: \"A1:J10\"\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":1033,"value":"xlsCasos2 = data1","pinned":false,"hidden":false,"mode":"ojs"},{"id":1771,"value":"$38","pinned":false,"hidden":false,"mode":"ojs"},{"id":1155,"value":"poblacionCaba = new Map([\n [\"COMUNA 1\", 223554],\n [\"COMUNA 2\", 161645],\n [\"COMUNA 3\", 196240],\n [\"COMUNA 4\", 229240],\n [\"COMUNA 5\", 194271],\n [\"COMUNA 6\", 203043],\n [\"COMUNA 7\", 215896],\n [\"COMUNA 8\", 204367],\n [\"COMUNA 9\", 169063],\n [\"COMUNA 10\", 173004],\n [\"COMUNA 11\", 204601],\n [\"COMUNA 12\", 236887],\n [\"COMUNA 13\", 264385],\n [\"COMUNA 14\", 248635],\n [\"COMUNA 15\", 196876]\n])","pinned":false,"hidden":false,"mode":"ojs"},{"id":1236,"value":"temperaturas = await FileAttachment(\"Temperaturas 2023 - Pivot Table 1@2.csv\").csv({typed: \"auto\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1247,"value":"climaHistoricoBulk = fetch(\n \"https://covidstats.com.ar/ws/smn?comprimido=1&estacionsmn=839\"\n).then((response) => response.json())","pinned":false,"hidden":false,"mode":"ojs"},{"id":1448,"value":"lastDate = d3.timeDay.offset(new Date(2020, 0, 1), climaHistoricoBulk.dias)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1254,"value":"climaHistorico = climaHistoricoBulk.temperatura.map((d, i) => {\n var fecha = d3.utcDay.offset(d3.utcParse(\"%Y-%m-%d\")(\"2020-01-01\"), i);\n return {\n fecha: fecha,\n dia: d3.utcDay.count(d3.utcYear(fecha), fecha),\n anio: +d3.utcFormat(\"%Y\")(fecha),\n temp: d,\n tMax: climaHistoricoBulk.temperatura_max[i],\n tMin: climaHistoricoBulk.temperatura_min[i],\n hum: climaHistoricoBulk.humedad[i]\n };\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1555,"value":"import { Scrubber } from \"@mbostock/scrubber\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":1672,"value":"workbook1 = FileAttachment(\"Desinsectaciones de enero a marzo 24.xlsx\").xlsx()","pinned":true,"hidden":false,"mode":"ojs"},{"id":1673,"value":"workbook1.sheetNames","pinned":true,"hidden":false,"mode":"ojs"},{"id":1674,"value":"data2 = workbook1.sheet(0, {\n headers: true\n // range: \"A1:J10\"\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":1680,"value":"Plot.plot({\n title: \"Fumigaciones en CABA\",\n subtitle: \"Enero - Marzo 2024\",\n caption: \"Datos de GCBA según Acceso a la Info.\",\n\n marginLeft: 100,\n height: 500,\n y: {\n label: null,\n tickFormat: (d) => \"Comuna \" + d\n },\n x: {\n label: \"Cantidad\"\n },\n marks: [\n Plot.barX(\n desinsectacion,\n Plot.binX({ x: \"count\" }, { y: \"COM.\", fill: \"green\", opacity: 0.7 })\n )\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1734,"value":"Plot.plot({\n title: \"Fumigaciones en CABA\",\n subtitle: \"Enero - Marzo 2024. En fumigaciones cada 100mil hab.\",\n caption: \"Datos de GCBA según Acceso a la Info.\",\n\n marginLeft: 100,\n height: 500,\n y: {\n label: null,\n tickFormat: (d) => \"Comuna \" + d\n },\n x: {\n label: \"Cantidad\"\n },\n marks: [\n Plot.barX(desinsectacionRel, {\n y: \"com\",\n x: (d) => (d.cantidad / d.pob) * 1e5,\n fill: \"green\",\n opacity: 0.7\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1753,"value":"Plot.plot({\n title: \"Fumigaciones en CABA\",\n subtitle:\n \"Enero - Marzo 2024. En fumigaciones cada 100mil NOTIFICACIONES de dengue\",\n caption: \"Datos de GCBA según Acceso a la Info.\",\n\n marginLeft: 100,\n height: 500,\n y: {\n label: null,\n tickFormat: (d) => \"Comuna \" + d\n },\n x: {\n label: \"Cantidad\"\n },\n marks: [\n Plot.barX(desinsectacionRel, {\n y: \"com\",\n x: (d) => (d.cantidad / d.casos) * 1e5,\n fill: \"green\",\n opacity: 0.7\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1692,"value":"desinsectacionRel = d3\n .rollups(\n desinsectacion,\n (v) => {\n return {\n cantidad: v.length,\n pob: poblacionCaba.get(\"COMUNA \" + v[0][\"COM.\"]),\n casos: xlsCasosPorComunaEneAbr.get(\"COMUNA \" + v[0][\"COM.\"]),\n com: v[0][\"COM.\"]\n };\n },\n (d) => d[\"COM.\"]\n )\n .map((d) => d[1])","pinned":false,"hidden":false,"mode":"ojs"},{"id":1675,"value":"desinsectacion = data2","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W39","stdlib":"1","titling":"auto"}