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 = 247 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.24.0.8.1 14 Aeronautics and Space II A 247 PART 247—DIRECT AIRPORT-TO-AIRPORT MILEAGE RECORDS       § 247.1 Official mileage record of the Department of Transportation. FAA     [Amdt. 247-2, 56 FR 67170, Dec. 30, 1991, as amended at 60 FR 66725, Dec. 26, 1995; Doc. No. DOT-OST-2014-0140, 84 FR 15932, Apr. 16, 2019] The direct airport-to-airport mileage record now maintained, and as hereafter amended or revised from time to time by the Office of Airline Information of the Bureau of Transportation Statistics of the Department of Transportation in the regular performance of its duties, is hereby adopted as the official mileage record of the Department and the mileages set forth therein shall be used in all instances where it shall be necessary to determine direct airport-to-airport mileages pursuant to the provisions of 49 U.S.C. Subtitle VII (Transportation)or any rule, regulation, or order of the Department pursuant thereto.
14:14:4.0.1.1.24.0.8.2 14 Aeronautics and Space II A 247 PART 247—DIRECT AIRPORT-TO-AIRPORT MILEAGE RECORDS       §§ 247.2-247.10 [Reserved] FAA        

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