l_blue_book_chapter

66 rows

✎ View and edit SQL

This data as json, CSV (advanced)

bb_chapter ▼ bb_division description
111 100 NLRA, AS AMENDED 100 111 CONSTITUTIONALITY OF APPLICATION OF NLRA
122 100 NLRA, AS AMENDED 100 122 PURPOSE AND POLICY OF NLRA
133 100 NLRA, AS AMENDED 100 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY
144 100 NLRA, AS AMENDED 100 144 CONSTRUCTION
155 100 NLRA, AS AMENDED 100 155 AMENDMENTS OF NLRA
166 100 NLRA, AS AMENDED 100 166 SEPARABILITY OF PROVISIONS
177 100 NLRA, AS AMENDED 100 177 STATUTORY DEFINITIONS
188 100 NLRA, AS AMENDED 100 188 AUTHORITY AND STRUCTURE OF NLRB AS AGENCY
201 200 NLRB JURISDICTION 200 201 GENERALLY
220 200 NLRB JURISDICTION 200 220 STATUTORY JURISDICTION
240 200 NLRB JURISDICTION 200 240 DISCRETION IN EXERCISE OF JURISDICTION
260 200 NLRB JURISDICTION 200 260 STANDARDS FOR ASSERTION OF JURISDICTION
280 200 NLRB JURISDICTION 200 280 ENTERPRISES OVER WHICH THE BOARD DID OR DID NOT ASSERT JURISDICTION
301 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 301 GENERALLY
308 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 308 WHO MAY RAISE QUESTION OF REPRESENTATION
316 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 316 HOW QUESTION OF REPRESENTATION IS RAISED
324 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 324 SHOWING OF INTEREST IN REPRESENTATION
332 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 332 DISCLAIMER OF INTEREST IN BEING REPRESENTATIVE
339 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 339 WHO MAY ACT AS REPRESENTATIVE
347 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 347 BARS TO CONDUCT OF ELECTION
355 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 355 TYPES OF ELECTIONS
362 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 362 ELIGIBILITY TO PARTICIPATE IN ELECTION
370 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 370 MECHANICS OF ELECTION
378 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 378 CONDUCT INTERFERING WITH ELECTION CHOICE
385 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 385 POST-CERTIFICATION AND UNIT CLARIFICATION ISSUES
393 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 393 PROCEDURE IN REPRESENTATION PROCEEDINGS
401 400 BARGAINING UNITS 400 401 GENERALLY
420 400 BARGAINING UNITS 400 420 FACTORS RELEVANT TO DETERMINATION OF SCOPE OR COMPOSITION OF UNIT
440 400 BARGAINING UNITS 400 440 DETERMINATIONS OF SCOPE OF UNIT
460 400 BARGAINING UNITS 400 460 DETERMINATION OF COMPOSITION OF UNIT
470 400 BARGAINING UNITS 400 470 HEALTH CARE INSTITUTION UNITS
480 400 BARGAINING UNITS 400 480 POSTAL SERVICE UNITS
501 500 UNFAIR LABOR PRACTICES 500 501 GENERALLY
506 500 UNFAIR LABOR PRACTICES 500 506 EMPLOYEE RIGHTS PROTECTED BY SECTION 7
512 500 UNFAIR LABOR PRACTICES 500 512 EMPLOYER INTERFERENCE WITH EMPLOYEE SECTION 7 RIGHTS (8(a)(1))
518 500 UNFAIR LABOR PRACTICES 500 518 EMPLOYER DOMINATION, ASSISTANCE OR SUPPORT OF LABOR ORGANIZATION
524 500 UNFAIR LABOR PRACTICES 500 524 EMPLOYER DISCRIMINATION IN EMPLOYMENT
530 500 UNFAIR LABOR PRACTICES 500 530 EMPLOYER OBLIGATION TO BARGAIN
536 500 UNFAIR LABOR PRACTICES 500 536 UNION COERCION OF EMPLOYEES (8(b)(1)(A))
542 500 UNFAIR LABOR PRACTICES 500 542 UNION COERCION OF EMPLOYER IN SELECTION OF REPRESENTATIVES
548 500 UNFAIR LABOR PRACTICES 500 548 UNION CAUSATION OF EMPLOYER DISCRIMINATION
554 500 UNFAIR LABOR PRACTICES 500 554 UNION OBLIGATION TO BARGAIN
560 500 UNFAIR LABOR PRACTICES 500 560 PROHIBITED STRIKES AND BOYCOTTS
566 500 UNFAIR LABOR PRACTICES 500 566 EXCESSIVE OR DISCRIMINATORY MEMBERSHIP FEES - (SEC. 8(b)(5))
572 500 UNFAIR LABOR PRACTICES 500 572 PAYMENT FOR SERVICES NOT PERFORMED - (SEC. 8(b)(6))
578 500 UNFAIR LABOR PRACTICES 500 578 PICKETING FOR RECOGNITION AND BARGAINING
584 500 UNFAIR LABOR PRACTICES 500 584 AGREEMENTS TO CEASE DOING BUSINESS
590 500 UNFAIR LABOR PRACTICES 500 590 PREHIRE AGREEMENTS - SECTION 8(f)
593 500 UNFAIR LABOR PRACTICES 500 593PICKETING AND STRIKES AT HEALTH CARE INSTITUTIONS (SECTION 8(g))
596 500 UNFAIR LABOR PRACTICES 500 596 PROCEDURE IN ULP PROCEEDINGS
601 600 REMEDIAL ORDER PROVISIONS 600 601 GENERALLY
625 600 REMEDIAL ORDER PROVISIONS 600 625 ORDERS AGAINST EMPLOYERS
650 600 REMEDIAL ORDER PROVISIONS 600 650 ORDERS AGAINST UNIONS
675 600 REMEDIAL ORDER PROVISIONS 600 675 PROCEEDINGS TO DETERMINE BACKPAY LIABILITY (FOR COMPUTATION OF BACKPAY SEE HEADINGS UNDER 625-4433)
712 700 GENERAL LEGAL PRINCIPLES 700 712 AGENCY PRINCIPLES
725 700 GENERAL LEGAL PRINCIPLES 700 725 CONTRACT LAW
737 700 GENERAL LEGAL PRINCIPLES 700 737 EVIDENCE
750 700 GENERAL LEGAL PRINCIPLES 700 750 RES JUDICATA
762 700 GENERAL LEGAL PRINCIPLES 700 762 LACHES
775 700 GENERAL LEGAL PRINCIPLES 700 775 WAIVER
787 700 GENERAL LEGAL PRINCIPLES 700 787 ESTOPPEL
817 800 COURT PROCEEDINGS 800 817 PROCEEDINGS FOR ENFORCEMENT OR REVIEW OF BOARD DECISIONS AND ORDERS
833 800 COURT PROCEEDINGS 800 833 PROCEEDINGS ON CONTEMPT OF COURT JUDGMENT
850 800 COURT PROCEEDINGS 800 850 PROCEEDINGS ANCILLARY TO BOARD PROCEEDING
867 800 COURT PROCEEDINGS 800 867 PROCEEDINGS COLLATERAL TO BOARD PROCEEDINGS
883 800 COURT PROCEEDINGS 800 883 PROCEEDINGS UNDER OTHER STATUTES

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "l_blue_book_chapter" (
[bb_chapter] integer PRIMARY KEY,
[bb_division] integer,
[description] text,
    FOREIGN KEY ([bb_division]) REFERENCES[l_blue_book_division] ([bb_division])
);