Prison Capacity And Number Of Persons Held

Eurostat code: crim_pris_cap · (2008 - 2023)

@eurostat.crim_pris_cap

Table List

2 tables(48.45 KB)

Prison Capacity And Number Of Persons Held - Raw

Prison Capacity And Number Of Persons Held - Unpivoted

Prison Capacity And Number Of Persons Held - Unpivoted

@eurostat.crim_pris_cap.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

19.43 KB
2260 rows
6 columns

freq Freq	indic_cr Indic Cr	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Actual number of persons held in prison	Number	Albania	2008	4916
Annual	Actual number of persons held in prison	Number	Austria	2008	8248
Annual	Actual number of persons held in prison	Number	Belgium	2008	9811
Annual	Actual number of persons held in prison	Number	Bulgaria	2008	9408
Annual	Actual number of persons held in prison	Number	Switzerland	2008	5303
Annual	Actual number of persons held in prison	Number	Cyprus	2008	652
Annual	Actual number of persons held in prison	Number	Czechia	2008	20502
Annual	Actual number of persons held in prison	Number	Germany	2008	73793
Annual	Actual number of persons held in prison	Number	Denmark	2008	3451
Annual	Actual number of persons held in prison	Number	Estonia	2008	3656


CREATE TABLE tidy (
  "freq" VARCHAR,
  "indic_cr" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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