Prisoners By Age And Sex

Eurostat code: crim_pris_age · (2008 - 2023)

@eurostat.crim_pris_age

Table List

2 tables(127.16 KB)

Prisoners By Age And Sex - Raw

Prisoners By Age And Sex - Unpivoted

Prisoners By Age And Sex - Raw

@eurostat.crim_pris_age.raw

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

71.61 KB
729 rows
21 columns

freq Freq	age Age	sex Sex	unit Unit	geo Geo	n_2008 2008	n_2009 2009	n_2010 2010	n_2011 2011	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020	n_2021 2021	n_2022 2022	n_2023 2023
Annual	Adult	Females	Number	Albania	101	113	96	84	82	89	109	121	97	93	109	86	57	63	64	76
Annual	Adult	Females	Number	Austria	396	460	516	564	568	538	501	498	481	508	555	600	544	517	596	605
Annual	Adult	Females	Number	Bosnia and Herzegovina			60	38		56	60	86	48	74	71	109	73	89	74	78
Annual	Adult	Females	Number	Belgium	441	389	411	437	440	456		525		440	461	479	490	507	503	510
Annual	Adult	Females	Number	Bulgaria	290	240	291	289	307	263	258	245	228	218	213	216	192	209	207	227
Annual	Adult	Females	Number	Switzerland	298	345	319	301	306	347	315	355	370	317	384	393	347	367	374	381
Annual	Adult	Females	Number	Cyprus	42	31	45	35	43	25	30	31	41	33	36	33	30	73	56	57
Annual	Adult	Females	Number	Czechia	1079	999	1282	1480	1446	954	1164	1430	1635	1631	1638	1740	1564	1515	1611	1707
Annual	Adult	Females	Number	Germany	3930	3857	3845	3927	3943	3797	3639	3609
Annual	Adult	Females	Number	Denmark	155	178	183	164	149	189	145	118	150	135	132	182	189	184	203	211


CREATE TABLE raw (
  "freq" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE
);

Share link

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