NLRB cases since 2010

National Labor Relations Board case data from the NLRB's current online case management system. Covers union-representation cases (R petitions — RC certification, RD decertification, RM employer-filed) and unfair-labor-practice cases (C charges — CA against employers, CB against unions, and several less-common subtypes), plus unit-clarification, deauthorization, and related case types.

The data is organized around a central filing table (one row per case) with related tables for participants, allegations, bargaining units sought, units that voted, elections, election results, tallies, docket events, and case documents. All linked by case_number.

Data source: National Labor Relations Board website, scraped

Custom SQL query

Queries

Tables schema

allegation

case_number, allegation, created_at

726,992 rows

docket

case_number, date, document, actor, url, created_at

2,069,369 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

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

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

506,067 rows

filing_group

root_case_number, case_number, created_at, updated_at

506,076 rows

participant

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

1,936,130 rows

sought_unit

case_number, unit_sought, created_at

52,920 rows

sqlite_sequence

name, seq

2 rows

tally

election_id, option, votes, created_at

68,833 rows

voting_unit

voting_unit_id, case_number, unit_id, description, created_at

32,155 rows

... and 1 hidden table

Download SQLite DB: nlrb.db 959.0 MB