Automated Data Extraction to Evaluate Courts of Last Resort in the American States
Courts Table
This table has the courts ’ data .
Column name Data type Description
lexis _ court _ abbreviation |
Text |
Primary key of the table . |
|
|
The abbreviation of the Courts based on Lexis reporter |
court _ name Text The court name
court _ type |
Text |
The court types . It will be helpful when different courts |
|
|
types and level add to the database . In this current |
|
|
dataset all the courts type is States Supreme Courts . |
postal _ state _ abbreviation
Judges Table
Text
This table has the judges ’ names with their ids .
Column name Data type Description
judge _ code |
Text |
Primary key of the table . |
|
|
The judge id in the system . |
judge _ name Text The judge name
Foreign key from the table “ States ” to connect the courts to the states . The abbreviation of the State .
Courts _ Judges Table
Since the relationship between the Judges and the Courts Tables is many-to-many , this table serves as an associative table to connect those tables . This table shows the court that each judge has worked in and the judge service start date and end date . Recall that some judges worked in more than one session at the same court . That is why the relationship is many to many .
Column name Data type Description
judge _ code |
Number |
Primary key |
|
|
The generated judge code |
lexis _ court _ abbreviation |
Text |
Part of the table composite primary key The abbreviations of the courts Foreign key from the table “ Court ” to connect the court with the judges who worked in that court |
judge _ code |
Text |
Part of the table composite primary key The judge code Foreign key from the table “ Judge ” to connect the judge with the court data and show his / her work sessions |
judge _ start _ date Date The date of the first day the judge served in the court judge _ end _ date Date The date of the last day the judge served in the court
79