home / nlrb / allegation

allegation

One row per allegation listed in an unfair-labor-practice charge. C-series cases (CA, CB, etc.) typically include one or more allegations citing specific NLRA section violations (e.g. "8(a)(1) — Coercive Statements", "8(a)(3) — Discharge"). Approximately 720k rows.
allegation
Text of the allegation as recorded by the NLRB, typically citing an NLRA section subdivision.
case_number
Foreign key to filing.case_number.
created_at
Scrape timestamp.

726,992 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ case_number allegation created_at
1 1 12-RC-008549 8(a)(3) Changes in Terms and Conditions of Employment 2021-05-29 14:13:09
2 2 22-RC-237214 8(b)(1)(A) Duty of Fair Representation, incl'g Superseniority, denial of access 2021-05-29 18:30:59
3 3 22-RC-134873 8(a)(5) Repudiation/Modification of Contract [Sec 8(d)/Unilateral Changes] 2021-05-29 19:33:37
4 4 22-RD-188965 8(b)(3) Refusal to Bargain/Bad Faith or Surface Bargaining 2021-05-31 03:38:00
5 5 22-RD-188965 8(b)(3) Repudiation/Modification of Contract 2021-05-31 03:38:00
6 6 01-CA-025969 8(a)(1) Coercive Actions (Surveillance, etc) 2021-06-18 19:52:01
7 7 01-CA-025969 8(a)(5) Refusal to Bargain/Bad Faith Bargaining (incl'g surface bargaining/direct dealing) 2021-06-18 19:52:01
8 8 01-CA-029433 8(a)(1) Coercive Rules 2021-06-18 19:52:01
9 9 01-CA-029433 8(a)(1) Concerted Activities (Retaliation, Discharge, Discipline) 2021-06-18 19:52:01
10 10 01-CA-029869 8(a)(5) Repudiation/Modification of Contract[Sec 8(d)/Unilateral Changes] 2021-06-18 19:52:01
11 11 01-CA-030292 8(a)(5) Repudiation/Modification of Contract[Sec 8(d)/Unilateral Changes] 2021-06-18 19:52:01
12 12 01-CA-030438 8(a)(3) Changes in Terms and Conditions of Employment 2021-06-18 19:52:01
13 13 01-CA-030438 8(a)(1) Coercive Statements (Threats, Promises of Benefits, etc.) 2021-06-18 19:52:01
14 14 01-CA-030438 8(a)(3) Discharge (Including Layoff and Refusal to Hire (not salting)) 2021-06-18 19:52:01
15 15 01-CA-030438 8(a)(1) Coercive Rules 2021-06-18 19:52:01
16 16 01-CA-030438 8(a)(3) Discipline 2021-06-18 19:52:01
17 17 01-CA-030739 8(a)(3) Changes in Terms and Conditions of Employment 2021-06-18 19:52:01
18 18 01-CA-030739 8(a)(5) Refusal to Furnish Information 2021-06-18 19:52:01
19 19 01-CA-030941 8(a)(1) Coercive Statements (Threats, Promises of Benefits, etc.) 2021-06-18 19:52:01
20 20 01-CA-030941 8(a)(1) Concerted Activities (Retaliation, Discharge, Discipline) 2021-06-18 19:52:01
21 21 01-CA-030941 8(a)(1) Interrogation (including Polling) 2021-06-18 19:52:01
22 22 01-CA-031010 8(a)(3) Changes in Terms and Conditions of Employment 2021-06-18 19:52:01
23 23 01-CA-031010 8(a)(3) Refusal to Reinstate E'ee/Striker (e.g. Laidlaw) 2021-06-18 19:52:01
24 24 01-CA-031010 8(a)(3) Discharge (Including Layoff and Refusal to Hire (not salting)) 2021-06-18 19:52:01
25 25 01-CA-031084 8(a)(5) Refusal to Furnish Information 2021-06-18 19:52:01
26 26 01-CA-031148 8(a)(3) Changes in Terms and Conditions of Employment 2021-06-18 19:52:01
27 27 01-CA-031148 8(a)(1) Coercive Actions (Surveillance, etc) 2021-06-18 19:52:01
28 28 01-CA-031148 8(a)(1) Coercive Statements (Threats, Promises of Benefits, etc.) 2021-06-18 19:52:01
29 29 01-CA-031148 8(a)(2) Assistance 2021-06-18 19:52:01
30 30 01-CA-031158 8(a)(5) Repudiation/Modification of Contract[Sec 8(d)/Unilateral Changes] 2021-06-18 19:52:01
31 31 01-CA-031566 8(a)(1) Coercive Actions (Surveillance, etc) 2021-06-18 19:52:01
32 32 01-CA-031566 8(a)(3) Discipline 2021-06-18 19:52:01
33 33 01-CA-031566 8(a)(5) Repudiation/Modification of Contract[Sec 8(d)/Unilateral Changes] 2021-06-18 19:52:01
34 34 01-CA-031567 8(a)(3) Discharge (Including Layoff and Refusal to Hire (not salting)) 2021-06-18 19:52:01
35 35 01-CA-031617 8(a)(1) Coercive Actions (Surveillance, etc) 2021-06-18 19:52:01
36 36 01-CA-031617 8(a)(5) Refusal to Furnish Information 2021-06-18 19:52:01
37 37 01-CA-031617 8(a)(3) Refusal to Reinstate E'ee/Striker (e.g. Laidlaw) 2021-06-18 19:52:01
38 38 01-CA-031617 8(a)(5) Refusal to Bargain/Bad Faith Bargaining (incl'g surface bargaining/direct dealing) 2021-06-18 19:52:01
39 39 01-CA-031617 8(a)(2) Assistance 2021-06-18 19:52:01
40 40 01-CA-031617 8(a)(5) Repudiation/Modification of Contract[Sec 8(d)/Unilateral Changes] 2021-06-18 19:52:01
41 41 01-CA-031889 8(a)(1) Concerted Activities (Retaliation, Discharge, Discipline) 2021-06-18 19:52:01
42 42 01-CA-031889 8(a)(3) Discharge (Including Layoff and Refusal to Hire (not salting)) 2021-06-18 19:52:01
43 43 01-CA-032082 8(a)(5) Repudiation/Modification of Contract[Sec 8(d)/Unilateral Changes] 2021-06-18 19:52:01
44 44 01-CA-032261 8(a)(3) Changes in Terms and Conditions of Employment 2021-06-18 19:52:01
45 45 01-CA-032310 8(a)(5) Repudiation/Modification of Contract[Sec 8(d)/Unilateral Changes] 2021-06-18 19:52:01
46 46 01-CA-032310 8(a)(5) Refusal to Bargain/Bad Faith Bargaining (incl'g surface bargaining/direct dealing) 2021-06-18 19:52:01
47 47 01-CA-032310 8(a)(1) Concerted Activities (Retaliation, Discharge, Discipline) 2021-06-18 19:52:01
48 48 01-CA-032310 8(a)(5) Refusal to Furnish Information 2021-06-18 19:52:01
49 49 01-CA-032493 8(a)(1) Coercive Actions (Surveillance, etc) 2021-06-18 19:52:01
50 50 01-CA-032493 8(a)(5) Repudiation/Modification of Contract[Sec 8(d)/Unilateral Changes] 2021-06-18 19:52:01
51 51 01-CA-032557 8(a)(5) Refusal to Bargain/Bad Faith Bargaining (incl'g surface bargaining/direct dealing) 2021-06-18 19:52:01
52 52 01-CA-032557 8(a)(1) Coercive Actions (Surveillance, etc) 2021-06-18 19:52:01
53 53 01-CA-032591 8(a)(1) Coercive Statements (Threats, Promises of Benefits, etc.) 2021-06-18 19:52:01
54 54 01-CA-032591 8(a)(3) Discharge (Including Layoff and Refusal to Hire (not salting)) 2021-06-18 19:52:01
55 55 01-CA-032591 8(a)(3) Changes in Terms and Conditions of Employment 2021-06-18 19:52:01
56 56 01-CA-032591 8(a)(1) Interrogation (including Polling) 2021-06-18 19:52:01
57 57 01-CA-032742 8(a)(3) Changes in Terms and Conditions of Employment 2021-06-18 19:52:01
58 58 01-CA-032742 8(a)(5) Alter Ego 2021-06-18 19:52:01
59 59 01-CA-032742 8(a)(3) Discharge (Including Layoff and Refusal to Hire (not salting)) 2021-06-18 19:52:01
60 60 01-CA-032742 8(a)(3) Refusal to Consider/Hire Applicant (salting only) 2021-06-18 19:52:01
61 61 01-CA-033275 8(a)(4) Changes in Terms and Conditions of Employment 2021-06-18 19:52:01
62 62 01-CA-033275 8(a)(1) Concerted Activities (Retaliation, Discharge, Discipline) 2021-06-18 19:52:01
63 63 01-CA-033999 8(a)(3) Discharge (Including Layoff and Refusal to Hire (not salting)) 2021-06-18 19:52:01
64 64 01-CA-034371 8(a)(3) Changes in Terms and Conditions of Employment 2021-06-18 19:52:01
65 65 01-CA-034371 8(a)(5) Repudiation/Modification of Contract[Sec 8(d)/Unilateral Changes] 2021-06-18 19:52:01
66 66 01-CA-034444 8(a)(3) Changes in Terms and Conditions of Employment 2021-06-18 19:52:01
67 67 01-CA-034444 8(a)(1) Coercive Actions (Surveillance, etc) 2021-06-18 19:52:01
68 68 01-CA-034598 8(a)(3) Discipline 2021-06-18 19:52:01
69 69 01-CA-034598 8(a)(1) Coercive Actions (Surveillance, etc) 2021-06-18 19:52:01
70 70 01-CA-034607 8(a)(5) Repudiation/Modification of Contract[Sec 8(d)/Unilateral Changes] 2021-06-18 19:52:01
71 71 01-CA-034621 8(a)(3) Changes in Terms and Conditions of Employment 2021-06-18 19:52:01
72 72 01-CA-034621 8(a)(5) Repudiation/Modification of Contract[Sec 8(d)/Unilateral Changes] 2021-06-18 19:52:01
73 73 01-CA-035060 8(a)(1) Coercive Actions (Surveillance, etc) 2021-06-18 19:52:01
74 74 01-CA-035060 8(a)(5) Repudiation/Modification of Contract[Sec 8(d)/Unilateral Changes] 2021-06-18 19:52:01
75 75 01-CA-035112 8(a)(3) Discipline 2021-06-18 19:52:01
76 76 01-CA-035124 8(a)(3) Changes in Terms and Conditions of Employment 2021-06-18 19:52:01
77 77 01-CA-035315 8(a)(5) Repudiation/Modification of Contract[Sec 8(d)/Unilateral Changes] 2021-06-18 19:52:01
78 78 01-CA-035315 8(a)(3) Changes in Terms and Conditions of Employment 2021-06-18 19:52:01
79 79 01-CA-035341 8(a)(5) Repudiation/Modification of Contract[Sec 8(d)/Unilateral Changes] 2021-06-18 19:52:01
80 80 01-CA-035341 8(a)(5) Refusal to Furnish Information 2021-06-18 19:52:01
81 81 01-CA-035403 8(a)(5) Repudiation/Modification of Contract[Sec 8(d)/Unilateral Changes] 2021-06-18 19:52:01
82 82 01-CA-035666 8(a)(3) Discharge (Including Layoff and Refusal to Hire (not salting)) 2021-06-18 19:52:01
83 83 01-CA-035666 8(a)(3) Discipline 2021-06-18 19:52:01
84 84 01-CA-035888 8(a)(3) Changes in Terms and Conditions of Employment 2021-06-18 19:52:01
85 85 01-CA-035888 8(a)(1) Coercive Actions (Surveillance, etc) 2021-06-18 19:52:01
86 86 01-CA-036011 8(a)(1) Coercive Statements (Threats, Promises of Benefits, etc.) 2021-06-18 19:52:01
87 87 01-CA-036011 8(a)(3) Changes in Terms and Conditions of Employment 2021-06-18 19:52:01
88 88 01-CA-036102 8(a)(3) Changes in Terms and Conditions of Employment 2021-06-18 19:52:01
89 89 01-CA-036102 8(a)(1) Coercive Actions (Surveillance, etc) 2021-06-18 19:52:01
90 90 01-CA-036102 8(a)(5) Repudiation/Modification of Contract[Sec 8(d)/Unilateral Changes] 2021-06-18 19:52:01
91 91 01-CA-036102 8(a)(1) Coercive Statements (Threats, Promises of Benefits, etc.) 2021-06-18 19:52:01
92 92 01-CA-036201 8(a)(5) Refusal to Bargain/Bad Faith Bargaining (incl'g surface bargaining/direct dealing) 2021-06-18 19:52:01
93 93 01-CA-036201 8(a)(5) Repudiation/Modification of Contract[Sec 8(d)/Unilateral Changes] 2021-06-18 19:52:01
94 94 01-CA-036213 8(a)(5) Repudiation/Modification of Contract[Sec 8(d)/Unilateral Changes] 2021-06-18 19:52:01
95 95 01-CA-036289 8(a)(1) Coercive Actions (Surveillance, etc) 2021-06-18 19:52:01
96 96 01-CA-036289 8(a)(5) Refusal to Bargain/Bad Faith Bargaining (incl'g surface bargaining/direct dealing) 2021-06-18 19:52:01
97 97 01-CA-036343 8(a)(1) Coercive Rules 2021-06-18 19:52:01
98 98 01-CA-036343 8(a)(1) Coercive Statements (Threats, Promises of Benefits, etc.) 2021-06-18 19:52:01
99 99 01-CA-036374 8(a)(1) Coercive Actions (Surveillance, etc) 2021-06-18 19:52:01
100 100 01-CA-036374 8(a)(5) Shutdown or Relocate (e.g. First National Maint.).Subcontract Work 2021-06-18 19:52:01

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE allegation (case_number text not null,
                         allegation text,
		         created_at timestamp default CURRENT_TIMESTAMP,			         FOREIGN KEY(case_number) REFERENCES filing(case_number));
Powered by Datasette · Queries took 1.2ms