35:null 36:["$","title",null,{"children":"Vigilancia Epidemiológica | Mauricio Foronda | Observable"}] 3c:Tb20,barplot = (html`

${ Plot.plot({ marginLeft: 0, marginBottom: 5, x: { axis: "top", label: "", tickSize: 0, grid: true, tickRotate: 0, ticks: d3.utcTicks(...d3.extent(dfo, d => d.mes), years).map((d) => new Date(d)).slice(1,), domain: d3.utcMonths(dfo[0].mes, dfo[dfo.length - 1].mes), tickFormat: x => x.toLocaleDateString("es-US", {year: "numeric", timeZone: 'UTC'}), }, y: { axis: "right", label: 'casos por mes', labelAnchor: "top", grid: true }, marks: [ Plot.dot(dfo, { x: "mes", y: column, fill: "color", fillOpacity: .75, r:2.5, strokeOpacity: .9, stroke: "#2f3038", strokeWidth: .2, title: (d) => `${d[column]} casos en ${d.municipio}\ndurante ${d.mes.toLocaleDateString("es-US", {year: "numeric", month: "long", timeZone: 'UTC'})}` }) ], height: 250, width: 530, }) }

${Plot.plot({ marginLeft: 0, marginRight: 0, marginBottom: 50, color: { scheme: 'pubugn', legend: true }, y: { grid: true, axis: "left", tickFormat: x => "", label: "", domain: d3.sort(municipio_order, d => -d.total).map(d => d.municipio), tickSize: 0, tickRotate: 0, }, x: { label: '', round: false, ticks: d3.utcTicks(...d3.extent(dfo, d => d.mes), years).map((d) => new Date(d)).slice(1,), domain: d3.utcMonths(dfo[0].mes, dfo[dfo.length - 1].mes), grid: true, tickRotate: 0, tickSize: 0, tickFormat: x => x.toLocaleDateString("es-US", {year: "numeric", timeZone: 'UTC'}), anchor: 'left' }, marks: [ Plot.cell(dfo, { x: 'mes', y: 'municipio', fill: column, title: (d) => `${d[column]}\nen ${d.municipio}\ndurante ${d.mes.toLocaleDateString("es-US", {year: "numeric", month: "long", timeZone: 'UTC'})}`, fillOpacity: .9, strokeWidth: 0. }) ], height: 1000, width: 245, })} ${Plot.plot({ marginRight: 50, marginLeft: 5, marginTop: 20, marginBottom: 0, color: { legend: false }, y: { tickFormat: x => "", label: "", domain: d3.sort(municipio_order, d => -d.total).map(d => d.municipio), tickSize: 0, tickRotate: 0, }, x: { label: 'casos →', grid: true }, marks: [ Plot.barX(municipio_order, { x: 'total', y: 'municipio', fill: 'color', title: (d) => `${d.total}\nen ${d.municipio}\n(${d.dep})`, fillOpacity: 1., strokeWidth: .0 }), Plot.text(municipio_order, { x: 'total', y: 'municipio', text: 'municipio', textAnchor: 'start', dx: 6, fontSize: 8, lineWidth: 6, opacity: .7 }) ], height: 950, width: 100, })}

`)3d:T556,lineplot = (html`

${Plot.plot({ marginLeft: 0, marginBottom: 50, color: { legend: false }, x: { label: "", tickSize: 0, grid: true, tickRotate: 0, ticks: d3.utcTicks(...d3.extent(dfo, d => d.mes), years).map((d) => new Date(d)), domain: d3.utcMonths(dfo[0].mes, dfo[dfo.length - 1].mes), tickFormat: x => x.toLocaleDateString("es-US", {year: "numeric", timeZone: 'UTC'}), }, y: { axis: "right", label: 'casos por mes', grid: true }, marks: [ Plot.area(municipio_vista, Plot.windowY({ k: 3, x1:"mes", y1: 0, y2:'selected', opacity: .15, fill: colores[municipio_vista.map(d => d.dep)[0]] })), Plot.line(municipio_vista, Plot.windowY({ k: 3, y: 'selected', x: 'mes', stroke: colores[municipio_vista.map(d => d.dep)[0]], strokeWidth: 1.5 }) ), Plot.dot(municipio_vista, { x: "mes", y: 'selected', fill: colores[municipio_vista.map(d => d.dep)[0]], fillOpacity: 1., r:2.5, strokeOpacity: .8, stroke: "#2f3038", strokeWidth: 1., title: (d) => `${d.selected} casos\nen ${d.mes.toLocaleDateString("es-US", {year: "numeric", month: "long", timeZone: 'UTC'})}` }) ], height: 300, width: 530, })}

`)3e:T8a8,genero_plot = { if (is_sex_compare) { return html`

${Object.keys(colores).map((d) => "" + d + "")}

${Plot.plot({ marginLeft: 40, marginBottom: 40, marginRight: 15, marginTop: 15, x: { ticks: d3.ticks(0, sex_max * 1.05, 6).slice(1,), tickSize: 0, grid: true, tickFormat: d => d3.format('.0f')(d) }, y: { tickSize: 0, ticks: d3.ticks(0, sex_max * 1.05, 6).slice(1,), tickFormat: d => d3.format('.0f')(d), grid: true }, marks: [ Plot.line([{x:0, y:0}, {x: sex_max * 1.05, y:sex_max * 1.05}], { x: "x", y: "y", stroke: "#000000", strokeWidth: 1.5, strokeOpacity: .08 }), Plot.text([{x: 0, y: sex_max * 1.05, text: sex_compare[1]}], { x: 'x', y: 'y', text: 'text', dx: 0, fontSize: 10, opacity: .7, lineWidth: 7, frameAnchor: "left" }), Plot.text([{x: sex_max * 1.05, y: sex_max * 0.02, text: sex_compare[0]}], { x: 'x', y: 'y', text: 'text', dx: 0, fontSize: 10, opacity: .7, lineWidth: 7, frameAnchor: "right" }), Plot.dot(dfo2, { x: "s0", y: "s1", fill: "color", fillOpacity: .7, r:3, strokeOpacity: .0, stroke: "#2f3038", strokeWidth: .0, title: (d) => `${d[sex_compare[1]]} ${sex_compare[1]}\n${d[sex_compare[0]]} ${sex_compare[0]}\nen ${d.municipio}\ndurante ${d.mes.toLocaleDateString("es-US", {year: "numeric", month: "long", timeZone: 'UTC'})}` } ) ], height: 550, width: 550, })}

Cada punto representa el número de casos en un municipio y mes.

` } else { return (md`*No existen cortes para comparar*`) }}3f:[] 3a:{"id":"2453f4e0d4273feb","slug":"vigilancia-epidemiologica/2","title":"Vigilancia Epidemiológica","thumbnail":"6177b7568f11e5341f8666c57d90871f265aeb1f6fef99f49db56aecf589eaad","access_level":"public","create_time":"$D2022-05-18T15:12:15.999Z","update_time":"$D2022-10-13T11:49:40.325Z","view_time":null,"first_public_time":"$D2022-05-18T15:36:44.004Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"475974948549302f","login":"mauforonda","name":"Mauricio Foronda","avatar_url":"https://avatars-next.observableusercontent.com/4cc3af3b792916571df54649e193dbdbf80a875b4e37b1def6ecb0480c561075","tier":"starter_2024","bio":""},"version":2824,"publish_version":2824,"role":null,"authored":false,"authors":[{"type":"individual","id":"018969b4abf63b07","login":"mauforonda","name":"Mau Foronda","avatar_url":"https://avatars-next.observableusercontent.com/513f52feadea4c57a52e2ab0f2fbdad66bf45a132acf7f9fbb19eb61e86e345f","tier":null,"bio":""}],"members":[{"type":"individual","id":"018969b4abf63b07","login":"mauforonda","name":"Mau Foronda","avatar_url":"https://avatars-next.observableusercontent.com/513f52feadea4c57a52e2ab0f2fbdad66bf45a132acf7f9fbb19eb61e86e345f","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":{"id":"d9392cefad8a061b","slug":"datos-abiertos-del-gobierno-boliviano","title":"Datos abiertos en Bolivia","owner":{"id":"475974948549302f","login":"mauforonda","name":"Mauricio Foronda"}},"type":"notebook","body":{"titling":"auto","title":"Vigilancia Epidemiológica","cells":[{"id":0,"value":"# Vigilancia Epidemiológica","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1287,"value":"text1 = (md`Explora datos de vigilancia epidemiológica por mes y municipio.`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":35,"value":"viewof nombre = Inputs.select(nombres, {value:\"Violencia en la familia entre 2015 y 2017\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":126,"value":"viewof column = Inputs.select(nonempty, {label: md`**Corte**`, value:last_column})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":496,"value":"heading1 = {\n let cum_mun = []\n let cum_suma\n let suma = 0\n column_summary.objects().forEach(r => {\n suma = r.porcentaje + suma\n if (suma < 60) {\n cum_mun.push(r.municipio)\n cum_suma = suma\n }\n })\n return md`**${nombre}** (*${column}*)\\n\\nEl **${d3.format(\".2f\")(first_mun.porcentaje)}%** de los casos se registraron en ${first_mun.municipio}. **${d3.format(\".2f\")(cum_suma)}%** de los casos se encuentran en ${cum_mun.length} municipios (*${cum_mun.join(\", \")}*).\\n\\n_**50 municipios** con más casos_`\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1235,"value":"legend = (\n html`

${Object.keys(colores).map((d) => \"\" + d + \"\")}

`\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":534,"value":"$3c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1123,"value":"viewof munselect = Inputs.select(municipio_order.map(d => d.municipio), {label: html`Casos en un municipio`})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1173,"value":"heading2 = (md`**${nombre} en ${munselect}** (*${column}*)`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1133,"value":"$3d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2641,"value":"genero_h = (\n md`**Comparaciones de género**\\n\\n*${nombre}*`\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2383,"value":"viewof sex_compare = Inputs.select(valid_comparisons, {format: d => d[1] + ' ··· ' + d[0], label: md`**Comparar**`, width: 400, disabled: !is_sex_compare})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2397,"value":"$3e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":390,"value":"text3 = (html`Descargar la tabla completa: CSV`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2262,"value":"column_summary = {\n return municipio_order_complete\n .groupby('municipio')\n .rollup({suma: op.sum(\"total\")})\n .derive({porcentaje: d => 100 * (d.suma / aq.sum(d.suma))})\n .orderby(aq.desc(\"porcentaje\"))\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2306,"value":"first_mun = column_summary.slice(0,1).object()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1819,"value":"years = {\n let row = indice_csv2.filter(aq.escape(d => (d.nombre_comun == nombre))).objects();\n return (row[0]['hasta'] - row[0]['desde']) + 1\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1862,"value":"minvalue = 0","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1302,"value":"nonempty = {\n\n let cols = [];\n dfcsv.\n columnNames()\n .slice(5,)\n .forEach((c) => {\n if (aq.agg(dfcsv, op.sum(c)) > 0) {\n cols.push(c)\n }\n });\n return cols\n\n \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1911,"value":"last_column = dfcsv.columnNames()[dfcsv.columnNames().length - 1]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":768,"value":"dfcsv = aq.loadCSV(dataurl)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":745,"value":"df = {\n return dfcsv\n .derive({ dep: aq.escape(d => departamentos[Number(String(d.codigo_municipio).slice(0,1))]) })\n .derive({ municipio: aq.escape(d => d.municipio.toLowerCase()) })\n .derive({ selected: aq.escape(d => d[column])})\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":779,"value":"municipio_order_complete = {\n return df\n .groupby(['dep', 'municipio'])\n .rollup({ total: d => op.sum(d.selected) })\n .filter(aq.escape( d => d.total >= minvalue))\n .orderby(aq.desc('total'))\n .derive({ color: aq.escape(d => colores[d.dep])})\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2270,"value":"municipio_order = {\n return municipio_order_complete\n .objects()\n .slice(0,50)\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1357,"value":"max_mun = aq.agg(df.groupby(['municipio']).rollup({ total: d => op.sum(d.selected)}), d => op.max(d.total))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1385,"value":"indice_csv2 = {\n const url = \"https://mauforonda.github.io/vigilancia-epidemiologica/resources/indice_agrupado.csv\";\n return aq.loadCSV(url)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1486,"value":"nombres = indice_csv2.orderby('nombre_comun').select('nombre_comun').objects().map(d => d.nombre_comun)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":330,"value":"dataurl = {\n const base = \"https://mauforonda.github.io/vigilancia-epidemiologica/agrupados/\";\n const f = indice_csv2.filter(aq.escape(d => (d.nombre_comun == nombre))).select('filename').objects()[0]['filename'];\n if (f.length > 0) {\n return base + f\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1708,"value":"dfo = {\n return df\n .select('dep', 'municipio', 'mes', column)\n .filter(aq.escape(d => d[column] > 0))\n .derive({ mes: aq.escape(d => new Date(d.mes))})\n .derive({ color: aq.escape(d => colores[d.dep])})\n .objects()\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2747,"value":"nonempty","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2421,"value":"dfo2 = {\n if (is_sex_compare) {\n return df\n .derive({ mes: aq.escape(d => new Date(d.mes))})\n .derive({ color: aq.escape(d => colores[d.dep])})\n .derive({ s0: aq.escape(d => d[sex_compare[0]] + Math.random() * .3)})\n .derive({ s1: aq.escape(d => d[sex_compare[1]] + Math.random() * .3)})\n .objects()\n } else {\n return null \n }\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1128,"value":"municipio_vista = {\n return df\n .filter(aq.escape((d) => d.municipio == munselect))\n .objects()\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":976,"value":"colores = ({\n 'La Paz': '#b6d3de',\n 'Oruro': '#b9c7e6',\n 'Potosí': '#d7c6f5',\n 'Cochabamba': '#f2bfdc',\n 'Chuquisaca': '#fbc6bb',\n 'Tarija': '#f5c0a9',\n 'Pando': '#f2d2b0',\n 'Beni': '#eee89d',\n 'Santa Cruz': '#c9dc9d'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":827,"value":"departamentos = ({\n 1: 'Chuquisaca',\n 2: 'La Paz',\n 3: 'Cochabamba',\n 4: 'Oruro',\n 5: 'Potosí',\n 6: 'Tarija',\n 7: 'Santa Cruz',\n 8: 'Beni',\n 9: 'Pando'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":730,"value":"import { aq, op } from '@uwdata/arquero'","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2376,"value":"sex_cols = d3.json('https://mauforonda.github.io/vigilancia-epidemiologica/resources/column_compare_sexo.json')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2617,"value":"is_sex_compare = valid_comparisons.length > 0","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2749,"value":"valid_comparisons = {\n let valid = []\n sex_cols[nombre]\n .forEach((d) => {if (nonempty.includes(d[0]) && nonempty.includes(d[1])) {\n valid.push(d)\n }})\n return valid\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2473,"value":"sex_max = {\n if (is_sex_compare) {\n return d3.max([d3.max(dfo2.map(d => d.s0)), d3.max(dfo2.map(d => d.s1))])\n } else {\n return null\n }\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W3f","stdlib":"1"}} 3b:"$3a:body"