documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
56 rows where agency_id = "USDA" and document_type = "Proposed Rule" sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: posted_date (date), comment_start_date (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-3255 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Agricultural Foreign Investment Disclosure Act: Revisions to Reporting Requirements; Correction | Proposed Rule | 2026-01-14T05:00:00Z | 2026 | 1 | 2026-01-14T05:00:00Z | 2026-01-14T17:20:17Z | 2026-00536 | 0 | 0 | 09000064b91393be | ||
| USDA-2026-0001-0001 | USDA | Agricultural Foreign Investment Disclosure Act: Revisions to Reporting Requirements USDA-2026-0001 | Agricultural Foreign Investment Disclosure Act: Revisions to Reporting Requirements | Proposed Rule | 2025-12-29T05:00:00Z | 2025 | 12 | 2025-12-29T05:00:00Z | 2026-01-29T04:59:59Z | 2026-02-20T20:29:57Z | 2025-23830 | 1 | 0 | 09000064b910a2c4 | |
| USDA-2024-0005-0001 | USDA | Agriculture Acquisition Regulation (AGAR) USDA-2024-0005 | Acquisition Regulation | Proposed Rule | 2024-07-26T04:00:00Z | 2024 | 7 | 2024-07-26T04:00:00Z | 2024-08-27T03:59:59Z | 2024-08-28T01:00:54Z | 2024-15329 | 0 | 0 | 0900006486606db9 | |
| USDA-2024-0002-0002 | USDA | USDA Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards USDA-2024-0002 | USDA Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards | Proposed Rule | 2024-07-03T04:00:00Z | 2024 | 7 | 2024-07-03T04:00:00Z | 2024-07-24T15:16:09Z | C1-2024-13 | 0 | 0 | 09000064865d8b33 | ||
| USDA-2024-0002-0001 | USDA | USDA Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards USDA-2024-0002 | USDA Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards | Proposed Rule | 2024-07-01T04:00:00Z | 2024 | 7 | 2024-07-01T04:00:00Z | 2024-08-01T03:59:59Z | 2024-07-29T01:00:51Z | 2024-13845 | 0 | 0 | 09000064865d4f7e | |
| USDA_FRDOC_0001-2969 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Semiannual Regulatory Agenda, Fall 2023 | Proposed Rule | 2024-02-09T05:00:00Z | 2024 | 2 | 2024-02-09T05:00:00Z | 2024-02-09T14:50:32Z | 2024-00517 | 0 | 0 | 09000064863f7e5b | ||
| USDA_FRDOC_0001-2864 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Semiannual Regulatory Agenda, Spring 2023 | Proposed Rule | 2023-07-27T04:00:00Z | 2023 | 7 | 2023-07-27T04:00:00Z | 2023-07-27T13:08:59Z | 2023-14539 | 0 | 0 | 0900006485d5e102 | ||
| USDA_FRDOC_0001-2784 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Semiannual Regulatory Agenda, Fall 2022 | Proposed Rule | 2023-02-22T05:00:00Z | 2023 | 2 | 2023-02-22T05:00:00Z | 2023-02-22T21:42:26Z | 2023-02023 | 0 | 0 | 09000064856ed8cf | ||
| USDA-2023-0003-0001 | USDA | Partnerships With Faith-Based and Neighborhood Organizations USDA-2023-0003 | Partnerships With Faith-Based and Neighborhood Organizations | Proposed Rule | 2023-01-13T05:00:00Z | 2023 | 1 | 2023-01-13T05:00:00Z | 2023-03-15T03:59:59Z | 2023-03-16T01:00:44Z | 2022-28376 | 0 | 0 | 09000064855eba43 | |
| USDA_FRDOC_0001-2673 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Privacy Act Regulations | Proposed Rule | 2022-07-11T04:00:00Z | 2022 | 7 | 2022-07-11T04:00:00Z | 2022-08-11T03:59:59Z | 2022-07-11T12:28:36Z | 2022-14707 | 0 | 0 | 09000064851b9663 | |
| USDA-2022-0002-0001 | USDA | Agriculture Acquisition Regulation (AGAR) USDA-2022-0002 | Acquisition Regulation | Proposed Rule | 2022-02-17T05:00:00Z | 2022 | 2 | 2022-02-17T05:00:00Z | 2022-03-22T03:59:59Z | 2022-03-23T01:00:45Z | 2022-01751 | 0 | 0 | 0900006484f81413 | |
| USDA-2020-0009-0001 | USDA | Equal Opportunity for Religious Organizations in U.S. Department of Agriculture Programs: Implementation of Executive Order 13831 USDA-2020-0009 | Equal Opportunity for Religious Organizations in U.S. Department of Agriculture Programs: Implementation Of Executive Order 13831 | Proposed Rule | 2020-01-17T05:00:00Z | 2020 | 1 | 2020-01-17T05:00:00Z | 2020-02-19T04:59:59Z | 2020-07-10T16:24:18Z | 2019-28541 | 0 | 0 | 09000064842b7e3f | |
| USDA_FRDOC_0001-2147 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | UA: Reg Flex Agenda | Proposed Rule | 2019-12-26T05:00:00Z | 2019 | 12 | 2019-12-26T05:00:00Z | 2019-12-26T12:49:24Z | 2019-26534 | 0 | 0 | 090000648424f8bd | ||
| USDA-2019-0005-0001 | USDA | Supplemental Standards of Ethical Conduct for Employees of the Department of Agriculture USDA-2019-0005 | Supplemental Standards of Ethical Conduct for Employees of the Department of Agriculture | Proposed Rule | 2019-11-08T05:00:00Z | 2019 | 11 | 2019-11-08T05:00:00Z | 2019-12-24T04:59:59Z | 2019-12-22T02:01:04Z | 2019-24082 | 0 | 0 | 0900006484130062 | |
| USDA_FRDOC_0001-2097 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Withdrawal of Certain Proposed Rules | Proposed Rule | 2019-09-10T04:00:00Z | 2019 | 9 | 2019-09-10T04:00:00Z | 2019-09-10T11:39:48Z | 2019-19572 | 0 | 0 | 0900006483f24b9c | ||
| USDA-2017-0002-4070 | USDA | Identifying Regulatory Reform Initiatives USDA-2017-0002 | Identifying Regulatory Reform Initiatives | Proposed Rule | 2018-06-20T04:00:00Z | 2018 | 6 | 2018-08-27T01:17:08Z | 2018-13153 | 0 | 0 | 0900006483433811 | |||
| USDA-2018-0003-0001 | USDA | USDA Departmental Freedom of Information Act Regulations USDA-2018-0003 | Departmental Freedom of Information Act Regulations | Proposed Rule | 2018-06-11T04:00:00Z | 2018 | 6 | 2018-06-11T04:00:00Z | 2018-08-11T03:59:59Z | 2018-08-12T01:02:58Z | 2018-11868 | 0 | 0 | 09000064833d712a | |
| USDA_FRDOC_0001-1835 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Federal Policy for the Protection of Human Subjects: Proposed Six Month Delay of the General Compliance Date While Allowing the Use of Three Burden-Reducing Provisions During the Delay Period | Proposed Rule | 2018-04-20T04:00:00Z | 2018 | 4 | 2018-04-20T04:00:00Z | 2018-04-20T12:06:30Z | 2018-08231 | 0 | 0 | 090000648319a157 | ||
| USDA_FRDOC_0001-1783 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Withdrawal of Certain Proposed Rules and Other Proposed Actions; Correction | Proposed Rule | 2018-01-19T05:00:00Z | 2018 | 1 | 2018-01-19T05:00:00Z | 2018-01-19T12:53:26Z | 2018-00893 | 0 | 0 | 0900006482e2ecbc | ||
| USDA_FRDOC_0001-1781 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Withdrawal of Certain Proposed Rules and Other Proposed Actions | Proposed Rule | 2018-01-04T05:00:00Z | 2018 | 1 | 2018-01-04T05:00:00Z | 2018-01-04T12:39:24Z | 2017-28433 | 0 | 0 | 0900006482d95ea5 | ||
| USDA-2017-0002-0001 | USDA | Identifying Regulatory Reform Initiatives USDA-2017-0002 | Identifying Regulatory Reform Initiatives | Proposed Rule | 2017-07-17T04:00:00Z | 2017 | 7 | 2017-07-17T04:00:00Z | 2020-09-19T03:59:59Z | 2020-09-19T01:02:23Z | 2017-14920 | 0 | 0 | 0900006482933118 | |
| USDA_FRDOC_0001-1546 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Semiannual Regulatory Agenda, Spring 2016 | Proposed Rule | 2016-06-09T04:00:00Z | 2016 | 6 | 2016-06-09T04:00:00Z | 2016-06-09T13:55:53Z | 2016-12899 | 0 | 0 | 0900006482025c08 | ||
| USDA-2016-0001-0045 | USDA | Identifying and Reducing Regulatory Burdens USDA-2016-0001 | Identifying and Reducing Regulatory Burdens | Proposed Rule | 2016-03-25T04:00:00Z | 2016 | 3 | 2016-03-25T04:00:00Z | 2016-04-28T03:59:59Z | 2016-04-28T01:00:15Z | 2016-06852 | 0 | 0 | 0900006481edf042 | |
| USDA-2016-0001-0001 | USDA | Identifying and Reducing Regulatory Burdens USDA-2016-0001 | Identifying and Reducing Regulatory Burdens | Proposed Rule | 2016-01-26T05:00:00Z | 2016 | 1 | 2016-01-26T05:00:00Z | 2016-04-28T03:59:59Z | 2016-04-27T22:00:16Z | 2016-00693 | 0 | 0 | 0900006481e2f6d8 | |
| USDA_FRDOC_0001-1519 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Federal Policy for the Protection of Human Subjects | Proposed Rule | 2015-11-25T05:00:00Z | 2015 | 11 | 2015-11-25T05:00:00Z | 2016-01-07T04:59:59Z | 2015-11-25T13:45:26Z | 2015-30122 | 0 | 0 | 0900006481d72939 | |
| USDA_FRDOC_0001-1510 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Federal Policy for the Protection of Human Subjects | Proposed Rule | 2015-09-08T04:00:00Z | 2015 | 9 | 2015-09-08T04:00:00Z | 2015-12-08T04:59:59Z | 2016-01-12T19:23:52Z | 2015-21756 | 0 | 0 | 0900006481c5dd42 | |
| USDA-2015-0005-0001 | USDA | Equal Opportunity for Religious Organizations in USDA Programs: Implementation of E.O.13559; Proposed Rule USDA-2015-0005 | Equal Opportunity for Religious Organizations | Proposed Rule | 2015-08-06T04:00:00Z | 2015 | 8 | 2015-08-06T04:00:00Z | 2015-10-06T03:59:59Z | 2015-10-07T21:25:25Z | 2015-18262 | 0 | 0 | 0900006481bc754d | |
| USDA-2015-0002-0001 | USDA | Identifying and Reducing Regulatory Burdens USDA-2015-0002 | Identifying and Reducing Regulatory Burdens | Proposed Rule | 2015-03-17T04:00:00Z | 2015 | 3 | 2015-03-17T04:00:00Z | 2015-05-19T03:59:59Z | 2015-05-19T01:31:40Z | 2015-05742 | 0 | 0 | 0900006481a4a93e | |
| USDA_FRDOC_0001-1387 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Programs or Activities Receiving Federal Financial Assistance: Nondiscrimination on the Basis of Age | Proposed Rule | 2014-12-10T05:00:00Z | 2014 | 12 | 2014-12-10T05:00:00Z | 2015-01-10T04:59:59Z | 2014-12-10T13:58:58Z | 2014-28453 | 0 | 0 | 090000648196a789 | |
| USDA_FRDOC_0001-1199 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Semiannual Regulatory Agenda, Fall 2013 | Proposed Rule | 2014-01-07T05:00:00Z | 2014 | 1 | 2014-01-07T05:00:00Z | 2014-01-07T16:51:39Z | 2013-29628 | 0 | 0 | 09000064814f1302 | ||
| USDA-2013-0005-0001 | USDA | Nondiscrimination in Programs or Activities Conducted by the United States Department of Agriculture USDA-2013-0005 | Nondiscrimination in Programs or Activities Conducted by the United States Department of Agriculture | Proposed Rule | 2013-12-27T05:00:00Z | 2013 | 12 | 2013-12-27T05:00:00Z | 2014-01-28T04:59:59Z | 2014-02-07T22:09:11Z | 2013-30812 | 0 | 0 | 09000064814de488 | |
| USDA_FRDOC_0001-1012 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | REGULATORY AGENDA Semiannual Regulatory Agenda | Proposed Rule | 2013-01-08T05:00:00Z | 2013 | 1 | 2013-01-08T05:00:00Z | 2013-01-09T23:30:25Z | 2012-31486 | 0 | 0 | 09000064811b09fb | ||
| USDA_FRDOC_0001-0921 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Export Sales Reporting Requirements | Proposed Rule | 2012-06-25T04:00:00Z | 2012 | 6 | 2012-06-25T04:00:00Z | 2012-08-25T03:59:59Z | 2012-06-25T12:59:45Z | 2012-15437 | 0 | 0 | 09000064810639f7 | |
| USDA_FRDOC_0001-0877 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Export Sales Reporting Requirements; Withdrawal | Proposed Rule | 2012-03-22T04:00:00Z | 2012 | 3 | 2012-03-22T04:00:00Z | 2012-03-22T14:39:51Z | 2012-06820 | 0 | 0 | 0900006480fddb4d | ||
| USDA_FRDOC_0001-0866 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Guidance to Federal Financial Assistance Recipients: Title VI Prohibition Against National Origin Discrimination Affecting Persons with Limited English Proficiency | Proposed Rule | 2012-03-08T05:00:00Z | 2012 | 3 | 2012-03-08T05:00:00Z | 2012-05-08T03:59:59Z | 2012-03-08T13:26:27Z | 2012-04377 | 0 | 0 | 0900006480fd1be0 | |
| USDA_FRDOC_0001-0867 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Export Sales Reporting Requirements | Proposed Rule | 2012-03-08T05:00:00Z | 2012 | 3 | 2012-03-08T05:00:00Z | 2012-05-08T03:59:59Z | 2012-05-08T12:02:31Z | 2012-05486 | 0 | 0 | 0900006480fd1c1b | |
| USDA_FRDOC_0001-0855 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | REGULATORY AGENDA Semiannual Regulatory Agenda | Proposed Rule | 2012-02-13T05:00:00Z | 2012 | 2 | 2012-02-13T05:00:00Z | 2012-02-13T14:27:30Z | 2012-01640 | 0 | 0 | 0900006480fb45a2 | ||
| USDA-2012-0002-0038 | USDA | Agriculture Acquisition; Labor Law Violations USDA-2012-0002 | Agriculture Acquisitions, Labor Law Violations: Withdrawal | Proposed Rule | 2012-02-06T05:00:00Z | 2012 | 2 | 2012-02-06T05:00:00Z | 2012-02-28T19:12:41Z | 2012-02639 | 0 | 0 | 0900006480fae381 | ||
| USDA-2012-0002-0001 | USDA | Agriculture Acquisition; Labor Law Violations USDA-2012-0002 | Agriculture Acquisition; Labor Law Violations | Proposed Rule | 2011-12-01T05:00:00Z | 2011 | 12 | 2011-12-01T05:00:00Z | 2012-01-31T04:59:59Z | 2012-01-25T21:36:22Z | 2011-30875 | 0 | 0 | 0900006480f792f1 | |
| USDA_FRDOC_0001-0802 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Agricultural Career and Employment Grants Program: Withdrawal | Proposed Rule | 2011-11-08T05:00:00Z | 2011 | 11 | 2011-11-08T05:00:00Z | 2011-11-08T13:41:46Z | 2011-29033 | 0 | 0 | 0900006480f681f1 | ||
| USDA_FRDOC_0001-0794 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Agricultural Career and Employment Grants Program | Proposed Rule | 2011-10-27T04:00:00Z | 2011 | 10 | 2011-10-27T04:00:00Z | 2011-12-28T04:59:59Z | 2011-10-27T12:39:18Z | 2011-27109 | 0 | 0 | 0900006480f5dde7 | |
| USDA_FRDOC_0001-0744 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | REGULATORY AGENDA Semiannual Regulatory Agenda | Proposed Rule | 2011-07-07T04:00:00Z | 2011 | 7 | 2011-07-07T04:00:00Z | 2011-07-07T14:07:27Z | 2011-15473 | 0 | 0 | 0900006480ebb67b | ||
| USDA_FRDOC_0001-0675 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Designation of Biobased Items for Federal Procurement | Proposed Rule | 2011-02-04T05:00:00Z | 2011 | 2 | 2011-02-04T05:00:00Z | 2011-04-06T03:59:59Z | 2011-06-11T18:06:37Z | 2011-02012 | 0 | 0 | 0900006480bdbab8 | |
| USDA_FRDOC_0001-0613 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Dairy Import Licensing Program | Proposed Rule | 2010-10-13T04:00:00Z | 2010 | 10 | 2010-10-13T04:00:00Z | 2010-11-13T04:59:59Z | 2011-06-11T18:06:41Z | 2010-25651 | 0 | 0 | 0900006480b6dda2 | |
| USDA-2010-0004-0001 | USDA | Office of the Secretary: Procedures Relating to Awards Under the Equal Access to Justice Act USDA-2010-0004 | Procedures Relating to Awards under Equal Access to Justice Act | Proposed Rule | 2010-07-30T04:00:00Z | 2010 | 7 | 2010-07-30T04:00:00Z | 2010-09-29T03:59:59Z | 2021-06-26T20:34:17Z | 2010-18099 | 0 | 0 | 0900006480b246f7 | |
| USDA-2009-0004-0001 | USDA | Voluntary Labeling Program for Biobased Products USDA-2009-0004 | Voluntary Labeling Program for Biobased Products | Proposed Rule | 2009-07-31T04:00:00Z | 2009 | 7 | 2009-07-31T04:00:00Z | 2009-09-30T03:59:59Z | 2011-06-11T18:06:35Z | E9-17610 | 0 | 0 | 09000064809feeea | |
| USDA_FRDOC_0001-0299 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Regulatory Agenda Semiannual Regulatory Agenda | Proposed Rule | 2008-11-24T05:00:00Z | 2008 | 11 | 2008-11-24T05:00:00Z | 2008-12-20T23:19:17Z | E8-21222 | 0 | 0 | 09000064807bd610 | ||
| USDA_FRDOC_0001-0300 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | United States Department of Agriculture Research Misconduct Regulations for Extramural Research | Proposed Rule | 2008-11-24T05:00:00Z | 2008 | 11 | 2008-11-24T05:00:00Z | 2008-12-25T04:59:59Z | 2008-12-24T15:57:37Z | E8-27607 | 0 | 0 | 09000064807bd6c2 | |
| USDA_FRDOC_0001-0222 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Minimum Age Requirements for the Transport of Animals | Proposed Rule | 2008-05-09T04:00:00Z | 2008 | 5 | 2008-05-09T04:00:00Z | 2008-07-09T03:59:59Z | 2011-06-11T18:06:42Z | E8-10400 | 0 | 0 | 0900006480557089 | |
| USDA_FRDOC_0001-0217 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | REGULATORY AGENDA Semiannual Regulatory Agenda | Proposed Rule | 2008-05-05T04:00:00Z | 2008 | 5 | 2008-05-05T04:00:00Z | 2008-05-05T14:58:44Z | E8-07340 | 0 | 0 | 0900006480548b5e | ||
| USDA_FRDOC_0001-0125 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | The Dairy Import Licensing Program | Proposed Rule | 2007-10-04T04:00:00Z | 2007 | 10 | 2007-10-04T04:00:00Z | 2007-11-06T04:59:59Z | 2011-06-11T18:06:40Z | 07-04780 | 0 | 0 | 09000064802f8260 | |
| USDA_FRDOC_0001-0050 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Semi-annual agenda | Proposed Rule | 2007-04-30T04:00:00Z | 2007 | 4 | 2007-04-30T04:00:00Z | 2007-06-06T19:59:07Z | 07-01241 | 0 | 0 | 0900006480231a6a | ||
| USDA_FRDOC_0001-0016 | USDA | Recently Posted USDA Rules and Notices. USDA_FRDOC_0001 | Selection and Functions of Farm Service Agency State and County Committees | Proposed Rule | 2007-01-12T05:00:00Z | 2007 | 1 | 2007-01-12T05:00:00Z | 2007-01-30T04:59:59Z | 2011-06-11T18:06:41Z | E7-00298 | 0 | 0 | 09000064801f40df | |
| 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 | ||
| USDA-2006-0174-0001 | USDA | Selection and Functions of Farm Service Agency State and County Committees USDA-2006-0174 | Selection and Functions of Farm Service Agency State and County Committees | Proposed Rule | 2006-11-28T05:00:00Z | 2006 | 11 | 2006-11-28T05:00:00Z | 2007-01-30T04:59:59Z | 2011-06-11T18:06:35Z | E6-20052 | 0 | 0 | 09000064801e60f1 | |
| USDA-2006-0055-0001 | USDA | Semi-annual agenda USDA-2006-0055 | Semi-annual agenda | Proposed Rule | 2006-04-24T04:00:00Z | 2006 | 4 | 2006-04-24T04:00:00Z | 2007-06-11T15:01:44Z | 06-02469 | 0 | 0 | 0900006480163af3 |
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;