r_challenge_issue

6,948 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ election_id sequence challenge_party challenge_issue number challenge_action challenge_result
1 1 01-00026 0 Petitioner PET Other Reasons 13 4 Initial 0  
2 2 01-00026 1 Board NLRB Not on List 10 2 Initial 0  
3 3 01-00026 2 Petitioner PET Supervisor 21 1 Initial 0  
4 4 01-00034 0 Employer EMP Supervisor 21 2 Hearing Officer's Report 10000 Eligible 10003
5 5 01-00034 1 Petitioner PET Supervisor 21 2 Hearing Officer's Report 10000 Eligible 10003
6 6 01-00034 2 Board NLRB Not on List 10 2 Hearing Officer's Report 10000 Ineligible 10002
7 7 01-00034 3 Board NLRB Not on List 10 1 Hearing Officer's Report 10000 Eligible 10003
8 8 01-00044 0 Employer EMP Not Employed during Elig.Period - No ULP 8 2 Rept.on Chall. & Obj.,w/o Notice of Hrg. 10003  
9 9 01-00044 1 Petitioner PET Other Reasons 13 4 Rept.on Chall. & Obj.,w/o Notice of Hrg. 10003  
10 10 01-00044 2 Board NLRB Not on List 10 2 Rept.on Chall. & Obj.,w/o Notice of Hrg. 10003  
11 11 01-00045 0 Petitioner PET Other Reasons 13 1 Initial 0 Initial 1
12 12 01-00045 1 Petitioner PET Managerial 7 1 Initial 0 Initial 1
13 13 01-00045 2 Board NLRB Other Reasons 13 1 Hearing Officer's Report 10000 Ineligible 10002
14 14 01-00045 3 Board NLRB Managerial 7 1 Hearing Officer's Report 10000 Ineligible 10002
15 15 01-00046 0 Employer EMP Not Employed during Elig.Period - No ULP 8 3    
16 16 01-00046 1 Board NLRB Not on List 10 4    
17 17 01-00046 2 Board NLRB Other Reasons 13 1    
18 18 01-00048 0 Employer EMP Discriminatee - ULP Issues 4 1 Rept. on Chall., w/o Notice of Hrg. 10001 Ineligible 10012
19 19 01-00048 1 Employer EMP Not on List 10 1 Initial 0 Initial 1
20 20 01-00071 0 Employer EMP Not Employed during Elig.Period - No ULP 8 1 Initial 0 Initial 1
21 21 01-00071 1 Board NLRB Not on List 10 2 Initial 0 Initial 1
22 22 01-00071 2 Union Involved UNIN Student 17 5 Initial 0 Initial 1
23 23 01-00071 3 Union Involved UNIN Other Reasons 13 1 Initial 0 Initial 1
24 24 01-00071 4 Employer EMP Not Employed during Elig.Period - No ULP 8 1 Approval of Stipulation on Chall. 10013 Unresolved 10133
25 25 01-00071 5 Board NLRB Not on List 10 2 Approval of Stipulation on Chall. 10013 Unresolved 10133
26 26 01-00071 6 Union Involved UNIN Student 17 5 Approval of Stipulation on Chall. 10013 Unresolved 10133
27 27 01-00071 7 Union Involved UNIN Other Reasons 13 1 Approval of Stipulation on Chall. 10013 Unresolved 10133
28 28 01-00117 0 Board NLRB Not on List 10 2 Initial 0  
29 29 01-00190 0 Petitioner PET Supervisor 21 2 Initial 0 Initial 1
30 30 01-00190 1 Petitioner PET Supervisor 21 2 Hearing Officer's Report 10000 Unresolved 10004
31 31 01-00191 0 Petitioner PET Supervisor 21 2 Initial 0 Initial 1
32 32 01-00191 1 Petitioner PET Supervisor 21 2 Hearing Officer's Report 10000 Unresolved 10004
33 33 01-00221 0 Union Involved UNIN Not on List 10 2 Initial 0 Initial 1
34 34 01-00222 0 Union Involved UNIN Managerial 7 2 Initial 0 Initial 1
35 35 01-00222 1 Union Involved UNIN Other Reasons 13 2 Initial 0 Initial 1
36 36 01-00222 2 Board NLRB Not on List 10 1 Initial 0 Initial 1
37 37 01-00222 3 Employer EMP Community of Interests 3 1 Initial 0 Initial 1
38 38 01-00231 0 Employer EMP Not on List 10 1 Initial 0 Initial 1
39 39 01-00231 1 Petitioner PET Supervisor 21 1 Initial 0 Initial 1
40 40 01-00231 2 Employer EMP Not on List 10 1 Approval of Withdrawal of Chall. 10016 Withdrawn 10161
41 41 01-00231 3 Petitioner PET Supervisor 21 1 Approval of Withdrawal of Chall. 10016 Withdrawn 10161
42 42 01-00237 0 Union Involved UNIN Other Reasons 13 1 Initial 0 Initial 1
43 43 01-00237 1 Board NLRB Not on List 10 1 Initial 0 Initial 1
44 44 01-00237 2 Board NLRB Not on List 10 1 Approval of Withdrawal of Chall. 10016 Withdrawn 10161
45 45 01-00237 3 Union Involved UNIN Other Reasons 13 1 Approval of Withdrawal of Chall. 10016 Withdrawn 10161
46 46 01-00247 0 Union Involved UNIN Managerial 7 1 Initial 0 Initial 1
47 47 01-00247 1 Union Involved UNIN Other Reasons 13 2 Initial 0 Initial 1
48 48 01-00247 2 Union Involved UNIN Managerial 7 1 Rept. on Chall., w/o Notice of Hrg. 10001 Ineligible 10012
49 49 01-00247 3 Union Involved UNIN Other Reasons 13 2 Rept. on Chall., w/o Notice of Hrg. 10001 Ineligible 10012
50 50 01-00266 0 Petitioner PET Supervisor 21 1 Initial 0 Initial 1
51 51 01-00266 1 Board NLRB Not on List 10 1 Initial 0 Initial 1
52 52 01-00302 0 Board NLRB Not on List 10 1 Initial 0 Initial 1
53 53 01-00313 0 Union Involved UNIN Not Employed during Elig.Period - No ULP 8 1 Initial 0 Initial 1
54 54 01-00313 1 Board NLRB Not on List 10 14 Initial 0 Initial 1
55 55 01-00322 0 Petitioner PET Casual, Extra, Temporary or Intermittent 1 1 Initial 0  
56 56 01-00322 1 Petitioner PET Not Employed during Elig.Period - No ULP 8 1 Initial 0  
57 57 01-00322 2 Board NLRB Not on List 10 1 Initial 0  
58 58 01-00336 0 Petitioner PET Supervisor 21 1 Rept. on Chall. & Notice of Hrg. 10002 Hearing directed 10025
59 59 01-00336 1 Petitioner PET Other Reasons 13 2 Rept. on Chall. & Notice of Hrg. 10002 Hearing directed 10025
60 60 01-00355 0 Board NLRB Not on List 10 7 Initial 0 Initial 1
61 61 01-00355 1 Board NLRB Not on List 10 2 Approval of Stipulation on Chall. 10013 Eligible 10132
62 62 01-00355 2 Board NLRB Not on List 10 5 Approval of Stipulation on Chall. 10013 Ineligible 10131
63 63 01-00356 0 Employer EMP Not Employed during Elig.Period - No ULP 8 1 Initial 0 Initial 1
64 64 01-00356 1 Employer EMP Supervisor 21 1 Initial 0 Initial 1
65 65 01-00356 2 Petitioner PET Not Employed during Elig.Period - No ULP 8 1 Initial 0 Initial 1
66 66 01-00356 3 Petitioner PET Not in Unit 23 1 Initial 0 Initial 1
67 67 01-00356 4 Board NLRB Not on List 10 3 Initial 0 Initial 1
68 68 01-00388 0 Employer EMP Not Employed during Elig.Period - No ULP 8 1 Initial 0 Initial 1
69 69 01-00388 1 Employer EMP Casual, Extra, Temporary or Intermittent 1 2 Initial 0 Initial 1
70 70 01-00388 2 Union Involved UNIN Managerial 7 1 Initial 0 Initial 1
71 71 01-00388 3 Union Involved UNIN Other Reasons 13 1 Initial 0 Initial 1
72 72 01-00388 4 Board NLRB Not on List 10 11 Initial 0 Initial 1
73 73 01-00400 0 Board NLRB Not on List 10 3 Initial 0 Initial 1
74 74 01-00400 1 Union Involved UNIN Not Employed during Elig.Period - No ULP 8 4 Initial 0 Initial 1
75 75 01-00417 0 Petitioner PET Not on List 10 1 Initial 0 Initial 1
76 76 01-00423 0 Employer EMP Not Employed during Elig.Period - No ULP 8 1 Initial 0 Initial 1
77 77 01-00423 1 Employer EMP Casual, Extra, Temporary or Intermittent 1 1 Initial 0 Initial 1
78 78 01-00423 2 Petitioner PET Casual, Extra, Temporary or Intermittent 1 1 Initial 0 Initial 1
79 79 01-00423 3 Board NLRB Not on List 10 1 Initial 0 Initial 1
80 80 01-00439 0 Petitioner PET Probationary 14 4 Initial 0 Initial 1
81 81 01-00439 1 Board NLRB Not on List 10 1 Initial 0 Initial 1
82 82 01-00448 0 Board NLRB Not on List 10 5 Initial 0 Initial 1
83 83 01-00450 0 Employer EMP Not Employed during Elig.Period-ULPfiled 9 2 Initial 0 Initial 1
84 84 01-00450 1 Board NLRB Not on List 10 1 Initial 0 Initial 1
85 85 01-00500 0 Board NLRB Not on List 10 4 Initial 0 Initial 1
86 86 01-00500 1 Board NLRB Not on List 10 2 Approval of Stipulation on Chall. 10013 Ineligible 10131
87 87 01-00500 2 Board NLRB Not on List 10 2 Approval of Stipulation on Chall. 10013 Unresolved 10133
88 88 01-00502 0 Board NLRB Not on List 10 1 Initial 0 Initial 1
89 89 01-00535 0 Petitioner PET Supervisor 21 1 Initial 0 Initial 1
90 90 01-00547 0 Union Involved UNIN Not in Unit 23 1 Initial 0 Initial 1
91 91 01-00547 1 Union Involved UNIN Supervisor 21 3 Initial 0 Initial 1
92 92 01-00547 2 Union Involved UNIN Not on List 10 1 Approval of Withdrawal of Chall. 10016 Withdrawn 10161
93 93 01-00547 3 Union Involved UNIN Supervisor 21 3 Approval of Withdrawal of Chall. 10016 Withdrawn 10161
94 94 01-00552 0 Employer EMP Not Employed during Elig.Period - No ULP 8 1 Initial 0 Initial 1
95 95 01-00552 1 Board NLRB Not on List 10 1 Initial 0 Initial 1
96 96 01-00552 2 Petitioner PET Supervisor 21 1 Initial 0 Initial 1
97 97 01-00552 3 Employer EMP Not Employed during Elig.Period - No ULP 8 1 Rept.on Chall. & Obj.,w/o Notice of Hrg. 10003 Ineligible 10032
98 98 01-00552 4 Board NLRB Not on List 10 1 Rept.on Chall. & Obj.,w/o Notice of Hrg. 10003 Ineligible 10032
99 99 01-00552 5 Petitioner PET Supervisor 21 1 Rept.on Chall. & Obj.,w/o Notice of Hrg. 10003 Unresolved 10034
100 100 01-00555 0 Employer EMP Supervisor 21 2 Initial 0 Initial 1

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "r_challenge_issue" (
    "election_id" text,
    "sequence" integer,
    "challenge_party" text,
    "challenge_issue" integer,
    "number" integer,
    "challenge_action" integer,
    "challenge_result" integer,
    FOREIGN KEY (election_id) REFERENCES r_election (election_id),
    FOREIGN KEY ([challenge_party]) REFERENCES[l_case_party] ([party]),
    FOREIGN KEY ([challenge_issue]) REFERENCES[l_r_challenge_issue] ([challenge_issue]),
    FOREIGN KEY ([challenge_action]) REFERENCES[l_r_challenge_act_type] ([challenge_action]),
    FOREIGN KEY ([challenge_result]) REFERENCES[l_r_challenge_act_result] ([challenge_result])
);