filing

case_number

NLRB case identifier. Format is <region>-<type>-<sequence>, e.g. "01-RC-123456". Primary key.

case_type

Two-letter case-type code. R-series are representation cases (RC, RD, RM); C-series are unfair-labor-practice charges (CA, CB, CC, CD, CE, CG, CP); others include UC (unit clarification), UD (union-shop deauthorization), AC (amendment of certification), and WH (workers under WH-prefixed administrative cases).

certified_representative

Name of the certified union, when the case ended in certification.

city

City of the establishment or unit involved.

created_at

Timestamp when this row was first scraped into the database.

date_closed

Date the case was administratively closed (blank for open cases).

date_filed

Date the petition or charge was filed (ISO 8601, YYYY-MM-DD).

last_checked_at

Timestamp of the most recent scrape check against nlrb.gov.

name

Case name (typically the employer or charged party).

number_of_eligible_voters

For election cases, the number of voters eligible to participate in the election.

number_of_voters_on_petition_or_charge

For petitions and charges, the number of workers identified on the filing.

reason_closed

Standard NLRB closing disposition (e.g. "Certification of Representative", "Withdrawal Non-adjusted", "Dismissal Adjusted", "Administrative Closing").

region_assigned

NLRB regional office handling the case (two-digit region code, sometimes with a sub-region letter).

state

Two-letter US Postal Service state abbreviation.

status

Case status — "Closed", "Open", "Open - Blocked" (paused pending another case), or "Inactive".

updated_at

Timestamp when this row was last updated by the scraper.

url

Public URL of the case on nlrb.gov.

506,067 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE "filing" (case_number text not null primary key,
		     name text,
		     case_type text,
		     url text,
	             city text,
	             state text,
	             date_filed text,
	             region_assigned text,
	             status text,
	             date_closed text,
	             reason_closed text,
	             number_of_eligible_voters bint,
	             number_of_voters_on_petition_or_charge int,
	             certified_representative text,
		     created_at timestamp default CURRENT_TIMESTAMP,
		     updated_at timestamp default CURRENT_TIMESTAMP,
		     last_checked_at timestamp default CURRENT_TIMESTAMP);
CREATE INDEX [idx_filing_case_type_created_at_date_filed]
    ON [filing] ([case_type], [created_at] desc, [date_filed] desc);
CREATE INDEX [idx_filing_date_filed]
    ON [filing] ([date_filed]);
CREATE INDEX [idx_filing_date_closed]
    ON [filing] ([date_closed]);
CREATE INDEX [idx_filing_date_filed_date_closed]
    ON [filing] ([date_filed], [date_closed]);
CREATE INDEX [idx_filing_region_assigned]
    ON [filing] ([region_assigned]);