2a:null 2b:["$","title",null,{"children":"RNPNDO - Explorador de municipios | quintoelab | Observable"}] 30:T4dd,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); console.log(muniData) const max_count = d3.max(muniData, m => m.rnpndo_aggregate.aggregate.sum.desapariciones); 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.rnpndo_aggregate.aggregate.sum.desapariciones)) .attr("d", m => path(m.geom)) return { mapSVG, path, projection, ...d } })31:T5c0, 32:[] 2e:{"id":"b4965cc396c266b3","slug":"rnpndo-explorador-de-municipios","title":"RNPNDO - Explorador de municipios","thumbnail":"9be03d52ae3a4d9e2b59d336a5f43f530a1a8262ff017ecb019d18f38f0cb9c8","access_level":"public","create_time":"$D2022-04-22T04:13:47.131Z","update_time":"$D2022-11-11T21:45:23.798Z","view_time":null,"first_public_time":"$D2022-05-13T01:09:25.712Z","has_unpublished_edits":null,"fork":{"id":"db1cee41cdb0b703","slug":"tabla-municipios","title":"Cenapi-PGR-Explorador por municipio","owner":{"id":"8ecf893159388c3a","login":"quintoelab","name":""}},"stars":2,"starred":false,"owner":{"type":"team","id":"8ecf893159388c3a","login":"quintoelab","name":"","avatar_url":"https://avatars-next.observableusercontent.com/b803a06bc4f1144429bdf5c0e85eb873a3abaa561c281a6f800e0f338420140a","tier":"pro_2024"},"version":1460,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"69810cd3cf4bf30c","login":"eads","name":"David Eads","avatar_url":"https://avatars-next.observableusercontent.com/ed73f86cbd46170a17e3bb2a06a1939ef04e5dc379b856148b769d7ac41ab78b","tier":null}],"members":[{"type":"individual","id":"69810cd3cf4bf30c","login":"eads","name":"David Eads","avatar_url":"https://avatars-next.observableusercontent.com/ed73f86cbd46170a17e3bb2a06a1939ef04e5dc379b856148b769d7ac41ab78b","tier":null,"role":"editor"},{"type":"team","id":"8ecf893159388c3a","login":"quintoelab","name":"","avatar_url":"https://avatars-next.observableusercontent.com/b803a06bc4f1144429bdf5c0e85eb873a3abaa561c281a6f800e0f338420140a","tier":"pro_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"a992fa36b34b22a3","slug":"datos-publicos","title":"Fragmentos de la desaparición","owner":{"id":"8ecf893159388c3a","login":"quintoelab","name":""}},"type":"notebook","body":{"titling":"auto","title":"RNPNDO - Explorador de municipios","cells":[{"id":0,"value":"# RNPNDO - Explorador de municipios\n\nEn este cuaderno se pueden explorar los datos de personas desaparecidas por municipio entre 2006 y febrero de 2022. La fuente de la información es el Registro Nacional de Personas Desaparecidas y No Localizadas (RNPDNO).\n\nSe recomienda utilizar las opciones disponibles para delimitar la búsqueda por estado y rango de población estimada. Es posible que los datos tomen algún tiempo para cargar.\n\nInvitamos a la audiencia a ser cuidadosos al leer las visualizaciones; los datos faltantes pueden ser ambiguos. Por ejemplo, un cero no siempre significa cero pero parece tal por el tamaño de la gráfica.\n\n_Nota: Estas visualizaciones abarcan los datos de personas desaparecidas entre 2006 y febrero de 2022. No se incluyen aquellos casos (14,459) en los que el RNPDNO no especifica el año de desaparición._","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1197,"value":"**Filtra los municipios por:**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"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: 0,\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1159,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1206,"value":"Filtra por estado seleccionando el recuadro que aparece al lado izquierdo de cada nombre.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1054,"value":"viewof selectedState = Inputs.table(totalsJoined, { layout: \"auto\" })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":512,"value":"**${filteredData.numRows().toLocaleString()} resultados.**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":28,"value":"Longbox(filteredData, {\n itemHeight,\n height: itemHeight * 3,\n render: item => render(item)\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":761,"value":"sortKey = \n ({\n col: \"reportes\",\n label: \"# de reportes\",\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1077,"value":"totalsJoined = totals.orderby(aq.desc(\"desapariciones\"))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1102,"value":"selectedNames = selectedState.map(d => d.nom_ent)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1049,"value":"filtered_totals = filteredAllData.groupby(\"nom_ent\").rollup({\n desapariciones: aq.op.sum(\"desapariciones\"),\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1047,"value":"totals = dt.groupby(\"nom_ent\").rollup({\n desapariciones: aq.op.sum(\"desapariciones\"),\n hombres: aq.op.sum(\"hombres_mun\"),\n mujeres: aq.op.sum(\"mujeres_mun\"),\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":917,"value":"filteredData = filteredAllData.params({selectedNames})\n .filter(d => \n aq.op.includes(selectedNames, d.nom_ent)\n )\n .orderby(aq.desc(\"desapariciones\"))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1459,"value":"filteredData.objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1058,"value":"filteredAllData = dt.params({pobMin, pobMax})\n .filter(d => \n (d.census.length && d.census[0].sum >= pobMin && d.census[0].sum <= pobMax)\n )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1257,"value":"Inputs.table(filteredAllData)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":103,"value":"function render(item) {\n const total = item.desapariciones;\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 ${plotGender(item)}\n

`\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":299,"value":"plot_size = ({\n width: itemHeight * .85,\n height: itemHeight - 100,\n marginTop: 30,\n marginLeft: 40,\n marginBottom: 40,\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1417,"value":"colors","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":239,"value":"function plotGender(item) {\n const data = item.rnpndo_ano_rollup;\n return Plot.plot({\n ...plot_size,\n width: itemHeight * 1.6,\n color: {\n legend: true,\n domain: [\"mujeres\", \"hombres\", \"indeterminado\"],\n range: [colors.femenino, colors.masculino, colors.localizado_con_vida],\n },\n x: {\n type: \"band\",\n ticks: [2006, 2010, 2014, 2018, 2022],\n domain: d3.range(2006, 2023),\n },\n y: {\n domain: [0, (item.rnpndo_ano_max > 30 ? item.rnpndo_ano_max : 30)],\n nice: true,\n },\n marks: [\n Plot.barY(data, {\n x: \"fecha_ano\",\n y: \"value\",\n fill: \"key\",\n }),\n ]\n }) \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":233,"value":"function totalsTable(item) {\n const data = [\n {\n key: \"Hombres\",\n total: item.hombres_mun,\n pct: item.hombres_mun / item.desapariciones,\n },\n {\n key: \"Mujeres\",\n total: item.mujeres_mun,\n pct: item.mujeres_mun / item.desapariciones,\n },\n {\n key: \"Indeterminado\",\n total: item.indeterminado_mun,\n pct: item.indeterminado_mun / item.desapariciones,\n },\n ];\n\n\n return html`\n \n \n \n \n \n \n \n \n ${data.map(row => html`\n \n \n \n `)}\n \n

Sexo	Total	Pct
${row.key}	${row.total.toLocaleString()}	${row.pct.toLocaleString(undefined, { style: \"percent\"})}

`\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":161,"value":"itemHeight = 260","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":366,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":42,"value":"mapSize = 120","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":789,"value":"$30","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":910,"value":"dt = aq.from(prerollData).derive({\n pob: item => item.census[0] ? item.census[0].sum : 0,\n desapariciones: item => item.rnpndo_aggregate.aggregate.sum.desapariciones,\n hombres_mun: item => item.rnpndo_aggregate.aggregate.sum.hombres_mun,\n mujeres_mun: item => item.rnpndo_aggregate.aggregate.sum.mujeres_mun,\n indeterminado_mun: item => item.rnpndo_aggregate.aggregate.sum.indeterminado_mun,\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1359,"value":"prerollData = dataQuery.views_municipales.map(d => {\n const data = aq.from(d.rnpndo);\n const rnpndo_ano_rollup = data.groupby(\"fecha_ano\").rollup({\n desapariciones: aq.op.sum(\"desapariciones\"),\n hombres: aq.op.sum(\"hombres_mun\"),\n mujeres: aq.op.sum(\"mujeres_mun\"),\n indeterminado: aq.op.sum(\"indeterminado_mun\"),\n }).fold([\"hombres\", \"mujeres\", \"indeterminado\"]);\n const rnpndo_ano_max = rnpndo_ano_rollup.rollup({max: aq.op.max(\"desapariciones\")}).get(\"max\");\n\n \n return {\n ...d,\n rnpndo_ano_rollup,\n rnpndo_ano_max,\n };\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":22,"value":"dataQuery = graphql({\n operationName: 'MunicipioQuery',\n query: `query MunicipioQuery {\n views_municipales(where: {rnpndo: {cod_inegi: {_is_null: false}}}) {\n cve_geoid\n nom_ent\n nom_mun\n geom: geom_simple\n centroid_geom\n census(where: {ano: {_eq: 2015}}) {\n ano\n sum\n }\n rnpndo(order_by: {fecha: asc}) {\n fecha\n fecha_ano\n fecha_mes\n desapariciones:reportes\n hombres_mun\n mujeres_mun\n indeterminado_mun\n }\n rnpndo_aggregate {\n aggregate {\n sum {\n desapariciones:reportes\n hombres_mun\n mujeres_mun\n indeterminado_mun\n }\n }\n }\n }\n }`\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":356,"value":"nombresDeEstados = [\"Todos\", ...estadoData.estados.map(d => d.nom_ent).sort(d3.ascending)]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"import { Longbox } from \"@eads/longbox\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"import {graphql} from \"@adonde/data-utils\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":721,"value":"import { colors, schemeGrayscale } from \"@adonde/graficos-fonts-colores\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":34,"value":"d3 = require(\"d3\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":57,"value":"$31","pinned":true,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W32","stdlib":"1"}} 2f:"$2e:body"