MariaDB [soelog]> select * from weblogs where website = "doj" and entry like "%user: kilo%"\G
*************************** 1. row ***************************
website: doj
   time: 2018-08-29 03:20:01
  entry: User: Kilo DELETED cpic record: [{"CPICID":"31449","CharID":"37330","Type":"2","Amount":"20","reason":" | Assault 2nd degree | Unlawful use of a weapon | 07.29.18 (J. Holt - LSPD)","DateTime":"2018-07-29 13:27:29"}]
*************************** 2. row ***************************
website: doj
   time: 2018-09-05 09:01:42
  entry: User: Kilo UPDATED courtorders for Jason Craig, 33674 to: | License will be suspended on 07/10/2018 - Judge T.Little | No contact order for Allison Mills, unless in the capacity of a LEO, he may not have contact with her or be within 50 meters of her - 40 months/$10k for violating. (Judge King) |
*************************** 3. row ***************************
website: doj
   time: 2018-09-05 09:03:28
  entry: User: Kilo UPDATED courtorders for Jason Craig, 33674 to: | No contact order for Allison Mills, unless in the capacity of a LEO, he may not have contact with her or be within 50 meters of her - 40 months/$10k for violating. (Judge King) |
*************************** 4. row ***************************
website: doj
   time: 2018-09-05 09:23:29
  entry: User: Kilo DELETED cpic record: [{"CPICID":"26598","CharID":"35466","Type":"1","Amount":"250","reason":"| Illegal U-Turn | 02.28.18 (D. Shrute - LSPD)","DateTime":"2018-02-28 03:22:38"}]
*************************** 5. row ***************************
website: doj
   time: 2018-09-05 09:23:36
  entry: User: Kilo DELETED cpic record: [{"CPICID":"26599","CharID":"35466","Type":"1","Amount":"1000","reason":"| Reckless Driving | 02.28.18 (D. Shrute - LSPD)","DateTime":"2018-02-28 03:23:30"}]
*************************** 6. row ***************************
website: doj
   time: 2018-09-05 09:23:44
  entry: User: Kilo DELETED cpic record: [{"CPICID":"28232","CharID":"35466","Type":"1","Amount":"500","reason":"Failure to Have Correct Registration Displayed on Vehicle | 04.14.2018 (N. Major - LSPD)","DateTime":"2018-04-15 02:25:29"}]
*************************** 7. row ***************************
website: doj
   time: 2018-09-05 09:23:53
  entry: User: Kilo DELETED cpic record: [{"CPICID":"28234","CharID":"35466","Type":"1","Amount":"400","reason":"| Speeding (Senora FWY | 96KKR148 | 91 in 70) | 04.15.18 (R. Abraham - BCSO)","DateTime":"2018-04-15 03:24:38"}]
*************************** 8. row ***************************
website: doj
   time: 2018-09-05 09:23:59
  entry: User: Kilo DELETED cpic record: [{"CPICID":"28294","CharID":"35466","Type":"1","Amount":"750","reason":"| Illegal passing | 04.16.18 (R. Segway - BCSO)\t\t\t\t\t\t\t\t","DateTime":"2018-04-16 17:38:47"}]
*************************** 9. row ***************************
website: doj
   time: 2018-09-05 09:27:42
  entry: User: Kilo UPDATED owesstate from: $0 to: $1000 for Joey Zelovf, 35466
*************************** 10. row ***************************
website: doj
   time: 2018-09-14 18:07:50
  entry: User: Kilo DELETED cpic record: [{"CPICID":"32681","CharID":"38692","Type":"2","Amount":"999999","reason":" Mental Eval (Sr. Officer Daniel Monsen - LSPD)","DateTime":"2018-09-08 19:32:20"}]
*************************** 11. row ***************************
website: doj
   time: 2018-09-14 18:08:06
  entry: User: Kilo UPDATED prison time for Jonas Anderson, 38692 to: 1
*************************** 12. row ***************************
website: doj
   time: 2018-09-14 18:22:56
  entry: User: Kilo UPDATED courtorders for Cj Johnson, 36680 to: | 2018-09-14 - | License suspended until driving school is completed and state debt cleared. (Judge King) |
*************************** 13. row ***************************
website: doj
   time: 2018-09-14 18:24:52
  entry: User: Kilo UPDATED courtorders for Blake Anderson, 38010 to: ''
*************************** 14. row ***************************
website: doj
   time: 2018-09-14 18:25:37
  entry: User: Kilo DELETED cpic record: [{"CPICID":"30539","CharID":"38010","Type":"1","Amount":"1500","reason":"| Reckless Driving | 06.27.18 (J. Dangerfield - LSPD)\t","DateTime":"2018-06-28 00:04:09"}]
*************************** 15. row ***************************
website: doj
   time: 2018-09-14 18:25:48
  entry: User: Kilo DELETED cpic record: [{"CPICID":"31169","CharID":"38010","Type":"1","Amount":"300","reason":"| Running a red light | 07.21.18 (J. Dangerfield - LSPD)\t\t\t\t\t\t\t\t","DateTime":"2018-07-21 02:43:47"}]
*************************** 16. row ***************************
website: doj
   time: 2018-09-14 18:25:59
  entry: User: Kilo DELETED cpic record: [{"CPICID":"31269","CharID":"38010","Type":"1","Amount":"1000","reason":"| Failure to have correct registration on vehicle | 07.23.18 (K.Anderson - BCSO)\t\t\t\t\t\t\t\t","DateTime":"2018-07-23 20:41:38"}]
*************************** 17. row ***************************
website: doj
   time: 2018-09-14 18:26:06
  entry: User: Kilo DELETED cpic record: [{"CPICID":"31459","CharID":"38010","Type":"1","Amount":"750","reason":"| Illegal passing | 07.29.18 (R. Segway - BCSO)\t\t\t\t\t\t\t\t","DateTime":"2018-07-29 18:26:48"}]
*************************** 18. row ***************************
website: doj
   time: 2018-09-14 18:26:20
  entry: User: Kilo DELETED cpic record: [{"CPICID":"31460","CharID":"38010","Type":"1","Amount":"250","reason":"| 10-19 MPH over | 07.29.18 (R. Segway - BCSO)\t\t\t\t\t\t\t\t","DateTime":"2018-07-29 18:27:27"}]
*************************** 19. row ***************************
website: doj
   time: 2018-09-14 18:26:48
  entry: User: Kilo DELETED cpic record: [{"CPICID":"31740","CharID":"38010","Type":"1","Amount":"1500","reason":"| Reckless Driving | 08.07.18 (J. Dangerfield - LSPD)\t\t\t\t\t\t\t\t","DateTime":"2018-08-07 04:10:35"}]
*************************** 20. row ***************************
website: doj
   time: 2018-09-14 18:27:14
  entry: User: Kilo DELETED cpic record: [{"CPICID":"31996","CharID":"38010","Type":"1","Amount":"1000","reason":"| Negligent Driving | 08.16.18 (J.Snow - BCSO)","DateTime":"2018-08-16 19:37:20"}]
*************************** 21. row ***************************
website: doj
   time: 2018-09-17 17:51:31
  entry: User: Kilo DELETED cpic record: [{"CPICID":"25907","CharID":"35287","Type":"2","Amount":"225","reason":" | Destruction of property | Reckless Endangerment | Attempted murder of a LEO or EMS (x4) | Fleeing and Eluding | Grand Theft Auto | 02.11.18 (G.Noble - SASP)\t\t\t\t\t\t\t\t","DateTime":"2018-02-11 02:24:24"}]
*************************** 22. row ***************************
website: doj
   time: 2018-09-17 17:52:26
  entry: User: Kilo DELETED cpic record: [{"CPICID":"25855","CharID":"35287","Type":"2","Amount":"5","reason":" | Attempted Grand Theft Auto | 02.10.18 (D. Shrute - LSPD)","DateTime":"2018-02-10 07:10:38"}]
*************************** 23. row ***************************
website: doj
   time: 2018-09-17 17:52:36
  entry: User: Kilo DELETED cpic record: [{"CPICID":"25896","CharID":"35287","Type":"2","Amount":"10","reason":" | Grand Theft Auto | 02.10.18 (S. Sabres - BCSO)\t\t\t\t\t\t\t\t","DateTime":"2018-02-10 23:34:51"}]
*************************** 24. row ***************************
website: doj
   time: 2018-09-17 17:52:41
  entry: User: Kilo DELETED cpic record: [{"CPICID":"26137","CharID":"35287","Type":"2","Amount":"3","reason":" | Grand Theft Auto | 02.17.18 (E.Knight - LSPD)\t\t\t\t\t\t\t\t","DateTime":"2018-02-18 00:05:23"}]
*************************** 25. row ***************************
website: doj
   time: 2018-09-17 17:52:45
  entry: User: Kilo DELETED cpic record: [{"CPICID":"26147","CharID":"35287","Type":"2","Amount":"2","reason":" | Poaching | 02.18.18 (J. Snow - BCSO)","DateTime":"2018-02-18 02:05:58"}]
*************************** 26. row ***************************
website: doj
   time: 2018-09-17 17:52:49
  entry: User: Kilo DELETED cpic record: [{"CPICID":"30164","CharID":"35287","Type":"2","Amount":"5","reason":" | Attempted Grand Theft Auto | 06.13.18 (B. Travis - LSPD)","DateTime":"2018-06-13 21:41:37"}]
*************************** 27. row ***************************
website: doj
   time: 2018-09-17 17:56:35
  entry: User: Kilo DELETED cpic record: [{"CPICID":"22404","CharID":"25479","Type":"2","Amount":"12","reason":" | Assault with a deadly weapon | Illegal possession of a outlawed firearm (x2) | 11.11.17 (A. De Luca - SASP)","DateTime":"2017-11-11 14:11:58"}]
*************************** 28. row ***************************
website: doj
   time: 2018-09-17 17:56:39
  entry: User: Kilo DELETED cpic record: [{"CPICID":"22619","CharID":"25479","Type":"2","Amount":"60","reason":" | Possession of burglary tools | Reckless Endangerment | Fleeing and Eluding | Illegal possession of a outlawed firearm (x2) | Trafficking of marijuana W\/O a license (x3) | 11.15.17 (M. King - BCSO)","DateTime":"2017-11-15 10:38:31"}]
*************************** 29. row ***************************
website: doj
   time: 2018-09-17 17:56:44
  entry: User: Kilo DELETED cpic record: [{"CPICID":"23262","CharID":"25479","Type":"2","Amount":"21","reason":" | Illegal possession of a outlawed firearm (x2) | 11.27.17 (B. Parker - BCSO)","DateTime":"2017-11-27 19:29:59"}]
*************************** 30. row ***************************
website: doj
   time: 2018-09-17 17:56:53
  entry: User: Kilo DELETED cpic record: [{"CPICID":"23274","CharID":"25479","Type":"2","Amount":"20","reason":" Illegal possession of a firearm x 1 | Trafficking of marijuana W\/O a license x 1 | 11\/28\/17 | M. Boscoreli | LSPD","DateTime":"2017-11-28 01:48:13"}]
*************************** 31. row ***************************
website: doj
   time: 2018-09-17 17:56:58
  entry: User: Kilo DELETED cpic record: [{"CPICID":"23305","CharID":"25479","Type":"2","Amount":"3","reason":" | Brandishing of a Firearm | 11.28.17 (K.Anderson - BCSO)","DateTime":"2017-11-28 23:45:18"}]
*************************** 32. row ***************************
website: doj
   time: 2018-09-17 17:57:02
  entry: User: Kilo DELETED cpic record: [{"CPICID":"28068","CharID":"25479","Type":"2","Amount":"10","reason":" | Poaching | Possession of Endangered Species (x15) | 04.09.18 (B. Parker - BCSO)\t\t\t\t\t\t\t\t","DateTime":"2018-04-09 22:14:18"}]
*************************** 33. row ***************************
website: doj
   time: 2018-09-17 17:57:07
  entry: User: Kilo DELETED cpic record: [{"CPICID":"29307","CharID":"25479","Type":"2","Amount":"5","reason":" | Public Intoxication | 05.20.18 (R.Segway - BCSO)\t\t\t\t\t\t\t\t","DateTime":"2018-05-20 13:51:20"}]
*************************** 34. row ***************************
website: doj
   time: 2018-09-17 17:59:24
  entry: User: Kilo DELETED cpic record: [{"CPICID":"22996","CharID":"14320","Type":"2","Amount":"8","reason":" | Possession of stolen motor vehicle | 11.22.17 (D. Shrute - LSPD)","DateTime":"2017-11-22 03:08:44"}]
*************************** 35. row ***************************
website: doj
   time: 2018-09-17 17:59:37
  entry: User: Kilo DELETED cpic record: [{"CPICID":"23048","CharID":"14320","Type":"2","Amount":"5","reason":" | Obstruction of justice | 11.23.17 (B.Lyles - LSPD)","DateTime":"2017-11-23 02:28:31"}]
*************************** 36. row ***************************
website: doj
   time: 2018-09-17 17:59:42
  entry: User: Kilo DELETED cpic record: [{"CPICID":"28304","CharID":"14320","Type":"2","Amount":"70","reason":" | Failure to comply with a lawful order | Possession of burglary tools | Possession of Illegal substance (General) 5 grams or less | Assault on a LEO or EMS | Criminal threat | Fleeing and Eluding (x2) | Possession of a outlawed Weapon | 04.16.18 (J.White - BCSO)","DateTime":"2018-04-16 23:21:27"}]
*************************** 37. row ***************************
website: doj
   time: 2018-09-17 17:59:45
  entry: User: Kilo DELETED cpic record: [{"CPICID":"28514","CharID":"14320","Type":"2","Amount":"20","reason":" | Armed Robbery | Fleeing and Eluding | 04.22.2018 (E. Clancy \u2013 LSPD)","DateTime":"2018-04-23 01:53:05"}]
*************************** 38. row ***************************
website: doj
   time: 2018-09-17 17:59:57
  entry: User: Kilo DELETED cpic record: [{"CPICID":"29096","CharID":"14320","Type":"2","Amount":"8","reason":" | Trespassing | R. Huntington - SASP","DateTime":"2018-05-13 02:31:05"}]
*************************** 39. row ***************************
website: doj
   time: 2018-09-17 18:00:05
  entry: User: Kilo DELETED cpic record: [{"CPICID":"29134","CharID":"14320","Type":"2","Amount":"15","reason":" | Grand Theft Auto | Trafficking of marijuana | 05.14.18 (C.Montgomery - LSPD)\t\t\t\t\t\t\t\t","DateTime":"2018-05-14 17:59:42"}]
*************************** 40. row ***************************
website: doj
   time: 2018-09-17 18:00:10
  entry: User: Kilo DELETED cpic record: [{"CPICID":"29306","CharID":"14320","Type":"2","Amount":"5","reason":" | Public Intoxication | 05.20.18 (R.Segway - BCSO)\t\t\t\t\t\t\t\t","DateTime":"2018-05-20 13:49:12"}]
*************************** 41. row ***************************
website: doj
   time: 2018-09-17 18:00:19
  entry: User: Kilo DELETED cpic record: [{"CPICID":"29599","CharID":"14320","Type":"2","Amount":"6","reason":" | Grand Theft Auto | Trafficking of marijuana | 05.28.18 (M.Hunter - BCSO)","DateTime":"2018-05-28 11:29:24"}]
*************************** 42. row ***************************
website: doj
   time: 2018-09-17 18:00:23
  entry: User: Kilo DELETED cpic record: [{"CPICID":"30272","CharID":"14320","Type":"2","Amount":"10","reason":" | Possession of Illegal substance (General) \nMore than 5 grams | 06.17.18 (C.Montgomery - LSPD)","DateTime":"2018-06-17 21:56:27"}]
42 rows in set (0.08 sec)