2c:null 2d:["$","title",null,{"children":"Estadísticas delictuales por comuna en Chile | Ernesto Laval | Observable"}] 32:T4fc,De la página del CEAD, exporté datos correspondiente a la Tasa cada 100.000 habitantes para los delitos de Mayor Connotación Social, para cada una de las comunas de Chile y en cada uno de los años disponibles (2005 a 2023). El tipo de datos utilizados son **Casos Policiales**. *"Es el indicador utilizado para analizar la ocurrencia de hechos delictivos. Considera las denuncias de delitos que realiza la comunidad en las unidades policiales, más las detenciones que realizan las policías ante la ocurrencia de delitos flagrantes. Internacionalmente este indicador es conocido como “delitos conocidos por la policía” (crimes known to police). Esta información está disponible desde el año 2005." (CEAD)* Para comunas con baja población, cada delito puede significar una cifra muy alta en la tasa cada 100 mil habitantes. Por ejemplo en la comuna de Cabo de Hornos (aprox. 2000 mil habitantes), un delito de homicidio en 2022 genera una tasa de 50 homicidios cada 100 mil habitantes (los casos aislados, pueden generar distorsiones en el análisis). Para evitar las distorsiones en los datos que se producen en comunas pequeñas, seleccioné a las comunas con sobre 100 mil habitantes (pudo haber sido otro umbral) entre las opciones del siguiente selector:33:T458,{ const data = dataPlot.map((d) => { const record = {}; record.localidad = d.localidad; record.delito = d.delito; record[rangoComparacion()] = d3.format(".1f")(d.tasaComparacion); record[rangoReferencia()] = d3.format(".1f")(d.tasaReferencia); return record; }); return html` ${dataPlot.map( (car) => htl.html`` )}

Fuente: Centro de Estudios y Análisis del Delito (CEAD), Subsecretaría de Prevención del Delito. https://cead.spd.gov.cl/estadisticas-delictuales/
Comuna	Delito	${rangoComparacion()} (Tasa cada 100 mil habs)	${rangoReferencia()} (Tasa cada 100 mil habs)
${car["localidad"]}	${car["delito"]}	${d3.format(".1f")( car["tasaComparacion"] )}	${d3.format(".1f")( car["tasaReferencia"] )}

`; }34:Tb6e,{ esCL; const maxValue = _.chain(dataPlot) .map((d) => _.max([d.tasaComparacion, d.tasaReferencia])) .max() .value(); const minValue = _.chain(dataPlot) .map((d) => _.min([d.tasaComparacion, d.tasaReferencia])) .min() .value(); return Plot.plot({ style: { fontSize: 13 }, title: `Tasa de delitos en ${localidadSeleccionada}: ${rangoComparacion()} vs ${rangoReferencia()} (Casos Policiales)`, marginLeft: 300, marginRight: 100, marginBottom: 50, width: width, height: 500, caption: `Fuente: Centro de Estudios y Análisis del Delito (CEAD), Subsecretaría de Prevención del Delito. \n https://cead.spd.gov.cl/estadisticas-delictuales/`, x: { type: "linear", domain: [-maxValue / 10, maxValue], tickFormat: (d) => (d >= 0 ? d : ""), grid: true, label: "Tasa cada 100 mil habitantes" }, y: { label: "Delito" }, color: { legend: true, domain: [rangoReferencia(), rangoComparacion()], range: esquemaDeColores }, marks: [ Plot.ruleY(dataPlot, { y: "delito", x1: "tasaComparacion", x2: "tasaReferencia", strokeWidth: 3, stroke: "grey" }), Plot.dot(dataPlot, { y: "delito", x: "tasaComparacion", fill: (d) => rangoComparacion() }), Plot.dot(dataPlot, { y: "delito", x: "tasaReferencia", fill: (d) => rangoReferencia() }), Plot.text( dataPlot.filter((d) => d.tasaReferencia > d.tasaComparacion), { y: "delito", x: "tasaReferencia", dx: 5, text: (d) => `${d3.format(".1f")(d.tasaReferencia)}\n${rangoReferencia()}`, textAnchor: "start", fill: (d) => rangoReferencia() } ), Plot.text( dataPlot.filter((d) => d.tasaReferencia <= d.tasaComparacion), { y: "delito", x: "tasaReferencia", dx: -5, text: (d) => `${d3.format(".1f")(d.tasaReferencia)}\n${rangoReferencia()}`, textAnchor: "end", fill: (d) => rangoReferencia() } ), Plot.text( dataPlot.filter((d) => d.tasaReferencia > d.tasaComparacion), { y: "delito", x: "tasaComparacion", dx: -5, text: (d) => `${d3.format(".1f")(d.tasaComparacion)}\n${rangoComparacion()}`, textAnchor: "end", fill: (d) => rangoComparacion() } ), Plot.text( dataPlot.filter((d) => d.tasaReferencia <= d.tasaComparacion), { y: "delito", x: "tasaComparacion", dx: 5, text: (d) => `${d3.format(".1f")(d.tasaComparacion)}\n${rangoComparacion()}`, textAnchor: "start", fill: (d) => rangoComparacion() } ) ] }); }35:Tb97,{ esCL; const maxValue = _.chain(dataPlot) .map((d) => _.max([d.tasaComparacion, d.tasaReferencia])) .max() .value(); const minValue = _.chain(dataPlot) .map((d) => _.min([d.tasaComparacion, d.tasaReferencia])) .min() .value(); return Plot.plot({ //style: { fontSize: 14 }, title: `Tasa de delitos en ${localidadSeleccionada}: ${rangoComparacion()} vs ${rangoReferencia()} (Casos Policiales)`, marginLeft: 250, marginRight: 70, marginBottom: 50, width: width, height: 500, caption: `Fuente: Centro de Estudios y Análisis del Delito (CEAD), Subsecretaría de Prevención del Delito. \n https://cead.spd.gov.cl/estadisticas-delictuales/`, x: { type: "log", domain: [minValue / 2, maxValue], tickFormat: (d) => (d >= 0 ? d : ""), grid: true, label: "Tasa cada 100 mil habitantes (escala logarítmica)", tickRotate: 90 }, y: { label: "Delito" }, color: { legend: true, domain: [rangoReferencia(), rangoComparacion()], range: esquemaDeColores }, marks: [ Plot.ruleY(dataPlot, { y: "delito", x1: "tasaComparacion", x2: "tasaReferencia", strokeWidth: 3, stroke: "grey" }), Plot.dot(dataPlot, { y: "delito", x: "tasaComparacion", fill: (d) => rangoComparacion() }), Plot.dot(dataPlot, { y: "delito", x: "tasaReferencia", fill: (d) => rangoReferencia() }), Plot.text( dataPlot.filter((d) => d.tasaReferencia > d.tasaComparacion), { y: "delito", x: "tasaReferencia", dx: 5, text: (d) => `${d3.format(".1f")(d.tasaReferencia)}\n${rangoReferencia()}`, textAnchor: "start", fill: (d) => rangoReferencia() } ), Plot.text( dataPlot.filter((d) => d.tasaReferencia <= d.tasaComparacion), { y: "delito", x: "tasaReferencia", dx: -5, text: (d) => `${d3.format(".1f")(d.tasaReferencia)}\n${rangoReferencia()}`, textAnchor: "end", fill: (d) => rangoReferencia() } ), Plot.text( dataPlot.filter((d) => d.tasaReferencia > d.tasaComparacion), { y: "delito", x: "tasaComparacion", dx: -5, text: (d) => `${d3.format(".1f")(d.tasaComparacion)}\n${rangoComparacion()}`, textAnchor: "end", fill: (d) => rangoComparacion() } ), Plot.text( dataPlot.filter((d) => d.tasaReferencia <= d.tasaComparacion), { y: "delito", x: "tasaComparacion", dx: 5, text: (d) => `${d3.format(".1f")(d.tasaComparacion)}\n${rangoComparacion()}`, textAnchor: "start", fill: (d) => rangoComparacion() } ) ] }); }36:T40b,{ const dataPlot = data.filter( (d) => d.localidad == localidadSeleccionada && d.delito == delitoSeleccionado ); return Plot.plot({ marginTop: 50, x: { grid: true, type: "point" }, y: { label: "Tasa cada 100 mil habitantes", grid: true }, title: `Causas Policiales para ${delitoSeleccionado} en ${localidadSeleccionada} (tasa cada 100 mil habitantes)`, caption: `Fuente: Centro de Estudios y Análisis del Delito (CEAD), Subsecretaría de Prevención del Delito. \n https://cead.spd.gov.cl/estadisticas-delictuales/`, marks: [ Plot.ruleY([0]), Plot.lineY(dataPlot, { x: "año", y: "valor", stroke: "delito" }), Plot.dot(dataPlot, { x: "año", y: "valor", fill: "delito" }), Plot.text( dataPlot, { x: "año", y: "valor", dy: -10, text: (d) => d3.format(".1f")(d.valor) } ), Plot.linearRegressionY(dataPlot, { x: "año", y: "valor", stroke: "grey" }) ] }); }37:T427,# ¿Cómo obtuve los datos? A contibuación describo los pasos seguidos para descargar los datos desde la página del CEAD. En la página de [Estadisticas Delictuales](https://cead.spd.gov.cl/estadisticas-delictuales/) seleccione "Estadísticas por Unidad Territorial" y luego las siguientes opciones: * Tasa Cada 100.000 habitantes * Tipo de Datos: Casos Policiales * Unidad Territorial: seleccioné cada una de las comunas * Delito * Grupo Delictual: Delitos de mayor connotación social * Delitos: Seleccioné uno de los delitos (ej Homicidios). Luego de obtener y exportar los datos, se debe repetir el proceso para cada uni de los delitos (Homicidios; Hurtos; Lesiones leves; Lesiones menos graves, graves o gravísimas; Otros robos con fuerza; Robo con violencia o intimidación; Robo de objetos de o desde vehículo; Robo de vehículo motorizado; Robo en lugar habitado; Robo en lugar no habitado; Robo por sorpresa; Violaciones) * Temporalidad: seleccioné cada uno de los años disponibles ![image.png](${await FileAttachment("image.png").url()}) 38:T587,planillasFuente = [ await FileAttachment( "Homicidios - reportesEstadisticos-unidadTerritorial 2@1.xlsx" ).xlsx(), await FileAttachment( "Hurtos - reportesEstadisticos-unidadTerritorial 2@1.xlsx" ).xlsx(), await FileAttachment( "Lesiones leves - reportesEstadisticos-unidadTerritorial 2@1.xlsx" ).xlsx(), await FileAttachment( "Lesiones menos graves, graves o gravísimas - reportesEstadisticos-unidadTerritorial 2@1.xlsx" ).xlsx(), await FileAttachment( "Otros robos con fuerza - reportesEstadisticos-unidadTerritorial 2@1.xlsx" ).xlsx(), await FileAttachment( "Robo con violencia o intimidación - reportesEstadisticos-unidadTerritorial 2@1.xlsx" ).xlsx(), await FileAttachment( "Robo de objetos de o desde vehículo - reportesEstadisticos-unidadTerritorial 2@1.xlsx" ).xlsx(), await FileAttachment( "Robo de vehículo motorizado - reportesEstadisticos-unidadTerritorial 2@1.xlsx" ).xlsx(), await FileAttachment( "Robo en lugar habitado - reportesEstadisticos-unidadTerritorial 3@1.xlsx" ).xlsx(), await FileAttachment( "Robo en lugar no habitado - reportesEstadisticos-unidadTerritorial 2@1.xlsx" ).xlsx(), await FileAttachment( "Robo por sorpresa - reportesEstadisticos-unidadTerritorial 2@1.xlsx" ).xlsx(), await FileAttachment( "Violaciones - reportesEstadisticos-unidadTerritorial 3@1.Xl se.xlsx" ).xlsx() ]39:[{"id":"2d42f9784f1044e7c0572ad927c9b990fe3f0cfd885f2d884d687f40d5c1d6bec6f8ca436cd5efdf1cb5af43ca56d1fc5dfe6d87deb2631e0fed6cb3d2422da8","href":"https://static.observableusercontent.com/files/2d42f9784f1044e7c0572ad927c9b990fe3f0cfd885f2d884d687f40d5c1d6bec6f8ca436cd5efdf1cb5af43ca56d1fc5dfe6d87deb2631e0fed6cb3d2422da8","name":"Homicidios - reportesEstadisticos-unidadTerritorial 2@1.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1710764452205.634,"size":90698},{"id":"263972f695d65fbe8b9f20ce1f97bf8c38b314f6579bb3894044570d50c43c0464795f79fed802bce405135c89809f2fcc959cd64d4ebe9fdeee005432ac4d5f","href":"https://static.observableusercontent.com/files/263972f695d65fbe8b9f20ce1f97bf8c38b314f6579bb3894044570d50c43c0464795f79fed802bce405135c89809f2fcc959cd64d4ebe9fdeee005432ac4d5f","name":"Robo de objetos de o desde vehículo - reportesEstadisticos-unidadTerritorial 2@1.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1710766744020.965,"size":120398},{"id":"1f3c718ddc2080dffe5500fca2cc1f85be82ed0b830e1dfddfd72df4725c1339a684c48d5293eb8f5f5e69a115ce3b5d0f1bf93e938cfe2222f215e8784c6247","href":"https://static.observableusercontent.com/files/1f3c718ddc2080dffe5500fca2cc1f85be82ed0b830e1dfddfd72df4725c1339a684c48d5293eb8f5f5e69a115ce3b5d0f1bf93e938cfe2222f215e8784c6247","name":"Violaciones - reportesEstadisticos-unidadTerritorial 3@1.Xl se.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1710766743601.629,"size":112908},{"id":"558b9376be8aa782557da8ecf1b302b5e60aa21ae0ec1b18fde5ee58f6a23c73fb4db176c55dabf51e212d76ecfdea1767a8417d099bef232c8c3d28cceee208","href":"https://static.observableusercontent.com/files/558b9376be8aa782557da8ecf1b302b5e60aa21ae0ec1b18fde5ee58f6a23c73fb4db176c55dabf51e212d76ecfdea1767a8417d099bef232c8c3d28cceee208","name":"Otros robos con fuerza - reportesEstadisticos-unidadTerritorial 2@1.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1710766744033.929,"size":112298},{"id":"823dfed3a7984975cb1cf0fdffa80b72ef3a7f44ea3e6ac2faedb252e710793491f5aae07b600dff7bf3d0159ec82b198999ce6cf8421866d052b92043d9c2e7","href":"https://static.observableusercontent.com/files/823dfed3a7984975cb1cf0fdffa80b72ef3a7f44ea3e6ac2faedb252e710793491f5aae07b600dff7bf3d0159ec82b198999ce6cf8421866d052b92043d9c2e7","name":"Lesiones menos graves, graves o gravísimas - reportesEstadisticos-unidadTerritorial 2@1.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1710766743702.8,"size":125375},{"id":"34009a1cee872d0a66b3e83a2c81a0cff9487f187656f3dec9b4ddcf737ad7ffebf1043d9728ce9fe275cabefa49a3d59376b09abafde201e296bc946bb4eefe","href":"https://static.observableusercontent.com/files/34009a1cee872d0a66b3e83a2c81a0cff9487f187656f3dec9b4ddcf737ad7ffebf1043d9728ce9fe275cabefa49a3d59376b09abafde201e296bc946bb4eefe","name":"Robo con violencia o intimidación - reportesEstadisticos-unidadTerritorial 2@1.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1710766744027.851,"size":121225},{"id":"e8f267e37adf19e86105e542fa26d7634e2925150e5c231ef3a307072d67725af1ad8708f195802cff616820c6919c1c048081eb5eb195d583896d2303d21f72","href":"https://static.observableusercontent.com/files/e8f267e37adf19e86105e542fa26d7634e2925150e5c231ef3a307072d67725af1ad8708f195802cff616820c6919c1c048081eb5eb195d583896d2303d21f72","name":"Robo de vehículo motorizado - reportesEstadisticos-unidadTerritorial 2@1.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1710766744059.968,"size":111846},{"id":"d31abcc403a8840d691bf9389dca673ea1be64a38a6da724e502b8598cf5382f1126dcc3cd40a32bbe834bf8f0822919f2bfbe46dfc185ac3a8287a886c4ac14","href":"https://static.observableusercontent.com/files/d31abcc403a8840d691bf9389dca673ea1be64a38a6da724e502b8598cf5382f1126dcc3cd40a32bbe834bf8f0822919f2bfbe46dfc185ac3a8287a886c4ac14","name":"Robo en lugar no habitado - reportesEstadisticos-unidadTerritorial 2@1.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1710766744064.194,"size":126007},{"id":"087b73efddeca5e3e603f857815aa19121a53cc66726645589d275adfd8eef94235750127082637a66b5b7ee2da8d1fae9b75a8b921596208d7864ee18c5e670","href":"https://static.observableusercontent.com/files/087b73efddeca5e3e603f857815aa19121a53cc66726645589d275adfd8eef94235750127082637a66b5b7ee2da8d1fae9b75a8b921596208d7864ee18c5e670","name":"Robo por sorpresa - reportesEstadisticos-unidadTerritorial 2@1.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1710766744065.353,"size":110439},{"id":"d7e5fc55876203f30bb219af753c58d6f56bfc54c4b1947c97dd5489d6c26f7ae7170412f66ca6643d12c6d62c21a5281a160285377847e2a6fe94621b64bf75","href":"https://static.observableusercontent.com/files/d7e5fc55876203f30bb219af753c58d6f56bfc54c4b1947c97dd5489d6c26f7ae7170412f66ca6643d12c6d62c21a5281a160285377847e2a6fe94621b64bf75","name":"Robo en lugar habitado - reportesEstadisticos-unidadTerritorial 3@1.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1710766744084.194,"size":126671},{"id":"0733abc406bb858cd77b0ea9b342a2991132090622844e4cc28629eaf1489669a27b95cf7f9a2450846cbdae0a83706d6673464cf5be8f2bc87d99010e3d0b89","href":"https://static.observableusercontent.com/files/0733abc406bb858cd77b0ea9b342a2991132090622844e4cc28629eaf1489669a27b95cf7f9a2450846cbdae0a83706d6673464cf5be8f2bc87d99010e3d0b89","name":"Lesiones leves - reportesEstadisticos-unidadTerritorial 2@1.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1710766744087.528,"size":128547},{"id":"24f4983e7ddaf0f916e8bcf09dc067becd51c5946b14997a7b6ae53dc9bd5948ef80b2456e3d3fb03b7fbecd5841ed50ab55c3d006f6f89f5d4d5ec1fb8fd152","href":"https://static.observableusercontent.com/files/24f4983e7ddaf0f916e8bcf09dc067becd51c5946b14997a7b6ae53dc9bd5948ef80b2456e3d3fb03b7fbecd5841ed50ab55c3d006f6f89f5d4d5ec1fb8fd152","name":"Hurtos - reportesEstadisticos-unidadTerritorial 2@1.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1710766744095.531,"size":130387},{"id":"23b3d64e27e95ea1018985a7ea4821d668f69d714ef24e37b9a383e5d8f60c4a2f9e400c1e3f92e7abb15449b2f5e7b654e984197fd4060e70fc57a8989cf120","href":"https://static.observableusercontent.com/files/23b3d64e27e95ea1018985a7ea4821d668f69d714ef24e37b9a383e5d8f60c4a2f9e400c1e3f92e7abb15449b2f5e7b654e984197fd4060e70fc57a8989cf120","name":"image.png","type":"image/png","lastModified":1710789219937.794,"size":246370},{"id":"038320fd3b62a23f45b348586c0bb3a2583abb24b7b9018d8d02fe02729920f6f46e949d8f8c0cd968abc22cedc3e678150abf16d29e4b60e7406f0452802cf8","href":"https://static.observableusercontent.com/files/038320fd3b62a23f45b348586c0bb3a2583abb24b7b9018d8d02fe02729920f6f46e949d8f8c0cd968abc22cedc3e678150abf16d29e4b60e7406f0452802cf8","name":"image@1.png","type":"image/png","lastModified":1710790886314.866,"size":319574},{"id":"4a34f6756b7780028ae1543c77552007054e317a35dcf67616636f8f05d7a82ce654eb086e2d5dc6775d8786e37f4f9d0e785b953cb9c0e2923dfd87fdade539","href":"https://static.observableusercontent.com/files/4a34f6756b7780028ae1543c77552007054e317a35dcf67616636f8f05d7a82ce654eb086e2d5dc6775d8786e37f4f9d0e785b953cb9c0e2923dfd87fdade539","name":"image@3.png","type":"image/png","lastModified":1710791034313.952,"size":124264},{"id":"1b510fc01a180d2a92578ee55470ffb932c4889ade51f69d6ad50e467977ac180b5812becde75a88befaa4447bad7f14a46326ce3a56d6e87590276b54f3ad15","href":"https://static.observableusercontent.com/files/1b510fc01a180d2a92578ee55470ffb932c4889ade51f69d6ad50e467977ac180b5812becde75a88befaa4447bad7f14a46326ce3a56d6e87590276b54f3ad15","name":"image@4.png","type":"image/png","lastModified":1710791816741.357,"size":402174},{"id":"d04fe0d661fcbb73ba4b8471d06280100b83e9876b18e1fd556c729233ee2b7767f8f66a532fe29f6abf5a90ca62e2f90c2dc0b76cedc2b0003437f69c73918c","href":"https://static.observableusercontent.com/files/d04fe0d661fcbb73ba4b8471d06280100b83e9876b18e1fd556c729233ee2b7767f8f66a532fe29f6abf5a90ca62e2f90c2dc0b76cedc2b0003437f69c73918c","name":"image@5.png","type":"image/png","lastModified":1710800537223.796,"size":335271},{"id":"77b6c88b8b9203d1d05968eb53795ec14c5f0e004690968d5a1f5273de722867a178a18b0dc16ff8bcc3ee6bf13ca0bc41031487a58065316a0d604d47ad2958","href":"https://static.observableusercontent.com/files/77b6c88b8b9203d1d05968eb53795ec14c5f0e004690968d5a1f5273de722867a178a18b0dc16ff8bcc3ee6bf13ca0bc41031487a58065316a0d604d47ad2958","name":"Poblacion por comuna.tsv","type":"text/tab-separated-values","lastModified":1710800919867.021,"size":136606}] 30:{"id":"3243161c40930660","slug":"estadisticas-delictuales-por-comuna_fuente_cead","title":"Estadísticas delictuales por comuna en Chile","thumbnail":"cbdc2a757bf592bf97dfe870c2006090c8f3fbf2106fb8b0d4532194d9144f14","access_level":"public","create_time":"$D2024-03-18T11:22:53.016Z","update_time":"$D2024-03-19T20:43:14.253Z","view_time":null,"first_public_time":"$D2024-03-18T22:33:25.585Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"0843f5dc42ca68a0","login":"elaval","name":"Ernesto Laval","avatar_url":"https://avatars-next.observableusercontent.com/089f0414fc9025dadb05cc06d7a406bc9be10093187c46729cb4ba3a4098dc30","tier":"starter_2024"},"version":759,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"e04cd7b5f4351ae9","login":"elaval","name":"Ernesto Laval","avatar_url":"https://avatars-next.observableusercontent.com/089f0414fc9025dadb05cc06d7a406bc9be10093187c46729cb4ba3a4098dc30","tier":null}],"members":[{"type":"team","id":"0843f5dc42ca68a0","login":"elaval","name":"Ernesto Laval","avatar_url":"https://avatars-next.observableusercontent.com/089f0414fc9025dadb05cc06d7a406bc9be10093187c46729cb4ba3a4098dc30","tier":"starter_2024","role":"editor"},{"type":"individual","id":"e04cd7b5f4351ae9","login":"elaval","name":"Ernesto Laval","avatar_url":"https://avatars-next.observableusercontent.com/089f0414fc9025dadb05cc06d7a406bc9be10093187c46729cb4ba3a4098dc30","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Estadísticas delictuales por comuna en Chile","cells":[{"id":0,"value":"# Estadísticas delictuales por comuna en Chile\n## Delitos de Mayor Connotación Social (DMCS)\nEsta página utiliza datos publicados por el \"Centro de Estudios y Análisis del Delito (CEAD)\" de la Subsecretaría de Prevención del Delito [https://cead.spd.gov.cl/estadisticas-delictuales/](https://cead.spd.gov.cl/estadisticas-delictuales/)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":584,"value":"$32","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":41,"value":"viewof localidadSeleccionada = Inputs.select(\n _.chain(data)\n .map((d) => d.localidad)\n .uniq()\n .filter(\n (d) =>\n dictPoblacionINE[d.toLowerCase()] &&\n dictPoblacionINE[d.toLowerCase()][\"2023\"] &&\n dictPoblacionINE[d.toLowerCase()][\"2023\"] > 100000\n )\n .sort()\n .value(),\n {\n label: \"Comuna\",\n value: \"Temuco\",\n format: (d) =>\n `${d} (${d3.format(\",\")(\n dictPoblacionINE[d.toLowerCase()][2023]\n )} habs en 2023)`\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":661,"value":"*Mi intención original era explorar los datos de delitos en la comuna en la cual vivo (Temuco), pero el usuario puede seleccionar otras comunas (sobre 100 mil habs) de su interés*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":620,"value":"Para el análisis considero un año de referencia (${añoReferencia}) y otro de comparación (${añoComparacion}) y utilizo los datos de la tasa cada 100 mil habitantes para delitos ocurridos en ${ventanaAños} años en torno al respectivo punto de referencia / comparación. Se utilizan los datos del respectivo año y ${ventanaAños-1} año${ventanaAños-1 > 1 ? 's' : ''} previo${ventanaAños-1 > 1 ? 's' : ''}.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":632,"value":"## Tabla de datos: ${localidadSeleccionada}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":546,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":641,"value":"## Visualización de datos: tasas cada 100 mil habs en ${rangoComparacion()} vs ${rangoReferencia()}\nEsta visualización compara, para cada delito, los datos del período ${rangoReferencia()} y ${rangoComparacion()}.\n\nHay que notar que se pueden comparar las magnitudes de las respectivas tasas, pero se dificulta la comparación del porcentaje de crecimiento / reducción de cada una de ellas (ver siguiente visualización).\n\nPara aquellos delitos en que el dato de ${rangoReferencia()} se encuentra a la derecha, corresponde a un aumento en la respectiva tasa (y viceversa).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":302,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":693,"value":"## Visualización de datos: tasas cada 100 mil habs en ${rangoComparacion()} vs ${rangoReferencia()} \n## (CON ESCALA LOGARÍTIMCA)\nEsta visualización es similar a la anterior, pero en este caso las cifras correspondientes a tasas de delitos se representan utilizando una **escala logarítmica** en el eje X.\n\nUna de las ventajas de utilizar esta escala es que permite visualizar de manera más apropiada la relación entre las cifras de los respectivos años. Es decir, si la tasa de un delito aumentó al doble (ej de 5 a 10), la distancia que separa ambos puntos será la misma que para otro delito que también haya aumentado al doble (ej de 200 a 400) independiente de la magnitud de dichas tasas.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":230,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":700,"value":"## Evolucion a lo largo de los años de la tasa cada 100 mil habitantes para un determinado delito\nLa siguiente visualización muestra un gráfico de líneas con la Tasa anual de delitos cada 100 mil habitantes por año. Se sobrepone una línea de regresión lineal (con bandas de confianza al 95%). Esta línea permite ilustar una eventual \"tendencia\" a lo largo del tiempo (más información sobre esta línea de regresión [acá](https://observablehq.com/plot/marks/linear-regression) )","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":84,"value":"viewof delitoSeleccionado = Inputs.select(\n _.chain(data)\n .map((d) => d.delito)\n .uniq()\n .value(),\n { label: \"Delito\" }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":93,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":723,"value":"## Descarga de datos","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":728,"value":"Comparto la tabla de datos que construí, en base a los datos descargados del CEAD, con tasas cada 100 mil habitantes (por localidad, delito, año), integrando todas los delitos en un mismo archivo. Espero que pueda ser de utilidad a otras personas que quieran realizar un análisis con estos datos. Se puede descargar un archivo de texto con datos separados por tabuladores (tsv).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":721,"value":"DOM.download(\n new Blob([d3.tsvFormat(data)], { type: \"application/text\" }),\n \"Tasas de causas policiales por comuna y año (CEAD).tsv\",\n \"Descargar: 'Tasas de causas policiales por comuna y año (CEAD).tsv'\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":725,"value":"image5 = FileAttachment(\"image@5.png\").image()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":586,"value":"$37","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":596,"value":"Luego de solicitar \"Buscar\", se obtiene en pantalla una tabla con la \"Tasa cada 100.000 habitantes\" para el delito seleccionado en cada una de las comunas y cada uno de los años:\n\n![image@1.png](${await FileAttachment(\"image@1.png\").url()})","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":600,"value":"La tabla de datos se puede exportar como un archivo Excel (esto se debe realizar para cada uno de los delitos) \n\n![image@3.png](${await FileAttachment(\"image@3.png\").url()})\n\nLa planilla exportada, junto con las correspondientes a otros delitos, es el insumo de datos para esta página.\n\n![image@4.png](${await FileAttachment(\"image@4.png\").url()})","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":512,"value":"# Parametros","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":258,"value":"viewof ventanaAños = Inputs.number({\n label: \"Ventana de años a considerar\",\n value: 2,\n range: [1, 5]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":263,"value":"viewof añoReferencia = Inputs.number({\n label: \"Año de referencia\",\n value: 2023\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":266,"value":"viewof añoComparacion = Inputs.number({\n label: \"Año de comparación\",\n value: 2013\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":273,"value":"añosComparacion = _.range(añoComparacion - ventanaAños + 1, añoComparacion + 1)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":279,"value":"añosReferencia = _.range(añoReferencia - ventanaAños + 1, añoReferencia + 1)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":516,"value":"## Funciones auxiliares","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":75,"value":"function extraerDatos(wb) {\n const dataTipoDelito = wb.sheet(0, {\n headers: false,\n range: \"A12:B12\"\n });\n\n const tipoDelito = dataTipoDelito[0].B;\n\n const dataRaw = wb.sheet(0, {\n headers: true,\n range: \"A20:\"\n });\n\n const data = _.chain(dataRaw)\n .slice(1)\n .map((d) => {\n return _.keys(d)\n .filter((d) => !d.match(/A/))\n .map((key) => {\n const record = {};\n record.localidad = d.A;\n record.delito = tipoDelito;\n record[\"año\"] = key;\n record[\"valor\"] = d[key];\n return record;\n });\n })\n .flatten()\n .value();\n\n return data;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":306,"value":"function rangoReferencia() {\n return ventanaAños > 1\n ? `${_.first(añosReferencia)}-${_.last(añosReferencia)}`\n : `${_.first(añosReferencia)}`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":311,"value":"function rangoComparacion() {\n return ventanaAños > 1\n ? `${_.first(añosComparacion)}-${_.last(añosComparacion)}`\n : `${_.first(añosComparacion)}`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":518,"value":"# Datos","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":64,"value":"$38","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"data = {\n return _.chain(planillasFuente)\n .map((d) => extraerDatos(d))\n .flatten()\n .value();\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"data","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":608,"value":"dictPoblacionINE[\"cabo de hornos\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":208,"value":"dataPlot = _.chain(data)\n .filter((d) => d.localidad == localidadSeleccionada)\n .groupBy((d) => d.delito)\n .map((items, key) => [\n {\n localidad: localidadSeleccionada,\n\n delito: key,\n tasaComparacion: items\n .filter((d) => añosComparacion.includes(+d.año))\n .reduce((memo, d) => memo + d.valor, 0),\n tasaReferencia: items\n .filter((d) => añosReferencia.includes(+d.año))\n .reduce((memo, d) => memo + d.valor, 0)\n }\n ])\n .flatten()\n .value()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":530,"value":"dataPlot","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":167,"value":"dictPoblacionINE = {\n const dict = {};\n\n dataPoblacionINE.forEach((d) => {\n dict[d.comuna.toLowerCase()] = dict[d.comuna.toLowerCase()] || {};\n dict[d.comuna.toLowerCase()][d.año] = d.poblacion;\n });\n\n return dict;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":743,"value":"dataPoblacionINE = FileAttachment(\"Poblacion por comuna.tsv\").tsv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":248,"value":"esCL = d3.formatDefaultLocale({\n thousands: \".\",\n decimal: \",\",\n grouping: [3],\n currency: [\"$\", \"\"]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":672,"value":"esquemaDeColores = [\"blue\", \"red\"] //d3.schemeTableau10","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":650,"value":"style_bootstrap","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":645,"value":"import { style_bootstrap } from \"@elaval/utils\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W39","stdlib":"1"}} 31:"$30:body"