The avatar for @rmauro
Renato Mauro
Public
Edited
Sep 11, 2023
Fork of INSEE Parquet
Insert cell
Insert cell
db
SELECT code_commune_ref, AVG(longitude) long , AVG(latitude) lat
FROM read_parquet('https://static.data.gouv.fr/resources/bureaux-de-vote-et-adresses-de-leurs-electeurs/20230626-135723/table-adresses-reu.parquet')
WHERE geo_score > 0.9
GROUP BY 1
ORDER BY 2 DESC

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