documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
25 rows where agency_id = "SEC", document_type = "Proposed Rule" and posted_year = 2009 sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: title, posted_date, posted_month, comment_start_date, comment_end_date, last_modified, 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-2009-1817-0001 | SEC | Revisions To Rule 163 | Proposed Rule | 2009-12-28T05:00:00Z | 2009 | 12 | 2009-12-28T05:00:00Z | 2010-01-28T04:59:59Z | 2011-06-11T17:59:36Z | E9-30589 | 0 | 0 | 0900006480a720d0 | ||
| SEC-2009-1774-0001 | SEC | Facilitating Shareholder Director Nominations | Proposed Rule | 2009-12-18T05:00:00Z | 2009 | 12 | 2009-12-18T05:00:00Z | 2010-01-20T04:59:59Z | 2011-06-11T17:59:35Z | E9-30076 | 0 | 0 | 0900006480a6de04 | ||
| SEC-2009-1704-0001 | SEC | Proposed Rules for Nationally Recognized Statistical Rating Organizations | Proposed Rule | 2009-12-04T05:00:00Z | 2009 | 12 | 2009-12-04T05:00:00Z | 2010-02-03T04:59:59Z | 2011-06-11T17:59:35Z | E9-28497 | 0 | 0 | 0900006480a62afa | ||
| SEC-2009-1642-0001 | SEC | Regulation of Non-Public Trading Interest | Proposed Rule | 2009-11-23T05:00:00Z | 2009 | 11 | 2009-11-23T05:00:00Z | 2010-02-23T04:59:59Z | 2011-06-11T17:59:35Z | E9-27951 | 0 | 0 | 0900006480a5c85a | ||
| SEC-2009-1516-0001 | SEC | Concept Release on Possible Rescission of Rule 436(g) Under the Securities Act of 1933 | Proposed Rule | 2009-10-27T04:00:00Z | 2009 | 10 | 2009-10-27T04:00:00Z | 2011-06-11T17:59:34Z | E9-25811 | 0 | 0 | 0900006480a4c02b | |||
| SEC-2009-1515-0001 | SEC | Credit Ratings Disclosure | Proposed Rule | 2009-10-27T04:00:00Z | 2009 | 10 | 2009-10-27T04:00:00Z | 2011-06-11T17:59:34Z | E9-25813 | 0 | 0 | 0900006480a4c002 | |||
| SEC-2009-1503-0001 | SEC | Extensions of Filing Accommodations: Static Pool Information in Filings with Respect to Asset-Backed Securities | Proposed Rule | 2009-10-23T04:00:00Z | 2009 | 10 | 2009-10-23T04:00:00Z | 2009-11-24T04:59:59Z | 2011-06-11T17:59:33Z | E9-25496 | 0 | 0 | 0900006480a49ab7 | ||
| SEC-2009-1487-0001 | SEC | Amendments to Rules Requiring Internet Availability of Proxy Materials | Proposed Rule | 2009-10-21T04:00:00Z | 2009 | 10 | 2009-10-21T04:00:00Z | 2009-11-21T04:59:59Z | 2011-06-11T17:59:33Z | E9-25232 | 0 | 0 | 0900006480a4722f | ||
| SEC-2009-1470-0001 | SEC | Concept Release on Possible Rescission of Rule 436(g) Under The Securities Act of 1933 | Proposed Rule | 2009-10-15T04:00:00Z | 2009 | 10 | 2009-10-15T04:00:00Z | 2009-12-15T04:59:59Z | 2011-06-11T17:59:32Z | E9-24547 | 0 | 0 | 0900006480a421dc | ||
| SEC-2009-1472-0001 | SEC | Credit Ratings Disclosure | Proposed Rule | 2009-10-15T04:00:00Z | 2009 | 10 | 2009-10-15T04:00:00Z | 2009-12-15T04:59:59Z | 2011-06-11T17:59:32Z | E9-24546 | 0 | 0 | 0900006480a42280 | ||
| SEC-2009-1456-0001 | SEC | References to Ratings of Nationally Recognized Statistical Rating Organizations | Proposed Rule | 2009-10-09T04:00:00Z | 2009 | 10 | 2009-10-09T04:00:00Z | 2009-12-09T04:59:59Z | 2011-06-11T17:59:31Z | E9-24365 | 0 | 0 | 0900006480a3f292 | ||
| SEC-2009-1355-0001 | SEC | Elimination of Flash Order Exception From Rule 602 of Regulation NMS | Proposed Rule | 2009-09-23T04:00:00Z | 2009 | 9 | 2009-09-23T04:00:00Z | 2009-11-24T04:59:59Z | 2011-06-11T17:59:31Z | E9-22911 | 0 | 0 | 0900006480a29c09 | ||
| SEC-2009-1181-0001 | SEC | Amendments to Regulation SHO | Proposed Rule | 2009-08-20T04:00:00Z | 2009 | 8 | 2009-08-20T04:00:00Z | 2009-09-22T03:59:59Z | 2011-06-11T17:59:30Z | E9-19989 | 0 | 0 | 0900006480a0e0da | ||
| SEC-2009-1114-0001 | SEC | Political Contributions by Certain Investment Advisers | Proposed Rule | 2009-08-07T04:00:00Z | 2009 | 8 | 2009-08-07T04:00:00Z | 2009-10-07T03:59:59Z | 2011-06-11T17:59:29Z | E9-18807 | 0 | 0 | 0900006480a031b7 | ||
| SEC-2009-1023-0001 | SEC | Proposed Amendment to Municipal Securities Disclosure | Proposed Rule | 2009-07-24T04:00:00Z | 2009 | 7 | 2009-07-24T04:00:00Z | 2009-09-09T03:59:59Z | 2011-06-11T17:59:28Z | E9-17466 | 0 | 0 | 09000064809fa17d | ||
| SEC-2009-0990-0001 | SEC | Proxy Disclosure and Solicitation Enhancements | Proposed Rule | 2009-07-17T04:00:00Z | 2009 | 7 | 2009-07-17T04:00:00Z | 2009-09-16T03:59:59Z | 2011-06-11T17:59:28Z | E9-16764 | 0 | 0 | 09000064809f3e86 | ||
| SEC-2009-0908-0001 | SEC | Money Market Fund Reform | Proposed Rule | 2009-07-08T04:00:00Z | 2009 | 7 | 2009-07-08T04:00:00Z | 2009-09-09T03:59:59Z | 2011-06-11T17:59:27Z | E9-15906 | 0 | 0 | 09000064809ec1d3 | ||
| SEC-2009-0909-0001 | SEC | Shareholder Approval of Executive Compensation of TARP Recipients | Proposed Rule | 2009-07-08T04:00:00Z | 2009 | 7 | 2009-07-08T04:00:00Z | 2009-09-09T03:59:59Z | 2011-06-11T17:59:28Z | E9-16037 | 0 | 0 | 09000064809ec1d5 | ||
| SEC-2009-0831-0001 | SEC | Facilitating Shareholder Director Nominations | Proposed Rule | 2009-06-18T04:00:00Z | 2009 | 6 | 2009-06-18T04:00:00Z | 2009-08-18T03:59:59Z | 2011-06-11T17:59:27Z | E9-14090 | 0 | 0 | 09000064809d291e | ||
| SEC-2009-0702-0001 | SEC | Custody of Funds or Securities of Clients by Investment Advisers | Proposed Rule | 2009-05-27T04:00:00Z | 2009 | 5 | 2009-05-27T04:00:00Z | 2009-07-29T03:59:59Z | 2011-06-11T17:59:26Z | E9-12182 | 0 | 0 | 09000064809b8eb1 | ||
| SEC-2009-0550-0001 | SEC | Interagency Proposal for Model Privacy Form Under the Gramm-Leach-Bliley Act | Proposed Rule | 2009-04-20T04:00:00Z | 2009 | 4 | 2009-04-20T04:00:00Z | 2009-05-21T03:59:59Z | 2011-06-11T17:59:25Z | E9-08977 | 0 | 0 | 090000648095e58e | ||
| SEC-2009-0540-0001 | SEC | Amendments to Regulation SHO | Proposed Rule | 2009-04-20T04:00:00Z | 2009 | 4 | 2009-04-20T04:00:00Z | 2009-06-20T03:59:59Z | 2011-06-11T17:59:25Z | E9-08730 | 0 | 0 | 090000648095e4a9 | ||
| SEC-2009-0176-0001 | SEC | Roadmap for Potential Use of Financial Statements Prepared in Accordance with International Financial Reporting Standards by U.S. Issuers | Proposed Rule | 2009-02-09T05:00:00Z | 2009 | 2 | 2009-02-09T05:00:00Z | 2009-04-21T03:59:59Z | 2009-02-09T15:35:07Z | E9-02607 | 0 | 0 | 090000648084d858 | ||
| SEC-2009-0181-0001 | SEC | Re-proposed Rules for Nationally Recognized Statistical Rating Organizations | Proposed Rule | 2009-02-09T05:00:00Z | 2009 | 2 | 2009-02-09T05:00:00Z | 2009-03-27T03:59:59Z | 2009-02-09T15:37:28Z | E9-02514 | 0 | 0 | 090000648084d8a3 | ||
| SEC-2009-0101-0001 | SEC | List of Rules to be Reviewed Pursuant to the Regulatory Flexibility Act | Proposed Rule | 2009-01-26T05:00:00Z | 2009 | 1 | 2009-01-26T05:00:00Z | 2009-02-26T04:59:59Z | 2009-01-26T21:46:14Z | E9-01173 | 0 | 0 | 090000648083093a |
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;