c_allegation
599,417 rows
Suggested facets: allegation_sequence, nlra_section
| c_case_number | allegation_sequence | nlra_section | allegation_keyname |
|---|---|---|---|
| 01-CA-19224-001 | 1 | 8(a)(5) | Bad Faith Bargaining (Succeeding Contract) |
| 01-CA-19567-001 | 1 | 8(a)(3) | Lockout |
| 01-CA-19567-001 | 2 | 8(a)(5) | Unilateral Changes [not Sec. 8(d)] |
| 01-CA-19567-001 | 3 | 8(a)(5) | Other Allegations |
| 01-CA-19690-001 | 1 | 8(a)(5) | Refusal to Furnish Information |
| 01-CA-19690-001 | 2 | 8(a)(5) | Unilateral Changes [not Sec. 8(d)] |
| 01-CA-19690-001 | 3 | 8(a)(5) | Bad Faith Bargaining (Succeeding Contract) |
| 01-CA-19731-001 | 1 | 8(a)(1) | Other Allegations |
| 01-CA-19731-001 | 2 | 8(a)(3) | Other Allegations |
| 01-CA-19797-001 | 1 | 8(a)(1) | Other Allegations |
| 01-CA-19903-001 | 1 | 8(a)(1) | Other Allegations |
| 01-CA-19958-001 | 1 | 8(a)(5) | Bad Faith Bargaining (Succeeding Contract) |
| 01-CA-20007-001 | 1 | 8(a)(1) | Other Allegations |
| 01-CA-20007-001 | 2 | 8(a)(5) | Other Allegations |
| 01-CA-20157-001 | 1 | 8(a)(1) | Other Allegations |
| 01-CA-20218-001 | 1 | 8(a)(1) | Other Allegations |
| 01-CA-20218-001 | 2 | 8(a)(3) | Other Allegations |
| 01-CA-20283-001 | 1 | 8(a)(5) | Bad Faith Bargaining (Succeeding Contract) |
| 01-CA-20291-001 | 1 | 8(a)(5) | Bad Faith Bargaining (Succeeding Contract) |
| 01-CA-20304-001 | 1 | 8(a)(2) | Other Allegations |
| 01-CA-20442-001 | 1 | 8(a)(1) | Other Allegations |
| 01-CA-20442-001 | 2 | 8(a)(3) | Other Allegations |
| 01-CA-20508-001 | 1 | 8(a)(5) | Bad Faith Bargaining (Succeeding Contract) |
| 01-CA-20521-001 | 1 | 8(a)(1) | Other Allegations |
| 01-CA-20521-001 | 2 | 8(a)(3) | Other Allegations |
| 01-CA-20521-001 | 3 | 8(a)(4) | Other Allegations |
| 01-CA-21438-001 | 1 | 8(a)(1) | Other Allegations |
| 01-CA-21438-001 | 2 | 8(a)(3) | Other Allegations |
| 01-CA-21438-001 | 3 | 8(a)(4) | Other Allegations |
| 01-CA-21560-001 | 1 | 8(a)(3) | Refusal to Reinstate E'ee/Striker (e.g. Laidlaw) |
| 01-CA-21560-001 | 2 | 8(a)(5) | Bad Faith Bargaining (Succeeding Contract) |
| 01-CA-21943-001 | 0 | 8(a)(5) | Unilateral Changes [not Sec. 8(d)] |
| 01-CA-21943-001 | 1 | 8(a)(3) | Refusal to Reinstate E'ee/Striker (e.g. Laidlaw) |
| 01-CA-22040-002 | 0 | 8(a)(3) | Other Allegations |
| 01-CA-22040-002 | 1 | 8(a)(5) | Other Allegations |
| 01-CA-22687-001 | 1 | 8(a)(1) | Coercive Statements, including Threats |
| 01-CA-22687-001 | 2 | 8(a)(3) | Discharge |
| 01-CA-22687-001 | 3 | 8(a)(5) | Refusal to Furnish Information |
| 01-CA-22687-001 | 4 | 8(a)(5) | Repudiation/Modification of Contract [Sec. 8(d)] |
| 01-CA-22769-001 | 1 | 8(a)(3) | Other Allegations |
| 01-CA-22769-001 | 2 | 8(a)(5) | Repudiation/Modification of Contract [Sec. 8(d)] |
| 01-CA-22769-001 | 3 | 8(a)(5) | Refusal to Furnish Information |
| 01-CA-22769-001 | 4 | 8(a)(3) | Layoff |
| 01-CA-22769-001 | 5 | 8(a)(5) | Other Allegations |
| 01-CA-22869-001 | 1 | 8(a)(1) | Other Allegations |
| 01-CA-22869-001 | 2 | 8(a)(3) | Other Allegations |
| 01-CA-22869-001 | 3 | 8(a)(5) | Other Allegations |
| 01-CA-22869-001 | 4 | 8(a)(4) | Other Allegations |
| 01-CA-23307-001 | 0 | 8(a)(1) | Other Allegations |
| 01-CA-23307-001 | 1 | 8(a)(3) | Other Allegations |
| 01-CA-23307-001 | 2 | 8(a)(5) | Unilateral Changes [not Sec. 8(d)] |
| 01-CA-23427-001 | 2 | 8(a)(5) | Test of Certification |
| 01-CA-23576-001 | 1 | 8(a)(3) | Other Allegations |
| 01-CA-23576-001 | 2 | 8(a)(5) | Alter Ego or Disguised Continuance |
| 01-CA-23748-001 | 0 | 8(a)(1) | Other Allegations |
| 01-CA-23748-001 | 1 | 8(a)(3) | Other Allegations |
| 01-CA-23748-001 | 2 | 8(a)(5) | Unilateral Changes [not Sec. 8(d)] |
| 01-CA-23748-001 | 3 | 8(a)(3) | Discharge |
| 01-CA-23748-001 | 4 | 8(a)(1) | Coercive Statements, including Threats |
| 01-CA-24161-001 | 1 | 8(a)(3) | Other Allegations |
| 01-CA-24161-001 | 2 | 8(a)(5) | Unilateral Changes [not Sec. 8(d)] |
| 01-CA-24161-001 | 3 | 8(a)(1) | Coercive Statements, including Threats |
| 01-CA-24372-001 | 1 | 8(a)(1) | Other Allegations |
| 01-CA-24372-001 | 2 | 8(a)(5) | Repudiation/Modification of Contract [Sec. 8(d)] |
| 01-CA-24390-002 | 0 | 8(a)(5) | Other Allegations |
| 01-CA-24528-001 | 1 | 8(a)(3) | Discharge |
| 01-CA-24528-001 | 2 | 8(a)(5) | Unilateral Changes [not Sec. 8(d)] |
| 01-CA-24528-001 | 3 | 8(a)(3) | Refusal to Reinstate E'ee/Striker (e.g. Laidlaw) |
| 01-CA-24863-001 | 1 | 8(a)(3) | Other Allegations |
| 01-CA-24863-001 | 3 | 8(a)(5) | Unilateral Changes [not Sec. 8(d)] |
| 01-CA-24883-001 | 1 | 8(a)(5) | Failure to Sign Agreement |
| 01-CA-24921-001 | 0 | 8(a)(1) | Other Allegations |
| 01-CA-24921-001 | 1 | 8(a)(3) | Refusal to Reinstate E'ee/Striker (e.g. Laidlaw) |
| 01-CA-24921-001 | 2 | 8(a)(5) | Unilateral Changes [not Sec. 8(d)] |
| 01-CA-24967-001 | 1 | 8(a)(3) | Other Allegations |
| 01-CA-24967-001 | 2 | 8(a)(5) | Unilateral Changes [not Sec. 8(d)] |
| 01-CA-24967-001 | 3 | 8(a)(5) | Refusal to Furnish Information |
| 01-CA-24967-001 | 4 | 8(a)(1) | Coercive Statements, including Threats |
| 01-CA-25033-001 | 1 | 8(a)(1) | Coercive Statements, including Threats |
| 01-CA-25033-001 | 2 | 8(a)(3) | Other Allegations |
| 01-CA-25237-001 | 1 | 8(a)(3) | Refusal to Reinstate E'ee/Striker (e.g. Laidlaw) |
| 01-CA-25237-001 | 2 | 8(a)(1) | Coercive Statements, including Threats |
| 01-CA-25237-002 | 1 | 8(a)(3) | Refusal to Reinstate E'ee/Striker (e.g. Laidlaw) |
| 01-CA-25237-002 | 2 | 8(a)(1) | Coercive Statements, including Threats |
| 01-CA-25237-002 | 3 | 8(a)(3) | Other Allegations |
| 01-CA-25341-001 | 0 | 8(a)(3) | Refusal to Reinstate E'ee/Striker (e.g. Laidlaw) |
| 01-CA-25341-001 | 1 | 8(a)(5) | Unilateral Changes [not Sec. 8(d)] |
| 01-CA-25521-001 | 0 | 8(a)(3) | Lockout |
| 01-CA-25521-001 | 1 | 8(a)(5) | Bad Faith Bargaining (Succeeding Contract) |
| 01-CA-25599-001 | 1 | 8(a)(3) | Layoff |
| 01-CA-25599-001 | 2 | 8(a)(5) | Repudiation/Modification of Contract [Sec. 8(d)] |
| 01-CA-25599-001 | 3 | 8(a)(5) | Direct Dealing/Bypassing Union |
| 01-CA-25599-001 | 4 | 8(a)(5) | Refusal to Furnish Information |
| 01-CA-25599-001 | 5 | 8(a)(1) | Interrogation |
| 01-CA-25656-001 | 1 | 8(a)(3) | Other Allegations |
| 01-CA-25656-001 | 2 | 8(a)(3) | Discharge |
| 01-CA-25656-001 | 3 | 8(a)(4) | Other Allegations |
| 01-CA-25656-001 | 4 | 8(a)(4) | Discharge |
| 01-CA-25656-001 | 5 | 8(a)(1) | Other Allegations |
| 01-CA-25656-001 | 6 | 8(a)(1) | Concerted Activities: Discharge |
Table schema
CREATE TABLE c_allegation(c_case_number VARCHAR, allegation_sequence BIGINT, nlra_section VARCHAR, allegation_keyname VARCHAR);