Manually deleted file to fix merge conflict.HEADmaster

5 files changed, 851 insertions, 0 deletions

diff --git a/interesting_defendants/disposition_groups b/interesting_defendants/disposition_groups
new file mode 100644
index 0000000..e0aded4
--- /dev/null
+++ b/interesting_defendants/disposition_groups
@@ -0,0 +1,86 @@
+1,ACQUITTAL/INSANITY
+1,ACQUITTED BY COURT
+1,ACQUITTED BY JURY
+1,ADJ WH 364 TASC/C.C.
+1,ADJ WH 364 TASC/PROB
+1,ADJ WH AND SENT-TASC
+1,ADJ WH C.C./ PROB
+1,ADJ WH COND:BOOT CMP
+1,ADJ WH PR SP CN TASC
+1,ADJ WH SNT/SORT FAIL
+1,ADJ WH SNT/SRT VOL T
+1,ADJ WH W/PROB-SORT
+1,ADJ WH-SORT/GRAD
+1,ADJ WH-SPL SENT-SORT
+1,ADJ WH/CTS/FINE/COST
+1,ADJ WHELD/BOOT CAMP
+1,ADJ WITHHELD/ SENT
+1,ADJ WITHHELD/PROB
+1,DISCHARGE
+1,DISM - SPEEDY TRIAL
+1,DISM W/O PREJUDICE
+1,DISM WITH PREJUDICE
+1,DISM-LACK OF PROS
+1,DISM/NO PROB CAUSE
+1,DISMISS/MODIFY
+1,DISMISS/TERM
+1,DISMISSED
+1,DISMISSED BY COURT
+1,DISMISSED-WITNESS
+1,VACATE PER MANDATE
+1,WH ADJ - JAIL TIME
+1,WH ADJ - RESTITUTION
+1,WH ADJ / CTS
+1,WH ADJ SP CND-PEG
+1,WH ADJ W/FINE & COST
+1,WH ADJ-C.C./SPC COND
+1,WH ADJ-COMM SERVICE
+1,WH ADJ-PROB SP COND
+1,WH ADJ-PROB W/CM SRV
+1,WH ADJ-SAL ARMY PROB
+1,WH ADJ-SPLIT SENT
+1,WH ADJ-SUSP ENT SENT
+1,WH ADJ-YOUTHFUL OFFN
+1,WH ADJ/PROB CONSEC
+1,WH ADJ/PROBATION
+1,WH ADJ/SENT SORT
+2,DEF PROSECUTION PGM
+2,DEFER DRUG PROGRAM
+2,DEFER FIRE ARM PGM
+2,DIV DEFR DRUG PGM
+2,DRUG COURT PRG PLEA
+2,NOLLE PROS
+2,NOLLE PROS - ADMIN
+2,NOLLE PROS - REST
+2,NOLLE PROS JDP
+2,NOLLE PROS- USAO/INS
+2,NOLLE PROS-ADM/WRNT
+2,NOLLE PROS-COMP 'DVI
+2,NOLLE PROS-COMP PTI
+2,NOLLE PROS-DRUG PGM
+2,NOLLE PROS-F/A PGM
+2,NOLLE PROS-WITNESS
+3,ABANDONED
+3,CASE FILED IN ERROR
+3,CIVIL PENALTY CLOSED
+3,CLOSED ADMIN JUDGE
+3,CLOSED/PER ADM MEMO
+3,NO ACTION
+3,NO INFORMATION
+3,NO TRUE BILL
+4,NO ACTION - FIL CTY
+4,NO ACTION - FIL TRAF
+4,NO ACTION FILED TRF
+4,NOLLE PROS FILED TRF
+4,NOLLE PROS/FILED CC
+4,NON JUDICIAL ACTION
+4,PETITION WITHDRAWN
+4,PROB RESTRD/REINSTAT
+4,PROB TERM/MOD/REV
+4,PROB W/COMM SERVICE
+4,PROBATION MODIFIED
+4,PROBATION REVOKED
+4,PROBATION TERMINATED
+4,VOLUNTARILY WTHDRAWN
+4,WITHDRAWN/TERM
+4,WITHDRAWN/TERMINATED
diff --git a/interesting_defendants/excludable_charges b/interesting_defendants/excludable_charges
new file mode 100644
index 0000000..f2847f7
--- /dev/null
+++ b/interesting_defendants/excludable_charges
@@ -0,0 +1,438 @@
+ARSON
+ARSON 1D/CONSPIRACY
+ARSON 1ST DEGREE
+ARSON 1ST/ATTEMPT
+ARSON 2ND DEGREE
+ARSON/2D/CONSPIRE
+ARSON/2D/SOLICIT
+ARSON/2ND/ATTEMPT
+ARSON/BODILY HARM
+ARSON/GREAT BOD HARM
+ASS AGG/PO/FF/ATTEMP
+ASS/AGG/BY PRISONER
+ASS/AGG/OFFICIAL EMP
+ASS/AGG/RELIG INSTI
+ASS/AGGR/CONSP
+ASS/AGG/RELIG INSTI
+ASS/AGGR/CONSP
+ASSAULT/AGG/DW/MASK
+ASSAULT/AGG/DWEAP
+ASSAULT/AGG/ELDER/DW
+ASSAULT/AGG/FELONY
+ASSAULT/AGG/FIREARM
+ASSAULT/AGG/LEO
+ASSAULT/AGG/POL/FIRE
+ASSAULT/AGG/PRINCIPL
+ASSAULT/AGGRAVATED
+ASSLT/AGG/6/FIREAR
+ASSLT/AGG/FEL/F ARM
+ASSLT/AGG/LEO/FA/ATT
+ASSLT/AGG/LEO/FIRERM
+ATT 2D MURDER/FIREAR
+ATT FEL MUR/DLY WEA
+ATT FEL MUR/FIREARM
+ATT FEL MURDER - PBL
+ATT FEL MURDER/IN/AR
+ATT FEL MURDER/INJUR
+ATT SEX ACTIV/MINOR
+ATT SOL 1ST DEG FEL
+ATT SOL 2ND DEG FEL
+ATTEMPT FEL MURDER
+BATT/AGG/BODHRM/WEAP
+BATT/AGG/BY PRISONER
+BATT/AGG/DDY WPN/ATT
+BATT/AGG/HARM/DWEAP
+BATT/AGG/OFFICIAL
+BATT/AGG/PREJ/WEA/HR
+BATT/AGG/WEA/FA/MASK
+BATT/AGG/WEAP/GANG
+BATT/AGG/WEAP/PRE/AT
+BATTERY/AGG/ATT
+BATTERY/AGG/BOD HARM
+BATTERY/AGG/CONSPIRE
+BATTERY/AGG/DWEAP
+BATTERY/AGG/ELDERLY
+BATTERY/AGG/FIREARM
+BATTERY/AGG/HRM/WEAP
+BATTERY/AGG/LEO
+BATTERY/AGG/POL/FIRE
+BATTERY/AGG/PREGNANT
+BATTERY/AGG/PRIN
+BATTERY/AGGRAVATED
+BOMB/ATT/FALS RPT/ST
+BOMB/BODILY HARM
+BOMB/DESTR DEV/CONSP
+BOMB/DESTR DEV/SOLIC
+BOMB/DISRUPTION
+BOMB/FALSE REPORT
+BOMB/FALSE RPT/STATE
+BOMB/GREAT BOD HARM
+BOMB/MAKE/POSN/THROW
+BOMB/THREAT TO THROW
+BUR/ASLT/BAT/ARD/SOL
+BUR/ASS/BAT/ARMD/CON
+BURG/ARMED/SOLICIT
+BURG/ASLT/BATT - PBL
+BURG/ASS/BAT/>7/1/01
+BURG/ASS/BAT/ARM/ATT
+BURG/DWL/STR/DAM-PBL
+BURG/DWL/STR/VEH-PBL
+BURG/OCC DWELL/SOLIC
+BURG/OCC DWL/MASK
+BURG/OCC/DWELL/ATT
+BURG/OCC/MASKED
+BURG/UNOC DWEL/GANG
+BURG/UNOCC DWEL/PREJ
+BURG/UNOCC DWELL/ATT
+BURG/UNOCC DWELL/CON
+BURG/UNOCC/DWL/MASK
+BURGLARY/ARMED - PBL
+BURGLARY/ARMED/ATT
+BURGLARY/ARMED/CONSP
+BURGLARY/ASSLT/ARMED
+BURGLARY/DWELL/CONSP
+BURGLARY/OCC/DWELL
+BURGLARY/UNOCC D/ATT
+BURGLARY/UNOCC DWELL
+BURGLARY/UNOCC/DWELL
+BURGLARY/W ASSLT/ATT
+BUY/SELL MINOR/SEX T
+CANN/TRF/10K>LBS
+CANN/TRF/25-2000LBS
+CANN/TRF/2K-10KLBS
+CANN/TRF/ARMD/ATTEMT
+CANNABIS/TRAFFICK
+CANNABIS/TRFK/10
+CANNABIS/TRFK/2-10K
+CANNABIS/TRFK/50-2K
+CANNABIS/TRFK/ARMED
+CANNABIS/TRFK/ATT
+CHILD AB/NO HARM/ATT
+CHILD ABU/NO HARM/FA
+CHILD ABUSE/AGG
+CHILD ABUSE/AGGRAV
+CHILD ABUSE/ATT
+CHILD ABUSE/BOD HARM
+CHILD ABUSE/FAIL RPT
+CHILD ABUSE/IMPREGNA
+CHILD ABUSE/INJURY
+CHILD ABUSE/NO HARM
+CHILD PORN/TRANSMIT
+CHILD/INFLICT PAIN
+CHLD AB/AGG/GRT HARM
+CHLD AB/HRM/AG BT/FA
+CHLD ABS/FAIL TO REP
+CHLD ABS/FALSE REPT
+CHLD ABS/NEG/FLS RPT
+CHLD ABS/REQ REPORT
+CHLD ABUSE/FALSE RPT
+CHLD NEG/GREAT HARM
+CHLD NEG/NO GRT HRM
+CHLD PORN/FRM O/S FL
+CHILD PORN/TRANSMIT
+CHLD AB/AGG/GRT HARM
+CHLD AB/HRM/AG BT/FA
+CHLD PORN/FRM O/S FL
+COCAINE/TRAF/CONSP
+COCAINE/TRAF/CONSPIR
+COCAINE/TRAFF/CONSP
+COCAINE/TRAFF/SOLIC
+COCAINE/TRAFFIC/ATT
+COCAINE/TRAFFICK
+COCAINE/TRF/200-400
+COCAINE/TRFK/10
+COCAINE/TRFK/2-10K
+COCAINE/TRFK/40
+COCAINE/TRFK/400-2K
+COCAINE/TRFK/400/ARM
+COKE/TRAF/40/CONSP
+COKE/TRAF/400>/<150K
+COKE/TRAFF/200>/<400
+COKE/TRAFF/28>/<200
+COKE/TRAFFICK/40
+COKE/TRF/150-300/PBL
+COKE/TRFK/28>/<150K
+COKE/TRFK/ARMED
+COKE/TRFK/ATTEMPT
+COKE/TRFK/CONSPIRACY
+COKE/TRFK/SOLICIT
+COKE/TRK/150K>/ARMED
+COMPUTER PORNOGRAPHY
+DRUGS/TRAFFICK/ATT
+DRUGS/TRAFFICKING
+DRUGS/TRFK/CONSPIRE
+DUI/MANSLAUGHTER
+DWI/MANSLAUGHTER
+ENG SEX/CHILD/ATTEMP
+ENGAGE/CHILD FAM SEX
+EXPLO/POSN/W/O/LICEN
+EXPLOSIVE/POSN
+EXPLOSIVE/TRANSPORT
+EXPLOSIVE/UNL POSN
+ECSTASY/TRF/10>/<200
+FLUNI/TRF/14>/<28GR
+FLUNI/TRF/4G>/<14GR
+FLUNOTRAZ/TRAFF/CONS
+GBL/TRAFF/1K><5K
+GBL/TRAFFICK/10K>
+FEL MUR/1ST/LEO/ATT
+HOME/INVASION
+HM INV/ROBB/W/O WEAP
+ILL DRG/TRAF/28/SOLI
+ILL DRG/TRF/30K>/DTH
+ILL DRG/TRFK/ARMED
+ILL DRGS/TRF/14>/<28
+ILL DRGS/TRF/4>/<14
+ILL DRGS/TRF/4>/<14G
+ILL DRUGS/TRAF/ARMED
+ILL DRUGS/TRAFF/2
+ILL DRUGS/TRAFFICK
+ILL DRUGS/TRF/ARM/AT
+ILL DRUGS/TRF/ATT
+ILL DRUGS/TRF/ATTEMP
+ILL DRUGS/TRFK/2
+ILL DRUGS/TRFK/30K>
+ILL DRUGS/TRFK/CONSP
+ILLDRG/TRF/28G>/<30K
+ILLDRG/TRF14>/<28SOL
+KID/CHLD<13/ARMD/ATT
+KIDNAP/-13/LL/SB
+KIDNAP/CHILD-13/ATT
+KIDNAP/FA/AGGB/CONSP
+KIDNAP/SOLIC
+KIDNAP/WEAP/FA/AGGB
+KIDNAP/WEAPON/CONSP
+KIDNAP/WP/FA/AGB/LEO
+KIDNAP/WP/FA/AGGB/AT
+KIDNAPPING Ð PBL
+KIDNAPPING/ATTEMPT
+KIDNAPPING/CHLD/GANG
+KIDNAPPING/CONSPIRE
+KIDNAPPING/DWEAP/LEO
+KIDNAPPING/LEO Ð PBL
+KIDNAPPING/MASKED
+KIDNAPPING/WEAP/AGGB
+KIDNAPPING/WEAPN/ATT
+L&L; ASS/CHILD/SOLICT
+L&L; ASSAULT/CHILD
+L&L; ASSLT/CHILD/ATT
+L&L; BATT ON CHILD
+L&L; BATT/ELD/DIS/ADL
+L&L; BEHAVIOR
+L&L; CD/<16/DF<18
+L&L; CHILD/ATT
+L&L; CHLD 12-16/DF<18
+L&L; CHLD <16/ARMED
+L&L; CHLD<12/D18>/ATT
+L&L; CHLD<12/DEF 18>
+L&L; CONDUCT/CHLD <16
+L&L; EXH/CLD<16/DF<18
+L&L; EXHI/ELD/DIS/ADL
+L&L; EXHIB <16 BY 18>
+L&L; EXHIB ON<16BY<18
+L&L; EXHIB/CHLD/<16
+L&L; EXHIB/CHLD/ONLIN
+L&L; MOL CHLD 12-16
+L&L; MOL/ELD/DISAB/AD
+L&L; MOLEST/CHILD/<12
+L&L; ON CHILD<16/ATTM
+L&L;/CH<12/DEF<18/ATT
+L&L;/CHD <12/DEF<18
+L&L;/CHILD/ARMED
+L&L;/EXHIB/CORR/FACIL
+L&LCHLD; <12/D18>/ATT
+LWD ACT/<16/<10/99
+LWD ASLT CHLD/<10/99
+LWD ASLT/<16/<10/99
+LWD ASLT/CHLD/<10/99
+MEN HLTH/SEX MISCND
+MANS/AGG/ELD/DIS ADL
+MANS/D WEAP/ATTEMPT
+MANSL/AGG/CHILD
+MANSLAUGHTER
+MANSLAUGHTER/ATTEMPT
+MANSLAUGHTER/DWEAP
+MANSLAUGHTER/LEO
+MANSLAUGHTER/LEO/ATT
+MR 2D/LEO/AT/DW/FA/B
+MUR 1D/DLY WEA/CONSP
+MUR 2/ATT/WEA/PREJ
+MUR 2/WEAP/AG BAT/AT
+MUR/PREMED/ATTEMPT
+MUR2D/ATTMP/DDLY WPN
+MURDER 1ST DEG/ATT
+MURDER 1ST DEG/CONSP
+MURDER 1ST DEG/LEO
+MURDER 1ST DEGREE
+MURDER 1ST/DWEAP/AT
+MURDER 1ST/DWEAP/ATT
+MURDER 1ST/PRIN/ATT
+MURDER 1ST/SOLICIT
+MURDER 2 DEG/FEL/PBL
+MURDER 2 DEG/LEO/PBL
+MURDER 2/FIREARM/ATT
+MURDER 2D/LEO/ATT/DW
+MURDER 2ND DEG - PBL
+MURDER 2ND DEG/ATT
+MURDER 2ND DEG/DWEAP
+MURDER 2ND DEG/PRIN
+MURDER 2ND DEGREE
+MURDER 2ND/ATT/WEAPN
+MURDER 2ND/DWEAP/LEO
+MURDER 2ND/FIREARM
+MURDER 2ND/LEO/ATT
+MURDER 2ND/PRIN/ATT
+MURDER 3RD DEG/ATT
+MURDER 3RD DEG/LEO
+MURDER 3RD DEGREE
+MURDER 3RD/DEA WEAPN
+MURDER/2D/CONSPIRAC
+MURDER/ATT/POL/FIRE
+MURDER/PREMED/ATT/FA
+OBSCENEMAT/MIN/ATT
+OBSCENE MAT/MINOR
+OBSCENE SHOW/MINOR
+ORG SCEME DEFR/CONSP
+ORG SCH FRD/50 ATT
+ORG SCHEME TO DEFRD
+ORG SCHM DEF/CONSPIR
+ORGANIZED FRAUD
+ORGANIZED FRAUD/50
+ORGANIZED FRD/0-20K
+ORGANIZED FRD/20-50K
+PCP/TRAF/28GR>/<200G
+PCP/TRAFF/400GR>
+PCP/TRAFFICK/40
+PCP/TRF/200G>/<400G
+PCP/TRFK/CONSPIRE
+PHEN/TRAFF/CONSP/ARM
+PHEN/TRAFF/CONSPIRE
+PHEN/TRF/10G><200G/A
+PHEN/TRF/10G><200GR
+PHEN/TRF/10GR>/SOLIC
+PHEN/TRF/200G><400G
+PHEN/TRF/400G>
+PHEN/TRF/ARMED
+PHENETHY/TRAFF/ARMED
+PREMED/MURDER1/LEO/A
+PROCUR -18 PROST/ATT
+PROCUR MINOR
+PROST/PROC <18/SOLIC
+PROST/PROCURE UN/18
+PROST/PROCURE<18/ARM
+RBRY/ARM/FA/DW - PBL
+RBRY/HM INV/FA - PBL
+ROB/HM INV/AGG BATT
+ROB/HOME INV/ARM/ATT
+ROB/SNAT/WEA/ATTEMPT
+ROBB/ARM/SOLIC
+ROBB/ARMED/ATT/MASK
+ROBB/ARMED/PREJUDICE
+ROBB/CARJACK/ARM/ATT
+ROBB/CARJACK/ATTEMPT
+ROBB/CARJACK/CONSPIR
+ROBB/CRJCK/ARM - PBL
+ROBB/HOME NV/ARM/CO
+ROBB/HOME INV/ATT
+ROBB/HOME INV/CONSP
+ROBB/HOME INVA/SOLIC
+ROBB/SA/W/A BATT/ATT
+ROBB/SDN/SNTCH/ATT
+ROBB/SNAT/F/A/DLY WE
+ROBB/STR/ARM/MASKED
+ROBB/STR/ATT/W/PREJU
+ROBB/STRARM/MASK/ATT
+ROBB/STRGARM/MASK
+ROBB/SUDDEN SNATCH
+ROBB/W/AGG BATT
+ROBB/W/AGG BATT
+ROBBERY
+ROBBERY/ARMED/ATT
+ROBBERY/ARMED/CONSP
+ROBBERY/ARMED/MASK
+ROBBERY/ARMED/PRIN
+ROBBERY/ARMED/WEAPON
+ROBBERY/CARJACK/ATT
+ROBBERY/CARJACKING
+ROBBERY/DWEAP/ATT
+ROBBERY/FORCE
+ROBBERY/HM INV/ARMED
+ROBBERY/SA/SOLICIT
+ROBBERY/STRARM/CONSP
+ROBBERY/STRARM/PRIN
+ROBBERY/STRGARM/PREJ
+ROBBERY/STRNGARM/ATT
+ROBBERY/STRONGARM
+ROBBRY/ARMD/PRIN/ATT
+SEXACT/FAMCHLD/ATT
+SEXACT/W/CHILD/SOLI
+SEX ACTIVITY/MINOR
+SEX BAT/BY THREATS
+SEX BAT/DWEAP/ATT
+SEXBAT/MULTPERP/F1
+SEXBAT/MULTPERP/F2
+SEXBAT/NOFORCE/ATT
+SEXBAT/NOHRM/ARMED
+SEX BAT/ON MINOR/ADT
+SEX BAT/ON MINOR/ATT
+SEX BAT/ON MINOR/MNR
+SEX BAT/THREATS/ATT
+SEX BATT/1/MENTAL
+SEX BATT/12>/COERCE
+SEX BATT/ARM/ATT/GNG
+SEX BATT/ARMED/GANG
+SEX BATT/BY LEO/CO
+SEX BATT/COERCE
+SEX BATT/FORCE/ATT
+SEX BATT/HLPLESS/ATT
+SEX BATT/LEO/ARM/ATT
+SEX BATT/LEO/CO/ARMD
+SEX BATT/MINOR/SOLIC
+SEX BATT/NO SER INJU
+SEX BATT/PHYS INCAP
+SEX BATT/VIC HELPLES
+SEX BATT/WEA/SOLICIT
+SEX BATTERY/ARMED
+SEX BATTERY/DRUGGED
+SEX OFF/CHNG ADDR
+SEX OFF/REP REQUIRED
+SEX OFF/RESD VIOL
+SEX OFFN/REG/COMPLY
+SEX OFFND/FAIL TO RE
+SEX OFFNDR/HAR/CON
+SEX OFND/PRED/RES/PR
+SEX OFND/RES VIOL
+SEX OFND/RPT STATE
+SEX OFND/VIOL REGIST
+SEX PERF/CH/PRO/ATT
+SEX PERF/CHILD/ATTEM
+SEX PERF/CHILD/POSN
+SEX PERF/CHILD/POSSN
+SEX PERF/CHILD/PROMO
+SEX PERF/CHILD/PROMT
+SEX PERF/CHILD/USE
+SEX W/FAM CHLD/ARMED
+SEXBAT/NO SER INJ AT
+SEXBAT/SER INJ/ATT
+SEXBAT/WEA/SER INJ/A
+SEXBAT/WEAP/SER INJ
+SEXBATT/NO SER INJ/C
+SEXBATT/NO SER INJ/G
+SOLIC/CHILD FAM SEX
+SOLIC/CHILD SEX ATT
+STALK/AGG/CYBER
+STALK/AGGRAV/MINOR
+STALKING
+STALKING/AGG/CT ORDR
+STALKING/AGG/FIREARM
+STALKING/AGG/PREJUDI
+STALKING/AGGRAVATED
+VID VOY/18> RESP <16
+VID VOY/24>/CHILD<16
+VIDEO VOYEUR/7/1/12
+VIDEO VOYEUR/DISSEM
+VIDEO VOYEURISM/ATT
+VIDEO VOYEURISM/D>18
+VIO INJ PRO AGT STAL
+VIOL INJ/DOM VIOLENC
+VOYEURISM
diff --git a/interesting_defendants/fatal_dispositions b/interesting_defendants/fatal_dispositions
new file mode 100644
index 0000000..c809fbe
--- /dev/null
+++ b/interesting_defendants/fatal_dispositions
@@ -0,0 +1,71 @@
+ADJ DEL COM HRS/FEL
+ADJ DEL COMM CTL/FEL
+ADJ DELINQ-COMT DJJ
+ADJ DELINQ PROB/FEL
+ADJ DEQ CC/PROB/FEL
+ADJUDGED DELINQUENT
+ADJUDGED GUILTY
+CNV-364 TASC/364 SRT
+CNV 364 TASC/COM CNT
+CNV/PRB/SPL SNT/CONC
+CNV/PROB SP CND SORT
+CNV/SNT-SORT FAILED
+CNV & SNT-SORT GRAD
+CNV/SNT-SORT/TRM VOL
+CONV 364 TASC/PROB
+CONV AND SENT
+CONV C.C./PROBATION
+CONV-C.C./SPEC COND
+CONV - COMM SERVICE
+CONV CONC-PROB CONS
+CONV/CTS/FINE/COST
+CONV FN/CST-SUSP POR
+CONVICTION/BOOT CAMP
+CONVICTION - JAIL
+CONVICTION-JAIL/FINE
+CONVICTION W/FINE
+CONVICTION W/PROB
+CONV PRB SP CD HART
+CONV PROB/BOOT CAMP
+CONV - PROB CONSEC
+CONV PROB SP CD/TASC
+CONV PROB SP CND-PEG
+CONV-PROB SPEC COND
+CONV PROB/SPLIT SENT
+CONV- REHAB PROGRAM
+CONV - RESTITUTION
+CONV/SALV ARMY PROB
+CONV & SENT-CONCUR
+CONV & SENT-CONSEC
+CONV & SENT-SORT
+CONV-SENT/SUSP POR
+CONV & SENT W/TASC
+CONV/SPLIT SENTENCE
+CONV SPLIT SENT-SORT
+CONV-SUSP ENTRY SENT
+CONV W/COMM CONTROL
+CONV W/CTS
+CONV W/FINE & COST
+CONV W/FINE OR SENT
+CONV W/FINE SUSP SEN
+CONV-YOUTHFUL OFFNDR
+DECEASED
+D. V. I.  PROGRAM
+EXTRADITED
+FINDING OF GUILT
+FND/GUILT \\PROB VIOL
+FND INCOMP\\PROB VIOL
+FW QUASHED/ABANDONED
+FW QUASHED/EXTRADITE
+JRA/ADJ SAFE TO REL
+JRA/ADJ TO REM COMMT
+ON APPEAL
+SVP/ADJ SAFE TO REL
+SVP/ADJ TO REMAIN CO
+TRANS-ANOTHER AGENCY
+TRANSFER-COUNTY CRT
+TRANSFER TO CIRC CRT
+TRANSFER TO JUVENILE
+TRANSFER TO TRAFFIC
+TRANSF TO OTHER CASE
+TRANS OTHER JURIS
diff --git a/interesting_defendants/interesting_defendants.php b/interesting_defendants/interesting_defendants.php
new file mode 100644
index 0000000..485eb8d
--- /dev/null
+++ b/interesting_defendants/interesting_defendants.php
@@ -0,0 +1,213 @@
+<?php
+
+error_reporting(E_ALL ^ E_NOTICE);
+
+$dbh = new PDO('mysql:host=localhost;dbname=mdcc', 'mdcc', 'Mdcc.');
+
+$fatal_dispositions = file('./fatal_dispositions',  FILE_IGNORE_NEW_LINES);
+$excludable_charges = file('./excludable_charges',  FILE_IGNORE_NEW_LINES);
+$safe_dispositions = file('./safe_dispositions',  FILE_IGNORE_NEW_LINES);
+$disposition_groups = file('./disposition_groups',  FILE_IGNORE_NEW_LINES);
+
+// CSV files
+$def_no_grp_csv = fopen('./output/interesting_defendants_no_group.csv', 'w');
+$def_grp1_csv = fopen('./output/interesting_defendants_group_1.csv', 'w');
+$def_grp2_csv = fopen('./output/interesting_defendants_group_2.csv', 'w');
+$def_grp3_csv = fopen('./output/interesting_defendants_group_3.csv', 'w');
+$def_grp4_csv = fopen('./output/interesting_defendants_group_4.csv', 'w');
+$def_multiple_cases_csv = fopen('./output/interesting_defendants_with_multiple_cases.csv', 'w');
+$def_akas_csv = fopen('./output/interesting_defendants_with_akas.csv', 'w');
+$def_akas_multiple_cases_csv = fopen('./output/interesting_defendants_with_akas_and_multiple_cases.csv', 'w');
+
+// HTML files
+$def_no_grp_html = fopen('./output/interesting_defendants_no_group.html', 'w');
+$def_grp1_html = fopen('./output/interesting_defendants_group_1.html', 'w');
+$def_grp2_html = fopen('./output/interesting_defendants_group_2.html', 'w');
+$def_grp3_html = fopen('./output/interesting_defendants_group_3.html', 'w');
+$def_grp4_html = fopen('./output/interesting_defendants_group_4.html', 'w');
+$def_multiple_cases_html = fopen('./output/interesting_defendants_with_multiple_cases.html', 'w');
+$def_akas_html = fopen('./output/interesting_defendants_with_akas.html', 'w');
+$def_akas_multiple_cases_html = fopen('./output/interesting_defendants_with_akas_and_multiple_cases.html', 'w');
+
+// HTML template start
+$html_start = <<<HTML
+<html>
+<head>
+	<title>Interesting defendants</title>
+</head>
+<body>
+<table border="1">
+HTML;
+
+// HTML template end
+$html_end = <<<HTML
+</table>
+</body>
+</html>
+HTML;
+
+// Initialize the HTML files
+fwrite($def_no_grp_html, $html_start);
+fwrite($def_grp1_html, $html_start);
+fwrite($def_grp2_html, $html_start);
+fwrite($def_grp3_html, $html_start);
+fwrite($def_grp4_html, $html_start);
+fwrite($def_multiple_cases_html, $html_start);
+fwrite($def_akas_html, $html_start);
+
+$sql = "SELECT * FROM cases";
+
+$st = $dbh->prepare($sql);
+if ( $st->execute() ) {
+	while ( $case = $st->fetch(PDO::FETCH_ASSOC) ) {
+
+		$has_multiple_cases = false;
+		$has_akas = false;
+
+		$defendant_csv = array(
+			$case['court_case_no'],
+			$case['name'],
+			$case['date_birth'],
+		);
+
+		$defendant_html = <<<HTML
+
+<tr>
+	<td>
+		<a href='http://li554-21.members.linode.com/search.php?case_id={$case['id']}'>{$case['court_case_no']}</a>
+	</td>
+	<td>{$case['name']}</td>
+	<td>{$case['date_birth']}</td>
+	<td>[<a href='http://li554-21.members.linode.com/charges.php?case_id={$case['id']}&case_no={$case['court_case_no']}'>charges</a>]</td>
+</tr>
+
+HTML;
+
+		$sql_charge = "SELECT * FROM charges WHERE case_id = '{$case['id']}'";
+		$st_charge = $dbh->prepare($sql_charge);
+		$st_charge->execute();
+		$charges = $st_charge->fetchAll(PDO::FETCH_ASSOC);
+
+		// The default group is no group (i.e. 0)
+		$disposition_group = 0;
+
+		foreach ( $charges as $charge ) {
+
+			// Figure out into which, if any, disposition group
+			// this charge puts the case
+			foreach ( $disposition_groups as $group_and_disposition ) {
+				list($group,$disposition) = explode(',', $group_and_disposition);
+				if ( $charge['disposition'] == $disposition ) {
+					// Only move a case into a higher group, never backward
+					if ( $disposition_group == '0' || $group < $disposition_group ) {
+						$disposition_group = $group;
+					}
+
+				}
+			}
+			
+			// Don't process this case if there is an empty disposition 
+			if ( ! trim($charge['disposition']) ) {
+				continue(2);
+			}
+
+			// If the disposition is a "fatal" one then go to next case
+			if ( in_array( $charge['disposition'], $fatal_dispositions) ) {
+				continue(2);
+			}
+
+			// If the charge is excludable and the disposition is not a safe one then go to the next case
+			if ( in_array($charge['charge'], $excludable_charges) && ! in_array($charge['disposition'], $safe_dispositions) ) {
+				continue(2);
+			}
+
+		}
+
+		// Does this person have multiple cases, based on the same name and date of birth?
+		$sql_def = "SELECT count(*) from cases WHERE name = '{$case['name']}' AND date_birth = '{$case['date_birth']}' AND id != '{$case['id']}'";
+		$st_def = $dbh->prepare($sql_def);
+		$st_def->execute();
+		$case_count = $st_def->fetchColumn();
+		if ( $case_count != '0' ) {
+			$has_multiple_cases = true;
+		}
+
+		// Does this person has any AKAs?
+		$sql_akas = "SELECT count(*) FROM akas WHERE case_id = '{$case['id']}'";
+		$st_akas = $dbh->prepare($sql_akas);
+		$st_akas->execute();
+		if ( $st_akas->fetchColumn() != '0' ) {
+			$has_akas = true;
+		}
+
+		if ( $has_multiple_cases && ! $has_akas ) {
+			fputcsv($def_multiple_cases_csv, $defendant_csv);
+			fwrite($def_multiple_cases_html, $defendant_html);
+		}
+
+		if ( $has_akas && ! $has_multiple_cases ) {
+			fputcsv($def_akas_csv, $defendant_csv);
+			fwrite($def_akas_html, $defendant_html);
+		}
+
+		if ( $has_multiple_cases && $has_akas ) {
+			fputcsv($def_akas_multiple_cases_csv, $defendant_csv);
+			fwrite($def_akas_multiple_cases_html, $defendant_html);
+		}
+
+
+		// The highest quality list
+		if ( ! $has_multiple_cases && ! $has_akas ) {
+			switch ( $disposition_group ) {
+				case '1':
+					fputcsv($def_grp1_csv, $defendant_csv);
+					fwrite($def_grp1_html, $defendant_html);
+					break;
+				case '2':
+					fputcsv($def_grp2_csv, $defendant_csv);
+					fwrite($def_grp2_html, $defendant_html);
+				case '3':
+					fputcsv($def_grp3_csv, $defendant_csv);
+					fwrite($def_grp3_html, $defendant_html);
+					break;
+				case '4':
+					fputcsv($def_grp4_csv, $defendant_csv);
+					fwrite($def_grp4_html, $defendant_html);
+					break;
+				default:
+					fputcsv($def_no_grp_csv, $defendant_csv);
+					fwrite($def_no_grp_html, $defendant_html);
+			}
+		}
+
+	}
+}
+
+// Finalize HTML files
+fwrite($def_no_grp_html, $html_stop);
+fwrite($def_grp1_html, $html_stop);
+fwrite($def_grp2_html, $html_stop);
+fwrite($def_grp3_html, $html_stop);
+fwrite($def_grp4_html, $html_stop);
+fwrite($def_multiple_cases_html, $html_stop);
+fwrite($def_akas_html, $html_stop);
+fwrite($def_akas_multiple_cases_html, $html_stop);
+
+fclose($def_no_group_csv);
+fclose($def_grp1_csv);
+fclose($def_grp2_csv);
+fclose($def_grp3_csv);
+fclose($def_grp4_csv);
+fclose($def_multiple_cases_csv);
+fclose($def_akas_csv);
+fclose($def_akas_multiple_cases_csv);
+fclose($def_no_group_html);
+fclose($def_grp1_html);
+fclose($def_grp2_html);
+fclose($def_grp3_html);
+fclose($def_grp4_html);
+fclose($def_multiple_cases_html);
+fclose($def_akas_html);
+fclose($def_akas_multiple_cases_html);
+
+?>
diff --git a/interesting_defendants/safe_dispositions b/interesting_defendants/safe_dispositions
new file mode 100644
index 0000000..4be60b1
--- /dev/null
+++ b/interesting_defendants/safe_dispositions
@@ -0,0 +1,43 @@
+ABANDONED
+ACQUITTAL/INSANITY
+ACQUITTED BY COURT
+ACQUITTED BY JURY
+CASE FILED IN ERROR
+CLOSED ADMIN JUDGE
+CLOSED/PER ADM MEMO
+DEF PROSECUTION PGM
+DEFER DRUG PROGRAM
+DEFER FIRE ARM PGM
+DISCHARGE
+DISM - SPEEDY TRIAL
+DISM W/O PREJUDICE
+DISM WITH PREJUDICE
+DISM-LACK OF PROS
+DISM/NO PROB CAUSE
+DISMISS/MODIFY
+DISMISS/TERM
+DISMISSED
+DISMISSED BY COURT
+DISMISSED-WITNESS
+DIV DEFR DRUG PGM
+DRUG COURT PRG PLEA
+NO ACTION
+NO ACTION - FIL CTY
+NO ACTION - FIL TRAF
+NO ACTION FILED TRF
+NO INFORMATION
+NO TRUE BILL
+NOLLE PROS
+NOLLE PROS - ADMIN
+NOLLE PROS - REST
+NOLLE PROS FILED TRF
+NOLLE PROS JDP
+NOLLE PROS- USAO/INS
+NOLLE PROS-ADM/WRNT
+NOLLE PROS-COMP 'DVI
+NOLLE PROS-COMP PTI
+NOLLE PROS-DRUG PGM
+NOLLE PROS-F/A PGM
+NOLLE PROS-WITNESS
+NOLLE PROS/FILED CC
+NON JUDICIAL ACTION