home / openregs

cfr_sections

Current Code of Federal Regulations (eCFR) — the actual text of federal regulations in force. Covers 19 CFR titles with 123,000+ regulatory sections and full-text search.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

3 rows where part_number = 1204 and title_number = 29 sorted by section_id

✎ View and edit SQL

This data as json, CSV (advanced)

title_number 1

  • 29 · 3 ✖

part_number 1

  • 1204 · 3 ✖

agency 1

  • NMB 3
section_id ▼ title_number title_name chapter subchapter part_number part_name subpart subpart_name section_number section_heading agency authority source_citation amendment_citations full_text
29:29:4.1.2.1.5.0.1.1 29 Labor X   1204 PART 1204—LABOR CONTRACTS       § 1204.1 Making and maintaining contracts. NMB       It is the duty of all carriers, their officers, agents, and employees to exert every reasonable effort to make and maintain contracts covering rates of pay, rules, and working conditions.
29:29:4.1.2.1.5.0.1.2 29 Labor X   1204 PART 1204—LABOR CONTRACTS       § 1204.2 Arbitrary changing of contracts. NMB       No carrier, its officers, or agents shall change the rates of pay, rules, or working conditions of its employees, as a class as embodied in agreements except in the manner prescribed in such agreements or in section 6 of the Railway Labor Act.
29:29:4.1.2.1.5.0.1.3 29 Labor X   1204 PART 1204—LABOR CONTRACTS       § 1204.3 Filing of contracts. NMB       Section 5, Third, (e) of the Railway Labor Act requires all carriers to file with the National Mediation Board copies of all contracts in effect with organizations representing their employees, covering rates of pay, rules, and working conditions. Several thousand of such contracts are on file in the Board's Washington office and are available for inspection by interested parties.

Advanced export

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

CSV options:

CREATE TABLE cfr_sections (
    section_id TEXT PRIMARY KEY,
    title_number INTEGER,
    title_name TEXT,
    chapter TEXT,
    subchapter TEXT,
    part_number TEXT,
    part_name TEXT,
    subpart TEXT,
    subpart_name TEXT,
    section_number TEXT,
    section_heading TEXT,
    agency TEXT,
    authority TEXT,
    source_citation TEXT,
    amendment_citations TEXT,
    full_text TEXT
);
CREATE INDEX idx_cfr_title ON cfr_sections(title_number);
CREATE INDEX idx_cfr_part ON cfr_sections(part_number);
CREATE INDEX idx_cfr_agency ON cfr_sections(agency);
Powered by Datasette · Queries took 311.131ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API