NLRB cases since 2010
Data source: National Labor Relations Board website, scraped
Queries
Tables
election
election_id, case_number, voting_unit_id, date, tally_type, ballot_type, unit_size, created_at
29,802 rows
election_mode
election_id, case_number, name, city, state, status, date_filed, date_closed, reason_closed, election_mode, date_ballot_mailed, date_ballot_counted, date_election_scheduled, date_tally_scheduled, date_tallied, tally_type, ballot_type, unit_id, ballots_impounded, number_of_eligible_voters, number_of_void_ballots, labor_organization_1_name, votes_for_labor_organization_1, labor_organization_2_name, votes_for_labor_organization_2, labor_organization_3_name, votes_for_labor_organization_3, votes_cast_against_labor_org, number_of_valid_votes_counted, number_of_challenged_ballots, challenges_are_determinative, runoff_required, union_to_certify, unit_involved_in_petition, bargaining_unit_determined
6,927 rows
election_result
election_id, total_ballots_counted, void_ballots, challenged_ballots, challenges_are_determinative, runoff_required, union_to_certify, created_at
29,802 rows
filing
case_number, name, case_type, url, city, state, date_filed, region_assigned, status, date_closed, reason_closed, number_of_eligible_voters, number_of_voters_on_petition_or_charge, certified_representative, created_at, updated_at, last_checked_at
460,449 rows
participant
case_number, participant, type, subtype, address, address_1, address_2, city, state, zip, phone_number, created_at
1,735,699 rows
unmatched_participant_details
case_number, participant, type, subtype, address_1, address_2, city, state, zip
2,223 rows
... and 1 hidden table
Download SQLite DB: nlrb.db 821.9 MB