The avatar for @datasile
datasile
Unlisted
site_datasile
Edited
Feb 21, 2023
Paused
1
Insert cell
Insert cell
Insert cell
asyappctza.parquet
SELECT citizen
, sex
, asyl_app
, geo
, age
, TIME_PERIOD
, OBS_VALUE
FROM asyappctza
Insert cell
Insert cell
Insert cell
asyappctza.parquet
SELECT TIME_PERIOD, COUNT(*)
FROM asyappctza
GROUP BY TIME_PERIOD
ORDER BY TIME_PERIOD
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
asyappctza.parquet
SELECT geo, COUNT(*), MIN(TIME_PERIOD), MAX(TIME_PERIOD)
FROM asyappctza
GROUP BY geo
ORDER BY 3 DESC
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
asyappctza.parquet
SELECT asyl_app, COUNT(*)
FROM asyappctza
GROUP BY asyl_app
Insert cell
Insert cell
Insert cell
asyappctza.parquet
SELECT geo, asyl_app, COUNT(*), MIN(TIME_PERIOD), MAX(TIME_PERIOD)
FROM asyappctza
GROUP BY geo, asyl_app
ORDER BY MIN(TIME_PERIOD) DESC
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
asyappctza.parquet
SELECT geo, sex, COUNT(*), MIN(TIME_PERIOD), MAX(TIME_PERIOD), SUM(CAST (OBS_VALUE AS FLOAT))
FROM asyappctza
GROUP BY geo, sex
ORDER BY MIN(TIME_PERIOD) DESC
Insert cell
Insert cell
Insert cell
Insert cell
asyappctza.parquet
SELECT geo, age, COUNT(*), MIN(TIME_PERIOD), MAX(TIME_PERIOD), SUM(CAST (OBS_VALUE AS FLOAT))
FROM asyappctza
GROUP BY geo, age
ORDER BY MIN(TIME_PERIOD) DESC
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
asyappctza.parquet
SELECT geo, age, sex, COUNT(*), MIN(TIME_PERIOD), MAX(TIME_PERIOD), SUM(CAST (OBS_VALUE AS FLOAT))
FROM asyappctza
GROUP BY geo, age,sex
ORDER BY MIN(TIME_PERIOD) DESC
Insert cell
Insert cell
Insert cell
asyappctza.parquet
SELECT citizen, COUNT(*), MIN(TIME_PERIOD), MAX(TIME_PERIOD)
FROM asyappctza
GROUP BY citizen
ORDER BY MIN(TIME_PERIOD) DESC
Insert cell
Insert cell
Insert cell
Insert cell
asyappctza.parquet
SELECT geo, TIME_PERIOD, asyl_app, sex, SUM(CAST (OBS_VALUE AS FLOAT))
FROM asyappctza
WHERE geo == 'FR'
AND TIME_PERIOD == '2009'
AND asyl_app == 'ASY_APP'
GROUP BY geo, TIME_PERIOD, asyl_app, sex


Insert cell
Insert cell
Insert cell
asyappctza.parquet
SELECT geo, TIME_PERIOD, asyl_app, sex, age, SUM(CAST (OBS_VALUE AS FLOAT))
FROM asyappctza
WHERE geo == 'FR'
AND TIME_PERIOD == '2015'
AND asyl_app == 'ASY_APP'
AND sex == 'T'
GROUP BY geo, TIME_PERIOD, asyl_app, sex, age

Insert cell
Insert cell
Insert cell
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 != 'T'
AND age NOT IN ('TOTAL','Y14-17','Y_LT14')
AND citizen NOT IN ('EU27_2020','EU28','EXT_EU27_2020','EXT_EU28','TOTAL')
AND asyl_app == 'ASY_APP'

Insert cell
Insert cell
Insert cell
asyappctza.parquet
SELECT citizen
, sex
, asyl_app
, geo
, age
, TIME_PERIOD
, OBS_VALUE
FROM asyappctza
WHERE geo == 'UK'
AND sex != 'T'
AND age NOT IN ('TOTAL','Y14-17','Y_LT14')
AND citizen NOT IN ('EU27_2020','EU28','EXT_EU27_2020','EXT_EU28')
AND asyl_app == 'ASY_APP'
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