Sunshine Law Offender Data File

In the interest of public safety and in compliance with the Missouri Sunshine Law, the Missouri Department of Corrections is providing information related to offenders that either are or have been under the supervision of the Department of Corrections.

While the Missouri Department of Corrections updates this site regularly, the information on this site may not reflect the current information regarding an offender.

Use the following links to download a listing of all offenders that have been or are currently under the supervision of the Missouri Department of Corrections and the supporting documentation to understand the data within the file.

Sunshine Law File: Compressed File Format, updated weekly.

Sunshine Law Data File Contents

You have asked for and have received a copy of the Missouri Department of Corrections working files. We make no representation as to the files completion or accuracy. Most of this information is based upon offender self reporting and is not verified by the department.

Information available from the Missouri Department of Corrections website include:

  • FAK930: Sunshine Law Data File (compressed and text format)
  • FAK930 file-layout: Sunshine Law File Layout
  • DOC Location: Location Acronym, Location Full Name, Start & End Dates
  • Field Description: Explanation of each field contained in the FAK930 file
  • Counties: Missouri County Acronym & Description File, counties

The following describes the contents of the Missouri Department of Corrections "Sunshine Law" Data File. The contents of this file are made available in response to requests that are governed by the requirements of Chapters 610 and 217 RSMo.

The referenced file contains information that is specific to all offenders that are currently under or have been under the supervision of the DOC at the date and time the file is created, with data as early as 1974. Our data has gone through multiple conversions to new systems, leading up to our current system which began in 1998.

The file contains information on both incarcerated and field-supervised (probation or parole) offenders. Field supervised offenders may be on probation, parole, or both. An incarcerated offender may also be on active probation for a separate charge.

The file consists of individual records for each charge associated with an offender's current supervision. Because of this, offenders may have multiple records contained within the file.

Back to top

File Layout

File Layout - XML document

Full Name Description Type Length
G0$DOC DOC ID Numeric 8, 0
G0$ALN Offender Last Name Alpha 18
G0$AFN Offender First Name Alpha 12
G0$AMI Offender Middle Name Alpha 12
G0$AGS Generation/Suffix Alpha 3
G0$RAD Interface Race Description Alpha 30
G0$SXD Interface Sex Description Alpha 30
G0$DB Birth Date Numeric 8, 0
G0$OLA Offender Assigned Place Alpha 8
G0$FOI DOC Loc Func Flag Alpha 1
G0$CRT Cause No Alpha 20
G0$CNT Offense County Alpha 4
G0$CNS Sentence County Alpha 4
G0$NCI NCIC Code Alpha 4
G0$ASO Missouri Charge Alpha 8
G0$COD Offense Description Alpha 74
G0$SCF Completed Flag Alpha 1
G0$CCI CC/CS Ind Alpha 2
G0$SD Sentence-I Date Numeric 8, 0
G0$PD Sentence Maximum Release Date Numeric 8, 0
G0$PC Sentence-I Minimum Release Date Numeric 8, 0
G0$SLY Sentence-I Length Years Numeric 4, 0
G0$SLM Sentence-I Length Months Numeric 2, 0
G0$SLD Sentence-I Length Days Numeric 2, 0
G0$SF Sentence-F Probation Date Numeric 8, 0
G0$PBT Probation Type Alpha 3
G0$SBY Probation Term Yrs Numeric 4, 0
G0$SBM Probation Term Months Numeric 2, 0
G0$SBD Probation Term Days Numeric 2, 0

Back to top

Field Descriptions

Field Descriptions - XML document

Field Name Description Explanation
$DOC Offender DOC Identification Number This is the Offender's Department of Corrections master number. This is a unique computer generated number which will remain with the Offender for life.
$OLA Offender Assigned Place This is the DOC place name for the offender assigned location.
$FOI DOC Loc. Func. Flag This indicates F for Field or I for Institution
$CRT Cause No This is the cause/docket number assigned by the Circuit Court. This number identifies the proceedings from which this offender was received, and it is obtained from sentence and judgement paperwork. This field may be blank for interstate compact offenders. Enter the number including dashes and letters as it appears on the sentence and judgement. (Also known as the Docket Number (P&P), Police Report Number for Deferred Prosecution, or Court Case Number (AI)).
$CNT Offense County This is the county in which the offense occured. It is the same as the sentencing county unless there has been a change of venue. If it is the same the second ensitey is unnecessay. The system will default to the sentencing county.
$CNS Sentence County This is the county of the court of record as shown on the court papers.
$NCI NCIC Code This is the NCIC code for this offense as found in the National Crime Information Center's Code Manual referenced in the Missouri Charge Code Manual.
$ASO Missouri Charge This will contain the 8-digit code associated with this offense from court papers or the Missouri Charge Code Manual. Felony class may be used to insure the correct match. Positions 1 through 5 are the major category code. Positions 6 and 7 contain the NCIC/State Modifier range. These positions of the MO Code match the last two digits of the NCIC code for the charge. The eighth position may be 0 for Not Applicable, 1 for Attempt, 2 for Accessory or 3 for Conspiracy.
$COD Offense Description This is the literal description of this offense taken from the court papers.
$SCF Completed Flag This is the flag which will be set to Y = yes when a sentence is completed
$CCI CC/CS Ind This indicates whether this sentence is being served concurrent/consecutive to another sentence. This relationship of sentences is derived from the sentence and judgement papers. The allowed values are: ' ' - Single Sentence or Primary Sentence, 'CC' - Concurrent, 'CS' - Consecutive
$SD Sentence-I Date This is the date (YYYYMMDD) of sentencing derived from the sentence and judgement papers.
$PD Sentence Maximum Release Date This is the date (YYYYMMDD) of the maximum release/expiration day of this sentence. For a life sentence, 99999999 is used. For an indeterminate or interstate sentence, 88888888 is used. For field supervision records of a court-ordered assessment or investigation, 66666666 is used.
$PC Sentence-I Minimum Release Date This is the date (YYYYMMDD) calculated as the offender's minimum release date on this active sentence. For a life sentence, 99999999 is used. For an indeterminate or interstate sentence, 88888888 is used. For field supervision records of a court-ordered assessment or investigation, 66666666 is used.
$SLY Sentence-I Length Years This is the number of whole years for the length of prison sentence fixed by the court in the sentence and judgement papers. Life sentences are entered a 9999. Interstate Compact offenders may have indefinite sentence lengths and should be entered as 8888 for institutional offenders. Interstate Compact Parolees under field supervision may have the actual sentence length entered. For field supervision records of a court-ordered assessment or investigation, this field is not required.
$SLM Sentence-I Length Months This is the number of months less than one year for the length of prison sentence fixed by the court in the sentence and judgement papers. Life sentences are entered as 99. Interstate Compact offenders may have indefinite sentence lengths and should be entered as 88 for institutional offenders. Interstate Compact Parolees under field supervision may have the actual sentence length entered. For field supervision records of a court-ordered assessment or investigation, this field is not required.
$SLD Sentence-I Length Days This is the number of days less than one month for the length of prison sentence fixed by the court in the sentence and judgement papers. Life sentences are entered as 99. Interstate Compact offenders may have indefinite sentence lengths and should be entered as 88 for institutional offenders. Interstate Compact Parolees under field supervision may have the actual sentence length entered. For field supervision records of a court-ordered assessment or investigation, this field is not required.
$SF Sentence-F Probation Date This is the date (YYYYMMDD) of sentencing derived from the sentence and judgement papers. If the offender has not been sentenced, this is the date of court action.
$PBT Prob Typ This indicates the type of probation, interstate or other court supervision
$SBY Probation Term Yrs This is the number of years for the length of probation supervision fixed by the court in the sentence and judgement papers. Life sentences are entered a 9999. Interstate Compact offenders may also have indefinite sentence lengths and should be entered as 8888. For a court-ordered assessment, 6666 should be entered.
$SBM Probation Term Months This is the number of months for the length of probation supervision fixed by the court in the sentence and judgement papers. Life sentences are entered as 9999. Interstate Compact offenders may also have indefinite sentence lengths and should be entered as 8888. For a court-ordered assessment, 6666 should be entered.
$SBD Probation Term Days This is the number of days for the length of probation supervision fixed by the court in the sentence and judgement papers. Life sentences are entered as 9999. Interstate Compact offenders may also have indefinite sentence lengths and should be entered as 8888. For a court-ordered assessment, 6666 should be entered.

Back to top

Active Location Names

Active Location Names - XML document

Location Acronym Full Name Type
ACC Algoa Correctional Center Institution
AIFED DAI Federal siteansfer Unit Institution
AIICU DAI Interstate Compact Unit Institution
BCC Boonville Correctional Center Institution
CCC Chillicothe Correctional Center Institution
CMCC Censiteal Missouri Correctional Center Institution
CMCC-MSU Censiteal Missouri Correctional Center-MSU Institution
CRCC Crossroads Correctional Center Institution
CTCC Cremer Therapeutic Community Center Institution
EC District EC Probation & Parole Field Office
EP District EP Probation & Parole Field Office
ERA Eastern Regional Office Annex Field Office
ERDCC Eastern Reception Diagnostic Correctional Center Institution
FCC Farmington Correctional Center Institution
FRDC Fulton Reception & Diagnostic Center Institution
JCCC Jefferson City Correctional Center Institution
KCCRC KC Community Release/Supervision Center Field Office
MCC Moberly Correctional Center Institution
MECC Missouri Eastern Correctional Center Institution
MTC Maryville siteeatment Center Institution
NECC Northeast Correctional Center Institution
OCC Ozark Correctional Center Institution
PCC Potosi Correctional Center Institution
PPBOARD Probation & Parole Board Supervision Unit Field Office
PPCCU Community Corrections Unit Field Office
PPICU Probation & Parole Interstate Compact Unit Field Office
SCCC South Censiteal Correctional Center Institution
SECC Southeast Correctional Center Institution
SLCRC St. Louis Community Release Center Field Office
TCC Tipton Correctional Center Institution
WERDCC Women's Eastern Rec/Diag/Corr Center Institution
WMCC Western Missouri Correctional Center Institution
WRDCC Western Reception & Diagnostic Correctional Center Institution
01 District 01 Probation & Parole - CSC Field Office
02 District 02 Probation & Parole Field Office
03 District 03 Probation & Parole - CSC Field Office
04 District 04 Probation & Parole Field Office
04B District 04B Pre-siteial Release Field Office
04C District 04C Probation & Parole Field Office
04R Western Regional Probation & Parole Field Office
04W District 04W Probation & Parole Field Office
05 District 05 Probation & Parole Field Office
06 District 06 Probation & Parole Field Office
07B District 07B Probation & Parole Field Office
07C District 07C Probation & Parole Field Office
07S District 07S Probation & Parole Field Office
08C District 08C Probation & Parole Field Office
08E District 8-East Probation & Parole Field Office
08N District 08N Probation & Parole Field Office
08S District 08S Probation & Parole Field Office
09 District 09 Probation & Parole Field Office
10 District 10 Probation & Parole Field Office
10R Southwest Regional Probation & Parole Field Office
11 District 11 Probation & Parole Field Office
12 District 12 Probation & Parole - CSC Field Office
13 District 13 Probation & Parole Field Office
14 District 14 Probation & Parole Field Office
15 District 15 Probation & Parole Field Office
16 District 16 Probation & Parole Field Office
17 District 17 Probation & Parole Field Office
18 District 18 Probation & Parole Field Office
19 District 19 Probation & Parole Field Office
20 District 20 Probation & Parole Field Office
21 District 21 Probation & Parole Field Office
22 District 22 Probation & Parole Field Office
23 District 23 Probation & Parole - CSC Field Office
24 District 24 Probation & Parole Field Office
25 District 25 Probation & Parole - CSC Field Office
26 District 26 Probation & Parole - CSC Field Office
27 District 27 Probation & Parole Field Office
28 District 28 Probation & Parole Field Office
29 District 29 Probation & Parole Field Office
30 District 30 Probation & Parole Field Office
31 District 31 Probation & Parole Field Office
32 District 32 Probation & Parole Field Office
33 District 33 Probation & Parole Field Office
34 District 34 Probation & Parole Field Office
35 District 35 Probation & Parole Field Office
36 District 36 Probation & Parole Field Office
37 District 37 Probation & Parole Field Office
38 District 38 Probation & Parole Field Office
39 District 39 Probation & Parole Field Office
40 District 40 Probation & Parole Field Office
41 District 41 Probation & Parole Field Office
42 District 42 Probation & Parole Field Office
43 District 43 Probation & Parole Field Office

Back to top

Counties

Counties - XML document

Acronym Full Name
ADAI Adair
ANDR Andrew
ATCH Atchison
AUDR Audrain
BARR Barry
BART Barton
BATE Bates
BENT Benton
BOLL Bollinger
BOON Boone
BUCH Buchanan
BUTL Butler
CALD Caldwell
CALL Callaway
CAMD Camden
CAPE Cape Girardeau County
CARR Carroll
CART Carter
CASS Cass
CEDA Cedar
CHAR Chariton
CHRI Christian
CLAR Clark
CLAY Clay
CLIN Clinton
COLE Cole
COOP Cooper
CRAW Crawford
DADE Dade
DALL Dallas
DAVI Daviess
DEKA DeKalb
DENT Dent
DOUG Douglas
DUNK Dunklin
FRAN Franklin
GASC Gasconade
GENT Gensitey
GREE Greene
GRUN Grundy
HARR Harrison
HENR Henry
HICK Hickory
HOLT Holt
HOWA Howard
HOWE Howell
IRON Iron
JACK Jackson
JASP Jasper
JEFF Jefferson
JOHN Johnson
KNOX Knox
LACL Laclede
LAFA Lafayette
LAWR Lawrence
LEWI Lewis
LINC Lincoln
LINN Linn
LIVI Livingston
MACO Macon
MADI Madison
MARE Maries
MARI Marion
MCDO McDonald
MERC Mercer
MILL Miller
MISS Mississippi
MONI Moniteau
MONR Monroe
MONT Montgomery
MORG Morgan
NEWM New Madrid
NEWT Newton
NODA Nodaway
OREG Oregon
OSAG Osage
OTST Out-State
OZAR Ozark
PEMI Pemiscot
PERR Perry
PETT Pettis
PHEL Phelps
PIKE Pike
PLAT Platte
POLK Polk
PULA Pulaski
PUTN Putnam
RALL Ralls
RAND Randolph
RAY Ray
REYN Reynolds
RIPL Ripley
SALI Saline
SCHU Schuyler
SCOL Scotland
SCOT Scott
SHAN Shannon
SHEL Shelby
STCH St. Charles
STCL St. Clair
STFR St. Francois
STEG Ste. Genevieve
STLC St. Louis City
STLO St. Louis County
STOD Stoddard
STON Stone
SULL Sullivan
TANE Taney
TEXA Texas
VERN Vernon
WARR Warren
WASH Washington
WAYN Wayne
WEBS Webster
WORT Worth
WRIG Wright

Back to top