Baselight
Sign In

Youth Magistrates Defendants Dealt With

OpenDataNI

@ukgov.youth_magistrates_defendants_dealt_with

Loading...
Loading...

About this Dataset

Youth Magistrates Defendants Dealt With

Youth 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-14T07:01:07Z

Tables

Youth Magistrates Defendants Dealt With 2021

@ukgov.youth_magistrates_defendants_dealt_with.youth_magistrates_defendants_dealt_with_2021
  • 29.87 KB
  • 18 rows
  • 42 columns
Loading... 

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

Youth Magistrates Defendants Dealt With 2018

@ukgov.youth_magistrates_defendants_dealt_with.youth_magistrates_defendants_dealt_with_2018
  • 30.16 KB
  • 18 rows
  • 42 columns
Loading... 

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

Youth Magistrates Defendants Dealt With 2020

@ukgov.youth_magistrates_defendants_dealt_with.youth_magistrates_defendants_dealt_with_2020
  • 31.32 KB
  • 17 rows
  • 42 columns
Loading... 

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

Youth Magistrates Defendants Dealt With 2017

@ukgov.youth_magistrates_defendants_dealt_with.youth_magistrates_defendants_dealt_with_2017
  • 30.79 KB
  • 18 rows
  • 42 columns
Loading... 

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

Youth Magistrates Defendants Dealt With 2016

@ukgov.youth_magistrates_defendants_dealt_with.youth_magistrates_defendants_dealt_with_2016
  • 28.05 KB
  • 18 rows
  • 38 columns
Loading... 

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

Youth Magistrates Defendants Dealt With 2019

@ukgov.youth_magistrates_defendants_dealt_with.youth_magistrates_defendants_dealt_with_2019
  • 29.92 KB
  • 17 rows
  • 42 columns
Loading... 

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

Share link

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