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

1 row where part_number = 4 and title_number = 40 sorted by section_id

✎ View and edit SQL

This data as json, CSV (advanced)

title_number 1

part_number 1

agency 1

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
40:40:1.0.1.1.4.0.1.1 40 Protection of Environment I A 4 PART 4—UNIFORM RELOCATION ASSISTANCE AND REAL PROPERTY ACQUISITION FOR FEDERAL AND FEDERALLY ASSISTED PROGRAMS       § 4.1 Uniform relocation assistance and real property acquisition. EPA     [52 FR 48023, Dec. 17, 1987 and 54 FR 8912, Mar. 2, 1989] Effective April 2, 1989, regulations and procedures for complying with the Uniform Relocation Assistance and Real Property Acquisition Policies Act of 1970 (Pub. L. 91-646, 84 Stat. 1894, 42 U.S.C. 4601), as amended by the Surface Transportation and Uniform Relocation Assistance Act of 1987 (Pub. L. 100-17, 101 Stat. 246-255, 42 U.S.C. 4601 note) are set forth in 49 CFR part 24.

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);