Decisions Granting Temporary Protection By Citizenship, Age And Sex - Quarterly Data

Eurostat code: migr_asytpfq$dv_1382

@eurostat.migr_asytpfq_dv_1382

Table List

2 tables(24.85 KB)

Decisions Granting Temporary Protection By Citizenship, Age And Sex - Quarterly Data - Raw

Decisions Granting Temporary Protection By Citizenship, Age And Sex - Quarterly Data - Unpivoted

Decisions Granting Temporary Protection By Citizenship, Age And Sex - Quarterly Data - Raw

@eurostat.migr_asytpfq_dv_1382.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

15.87 KB
90 rows
16 columns

freq Freq	unit Unit	citizen Citizen	sex Sex	age Age	geo Geo	n_2022_q3 2022-Q3	n_2022_q4 2022-Q4	n_2023_q1 2023-Q1	n_2023_q2 2023-Q2	n_2023_q3 2023-Q3	n_2023_q4 2023-Q4	n_2024_q1 2024-Q1	n_2024_q2 2024-Q2	n_2024_q3 2024-Q3	n_2024_q4 2024-Q4
Quarterly	Person	Extra-EU27 (from 2020)	Total	From 14 to 17 years	Austria	810	495	280	230	485	395	265	295	835	630
Quarterly	Person	Extra-EU27 (from 2020)	Total	From 14 to 17 years	Belgium	520	285	255	185	330	190	225	210	430	235
Quarterly	Person	Extra-EU27 (from 2020)	Total	From 14 to 17 years	Bulgaria	840	670	225	405	405	190	235	610	470	275
Quarterly	Person	Extra-EU27 (from 2020)	Total	From 14 to 17 years	Switzerland	530	425	415	255	415	260	40	255	330	285
Quarterly	Person	Extra-EU27 (from 2020)	Total	From 14 to 17 years	Cyprus	135	65	115	80	65	70	25	15	50	15
Quarterly	Person	Extra-EU27 (from 2020)	Total	From 14 to 17 years	Czechia	3520	2000	2960	2400	3485	1745	2035	2485	4290	1960
Quarterly	Person	Extra-EU27 (from 2020)	Total	From 14 to 17 years	Germany	15790	8705	8600	6635	6420	5550	6060	4055	4845	4090
Quarterly	Person	Extra-EU27 (from 2020)	Total	From 14 to 17 years	Denmark	415	125	185	120	155	120	145	195	345	235
Quarterly	Person	Extra-EU27 (from 2020)	Total	From 14 to 17 years	Estonia	490	265	175	110	180	105	90	90	185	120
Quarterly	Person	Extra-EU27 (from 2020)	Total	From 14 to 17 years	Greece	125	65	35	50	60	25	30	65	65	40


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "citizen" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "geo" VARCHAR,
  "n_2022_q3" DOUBLE,
  "n_2022_q4" DOUBLE,
  "n_2023_q1" DOUBLE,
  "n_2023_q2" DOUBLE,
  "n_2023_q3" DOUBLE,
  "n_2023_q4" DOUBLE,
  "n_2024_q1" DOUBLE,
  "n_2024_q2" DOUBLE,
  "n_2024_q3" DOUBLE,
  "n_2024_q4" DOUBLE
);

Share link

Anyone who has the link will be able to view this.