rc_elect
where unit = "T"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17 | 17 | 01-RC-017842 | A | 1983-04-21 | T | 1 | 0 | 1983-04-21 | S | 52 | 0 | 26 | 3 | 233 233 | 0 | 0 | 24 | 1 | 0 | 1 | 0 | 1 1 | B | 0 | 0 | 1983-12-12 | X | 3 | |||||||||||||||||||||
| 28 | 28 | 01-RC-017940 | A | 1983-09-02 | T | 1 | 0 | 1983-09-02 | R | 29 | 0 | 15 | 1 | 61 61 | 0 | 0 | 11 | 2 | 1 | 1 | 0 | 1 1 | A | 0 | 0 | 1984-07-03 | 7 | 4 | |||||||||||||||||||||
| 29 | 29 | 01-RC-017940 | K | 1984-06-22 | T | 3 | 0 | 1984-06-22 | R | 35 | 0 | 0 | 8 | 0 | 1 | 1 | 61 61 | 25 | 0 | 1 | 1 | 0 | 1 1 | A | 0 | 0 | 1984-07-03 | 7 | 4 | ||||||||||||||||||||
| 41 | 41 | 01-RC-017978 | A | 1983-10-06 | T | 1 | 0 | 1983-10-06 | S | 17 | 0 | 0 | 8 | 0 | 5 | 3 | 233 233 | 12 | 0 | 0 | 1 | 0 | 1 1 | B | 0 | 0 | 1983-10-17 | 1 | 4 | ||||||||||||||||||||
| 43 | 43 | 01-RC-017983 | A | 1983-11-02 | T | 1 | 0 | 1983-11-02 | R | 420 | 0 | 0 | 8 | 0 | 133 | 3 | 233 233 | 218 | 17 | 3 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 0 | 1984-04-03 | 7 | 4 | |||||||||||||||||
| 44 | 44 | 01-RC-017984 | A | 1983-09-23 | T | 1 | 0 | 1983-09-23 | S | 2 | 0 | 2 | 1 | 23 23 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 1 | A | 0 | 0 | 1983-10-04 | 1 | 3 | |||||||||||||||||||||
| 45 | 45 | 01-RC-017985 | A | 1983-09-30 | T | 1 | 0 | 1983-09-30 | S | 54 | 0 | 30 | 7 | 0 | 0 | 20 | 2 | 0 | 1 | 0 | 1 1 | D | 0 | 0 | 1983-10-11 | 1 | 3 | ||||||||||||||||||||||
| 49 | 49 | 01-RC-017990 | A | 1983-10-27 | T | 1 | 0 | 1983-10-27 | S | 16 | 0 | 0 | 8 | 0 | 6 | 3 | 233 233 | 10 | 0 | 0 | 1 | 0 | 1 1 | B | 0 | 0 | 1983-11-07 | 1 | 4 | ||||||||||||||||||||
| 66 | 66 | 01-RC-018011 | A | 1983-09-30 | T | 1 | 0 | 1983-09-30 | S | 6 | 0 | 4 | 7 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 1 1 | D | 0 | 0 | 1983-10-11 | 1 | 3 | ||||||||||||||||||||||
| 73 | 73 | 01-RC-018022 | A | 1984-01-06 | T | 1 | 0 | 1984-01-06 | R | 48 | 0 | 0 | 8 | 0 | 2 | 3 | 233 233 | 41 | 0 | 0 | 1 | 0 | 1 1 | B | 0 | 0 | 1984-01-17 | 7 | 4 | ||||||||||||||||||||
| 74 | 74 | 01-RC-018023 | A | 1984-04-10 | T | 1 | 0 | 1984-04-10 | S | 20 | 0 | 10 | 3 | 233 233 | 0 | 0 | 6 | 3 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 0 | 1988-02-29 | X | 3 | ||||||||||||||||||
| 84 | 84 | 01-RC-018034 | A | 1983-11-18 | T | 1 | 0 | 1983-11-18 | S | 2 | 0 | 2 | 3 | 233 233 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 1 | B | 0 | 0 | 1983-11-30 | 1 | 3 | |||||||||||||||||||||
| 86 | 86 | 01-RC-018037 | A | 1983-11-10 | T | 1 | 0 | 1983-11-10 | S | 7 | 0 | 0 | 8 | 0 | 0 | 3 | 233 233 | 6 | 1 | 0 | 1 | 0 | 1 1 | B | 1 | 0 | 0 | 1983-11-21 | 1 | 4 | |||||||||||||||||||
| 89 | 89 | 01-RC-018039 | A | 1983-11-18 | T | 1 | 0 | 1983-11-18 | S | 16 | 0 | 12 | 3 | 233 233 | 0 | 0 | 4 | 0 | 0 | 1 | 0 | 1 1 | B | 0 | 0 | 1984-01-13 | X | 3 | |||||||||||||||||||||
| 90 | 90 | 01-RC-018040 | A | 1983-12-01 | T | 1 | 0 | 1983-12-01 | S | 12 | 0 | 5 | 7 7 | 0 | 0 | 5 | 0 | 0 | 3 | 0 | 1 1 | 1 | 0 | 1 | 0 | 01-RC-000000 | 1983-12-01 | 1 | 3 | ||||||||||||||||||||
| 104 | 104 | 01-RC-018055 | A | 1983-12-08 | T | 1 | 0 | 1983-12-08 | C | 12 | 0 | 0 | 8 | 0 | 3 | 3 | 233 233 | 5 | 2 | 0 | 1 | 0 | 2 2 | B | 0 | 0 | 1983-12-19 | 1 | 4 | ||||||||||||||||||||
| 111 | 111 | 01-RC-018063 | A | 1983-12-21 | T | 1 | 0 | 1983-12-21 | S | 4 | 0 | 3 | 3 | 233 233 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 1 | B | 0 | 0 | 1984-01-03 | 1 | 3 | |||||||||||||||||||||
| 114 | 114 | 01-RC-018072 | A | 1984-02-02 | T | 1 | 0 | 1984-02-02 | S | 49 | 0 | 0 | 8 | 0 | 8 | 3 | 233 233 | 41 | 0 | 0 | 1 | 0 | 1 1 | B | 0 | 0 | 1984-02-13 | 1 | 4 | ||||||||||||||||||||
| 134 | 134 | 01-RC-018095 | A | 1984-10-02 | T | 1 | 0 | 1984-03-28 | S | 22 | 0 | 11 | 3 | 233 233 | 0 | 0 | 5 | 4 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 1 | 1984-10-03 | X | 3 | ||||||||||||||||||
| 141 | 141 | 01-RC-018102 | A | 1984-03-23 | T | 1 | 0 | 1984-03-23 | S | 4 | 0 | 0 | 8 | 0 | 0 | 3 | 233 233 | 2 | 2 | 0 | 1 | 0 | 1 1 | B | 0 | 0 | 1984-05-01 | X | 4 | ||||||||||||||||||||
| 143 | 143 | 01-RC-018106 | A | 1984-03-30 | T | 1 | 0 | 1984-03-30 | S | 4 | 0 | 0 | 8 | 0 | 0 | 3 | 233 233 | 3 | 1 | 0 | 1 | 0 | 1 1 | B | 0 | 0 | 1984-04-26 | 1 | 4 | ||||||||||||||||||||
| 160 | 160 | 01-RC-018122 | A | 1984-05-25 | T | 1 | 0 | 1984-05-25 | S | 210 | 0 | 0 | 8 | 0 | 69 | 3 | 233 233 | 129 | 3 | 0 | 1 | 0 | 1 1 | B | 0 | 0 | 1984-11-15 | X | 4 | ||||||||||||||||||||
| 166 | 166 | 01-RC-018130 | A | 1984-06-01 | T | 1 | 0 | 1984-06-01 | S | 31 | 0 | 0 | 8 | 0 | 13 | 3 | 233 233 | 17 | 1 | 0 | 1 | 0 | 1 1 | B | 0 | 0 | 1984-06-12 | 1 | 4 | ||||||||||||||||||||
| 183 | 183 | 01-RC-018151 | A | 1984-05-25 | T | 1 | 0 | 1984-05-25 | S | 21 | 0 | 11 | 3 | 233 233 | 0 | 0 | 9 | 0 | 0 | 1 | 0 | 1 1 | B | 0 | 0 | 1984-06-05 | 1 | 3 | |||||||||||||||||||||
| 190 | 190 | 01-RC-018161 | A | 1984-07-12 | T | 1 | 0 | 1984-07-12 | S | 12 | 0 | 0 | 8 | 0 | 1 | 3 | 233 233 | 8 | 1 | 1 | 1 | 0 | 1 1 | B | 0 | 0 | 1984-07-23 | 1 | 4 | ||||||||||||||||||||
| 191 | 191 | 01-RC-018162 | A | 1984-06-15 | T | 1 | 0 | 1984-06-15 | S | 8 | 0 | 0 | 8 | 0 | 1 | 3 | 233 233 | 7 | 0 | 0 | 1 | 0 | 1 1 | B | 0 | 0 | 1984-06-26 | 1 | 4 | ||||||||||||||||||||
| 198 | 198 | 01-RC-018170 | A | 1984-07-13 | T | 1 | 0 | 1984-07-13 | S | 20 | 0 | 0 | 8 | 0 | 9 | 3 | 233 233 | 9 | 1 | 0 | 1 | 0 | 2 2 | 1 | B | 0 | 0 | 0 | 0 | 1985-04-01 | X | 3 | |||||||||||||||||
| 199 | 199 | 01-RC-018170 | B | 1985-04-01 | T | A | 0 | 1984-07-13 | S | 20 | 0 | 10 | 3 | 233 233 | 0 | 0 | 9 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 0 | 1985-04-01 | X | 3 | ||||||||||||||||||
| 224 | 224 | 01-RC-018203 | A | 1984-08-03 | T | 1 | 0 | 1984-08-03 | S | 14 | 0 | 0 | 8 | 0 | 1 | 3 | 233 233 | 8 | 4 | 0 | 1 | 0 | 1 1 | B | 0 | 0 | 1984-08-14 | 1 | 4 | ||||||||||||||||||||
| 231 | 231 | 01-RC-018211 | A | 1984-08-23 | T | 1 | 0 | 1984-08-23 | S | 42 | 0 | 0 | 8 | 0 | 8 | 3 | 233 233 | 29 | 5 | 0 | 1 | 0 | 1 1 | B | 0 | 0 | 0 | 1984-09-04 | 1 | 4 | |||||||||||||||||||
| 234 | 234 | 01-RC-018214 | A | 1984-08-25 | T | 1 | 0 | 1984-08-25 | S | 8 | 0 | 4 | 3 | 233 233 | 0 | 0 | 2 | 1 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 0 | 1985-01-14 | X | 3 | ||||||||||||||||||
| 250 | 250 | 01-RC-018231 | A | 1984-09-13 | T | 1 | 0 | 1984-09-13 | S | 23 | 0 | 0 | 8 | 0 | 0 | 3 | 233 233 | 10 | 2 | 0 | 1 | 0 | 1 1 | 1 | B | 0 | 0 | 0 | 0 | 1986-04-10 | 1 | 4 | |||||||||||||||||
| 251 | 251 | 01-RC-018231 | B | 1985-06-12 | T | A | 0 | 1984-09-13 | S | 23 | 0 | 12 | 3 | 233 233 | 0 | 0 | 10 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 0 | 1986-04-10 | 1 | 4 | ||||||||||||||||||
| 252 | 252 | 01-RC-018231 | K | 1985-07-18 | T | 3 | 0 | 1985-07-18 | B | 20 | 0 | 0 | 8 | 0 | 0 | 3 | 233 233 | 9 | 1 | 0 | 1 | 0 | 1 1 | 1 | B | 0 | 0 | 0 | 3 | 0 | 1986-04-10 | 1 | 4 | ||||||||||||||||
| 253 | 253 | 01-RC-018231 | Q | 1986-03-28 | T | D | 0 | 1985-07-18 | S | 20 | 0 | 0 | 8 | 0 | 10 | 3 | 233 233 | 10 | 0 | 0 | 1 | 0 | 5 5 | 0 | B | 0 | 0 | 0 | 1986-04-10 | 1 | 4 | ||||||||||||||||||
| 256 | 256 | 01-RC-018234 | A | 1984-09-27 | T | 1 | 0 | 1984-09-27 | S | 18 | 0 | 0 | 8 | 0 | 3 | 3 | 233 233 | 15 | 0 | 0 | 1 | 0 | 1 1 | B | 0 | 0 | 0 | 1984-10-09 | 1 | 4 | |||||||||||||||||||
| 265 | 265 | 01-RC-018243 | A | 1984-11-15 | T | 1 | 0 | 1984-11-15 | R | 21 | 0 | 0 | 8 | 0 | 6 | 3 | 233 233 | 13 | 0 | 0 | 1 | 0 | 1 1 | B | 0 | 0 | 1984-11-27 | 7 | 4 | ||||||||||||||||||||
| 268 | 268 | 01-RC-018250 | A | 1984-10-31 | T | 1 | 0 | 1984-10-31 | S | 12 | 0 | 0 | 8 | 0 | 3 | 3 | 233 233 | 7 | 1 | 0 | 1 | 0 | 1 1 | B | 0 | 0 | 1984-11-09 | 1 | 4 | ||||||||||||||||||||
| 317 | 317 | 01-RC-018300 | A | 1984-12-20 | T | 1 | 0 | 1984-12-20 | S | 21 | 0 | 0 | 8 | 0 | 5 | 3 | 233 233 | 15 | 1 | 0 | 1 | 0 | 1 1 | B | 0 | 0 | 1985-01-02 | 1 | 4 | ||||||||||||||||||||
| 327 | 327 | 01-RC-018313 | A | 1984-12-14 | T | 1 | 0 | 1984-12-14 | S | 13 | 0 | 8 | 3 | 233 233 | 0 | 0 | 4 | 0 | 0 | 1 | 0 | 1 1 | B | 0 | 0 | 1984-12-26 | 1 | 3 | |||||||||||||||||||||
| 333 | 333 | 01-RC-018322 | A | 1985-06-19 | T | 1 | 0 | 1985-06-19 | S | 16 | 1 | 10 | 3 | 233 233 | 1 | 2 | 2 | 204 204 | 1 | 1 | 0 | 1 | 0 | 1 1 | 0 | F | 0 | 0 | 0 | 0 | 1985-06-28 | 1 | 3 | ||||||||||||||||
| 365 | 365 | 01-RC-018374 | A | 1985-03-29 | T | 1 | 0 | 1985-03-29 | S | 10 | 0 | 7 | 3 | 233 233 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 1 1 | B | 0 | 0 | 0 | 1985-04-09 | 1 | 3 | ||||||||||||||||||||
| 373 | 373 | 01-RC-018385 | A | 1985-04-17 | T | 1 | 0 | 1985-04-17 | S | 32 | 0 | 0 | 8 | 0 | 11 | 3 | 233 233 | 15 | 6 | 0 | 1 | 0 | 2 2 | B | 0 | 0 | 0 | 1985-05-08 | X | 4 | |||||||||||||||||||
| 384 | 384 | 01-RC-018401 | A | 1985-05-08 | T | 1 | 0 | 1985-05-08 | S | 76 | 0 | 0 | 8 | 0 | 21 | 3 | 233 233 | 49 | 6 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 0 | 1985-05-17 | 1 | 4 | |||||||||||||||||
| 388 | 388 | 01-RC-018408 | A | 1985-06-06 | T | 1 | 0 | 1985-06-06 | R | 3 | 0 | 3 | 3 | 233 233 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 1 | 0 | 0 | 1985-06-17 | 7 | 3 | |||||||||||||||||||
| 443 | 443 | 01-RC-018455 | A | 1985-04-30 | T | 1 | 0 | 1985-04-30 | S | 3 | 0 | 3 | 3 | 233 233 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 1 | B | 0 | 0 | 0 | 1985-05-09 | 1 | 3 | ||||||||||||||||||||
| 469 | 469 | 01-RC-018484 | A 1 | 1985-06-06 | T | 1 | 0 | 1985-06-06 | S | 96 | 0 | 0 | 8 | 0 | 46 | 3 | 233 233 | 49 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 0 | 1986-03-24 | 1 | 4 | |||||||||||||||||
| 470 | 470 | 01-RC-018484 | K | 1986-03-13 | T | 3 | 0 | 1986-03-13 | S | 121 | 0 | 0 | 8 | 0 | 34 | 3 | 233 233 | 62 | 0 | 2 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 1 | 0 | 1986-03-24 | 1 | 4 | |||||||||||||||||
| 479 | 479 | 01-RC-018491 | A | 1985-07-26 | T | 1 | 0 | 1985-07-26 | R | 13 | 0 | 6 | 3 | 233 233 | 0 | 0 | 2 | 1 | 1 | 1 | 0 | 1 1 | 0 | B | 2 | 1 | 0 | 0 | 1985-08-27 | 7 | 3 | ||||||||||||||||||
| 481 | 481 | 01-RC-018493 | A | 1985-06-14 | T | 1 | 0 | 1985-06-14 | S | 24 | 0 | 0 | 8 | 0 | 4 | 3 | 233 233 | 18 | 0 | 0 | 1 | 0 | 1 1 | B | 0 | 0 | 1985-06-25 | 1 | 4 | ||||||||||||||||||||
| 482 | 482 | 01-RC-018494 | A | 1985-07-02 | T | 1 | 0 | 1985-07-02 | S | 12 | 0 | 9 | 3 | 233 233 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 1 | 0 | 0 | 1985-08-08 | 1 | 3 | |||||||||||||||||||
| 489 | 489 | 01-RC-018505 | A | 1985-06-21 | T | 1 | 0 | 1985-06-21 | S | 18 | 0 | 0 | 8 | 0 | 10 | 3 | 233 233 | 6 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 0 | 1985-07-02 | 1 | 3 | |||||||||||||||||
| 502 | 502 | 01-RC-018522 | A | 1985-07-25 | T | 1 | 0 | 1985-07-25 | S | 18 | 0 | 0 | 8 | 0 | 6 | 3 | 233 233 | 11 | 1 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 1985-08-05 | 1 | 4 | ||||||||||||||||||
| 520 | 520 | 01-RC-018546 | A | 1985-09-06 | T | 1 | 0 | 1985-09-06 | S | 13 | 0 | 0 | 8 | 0 | 4 | 3 | 233 233 | 7 | 0 | 1 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 1985-09-17 | 1 | 4 | ||||||||||||||||||
| 523 | 523 | 01-RC-018549 | A | 1985-08-22 | T | 1 | 0 | 1985-08-22 | S | 9 | 0 | 0 | 8 | 0 | 3 | 3 | 233 233 | 6 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 1 | 0 | 0 | 0 | 1985-08-30 | 1 | 4 | |||||||||||||||||
| 525 | 525 | 01-RC-018553 | A 1 | 1985-09-10 | T | 1 | 0 | 1985-09-10 | S | 6 | 0 | 5 | 3 | 233 233 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 1985-09-19 | 1 | 3 | |||||||||||||||||||
| 529 | 529 | 01-RC-018559 | A | 1985-09-20 | T | 1 | 0 | 1985-09-20 | C | 4 | 0 | 0 | 8 | 0 | 2 | 3 | 233 233 | 0 | 2 | 0 | 1 | 0 | 2 2 | 1 | B | 0 | 0 | 0 | 0 | 1985-10-04 | X | 4 | |||||||||||||||||
| 530 | 530 | 01-RC-018559 | B | 1985-10-04 | T | A | 0 | 1985-09-20 | C | 4 | 0 | 2 | 3 | 233 233 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 0 | 1985-10-04 | X | 4 | ||||||||||||||||||
| 531 | 531 | 01-RC-018560 | A | 1985-09-13 | T | 1 | 0 | 1985-09-13 | S | 9 | 0 | 0 | 8 | 0 | 0 | 3 | 233 233 | 7 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 1985-09-24 | 1 | 4 | ||||||||||||||||||
| 532 | 532 | 01-RC-018561 | A | 1985-09-05 | T | 1 | 0 | 1985-09-05 | S | 11 | 0 | 0 | 8 | 0 | 4 | 3 | 233 233 | 7 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 0 | 1985-09-16 | 1 | 4 | |||||||||||||||||
| 533 | 533 | 01-RC-018563 | A | 1985-09-30 | T | 1 | 0 | 1985-09-30 | S | 26 | 0 | 0 | 8 | 0 | 5 | 3 | 233 233 | 17 | 3 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 1985-10-09 | 1 | 4 | ||||||||||||||||||
| 537 | 537 | 01-RC-018569 | A | 1985-10-10 | T | 1 | 0 | 1985-10-10 | S | 12 | 1 | 10 | 3 | 233 233 | 1 | 0 | 9 | 0 | 1 | 2 | 1 | 0 | 1 1 | 0 | K | 0 | 0 | 0 | 1985-10-23 | 1 | 3 | ||||||||||||||||||
| 558 | 558 | 01-RC-018595 | A | 1985-11-06 | T | 1 | 0 | 1985-11-06 | S | 14 | 0 | 8 | 3 | 233 233 | 0 | 0 | 6 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 1985-11-18 | 1 | 3 | |||||||||||||||||||
| 562 | 562 | 01-RC-018601 | A | 1985-10-30 | T | 1 | 0 | 1985-10-30 | S | 31 | 0 | 0 | 8 | 0 | 7 | 3 | 233 233 | 17 | 6 | 1 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 1985-11-08 | 1 | 4 | ||||||||||||||||||
| 564 | 564 | 01-RC-018603 | A | 1985-12-12 | T | 1 | 0 | 1985-12-12 | R | 2 | 0 | 2 | 3 | 233 233 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 1985-12-31 | 7 | 3 | |||||||||||||||||||
| 565 | 565 | 01-RC-018607 | A | 1985-11-22 | T | 1 | 0 | 1985-11-22 | S | 26 | 0 | 0 | 8 | 0 | 3 | 1 | 187 187 | 20 | 3 | 0 | 1 | 0 | 1 1 | 0 | A | 0 | 0 | 0 | 1986-01-14 | 1 | 4 | ||||||||||||||||||
| 577 | 577 | 01-RC-018616 | A | 1985-11-14 | T | 1 | 0 | 1985-11-14 | S | 30 | 0 | 0 | 8 | 0 | 11 | 3 | 233 233 | 17 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 1985-11-25 | 1 | 4 | ||||||||||||||||||
| 583 | 583 | 01-RC-018626 | A | 1986-01-15 | T | 1 | 0 | 1986-01-15 | R | 15 | 0 | 10 | 3 | 233 233 | 0 | 0 | 4 | 1 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 1986-01-27 | 7 | 3 | |||||||||||||||||||
| 586 | 586 | 01-RC-018631 | A | 1985-12-20 | T | 1 | 0 | 1985-12-20 | S | 13 | 0 | 0 | 8 | 0 | 6 | 3 | 233 233 | 6 | 1 | 0 | 1 | 0 | 2 2 | 1 | B | 0 | 0 | 0 | 0 | ||||||||||||||||||||
| 611 | 611 | 01-RC-018664 | A | 1986-03-19 | T | 1 | 0 | 1986-03-19 | S | 42 | 0 | 0 | 8 | 0 | 15 | 3 | 233 233 | 24 | 3 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 0 | 1987-02-02 | X | 4 | |||||||||||||||||
| 615 | 615 | 01-RC-018668 | A | 1986-04-02 | T | 1 | 0 | 1986-04-02 | S | 13 | 0 | 8 | 3 | 233 233 | 0 | 0 | 4 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 1986-04-11 | 1 | 3 | |||||||||||||||||||
| 646 | 646 | 01-RC-018701 | A 1 | 1986-08-21 | T | 1 | 0 | 1986-08-21 | S | 27 | 0 | 14 | 3 | 233 233 | 0 | 0 | 13 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 1 | 0 | 0 | 0 | 1987-02-13 | 1 | 3 | ||||||||||||||||||
| 653 | 653 | 01-RC-018709 | A | 1986-05-29 | T | 1 | 0 | 1986-05-29 | S | 8 | 0 | 7 | 3 | 233 233 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 0 | 1986-06-09 | 1 | 3 | ||||||||||||||||||
| 657 | 657 | 01-RC-018713 | A | 1986-05-29 | T | 1 | 0 | 1986-05-29 | S | 4 | 0 | 0 | 8 | 0 | 2 | 3 | 233 233 | 2 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 1986-08-12 | 1 | 4 | ||||||||||||||||||
| 658 | 658 | 01-RC-018713 | K | 1986-08-01 | T | 3 | 0 | 1986-08-01 | S | 4 | 0 | 0 | 8 | 0 | 1 | 3 | 233 233 | 2 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 1 | 0 | 0 | 1 | 0 | 1986-08-12 | 1 | 4 | ||||||||||||||||
| 676 | 676 | 01-RC-018739 | A | 1986-07-29 | T | 1 | 0 | 1986-07-29 | S | 20 | 0 | 0 | 8 | 0 | 9 | 3 | 233 233 | 10 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 0 | 1986-08-12 | 1 | 4 | |||||||||||||||||
| 679 | 679 | 01-RC-018744 | A 1 | 1986-07-18 | T | 1 | 0 | 1986-07-18 | S | 25 | 0 | 0 | 8 | 0 | 6 | 3 | 233 233 | 17 | 2 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 0 | 1986-07-29 | 1 | 4 | |||||||||||||||||
| 705 | 705 | 01-RC-018767 | A 1 | 1986-09-05 | T | 1 | 0 | 1986-09-05 | S | 14 | 0 | 0 | 8 | 0 | 4 | 3 | 233 233 | 8 | 2 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 0 | 1986-09-16 | 1 | 4 | |||||||||||||||||
| 709 | 709 | 01-RC-018772 | A 1 | 1986-10-01 | T | 1 | 0 | 1986-10-01 | S | 8 | 0 | 4 | 3 | 233 233 | 0 | 0 | 3 | 1 | 0 | 1 | 0 | 1 1 | 1 | B | 1 | 0 | 0 | 0 | 1986-10-29 | X | 3 | ||||||||||||||||||
| 710 | 710 | 01-RC-018772 | B 1 | 1986-10-21 | T | A | 0 | 1986-10-01 | S | 8 | 0 | 5 | 3 | 233 233 | 0 | 0 | 3 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 1 | 0 | 0 | 0 | 1986-10-29 | X | 3 | ||||||||||||||||||
| 714 | 714 | 01-RC-018776 | A 1 | 1986-10-16 | T | 1 | 0 | 1986-10-16 | S | 12 | 0 | 0 | 8 | 0 | 6 | 3 | 233 233 | 6 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 1 | 0 | 0 | 0 | 1986-10-24 | 1 | 4 | |||||||||||||||||
| 719 | 719 | 01-RC-018781 | A 1 | 1986-11-21 | T | 1 | 0 | 1986-11-21 | S | 53 | 0 | 0 | 8 | 0 | 22 | 3 | 233 233 | 28 | 3 | 0 | 1 | 0 | 1 1 | 0 | B | 1 | 0 | 0 | 0 | 1986-12-01 | 1 | 4 | |||||||||||||||||
| 720 | 720 | 01-RC-018786 | A 1 | 1986-11-21 | T | 1 | 0 | 1986-11-21 | S | 21 | 0 | 0 | 8 | 0 | 2 | 3 | 233 233 | 18 | 1 | 0 | 1 | 0 | 1 1 | 0 | B | 1 | 0 | 0 | 0 | 1986-12-01 | 1 | 4 | |||||||||||||||||
| 733 | 733 | 01-RC-018800 | A 1 | 1986-12-12 | T | 1 | 0 | 1986-12-12 | S | 2 | 0 | 2 | 3 | 233 233 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 1 | 0 | 0 | 0 | 1986-12-22 | 1 | 3 | ||||||||||||||||||
| 738 | 738 | 01-RC-018805 | A 1 | 1986-12-16 | T | 1 | 0 | 1986-12-16 | S | 52 | 0 | 0 | 8 | 0 | 25 | 3 | 233 233 | 27 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 1 | 0 | 0 | 0 | ||||||||||||||||||||
| 742 | 742 | 01-RC-018809 | A 1 | 1986-12-23 | T | 1 | 0 | 1986-12-23 | S | 5 | 0 | 4 | 3 | 233 233 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 0 | 1987-01-07 | 1 | 3 | ||||||||||||||||||
| 747 | 747 | 01-RC-018813 | A 1 | 1987-04-03 | T | 1 | 0 | 1987-04-03 | R | 11 | 0 | 9 | 3 | 233 233 | 1 | 2 | 2 | 241 241 | 0 | 0 | 0 | 1 | 0 | 1 1 | 0 | F | 5 | 0 | 0 | 0 | 1987-04-14 | 7 | 3 | ||||||||||||||||
| 756 | 756 | 01-RC-018825 | A 1 | 1987-01-22 | T | 1 | 0 | 1987-01-22 | S | 9 | 0 | 0 | 8 | 0 | 4 | 3 | 233 233 | 4 | 1 | 0 | 1 | 0 | 2 2 | 1 | B | 1 | 0 | 0 | 0 | 1987-03-24 | 1 | 3 | |||||||||||||||||
| 757 | 757 | 01-RC-018825 | B 1 | 1987-03-13 | T | A | 0 | 1987-03-06 | S | 9 | 0 | 5 | 3 | 233 233 | 0 | 0 | 4 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 0 | 1987-03-24 | 1 | 3 | ||||||||||||||||||
| 772 | 772 | 01-RC-018841 | A 1 | 1987-03-20 | T | 1 | 0 | 1987-03-20 | S | 37 | 0 | 0 | 8 | 0 | 12 | 3 | 233 233 | 25 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 1 | 0 | 0 | 0 | 1987-04-16 | X | 4 | |||||||||||||||||
| 775 | 775 | 01-RC-018847 | A 1 | 1987-03-03 | T | 1 | 0 | 1987-03-03 | S | 14 | 0 | 10 | 3 | 233 233 | 0 | 0 | 3 | 1 | 0 | 1 | 0 | 1 1 | 0 | B | 1 | 0 | 0 | 0 | 1987-03-11 | 1 | 3 | ||||||||||||||||||
| 778 | 778 | 01-RC-018850 | A | 1987-06-26 | T | 1 | 0 | 1987-06-26 | S | 19 | 0 | 0 | 8 | 0 | 3 | 3 | 233 233 | 14 | 1 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 0 | 1987-07-06 | 1 | 4 | |||||||||||||||||
| 781 | 781 | 01-RC-018854 | A 1 | 1987-04-13 | T | 1 | 0 | 1987-04-13 | S | 22 | 0 | 15 | 3 | 233 233 | 0 | 0 | 4 | 1 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 1987-05-21 | X | 3 | |||||||||||||||||||
| 789 | 789 | 01-RC-018863 | A | 1987-06-12 | T | 1 | 0 | 1987-06-12 | R | 13 | 0 | 10 | 3 | 233 233 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 1987-06-22 | 7 | 3 | |||||||||||||||||||
| 790 | 790 | 01-RC-018864 | A | 1987-05-20 | T | 1 | 0 | 1987-05-20 | S | 6 | 0 | 4 | 3 | 233 233 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 1987-05-28 | 1 | 3 | |||||||||||||||||||
| 792 | 792 | 01-RC-018866 | A | 1987-05-21 | T | 1 | 0 | 1987-05-21 | S | 12 | 0 | 0 | 8 | 0 | 0 | 3 | 233 233 | 12 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 1987-05-29 | 1 | 3 | ||||||||||||||||||
| 807 | 807 | 01-RC-018883 | A | 1987-07-30 | T | 1 | 0 | 1987-07-30 | R | 19 | 0 | 0 | 8 | 0 | 7 | 3 | 233 233 | 8 | 2 | 0 | 1 | 0 | 2 2 | 1 | B | 0 | 0 | 0 | 0 | 1987-09-10 | 7 | 4 | |||||||||||||||||
| 808 | 808 | 01-RC-018883 | B | 1987-09-10 | T | A | 0 | 1987-07-30 | R | 19 | 0 | 0 | 8 | 0 | 7 | 3 | 233 233 | 8 | 1 | 0 | 1 | 0 | 2 2 | 0 | B | 0 | 0 | 0 | 1987-09-10 | 7 | 4 | ||||||||||||||||||
| 816 | 816 | 01-RC-018895 | A | 1987-06-19 | T | 1 | 0 | 1987-06-19 | S | 56 | 0 | 34 | 3 | 233 233 | 0 | 0 | 9 | 2 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 1987-06-29 | 1 | 3 | |||||||||||||||||||
| 827 | 827 | 01-RC-018909 | A | 1987-07-31 | T | 1 | 0 | 1987-07-31 | S | 8 | 0 | 0 | 8 | 0 | 0 | 3 | 233 233 | 6 | 0 | 0 | 1 | 0 | 1 1 | 0 | B | 0 | 0 | 0 | 0 | 1987-08-10 | 7 | 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]) );