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

1 row where part_number = 93 and title_number = 46 sorted by section_id

✎ View and edit SQL

This data as json, CSV (advanced)

title_number 1

  • 46 · 1 ✖

part_number 1

  • 93 · 1 ✖

agency 1

  • USCG 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
46:46:4.0.1.1.4.1.1.1 46 Shipping I I 93 PART 93—STABILITY 93.01 Subpart 93.01—Application   § 93.01-1 General. USCG     [CGD 79-023, 48 FR 51008, Nov. 4, 1983] Each vessel must meet the applicable requirements in subchapter S of this chapter.

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 581.045ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API