30:T649,function plotStatus(item) { const data = item[`${reporteOEvento.prefix}${timeChunk.col}`].map(d => ([{ year: d.year, date: new Date(d.year, d.month || 0, 1), ct: d.status_alive_ct, status: 'Localizado con vida' }, { year: d.year, date: new Date(d.year, d.month || 0, 1), ct: d.status_not_found_ct, status: 'Sin localizar', }, { year: d.year, date: new Date(d.year, d.month || 0, 1), ct: d.status_dead_ct, status: 'Localizado sin vida', }])).flat(); return Plot.plot({ ...plotSize, width: itemHeight * 2.2, color: { domain: ["Sin localizar", "Localizado sin vida", "Localizado con vida"], range: [colors.sin_localizar, colors.localizado_sin_vida, colors.localizado_con_vida], }, x: { label: null, ticks: [new Date("2008-01-01"), new Date("2017-01-01")], tickFormat: d => d.getFullYear() + 1, }, y: { label: null, nice: true, }, facet: { data, x: "status", marginRight: 20, label: null, }, marks: [ Plot.ruleY([0], {stroke: "#222222", strokeWidth: 0.75}), Plot.ruleX([new Date(2006, 0, 1)], {stroke: "#222222", strokeWidth: 0.75}), Plot.lineY(data, { x: "date", y: "ct", stroke: "status", strokeWidth: 1, }), Plot.dot(data, { x: "date", y: "ct", stroke: "status", fill: "white", r: timeChunk.col === "years" ? 2 : 0, title: d => `${d.date.getFullYear()}${timeChunk.col === "years" ? "" : `-X`}: ${d.ct}` }), ] }) }31:T537,function plotGender(item) { const data = item[`${reporteOEvento.prefix}${timeChunk.col}`].map(d => ([{ date: new Date(d.year, d.month || 0, 1), ct: d.gender_fem_ct, gender: 'Femenino' }, { date: new Date(d.year, d.month || 0, 1), ct: d.gender_masc_ct, gender: 'Masculino', }])).flat(); return Plot.plot({ ...plotSize, width: itemHeight * 2.3, color: { domain: ["Femenino", "Masculino"], range: [colors.femenino, colors.masculino], }, x: { label: null, ticks: [new Date("2008-01-01"), new Date("2017-01-01")], tickFormat: d => d.getFullYear() + 1, }, y: { label: null, nice: true, }, facet: { data, x: "gender", marginRight: 60, label: null, }, marks: [ Plot.ruleY([0], {stroke: "#222222", strokeWidth: 0.75}), Plot.ruleX([new Date(2006, 0, 1)], {stroke: "#222222", strokeWidth: 0.75}), Plot.lineY(data, { x: "date", y: "ct", stroke: "gender", strokeWidth: 1, }), Plot.dot(data, { x: "date", y: "ct", stroke: "gender", fill: "white", r: timeChunk.col === "years" ? 3 : 0, title: d => `${d.date.getFullYear()}${timeChunk.col === "years" ? "" : `-X`}: ${d.ct}` }), ] }) }32:T8ca,function totalsTable(item) { const data = [ { key: "Localizado con vida", total: item.evento_years_aggregate.aggregate.sum.status_alive_ct, percap: (item.evento_years_aggregate.aggregate.sum.status_alive_ct / item.census[0].sum * 100000).toFixed(1), fem: item.evento_years_aggregate.aggregate.sum.femenino_vivo, masc: item.evento_years_aggregate.aggregate.sum.masculino_vivo, }, { key: "Localizado sin vida", total: item.evento_years_aggregate.aggregate.sum.status_dead_ct, percap: (item.evento_years_aggregate.aggregate.sum.status_dead_ct / item.census[0].sum * 100000).toFixed(1), fem: item.evento_years_aggregate.aggregate.sum.femenino_muerto, masc: item.evento_years_aggregate.aggregate.sum.masculino_muerto, }, { key: "Sin localizar", total: item.evento_years_aggregate.aggregate.sum.status_not_found_ct, percap: (item.evento_years_aggregate.aggregate.sum.status_not_found_ct / item.census[0].sum * 100000).toFixed(1), fem: item.evento_years_aggregate.aggregate.sum.femenino_aun_sin_localizar, masc: item.evento_years_aggregate.aggregate.sum.masculino_aun_sin_localizar, }, { key: html`Total`, total: item.evento_years_aggregate.aggregate.sum.disappearance_ct, percap: (item.evento_years_aggregate.aggregate.sum.disappearance_ct / item.census[0].sum * 100000).toFixed(1), fem: item.evento_years_aggregate.aggregate.sum.gender_fem_ct, masc: item.evento_years_aggregate.aggregate.sum.gender_masc_ct, } ]; return html` ${data.map(row => html``)}

Estatus	Fem.	Masc.	Per 100k	Total
${row.key}	${row.fem ? row.fem.toLocaleString() : "-"}	${row.masc ? row.masc.toLocaleString() : "-"}	${row.percap ? row.percap.toLocaleString() : "-"}	${row.total ? row.total.toLocaleString() : "-"}

` }33:T4d5,choropleths = estadoData.estados.map(d => { const projection = d3.geoMercator().fitSize([mapSize, mapSize], d.geom); const path = d3.geoPath().projection(projection); const muniData = dataQuery.views_municipales.filter(m => m.nom_ent === d.nom_ent); const max_count = d3.max(muniData, m => m.evento_years_aggregate.aggregate.sum.disappearance_ct); const fillScale = d3.scaleSequentialPow() .exponent(0.5) .domain([0, max_count]) .interpolator(d3.interpolateRgbBasis(schemeGrayscale.slice(0, 5))) .unknown("none"); const mapSVG = d3.create("svg") .attr("viewBox", [0, 0, mapSize, mapSize]); mapSVG .append("path") .attr("stroke", "#444444") .attr("stroke-width", .75) // .attr("shape-rendering", "geometricPrecision") .attr("fill", "none") .attr("d", path(d.geom)) mapSVG.append("g") .selectAll("path") .data(muniData) .join("path") .attr("stroke", "none") .attr("stroke-width", 0) .attr("shape-rendering", "geometricPrecision") .attr("fill", m => fillScale(m.evento_years_aggregate.aggregate.sum.disappearance_ct)) .attr("d", m => path(m.geom)) return { mapSVG, path, projection, ...d } })34:T41c,dt = aq.from(dataQuery.views_municipales).derive({ pob: item => item.census[0] ? item.census[0].sum : -1, status_todo_percap: item => item.census.length ? item.evento_years_aggregate.aggregate.sum.disappearance_ct / item.census[0].sum * 100000 : -1, status_alive_percap: item => item.census.length ? item.evento_years_aggregate.aggregate.sum.status_alive_ct / item.census[0].sum * 100000 : -1, status_dead_percap: item => item.census.length ? item.evento_years_aggregate.aggregate.sum.status_dead_ct / item.census[0].sum * 100000 : -1, status_not_found_percap: item => item.census.length ? item.evento_years_aggregate.aggregate.sum.status_not_found_ct / item.census[0].sum * 100000 : -1, disappearance_ct: item => item.evento_years_aggregate.aggregate.sum.disappearance_ct, status_alive_ct: item => item.evento_years_aggregate.aggregate.sum.status_alive_ct, status_dead_ct: item => item.evento_years_aggregate.aggregate.sum.status_dead_ct, status_not_found_ct: item => item.evento_years_aggregate.aggregate.sum.status_not_found_ct, })35:Tac7,dataQuery = graphql({ operationName: 'MunicipioQuery', query: `query MunicipioQuery { views_municipales { cve_geoid nom_ent nom_mun geom: geom_simple centroid_geom census(where: {ano: {_eq: 2015}}) { ano sum } years(order_by: {year: asc}) { disappearance_ct gender_fem_ct gender_masc_ct status_alive_ct status_dead_ct status_not_found_ct femenino_aun_sin_localizar femenino_muerto femenino_vivo masculino_aun_sin_localizar masculino_muerto masculino_vivo year } years_aggregate { aggregate { sum { disappearance_ct gender_fem_ct gender_masc_ct status_alive_ct status_dead_ct status_not_found_ct femenino_aun_sin_localizar femenino_muerto femenino_vivo masculino_aun_sin_localizar masculino_muerto masculino_vivo } } } evento_years(order_by: {year: asc}) { disappearance_ct gender_fem_ct gender_masc_ct status_alive_ct status_dead_ct status_not_found_ct femenino_aun_sin_localizar femenino_muerto femenino_vivo masculino_aun_sin_localizar masculino_muerto masculino_vivo year } evento_years_aggregate { aggregate { sum { disappearance_ct gender_fem_ct gender_masc_ct status_alive_ct status_dead_ct status_not_found_ct femenino_aun_sin_localizar femenino_muerto femenino_vivo masculino_aun_sin_localizar masculino_muerto masculino_vivo } } } months(order_by: {year: asc, month: asc}) { disappearance_ct gender_fem_ct gender_masc_ct status_alive_ct status_dead_ct status_not_found_ct femenino_aun_sin_localizar femenino_muerto femenino_vivo masculino_aun_sin_localizar masculino_muerto masculino_vivo year month date } evento_months(order_by: {year: asc, month: asc}) { disappearance_ct gender_fem_ct gender_masc_ct status_alive_ct status_dead_ct status_not_found_ct femenino_aun_sin_localizar femenino_muerto femenino_vivo masculino_aun_sin_localizar masculino_muerto masculino_vivo date month year } } }` })36:T5c0, 37:[] 2e:{"title":"Cenapi-PGR-Explorador por municipio","cells":[{"id":0,"value":"# Cenapi-PGR-Explorador por municipio\n\nEn este cuaderno se pueden explorar con detalle los datos por municipio. Se recomienda utilizar las opciones disponibles para delimitar la búsqueda por estado, rango de población estimada o número de casos mínimos reportados. También se puede explorar la información por año de reporte o año de evento, u ordenar la información por las variables disponibles. Es posible que la información tome algún tiempo para cargar.\n","pinned":false,"hidden":false,"mode":"md"},{"id":1197,"value":"**Filtra los municipios por:**","pinned":false,"hidden":false,"mode":"md"},{"id":505,"value":"viewof minCasos = Inputs.select([0, 1, 5, 10, 50, 100, 500, 1000], {\n label: 'Casos mínimos',\n value: 10,\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":518,"value":"viewof pobMin = Inputs.select([0, 500, ...d3.range(1000, 10001, 1000),...d3.range(15000, 100001, 5000)], {\n label: 'Población mínima',\n value: 1000,\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":523,"value":"viewof pobMax = Inputs.select([15000, 30000, 50000, 100000, 250000, 500000, 1e6, 2e6], {\n label: 'Población máxima',\n value: 2e6,\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":589,"value":"viewof timeChunk = Inputs.select([{col: \"years\", label: \"Por año\"}, {col: \"months\", label: \"Por mes\"}], { label: \"Temporalidad en las gráficas\", format: x => x.label})","pinned":false,"hidden":false,"mode":"ojs"},{"id":597,"value":"viewof reporteOEvento = Inputs.select([{prefix: \"evento_\", label: \"Evento\"}, {prefix: \"\", label: \"Reporte\"}], { label: \"Ver por tipo de fecha\", format: x => x.label, value: {prefix: \"evento_\", label: \"Evento\"}})","pinned":false,"hidden":false,"mode":"ojs"},{"id":761,"value":"viewof sortKey = Inputs.select([\n {\n col: \"disappearance_ct\",\n label: \"# de reportes\",\n },\n {\n col: \"status_alive_ct\",\n label: \"Estatus: Localizado con vida\",\n },\n {\n col: \"status_dead_ct\",\n label: \"Estatus: Localizado sin vida\",\n },\n {\n col: \"status_not_found_ct\",\n label: \"Estatus: Sin localizar\",\n },\n {\n col: \"status_todo_percap\",\n label: \"# de Reportes por 100mil hab\",\n },\n {\n col: \"status_alive_percap\",\n label: \"Localizado con vida / 100k\",\n },\n {\n col: \"status_dead_percap\",\n label: \"Localizado sin vida / 100k\",\n },\n {\n col: \"status_not_found_percap\",\n label: \"Sin localizar / 100k\",\n }, \n {\n col: \"pob\",\n label: \"Población estimada\",\n },\n], {\n label: \"Organizar información por\",\n format: x => x.label\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1001,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":534,"value":"viewof chartType = Inputs.select([\"Sexo\", \"Estatus de localización\"], { label: \"Mostrar gráficos por\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1159,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":1206,"value":"Filtra por estado seleccionando el recuadro que aparece al lado izquierdo de cada nombre.","pinned":false,"hidden":false,"mode":"md"},{"id":1054,"value":"viewof selectedState = Inputs.table(totalsJoined, { layout: \"auto\" })","pinned":false,"hidden":false,"mode":"ojs"},{"id":512,"value":"**${filteredData.numRows().toLocaleString()} resultados, ${(filteredData.numRows() / dt.numRows()).toLocaleString(undefined, { style: \"percent\"})} de todos los municipios.**","pinned":false,"hidden":false,"mode":"md"},{"id":28,"value":"Longbox(filteredData, {\n itemHeight,\n height: itemHeight * 5,\n render: item => render(item, timeChunk)\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1212,"value":"*** \n\n## Notas\n\n* El cálculo de **población per cápita** (que aparece en la tabla como \"Per 100k\"), utiliza los estimados de población a 2015 de [CONAPO](https://www.gob.mx/conapo/acciones-y-programas/conciliacion-demografica-de-mexico-1950-2015-y-proyecciones-de-la-poblacion-de-mexico-y-de-las-entidades-federativas-2016-2050). Estos estimados no son perfectos y no coinciden al 100% con el intervalo de tiempo que abarca la base de datos. Para nuestros propósitos, ofrecen una **escala aproximada** desde la perspectiva del pasado reciente. Si quieres hacer un análisis en el futuro, recomendamos obtener o generar estimaciones año por año y datos de censo anteriores a 2015. Los datos de los censos 2010 y 2020 están disponibles en nuestra API para quienes tengan interés en hacer el comparativo.\n\n* Estas visualizaciones abarcan los casos reportados entre 2006 y 2018.\n\n* Los casos que en la base Cenapi no presentan municipio no se visualizan. \n\n*** ","pinned":false,"hidden":false,"mode":"md"},{"id":1077,"value":"totalsJoined = totals //.join(filtered_totals, \"nom_ent\").rename({\n// disappearance_ct_1: \"disappearance_total\",\n// status_alive_ct_1: \"alive_total\",\n// status_dead_ct_1: \"dead_total\",\n// status_not_found_ct_1: \"notfound_total\",\n// disappearance_ct_2: \"disappearance_filtered\",\n// status_alive_ct_2: \"alive_filtered\",\n// status_dead_ct_2: \"dead_filtered\",\n// status_not_found_ct_2: \"notfound_filtered\",\n// })\n.orderby(aq.desc(\"disappearance_ct\"))","pinned":false,"hidden":false,"mode":"ojs"},{"id":1102,"value":"selectedNames = selectedState.map(d => d.nom_ent)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1049,"value":"filtered_totals = filteredAllData.groupby(\"nom_ent\").rollup({\n disappearance_ct: aq.op.sum(\"disappearance_ct\"),\n status_alive_ct: aq.op.sum(\"status_alive_ct\"),\n status_dead_ct: aq.op.sum(\"status_dead_ct\"),\n status_not_found_ct: aq.op.sum(\"status_not_found_ct\"),\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1047,"value":"totals = dt.groupby(\"nom_ent\").rollup({\n disappearance_ct: aq.op.sum(\"disappearance_ct\"),\n status_alive_ct: aq.op.sum(\"status_alive_ct\"),\n status_dead_ct: aq.op.sum(\"status_dead_ct\"),\n status_not_found_ct: aq.op.sum(\"status_not_found_ct\"),\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":917,"value":"filteredData = filteredAllData.params({selectedNames})\n .filter(d => \n aq.op.includes(selectedNames, d.nom_ent)\n )\n .orderby(\n aq.desc(sortKey.col)\n )","pinned":false,"hidden":false,"mode":"ojs"},{"id":1058,"value":"filteredAllData = dt.params({pobMin, pobMax, minCasos})\n .filter(d => \n (d.census.length && d.census[0].sum >= pobMin && d.census[0].sum <= pobMax)\n &&\n d.disappearance_ct >= minCasos\n )\n .orderby(\n aq.desc(sortKey.col)\n )","pinned":false,"hidden":false,"mode":"ojs"},{"id":103,"value":"function render(item) {\n const aggregate = item[`${reporteOEvento.prefix}years_aggregate`];\n const total = parseInt(aggregate.aggregate.sum.disappearance_ct);\n const census = item.census ? item.census[0].sum.toLocaleString() : \"Undefined\";\n \n return html`\n

\n ${item.nom_mun}, ${item.nom_ent}\n

${census} pob. est.

\n ${getMap(item)}\n

${total.toLocaleString()} total

\n ${totalsTable(item)}\n

\n ${chartType === \"Sexo\" ? html`\n

\n ${plotGender(item)}\n

` : html`\n

\n ${plotStatus(item)}\n

`}\n

`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":299,"value":"plotSize = ({\n width: itemHeight * .85,\n height: itemHeight - 50,\n marginTop: 30,\n marginLeft: 40,\n marginBottom: 40,\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":539,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":239,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":233,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":161,"value":"itemHeight = 240","pinned":false,"hidden":false,"mode":"ojs"},{"id":366,"value":"","pinned":false,"hidden":false,"mode":"html"},{"id":47,"value":"getMap = (item) => {\n const { path, projection, geom, nom_ent, mapSVG } = choropleths.find(d => d.nom_ent === item.nom_ent);\n\n const svg = mapSVG.clone(true);\n \n svg\n .append(\"path\")\n .attr(\"stroke\", colors.localizado_con_vida)\n .attr(\"stroke-width\", 2.2)\n .attr(\"fill\", \"none\")\n // .attr(\"shape-rendering\", \"geometricPrecision\")\n .attr(\"d\", path(item.geom))\n\n return svg.node();\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":42,"value":"mapSize = 120","pinned":false,"hidden":false,"mode":"ojs"},{"id":789,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":910,"value":"$34","pinned":false,"hidden":false,"mode":"ojs"},{"id":22,"value":"$35","pinned":false,"hidden":false,"mode":"ojs"},{"id":356,"value":"nombresDeEstados = [\"Todos\", ...estadoData.estados.map(d => d.nom_ent).sort(d3.ascending)]","pinned":false,"hidden":false,"mode":"ojs"},{"id":17,"value":"estadoData = graphql({\n operationName: 'EstadoQuery',\n query: `\nquery EstadoQuery {\n estados: views_estatales {\n nom_ent\n geom: geom_simple\n }\n}\n`})","pinned":false,"hidden":false,"mode":"ojs"},{"id":6,"value":"import { Longbox } from \"@eads/longbox\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":14,"value":"import {graphql} from \"@adonde/data-utils\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":721,"value":"import { colors, schemeGrayscale } from \"@adonde/graficos-fonts-colores\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":34,"value":"d3 = require(\"d3\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":57,"value":"$36","pinned":true,"hidden":false,"mode":"html"}],"files":"$W37","stdlib":"1","titling":"auto"}