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

Queries

New petitions for representation elections

Tables

allegation

case_number, allegation, created_at

727,373 rows

docket

case_number, date, document, actor, url, created_at

2,070,197 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,711 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,711 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,330 rows