Harvey Ruvin - Clerk of the Courts - Miami-Dade County, Florida

CRIMINAL PUBLIC ACCESS FOLDER DESCRIPTION

The Clerk of the Courts provides daily files containing all criminal case information processed by the court the previous day. This file can be downloaded by the interested parties from the County’s site.

Bi-weekly, weekly and monthly files are also available as described below.

Criminal extracts are in the form of ASCII text files in which records may be delimited by the character (^) and have a variable length or may be column delimited. The extract files contain the following record structure:

Table of Contents

Bi-Weekly Files

Daily Files

Monthly Files

Weekly Files

 

BI-WEEKLY FILES

 

Felony File Structure (File Definition)

File Name:  Felony.asc                 

Run Frequency:  Bi-Weekly (Monday & Thursday)  

Description:  Extracts new felony and misdemeanor case information

Field Name

Field Description

Comment

Case Number

CHAR(12)

 

Name

CHAR(50)

 

Race

CHAR(1)

 

Sex

CHAR(1)

 

DOB

DATE(8)

Format ccyymmdd

Street

CHAR(29)

 

City State

CHAR(18)

 

Zip

CHAR(9)

 

Charge

CHAR(11)

 

Char Des

CHAR(20)

 

Char Cnt

CHAR(2)

 

 

DAILY FILES

 

CJIS Filings Closing File Structure (File Definition)

File Name:  dly_cjis_filings_closings_ccyymmdd.txt

Run Frequency:  Daily  

File Description:  Extract Closed or Filed Cases Daily 

Field Name

Field Description

Comment

CIN

NUMERIC(7)

 

IDS

NUMERIC(7)

 

Last Name

CHAR(30)

 

First Name

CHAR(12)

 

Middle Name

CHAR(12)

 

DOB

DATE(8)

Format ccyymmdd

Race

CHAR(1)

 

Sex

CHAR(1)

 

Street

CHAR(24)

 

Apt

CHAR(5)

 

City

CHAR(15)

 

State

CHAR(2)

 

Zip

CHAR(9)

 

Case Number

CHAR(12)

 

State Case Number

CHAR(20)

 

Police Number

CHAR(15)

 

Jail Number

CHAR(9)

 

Bfile Sect

CHAR(4)

 

Arrest Date

DATE(8)

Format ccyymmdd

File Date

DATE(8)

Format ccyymmdd

Info Date

DATE(8)

Format ccyymmdd

Close Date

DATE(8)

Format ccyymmdd

Assessed

CHAR(11)

 

Balance Due

NUMERIC(11,2)

Format 99999999999.99

Chg Status

CHAR(1)

 

Input Number

CHAR(11)

 

Chg Seq Number

NUMERIC(5)

 

Intent

CHAR(1)

 

Version

CHAR(1)

 

Type

CHAR(1)

 

Degree

CHAR(1)

 

Offense Description

CHAR(20)

 

Disposition Code

NUMERIC(3)

 

Disposition Description

CHAR(20)

 

Disposition Date

DATE(8)

Format ccyymmdd

Sent Type

CHAR(1)

 

Sent Dur

NUMERIC(3,2)

Format 999.99

Prob Lg

CHAR(4)

 

Prob Type

CHAR(1)

 

Prob Start Date

DATE(8)

Format ccyymmdd

Prob End Date

DATE(8)

Format ccyymmdd

 

Nolle Pros File Structure (File Definition)

File Name:  Dly_nolle_pros_ccyymmdd.txt          

Run Frequency:  Daily  

Description:  Closed Cases with Nolle Pros disposition from the previous day  

Field Name

Field Description

Comment

Filler

CHAR(1)

 

Case Number

CHAR(12)

 

Defn Last Name

CHAR(30)

 

Defn First Name

CHAR(12)

 

Defn Mid Name

CHAR(12)

 

Defn Street

CHAR(24)

 

Defn Apt

CHAR(5)

 

Defn City

CHAR(15)

 

Defn State

CHAR(2)

 

Defn Zip

CHAR(9)

 

  

Nolle Pros File Structure (File Definition)

File Name:  Nollepro_ccyymmdd.asc            

Run Frequency:  Daily  

File Description:  Closed Cases with Nolle Pros disposition from the previous day  

Field Name

Field Description

Comment

Filler

CHAR(1)

 

Case Number

CHAR(12)

 

Defn Last Name

CHAR(30)

 

Defn First Name

CHAR(12)

 

Defn Mid Name

CHAR(12)

 

Defn Street

CHAR(24)

 

Defn Apt

CHAR(5)

 

Defn City

CHAR(15)

 

Defn State

CHAR(2)

 

Defn Zip

CHAR(9)

 

 

MONTHLY FILES

 

Case Charges File Structure (File Definition)

File Name:  mly_casechg_yyyymmdd.txt              

Run Frequency:  Monthly

Description:  Closed or Filed Cases with Charges  

Field Name

Field Description

Comment

Case Number

CHAR(12)

 

Record Cd

CHAR(6)

Value ‘10CASE’

File Date

DATE(8)

Format ccyymmdd

Close Date

DATE(8)

Format ccyymmdd

Arrest Date

DATE(8)

Format ccyymmdd

Assessed

CHAR(11)

 

IDS Num

NUMERIC(7)

 

  

Field Name

Field Description

Comment

Case Number

CHAR(12)

 

Record Cd

CHAR(6)

Value ‘20NAME’

IDS Number

NUMERIC(7)

 

CIN Number

NUMERIC(7)

 

Last Name

CHAR(30)

 

First Name

CHAR(12)

 

Middle Name

CHAR(12)

 

DOB

DATE(8)

Format ccyymmdd

Race

CHAR(1)

 

Sex

CHAR(1)

 

 

Field Name

Field Description

Comment

Case Number

CHAR(12)

 

Record Cd

CHAR(6)

Value ‘30ADD’

IDS Number

NUMERIC(7)

 

CIN Number

NUMERIC(7)

 

Street

CHAR(24)

 

Apt

CHAR(5)

 

City

CHAR(15)

 

Zip

CHAR(9)

 

  

Field Name

Field Description

Comment

Case Number

CHAR(12)

 

Record Cd

CHAR(6)

Value ‘50CHG’

Input Number

CHAR(11)

 

Intent

CHAR(1)

 

Version

CHAR(1)

 

Type

CHAR(1)

 

Degree

CHAR(1)

 

Desc

CHAR(20)

 

Disp Cd

NUMBER(3)

 

Disp Desc

CHAR(20)

 

Disp Date

DATE(8)

 

Sent Type

CHAR(1)

 

Sent Dur

NUMBER(3,2)

Format 999.99

 

CJIS Filings Closings File Structure (File Definition)

File Name:  mly_cjis_filings_closings_yyyymmdd.txt            

Run Frequency:  Monthly

Description:  Extract Closed or Filed Cases for the Previous Month  

Field Name

Field Description

Comment

CIN

NUMERIC(7)

 

IDS Num

NUMERIC(7)

 

Last Name

CHAR(30)

 

First Name

CHAR(12)

 

Middle Name

CHAR(12)

 

DOB

DATE(8)

Format ccyymmdd

Race

CHAR(1)

 

Sex

CHAR(1)

 

Street

CHAR(24)

 

Apt

CHAR(5)

 

City

CHAR(15)

 

Zip

CHAR(9)

 

Case Number

CHAR(12)

 

State Case Number

CHAR(20)

 

Police Number

CHAR(15)

 

Jail Number

CHAR(9)

 

Bfile Sect

CHAR(4)

 

Arrest Date

DATE(8)

Format ccyymmdd

File Date

DATE(8)

Format ccyymmdd

Info Date

DATE(8)

Format ccyymmdd

Close Date

DATE(8)

Format ccyymmdd

Assessed

CHAR(11)

 

Balance Due

NUMERIC(11,2)

Format 99999999999.99

Chg Status

CHAR(1)

 

Input Number

CHAR(11)

 

Chg Seq Number

NUMERIC(5)

 

Intent

CHAR(1)

 

Version

CHAR(1)

 

Type

CHAR(1)

 

Degree

CHAR(1)

 

Offense Description

CHAR(20)

 

Disposition Code

NUMERIC(3)

 

Disposition Description

CHAR(20)

 

Disposition Date

DATE(8)

Format ccyymmdd

Sent Type

CHAR(1)

 

Sent Dur

NUMERIC(3,2)

Format 999.99

Prob Lg

CHAR(4)

 

Prob Type

CHAR(1)

 

Prob Start Date

DATE(8)

Format ccyymmdd

Prob End Date

DATE(8)

Format ccyymmdd

  

CJIS Hist File Structure (File Definition)

File Name:  Cjshist.asc                  

Run Frequency:  Monthly

Description:  Custom File 

Field Name

Field Description

Comment

Case Number

CHAR(12)

 

Arst Date

DATE(8)

Format ccyymmdd

Arst Dept

CHAR(3)

 

Case File Date

DATE(8)

Format ccyymmdd

Case Close Date

DATE(8)

Format ccyymmdd

Last Name

CHAR(30)

 

First Name

CHAR(12)

 

Mid Name

CHAR(12)

 

Title

CHAR(3)

 

Street

CHAR(24)

 

City

CHAR(15)

 

State

CHAR(2)

 

Zip

CHAR(9)

 

Race

CHAR(1)

 

Sex

CHAR(1)

 

DOB

DATE(8)

Format ccyymmdd

Chg Final Input Num

CHAR(11)

 

Offn Desc

CHAR(20)

 

Chg Disp Cd

CHAR(3)

 

Chg Disp Desc

CHAR(20)

 

 

Felony Convictions File Structure (File Definition)

File Name: Mly_felconv_ccyymmdd.txt                

Run Frequency: Monthly  

Description:  File of Felony Cases Closed the Previous Month with a Conviction Disposition 

Field Name

Field Description

Comment

Last Name

CHAR(30)

 

First Name

CHAR(12)

 

Street

CHAR(24)

 

Apt

CHAR(5)

 

City

CHAR(15)

 

State

CHAR(2)

 

Zip

CHAR(9)

 

Case Number

CHAR(14)

 

Close Date

DATE(8)

Format ccyymmdd

 

WEEKLY FILES

 

Dispositions Descriptions File Structure (File Definition)

File Name:  Wky_dispstn_desc_yyyymmdd.asc            

Run Frequency:  Weekly  

Description: Weekly Listing of CJIS Disposition Descriptions  

Field Name

Field Description

Comment

Filler

CHAR(1)

VALUE ‘ ‘

Disp Cd

CHAR(3)

 

Desc20

CHAR(20)

 

Desc40

CHAR(40)

 

Disp Type

CHAR(1)

 

Juv Only Flag

CHAR(1)

 

Fstr Care Flag

CHAR(1)

 

Plea Ng Flag

CHAR(1)

 

Plea Nolo Flag

CHAR(1)

 

Plea Glty Flag

CHAR(1)

 

No Plea Flag

CHAR(1)

 

Prob Sent Reqd

CHAR(1)

 

Last Chgd ID

CHAR(8)

 

Last Chgd Date

DATE(8)

 

Last Chgd Time

NUMBER(4)

 

Last Chgd Term

CHAR(8)

 

Jlmtx Flag

CHAR(1)

 

Sent Type

CHAR(1)

 

Group

CHAR(2)

 

 

Offense Descriptions File Structure (File Definition)

File Name:  Wky_offense_desc_yyyymmdd.asc            

Run Frequency:  Weekly  

Description:  Weekly Listing of CJIS Offense Descriptions  

Field Name

Field Description

Comment

Filler

CHAR(1)

VALUE ‘ ‘

Chapter

CHAR(3)

 

Section

CHAR(4)

 

Intent

CHAR(1)

 

Version

CHAR(1)

 

Type

CHAR(1)

 

Degree

CHAR(1)

 

Old Input Number

NUMBER(9)

 

Statute Number

CHAR(16)

 

FLDOC Number

NUMBER(4)

 

Sentguide Level

NUMBER(3)

 

Matrix Score

NUMBER(3)

 

Desc50

CHAR(50)

 

Desc20

CHAR(20)

 

Std Bond Amt

CHAR(9)

 

NCIC Code

NUMBER(4)

 

Create Date

DATE(8)

 

Inact Date

DATE(8)

 

Error Date

DATE(8)