l_allegation_type

217 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ nlra_section allegation_keyname case_type description
1 1 8(a)(1) Changes in Conditions of Employment [not 8a3] CA 8(a)(1) Changes in Conditions of Employment [not 8a3]
2 2 8(a)(1) Coercive Statements, including Threats CA 8(a)(1) Coercive Statements, including Threats
3 3 8(a)(1) Concerted Activities: Benefits Altered CA 8(a)(1) Conserted Activities: Benefits Altered
4 4 8(a)(1) Concerted Activities: Discharge CA 8(a)(1) Concerted Activities: Discharge
5 5 8(a)(1) Concerted Activities: Discipline CA 8(a)(1) Concerted Activities: Discipline
6 6 8(a)(1) Concerted Activities: Layoff CA 8(a)(1) Concerted Activities: Layoff
7 7 8(a)(1) Concerted Activities: Lockout CA 8(a)(1) Concerted Activities: Lockout
8 8 8(a)(1) Concerted Activities: Onerous Assignment/Condition CA 8(a)(1) Concerted Activities: Onerous Assignment/Condition
9 9 8(a)(1) Concerted Activities: Other Allegations CA 8(a)(1) Concerted Activities: Other Allegations
10 10 8(a)(1) Concerted Activities: Promotions Withheld CA 8(a)(1) Concerted Activities: Promotions Withheld
11 11 8(a)(1) Concerted Activities: Refusal to Consider/Hire CA 8(a)(1) Concerted Activities: Refusal to Consider/Hire
12 12 8(a)(1) Concerted Activities: Refusal to Reinstate CA 8(a)(1) Concerted Activities: Refusal to Reinstate
13 13 8(a)(1) Concerted Activities: Rewards CA 8(a)(1) Concerted Activities: Rewards
14 14 8(a)(1) Concerted Activities: Shutdown or Relocate CA 8(a)(1) Concerted Activities: Shutdown or Relocate
15 15 8(a)(1) Concerted Activities: Suspension CA 8(a)(1) Concerted Activities: Suspension
16 16 8(a)(1) Concerted Activities: Union Security Related CA 8(a)(1) Concerted Activities: Union Security Related
17 17 8(a)(1) Concerted Activities: Unknown CA 8(a)(1) Concerted Activities: Unknown
18 18 8(a)(1) Concerted Activities: Wages Altered CA 8(a)(1) Concerted Activities: Wages Altered
19 19 8(a)(1) Denial of Access (Lechmere) CA 8(a)(1) Denial of Access (Lechmere)
20 20 8(a)(1) Discharge of supervisor (Parker-Robb Chevrolet) CA 8(a)(1) Discharge of supervisor (Parker-Robb Chevrolet)
21 21 8(a)(1) Disparagement of Union/Employee CA 8(a)(1) Disparagement of Union or its supporters
22 22 8(a)(1) Harassment CA 8(a)(1) Harassment
23 23 8(a)(1) Interference, (Weingarten) CA 8(a)(1) Interference, (Weingarten)
24 24 8(a)(1) Interrogation CA 8(a)(1) Interrogation
25 25 8(a)(1) Lawsuits CA 8(a)(1) Lawsuits
26 26 8(a)(1) Other Allegations CA 8(a)(1) Other Allegations
27 27 8(a)(1) Polling Employees CA 8(a)(1) Polling Employees
28 28 8(a)(1) Promise of Benefits CA 8(a)(1) Promise of Benefits
29 29 8(a)(1) Rules: No-Solicitation/No-Distribution Rules CA 8(a)(1) Rules: No-Solicitation/No-Distribution Rules
30 30 8(a)(1) Rules: Other Employer Rules CA 8(a)(1) Rules: Other Employer Rules
31 31 8(a)(1) Statements of Futility CA 8(a)(1) Statements of Futility
32 32 8(a)(1) Surveillance CA 8(a)(1) Surveillance
33 33 8(a)(1) Unknown CA 8(a)(1) Unknown
34 34 8(a)(1) Violence CA 8(a)(1) Violence
35 35 8(a)(2) Assistance CA 8(a)(2) Assistance
36 36 8(a)(2) Creation of In-House Organization (Electromation) CA 8(a)(2) Creation of In-House Organization (Electromation)
37 37 8(a)(2) Domination CA 8(a)(2) Domination
38 38 8(a)(2) Interference CA 8(a)(2) Interference
39 39 8(a)(2) Other Allegations CA 8(a)(2) Other Allegations
40 40 8(a)(2) Unknown CA 8(a)(2) Unknown
41 41 8(a)(2) Unlawful Recognition CA 8(a)(2) Unlawful Recognition
42 42 8(a)(3) Benefits Altered CA 8(a)(3) Benefits Altered
43 43 8(a)(3) Discharge CA 8(a)(3) Discharge
44 44 8(a)(3) Discharge, Constructive CA 8(a)(3) Discharge, Constructive
45 45 8(a)(3) Discipline CA 8(a)(3) Discipline
46 46 8(a)(3) Inherently Destructive Conduct CA 8(a)(3) Inherently Destructive Conduct
47 47 8(a)(3) Investigatory Meetings (Weingarten) CA 8(a)(3) Investigatory Meetings (Weingarten)
48 48 8(a)(3) Lawsuit CA 8(a)(3) Lawsuit
49 49 8(a)(3) Layoff CA 8(a)(3) Layoff
50 50 8(a)(3) Lockout CA 8(a)(3) Lockout
51 51 8(a)(3) Onerous Assignments/Conditions CA 8(a)(3) Onerous Assignments/Conditions
52 52 8(a)(3) Other Allegations CA 8(a)(3) Other Allegations
53 53 8(a)(3) Promotions Withheld CA 8(a)(3) Promotions Withheld
54 54 8(a)(3) Refusal to Consider/Hire Applicant (Not Salting) CA 8(a)(3) Refusal to Consider/Hire Applicant (Not Salting)
55 55 8(a)(3) Refusal to Consider/Hire Applicant (Salting) CA 8(a)(3) Refusal to Consider/Hire Applicant (Salting)
56 56 8(a)(3) Refusal to Reinstate E'ee/Striker (e.g. Laidlaw) CA 8(a)(3) Refusal to Reinstate E'ee/Striker (e.g. Laidlaw)
57 57 8(a)(3) Rewards CA 8(a)(3) Rewards
58 58 8(a)(3) Shutdown or Relocate CA 8(a)(3) Shutdown or Relocate
59 59 8(a)(3) Subcontract Unit Work CA 8(a)(3) Subcontract Unit Work
60 60 8(a)(3) Suspension CA 8(a)(3) Suspension
61 61 8(a)(3) Union Security Related Actions CA 8(a)(3) Union Security Related Actions
62 62 8(a)(3) Unknown CA 8(a)(3) Unknown
63 63 8(a)(3) Wages Altered CA 8(a)(3) Wages Altered
64 64 8(a)(4) Benefits Altered CA 8(a)(4) Benefits Altered
65 65 8(a)(4) Discharge CA 8(a)(4) Discharge
66 66 8(a)(4) Discharge, Constructive CA 8(a)(4) Discharge, Constructive
67 67 8(a)(4) Discipline CA 8(a)(4) Discipline
68 68 8(a)(4) Inherently Destructive Conduct CA 8(a)(4) Inherently Destructive Conduct
69 69 8(a)(4) Lawsuit CA 8(a)(4) Lawsuit
70 70 8(a)(4) Layoff CA 8(a)(4) Layoff
71 71 8(a)(4) Lockout CA 8(a)(4) Lockout
72 72 8(a)(4) Onerous Assignments/Conditions CA 8(a)(4) Onerous Assignments/Conditions
73 73 8(a)(4) Other Allegations CA 8(a)(4) Other Allegation
74 74 8(a)(4) Promotions Withheld CA 8(a)(4) Promotions Withheld
75 75 8(a)(4) Refusal to Consider/Hire Applicant (Not Salting) CA 8(a)(4) Refusal to Consider/Hire Applicant (Not Salting)
76 76 8(a)(4) Refusal to Consider/Hire Applicant (Salting) CA 8(a)(4) Refusal to Consider/Hire Applicant (Salting)
77 77 8(a)(4) Refusal to Reinstate Employee/Striker CA 8(a)(4) Refusal to Reinstate Employee/Striker
78 78 8(a)(4) Rewards CA 8(a)(4) Rewards
79 79 8(a)(4) Shutdown or Relocate CA 8(a)(4) Shutdown or Relocate
80 80 8(a)(4) Subcontract Unit Work CA 8(a)(4) Subcontract Unit Work
81 81 8(a)(4) Suspension CA 8(a)(4) Suspension
82 82 8(a)(4) Union Security Related Actions CA 8(a)(4) Union Security Related Actions
83 83 8(a)(4) Unknown CA 8(a)(4) Unknown
84 84 8(a)(4) Wages Altered CA 8(a)(4) Wages Altered
85 85 8(a)(5) Alter Ego or Disguised Continuance CA 8(a)(5) Alter Ego or Disguised Continuance
86 86 8(a)(5) Bad Faith Bargaining (Initial Contract) CA Bad Faith Bargaining (Initial Contract)
87 87 8(a)(5) Bad Faith Bargaining (Succeeding Contract) CA Bad Faith Bargaining (Succeeding Contract)
88 88 8(a)(5) Direct Dealing/Bypassing Union CA 8(a)(5) Direct Dealing/Bypassing Union
89 89 8(a)(5) Failure to Sign Agreement CA 8(a)(5) Failure to Sign Agreement
90 90 8(a)(5) Implement Drug Testing CA 8(a)(5) Implement Drug Testing
91 91 8(a)(5) Implementation (Colorado Ute) CA 8(a)(5) Implementation (Colorado Ute)
92 92 8(a)(5) Implementation (impasse issue) CA 8(a)(5) Implementation (impasse issue)
93 93 8(a)(5) Other Allegations CA 8(a)(5) Other Allegations
94 94 8(a)(5) Refusal to Bargain (Initial Contract) CA 8(a)(5) Refusal to Bargain (Initial Contract)
95 95 8(a)(5) Refusal to Bargain (Succeeding or mid Contract) CA 8(a)(5) Refusal to Bargain (Succeeding or mid Contract)
96 96 8(a)(5) Refusal to Furnish Information CA 8(a)(5) Refusal to Furnish Information
97 97 8(a)(5) Refusal to Hire Majority CA 8(a)(5) Refusal to Hire Majority
98 98 8(a)(5) Refusal to Recognize (Gissel) CA 8(a)(5) Refusal to Recognize (Gissel)
99 99 8(a)(5) Refusal to Recognize (not Gissel) CA 8(a)(5) Refusal to Recognize (not Gissel)
100 100 8(a)(5) Repudiation/Modification of Contract [Sec. 8(d)] CA 8(a)(5) Repudiation/Modification of Contract [Sec. 8(d)]

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "l_allegation_type" (
    "nlra_section" text,
    "allegation_keyname" text,
    "case_type" text,
    "description" text
);