documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
20 rows where agency_id = "SEC", document_type = "Rule" and posted_year = 2013 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-2013-2250-0001 | SEC | Securities Exempted: Distribution of Shares by Registered Open-End Management Investment Company; Applications Regarding Joint Enterprises or Arrangements and Certain Profit-Sharing Plans | Rule | 2013-12-30T05:00:00Z | 2013 | 12 | 2013-12-30T05:00:00Z | 2013-12-30T14:12:32Z | 2013-31172 | 0 | 0 | 09000064814e1a4e | |||
| SEC-2013-1912-0001 | SEC | Registration of Municipal Advisors | Rule | 2013-11-12T05:00:00Z | 2013 | 11 | 2013-11-12T05:00:00Z | 2013-11-12T17:51:09Z | 2013-23524 | 0 | 0 | 090000648147736c | |||
| SEC-2013-1722-0001 | SEC | Adoption of Updated EDGAR Filer Manual | Rule | 2013-10-02T04:00:00Z | 2013 | 10 | 2013-10-02T04:00:00Z | 2013-10-02T13:05:58Z | 2013-23914 | 0 | 0 | 0900006481443a08 | |||
| SEC-2013-1682-0001 | SEC | Registration of Municipal Advisors; Extension | Rule | 2013-09-30T04:00:00Z | 2013 | 9 | 2013-09-30T04:00:00Z | 2013-09-30T13:18:02Z | 2013-23519 | 0 | 0 | 0900006481440695 | |||
| SEC-2013-1497-0001 | SEC | Financial Responsibility Rules for Broker-Dealers | Rule | 2013-08-21T04:00:00Z | 2013 | 8 | 2013-08-21T04:00:00Z | 2013-08-21T13:03:13Z | 2013-18734 | 0 | 0 | 09000064813bcee0 | |||
| SEC-2013-1491-0001 | SEC | Broker-Dealer Reports | Rule | 2013-08-21T04:00:00Z | 2013 | 8 | 2013-08-21T04:00:00Z | 2013-08-21T13:03:12Z | 2013-18738 | 0 | 0 | 09000064813bcd3d | |||
| SEC-2013-1364-0001 | SEC | Delegationof Authority to Director of the Division of Enforcement | Rule | 2013-08-01T04:00:00Z | 2013 | 8 | 2013-08-01T04:00:00Z | 2013-08-01T13:00:15Z | 2013-18468 | 0 | 0 | 090000648138a0b9 | |||
| SEC-2013-1359-0001 | SEC | Adoption of the Updated Electronic Data Gathering, Analysis, and Retrieval System Filer Manual | Rule | 2013-07-31T04:00:00Z | 2013 | 7 | 2013-07-31T04:00:00Z | 2013-07-31T12:59:06Z | 2013-18395 | 0 | 0 | 09000064813874ab | |||
| SEC-2013-1333-0001 | SEC | Eliminating the Prohibition Against General Solicitation and General Advertising in Rule 506 and Rule 144A Offerings | Rule | 2013-07-24T04:00:00Z | 2013 | 7 | 2013-07-24T04:00:00Z | 2013-07-24T14:00:45Z | 2013-16883 | 0 | 0 | 0900006481379d77 | |||
| SEC-2013-1336-0001 | SEC | Disqualification of Felons and Other Bad Actors from Rule 506 Offerings | Rule | 2013-07-24T04:00:00Z | 2013 | 7 | 2013-07-24T04:00:00Z | 2013-08-24T03:59:59Z | 2013-07-24T14:00:38Z | 2013-16983 | 0 | 0 | 0900006481379e1c | ||
| SEC-2013-1303-0001 | SEC | Rescission of Supervised Investment Bank Holding Company Rules | Rule | 2013-07-18T04:00:00Z | 2013 | 7 | 2013-07-18T04:00:00Z | 2013-07-18T13:51:40Z | 2013-17194 | 0 | 0 | 090000648136d3fd | |||
| SEC-2013-1294-0001 | SEC | Retail Foreign Exchange Transactions | Rule | 2013-07-16T04:00:00Z | 2013 | 7 | 2013-07-16T04:00:00Z | 2013-07-16T13:31:33Z | 2013-17015 | 0 | 0 | 09000064813685cc | |||
| SEC-2013-0949-0001 | SEC | Adoption of Updated EDGAR Filer Manual | Rule | 2013-05-21T04:00:00Z | 2013 | 5 | 2013-05-21T04:00:00Z | 2013-05-21T13:34:28Z | 2013-11921 | 0 | 0 | 09000064812efc5d | |||
| SEC-2013-0757-0001 | SEC | Identity Theft Red Flags Rules | Rule | 2013-04-19T04:00:00Z | 2013 | 4 | 2013-04-19T04:00:00Z | 2013-04-19T12:48:06Z | 2013-08830 | 0 | 0 | 090000648129c6c6 | |||
| SEC-2013-0671-0001 | SEC | Filing Requirements for Dually-Registered Clearing Agencies; Amendment | Rule | 2013-04-09T04:00:00Z | 2013 | 4 | 2013-04-09T04:00:00Z | 2013-04-09T12:43:45Z | 2013-08141 | 0 | 0 | 0900006481289e30 | |||
| SEC-2013-0422-0001 | SEC | Adjustments to Civil Monetary Penalty Amounts | Rule | 2013-03-05T05:00:00Z | 2013 | 3 | 2013-03-05T05:00:00Z | 2013-03-05T13:32:43Z | 2013-04931 | 0 | 0 | 090000648121804c | |||
| SEC-2013-0200-0001 | SEC | Extension of Exemptions for Security-Based Swaps | Rule | 2013-02-04T05:00:00Z | 2013 | 2 | 2013-02-04T05:00:00Z | 2013-02-04T14:12:52Z | 2013-02191 | 0 | 0 | 09000064811e4e06 | |||
| SEC-2013-0137-0001 | SEC | EDGAR Filer Manual | Rule | 2013-01-23T05:00:00Z | 2013 | 1 | 2013-01-23T05:00:00Z | 2013-01-23T14:35:04Z | 2013-01058 | 0 | 0 | 09000064811d32b5 | |||
| SEC-2013-0132-0001 | SEC | Lost Securityholders and Unresponsive Payees | Rule | 2013-01-23T05:00:00Z | 2013 | 1 | 2013-01-23T05:00:00Z | 2013-01-23T14:35:06Z | 2013-01269 | 0 | 0 | 09000064811d31c7 | |||
| SEC-2013-0139-0001 | SEC | Authority Citation Correction | Rule | 2013-01-23T05:00:00Z | 2013 | 1 | 2013-01-23T05:00:00Z | 2013-01-23T14:35:01Z | 2013-01202 | 0 | 0 | 09000064811d32b7 |
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;