Criminal offenses
Criminal offenses
KRXAF_raw <-
statgl_url("KRXAF", lang = language) %>%
statgl_fetch(
"precautionary measure" = px_all(),
"type of offence" = px_all(),
time = px_top(1),
.col_code = TRUE
) %>%
as_tibble()
KRXAF <-
KRXAF_raw %>%
filter(`type of offence` %in% unique(KRXAF_raw[[2]])[c(1, 2, 39, 49)]) %>%
mutate(
`type of offence` = `type of offence` %>% fct_inorder(),
`precautionary measure` = `precautionary measure` %>% fct_inorder()
) %>%
spread(`type of offence`, value)
KRXAF %>%
select(-time) %>%
rename(" " = 1) %>%
statgl_table(replace_0s = TRUE) %>%
pack_rows(index = KRXAF[["time"]] %>% table()) %>%
row_spec(1, bold = TRUE)
|
Total
|
Criminal Law in total
|
Traffic Law in total
|
Special Laws in total
|
2022
|
Total
|
2.160
|
1.278
|
458
|
424
|
Total incriminating decisions
|
1.660
|
879
|
425
|
356
|
Warning
|
53
|
47
|
1
|
5
|
Suspended sentence
|
270
|
222
|
8
|
40
|
Unsuspended imprisonment
|
203
|
159
|
15
|
29
|
Fine
|
883
|
229
|
391
|
263
|
Community service
|
15
|
14
|
1
|
-
|
Withdrawal of charges
|
117
|
93
|
6
|
18
|
Notification of social services (under 15 y/o)
|
119
|
115
|
3
|
1
|
Acquittal - Not incriminating
|
157
|
137
|
9
|
11
|
Terminated - Not incriminating
|
343
|
262
|
24
|
57
|
See the table in our Statbank: KRXAF
KRXAF_raw <-
statgl_url("KRXAN", lang = language) %>%
statgl_fetch(
"number of reports" = px_all(),
"type of offence" = px_all(),
time = px_top(3),
.col_code = TRUE
) %>%
as_tibble()
KRXAF <-
KRXAF_raw %>%
filter(`type of offence` %in% unique(KRXAF_raw[[2]])[c(1, 2, 39, 49)]) %>%
arrange(desc(time)) %>%
mutate(
time = time %>% fct_inorder(),
`type of offence` = `type of offence` %>% fct_inorder(),
`number of reports` = `number of reports` %>% fct_inorder()
) %>%
spread(`type of offence`, value) %>%
arrange(time)
KRXAF %>%
select(-time) %>%
rename(" " = 1) %>%
statgl_table() %>%
pack_rows(index = KRXAF[["time"]] %>% table())
|
Total
|
Criminal law in total
|
Traffic law in total
|
Special laws in total
|
2022
|
Number of reports
|
5.250
|
3.610
|
767
|
873
|
Number of reports resulting in charges
|
3.262
|
2.019
|
653
|
590
|
Number of reports resulting in decisions
|
970
|
446
|
330
|
194
|
2021
|
Number of reports
|
5.629
|
3.920
|
878
|
831
|
Number of reports resulting in charges
|
3.890
|
2.526
|
758
|
606
|
Number of reports resulting in decisions
|
2.003
|
1.104
|
496
|
403
|
2020
|
Number of reports
|
6.030
|
4.222
|
1.101
|
707
|
Number of reports resulting in charges
|
4.356
|
2.792
|
1.020
|
544
|
Number of reports resulting in decisions
|
3.100
|
1.822
|
849
|
429
|
See the table in our Statbank: KRXAN
Last updated: 06. juni 2023
LS0tDQpwYXJhbXM6DQogIGxhbmc6ICJkYSINCm91dHB1dDoNCiAgc3RhdGdsOjpzdGF0Z2xfcmVwb3J0Og0KICAgIGFuY2hvcl9zZWN0aW9uczogZmFsc2UNCiAgICBjb2RlX2Rvd25sb2FkOiB0cnVlDQogICAgY29kZV9mb2xkaW5nOiBoaWRlDQplZGl0b3Jfb3B0aW9uczogDQogIGNodW5rX291dHB1dF90eXBlOiBjb25zb2xlDQotLS0NCg0KYGBge3Igc2V0dXAsIGluY2x1ZGU9RkFMU0V9DQoNCmtuaXRyOjpvcHRzX2NodW5rJHNldCgNCgllY2hvICAgID0gVFJVRSwNCgltZXNzYWdlID0gRkFMU0UsDQoJd2FybmluZyA9IEZBTFNFDQopDQoNCnsNCmxpYnJhcnkoInRpZHl2ZXJzZSIpDQpsaWJyYXJ5KCJzdGF0Z2wiKQ0KbGlicmFyeSgia2FibGVFeHRyYSIpDQpsaWJyYXJ5KCJsdWJyaWRhdGUiKQ0KbGlicmFyeSgieWFtbCIpDQp9DQogIA0KbGFuZ3VhZ2UgIDwtIHBhcmFtcyRsYW5nDQpvcHRpb24gICAgPC0gcGFzdGUwKCI/bGFuZz0iLCBsYW5ndWFnZSwgIiZzZWxlY3QiKQ0KbG9nbyAgICAgIDwtIHBhc3RlMChnZXR3ZCgpLCIvYWRkL2xvZ28uZ2lmIikNCnR4dCAgICAgICA8LSByZWFkX3lhbWwocGFzdGUwKGdldHdkKCksICIvYWRkL3R4dC55bWwiKSwgZmlsZUVuY29kaW5nID0gIklTTy04ODU5LTEiKQ0Kc291cmNlICAgIDwtIHR4dCRzb3VyY2VbbGFuZ3VhZ2VdICU+JSB1bmxpc3QoKQ0KYGBgDQoNCmBgYHtjc3MsIGVjaG8gPSBGQUxTRX0NCg0KLmFjY29yZGlvbiB7DQogIGJhY2tncm91bmQtY29sb3I6ICM5MTk5MDA7DQogIGNvbG9yOiB3aGl0ZTsNCiAgY3Vyc29yOiBwb2ludGVyOw0KICBwYWRkaW5nOiAxOHB4Ow0KICB3aWR0aDogMTAwJTsNCiAgYm9yZGVyOiBub25lOw0KICBib3JkZXItcmFkaXVzOiA1cHg7DQogIHRleHQtYWxpZ246IGxlZnQ7DQogIG91dGxpbmU6IG5vbmU7DQogIGZvbnQtc2l6ZTogMTVweDsNCiAgdHJhbnNpdGlvbjogMC40czsNCn0NCg0KLmFjdGl2ZSwgLmFjY29yZGlvbjpob3ZlciB7DQogIGJhY2tncm91bmQtY29sb3I6ICNmOTcyNDI7DQp9DQoNCi5hY2NvcmRpb246YWZ0ZXIgew0KICBjb250ZW50OiAnXDAwMkInOw0KICBjb2xvcjogIzc3NzsNCiAgZm9udC13ZWlnaHQ6IGJvbGQ7DQogIGZsb2F0OiByaWdodDsNCiAgbWFyZ2luLWxlZnQ6IDVweDsNCn0NCg0KLmFjdGl2ZTphZnRlciB7DQogIGNvbnRlbnQ6ICJcMjIxMiI7DQp9DQoNCi5wYW5lbCB7DQogIHBhZGRpbmc6IDBweCA1cHggMHB4IDVweDsNCiAgYmFja2dyb3VuZC1jb2xvcjogd2hpdGU7DQogIG1heC1oZWlnaHQ6IDA7DQogIG92ZXJmbG93OiBoaWRkZW47DQogIHRyYW5zaXRpb246IG1heC1oZWlnaHQgMC4ycyBlYXNlLW91dDsNCn0NCg0KZGV0YWlscyB7DQogIHdpZHRoOiAxMDAlOw0KfQ0KDQpkZXRhaWxzID4gc3VtbWFyeSB7DQogIHBhZGRpbmc6IDRweCAxMnB4Ow0KICB3aWR0aDogMTAwJTsNCiAgYmFja2dyb3VuZC1jb2xvcjogIzAwN2Y5OTsNCiAgYm9yZGVyOiBzb2xpZDsNCiAgYm9yZGVyLWNvbG9yOiB3aGl0ZTsNCiAgYm9yZGVyLXJhZGl1czogNXB4Ow0KICBjdXJzb3I6IHBvaW50ZXI7DQogIGZvbnQtc2l6ZTogMTVweDsNCiAgY29sb3I6IHdoaXRlOw0KfQ0KDQpkZXRhaWxzW29wZW5dID4gc3VtbWFyeSB7DQogIGJhY2tncm91bmQtY29sb3I6ICNmYWE0MWE7DQp9DQoNCg0KLnRpdGxlIHsNCiAgY29sb3I6ICMxYjU0NjM7DQogIGZvbnQtc2l6ZTogMzZweDsNCn0NCg0KDQoucGVyc29uZXIgew0KICBib3gtc2hhZG93OiAzcHggM3B4IDRweCBibGFjazsNCiAgYmFja2dyb3VuZDogIzAwNDQ1OTsNCiAgcGFkZGluZy1yaWdodDogMTVweDsNCiAgcGFkZGluZy1sZWZ0OiAxNnB4Ow0KICBwYWRkaW5nLXRvcDogMC4xcHg7DQogIHBhZGRpbmctYm90dG9tOiAxcHg7DQogIGZvbnQtc2l6ZTogMTFweDsNCiAgY29sb3I6IHdoaXRlOw0KICB2ZXJ0aWNhbC1hbGlnbjogbWlkZGxlOw0KfQ0KDQouw7hrb25vbWkgew0KICBib3gtc2hhZG93OiAzcHggM3B4IDRweCBibGFjazsNCiAgYmFja2dyb3VuZDogIzAwN0Y5OTsNCiAgcGFkZGluZy1yaWdodDogMTVweDsNCiAgcGFkZGluZy1sZWZ0OiAxNnB4Ow0KICBwYWRkaW5nLXRvcDogMXB4Ow0KICBwYWRkaW5nLWJvdHRvbTogMC4xcHg7DQogIGZvbnQtc2l6ZTogMTFweDsNCiAgY29sb3I6IHdoaXRlOw0KICB2ZXJ0aWNhbC1hbGlnbjogbWlkZGxlOw0KfQ0KDQoudHbDpnJnw6VlbmRlIHsNCiAgYm94LXNoYWRvdzogM3B4IDNweCA0cHggYmxhY2s7DQogIGJhY2tncm91bmQ6ICNmYWE0MWE7DQogIHBhZGRpbmctcmlnaHQ6IDE1cHg7DQogIHBhZGRpbmctbGVmdDogMTZweDsNCiAgcGFkZGluZy10b3A6IDAuMXB4Ow0KICBwYWRkaW5nLWJvdHRvbTogMXB4Ow0KICBmb250LXNpemU6IDExcHg7DQogIGNvbG9yOiB3aGl0ZTsNCiAgdmVydGljYWwtYWxpZ246IG1pZGRsZTsNCn0NCg0KLmNvbnRhaW5lciB7DQogIHdpZHRoOiBpbmhlcml0Ow0KfQ0KDQoNCmBgYA0KDQpgYGB7ciB4YXJpbmdhbkV4dHJhLWNsaXBib2FyZCwgZWNobz1GQUxTRX0NCnhhcmluZ2FuRXh0cmE6OnVzZV9jbGlwYm9hcmQoKQ0KYGBgDQoNCg0KPGJyPg0KPGJyPg0KDQo8Y2VudGVyPg0KDQoNCg0KLS0tDQoNCiMgW2ByIHR4dCRLUiR0aXRsZVtsYW5ndWFnZV1gXXsudGl0bGV9DQogDQotLS0NCjwvY2VudGVyPg0KPGRldGFpbHMgb3Blbj4gPHN1bW1hcnk+IGByIHR4dCRLUiR0aXRsZVtsYW5ndWFnZV1gIDwvc3VtbWFyeT4gDQo8YnI+DQo8YnV0dG9uIGNsYXNzPSJhY2NvcmRpb24iPiBgciBwYXN0ZTAoIioqVGFiZWwgMTogKioiLCBzdGF0Z2xfbWV0YShzdGF0Z2xfdXJsKCJLUlhBRiIsIGxhbmcgPSBsYW5ndWFnZSkpWzFdJHRpdGxlKSBgIDwvYnV0dG9uPiA8ZGl2IGNsYXNzPSJwYW5lbCI+DQpgYGB7ciBLUlhBRn0NCg0KS1JYQUZfcmF3IDwtDQogIHN0YXRnbF91cmwoIktSWEFGIiwgbGFuZyA9IGxhbmd1YWdlKSAlPiUNCiAgc3RhdGdsX2ZldGNoKA0KICAgICJwcmVjYXV0aW9uYXJ5IG1lYXN1cmUiID0gcHhfYWxsKCksDQogICAgInR5cGUgb2Ygb2ZmZW5jZSIgICAgICAgPSBweF9hbGwoKSwNCiAgICB0aW1lICAgICAgICAgICAgICAgICAgICA9IHB4X3RvcCgxKSwNCiAgICAuY29sX2NvZGUgPSBUUlVFDQogICkgJT4lIA0KICBhc190aWJibGUoKQ0KDQpLUlhBRiA8LSANCiAgS1JYQUZfcmF3ICU+JQ0KICBmaWx0ZXIoYHR5cGUgb2Ygb2ZmZW5jZWAgJWluJSB1bmlxdWUoS1JYQUZfcmF3W1syXV0pW2MoMSwgMiwgMzksIDQ5KV0pICU+JSANCiAgbXV0YXRlKA0KICAgIGB0eXBlIG9mIG9mZmVuY2VgID0gIGB0eXBlIG9mIG9mZmVuY2VgICU+JSBmY3RfaW5vcmRlcigpLA0KICAgYHByZWNhdXRpb25hcnkgbWVhc3VyZWAgID0gYHByZWNhdXRpb25hcnkgbWVhc3VyZWAgICU+JSBmY3RfaW5vcmRlcigpDQogICkgJT4lIA0KICBzcHJlYWQoYHR5cGUgb2Ygb2ZmZW5jZWAsIHZhbHVlKQ0KDQoNCktSWEFGICU+JSANCiAgc2VsZWN0KC10aW1lKSAlPiUgDQogIHJlbmFtZSgiICIgPSAxKSAlPiUgDQogIHN0YXRnbF90YWJsZShyZXBsYWNlXzBzID0gVFJVRSkgJT4lIA0KICBwYWNrX3Jvd3MoaW5kZXggPSBLUlhBRltbInRpbWUiXV0gJT4lIHRhYmxlKCkpICU+JSANCiAgcm93X3NwZWMoMSwgYm9sZCA9IFRSVUUpDQoNCg0KYGBgDQo8YnI+DQpbIVtdKGByIGxvZ29gKXt3aWR0aD00MH1gciBwYXN0ZShzb3VyY2UsICJLUlhBRiIpYF0oYHIgcGFzdGUwKCJodHRwczovL2Jhbmsuc3RhdC5nbDo0NDMvc3EvMzQ0NDY1MzktMzI0ZC00NzJkLTlhZGMtODBlODlhMDViOWIwIiwgb3B0aW9uKWApe3RhcmdldD0iX2JsYW5rIn0NCjwvZGl2PiANCg0KPGJ1dHRvbiBjbGFzcz0iYWNjb3JkaW9uIj4gYHIgcGFzdGUwKCIqKlRhYmVsIDI6ICoqIiwgc3RhdGdsX21ldGEoc3RhdGdsX3VybCgiS1JYQU4iLCBsYW5nID0gbGFuZ3VhZ2UpKVsxXSR0aXRsZSkgYCA8L2J1dHRvbj4gPGRpdiBjbGFzcz0icGFuZWwiPg0KDQpgYGB7ciBLUlhBTn0NCg0KS1JYQUZfcmF3IDwtDQogIHN0YXRnbF91cmwoIktSWEFOIiwgbGFuZyA9IGxhbmd1YWdlKSAlPiUgDQogIHN0YXRnbF9mZXRjaCgNCiAgICAibnVtYmVyIG9mIHJlcG9ydHMiID0gcHhfYWxsKCksDQogICAgInR5cGUgb2Ygb2ZmZW5jZSIgICA9IHB4X2FsbCgpLA0KICAgIHRpbWUgICAgICAgICAgICAgICAgPSBweF90b3AoMyksDQogICAgLmNvbF9jb2RlICAgICAgICAgICA9IFRSVUUNCiAgKSAlPiUgDQogIGFzX3RpYmJsZSgpDQoNCg0KS1JYQUYgPC0gDQogIEtSWEFGX3JhdyAlPiUgDQogIGZpbHRlcihgdHlwZSBvZiBvZmZlbmNlYCAlaW4lIHVuaXF1ZShLUlhBRl9yYXdbWzJdXSlbYygxLCAyLCAzOSwgNDkpXSkgJT4lIA0KICBhcnJhbmdlKGRlc2ModGltZSkpICU+JSANCiAgbXV0YXRlKA0KICAgIHRpbWUgPSB0aW1lICU+JSBmY3RfaW5vcmRlcigpLA0KICAgIGB0eXBlIG9mIG9mZmVuY2VgID0gIGB0eXBlIG9mIG9mZmVuY2VgICU+JSBmY3RfaW5vcmRlcigpLA0KICAgIGBudW1iZXIgb2YgcmVwb3J0c2AgPSBgbnVtYmVyIG9mIHJlcG9ydHNgICAlPiUgZmN0X2lub3JkZXIoKQ0KICApICU+JSANCiAgc3ByZWFkKGB0eXBlIG9mIG9mZmVuY2VgLCB2YWx1ZSkgJT4lIA0KICBhcnJhbmdlKHRpbWUpDQoNCg0KS1JYQUYgJT4lIA0KICBzZWxlY3QoLXRpbWUpICU+JSANCiAgcmVuYW1lKCIgIiA9IDEpICU+JSANCiAgc3RhdGdsX3RhYmxlKCkgJT4lIA0KICBwYWNrX3Jvd3MoaW5kZXggPSBLUlhBRltbInRpbWUiXV0gJT4lIHRhYmxlKCkpDQoNCmBgYA0KPGJyPg0KWyFbXShgciBsb2dvYCl7d2lkdGg9NDB9YHIgcGFzdGUoc291cmNlLCAiS1JYQU4iKWBdKGByIHBhc3RlMCgiaHR0cHM6Ly9iYW5rLnN0YXQuZ2w6NDQzL3NxL2QzMGE5MDYzLTZjN2EtNDc0Zi1iZTQ1LWMxYTFiZmE0MzI5NCIsIG9wdGlvbilgKXt0YXJnZXQ9Il9ibGFuayJ9DQo8L2Rpdj4gDQo8L2RldGFpbHM+DQoNCg0KPGhyIHN0eWxlPSJib3JkZXI6MXB4IHJpZGdlIGxpZ2h0Z3JheSI+IDwvaHI+DQo8Y2VudGVyPiA8c3BhbiBzdHlsZT0nY29sb3I6I0QzRDNEMzsgZm9udC1zaXplOjkwJTsnPiBgciBwYXN0ZSh0eHQkdXBkYXRlW2xhbmd1YWdlXSwgZm9ybWF0KFN5cy5EYXRlKCksICIlZC4gJUIgJVkiKSlgIDwvc3Bhbj4gPC9jZW50ZXI+DQoNCg0KDQoNCjxzY3JpcHQ+DQp2YXIgYWNjID0gZG9jdW1lbnQuZ2V0RWxlbWVudHNCeUNsYXNzTmFtZSgiYWNjb3JkaW9uIik7DQp2YXIgaTsNCg0KZm9yIChpID0gMDsgaSA8IGFjYy5sZW5ndGg7IGkrKykgew0KICBhY2NbaV0uYWRkRXZlbnRMaXN0ZW5lcigiY2xpY2siLCBmdW5jdGlvbigpIHsNCiAgICB0aGlzLmNsYXNzTGlzdC50b2dnbGUoImFjdGl2ZSIpOw0KICAgIHZhciBwYW5lbCA9IHRoaXMubmV4dEVsZW1lbnRTaWJsaW5nOw0KICAgIGlmIChwYW5lbC5zdHlsZS5tYXhIZWlnaHQpIHsNCiAgICAgIHBhbmVsLnN0eWxlLm1heEhlaWdodCA9IG51bGw7DQogICAgfSBlbHNlIHsNCiAgICAgIHBhbmVsLnN0eWxlLm1heEhlaWdodCA9IHBhbmVsLnNjcm9sbEhlaWdodCArICJweCI7DQogICAgfSANCiAgfSk7DQp9DQo8L3NjcmlwdD4NCg0KDQo=