documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
65 rows where docket_id = "FSA_FRDOC_0001" and document_type = "Rule" sorted by posted_date descending
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FSA_FRDOC_0001-0441 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Removal of Unconstitutional Preferences Based on Race and Sex in Response to Court Ruling | Rule | 2025-07-10T04:00:00Z | 2025 | 7 | 2025-07-10T04:00:00Z | 2025-07-10T16:40:21Z | 2025-12877 | 0 | 0 | 09000064b8e601ad | ||
| FSA_FRDOC_0001-0440 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Removal of Obsolete Regulations | Rule | 2025-06-18T04:00:00Z | 2025 | 6 | 2025-06-18T04:00:00Z | 2025-06-18T15:35:30Z | 2025-11204 | 0 | 0 | 09000064b8e17477 | ||
| FSA_FRDOC_0001-0436 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Removal of Obsolete Regulations | Rule | 2025-05-29T00:00:00Z | 2025 | 5 | 2025-05-29T00:00:00Z | 2025-05-29T15:36:10Z | 2025-09617 | 0 | 0 | 09000064b8dc77b3 | ||
| FSA_FRDOC_0001-0435 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Removal of Obsolete Crop Assistance Program Regulations | Rule | 2025-05-13T00:00:00Z | 2025 | 5 | 2025-05-13T00:00:00Z | 2025-05-21T22:19:49Z | 2025-08298 | 0 | 0 | 09000064b8d477a1 | ||
| FSA_FRDOC_0001-0412 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Special Authority to Enable Funding of Broadband and Smart Utility Facilities Across Select Rural Development Programs | Rule | 2023-10-19T04:00:00Z | 2023 | 10 | 2023-10-19T04:00:00Z | 2023-10-19T12:11:26Z | 2023-23070 | 0 | 0 | 090000648610bebd | ||
| FSA_FRDOC_0001-0401 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Pandemic Assistance Programs and Agricultural Disaster Assistance Programs; Correction | Rule | 2023-06-20T04:00:00Z | 2023 | 6 | 2023-06-20T04:00:00Z | 2023-06-20T11:49:43Z | 2023-12912 | 0 | 0 | 0900006485b77e3a | ||
| FSA_FRDOC_0001-0392 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Pandemic Assistance Programs and Agricultural Disaster Assistance Programs | Rule | 2023-01-11T05:00:00Z | 2023 | 1 | 2023-01-11T05:00:00Z | 2023-03-14T03:59:59Z | 2023-03-14T01:01:19Z | 2023-00005 | 0 | 0 | 09000064855e0660 | |
| FSA_FRDOC_0001-0356 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Farm Loan Programs, Debt Settlement | Rule | 2021-02-22T05:00:00Z | 2021 | 2 | 2021-02-22T05:00:00Z | 2021-02-22T12:45:27Z | 2021-03186 | 0 | 0 | 0900006484a46740 | ||
| FSA_FRDOC_0001-0350 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Strategic Economic and Community Development | Rule | 2020-09-22T04:00:00Z | 2020 | 9 | 2020-09-22T04:00:00Z | 2020-09-22T11:52:23Z | 2020-19825 | 0 | 0 | 090000648486ee03 | ||
| FSA_FRDOC_0001-0349 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Special Authority To Enable Funding of Broadband and Smart Utility Facilities Across Select Rural Development Programs | Rule | 2020-09-15T04:00:00Z | 2020 | 9 | 2020-09-15T04:00:00Z | 2020-11-17T04:59:59Z | 2020-09-18T01:01:20Z | 2020-19033 | 0 | 0 | 09000064848591cd | |
| FSA_FRDOC_0001-0344 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Funding Availability: Coronavirus Food Assistance Program Additional Eligible Commodities | Rule | 2020-07-10T04:00:00Z | 2020 | 7 | 2020-07-10T04:00:00Z | 2020-07-10T12:17:08Z | 2020-14854 | 0 | 0 | 090000648473b301 | ||
| FSA_FRDOC_0001-0345 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Coronavirus Food Assistance Program; Correction | Rule | 2020-07-10T04:00:00Z | 2020 | 7 | 2020-07-10T04:00:00Z | 2020-07-10T12:17:28Z | 2020-14855 | 0 | 0 | 090000648473b30a | ||
| FSA_FRDOC_0001-0343 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Debt Management | Rule | 2020-06-17T04:00:00Z | 2020 | 6 | 2020-06-17T04:00:00Z | 2020-06-17T11:36:48Z | 2020-09447 | 0 | 0 | 09000064846f5dcb | ||
| FSA_FRDOC_0001-0338 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Agriculture Risk Coverage and Price Loss Coverage Programs; Correction | Rule | 2019-10-08T04:00:00Z | 2019 | 10 | 2019-10-08T04:00:00Z | 2019-10-08T11:45:48Z | 2019-21604 | 0 | 0 | 090000648405b1f3 | ||
| FSA_FRDOC_0001-0331 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Emergency Conservation Program | Rule | 2019-07-10T04:00:00Z | 2019 | 7 | 2019-07-10T04:00:00Z | 2019-07-10T11:41:29Z | 2019-14346 | 0 | 0 | 0900006483d74bd0 | ||
| FSA_FRDOC_0001-0329 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Dairy Margin Coverage Program and Dairy Indemnity Payment Program | Rule | 2019-06-18T04:00:00Z | 2019 | 6 | 2019-06-18T04:00:00Z | 2019-06-18T11:50:04Z | 2019-12998 | 0 | 0 | 0900006483d1dcbc | ||
| FSA_FRDOC_0001-0319 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Rural Development Environmental Regulation for Rural Infrastructure Projects | Rule | 2018-11-23T05:00:00Z | 2018 | 11 | 2018-11-23T05:00:00Z | 2018-11-23T13:08:38Z | 2018-25523 | 0 | 0 | 09000064838f5b1a | ||
| FSA_FRDOC_0001-0309 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Truth in Lending-Real Estate Settlement Procedures | Rule | 2018-03-23T04:00:00Z | 2018 | 3 | 2018-03-23T04:00:00Z | 2018-05-23T03:59:59Z | 2018-03-23T12:04:16Z | 2018-05999 | 0 | 0 | 0900006483043462 | |
| FSA_FRDOC_0001-0308 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Revision of Delegation of Authority for State Executive Director for Farm Loan Programs | Rule | 2018-03-19T04:00:00Z | 2018 | 3 | 2018-03-19T04:00:00Z | 2018-03-19T12:36:43Z | 2018-05466 | 0 | 0 | 090000648302557d | ||
| FSA_FRDOC_0001-0300 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Environmental Policies and Procedures; Corrections | Rule | 2017-04-27T04:00:00Z | 2017 | 4 | 2017-04-27T04:00:00Z | 2017-04-27T12:22:38Z | 2017-08529 | 0 | 0 | 090000648257e183 | ||
| FSA_FRDOC_0001-0288 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Methodology and Formulas for Allocation of Loan and Grant Program Funds; Correction | Rule | 2016-09-28T04:00:00Z | 2016 | 9 | 2016-09-28T04:00:00Z | 2016-09-28T11:57:07Z | 2016-23228 | 0 | 0 | 090000648227b376 | ||
| FSA_FRDOC_0001-0285 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Environmental Policies and Procedures: Compliance with the National Environmental Policy Act and Related Authorities | Rule | 2016-08-03T04:00:00Z | 2016 | 8 | 2016-08-03T04:00:00Z | 2016-08-03T20:36:12Z | 2016-18075 | 0 | 0 | 09000064821517da | ||
| FSA_FRDOC_0001-0284 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Community Facility Loans | Rule | 2016-07-06T04:00:00Z | 2016 | 7 | 2016-07-06T04:00:00Z | 2016-09-07T03:59:59Z | 2016-09-03T01:00:36Z | 2016-16005 | 0 | 0 | 090000648208beda | |
| FSA_FRDOC_0001-0280 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Environmental Policies and Procedures; Corrections | Rule | 2016-05-04T04:00:00Z | 2016 | 5 | 2016-05-04T04:00:00Z | 2016-05-04T13:02:02Z | 2016-10377 | 0 | 0 | 0900006481fa86f4 | ||
| FSA_FRDOC_0001-0281 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Environmental Policies and Procedures; Corrections | Rule | 2016-05-04T04:00:00Z | 2016 | 5 | 2016-05-04T04:00:00Z | 2016-05-04T13:03:10Z | 2016-10381 | 0 | 0 | 0900006481fa883d | ||
| FSA_FRDOC_0001-0279 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Environmental Policies and Procedures | Rule | 2016-03-02T05:00:00Z | 2016 | 3 | 2016-03-02T05:00:00Z | 2016-03-02T13:37:39Z | 2016-03433 | 0 | 0 | 0900006481e988f5 | ||
| FSA_FRDOC_0001-0278 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Strategic Economic and Community Development; Technical Amendments | Rule | 2016-03-01T05:00:00Z | 2016 | 3 | 2016-03-01T05:00:00Z | 2016-03-01T14:07:42Z | 2016-04309 | 0 | 0 | 0900006481e953a0 | ||
| FSA_FRDOC_0001-0275 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards | Rule | 2016-02-16T05:00:00Z | 2016 | 2 | 2016-02-16T05:00:00Z | 2016-02-16T13:58:56Z | 2016-02473 | 0 | 0 | 0900006481e6e467 | ||
| FSA_FRDOC_0001-0271 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Construction and Repair; CFR Correction, | Rule | 2015-12-31T05:00:00Z | 2015 | 12 | 2015-12-31T05:00:00Z | 2015-12-31T13:14:00Z | 2015-33037 | 0 | 0 | 0900006481dde9b3 | ||
| FSA_FRDOC_0001-0270 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Construction and Repair; CFR Correction, | Rule | 2015-12-31T05:00:00Z | 2015 | 12 | 2015-12-31T05:00:00Z | 2015-12-31T13:12:05Z | 2015-33038 | 0 | 0 | 0900006481dde850 | ||
| FSA_FRDOC_0001-0268 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Rural Development Loan Servicing; Correction | Rule | 2015-11-25T05:00:00Z | 2015 | 11 | 2015-11-25T05:00:00Z | 2015-11-25T13:46:14Z | 2015-29781 | 0 | 0 | 0900006481d72b00 | ||
| FSA_FRDOC_0001-0261 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Strategic Economic and Community Development | Rule | 2015-09-04T04:00:00Z | 2015 | 9 | 2015-09-04T04:00:00Z | 2015-09-19T03:59:59Z | 2015-09-04T13:06:58Z | 2015-21898 | 0 | 0 | 0900006481c5754e | |
| FSA_FRDOC_0001-0259 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Conservation Reserve Program | Rule | 2015-07-16T04:00:00Z | 2015 | 7 | 2015-07-16T04:00:00Z | 2015-07-16T13:32:23Z | 2015-17317 | 0 | 0 | 0900006481b8acd7 | ||
| FSA_FRDOC_0001-0258 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Strategic Economic and Community Development | Rule | 2015-06-18T04:00:00Z | 2015 | 6 | 2015-06-18T04:00:00Z | 2015-06-18T13:03:33Z | 2015-15048 | 0 | 0 | 0900006481b44c55 | ||
| FSA_FRDOC_0001-0254 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Final Affordability Determinations: Energy Efficiency Standards; Correction | Rule | 2015-05-28T04:00:00Z | 2015 | 5 | 2015-05-28T04:00:00Z | 2015-05-28T12:05:03Z | 2015-12931 | 0 | 0 | 0900006481b0893b | ||
| FSA_FRDOC_0001-0253 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Strategic Economic and Community Development | Rule | 2015-05-20T04:00:00Z | 2015 | 5 | 2015-05-20T04:00:00Z | 2015-08-19T03:59:59Z | 2015-08-19T01:31:04Z | 2015-12163 | 0 | 0 | 0900006481aeb503 | |
| FSA_FRDOC_0001-0251 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Rural Development: Updates to FmHA, Census References; Corrections | Rule | 2015-03-26T04:00:00Z | 2015 | 3 | 2015-03-26T04:00:00Z | 2015-03-26T13:16:55Z | 2015-06627 | 0 | 0 | 0900006481a69115 | ||
| FSA_FRDOC_0001-0250 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Rural Development Loan Servicing | Rule | 2015-03-13T04:00:00Z | 2015 | 3 | 2015-03-13T04:00:00Z | 2015-04-14T03:59:59Z | 2015-03-13T13:31:06Z | 2015-05435 | 0 | 0 | 0900006481a4270c | |
| FSA_FRDOC_0001-0248 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Rural Development: FmHAand Census References | Rule | 2015-02-24T05:00:00Z | 2015 | 2 | 2015-02-24T05:00:00Z | 2015-03-27T03:59:59Z | 2015-03-06T03:01:14Z | 2015-01571 | 0 | 0 | 0900006481a11af0 | |
| FSA_FRDOC_0001-0242 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards: Federal Awarding Agency Regulatory Implementation | Rule | 2014-12-19T05:00:00Z | 2014 | 12 | 2014-12-19T05:00:00Z | 2015-02-18T04:59:59Z | 2014-12-19T14:23:23Z | 2014-28697 | 0 | 0 | 0900006481985da0 | |
| FSA_FRDOC_0001-0233 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Methodology and Formulas for Allocation of Loan and Grant Program Funds | Rule | 2014-09-19T04:00:00Z | 2014 | 9 | 2014-09-19T04:00:00Z | 2014-09-19T12:39:27Z | 2014-22309 | 0 | 0 | 090000648187edd3 | ||
| FSA_FRDOC_0001-0231 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Eliminate the 6-Day Reservation Period Requirement for Rural Development Obligations | Rule | 2014-09-18T04:00:00Z | 2014 | 9 | 2014-09-18T04:00:00Z | 2014-11-18T04:59:59Z | 2014-09-18T12:27:33Z | 2014-21704 | 0 | 0 | 090000648187b5ce | |
| FSA_FRDOC_0001-0229 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Single Family Housing Guaranteed Loan Program; Correction | Rule | 2014-08-22T04:00:00Z | 2014 | 8 | 2014-08-22T04:00:00Z | 2014-08-22T13:13:57Z | 2014-19958 | 0 | 0 | 090000648183b3da | ||
| FSA_FRDOC_0001-0226 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Intermediary Relending Program | Rule | 2014-06-03T04:00:00Z | 2014 | 6 | 2014-06-03T04:00:00Z | 2014-06-03T13:17:15Z | 2014-12633 | 0 | 0 | 0900006481725866 | ||
| FSA_FRDOC_0001-0212 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Single Family Housing Guaranteed Loan Program | Rule | 2013-12-09T05:00:00Z | 2013 | 12 | 2013-12-09T05:00:00Z | 2014-01-09T04:59:59Z | 2014-01-17T21:40:27Z | 2013-29084 | 0 | 0 | 09000064814b281f | |
| FSA_FRDOC_0001-0210 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Farm Loan Programs | Rule | 2013-11-01T04:00:00Z | 2013 | 11 | 2013-11-01T04:00:00Z | 2014-01-18T19:53:50Z | 2013-25836 | 0 | 0 | 090000648146bd51 | ||
| FSA_FRDOC_0001-0196 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Microloan Operating Loans | Rule | 2013-01-17T05:00:00Z | 2013 | 1 | 2013-01-17T05:00:00Z | 2014-01-17T21:39:38Z | 2013-00672 | 0 | 0 | 09000064811c3aae | ||
| FSA_FRDOC_0001-0190 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | End-Use Certificate Program Requirements; suspension | Rule | 2012-08-24T04:00:00Z | 2012 | 8 | 2012-08-24T04:00:00Z | 2014-01-18T19:53:14Z | 2012-20983 | 0 | 0 | 09000064810eef7a | ||
| FSA_FRDOC_0001-0188 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Disaster Designation Process | Rule | 2012-07-13T04:00:00Z | 2012 | 7 | 2012-07-13T04:00:00Z | 2014-01-18T17:21:57Z | 2012-17137 | 0 | 0 | 09000064810934ce | ||
| FSA_FRDOC_0001-0187 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Federal Deposit Insurance Corporation Limit Change | Rule | 2012-07-13T04:00:00Z | 2012 | 7 | 2012-07-13T04:00:00Z | 2012-09-12T03:59:59Z | 2014-01-18T17:21:57Z | 2012-17061 | 0 | 0 | 09000064810932b9 | |
| FSA_FRDOC_0001-0186 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Single Family Housing Guaranteed Loan Program | Rule | 2012-07-11T04:00:00Z | 2012 | 7 | 2012-07-11T04:00:00Z | 2014-01-17T21:39:37Z | 2012-16864 | 0 | 0 | 09000064810861f3 | ||
| FSA_FRDOC_0001-0183 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Community Facility Loans | Rule | 2012-05-18T04:00:00Z | 2012 | 5 | 2012-05-18T04:00:00Z | 2014-01-17T21:39:34Z | 2012-11961 | 0 | 0 | 0900006481013eaf | ||
| FSA_FRDOC_0001-0174 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Intergovernmental Review | Rule | 2011-12-27T05:00:00Z | 2011 | 12 | 2011-12-27T05:00:00Z | 2014-01-18T17:22:31Z | 2011-33025 | 0 | 0 | 0900006480f898cb | ||
| FSA_FRDOC_0001-0173 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Amending Rural Business Investment Program | Rule | 2011-12-23T05:00:00Z | 2011 | 12 | 2011-12-23T05:00:00Z | 2012-01-24T04:59:59Z | 2014-01-18T16:58:31Z | 2011-32570 | 0 | 0 | 0900006480f8888a | |
| FSA_FRDOC_0001-0172 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Farm Loan Programs Loan Making Activities | Rule | 2011-12-02T05:00:00Z | 2011 | 12 | 2011-12-02T05:00:00Z | 2014-01-17T22:25:10Z | 2011-31046 | 0 | 0 | 0900006480f7a2ac | ||
| FSA_FRDOC_0001-0161 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Single Family Housing Guaranteed Loan Program | Rule | 2011-05-31T04:00:00Z | 2011 | 5 | 2011-05-31T04:00:00Z | 2014-01-17T21:37:55Z | 2011-13061 | 0 | 0 | 0900006480e35375 | ||
| FSA_FRDOC_0001-0145 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Prevention of Payments to Deceased Persons | Rule | 2010-12-29T05:00:00Z | 2010 | 12 | 2010-12-29T05:00:00Z | 2014-01-17T21:37:47Z | 2010-32760 | 0 | 0 | 0900006480bc1bae | ||
| FSA_FRDOC_0001-0137 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Conservation Loan Program | Rule | Interim Final | 2010-09-03T04:00:00Z | 2010 | 9 | 2010-09-03T04:00:00Z | 2010-11-03T03:59:59Z | 2014-01-18T19:41:16Z | 2010-22070 | 0 | 0 | 0900006480b4495b |
| FSA_FRDOC_0001-0133 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Dairy Product Price Support Program and Dairy Indemnity Payment Program | Rule | 2010-07-16T04:00:00Z | 2010 | 7 | 2010-07-16T04:00:00Z | 2014-01-17T21:33:30Z | 2010-17409 | 0 | 0 | 0900006480b1b1d5 | ||
| FSA_FRDOC_0001-0124 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Tree Assistance Program | Rule | 2010-05-07T04:00:00Z | 2010 | 5 | 2010-05-07T04:00:00Z | 2014-01-17T21:33:05Z | 2010-10800 | 0 | 0 | 0900006480ae8aeb | ||
| FSA_FRDOC_0001-0120 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Direct and Counter-Cyclical Program and Average Crop Revenue Election Program, Disaster Assistance Programs, etc. | Rule | 2010-04-14T04:00:00Z | 2010 | 4 | 2010-04-14T04:00:00Z | 2014-01-17T21:33:01Z | 2010-08308 | 0 | 0 | 0900006480ad727c | ||
| FSA_FRDOC_0001-0114 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Supplemental Revenue Assistance Payments Program | Rule | 2009-12-28T05:00:00Z | 2009 | 12 | 2009-12-28T05:00:00Z | 2014-01-17T21:32:47Z | E9-30632 | 0 | 0 | 0900006480a72073 | ||
| FSA_FRDOC_0001-0113 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Dairy Economic Loss Assistance Payment Program | Rule | 2009-12-21T05:00:00Z | 2009 | 12 | 2009-12-21T05:00:00Z | 2014-01-18T16:57:19Z | E9-30264 | 0 | 0 | 0900006480a6efbb | ||
| FSA_FRDOC_0001-0110 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Livestock Forage Disaster Program and Emergency Assistance for Livestock, Honeybees, and Farm-Raised Fish; Supplemental Agricultural Disaster Assistance | Rule | 2009-09-11T04:00:00Z | 2009 | 9 | 2009-09-11T04:00:00Z | 2014-01-18T19:26:36Z | E9-21906 | 0 | 0 | 0900006480a200a9 | ||
| FSA_FRDOC_0001-0098 | FSA | Recently Posted FSA Rules and Notices. FSA_FRDOC_0001 | Livestock Indemnity Program and General Provisions for Supplemental Agricultural Disaster Assistance Programs | Rule | 2009-07-02T04:00:00Z | 2009 | 7 | 2009-07-02T04:00:00Z | 2017-12-08T14:22:48Z | E9-15537 | 0 | 0 | 09000064809e8906 |
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;