Regional _ Reporters Table
Journal on Policy and Complex Systems
The courts of last resort have been divided into seven groups based on U . S . geographic region . Each region has its own reporter that includes all the published cases of the region ’ s courts . This table has the data for the seven regions . As publishing decisions online became more readily available , cases in more recent decades may include published or unpublished decisions , with unpublished decisions that hold no precedential authority in future cases .
Column name Data type Description
rr _ abbreviation |
Text |
Primary key of the table . |
|
|
The abbreviation of the region name . |
rr _ name Text The name of the region .
Regional _ Reporters _ Volumes Table
This table has the data of each volume that has been published in each region .
Column name Data type Description
rr _ volume _ abbreviation
Text Part of the table composite primary key . The number and abbreviation of each volume .
rr _ abbreviation |
Text |
Part of the table composite primary key . Foreign key from the table “ Regional _ Reporters ” to connect the volume with the region . The abbreviation of the region . |
rr _ volume _ start _ date Date The start date of the volume . rr _ volume _ end _ date Date The end date of the volume .
States Table
This table has the states ’ data . Each state has one court except the state of Colorado and Texas that has two courts , one for the criminal cases and one for other types of cases . Each state is described in this table with three columns .
Column name Data type Description
postal _ state _ abbreviation |
Text |
Primary key of the table . |
|
|
The abbreviation of the State . |
state _ name Text The name of the state
fips _ code |
Text |
The Federal Information Processing Standard state |
|
|
code |
rr _ abbreviation |
Text |
Foreign key from the table “ Regional _ Reporters ” to |
|
|
connect the state with the region . |
|
|
The abbreviation of the region |
78