Load MSHP Charge Codes and related files

25-July02921 Load

File	Lines	Table	Records	Statutes
May2021ChargeCodeManual-cleaned.csv	2975	import_mshp_charge_code_manuals	2642	1,227
ChargeCodeCSV2021-5-3.csv	8273	import_charge_codes	8270	1,584 (some ORD)
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.

Attribute	CC Manual	CC
Chapters	213	256
F / A	38	60
sor	55	n/a

May2021ChargeCodeManual.csv

Records: 2,642 Unique Statute Numbers: 1,227

Type and Class

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

State Modifier

The State Modifier is the final digit of the charge code. Only the state modifiers listed with each charge are applicable. Available state modifiers are:

• 0 - Not Applicable,
• 1 - Attempt,
• 2 - Accessory.

state_mod	count(*)
0	782
0 1	28
0 1 2	1748
0 1 2 3	4
0 2	80