rc_elect

where patric_union = "H"

✎ View and edit SQL

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

Next page

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])
);