Unlisted
Edited
May 24, 2023
Paused
Importers
Insert cell
Insert cell
asyappctza.parquet
SELECT citizen
, sex
, asyl_app
, geo
, age
, TIME_PERIOD
, OBS_VALUE
FROM asyappctza
WHERE geo NOT IN ('HR','ME','EU27_2020')
AND sex NOT IN ('T','UNK')
AND age NOT IN ('TOTAL','Y14-17','Y_LT14','UNK')
AND citizen NOT IN ('EU27_2020','EU28','EXT_EU27_2020','EXT_EU28','TOTAL')
AND asyl_app == 'ASY_APP'
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
countryGroup = d3.groupSort(data, v => d3.sum(v, d => +d.OBS_VALUE), d => d.geo).reverse()
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
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