rc_elect
where patric_union = "H"
Download this data as a CSV Spreadsheet (All Rows)
Link | rowid ▼ | case_number | suffix | election_date | unit | description_election | expedited | date_election_held | type_election | no_elig | join_union_won | union_won_votes | union_won_intl_type | union_won_intl | joint_union_lost_1 | union_lost_votes_1 | union_lost_intl_1_type | union_lost_intl_1 | joint_union_lost_2 | union_lost_votes_2 | union_lost_intl_2_type | union_lost_intl_2 | joint_union_lost_3 | union_lost_votes_3 | union_lost_intl_3_type | union_lost_intl_3 | joint_union_lost_4 | union_lost_votes_4 | union_lost_intl_4_type | union_lost_intl_4 | votes_against_union | challenges | void_votes | elect_vote_control | control | conclusive | challenges_determinative | patric_union | incumb_union | mail_ballot | union_control | cross_petition | runoff_necessary | cross_pet_case_number | rerun_runoff_number | impounded | date_elect_certified | stage | method |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9 | 9 | 01-RC-017751 | A ? | 1985-06-27 | Z | 1 | 0 | 1985-06-27 | R | 24 | 0 | 0 | 8 | 0 | 0 | 9 | 0 | 0 | 1 | 61 61 | 18 | 0 | 0 | 9 | 0 | 1 1 | 0 | H | I | 0 | 1 | 0 | 01-RC-018471 | 0 | 1985-07-09 | 7 | 3 | ||||||||||||
10 | 10 | 01-RC-017751 | A A | 1985-06-27 | Z | 1 | 0 | 1985-06-27 | R | 7 | 1 | 5 | 9 | 1 | 0 | 1 | 61 61 | 2 | 0 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 0 | 1985-07-09 | 7 | 3 | |||||||||||||||||
11 | 11 | 01-RC-017751 | A B | 1985-06-27 | Z | 1 | 0 | 1985-06-27 | R | 17 | 0 | 10 | 9 | 0 | 1 | 1 | 61 61 | 0 | 0 | 0 | 5 | 0 | 1 1 | 0 | H | 0 | 0 | 1 | 0 | 01-RC-018471 | 0 | 1985-07-09 | 7 | 3 | |||||||||||||||
223 | 223 | 01-RC-018202 | A | 1984-08-08 | P | 1 | 0 | 1984-08-08 | S | 126 | 0 | 69 | 9 | 0 | 49 | 1 | 23 23 | 0 | 0 | 0 | 1 | 0 | 1 1 | H | 0 | 0 | 1984-08-17 | 1 | 3 | ||||||||||||||||||||
229 | 229 | 01-RC-018208 | A | 1984-08-16 | R | 1 | 0 | 1984-08-16 | S | 15 | 0 | 11 | 1 | 241 241 | 0 | 3 | 9 | 1 | 0 | 0 | 1 | 0 | 1 1 | H | 0 | 0 | 1984-08-28 | 1 | 3 | ||||||||||||||||||||
458 | 458 | 01-RC-018471 | A ? | 1985-06-27 | Z | 1 | 0 | 1985-06-27 | R | 24 | 0 | 0 | 8 | 0 | 0 | 7 | 0 | 0 | 2 | 61 61 | 18 | 0 | 0 | 9 | 0 | 1 1 | 0 | H | I | 0 | 1 | 0 | 01-RC-018472 | 0 | 1985-07-09 | 7 | 3 | ||||||||||||
459 | 459 | 01-RC-018471 | A A | 1985-06-27 | Z | 1 | 0 | 1985-06-27 | R | 7 | 0 | 5 | 7 | 0 | 0 | 2 | 61 61 | 2 | 0 | 0 | 3 | 0 | 1 1 | 0 | H | 0 | 1 | 0 | 01-RC-018472 | 0 | 1985-07-09 | 7 | 3 | ||||||||||||||||
460 | 460 | 01-RC-018471 | A B | 1985-06-27 | Z | 1 | 0 | 1985-06-27 | R | 17 | 1 | 10 | 7 | 1 | 1 | 2 | 61 61 | 0 | 0 | 0 | 2 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 0 | 1985-07-09 | 7 | 3 | |||||||||||||||||
461 | 461 | 01-RC-018472 | A ? | 1985-06-27 | Z | 1 | 0 | 1985-06-27 | R | 24 | 0 | 0 | 8 | 0 | 0 | 7 | 0 | 0 | 2 | 61 61 | 18 | 0 | 0 | 9 | 0 | 1 1 | 0 | H | I | 0 | 1 | 0 | 01-RC-017751 | 0 | 1985-07-09 | 7 | 3 | ||||||||||||
462 | 462 | 01-RC-018472 | A A | 1985-06-27 | Z | 1 | 0 | 1985-06-27 | R | 7 | 1 | 5 | 7 | 1 | 0 | 2 | 61 61 | 2 | 0 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 0 | 1985-07-09 | 7 | 3 | |||||||||||||||||
463 | 463 | 01-RC-018472 | A B | 1985-06-27 | Z | 1 | 0 | 1985-06-27 | R | 17 | 0 | 10 | 7 | 0 | 1 | 2 | 61 61 | 0 | 0 | 0 | 6 | 0 | 1 1 | 0 | H | 0 | 1 | 0 | 01-RC-017751 | 0 | 1985-07-09 | 7 | 3 | ||||||||||||||||
548 | 548 | 01-RC-018582 | A A | 1985-10-17 | P | 1 | 0 | 1985-10-17 | S | 35 | 1 | 21 | 9 | 1 | 9 | 1 | 23 23 | 0 | 0 | 0 | 1 | 0 | 1 1 | 0 | H | 3 | 0 | 0 | 0 | 1985-10-28 | 1 | 3 | |||||||||||||||||
549 | 549 | 01-RC-018582 | A B | 1985-10-17 | P | 1 | 0 | 1985-10-17 | S | 213 | 1 | 130 | 1 | 23 23 | 1 | 40 | 9 | 6 | 7 | 0 | 2 | 0 | 1 1 | 0 | H | 5 | 0 | 0 | 0 | 1985-10-28 | 1 | 3 | |||||||||||||||||
663 | 663 | 01-RC-018719 | A 1 | 1986-06-13 | D | 1 | 0 | 1986-06-13 | S | 30 | 0 | 17 | 7 | 0 | 1 | 2 | 23 23 | 12 | 0 | 0 | 1 | 0 | 1 1 | 0 | H | 6 | 0 | 0 | 0 | 1986-06-24 | 1 | 3 | |||||||||||||||||
739 | 739 | 01-RC-018806 | A 1 | 1986-12-17 | A | 1 | 0 | 1986-12-17 | S | 82 | 0 | 62 | 2 | 141 141 | 0 | 5 | 7 | 13 | 1 | 0 | 1 | 0 | 1 1 | 0 | H | 3 | 0 | 0 | 0 | 1986-12-29 | 1 | 3 | |||||||||||||||||
1057 | 1057 | 01-RC-019188 | A | 1989-05-01 | C | 1 | 0 | 1989-02-09 | S | 17 | 0 | 4 | 2 | 236 236 | 0 | 2 | 7 | 0 | 7 | 1 | 1 | 0 | 2 2 | 1 | H | 3 | 1 | 0 | 1 | 1989-06-12 | X | 3 | |||||||||||||||||
1245 | 1245 | 01-RC-019450 | A | 1990-09-17 | A | 1 | 0 | 1990-09-17 | R | 62 | 0 | 29 | 2 | 21 21 | 0 | 25 | 7 | 3 | 0 | 0 | 1 | 1 | 1 1 | 0 | H | 3 | 0 | 0 | 0 | 1990-09-26 | 1 | 3 | |||||||||||||||||
2263 | 2263 | 01-RD-001428 | B 1 | 1985-09-30 | A | A | 0 | 1985-08-29 | C | 10 | 0 | 5 | 2 | 141 141 | 0 | 0 | 9 | 4 | 0 | 0 | 1 | 0 | 1 1 | 0 | H | 3 | 0 | 0 | 0 | 1985-09-30 | X | 3 | |||||||||||||||||
2430 | 2430 | 01-RD-001741 | A | 1993-07-23 | A | 1 | 0 | 1993-07-23 | S | 141 | 0 | 0 | 9 | 0 | 57 | 2 | 61 61 | 84 | 0 | 0 | 1 | 0 | 1 1 | 0 | H | 4 | 0 | 0 | 0 | 1993-12-06 | X | 4 | |||||||||||||||||
2529 | 2529 | 01-RM-001214 | A | 1990-07-09 | Z | 1 | 0 | 1990-07-09 | S | 6 | 0 | 6 | 2 | 63 63 | 0 | 0 | 9 | 0 | 0 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 1 | 1990-07-18 | 1 | 3 | |||||||||||||||||
2558 | 2558 | 02-RC-019228 | K | 1984-09-19 | A | 3 | 0 | 1984-09-19 | S | 48 | 0 | 0 | 8 | 0 | 8 | 1 | 105 105 | 0 | 0 | 9 | 30 | 1 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 1 | 0 | 1984-10-01 | X | 4 | |||||||||||||
2593 | 2593 | 02-RC-019552 | A | 1983-09-12 | A | 1 | 0 | 1983-09-12 | S | 292 | 0 | 0 | 8 | 0 | 17 | 1 | 451 451 | 0 | 18 | 9 | 28 | 115 | 7 | 1 | 0 | 2 2 | 0 | H | 0 | 0 | 0 | ||||||||||||||||||
2600 | 2600 | 02-RC-019571 | A | 1983-10-03 | P | 1 | 0 | 1983-10-03 | R | 7 | 0 | 6 | 1 | 166 166 | 0 | 0 | 9 | 0 | 1 | 0 | 1 | 0 | 1 1 | H | 0 | 0 | 0 | 1983-10-12 | 7 | 3 | |||||||||||||||||||
2606 | 2606 | 02-RC-019588 | A | 1983-09-29 | G | 1 | 0 | 1983-09-29 | S | 118 | 0 | 74 | 2 | 472 472 | 0 | 31 | 7 | 1 | 0 | 0 | 1 | 0 | 1 1 | H | 3 | 0 | 0 | 1983-10-12 | 1 | 3 | |||||||||||||||||||
2629 | 2629 | 02-RC-019624 | A | 1983-11-10 | A | 1 | 0 | 1983-11-10 | S | 1100 | 0 | 651 | 9 | 0 | 6 | 2 | 23 23 | 181 | 40 | 5 | 1 | 0 | 1 1 | H | 5 | 0 | 0 | 1983-11-21 | 1 | 3 | |||||||||||||||||||
2639 | 2639 | 02-RC-019635 | A | 1983-11-15 | A | 1 | 0 | 1983-11-15 | S | 62 | 0 | 0 | 8 | 0 | 8 | 2 | 404 404 | 0 | 24 | 7 | 22 | 5 | 0 | 1 | 0 | 2 2 | H | 0 | 0 | 1984-01-10 | 1 | 4 | |||||||||||||||||
2642 | 2642 | 02-RC-019643 | A | 1983-11-30 | D | 1 | 0 | 1983-11-30 | S | 26 | 0 | 0 | 7 | 0 | 4 | 2 | 186 186 | 11 | 10 | 0 | 1 | 0 | 2 2 | H | 0 | 0 | 1984-01-04 | 1 | 4 | ||||||||||||||||||||
2649 | 2649 | 02-RC-019650 | A | 1984-01-13 | P | 1 | 0 | 1984-01-13 | S | 243 | 0 | 0 | 7 | 0 | 89 | 2 | 232 232 | 133 | 2 | 0 | 1 | 0 | 2 2 | H | 0 | 0 | 1984-01-23 | 1 | 4 | ||||||||||||||||||||
2697 | 2697 | 02-RC-019731 | A | 1984-05-17 | A | 1 | 0 | 1984-05-17 | S | 4 | 0 | 3 | 1 | 23 23 | 0 | 1 | 9 | 0 | 0 | 0 | 1 | 0 | 1 1 | H | 0 | 0 | 0 | 1984-05-25 | X | 3 | |||||||||||||||||||
2711 | 2711 | 02-RC-019755 | A | 1984-07-18 | P | 1 | 0 | 1984-07-18 | S | 5 | 0 | 0 | 8 | 0 | 2 | 1 | 241 241 | 0 | 0 | 9 | 3 | 0 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 0 | 1984-07-26 | 1 | 4 | ||||||||||||||
2745 | 2745 | 02-RC-019818 | A | 1984-10-02 | A | 1 | 1 | 1984-10-02 | S | 21 | 0 | 0 | 8 | 0 | 7 | 1 | 26 26 | 0 | 0 | 9 | 11 | 3 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 0 | |||||||||||||||||
2755 | 2755 | 02-RC-019830 | A | 1984-10-12 | A | 1 | 1 | 1984-10-12 | S | 5 | 0 | 4 | 1 | 23 23 | 0 | 1 | 9 | 0 | 0 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 0 | 1984-10-22 | X | 3 | |||||||||||||||||
2767 | 2767 | 02-RC-019849 | A | 1984-11-26 | A | 1 | 1 | 1984-11-26 | S | 19 | 0 | 11 | 2 | 105 105 | 0 | 0 | 7 | 1 | 3 | 0 | 1 | 0 | 1 1 | H | 0 | 0 | 0 | 1984-12-04 | X | 3 | |||||||||||||||||||
2768 | 2768 | 02-RC-019858 | A | 1985-01-14 | A | 1 | 1 | 1985-01-14 | S | 130 | 0 | 50 | 1 | 23 23 | 0 | 34 | 9 | 2 | 8 | 1 | 3 | 0 | 1 1 | H | 0 | 1 | 1 | 0 | 02-RC-019862 | 1985-01-22 | X | 3 | |||||||||||||||||
2771 | 2771 | 02-RC-019862 | A | 1985-01-14 | A | 1 | 1 | 1985-01-14 | S | 130 | 0 | 50 | 2 | 23 23 | 0 | 34 | 9 | 2 | 8 | 1 | 4 | 0 | 1 1 | H | 0 | 1 | 1 | 0 | 02-RC-019858 | 1985-01-22 | X | 3 | |||||||||||||||||
2774 | 2774 | 02-RC-019867 | A | 1985-01-09 | A | 1 | 1 | 1985-01-09 | S | 155 | 0 | 0 | 8 | 0 | 45 | 9 | 0 | 18 | 2 | 23 23 | 0 | 29 | 15 | 1 | 0 | 2 2 | H | 0 | 0 | 0 | 1985-05-16 | X | 3 | ||||||||||||||||
2776 | 2776 | 02-RC-019869 | A | 1986-03-27 | A | 1 | 0 | 1986-03-27 | R | 156 | 0 | 0 | 8 | 0 | 57 | 7 | 0 | 59 | 2 | 105 105 | 1 | 8 | 3 | 1 | 0 | 2 2 | 1 | H | 0 | 0 | 0 | 0 | 1986-08-22 | 7 | 3 | ||||||||||||||
2777 | 2777 | 02-RC-019869 | B | 1986-08-14 | A | A | 0 | 1986-03-27 | R | 156 | 0 | 63 | 7 | 0 | 60 | 2 | 105 105 | 0 | 0 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 0 | 1986-08-22 | 7 | 3 | |||||||||||||||||
2801 | 2801 | 02-RC-019907 | A | 1985-04-11 | A | 1 | 1 | 1985-04-11 | S | 337 | 0 | 181 | 7 | 0 | 20 | 2 | 23 23 | 1 | 5 | 0 | 1 | 0 | 1 1 | H | 5 | 0 | 0 | 1985-04-19 | X | 3 | |||||||||||||||||||
2802 | 2802 | 02-RC-019908 | A | 1985-03-20 | A | 1 | 0 | 1985-03-20 | S | 15 | 0 | 0 | 8 | 0 | 6 | 1 | 21 21 | 0 | 0 | 9 | 6 | 2 | 0 | 1 | 0 | 2 2 | 1 | H | 0 | 0 | 0 | 0 | 1988-08-23 | X | 3 | ||||||||||||||
2813 | 2813 | 02-RC-019923 | A | 1985-04-25 | A | 1 | 0 | 1985-04-25 | S | 11 | 0 | 11 | 7 | 0 | 0 | 2 | 23 23 | 0 | 0 | 0 | 1 | 0 | 1 1 | H | 0 | 0 | 0 | 1985-05-07 | X | 3 | |||||||||||||||||||
2816 | 2816 | 02-RC-019928 | A | 1985-05-22 | A | 1 | 0 | 1985-05-22 | R | 10 | 0 | 8 | 7 | 0 | 0 | 2 | 23 23 | 0 | 0 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 0 | 1985-06-04 | 7 | 3 | |||||||||||||||||
2819 | 2819 | 02-RC-019932 | A | 1985-05-22 | A | 1 | 0 | 1985-05-22 | R | 10 | 0 | 8 | 9 | 0 | 0 | 1 | 23 23 | 0 | 0 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 0 | 1985-06-04 | 7 | 3 | |||||||||||||||||
2823 | 2823 | 02-RC-019937 | A | 1985-06-06 | A | 1 | 0 | 1985-06-06 | R | 126 | 0 | 75 | 1 | 23 23 | 0 | 17 | 9 | 3 | 5 | 0 | 1 | 0 | 1 1 | 0 | H | 6 | 0 | 0 | 0 | 1985-07-18 | 7 | 3 | |||||||||||||||||
2840 | 2840 | 02-RC-019970 | A | 1986-03-04 | A | 1 | 0 | 1986-03-04 | R | 70 | 0 | 53 | 9 | 0 | 13 | 1 | 61 61 | 0 | 3 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 0 | 1986-03-12 | 7 | 3 | |||||||||||||||||
2888 | 2888 | 02-RC-020045 | A | 1985-10-31 | A | 1 | 0 | 1985-10-31 | S | 29 | 0 | 26 | 2 | 63 63 | 0 | 1 | 7 | 2 | 0 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 0 | 1985-11-13 | X | 3 | |||||||||||||||||
2909 | 2909 | 02-RC-020089 | A | 1986-03-13 | A | 1 | 0 | 1986-03-13 | S | 3 | 0 | 2 | 2 | 665 665 | 0 | 1 | 7 | 0 | 0 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 0 | 1987-03-30 | X | 3 | |||||||||||||||||
2935 | 2935 | 02-RC-020131 | A | 1986-11-06 | A | 1 | 0 | 1986-11-06 | R | 314 | 0 | 133 | 1 | 121 121 | 0 | 3 | 9 | 29 | 26 | 3 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 0 | 1986-11-14 | 7 | 3 | |||||||||||||||||
2936 | 2936 | 02-RC-020132 | A | 1986-04-28 | A | 1 | 0 | 1986-04-28 | S | 4 | 0 | 4 | 9 | 0 | 0 | 1 | 451 451 | 0 | 0 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 0 | 1986-05-06 | X | 3 | |||||||||||||||||
2941 | 2941 | 02-RC-020142 | A | 1986-07-10 | A | 1 | 0 | 1986-07-10 | S | 32 | 0 | 25 | 7 | 0 | 2 | 2 | 23 23 | 0 | 4 | 5 | 1 | 0 | 1 1 | 0 | H | 0 | 1 | 0 | 0 | 1986-07-18 | X | 3 | |||||||||||||||||
2960 | 2960 | 02-RC-020180 | A | 1986-07-30 | A | 1 | 0 | 1986-07-30 | S | 2 | 0 | 2 | 1 | 23 23 | 0 | 0 | 9 | 0 | 0 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 0 | 1986-08-11 | X | 3 | |||||||||||||||||
2975 | 2975 | 02-RC-020204 | A | 1986-09-03 | A | 1 | 0 | 1986-09-03 | S | 21 | 0 | 15 | 1 | 23 23 | 0 | 2 | 9 | 0 | 1 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 0 | 1986-09-15 | X | 3 | |||||||||||||||||
2998 | 2998 | 02-RC-020238 | A | 1987-01-08 | A | 1 | 0 | 1987-01-08 | S | 209 | 0 | 103 | 2 | 23 23 | 0 | 16 | 7 | 52 | 0 | 1 | 1 | 0 | 1 1 | 0 | H | 4 | 0 | 0 | 0 | 1987-01-16 | 1 | 3 | |||||||||||||||||
3011 | 3011 | 02-RC-020258 | A | 1987-03-12 | A | 1 | 0 | 1987-03-12 | S | 130 | 0 | 62 | 1 | 23 23 | 0 | 53 | 9 | 2 | 1 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 1987-08-20 | X | 3 | ||||||||||||||||||
3028 | 3028 | 02-RC-020284 | A | 1987-08-14 | A | 1 | 0 | 1987-08-14 | R | 115 | 0 | 0 | 8 | 0 | 54 | 7 | 0 | 50 | 2 | 105 105 | 5 | 2 | 0 | 1 | 0 | 2 2 | 1 | H | I | 0 | 0 | 0 | 1987-10-09 | 7 | 3 | ||||||||||||||
3029 | 3029 | 02-RC-020284 | F | 1987-10-01 | A | 2 | 0 | 1987-10-01 | R | 167 | 0 | 61 | 7 | 0 | 46 | 2 | 105 105 | 0 | 4 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 1 | 0 | 1987-10-09 | 7 | 3 | |||||||||||||||||
3058 | 3058 | 02-RC-020331 | A | 1987-12-17 | A | 1 | 0 | 1987-12-17 | R | 17 | 0 | 8 | 2 | 105 105 | 0 | 6 | 7 | 0 | 0 | 1 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 1987-12-28 | 7 | 3 | ||||||||||||||||||
3101 | 3101 | 02-RC-020441 | A | 1988-01-29 | A | 1 | 0 | 1988-01-29 | S | 61 | 0 | 31 | 1 | 23 23 | 0 | 23 | 9 | 1 | 0 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 1988-02-08 | 1 | 3 | ||||||||||||||||||
3119 | 3119 | 02-RC-020466 | A | 1988-04-18 | A | 1 | 0 | 1988-04-18 | S | 167 | 0 | 0 | 8 | 0 | 10 | 1 | 236 236 | 0 | 15 | 9 | 64 | 8 | 1 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 0 | 1988-10-06 | X | 4 | ||||||||||||||
3125 | 3125 | 02-RC-020477 | A | 1988-05-06 | A | 1 | 0 | 1988-05-06 | R | 8 | 0 | 6 | 7 | 0 | 1 | 2 | 105 105 | 1 | 0 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 1988-05-16 | 7 | 3 | ||||||||||||||||||
3145 | 3145 | 02-RC-020507 | A | 1988-07-14 | A | 1 | 0 | 1988-07-14 | R | 26 | 0 | 19 | 1 | 61 61 | 0 | 7 | 9 | 0 | 0 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 0 | 1988-07-22 | 7 | 3 | |||||||||||||||||
3146 | 3146 | 02-RC-020508 | A | 1988-05-24 | A | 1 | 0 | 1988-05-24 | S | 20 | 0 | 12 | 2 | 303 303 | 0 | 7 | 7 | 1 | 0 | 0 | 1 | 0 | 1 1 | 0 | H | 3 | 0 | 0 | 0 | 1988-06-01 | 1 | 3 | |||||||||||||||||
3162 | 3162 | 02-RC-020534 | A | 1989-03-24 | A | 1 | 0 | 1989-03-24 | S | 143 | 0 | 45 | 7 | 0 | 5 | 2 | 105 105 | 6 | 15 | 2 | 1 | 0 | 1 1 | 0 | H | 5 | 0 | 0 | 0 | 1989-04-03 | 1 | 3 | |||||||||||||||||
3192 | 3192 | 02-RC-020582 | A | 1989-01-12 | A | 1 | 0 | 1989-01-12 | S | 421 | 0 | 227 | 1 | 105 105 | 0 | 10 | 9 | 4 | 25 | 1 | 1 | 0 | 1 1 | 0 | H | 5 | 0 | 0 | 0 | 1989-05-17 | 1 | 3 | |||||||||||||||||
3246 | 3246 | 02-RC-021000 | A | 1991-06-24 | A | 1 | 0 | 1991-06-24 | R | 150 | 0 | 68 | 1 | 169 169 | 0 | 33 | 9 | 33 | 3 | 0 | 1 | 0 | 1 1 | 0 | H | 3 | 0 | 0 | 0 | 1991-07-08 | 1 | 4 | |||||||||||||||||
3293 | 3293 | 02-RC-021102 | A | 1992-03-13 | A | 1 | 0 | 1992-03-13 | S | 278 | 0 | 154 | 1 | 583 583 | 0 | 39 | 9 | 84 | 1 | 4 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 1992-03-23 | 1 | 3 | ||||||||||||||||||
3366 | 3366 | 02-RC-021230 | A | 1993-01-07 | A | 1 | 0 | 1993-01-07 | S | 10 | 0 | 10 | 1 | 23 23 | 0 | 0 | 9 | 0 | 0 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 1993-01-15 | 1 | 3 | ||||||||||||||||||
3400 | 3400 | 02-RC-021281 | A | 1994-12-14 | A | 1 | 0 | 1994-12-14 | R | 88 | 0 | 0 | 8 | 0 | 34 | 1 | 121 121 | 0 | 36 | 9 | 5 | 0 | 3 | 1 | 0 | 4 4 | 0 | H | 0 | 1 | 0 | 1995-02-08 | 7 | 3 | |||||||||||||||
3401 | 3401 | 02-RC-021281 | F | 1995-01-25 | A | 2 | 0 | 1995-01-25 | R | 88 | 0 | 53 | 9 | 0 | 29 | 1 | 121 121 | 0 | 0 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 1 | 0 | 1995-02-08 | 7 | 3 | |||||||||||||||||
3410 | 3410 | 02-RC-021290 | A | 1994-06-23 | A | 1 | 0 | 1994-06-23 | R | 47 | 0 | 35 | 9 | 0 | 0 | 1 | 121 121 | 0 | 5 | 0 | 1 | 0 | 1 1 | 0 | H | 3 | 0 | 0 | 0 | 1994-07-01 | 3 | 4 | |||||||||||||||||
3440 | 3440 | 02-RC-021335 | A | 1993-09-20 | A | 1 | 0 | 1993-09-20 | S | 15 | 0 | 15 | 7 | 0 | 0 | 2 | 241 241 | 0 | 0 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 1993-09-28 | 1 | 3 | ||||||||||||||||||
3474 | 3474 | 02-RC-021391 | A | 1994-02-17 | A | 1 | 0 | 1994-02-17 | S | 80 | 0 | 42 | 1 | 23 23 | 0 | 16 | 9 | 10 | 4 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 1994-02-25 | 1 | 3 | ||||||||||||||||||
3477 | 3477 | 02-RC-021394 | A | 1994-05-19 | A | 1 | 0 | 1994-05-19 | S | 162 | 0 | 0 | 8 | 0 | 11 | 2 | 5 5 | 0 | 10 | 9 | 5 | 4 | 28 | 1 | 0 | 4 4 | 0 | H | 1 | 1 | 0 | 1994-09-09 | 1 | 4 | |||||||||||||||
3618 | 3618 | 02-RC-021609 | A | 1996-05-03 | A | 1 | 0 | 1996-05-03 | R | 350 | 0 | 0 | 8 | 0 | 100 | 1 | 103 103 | 0 | 3 | 9 | 115 | 0 | 4 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 1997-04-16 | 7 | 3 | |||||||||||||||
3620 | 3620 | 02-RC-021609 | P | 1997-03-21 | A | 4 | 0 | 1997-03-21 | R | 422 | 0 | 41 | 1 | 103 103 | 0 | 4 | 9 | 21 | 33 | 15 | 1 | 1 | 5 5 | 1 | H | 1 | 0 | 0 | 1997-04-16 | 7 | 3 | ||||||||||||||||||
3730 | 3730 | 02-RC-021800 | A | 1997-02-28 | A | 1 | 0 | 1997-02-28 | S | 15 | 0 | 0 | 8 | 0 | 6 | 1 | 999 999 | 0 | 0 | 9 | 8 | 0 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 1997-03-10 | 1 | 4 | |||||||||||||||
3740 | 3740 | 02-RC-021817 | A | 1997-03-20 | A | 1 | 0 | 1997-03-20 | S | 15 | 0 | 7 | 1 | 23 23 | 0 | 0 | 9 | 3 | 3 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 1997-03-28 | 1 | 3 | ||||||||||||||||||
3751 | 3751 | 02-RC-021829 | A | 1997-06-20 | A | 1 | 0 | 1997-06-20 | R | 25 | 0 | 16 | 2 | 223 223 | 0 | 0 | 7 | 0 | 8 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 1997-06-30 | 7 | 3 | ||||||||||||||||||
3757 | 3757 | 02-RC-021837 | A | 1997-05-02 | A | 1 | 0 | 1997-05-02 | S | 17 | 0 | 13 | 2 | 239 239 | 0 | 0 | 7 | 0 | 1 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 1997-05-12 | 1 | 3 | ||||||||||||||||||
3776 | 3776 | 02-RC-021866 | A | 1997-07-17 | A | 1 | 0 | 1997-07-17 | S | 81 | 0 | 42 | 7 | 0 | 0 | 2 | 239 239 | 0 | 9 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 1997-07-25 | 1 | 3 | ||||||||||||||||||
3780 | 3780 | 02-RC-021879 | A | 1997-10-10 | A | 1 | 0 | 1997-10-10 | S | 55 | 0 | 33 | 1 | 472 472 | 0 | 0 | 9 | 15 | 1 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 1997-10-20 | 1 | 3 | ||||||||||||||||||
3788 | 3788 | 02-RC-021891 | A | 1997-12-30 | A | 1 | 0 | 1997-12-30 | R | 7 | 0 | 4 | 9 | 0 | 3 | 1 | 105 105 | 0 | 0 | 0 | 3 | 0 | 1 1 | 0 | H | 0 | 1 | 0 | 02-RC-021898 | 0 | 1998-01-07 | 7 | 3 | ||||||||||||||||
3794 | 3794 | 02-RC-021898 | A | 1997-12-30 | A | 1 | 0 | 1997-12-30 | R | 7 | 0 | 4 | 1 | 999 999 | 0 | 3 | 9 | 0 | 0 | 0 | 4 | 1 | 1 1 | 0 | H | 0 | 1 | 0 | 02-RC-021891 | 0 | 1998-01-07 | 7 | 3 | ||||||||||||||||
3811 | 3811 | 02-RC-021923 | A | 1998-02-13 | A | 1 | 0 | 1998-02-13 | S | 19 | 0 | 9 | 9 | 0 | 3 | 1 | 999 999 | 0 | 2 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 1998-02-23 | 1 | 3 | ||||||||||||||||||
3837 | 3837 | 02-RC-021963 | A | 1998-07-02 | A | 1 | 0 | 1998-07-02 | R | 2 | 0 | 2 | 1 | 23 23 | 0 | 0 | 9 | 0 | 0 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 1998-07-10 | 7 | 3 | ||||||||||||||||||
3845 | 3845 | 02-RC-021973 | A | 1998-11-05 | A | 1 | 0 | 1998-11-04 | R | 1070 | 0 | 701 | 2 | 166 166 | 0 | 97 | 7 | 176 | 8 | 1 | 1 | 1 | 1 1 | 0 | H | 0 | 0 | 0 | 1998-11-13 | 7 | 3 | ||||||||||||||||||
3982 | 3982 | 02-RD-001163 | A | 1986-10-02 | A | 1 | 0 | 1986-10-02 | S | 250 | 0 | 0 | 8 | 0 | 100 | 2 | 451 451 | 0 | 18 | 9 | 99 | 2 | 0 | 1 | 0 | 4 4 | 0 | H | 0 | 0 | 1 | 0 | 1987-06-04 | X | 3 | ||||||||||||||
3996 | 3996 | 02-RD-001184 | A | 1987-07-14 | A | 1 | 0 | 1987-07-14 | S | 37 | 0 | 0 | 8 | 0 | 13 | 9 | 0 | 12 | 2 | 473 473 | 1 | 1 | 0 | 1 | 0 | 2 2 | 1 | H | 0 | 0 | 0 | 0 | 1987-10-14 | 1 | 3 | ||||||||||||||
3997 | 3997 | 02-RD-001184 | B | 1987-08-19 | A | A | 0 | 1987-07-14 | S | 37 | 0 | 14 | 9 | 0 | 12 | 2 | 473 473 | 1 | 0 | 0 | 1 | 0 | 1 1 | 0 | H | 3 | 0 | 0 | 0 | 1987-10-14 | 1 | 3 | |||||||||||||||||
4114 | 4114 | 02-RM-001999 | A | 1989-11-27 | A | 1 | 0 | 1989-11-27 | S | 9 | 0 | 0 | 9 | 0 | 0 | 2 | 223 223 | 6 | 0 | 0 | 1 | 0 | 1 1 | 0 | H | 5 | 0 | 0 | 0 | 1989-12-05 | 1 | 3 | |||||||||||||||||
4132 | 4132 | 03-RC-008315 | A | 1982-10-28 | W | 1 | 0 | 1982-10-28 | S | 669 | 0 | 322 | 9 | 0 | 0 | 1 | 481 481 | 10 | 12 | 11 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 0 | 1987-02-19 | X | 3 | |||||||||||||||||
4183 | 4183 | 03-RC-008494 | F | 1984-05-18 | A | 2 | 0 | 1984-05-18 | R | 54 | 0 | 0 | 7 | 0 | 15 | 2 | 26 26 | 36 | 2 | 0 | 1 | 0 | 2 2 | H | 0 | 0 | 0 | 1984-05-29 | 7 | 4 | |||||||||||||||||||
4189 | 4189 | 03-RC-008503 | A | 1984-03-13 | A | 1 | 0 | 1984-03-13 | S | 6 | 0 | 0 | 8 | 0 | 3 | 7 | 0 | 0 | 2 | 141 141 | 0 | 3 | 0 | 1 | 0 | 2 2 | 1 | H | 0 | 0 | 0 | 0 | 1984-05-02 | X | 3 | ||||||||||||||
4384 | 4384 | 03-RC-008739 | A | 1985-10-31 | A | 1 | 0 | 1985-10-31 | S | 112 | 0 | 0 | 8 | 1 | 48 | 7 | 1 | 14 | 2 | 219 219 | 34 | 3 | 0 | 1 | 0 | 4 4 | 1 | H | 0 | 0 | 1 | 0 | 1985-11-08 | X | 3 | ||||||||||||||
4450 | 4450 | 03-RC-008811 | A | 1985-12-12 | A | 1 | 0 | 1985-12-12 | S | 99 | 1 | 46 | 1 | 473 473 | 1 | 13 | 9 | 3 | 1 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 0 | 1985-12-20 | X | 3 | |||||||||||||||||
4461 | 4461 | 03-RC-008823 | A | 1985-12-13 | A | 1 | 0 | 1985-12-13 | S | 66 | 0 | 0 | 8 | 0 | 30 | 7 | 0 | 12 | 2 | 583 583 | 24 | 0 | 0 | 1 | 0 | 4 4 | 0 | H | 0 | 0 | 1 | 0 | 1987-01-08 | X | 3 | ||||||||||||||
4495 | 4495 | 03-RC-008867 | A A | 1986-05-29 | P | 1 | 0 | 1986-05-29 | R | 131 | 0 | 0 | 7 | 0 | 47 | 2 | 105 105 | 61 | 1 | 0 | 1 | 0 | 2 2 | 0 | H | 0 | 0 | 0 | 0 | 1986-06-06 | 7 | 3 | |||||||||||||||||
4586 | 4586 | 03-RC-008958 | A | 1986-10-29 | A | 1 | 0 | 1986-10-29 | S | 64 | 1 | 43 | 9 | 1 | 18 | 1 | 303 303 | 2 | 0 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 0 | 1986-11-06 | X | 3 | |||||||||||||||||
4640 | 4640 | 03-RC-009019 | A | 1987-05-07 | A | 1 | 0 | 1987-05-07 | S | 81 | 0 | 0 | 8 | 1 | 26 | 7 | 1 | 3 | 2 | 23 23 | 28 | 5 | 0 | 1 | 0 | 2 2 | 1 | H | I | 0 | 0 | 0 | 1987-06-12 | X | 3 | ||||||||||||||
4734 | 4734 | 03-RC-009149 | A | 1987-11-20 | A | 1 | 0 | 1987-11-20 | S | 92 | 1 | 49 | 1 | 25 25 | 1 | 30 | 9 | 4 | 2 | 0 | 1 | 0 | 1 1 | 0 | H | 0 | 0 | 0 | 1987-11-30 | 1 | 3 |
CREATE TABLE "rc_elect" ( [case_number] TEXT REFERENCES [r_master]([case_number]), [suffix] TEXT, [election_date] TEXT, [unit] TEXT REFERENCES [l_unit_codes]([code]), [description_election] TEXT, [expedited] INTEGER, [date_election_held] TEXT, [type_election] TEXT REFERENCES [l_type_elections]([code]), [no_elig] INTEGER, [join_union_won] INTEGER, [union_won_votes] INTEGER, [union_won_intl_type] TEXT, [union_won_intl] INTEGER, [joint_union_lost_1] INTEGER, [union_lost_votes_1] INTEGER, [union_lost_intl_1_type] TEXT, [union_lost_intl_1] INTEGER, [joint_union_lost_2] INTEGER, [union_lost_votes_2] INTEGER, [union_lost_intl_2_type] TEXT, [union_lost_intl_2] INTEGER, [joint_union_lost_3] INTEGER, [union_lost_votes_3] INTEGER, [union_lost_intl_3_type] TEXT, [union_lost_intl_3] INTEGER, [joint_union_lost_4] INTEGER, [union_lost_votes_4] INTEGER, [union_lost_intl_4_type] TEXT, [union_lost_intl_4] INTEGER, [votes_against_union] INTEGER, [challenges] INTEGER, [void_votes] INTEGER, [elect_vote_control] INTEGER, [control] INTEGER, [conclusive] INTEGER, [challenges_determinative] INTEGER, [patric_union] TEXT, [incumb_union] TEXT, [mail_ballot] INTEGER, [union_control] TEXT, [cross_petition] TEXT, [runoff_necessary] INTEGER, [cross_pet_case_number] TEXT, [rerun_runoff_number] TEXT, [impounded] INTEGER, [date_elect_certified] TEXT, [stage] TEXT, [method] TEXT, FOREIGN KEY([union_won_intl_type]) REFERENCES [l_elect_union_type]([code]), FOREIGN KEY([union_won_intl]) REFERENCES [l_union_codes_and_names]([code]), FOREIGN KEY([union_lost_intl_1_type]) REFERENCES [l_elect_union_type]([code]), FOREIGN KEY([union_lost_intl_1]) REFERENCES [l_union_codes_and_names]([code]), FOREIGN KEY([union_lost_intl_2_type]) REFERENCES [l_elect_union_type]([code]), FOREIGN KEY([union_lost_intl_2]) REFERENCES [l_union_codes_and_names]([code]), FOREIGN KEY([union_lost_intl_3_type]) REFERENCES [l_elect_union_type]([code]), FOREIGN KEY([union_lost_intl_3]) REFERENCES [l_union_codes_and_names]([code]), FOREIGN KEY([union_lost_intl_4_type]) REFERENCES [l_elect_union_type]([code]), FOREIGN KEY([union_lost_intl_4]) REFERENCES [l_union_codes_and_names]([code]), FOREIGN KEY([conclusive]) REFERENCES [l_elect_conclusive]([code]), FOREIGN KEY([incumb_union]) REFERENCES [l_elect_incumbent_union]([code]), FOREIGN KEY([method]) REFERENCES [l_elect_method_of_disposition]([code]), FOREIGN KEY([stage]) REFERENCES [l_elect_stage_of_closing]([code]), FOREIGN KEY([patric_union]) REFERENCES [l_elect_participating_union]([code]) );