Suspects And Offenders By Sex

Eurostat code: crim_just_sex · (2008 - 2023)

@eurostat.crim_just_sex

Table List

2 tables(140.18 KB)

Suspects And Offenders By Sex - Unpivoted

Suspects And Offenders By Sex - Unpivoted

@eurostat.crim_just_sex.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.

67.56 KB
8642 rows
7 columns

freq Freq	leg_stat Leg Stat	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Convicted person	Females	Number	Albania	2008	569
Annual	Convicted person	Females	Number	Austria	2008	5406
Annual	Convicted person	Females	Number	Bulgaria	2008	2133
Annual	Convicted person	Females	Number	Switzerland	2008	16435
Annual	Convicted person	Females	Number	Cyprus	2008	11202
Annual	Convicted person	Females	Number	Czechia	2008	9502
Annual	Convicted person	Females	Number	Germany	2008	158618
Annual	Convicted person	Females	Number	Denmark	2008	31618
Annual	Convicted person	Females	Number	Finland	2008	43706
Annual	Convicted person	Females	Number	France	2008	68350


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

Share link

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