home / nlrb / election

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,621 rows

✎ View and edit SQL

This data as json, CSV (advanced)

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE election (election_id INTEGER PRIMARY KEY AUTOINCREMENT,
                       case_number text not null,
		       voting_unit_id INT,
                       date text,
		       tally_type text,
		       ballot_type text,
		       unit_size INT,
		       created_at timestamp default CURRENT_TIMESTAMP,
		       UNIQUE(case_number, voting_unit_id, date, ballot_type, tally_type),
		       FOREIGN KEY(voting_unit_id) REFERENCES voting_unit(voting_unit_id),
		       FOREIGN KEY(case_number) REFERENCES filing(case_number));
Powered by Datasette · Queries took 1.2ms