l_blue_book_codes

24,546 rows

✎ View and edit SQL

This data as json, CSV (advanced)

blue_book_code ▼ bb_section bb_heading bb_chapter bb_division description
111-0100-0000-0000 0 100 111 CONSTITUTIONALITY OF APPLICATION OF NLRA 111 100 NLRA, AS AMENDED 100 GENERALLY
111-5000-0000-0000 0 5000 111 CONSTITUTIONALITY OF APPLICATION OF NLRA 111 100 NLRA, AS AMENDED 100 FIRST AMENDMENT TO CONSTITUTION
111-5800-0000-0000 0 5800 111 CONSTITUTIONALITY OF APPLICATION OF NLRA 111 100 NLRA, AS AMENDED 100 FIFTH AMENDMENT TO CONSTITUTION
111-6300-0000-0000 0 6300 111 CONSTITUTIONALITY OF APPLICATION OF NLRA 111 100 NLRA, AS AMENDED 100 TENTH AMENDMENT TO CONSTITUTION
111-7500-0000-0000 0 7500 111 CONSTITUTIONALITY OF APPLICATION OF NLRA 111 100 NLRA, AS AMENDED 100 FOURTEENTH AMENDMENT TO CONSTITUTION
122-0100-0000-0000 0 100 122 PURPOSE AND POLICY OF NLRA 122 100 NLRA, AS AMENDED 100 GENERALLY
122-3300-0000-0000 0 3300 122 PURPOSE AND POLICY OF NLRA 122 100 NLRA, AS AMENDED 100 LEGISLATIVE HISTORY
122-6700-0000-0000 0 6700 122 PURPOSE AND POLICY OF NLRA 122 100 NLRA, AS AMENDED 100 SAVINGS PROVISION
133-0100-0000-0000 0 100 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 GENERALLY
133-0600-0000-0000 0 600 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 SECTION 301 - SUITS FOR VIOLATION OF CONTRACT
133-0625-0000-0000 0 625 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 SUITS BY EMPLOYERS
133-0650-0000-0000 0 650 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 SUITS BY UNIONS
133-0675-0000-0000 0 675 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 SUITS BY EMPLOYEES
133-1200-0000-0000 0 1200 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 SECTION 302(a) - RESTRICTIONS ON PAYMENTS TO EMPLOYEE REPRESENTATIVES
133-1400-0000-0000 0 1400 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 SECTION 302(c) - EXEMPTION FROM APPLICABILITY OF 302(a)
133-2500-0000-0000 0 2500 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 LABOR MANAGEMENT REPORTING AND DISCLOSURE ACT
133-2507-0000-0000 0 2507 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 SECTION 3(k) - DEFINITION OF SECRET BALLOT
133-2513-0000-0000 0 2513 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 SECTION 101(a)(1) - EQUAL RIGHTS
133-2519-0000-0000 0 2519 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 SECTION 101(a)(3) - REQUIRING SECRET BALLOT TO APPROVE INCREASE IN DUES RATE
133-2550-0000-0000 0 2550 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 SECTION 101(a)(2) - FREEDOM OF SPEECH AND ASSEMBLY
133-2575-0000-0000 0 2575 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 SECTION 101(a)(4) - REQUIRING EXHAUSTION OF INTERNAL REMEDIES
133-3000-0000-0000 0 3000 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 MARITIME LAWS
133-3050-0000-0000 0 3050 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 SAFETY LAWS
133-3400-0000-0000 0 3400 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 SURFACE TRANSPORTATION ASSISTANCE ACT OF 1982
133-3500-0000-0000 0 3500 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 EXECUTIVE ORDERS
133-3600-0000-0000 0 3600 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 OCCUPATIONAL SAFETY AND HEALTH ACT
133-3700-0000-0000 0 3700 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 URBAN MASS TRANSPORTATION ACT OF l969
133-3800-0000-0000 0 3800 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 INTERSTATE COMMERCE ACT
133-3900-0000-0000 0 3900 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 IMMIGRATION AND NATURALIZATION ACT
133-4000-0000-0000 0 4000 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 EMPLOYEE RETIREMENT INCOME SECURITY ACT OF 1974
133-4500-0000-0000 0 4500 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 FEDERAL TORT CLAIMS ACT
133-5000-0000-0000 0 5000 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 FEDERAL SERVICE CONTRACT ACT OF 1965
133-5200-0000-0000 0 5200 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 WORKER ADJUSTMENT AND RETRAINING NOTIFICATION ACT
133-5300-0000-0000 0 5300 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 POSTAL REORGANIZATION ACT
133-5600-0000-0000 0 5600 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 PRIVACY ACT
133-5800-0000-0000 0 5800 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 FEDERAL WIRETAPPING STATUTE
133-5900-0000-0000 0 5900 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 CRIMINAL LAWS, INVESTIGATIONS AND PROCEEDINGS
133-6000-0000-0000 0 6000 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 FEDERAL DEBT COLLECTION PROCEDURE ACT
133-6200-0000-0000 0 6200 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 FREEDOM OF INFORMATION ACT (SEE 883-2500)
133-6201-0000-0000 0 6201 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 GENERALLY
133-6225-0000-0000 0 6225 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 EXEMPTION 4--TRADE SECRETS
133-6250-0000-0000 0 6250 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 EXEMPTION 5
133-6260-0000-0000 0 6260 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 EXEMPTION 6
133-6275-0000-0000 0 6275 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 EXEMPTION 7
133-6287-0000-0000 0 6287 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 APPEALS FROM INITIAL DETERMINATION
133-6299-0000-0000 0 6299 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 EXHAUSTION OF REMEDIES
133-7000-0000-0000 0 7000 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 EQUAL ACCESS TO JUSTICE ACT
133-7100-0000-0000 0 7100 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 ATOMIC ENERGY ACT
133-7200-0000-0000 0 7200 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 ANTITRUST STATUTES
133-7300-0000-0000 0 7300 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 FEDERAL MOTOR VEHICLE INFORMATION AND COST SAVINGS ACT
133-7500-0000-0000 0 7500 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 ECONOMIC STABILIZATION ACT OF 1971
133-7600-0000-0000 0 7600 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 DAVIS BACON ACT
133-7700-0000-0000 0 7700 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 FAIR LABOR STANDARDS ACT
133-7800-0000-0000 0 7800 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 Age Discrimination in Employment Act
133-7900-0000-0000 0 7900 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 DECLARATORY JUDGMENT ACT
133-8100-0000-0000 0 8100 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 RAILWAY LABOR ACT
133-8200-0000-0000 0 8200 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 BANKRUPTCY STATUTES
133-8300-0000-0000 0 8300 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 FOREIGN SOVEREIGN IMMUNITY ACT OF 1976
133-8400-0000-0000 0 8400 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 FEDERAL COMMUNICATIONS ACT
133-8500-0000-0000 0 8500 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 FEDERAL ANTI-INJUNCTION STATUTE
133-8600-0000-0000 0 8600 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 FEDERAL TAX CODE
133-8700-0000-0000 0 8700 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 STATE STATUTES
133-8701-0000-0000 0 8701 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 GENERALLY
133-8722-0000-0000 0 8722 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 Workmen's Compensation
133-8733-0000-0000 0 8733 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 RIGHT TO WORK STATUTES
133-8740-0000-0000 0 8740 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 UNIFORM FRAUDULENT TRANSFER ACT
133-8744-0000-0000 0 8744 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 WIRETAPPING STATUTES
133-8767-0000-0000 0 8767 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 QUALIFICATION TO DO BUSINESS
133-8775-0000-0000 0 8775 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 MUNICIPAL ORDINANCES
133-8800-0000-0000 0 8800 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 FEDERAL RULES OF EVIDENCE
133-8900-0000-0000 0 8900 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 FEDERAL RULES OF CIVIL PROCEDURE
133-9000-0000-0000 0 9000 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 TITLE VII OF THE CIVIL RIGHTS ACT
133-9100-0000-0000 0 9100 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 SOCIAL SECURITY ACT-MODEL CITIES PROGRAM
133-9300-0000-0000 0 9300 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 RACKETEER INFLUENCED AND CORRUPT ORGANIZATIONS ACT(RICO)
133-9500-0000-0000 0 9500 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 MINE SAFETY AND HEALTH ACT
133-9600-0000-0000 0 9600 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 CIVIL SERVICE REFORM ACT OF 1978
133-9700-0000-0000 0 9700 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 ALL WRITS ACT
133-9800-0000-0000 0 9800 133 RELATIONSHIP TO OTHER STATUTES AND PUBLIC POLICY 133 100 NLRA, AS AMENDED 100 AMERICAN DISABILITIES ACT
144-5000-0000-0000 0 5000 144 CONSTRUCTION 144 100 NLRA, AS AMENDED 100 LEGISLATIVE HISTORY
144-7500-0000-0000 0 7500 144 CONSTRUCTION 144 100 NLRA, AS AMENDED 100 COURT INTERPRETATION OF STATUTORY PROVISIONS
155-2000-0000-0000 0 2000 155 AMENDMENTS OF NLRA 155 100 NLRA, AS AMENDED 100 CONSTITUTIONALITY OF AMENDMENTS
155-4000-0000-0000 0 4000 155 AMENDMENTS OF NLRA 155 100 NLRA, AS AMENDED 100 EFFECTIVE DATE OF APPLICATION
155-6000-0000-0000 0 6000 155 AMENDMENTS OF NLRA 155 100 NLRA, AS AMENDED 100 RETROACTIVE APPLICATION
155-8000-0000-0000 0 8000 155 AMENDMENTS OF NLRA 155 100 NLRA, AS AMENDED 100 EFFECT OF AMENDMENTS
177-0800-0000-0000 0 800 177 STATUTORY DEFINITIONS 177 100 NLRA, AS AMENDED 100 "PERSON"
177-0801-0000-0000 0 801 177 STATUTORY DEFINITIONS 177 100 NLRA, AS AMENDED 100 GENERALLY
177-0850-0000-0000 0 850 177 STATUTORY DEFINITIONS 177 100 NLRA, AS AMENDED 100 SECTION 2(1) DEFINITION OF "ANY PERSON"
177-1600-0000-0000 0 1600 177 STATUTORY DEFINITIONS 177 100 NLRA, AS AMENDED 100 EMPLOYER
177-1601-0000-0000 0 1601 177 STATUTORY DEFINITIONS 177 100 NLRA, AS AMENDED 100 GENERALLY
177-1617-0000-0000 0 1617 177 STATUTORY DEFINITIONS 177 100 NLRA, AS AMENDED 100 AGENT OF EMPLOYER (SEE ALSO GENERAL LEGAL PRINCIPLES 712)
177-1617-1700-0000 1700 1617 177 STATUTORY DEFINITIONS 177 100 NLRA, AS AMENDED 100 Employer associations
177-1617-2500-0000 2500 1617 177 STATUTORY DEFINITIONS 177 100 NLRA, AS AMENDED 100 Employee
177-1617-3300-0000 3300 1617 177 STATUTORY DEFINITIONS 177 100 NLRA, AS AMENDED 100 Officials of corporate employers
177-1617-4000-0000 4000 1617 177 STATUTORY DEFINITIONS 177 100 NLRA, AS AMENDED 100 Consultant
177-1617-5000-0000 5000 1617 177 STATUTORY DEFINITIONS 177 100 NLRA, AS AMENDED 100 Companies performing work for employer or having work performed by employer
177-1617-6700-0000 6700 1617 177 STATUTORY DEFINITIONS 177 100 NLRA, AS AMENDED 100 Public officials
177-1617-7500-0000 7500 1617 177 STATUTORY DEFINITIONS 177 100 NLRA, AS AMENDED 100 Partner
177-1617-8300-0000 8300 1617 177 STATUTORY DEFINITIONS 177 100 NLRA, AS AMENDED 100 Civic organizations
177-1633-0000-0000 0 1633 177 STATUTORY DEFINITIONS 177 100 NLRA, AS AMENDED 100 PERSONS FOUND TO BE EMPLOYERS
177-1633-2500-0000 2500 1633 177 STATUTORY DEFINITIONS 177 100 NLRA, AS AMENDED 100 Separate employers

Next page

Advanced export

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

CSV options: 

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