Case Data File Layouts:

 

Files are provided in comma separated format.

If Conviction code fields are populated, defendant was convicted of a different offense than what was originally charged.

For criminal cases you may want to download the Event Codes and Descriptions Table file.

 

Criminal case event code table

Field

Data Type

Event Number

Dec(3,0)

Event Description

Char(35)

Court Usage

Char(1)

Court usage ‘C’ = County Courts, ‘D’ = District Courts, ‘B’ = Both Courts

 

Civil Case Data

Field

Data Type

Description

Court

Dec (3,0)

The court assigned when the case was created.

Cause

Char (5)

Cause number (right adjusted.  Zero filled for dck cases, blank filled for cck cases)

Year

Dec (2,0)

The year the case was created.

Curcrt

Dec (3,0)

The court currently hearing the case

Nature

Char(3)

Type of case

FileDate

Dec(8,0) ISO

Date the case was filed

DispDate

DEC(8,0) ISO

Date the case was disposed

DispCode

Char(3)

Disposition coded

DispDesc

Char(50)

Description of the Disposition Code

 

Civil Plaintiff Data

Court

Dec (3,0)

The court assigned when the case was created.(pk1)

Cause

Char (5)

Cause number (right adjusted.  Zero filled for dck cases, blank filled for cck cases) (PK2)

Year

Dec (2,0)

The year the case was created.(PK3)

PtyType

Char(2)

‘PL’ – Plaintiff

PtySeq

Dec(3,0)

Platintiff sequence number

Last Name

Char(15)

Last Name

First Name

Char(12)

First Name

Mid init

Char(1)

Middle Initial

Address1

Char(25)

Address Line 1

Address2

Char(25)

Address Line 2

City

Char(15)

City

State

Char(2)

State

Zip5

Char(5)

Zip Code

Zip4

Char(4)

+4

Afirstname

Char(20)

Party’s attorney First Name

Amid init

Char(1)

Party’s attorney Middle Initial

Alastname

Char(35)

Party’s attorney Last Name

Asuffix

Char(8)

Party’s attorney Suffix (Sr, Jr, etc…)

Aphone

Dec(10,0)

Party’s attorney phone number

 

Civil Defendant Data

Court

Dec (3,0)

The court assigned when the case was created.(pk1)

Cause

Char (5)

Cause number (right adjusted.  Zero filled for dck cases, blank filled for cck cases) (PK2)

Year

Dec (2,0)

The year the case was created.(PK3)

PtyType

Char(2)

‘DE’ – Defendant

PtySeq

Dec(3,0)

Defendant sequence number

Last Name

Char(15)

Last Name

First Name

Char(12)

First Name

Mid init

Char(1)

Middle Initial

Address1

Char(25)

Address Line 1

Address2

Char(25)

Address Line 2

City

Char(15)

City

State

Char(2)

State

Zip5

Char(5)

Zip Code

Zip4

Char(4)

+4

Afirstname

Char(20)

Party’s attorney First Name

Amid init

Char(1)

Party’s attorney Middle Initial

Alastname

Char(35)

Party’s attorney Last Name

Asuffix

Char(8)

Party’s attorney Suffix (Sr, Jr, etc…)

Aphone

Dec(10,0)

Party’s attorney phone number

 

Civil Actions of the Court Data

Case Number

Char(10)

Aggregate court + cause + year. (PK)

Entrydate

Dec (8,0) ISO

Date entered by clerk

Roadate

Dec (8,0) ISO

Date the event is scheduled or occurred

Roatime

Dec(4,0) (HHMM)

Time the event is scheduled for

Eventid

Dec(5,0)

Event sequence number

Roatext

Char(40)

Description of the event

 

Criminal Case Data

Case Number

Char(10)

Case Number (court + cause + year)

CurCrt

Dec(3,0)

Court currently hearing the case

Issagy

Char(25)

Issuing agency

Incsev

Char(1)

Incident severity

IncLev

Char(1)

Incident level

IncDate

Dec(8,0) ISO

Date Incident occured

ChargeCode

Char(9)

Charge Code

ChargeDes

Char(50)

Description for charge code

FileDate

Dec(8,0) ISO

Date case was filed

DispDate

Dec(8,0) ISO

Date case was disposed

Plea

Char(2)

Plea entered for case

Fnding

Char(2)

Courts finding in the case

Jurvdt

Char(3)

Jury verdict? (Yes or No) (abandoned after 1991)

JurPun

Char(3)

Jury Punishment (Yes or No) (abandoned after 1991)

CasTyp

Char(8)

Type of case

Dispcode

Dec(3,0)

Disposition code

DispDes

Char(35)

Disposition code description

Appdat

Dec(8,0) ISO

Appeal Date

Unappr

Char(1)

Un-apprehended (Y or N)

OffModifier

Char(1)

Offense Modifier Code

ConvCod

Char(9)

Charge at conviction if different from Charge Code

ConvDesc

Char(50)

Description for conviction charge Code

ConvSev

Char(1)

Conviction Severity for conviction charge code

ConvLevel

Char(1)

Conviction Level for conviction charge code

ConvModifier

Char(1)

Offense Modifier Code for Conviction Charge

Warrant Type

Char(50)

Type of Warrant issued on case

 

Criminal Defendant Data

Casenumber

Char(10)

Case Number (PK)

Defname

Char(30)

Defendants full name

Race

Char(1)

Race

Sex

Char(1)

Sex

Height

Dec(3,0)

Height

Weight

Dec(3,0)

Weight

Hair

Char(3)

Hair Color

Eyes

Char(3)

Eye Color

dob

Dec(6,0) YMD

Date of birth

Address1

Char(25)

Address Line 1

Address2

Char(25)

Address Line 2

City

Char(15)

City

State

Char(2)

State

Zip5

Char(5)

Zip Code

Zip4

Char(4)

+4

Afirstname

Char(20)

Party’s attorney First Name

Amid init

Char(1)

Party’s attorney Middle Initial

Alastname

Char(35)

Party’s attorney Last Name

Asuffix

Char(8)

Party’s attorney Suffix (Sr, Jr, etc…)

Aphone

Dec(10,0)

Party’s attorney phone number

 

Criminal Actions of the Court Data

Case Number

Char(10)