r_post_elect_board_act

2,536 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ r_case_number received_date received_reason ruling_action_code exception_withdrawn_date board_decision_date board_action_code
1 1 01-RC-20815         2001-03-23T00:00:00 Decision and Certification of Results 50
2 2 01-RC-20984 2000-08-09T00:00:00 Request for Review RRFIL Request Granted / Remanded 27      
3 3 01-RC-20984         2006-09-30T00:00:00 Decision and Order Remanding to RD 55
4 4 01-RC-21090         2000-01-12T00:00:00 Decision and Certification of Representation 52
5 5 01-RC-21116         2000-06-16T00:00:00 Decision and Certification of Results 50
6 6 01-RC-21143 2000-05-11T00:00:00 Exceptions Filed EXCEP     2000-05-31T00:00:00 Decision and Certification of Representation 52
7 7 01-RC-21149         2000-05-17T00:00:00 Decision and Certification of Results 50
8 8 01-RC-21152 2000-09-11T00:00:00 Exceptions Filed EXCEP     2003-05-30T00:00:00 Decision and Direction of Second Election 54
9 9 01-RC-21152 2003-07-17T00:00:00 Request for Review RRFIL        
10 10 01-RC-21159         2000-08-31T00:00:00 Decision and Direction of Second Election 54
11 11 01-RC-21194 2000-10-20T00:00:00 Exceptions Filed EXCEP     2001-08-03T00:00:00 Decision and Direction of Second Election 54
12 12 01-RC-21200         2000-12-18T00:00:00 Decision and Certification of Representation 52
13 13 01-RC-21210 2000-11-09T00:00:00 Exceptions Filed EXCEP     2001-03-16T00:00:00 Decision and Certification of Representation 52
14 14 01-RC-21216 2000-10-12T00:00:00 Exceptions Filed EXCEP     2000-11-01T00:00:00 Decision and Certification of Results 50
15 15 01-RC-21227         2001-05-09T00:00:00 Decision and Direction / Open and Count 53
16 16 01-RC-21242         2001-02-08T00:00:00 Decision and Direction of Second Election 54
17 17 01-RC-21266         2001-03-02T00:00:00 Decision and Direction / Open and Count 53
18 18 01-RC-21288 2001-04-10T00:00:00 Exceptions Filed EXCEP     2001-04-27T00:00:00 Decision and Direction / Open and Count 53
19 19 01-RC-21313 2001-06-06T00:00:00 Exceptions Filed EXCEP        
20 20 01-RC-21313         2001-06-27T00:00:00 Decision and Certification of Representation 52
21 21 01-RC-21335         2001-08-20T00:00:00 Decision and Direction of Second Election 54
22 22 01-RC-21365         2001-12-19T00:00:00 Decision and Certification of Results 50
23 23 01-RC-21376 2002-03-28T00:00:00 Exceptions Filed EXCEP     2005-03-24T00:00:00 Decision and Certification of Representation 52
24 24 01-RC-21388 2001-10-16T00:00:00 Exceptions Filed EXCEP     2001-12-20T00:00:00 Decision and Certification of Representation 52
25 25 01-RC-21403         2002-01-14T00:00:00 Decision and Direction of Second Election 54
26 26 01-RC-21405 2001-11-08T00:00:00 Exceptions Filed EXCEP     2001-12-19T00:00:00 Decision and Direction / Open and Count 53
27 27 01-RC-21417 2002-01-18T00:00:00 Exceptions Filed EXCEP     2002-09-06T00:00:00 Decision and Direction / Open and Count 53
28 28 01-RC-21417 2002-09-26T00:00:00 Motion for Reconsideration MOTRE Motion Granted 75      
29 29 01-RC-21417 2002-09-26T00:00:00 Request for Review RRFIL Request Granted 25   2002-11-15T00:00:00 Miscellaneous Decisions and Orders 57
30 30 01-RC-21417         2003-02-13T00:00:00 Board Order Sustaining Objections/ Proc Persuant RD 61
31 31 01-RC-21510         2002-09-06T00:00:00 Decision and Certification of Representation 52
32 32 01-RC-21523         2002-12-19T00:00:00 Decision and Direction / Open and Count 53
33 33 01-RC-21557 2003-02-28T00:00:00 Exceptions Filed EXCEP     2003-08-21T00:00:00 Decision and Direction of Second Election 54
34 34 01-RC-21561 2003-01-17T00:00:00 Exceptions Filed EXCEP     2003-05-08T00:00:00 Decision and Direction of Second Election 54
35 35 01-RC-21579         2003-05-08T00:00:00 Decision and Certification of Representation 52
36 36 01-RC-21601         2003-07-02T00:00:00 Decision and Direction of Second Election 54
37 37 01-RC-21649         2004-03-08T00:00:00 Decision and Certification of Representation 52
38 38 01-RC-21650         2004-03-08T00:00:00 Decision and Certification of Representation 52
39 39 01-RC-21660 2003-11-12T00:00:00 Exceptions Filed EXCEP        
40 40 01-RC-21660         2004-04-16T00:00:00 Decision and Certification of Representation 52
41 41 01-RC-21677         2004-01-13T00:00:00 Decision and Certification of Results 50
42 42 01-RC-21717         2005-04-29T00:00:00 Decision and Direction / Open and Count 53
43 43 01-RC-21740         2004-08-26T00:00:00 Decision and Certification of Representation 52
44 44 01-RC-21749 2005-03-31T00:00:00 Exceptions Filed EXCEP     2005-05-27T00:00:00 Board's Supplemental Decision (All) 59
45 45 01-RC-21754         2004-10-04T00:00:00 Decision and Certification of Results 50
46 46 01-RC-21759 2004-11-18T00:00:00 Exceptions Filed EXCEP     2004-12-07T00:00:00 Decision and Certification of Representation 52
47 47 01-RC-21779         2004-11-29T00:00:00 Decision and Certification of Results 50
48 48 01-RC-21801 2004-11-18T00:00:00 Exceptions Filed EXCEP   2004-11-23T00:00:00 2004-11-29T00:00:00 Decision and Direction / Open and Count 53
49 49 01-RC-21804         2004-12-17T00:00:00 Decision and Direction / Open and Count 53
50 50 01-RC-21805         2004-12-22T00:00:00 Decision and Certification of Results 50
51 51 01-RC-21817         2005-02-10T00:00:00 Decision and Certification of Results 50
52 52 01-RC-21819 2005-01-24T00:00:00 Exceptions Filed EXCEP     2005-03-09T00:00:00 Decision and Certification of Representation 52
53 53 01-RC-21826 2004-12-30T00:00:00 Exceptions Filed EXCEP     2005-02-10T00:00:00 Decision and Certification of Representation 52
54 54 01-RC-21843         2005-03-02T00:00:00 Decision and Certification of Representation 52
55 55 01-RC-21881         2005-09-16T00:00:00 Decision and Certification of Results 50
56 56 01-RC-21917 2005-09-27T00:00:00 Exceptions Filed EXCEP     2005-12-27T00:00:00 Decision and Certification of Representation 52
57 57 01-RC-21971         2006-03-28T00:00:00 Decision and Certification of Representation 52
58 58 01-RC-22034 2007-03-09T00:00:00 Exceptions Filed EXCEP     2007-06-18T00:00:00 Decision and Certification of Representation 52
59 59 01-RC-22035 2007-03-09T00:00:00 Exceptions Filed EXCEP     2007-06-18T00:00:00 Decision and Certification of Representation 52
60 60 01-RC-22038 2006-11-22T00:00:00 Exceptions Filed EXCEP     2007-07-25T00:00:00 Decision and Certification of Representation 52
61 61 01-RC-22056 2007-01-12T00:00:00 Exceptions Filed EXCEP     2007-05-08T00:00:00 Decision and Certification of Representation 52
62 62 01-RC-22087 2008-05-07T00:00:00 Request for Review RRFIL Request Denied 22      
63 63 01-RC-22092 2008-05-07T00:00:00 Request for Review RRFIL Request Denied 22      
64 64 01-RC-22139 2008-01-10T00:00:00 Exceptions Filed EXCEP     2008-03-31T00:00:00 Decision and Direction / Open and Count 53
65 65 01-RC-22148 2008-02-29T00:00:00 Exceptions Filed EXCEP     2008-07-18T00:00:00 Decision and Certification of Representation 52
66 66 01-RC-22162 2008-10-10T00:00:00 Exceptions Filed EXCEP     2009-03-31T00:00:00 Decision and Direction of Second Election 54
67 67 01-RC-22162 2009-08-31T00:00:00 Request for Review RRFIL Request Granted / Remanded 27      
68 68 01-RC-22165 2008-04-22T00:00:00 Exceptions Filed EXCEP     2009-01-29T00:00:00 Decision and Direction / Open and Count 53
69 69 01-RC-22195         2008-08-11T00:00:00 Decision and Certification of Representation 52
70 70 01-RC-22272 2009-03-30T00:00:00 Exceptions Filed EXCEP     2009-07-21T00:00:00 Decision and Direction of Second Election 54
71 71 01-RC-22272 2010-02-16T00:00:00 Exceptions Filed EXCEP     2010-11-18T00:00:00 Decision and Direction of Second Election 54
72 72 01-RC-22303         2009-07-23T00:00:00 Decision and Direction of Second Election 54
73 73 01-RC-22362         2009-12-22T00:00:00 Decision and Certification of Representation 52
74 74 01-RC-22404         2010-04-30T00:00:00 Decision and Order Remanding to RD 55
75 75 01-RC-22460         2010-09-24T00:00:00 Decision and Certification of Representation 52
76 76 01-RD-01935 2000-08-04T00:00:00 Exceptions Filed EXCEP     2000-08-30T00:00:00 Decision and Certification of Results 50
77 77 01-RD-02030         2004-04-27T00:00:00 Decision and Direction / Open and Count 53
78 78 01-RD-02033         2004-12-09T00:00:00 Decision and Certification of Results 50
79 79 01-RD-02071         2006-06-06T00:00:00 Decision and Certification of Results 50
80 80 01-RM-01263         2004-10-06T00:00:00 Decision and Certification of Representation 52
81 81 01-UD-00291 2006-11-28T00:00:00 Exceptions Filed EXCEP     2006-12-21T00:00:00 Decision and Certification of Results 50
82 82 02-RC-21781 2001-06-07T00:00:00 Request for Review RRFIL Request Denied 22      
83 83 02-RC-22077 2000-08-30T00:00:00 Exceptions Filed EXCEP     2000-10-04T00:00:00 Decision and Direction of Second Election 54
84 84 02-RC-22077 2001-07-25T00:00:00 Exceptions Filed EXCEP     2001-09-06T00:00:00 Decision and Certification of Representation 52
85 85 02-RC-22120 2001-03-22T00:00:00 Request for Review RRFIL Request Denied 22      
86 86 02-RC-22120 2001-04-27T00:00:00 Request for Review RRFIL Request Denied 22      
87 87 02-RC-22138 2000-02-22T00:00:00 Exceptions Filed EXCEP     2000-03-15T00:00:00 Decision and Certification of Representation 52
88 88 02-RC-22142 2000-02-04T00:00:00 Exceptions Filed EXCEP     2000-02-24T00:00:00 Decision and Certification of Representation 52
89 89 02-RC-22161 2000-09-06T00:00:00 Exceptions Filed EXCEP     2000-11-22T00:00:00 Decision and Certification of Representation 52
90 90 02-RC-22188         2000-10-06T00:00:00 Decision and Direction of Second Election 54
91 91 02-RC-22206 2001-06-27T00:00:00 Request for Review RRFIL Request Denied 22      
92 92 02-RC-22217 2000-07-11T00:00:00 Request for Review RRFIL Request Denied 22      
93 93 02-RC-22223 2000-07-10T00:00:00 Exceptions Filed EXCEP     2000-08-02T00:00:00 Decision and Certification of Representation 52
94 94 02-RC-22300         2001-05-08T00:00:00 Decision and Certification of Results 50
95 95 02-RC-22355 2002-02-05T00:00:00 Request for Review RRFIL Request Granted 25   2007-08-09T00:00:00 Decision and Certification of Results 50
96 96 02-RC-22360 2001-09-05T00:00:00 Exceptions Filed EXCEP     2001-10-17T00:00:00 Decision and Direction / Open and Count 53
97 97 02-RC-22388         2001-08-31T00:00:00 Decision and Certification of Representation 52
98 98 02-RC-22395 2001-12-21T00:00:00 Exceptions Filed EXCEP        
99 99 02-RC-22402 2002-01-09T00:00:00 Exceptions Filed EXCEP     2002-09-04T00:00:00 Decision and Certification of Results 50
100 100 02-RC-22402 2002-03-18T00:00:00 Exceptions Filed EXCEP     2002-09-04T00:00:00 Decision and Certification of Results 50

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "r_post_elect_board_act" (
    "r_case_number" text,
    "received_date" text,
    "received_reason" text,
    "ruling_action_code" integer,
    "exception_withdrawn_date" text,
    "board_decision_date" text,
    "board_action_code" integer,
    FOREIGN KEY (r_case_number) REFERENCES r_case (r_case_number),
    FOREIGN KEY ([board_action_code]) REFERENCES[l_r_board_action_code] ([action_code]),
    FOREIGN KEY ([ruling_action_code]) REFERENCES[l_r_board_action_code] ([action_code]),
    FOREIGN KEY ([received_reason]) REFERENCES[l_r_board_received_reason] ([received_reason])
);