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 = 3 and title_number = 49 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
49:49:1.0.1.1.2.0.3.1 49 Transportation A   3 PART 3—OFFICIAL SEAL       § 3.1 Description. DOT       The official seal of the Department of Transportation is described as follows: A white abstract triskelion figure signifying motion appears within a circular blue field. The figure is symmetrical. The three branches of the figure curve outward in a counter-clockwise direction, each tapering almost to a point at the edge of the field. Surrounding the blue circle is a circular ring of letters. The upper half of the ring shows the words “Department of Transportation”. The lower half of the ring shows the words “United States of America”. The letters may be shown in either black or medium gray. The official seal of the Department is modified when embossed. It appears below in black and white.

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