Reconstructed tidy output

Long labels or cell text are truncated in this evidence view.

Tidy rows for FDV_Table_21
FDV_Table_21
rowcoladdress.valueyearyear_sourcesummary_categorysummary_category_sourcesummary_characteristicsummary_characteristic_…
72R7C24292019–20R5C2Court level R6C1Higher R7C1
73R7C33532020–21R5C3Court level R6C1Higher R7C1
74R7C44042021–22R5C4Court level R6C1Higher R7C1
75R7C53842022–23R5C5Court level R6C1Higher R7C1
76R7C64042023–24R5C6Court level R6C1Higher R7C1
77R7C74232024–25R5C7Court level R6C1Higher R7C1
82R8C2103682019–20R5C2Court level R6C1Magistrates' R8C1
83R8C3156542020–21R5C3Court level R6C1Magistrates' R8C1
84R8C4163542021–22R5C4Court level R6C1Magistrates' R8C1
85R8C5192442022–23R5C5Court level R6C1Magistrates' R8C1
86R8C6194172023–24R5C6Court level R6C1Magistrates' R8C1
87R8C7187382024–25R5C7Court level R6C1Magistrates' R8C1
92R9C21082019–20R5C2Court level R6C1Children's R9C1
93R9C31482020–21R5C3Court level R6C1Children's R9C1
94R9C41822021–22R5C4Court level R6C1Children's R9C1
95R9C51912022–23R5C5Court level R6C1Children's R9C1
96R9C62192023–24R5C6Court level R6C1Children's R9C1
97R9C71812024–25R5C7Court level R6C1Children's R9C1
122R12C292742019–20R5C2SexR11C1MalesR12C1
123R12C3135132020–21R5C3SexR11C1MalesR12C1
124R12C4141342021–22R5C4SexR11C1MalesR12C1
125R12C5164182022–23R5C5SexR11C1MalesR12C1
126R12C6165212023–24R5C6SexR11C1MalesR12C1
127R12C7162092024–25R5C7SexR11C1MalesR12C1
132R13C216342019–20R5C2SexR11C1FemalesR13C1
133R13C326362020–21R5C3SexR11C1FemalesR13C1
134R13C428102021–22R5C4SexR11C1FemalesR13C1
135R13C534002022–23R5C5SexR11C1FemalesR13C1
136R13C635202023–24R5C6SexR11C1FemalesR13C1
137R13C731282024–25R5C7SexR11C1FemalesR13C1
162R16C25202019–20R5C2AgeR15C110–19 yearsR16C1
163R16C36392020–21R5C3AgeR15C110–19 yearsR16C1
164R16C46852021–22R5C4AgeR15C110–19 yearsR16C1
165R16C57602022–23R5C5AgeR15C110–19 yearsR16C1
166R16C67952023–24R5C6AgeR15C110–19 yearsR16C1
167R16C77092024–25R5C7AgeR15C110–19 yearsR16C1
172R17C215502019–20R5C2AgeR15C120–24 yearsR17C1
173R17C321532020–21R5C3AgeR15C120–24 yearsR17C1
174R17C421542021–22R5C4AgeR15C120–24 yearsR17C1
175R17C524692022–23R5C5AgeR15C120–24 yearsR17C1
176R17C624612023–24R5C6AgeR15C120–24 yearsR17C1
177R17C723992024–25R5C7AgeR15C120–24 yearsR17C1
182R18C218542019–20R5C2AgeR15C125–29 yearsR18C1
183R18C326952020–21R5C3AgeR15C125–29 yearsR18C1
184R18C429522021–22R5C4AgeR15C125–29 yearsR18C1
185R18C532122022–23R5C5AgeR15C125–29 yearsR18C1
186R18C631372023–24R5C6AgeR15C125–29 yearsR18C1
187R18C728772024–25R5C7AgeR15C125–29 yearsR18C1
192R19C219132019–20R5C2AgeR15C130–34 yearsR19C1
193R19C327572020–21R5C3AgeR15C130–34 yearsR19C1
194R19C428562021–22R5C4AgeR15C130–34 yearsR19C1
195R19C533642022–23R5C5AgeR15C130–34 yearsR19C1
196R19C633532023–24R5C6AgeR15C130–34 yearsR19C1
197R19C734512024–25R5C7AgeR15C130–34 yearsR19C1
202R20C217382019–20R5C2AgeR15C135–39 yearsR20C1
203R20C326922020–21R5C3AgeR15C135–39 yearsR20C1
204R20C427042021–22R5C4AgeR15C135–39 yearsR20C1
205R20C530712022–23R5C5AgeR15C135–39 yearsR20C1
206R20C631772023–24R5C6AgeR15C135–39 yearsR20C1
207R20C730412024–25R5C7AgeR15C135–39 yearsR20C1
212R21C214352019–20R5C2AgeR15C140–44 yearsR21C1
213R21C321832020–21R5C3AgeR15C140–44 yearsR21C1
214R21C422752021–22R5C4AgeR15C140–44 yearsR21C1
215R21C527332022–23R5C5AgeR15C140–44 yearsR21C1
216R21C628512023–24R5C6AgeR15C140–44 yearsR21C1
217R21C726272024–25R5C7AgeR15C140–44 yearsR21C1
222R22C210432019–20R5C2AgeR15C145–49 yearsR22C1
223R22C315562020–21R5C3AgeR15C145–49 yearsR22C1
224R22C416372021–22R5C4AgeR15C145–49 yearsR22C1
225R22C519512022–23R5C5AgeR15C145–49 yearsR22C1
226R22C619992023–24R5C6AgeR15C145–49 yearsR22C1
227R22C719702024–25R5C7AgeR15C145–49 yearsR22C1
232R23C24962019–20R5C2AgeR15C150–54 yearsR23C1
233R23C38522020–21R5C3AgeR15C150–54 yearsR23C1
234R23C49402021–22R5C4AgeR15C150–54 yearsR23C1
235R23C512782022–23R5C5AgeR15C150–54 yearsR23C1
236R23C612852023–24R5C6AgeR15C150–54 yearsR23C1
237R23C712462024–25R5C7AgeR15C150–54 yearsR23C1
242R24C23622019–20R5C2AgeR15C155 years and overR24C1
243R24C36262020–21R5C3AgeR15C155 years and overR24C1
244R24C47332021–22R5C4AgeR15C155 years and overR24C1
245R24C59822022–23R5C5AgeR15C155 years and overR24C1
246R24C69882023–24R5C6AgeR15C155 years and overR24C1
247R24C710192024–25R5C7AgeR15C155 years and overR24C1
252R25C234.92019–20R5C2AgeR15C1Mean (years)R25C1
253R25C335.52020–21R5C3AgeR15C1Mean (years)R25C1
254R25C435.72021–22R5C4AgeR15C1Mean (years)R25C1
255R25C536.22022–23R5C5AgeR15C1Mean (years)R25C1
256R25C636.32023–24R5C6AgeR15C1Mean (years)R25C1
257R25C736.52024–25R5C7AgeR15C1Mean (years)R25C1
262R26C2342019–20R5C2AgeR15C1Median (years)R26C1
263R26C334.72020–21R5C3AgeR15C1Median (years)R26C1
264R26C434.72021–22R5C4AgeR15C1Median (years)R26C1
265R26C535.22022–23R5C5AgeR15C1Median (years)R26C1
266R26C635.42023–24R5C6AgeR15C1Median (years)R26C1
267R26C735.42024–25R5C7AgeR15C1Median (years)R26C1
292R29C233952019–20R5C2Indigenous status R28C1Aboriginal and Torres S…R29C1
293R29C347592020–21R5C3Indigenous status R28C1Aboriginal and Torres S…R29C1
294R29C453342021–22R5C4Indigenous status R28C1Aboriginal and Torres S…R29C1
295R29C563192022–23R5C5Indigenous status R28C1Aboriginal and Torres S…R29C1
296R29C664752023–24R5C6Indigenous status R28C1Aboriginal and Torres S…R29C1
297R29C763272024–25R5C7Indigenous status R28C1Aboriginal and Torres S…R29C1
302R30C274832019–20R5C2Indigenous status R28C1Non-IndigenousR30C1
303R30C3113312020–21R5C3Indigenous status R28C1Non-IndigenousR30C1
304R30C4115432021–22R5C4Indigenous status R28C1Non-IndigenousR30C1
305R30C5134222022–23R5C5Indigenous status R28C1Non-IndigenousR30C1
306R30C6134832023–24R5C6Indigenous status R28C1Non-IndigenousR30C1
307R30C7129042024–25R5C7Indigenous status R28C1Non-IndigenousR30C1
312R31C2312019–20R5C2Indigenous status R28C1Not statedR31C1
313R31C3622020–21R5C3Indigenous status R28C1Not statedR31C1
314R31C4652021–22R5C4Indigenous status R28C1Not statedR31C1
315R31C5862022–23R5C5Indigenous status R28C1Not statedR31C1
316R31C6782023–24R5C6Indigenous status R28C1Not statedR31C1
317R31C71042024–25R5C7Indigenous status R28C1Not statedR31C1
322R32C2109032019–20R5C2Indigenous status R28C1Total finalised (exclud…R32C1
323R32C3161522020–21R5C3Indigenous status R28C1Total finalised (exclud…R32C1
324R32C4169412021–22R5C4Indigenous status R28C1Total finalised (exclud…R32C1
325R32C5198202022–23R5C5Indigenous status R28C1Total finalised (exclud…R32C1
326R32C6200402023–24R5C6Indigenous status R28C1Total finalised (exclud…R32C1
327R32C7193412024–25R5C7Indigenous status R28C1Total finalised (exclud…R32C1
352R35C2100682019–20R5C2Method of finalisationR34C1Adjudicated outcomes(b)R35C1
353R35C3151112020–21R5C3Method of finalisationR34C1Adjudicated outcomes(b)R35C1
354R35C4158552021–22R5C4Method of finalisationR34C1Adjudicated outcomes(b)R35C1
355R35C5186022022–23R5C5Method of finalisationR34C1Adjudicated outcomes(b)R35C1
356R35C6188202023–24R5C6Method of finalisationR34C1Adjudicated outcomes(b)R35C1
357R35C7181082024–25R5C7Method of finalisationR34C1Adjudicated outcomes(b)R35C1
362R36C2642019–20R5C2Method of finalisationR34C1AcquittedR36C1
363R36C31112020–21R5C3Method of finalisationR34C1AcquittedR36C1
364R36C41182021–22R5C4Method of finalisationR34C1AcquittedR36C1
365R36C51422022–23R5C5Method of finalisationR34C1AcquittedR36C1
366R36C61022023–24R5C6Method of finalisationR34C1AcquittedR36C1
367R36C71392024–25R5C7Method of finalisationR34C1AcquittedR36C1
372R37C2100112019–20R5C2Method of finalisationR34C1Guilty outcome(c)(d)R37C1
373R37C3150062020–21R5C3Method of finalisationR34C1Guilty outcome(c)(d)R37C1
374R37C4157332021–22R5C4Method of finalisationR34C1Guilty outcome(c)(d)R37C1
375R37C5184592022–23R5C5Method of finalisationR34C1Guilty outcome(c)(d)R37C1
376R37C6187162023–24R5C6Method of finalisationR34C1Guilty outcome(c)(d)R37C1
377R37C7179682024–25R5C7Method of finalisationR34C1Guilty outcome(c)(d)R37C1
382R38C298752019–20R5C2Method of finalisationR34C1Guilty plea by defendan…R38C1
383R38C3147942020–21R5C3Method of finalisationR34C1Guilty plea by defendan…R38C1
384R38C4155392021–22R5C4Method of finalisationR34C1Guilty plea by defendan…R38C1
385R38C5182532022–23R5C5Method of finalisationR34C1Guilty plea by defendan…R38C1
386R38C6185142023–24R5C6Method of finalisationR34C1Guilty plea by defendan…R38C1
387R38C7177862024–25R5C7Method of finalisationR34C1Guilty plea by defendan…R38C1
392R39C2922019–20R5C2Method of finalisationR34C1Guilty finding by courtR39C1
393R39C31332020–21R5C3Method of finalisationR34C1Guilty finding by courtR39C1
394R39C41312021–22R5C4Method of finalisationR34C1Guilty finding by courtR39C1
395R39C51402022–23R5C5Method of finalisationR34C1Guilty finding by courtR39C1
396R39C61402023–24R5C6Method of finalisationR34C1Guilty finding by courtR39C1
397R39C71382024–25R5C7Method of finalisationR34C1Guilty finding by courtR39C1
402R40C2472019–20R5C2Method of finalisationR34C1Guilty ex-parte R40C1
403R40C3712020–21R5C3Method of finalisationR34C1Guilty ex-parte R40C1
404R40C4722021–22R5C4Method of finalisationR34C1Guilty ex-parte R40C1
405R40C5632022–23R5C5Method of finalisationR34C1Guilty ex-parte R40C1
406R40C6632023–24R5C6Method of finalisationR34C1Guilty ex-parte R40C1
407R40C7432024–25R5C7Method of finalisationR34C1Guilty ex-parte R40C1
412R41C2..2019–20R5C2Method of finalisationR34C1Agreement of wrongdoing…R41C1
413R41C3..2020–21R5C3Method of finalisationR34C1Agreement of wrongdoing…R41C1
414R41C4..2021–22R5C4Method of finalisationR34C1Agreement of wrongdoing…R41C1
415R41C5..2022–23R5C5Method of finalisationR34C1Agreement of wrongdoing…R41C1
416R41C6..2023–24R5C6Method of finalisationR34C1Agreement of wrongdoing…R41C1
417R41C7..2024–25R5C7Method of finalisationR34C1Agreement of wrongdoing…R41C1
422R42C23312019–20R5C2Method of finalisationR34C1Transfer to other court…R42C1
423R42C33342020–21R5C3Method of finalisationR34C1Transfer to other court…R42C1
424R42C43422021–22R5C4Method of finalisationR34C1Transfer to other court…R42C1
425R42C54052022–23R5C5Method of finalisationR34C1Transfer to other court…R42C1
426R42C64172023–24R5C6Method of finalisationR34C1Transfer to other court…R42C1
427R42C74542024–25R5C7Method of finalisationR34C1Transfer to other court…R42C1
432R43C28102019–20R5C2Method of finalisationR34C1Withdrawn by prosecutio…R43C1
433R43C310042020–21R5C3Method of finalisationR34C1Withdrawn by prosecutio…R43C1
434R43C410622021–22R5C4Method of finalisationR34C1Withdrawn by prosecutio…R43C1
435R43C511942022–23R5C5Method of finalisationR34C1Withdrawn by prosecutio…R43C1
436R43C611952023–24R5C6Method of finalisationR34C1Withdrawn by prosecutio…R43C1
437R43C711962024–25R5C7Method of finalisationR34C1Withdrawn by prosecutio…R43C1
442R44C2112342019–20R5C2Method of finalisationR34C1Total finalised(e)R44C1
443R44C3164882020–21R5C3Method of finalisationR34C1Total finalised(e)R44C1
444R44C4172802021–22R5C4Method of finalisationR34C1Total finalised(e)R44C1
445R44C5202312022–23R5C5Method of finalisationR34C1Total finalised(e)R44C1
446R44C6204562023–24R5C6Method of finalisationR34C1Total finalised(e)R44C1
447R44C7198012024–25R5C7Method of finalisationR34C1Total finalised(e)R44C1
472R47C228262019–20R5C2Principal sentence(f)R46C1Custody in a correction…R47C1
473R47C333072020–21R5C3Principal sentence(f)R46C1Custody in a correction…R47C1
474R47C435062021–22R5C4Principal sentence(f)R46C1Custody in a correction…R47C1
475R47C541772022–23R5C5Principal sentence(f)R46C1Custody in a correction…R47C1
476R47C645562023–24R5C6Principal sentence(f)R46C1Custody in a correction…R47C1
477R47C748802024–25R5C7Principal sentence(f)R46C1Custody in a correction…R47C1
482R48C2332019–20R5C2Principal sentence(f)R46C1Intensive penalty in th…R48C1
483R48C3462020–21R5C3Principal sentence(f)R46C1Intensive penalty in th…R48C1
484R48C4442021–22R5C4Principal sentence(f)R46C1Intensive penalty in th…R48C1
485R48C5322022–23R5C5Principal sentence(f)R46C1Intensive penalty in th…R48C1
486R48C6202023–24R5C6Principal sentence(f)R46C1Intensive penalty in th…R48C1
487R48C7202024–25R5C7Principal sentence(f)R46C1Intensive penalty in th…R48C1
492R49C29392019–20R5C2Principal sentence(f)R46C1Fully suspended sentenc…R49C1
493R49C313192020–21R5C3Principal sentence(f)R46C1Fully suspended sentenc…R49C1
494R49C415172021–22R5C4Principal sentence(f)R46C1Fully suspended sentenc…R49C1
495R49C517512022–23R5C5Principal sentence(f)R46C1Fully suspended sentenc…R49C1
496R49C619062023–24R5C6Principal sentence(f)R46C1Fully suspended sentenc…R49C1
497R49C719022024–25R5C7Principal sentence(f)R46C1Fully suspended sentenc…R49C1
502R50C22242019–20R5C2Principal sentence(f)R46C1Community service / wor…R50C1
503R50C32622020–21R5C3Principal sentence(f)R46C1Community service / wor…R50C1
504R50C42592021–22R5C4Principal sentence(f)R46C1Community service / wor…R50C1
505R50C52562022–23R5C5Principal sentence(f)R46C1Community service / wor…R50C1
506R50C62412023–24R5C6Principal sentence(f)R46C1Community service / wor…R50C1
507R50C72632024–25R5C7Principal sentence(f)R46C1Community service / wor…R50C1
512R51C217152019–20R5C2Principal sentence(f)R46C1Moderate penalty in the…R51C1
513R51C327542020–21R5C3Principal sentence(f)R46C1Moderate penalty in the…R51C1
514R51C427652021–22R5C4Principal sentence(f)R46C1Moderate penalty in the…R51C1
515R51C531312022–23R5C5Principal sentence(f)R46C1Moderate penalty in the…R51C1
516R51C632712023–24R5C6Principal sentence(f)R46C1Moderate penalty in the…R51C1
517R51C730222024–25R5C7Principal sentence(f)R46C1Moderate penalty in the…R51C1
522R52C230692019–20R5C2Principal sentence(f)R46C1Monetary penalties(g)R52C1
523R52C355152020–21R5C3Principal sentence(f)R46C1Monetary penalties(g)R52C1
524R52C454912021–22R5C4Principal sentence(f)R46C1Monetary penalties(g)R52C1
525R52C564712022–23R5C5Principal sentence(f)R46C1Monetary penalties(g)R52C1
526R52C659242023–24R5C6Principal sentence(f)R46C1Monetary penalties(g)R52C1
527R52C754662024–25R5C7Principal sentence(f)R46C1Monetary penalties(g)R52C1
532R53C230642019–20R5C2Principal sentence(f)R46C1FinesR53C1
533R53C355152020–21R5C3Principal sentence(f)R46C1FinesR53C1
534R53C454802021–22R5C4Principal sentence(f)R46C1FinesR53C1
535R53C564512022–23R5C5Principal sentence(f)R46C1FinesR53C1
536R53C659192023–24R5C6Principal sentence(f)R46C1FinesR53C1
537R53C754592024–25R5C7Principal sentence(f)R46C1FinesR53C1
542R54C25962019–20R5C2Principal sentence(f)R46C1Good behaviour (incl. b…R54C1
543R54C39802020–21R5C3Principal sentence(f)R46C1Good behaviour (incl. b…R54C1
544R54C410842021–22R5C4Principal sentence(f)R46C1Good behaviour (incl. b…R54C1
545R54C511552022–23R5C5Principal sentence(f)R46C1Good behaviour (incl. b…R54C1
546R54C610862023–24R5C6Principal sentence(f)R46C1Good behaviour (incl. b…R54C1
547R54C79562024–25R5C7Principal sentence(f)R46C1Good behaviour (incl. b…R54C1
552R55C26082019–20R5C2Principal sentence(f)R46C1Nominal and other penal…R55C1
553R55C38252020–21R5C3Principal sentence(f)R46C1Nominal and other penal…R55C1
554R55C410722021–22R5C4Principal sentence(f)R46C1Nominal and other penal…R55C1
555R55C514952022–23R5C5Principal sentence(f)R46C1Nominal and other penal…R55C1
556R55C617232023–24R5C6Principal sentence(f)R46C1Nominal and other penal…R55C1
557R55C714662024–25R5C7Principal sentence(f)R46C1Nominal and other penal…R55C1
562R56C2100112019–20R5C2Principal sentence(f)R46C1Total guilty outcome(h)R56C1
563R56C3150062020–21R5C3Principal sentence(f)R46C1Total guilty outcome(h)R56C1
564R56C4157332021–22R5C4Principal sentence(f)R46C1Total guilty outcome(h)R56C1
565R56C5184592022–23R5C5Principal sentence(f)R46C1Total guilty outcome(h)R56C1
566R56C6187162023–24R5C6Principal sentence(f)R46C1Total guilty outcome(h)R56C1
567R56C7179682024–25R5C7Principal sentence(f)R46C1Total guilty outcome(h)R56C1