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

CIVIL PUBLIC ACCESS FOLDER DESCRIPTION

The Clerk of the Courts provides daily files containing all civil (Circuit and County Civil) case information processed by the court the previous day. These files can be downloaded by the interested parties from the County’s site.

A ZIP file (daily_civil_09292015.zip) will be posted on the County’s ftp site containing the main case information for the current day and the lookup tables associated to user codes (case events, case types, judges, party types, etc):

The naming convention will be: 'daily_civil_'+<date of extraction>+.zip.  

Other weekly and monthly files are described below.

Civil extracts are in the form of ASCII text files in which records are delimited by a caret (^) and have a variable length. The file extension “.exp” stands for export file. The extract files contain the following record structure:

Table of Contents

Daily Files

Monthly Files

Weekly Files

DAILY FILES

 

Case File Structure (File Definition)

File Name: Cases.exp

Run Frequency: Daily

Description: Contains civil case information for cases changed the previous day.  This includes new cases and any changes to cases.

For historical information retention, all case information must be overlapped by the new file where the “case id” or “case number” matches the old one. In other words, a full refresh of the case must be performed by the customer.

Sample File:  Cases.xls

Field Description

Field Type

Description

Case ID

NUMBER(11)

Unique key of the case (ie. 1654210)

Case Number

CHAR(30)

Local case number (ie. 2007-025360-CA -01)

Filing Date

DATE(10)

Filing date of the case

Style 

CHAR(300)

Style of the case (ie. Ramos Raul vs. Hugh Grant)

Case Type Code

CHAR(20)

Case type code (old action code in SIVA)

Judge Code

CHAR(20)

Judge code of the case (ie. 00182)

Section Code

CHAR(20)

Family section of the case (ie. CA01)

State Case Number

CHAR(30)

State case number

Companion Case

CHAR(30)

Companion case

Disposition Date

DATE(10)

Date case was disposed

 

Party File Structure (File Definition)

File Name:  Parties.exp

Run Frequency:  Daily

Description:  Contains party information for cases changed the previous day.

For historical information retention, all party information must be overlapped by the new file where the “case id” or “case number” matches the old one. In other words, a full refresh of the parties must be performed by the customer.

Sample File: Parties.xls                    

Field Description

Field Type

Description

Party ID

NUMBER(11)

Unique key for a party in Odyssey

Case ID      

NUMBER(11)

Foreign key to the case

Case Number

CHAR(30)

Local case number (ie. 2007-025360-CA-01)

Party Name

CHAR(180)

Party name (LName, FName MName)

Party Type

CHAR(20)

Party type code (ie. PN=Petitioner Defendant= DN)

Bar Number

CHAR(20)

Attorney bar number

Attorney Name

CHAR(180)

Attorney name of the party (LName, FName MName)

Disposition Code

CHAR(20)

Event code that triggered the disposition

Disposition Date

CHAR(10)

Date case was disposed

Address 1

CHAR (64)

Address line 1

Address 2

CHAR (64)

Address line 2

Address 3

CHAR (64)

Address line 3

Address 4

CHAR (64)

Address line 4

City

CHAR (64)

City

State

CHAR (2)

State abbreviation

Zip

CHAR (10)

Zip Code

 

Docket File Structure (File Definition)

File Name:  Dockets.exp

Run Frequency:  Daily

Description:  Contains list of dockets for any case changed the previous day.

For historical information retention, all docket information must be overlapped by the new file where the “case id” or “case number” matches the old one. In other words, a full refresh of the dockets must be performed by the customer.

Sample File:  Dockets.xls

Field Description

Field Type

Description

Event ID

NUMBER(11)

Unique key for a docket

Case ID      

NUMBER(11)

Foreign key to the case

Case Number

CHAR(30)

Local case number (ie. 2007-025360-CA-01)

Event Date

DATE(10)

Docket date

Docket Code

CHAR(20)

Docket code (ie. FJUD)

Description

CHAR(100)

Docket description

Book

CHAR(20)

Recording book number

Page

CHAR(30)

Recording page

Event Type

CHAR(1)

(E=Event, J=Judgment, H=Hearing, S=Service)

 

Case Types Lookup Table File Structure (File Definition) 

File Name:  CaseType.exp

Run Frequency:  Daily

Description:  Contains the definition of the case type code

Sample File:  CaseType.xls

Field Description

Field Type

Description

Case Type ID

NUMBER(11)

Unique key for a case type in the system

Case Type Code

CHAR(20)

Case type user code (ie. DOM)

Description

CHAR(100)

Case type description

Creation Date

DATE(10)

Creation Date

Obsolete Date

DATE(10)

Obsolete Date

 

Event Types Lookup Table File Structure (File Definition) 

File Name: Events.exp

Run Frequency:  Daily

Description:  Contains the definition of the docket/event code.  Information is sorted by Event Definition (E, H, J and S) and Event Type ID. Keep in mind that the “Event Type Code” could be the same among different Event Definitions.

Sample File:  Events.xls

Field Description

Field Type

Description

Event Type ID

NUMBER(11)

Unique key for an event type in the system

Event Type Code

CHAR(20)

Event type user code (ie. NOTI, FJUD)

Description

CHAR(100)

Event type description

Creation Date

DATE(10)

Creation Date

Obsolete Date

DATE(10)

Obsolete Date

Event Definition

CHAR(1)

(E=Event, J=Judgment, H=Hearing, S=Service)

 

Judge Section Lookup Table File Structure (File Definition) 

File Name:  Judges.exp

Run Frequency: Daily

Description:  Contains the translation of the judicial section to Judge’s Name.  Since the user code is unique for the entire record set (table), developers can match the judge and/or section assigned to a case based on the Judge Code or Section Code fields of the Case table.

Sample File: Judges.xls

Field Description

Field Type

Description

Judge/Sec ID

NUMBER(11)

Unique key for a judge or section in the system

Judge/Sec Code

CHAR(20)

Judge or Section user code (ie. DOM)

Judge/Sec Description

CHAR(100)

Judge or Section description

Creation Date

DATE(10)

Creation Date

Obsolete Date

DATE(10)

Obsolete Date

 

Party Types Lookup Table File Structure (File Definition) 

File Name:  PartyType.exp 

Run Frequency: Daily

Description:  Contains the definition of the party types

Sample File:  PartyType.xls

Field Description

Field Type

Description

Party Type ID

NUMBER(11)

Unique key for a party type in the system

Party Type Code

CHAR(20)

Party type code (ie. PN = Plaintiff, DN = Defendant, LT = the address of the property)

Party Type Description

CHAR(100)

Party type description

Creation Date

DATE(10)

Creation Date

Obsolete Date

DATE(10)

Obsolete Date

 

New Case File Structure (File Definition)

File Name: NewCaseCCYYMMDD.txt

Run Frequency: Daily

Description:  All new cases created yesterday.

Sample File:  NewCaseCCYYMMDD.xls

Field Description

Field Type

Description

Case Number

VARCHAR(30)

 

File Date

DATE(10)

Format MM/DD/YYYY

Case Type

VARCHAR(100)

 

Party Name

VARCHAR(300)

 

Party Code

VARCHAR(20)

 

Judicial Section

VARCHAR(20)

 

Pretrial Hearing Date

DATE(10)

Format MM/DD/YYYY

Created Date

DATE(10)

Format MM/DD/YYYY

 

MONTHLY FILES

 

Custom Verdict File Structure (File Definition) 

File Name: VerdictTReuters_CCYYMM.txt

Run Frequency:  Monthly

Description:  Custom File

Sample File: Verdict_TReuters_CCYYMM.xls  

Field Description

Field Type

Description

Case Number

VARCHAR(30)

Local case number (ie. 2007-025360-CA -01)

Case Type Description

VARCHAR(100)

 

Case Verdict

VARCHAR(20)

 

Verdict Date

DATE

FORMAT CCYY-MM-DD

Verdict Amount

NUMBER

 

Plaintiff

VARCHAR(300)

 

Plaintiff Attorney

VARCHAR(300)

 

Defendant

VARCHAR(300)

 

Defendant Attorney

VARCHAR(300)

 

Action Code

VARCHAR(20)

 

Judge Section Number

VARCHAR(20)

 

Judge Name

VARCHAR(180)

 

Closing Docket

VARCHAR(20)

 

Closing Docket Date

DATE

FORMAT CCYY-MM-DD

 

Landlord and Tenant by Address File Structure (File Definition) 

File Name:  CivltntnCCYYMM.txt

Run Frequency:  Monthly

Description:  Eviction cases closed for the previous month by eviction address.

Sample File:  CIVLTNTNCCYYMM.xls 

Field Description

Field Type

Description

Case Number

VARCHAR(30)

Local case number (ie. 2007-025360-CA -01)

File Date

DATE(19)

Format CCYY-MM-DD 00:00:00

Stat Closure Code

VARCHAR(20)

 

Respondent

VARCHAR(300)

 

Property Address

VARCHAR(257)

 

Property City

VARCHAR(64)

City

Property State

CHAR(2)

State abbreviation

Property Zip

VARCHAR(10)

Zip Code

Petitioner

VARCHAR(300)

 

 

Landlord and Tenant By Party File Structure (File Definition) 

File Name:  CivltCCYYMM.txt

Run Frequency:  Monthly

Description:  Eviction cases for the previous month.  Lists each party in the case.

Sample File:  CIVLTCCYYMM.xls 

Field Description

Field Type

Description

Case Number

VARCHAR(30)

Local case number (ie. 2007-025360-CA -01)

Party Name

VARCHAR(300)

Party name (LName, FName MName)

Party Code

VARCHAR(20)

Party type code (ie. PN = Plaintiff, DN = Defendant, LT = the address of the property)

Style

VARCHAR(5000)

Style of the case (ie. Ramos Raul vs. Hugh Grant)

File Date

DATE(8)

Format CCYYMMDD

Party Disposition Date

DATE(8)

Format CCYYMMDD

Party Address Line 1

VARCHAR(64)

Address line 1

Party Address Line 2

VARCHAR(64)

Address line 2

Party Address Line 3

VARCHAR(129)

Address line 3

Party City

VARCHAR(64)

City

Party Street

CHAR(2)

State abbreviation

Party Zip

VARCHAR(10)

Zip Code

 

Verdict File Structure (File Definition) 

File Name:  Verdict_CCYYMM.txt

Run Frequency:  Monthly

Description:  Any civil court jury trials completed during the previous month.

Sample File:  VerdictCCYYMM.xls 

Field Description

Field Type

Description

Case Number

VARCHAR(30)

Local case number (ie. 2007-025360-CA -01)

Case Type Description

VARCHAR(100)

 

Case Verdict

VARCHAR(20)

 

Verdict Date

DATE

FORMAT CCYY-MM-DD

Verdict Amount

NUMBER

 

Plaintiff

VARCHAR(300)

 

Plaintiff Attorney

VARCHAR(300)

 

Defendant

VARCHAR(300)

 

Defendant Attorney

VARCHAR(300)

 

Action Code

VARCHAR(20)

 

Judge Section Number

VARCHAR(20)

 

Judge Name

VARCHAR(180)

 

Closing Docket

VARCHAR(20)

 

Closing Docket Date

DATE

FORMAT CCYY-MM-DD

 

WEEKLY FILES

 

Contract & Indebtedness File Structure (File Definition) 

File Name:  Indebtedness_CCYYMMDD.txt

Run Frequency:  Weekly

Description:  Contains contract indebtedness cases updated during the previous week.

Sample File: IndebtednessCCYYMMDD.xls

Field Description

Field Type

Description

Case Number

VARCHAR(30)

Local case number (ie. 2007-025360-CA -01)

Case Type

VARCHAR(20)

Case type user code (ie. DOM)

Judge Section

VARCHAR(20)

 

File Date

DATE

Format CCYY-MM-DD

Plaintiff Name

VARCHAR(300)

 

Defendant Name

VARCHAR(300)

 

Case Status

VARCHAR(20)

 

Dispo Date

DATE

FORMAT CCYY-MM-DD

Dispo Code

VARCHAR(20)

 

Dispo Description

TEXT

 

New Sp Date

DATE

FORMAT CCYY-MM-DD

SPPT Date

DATE

FORMAT CCYY-MM-DD

SPPN Date

DATE

FORMAT CCYY-MM-DD

SVRT Code

VARCHAR(20)

 

SVRT Date

DATE

FORMAT CCYY-MM-DD

SMRN Date

DATE

FORMAT CCYY-MM-DD

DFLT Date

DATE

FORMAT CCYY-MM-DD

DJUD Date

DATE

FORMAT CCYY-MM-DD

MDFT Date

DATE

FORMAT CCYY-MM-DD

MDDT Date

DATE

FORMAT CCYY-MM-DD

Answer Code

VARCHAR(20)

 

Answer Date

DATE

FORMAT CCYY-MM-DD

MCAR Date

DATE

FORMAT CCYY-MM-DD

FWNG Date

DATE

FORMAT CCYY-MM-DD

FWND Date

DATE

FORMAT CCYY-MM-DD

NSCA Date

DATE

FORMAT CCYY-MM-DD

VOLD Date

DATE

FORMAT CCYY-MM-DD

FJUD Date

DATE

FORMAT CCYY-MM-DD

FJDF Date

DATE

FORMAT CCYY-MM-DD

Pn Atty Name

VARCHAR(300)

 

Claim Amount

NUMBER

 

Dn Street

VARCHAR(256)

 

Dn City

VARCHAR(64)

 

Dn State

CHAR(2)

 

Dn Zip

VARCHAR(10)

 

Next Hrg Date

DATE(10)

FORMAT CCYY-MM-DD