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

4 rows where part_number = 418 and title_number = 9 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
9:9:2.0.2.4.42.0.40.1 9 Animals and Animal Products III E 418 PART 418—RECALLS       § 418.1 [Reserved] FSIS        
9:9:2.0.2.4.42.0.40.2 9 Animals and Animal Products III E 418 PART 418—RECALLS       § 418.2 Notification. FSIS       Each official establishment must promptly notify the local FSIS District Office within 24 hours of learning or determining that an adulterated or misbranded meat, meat food, poultry, or poultry product received by or originating from the official establishment has entered commerce, if the official establishment believes or has reason to believe that this has happened. The official establishment must inform the District Office of the type, amount, origin, and destination of the adulterated or misbranded product.
9:9:2.0.2.4.42.0.40.3 9 Animals and Animal Products III E 418 PART 418—RECALLS       § 418.3 Preparation and maintenance of written recall procedures. FSIS       Each official establishment must prepare and maintain written procedures for the recall of any meat, meat food, poultry, or poultry product produced and shipped by the official establishment. These written procedures must specify how the official establishment will decide whether to conduct a product recall, and how the establishment will effect the recall, should it decide that one is necessary.
9:9:2.0.2.4.42.0.40.4 9 Animals and Animal Products III E 418 PART 418—RECALLS       § 418.4 Records. FSIS       All records, including records documenting procedures required by this part, must be available for official review and copying.

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