documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
20 rows where agency_id = "FCA", document_type = "Notice" and posted_year = 2011 sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: title, posted_month, comment_end_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FCA-2011-0035-0001 | FCA | Market Access Agreement | Notice | 2011-12-15T05:00:00Z | 2011 | 12 | 2011-12-15T05:00:00Z | 2011-12-15T13:25:14Z | 2011-32136 | 0 | 0 | 0900006480f83b7b | |||
| FCA-2011-0034-0001 | FCA | Meetings; Sunshine Act | Notice | 2011-12-05T05:00:00Z | 2011 | 12 | 2011-12-05T05:00:00Z | 2011-12-05T14:29:58Z | 2011-31319 | 0 | 0 | 0900006480f7b5ec | |||
| FCA-2011-0032-0001 | FCA | Ethics, Independence, Arm's-Length Role, Ex Parte Communications and Open Government | Notice | 2011-11-17T05:00:00Z | 2011 | 11 | 2011-11-17T05:00:00Z | 2011-11-17T13:24:17Z | 2011-29687 | 0 | 0 | 0900006480f6e5f7 | |||
| FCA-2011-0031-0001 | FCA | Meetings; Sunshine Act | Notice | 2011-11-08T05:00:00Z | 2011 | 11 | 2011-11-08T05:00:00Z | 2011-11-08T13:39:22Z | 2011-29040 | 0 | 0 | 0900006480f68110 | |||
| FCA-2011-0030-0001 | FCA | Market Access Agreements; Request for Comments | Notice | 2011-11-01T04:00:00Z | 2011 | 11 | 2011-11-01T04:00:00Z | 2011-12-02T04:59:59Z | 2011-11-01T13:19:08Z | 2011-28250 | 0 | 0 | 0900006480f63da8 | ||
| FCA-2011-0029-0001 | FCA | Loans in Areas Having Special Flood Hazards: Interagency Questions and Answers Regarding Flood Insurance | Notice | 2011-10-17T04:00:00Z | 2011 | 10 | 2011-10-17T04:00:00Z | 2011-12-02T04:59:59Z | 2011-10-17T12:36:18Z | 2011-26749 | 0 | 0 | 0900006480f53f23 | ||
| FCA-2011-0028-0001 | FCA | Meetings; Sunshine Act | Notice | 2011-10-06T04:00:00Z | 2011 | 10 | 2011-10-06T04:00:00Z | 2011-10-06T12:59:20Z | 2011-26029 | 0 | 0 | 0900006480f4d3c8 | |||
| FCA-2011-0027-0001 | FCA | Meetings; Sunshine Act | Notice | 2011-09-07T04:00:00Z | 2011 | 9 | 2011-09-07T04:00:00Z | 2011-09-07T13:11:53Z | 2011-23037 | 0 | 0 | 0900006480f12f72 | |||
| FCA-2011-0023-0001 | FCA | Meetings; Sunshine Act | Notice | 2011-08-08T04:00:00Z | 2011 | 8 | 2011-08-08T04:00:00Z | 2011-08-08T12:58:26Z | 2011-20189 | 0 | 0 | 0900006480ed9ead | |||
| FCA-2011-0021-0001 | FCA | Meetings; Sunshine Act | Notice | 2011-07-11T04:00:00Z | 2011 | 7 | 2011-07-11T04:00:00Z | 2011-07-11T12:59:02Z | 2011-17466 | 0 | 0 | 0900006480ebef25 | |||
| FCA-2011-0015-0001 | FCA | Meetings; Sunshine Act | Notice | 2011-06-14T04:00:00Z | 2011 | 6 | 2011-06-14T04:00:00Z | 2011-06-14T13:33:04Z | 2011-14855 | 0 | 0 | 0900006480e4f036 | |||
| FCA-2011-0014-0001 | FCA | Meetings; Sunshine Act | Notice | 2011-06-06T04:00:00Z | 2011 | 6 | 2011-06-06T04:00:00Z | 2011-06-06T13:09:49Z | 2011-14030 | 0 | 0 | 0900006480e3d11e | |||
| FCA-2011-0009-0001 | FCA | Meetings; Sunshine Act | Notice | 2011-05-09T04:00:00Z | 2011 | 5 | 2011-05-09T04:00:00Z | 2011-05-09T14:37:05Z | 2011-11387 | 0 | 0 | 0900006480c42be8 | |||
| FCA-2011-0007-0001 | FCA | Meetings: Farm Credit System Insurance Corporation Board | Notice | 2011-04-13T04:00:00Z | 2011 | 4 | 2011-04-13T04:00:00Z | 2011-04-13T14:43:17Z | 2011-08784 | 0 | 0 | 0900006480c25f8e | |||
| FCA-2011-0006-0001 | FCA | Meetings; Sunshine Act | Notice | 2011-04-12T04:00:00Z | 2011 | 4 | 2011-04-12T04:00:00Z | 2011-04-12T13:00:24Z | 2011-08783 | 0 | 0 | 0900006480c22d8a | |||
| FCA-2011-0005-0001 | FCA | Meetings; Sunshine Act | Notice | 2011-03-07T05:00:00Z | 2011 | 3 | 2011-03-07T05:00:00Z | 2011-03-07T14:02:36Z | 2011-05233 | 0 | 0 | 0900006480c023bf | |||
| FCA-2011-0004-0001 | FCA | Privacy Act; Systems of Records | Notice | 2011-02-09T05:00:00Z | 2011 | 2 | 2011-02-09T05:00:00Z | 2011-03-16T03:59:59Z | 2011-02-09T13:06:50Z | 2011-02840 | 0 | 0 | 0900006480beaacc | ||
| FCA-2011-0003-0001 | FCA | Meetings; Sunshine Act | Notice | 2011-02-07T05:00:00Z | 2011 | 2 | 2011-02-07T05:00:00Z | 2011-02-07T13:41:07Z | 2011-02749 | 0 | 0 | 0900006480bdd1d6 | |||
| FCA-2011-0002-0001 | FCA | Registration of Mortgage Loan Originators | Notice | 2011-02-03T05:00:00Z | 2011 | 2 | 2011-02-03T05:00:00Z | 2011-02-03T13:53:49Z | 2011-02378 | 0 | 0 | 0900006480bda334 | |||
| FCA-2011-0001-0001 | FCA | Meetings; Sunshine Act | Notice | 2011-01-07T05:00:00Z | 2011 | 1 | 2011-01-07T05:00:00Z | 2011-01-07T14:07:49Z | 2011-00252 | 0 | 0 | 0900006480bc6d6d |
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;