documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
33 rows where agency_id = "SEC", document_type = "Rule" and posted_year = 2012 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-2012-2174-0001 | SEC | Principal Trades With Certain Advisory Clients | Rule | 2012-12-31T05:00:00Z | 2012 | 12 | 2012-12-31T05:00:00Z | 2012-12-31T14:45:00Z | 2012-31221 | 0 | 0 | 09000064811a0501 | |||
| SEC-2012-2085-0001 | SEC | Extension of Dates for Certain Requirements and Amendment of Form 19b-4: Correction | Rule | 2012-12-18T05:00:00Z | 2012 | 12 | 2012-12-18T05:00:00Z | 2012-12-18T13:38:49Z | 2012-30389 | 0 | 0 | 0900006481190954 | |||
| SEC-2012-2024-0001 | SEC | Certain Requirements and Amendment of Form 19b-4; Extension of Dates | Rule | 2012-12-10T05:00:00Z | 2012 | 12 | 2012-12-10T05:00:00Z | 2012-12-10T14:07:41Z | 2012-29712 | 0 | 0 | 09000064811846c4 | |||
| SEC-2012-1927-0001 | SEC | Purchase of Certain Debt Securities: Business and Industrial Development Companies Relying on an Investment Company Act Exemption | Rule | 2012-11-23T05:00:00Z | 2012 | 11 | 2012-11-23T05:00:00Z | 2012-11-23T14:45:04Z | 2012-28456 | 0 | 0 | 0900006481171933 | |||
| SEC-2012-1924-0001 | SEC | Disclosure of Payments by Resource Extraction Issuers; Correction | Rule | 2012-11-23T05:00:00Z | 2012 | 11 | 2012-11-23T05:00:00Z | 2012-11-23T14:42:57Z | 2012-28455 | 0 | 0 | 090000648117185f | |||
| SEC-2012-1772-0001 | SEC | Clearing Agency Standards | Rule | 2012-11-02T04:00:00Z | 2012 | 11 | 2012-11-02T04:00:00Z | 2012-11-02T15:33:30Z | 2012-26407 | 0 | 0 | 090000648115a5b3 | |||
| SEC-2012-1678-0001 | SEC | Adoption of Updated EDGAR Filer Manual | Rule | 2012-10-15T04:00:00Z | 2012 | 10 | 2012-10-15T04:00:00Z | 2012-10-15T12:46:21Z | 2012-24998 | 0 | 0 | 0900006481140b54 | |||
| SEC-2012-1583-0001 | SEC | Extension of Temporary Registration of Municipal Advisors | Rule | 2012-09-26T04:00:00Z | 2012 | 9 | 2012-09-26T04:00:00Z | 2012-09-26T12:46:02Z | 2012-23688 | 0 | 0 | 0900006481128aa7 | |||
| SEC-2012-1496-0001 | SEC | Disclosure of Payments by Resource Extraction Issuers | Rule | 2012-09-12T04:00:00Z | 2012 | 9 | 2012-09-12T04:00:00Z | 2012-09-12T14:11:41Z | 2012-21155 | 0 | 0 | 0900006481112ee3 | |||
| SEC-2012-1495-0001 | SEC | Conflict Minerals | Rule | 2012-09-12T04:00:00Z | 2012 | 9 | 2012-09-12T04:00:00Z | 2012-09-12T14:11:12Z | 2012-21153 | 0 | 0 | 0900006481113323 | |||
| SEC-2012-1465-0001 | SEC | Adoption of Updated EDGAR Filer Manual | Rule | 2012-09-06T04:00:00Z | 2012 | 9 | 2012-09-06T04:00:00Z | 2012-09-06T12:59:02Z | 2012-21805 | 0 | 0 | 0900006481109197 | |||
| SEC-2012-1364-0001 | SEC | Retail Foreign Exchange Transactions | Rule | 2012-08-20T04:00:00Z | 2012 | 8 | 2012-08-20T04:00:00Z | 2012-11-01T03:59:59Z | 2012-08-20T13:36:26Z | 2012-20089 | 0 | 0 | 09000064810e491f | ||
| SEC-2012-1328-0001 | SEC | Definitions; Mixed Swaps; Security-Based Swap Agreement Recordkeeping | Rule | 2012-08-13T04:00:00Z | 2012 | 8 | 2012-08-13T04:00:00Z | 2012-08-13T13:21:50Z | 2012-18003 | 0 | 0 | 09000064810d11e7 | |||
| SEC-2012-1244-0001 | SEC | Consolidated Audit Trail | Rule | 2012-08-01T04:00:00Z | 2012 | 8 | 2012-08-01T04:00:00Z | 2012-08-01T12:48:45Z | 2012-17918 | 0 | 0 | 09000064810bc535 | |||
| SEC-2012-1200-0001 | SEC | Process for Submissions for Review of Security-Based Swaps for Mandatory Clearing and Notice Filing Requirements for Clearing Agencies: Technical Amendments to Rule 19b-4 and Form 19b-4 Applicable to All Self-Regulatory Organizations; Correction | Rule | 2012-07-25T04:00:00Z | 2012 | 7 | 2012-07-25T04:00:00Z | 2012-07-25T12:37:18Z | 2012-17985 | 0 | 0 | 09000064810aeea9 | |||
| SEC-2012-1192-0001 | SEC | Commission Guidances: Definitions of Mortgage Related Security and Small Business Related Security | Rule | 2012-07-23T04:00:00Z | 2012 | 7 | 2012-07-23T04:00:00Z | 2012-08-23T03:59:59Z | 2012-07-23T13:32:21Z | 2012-17763 | 0 | 0 | 09000064810a9a91 | ||
| SEC-2012-1171-0001 | SEC | Temporary Registration of Municipal Advisors: Technical Amendment | Rule | 2012-07-18T04:00:00Z | 2012 | 7 | 2012-07-18T04:00:00Z | 2012-07-18T12:48:28Z | 2012-17411 | 0 | 0 | 090000648109fa13 | |||
| SEC-2012-1173-0001 | SEC | Securities Act Industry Guides; Technical Amendments | Rule | 2012-07-18T04:00:00Z | 2012 | 7 | 2012-07-18T04:00:00Z | 2012-07-18T12:48:55Z | 2012-17449 | 0 | 0 | 090000648109faa2 | |||
| SEC-2012-1142-0001 | SEC | Extension of Interim Final Temporary Rule on Retail Foreign Exchange Transactions | Rule | 2012-07-16T04:00:00Z | 2012 | 7 | 2012-07-16T04:00:00Z | 2012-07-16T13:51:54Z | 2012-17261 | 0 | 0 | 090000648109bcf5 | |||
| SEC-2012-1126-0001 | SEC | Process for Submissions for Review of Security-Based Swaps for Mandatory Clearing and Notice Filing Requirements for Clearing Agencies: Technical Amendments to Rule 19b-4 and Form 19b-4 Applicable to All Self-Regulatory Organizations | Rule | 2012-07-13T04:00:00Z | 2012 | 7 | 2012-07-13T04:00:00Z | 2012-07-13T12:23:32Z | 2012-16233 | 0 | 0 | 0900006481093316 | |||
| SEC-2012-1065-0001 | SEC | Definitions; Corrections: Swap Dealer, Security-Based Swap Dealer, Major Swap Participant, Major Security-Based Swap Participant and Eligible Contract Participant | Rule | 2012-07-05T04:00:00Z | 2012 | 7 | 2012-07-05T04:00:00Z | 2012-07-05T12:55:39Z | 2012-16409 | 0 | 0 | 090000648107a46f | |||
| SEC-2012-1048-0001 | SEC | Listing Standards for Compensation Committees | Rule | 2012-07-03T04:00:00Z | 2012 | 7 | 2012-07-03T04:00:00Z | 2012-07-03T13:06:42Z | C1-2012-15408 | 0 | 0 | 0900006481078097 | |||
| SEC-2012-1006-0001 | SEC | Listing Standards for Compensation Committees | Rule | 2012-06-27T04:00:00Z | 2012 | 6 | 2012-06-27T04:00:00Z | 2012-06-27T13:14:21Z | 2012-15408 | 0 | 0 | 090000648106a7b2 | |||
| SEC-2012-0941-0001 | SEC | Political Contributions by Certain Investment Advisers: Ban on Third-Party Solicitation; Extension of Compliance Date | Rule | 2012-06-13T04:00:00Z | 2012 | 6 | 2012-06-13T04:00:00Z | 2012-06-13T13:28:59Z | 2012-14440 | 0 | 0 | 090000648104720a | |||
| SEC-2012-0811-0001 | SEC | Definitions: Swap Dealer, Security-Based Swap Dealer, Major Swap Participant, Major Security-Based Swap Participant and Eligible Contract Participant | Rule | 2012-05-23T04:00:00Z | 2012 | 5 | 2012-05-23T04:00:00Z | 2012-07-24T03:59:59Z | 2012-05-23T12:35:59Z | 2012-10562 | 0 | 0 | 0900006481019e05 | ||
| SEC-2012-0753-0001 | SEC | Political Contributions by Certain Investment Advisers | Rule | 2012-05-15T04:00:00Z | 2012 | 5 | 2012-05-15T04:00:00Z | 2012-05-15T13:30:28Z | 2012-11662 | 0 | 0 | 090000648100ee09 | |||
| SEC-2012-0534-0001 | SEC | Exemptions For Security-Based Swaps Issued By Certain Clearing Agencies | Rule | 2012-04-05T04:00:00Z | 2012 | 4 | 2012-04-05T04:00:00Z | 2012-04-05T12:55:57Z | 2012-08141 | 0 | 0 | 0900006480fe9d15 | |||
| SEC-2012-0506-0001 | SEC | Adoption of Updated EDGAR Filer Manual | Rule | 2012-03-30T04:00:00Z | 2012 | 3 | 2012-03-30T04:00:00Z | 2012-03-30T13:40:16Z | 2012-07608 | 0 | 0 | 0900006480fe4dc0 | |||
| SEC-2012-0491-0001 | SEC | Net Worth Standard for Accredited Investors | Rule | 2012-03-28T04:00:00Z | 2012 | 3 | 2012-03-28T04:00:00Z | 2012-03-28T13:01:31Z | 2012-07446 | 0 | 0 | 0900006480fe2eac | |||
| SEC-2012-0372-0001 | SEC | Rules of Organization, Conduct and Ethics, and Information and Requests | Rule | 2012-03-07T05:00:00Z | 2012 | 3 | 2012-03-07T05:00:00Z | 2012-03-07T13:52:51Z | 2012-05454 | 0 | 0 | 0900006480fd08de | |||
| SEC-2012-0303-0001 | SEC | Investment Adviser Performance Compensation | Rule | 2012-02-22T05:00:00Z | 2012 | 2 | 2012-02-22T05:00:00Z | 2012-02-22T14:05:13Z | 2012-04046 | 0 | 0 | 0900006480fbd654 | |||
| SEC-2012-0263-0001 | SEC | Reporting Line for the Commission's Inspector General | Rule | 2012-02-14T05:00:00Z | 2012 | 2 | 2012-02-14T05:00:00Z | 2012-02-14T13:58:53Z | 2012-03312 | 0 | 0 | 0900006480fb565a | |||
| SEC-2012-0118-0001 | SEC | Covered Securities of BATS Exchange, Inc. | Rule | 2012-01-25T05:00:00Z | 2012 | 1 | 2012-01-25T05:00:00Z | 2012-01-25T13:27:56Z | 2012-01521 | 0 | 0 | 0900006480fa3bdc |
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;