documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
14 rows where agency_id = "PBGC", document_type = "Rule" and posted_year = 2013 sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: title, posted_month, posted_date (date), comment_start_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PBGC_FRDOC_0001-0237 | PBGC | Recently Posted PBGC Rules and Notices. PBGC_FRDOC_0001 | Allocation of Assets in Single-Employer Plans; Benefits Payable in Terminated Single-Employer Plans; Interest Assumptions for Valuing and Paying Benefits | Rule | 2013-12-13T05:00:00Z | 2013 | 12 | 2013-12-13T05:00:00Z | 2013-12-13T14:24:15Z | 2013-29755 | 0 | 0 | 09000064814bcf3c | ||
| PBGC_FRDOC_0001-0236 | PBGC | Recently Posted PBGC Rules and Notices. PBGC_FRDOC_0001 | Allocation of Assets in Single-Employer Plans: Valuation of Benefits and Assets; Expected Retirement Age | Rule | 2013-12-02T05:00:00Z | 2013 | 12 | 2013-12-02T05:00:00Z | 2013-12-02T14:04:59Z | 2013-28682 | 0 | 0 | 09000064814a2011 | ||
| PBGC_FRDOC_0001-0233 | PBGC | Recently Posted PBGC Rules and Notices. PBGC_FRDOC_0001 | Benefits Payable in Terminated Single-Employer Plans: Interest Assumptions for Paying Benefits | Rule | 2013-11-15T05:00:00Z | 2013 | 11 | 2013-11-15T05:00:00Z | 2013-11-15T14:32:58Z | 2013-27385 | 0 | 0 | 0900006481481e8e | ||
| PBGC_FRDOC_0001-0231 | PBGC | Recently Posted PBGC Rules and Notices. PBGC_FRDOC_0001 | Terminated Single-Employer Plans: Interest Assumptions for Paying Benefits | Rule | 2013-10-22T04:00:00Z | 2013 | 10 | 2013-10-22T04:00:00Z | 2013-10-22T13:23:12Z | 2013-24592 | 0 | 0 | 0900006481458675 | ||
| PBGC_FRDOC_0001-0230 | PBGC | Recently Posted PBGC Rules and Notices. PBGC_FRDOC_0001 | Terminated Single-Employer Plans: Interest Assumptions for Valuing and Paying Benefits | Rule | 2013-09-13T04:00:00Z | 2013 | 9 | 2013-09-13T04:00:00Z | 2013-09-13T13:57:13Z | 2013-22355 | 0 | 0 | 09000064814118f3 | ||
| PBGC_FRDOC_0001-0227 | PBGC | Recently Posted PBGC Rules and Notices. PBGC_FRDOC_0001 | Benefits Payable in Terminated Single-Employer Plans: Interest Assumptions for Paying Benefits | Rule | 2013-08-15T04:00:00Z | 2013 | 8 | 2013-08-15T04:00:00Z | 2013-08-15T12:45:16Z | 2013-19842 | 0 | 0 | 09000064813b38fc | ||
| PBGC_FRDOC_0001-0223 | PBGC | Recently Posted PBGC Rules and Notices. PBGC_FRDOC_0001 | Benefits Payable in Terminated Single-Employer Plans; Interest Assumptions for Paying Benefits | Rule | 2013-07-15T04:00:00Z | 2013 | 7 | 2013-07-15T04:00:00Z | 2013-07-15T13:21:08Z | 2013-16853 | 0 | 0 | 0900006481366796 | ||
| PBGC_FRDOC_0001-0220 | PBGC | Recently Posted PBGC Rules and Notices. PBGC_FRDOC_0001 | Benefits Payable in Terminated Single-Employer Plans and Allocation of Assets in Single-Employer Plans: Interest Assumptions for Valuing and Paying Benefits | Rule | 2013-06-14T04:00:00Z | 2013 | 6 | 2013-06-14T04:00:00Z | 2013-06-14T13:09:25Z | 2013-14194 | 0 | 0 | 090000648131fe83 | ||
| PBGC_FRDOC_0001-0219 | PBGC | Recently Posted PBGC Rules and Notices. PBGC_FRDOC_0001 | Benefits Payable in Terminated Single-Employer Plans; Interest Assumptions for Paying Benefits | Rule | 2013-05-15T04:00:00Z | 2013 | 5 | 2013-05-15T04:00:00Z | 2013-05-15T13:15:44Z | 2013-11557 | 0 | 0 | 09000064812e54fa | ||
| PBGC_FRDOC_0001-0217 | PBGC | Recently Posted PBGC Rules and Notices. PBGC_FRDOC_0001 | Interest Assumptions for Paying Benefits: Terminated Single-Employer Plans | Rule | 2013-04-15T04:00:00Z | 2013 | 4 | 2013-04-15T04:00:00Z | 2013-04-15T13:42:13Z | 2013-08743 | 0 | 0 | 0900006481293f34 | ||
| PBGC_FRDOC_0001-0214 | PBGC | Recently Posted PBGC Rules and Notices. PBGC_FRDOC_0001 | Allocation of Assets in Single-Employer Plans and Benefits Payable in Terminated Single-Employer Plans: Interest Assumptions for Valuing and Paying Benefits | Rule | 2013-03-15T04:00:00Z | 2013 | 3 | 2013-03-15T04:00:00Z | 2013-03-15T13:02:23Z | 2013-06085 | 0 | 0 | 090000648122cddb | ||
| PBGC_FRDOC_0001-0212 | PBGC | Recently Posted PBGC Rules and Notices. PBGC_FRDOC_0001 | Benefits Payable in Terminated Single-Employer Plans; Interest Assumptions for Paying Benefits | Rule | 2013-02-15T05:00:00Z | 2013 | 2 | 2013-02-15T05:00:00Z | 2013-02-15T13:54:09Z | 2013-03544 | 0 | 0 | 09000064811fa1e3 | ||
| PBGC_FRDOC_0001-0211 | PBGC | Recently Posted PBGC Rules and Notices. PBGC_FRDOC_0001 | Benefits Payable in Terminated Single-Employer Plans; Interest Assumptions for Paying Benefits | Rule | 2013-02-07T05:00:00Z | 2013 | 2 | 2013-02-07T05:00:00Z | 2013-02-07T14:05:54Z | 2013-02689 | 0 | 0 | 09000064811ea2cc | ||
| PBGC_FRDOC_0001-0210 | PBGC | Recently Posted PBGC Rules and Notices. PBGC_FRDOC_0001 | Benefits Payable in Terminated Single-Employer Plans; Interest Assumptions for Paying Benefits | Rule | 2013-01-15T00:00:00Z | 2013 | 1 | 2013-01-15T00:00:00Z | 2013-01-15T14:29:08Z | 2013-00632 | 0 | 0 | 09000064811bd4d5 |
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;