2c:null 2d:["$","title",null,{"children":"Promedio de edad de personas fallecidas por comuna | Ernesto Laval | Observable"}] 32:T7cb,{ const regexp = new RegExp(comuna, "is"); return Plot.plot({ width: width, y: { label: "Promedio de edad de personas fallecidas entre 2013 y 2019" }, x: { tickFormat: "%", label: "Porcentaje de personas en situación de pobreza por ingresos 2020" }, color: { legend: true }, marks: [ Plot.dot( data.filter((d) => d.personas >= 100), { x: "porcentajePobreza", y: "promedioEdadFallecidos", z: "comuna", r: "personas", fill: (d) => d.promedioEdadFallecidos >= 77 ? ">= 77 años" : d.promedioEdadFallecidos >= 70 ? ">= 70 y < 77 años" : d.promedioEdadFallecidos >= 65 ? ">= 65 y < 70 años" : "< 65 años", opacity: 0.8, stroke: "lightgrey", strokeWidth: 0.5, tip: true, title: (d) => `${d.comuna} Promedio edad fallecidos: ${d3.format(".1f")(d.promedioEdadFallecidos)} años Porcentaje de pobreza: ${d3.format(".1%")(d.porcentajePobreza)} Personas fallecidas (2013-2019): ${d3.format("d")(d.personas)} ` } ), Plot.tip( data.filter( (d) => comuna.length >= 3 && d.comuna.match(regexp) && d.personas >= 100 ), { x: "porcentajePobreza", y: "promedioEdadFallecidos", title: (d) => `${d.comuna} ${d3.format(".1f")(d.promedioEdadFallecidos)}` } ) ], caption: md`

Fuentes de datos:
“Defunciones por Causa 1990 - 2020 CIFRAS OFICIALES”, DEIS, Ministerio de Salud, https://deis.minsal.cl/#datosabiertos
“Estimaciones de Pobreza Comunal 2020”, Observatorio Social, Ministerio de Desarrollo Social y Familia, "https://observatorio.ministeriodesarrollosocial.gob.cl/pobreza-comunal-2020

Autor de la visualización: Ernesto Laval (@elaval)

` }); }33:[{"id":"7f2b8b17f741fbe72afe786853c67bcbb98484782c80d037c68a0638d06f7b578025467a7037099dd9aa95484c59e6bf5bdf4b52f32e1f554b219c0b3471c2c4","href":"https://static.observableusercontent.com/files/7f2b8b17f741fbe72afe786853c67bcbb98484782c80d037c68a0638d06f7b578025467a7037099dd9aa95484c59e6bf5bdf4b52f32e1f554b219c0b3471c2c4","name":"DEFUNCIONES_FUENTE_DEIS_1990_2022_01122022_2013_2019.parquet","type":"application/octet-stream","lastModified":1693270772666.379,"size":41858132},{"id":"050743f4470d3360d82377fcf8cf857837163fc6daac08149b918c6a381f43a128770ee4410158b9b5121b44e75056c62c3450a8906e833924d0ad5c79f3cc6b","href":"https://static.observableusercontent.com/files/050743f4470d3360d82377fcf8cf857837163fc6daac08149b918c6a381f43a128770ee4410158b9b5121b44e75056c62c3450a8906e833924d0ad5c79f3cc6b","name":"Estimaciones_de_Tasa_de_Pobreza_por_Ingresos_por_Comunas_2020_revisada2022_09.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1693270772666.379,"size":51159}] 30:{"id":"21ebefb92cbab94a","slug":"promedio-de-edad-de-personas-fallecidas-por-comuna","title":"Promedio de edad de personas fallecidas por comuna","thumbnail":"dc33e8f607b211a20354530818bc3019ebc5808722ce760253bb5cf2d4eb5184","access_level":"public","create_time":"$D2023-08-29T00:59:32.666Z","update_time":"$D2023-08-29T02:15:13.691Z","view_time":null,"first_public_time":"$D2023-08-29T01:50:37.545Z","has_unpublished_edits":null,"fork":true,"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":544,"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":"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":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Promedio de edad de personas fallecidas por comuna","cells":[{"id":0,"value":"# Promedio de edad de personas fallecidas por comuna","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":432,"value":"viewof comuna = Inputs.text({\n label: \"Comuna\",\n placeholder: \"Comuna a buscar\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":500,"value":"###

Promedio de edad de personas fallecidas entre 2013 y 2019
vs Porcentaje de personas en situación de pobreza

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":37,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":502,"value":"**Notas:**\n* Cada círculo representa una comuna\n* El tamaño del círculo representa la cantidad de personas fallecidas entre 2013 y 2019\n* Los colores representan distintos rangos de edad\n* Se excluyen comunas pequeñas que registran menos de 100 fallecidos entre 2013 y 2019\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":469,"value":"## Datos","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":25,"value":"SELECT edadFallecidos.COMUNA as comuna, \n edadFallecidos.COD_COMUNA as cod_comuna, \n edadFallecidos.EDAD as promedioEdadFallecidos, \n edadFallecidos.PERSONAS as personas, \n \"Porcentaje de personas en situación de pobreza por ingresos 2020\" as porcentajePobreza\nFROM edadFallecidos\nINNER JOIN pobrezaComunal ON edadFallecidos.COD_COMUNA = pobrezaComunal.Código\nORDER BY promedioEdadFallecidos desc","pinned":false,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"data","database":"var:db"},{"id":22,"value":"db = DuckDBClient.of({\n edadFallecidos: dataEdadFallecidos,\n pobrezaComunal: dataPobrezaComunal\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":474,"value":"### Datos - promedio de edad de personas fallecidas por comuna\nFuente: \"Defunciones por Causa 1990 - 2020 CIFRAS OFICIALES”, DEIS, Ministerio de Salud, https://deis.minsal.cl/#datosabiertos","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":407,"value":"SELECT COMUNA, COD_COMUNA, AVG(CASE WHEN EDAD_TIPO = 1 THEN EDAD_CANT ELSE 0 END) AS EDAD, COUNT(*) AS PERSONAS\nFROM DEFUNCIONES_FUENTE_DEIS_1990_2022_01122022_2013_2019.parquet\nGROUP BY COMUNA, COD_COMUNA\nORDER BY EDAD DESC","pinned":false,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"dataEdadFallecidos","database":"DEFUNCIONES_FUENTE_DEIS_1990_2022_01122022_2013_2019.parquet"},{"id":494,"value":"## Datos - porcentaje de personas en situación de pobreza por comuna\nFuente: “Estimaciones de Pobreza Comunal 2020”, Observatorio Social, Ministerio de Desarrollo Social y Familia, \"https://observatorio.ministeriodesarrollosocial.gob.cl/pobreza-comunal-2020","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":509,"value":"dataPobrezaComunal","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":16,"value":"dataPobrezaComunal = workbookPobreza.sheet(0, {\n headers: true,\n range: \"A3:\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"workbookPobreza = FileAttachment(\n \"Estimaciones_de_Tasa_de_Pobreza_por_Ingresos_por_Comunas_2020_revisada2022_09.xlsx\"\n).xlsx()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":496,"value":"# Librerías externas","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":417,"value":"import { autoSelect } from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1"}} 31:"$30:body"