election

One row per NLRB election event. An election is identified by case_number + voting_unit_id + date + ballot_type + tally_type — a single case can produce more than one election (e.g. a runoff or a re-run after objections).
ballot_type
Whether ballots were manual, mail, mixed, or another mode.
case_number
Foreign key to filing.case_number.
created_at
Scrape timestamp.
date
Date the election was held (ISO 8601, YYYY-MM-DD).
election_id
Synthetic auto-increment identifier for this election.
tally_type
NLRB tally-type designation (e.g. initial, re-run, runoff).
unit_size
Number of workers in the voting unit at the time of the election.
voting_unit_id
Foreign key to voting_unit.voting_unit_id.

33,702 rows

✎ View and edit SQL

Suggested facets: tally_type, ballot_type, date (date), created_at (date)

election_id ▼ case_number voting_unit_id date tally_type ballot_type unit_size created_at
1 01-RC-020966 1 1999-03-17 Initial Single Labor Organization 7 2021-05-28 23:57:49
2 01-RC-020986 2 1999-04-22 Initial Single Labor Organization 160 2021-05-28 23:57:49
3 01-RC-021152 3 2000-04-27 Initial Single Labor Organization 487 2021-05-28 23:57:49
4 01-RC-021561 4 2002-11-07 Initial Two Labor Organizations 106 2021-05-28 23:57:49
5 01-RC-022002 5 2007-04-25 Initial Single Labor Organization 9 2021-05-28 23:57:49
6 01-RC-022034 6 2006-11-17 Initial Single Labor Organization 14 2021-05-28 23:57:49
7 01-RC-022035 7 2006-11-17 Initial Single Labor Organization 26 2021-05-28 23:57:49
8 01-RC-022038 8 2006-08-26 Initial Single Labor Organization 41 2021-05-28 23:57:49
9 01-RC-022044 9 2007-03-06 Initial Single Labor Organization 8 2021-05-28 23:57:49
10 01-RC-022056 10 2006-11-01 Initial Single Labor Organization 40 2021-05-28 23:57:49
11 01-RC-022066 11 2006-12-29 Initial Single Labor Organization 19 2021-05-28 23:57:49
12 01-RC-022067 12 2007-01-12 Initial Single Labor Organization 6 2021-05-28 23:57:49
13 01-RC-022068 13 2007-01-18 Initial Single Labor Organization 16 2021-05-28 23:57:49
14 01-RC-022070 14 2007-01-18 Initial Single Labor Organization 9 2021-05-28 23:57:49
15 01-RC-022071 15 2007-01-26 Initial Single Labor Organization 36 2021-05-28 23:57:49
16 01-RC-022072 16 2007-01-30 Initial Single Labor Organization 11 2021-05-28 23:57:49
17 01-RC-022073 17 2007-02-01 Initial Single Labor Organization 51 2021-05-28 23:57:49
18 01-RC-022074 18 2007-01-30 Initial Single Labor Organization 6 2021-05-28 23:57:49
19 01-RC-022077 19 2007-02-14 Initial Single Labor Organization 222 2021-05-28 23:57:49
20 01-RC-022078 20 2007-02-01 Initial Single Labor Organization 2 2021-05-28 23:57:49
21 01-RC-022079 21 2007-02-09 Initial Single Labor Organization 24 2021-05-28 23:57:49
22 01-RC-022080 22 2007-02-15 Initial Single Labor Organization 41 2021-05-28 23:57:49
23 01-RC-022081 23 2007-03-01 Initial Single Labor Organization 24 2021-05-28 23:57:49
24 01-RC-022082 24 2007-03-01 Initial Single Labor Organization 4 2021-05-28 23:57:49
25 01-RC-022083 25 2007-03-02 Initial Single Labor Organization 36 2021-05-28 23:57:49
26 01-RC-022086 26 2007-03-08 Initial Single Labor Organization 2 2021-05-28 23:57:49
27 01-RC-022087 27 2007-07-31 Initial Two Labor Organizations 455 2021-05-28 23:57:49
28 01-RC-022087 27 2009-07-31 Rerun Two Labor Organizations 634 2021-05-28 23:57:49
29 01-RC-022087 27 2009-09-14 Run-off Single Labor Organization 634 2021-05-28 23:57:49
30 01-RC-022088 28 2007-04-12 Initial Single Labor Organization 8 2021-05-28 23:57:49
31 01-RC-022088 28 2007-11-02 Rerun Single Labor Organization 8 2021-05-28 23:57:49
32 01-RC-022089 29 2007-03-22 Initial Single Labor Organization 46 2021-05-28 23:57:49
33 01-RC-022090 30 2007-03-29 Initial Single Labor Organization 3 2021-05-28 23:57:49
34 01-RC-022091 31 2007-03-16 Initial Single Labor Organization 26 2021-05-28 23:57:49
35 01-RC-022092 32 2007-07-31 Initial Two Labor Organizations 455 2021-05-28 23:57:49
36 01-RC-022092 32 2009-07-31 Rerun Two Labor Organizations 634 2021-05-28 23:57:49
37 01-RC-022093 33 2007-04-06 Initial Single Labor Organization 5 2021-05-28 23:57:49
38 01-RC-022094 34 2007-04-11 Initial Single Labor Organization 58 2021-05-28 23:57:49
39 01-RC-022095 35 2007-04-04 Initial Single Labor Organization 39 2021-05-28 23:57:49
40 01-RC-022097 36 2007-04-25 Initial Single Labor Organization 6 2021-05-28 23:57:49
41 01-RC-022100 37 2007-06-07 Initial Single Labor Organization 43 2021-05-28 23:57:49
42 01-RC-022101 38 2007-04-27 Initial Single Labor Organization 12 2021-05-28 23:57:49
43 01-RC-022104 39 2007-05-17 Initial Single Labor Organization 9 2021-05-28 23:57:49
44 01-RC-022107 40 2007-05-10 Initial Single Labor Organization 18 2021-05-28 23:57:49
45 01-RC-022108 41 2007-05-24 Initial Single Labor Organization 58 2021-05-28 23:57:49
46 01-RC-022109 42 2007-06-19 Initial Single Labor Organization 54 2021-05-28 23:57:49
47 01-RC-022109 42 2008-06-23 Rerun Single Labor Organization 53 2021-05-28 23:57:49
48 01-RC-022111 43 2007-06-06 Initial Single Labor Organization 176 2021-05-28 23:57:49
49 01-RC-022112 44 2007-06-01 Initial Single Labor Organization 22 2021-05-28 23:57:49
50 01-RC-022113 45 2007-06-13 Initial Single Labor Organization 7 2021-05-28 23:57:49
51 01-RC-022114 46 2007-06-08 Initial Single Labor Organization 57 2021-05-28 23:57:49
52 01-RC-022115 47 2007-07-20 Initial Single Labor Organization 35 2021-05-28 23:57:49
53 01-RC-022116 48 2007-08-14 Initial Single Labor Organization 3 2021-05-28 23:57:49
54 01-RC-022117 49 2007-06-18 Initial Single Labor Organization 101 2021-05-28 23:57:49
55 01-RC-022120 50 2007-06-21 Initial Single Labor Organization 13 2021-05-28 23:57:49
56 01-RC-022121 51 2007-07-19 Initial Single Labor Organization 71 2021-05-28 23:57:49
57 01-RC-022123 52 2007-08-08 Initial Single Labor Organization 7 2021-05-28 23:57:49
58 01-RC-022124 53 2007-07-13 Initial Single Labor Organization 6 2021-05-28 23:57:49
59 01-RC-022126 54 2007-08-03 Initial Single Labor Organization 11 2021-05-28 23:57:49
60 01-RC-022127 55 2007-08-08 Initial Single Labor Organization 12 2021-05-28 23:57:49
61 01-RC-022131 56 2007-09-11 Initial Two Labor Organizations 46 2021-05-28 23:57:49
62 01-RC-022132 57 2007-08-17 Initial Single Labor Organization 40 2021-05-28 23:57:49
63 01-RC-022134 58 2007-08-23 Initial Single Labor Organization 34 2021-05-28 23:57:49
64 01-RC-022135 59 2007-08-13 Initial Single Labor Organization 5 2021-05-28 23:57:49
65 01-RC-022136 60 2007-09-20 Initial Single Labor Organization 62 2021-05-28 23:57:49
66 01-RC-022137 61 2007-09-13 Initial Single Labor Organization 20 2021-05-28 23:57:49
67 01-RC-022139 62 2007-10-04 Initial Single Labor Organization 25 2021-05-28 23:57:49
68 01-RC-022139 62 2008-04-11 Rerun Single Labor Organization 25 2021-05-28 23:57:49
69 01-RC-022140 63 2007-10-05 Initial Single Labor Organization 26 2021-05-28 23:57:49
70 01-RC-022140 63 2008-02-25 Rerun Single Labor Organization 28 2021-05-28 23:57:49
71 01-RC-022140 63 2007-12-10 Rerun Single Labor Organization 28 2021-05-28 23:57:49
72 01-RC-022141 64 2007-10-04 Initial Single Labor Organization 35 2021-05-28 23:57:49
73 01-RC-022142 65 2007-10-04 Initial Single Labor Organization 4 2021-05-28 23:57:49
74 01-RC-022143 66 2007-11-02 Initial Single Labor Organization 8 2021-05-28 23:57:49
75 01-RC-022145 67 2007-11-09 Initial Single Labor Organization 33 2021-05-28 23:57:49
76 01-RC-022146 68 2007-11-15 Initial Single Labor Organization 46 2021-05-28 23:57:49
77 01-RC-022148 69 2007-11-20 Initial Single Labor Organization 8 2021-05-28 23:57:49
78 01-RC-022149 70 2007-11-20 Initial Single Labor Organization 3 2021-05-28 23:57:49
79 01-RC-022151 71 2007-11-16 Initial Single Labor Organization 65 2021-05-28 23:57:49
80 01-RC-022153 72 2007-12-04 Initial Single Labor Organization 67 2021-05-28 23:57:49
81 01-RC-022154 73 2007-12-07 Initial Single Labor Organization 7 2021-05-28 23:57:49
82 01-RC-022155 74 2007-12-06 Initial Single Labor Organization 4 2021-05-28 23:57:49
83 01-RC-022158 75 2008-01-30 Initial Single Labor Organization 6 2021-05-28 23:57:49
84 01-RC-022159 76 2008-01-04 Initial Single Labor Organization 72 2021-05-28 23:57:49
85 01-RC-022162 77 2008-06-14 Initial Single Labor Organization 134 2021-05-28 23:57:49
86 01-RC-022162 77 2009-06-21 Rerun Single Labor Organization 129 2021-05-28 23:57:49
87 01-RC-022162 77 2010-07-18 Rerun Single Labor Organization 126 2021-05-28 23:57:49
88 01-RC-022163 78 2008-01-16 Initial Single Labor Organization 83 2021-05-28 23:57:49
89 01-RC-022164 79 2008-01-16 Initial Single Labor Organization 162 2021-05-28 23:57:49
90 01-RC-022165 80 2008-01-24 Initial Single Labor Organization 17 2021-05-28 23:57:49
91 01-RC-022165 80 2009-02-11 Rerun Single Labor Organization 17 2021-05-28 23:57:49
92 01-RC-022167 81 2008-01-25 Initial Single Labor Organization 9 2021-05-28 23:57:49
93 01-RC-022171 82 2008-02-27 Initial Single Labor Organization 166 2021-05-28 23:57:49
94 01-RC-022171 82 2008-03-20 Rerun Single Labor Organization 166 2021-05-28 23:57:49
95 01-RC-022172 83 2008-01-31 Initial Single Labor Organization 87 2021-05-28 23:57:49
96 01-RC-022173 84 2008-02-01 Initial Single Labor Organization 107 2021-05-28 23:57:49
97 01-RC-022174 85 2008-01-31 Initial Single Labor Organization 20 2021-05-28 23:57:49
98 01-RC-022175 86 2008-01-18 Initial Single Labor Organization 2 2021-05-28 23:57:49
99 01-RC-022176 87 2008-02-05 Initial Single Labor Organization 35 2021-05-28 23:57:49
100 01-RC-022181 88 2008-03-06 Initial Single Labor Organization 96 2021-05-28 23:57:49

Next page

Download this data

CSV · JSON

Table schema 
CREATE TABLE election(election_id BIGINT, case_number VARCHAR, voting_unit_id BIGINT, date DATE, tally_type VARCHAR, ballot_type VARCHAR, unit_size BIGINT, created_at TIMESTAMP, PRIMARY KEY(election_id));