r_pre_elect_rd_decision

10,280 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ 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
1 1 01-AC-00094 A 0 0             2001-08-02T00:00:00 Decision and Order DecOr           2001-08-16T00:00:00
2 2 01-AC-00096 A 0 0             2002-06-12T00:00:00 Amendment of Certification AmdCe            
3 3 01-AC-00097 A 0 0             2003-11-05T00:00:00 Amendment of Certification AmdCe           2003-11-19T00:00:00
4 4 01-AC-00098 A 0 0             2007-09-06T00:00:00 Decision and Order DecOr           2007-09-20T00:00:00
5 5 01-AC-00101 A 0 0             2010-08-18T00:00:00 Amendment of Certification AmdCe           2010-09-01T00:00:00
6 6 01-AC-00102 A 0 0             2010-08-18T00:00:00 Amendment of Certification AmdCe           2010-09-01T00:00:00
7 7 01-RC-19536 A 0 0             1991-05-24T00:00:00 Direction of Election DirEl            
8 8 01-RC-19926 A 0 0         Employer EMP 1993-03-25T00:00:00 1993-04-23T00:00:00 Direction of Election DirEl         1993-03-10T00:00:00  
9 9 01-RC-19926 A 0 1         Petitioner PET 1993-03-25T00:00:00 1996-11-21T00:00:00 Direction of Election DirEl            
10 10 01-RC-20080 A 0 0         Petitioner PET 1994-02-11T00:00:00 1994-03-11T00:00:00 Direction of Election DirEl         1994-02-11T00:00:00  
11 11 01-RC-20080 A 0 1         Employer EMP 1994-02-14T00:00:00                
12 12 01-RC-20106 A 0 0         Employer EMP 1994-04-07T00:00:00 1994-06-08T00:00:00 Decision and Order DecOr         1994-04-07T00:00:00  
13 13 01-RC-20106 A 0 1         Petitioner PET 1994-04-07T00:00:00                
14 14 01-RC-20309 A 0 0         Employer EMP 1995-08-09T00:00:00 1995-09-01T00:00:00 Direction of Election DirEl         1995-08-09T00:00:00 1995-09-15T00:00:00
15 15 01-RC-20309 A 0 1         Petitioner PET 1995-08-09T00:00:00 1995-09-01T00:00:00              
16 16 01-RC-20310 A 0 0         Employer EMP 1995-08-09T00:00:00 1995-09-01T00:00:00 Direction of Election DirEl         1995-08-09T00:00:00 1995-09-15T00:00:00
17 17 01-RC-20310 A 0 1         Petitioner PET 1995-08-09T00:00:00                
18 18 01-RC-20463 A 0 0         Employer EMP 1996-06-17T00:00:00 1996-06-26T00:00:00 Direction of Election DirEl         1996-06-17T00:00:00 1999-07-09T00:00:00
19 19 01-RC-20508 A 0 0         Employer EMP 1996-10-10T00:00:00 1996-11-07T00:00:00 Direction of Election DirEl         1996-10-10T00:00:00  
20 20 01-RC-20508 A 0 1         Petitioner PET 1996-10-10T00:00:00                
21 21 01-RC-20574 A 0 0 Granted to Requested Date Grant Employer EMP 1997-08-17T00:00:00 1997-08-27T00:00:00 Employer EMP 1997-08-27T00:00:00 1997-10-17T00:00:00 Order Dismissing Dismi         1997-08-18T00:00:00 1997-10-31T00:00:00
22 22 01-RC-20574 A 0 1         Petitioner PET 1997-08-27T00:00:00                
23 23 01-RC-20761 A 0 0 Granted to Requested Date Grant   1998-02-23T00:00:00 1998-03-03T00:00:00 Employer EMP 1998-03-03T00:00:00 1998-03-19T00:00:00 Direction of Election DirEl         1998-02-25T00:00:00  
24 24 01-RC-20761 A 0 1         Petitioner PET 1998-03-03T00:00:00                
25 25 01-RC-20804 A 0 0         Employer EMP 1998-04-27T00:00:00 1998-05-21T00:00:00 Direction of Election DirEl         1998-04-27T00:00:00 1998-06-04T00:00:00
26 26 01-RC-20804 A 0 1         Petitioner PET 1998-04-27T00:00:00                
27 27 01-RC-20905 A 0 0         Petitioner PET 1998-10-23T00:00:00 1998-11-10T00:00:00 Direction of Election DirEl         1998-10-23T00:00:00 1998-11-24T00:00:00
28 28 01-RC-20914 A 0 0 Granted to Requested Date Grant Employer EMP 1998-11-18T00:00:00 1998-11-18T00:00:00 Employer EMP 1998-12-02T00:00:00 1998-12-21T00:00:00 Direction of Election DirEl         1998-11-23T00:00:00 1999-01-04T00:00:00
29 29 01-RC-20914 A 0 1         Petitioner PET 1998-12-02T00:00:00             1998-12-02T00:00:00  
30 30 01-RC-20915 A 0 0 Granted to Requested Date Grant Employer EMP 1998-11-18T00:00:00 1998-11-18T00:00:00 Employer EMP 1998-12-02T00:00:00 1998-12-21T00:00:00 Direction of Election DirEl         1998-11-23T00:00:00 1999-01-04T00:00:00
31 31 01-RC-20915 A 0 1         Petitioner PET 1998-12-02T00:00:00             1998-12-02T00:00:00  
32 32 01-RC-20921 A 0 0         Employer EMP 1998-11-25T00:00:00 1998-12-15T00:00:00 Direction of Election DirEl         1998-11-23T00:00:00 1998-12-29T00:00:00
33 33 01-RC-20921 A 0 1         Petitioner PET 1998-11-25T00:00:00             1998-11-25T00:00:00  
34 34 01-RC-20925 A 0 0         Employer EMP 1998-11-30T00:00:00 1998-12-11T00:00:00 Direction of Election DirEl         1998-11-30T00:00:00 1998-12-27T00:00:00
35 35 01-RC-20927 A 0 0         Petitioner PET 1998-12-02T00:00:00 1998-12-24T00:00:00 Direction of Election DirEl         1998-12-02T00:00:00 1999-01-07T00:00:00
36 36 01-RC-20940 A 0 0         Employer EMP 1999-01-20T00:00:00 1999-02-12T00:00:00 Direction of Election DirEl         1998-12-28T00:00:00 1999-02-26T00:00:00
37 37 01-RC-20940 A 0 1         Petitioner PET 1999-01-20T00:00:00                
38 38 01-RC-20945 A 0 0         Employer EMP 1998-12-28T00:00:00 1998-12-31T00:00:00 Direction of Election DirEl         1998-12-28T00:00:00 1999-01-14T00:00:00
39 39 01-RC-20945 A 0 1         Petitioner PET 1998-12-28T00:00:00                
40 40 01-RC-20947 A 0 0 Granted to Requested Date Grant   1998-12-27T00:00:00 1999-01-05T00:00:00 Employer EMP 1999-01-05T00:00:00 1999-01-14T00:00:00 Direction of Election DirEl         1998-12-28T00:00:00 1999-01-28T00:00:00
41 41 01-RC-20947 A 0 1         Petitioner PET 1999-01-05T00:00:00                
42 42 01-RC-20957 A 0 0             1999-01-13T00:00:00 Direction of Election DirEl            
43 43 01-RC-20958 A 0 0 Granted to Another Date GrntA Employer EMP 1999-01-08T00:00:00 1999-01-08T00:00:00 Petitioner PET 1999-01-15T00:00:00 1999-01-28T00:00:00 Direction of Election DirEl         1999-01-12T00:00:00 1999-02-11T00:00:00
44 44 01-RC-20958 A 0 1         Employer EMP 1999-01-15T00:00:00             1999-01-15T00:00:00  
45 45 01-RC-20960 A 0 0 Granted to Another Date GrntA Employer EMP 1999-01-21T00:00:00 1999-01-22T00:00:00 Employer EMP 1999-01-29T00:00:00 1999-02-02T00:00:00 Direction of Election DirEl         1999-01-27T00:00:00 1999-02-16T00:00:00
46 46 01-RC-20960 A 0 1         Petitioner PET 1999-01-29T00:00:00             1999-01-29T00:00:00  
47 47 01-RC-20968 A 0 0         Employer EMP 1999-02-18T00:00:00 1999-03-04T00:00:00 Direction of Election DirEl         1999-02-18T00:00:00 1999-03-18T00:00:00
48 48 01-RC-20968 A 0 1         Petitioner PET 1999-02-18T00:00:00                
49 49 01-RC-20969 A 0 0 Granted to Requested Date Grant Employer EMP 1999-02-23T00:00:00 1999-02-23T00:00:00 Employer EMP 1999-03-01T00:00:00 1999-03-19T00:00:00 Direction of Election DirEl         1999-02-26T00:00:00 1999-04-02T00:00:00
50 50 01-RC-20969 A 0 1         Petitioner PET 1999-03-01T00:00:00             1999-03-01T00:00:00  
51 51 01-RC-20970 A 0 0 Granted to Another Date GrntA Employer EMP 1999-03-05T00:00:00 1999-03-05T00:00:00 Employer EMP 1999-03-10T00:00:00 1999-03-18T00:00:00 Direction of Election DirEl         1999-03-08T00:00:00 1999-04-01T00:00:00
52 52 01-RC-20970 A 0 1         Petitioner PET 1999-03-10T00:00:00             1999-03-10T00:00:00  
53 53 01-RC-20971 A 0 0 Granted to Requested Date Grant Employer EMP 1999-02-22T00:00:00 1999-02-22T00:00:00 Employer EMP 1999-03-03T00:00:00 1999-03-19T00:00:00 Direction of Election DirEl         1999-03-03T00:00:00 1999-04-02T00:00:00
54 54 01-RC-20975 A 0 0         Employer EMP 1999-03-10T00:00:00 1999-03-15T00:00:00 Decision and Order DecOr         1999-03-10T00:00:00  
55 55 01-RC-20983 A 0 0             1999-03-25T00:00:00 Direction of Election DirEl         1999-03-22T00:00:00 1999-04-08T00:00:00
56 56 01-RC-20984 A 0 0         Employer EMP 1999-04-06T00:00:00 1999-04-21T00:00:00 Direction of Election DirEl         1999-04-06T00:00:00 1999-05-05T00:00:00
57 57 01-RC-20984 A 0 1         Petitioner PET 1999-04-06T00:00:00                
58 58 01-RC-20984 A 1 0 Granted to Requested Date Grant Employer EMP 2002-03-05T00:00:00 2002-03-05T00:00:00 Employer EMP 2002-03-11T00:00:00 2002-05-22T00:00:00 Decision and Order DecOr         2002-03-26T00:00:00 2002-06-05T00:00:00
59 59 01-RC-20984 A 1 1         Petitioner PET 2002-03-26T00:00:00                
60 60 01-RC-20984 A 1 2         Employer EMP 2002-03-27T00:00:00                
61 61 01-RC-20985 A 0 0 Granted to Another Date GrntA Employer EMP 1999-04-01T00:00:00 1999-04-01T00:00:00 Petitioner PET 1999-04-07T00:00:00 1999-04-27T00:00:00 Direction of Election DirEl         1999-04-06T00:00:00 1999-05-11T00:00:00
62 62 01-RC-20985 A 0 1         Employer EMP 1999-04-08T00:00:00             1999-04-08T00:00:00  
63 63 01-RC-21011 A 0 0 Granted to Another Date GrntA Petitioner PET 1999-05-13T00:00:00 1999-05-13T00:00:00 Petitioner PET 1999-05-26T00:00:00 1999-06-03T00:00:00 Direction of Election DirEl         1999-05-17T00:00:00 1999-06-17T00:00:00
64 64 01-RC-21011 A 0 1         Employer EMP 1999-05-26T00:00:00             1999-05-26T00:00:00  
65 65 01-RC-21012 A 0 0         Employer EMP 1999-05-19T00:00:00 1999-05-21T00:00:00 Direction of Election DirEl         1999-05-19T00:00:00 1999-06-04T00:00:00
66 66 01-RC-21014 A 0 0 Granted to Another Date GrntA Employer EMP 1999-05-21T00:00:00 1999-05-21T00:00:00 Employer EMP 1999-05-28T00:00:00 1999-06-02T00:00:00 Direction of Election DirEl         1999-05-24T00:00:00 1999-06-16T00:00:00
67 67 01-RC-21014 A 0 1                         1999-05-28T00:00:00  
68 68 01-RC-21020 A 0 0             1999-06-22T00:00:00 Direction of Election DirEl         1999-06-11T00:00:00  
69 69 01-RC-21026 A 0 0         Petitioner PET 1999-06-30T00:00:00 1999-07-06T00:00:00 Direction of Election DirEl         1999-06-28T00:00:00 1999-07-20T00:00:00
70 70 01-RC-21029 A 0 0         Petitioner PET 1999-06-23T00:00:00             1999-06-24T00:00:00  
71 71 01-RC-21029 A 0 1         Employer EMP 1999-06-24T00:00:00                
72 72 01-RC-21037 A 0 0         Employer EMP 1999-07-20T00:00:00 1999-07-30T00:00:00 Direction of Election DirEl         1999-07-20T00:00:00  
73 73 01-RC-21044 A 0 0             1999-08-27T00:00:00 Direction of Election DirEl            
74 74 01-RC-21078 A 0 0         Petitioner PET 1999-09-28T00:00:00 1999-10-15T00:00:00 Direction of Election DirEl         1999-09-29T00:00:00 1999-10-29T00:00:00
75 75 01-RC-21092 A 0 0             1999-10-27T00:00:00 Direction of Election DirEl           1999-11-10T00:00:00
76 76 01-RC-21097 A 0 0         Petitioner PET 1999-11-08T00:00:00 1999-11-22T00:00:00 Direction of Election DirEl         1999-11-04T00:00:00  
77 77 01-RC-21097 A 0 1         Employer EMP 1999-11-08T00:00:00 1999-11-22T00:00:00 Direction of Election DirEl           1999-12-06T00:00:00
78 78 01-RC-21098 A 0 0         Employer EMP 1999-11-17T00:00:00 1999-12-02T00:00:00 Direction of Election DirEl         1999-11-12T00:00:00 1999-12-16T00:00:00
79 79 01-RC-21098 A 0 1         Petitioner PET 1999-11-17T00:00:00 1999-12-02T00:00:00 Direction of Election DirEl           1999-12-06T00:00:00
80 80 01-RC-21102 A 0 0             2000-02-02T00:00:00 Direction of Election DirEl           2000-02-16T00:00:00
81 81 01-RC-21128 A 0 0 Granted to Requested Date Grant Employer EMP 2000-01-21T00:00:00 2000-02-04T00:00:00 Employer EMP 2000-02-04T00:00:00 2000-02-10T00:00:00 Decision and Order DecOr         2000-01-28T00:00:00 2000-02-24T00:00:00
82 82 01-RC-21128 A 0 1 Granted to Requested Date Grant Petitioner PET 2000-01-21T00:00:00 2000-02-04T00:00:00 Petitioner PET 2000-02-08T00:00:00             2000-02-04T00:00:00  
83 83 01-RC-21130 A 0 0 Granted to Requested Date Grant Employer EMP 2000-02-17T00:00:00 2000-02-23T00:00:00 Employer EMP 2000-02-24T00:00:00 2000-02-25T00:00:00 Direction of Election DirEl         2000-02-17T00:00:00 2000-03-10T00:00:00
84 84 01-RC-21130 A 0 1         Petitioner PET 2000-02-24T00:00:00             2000-02-23T00:00:00  
85 85 01-RC-21131 A 0 0 Granted to Requested Date Grant Employer EMP 2000-01-31T00:00:00 2000-02-04T00:00:00 Employer EMP 2000-02-04T00:00:00 2000-02-16T00:00:00 Direction of Election DirEl         2000-01-31T00:00:00 2000-03-01T00:00:00
86 86 01-RC-21131 A 0 1         Petitioner PET 2000-02-04T00:00:00             2000-02-04T00:00:00  
87 87 01-RC-21135 A 0 0 Granted to Requested Date Grant Employer EMP 2000-02-15T00:00:00 2000-02-18T00:00:00 Employer EMP 2000-02-18T00:00:00 2000-03-02T00:00:00 Direction of Election DirEl         2000-02-15T00:00:00 2000-03-16T00:00:00
88 88 01-RC-21135 A 0 1         Petitioner PET 2000-02-18T00:00:00             2000-02-18T00:00:00  
89 89 01-RC-21138 A 0 0             2000-02-11T00:00:00 Direction of Election DirEl           2000-02-25T00:00:00
90 90 01-RC-21160 A 0 0         Employer EMP 2000-04-05T00:00:00 2000-04-21T00:00:00 Direction of Election DirEl         2000-04-05T00:00:00  
91 91 01-RC-21163 A 0 0             2000-04-19T00:00:00 Direction of Election DirEl 2000-04-24T00:00:00 Employer EMP Denied Deny 2000-05-18T00:00:00 2000-04-07T00:00:00 2000-05-03T00:00:00
92 92 01-RC-21185 A 0 0         Petitioner PET 2000-05-15T00:00:00 2000-05-16T00:00:00 Direction of Election DirEl         2000-05-15T00:00:00 2000-05-30T00:00:00
93 93 01-RC-21185 A 0 1         Employer EMP 2000-05-15T00:00:00                
94 94 01-RC-21188 A 0 0         Petitioner PET 2000-05-17T00:00:00 2000-05-23T00:00:00 Direction of Election DirEl         2000-05-17T00:00:00 2000-06-03T00:00:00
95 95 01-RC-21189 A 0 0             2000-06-01T00:00:00 Decision and Order DecOr         2000-05-17T00:00:00 2000-06-15T00:00:00
96 96 01-RC-21192 A 0 0         Employer EMP 2000-06-06T00:00:00 2000-06-14T00:00:00 Direction of Election DirEl         2000-06-06T00:00:00 2000-06-28T00:00:00
97 97 01-RC-21195 A 0 0         Employer EMP 2000-06-13T00:00:00 2000-06-23T00:00:00 Direction of Election DirEl         2000-06-13T00:00:00 2000-07-07T00:00:00
98 98 01-RC-21199 A 0 0 Granted to Requested Date Grant Employer EMP 2000-07-07T00:00:00 2000-07-07T00:00:00 Petitioner PET 2000-07-10T00:00:00 2000-08-03T00:00:00 Direction of Election DirEl         2000-07-11T00:00:00 2000-08-17T00:00:00
99 99 01-RC-21199 A 0 1         Employer EMP 2000-07-10T00:00:00                
100 100 01-RC-21202 A 0 0         Petitioner PET 2000-07-10T00:00:00 2000-07-13T00:00:00 Direction of Election DirEl         2000-07-07T00:00:00 2000-07-27T00:00:00

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "r_pre_elect_rd_decision" (
    "r_case_number" text,
    "unit_id" text,
    "action_sequence" integer,
    "recurrence" integer,
    "determination_eot" text,
    "eot_party" text,
    "eot_filed_date" text,
    "eot_deter_brief_date" text,
    "brief_rcvd_party" text,
    "pre_election_brief_rcvd" text,
    "rd_decision_issued_date" text,
    "rd_decision_type" text,
    "recon_request_filed" text,
    "recon_request_party" text,
    "rd_recon_deter" text,
    "rd_recon_deter_date" text,
    "brief_due_date" text,
    "review_due_date" text,
    FOREIGN KEY (r_case_number, unit_id) REFERENCES r_bargaining_unit (r_case_number, unit_id),
    FOREIGN KEY ([brief_rcvd_party]) REFERENCES[l_case_party] ([party]),
    FOREIGN KEY ([eot_party]) REFERENCES[l_case_party] ([party]),
    FOREIGN KEY ([recon_request_party]) REFERENCES[l_case_party] ([party]),
    FOREIGN KEY ([determination_eot]) REFERENCES[l_r_preelec_det_eot] ([determination_eot]),
    FOREIGN KEY ([rd_decision_type]) REFERENCES[l_r_preelec_rd_dec_type] ([rd_decision_type]),
    FOREIGN KEY ([rd_recon_deter]) REFERENCES[l_r_preelec_rd_recon] ([rd_reconsider_deter])
);