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

2 rows where part_number = 200 and title_number = 14 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
14:14:4.0.1.1.1.0.1.1 14 Aeronautics and Space II A 200 PART 200—DEFINITIONS AND INSTRUCTIONS       § 200.1 Terms and definitions. FAA     [Doc. No. DOT-OST-2014-0140, 84 FR 15924, Apr. 16, 2019] For purposes of this chapter— (a) Unless otherwise specifically stated, words and phrases other than those listed in this section have the meaning defined in 49 U.S.C. Subtitle VII. (b) Department or DOT means the Department of Transportation. (c) Predecessor means the Civil Aeronautics Board (CAB). (d) Order refers to the rules, regulations, and orders prescribed by the Department pursuant to the 49 U.S.C. Subtitle VII or its orders that are, by law, still in effect. (e) FAA means the Federal Aviation Administration, U.S. Department of Transportation. (f) OST-R means the Office of the Assistant Secretary for Research and Technology, U.S. Department of Transportation. (g) Secretary means the Secretary of Transportation, U.S. Department of Transportation.
14:14:4.0.1.1.1.0.1.2 14 Aeronautics and Space II A 200 PART 200—DEFINITIONS AND INSTRUCTIONS       § 200.2 Instructions. FAA     [Doc. No. 47939, 57 FR 40100, Sept. 2, 1992, as amended at 65 FR 6456, Feb. 9, 2000] The regulations of the Department may be cited by section numbers. For example, this regulation may be cited as “§ 200.2 of the Aviation Economic Regulations.” The sections contained in the Rules of Practice may also be cited by appropriate rule numbers. (See § 302.1(c) of this chapter.) For example, 14 CFR 302.10 may be cited as “rule 10 of the Rules of Practice.”

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