The avatar for @rmauro
Renato Mauro
Public
Edited
Aug 26, 2024
Fork of INSEE Parquet
Insert cell
Insert cell
db
SELECT data, AVG(PESO) pesoMedio
FROM read_parquet('https://storage.googleapis.com/compact-data/sinasc.parquet')
WHERE False and CODMUNRES = 355030 AND data >= 20140000 and DATA <= 20150000 AND clSEXO = 1
GROUP BY 1

Insert cell
db
SELECT data, AVG(PESO) pesoMedio
FROM
(select data, PESO, clSEXO from read_parquet('https://storage.googleapis.com/compact-data/sinasc-rg.parquet') WHERE CODMUNRES >= 150815 and CODMUNRES < 211130 )
WHERE clSEXO = 1
GROUP BY 1
Insert cell
// We need something to boot the SQL cell (a data array or a databaseClient)
db = DuckDBClient.of({})
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