2d:null 2e:["$","title",null,{"children":"Coronavirus en Chile - Nuevos casos semanales por comuna | Ernesto Laval | Observable"}] 33:T4b9,html`

Advertencia

El Informe Epidemiológico contiene datos de casos confirmados para todas las comunas de Chile y se publica 2 veces a la semana (generaslmente los mismos días de la semana, pero no siempre es así)

Adicionalmente las autoridades regionales publican datos regulares (en muchos casos diarios) de las casos confirmados a nivel comunal, pero esto no ocurre para la Región Metropolitana.

Para tener uniformidad en el reporte, publicábamos el avance comunal en base al informe epidemiológico para todo el país. Sin embargo, debido a ajustes que se realizan en el informe epidemiológico (ej. reasignar comunas de residencia producto de investigación epidemiológica), el cálculo de nuevos casos confirmados al comparar los datos de distintos informes genera importantes anomalías (ej. casos confirmados acumulados disminuyen en 144 personas entre los informes del 13 y el 30 de Julio).

A partir del Julio, esta página utilizará datos diarios informados por las autoridades regionales en todas las comunas de Chile, excepto por la Región Metropolitana en que se utilizarán datos de los informes epidemiológicos.

`34:T16bd,{ const itemsArica = dataGroupedByLocationSEREMIS.find(d => d.location == ["Arica"])["items"] const last8DaysArica = _.chain(itemsArica) .sortBy(d => d.date) .reverse() .take(8) .value(); const todayArica = _.first(last8DaysArica); //return todayArica return html`

Aspectos metodológicos

Los informes epidemiológicos incluyen datos de "casos activos" por comuna que son estimados en base a los casos confirmados CONOCIDOS que reportaron inicio de síntomas en los últimos 14 días.

Al momento de emitir cada informe existe una cantidad importante de personas que son infectados activos (personas con COVID-19 que están en una etapa contagiante) pero aún no han consultado a un servicio de salud o todavía no se cuenta con el resultado de su test PCR.

Muchos de estos casos activos serán identificados en forma posterior al Informe Epidemiológico por lo que el dato de casos activos está subestimado.

Por ejemplo, en el Informe Epidemiológico del 1 de Julio se reporta 38.649 casos activos para todo Chile, pero algunas semanas después (al 20 de Julio) ya se ha confirmado que al 1 de Julio había al menos 57.753 casos activos (1.5 veces los reportados originalmente).

En este documento hemos adoptado el criterio de estimar los casos activos en base a los nuevos casos confirmados reportados en los días recientes.

Cuando los casos van en aumento, los casos confirmados en los últimos 14 días son mejor estimador que los casos con inicio de síntomas en los últimos 14 días para los casos activos.

Cuando los casos van disminuyendo, el doble de los casos confirmados en los últimos 7 días parece ser una buena aproximación a los casos activos. Usaremos este criterio como un estimador "conservador" de los casos activos (con el riesgo de subestimar los casos activos en aquellas localidades que van en aumento).

En el mismo ejemplo anterior, los casos confirmados en los 7 días previos al 1 de Julio son 28.626 casos. El estimador de casos activos sería (2x casos confirmados en 7 días) 57.252 casos (bastante aproximado a los 57.753 con inicio de síntomas que conocimos casi 3 semanas después).

Esta estimación también equivale a multiplicar x 14 el promedio de casos diarios confirmados la última semana.

Cálculo de casos confirmados en la última semana

La fuente oficial de casos confirmados a nivel comunal para todo el país son los Informes Epidemiológicos, que se publican 2 veces por semana. Estos debiesen ser publicados regularmente los mísmos días cada semana, lo que permite obtener el aumento de casos confirmados en los últimos 7 días.

Sin embargo, recientemente han existido irregularidades en el día de publicación de estos informes, por lo que realizamos aproximaciones. Tomamos los datos de cada 2 informes (ejemplo el informe Nº33 y el Nº35), calculamos el aumento de casos confirmados e identificaremos los días transcurridos. Si los días transcurridos difieren de 7, realizaremos una aproximacióna los nuevos casos semanales en base al promedio diario de casos entre los 2 informes (7 * Nuevos casos / Días transcurridos entre los informes).

Por ejemplo, para el caso de Tierra Amarilla al 28 de Junio, estimamos que hay 19.44 nuevos casos confirmados en 7 días.

Hubo 25 casos en 9 días y un estimado de 7 x 25 / 9 = 19.44 nuevos casos en 7 días

Aumento semanal en regiones de Chile que no son la Región Metropolitana

Fuera de la Región Metropolitna, las autoridades regionales publican los casos confirmados diarios por comuna. De esta manera es posible calcular el aumento semanal de casos para cualquier fecha (no limitándose a las fechas de los informes epidemiológicos como ocurre en la Región Metropolitana)

Por ejemplo para la Comuna de Arica se tienen los siguientes datos: ${ last8DaysArica .map(d => ` `) }

Fecha	Casos confirmados
${moment(d.date).format("DD MMM")}	${d.total_cases}

Los nuevos casos en la última semana serán ${todayArica.deltaLastWeek}(${todayArica.total_cases}-${todayArica.valueLastWeek})

Incidencia por cada 100 mil habitantes

Para estimar la incidencia, necesitamos calcular el equivalente a casos por cada 100.000 habitantes.

La formula sería:

Incidencia (casos x 100 mil habitantes) = casos * 100.000 / población

Para el caso de Tierra Amarilla en el ejemplo anterior (población de 14.312 habitantes), la incidencia de nuevos casos confirmados en 7 días sería:

Incidencia = 19.44 x 100.000 / 14.312 = 136 nuevos casos x 100 mil habitantes en 7 días (al 28 de Junio)

Promedio diario de casos en últimos 7 días x 100 mil habitantes

Una vez que tenemos la cantidad de casos en los últimos 7 días x 100 mil habitantes, basta dividir x 7 para calcular el promedio diario en últimos 7 dñias

Para el ejemplo de Tierra Amarilla al 28 de Junio:

136 / 7 = 19.4 casos diarios x 100 mil habitantes

Estimación de casos activos x 100 mil habitantes

Tal como lo explicamos más arriba, estimaremos los casos activos multiplicando x 2 los nuevos casos confirmados x 100 mil habitantes en los últimos 7 días.

Para el ejemplo de Tierra Amarilla al 28 de Junio, los casos activos serán:

136 x 2 = 272 Casos activos x 100 mil habitantes

` }35:T44e,{ const color = d3.scaleLinear().range(colorRange).domain(colorDomainPorPoblacion); const values = [0,1,5,10,50,100,200] const out = html`

Código de colores

${ values.map(d => ` `).join("") }

${d3.format("d")(d)}

Nota: El Consejo Asesor COVID-19 del Ministerio de Salud define los siguientes umbrales para el promedio diario de casos en últimos 7 dias:

10 casos diarios x 100 mil habitantes umbral sobre el cuál pasar a cuarentena (bajo el umbral se podría pasar a trasición o apretura)
5 casos diarios x 100 mil habitantes umbral bajo el cual pasar a apertura incial
1 casos activos x 100 mil habitantes umbral bajo el cual pasar a apertura avanzada

` return out }36:Ta8a,{ const color = d3.scaleLinear().range(colorRange).domain(colorDomainPorPoblacion); const data = _.chain(dataGroupedByLocation).map(d => { const lastWeek = _.last(epiDates); const lastItem = _.find(d.items, e=> e.date == lastWeek) return ({ location:d.location, region: d.region, poblacion: d.poblacion, maxCases: _.max(d.items.map(e => e.totalCases_today)), lastWeekCases: lastItem && (lastItem.totalCases_today-lastItem.totalCases_1weeksAgo), items: d.items.filter(e => epiDates.includes(e.date)).map(d => ({ date: d.date, lastWeekCases: 10000*(d.totalCases_today - d.totalCases_1weeksAgo)/d.poblacion })) }) }) .filter(d => regionSeleccionada ? d.region == regionSeleccionada : true) .filter(d => d.maxCases >=0) .sortBy(d => -d.lastWeekCases/d.poblacion) .value() const out = html` ${data.map((d,i) => ` ${ i % 20 == 0 ? ` ${ epiDates.map(e => ` `).join("") } `: ``} ${ epiDates.map(e => ` `).join("") } `).join("")}

Comuna (población)	${moment(e).format("ddd DD MMM")}
${d.location} (${d3.format(".2s")(d.poblacion)})	${ _.find(d.items, f=> f.date == e) ? d3.format(".1f")(_.find(d.items, f=> f.date == e).lastWeekCases) : `` }	${[null].map(d => { const inlineVis = html`HOLA`; return inlineVis.innerHtml; }) }

` /* ${[null].map(d => { const out = html` `; debugger; const visEl = d3.select(out).select("td svg"); const visObj = new InlineVis(visEl.node()); visObj.height(20).width(100).render([10,50,30]); return out.innerHtml; })}*/ //return out return html`` }37:T13dd,{ const fechas = (fuenteDatos == "epi" || regionSeleccionada == "Metropolitana") ? fechasMetropolitana : fechasRegiones; //const fechas = fechasMetropolitana; const color = d3.scaleLinear().range(colorRange).domain(colorDomainPorPoblacion); function getCellContent(items, date) { const metric = _.find(items, f=> f.date == date) && _.find(items, f=> f.date == date).dailyAverage return metric >= 0 && (metric > 11 ? d3.format(".0f")(metric) : d3.format(".1f")(metric)) || `` } function growing(record) { const sortedItems = _.chain(record.items).sortBy(f=> f.date == date).reverse().value(); const lastItem = sortedItems[0]; const beforeLastItem = sortedItems[1]; return lastItem.dailyAverage > beforeLastItem.dailyAverage } function warning(record) { const sortedItems = _.chain(record.items).sortBy(f=> f.date == date).reverse().value(); const lastItem = sortedItems[0]; return lastItem.dailyAverage > 10; } function softwarning(record) { const sortedItems = _.chain(record.items).sortBy(f=> f.date == date).reverse().value(); const lastItem = sortedItems[0]; return lastItem.dailyAverage >= 5; } const groupedData = fuenteDatos == "regionales" ? dataGroupedByLocationSEREMIS : dataGroupedByLocation; const data = _.chain(groupedData).map(d => { //const data = _.chain(dataGroupedByLocation).map(d => { const lastWeek = _.last(fechas); const lastItem = _.find(d.items, e=> e.date == lastWeek) return ({ location:d.location, region: d.region, poblacion: d.poblacion, maxCases: _.max(d.items.map(e => e.totalCases_today)), lastWeekCases: lastItem && (lastItem.weeklyNewCasesEstimate), dailyAverage: lastItem && (lastItem.weeklyNewCasesEstimate)/7, dailyAveragePoblacion: lastItem && 100000*(lastItem.weeklyNewCasesEstimate)/d.poblacion/7, activeCases: lastItem && (lastItem.weeklyNewCasesEstimate)*2, items: d.items.filter(e => fechas.includes(e.date)).map(d => ({ date: d.date, //lastWeekCases: 10000*(d.totalCases_today - d.totalCases_1weeksAgo)/d.poblacion lastWeekCases: 100000*(d.weeklyNewCasesEstimate)/d.poblacion, dailyAverage: 100000*(d.weeklyNewCasesEstimate)/d.poblacion/7, activeCases: 2*100000*(d.weeklyNewCasesEstimate)/d.poblacion })) }) }) .filter(d => regionSeleccionada ? d.region == regionSeleccionada : true) //.filter(d => d.dailyAveragePoblacion >=10) .sortBy(d => -d.activeCases/d.poblacion) //.slice(1,30) .value() const numItems = data.length; const windowSize = numItems < 40 ? (numItems <= 15 ? numItems : Math.ceil(numItems / 2)) : Math.ceil(numItems / 6); //return dataGroupedByLocation const out = html` ${data.map((d,i) => html` ${ i % windowSize == 0 ? ` ${ fechas.map(e => ` `).join("") } ` : ``} ${ fechas.map(e => ` `).join("") } ${[null].map(x => { const out = html` `; debugger; const visEl = d3.select(out).select("td svg"); const visObj = new InlineVis(visEl.node()); visObj.height(20).width(80).render(d.items && d.items.filter(d => !omitDates.includes(d.date)).map(e => e.dailyAverage)); return out; })} `)}

Comuna (población)	${moment(e).format("ddd DD MMM")}
${d.location} (${d3.format(".2s")(d.poblacion)})	${ getCellContent(d.items, e) }		${softwarning(d) ? `` : ""}	${growing(d) ? `` : ""}

` /* */ return out }38:T754,{ const fechas = (fuenteDatos == "epi" || regionSeleccionada == "Metropolitana") ? fechasMetropolitana : fechasRegiones; //const fechas = regionSeleccionada == "Metropolitana" ? fechasMetropolitana : fechasRegiones; //const fechas = fechasMetropolitana ; const color = d3.scaleLinear().range(colorRange).domain(colorDomain); const groupedData = fuenteDatos == "regionales" ? dataGroupedByLocationSEREMIS : dataGroupedByLocation; const data = _.chain(groupedData).map(d => ({ location:d.location, region: d.region, recentCases: _.last(d.items).weeklyNewCasesEstimate, items: d.items.filter(e => fechas.includes(e.date)).map(d => ({ date: d.date, lastWeekCases: d.weeklyNewCasesEstimate })) })) .filter(d => regionSeleccionada ? d.region == regionSeleccionada : true) .sortBy(d => -d.recentCases) .value() const out = html` ${data.map((d,i) => ` ${ i % 20 == 0 ? ` ${ fechas.map(e => ` `).join("") } `: ``} ${ fechas.map(e => ` `).join("") } `).join("")}

	${moment(e).format("ddd DD MMM")}
${d.location}	${ _.find(d.items, f=> f.date == e) ? d3.format(".1f")(_.find(d.items, f=> f.date == e).lastWeekCases) : `` }

` return out }39:T584,/*html`

IMPORTANTE

Hasta el 19 de Junio los informes epidemiológicos eran publicados consistentemente los días Lunes y Viernes. Esto permitía conocer el número exacto de nuevos casos confirmados que habían sido reportados cada semana.

A partir del Martes 23 de Junio, ya no se mantiene la regularidad de publicación en días Lunes y Viernes, por lo que ahora trabajo con estimaciones de casos confirmados en la semana utilizando los datos de un informe y los de 2 informes previos (que ahora no tienen 7 días de diferencia). Para estimar el aumento semanal se calcula el incremento proporcional para 7 días.

Por ejemplo, para la ciudad de Calama:

Informe epidemiológico del Domingo 28 de Junio reporta: 3.847 casos confirmados

Informe epidemiológico del Viernes 19 de Junio reporta: 2.375 casos confirmados

El incremento fue de 1.472 casos confirmados en 9 días

Esto equivale a un promedio de 1.144,9 casos confirmados en 7 días (1.472*7/9)

La ciudad de Calama tiene una población de 190.336 habitantes, por lo que este incremento corresponde a
60.2 casos confirmados por 10 mil habilantes (1.144,9 * 10.000/190.336)

`*/3a:T643,html``3b:T8dd,class InlineVis { constructor(el, metric) { this._data = []; this._margin = {left: 2, right:2, top:2, bottom: 2}; this._totalWidth = width; this._totalHeight = 800 < screen.height ? 800 : screen.height; this.svgContainer = d3.select(el); this.startup(); } startup() { this._width = this._totalWidth - this._margin.left - this._margin.right; this._height = this._totalHeight - this._margin.top - this._margin.bottom; this.xScale = d3.scaleLinear() .range([0,this._width]) //this.yScale = d3.scaleLog() this.yScale = d3.scaleLinear() .range([this._height,0]) this.yAxis = d3.axisLeft(this.yScale) .ticks(10) .tickFormat(d3.format(",")); this.xAxis = d3.axisBottom(this.xScale) //.ticks(4); this.svgContainer .attr("width",this._width+this._margin.left+this._margin.right) .attr("height",this._height+this._margin.top+this._margin.bottom) this.svgContainer.selectAll("g").remove(); this.container = this.svgContainer.selectAll("g.container") .data([1]) .join("g") .attr("class", "container inlineVis") .attr("transform", `translate(${this._margin.left},${this._margin.top})`) this.line = d3.line() .x((d, i) => this.xScale(i)) // set the x values for the line generator .y((d) => this.yScale(d)) // set the y values for the line generator .curve(d3.curveMonotoneX) // apply smoothing to the line } render(data) { debugger; // change... const self = this; const yDomain = d3.extent(data, (d,i) => d);; const xDomain = d3.extent(data, (d,i) => i); // Update scale domoins according to data values this.xScale.domain(xDomain) //this.yScale.domain([minValue, maxValue]) this.yScale.domain(yDomain) // Path line for each country const line = this.container.selectAll("path.line") .data([data]) .join("path") .attr("class",d => `line`) .attr("d",this.line) } height(_) { this._totalHeight = _; this.startup(); return this; } width(_) { this._totalWidth = _; this.startup(); return this; } }3c:T6b4,dataGroupedByLocation = { debugger; function estimateAverageWeeklyNewCases(record) { const location = record.location const date = record.date function estimateWeeklyCases(date1, date2) { const record1 = dictDataComunas[location][date1]; const record2 = dictDataComunas[location][date2]; const elapsedDays = moment(date1).diff(moment(date2), "days"); const changeCases = record1 && record2 && record1.total_cases - record2.total_cases || null; return changeCases && elapsedDays && 7 * changeCases / elapsedDays || null; } if (record.weekAgoRecord) { return record.total_cases - record.weekAgoRecord.total_cases } else { debugger; const weekAgoDate = moment(date).subtract(1, "week").format("YYYY-MM-DD"); const olderDates = _.chain(dictDataComunas[location]) .keys() .filter(d => d <= weekAgoDate) .sortBy() .reverse() .value(); const closestDateToWeekAgo = _.first(olderDates); return estimateWeeklyCases(date, closestDateToWeekAgo) } } // Filter records only before the selected max date const _data = dataComunas const newData = _.chain(_data) .groupBy(d => d.location) .map((items, location) => { return ({ location: location, region: items[0].region, items: items.map(item => { item.weeklyNewCasesEstimate = estimateAverageWeeklyNewCases(item); return item }), lockdowns: cuarentenasByCode[items[0].location_code] || [], poblacion: items[0].poblacion }) }) .filter(d => !d.location.match(/Desconocido/)) .value() return newData }3d:Teab,dataComunas = { const data = dataComunasRaw; // Datos Informe Epidemiológico //const data = dataComunasRaw1; // Datos de fuentes regionales const sortedDates = _.chain(data).map(d => d.date).uniq().sortBy().reverse().value(); const prevDateDict = {}; sortedDates.forEach((d,i) => { prevDateDict[d] = sortedDates[i+1] || null; }) debugger; const comunaDateDict = {}; data.forEach(d => { comunaDateDict[d.location] = comunaDateDict[d.location] || {}; comunaDateDict[d.location][d.date] = d; }) data.forEach(d => { d.dateLastWeek = moment(d.date).subtract(7, "days").format("YYYY-MM-DD"); const recordLastWeek = comunaDateDict[d.location][d.dateLastWeek]; d.valueLastWeek = recordLastWeek && recordLastWeek.total_cases d.deltaLastWeek = recordLastWeek && (+d.total_cases - recordLastWeek.total_cases) d.dailyAverage = d.deltaLastWeek / 7; d.weekAgoRecord=recordLastWeek; d.growthFactor = recordLastWeek && (+d.total_cases / +recordLastWeek.total_cases) }) //return data; function getCasesWeekAgo(item,n) { if (n == 0) { return item && item.total_cases || null } else { return item && getCasesWeekAgo(item.weekAgoRecord, n-1) || null } } function getCasesDatePointsAgo(item,n) { if (n == 0) { return item && item.total_cases || null } else { return item && getCasesDatePointsAgo(comunaDateDict[item.location][prevDateDict[item.date]], n-1) || null } } function getCasesDaysPointsAgo(item,n) { if (n == 0) { return 0 } else { const prevDate = item && prevDateDict[item.date] || null; const daysSincePrevDAte = item && moment(item.date).diff(moment(prevDate), "days") return item && daysSincePrevDAte + getCasesDaysPointsAgo(comunaDateDict[item.location][prevDateDict[item.date]], n-1) || 0 } } data.forEach(d => { d.referenceDate = refDate; d.deltaOnReferenceDate = comunaDateDict[d.location][refDate] && comunaDateDict[d.location][refDate].deltaLastWeek ? +comunaDateDict[d.location][refDate].deltaLastWeek : null; d.dailyAvgOnReferenceDay = d.deltaOnReferenceDate / 7; d.dailyAverageDiffAgainstReferenceDay = d.dailyAverage - d.dailyAvgOnReferenceDay; d.relativeIncrease = d.dailyAverage / d.dailyAvgOnReferenceDay; d.dailyAverageLAstWeek = d.weekAgoRecord && d.weekAgoRecord.weekAgoRecord ? (d.weekAgoRecord.total_cases - d.weekAgoRecord.weekAgoRecord.total_cases)/7 : null d.totalCases_today = getCasesWeekAgo(d,0) d.totalCases_1weeksAgo = getCasesWeekAgo(d,1) d.totalCases_2weeksAgo = getCasesWeekAgo(d,2) d.totalCases_3weeksAgo = getCasesWeekAgo(d,3) d.totalCases_4weeksAgo = getCasesWeekAgo(d,4) d.totalCases_5weeksAgo = getCasesWeekAgo(d,5) d.totalCases_6weeksAgo = getCasesWeekAgo(d,6) d.totalCases_2Datepointsago = getCasesDatePointsAgo(d,2) d.totalCases_4Datepointsago = getCasesDatePointsAgo(d,4) d.daysSince2Datepointsago = getCasesDaysPointsAgo(d,2) d.daysSince4Datepointsago = getCasesDaysPointsAgo(d,4) d.avgWeekyCases_2Datepointsago = getCasesDaysPointsAgo(d,2) ? 7*(d.total_cases - getCasesDatePointsAgo(d,2))/getCasesDaysPointsAgo(d,2) : 0; d.avgWeekyCases_4Datepointsago = getCasesDaysPointsAgo(d,4) ? 14*(d.total_cases - getCasesDatePointsAgo(d,4))/getCasesDaysPointsAgo(d,4) : 0; //d.poblacion = +poblacionPorComuna[+d.location_code]; }) /* _.chain(data).groupBy(d => d.location).each((items,key) => { identifySlope(items) }).value() */ return data }3e:T5df,dataGroupedByLocationSEREMIS = { function estimateAverageWeeklyNewCases(record) { const location = record.location const date = record.date function estimateWeeklyCases(date1, date2) { const record1 = dictDataComunasSEREMIS[location][date1]; const record2 = dictDataComunasSEREMIS[location][date2]; const elapsedDays = moment(date1).diff(moment(date2), "days"); const changeCases = record1 && record2 && record1.total_cases - record2.total_cases || null; return changeCases && elapsedDays && 7 * changeCases / elapsedDays || null; } if (record.weekAgoRecord) { return record.total_cases - record.weekAgoRecord.total_cases } else { debugger; const weekAgoDate = moment(date).subtract(1, "week").format("YYYY-MM-DD"); const olderDates = _.chain(dictDataComunasSEREMIS[location]) .keys() .filter(d => d <= weekAgoDate) .sortBy() .reverse() .value(); const closestDateToWeekAgo = _.first(olderDates); return estimateWeeklyCases(date, closestDateToWeekAgo) } } const grouped = _.chain(dataComunasSEREMIS) .groupBy(d => d.location) .map((items, location) => ({ location: location, poblacion: items[0].poblacion, region: items[0].region, items: items.map(item => { item.weeklyNewCasesEstimate = estimateAverageWeeklyNewCases(item); return item }), })) .value() return grouped }3f:T8fe,dataComunasSEREMIS = { //const data = dataComunasRaw; // Datos Informe Epidemiológico const data = dataComunasRawSEREMIS; // Datos de fuentes regionales const comunaDateDict = {}; data.forEach(d => { comunaDateDict[d.location] = comunaDateDict[d.location] || {}; comunaDateDict[d.location][d.date] = d; }) data.forEach(d => { d.dateLastWeek = moment(d.date).subtract(7, "days").format("YYYY-MM-DD"); const recordLastWeek = comunaDateDict[d.location][d.dateLastWeek]; d.valueLastWeek = recordLastWeek && recordLastWeek.total_cases d.deltaLastWeek = recordLastWeek && (+d.total_cases - recordLastWeek.total_cases) d.dailyAverage = d.deltaLastWeek / 7; d.weekAgoRecord=recordLastWeek; d.growthFactor = recordLastWeek && (+d.total_cases / +recordLastWeek.total_cases) }) //return data; function getCasesWeekAgo(item,n) { if (n == 0) { return item && item.total_cases || null } else { return item && getCasesWeekAgo(item.weekAgoRecord, n-1) || null } } data.forEach(d => { d.referenceDate = refDate; d.deltaOnReferenceDate = comunaDateDict[d.location][refDate] && comunaDateDict[d.location][refDate].deltaLastWeek ? +comunaDateDict[d.location][refDate].deltaLastWeek : null; d.dailyAvgOnReferenceDay = d.deltaOnReferenceDate / 7; d.dailyAverageDiffAgainstReferenceDay = d.dailyAverage - d.dailyAvgOnReferenceDay; d.relativeIncrease = d.dailyAverage / d.dailyAvgOnReferenceDay; d.dailyAverageLAstWeek = d.weekAgoRecord && d.weekAgoRecord.weekAgoRecord ? (d.weekAgoRecord.total_cases - d.weekAgoRecord.weekAgoRecord.total_cases)/7 : null d.totalCases_today = getCasesWeekAgo(d,0) d.totalCases_1weeksAgo = getCasesWeekAgo(d,1) d.totalCases_2weeksAgo = getCasesWeekAgo(d,2) d.totalCases_3weeksAgo = getCasesWeekAgo(d,3) d.totalCases_4weeksAgo = getCasesWeekAgo(d,4) d.totalCases_5weeksAgo = getCasesWeekAgo(d,5) d.totalCases_6weeksAgo = getCasesWeekAgo(d,6) d.poblacion = +poblacionPorComuna[+d.location_code]; }) /* _.chain(data).groupBy(d => d.location).each((items,key) => { identifySlope(items) }).value() */ return data }40:T4ac,function checkbox(config = {}) { let { value: formValue, title, description, submit, options } = Array.isArray(config) ? {options: config} : config; options = options.map( o => (typeof o === "string" ? { value: o, label: o } : o) ); const form = input({ type: "checkbox", title, description, submit, getValue: input => { if (input.length) return Array.prototype.filter .call(input, i => i.checked) .map(i => i.value); return input.checked ? input.value : false; }, form: html` ` }); form.output.remove(); return form; }41:[{"id":"c047f0f796d31c89f0b2d555a91513818b11df236fca8c2d96a0114057226777cee2669ecb33e55b08b13edd7ef197b5d8dfb02ced61589c9a00c758a1b96773","href":"https://static.observableusercontent.com/files/c047f0f796d31c89f0b2d555a91513818b11df236fca8c2d96a0114057226777cee2669ecb33e55b08b13edd7ef197b5d8dfb02ced61589c9a00c758a1b96773","name":"circle.png","type":"image/png","lastModified":1591837129538.94,"size":28081},{"id":"8d85237bf517d833edca83df9ecdbbc770f790354650f70cef024e8fd39c3cf03f529f290754022624c0c4cfff2f3fe76e9e6d480ed78b0a38ba0e7faaf47535","href":"https://static.observableusercontent.com/files/8d85237bf517d833edca83df9ecdbbc770f790354650f70cef024e8fd39c3cf03f529f290754022624c0c4cfff2f3fe76e9e6d480ed78b0a38ba0e7faaf47535","name":"confirmados semanales.png","type":"image/png","lastModified":1595450551607.727,"size":192685}] 31:{"id":"a1a1b15512fe5a0b","slug":"coronavirus-en-chile-nuevos-casos-semanales-por-comuna","title":"Coronavirus en Chile - Nuevos casos semanales por comuna","thumbnail":"b0a310a8755d3c96110af8bd3ab9e4629f4fcdd5708e901f3abf5e50c981a1b6","access_level":"public","create_time":"$D2020-06-11T00:58:49.538Z","update_time":"$D2020-08-20T17:25:25.051Z","view_time":null,"first_public_time":"$D2020-06-11T11:23:07.674Z","has_unpublished_edits":null,"fork":{"id":"421242a629a8e08e","slug":"coronavirus-en-chile-por-comuna","title":"Coronavirus en Chile por Comuna","owner":{"id":"0843f5dc42ca68a0","login":"elaval","name":"Ernesto Laval"}},"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":5481,"publish_version":5481,"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":[{"id":"8cad692d82beebf4","reply_to_id":null,"content":"Se omiten fechas para las cuales las cifgras de casos confirmados no pueden compararse con informes recientes","create_time":"$D2020-07-03T11:42:29.259Z","update_time":null,"resolved":false,"user":{"type":"individual","id":"e04cd7b5f4351ae9","login":"elaval","name":"Ernesto Laval","avatar_url":"https://avatars-next.observableusercontent.com/089f0414fc9025dadb05cc06d7a406bc9be10093187c46729cb4ba3a4098dc30","tier":null}}],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":3,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Coronavirus en Chile - Nuevos casos semanales por comuna","cells":[{"id":0,"value":"md`# Coronavirus en Chile - Nuevos casos semanales por comuna`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5189,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5139,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5439,"value":"viewof fuenteDatos = radio({\n title: 'Fuente de datos',\n description: 'Seleccionar fuente de datos (por defecto son informes regionales)',\n options: [\n { label: 'Informes regionales (salvo R. Metropolitana)', value: 'regionales' },\n { label: 'Informes epidemiológicos para todas las regiones ', value: 'epi' },\n ],\n value: 'regionales'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4698,"value":"\nviewof regionSeleccionada = {\n const regiones = _.chain(dataToRender)\n .map(d => d.region)\n .uniq()\n .sortBy()\n .map(d => ({\n label: d,\n value:d\n }))\n .value()\n \n const options = _.concat(\n //[{label: \"Todas\", value:\"\"}],\n regiones\n )\n \n return select({\n title: \"Seleccionar una región\",\n description: \"Escriba el nombre de una región para ver sólo datos de esa región \",\n options: options,\n placeholder: \"Seleccione una región . . .\",\n value: \"\"\n })\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4809,"value":"html`

${regionSeleccionada ? `Comunas en región: ${regionSeleccionada}`: `Todas las comunas de Chile con casos confirmados`}

Promedio diario de casos en últimos 7 días (x 100 mil habitantes)

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4632,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4611,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4899,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4672,"value":"md`## Nuevos casos semanales (valores absolutos)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4579,"value":"{\n\n \n const color = d3.scaleLinear().range(colorRange).domain(colorDomain);\n\n const values = [0,50,100,200,600,1000,2000,maxDiff]\n \n \n \n const out = html`\n

Código de colores

\n\n\n \n\n \n\n ${\n values.map(d => `\n \n `).join(\"\")\n }\n\n\n \n\n\n

whiteTextThreshold ? \"white\" : \"black\"}\">\n ${d}\n

\n ` \n return out\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4460,"value":"$38","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":589,"value":"html`

Autor

Ernesto Laval (@elaval)

\n\n

Fuente de datos

\nDatos de casos confirmados por comunas en Informes epidemiológicos del Ministerio de Salud de Chile, publicados por el Ministerio de Ciencia en: https://github.com/MinCiencia/Datos-COVID19/blob/master/output/producto1/Covid-19_std.csv\n

\nDatos confirmados diarios por comunas (excepto en la Región Metropolitana en la que no están disponibles) publicados por las respectivas SEREMI de Salud y/o Gobiernos Regionales y condolidados por Iván González en: https://github.com/ivanMSC/COVID19_Chile \n

\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":593,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5141,"value":"$39","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1402,"value":"md`## CSS Styles`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":85,"value":"style_bootstrap","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4097,"value":"style_fontawesome","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":218,"value":"$3a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4832,"value":"md`# Vis`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4833,"value":"$3b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1407,"value":"md`## Config Params`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5312,"value":"fechasMetropolitana = {\n const out = _.chain(epiDates)\n //.filter(d => d > \"2020-06-23\")\n .sortBy().reverse().filter((d,i) => i % 2 == 0).reverse().value();\n \n return out\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5250,"value":"fechasRegiones = {\n const out = _.chain(dataComunasSEREMIS).map(d => d.date).uniq().sortBy().reverse()\n .filter(d => d <= maxDate)\n .filter((d,i) => i % 7 == 0).take(6).reverse()\n .value()\n \n return out\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5097,"value":"omitDates = [\"2020-06-08\",\"2020-06-12\",\"2020-06-15\", \"2020-06-19\", \"2020-06-23\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4684,"value":"epiDates = _.chain(dataComunas)\n .map(d => d.date)\n .uniq()\n .filter(d => d <= maxDate)\n .filter(d => moment(maxDate).diff(moment(d), \"weeks\") < 12)// Last 6 weeks\n\n //.filter(d => moment(d).day()==1)// Lunes\n //.filter(d => moment(d).day()==5)\n //.filter(d => [5,6].includes(moment(d).day()))\n .sortBy(d => d)\n .value()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4542,"value":"whiteTextThreshold = 800","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4626,"value":"whiteTextThresholdPorPoblacion = 60","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4516,"value":"maxDiff = _.max(dataGroupedByLocation.map(d => _.max(d.items.map(e => e.avgWeekyCases_2Datepointsago)) ))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4619,"value":"maxDiffPorPoblacion = _.max(dataGroupedByLocation.map(d => _.max(d.items.map(e => 2*100000*(e.avgWeekyCases_2Datepointsago)/e.poblacion)) ))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4504,"value":"colorRange = ['white', 'yellow',\"orange\",'red', \"purple\", \"black\"]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4507,"value":"colorDomain = [0, 50,100, 200, 1000, maxDiff]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4617,"value":"colorDomainPorPoblacion = [0, 5, 10, 50, 100, 200]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2536,"value":"standardNames= ({\n \"Arica y Parinacota\": \"Arica y Parinacota\",\n\"Tarapaca\": \"Tarapacá\",\n\"Antofagasta\": \"Antofagasta\",\n\"Atacama\": \"Atacama\",\n\"Coquimbo\": \"Coquimbo\",\n\"Valparaiso\": \"Valparaíso\",\n\"Metropolitana\": \"Metropolitana\",\n\"Del Libertador General Bernardo O’Higgins\":\"O'Higgins\",\n\"O’Higgins\":\"O'Higgins\",\n\"Maule\": \"Maule\",\n\"Nuble\": \"Ñuble\",\n\"Biobio\": \"Biobío\",\n\"La Araucania\": \"Araucanía\",\n\"Los Rios\": \"Los Ríos\",\n\"Los Lagos\": \"Los Lagos\",\n\"Aysen\": \"Aysén\",\n\"Magallanes y la Antartica\": \"Magallanes\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2884,"value":"locale_es_ES = d3.json(\"https://raw.githubusercontent.com/d3/d3-time-format/master/locale/es-ES.json\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2883,"value":"function multiFormat(date) {\n const locale = d3.timeFormatLocale(locale_es_ES);\n const formatMillisecond = locale.format(\".%L\"),\n formatSecond = locale.format(\":%S\"),\n formatMinute = locale.format(\"%I:%M\"),\n formatHour = locale.format(\"%I %p\"),\n formatDay = locale.format(\"%a %d\"),\n formatWeek = locale.format(\"%b %d\"),\n formatMonth = locale.format(\"%B\"),\n formatYear = locale.format(\"%Y\");\n \n return (d3.timeSecond(date) < date ? formatMillisecond\n : d3.timeMinute(date) < date ? formatSecond\n : d3.timeHour(date) < date ? formatMinute\n : d3.timeDay(date) < date ? formatHour\n : d3.timeMonth(date) < date ? (d3.timeWeek(date) < date ? formatDay : formatWeek)\n : d3.timeYear(date) < date ? formatMonth\n : formatYear)(date);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":840,"value":"// Base trasition duration during transitions \nduration = 500","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2801,"value":"// locationIconUrl = \"https://qg70ohwn8vgx8gg1dm7bu6g9-wpengine.netdna-ssl.com/wp-content/uploads/2014/02/house-Icon.png\"\n\nlocationIconUrl = await FileAttachment(\"circle.png\").url();","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3413,"value":"metric = \"total_cases\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3616,"value":"diagnosticMessages = ({\n 1: `no muestra reducción de nuevos casos con respecto a la semana anterior`,\n 2: `muestra reducción de nuevos casos con respecto a la semana anterior, pero no con respecto a 2 semanas atrás`,\n 3: `muestra reducción de casos con respecto a las 2 semanas anteriores`\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3904,"value":"diagnosticMessagesPlural = ({\n 1: `no muestran reducción de nuevos casos con respecto a la semana anterior`,\n 2: `muestran reducción de nuevos casos con respecto a la semana anterior, pero no con respecto a 2 semanas atrás`,\n 3: `muestran reducción de casos con respecto a las 2 semanas anteriores`\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3997,"value":"function enCuarentena(item) {\n return item.lockdowns.find(d => {\n const fromDate = moment(d.start_date);\n const toDate = moment(d.end_date).add(1, \"day\")\n return moment(new Date()).isBetween(fromDate, toDate)\n }) ? true : false\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3750,"value":"chartWidth = 1024 < width ? 1024 : width;","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1384,"value":"md`## Data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3132,"value":"maxLocation_dailyAvg = {\n return _.maxBy(dataToRender, (d) => _.max(d.items.map(e => e.dailyAverage || 0)))\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3157,"value":"minLocation_dailyAvg = {\n return _.minBy(dataToRender, (d) => _.min(d.items.map(e => e.dailyAverage || 999)))\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":265,"value":"dataToRender = _.chain(dataGroupedByLocation)\n.map(d => {\n return {\n location : d.location,\n region : d.region,\n items: d.items.filter(e => e[\"date\"] >= refDate),\n lockdowns: d.lockdowns\n }\n})\n.filter(d => true)\n.value()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3783,"value":"dataGroupedByLocation.find(d => d.location == \"Tierra Amarilla\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1211,"value":"dataGroupedByLocation_bkup = { \n \n debugger;\n \n // Filter records only before the selected max date\n const _data = dataComunas\n \n \n const newData = _.chain(_data)\n .groupBy(d => d.location)\n .map((items, location) => { \n return ({\n location: location,\n region: items[0].region,\n items: removeLastIfNoPrevWeek(items),\n lockdowns: cuarentenasByCode[items[0].location_code] || [],\n poblacion: items[0].poblacion\n })\n })\n .value()\n \n return newData\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5006,"value":"$3c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3932,"value":"function removeLastIfNoPrevWeek(items) {\n debugger;\n let lastItem = _.last(items);\n \n if (items.length <= 7 || lastItem.valueLastWeek) {\n return items\n } else {\n return removeLastIfNoPrevWeek(_.slice(items,0,items.length-1))\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2176,"value":"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2663,"value":"DOM.download(new Blob([d3.tsvFormat(dataComunasSEREMIS), {type: \"text/tsv\"}]), \"data_chile_comunas.tsv\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3019,"value":"dataCuarentenas_custom = {\n const data = (await d3.csv(\"https://raw.githubusercontent.com/elaval/covid_chile_regional/master/cuarentenas.csv\")).map(d => ({\n location: d.comuna,\n regions: d.region,\n start_date: d.fecha_inicio,\n end_date: d.fecha_termino\n }));\n return _.groupBy(data, d => d.location);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3870,"value":"cuarentenasByCode = _.groupBy(dataCuarentenas_minCencia, d => d.location_code)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3850,"value":"dataCuarentenas_minCencia = {\n \n const dataRaw = await d3.csv(\"https://raw.githubusercontent.com/MinCiencia/Datos-COVID19/master/output/producto29/Cuarentenas-Totales.csv\");\n return _.chain(dataRaw)\n .map(d => ({\n \n location: d.Nombre,\n detail: d.Nombre,\n scope: d[\"Alcance\"],\n start_date: moment(d[\"Fecha de Inicio\"]).format(\"YYYY-MM-DD\"),\n end_date: d[\"Fecha de Término\"] && moment(d[\"Fecha de Término\"]).format(\"YYYY-MM-DD\") || moment(d[\"Fecha de Inicio\"]).add(30,\"days\").format(\"YYYY-MM-DD\"),\n location_code: d[\"Código CUT Comuna\"]\n }))\n .sortBy(d => d.location)\n .value()\n \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3772,"value":"dataComunas.filter(d => d.location == \"Huara\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5423,"value":"dictDataComunas[\"Rancagua\"]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5429,"value":"_.chain(dictDataComunas).map((d,key) => key).filter(d => !d.match(/Desconocido/)).value()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5410,"value":"dictDataComunas = {\n const dict = {};\n \n dataComunas.forEach(d => {\n const date = d.date;\n const location = d.location;\n \n dict[location] = dict[location] || {};\n dict[location][date] = d;\n })\n \n return dict\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2652,"value":"$3d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2716,"value":"refDate = moment(maxDate).subtract(referenceDays,\"days\").format(\"YYYY-MM-DD\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2732,"value":"referenceDays = 14;","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2713,"value":"maxDate = {\n return d3.max(dataComunasRawSEREMIS, d => d.date)\n //return \"2020-06-17\"\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3890,"value":"md`Datos de comunas `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2933,"value":"dataComunasRaw = {\n const baseData = await d3.csv(\"https://raw.githubusercontent.com/MinCiencia/Datos-COVID19/master/output/producto1/Covid-19_std.csv\")\n \n // Region,Codigo region,Comuna,Codigo comuna,Poblacion,Fecha,Casos confirmados\n\n return _.chain(baseData).map(d => ({\n date: moment(d[\"Fecha\"], \"YYYY-MM-DD\").format(\"YYYY-MM-DD\"),\n location: d[\"Comuna\"],\n location_code: d[\"Codigo comuna\"],\n region:d[\"Region\"],\n total_cases: +d[\"Casos confirmados\"],\n poblacion: +d[\"Poblacion\"]\n }))\n .sortBy(d => d.location)\n .value()\n \n /*\n 0: Object {\n Fecha: \"30-03-2020\"\n CUT: \"15101\"\n Region: \"AP\"\n Comuna: \"Arica\"\n Casos Confirmados: \"6\"\n}\n*/\n \n /*\n date: moment(d[\"Fecha\"], \"DD-MM-YYYY\").format(\"YYYY-MM-DD\"),\n location: d[\"Comuna\"],\n ISO_Region: d[\"Region\"],\n location_code: d[\"CUT\"],\n total_cases: +d[\"Confirmados Acumulados\"],\n new_cases: +d[\"Nuevos Confirmados\"]\n */\n \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5209,"value":"$3e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5206,"value":"dictDataComunasSEREMIS = {\n const dict = {};\n \n dataComunasSEREMIS.forEach(d => {\n const date = d.date;\n const location = d.location;\n \n dict[location] = dict[location] || {};\n dict[location][date] = d;\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":5201,"value":"$3f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5197,"value":"dataComunasRawSEREMIS = {\n const baseData = await d3.csv(\"https://raw.githubusercontent.com/ivanMSC/COVID19_Chile/master/historial_comunas.csv\")\n \n return _.chain(baseData).map(d => ({\n date: moment(d[\"Fecha\"], \"DD-MM-YYYY\").format(\"YYYY-MM-DD\"),\n location: d[\"Comuna\"],\n ISO_Region: d[\"Region\"],\n region: regiones[d[\"Region\"]] && regiones[d[\"Region\"]][\"nombreRegion\"],\n location_code: d[\"CUT\"],\n total_cases: +d[\"Confirmados Acumulados\"],\n new_cases: +d[\"Nuevos Confirmados\"]\n }))\n .sortBy(d => d.location)\n .value()\n \n /*\n Fecha: \"06-04-2020\"\n CUT: \"15101\"\n Region: \"AP\"\n Comuna: \"Arica\"\n Confirmados Acumulados: \"54\"\n Nuevos Confirmados: \"22\"\n}\n*/\n \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5203,"value":"poblacionPorComuna = {\n \n \n const data = await d3.csv(\"https://raw.githubusercontent.com/MinCiencia/Datos-COVID19/master/output/producto2/2020-06-08-CasosConfirmados.csv\");\n \n const dict = {};\n \n data.forEach(d => {\n dict[+d[\"Codigo comuna\"]] = +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":5199,"value":"regiones = {\n const data = await d3.csv(\"https://raw.githubusercontent.com/ivanMSC/COVID19_Chile/master/utils/regionesChile.csv\");\n const dict = {};\n \n data.forEach(d => dict[d.ISO_Region] = d);\n \n return dict\n \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1397,"value":"md`## Aux functions`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":966,"value":"$40","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1387,"value":"md`## Code Libraries`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":83,"value":"import {style_bootstrap, style_fontawesome} from \"@elaval/utils\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"_ = require(\"lodash\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"d3 = require(\"d3\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":249,"value":"moment = require('moment@2.24.0/moment.js')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2331,"value":"momentLocaleConfig = {\n moment.locale('es'); // 'en'\n \n moment.updateLocale('es', {\n weekdays : [\n \"Domingo\", \"Lunes\", \"Martes\", \"Miércoles\", \"Jueves\", \"Viernes\", \"Sábado\"\n ]\n});\n \n moment.updateLocale('es', {\n months : [\n \"Enero\", \"Febrero\", \"Marzo\", \"Abril\", \"Mayo\", \"Junio\", \"Julio\",\n \"Agosto\", \"Septiembre\", \"Octubre\", \"Noviembre\", \"Diciembre\"\n ]\n});\n \n moment.updateLocale('es', {\n monthsShort : [\n \"Ene\", \"Feb\", \"Mar\", \"Abr\", \"May\", \"Jun\",\n \"Jul\", \"Ago\", \"Sep\", \"Oct\", \"Nov\", \"Dic\"\n ]\n});\n \n moment.updateLocale('es', {\n weekdaysShort : [\"Dom\", \"Lun\", \"Mar\", \"Mie\", \"Jue\", \"Vie\", \"Sab\"]\n});\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":333,"value":"import {input, autoSelect,text, select, date, radio, button, number} from '@jashkenas/inputs'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":627,"value":"ga = {\n const ga = await require(\"https://www.google-analytics.com/analytics.js\").catch(() => window.ga);\n ga(\"create\", \"UA-143020946-10\", \"auto\");\n ga(\"send\", \"pageview\", html``.pathname);\n return ga;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5308,"value":"moment(\"2020-06-15\").subtract(\"28\", \"days\").format(\"DD MMM\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W41","stdlib":"1"}} 32:"$31:body"