diff options
Diffstat (limited to 'interesting_defendants')
| -rw-r--r-- | interesting_defendants/disposition_groups | 86 | ||||
| -rw-r--r-- | interesting_defendants/excludable_charges | 438 | ||||
| -rw-r--r-- | interesting_defendants/fatal_dispositions | 71 | ||||
| -rw-r--r-- | interesting_defendants/interesting_defendants.php | 213 | ||||
| -rw-r--r-- | interesting_defendants/safe_dispositions | 43 |
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 |