home / cats / r_post_elect_rd_act

r_post_elect_rd_act

4,745 rows

✎ View and edit SQL

Suggested facets: unit_id, action_sequence, recurrence, brief_party, eot_request_date, eot_party, eot_determination_date, eot_determination, rd_action_type, 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 Rept. on Obj. & NOH 10006 Hearing directed on all activeObjections 24        
01-RC-20761 A 01-00357 0 0               2001-03-01 Supp. Dec. on Obj., w/o NOH 10011 Active Obj. resolved; election certified 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 Rept. on Obj., w/o NOH 10005 All active Obj.resolved; elec. certified 22 2001-03-15      
01-RC-20890 A 01-00081 0 0               1998-12-02 Approval of Withdrawal of Obj. 10018 All active Objections withdrawn 80 1998-12-16      
01-RC-20897 A 01-00048 0 0               1999-03-19 Rept. on Chall., w/o NOH 10001 All active Chall.resolved;elec.certified 3 1999-04-02      
01-RC-20905 A 01-00026 0 0               1998-12-30 Rept. on Chall. & Obj. & NOH 10004 Hrg.directed on actveObj.;activeCh.rslvd 17 1999-01-13      
01-RC-20906 A 01-00148 0 0               1998-12-22 Rept. on Obj., w/o NOH 10005 All active Obj.resolved; elec. certified 22 1999-01-05      
01-RC-20923 A 01-00034 0 0                       1999-02-24 Regional Director RD  
01-RC-20966 A 01-00143 0 0               1999-08-05 Approval of Withdrawal of Chall. & Obj. 10017 Some Obj.& some Chall.withdrawn 79 1999-08-19      
01-RC-20979 A 01-00071 0 0               1999-05-05 Rept. on Chall. & Obj., w/o NOH 10003 ActvO.rslvd;actvC.rslvd;opn&cnt some/all 12 1999-05-19      
01-RC-20983 A 01-00096 0 0               1999-05-07 Supp. Dec. on Obj., w/o NOH 10011 Active Obj. resolved; election certified 68 1999-05-21      
01-RC-20984 A 01-00285 0 0               2000-07-26 Supp. Dec. on Obj., w/o NOH 10011 Active Obj. resolved; election certified 68 2000-08-09      
01-RC-20986 A 01-00099 0 0               1999-06-10 Rept. on Obj., w/o NOH 10005 All active Obj.resolved; elec. certified 22        
01-RC-21013 A 01-00117 0 0               1999-06-25 Rept. on Chall., w/o NOH 10001 All active Chall.resolved;elec.certified 3 1999-07-09      
01-RC-21023 A 01-00124 0 0 1999-11-05             1999-07-22 Rept. on Obj., w/o NOH 10005 All active Obj.resolved; elec. certified 22   1999-11-15 Regional Director RD  
01-RC-21073 A 01-00180 0 0               1999-11-16 Rept. on Chall. & Obj. & NOH 10004 Hearing directed on all active Obj.&Ch. 16 1999-11-30      
01-RC-21085 A 01-00190 0 0               1999-11-15 Rept. on Chall. & Obj. & NOH 10004 Hearing directed on all active Obj.&Ch. 16 1999-11-29 2000-01-06 Regional Director RD  
01-RC-21085 B 01-00190 0 0               1999-11-15 Rept. on Chall. & Obj. & NOH 10004 Hearing directed on all active Obj.&Ch. 16 1999-11-29 2000-01-06 Regional Director RD  
01-RC-21085 B 01-00190 1 0                       2000-01-06 Regional Director RD  
01-RC-21086 A 01-00191 0 0               1999-11-15 Rept. on Chall. & Obj. & NOH 10004 Hearing directed on all active Obj.&Ch. 16 1999-11-29 2000-01-06 Regional Director RD  
01-RC-21086 B 01-00191 0 0               1999-11-15 Rept. on Chall. & Obj. & NOH 10004 Hearing directed on all active Obj.&Ch. 16 1999-11-29 2000-01-06 Regional Director RD  
01-RC-21086 B 01-00191 1 0                       2000-01-06 Regional Director RD  
01-RC-21090 A 01-00201 0 0               1999-12-16 Rept. on Obj., w/o NOH 10005 All active Obj.resolved; elec. certified 22 1999-12-30      
01-RC-21106 B 01-00222 0 0               2000-01-31 Approval of Withdrawal of Chall. 10016 Active Chall. withdrawn; elec. certified 73        
01-RC-21116 A 01-00225 0 0 2000-05-16 2000-05-16 Petitioner PET                 2000-05-23 Board  
01-RC-21122 A 01-00237 0 0               2000-03-14 Approval of Withdrawal of Chall. 10016 All active Chall. withdrawn 72 2000-03-28      
01-RC-21133 A 01-00238 0 0               2000-03-24 Rept. on Chall., w/o NOH 10001 All active Chall.resolved;elec.certified 3 2000-04-07      
01-RC-21134 A 01-00231 0 0               2000-02-17 Approval of Withdrawal of Chall. 10016 All active Chall. withdrawn 72 2000-03-02      
01-RC-21138 A 01-00247 0 0               2000-03-30 Rept. on Chall., w/o NOH 10001 All active Chall.resolved;elec.certified 3 2000-04-13      
01-RC-21143 A 01-00248 0 0               2000-04-27 Rept. on Obj., w/o NOH 10005 All active Obj.resolved; elec. certified 22 2000-05-11      
01-RC-21146 A 01-00255 0 0               2000-08-11 Rept. on Obj. & NOH 10006 Hearing directed on all activeObjections 24        
01-RC-21149 A 01-00257 0 0               2000-04-26 Rept. on Obj., w/o NOH 10005 All active Obj.resolved; elec. set aside 23 2000-05-10      
01-RC-21152 A 01-00263 0 0 2000-07-10 2000-07-13 Employer EMP                 2000-08-14 Board 2000-08-28
01-RC-21152 A 01-00263 0 1   2000-07-13 Union Involved UNIN                      
01-RC-21158 A 01-00388 0 0               2001-10-24 Rept. on Chall. & Obj. & NOH 10004 Hrg.directed on actveObj.;activeCh.rslvd 17 2001-11-07      
01-RC-21159 A 01-00266 0 0 2000-06-22 2000-06-22 Employer 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 Rept. on Obj. & NOH 10006 Some obj.rslvd;Hrg.directed on remaining 25        
01-RC-21200 A 01-00331 0 0               2000-11-22 Rept. on Obj., w/o NOH 10005 All active Obj.resolved; elec. certified 22 2000-12-06      
01-RC-21210 A 01-00303 0 0 2000-10-11 2000-10-11 Employer EMP         2000-09-21 Rept. on Obj. & NOH 10006 Hearing directed on all activeObjections 24   2000-10-26 Board  
01-RC-21216 A 01-00305 0 0               2000-09-28 Rept. on Obj., w/o NOH 10005 All active Obj.resolved; elec. certified 22 2000-10-12      
01-RC-21227 A 01-00313 0 0               2001-04-05 Rept. on Chall., w/o NOH 10001 Some Chall. resolved; open & count some 2 2001-04-19      
01-RC-21238 A 01-00316 0 0               2000-11-20 Approval of Stipulation on Obj. 10015 All active Obj.resolved; elec. set aside 46        
01-RC-21242 A 01-00322 0 0                       2001-01-17 Board  
01-RC-21255 A 01-00323 0 0               2000-11-01 Approval of Withdrawal of Obj. 10018 All active Objections withdrawn 80        
01-RC-21257 A 01-00326 0 0               2000-11-14 Approval of Stipulation on Chall. 10013 All active Chall.resolved;elec.certified 28        
01-RC-21266 A 01-00336 0 0 2000-12-21 2000-12-21 Employer EMP         2000-12-01 Rept. on Chall. & NOH 10002 Hearing directed on all active Chall. 4   2001-01-09 Board  
01-RC-21279 A 01-00355 0 0               2001-01-30 Approval of Stipulation on Chall. 10013 All active Chall.resolved;elec.certified 28        
01-RC-21288 A 01-00356 0 0 2001-03-21 2001-03-21 Employer EMP                 2001-03-29 Board  
01-RC-21288 A 01-00356 0 1   2001-03-21 Petitioner PET                      
01-RC-21313 A 01-00392 0 0               2001-05-23 Rept. on Obj., w/o NOH 10005 All active Obj.resolved; elec. certified 22 2001-06-06      
01-RC-21335 A 01-00398 0 0 2001-06-21 2001-06-21 Employer EMP                 2001-07-26 Board  
01-RC-21335 A 01-00398 0 1   2001-06-21 Petitioner PET                      
01-RC-21365 A 01-00410 0 0               2001-10-25 Rept. on Obj., w/o NOH 10005 All active Obj.resolved; elec. certified 22 2001-11-08      
01-RC-21376 A 01-00423 0 0 2002-01-22 2002-01-22 Employer EMP         2001-12-21 Rept. on Obj. & NOH 10006 Some obj.rslvd;Hrg.directed on remaining 25 2002-01-04 2002-03-14 Board 2002-03-28
01-RC-21376 A 01-00423 0 1   2002-01-22 Petitioner PET                      
01-RC-21388 A 01-00429 0 0               2001-09-27 Rept. on Obj., w/o NOH 10005 All active Obj.resolved; elec. certified 22 2001-10-11      
01-RC-21403 A 01-00438 0 0 2001-11-21 2001-11-21 Employer EMP                 2001-12-05 Board 2001-12-19
01-RC-21403 A 01-00438 0 1   2001-11-21 Petitioner PET                      
01-RC-21405 A 01-00439 0 0   2001-10-18 Employer EMP                 2001-10-23 Board  
01-RC-21405 A 01-00439 0 1   2001-10-18 Petitioner PET                      
01-RC-21417 A 01-00450 0 0 2002-12-21 2002-12-21 Employer EMP         2002-01-04 Rept. on Chall. & Obj., w/o NOH 10003 ActiveOb.rslvd;someCh.rslvd;opn&cnt some 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 Employer EMP                 2002-12-11 Board 2002-12-25
01-RC-21480 A 01-00502 0 0               2002-05-02 Approval of Stipulation on Chall. 10013 All active Chall. resolved; open & count 26 2002-05-16      
01-RC-21484 A 01-00503 0 0               2002-05-17 Rept. on Obj., w/o NOH 10005 All active Obj.resolved; elec. certified 22 2002-05-31      
01-RC-21510 A 01-00521 0 0               2002-08-15 Rept. on Obj., w/o NOH 10005 All active Obj.resolved; elec. certified 22 2002-08-29      
01-RC-21523 A 01-00535 0 0 2002-11-07 2002-11-12 Intervenor INT                 2002-11-13 Board 2002-11-27
01-RC-21548 A 01-00553 0 0               2002-12-11 Supp. Dec. on Obj., w/o NOH 10011 Active Obj. resolved; election set aside 69 2002-12-26      
01-RC-21553 A 01-00552 0 0               2002-12-05 Rept. on Chall. & Obj., w/o NOH 10003 All activeObj.&Chal.reslved;elec.certfid 8 2002-12-19      
01-RC-21557 A 01-00557 0 0 2003-01-03 2003-01-06 Employer EMP                 2003-02-14 Board 2003-02-28
01-RC-21557 A 01-00557 0 1   2003-01-06 Petitioner PET                      
01-RC-21558 A 01-00555 0 0               2002-11-26 Rept. on Chall., w/o NOH 10001 All active Chall.resolved;elec.certified 3 2002-12-10      
01-RC-21561 A 01-00556 0 0 2002-12-20 2002-12-20 Petitioner PET                 2003-01-03 Board 2003-01-17
01-RC-21572 A 01-00570 0 0 2003-04-15 2003-04-15 Employer EMP                 2003-05-28 Board 2003-06-11
01-RC-21572 A 01-00570 0 1   2003-04-15 Petitioner PET                      
01-RC-21579 A 01-00574 0 0 2003-03-24 2003-03-20 Petitioner PET                 2003-04-01 Board 2003-04-15
01-RC-21579 A 01-00574 0 1   2003-03-24 Employer EMP                      
01-RC-21601 A 01-00589 0 0 2003-05-20 2003-05-20 Employer EMP         2003-03-10 Rept. on Chall., w/o NOH 10001 All active Chall. resolved; open & count 1 2003-03-24 2003-06-09 Board 2003-06-23
01-RC-21601 A 01-00589 0 1   2003-05-20 Petitioner PET                      
01-RC-21646 A 01-00640 0 0               2003-08-14 Supp. Dec. on Chall., w/o NOH 10009 Chall. resolved; open & count ballots 65 2003-08-28      
01-RC-21649 A 01-00674 0 0 2004-01-07 2004-01-07 Petitioner PET                 2004-01-27 Board 2004-02-10
01-RC-21649 A 01-00674 0 1   2004-01-07 Intervenor INT                      
01-RC-21660 A 01-00646 0 0 2003-10-08 2003-10-15 Employer EMP                 2003-10-30 Regional Director RD 2003-11-13
01-RC-21660 A 01-00646 0 1   2003-10-15 Petitioner PET                      
01-RC-21668 A 01-00660 0 0               2003-11-07 Approval of Withdrawal of Obj. 10018 All active Obj.withdrawn; elec.certified 81 2003-11-21      
01-RC-21677 A 01-00668 0 0               2003-12-17 Rept. on Obj., w/o NOH 10005 All active Obj.resolved; elec. certified 22 2003-12-31      
01-RC-21717 A 01-00703 0 0 2004-07-02 2004-07-02 Petitioner PET         2004-04-26 Rept. on Obj. & NOH 10006 Hearing directed on all activeObjections 24 2004-05-10      
01-RC-21717 A 01-00703 0 1   2004-07-02 Employer 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 Approval of Withdrawal of Chall. & Obj. 10017 Some Obj.& some Chall.withdrawn 79 2004-06-10      
01-RC-21749 A 01-00811 0 0 2005-03-09 2005-03-09 Employer EMP         2005-02-24 Rept. on Chall. & Obj. & NOH 10004 Hearing directed on all active Obj.&Ch. 16 2005-03-10 2005-03-14 Board 2005-03-28
01-RC-21749 A 01-00811 0 1   2005-03-11 Petitioner PET                      
01-RC-21754 A 01-00729 0 0 2004-06-10 2004-06-10 Petitioner PET                 2004-06-25 Regional Director RD 2004-07-09
01-RC-21759 A 01-00736 0 0               2004-06-24 Rept. on Obj., w/o NOH 10005 All active Obj.resolved; elec. set aside 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 Rept. on Chall., w/o NOH 10001 All active Chall.resolved;elec.certified 3 2004-10-21      
01-RC-21801 A 01-00765 0 0 2004-10-14 2004-10-14 Employer EMP                 2004-11-04 Board 2004-11-18
01-RC-21801 A 01-00765 0 1   2004-10-14 Petitioner PET                      

Next page

Download this data

CSV · JSON

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, FOREIGN KEY (rd_action_determination) REFERENCES l_r_rd_action_det(rd_action_determination), FOREIGN KEY (rd_action_type) REFERENCES l_r_rd_action_type(rd_action_type), FOREIGN KEY (ho_report_directed) REFERENCES l_r_postelec_ho_directed(ho_report_directed), FOREIGN KEY (eot_determination) REFERENCES l_r_postelec_det_eot(post_elect_determ_eot), FOREIGN KEY (eot_party) REFERENCES l_case_party(party), FOREIGN KEY (brief_party) REFERENCES l_case_party(party));

Queries took 1.2ms

A project of Forest Gregg. Read about project updates on Notes on Labor Data.