About this Dataset

Prosecutions And Convictions By Ethnicity

The data shows the ‘conviction ratio’ for defendants from different ethnic groups. A defendant is someone who has been accused of committing a crime. The conviction ratio is the number of defendants found guilty of a crime in court, as a percentage of all defendants who were prosecuted. Further analyses are shown by ethnicity and sex, ethnicity and age group, and ethnicity and offence. This data is taken from the Ministry of Justice's criminal justice statistics and published on 'Ethnicity facts and figures'.
Publisher name: Race Disparity Unit
Last updated: 2024-06-14T04:03:06Z

Tables

Prosecutions And Convictions

@ukgov.prosecutions_and_convictions_by_ethnicity.prosecutions_and_convictions

35.97 kB
2,624 rows
13 columns

CREATE TABLE prosecutions_and_convictions (
  "measure" VARCHAR,
  "ethnicity" VARCHAR,
  "ethnicity_type" VARCHAR,
  "time" BIGINT,
  "time_type" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "offence_group" VARCHAR,
  "police_force_area" VARCHAR,
  "value" DOUBLE,
  "value_type" VARCHAR,
  "denominator_prosecutions_at_magistrates_court" BIGINT  -- Denominator (Prosecutions At Magistrates Court),
  "numerator_convictions_and_magistrates_court_and_crown_court" BIGINT  -- Numerator (Convictions And Magistrates Court And Crown Court)
);