election

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)

Next page

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