r_elect_agreement
32,708 rows
Suggested facets: action_sequence, election_agreement_type, date_approved (date)
| r_case_number | unit_id | action_sequence | date_approved | election_agreement_type |
|---|---|---|---|---|
| 01-RC-19926 | A | 0 | 1993-05-06 | Stipulated Election Agreement Stip |
| 01-RC-20292 | A | 0 | 1995-05-02 | Stipulated Election Agreement Stip |
| 01-RC-20467 | A | 0 | 1996-06-14 | Stipulated Election Agreement Stip |
| 01-RC-20626 | A | 0 | 1997-06-24 | Stipulated Election Agreement Stip |
| 01-RC-20634 | A | 0 | 1997-06-30 | Stipulated Election Agreement Stip |
| 01-RC-20649 | A | 0 | 1997-07-30 | Stipulated Election Agreement Stip |
| 01-RC-20761 | A | 0 | 1998-03-19 | Stipulated Election Agreement Stip |
| 01-RC-20815 | A | 0 | 2001-01-10 | Stipulated Election Agreement Stip |
| 01-RC-20890 | A | 0 | 1998-09-18 | Stipulated Election Agreement Stip |
| 01-RC-20897 | A | 0 | 1998-10-06 | Stipulated Election Agreement Stip |
| 01-RC-20906 | A | 0 | 1998-10-23 | Stipulated Election Agreement Stip |
| 01-RC-20910 | A | 0 | 1998-10-30 | Stipulated Election Agreement Stip |
| 01-RC-20912 | A | 0 | 1998-10-28 | Stipulated Election Agreement Stip |
| 01-RC-20922 | A | 0 | 1998-11-10 | Stipulated Election Agreement Stip |
| 01-RC-20923 | A | 0 | 1998-11-10 | Stipulated Election Agreement Stip |
| 01-RC-20936 | A | 0 | 1998-12-07 | Stipulated Election Agreement Stip |
| 01-RC-20937 | A | 0 | 1998-12-10 | Stipulated Election Agreement Stip |
| 01-RC-20938 | A | 0 | 1998-12-10 | Stipulated Election Agreement Stip |
| 01-RC-20941 | A | 0 | 1998-12-17 | Stipulated Election Agreement Stip |
| 01-RC-20942 | A | 0 | 1998-12-11 | Stipulated Election Agreement Stip |
| 01-RC-20944 | A | 0 | 1998-12-22 | Stipulated Election Agreement Stip |
| 01-RC-20946 | A | 0 | 1998-12-23 | Stipulated Election Agreement Stip |
| 01-RC-20949 | A | 0 | 1999-01-28 | Stipulated Election Agreement Stip |
| 01-RC-20950 | A | 0 | 1999-01-13 | Stipulated Election Agreement Stip |
| 01-RC-20952 | A | 0 | 1998-12-24 | Stipulated Election Agreement Stip |
| 01-RC-20953 | A | 0 | 1999-01-05 | Stipulated Election Agreement Stip |
| 01-RC-20955 | A | 0 | 1999-01-04 | Stipulated Election Agreement Stip |
| 01-RC-20956 | A | 0 | 1998-12-30 | Stipulated Election Agreement Stip |
| 01-RC-20959 | A | 0 | 1999-01-08 | Stipulated Election Agreement Stip |
| 01-RC-20964 | A | 0 | 1999-02-04 | Stipulated Election Agreement Stip |
| 01-RC-20966 | A | 0 | 1999-02-18 | Stipulated Election Agreement Stip |
| 01-RC-20972 | A | 0 | 1999-02-26 | Stipulated Election Agreement Stip |
| 01-RC-20973 | A | 0 | 1999-02-18 | Stipulated Election Agreement Stip |
| 01-RC-20974 | A | 0 | 1999-03-01 | Stipulated Election Agreement Stip |
| 01-RC-20976 | A | 0 | 1999-03-05 | Stipulated Election Agreement Stip |
| 01-RC-20977 | A | 0 | 1999-03-08 | Stipulated Election Agreement Stip |
| 01-RC-20978 | A | 0 | 1999-03-11 | Stipulated Election Agreement Stip |
| 01-RC-20979 | A | 0 | 1999-03-09 | Stipulated Election Agreement Stip |
| 01-RC-20980 | A | 0 | 1999-03-10 | Stipulated Election Agreement Stip |
| 01-RC-20981 | A | 0 | 1999-03-23 | Stipulated Election Agreement Stip |
| 01-RC-20982 | A | 0 | 1999-03-12 | Stipulated Election Agreement Stip |
| 01-RC-20986 | A | 0 | 1999-03-25 | Stipulated Election Agreement Stip |
| 01-RC-20987 | A | 0 | 1999-03-25 | Stipulated Election Agreement Stip |
| 01-RC-20988 | A | 0 | 1999-03-31 | Stipulated Election Agreement Stip |
| 01-RC-20989 | A | 0 | 1999-04-08 | Stipulated Election Agreement Stip |
| 01-RC-20991 | A | 0 | 1999-04-05 | Stipulated Election Agreement Stip |
| 01-RC-20992 | A | 0 | 1999-04-07 | Stipulated Election Agreement Stip |
| 01-RC-20993 | A | 0 | 1999-04-12 | Stipulated Election Agreement Stip |
| 01-RC-20994 | A | 0 | 1999-04-15 | Stipulated Election Agreement Stip |
| 01-RC-20997 | A | 0 | 1999-04-14 | Stipulated Election Agreement Stip |
| 01-RC-20998 | A | 0 | 1999-04-09 | Stipulated Election Agreement Stip |
| 01-RC-21001 | A | 0 | 1999-05-03 | Stipulated Election Agreement Stip |
| 01-RC-21002 | A | 0 | 1999-04-28 | Stipulated Election Agreement Stip |
| 01-RC-21003 | A | 0 | 1999-04-30 | Stipulated Election Agreement Stip |
| 01-RC-21004 | A | 0 | 1999-04-28 | Stipulated Election Agreement Stip |
| 01-RC-21007 | A | 0 | 1999-04-30 | Stipulated Election Agreement Stip |
| 01-RC-21008 | A | 0 | 1999-05-03 | Stipulated Election Agreement Stip |
| 01-RC-21010 | A | 0 | 1999-05-12 | Stipulated Election Agreement Stip |
| 01-RC-21013 | A | 0 | 1999-05-21 | Stipulated Election Agreement Stip |
| 01-RC-21015 | A | 0 | 1999-05-19 | Stipulated Election Agreement Stip |
| 01-RC-21016 | A | 0 | 1999-05-24 | Stipulated Election Agreement Stip |
| 01-RC-21017 | A | 0 | 1999-05-26 | Stipulated Election Agreement Stip |
| 01-RC-21018 | A | 0 | 1998-06-03 | Stipulated Election Agreement Stip |
| 01-RC-21019 | A | 0 | 1999-05-27 | Stipulated Election Agreement Stip |
| 01-RC-21020 | A | 0 | 1999-06-29 | Stipulated Election Agreement Stip |
| 01-RC-21021 | A | 0 | 1999-06-03 | Stipulated Election Agreement Stip |
| 01-RC-21022 | A | 0 | 1999-06-04 | Stipulated Election Agreement Stip |
| 01-RC-21023 | A | 0 | 1999-06-08 | Stipulated Election Agreement Stip |
| 01-RC-21024 | A | 0 | 1999-06-17 | Stipulated Election Agreement Stip |
| 01-RC-21027 | A | 0 | 1999-06-16 | Stipulated Election Agreement Stip |
| 01-RC-21028 | A | 0 | 1999-06-17 | Stipulated Election Agreement Stip |
| 01-RC-21029 | A | 0 | 1999-08-03 | Stipulated Election Agreement Stip |
| 01-RC-21030 | A | 0 | 1999-06-23 | Stipulated Election Agreement Stip |
| 01-RC-21031 | A | 0 | 1999-06-22 | Stipulated Election Agreement Stip |
| 01-RC-21032 | A | 0 | 1999-06-28 | Stipulated Election Agreement Stip |
| 01-RC-21033 | A | 0 | 1999-06-28 | Stipulated Election Agreement Stip |
| 01-RC-21034 | A | 0 | 1999-07-01 | Stipulated Election Agreement Stip |
| 01-RC-21035 | A | 0 | 1999-06-30 | Stipulated Election Agreement Stip |
| 01-RC-21036 | A | 0 | 1999-07-07 | Stipulated Election Agreement Stip |
| 01-RC-21038 | A | 0 | 1999-07-20 | Stipulated Election Agreement Stip |
| 01-RC-21039 | A | 0 | 1999-07-21 | Stipulated Election Agreement Stip |
| 01-RC-21040 | A | 0 | 1999-08-02 | Stipulated Election Agreement Stip |
| 01-RC-21043 | A | 0 | 1999-08-09 | Stipulated Election Agreement Stip |
| 01-RC-21044 | A | 0 | 1999-09-09 | Stipulated Election Agreement Stip |
| 01-RC-21045 | A | 0 | 1999-08-10 | Stipulated Election Agreement Stip |
| 01-RC-21046 | A | 0 | 1999-08-12 | Stipulated Election Agreement Stip |
| 01-RC-21047 | A | 0 | 1999-08-24 | Stipulated Election Agreement Stip |
| 01-RC-21048 | A | 0 | 1999-08-13 | Stipulated Election Agreement Stip |
| 01-RC-21050 | A | 0 | 1999-08-18 | Stipulated Election Agreement Stip |
| 01-RC-21051 | A | 0 | 1999-08-24 | Stipulated Election Agreement Stip |
| 01-RC-21052 | A | 0 | 1999-08-24 | Stipulated Election Agreement Stip |
| 01-RC-21053 | A | 0 | 1999-08-24 | Stipulated Election Agreement Stip |
| 01-RC-21055 | A | 0 | 1999-08-24 | Stipulated Election Agreement Stip |
| 01-RC-21056 | A | 0 | 1999-08-25 | Stipulated Election Agreement Stip |
| 01-RC-21057 | A | 0 | 1999-08-31 | Stipulated Election Agreement Stip |
| 01-RC-21058 | A | 0 | 1999-09-03 | Stipulated Election Agreement Stip |
| 01-RC-21059 | A | 0 | 1999-08-31 | Stipulated Election Agreement Stip |
| 01-RC-21060 | A | 0 | 1999-09-02 | Stipulated Election Agreement Stip |
| 01-RC-21061 | A | 0 | 1999-08-26 | Stipulated Election Agreement Stip |
| 01-RC-21064 | A | 0 | 1999-10-14 | Stipulated Election Agreement Stip |
Table schema
CREATE TABLE r_elect_agreement(r_case_number VARCHAR, unit_id VARCHAR, action_sequence BIGINT, date_approved DATE, election_agreement_type VARCHAR, FOREIGN KEY (election_agreement_type) REFERENCES l_r_elect_agree_type(election_agreement_type));