documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
13 rows where agency_id = "USDA", docket_id = "USDA_FRDOC_0001" and posted_year = 2006 sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: title, posted_date, comment_start_date, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| USDA_FRDOC_0001-0014 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Agency information collection activities; proposals, submissions, and approvals | Notice | 2006-12-28T05:00:00Z | 2006 | 12 | 2006-12-28T05:00:00Z | 2006-12-28T12:09:12Z | E6-22202 | 0 | 0 | 09000064801f0690 | ||
| USDA_FRDOC_0001-0013 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Agency information collection activities; proposals, submissions, and approvals | Notice | 2006-12-27T05:00:00Z | 2006 | 12 | 2006-12-27T05:00:00Z | 2006-12-27T12:07:14Z | E6-22095 | 0 | 0 | 09000064801f01f6 | ||
| USDA_FRDOC_0001-0012 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Agency information collection activities; proposals, submissions, and approvals | Notice | 2006-12-22T05:00:00Z | 2006 | 12 | 2006-12-22T05:00:00Z | 2006-12-22T12:09:27Z | E6-21965 | 0 | 0 | 09000064801ef394 | ||
| USDA_FRDOC_0001-0011 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Agency information collection activities; proposals, submissions, and approvals | Notice | 2006-12-22T05:00:00Z | 2006 | 12 | 2006-12-22T05:00:00Z | 2006-12-22T12:05:56Z | E6-21968 | 0 | 0 | 09000064801ef288 | ||
| USDA_FRDOC_0001-0010 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Agency information collection activities; proposals, submissions, and approvals | Notice | 2006-12-21T05:00:00Z | 2006 | 12 | 2006-12-21T05:00:00Z | 2006-12-21T12:04:54Z | E6-21833 | 0 | 0 | 09000064801eec62 | ||
| USDA_FRDOC_0001-0008 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Agency information collection activities; proposals, submissions, and approvals | Notice | 2006-12-20T05:00:00Z | 2006 | 12 | 2006-12-20T05:00:00Z | 2006-12-20T12:05:59Z | E6-21677 | 0 | 0 | 09000064801ee3dd | ||
| USDA_FRDOC_0001-0009 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Agency information collection activities; proposals, submissions, and approvals | Notice | 2006-12-20T05:00:00Z | 2006 | 12 | 2006-12-20T05:00:00Z | 2006-12-20T12:06:36Z | E6-21678 | 0 | 0 | 09000064801ee411 | ||
| USDA_FRDOC_0001-0007 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Agency information collection activities; proposals, submissions, and approvals | Notice | 2006-12-18T05:00:00Z | 2006 | 12 | 2006-12-18T05:00:00Z | 2006-12-18T12:04:34Z | E6-21451 | 0 | 0 | 09000064801ed511 | ||
| USDA_FRDOC_0001-0005 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Agency information collection activities; proposals, submissions, and approvals | Notice | 2006-12-15T05:00:00Z | 2006 | 12 | 2006-12-15T05:00:00Z | 2006-12-15T12:08:30Z | E6-21341 | 0 | 0 | 09000064801ec767 | ||
| USDA_FRDOC_0001-0006 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Agency information collection activities; proposals, submissions, and approvals | Notice | 2006-12-15T05:00:00Z | 2006 | 12 | 2006-12-15T05:00:00Z | 2006-12-15T12:08:48Z | E6-21343 | 0 | 0 | 09000064801ec781 | ||
| USDA_FRDOC_0001-0003 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Agency information collection activities; proposals, submissions, and approvals | Notice | 2006-12-11T05:00:00Z | 2006 | 12 | 2006-12-11T05:00:00Z | 2006-12-11T12:07:40Z | E6-20968 | 0 | 0 | 09000064801eab14 | ||
| USDA_FRDOC_0001-0004 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Agency information collection activities; proposals, submissions, and approvals | Notice | 2006-12-11T05:00:00Z | 2006 | 12 | 2006-12-11T05:00:00Z | 2006-12-11T12:11:46Z | E6-20947 | 0 | 0 | 09000064801eac7e | ||
| USDA_FRDOC_0001-0002 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Semi-annual agenda | Proposed Rule | 2006-12-11T05:00:00Z | 2006 | 12 | 2006-12-11T05:00:00Z | 2007-06-11T15:46:51Z | 06-07543 | 0 | 0 | 09000064801eaaee |
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);