Please submit Missouri Sunshine Law-related requests for information to the appropriate custodian of records for each division.
- Missouri Department of Corrections Office of Director: OD.SunshineRequest@doc.mo.gov
- Missouri Parole Board: ParoleBoard.SunshineRequest@doc.mo.gov
Offender Database
In the interest of public safety and in compliance with the Missouri Sunshine Law, the Missouri Department of Corrections provides information about people who either are or have been under the supervision of the department.
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 nightly.
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.
File Layout
| 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 |
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. |
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 |
Counties
| 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 |