rc_elect
75,894 rows
Suggested facets: suffix, unit, description_election, expedited, type_election, join_union_won, union_won_intl_type, joint_union_lost_1, union_lost_intl_1_type, joint_union_lost_2, union_lost_votes_2, union_lost_intl_2_type, union_lost_intl_2, void_votes, elect_vote_control, control, conclusive, challenges_determinative, patric_union, incumb_union, mail_ballot, cross_petition, runoff_necessary, cross_pet_case_number, rerun_runoff_number, impounded, stage, method, election_date (date), date_election_held (date), date_elect_certified (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01-RC-015889 | A | 1978-11-15 | C | 1 | 0 | 1978-11-15 | S | 44 | 0 | 0 | 8 | 0 | 17 | 1 | 121 | 16 | 6 | 0 | 1 | 0 | 2 | 1 | A | 0 | 0 | 0 | 0 | 1985-01-30 | X | 4 | |||||||||||||||||
| 01-RC-015889 | B | 1979-09-24 | C | A | 0 | 1978-11-15 | S | 44 | 0 | 0 | 8 | 0 | 17 | 1 | 121 | 18 | 0 | 0 | 1 | 0 | 1 | 0 | A | 0 | 0 | 0 | 0 | 1985-01-30 | X | 4 | |||||||||||||||||
| 01-RC-017183 | B | 1984-07-03 | D | A | 0 | 1981-06-12 | S | 23 | 0 | 12 | 1 | 178 | 0 | 0 | 11 | 0 | 0 | 1 | 0 | 1 | A | 0 | 0 | 1984-07-10 | X | 3 | |||||||||||||||||||||
| 01-RC-017441 | A | 1981-11-17 | A | 1 | 0 | 1981-11-17 | R | 45 | 0 | 0 | 8 | 0 | 19 | 1 | 342 | 20 | 4 | 0 | 1 | 0 | 2 | 1 | A | 0 | 0 | 0 | 0 | ||||||||||||||||||||
| 01-RC-017475 | A | 1982-02-04 | P | 1 | 0 | 1982-02-04 | R | 59 | 0 | 0 | 8 | 0 | 29 | 1 | 451 | 26 | 4 | 0 | 1 | 0 | 2 | 1 | A | 0 | 0 | 0 | 0 | 1986-10-16 | 7 | 3 | |||||||||||||||||
| 01-RC-017569 | A | 1984-01-26 | C | 1 | 0 | 1984-01-26 | R | 50 | 0 | 0 | 8 | 0 | 7 | 1 | 61 | 39 | 0 | 0 | 1 | 0 | 1 | A | 0 | 0 | 1984-02-06 | 7 | 4 | ||||||||||||||||||||
| 01-RC-017700 | A | 1982-09-29 | A | 1 | 0 | 1982-09-29 | R | 113 | 0 | 0 | 8 | 0 | 33 | 1 | 61 | 80 | 0 | 0 | 1 | 0 | 1 | 0 | A | 0 | 0 | 0 | 0 | ||||||||||||||||||||
| 01-RC-017718 | A | 1982-10-22 | Z | 1 | 0 | 1982-10-22 | S | 317 | 0 | 0 | 8 | 0 | 86 | 1 | 241 | 195 | 24 | 1 | 1 | 0 | 1 | A | 1 | 0 | 0 | 1984-04-20 | X | 4 | |||||||||||||||||||
| 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 | 18 | 0 | 0 | 9 | 0 | 1 | 0 | H | I | 0 | 1 | 0 | 01-RC-018471 | 0 | 1985-07-09 | 7 | 3 | ||||||||||||
| 01-RC-017751 | A A | 1985-06-27 | Z | 1 | 0 | 1985-06-27 | R | 7 | 1 | 5 | 9 | 1 | 0 | 1 | 61 | 2 | 0 | 0 | 1 | 0 | 1 | 0 | H | 0 | 0 | 0 | 0 | 1985-07-09 | 7 | 3 | |||||||||||||||||
| 01-RC-017751 | A B | 1985-06-27 | Z | 1 | 0 | 1985-06-27 | R | 17 | 0 | 10 | 9 | 0 | 1 | 1 | 61 | 0 | 0 | 0 | 5 | 0 | 1 | 0 | H | 0 | 0 | 1 | 0 | 01-RC-018471 | 0 | 1985-07-09 | 7 | 3 | |||||||||||||||
| 01-RC-017764 | A | 1982-12-07 | Z | 1 | 0 | 1982-12-07 | S | 25 | 0 | 0 | 8 | 0 | 3 | 1 | 187 | 16 | 0 | 0 | 1 | 0 | 1 | 0 | A | 0 | 0 | 0 | 0 | ||||||||||||||||||||
| 01-RC-017785 | A | 1983-09-19 | Z | 1 | 0 | 1983-09-19 | R | 20 | 0 | 0 | 8 | 0 | 0 | 1 | 223 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | A | 0 | 0 | 1 | |||||||||||||||||||||
| 01-RC-017813 | A | 1983-03-04 | A | 1 | 0 | 1983-03-04 | R | 103 | 0 | 0 | 8 | 0 | 35 | 1 | 23 | 43 | 14 | 0 | 1 | 0 | 2 | 1 | A | 1 | 0 | 0 | 0 | 1986-08-29 | 7 | 4 | |||||||||||||||||
| 01-RC-017830 | A | 1983-06-02 | P | 1 | 0 | 1983-06-02 | R | 53 | 0 | 0 | 8 | 0 | 0 | 5 | 748 | 0 | 53 | 0 | 1 | 1 | 1 | 1 | C | 0 | 0 | 0 | 1 | 1985-01-25 | 7 | 3 | |||||||||||||||||
| 01-RC-017830 | P | 1985-01-16 | P | 4 | 0 | 1985-01-16 | R | 48 | 0 | 26 | 5 | 748 | 0 | 0 | 15 | 7 | 0 | 1 | 0 | 5 | 0 | C | 0 | 0 | 0 | 1985-01-25 | 7 | 3 | |||||||||||||||||||
| 01-RC-017842 | A | 1983-04-21 | T | 1 | 0 | 1983-04-21 | S | 52 | 0 | 26 | 3 | 233 | 0 | 0 | 24 | 1 | 0 | 1 | 0 | 1 | B | 0 | 0 | 1983-12-12 | X | 3 | |||||||||||||||||||||
| 01-RC-017843 | A | 1983-06-09 | Z | 1 | 0 | 1983-06-09 | S | 41 | 0 | 0 | 8 | 0 | 16 | 1 | 241 | 19 | 6 | 0 | 1 | 0 | 2 | A | 0 | 0 | 1984-05-09 | X | 4 | ||||||||||||||||||||
| 01-RC-017843 | B | 1984-04-23 | Z | A | 0 | 1983-06-09 | S | 41 | 0 | 0 | 8 | 0 | 16 | 1 | 241 | 21 | 0 | 0 | 1 | 0 | 1 | A | 0 | 0 | 1984-05-09 | X | 4 | ||||||||||||||||||||
| 01-RC-017863 | A | 1983-05-20 | A | 1 | 0 | 1983-05-20 | R | 33 | 0 | 0 | 8 | 0 | 7 | 1 | 241 | 3 | 22 | 0 | 1 | 0 | 2 | A | 0 | 0 | 1983-10-27 | 7 | 3 | ||||||||||||||||||||
| 01-RC-017863 | B | 1983-10-21 | A | A | 0 | 1983-05-20 | R | 33 | 0 | 18 | 1 | 241 | 0 | 0 | 13 | 1 | 0 | 1 | 0 | 1 | A | 0 | 0 | 1983-10-27 | 7 | 3 | |||||||||||||||||||||
| 01-RC-017896 | A | 1983-07-01 | A | 1 | 0 | 1983-07-01 | S | 85 | 0 | 0 | 8 | 0 | 37 | 1 | 452 | 43 | 3 | 0 | 1 | 0 | 1 | 0 | A | 0 | 0 | 0 | 0 | 1988-08-31 | X | 4 | |||||||||||||||||
| 01-RC-017897 | A 1 | 1983-07-01 | A | 1 | 0 | 1983-07-01 | S | 101 | 0 | 0 | 8 | 0 | 14 | 1 | 187 | 64 | 23 | 0 | 1 | 0 | 1 | 0 | A | 0 | 0 | 0 | 1983-12-13 | X | 4 | ||||||||||||||||||
| 01-RC-017897 | K 1 | 1983-12-02 | A | 3 | 0 | 1983-12-02 | S | 101 | 0 | 21 | 1 | 187 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | A | 0 | 0 | 3 | 0 | 1983-12-13 | X | 4 | ||||||||||||||||||
| 01-RC-017934 | A | 1984-04-06 | A | 1 | 0 | 1984-04-06 | R | 350 | 0 | 0 | 8 | 0 | 46 | 7 | 57 | 13 | 15 | 1 | 0 | 2 | D | 0 | 0 | 1984-05-04 | 7 | 4 | |||||||||||||||||||||
| 01-RC-017934 | B | 1984-05-04 | A | A | 0 | 1984-04-06 | R | 350 | 0 | 0 | 8 | 0 | 46 | 7 | 57 | 11 | 15 | 1 | 0 | 2 | D | 0 | 0 | 1984-05-04 | 7 | 4 | |||||||||||||||||||||
| 01-RC-017939 | A | 1983-08-19 | Z | 1 | 0 | 1983-08-19 | S | 4 | 0 | 0 | 8 | 0 | 1 | 1 | 61 | 0 | 3 | 0 | 1 | 0 | 2 | A | 0 | 0 | 1984-10-19 | X | 3 | ||||||||||||||||||||
| 01-RC-017940 | A | 1983-09-02 | T | 1 | 0 | 1983-09-02 | R | 29 | 0 | 15 | 1 | 61 | 0 | 0 | 11 | 2 | 1 | 1 | 0 | 1 | A | 0 | 0 | 1984-07-03 | 7 | 4 | |||||||||||||||||||||
| 01-RC-017940 | K | 1984-06-22 | T | 3 | 0 | 1984-06-22 | R | 35 | 0 | 0 | 8 | 0 | 1 | 1 | 61 | 25 | 0 | 1 | 1 | 0 | 1 | A | 0 | 0 | 1984-07-03 | 7 | 4 | ||||||||||||||||||||
| 01-RC-017952 | A | 1983-11-14 | W | 1 | 0 | 1983-11-14 | S | 43 | 0 | 0 | 8 | 0 | 23 | 7 | 6 | 1 | 0 | 1 | 0 | 2 | D | 1 | 0 | 0 | 1983-11-23 | 1 | 3 | ||||||||||||||||||||
| 01-RC-017953 | A | 1984-01-25 | A | 1 | 0 | 1984-01-25 | R | 69 | 0 | 0 | 8 | 0 | 22 | 3 | 233 | 39 | 0 | 0 | 1 | 1 | 1 | B | 0 | 0 | 1984-02-06 | 7 | 4 | ||||||||||||||||||||
| 01-RC-017955 | A | 1983-10-17 | C | 1 | 0 | 1983-10-17 | R | 14 | 0 | 10 | 1 | 61 | 0 | 0 | 0 | 3 | 0 | 1 | 0 | 1 | A | 0 | 0 | 1983-11-01 | 7 | 3 | |||||||||||||||||||||
| 01-RC-017962 | A | 1983-10-28 | D | 1 | 0 | 1983-10-28 | R | 3 | 0 | 0 | 8 | 0 | 0 | 1 | 23 | 2 | 1 | 0 | 1 | 0 | 1 | A | 0 | 0 | 1983-11-08 | 7 | 4 | ||||||||||||||||||||
| 01-RC-017964 | A | 1983-09-14 | D | 1 | 0 | 1983-09-14 | C | 89 | 0 | 61 | 1 | 451 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | A | 0 | 0 | 0 | 1983-09-23 | 1 | 3 | |||||||||||||||||||
| 01-RC-017968 | A | 1983-09-23 | Z | 1 | 0 | 1983-09-23 | S | 8 | 0 | 6 | 1 | 245 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 1 | A | 0 | 0 | 1983-10-04 | 1 | 3 | |||||||||||||||||||||
| 01-RC-017969 | A | 1983-09-22 | P | 1 | 0 | 1983-09-22 | C | 9 | 0 | 8 | 1 | 303 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | A | 0 | 0 | 0 | 1983-10-03 | 1 | 3 | |||||||||||||||||||
| 01-RC-017972 | A | 1983-09-16 | A | 1 | 0 | 1983-09-16 | S | 8 | 0 | 0 | 8 | 0 | 3 | 1 | 23 | 4 | 0 | 1 | 1 | 0 | 1 | A | 0 | 0 | 1983-10-26 | 1 | 4 | ||||||||||||||||||||
| 01-RC-017973 | A | 1983-09-16 | A | 1 | 0 | 1983-09-16 | S | 9 | 0 | 0 | 8 | 0 | 4 | 1 | 23 | 4 | 0 | 0 | 1 | 0 | 1 | A | 0 | 0 | 1983-11-16 | 1 | 4 | ||||||||||||||||||||
| 01-RC-017974 | A | 1983-10-06 | A | 1 | 0 | 1983-10-06 | S | 45 | 0 | 26 | 1 | 21 | 0 | 0 | 17 | 0 | 1 | 1 | 0 | 1 | A | 0 | 0 | 1983-10-17 | 1 | 3 | |||||||||||||||||||||
| 01-RC-017977 | A | 1983-10-13 | Z | 1 | 0 | 1983-10-13 | S | 13 | 0 | 0 | 8 | 0 | 3 | 1 | 61 | 10 | 0 | 0 | 1 | 0 | 1 | A | 0 | 0 | 1983-10-21 | 1 | 4 | ||||||||||||||||||||
| 01-RC-017978 | A | 1983-10-06 | T | 1 | 0 | 1983-10-06 | S | 17 | 0 | 0 | 8 | 0 | 5 | 3 | 233 | 12 | 0 | 0 | 1 | 0 | 1 | B | 0 | 0 | 1983-10-17 | 1 | 4 | ||||||||||||||||||||
| 01-RC-017982 | A 1 | 1983-10-06 | D | 1 | 0 | 1983-10-06 | S | 6 | 0 | 4 | 1 | 105 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 1 | 0 | A | 0 | 0 | 0 | 1983-10-17 | 1 | 3 | |||||||||||||||||||
| 01-RC-017983 | A | 1983-11-02 | T | 1 | 0 | 1983-11-02 | R | 420 | 0 | 0 | 8 | 0 | 133 | 3 | 233 | 218 | 17 | 3 | 1 | 0 | 1 | 0 | B | 0 | 0 | 0 | 0 | 1984-04-03 | 7 | 4 | |||||||||||||||||
| 01-RC-017984 | A | 1983-09-23 | T | 1 | 0 | 1983-09-23 | S | 2 | 0 | 2 | 1 | 23 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | A | 0 | 0 | 1983-10-04 | 1 | 3 | |||||||||||||||||||||
| 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 | D | 0 | 0 | 1983-10-11 | 1 | 3 | ||||||||||||||||||||||
| 01-RC-017986 | A 1 | 1983-11-02 | Z | 1 | 0 | 1983-11-02 | S | 144 | 0 | 0 | 8 | 0 | 56 | 1 | 219 | 83 | 2 | 0 | 1 | 0 | 1 | 0 | A | 0 | 0 | 0 | 1984-02-08 | 1 | 4 | ||||||||||||||||||
| 01-RC-017988 | A | 1983-10-04 | G | 1 | 0 | 1983-10-04 | S | 29 | 0 | 17 | 7 | 0 | 0 | 10 | 0 | 1 | 1 | 0 | 1 | D | 0 | 0 | 1983-10-13 | 1 | 3 | ||||||||||||||||||||||
| 01-RC-017989 | A 1 | 1983-10-14 | A | 1 | 0 | 1983-10-14 | S | 29 | 0 | 0 | 8 | 0 | 14 | 1 | 471 | 14 | 1 | 0 | 1 | 0 | 2 | 1 | A | 0 | 0 | 0 | 1984-04-27 | X | 4 | ||||||||||||||||||
| 01-RC-017990 | A | 1983-10-27 | T | 1 | 0 | 1983-10-27 | S | 16 | 0 | 0 | 8 | 0 | 6 | 3 | 233 | 10 | 0 | 0 | 1 | 0 | 1 | B | 0 | 0 | 1983-11-07 | 1 | 4 | ||||||||||||||||||||
| 01-RC-017992 | A | 1983-11-04 | A | 1 | 0 | 1983-11-04 | S | 4 | 0 | 0 | 8 | 0 | 0 | 1 | 23 | 2 | 0 | 0 | 1 | 0 | 1 | A | 0 | 0 | 1983-12-07 | X | 4 | ||||||||||||||||||||
| 01-RC-017993 | A | 1984-05-15 | A | 1 | 0 | 1984-05-15 | S | 9 | 0 | 0 | 8 | 0 | 0 | 1 | 23 | 8 | 1 | 0 | 1 | 0 | 1 | A | 0 | 0 | 1984-05-29 | 1 | 4 | ||||||||||||||||||||
| 01-RC-017995 | A | 1983-10-14 | D | 1 | 0 | 1983-10-14 | S | 268 | 0 | 0 | 8 | 0 | 84 | 1 | 61 | 172 | 0 | 0 | 1 | 0 | 1 | A | 0 | 0 | 1983-10-25 | 1 | 4 | ||||||||||||||||||||
| 01-RC-017996 | A | 1983-10-20 | A | 1 | 0 | 1983-10-20 | S | 6 | 0 | 4 | 1 | 61 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 1 | A | 0 | 0 | 1983-11-08 | 1 | 3 | |||||||||||||||||||||
| 01-RC-017997 | A | 1984-07-30 | A | 1 | 0 | 1984-07-30 | S | 47 | 0 | 0 | 8 | 0 | 16 | 1 | 141 | 21 | 5 | 0 | 1 | 0 | 2 | A | 0 | 0 | 1984-08-08 | 1 | 4 | ||||||||||||||||||||
| 01-RC-017998 | A | 1983-11-10 | A | 1 | 0 | 1983-11-10 | R | 80 | 0 | 0 | 8 | 0 | 44 | 1 | 31 | 29 | 3 | 0 | 1 | 1 | 2 | A | 1 | 0 | 0 | 1983-11-21 | 7 | 3 | |||||||||||||||||||
| 01-RC-017999 | A | 1983-09-23 | A | 1 | 0 | 1983-09-23 | S | 14 | 0 | 0 | 8 | 0 | 6 | 2 | 223 | 8 | 0 | 0 | 1 | 0 | 1 | A | 0 | 0 | 1983-10-04 | 1 | 4 | ||||||||||||||||||||
| 01-RC-018000 | A | 1983-10-21 | A | 1 | 0 | 1983-10-21 | S | 36 | 0 | 23 | 1 | 23 | 0 | 0 | 4 | 2 | 0 | 1 | 0 | 1 | A | 0 | 0 | 1983-11-04 | 1 | 3 | |||||||||||||||||||||
| 01-RC-018001 | A | 1983-10-26 | A | 1 | 0 | 1983-10-26 | S | 147 | 0 | 0 | 8 | 0 | 28 | 3 | 233 | 105 | 0 | 1 | 1 | 0 | 1 | B | 0 | 0 | 1983-11-04 | 1 | 4 | ||||||||||||||||||||
| 01-RC-018002 | A | 1983-10-28 | A | 1 | 0 | 1983-10-28 | S | 41 | 0 | 0 | 8 | 0 | 11 | 3 | 233 | 21 | 8 | 0 | 1 | 0 | 1 | 0 | B | 0 | 0 | 0 | 0 | 1983-11-09 | X | 4 | |||||||||||||||||
| 01-RC-018003 | A | 1983-10-25 | A | 1 | 0 | 1983-10-25 | S | 86 | 0 | 0 | 8 | 0 | 30 | 1 | 241 | 51 | 4 | 0 | 1 | 0 | 1 | A | 0 | 0 | 1983-11-03 | 1 | 4 | ||||||||||||||||||||
| 01-RC-018005 | A | 1983-11-10 | P | 1 | 0 | 1983-11-10 | S | 310 | 0 | 0 | 8 | 0 | 128 | 7 | 167 | 0 | 0 | 1 | 0 | 1 | D | 0 | 0 | 1983-11-21 | 1 | 4 | |||||||||||||||||||||
| 01-RC-018006 | B 1 | 1983-12-02 | A | A | 0 | 1983-12-02 | S | 6 | 0 | 0 | 8 | 0 | 0 | 3 | 233 | 4 | 0 | 0 | 3 | 0 | 1 | B | 1 | 0 | 1 | 0 | 01-RC-000000 | 1983-12-15 | 1 | 3 | |||||||||||||||||
| 01-RC-018007 | A | 1983-10-20 | W | 1 | 0 | 1983-10-20 | S | 11 | 0 | 0 | 8 | 0 | 4 | 3 | 233 | 0 | 1 | 0 | 1 | 0 | 2 | B | 0 | 0 | 1983-10-31 | 1 | 4 | ||||||||||||||||||||
| 01-RC-018008 | A | 1983-11-23 | A | 1 | 0 | 1983-11-23 | S | 40 | 0 | 24 | 1 | 342 | 0 | 0 | 11 | 2 | 2 | 1 | 0 | 1 | A | 1 | 0 | 0 | 1983-12-06 | 1 | 3 | ||||||||||||||||||||
| 01-RC-018010 | A | 1983-10-06 | Z | 1 | 0 | 1983-10-06 | S | 28 | 0 | 14 | 1 | 223 | 0 | 0 | 12 | 0 | 1 | 1 | 0 | 1 | A | 0 | 0 | 1983-10-17 | 1 | 3 | |||||||||||||||||||||
| 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 | D | 0 | 0 | 1983-10-11 | 1 | 3 | ||||||||||||||||||||||
| 01-RC-018013 | A | 1983-12-07 | A | 1 | 0 | 1983-12-07 | R | 78 | 0 | 35 | 1 | 241 | 0 | 0 | 21 | 13 | 1 | 1 | 0 | 1 | A | 0 | 0 | 1984-01-06 | 7 | 3 | |||||||||||||||||||||
| 01-RC-018015 | A | 1983-10-14 | A | 1 | 0 | 1983-10-14 | R | 94 | 0 | 0 | 8 | 0 | 4 | 1 | 241 | 0 | 0 | 1 | 241 | 12 | 0 | 0 | 1 | 0 | 1 | 0 | E | 0 | 0 | 0 | 1989-03-30 | X | 3 | ||||||||||||||
| 01-RC-018016 | A | 1983-11-03 | D | 1 | 0 | 1983-11-03 | S | 5 | 0 | 0 | 8 | 0 | 2 | 1 | 105 | 2 | 0 | 0 | 1 | 0 | 1 | A | 0 | 0 | 1984-02-24 | X | 4 | ||||||||||||||||||||
| 01-RC-018017 | A | 1983-11-30 | R | 1 | 0 | 1983-11-30 | S | 42 | 0 | 0 | 8 | 0 | 12 | 1 | 23 | 28 | 2 | 0 | 1 | 0 | 1 | A | 0 | 0 | 1983-12-09 | 1 | 4 | ||||||||||||||||||||
| 01-RC-018019 | A | 1983-10-26 | A | 1 | 0 | 1983-10-26 | S | 33 | 0 | 0 | 8 | 0 | 0 | 7 | 0 | 14 | 4 | 233 | 12 | 7 | 0 | 1 | 0 | 2 | 1 | K | 0 | 0 | 0 | 0 | |||||||||||||||||
| 01-RC-018021 | A | 1983-10-26 | P | 1 | 0 | 1983-10-26 | S | 53 | 0 | 26 | 1 | 219 | 0 | 0 | 8 | 2 | 0 | 1 | 0 | 1 | A | 0 | 0 | 1983-11-04 | 1 | 3 | |||||||||||||||||||||
| 01-RC-018022 | A | 1984-01-06 | T | 1 | 0 | 1984-01-06 | R | 48 | 0 | 0 | 8 | 0 | 2 | 3 | 233 | 41 | 0 | 0 | 1 | 0 | 1 | B | 0 | 0 | 1984-01-17 | 7 | 4 | ||||||||||||||||||||
| 01-RC-018023 | A | 1984-04-10 | T | 1 | 0 | 1984-04-10 | S | 20 | 0 | 10 | 3 | 233 | 0 | 0 | 6 | 3 | 0 | 1 | 0 | 1 | 0 | B | 0 | 0 | 0 | 0 | 1988-02-29 | X | 3 | ||||||||||||||||||
| 01-RC-018024 | A | 1983-11-04 | A | 1 | 0 | 1983-11-04 | S | 41 | 0 | 25 | 7 | 0 | 0 | 12 | 3 | 0 | 1 | 0 | 1 | 0 | D | 0 | 0 | 0 | 1983-11-15 | 1 | 3 | ||||||||||||||||||||
| 01-RC-018025 | A | 1983-10-28 | Z | 1 | 0 | 1983-10-28 | S | 8 | 0 | 0 | 8 | 0 | 0 | 3 | 233 | 7 | 1 | 0 | 1 | 0 | 1 | B | 0 | 0 | 1983-11-08 | 1 | 4 | ||||||||||||||||||||
| 01-RC-018026 | A | 1983-11-10 | W | 1 | 0 | 1983-11-10 | S | 17 | 0 | 0 | 8 | 0 | 4 | 3 | 233 | 3 | 6 | 0 | 1 | 0 | 2 | B | 1 | 0 | 0 | 1983-12-30 | X | 4 | |||||||||||||||||||
| 01-RC-018027 | A | 1983-11-23 | D | 1 | 0 | 1983-11-23 | S | 54 | 0 | 0 | 8 | 0 | 23 | 3 | 233 | 30 | 0 | 1 | 1 | 0 | 1 | B | 0 | 0 | 1983-12-05 | 1 | 4 | ||||||||||||||||||||
| 01-RC-018028 | A | 1983-11-16 | A | 1 | 0 | 1983-11-16 | S | 74 | 0 | 0 | 8 | 0 | 26 | 3 | 233 | 38 | 6 | 0 | 1 | 0 | 1 | B | 1 | 0 | 0 | 1983-11-25 | 1 | 4 | |||||||||||||||||||
| 01-RC-018029 | A | 1983-12-06 | A | 1 | 0 | 1983-12-06 | R | 35 | 0 | 0 | 8 | 0 | 10 | 7 | 17 | 2 | 1 | 1 | 0 | 1 | D | 0 | 0 | 1983-12-15 | 7 | 4 | |||||||||||||||||||||
| 01-RC-018031 | A | 1983-11-10 | G | 1 | 0 | 1983-11-10 | S | 8 | 0 | 0 | 8 | 0 | 4 | 7 | 3 | 0 | 0 | 1 | 0 | 1 | D | 1 | 0 | 0 | 1983-12-06 | 1 | 3 | ||||||||||||||||||||
| 01-RC-018032 | A | 1983-11-14 | R | 1 | 0 | 1983-11-14 | S | 45 | 0 | 30 | 1 | 23 | 0 | 0 | 5 | 3 | 0 | 1 | 0 | 1 | 0 | A | 1 | 0 | 0 | 0 | 1983-11-23 | 1 | 3 | ||||||||||||||||||
| 01-RC-018033 | A | 1983-12-07 | A | 1 | 0 | 1983-12-07 | R | 19 | 0 | 8 | 7 | 0 | 0 | 2 | 9 | 0 | 1 | 0 | 1 | D | 0 | 0 | |||||||||||||||||||||||||
| 01-RC-018034 | A | 1983-11-18 | T | 1 | 0 | 1983-11-18 | S | 2 | 0 | 2 | 3 | 233 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | B | 0 | 0 | 1983-11-30 | 1 | 3 | |||||||||||||||||||||
| 01-RC-018036 | A | 1983-12-09 | Z | 1 | 0 | 1983-12-09 | S | 12 | 0 | 9 | 3 | 233 | 0 | 0 | 0 | 2 | 0 | 1 | 0 | 1 | B | 0 | 0 | 1983-12-20 | 1 | 3 | |||||||||||||||||||||
| 01-RC-018037 | A | 1983-11-10 | T | 1 | 0 | 1983-11-10 | S | 7 | 0 | 0 | 8 | 0 | 0 | 3 | 233 | 6 | 1 | 0 | 1 | 0 | 1 | B | 1 | 0 | 0 | 1983-11-21 | 1 | 4 | |||||||||||||||||||
| 01-RC-018038 | A | 1983-12-01 | A | 1 | 0 | 1983-12-01 | S | 80 | 0 | 39 | 3 | 233 | 0 | 0 | 31 | 6 | 0 | 1 | 0 | 1 | 0 | B | 0 | 0 | 0 | 0 | 1984-04-05 | X | 3 | ||||||||||||||||||
| 01-RC-018038 | B | 1983-12-01 | A | A | 0 | 1983-12-01 | S | 80 | 0 | 39 | 3 | 233 | 0 | 0 | 31 | 6 | 0 | 3 | 0 | 1 | B | 0 | 1 | 0 | 01-RC-000000 | 1984-04-05 | X | 3 | |||||||||||||||||||
| 01-RC-018039 | A | 1983-11-18 | T | 1 | 0 | 1983-11-18 | S | 16 | 0 | 12 | 3 | 233 | 0 | 0 | 4 | 0 | 0 | 1 | 0 | 1 | B | 0 | 0 | 1984-01-13 | X | 3 | |||||||||||||||||||||
| 01-RC-018040 | A | 1983-12-01 | T | 1 | 0 | 1983-12-01 | S | 12 | 0 | 5 | 7 | 0 | 0 | 5 | 0 | 0 | 3 | 0 | 1 | 1 | 0 | 1 | 0 | 01-RC-000000 | 1983-12-01 | 1 | 3 | ||||||||||||||||||||
| 01-RC-018041 | A | 1983-11-14 | D | 1 | 0 | 1983-11-14 | S | 24 | 0 | 0 | 8 | 0 | 0 | 3 | 233 | 20 | 0 | 0 | 1 | 0 | 1 | B | 1 | 0 | 0 | 1984-08-31 | X | 4 | |||||||||||||||||||
| 01-RC-018042 | A | 1983-12-15 | R | 1 | 0 | 1983-12-15 | S | 48 | 0 | 32 | 7 | 0 | 0 | 3 | 3 | 0 | 1 | 0 | 1 | D | 0 | 0 | 1983-12-28 | 1 | 3 | ||||||||||||||||||||||
| 01-RC-018043 | A | 1983-12-07 | C | 1 | 0 | 1983-12-07 | S | 128 | 0 | 0 | 8 | 0 | 22 | 3 | 233 | 97 | 1 | 0 | 1 | 0 | 1 | B | 0 | 0 | 1983-12-16 | 1 | 4 | ||||||||||||||||||||
| 01-RC-018044 | A | 1983-11-23 | A | 1 | 1 | 1983-11-23 | S | 8 | 0 | 5 | 1 | 130 | 0 | 0 | 2 | 1 | 0 | 1 | 0 | 1 | A | 0 | 0 | 1983-12-05 | 1 | 3 | |||||||||||||||||||||
| 01-RC-018045 | A | 1983-12-08 | Z | 1 | 0 | 1983-12-08 | S | 33 | 0 | 0 | 8 | 0 | 7 | 1 | 223 | 23 | 2 | 0 | 1 | 0 | 1 | A | 0 | 0 | 1983-12-19 | 1 | 4 | ||||||||||||||||||||
| 01-RC-018046 | A | 1983-12-16 | Z | 1 | 0 | 1983-12-16 | S | 6 | 0 | 4 | 3 | 233 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 1 | B | 0 | 0 | 1984-01-04 | 1 | 3 | |||||||||||||||||||||
| 01-RC-018048 | A | 1983-12-22 | A | 1 | 0 | 1983-12-22 | S | 71 | 0 | 0 | 8 | 0 | 30 | 7 | 38 | 1 | 0 | 1 | 0 | 1 | D | 0 | 0 | 1984-01-04 | 1 | 4 | |||||||||||||||||||||
| 01-RC-018049 | A | 1983-12-14 | A | 1 | 0 | 1983-12-14 | S | 22 | 0 | 0 | 8 | 0 | 9 | 9 | 9 | 3 | 0 | 1 | 0 | 2 | D | 0 | 0 | ||||||||||||||||||||||||
| 01-RC-018050 | A | 1983-12-22 | A | 1 | 0 | 1983-12-22 | S | 93 | 0 | 0 | 8 | 0 | 30 | 3 | 233 | 59 | 0 | 3 | 1 | 0 | 1 | B | 0 | 0 | 1984-01-06 | 1 | 4 | ||||||||||||||||||||
| 01-RC-018051 | A 1 | 1984-02-29 | P | 1 | 0 | 1984-02-29 | R | 122 | 0 | 64 | 1 | 219 | 0 | 0 | 50 | 6 | 1 | 1 | 0 | 1 | A | 0 | 0 | 1984-03-16 | 7 | 3 |
Table schema
CREATE TABLE rc_elect(case_number VARCHAR, suffix VARCHAR, election_date DATE, unit VARCHAR, description_election VARCHAR, expedited BIGINT, date_election_held DATE, type_election VARCHAR, no_elig BIGINT, join_union_won BIGINT, union_won_votes BIGINT, union_won_intl_type BIGINT, union_won_intl BIGINT, joint_union_lost_1 BIGINT, union_lost_votes_1 BIGINT, union_lost_intl_1_type BIGINT, union_lost_intl_1 BIGINT, joint_union_lost_2 BIGINT, union_lost_votes_2 BIGINT, union_lost_intl_2_type BIGINT, union_lost_intl_2 BIGINT, joint_union_lost_3 BIGINT, union_lost_votes_3 BIGINT, union_lost_intl_3_type VARCHAR, union_lost_intl_3 BIGINT, joint_union_lost_4 BIGINT, union_lost_votes_4 BIGINT, union_lost_intl_4_type VARCHAR, union_lost_intl_4 BIGINT, votes_against_union BIGINT, challenges BIGINT, void_votes BIGINT, elect_vote_control BIGINT, control BIGINT, conclusive BIGINT, challenges_determinative BIGINT, patric_union VARCHAR, incumb_union VARCHAR, mail_ballot BIGINT, union_control VARCHAR, cross_petition BIGINT, runoff_necessary BIGINT, cross_pet_case_number VARCHAR, rerun_runoff_number BIGINT, impounded BIGINT, date_elect_certified DATE, stage VARCHAR, "method" VARCHAR);