About this Dataset

Crown Court Defendants Dealt With

Crown Court Defendants Dealt with including a breakdown by Processing Court Office, types of charges, plea and finding information.
Publisher name: OpenDataNI
Last updated: 2023-04-14T06:57:48Z

Tables

Crown Court Defendants Dealt With 2017

@ukgov.crown_court_defendants_dealt_with.crown_court_defendants_dealt_with_2017

29.08 KB
7 rows
38 columns


CREATE TABLE crown_court_defendants_dealt_with_2017 (
  "processingofficeid" VARCHAR,
  "alloffencesagainstperson_sum" BIGINT,
  "allsexualoffences_sum" BIGINT,
  "allburglaryoffences_sum" BIGINT,
  "allrobberyoffences_sum" BIGINT,
  "alltheftoffences_sum" BIGINT,
  "allfraudforgeryoffences_sum" BIGINT,
  "allcriminaldamageoffences_sum" VARCHAR,
  "alloffencesagainststate_sum" VARCHAR,
  "allotheroffences_sum" BIGINT,
  "alldrugoffences_sum" BIGINT,
  "allmotoringoffences_sum" BIGINT,
  "allnonpoliceoffences_sum" VARCHAR,
  "combinationoffences_sum" BIGINT,
  "allarticle29offences_sum" VARCHAR,
  "allhybridoffences_sum" BIGINT,
  "allindictableonlyoffences_sum" BIGINT,
  "allitsoffences_sum" BIGINT,
  "allmajormotoringoffences_sum" VARCHAR,
  "allminormotoringoffences_sum" VARCHAR,
  "allsummaryoffences_sum" VARCHAR,
  "allbreachoffences_sum" VARCHAR,
  "combination_sum" BIGINT,
  "pleaguiltyonallcharges_sum" BIGINT,
  "pleangfoundguilty_sum" BIGINT,
  "pleangacquitted_sum" BIGINT,
  "alliwithdrawn_sum" VARCHAR,
  "missingage_sum" VARCHAR,
  "under18_sum" VARCHAR,
  "age18to25_sum" BIGINT,
  "age26to30_sum" BIGINT,
  "age31to35_sum" BIGINT,
  "age36to40_sum" BIGINT,
  "age41to45_sum" BIGINT,
  "age46to50_sum" BIGINT,
  "age51to55_sum" BIGINT,
  "age56andover_sum" BIGINT,
  "numberofdefendants" BIGINT
);

Crown Court Defendants Dealt With 2018

@ukgov.crown_court_defendants_dealt_with.crown_court_defendants_dealt_with_2018

29.07 KB
7 rows
38 columns


CREATE TABLE crown_court_defendants_dealt_with_2018 (
  "processingofficeid" VARCHAR,
  "alloffencesagainstperson_sum" BIGINT,
  "allsexualoffences_sum" BIGINT,
  "allburglaryoffences_sum" BIGINT,
  "allrobberyoffences_sum" VARCHAR,
  "alltheftoffences_sum" BIGINT,
  "allfraudforgeryoffences_sum" BIGINT,
  "allcriminaldamageoffences_sum" VARCHAR,
  "alloffencesagainststate_sum" VARCHAR,
  "allotheroffences_sum" BIGINT,
  "alldrugoffences_sum" BIGINT,
  "allmotoringoffences_sum" BIGINT,
  "allnonpoliceoffences_sum" VARCHAR,
  "combinationoffences_sum" BIGINT,
  "allarticle29offences_sum" VARCHAR,
  "allhybridoffences_sum" BIGINT,
  "allindictableonlyoffences_sum" BIGINT,
  "allitsoffences_sum" BIGINT,
  "allmajormotoringoffences_sum" VARCHAR,
  "allminormotoringoffences_sum" VARCHAR,
  "allsummaryoffences_sum" VARCHAR,
  "allbreachoffences_sum" VARCHAR,
  "combination_sum" BIGINT,
  "pleaguiltyonallcharges_sum" BIGINT,
  "pleangfoundguilty_sum" BIGINT,
  "pleangacquitted_sum" BIGINT,
  "alliwithdrawn_sum" VARCHAR,
  "missingage_sum" BIGINT,
  "under18_sum" VARCHAR,
  "age18to25_sum" BIGINT,
  "age26to30_sum" BIGINT,
  "age31to35_sum" BIGINT,
  "age36to40_sum" BIGINT,
  "age41to45_sum" BIGINT,
  "age46to50_sum" BIGINT,
  "age51to55_sum" BIGINT,
  "age56andover_sum" BIGINT,
  "numberofdefendants" BIGINT
);

Crown Court Defendants Dealt With 2019

@ukgov.crown_court_defendants_dealt_with.crown_court_defendants_dealt_with_2019

29.04 KB
7 rows
38 columns


CREATE TABLE crown_court_defendants_dealt_with_2019 (
  "processingofficeid" VARCHAR,
  "alloffencesagainstperson_sum" BIGINT,
  "allsexualoffences_sum" BIGINT,
  "allburglaryoffences_sum" VARCHAR,
  "allrobberyoffences_sum" VARCHAR,
  "alltheftoffences_sum" BIGINT,
  "allfraudforgeryoffences_sum" BIGINT,
  "allcriminaldamageoffences_sum" BIGINT,
  "alloffencesagainststate_sum" VARCHAR,
  "allotheroffences_sum" BIGINT,
  "alldrugoffences_sum" BIGINT,
  "allmotoringoffences_sum" BIGINT,
  "allnonpoliceoffences_sum" VARCHAR,
  "combinationoffences_sum" BIGINT,
  "allarticle29offences_sum" VARCHAR,
  "allhybridoffences_sum" BIGINT,
  "allindictableonlyoffences_sum" BIGINT,
  "allitsoffences_sum" BIGINT,
  "allmajormotoringoffences_sum" VARCHAR,
  "allminormotoringoffences_sum" VARCHAR,
  "allsummaryoffences_sum" VARCHAR,
  "allbreachoffences_sum" VARCHAR,
  "combination_sum" BIGINT,
  "pleaguiltyonallcharges_sum" BIGINT,
  "pleangfoundguilty_sum" BIGINT,
  "pleangacquitted_sum" BIGINT,
  "alliwithdrawn_sum" VARCHAR,
  "missingage_sum" BIGINT,
  "under18_sum" VARCHAR,
  "age18to25_sum" BIGINT,
  "age26to30_sum" BIGINT,
  "age31to35_sum" BIGINT,
  "age36to40_sum" BIGINT,
  "age41to45_sum" BIGINT,
  "age46to50_sum" BIGINT,
  "age51to55_sum" BIGINT,
  "age56andover_sum" BIGINT,
  "numberofdefendants" BIGINT
);

Crown Court Defendants Dealt With 2020

@ukgov.crown_court_defendants_dealt_with.crown_court_defendants_dealt_with_2020

29.41 KB
7 rows
38 columns


CREATE TABLE crown_court_defendants_dealt_with_2020 (
  "processingofficeid" VARCHAR,
  "alloffencesagainstperson_sum" DOUBLE,
  "allsexualoffences_sum" DOUBLE,
  "allburglaryoffences_sum" VARCHAR,
  "allrobberyoffences_sum" VARCHAR,
  "alltheftoffences_sum" DOUBLE,
  "allfraudforgeryoffences_sum" DOUBLE,
  "allcriminaldamageoffences_sum" VARCHAR,
  "alloffencesagainststate_sum" VARCHAR,
  "allotheroffences_sum" DOUBLE,
  "alldrugoffences_sum" DOUBLE,
  "allmotoringoffences_sum" DOUBLE,
  "allnonpoliceoffences_sum" VARCHAR,
  "combinationoffences_sum" DOUBLE,
  "allarticle29offences_sum" VARCHAR,
  "allhybridoffences_sum" DOUBLE,
  "allindictableonlyoffences_sum" DOUBLE,
  "allitsoffences_sum" DOUBLE,
  "allmajormotoringoffences_sum" VARCHAR,
  "allminormotoringoffences_sum" VARCHAR,
  "allsummaryoffences_sum" VARCHAR,
  "allbreachoffences_sum" VARCHAR,
  "combination_sum" DOUBLE,
  "pleaguiltyonallcharges_sum" DOUBLE,
  "pleangfoundguilty_sum" DOUBLE,
  "pleangacquitted_sum" DOUBLE,
  "alliwithdrawn_sum" VARCHAR,
  "missingage_sum" VARCHAR,
  "under18_sum" VARCHAR,
  "age18to25_sum" DOUBLE,
  "age26to30_sum" DOUBLE,
  "age31to35_sum" DOUBLE,
  "age36to40_sum" DOUBLE,
  "age41to45_sum" DOUBLE,
  "age46to50_sum" DOUBLE,
  "age51to55_sum" DOUBLE,
  "age56andover_sum" DOUBLE,
  "numberofdefendants" BIGINT
);

Crown Court Defendants Dealt With 2021

@ukgov.crown_court_defendants_dealt_with.crown_court_defendants_dealt_with_2021

29.04 KB
7 rows
38 columns


CREATE TABLE crown_court_defendants_dealt_with_2021 (
  "processingofficeid" VARCHAR,
  "alloffencesagainstperson_sum" BIGINT,
  "allsexualoffences_sum" BIGINT,
  "allburglaryoffences_sum" BIGINT,
  "allrobberyoffences_sum" VARCHAR,
  "alltheftoffences_sum" VARCHAR,
  "allfraudforgeryoffences_sum" BIGINT,
  "allcriminaldamageoffences_sum" BIGINT,
  "alloffencesagainststate_sum" VARCHAR,
  "allotheroffences_sum" BIGINT,
  "alldrugoffences_sum" BIGINT,
  "allmotoringoffences_sum" BIGINT,
  "allnonpoliceoffences_sum" VARCHAR,
  "combinationoffences_sum" BIGINT,
  "allarticle29offences_sum" VARCHAR,
  "allhybridoffences_sum" BIGINT,
  "allindictableonlyoffences_sum" BIGINT,
  "allitsoffences_sum" BIGINT,
  "allmajormotoringoffences_sum" VARCHAR,
  "allminormotoringoffences_sum" VARCHAR,
  "allsummaryoffences_sum" VARCHAR,
  "allbreachoffences_sum" VARCHAR,
  "combination_sum" BIGINT,
  "pleaguiltyonallcharges_sum" BIGINT,
  "pleangfoundguilty_sum" BIGINT,
  "pleangacquitted_sum" BIGINT,
  "alliwithdrawn_sum" VARCHAR,
  "missingage_sum" BIGINT,
  "under18_sum" VARCHAR,
  "age18to25_sum" BIGINT,
  "age26to30_sum" BIGINT,
  "age31to35_sum" BIGINT,
  "age36to40_sum" BIGINT,
  "age41to45_sum" BIGINT,
  "age46to50_sum" BIGINT,
  "age51to55_sum" BIGINT,
  "age56andover_sum" BIGINT,
  "numberofdefendants" BIGINT
);