documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
9 rows where agency_id = "CFTC", document_type = "Proposed Rule" and posted_year = 2017 sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: posted_month, comment_end_date, posted_date (date), comment_start_date (date), comment_end_date (date), last_modified (date)
| id | agency_id | docket_id | title | document_type | subtype | posted_date ▲ | posted_year | posted_month | comment_start_date | comment_end_date | last_modified | fr_doc_num | open_for_comment | withdrawn | object_id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CFTC-2017-0065-0001 | CFTC | Retail Commodity Transactions Involving Virtual Currency | Proposed Rule | 2017-12-20T05:00:00Z | 2017 | 12 | 2017-12-20T05:00:00Z | 2018-03-21T03:59:59Z | 2017-12-20T12:46:51Z | 2017-27421 | 0 | 0 | 0900006482d3f2bb | ||
| CFTC-2017-0030-0001 | CFTC | Requests for Information: Project KISS; Correction | Proposed Rule | 2017-05-24T04:00:00Z | 2017 | 5 | 2017-05-24T04:00:00Z | 2017-10-01T03:59:59Z | 2017-05-24T11:43:32Z | 2017-10622 | 0 | 0 | 0900006482609194 | ||
| CFTC-2017-0028-0001 | CFTC | Project KISS | Proposed Rule | 2017-05-09T04:00:00Z | 2017 | 5 | 2017-05-09T04:00:00Z | 2017-10-01T03:59:59Z | 2017-05-09T11:56:19Z | 2017-09318 | 0 | 0 | 090000648259bbc6 | ||
| CFTC-2017-0027-0001 | CFTC | Chief Compliance Officer Duties and Annual Report Requirements for Futures Commission Merchants, Swap Dealers, and Major Swap Participants | Proposed Rule | 2017-05-08T04:00:00Z | 2017 | 5 | 2017-05-08T04:00:00Z | 2017-07-08T03:59:59Z | 2017-05-08T12:10:48Z | 2017-09229 | 0 | 0 | 09000064825986b7 | ||
| CFTC-2017-0012-0001 | CFTC | Capital Requirements of Swap Dealers and Major Swap Participants | Proposed Rule | 2017-03-16T04:00:00Z | 2017 | 3 | 2017-03-16T04:00:00Z | 2017-05-16T03:59:59Z | 2017-03-16T11:53:57Z | 2017-05277 | 0 | 0 | 090000648250c555 | ||
| CFTC-2017-0006-0001 | CFTC | Regulation Automated Trading | Proposed Rule | 2017-01-26T05:00:00Z | 2017 | 1 | 2017-01-26T05:00:00Z | 2017-05-02T03:59:59Z | 2017-01-26T12:52:24Z | 2017-01801 | 0 | 0 | 09000064824943e8 | ||
| CFTC-2017-0005-0001 | CFTC | Swap Data Access Provisions and Certain Other Matters | Proposed Rule | 2017-01-25T05:00:00Z | 2017 | 1 | 2017-01-25T05:00:00Z | 2017-03-28T03:59:59Z | 2017-01-25T12:42:27Z | 2017-01287 | 0 | 0 | 09000064824912e2 | ||
| CFTC-2017-0003-0001 | CFTC | Technical Amendments to Rules on Registration and Review of Exchange Disciplinary, Access Denial or Other Adverse Actions | Proposed Rule | 2017-01-23T05:00:00Z | 2017 | 1 | 2017-01-23T05:00:00Z | 2017-03-25T03:59:59Z | 2017-01-20T15:37:43Z | 2017-01232 | 0 | 0 | 0900006482488bd9 | ||
| CFTC-2017-0002-0001 | CFTC | Recordkeeping | Proposed Rule | 2017-01-19T05:00:00Z | 2017 | 1 | 2017-01-19T05:00:00Z | 2017-03-21T03:59:59Z | 2017-01-19T16:29:06Z | 2017-01148 | 0 | 0 | 09000064824850e4 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE documents (
id TEXT PRIMARY KEY,
agency_id TEXT,
docket_id TEXT REFERENCES dockets(id),
title TEXT,
document_type TEXT,
subtype TEXT,
posted_date TEXT,
posted_year INTEGER,
posted_month INTEGER,
comment_start_date TEXT,
comment_end_date TEXT,
last_modified TEXT,
fr_doc_num TEXT,
open_for_comment INTEGER,
withdrawn INTEGER,
object_id TEXT
);
CREATE INDEX idx_docs_agency ON documents(agency_id);
CREATE INDEX idx_docs_docket ON documents(docket_id);
CREATE INDEX idx_docs_date ON documents(posted_date);
CREATE INDEX idx_docs_year ON documents(posted_year);
CREATE INDEX idx_docs_type ON documents(document_type);
CREATE INDEX idx_docs_frnum ON documents(fr_doc_num);
CREATE INDEX idx_docs_comment_end ON documents(comment_end_date) WHERE comment_end_date IS NOT NULL AND withdrawn = 0;