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 = 0 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:1.1.1.1.1.0.1.1 24 Housing and Urban Development     0 PART 0—STANDARDS OF CONDUCT       § 0.1 Cross-reference to employees ethical conduct standards and financial disclosure regulations. HUD     [61 FR 36251, July 9, 1996] Employees of the Department of Housing and Urban Development (Department) are subject to the executive branch-wide standards of ethical conduct at 5 CFR part 2635, the Department's regulation at 5 CFR part 7501 which supplements the executive branch-wide standards, and the executive branch-wide financial disclosure regulation at 5 CFR part 2634.

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