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

New petitions for representation elections

Tables

allegation

case_number, allegation, created_at

736,109 rows

docket

case_number, date, document, actor, url, created_at

2,087,238 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

34,092 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

34,092 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

512,134 rows

filing_group

root_case_number, case_number, created_at, updated_at

512,143 rows

participant

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

1,960,506 rows

sought_unit

case_number, unit_sought, created_at

53,640 rows

tally

election_id, option, votes, created_at

69,779 rows

voting_unit

voting_unit_id, case_number, unit_id, description, created_at

32,617 rows

... and 1 hidden table

Database schema

Download SQLite DB: nlrb.db 439.8 MB