r_objection_issue

37,264 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ election_id sequence objection_issue_date objection_party objection_issue objection_action objection_result
1 1 01-00001 0 1996-07-12T00:00:00 Petitioner PET Other Conduct OI013 Initial 0 Filed 1
2 2 01-00001 1 2001-01-10T00:00:00 Petitioner PET Other Conduct OI013 Approval of Withdrawal of Obj. 10018 Withdrawn 10181
3 3 01-00002 0 1997-08-26T00:00:00 Employer EMP Other Conduct OI013 Initial 0 Filed 1
4 4 01-00026 0 1998-12-16T00:00:00 Petitioner PET Other Conduct OI013 Initial 0 Filed 1
5 5 01-00026 1 1998-12-30T00:00:00 Petitioner PET Other Conduct OI013 Rept. on Chall. & Obj. & Notice of Hrg. 10004 Hearing directed 10044
6 6 01-00026 2 1999-01-11T00:00:00 Petitioner PET Other Conduct OI013 Approval of Withdrawal of Obj. 10018 Withdrawn 10181
7 7 01-00029 0 1998-12-07T00:00:00 Employer EMP Board Agent Conduct OI003 Initial 0 Filed 1
8 8 01-00029 1 1998-12-07T00:00:00 Employer EMP Board Agent Conduct OI003 Initial 0 Filed 1
9 9 01-00029 2 1999-01-04T00:00:00   Board Agent Conduct OI003 Rept. on Obj., w/o Notice of Hrg. 10005 Overruled 10053
10 10 01-00034 0 1998-12-14T00:00:00 Petitioner PET Other Conduct OI013 Rept. on Obj. & Notice of Hrg. 10006 Overruled 10063
11 11 01-00034 1 1998-12-10T00:00:00 Petitioner PET Other Conduct OI013 Initial 0 Filed 1
12 12 01-00040 0 1998-09-16T00:00:00 Petitioner PET Other Conduct OI013 Initial 0 Filed 1
13 13 01-00040 1 1999-03-23T00:00:00 Union Involved UNIN Other Conduct OI013 Approval of Withdrawal of Obj. 10018 Withdrawn 10181
14 14 01-00044 0 1995-06-06T00:00:00 Petitioner PET Other Conduct OI013 Initial 0 Filed 1
15 15 01-00044 1 1995-06-08T00:00:00 Employer EMP Other Conduct OI013 Initial 0 Filed 1
16 16 01-00045 0 1999-01-13T00:00:00 Employer EMP Conduct Close to Polling Area (Milchem) OI004 Initial 0 Filed 1
17 17 01-00045 1 1999-03-25T00:00:00 Employer EMP Conduct Close to Polling Area (Milchem) OI004 Hearing Officer's Report 10000 Overruled 10003
18 18 01-00046 0 1998-11-12T00:00:00 Union Involved UNIN Other Conduct OI013 Hearing Officer's Report 10000  
19 19 01-00058 0 1999-03-22T00:00:00 Union Involved UNIN Other Conduct OI013 Initial 0 Filed 1
20 20 01-00071 0 1999-04-13T00:00:00 Employer EMP Other Conduct OI013 Initial 0 Filed 1
21 21 01-00071 1 1999-04-13T00:00:00 Union Involved UNIN Other Conduct OI013 Initial 0 Filed 1
22 22 01-00071 2 1999-05-05T00:00:00 Employer EMP Other Conduct OI013 Approval of Withdrawal of Obj. 10018 Withdrawn 10181
23 23 01-00071 3 1999-05-05T00:00:00 Union Involved UNIN Other Conduct OI013 Approval of Withdrawal of Obj. 10018 Withdrawn 10181
24 24 01-00081 0 1998-10-22T00:00:00 Employer EMP Other Conduct OI013 Initial 0 Filed 1
25 25 01-00081 1 1998-12-02T00:00:00 Employer EMP Other Conduct OI013 Approval of Withdrawal of Obj. 10018 Withdrawn 10181
26 26 01-00086 0 1998-12-18T00:00:00 Employer EMP Conduct of Observer OI005 Initial 0 Filed 1
27 27 01-00086 1 1998-12-18T00:00:00 Employer EMP Board Agent Conduct OI003 Initial 0 Filed 1
28 28 01-00086 2 1998-12-18T00:00:00 Employer EMP Threat OI021 Initial 0 Filed 1
29 29 01-00086 3 1998-12-18T00:00:00 Employer EMP Other Conduct OI013 Initial 0 Filed 1
30 30 01-00088 0 1999-04-14T00:00:00 Petitioner PET Other Conduct OI013 Initial 0 Filed 1
31 31 01-00090 0 1999-04-16T00:00:00 Petitioner PET Other Conduct OI013 Initial 0 Filed 1
32 32 01-00090 1 1999-08-04T00:00:00 Petitioner PET Other Conduct OI013 Approval of Withdrawal of Obj. 10018 Withdrawn 10181
33 33 01-00096 0 1999-04-26T00:00:00 Employer EMP Other Conduct OI013 Initial 0 Filed 1
34 34 01-00096 1 1999-05-07T00:00:00 Employer EMP Other Conduct OI013 Rept. on Obj., w/o Notice of Hrg. 10005 Overruled 10053
35 35 01-00099 0 1999-04-29T00:00:00 Employer EMP Threat OI021 Initial 0 Filed 1
36 36 01-00099 1 1999-04-29T00:00:00 Employer EMP Conduct Close to Polling Area (Milchem) OI004 Initial 0 Filed 1
37 37 01-00099 2 1999-04-29T00:00:00 Employer EMP Violent Conduct or Threats OI024 Initial 0 Filed 1
38 38 01-00099 3 1999-04-29T00:00:00 Employer EMP Waiver of Dues/Fees (Savair) OI026 Initial 0 Filed 1
39 39 01-00104 0 1999-05-12T00:00:00 Petitioner PET Threat OI021 Initial 0 Filed 1
40 40 01-00104 10 1999-06-08T00:00:00 Petitioner PET Gifts or Inducements OI008 Rept. on Obj. & Notice of Hrg. 10006 Hearing directed 10064
41 41 01-00104 2 1999-05-12T00:00:00 Petitioner PET Gifts or Inducements OI008 Initial 0 Filed 1
42 42 01-00104 3 1999-05-12T00:00:00 Petitioner PET Surveillance or Impression thereof OI019 Initial 0 Filed 1
43 43 01-00104 4 1999-05-12T00:00:00 Petitioner PET Promise/Grant Wages or Benefits OI015 Initial 0 Filed 1
44 44 01-00104 5 1999-05-12T00:00:00 Petitioner PET Other Conduct OI013 Initial 0 Filed 1
45 45 01-00104 6 1999-06-08T00:00:00 Petitioner PET Other Conduct OI013 Approval of Withdrawal of Obj. 10018 Withdrawn 10181
46 46 01-00104 7 1999-06-08T00:00:00 Petitioner PET Promise/Grant Wages or Benefits OI015 Approval of Withdrawal of Obj. 10018 Withdrawn 10181
47 47 01-00104 8 1999-06-08T00:00:00 Petitioner PET Surveillance or Impression thereof OI019 Approval of Withdrawal of Obj. 10018 Withdrawn 10181
48 48 01-00104 9 1999-06-08T00:00:00 Petitioner PET Threat OI021 Approval of Withdrawal of Obj. 10018 Withdrawn 10181
49 49 01-00111 0 1999-06-02T00:00:00 Petitioner PET Conduct Close to Polling Area (Milchem) OI004 Initial 0 Filed 1
50 50 01-00111 1 1998-06-02T00:00:00 Petitioner PET Excelsior List Issues OI006 Initial 0 Filed 1
51 51 01-00111 2 1999-06-02T00:00:00 Petitioner PET Mechanics of Election OI011 Initial 0 Filed 1
52 52 01-00111 3 1999-06-02T00:00:00 Petitioner PET Promise/Grant Wages or Benefits OI015 Initial 0 Filed 1
53 53 01-00111 4 1999-06-02T00:00:00 Petitioner PET Threat OI021 Initial 0 Filed 1
54 54 01-00111 5 1999-06-09T00:00:00 Petitioner PET Excelsior List Issues OI006 Approval of Withdrawal of Obj. 10018 Withdrawn 10181
55 55 01-00111 6 1999-06-09T00:00:00 Petitioner PET Conduct Close to Polling Area (Milchem) OI004 Approval of Withdrawal of Obj. 10018 Withdrawn 10181
56 56 01-00111 7 1999-06-09T00:00:00 Petitioner PET Mechanics of Election OI011 Approval of Withdrawal of Obj. 10018 Withdrawn 10181
57 57 01-00111 8 1999-06-09T00:00:00 Petitioner PET Promise/Grant Wages or Benefits OI015 Approval of Withdrawal of Obj. 10018 Withdrawn 10181
58 58 01-00111 9 1999-06-09T00:00:00 Petitioner PET Threat OI021 Approval of Withdrawal of Obj. 10018 Withdrawn 10181
59 59 01-00119 0 1999-06-29T00:00:00 Petitioner PET Promise/Grant Wages or Benefits OI015 Initial 0 Filed 1
60 60 01-00119 1 1999-06-29T00:00:00 Petitioner PET Speech within 24 hours (Peerless) OI018 Initial 0 Filed 1
61 61 01-00119 2 1999-06-29T00:00:00 Petitioner PET Threat OI021 Initial 0 Filed 1
62 62 01-00119 3 1999-07-14T00:00:00 Petitioner PET Promise/Grant Wages or Benefits OI015 Approval of Withdrawal of Obj. 10018 Withdrawn 10181
63 63 01-00119 4 1999-07-14T00:00:00 Petitioner PET Speech within 24 hours (Peerless) OI018 Approval of Withdrawal of Obj. 10018 Withdrawn 10181
64 64 01-00119 5 1999-07-14T00:00:00 Petitioner PET Threat OI021 Approval of Withdrawal of Obj. 10018 Withdrawn 10181
65 65 01-00123 0 1999-07-09T00:00:00 Petitioner PET Mechanics of Election OI011 Initial 0 Filed 1
66 66 01-00123 1 1999-07-09T00:00:00 Petitioner PET Other Conduct OI013 Initial 0 Filed 1
67 67 01-00123 2 1999-07-09T00:00:00 Petitioner PET Promise/Grant Wages or Benefits OI015 Initial 0 Filed 1
68 68 01-00123 3 1999-07-09T00:00:00 Petitioner PET ULP Discrimination (Texas Meat Packer) OI022 Initial 0 Filed 1
69 69 01-00123 4 2000-05-11T00:00:00 Petitioner PET Mechanics of Election OI011 Approval of Withdrawal of Obj. 10018 Withdrawn 10181
70 70 01-00123 5 2000-05-11T00:00:00 Petitioner PET Other Conduct OI013 Approval of Withdrawal of Obj. 10018 Withdrawn 10181
71 71 01-00123 6 2000-05-11T00:00:00 Petitioner PET Promise/Grant Wages or Benefits OI015 Approval of Withdrawal of Obj. 10018 Withdrawn 10181
72 72 01-00123 7 2000-05-11T00:00:00 Petitioner PET ULP Discrimination (Texas Meat Packer) OI022 Approval of Withdrawal of Obj. 10018 Withdrawn 10181
73 73 01-00124 0 1999-07-07T00:00:00 Employer EMP Pro-Union Supervisory Conduct OI016 Initial 0 Filed 1
74 74 01-00124 1 1999-07-22T00:00:00 Employer EMP Pro-Union Supervisory Conduct OI016 Rept. on Obj., w/o Notice of Hrg. 10005 Overruled 10053
75 75 01-00135 0 1999-07-28T00:00:00 Employer EMP Conduct Close to Polling Area (Milchem) OI004 Initial 0 Filed 1
76 76 01-00135 1 1999-07-28T00:00:00 Employer EMP Mechanics of Election OI011 Initial 0 Filed 1
77 77 01-00143 0 1999-03-18T00:00:00 Petitioner PET Other Conduct OI013 Initial 0 Filed 1
78 78 01-00143 1 1999-08-05T00:00:00 Petitioner PET Other Conduct OI013 Approval of Withdrawal of Obj. 10018 Withdrawn 10181
79 79 01-00148 0 1998-11-25T00:00:00 Employer EMP Other Conduct OI013 Initial 0 Filed 1
80 80 01-00148 1 1998-12-22T00:00:00 Employer EMP Other Conduct OI013 Rept. on Obj., w/o Notice of Hrg. 10005 Overruled 10053
81 81 01-00164 0 1999-09-16T00:00:00 Petitioner PET Other Conduct OI013 Initial 0 Filed 1
82 82 01-00180 0 1999-10-25T00:00:00 Petitioner PET 3-Day Notice Rules OI001 Initial 0 Filed 1
83 83 01-00180 1 1999-10-25T00:00:00 Petitioner PET Gifts or Inducements OI008 Initial 0 Filed 1
84 84 01-00180 2 1999-10-25T00:00:00 Petitioner PET Interrogation OI009 Initial 0 Filed 1
85 85 01-00180 3 1999-10-25T00:00:00 Petitioner PET Promise/Grant Wages or Benefits OI015 Initial 0 Filed 1
86 86 01-00186 1 1999-10-28T00:00:00 Petitioner PET Excelsior List Issues OI006 Initial 0 Filed 1
87 87 01-00186 2 1999-10-28T00:00:00 Petitioner PET Other Conduct OI013 Initial 0 Filed 1
88 88 01-00186 3 1999-10-28T00:00:00 Petitioner PET Promise/Grant Wages or Benefits OI015 Initial 0 Filed 1
89 89 01-00186 4 1999-10-28T00:00:00 Petitioner PET Surveillance or Impression thereof OI019 Initial 0 Filed 1
90 90 01-00186 5 1999-10-28T00:00:00 Petitioner PET Threat OI021 Initial 0 Filed 1
91 91 01-00186 6 1999-10-28T00:00:00 Petitioner PET ULP Discrimination (Texas Meat Packer) OI022 Initial 0 Filed 1
92 92 01-00186 7 1999-10-28T00:00:00 Petitioner PET Interrogation OI009 Initial 0 Filed 1
93 93 01-00186 8 1999-10-28T00:00:00 Petitioner PET 8(a)(2) conduct OI002 Initial 0 Filed 1
94 94 01-00187 0 1999-10-28T00:00:00 Petitioner PET 8(a)(2) conduct OI002 Initial 0 Filed 1
95 95 01-00187 1 1999-10-28T00:00:00 Petitioner PET Excelsior List Issues OI006 Initial 0 Filed 1
96 96 01-00187 2 1999-10-28T00:00:00 Petitioner PET Interrogation OI009 Initial 0 Filed 1
97 97 01-00187 3 1999-10-28T00:00:00 Petitioner PET Other Conduct OI013 Initial 0 Filed 1
98 98 01-00187 4 1999-10-28T00:00:00 Petitioner PET Promise/Grant Wages or Benefits OI015 Initial 0 Filed 1
99 99 01-00187 5 1999-10-28T00:00:00 Petitioner PET Surveillance or Impression thereof OI019 Initial 0 Filed 1
100 100 01-00187 6 1999-10-28T00:00:00 Petitioner PET Threat OI021 Initial 0 Filed 1

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "r_objection_issue" (
    "election_id" text,
    "sequence" integer,
    "objection_issue_date" text,
    "objection_party" text,
    "objection_issue" text,
    "objection_action" integer,
    "objection_result" integer,
    FOREIGN KEY (election_id) REFERENCES r_election (election_id),
    FOREIGN KEY ([objection_party]) REFERENCES[l_case_party] ([party]),
    FOREIGN KEY ([objection_issue]) REFERENCES[l_r_objection_issue] ([objection_issue]),
    FOREIGN KEY ([objection_action]) REFERENCES[l_r_obj_act_type] ([objection_action]),
    FOREIGN KEY ([objection_result]) REFERENCES[l_r_obj_act_result] ([objection_result])
);