documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
27 rows where agency_id = "SEC", document_type = "Rule" and posted_year = 2014 sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: title, posted_date, posted_month, comment_start_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SEC-2014-2169-0001 | SEC | Credit Risk Retention | Rule | 2014-12-24T05:00:00Z | 2014 | 12 | 2014-12-24T05:00:00Z | 2014-12-24T15:22:15Z | 2014-29256 | 0 | 0 | 090000648199119b | |||
| SEC-2014-2159-0001 | SEC | Principal Trades With Certain Advisory Clients | Rule | 2014-12-23T05:00:00Z | 2014 | 12 | 2014-12-23T05:00:00Z | 2014-12-23T13:44:27Z | 2014-29975 | 0 | 0 | 090000648198ea44 | |||
| SEC-2014-2158-0001 | SEC | Adoption of Updated EDGAR Filer Manual | Rule | 2014-12-23T05:00:00Z | 2014 | 12 | 2014-12-23T05:00:00Z | 2014-12-23T13:44:25Z | 2014-30041 | 0 | 0 | 090000648198ea43 | |||
| SEC-2014-2036-0001 | SEC | Regulation Systems Compliance and Integrity | Rule | 2014-12-05T05:00:00Z | 2014 | 12 | 2014-12-05T05:00:00Z | 2014-12-05T13:42:31Z | 2014-27767 | 0 | 0 | 090000648195e6b5 | |||
| SEC-2014-1952-0001 | SEC | Staff Accounting Bulletin | Rule | 2014-11-21T05:00:00Z | 2014 | 11 | 2014-11-21T05:00:00Z | 2014-11-21T13:42:41Z | 2014-27618 | 0 | 0 | 090000648193d605 | |||
| SEC-2014-1879-0001 | SEC | Asset-Backed Securities Disclosure and Registration; Correction | Rule | 2014-11-10T05:00:00Z | 2014 | 11 | 2014-11-10T05:00:00Z | 2014-11-11T00:51:16Z | 2014-26504 | 0 | 0 | 0900006481924a8d | |||
| SEC-2014-1812-0001 | SEC | Adoption of Updated EDGAR Filer Manual | Rule | 2014-10-29T04:00:00Z | 2014 | 10 | 2014-10-29T04:00:00Z | 2014-10-29T13:57:44Z | 2014-25536 | 0 | 0 | 090000648190527c | |||
| SEC-2014-1726-0001 | SEC | Nationally Recognized Statistical Rating Organizations; Corrections | Rule | 2014-10-14T04:00:00Z | 2014 | 10 | 2014-10-14T04:00:00Z | 2014-10-14T13:29:12Z | 2014-24300 | 0 | 0 | 09000064818bca98 | |||
| SEC-2014-1651-0001 | SEC | Delegation of Authority to the Chief Financial Officer | Rule | 2014-10-01T04:00:00Z | 2014 | 10 | 2014-10-01T04:00:00Z | 2014-10-01T13:19:49Z | 2014-23394 | 0 | 0 | 090000648189faa8 | |||
| SEC-2014-1636-0001 | SEC | Asset-Backed Securities Disclosure and Registration | Rule | 2014-09-30T04:00:00Z | 2014 | 9 | 2014-09-30T04:00:00Z | 2014-09-30T13:10:19Z | C1-2014-21375 | 0 | 0 | 090000648189be3b | |||
| SEC-2014-1599-0001 | SEC | Asset-Backed Securities Disclosure and Registration | Rule | 2014-09-24T04:00:00Z | 2014 | 9 | 2014-09-24T04:00:00Z | 2014-09-24T13:19:50Z | 2014-21375 | 0 | 0 | 090000648188c915 | |||
| SEC-2014-1545-0001 | SEC | Nationally Recognized Statistical Rating Organizations | Rule | 2014-09-15T04:00:00Z | 2014 | 9 | 2014-09-15T04:00:00Z | 2014-09-15T12:03:04Z | 2014-20890 | 0 | 0 | 0900006481871aab | |||
| SEC-2014-1400-0001 | SEC | Applications: Security-Based Swap Dealer and Major Security-Based Swap Participant Definitions to Cross-Border Security-Based Swap Activities | Rule | 2014-08-19T04:00:00Z | 2014 | 8 | 2014-08-19T04:00:00Z | 2014-08-19T12:44:39Z | C1-2014-15337 | 0 | 0 | 090000648182eff8 | |||
| SEC-2014-1371-0001 | SEC | Money Market Funds | Rule | 2014-08-14T04:00:00Z | 2014 | 8 | 2014-08-14T04:00:00Z | 2014-08-14T12:38:07Z | 2014-17747 | 0 | 0 | 09000064818221e8 | |||
| SEC-2014-1359-0001 | SEC | Applications: Security-Based Swap Dealer and Major Security-Based Swap Participant Definitions to Cross-Border Security-Based Swap Activities | Rule | 2014-08-12T04:00:00Z | 2014 | 8 | 2014-08-12T04:00:00Z | 2014-08-12T12:42:30Z | R1-2014-15337 | 0 | 0 | 090000648181babd | |||
| SEC-2014-1126-0001 | SEC | Applications: Security-Based Swap Dealer and Major Security-Based Swap Participant Definitions to Cross-Border Security-Based Swap Activities | Rule | 2014-07-09T04:00:00Z | 2014 | 7 | 2014-07-09T04:00:00Z | 2014-07-09T12:56:19Z | 2014-15337 | 0 | 0 | 09000064817997be | |||
| SEC-2014-1119-0001 | SEC | Securities Exchange Act: Credit Ratings References; Removal; Correction | Rule | 2014-07-08T04:00:00Z | 2014 | 7 | 2014-07-08T04:00:00Z | 2014-07-08T13:54:48Z | 2014-15841 | 0 | 0 | 0900006481796714 | |||
| SEC-2014-1025-0001 | SEC | Adoption of Updated EDGAR Filer Manual | Rule | 2014-06-20T04:00:00Z | 2014 | 6 | 2014-06-20T04:00:00Z | 2014-06-20T12:46:28Z | 2014-14417 | 0 | 0 | 0900006481756f5b | |||
| SEC-2014-0387-0001 | SEC | EDGAR Filer Manual Update | Rule | 2014-03-10T04:00:00Z | 2014 | 3 | 2014-03-10T04:00:00Z | 2014-03-10T13:23:08Z | 2014-05057 | 0 | 0 | 090000648165ab2a | |||
| SEC-2014-0248-0001 | SEC | Security Based Swaps; Exemptions | Rule | 2014-02-10T05:00:00Z | 2014 | 2 | 2014-02-10T05:00:00Z | 2014-02-10T14:05:24Z | 2014-02833 | 0 | 0 | 0900006481556344 | |||
| SEC-2014-0189-0001 | SEC | Dodd-Frank Act: Debt Obligations Backed Primarily by Trust Preferred Securities | Rule | 2014-01-31T05:00:00Z | 2014 | 1 | 2014-01-31T05:00:00Z | 2014-03-04T04:59:59Z | 2014-01-31T14:17:47Z | 2014-02019 | 0 | 0 | 0900006481539b1c | ||
| SEC-2014-0190-0001 | SEC | Prohibitions and Restrictions on Proprietary Trading and Certain Interests In, and Relationships With, Hedge Funds and Private Equity Funds | Rule | 2014-01-31T05:00:00Z | 2014 | 1 | 2014-01-31T05:00:00Z | 2014-01-31T14:18:26Z | 2013-31511 | 0 | 0 | 0900006481539ba9 | |||
| SEC-2014-0083-0001 | SEC | Rules of the Securities Investor Protection Corporation | Rule | 2014-01-16T05:00:00Z | 2014 | 1 | 2014-01-16T05:00:00Z | 2014-01-16T13:57:35Z | 2014-00556 | 0 | 0 | 090000648150d513 | |||
| SEC-2014-0086-0001 | SEC | Registration of Municipal Advisors | Rule | 2014-01-16T05:00:00Z | 2014 | 1 | 2014-01-16T05:00:00Z | 2014-01-16T13:58:22Z | 2014-00740 | 0 | 0 | 090000648150d5ad | |||
| SEC-2014-0050-0001 | SEC | Responsibilities of the General Counsel | Rule | 2014-01-10T05:00:00Z | 2014 | 1 | 2014-01-10T05:00:00Z | 2014-01-10T14:25:53Z | 2014-00219 | 0 | 0 | 09000064814fa813 | |||
| SEC-2014-0044-0001 | SEC | Removal of Certain References to Credit Ratings under the Securities Exchange Act | Rule | 2014-01-08T05:00:00Z | 2014 | 1 | 2014-01-08T05:00:00Z | 2014-01-08T13:35:02Z | 2013-31426 | 0 | 0 | 09000064814f428c | |||
| SEC-2014-0038-0001 | SEC | Removal of Certain References to Credit Ratings under the Investment Company Act | Rule | 2014-01-08T05:00:00Z | 2014 | 1 | 2014-01-08T05:00:00Z | 2014-01-08T13:34:23Z | 2013-31425 | 0 | 0 | 09000064814f41af |
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;