r_pre_elect_board_act

2,720 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ r_case_number action_sequence recurrence received_date received_reason ruling_decision_date ruling_action_code exception_withdrawn_date board_decision_date board_action_code
1 1 01-RC-21097 0 0 1999-11-30T00:00:00 Request for Review RRFIL 1999-12-15T00:00:00 Request Denied 22      
2 2 01-RC-21131 0 0 2000-02-29T00:00:00 Request for Review RRFIL 2000-03-08T00:00:00 Request Denied 22      
3 3 01-RC-21135 0 0 2000-03-16T00:00:00 Request for Review RRFIL 2000-03-29T00:00:00 Request Denied 22      
4 4 01-RC-21163 0 0 2000-05-03T00:00:00 Request for Review RRFIL 2000-05-18T00:00:00 Request Denied 22      
5 5 01-RC-21189 0 0 2000-06-12T00:00:00 Request for Review RRFIL 2000-09-22T00:00:00 Request Granted 25   2001-06-08T00:00:00 Decision and Order on Review 51
6 6 01-RC-21199 0 0 2000-08-11T00:00:00 Request for Review RRFIL 2000-08-30T00:00:00 Request Denied 22      
7 7 01-RC-21202 0 0 2000-07-27T00:00:00 Request for Review RRFIL 2000-08-09T00:00:00 Request Denied 22      
8 8 01-RC-21210 0 0 2000-08-07T00:00:00 Request for Review RRFIL 2000-08-16T00:00:00 Request Denied 22      
9 9 01-RC-21224 0 0 2000-09-21T00:00:00 Request for Review RRFIL 2000-10-04T00:00:00 Request Granted Partial / Other Denied 26   2001-03-09T00:00:00 Decision and Order on Review 51
10 10 01-RC-21235 0 0 2000-10-11T00:00:00 Request for Review RRFIL 2000-10-25T00:00:00 Request Granted 25      
11 11 01-RC-21235 1 0 2001-12-26T00:00:00 Request for Review RRFIL 2002-10-18T00:00:00 Request Denied 22      
12 12 01-RC-21240 0 0 2000-11-13T00:00:00 Request for Review RRFIL 2001-04-24T00:00:00 Request Granted 25   2001-04-24T00:00:00 Decision and Order on Review 51
13 13 01-RC-21243 0 0 2000-11-13T00:00:00 Request for Review RRFIL 2000-11-21T00:00:00 Request Denied 22      
14 14 01-RC-21286 0 0 2001-01-25T00:00:00 Request for Review RRFIL 2001-01-31T00:00:00 Request Denied 22      
15 15 01-RC-21289 0 0 2001-01-19T00:00:00 Request for Review RRFIL 2001-03-08T00:00:00 Request Granted 25   2001-03-08T00:00:00 Decision and Order on Review 51
16 16 01-RC-21301 0 0 2001-02-28T00:00:00 Request for Review RRFIL 2001-03-21T00:00:00 Request Denied 22      
17 17 01-RC-21302 0 0 2001-02-28T00:00:00 Request for Review RRFIL 2001-03-21T00:00:00 Request Denied 22      
18 18 01-RC-21304 0 0 2001-03-26T00:00:00 Request for Review RRFIL 2001-04-04T00:00:00 Request Denied 22      
19 19 01-RC-21319 0 0 2001-04-19T00:00:00 Request for Review RRFIL          
20 20 01-RC-21339 0 0 2001-05-15T00:00:00 Request for Review RRFIL 2001-05-23T00:00:00 Request Denied 22      
21 21 01-RC-21343 0 0 2001-10-01T00:00:00 Request for Review RRFIL 2001-10-24T00:00:00 Request Denied 22      
22 22 01-RC-21347 0 0 2001-10-10T00:00:00 Request for Review RRFIL 2001-10-24T00:00:00 Request Denied 22      
23 23 01-RC-21354 0 0 2001-06-01T00:00:00 Request for Review RRFIL 2001-06-13T00:00:00 Request Denied 22      
24 24 01-RC-21366 0 0 2001-06-18T00:00:00 Request for Review RRFIL 2001-06-27T00:00:00 Request Denied 22      
25 25 01-RC-21368 0 0 2001-12-14T00:00:00 Request for Review RRFIL 2002-03-22T00:00:00 Request Granted 25   2004-07-13T00:00:00 Decision and Order on Review 51
26 26 01-RC-21392 0 0 2001-08-30T00:00:00 Request for Review RRFIL 2001-09-13T00:00:00 Request Denied 22      
27 27 01-RC-21396 0 0 2001-09-18T00:00:00 Request for Review RRFIL 2001-09-26T00:00:00 Request Denied 22      
28 28 01-RC-21404 0 0 2001-09-28T00:00:00 Request for Review RRFIL 2001-10-16T00:00:00 Request Denied 22      
29 29 01-RC-21406 0 0 2001-10-17T00:00:00 Request for Review RRFIL 2001-10-31T00:00:00 Request Denied 22      
30 30 01-RC-21429 0 0 2001-12-07T00:00:00 Request for Review RRFIL 2002-04-12T00:00:00 Request Denied 22      
31 31 01-RC-21434 0 0 2001-12-12T00:00:00 Request for Review RRFIL 2001-12-19T00:00:00 Request Denied 22      
32 32 01-RC-21452 0 0 2002-04-12T00:00:00 Request for Review RRFIL 2002-10-11T00:00:00 Request Granted 25   2004-07-16T00:00:00 Miscellaneous Decisions and Orders 57
33 33 01-RC-21469 0 0 2002-03-14T00:00:00 Request for Review RRFIL 2002-03-27T00:00:00 Request Denied 22      
34 34 01-RC-21485 0 0 2002-06-07T00:00:00 Request for Review RRFIL 2002-06-19T00:00:00 Request Denied 22      
35 35 01-RC-21501 0 0 2002-06-25T00:00:00 Request for Review RRFIL 2002-07-10T00:00:00 Request Granted 25      
36 36 01-RC-21508 0 0 2002-07-17T00:00:00 Request for Review RRFIL 2002-07-30T00:00:00 Request Denied with Amendments 23      
37 37 01-RC-21520 0 0 2002-08-20T00:00:00 Request for Review RRFIL 2002-10-02T00:00:00 Request Denied 22      
38 38 01-RC-21526 0 0 2002-08-19T00:00:00 Request for Review RRFIL 2002-10-16T00:00:00 Request Denied 22      
39 39 01-RC-21555 0 0 2002-11-05T00:00:00 Request for Review RRFIL 2002-11-20T00:00:00 Request Denied 22      
40 40 01-RC-21570 0 0 2003-01-03T00:00:00 Request for Review RRFIL 2003-01-15T00:00:00 Request Withdrawn 29      
41 41 01-RC-21583 0 0 2003-01-22T00:00:00 Request for Review RRFIL 2003-02-05T00:00:00 Request Denied with Amendments 23      
42 42 01-RC-21586 0 0 2003-01-30T00:00:00 Request for Review RRFIL 2003-02-13T00:00:00 Request Denied 22      
43 43 01-RC-21608 0 0 2003-05-08T00:00:00 Request for Review RRFIL 2003-05-21T00:00:00 Request Denied with Amendments 23      
44 44 01-RC-21646 0 0 2003-07-17T00:00:00 Request for Review RRFIL 2003-07-30T00:00:00 Request Granted 25   2003-07-30T00:00:00 Decision and Order on Review 51
45 45 01-RC-21649 0 0 2003-09-05T00:00:00 Request for Review RRFIL 2003-10-31T00:00:00 Request Denied 22      
46 46 01-RC-21650 0 0 2003-09-05T00:00:00 Request for Review RRFIL 2003-10-31T00:00:00 Request Denied 22      
47 47 01-RC-21653 0 0 2003-07-31T00:00:00 Request for Review RRFIL          
48 48 01-RC-21655 0 0 2003-08-21T00:00:00 Request for Review RRFIL 2003-09-10T00:00:00 Request Denied 22      
49 49 01-RC-21658 0 0 2003-08-22T00:00:00 Request for Review RRFIL 2003-09-10T00:00:00 Request Denied with Amendments 23      
50 50 01-RC-21682 0 0 2003-11-21T00:00:00 Request for Review RRFIL          
51 51 01-RC-21704 0 0 2004-02-04T00:00:00 Request for Review RRFIL 2004-02-18T00:00:00 Request Granted 25   2006-09-30T00:00:00 Decision and Order Remanding to RD 55
52 52 01-RC-21877 0 0 2005-03-11T00:00:00 Request for Review RRFIL 2005-03-22T00:00:00 Request Denied 22      
53 53 01-RC-21878 0 0 2005-03-24T00:00:00 Request for Review RRFIL 2005-04-06T00:00:00 Request Denied 22      
54 54 01-RC-21908 0 0 2005-06-06T00:00:00 Request for Review RRFIL          
55 55 01-RC-21915 0 0 2005-06-17T00:00:00 Request for Review RRFIL 2005-07-20T00:00:00 Request Denied 22      
56 56 01-RC-21923 0 0 2005-09-26T00:00:00 Request for Review RRFIL 2005-10-12T00:00:00 Request Denied with Amendments 23      
57 57 01-RC-21924 0 0 2005-09-26T00:00:00 Request for Review RRFIL 2005-10-12T00:00:00 Request Denied with Amendments 23      
58 58 01-RC-21946 0 0 2005-09-23T00:00:00 Request for Review RRFIL 2005-10-06T00:00:00 Request Denied 22      
59 59 01-RC-21963 0 0 2005-12-22T00:00:00 Request for Review RRFIL 2006-01-05T00:00:00 Request Denied 22      
60 60 01-RC-21966 0 0 2006-02-14T00:00:00 Request for Review RRFIL 2006-03-23T00:00:00 Request Granted Partial / Other Denied 26   2006-03-23T00:00:00 Decision and Order on Review 51
61 61 01-RC-21975 0 0 2006-01-31T00:00:00 Request for Review RRFIL 2006-02-15T00:00:00 Request Denied 22      
62 62 01-RC-21996 0 0 2006-04-25T00:00:00 Request for Review RRFIL 2006-04-28T00:00:00 Request Withdrawn 29      
63 63 01-RC-22002 0 0 2006-05-22T00:00:00 Request for Review RRFIL 2006-06-02T00:00:00 Request Granted 25   2006-09-30T00:00:00 Decision and Order Remanding to RD 55
64 64 01-RC-22002 1 0 2007-01-05T00:00:00 Request for Review RRFIL 2007-04-11T00:00:00 Request Denied 22      
65 65 01-RC-22005 0 0 2006-05-23T00:00:00 Request for Review RRFIL 2006-06-21T00:00:00 Request Denied 22      
66 66 01-RC-22019 0 0 2006-05-30T00:00:00 Request for Review RRFIL 2006-08-18T00:00:00 Request Withdrawn 29      
67 67 01-RC-22028 0 0 2006-08-07T00:00:00 Request for Review RRFIL 2006-08-23T00:00:00 Request Denied 22      
68 68 01-RC-22034 0 0 2006-10-11T00:00:00 Request for Review RRFIL 2006-11-08T00:00:00 Request Denied 22      
69 69 01-RC-22035 0 0 2006-10-11T00:00:00 Request for Review RRFIL 2006-11-08T00:00:00 Request Denied 22      
70 70 01-RC-22044 0 0 2006-09-15T00:00:00 Request for Review RRFIL 2006-10-11T00:00:00 Request Granted 25   2007-02-20T00:00:00 Decision and Order on Review 51
71 71 01-RC-22061 0 0 2006-11-29T00:00:00 Request for Review RRFIL 2006-12-19T00:00:00 Request Denied 22      
72 72 01-RC-22116 0 0 2007-07-05T00:00:00 Request for Review RRFIL 2007-07-26T00:00:00 Request Denied 22      
73 73 01-RC-22133 0 0 2008-01-25T00:00:00 Request for Review RRFIL 2008-01-30T00:00:00 Request Untimely / Or Not Self Contained 28      
74 74 01-RC-22133 1 0 2008-02-06T00:00:00 Request for Review RRFIL 2008-03-13T00:00:00 Request Denied 22      
75 75 01-RC-22162 0 0 2008-01-30T00:00:00 Request for Review RRFIL 2008-03-13T00:00:00 Request Denied 22      
76 76 01-RC-22168 0 0 2008-04-10T00:00:00 Request for Review RRFIL 2008-06-27T00:00:00 Request Denied 22      
77 77 01-RC-22171 0 0 2008-02-19T00:00:00 Request for Review RRFIL 2008-02-26T00:00:00 Request Denied with Amendments 23      
78 78 01-RC-22235 0 0 2008-09-05T00:00:00 Request for Review RRFIL 2008-09-19T00:00:00 Request Denied 22      
79 79 01-RC-22275 0 0 2009-01-21T00:00:00 Request for Review RRFIL 2009-01-29T00:00:00 Request Untimely / Or Not Self Contained 28      
80 80 01-RC-22282 0 0 2008-12-30T00:00:00 Request for Review RRFIL 2009-01-15T00:00:00 Request Denied 22      
81 81 01-RC-22296 0 0 2009-03-18T00:00:00 Request for Review RRFIL 2009-04-09T00:00:00 Request Denied 22      
82 82 01-RC-22338 0 0 2009-08-05T00:00:00 Request for Review RRFIL          
83 83 01-RC-22359 0 0 2009-09-28T00:00:00 Request for Review RRFIL          
84 84 01-RC-22375 0 0 2009-11-13T00:00:00 Request for Review RRFIL 2010-01-14T00:00:00 Request Denied 22      
85 85 01-RC-22389 0 0 2010-01-22T00:00:00 Request for Review RRFIL 2010-04-28T00:00:00 Request Denied 22      
86 86 01-RC-22447 0 0 2010-05-27T00:00:00 Request for Review RRFIL 2010-08-27T00:00:00 Request Granted 25   2010-08-27T00:00:00 Decision and Order on Review 51
87 87 01-RC-22474 0 0 2010-10-01T00:00:00 Request for Review RRFIL 2010-11-10T00:00:00 Request Denied 22      
88 88 01-RD-01919 0 0 2000-04-19T00:00:00 Request for Review RRFIL 2000-07-26T00:00:00 Request Denied 22      
89 89 01-RD-01969 0 0 2002-05-22T00:00:00 Request for Review RRFIL 2002-07-10T00:00:00 Request Denied 22      
90 90 01-RD-01987 0 0 2003-06-25T00:00:00 Request for Review RRFIL 2004-08-17T00:00:00 Request Granted 25   2007-01-31T00:00:00 Decision and Order Remanding to RD 55
91 91 01-RD-02003 0 0 2003-10-16T00:00:00 Request for Review RRFIL 2004-09-08T00:00:00 Request Denied/Amendments/Remanded 24      
92 92 01-RD-02003 1 0           2004-07-08T00:00:00 Decision and Order Remanding to RD 55
93 93 01-RD-02003 2 0 2004-11-16T00:00:00 Request for Review RRFIL 2004-12-29T00:00:00 Request Withdrawn 29      
94 94 01-RD-02076 0 0 2006-02-06T00:00:00 Request for Review RRFIL 2006-03-08T00:00:00 Request Denied 22      
95 95 01-RD-02102 0 0 2007-09-10T00:00:00 Request for Review RRFIL          
96 96 01-RD-02102 1 0           2007-09-26T00:00:00 Decision and Order on Review 51
97 97 01-RD-02144 0 0 2010-08-30T00:00:00 Request for Review RRFIL          
98 98 01-RM-01264 0 0 2004-03-30T00:00:00 Request for Review RRFIL 2004-06-09T00:00:00 Request Denied 22      
99 99 01-RM-01267 0 0 2004-05-14T00:00:00 Request for Review RRFIL          
100 100 01-RM-01267 1 0           2004-12-08T00:00:00 Decision and Order on Review 51

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "r_pre_elect_board_act" (
    "r_case_number" text,
    "action_sequence" integer,
    "recurrence" integer,
    "received_date" text,
    "received_reason" text,
    "ruling_decision_date" text,
    "ruling_action_code" integer,
    "exception_withdrawn_date" integer,
    "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])
);