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 = 35 and title_number = 17 sorted by section_id

✎ View and edit SQL

This data as json, CSV (advanced)

title_number 1

  • 17 · 1 ✖

part_number 1

  • 35 · 1 ✖

agency 1

  • CFTC 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
17:17:1.0.1.1.28.0.7.1 17 Commodity and Securities Exchanges I   35 PART 35—SWAPS IN AN AGRICULTURAL COMMODITY (AGRICULTURAL SWAPS)       § 35.1 Agricultural swaps, generally. CFTC       (a) Any person or group of persons may offer to enter into, enter into, confirm the execution of, maintain a position in, or otherwise conduct activity related to, any transaction in interstate commerce that is a swap in an agricultural commodity subject to all provisions of the Act, including any Commission rule, regulation, or order thereunder, otherwise applicable to any other swap; and (b) In addition to paragraph (a) of this section, any transaction in interstate commerce that is a swap in an agricultural commodity may be transacted on a swap execution facility, designated contract market, or otherwise in accordance with all provisions of the Act, including any Commission rule, regulation, or order thereunder, applicable to any other swap eligible to be transacted on a swap execution facility, designated contract market, or otherwise.

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