documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
16 rows where agency_id = "USDA", document_type = "Rule" and posted_year = 2011 sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: docket_id, title, posted_date, posted_month, comment_start_date, comment_end_date, last_modified, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| USDA_FRDOC_0001-0840 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Highly Erodible Land and Wetland Conservation | Rule | 2011-12-30T05:00:00Z | 2011 | 12 | 2011-12-30T05:00:00Z | 2011-12-30T13:00:57Z | 2011-33547 | 0 | 0 | 0900006480f8b7c7 | ||
| USDA_FRDOC_0001-0822 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Implementation of OMB Guidance on Drug Free Workplace Requirements | Rule | 2011-12-08T05:00:00Z | 2011 | 12 | 2011-12-08T05:00:00Z | 2012-01-10T04:59:59Z | 2011-12-08T13:17:45Z | 2011-31467 | 0 | 0 | 0900006480f7e054 | |
| USDA-2012-0002-0002 | USDA | Agriculture Acquisition; Labor Law Violations USDA-2012-0002 | Agriculture Acquisition; Labor Law Violations | Rule | 2011-12-01T05:00:00Z | 2011 | 12 | 2011-12-01T05:00:00Z | 2012-01-31T04:59:59Z | 2012-01-25T21:38:18Z | 2011-30874 | 0 | 0 | 0900006480f7936a | |
| USDA_FRDOC_0001-0805 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Agricultural Career and Employment Grants Program; Correction | Rule | 2011-11-15T05:00:00Z | 2011 | 11 | 2011-11-15T05:00:00Z | 2011-12-09T04:59:59Z | 2011-11-15T13:15:04Z | 2011-29389 | 0 | 0 | 0900006480f6c755 | |
| USDA_FRDOC_0001-0801 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Agricultural Career and Employment Grants Program | Rule | 2011-11-08T05:00:00Z | 2011 | 11 | 2011-11-08T05:00:00Z | 2011-12-09T04:59:59Z | 2011-11-08T13:41:45Z | 2011-29029 | 0 | 0 | 0900006480f681f0 | |
| USDA_FRDOC_0001-0793 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Revision of Delegations of Authority | Rule | 2011-10-27T04:00:00Z | 2011 | 10 | 2011-10-27T04:00:00Z | 2011-10-27T12:38:42Z | 2011-27760 | 0 | 0 | 0900006480f5ddc2 | ||
| USDA_FRDOC_0001-0795 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Revision of Delegations of Authority | Rule | 2011-10-27T04:00:00Z | 2011 | 10 | 2011-10-27T04:00:00Z | 2011-10-27T12:39:23Z | 2011-27759 | 0 | 0 | 0900006480f5ddfe | ||
| USDA_FRDOC_0001-0791 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Office of Advocacy and Outreach Federal Financial Assistance Programs | Rule | 2011-10-26T04:00:00Z | 2011 | 10 | 2011-10-26T04:00:00Z | 2011-12-28T04:59:59Z | 2011-10-26T13:13:26Z | 2011-27108 | 0 | 0 | 0900006480f5cb36 | |
| USDA_FRDOC_0001-0784 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Adjustment of Appendices to the Dairy Tariff-Rate Import Quota Licensing Regulation for the 2011 Tariff-Rate Quota Year | Rule | 2011-10-13T04:00:00Z | 2011 | 10 | 2011-10-13T04:00:00Z | 2011-10-13T12:58:15Z | 2011-26480 | 0 | 0 | 0900006480f51bc4 | ||
| USDA_FRDOC_0001-0765 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Revision of Delegations of Authority | Rule | 2011-08-24T04:00:00Z | 2011 | 8 | 2011-08-24T04:00:00Z | 2011-08-24T11:50:59Z | 2011-21597 | 0 | 0 | 0900006480eeb2ef | ||
| USDA_FRDOC_0001-0688 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Procedures Relating to Awards Under the Equal Access to Justice Act | Rule | 2011-03-03T05:00:00Z | 2011 | 3 | 2011-03-03T05:00:00Z | 2011-06-11T18:06:36Z | 2011-04423 | 0 | 0 | 0900006480bfe05e | ||
| USDA_FRDOC_0001-0687 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Delegations Of Authority: Establishment of Office of Chief Scientist; Revision | Rule | 2011-02-28T05:00:00Z | 2011 | 2 | 2011-02-28T05:00:00Z | 2011-02-28T13:55:52Z | 2011-04128 | 0 | 0 | 0900006480bfa639 | ||
| USDA_FRDOC_0001-0686 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Delegation of Authority to Under Secretary for Research, Education, and Economics | Rule | 2011-02-22T05:00:00Z | 2011 | 2 | 2011-02-22T05:00:00Z | 2011-02-22T14:03:07Z | 2011-01819 | 0 | 0 | 0900006480bf4f87 | ||
| USDA_FRDOC_0001-0674 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Designation of Biobased Items for Federal Procurement | Rule | 2011-02-04T05:00:00Z | 2011 | 2 | 2011-02-04T05:00:00Z | 2011-04-06T03:59:59Z | 2011-06-11T18:06:38Z | 2011-02017 | 0 | 0 | 0900006480bdba39 | |
| USDA_FRDOC_0001-0668 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Establishment of New Agency; Revision of Delegations of Authority | Rule | 2011-01-27T05:00:00Z | 2011 | 1 | 2011-01-27T05:00:00Z | 2011-06-11T18:06:38Z | 2011-01701 | 0 | 0 | 0900006480bd4596 | ||
| USDA_FRDOC_0001-0663 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Voluntary Labeling Program for Biobased Products | Rule | 2011-01-20T05:00:00Z | 2011 | 1 | 2011-01-20T05:00:00Z | 2011-06-11T18:06:36Z | 2011-00968 | 0 | 0 | 0900006480bce92d |
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);