Baselight

Personnel In The Criminal Justice System By Sex

Eurostat code: crim_just_job ยท (2008 - 2023)

@eurostat.crim_just_job

Personnel In The Criminal Justice System By Sex - Unpivoted
@eurostat.crim_just_job.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.

  • 65.04 KB
  • 10816 rows
  • 7 columns
freq

Freq

isco08

Isco08

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualProfessional judgesFemalesNumberAustria2008151
AnnualProfessional judgesFemalesNumberBosnia and Herzegovina2008548
AnnualProfessional judgesFemalesNumberCyprus200840
AnnualProfessional judgesFemalesNumberGermany20087195
AnnualProfessional judgesFemalesNumberDenmark2008447
AnnualProfessional judgesFemalesNumberSpain20082094
AnnualProfessional judgesFemalesNumberFinland2008406
AnnualProfessional judgesFemalesNumberCroatia20081245
AnnualProfessional judgesFemalesNumberHungary20081967
AnnualProfessional judgesFemalesNumberLithuania2008422

CREATE TABLE tidy (
  "freq" VARCHAR,
  "isco08" 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.