Load MSHP Charge Codes and related files

25-July02921 Load

File	Lines	Table	Records
May2021ChargeCodeManual-cleaned.csv	2975	import_mshp_charge_code_manuals	2642
ChargeCodeCSV2021-5-3.csv	8273	import_charge_codes	8270
NCICCSV2021-5-3.csv	453	import_ncics	453
NCICModifiersCSV2021-5-3.csv	19957	import_ncic_modifiers	19957

• Lines: used wc -l. Count is incorrect due to special characters in May2021ChargeCodeManual.csv
• Records: SQL select count(*)...
• Command to load php artisan cmr:import-mshp-data
• file are in pdata
• May2021ChargeCodeManual-cleaned.csv was created from May2021ChargeCodeManual.csv by filtering out heading lines.

May2021ChargeCodeManual.csv

type_class	count(*)
F / A	49
F / B	102
F / C	50
F / D	177
F / E	288
F / UN	98
I	199
M / A	906
M / B	324
M / C	189
M / D	16
M / UN	244

DNA - Indicates whether the offense requires the collection of DNA.

• “A” identifies offenses requiring the collection of DNA upon arrest.
• “C” identifies offenses requiring the collection of DNA upon conviction.
• “S” identifies offenses requiring the collection of DNA if the subject is registering as a sex offender.
• “N” indicates that the collection of DNA is NOT required for the offense.

dna	count(*)
A/C	77
A/C/S	93
C	597
C/S	8
N	1865
S	2

SOR - (Sex Offender Registration) – A “Y” (yes) in this column indicates that registration as a sex offender is required upon conviction. An “N” (no) indicates that the charge does not require registration as a sex offender.

sor	count(*)
N	2539
Y	103

ROC - (Record of Conviction) This column identifies offenses reportable to the Department of Revenue upon conviction. A “Y” (yes) indicates the offense is reportable to DOR. An “N” (no) indicates the offense is not reportable to DOR. An asterisk “*” indicates the offense is reportable to DOR if the offense occurred while operating a motor vehicle.

roc	count(*)
	2
*	45
N	2353
Y	242