l_blue_book_section

12,607 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link bb_section bb_heading bb_chapter bb_division description
0,100,111,100 0 100 111 CONSTITUTIONALITY OF APPLICATION OF NLRA 111 100 NLRA, AS AMENDED 100 GENERALLY
0,100,122,100 0 100 122 PURPOSE AND POLICY OF NLRA 122 100 NLRA, AS AMENDED 100 GENERALLY
0,100,133,100 0 100 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 GENERALLY
0,100,188,100 0 100 188 AUTHORITY AND STRUCTURE OF NLRB AS AGENCY 188 100 NLRA, AS AMENDED 100 GENERALLY
0,100,220,200 0 100 220 STATUTORY JURISDICTION 220 200 NLRB JURISDICTION 200 GENERALLY
0,100,240,200 0 100 240 DISCRETION IN EXERCISE OF JURISDICTION 240 200 NLRB JURISDICTION 200 GENERALLY
0,100,260,200 0 100 260 STANDARDS FOR ASSERTION OF JURISDICTION 260 200 NLRB JURISDICTION 200 GENERALLY
0,100,280,200 0 100 280 ENTERPRISES OVER WHICH THE BOARD DID OR DID NOT ASSERT JURISDICTION 280 200 NLRB JURISDICTION 200 AGRICULTURAL PRODUCTION - CROPS
0,100,308,300 0 100 308 WHO MAY RAISE QUESTION OF REPRESENTATION 308 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 GENERALLY
0,100,316,300 0 100 316 HOW QUESTION OF REPRESENTATION IS RAISED 316 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 GENERALLY
0,100,324,300 0 100 324 SHOWING OF INTEREST IN REPRESENTATION 324 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 GENERALLY
0,100,332,300 0 100 332 DISCLAIMER OF INTEREST IN BEING REPRESENTATIVE 332 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 GENERALLY
0,100,339,300 0 100 339 WHO MAY ACT AS REPRESENTATIVE 339 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 GENERALLY
0,100,347,300 0 100 347 BARS TO CONDUCT OF ELECTION 347 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 GENERALLY
0,100,362,300 0 100 362 ELIGIBILITY TO PARTICIPATE IN ELECTION 362 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 GENERALLY
0,100,370,300 0 100 370 MECHANICS OF ELECTION 370 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 GENERALLY
0,100,378,300 0 100 378 CONDUCT INTERFERING WITH ELECTION CHOICE 378 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 GENERALLY
0,100,385,300 0 100 385 POST-CERTIFICATION AND UNIT CLARIFICATION ISSUES 385 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 GENERALLY
0,100,393,300 0 100 393 PROCEDURE IN REPRESENTATION PROCEEDINGS 393 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 GENERALLY
0,100,420,400 0 100 420 FACTORS RELEVANT TO DETERMINATION OF SCOPE OR COMPOSITION OF UNIT 420 400 BARGAINING UNITS 400 GENERALLY
0,100,470,400 0 100 470 HEALTH CARE INSTITUTION UNITS 470 400 BARGAINING UNITS 400 GENERALLY (FOR DEFINITIONS OF HEALTH CARE INSTITUTIONS SEE 177-9700-0000-0000)
0,100,480,400 0 100 480 POSTAL SERVICE UNITS 480 400 BARGAINING UNITS 400 GENERALLY
0,100,506,500 0 100 506 EMPLOYEE RIGHTS PROTECTED BY SECTION 7 506 500 UNFAIR LABOR PRACTICES 500 GENERALLY
0,100,512,500 0 100 512 EMPLOYER INTERFERENCE WITH EMPLOYEE SECTION 7 RIGHTS (8(a)(1)) 512 500 UNFAIR LABOR PRACTICES 500 GENERALLY
0,100,518,500 0 100 518 EMPLOYER DOMINATION, ASSISTANCE OR SUPPORT OF LABOR ORGANIZATION 518 500 UNFAIR LABOR PRACTICES 500 GENERALLY
0,100,524,500 0 100 524 EMPLOYER DISCRIMINATION IN EMPLOYMENT 524 500 UNFAIR LABOR PRACTICES 500 GENERALLY
0,100,530,500 0 100 530 EMPLOYER OBLIGATION TO BARGAIN 530 500 UNFAIR LABOR PRACTICES 500 GENERALLY
0,100,536,500 0 100 536 UNION COERCION OF EMPLOYEES (8(b)(1)(A)) 536 500 UNFAIR LABOR PRACTICES 500 GENERALLY
0,100,542,500 0 100 542 UNION COERCION OF EMPLOYER IN SELECTION OF REPRESENTATIVES 542 500 UNFAIR LABOR PRACTICES 500 GENERALLY
0,100,548,500 0 100 548 UNION CAUSATION OF EMPLOYER DISCRIMINATION 548 500 UNFAIR LABOR PRACTICES 500 GENERALLY
0,100,554,500 0 100 554 UNION OBLIGATION TO BARGAIN 554 500 UNFAIR LABOR PRACTICES 500 GENERALLY
0,100,560,500 0 100 560 PROHIBITED STRIKES AND BOYCOTTS 560 500 UNFAIR LABOR PRACTICES 500 GENERALLY
0,100,572,500 0 100 572 PAYMENT FOR SERVICES NOT PERFORMED - (SEC. 8(b)(6)) 572 500 UNFAIR LABOR PRACTICES 500 GENERALLY
0,100,578,500 0 100 578 PICKETING FOR RECOGNITION AND BARGAINING 578 500 UNFAIR LABOR PRACTICES 500 GENERALLY
0,100,584,500 0 100 584 AGREEMENTS TO CEASE DOING BUSINESS 584 500 UNFAIR LABOR PRACTICES 500 GENERALLY
0,100,590,500 0 100 590 PREHIRE AGREEMENTS - SECTION 8(f) 590 500 UNFAIR LABOR PRACTICES 500 GENERALLY
0,100,593,500 0 100 593PICKETING AND STRIKES AT HEALTH CARE INSTITUTIONS (SECTION 8(g)) 593 500 UNFAIR LABOR PRACTICES 500 GENERALLY
0,100,596,500 0 100 596 PROCEDURE IN ULP PROCEEDINGS 596 500 UNFAIR LABOR PRACTICES 500 GENERALLY
0,100,675,600 0 100 675 PROCEEDINGS TO DETERMINE BACKPAY LIABILITY (FOR COMPUTATION OF BACKPAY SEE HEADINGS UNDER 625-4433) 675 600 REMEDIAL ORDER PROVISIONS 600 GENERALLY
0,100,725,700 0 100 725 CONTRACT LAW 725 700 GENERAL LEGAL PRINCIPLES 700 GENERALLY
0,100,737,700 0 100 737 EVIDENCE 737 700 GENERAL LEGAL PRINCIPLES 700 GENERALLY
0,100,750,700 0 100 750 RES JUDICATA 750 700 GENERAL LEGAL PRINCIPLES 700 GENERALLY
0,100,762,700 0 100 762 LACHES 762 700 GENERAL LEGAL PRINCIPLES 700 GENERALLY
0,100,775,700 0 100 775 WAIVER 775 700 GENERAL LEGAL PRINCIPLES 700 GENERALLY
0,100,787,700 0 100 787 ESTOPPEL 787 700 GENERAL LEGAL PRINCIPLES 700 GENERALLY
0,100,817,800 0 100 817 PROCEEDINGS FOR ENFORCEMENT OR REVIEW OF BOARD DECISIONS AND ORDERS 817 800 COURT PROCEEDINGS 800 GENERALLY
0,100,833,800 0 100 833 PROCEEDINGS ON CONTEMPT OF COURT JUDGMENT 833 800 COURT PROCEEDINGS 800 GENERALLY
0,100,867,800 0 100 867 PROCEEDINGS COLLATERAL TO BOARD PROCEEDINGS 867 800 COURT PROCEEDINGS 800 GENERALLY
0,110,280,200 0 110 280 ENTERPRISES OVER WHICH THE BOARD DID OR DID NOT ASSERT JURISDICTION 280 200 NLRB JURISDICTION 200 CASH GRAINS
0,114,506,500 0 114 506 EMPLOYEE RIGHTS PROTECTED BY SECTION 7 506 500 UNFAIR LABOR PRACTICES 500 RIGHT OF SELF-ORGANIZATION
0,117,512,500 0 117 512 EMPLOYER INTERFERENCE WITH EMPLOYEE SECTION 7 RIGHTS (8(a)(1)) 512 500 UNFAIR LABOR PRACTICES 500 SCOPE OF PROSCRIPTION
0,117,524,500 0 117 524 EMPLOYER DISCRIMINATION IN EMPLOYMENT 524 500 UNFAIR LABOR PRACTICES 500 SCOPE OF PROSCRIPTION
0,120,378,300 0 120 378 CONDUCT INTERFERING WITH ELECTION CHOICE 378 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 BOARD RESPONSIBLE FOR FAIR ELECTION
0,120,518,500 0 120 518 EMPLOYER DOMINATION, ASSISTANCE OR SUPPORT OF LABOR ORGANIZATION 518 500 UNFAIR LABOR PRACTICES 500 EMPLOYER'S OBLIGATION OF NEUTRALITY TOWARDS EMPLOYEE'S ORGANIZATIONAL ACTIVITIES (See also 518-4040-6701-3300)
0,120,584,500 0 120 584 AGREEMENTS TO CEASE DOING BUSINESS 584 500 UNFAIR LABOR PRACTICES 500 NATURE AND PURPOSE OF PROSCRIPTION
0,125,324,300 0 125 324 SHOWING OF INTEREST IN REPRESENTATION 324 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 INTEREST REQUIREMENT AS BOARD POLICY
0,125,470,400 0 125 470 HEALTH CARE INSTITUTION UNITS 470 400 BARGAINING UNITS 400 EFFECT OF STIPULATIONS
0,125,480,400 0 125 480 POSTAL SERVICE UNITS 480 400 BARGAINING UNITS 400 POSTAL REORGANIZATION ACT OF 1970
0,125,512,500 0 125 512 EMPLOYER INTERFERENCE WITH EMPLOYEE SECTION 7 RIGHTS (8(a)(1)) 512 500 UNFAIR LABOR PRACTICES 500 INDIVIDUALS AFFECTED
0,125,542,500 0 125 542 UNION COERCION OF EMPLOYER IN SELECTION OF REPRESENTATIVES 542 500 UNFAIR LABOR PRACTICES 500 SCOPE OF PRESCRIPTION
0,125,548,500 0 125 548 UNION CAUSATION OF EMPLOYER DISCRIMINATION 548 500 UNFAIR LABOR PRACTICES 500 NATURE AND SCOPE OF PROSCRIPTION
0,125,554,500 0 125 554 UNION OBLIGATION TO BARGAIN 554 500 UNFAIR LABOR PRACTICES 500 SECTION 301 SUITS
0,125,596,500 0 125 596 PROCEDURE IN ULP PROCEEDINGS 596 500 UNFAIR LABOR PRACTICES 500 APPLICABILITY AND EFFECT OF APA
0,125,817,800 0 125 817 PROCEEDINGS FOR ENFORCEMENT OR REVIEW OF BOARD DECISIONS AND ORDERS 817 800 COURT PROCEEDINGS 800 BOARD ALONE MAY SEEK ENFORCEMENT
0,125,833,800 0 125 833 PROCEEDINGS ON CONTEMPT OF COURT JUDGMENT 833 800 COURT PROCEEDINGS 800 BOARD ONLY MAY INSTITUTE CONTEMPT PROCEEDINGS
0,128,506,500 0 128 506 EMPLOYEE RIGHTS PROTECTED BY SECTION 7 506 500 UNFAIR LABOR PRACTICES 500 RIGHT TO FORM, JOIN, OR ASSIST LABOR ORGANIZATIONS
0,130,280,200 0 130 280 ENTERPRISES OVER WHICH THE BOARD DID OR DID NOT ASSERT JURISDICTION 280 200 NLRB JURISDICTION 200 FIELD CROPS, EXCEPT CASH GRAINS
0,130,584,500 0 130 584 AGREEMENTS TO CEASE DOING BUSINESS 584 500 UNFAIR LABOR PRACTICES 500 CONSTRUCTION OF CONTRACT CLAUSES
0,133,240,200 0 133 240 DISCRETION IN EXERCISE OF JURISDICTION 240 200 NLRB JURISDICTION 200 DISTINCTION BETWEEN BOARD'S MONETARY JURISDICTIONAL STANDARDS AND LEGAL OR STATUTORY JURISDICTION
0,133,393,300 0 133 393 PROCEDURE IN REPRESENTATION PROCEEDINGS 393 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 EXEMPT FROM APA ADJUDICATION REQUIREMENTS
0,133,512,500 0 133 512 EMPLOYER INTERFERENCE WITH EMPLOYEE SECTION 7 RIGHTS (8(a)(1)) 512 500 UNFAIR LABOR PRACTICES 500 ISOLATED ACTS
0,133,524,500 0 133 524 EMPLOYER DISCRIMINATION IN EMPLOYMENT 524 500 UNFAIR LABOR PRACTICES 500 INDIVIDUALS AFFECTED
0,133,530,500 0 133 530 EMPLOYER OBLIGATION TO BARGAIN 530 500 UNFAIR LABOR PRACTICES 500 NATURE AND PURPOSE OF COLLECTIVE BARGAINING
0,137,596,500 0 137 596 PROCEDURE IN ULP PROCEEDINGS 596 500 UNFAIR LABOR PRACTICES 500 APPLICABILITY OF FEDERAL RULES OF EVIDENCE
0,140,378,300 0 140 378 CONDUCT INTERFERING WITH ELECTION CHOICE 378 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 DELEGATION OF ELECTION DETAILS TO REGIONAL DIRECTOR PROPER
0,140,518,500 0 140 518 EMPLOYER DOMINATION, ASSISTANCE OR SUPPORT OF LABOR ORGANIZATION 518 500 UNFAIR LABOR PRACTICES 500 EFFECT OF STATEMENTS OF NEUTRALITY
0,140,584,500 0 140 584 AGREEMENTS TO CEASE DOING BUSINESS 584 500 UNFAIR LABOR PRACTICES 500 CONSTRUCTION OF LEGISLATIVE HISTORY
0,142,506,500 0 142 506 EMPLOYEE RIGHTS PROTECTED BY SECTION 7 506 500 UNFAIR LABOR PRACTICES 500 RIGHT TO BARGAIN COLLECTIVELY THROUGH REPRESENTATIVE OF OWN CHOOSING
0,142,512,500 0 142 512 EMPLOYER INTERFERENCE WITH EMPLOYEE SECTION 7 RIGHTS (8(a)(1)) 512 500 UNFAIR LABOR PRACTICES 500 DE MINIMIS VIOLATIONS
0,150,220,200 0 150 220 STATUTORY JURISDICTION 220 200 NLRB JURISDICTION 200 INCUMBENT ON BOARD TO ESTABLISH LEGAL JURISDICTION AS AUTHORITY TO PROCEED
0,150,240,200 0 150 240 DISCRETION IN EXERCISE OF JURISDICTION 240 200 NLRB JURISDICTION 200 DISCRETION TO DECLINE TO EXERCISE JURISDICTION
0,150,260,200 0 150 260 STANDARDS FOR ASSERTION OF JURISDICTION 260 200 NLRB JURISDICTION 200 NOT-FOR-PROFIT EMPLOYERS SUBJECT TO STANDARDS ON SAME BASIS AS FOR-PROFIT EMPLOYERS
0,150,324,300 0 150 324 SHOWING OF INTEREST IN REPRESENTATION 324 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 PURPOSE OF REQUIREMENT TO LIMIT ELECTIONS TO THOSE SITUATIONS WHERE THERE IS ENOUGH INTEREST TO JUSTIFY THEM
0,150,378,300 0 150 378 CONDUCT INTERFERING WITH ELECTION CHOICE 378 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 BOARD MAY CONSIDER CONCURRENT ULP'S EVEN THOUGH NOT ALLEGED IN OBJECTIONS
0,150,385,300 0 150 385 POST-CERTIFICATION AND UNIT CLARIFICATION ISSUES 385 300 INVESTIGATION AND CERTIFICATION OF REPRESENTATIVE 300 BOARD AUTHORITY TO AMEND, CLARIFY, AND POLICE CERTIFICATION INHERENT IN AUTHORITY TO ISSUE
0,150,420,400 0 150 420 FACTORS RELEVANT TO DETERMINATION OF SCOPE OR COMPOSITION OF UNIT 420 400 BARGAINING UNITS 400 PRESUMPTION OF APPROPRIATENESS OF 9(b) UNITS
0,150,470,400 0 150 470 HEALTH CARE INSTITUTION UNITS 470 400 BARGAINING UNITS 400 LEGISLATIVE HISTORY
0,150,480,400 0 150 480 POSTAL SERVICE UNITS 480 400 BARGAINING UNITS 400 BARGAINING HISTORY AND PRACTICE
0,150,512,500 0 150 512 EMPLOYER INTERFERENCE WITH EMPLOYEE SECTION 7 RIGHTS (8(a)(1)) 512 500 UNFAIR LABOR PRACTICES 500 ACTS OR STATEMENTS NEUTRALIZING COERCIVE EFFECT OF PREJUDICIAL CONDUCT
0,150,524,500 0 150 524 EMPLOYER DISCRIMINATION IN EMPLOYMENT 524 500 UNFAIR LABOR PRACTICES 500 WHAT CONSTITUTES DISCRIMINATION
0,150,536,500 0 150 536 UNION COERCION OF EMPLOYEES (8(b)(1)(A)) 536 500 UNFAIR LABOR PRACTICES 500 SCOPE OF PROSCRIPTION
0,150,542,500 0 150 542 UNION COERCION OF EMPLOYER IN SELECTION OF REPRESENTATIVES 542 500 UNFAIR LABOR PRACTICES 500 SECTION 8(b)(1)(A) PROVISO NOT APPLICABLE TO SECTION 8(b)(1)(B)
0,150,548,500 0 150 548 UNION CAUSATION OF EMPLOYER DISCRIMINATION 548 500 UNFAIR LABOR PRACTICES 500 FINDING OF 8(a)(3) VIOLATION NOT PREREQUISITE TO 8(b)(2) FINDING
0,150,554,500 0 150 554 UNION OBLIGATION TO BARGAIN 554 500 UNFAIR LABOR PRACTICES 500 SETTLEMENT AGREEMENTS
0,150,590,500 0 150 590 PREHIRE AGREEMENTS - SECTION 8(f) 590 500 UNFAIR LABOR PRACTICES 500 STATUTORY OBJECTIVES OF SECTION 8(f)
0,150,596,500 0 150 596 PROCEDURE IN ULP PROCEEDINGS 596 500 UNFAIR LABOR PRACTICES 500 PRESUMPTION OF ADMINISTRATIVE REGULARITY
0,150,725,700 0 150 725 CONTRACT LAW 725 700 GENERAL LEGAL PRINCIPLES 700 TECHNICAL RULES OF CONTRACT LAW NOT NECESSARILY CONTROLLING UNDER NLRA
0,150,737,700 0 150 737 EVIDENCE 737 700 GENERAL LEGAL PRINCIPLES 700 FEDERAL RULES OF EVIDENCE, APPLICABILITY (SECTION 10(b))
0,150,750,700 0 150 750 RES JUDICATA 750 700 GENERAL LEGAL PRINCIPLES 700 PRIOR COURT OR AGENCY DECISION
0,150,817,800 0 150 817 PROCEEDINGS FOR ENFORCEMENT OR REVIEW OF BOARD DECISIONS AND ORDERS 817 800 COURT PROCEEDINGS 800 ENFORCEMENT PERMISSIVE, NOT MANDATORY

Next page

Advanced export

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

CSV options: 

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