home / openregs

documents

Regulatory documents from Regulations.gov including rules, proposed rules, notices, and supporting materials.

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

✎ View and edit SQL

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)

posted_year 1

  • 2011 · 20 ✖

document_type 1

  • Notice · 20 ✖

agency_id 1

  • FCA · 20 ✖
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

CSV options:

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;
Powered by Datasette · Queries took 1164.202ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API