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 = 500 and title_number = 24 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
24:24:3.1.1.1.1.0.1.1 24 Housing and Urban Development V A 500 PART 500—EXPIRING PROGRAMS—SAVINGS CLAUSE       § 500.1 Expiring programs—Savings clause. HUD       No new grants or grant agreements are being made under the programs listed in this section. Existing grants or grant agreements making designation under these programs continue to be governed by the regulations in effect as they existed immediately before October 2, 2014 (see 24 CFR parts 500 to 699, revised as of April 1, 2014): 24 CFR Part 511 Rental Rehabilitation Grant Program (42 U.S.C. 1437o) 24 CFR Part 572 HOPE for Homeownership of Single Family Homes (HOPE 3) (42 U.S.C. 12891) 24 CFR Part 585 Youthbuild (42 U.S.C. 8011) 24 CFR Part 590 Urban homesteading (12 U.S.C. 1706e) 24 CFR Part 597 Urban empowerment zones and enterprise communities (Round one designations) (26 U.S.C. 1391) 24 CFR Part 598 Urban empowerment zones; Round two and three designations (26 U.S.C. 1391)

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