documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
8 rows where agency_id = "FCA", document_type = "Rule" and posted_year = 2006 sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: posted_month, last_modified, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FCA-2006-0035-0001 | FCA | Federal Agricultural Mortgage Corporation Funding and Fiscal Affairs; Federal Agricultural Mortgage Corporation Disclosure and Reporting Requirements; Risk-Based Capital Requirements | Rule | 2006-12-26T05:00:00Z | 2006 | 12 | 2006-12-26T05:00:00Z | 2011-06-11T17:20:43Z | E6-21831 | 0 | 0 | 09000064801efdc1 | |||
| FCA-2006-0034-0001 | FCA | Organization; Definitions; Disclosure to Shareholders; Accounting and Reporting Requirements; Regulatory Accounting Practices; Title IV Conservators, Receivers, and Voluntary Liquidations; and Disclosure to Investors in System-Wide and Consolidated Bank Debt Obligations of the Farm Credit System | Rule | 2006-12-20T05:00:00Z | 2006 | 12 | 2006-12-20T05:00:00Z | 2011-06-11T17:20:43Z | E6-21529 | 0 | 0 | 09000064801ee406 | |||
| FCA-2006-0030-0001 | FCA | Organization; Standards of Conduct and Referral of Known or Suspected Criminal Violations; Eligibility and Scope of Financing; Loan Policies and Operations; Funding and Fiscal Affairs, Loan Policies and Operations, and Funding Operations; Regulatory Burden | Rule | 2006-11-08T05:00:00Z | 2006 | 11 | 2006-11-08T05:00:00Z | 2011-06-11T17:20:43Z | E6-18841 | 0 | 0 | 09000064801deed9 | |||
| FCA-2006-0023-0001 | FCA | Organization; Termination of System Institution Status | Rule | 2006-08-04T04:00:00Z | 2006 | 8 | 2006-08-04T04:00:00Z | 2011-06-11T17:20:42Z | 06-06648 | 0 | 0 | 09000064801aed38 | |||
| FCA-2006-0015-0001 | FCA | Organization; Standards of Conduct and Referral of Known or Suspected Criminal Violations; Loan Policies and Operations; Funding and Fiscal Affairs, Loan Policies and Operations, and Funding Operations; Disclosure to Shareholders; Preferred Stock; Effective Date | Rule | 2006-05-03T04:00:00Z | 2006 | 5 | 2006-05-03T04:00:00Z | 2011-06-11T17:20:41Z | 06-04175 | 0 | 0 | 090000648016ab98 | |||
| FCA-2006-0004-0002 | FCA | Organization; Standards of Conduct and Referral of Known or Suspected Criminal Violations; Loan Policies and Operations; Funding and Fiscal Affairs, Loan Policies and Operations, and Funding Operations; General Provisions; Definitions; Disclosure to Shareholders; Disclosure to Investors in System-Wide and Consolidated Bank Debt Obligations of the Farm Credit System; Effective Date | Rule | 2006-04-11T04:00:00Z | 2006 | 4 | 2006-04-11T04:00:00Z | 2011-06-11T17:20:39Z | 06-03448 | 0 | 0 | 090000648015a812 | |||
| FCA-2005-0010-0002 | FCA | Organization and Functions; Releasing Information; Privacy Act Regulations; Farm Credit Administration Board Meetings; and Enforcement of Nondiscrimination on the Basis of Handicap in Programs or Activities Conducted by the Farm Credit Administration; Effective Date | Rule | 2006-02-22T05:00:00Z | 2006 | 2 | 2006-02-22T05:00:00Z | 2011-06-11T17:20:38Z | 06-01637 | 0 | 0 | 0900006480136347 | |||
| FCA-2006-0004-0001 | FCA | Organization; Standards of Conduct and Referral of Known or Suspected Criminal Violations; Loan Policies and Operations; Funding and Fiscal Affairs, Loan Policies and Operations, and Funding Operations; General Provisions; Definitions; Disclosure to Shareholders; Disclosure to Investors in System-Wide and Consolidated Bank Debt Obligations of the Farm Credit System | Rule | 2006-02-02T05:00:00Z | 2006 | 2 | 2006-02-02T05:00:00Z | 2011-06-11T17:20:40Z | 06-00829 | 0 | 0 | 0900006480125229 |
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;