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

731,588 rows

docket

case_number, date, document, actor, url, created_at

2,078,925 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,884 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,884 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

509,110 rows

filing_group

root_case_number, case_number, created_at, updated_at

509,119 rows

participant

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

1,948,459 rows

sought_unit

case_number, unit_sought, created_at

53,287 rows

tally

election_id, option, votes, created_at

69,361 rows

voting_unit

voting_unit_id, case_number, unit_id, description, created_at

32,410 rows

... and 1 hidden table

Database schema

Download SQLite DB: nlrb.db 436.3 MB