NLRB cases since 2010

This is a database of representation certification election and unfair labor practice cases since 2010. It is updated nightly.

Data Limitations

  • The data starts around 2010. See cats for data from the previous system
  • The update process starts by downloading a CSV of all the cases within a specified time period from the nlrb.gov website. However, repeatingly requesting the same information from nlrb.gov results in spreadsheets with slightly different contents. We might be a bit out of date if the last CSV we downloaded missed a recent case.

Data source: National Labor Relations Board website, scraped

Custom SQL query

Tables

allegation

case_number, allegation, created_at

674,992 rows

docket

case_number, date, document, actor, url, created_at

1,963,922 rows

document

case_number, document, url, created_at

8,076 rows

election

election_id, case_number, voting_unit_id, date, tally_type, ballot_type, unit_size, created_at

30,832 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

30,832 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

471,819 rows

filing_group

root_case_number, case_number, created_at, updated_at

471,828 rows

participant

case_number, participant, type, subtype, address, address_1, address_2, city, state, zip, phone_number, created_at

1,793,840 rows

sought_unit

case_number, unit_sought, created_at

48,624 rows

sqlite_sequence

name, seq

2 rows

tally

election_id, option, votes, created_at

63,232 rows

voting_unit

voting_unit_id, case_number, unit_id, description, created_at

29,434 rows

... and 2 hidden tables

Download SQLite DB: nlrb.db 856.4 MB