r_pre_elect_rd_decision
10,280 rows
Suggested facets: unit_id, recurrence, rd_decision_type, recon_request_party, rd_recon_deter, eot_filed_date (date), eot_deter_brief_date (date), pre_election_brief_rcvd (date), rd_decision_issued_date (date), recon_request_filed (date), rd_recon_deter_date (date), brief_due_date (date), review_due_date (date)
| r_case_number | unit_id | action_sequence | recurrence | determination_eot | eot_party | eot_filed_date | eot_deter_brief_date | brief_rcvd_party | pre_election_brief_rcvd | rd_decision_issued_date | rd_decision_type | recon_request_filed | recon_request_party | rd_recon_deter | rd_recon_deter_date | brief_due_date | review_due_date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01-AC-00094 | A | 0 | 0 | 2001-08-02 | DecOr | 2001-08-16 | |||||||||||
| 01-AC-00096 | A | 0 | 0 | 2002-06-12 | AmdCe | ||||||||||||
| 01-AC-00097 | A | 0 | 0 | 2003-11-05 | AmdCe | 2003-11-19 | |||||||||||
| 01-AC-00098 | A | 0 | 0 | 2007-09-06 | DecOr | 2007-09-20 | |||||||||||
| 01-AC-00101 | A | 0 | 0 | 2010-08-18 | AmdCe | 2010-09-01 | |||||||||||
| 01-AC-00102 | A | 0 | 0 | 2010-08-18 | AmdCe | 2010-09-01 | |||||||||||
| 01-RC-19536 | A | 0 | 0 | 1991-05-24 | DirEl | ||||||||||||
| 01-RC-19926 | A | 0 | 0 | EMP | 1993-03-25 | 1993-04-23 | DirEl | 1993-03-10 | |||||||||
| 01-RC-19926 | A | 0 | 1 | PET | 1993-03-25 | 1996-11-21 | DirEl | ||||||||||
| 01-RC-20080 | A | 0 | 0 | PET | 1994-02-11 | 1994-03-11 | DirEl | 1994-02-11 | |||||||||
| 01-RC-20080 | A | 0 | 1 | EMP | 1994-02-14 | ||||||||||||
| 01-RC-20106 | A | 0 | 0 | EMP | 1994-04-07 | 1994-06-08 | DecOr | 1994-04-07 | |||||||||
| 01-RC-20106 | A | 0 | 1 | PET | 1994-04-07 | ||||||||||||
| 01-RC-20309 | A | 0 | 0 | EMP | 1995-08-09 | 1995-09-01 | DirEl | 1995-08-09 | 1995-09-15 | ||||||||
| 01-RC-20309 | A | 0 | 1 | PET | 1995-08-09 | 1995-09-01 | |||||||||||
| 01-RC-20310 | A | 0 | 0 | EMP | 1995-08-09 | 1995-09-01 | DirEl | 1995-08-09 | 1995-09-15 | ||||||||
| 01-RC-20310 | A | 0 | 1 | PET | 1995-08-09 | ||||||||||||
| 01-RC-20463 | A | 0 | 0 | EMP | 1996-06-17 | 1996-06-26 | DirEl | 1996-06-17 | 1999-07-09 | ||||||||
| 01-RC-20508 | A | 0 | 0 | EMP | 1996-10-10 | 1996-11-07 | DirEl | 1996-10-10 | |||||||||
| 01-RC-20508 | A | 0 | 1 | PET | 1996-10-10 | ||||||||||||
| 01-RC-20574 | A | 0 | 0 | Grant | EMP | 1997-08-17 | 1997-08-27 | EMP | 1997-08-27 | 1997-10-17 | Dismi | 1997-08-18 | 1997-10-31 | ||||
| 01-RC-20574 | A | 0 | 1 | PET | 1997-08-27 | ||||||||||||
| 01-RC-20761 | A | 0 | 0 | Grant | 1998-02-23 | 1998-03-03 | EMP | 1998-03-03 | 1998-03-19 | DirEl | 1998-02-25 | ||||||
| 01-RC-20761 | A | 0 | 1 | PET | 1998-03-03 | ||||||||||||
| 01-RC-20804 | A | 0 | 0 | EMP | 1998-04-27 | 1998-05-21 | DirEl | 1998-04-27 | 1998-06-04 | ||||||||
| 01-RC-20804 | A | 0 | 1 | PET | 1998-04-27 | ||||||||||||
| 01-RC-20905 | A | 0 | 0 | PET | 1998-10-23 | 1998-11-10 | DirEl | 1998-10-23 | 1998-11-24 | ||||||||
| 01-RC-20914 | A | 0 | 0 | Grant | EMP | 1998-11-18 | 1998-11-18 | EMP | 1998-12-02 | 1998-12-21 | DirEl | 1998-11-23 | 1999-01-04 | ||||
| 01-RC-20914 | A | 0 | 1 | PET | 1998-12-02 | 1998-12-02 | |||||||||||
| 01-RC-20915 | A | 0 | 0 | Grant | EMP | 1998-11-18 | 1998-11-18 | EMP | 1998-12-02 | 1998-12-21 | DirEl | 1998-11-23 | 1999-01-04 | ||||
| 01-RC-20915 | A | 0 | 1 | PET | 1998-12-02 | 1998-12-02 | |||||||||||
| 01-RC-20921 | A | 0 | 0 | EMP | 1998-11-25 | 1998-12-15 | DirEl | 1998-11-23 | 1998-12-29 | ||||||||
| 01-RC-20921 | A | 0 | 1 | PET | 1998-11-25 | 1998-11-25 | |||||||||||
| 01-RC-20925 | A | 0 | 0 | EMP | 1998-11-30 | 1998-12-11 | DirEl | 1998-11-30 | 1998-12-27 | ||||||||
| 01-RC-20927 | A | 0 | 0 | PET | 1998-12-02 | 1998-12-24 | DirEl | 1998-12-02 | 1999-01-07 | ||||||||
| 01-RC-20940 | A | 0 | 0 | EMP | 1999-01-20 | 1999-02-12 | DirEl | 1998-12-28 | 1999-02-26 | ||||||||
| 01-RC-20940 | A | 0 | 1 | PET | 1999-01-20 | ||||||||||||
| 01-RC-20945 | A | 0 | 0 | EMP | 1998-12-28 | 1998-12-31 | DirEl | 1998-12-28 | 1999-01-14 | ||||||||
| 01-RC-20945 | A | 0 | 1 | PET | 1998-12-28 | ||||||||||||
| 01-RC-20947 | A | 0 | 0 | Grant | 1998-12-27 | 1999-01-05 | EMP | 1999-01-05 | 1999-01-14 | DirEl | 1998-12-28 | 1999-01-28 | |||||
| 01-RC-20947 | A | 0 | 1 | PET | 1999-01-05 | ||||||||||||
| 01-RC-20957 | A | 0 | 0 | 1999-01-13 | DirEl | ||||||||||||
| 01-RC-20958 | A | 0 | 0 | GrntA | EMP | 1999-01-08 | 1999-01-08 | PET | 1999-01-15 | 1999-01-28 | DirEl | 1999-01-12 | 1999-02-11 | ||||
| 01-RC-20958 | A | 0 | 1 | EMP | 1999-01-15 | 1999-01-15 | |||||||||||
| 01-RC-20960 | A | 0 | 0 | GrntA | EMP | 1999-01-21 | 1999-01-22 | EMP | 1999-01-29 | 1999-02-02 | DirEl | 1999-01-27 | 1999-02-16 | ||||
| 01-RC-20960 | A | 0 | 1 | PET | 1999-01-29 | 1999-01-29 | |||||||||||
| 01-RC-20968 | A | 0 | 0 | EMP | 1999-02-18 | 1999-03-04 | DirEl | 1999-02-18 | 1999-03-18 | ||||||||
| 01-RC-20968 | A | 0 | 1 | PET | 1999-02-18 | ||||||||||||
| 01-RC-20969 | A | 0 | 0 | Grant | EMP | 1999-02-23 | 1999-02-23 | EMP | 1999-03-01 | 1999-03-19 | DirEl | 1999-02-26 | 1999-04-02 | ||||
| 01-RC-20969 | A | 0 | 1 | PET | 1999-03-01 | 1999-03-01 | |||||||||||
| 01-RC-20970 | A | 0 | 0 | GrntA | EMP | 1999-03-05 | 1999-03-05 | EMP | 1999-03-10 | 1999-03-18 | DirEl | 1999-03-08 | 1999-04-01 | ||||
| 01-RC-20970 | A | 0 | 1 | PET | 1999-03-10 | 1999-03-10 | |||||||||||
| 01-RC-20971 | A | 0 | 0 | Grant | EMP | 1999-02-22 | 1999-02-22 | EMP | 1999-03-03 | 1999-03-19 | DirEl | 1999-03-03 | 1999-04-02 | ||||
| 01-RC-20975 | A | 0 | 0 | EMP | 1999-03-10 | 1999-03-15 | DecOr | 1999-03-10 | |||||||||
| 01-RC-20983 | A | 0 | 0 | 1999-03-25 | DirEl | 1999-03-22 | 1999-04-08 | ||||||||||
| 01-RC-20984 | A | 0 | 0 | EMP | 1999-04-06 | 1999-04-21 | DirEl | 1999-04-06 | 1999-05-05 | ||||||||
| 01-RC-20984 | A | 0 | 1 | PET | 1999-04-06 | ||||||||||||
| 01-RC-20984 | A | 1 | 0 | Grant | EMP | 2002-03-05 | 2002-03-05 | EMP | 2002-03-11 | 2002-05-22 | DecOr | 2002-03-26 | 2002-06-05 | ||||
| 01-RC-20984 | A | 1 | 1 | PET | 2002-03-26 | ||||||||||||
| 01-RC-20984 | A | 1 | 2 | EMP | 2002-03-27 | ||||||||||||
| 01-RC-20985 | A | 0 | 0 | GrntA | EMP | 1999-04-01 | 1999-04-01 | PET | 1999-04-07 | 1999-04-27 | DirEl | 1999-04-06 | 1999-05-11 | ||||
| 01-RC-20985 | A | 0 | 1 | EMP | 1999-04-08 | 1999-04-08 | |||||||||||
| 01-RC-21011 | A | 0 | 0 | GrntA | PET | 1999-05-13 | 1999-05-13 | PET | 1999-05-26 | 1999-06-03 | DirEl | 1999-05-17 | 1999-06-17 | ||||
| 01-RC-21011 | A | 0 | 1 | EMP | 1999-05-26 | 1999-05-26 | |||||||||||
| 01-RC-21012 | A | 0 | 0 | EMP | 1999-05-19 | 1999-05-21 | DirEl | 1999-05-19 | 1999-06-04 | ||||||||
| 01-RC-21014 | A | 0 | 0 | GrntA | EMP | 1999-05-21 | 1999-05-21 | EMP | 1999-05-28 | 1999-06-02 | DirEl | 1999-05-24 | 1999-06-16 | ||||
| 01-RC-21014 | A | 0 | 1 | 1999-05-28 | |||||||||||||
| 01-RC-21020 | A | 0 | 0 | 1999-06-22 | DirEl | 1999-06-11 | |||||||||||
| 01-RC-21026 | A | 0 | 0 | PET | 1999-06-30 | 1999-07-06 | DirEl | 1999-06-28 | 1999-07-20 | ||||||||
| 01-RC-21029 | A | 0 | 0 | PET | 1999-06-23 | 1999-06-24 | |||||||||||
| 01-RC-21029 | A | 0 | 1 | EMP | 1999-06-24 | ||||||||||||
| 01-RC-21037 | A | 0 | 0 | EMP | 1999-07-20 | 1999-07-30 | DirEl | 1999-07-20 | |||||||||
| 01-RC-21044 | A | 0 | 0 | 1999-08-27 | DirEl | ||||||||||||
| 01-RC-21078 | A | 0 | 0 | PET | 1999-09-28 | 1999-10-15 | DirEl | 1999-09-29 | 1999-10-29 | ||||||||
| 01-RC-21092 | A | 0 | 0 | 1999-10-27 | DirEl | 1999-11-10 | |||||||||||
| 01-RC-21097 | A | 0 | 0 | PET | 1999-11-08 | 1999-11-22 | DirEl | 1999-11-04 | |||||||||
| 01-RC-21097 | A | 0 | 1 | EMP | 1999-11-08 | 1999-11-22 | DirEl | 1999-12-06 | |||||||||
| 01-RC-21098 | A | 0 | 0 | EMP | 1999-11-17 | 1999-12-02 | DirEl | 1999-11-12 | 1999-12-16 | ||||||||
| 01-RC-21098 | A | 0 | 1 | PET | 1999-11-17 | 1999-12-02 | DirEl | 1999-12-06 | |||||||||
| 01-RC-21102 | A | 0 | 0 | 2000-02-02 | DirEl | 2000-02-16 | |||||||||||
| 01-RC-21128 | A | 0 | 0 | Grant | EMP | 2000-01-21 | 2000-02-04 | EMP | 2000-02-04 | 2000-02-10 | DecOr | 2000-01-28 | 2000-02-24 | ||||
| 01-RC-21128 | A | 0 | 1 | Grant | PET | 2000-01-21 | 2000-02-04 | PET | 2000-02-08 | 2000-02-04 | |||||||
| 01-RC-21130 | A | 0 | 0 | Grant | EMP | 2000-02-17 | 2000-02-23 | EMP | 2000-02-24 | 2000-02-25 | DirEl | 2000-02-17 | 2000-03-10 | ||||
| 01-RC-21130 | A | 0 | 1 | PET | 2000-02-24 | 2000-02-23 | |||||||||||
| 01-RC-21131 | A | 0 | 0 | Grant | EMP | 2000-01-31 | 2000-02-04 | EMP | 2000-02-04 | 2000-02-16 | DirEl | 2000-01-31 | 2000-03-01 | ||||
| 01-RC-21131 | A | 0 | 1 | PET | 2000-02-04 | 2000-02-04 | |||||||||||
| 01-RC-21135 | A | 0 | 0 | Grant | EMP | 2000-02-15 | 2000-02-18 | EMP | 2000-02-18 | 2000-03-02 | DirEl | 2000-02-15 | 2000-03-16 | ||||
| 01-RC-21135 | A | 0 | 1 | PET | 2000-02-18 | 2000-02-18 | |||||||||||
| 01-RC-21138 | A | 0 | 0 | 2000-02-11 | DirEl | 2000-02-25 | |||||||||||
| 01-RC-21160 | A | 0 | 0 | EMP | 2000-04-05 | 2000-04-21 | DirEl | 2000-04-05 | |||||||||
| 01-RC-21163 | A | 0 | 0 | 2000-04-19 | DirEl | 2000-04-24 | EMP | Deny | 2000-05-18 | 2000-04-07 | 2000-05-03 | ||||||
| 01-RC-21185 | A | 0 | 0 | PET | 2000-05-15 | 2000-05-16 | DirEl | 2000-05-15 | 2000-05-30 | ||||||||
| 01-RC-21185 | A | 0 | 1 | EMP | 2000-05-15 | ||||||||||||
| 01-RC-21188 | A | 0 | 0 | PET | 2000-05-17 | 2000-05-23 | DirEl | 2000-05-17 | 2000-06-03 | ||||||||
| 01-RC-21189 | A | 0 | 0 | 2000-06-01 | DecOr | 2000-05-17 | 2000-06-15 | ||||||||||
| 01-RC-21192 | A | 0 | 0 | EMP | 2000-06-06 | 2000-06-14 | DirEl | 2000-06-06 | 2000-06-28 | ||||||||
| 01-RC-21195 | A | 0 | 0 | EMP | 2000-06-13 | 2000-06-23 | DirEl | 2000-06-13 | 2000-07-07 | ||||||||
| 01-RC-21199 | A | 0 | 0 | Grant | EMP | 2000-07-07 | 2000-07-07 | PET | 2000-07-10 | 2000-08-03 | DirEl | 2000-07-11 | 2000-08-17 | ||||
| 01-RC-21199 | A | 0 | 1 | EMP | 2000-07-10 | ||||||||||||
| 01-RC-21202 | A | 0 | 0 | PET | 2000-07-10 | 2000-07-13 | DirEl | 2000-07-07 | 2000-07-27 |
Table schema
CREATE TABLE r_pre_elect_rd_decision(r_case_number VARCHAR, unit_id VARCHAR, action_sequence BIGINT, recurrence BIGINT, determination_eot VARCHAR, eot_party VARCHAR, eot_filed_date DATE, eot_deter_brief_date DATE, brief_rcvd_party VARCHAR, pre_election_brief_rcvd DATE, rd_decision_issued_date DATE, rd_decision_type VARCHAR, recon_request_filed DATE, recon_request_party VARCHAR, rd_recon_deter VARCHAR, rd_recon_deter_date DATE, brief_due_date DATE, review_due_date DATE);