r_post_elect_rd_act
4,745 rows
Suggested facets: unit_id, action_sequence, recurrence, brief_party, eot_request_date, eot_party, eot_determination_date, eot_determination, ho_report_directed, brief_due (date), brief_filed (date), eot_request_date (date), eot_determination_date (date), action_date (date), review_due_date (date), date_ho_report (date), exceptions_due_date (date)
| r_case_number | unit_id | election_id | action_sequence | recurrence | brief_due | brief_filed | brief_party | eot_request_date | eot_party | eot_determination_date | eot_determination | action_date | rd_action_type | rd_action_determination | review_due_date | date_ho_report | ho_report_directed | exceptions_due_date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01-RC-20467 | A | 01-00001 | 0 | 0 | 1996-09-09 | 10006 | 24 | |||||||||||
| 01-RC-20761 | A | 01-00357 | 0 | 0 | 2001-03-01 | 10011 | 68 | 2001-03-15 | ||||||||||
| 01-RC-20804 | A | 01-00012 | 0 | 0 | 1998-08-21 | Board | ||||||||||||
| 01-RC-20815 | A | 01-00359 | 0 | 0 | 2001-03-01 | 10005 | 22 | 2001-03-15 | ||||||||||
| 01-RC-20890 | A | 01-00081 | 0 | 0 | 1998-12-02 | 10018 | 80 | 1998-12-16 | ||||||||||
| 01-RC-20897 | A | 01-00048 | 0 | 0 | 1999-03-19 | 10001 | 3 | 1999-04-02 | ||||||||||
| 01-RC-20905 | A | 01-00026 | 0 | 0 | 1998-12-30 | 10004 | 17 | 1999-01-13 | ||||||||||
| 01-RC-20906 | A | 01-00148 | 0 | 0 | 1998-12-22 | 10005 | 22 | 1999-01-05 | ||||||||||
| 01-RC-20923 | A | 01-00034 | 0 | 0 | 1999-02-24 | RD | ||||||||||||
| 01-RC-20966 | A | 01-00143 | 0 | 0 | 1999-08-05 | 10017 | 79 | 1999-08-19 | ||||||||||
| 01-RC-20979 | A | 01-00071 | 0 | 0 | 1999-05-05 | 10003 | 12 | 1999-05-19 | ||||||||||
| 01-RC-20983 | A | 01-00096 | 0 | 0 | 1999-05-07 | 10011 | 68 | 1999-05-21 | ||||||||||
| 01-RC-20984 | A | 01-00285 | 0 | 0 | 2000-07-26 | 10011 | 68 | 2000-08-09 | ||||||||||
| 01-RC-20986 | A | 01-00099 | 0 | 0 | 1999-06-10 | 10005 | 22 | |||||||||||
| 01-RC-21013 | A | 01-00117 | 0 | 0 | 1999-06-25 | 10001 | 3 | 1999-07-09 | ||||||||||
| 01-RC-21023 | A | 01-00124 | 0 | 0 | 1999-11-05 | 1999-07-22 | 10005 | 22 | 1999-11-15 | RD | ||||||||
| 01-RC-21073 | A | 01-00180 | 0 | 0 | 1999-11-16 | 10004 | 16 | 1999-11-30 | ||||||||||
| 01-RC-21085 | A | 01-00190 | 0 | 0 | 1999-11-15 | 10004 | 16 | 1999-11-29 | 2000-01-06 | RD | ||||||||
| 01-RC-21085 | B | 01-00190 | 0 | 0 | 1999-11-15 | 10004 | 16 | 1999-11-29 | 2000-01-06 | RD | ||||||||
| 01-RC-21085 | B | 01-00190 | 1 | 0 | 2000-01-06 | RD | ||||||||||||
| 01-RC-21086 | A | 01-00191 | 0 | 0 | 1999-11-15 | 10004 | 16 | 1999-11-29 | 2000-01-06 | RD | ||||||||
| 01-RC-21086 | B | 01-00191 | 0 | 0 | 1999-11-15 | 10004 | 16 | 1999-11-29 | 2000-01-06 | RD | ||||||||
| 01-RC-21086 | B | 01-00191 | 1 | 0 | 2000-01-06 | RD | ||||||||||||
| 01-RC-21090 | A | 01-00201 | 0 | 0 | 1999-12-16 | 10005 | 22 | 1999-12-30 | ||||||||||
| 01-RC-21106 | B | 01-00222 | 0 | 0 | 2000-01-31 | 10016 | 73 | |||||||||||
| 01-RC-21116 | A | 01-00225 | 0 | 0 | 2000-05-16 | 2000-05-16 | PET | 2000-05-23 | Board | |||||||||
| 01-RC-21122 | A | 01-00237 | 0 | 0 | 2000-03-14 | 10016 | 72 | 2000-03-28 | ||||||||||
| 01-RC-21133 | A | 01-00238 | 0 | 0 | 2000-03-24 | 10001 | 3 | 2000-04-07 | ||||||||||
| 01-RC-21134 | A | 01-00231 | 0 | 0 | 2000-02-17 | 10016 | 72 | 2000-03-02 | ||||||||||
| 01-RC-21138 | A | 01-00247 | 0 | 0 | 2000-03-30 | 10001 | 3 | 2000-04-13 | ||||||||||
| 01-RC-21143 | A | 01-00248 | 0 | 0 | 2000-04-27 | 10005 | 22 | 2000-05-11 | ||||||||||
| 01-RC-21146 | A | 01-00255 | 0 | 0 | 2000-08-11 | 10006 | 24 | |||||||||||
| 01-RC-21149 | A | 01-00257 | 0 | 0 | 2000-04-26 | 10005 | 23 | 2000-05-10 | ||||||||||
| 01-RC-21152 | A | 01-00263 | 0 | 0 | 2000-07-10 | 2000-07-13 | EMP | 2000-08-14 | Board | 2000-08-28 | ||||||||
| 01-RC-21152 | A | 01-00263 | 0 | 1 | 2000-07-13 | UNIN | ||||||||||||
| 01-RC-21158 | A | 01-00388 | 0 | 0 | 2001-10-24 | 10004 | 17 | 2001-11-07 | ||||||||||
| 01-RC-21159 | A | 01-00266 | 0 | 0 | 2000-06-22 | 2000-06-22 | EMP | 2000-07-25 | Board | |||||||||
| 01-RC-21194 | A | 01-00287 | 0 | 0 | 2000-09-15 | Board | ||||||||||||
| 01-RC-21198 | A | 01-00290 | 0 | 0 | 2000-12-12 | 10006 | 25 | |||||||||||
| 01-RC-21200 | A | 01-00331 | 0 | 0 | 2000-11-22 | 10005 | 22 | 2000-12-06 | ||||||||||
| 01-RC-21210 | A | 01-00303 | 0 | 0 | 2000-10-11 | 2000-10-11 | EMP | 2000-09-21 | 10006 | 24 | 2000-10-26 | Board | ||||||
| 01-RC-21216 | A | 01-00305 | 0 | 0 | 2000-09-28 | 10005 | 22 | 2000-10-12 | ||||||||||
| 01-RC-21227 | A | 01-00313 | 0 | 0 | 2001-04-05 | 10001 | 2 | 2001-04-19 | ||||||||||
| 01-RC-21238 | A | 01-00316 | 0 | 0 | 2000-11-20 | 10015 | 46 | |||||||||||
| 01-RC-21242 | A | 01-00322 | 0 | 0 | 2001-01-17 | Board | ||||||||||||
| 01-RC-21255 | A | 01-00323 | 0 | 0 | 2000-11-01 | 10018 | 80 | |||||||||||
| 01-RC-21257 | A | 01-00326 | 0 | 0 | 2000-11-14 | 10013 | 28 | |||||||||||
| 01-RC-21266 | A | 01-00336 | 0 | 0 | 2000-12-21 | 2000-12-21 | EMP | 2000-12-01 | 10002 | 4 | 2001-01-09 | Board | ||||||
| 01-RC-21279 | A | 01-00355 | 0 | 0 | 2001-01-30 | 10013 | 28 | |||||||||||
| 01-RC-21288 | A | 01-00356 | 0 | 0 | 2001-03-21 | 2001-03-21 | EMP | 2001-03-29 | Board | |||||||||
| 01-RC-21288 | A | 01-00356 | 0 | 1 | 2001-03-21 | PET | ||||||||||||
| 01-RC-21313 | A | 01-00392 | 0 | 0 | 2001-05-23 | 10005 | 22 | 2001-06-06 | ||||||||||
| 01-RC-21335 | A | 01-00398 | 0 | 0 | 2001-06-21 | 2001-06-21 | EMP | 2001-07-26 | Board | |||||||||
| 01-RC-21335 | A | 01-00398 | 0 | 1 | 2001-06-21 | PET | ||||||||||||
| 01-RC-21365 | A | 01-00410 | 0 | 0 | 2001-10-25 | 10005 | 22 | 2001-11-08 | ||||||||||
| 01-RC-21376 | A | 01-00423 | 0 | 0 | 2002-01-22 | 2002-01-22 | EMP | 2001-12-21 | 10006 | 25 | 2002-01-04 | 2002-03-14 | Board | 2002-03-28 | ||||
| 01-RC-21376 | A | 01-00423 | 0 | 1 | 2002-01-22 | PET | ||||||||||||
| 01-RC-21388 | A | 01-00429 | 0 | 0 | 2001-09-27 | 10005 | 22 | 2001-10-11 | ||||||||||
| 01-RC-21403 | A | 01-00438 | 0 | 0 | 2001-11-21 | 2001-11-21 | EMP | 2001-12-05 | Board | 2001-12-19 | ||||||||
| 01-RC-21403 | A | 01-00438 | 0 | 1 | 2001-11-21 | PET | ||||||||||||
| 01-RC-21405 | A | 01-00439 | 0 | 0 | 2001-10-18 | EMP | 2001-10-23 | Board | ||||||||||
| 01-RC-21405 | A | 01-00439 | 0 | 1 | 2001-10-18 | PET | ||||||||||||
| 01-RC-21417 | A | 01-00450 | 0 | 0 | 2002-12-21 | 2002-12-21 | EMP | 2002-01-04 | 10003 | 13 | 2002-01-18 | 2003-01-08 | Board | 2003-01-22 | ||||
| 01-RC-21464 | A | 01-00506 | 0 | 0 | 2002-10-21 | 2002-10-23 | EMP | 2002-12-11 | Board | 2002-12-25 | ||||||||
| 01-RC-21480 | A | 01-00502 | 0 | 0 | 2002-05-02 | 10013 | 26 | 2002-05-16 | ||||||||||
| 01-RC-21484 | A | 01-00503 | 0 | 0 | 2002-05-17 | 10005 | 22 | 2002-05-31 | ||||||||||
| 01-RC-21510 | A | 01-00521 | 0 | 0 | 2002-08-15 | 10005 | 22 | 2002-08-29 | ||||||||||
| 01-RC-21523 | A | 01-00535 | 0 | 0 | 2002-11-07 | 2002-11-12 | INT | 2002-11-13 | Board | 2002-11-27 | ||||||||
| 01-RC-21548 | A | 01-00553 | 0 | 0 | 2002-12-11 | 10011 | 69 | 2002-12-26 | ||||||||||
| 01-RC-21553 | A | 01-00552 | 0 | 0 | 2002-12-05 | 10003 | 8 | 2002-12-19 | ||||||||||
| 01-RC-21557 | A | 01-00557 | 0 | 0 | 2003-01-03 | 2003-01-06 | EMP | 2003-02-14 | Board | 2003-02-28 | ||||||||
| 01-RC-21557 | A | 01-00557 | 0 | 1 | 2003-01-06 | PET | ||||||||||||
| 01-RC-21558 | A | 01-00555 | 0 | 0 | 2002-11-26 | 10001 | 3 | 2002-12-10 | ||||||||||
| 01-RC-21561 | A | 01-00556 | 0 | 0 | 2002-12-20 | 2002-12-20 | PET | 2003-01-03 | Board | 2003-01-17 | ||||||||
| 01-RC-21572 | A | 01-00570 | 0 | 0 | 2003-04-15 | 2003-04-15 | EMP | 2003-05-28 | Board | 2003-06-11 | ||||||||
| 01-RC-21572 | A | 01-00570 | 0 | 1 | 2003-04-15 | PET | ||||||||||||
| 01-RC-21579 | A | 01-00574 | 0 | 0 | 2003-03-24 | 2003-03-20 | PET | 2003-04-01 | Board | 2003-04-15 | ||||||||
| 01-RC-21579 | A | 01-00574 | 0 | 1 | 2003-03-24 | EMP | ||||||||||||
| 01-RC-21601 | A | 01-00589 | 0 | 0 | 2003-05-20 | 2003-05-20 | EMP | 2003-03-10 | 10001 | 1 | 2003-03-24 | 2003-06-09 | Board | 2003-06-23 | ||||
| 01-RC-21601 | A | 01-00589 | 0 | 1 | 2003-05-20 | PET | ||||||||||||
| 01-RC-21646 | A | 01-00640 | 0 | 0 | 2003-08-14 | 10009 | 65 | 2003-08-28 | ||||||||||
| 01-RC-21649 | A | 01-00674 | 0 | 0 | 2004-01-07 | 2004-01-07 | PET | 2004-01-27 | Board | 2004-02-10 | ||||||||
| 01-RC-21649 | A | 01-00674 | 0 | 1 | 2004-01-07 | INT | ||||||||||||
| 01-RC-21660 | A | 01-00646 | 0 | 0 | 2003-10-08 | 2003-10-15 | EMP | 2003-10-30 | RD | 2003-11-13 | ||||||||
| 01-RC-21660 | A | 01-00646 | 0 | 1 | 2003-10-15 | PET | ||||||||||||
| 01-RC-21668 | A | 01-00660 | 0 | 0 | 2003-11-07 | 10018 | 81 | 2003-11-21 | ||||||||||
| 01-RC-21677 | A | 01-00668 | 0 | 0 | 2003-12-17 | 10005 | 22 | 2003-12-31 | ||||||||||
| 01-RC-21717 | A | 01-00703 | 0 | 0 | 2004-07-02 | 2004-07-02 | PET | 2004-04-26 | 10006 | 24 | 2004-05-10 | |||||||
| 01-RC-21717 | A | 01-00703 | 0 | 1 | 2004-07-02 | EMP | ||||||||||||
| 01-RC-21740 | A | 01-00717 | 0 | 0 | 2004-06-02 | 2004-06-29 | Board | 2004-07-13 | ||||||||||
| 01-RC-21749 | A | 01-00724 | 0 | 0 | 2004-05-27 | 10017 | 79 | 2004-06-10 | ||||||||||
| 01-RC-21749 | A | 01-00811 | 0 | 0 | 2005-03-09 | 2005-03-09 | EMP | 2005-02-24 | 10004 | 16 | 2005-03-10 | 2005-03-14 | Board | 2005-03-28 | ||||
| 01-RC-21749 | A | 01-00811 | 0 | 1 | 2005-03-11 | PET | ||||||||||||
| 01-RC-21754 | A | 01-00729 | 0 | 0 | 2004-06-10 | 2004-06-10 | PET | 2004-06-25 | RD | 2004-07-09 | ||||||||
| 01-RC-21759 | A | 01-00736 | 0 | 0 | 2004-06-24 | 10005 | 23 | 2004-07-08 | ||||||||||
| 01-RC-21759 | A | 01-00750 | 0 | 0 | 2004-10-08 | 2004-11-04 | Board | 2004-11-18 | ||||||||||
| 01-RC-21759 | A | 01-00750 | 0 | 1 | 2004-10-13 | |||||||||||||
| 01-RC-21779 | A | 01-00748 | 0 | 0 | 2004-10-07 | 10001 | 3 | 2004-10-21 | ||||||||||
| 01-RC-21801 | A | 01-00765 | 0 | 0 | 2004-10-14 | 2004-10-14 | EMP | 2004-11-04 | Board | 2004-11-18 | ||||||||
| 01-RC-21801 | A | 01-00765 | 0 | 1 | 2004-10-14 | PET |
Table schema
CREATE TABLE r_post_elect_rd_act(r_case_number VARCHAR, unit_id VARCHAR, election_id VARCHAR, action_sequence BIGINT, recurrence BIGINT, brief_due DATE, brief_filed DATE, brief_party VARCHAR, eot_request_date DATE, eot_party VARCHAR, eot_determination_date DATE, eot_determination VARCHAR, action_date DATE, rd_action_type BIGINT, rd_action_determination BIGINT, review_due_date DATE, date_ho_report DATE, ho_report_directed VARCHAR, exceptions_due_date DATE);