Law Commons^™

Cchlp: Original Public Interface, Eastern Illinois University Department Of History

Coles County Legal History

The Coles County Legal History Project (CCLHP) was began as a grant-supported project in 1999. The database covers civil and criminal cases from 1830 to 1906. The records were originally in a postgres database with a two tables. The public interface was written in Perl. The interface and data were served by Solaris hardware. The Cases table contains 1602 records, the Parties table contains 4487 records. The Solaris system was retired in 2009 and the database was transferred to Booth Library.

Cclhp: Data As Microsoft Access File, Newton Key, Chris Waldrep, Michael Kroll, Mark Voss-Hubbard

Coles County Legal History

Table Cases Fields:

Case_Number

Incident_Date

File_Date

Settlement_Date

Location

Case_Type

Dollar_Amount

Issue

Outcome

Ancillary_Catters

Memo

Transcribed

Additional_Info

Marked

Last_Modified

Table Parties

Record_Number

Case_Number

L_Name

F_Name

Sex

Occupation

Literate

Location

Additional_Info

Marked

Modified_Date

Queries

Cclhp: Case Types As Csv, Newton Key, Mark Voss-Hubbard, Michael Kroll, Chris Waldrep

Coles County Legal History

Single column, controlled vocabulary for case types

Cclhp: Cases As Csv, Newton Key, Mark Voss-Hubbard, Chris Waldrep, Michael Kroll

Coles County Legal History

Fields included: case_number Incident Date File Date Settlement Date Location Case Type Dollar Amount Issue Outcome Ancillary Matters Memo Transcribed Additional Information Marked Last Modified

Cclhp: Parties As Csv, Newton Key, Mark Voss-Hubbard, Michael Kroll, Chris Waldrep

Coles County Legal History

Fields included: Record Number case_number Actor (P D W or J) Last Name First Name Sex Occupation Literate Location Additional Information Marked Last Modified