The avatar for @elaval
Ernesto Laval
Published
Edited
May 2, 2022
Fork of Análisis de datos públicos en Observable con SQL y Plot
3
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
{
const a = `Three plus seven`;
const b = 3;

return `${a} is ${b + c}`;
}
Insert cell
Insert cell
c = 7
Insert cell
Insert cell
## Title
* Item 1
* Item 2 **highlighted**
Insert cell
Insert cell
Insert cell
Insert cell

x_i=\sqrt[n]{\frac{a_i}{b_i}}
Insert cell
Insert cell
Insert cell
dbExcessDeaths = FileAttachment("excessDeathsUSA_TheEconomist.sqlite").sqlite()
Insert cell
Insert cell
dbExcessDeaths
SELECT *
FROM united_states_excess_deaths
WHERE region = 'California'
AND start_date >= '2021-01-01'
AND end_date <= '2021-12-31'
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
dbDeathsChile = DuckDBClient.of([FileAttachment("defunciones.parquet")])
Insert cell
Insert cell
dbDeathsChile
SELECT *
FROM defunciones
WHERE CAPITULO_DIAG1 = 'I00-I99'
LIMIT 100
Insert cell
Insert cell
dbDeathsChile
SELECT FECHA_DEF as date, count(*)::Int as deaths
FROM defunciones
WHERE GLOSA_REG_RES = 'Metropolitana de Santiago'
AND CAPITULO_DIAG1 = ${causaSeleccionada.CAPITULO_DIAG1}
GROUP BY FECHA_DEF
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
import { DuckDBClient } from "@cmudig/duckdb"
Insert cell

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Learn more