About this Dataset

Adult Magistrates Defendants Dealt With

Adult Magistrates 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:02Z

Tables

Adult Magistrates Criminal Defendants Dealt With 2016

@ukgov.adult_magistrates_defendants_dealt_with.adult_magistrates_criminal_defendants_dealt_with_2016

33.54 kB
18 rows
39 columns

CREATE TABLE adult_magistrates_criminal_defendants_dealt_with_2016 (
  "processingoffice" VARCHAR,
  "alloffencesagainstperson_sum" BIGINT,
  "allsexualoffences_sum" BIGINT,
  "allburglaryoffences_sum" VARCHAR,
  "allrobberyoffences_sum" VARCHAR,
  "alltheftoffences_sum" BIGINT,
  "allfraudforgeryoffences_sum" BIGINT,
  "allcriminaldamageoffences_sum" BIGINT,
  "alloffencesagainststate_sum" BIGINT,
  "allotheroffences_sum" BIGINT,
  "alldrugoffences_sum" BIGINT,
  "allmotoringoffences_sum" BIGINT,
  "allnonpoliceoffences_sum" BIGINT,
  "allbreachoffences1_sum" BIGINT,
  "combinationoffences_sum" BIGINT,
  "allhybridoffences_sum" BIGINT,
  "allindictableonlyoffences_sum" BIGINT,
  "allitsoffences_sum" BIGINT,
  "allsummaryoffences_sum" BIGINT,
  "allbreachoffences_sum" BIGINT,
  "combination_sum" BIGINT,
  "committedcrown_sum" VARCHAR,
  "pleaguiltyonallcharges_sum" BIGINT,
  "alliwithdrawn_sum" BIGINT,
  "fixedpenaltydefault_sum" VARCHAR,
  "pleangfoundguilty_sum" BIGINT,
  "pleangacquitted_sum" BIGINT,
  "penaltynoticedisorder_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
);

Adult Magistrates Defendants Dealt With 2017

@ukgov.adult_magistrates_defendants_dealt_with.adult_magistrates_defendants_dealt_with_2017

35.76 kB
18 rows
42 columns

CREATE TABLE adult_magistrates_defendants_dealt_with_2017 (
  "processingofficeid" VARCHAR,
  "alloffencesagainstperson_sum" BIGINT,
  "allsexualoffences_sum" BIGINT,
  "allburglaryoffences_sum" BIGINT,
  "allrobberyoffences_sum" VARCHAR,
  "alltheftoffences_sum" BIGINT,
  "allfraudforgeryoffences_sum" BIGINT,
  "allcriminaldamageoffences_sum" BIGINT,
  "alloffencesagainststate_sum" BIGINT,
  "allotheroffences_sum" BIGINT,
  "alldrugoffences_sum" BIGINT,
  "allmotoringoffences_sum" BIGINT,
  "allnonpoliceoffences_sum" BIGINT,
  "allbreachoffences1_sum" BIGINT,
  "combinationoffences_sum" BIGINT,
  "allarticle29offences_sum" VARCHAR,
  "allhybridoffences_sum" BIGINT,
  "allindictableonlyoffences_sum" BIGINT,
  "allitsoffences_sum" BIGINT,
  "allmajormotoringoffences_sum" VARCHAR,
  "allminormotoringoffences_sum" VARCHAR,
  "allsummaryoffences_sum" BIGINT,
  "allbreachoffences_sum" BIGINT,
  "combination_sum" BIGINT,
  "committedcrown_sum" VARCHAR,
  "pleaguiltyonallcharges_sum" BIGINT,
  "alliwithdrawn_sum" BIGINT,
  "fixedpenaltydefault_sum" VARCHAR,
  "pleangfoundguilty_sum" BIGINT,
  "pleangacquitted_sum" BIGINT,
  "penaltynoticedisorder_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
);

Adult Magistrates Defendants Dealt With 2018

@ukgov.adult_magistrates_defendants_dealt_with.adult_magistrates_defendants_dealt_with_2018

35.81 kB
18 rows
42 columns

CREATE TABLE adult_magistrates_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" BIGINT,
  "alloffencesagainststate_sum" BIGINT,
  "allotheroffences_sum" BIGINT,
  "alldrugoffences_sum" BIGINT,
  "allmotoringoffences_sum" BIGINT,
  "allnonpoliceoffences_sum" BIGINT,
  "allbreachoffences1_sum" BIGINT,
  "combinationoffences_sum" BIGINT,
  "allarticle29offences_sum" VARCHAR,
  "allhybridoffences_sum" BIGINT,
  "allindictableonlyoffences_sum" BIGINT,
  "allitsoffences_sum" BIGINT,
  "allmajormotoringoffences_sum" VARCHAR,
  "allminormotoringoffences_sum" VARCHAR,
  "allsummaryoffences_sum" BIGINT,
  "allbreachoffences_sum" BIGINT,
  "combination_sum" BIGINT,
  "committedcrown_sum" VARCHAR,
  "pleaguiltyonallcharges_sum" BIGINT,
  "alliwithdrawn_sum" BIGINT,
  "fixedpenaltydefault_sum" VARCHAR,
  "pleangfoundguilty_sum" BIGINT,
  "pleangacquitted_sum" BIGINT,
  "penaltynoticedisorder_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
);

Adult Magistrates Defendants Dealt With 2019

@ukgov.adult_magistrates_defendants_dealt_with.adult_magistrates_defendants_dealt_with_2019

35.61 kB
18 rows
42 columns

CREATE TABLE adult_magistrates_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" BIGINT,
  "allotheroffences_sum" BIGINT,
  "alldrugoffences_sum" BIGINT,
  "allmotoringoffences_sum" BIGINT,
  "allnonpoliceoffences_sum" VARCHAR,
  "allbreachoffences1_sum" BIGINT,
  "combinationoffences_sum" BIGINT,
  "allarticle29offences_sum" VARCHAR,
  "allhybridoffences_sum" BIGINT,
  "allindictableonlyoffences_sum" BIGINT,
  "allitsoffences_sum" BIGINT,
  "allmajormotoringoffences_sum" VARCHAR,
  "allminormotoringoffences_sum" VARCHAR,
  "allsummaryoffences_sum" BIGINT,
  "allbreachoffences_sum" BIGINT,
  "combination_sum" BIGINT,
  "committedcrown_sum" VARCHAR,
  "pleaguiltyonallcharges_sum" BIGINT,
  "alliwithdrawn_sum" BIGINT,
  "fixedpenaltydefault_sum" BIGINT,
  "pleangfoundguilty_sum" BIGINT,
  "pleangacquitted_sum" BIGINT,
  "penaltynoticedisorder_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
);

Adult Magistrates Defendants Dealt With 2020

@ukgov.adult_magistrates_defendants_dealt_with.adult_magistrates_defendants_dealt_with_2020

36.12 kB
18 rows
42 columns

CREATE TABLE adult_magistrates_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" DOUBLE,
  "alloffencesagainststate_sum" DOUBLE,
  "allotheroffences_sum" DOUBLE,
  "alldrugoffences_sum" DOUBLE,
  "allmotoringoffences_sum" DOUBLE,
  "allnonpoliceoffences_sum" VARCHAR,
  "allbreachoffences1_sum" DOUBLE,
  "combinationoffences_sum" DOUBLE,
  "allarticle29offences_sum" VARCHAR,
  "allhybridoffences_sum" DOUBLE,
  "allindictableonlyoffences_sum" DOUBLE,
  "allitsoffences_sum" DOUBLE,
  "allmajormotoringoffences_sum" VARCHAR,
  "allminormotoringoffences_sum" VARCHAR,
  "allsummaryoffences_sum" DOUBLE,
  "allbreachoffences_sum" DOUBLE,
  "combination_sum" DOUBLE,
  "committedcrown_sum" VARCHAR,
  "pleaguiltyonallcharges_sum" DOUBLE,
  "alliwithdrawn_sum" DOUBLE,
  "fixedpenaltydefault_sum" VARCHAR,
  "pleangfoundguilty_sum" DOUBLE,
  "pleangacquitted_sum" DOUBLE,
  "penaltynoticedisorder_sum" VARCHAR,
  "missingage_sum" DOUBLE,
  "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
);

Adult Magistrates Defendants Dealt With 2021

@ukgov.adult_magistrates_defendants_dealt_with.adult_magistrates_defendants_dealt_with_2021

35.7 kB
18 rows
42 columns

CREATE TABLE adult_magistrates_defendants_dealt_with_2021 (
  "processingofficeid" VARCHAR,
  "alloffencesagainstperson_sum" BIGINT,
  "allsexualoffences_sum" BIGINT,
  "allburglaryoffences_sum" BIGINT,
  "allrobberyoffences_sum" VARCHAR,
  "alltheftoffences_sum" BIGINT,
  "allfraudforgeryoffences_sum" BIGINT,
  "allcriminaldamageoffences_sum" BIGINT,
  "alloffencesagainststate_sum" BIGINT,
  "allotheroffences_sum" BIGINT,
  "alldrugoffences_sum" BIGINT,
  "allmotoringoffences_sum" BIGINT,
  "allnonpoliceoffences_sum" VARCHAR,
  "allbreachoffences1_sum" BIGINT,
  "combinationoffences_sum" BIGINT,
  "allarticle29offences_sum" VARCHAR,
  "allhybridoffences_sum" BIGINT,
  "allindictableonlyoffences_sum" BIGINT,
  "allitsoffences_sum" BIGINT,
  "allmajormotoringoffences_sum" VARCHAR,
  "allminormotoringoffences_sum" VARCHAR,
  "allsummaryoffences_sum" BIGINT,
  "allbreachoffences_sum" BIGINT,
  "combination_sum" BIGINT,
  "committedcrown_sum" VARCHAR,
  "pleaguiltyonallcharges_sum" BIGINT,
  "alliwithdrawn_sum" BIGINT,
  "fixedpenaltydefault_sum" VARCHAR,
  "pleangfoundguilty_sum" BIGINT,
  "pleangacquitted_sum" BIGINT,
  "penaltynoticedisorder_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
);