documents

Regulatory documents from Regulations.gov including rules, proposed rules, notices, and supporting materials.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

74 rows where agency_id = "NRCS" and document_type = "Rule" sorted by posted_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

posted_year 16

document_type 1

  • Rule · 74 ✖

agency_id 1

  • NRCS · 74 ✖
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
NRCS_FRDOC_0001-0394 NRCS Recently Posted NRCS Rules and Notices. NRCS_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:43:15Z 2025-12877 0 0 09000064b8e60376
NRCS-2023-0020-0001 NRCS Changes to 7 CFR Part 622 - Alaska Watershed Projects for the Natural Resources Conservation Service NRCS-2023-0020 Tribe or Tribal Organization Sponsor Option for Watershed Projects Rule   2024-08-14T04:00:00Z 2024 8 2024-08-14T04:00:00Z 2024-09-14T03:59:59Z 2024-08-14T16:51:40Z 2024-17819 0 0 0900006486643837
NRCS-2019-0006-0074 NRCS Agricultural Conservation Easement Program NRCS-2019-0006 Agricultural Conservation Easement Program Rule   2021-02-04T05:00:00Z 2021 2 2021-02-04T05:00:00Z   2021-02-04T20:07:21Z 2021-02268 0 0 0900006484a1b992
NRCS-2019-0012-0070 NRCS Regional Conservation Partnership Program (RCPP) NRCS-2019-0012 Regional Conservation Partnership Program Rule   2021-01-15T05:00:00Z 2021 1 2021-01-15T05:00:00Z   2021-01-15T20:15:45Z 2021-00300 0 0 09000064849f4640
NRCS-2019-0009-0200 NRCS Environmental Quality Incentives Program (EQIP) Changes NRCS-2019-0009 Environmental Quality Incentives Program Rule Final Rule 2020-10-26T04:00:00Z 2020 10 2020-10-26T04:00:00Z   2020-10-26T13:46:40Z 2020-23437 0 0 090000648492f88a
NRCS-2019-0020-0113 NRCS Conservation Stewardship Program Interim Rule NRCS-2019-0020 Conservation Stewardship Program Rule   2020-10-09T04:00:00Z 2020 10 2020-10-09T04:00:00Z   2020-10-09T22:34:34Z 2020-22345 0 0 09000064848f1664
NRCS-2019-0012-0007 NRCS Regional Conservation Partnership Program (RCPP) NRCS-2019-0012 Regional Conservation Partnership Program Rule   2020-03-17T04:00:00Z 2020 3     2020-07-28T15:22:45Z 2020-05157 0 0 090000648444bfbc
NRCS-2019-0012-0001 NRCS Regional Conservation Partnership Program (RCPP) NRCS-2019-0012 Regional Conservation Partnership Program Rule   2020-02-13T05:00:00Z 2020 2 2020-02-13T05:00:00Z 2020-05-13T03:59:59Z 2020-05-14T01:04:07Z 2020-01812 0 0 0900006484362e10
NRCS-2019-0006-0013 NRCS Agricultural Conservation Easement Program NRCS-2019-0006 Agricultural Conservation Easement Program Rule   2020-01-24T05:00:00Z 2020 1 2020-01-24T05:00:00Z 2020-03-21T03:59:59Z 2020-03-22T01:01:45Z 2020-01066 0 0 09000064842e7be5
NRCS-2019-0006-0001 NRCS Agricultural Conservation Easement Program NRCS-2019-0006 Agricultural Conservation Easement Program Rule   2020-01-06T05:00:00Z 2020 1 2020-01-06T05:00:00Z 2020-03-07T04:59:59Z 2020-03-08T03:01:26Z 2019-27883 0 0 090000648426ec45
NRCS-2019-0009-0001 NRCS Environmental Quality Incentives Program (EQIP) Changes NRCS-2019-0009 Environmental Quality Incentives Program Rule   2019-12-17T05:00:00Z 2019 12 2019-12-17T05:00:00Z 2020-02-19T04:59:59Z 2020-02-20T02:01:28Z 2019-26872 0 0 090000648421d096
NRCS-2019-0020-0002 NRCS Conservation Stewardship Program Interim Rule NRCS-2019-0020 Conservation Stewardship Program Rule   2019-11-12T05:00:00Z 2019 11 2019-11-12T05:00:00Z 2020-01-14T04:59:59Z 2020-01-15T02:01:05Z 2019-24367 0 0 0900006484143213
NRCS-2019-0007-0001 NRCS Miscellaneous Conservation Provisions NRCS-2019-0007 Miscellaneous Conservation Provisions Rule   2019-05-06T04:00:00Z 2019 5 2019-05-06T04:00:00Z 2019-07-06T03:59:59Z 2019-07-06T01:01:48Z 2019-09151 0 0 0900006483c36d77
NRCS-2018-0010-0001 NRCS Highly Erodible Land and Wetland Conservation (7 CFR Part 12) NRCS-2018-0010 Highly Erodible Land and Wetland Conservation Rule   2018-12-07T05:00:00Z 2018 12 2018-12-07T05:00:00Z 2019-02-06T04:59:59Z 2019-02-08T02:04:31Z 2018-26521 0 0 09000064839584b7
NRCS-2014-0011-0109 NRCS Agricultural Conservation Easement Program (ACEP) Rule NRCS-2014-0011 Agricultural Conservation Easement Program Rule   2016-10-18T04:00:00Z 2016 10 2016-10-18T04:00:00Z   2016-10-21T14:56:49Z 2016-24504 0 0 090000648230f4f5
NRCS-2014-0007-0066 NRCS Environmental Quality Incentives Program (EQIP) interim rule NRCS-2014-0007 Environmental Quality Incentives Program Rule   2016-05-12T04:00:00Z 2016 5 2016-05-12T04:00:00Z   2016-06-09T14:07:36Z 2016-10161 0 0 0900006481fc79a9
NRCS-2014-0008-0234 NRCS Conservation Stewardship Program (CSP) rule NRCS-2014-0008 Conservation Stewardship Program Rule   2016-03-10T05:00:00Z 2016 3 2016-03-10T05:00:00Z   2016-06-09T13:57:53Z 2016-05419 0 0 0900006481eb8236
NRCS-2015-0013-0001 NRCS Equitable Relief Final Rule NRCS-2015-0013 NRCS Procedures for Granting Equitable Relief Rule   2015-10-16T04:00:00Z 2015 10 2015-10-16T04:00:00Z   2015-10-16T18:03:53Z 2015-26309 0 0 0900006481cd0430
NRCS-2014-0017-0001 NRCS Water Bank Rule Amendment NRCS-2014-0017 Water Bank Program Rule   2015-06-09T04:00:00Z 2015 6 2015-06-09T04:00:00Z   2015-06-09T14:29:48Z 2015-13992 0 0 0900006481b24c7d
NRCS-2014-0011-0008 NRCS Agricultural Conservation Easement Program (ACEP) Rule NRCS-2014-0011 Agricultural Conservation Easement Program Rule   2015-04-30T04:00:00Z 2015 4     2015-04-30T20:09:17Z 2015-10055 0 0 0900006481ac4846
NRCS-2014-0006-0010 NRCS Changes to Existing Conservation Program Regulations Rule NRCS-2014-0006 Changes to Existing Conservation Program Regulations Rule   2015-04-09T04:00:00Z 2015 4 2015-04-09T04:00:00Z   2015-04-15T16:20:19Z 2015-08008 0 0 0900006481a96d4c
NRCS-2014-0006-0009 NRCS Changes to Existing Conservation Program Regulations Rule NRCS-2014-0006 Changes to Existing Conservation Program Regulations Rule Final Rule 2015-04-09T04:00:00Z 2015 4 2015-04-09T04:00:00Z   2015-04-15T16:19:24Z 2015-08008 0 0 0900006481a96d8f
NRCS-2014-0011-0001 NRCS Agricultural Conservation Easement Program (ACEP) Rule NRCS-2014-0011 Agricultural Conservation Easement Program Rule   2015-02-27T05:00:00Z 2015 2 2015-02-27T05:00:00Z 2015-05-29T03:59:59Z 2015-06-12T01:30:41Z 2015-03781 0 0 0900006481a1d805
NRCS-2014-0011-0007 NRCS Agricultural Conservation Easement Program (ACEP) Rule NRCS-2014-0011 Agricultural Conservation Easement Program Rule   2015-02-27T05:00:00Z 2015 2 2015-02-27T05:00:00Z 2015-04-29T03:59:59Z 2015-04-28T02:03:21Z 2015-03781 0 0 0900006481a1d89c
NRCS-2014-0008-0017 NRCS Conservation Stewardship Program (CSP) rule NRCS-2014-0008 Conservation Stewardship Program Rule Extension of Comment Period 2014-12-23T05:00:00Z 2014 12 2014-12-23T05:00:00Z   2014-12-23T14:15:16Z 2014-29982 0 0 090000648198ea42
NRCS-2014-0008-0016 NRCS Conservation Stewardship Program (CSP) rule NRCS-2014-0008 Conservation Stewardship Program Rule Extension of Comment Period 2014-12-23T05:00:00Z 2014 12 2014-12-23T05:00:00Z 2014-12-24T04:59:59Z 2014-12-23T14:16:56Z 2014-29982 0 0 090000648198ead3
NRCS-2014-0007-0001 NRCS Environmental Quality Incentives Program (EQIP) interim rule NRCS-2014-0007 Environmental Quality Incentives Program Rule   2014-12-12T05:00:00Z 2014 12 2014-12-12T05:00:00Z 2015-02-11T04:59:59Z 2015-05-01T18:20:44Z 2014-28941 0 0 09000064819703fd
NRCS-2014-0008-0001 NRCS Conservation Stewardship Program (CSP) rule NRCS-2014-0008 Conservation Stewardship Program Rule Interim Final Rule 2014-11-05T05:00:00Z 2014 11 2014-11-05T05:00:00Z 2015-01-21T04:59:59Z 2015-01-25T02:54:53Z 2014-26295 0 0 0900006481915538
NRCS-2014-0008-0008 NRCS Conservation Stewardship Program (CSP) rule NRCS-2014-0008 Conservation Stewardship Program Rule   2014-11-05T00:00:00Z 2014 11     2014-12-23T13:56:55Z   0 1 0900006481915337
NRCS-2014-0006-0001 NRCS Changes to Existing Conservation Program Regulations Rule NRCS-2014-0006 Conservation Program Regulations Rule   2014-08-01T04:00:00Z 2014 8 2014-08-01T04:00:00Z 2014-10-01T03:59:59Z 2014-12-12T03:06:22Z 2014-17993 0 0 09000064817f4e08
NRCS-2014-0006-0006 NRCS Changes to Existing Conservation Program Regulations Rule NRCS-2014-0006 Conservation Program Regulations Rule   2014-08-01T00:00:00Z 2014 8     2014-12-14T03:06:00Z   0 1 09000064817f5165
NRCS-2011-0017-0001 NRCS NRCS Appeal Procedures NRCS-2011-0017 Appeal Procedures Rule   2012-06-11T04:00:00Z 2012 6 2012-06-11T04:00:00Z   2012-08-16T16:19:23Z 2012-14098 0 0 0900006481040a23
NRCS-2009-0004-0033 NRCS Farm and Ranch Lands Protection Program NRCS-2009-0004 Farm and Ranch Lands Protection Program Rule   2012-02-10T05:00:00Z 2012 2 2012-02-10T05:00:00Z   2012-03-24T19:34:47Z 2012-03173 0 0 0900006480fb28a6
NRCS-2011-0010-0001 NRCS Wetland Conservation NRCS-2011-0010 Wetland Conservation Rule   2011-04-25T04:00:00Z 2011 4 2011-04-25T04:00:00Z   2011-06-11T17:51:49Z 2011-09870 0 0 0900006480c37230
NRCS-2011-0012-0001 NRCS Conservation Program Recipient Reporting (Transparency Rule) NRCS-2011-0012 Conservation Program Recipient Reporting Rule   2011-04-08T04:00:00Z 2011 4 2011-04-08T04:00:00Z   2011-04-08T15:21:37Z 2011-08368 0 0 0900006480c1f1a1
NRCS-2009-0007-0017 NRCS Technical Service Provider Assistance NRCS-2009-0007 Technical Service Provider Assistance; CFR Correction Rule   2010-12-29T05:00:00Z 2010 12 2010-12-29T05:00:00Z   2011-02-16T15:36:33Z 2010-32945 0 0 0900006480bc1c44
NRCS-2009-0006-0001 NRCS Grassland Reserve Program NRCS-2009-0006 Grassland Reserve Program Rule   2010-11-29T05:00:00Z 2010 11 2010-11-29T05:00:00Z   2011-06-11T17:51:43Z 2010-29513 0 0 0900006480ba819a
NRCS-2009-0001-0028 NRCS Wildlife Habitat Incentives Program NRCS-2009-0001 Wildlife Habitat Incentive Program Rule   2010-11-23T05:00:00Z 2010 11 2010-11-23T05:00:00Z   2011-06-11T17:51:39Z 2010-29394 0 0 0900006480ba1d99
NRCS-2009-0007-0018 NRCS Technical Service Provider Assistance NRCS-2009-0007 Technical Service Provider Assistance Rule   2010-08-10T04:00:00Z 2010 8 2010-08-10T04:00:00Z   2011-06-11T17:51:44Z 2010-19623 0 0 0900006480b2d121
NRCS-2009-0014-0005 NRCS Conservation Stewardship Program Interim Final Rule NRCS-2009-0014 Conservation Stewardship Program Rule   2010-06-21T04:00:00Z 2010 6 2010-06-21T04:00:00Z   2013-02-22T17:16:35Z 2010-14847 0 0 0900006480b06e8e
NRCS-2009-0014-0001 NRCS Conservation Stewardship Program Interim Final Rule NRCS-2009-0014 Conservation Stewardship Program Rule   2010-06-03T04:00:00Z 2010 6 2010-06-03T04:00:00Z   2013-02-22T17:16:35Z 2010-12699 0 0 0900006480afabc7
NRCS-2009-0007-0019 NRCS Technical Service Provider Assistance NRCS-2009-0007 Technical Service Provider Assistance Rule   2010-02-12T05:00:00Z 2010 2 2010-02-12T05:00:00Z   2011-06-11T17:51:43Z 2010-02814 0 0 0900006480a91b09
NRCS-2009-0005-0010 NRCS Healthy Forests Reserve Program NRCS-2009-0005 Healthy Forests Reserve Program Rule   2010-02-10T05:00:00Z 2010 2 2010-02-10T05:00:00Z   2011-06-11T17:51:42Z 2010-02812 0 0 0900006480a90a91
NRCS-2011-0007-0004 NRCS Compliance with NEPA NRCS-2011-0007 Compliance with NEPA Rule   2010-02-10T05:00:00Z 2010 2 2010-02-10T05:00:00Z   2011-06-11T17:51:48Z 2010-02815 0 0 0900006480a90b97
NRCS-2009-0009-0001 NRCS State Technical Committees NRCS-2009-0009 State Technical Committees Rule   2009-12-17T05:00:00Z 2009 12 2009-12-17T05:00:00Z   2011-02-16T18:31:50Z E9-30055 0 0 0900006480a6ca06
NRCS-2009-0017-0001 NRCS Agricultural Management Assistance Program (AMA) NRCS-2009-0017 Agricultural Management Assistance Program Rule   2009-12-08T05:00:00Z 2009 12 2009-12-08T05:00:00Z   2011-06-11T17:51:47Z E9-29070 0 0 0900006480a66742
NRCS-2009-0008-0006 NRCS Regional Equity NRCS-2009-0008 Regional Equity Rule   2009-12-04T05:00:00Z 2009 12 2009-12-04T05:00:00Z   2011-06-11T17:51:44Z E9-29001 0 0 0900006480a62b85
NRCS-2009-0014-0006 NRCS Conservation Stewardship Program Interim Final Rule NRCS-2009-0014 Conservation Stewardship Program Rule Correction 2009-09-21T04:00:00Z 2009 9 2009-09-21T04:00:00Z 2009-10-29T03:59:59Z 2013-02-22T17:16:35Z E9-22597 0 0 0900006480a280f3
NRCS-2009-0006-0002 NRCS Grassland Reserve Program NRCS-2009-0006 Grassland Reserve Program; Amendment Rule   2009-08-21T04:00:00Z 2009 8 2009-08-21T04:00:00Z 2009-09-22T03:59:59Z 2011-06-11T17:51:43Z E9-20074 0 0 0900006480a0f0bf
NRCS-2009-0014-0002 NRCS Conservation Stewardship Program Interim Final Rule NRCS-2009-0014 Conservation Stewardship Program Rule   2009-07-29T04:00:00Z 2009 7 2009-07-29T04:00:00Z 2009-09-29T03:59:59Z 2013-03-27T02:02:06Z E9-17812 0 0 09000064809fd67a
NRCS-2009-0015-0001 NRCS Wildlife Habitat Incentive Program NRCS-2009-0015 Wildlife Habitat Incentive Program Rule   2009-07-15T04:00:00Z 2009 7 2009-07-15T04:00:00Z 2009-08-15T03:59:59Z 2011-06-11T17:51:46Z E9-16705 0 0 09000064809f1d81
NRCS-2011-0007-0003 NRCS Compliance with NEPA NRCS-2011-0007 Compliance with NEPA Rule   2009-07-13T04:00:00Z 2009 7 2009-07-13T04:00:00Z 2009-09-12T03:59:59Z 2011-06-11T17:51:48Z E9-16400 0 0 09000064809f0127
NRCS-2009-0004-0001 NRCS Farm and Ranch Lands Protection Program NRCS-2009-0004 Farm and Ranch Lands Protection Program Rule   2009-07-02T04:00:00Z 2009 7 2009-07-02T04:00:00Z 2009-08-04T03:59:59Z 2011-06-11T17:51:41Z E9-15684 0 0 09000064809e84ba
NRCS-2009-0002-0002 NRCS Wetland Reserve Program NRCS-2009-0002 Wetlands Reserve Program Rule Correction 2009-06-02T04:00:00Z 2009 6 2009-06-02T04:00:00Z 2009-07-03T03:59:59Z 2011-06-11T17:51:39Z E9-12680 0 0 09000064809c2a61
NRCS-2009-0003-0003 NRCS Environmental Quality Incentives Program NRCS-2009-0003 Environmental Quality Incentives Program; Amendment Rule   2009-05-29T04:00:00Z 2009 5 2009-05-29T04:00:00Z 2009-06-30T03:59:59Z 2011-06-11T17:51:40Z E9-12562 0 0 09000064809be7f9
NRCS-2009-0017-0003 NRCS Agricultural Management Assistance Program (AMA) NRCS-2009-0017 Agricultural Management Assistance Program; Correction Rule Correction 2009-03-12T04:00:00Z 2009 3 2009-03-12T04:00:00Z   2011-06-11T17:51:47Z E9-05093 0 0 090000648090e463
NRCS-2009-0001-0005 NRCS Wildlife Habitat Incentives Program NRCS-2009-0001 Wildlife Habitat Incentive Program Rule   2009-03-12T04:00:00Z 2009 3 2009-03-12T04:00:00Z 2009-04-18T03:59:59Z 2011-06-11T17:51:39Z E9-05083 0 0 090000648090e47f
NRCS-2009-0003-0002 NRCS Environmental Quality Incentives Program NRCS-2009-0003 Environmental Quality Incentives Program Rule   2009-03-12T04:00:00Z 2009 3 2009-03-12T04:00:00Z 2009-04-18T03:59:59Z 2011-06-11T17:51:40Z E9-05087 0 0 090000648090e4bc
NRCS-2009-0001-0003 NRCS Wildlife Habitat Incentives Program NRCS-2009-0001 Wildlife Habitat Incentive Program Rule   2009-02-19T05:00:00Z 2009 2 2009-02-19T05:00:00Z 2009-03-18T03:59:59Z 2011-06-11T17:51:39Z E9-00827 0 0 090000648085e836
NRCS-2009-0006-0003 NRCS Grassland Reserve Program NRCS-2009-0006 Grassland Reserve Program Rule   2009-01-21T05:00:00Z 2009 1 2009-01-21T05:00:00Z 2009-03-24T03:59:59Z 2011-06-11T17:51:43Z E9-01075 0 0 0900006480829484
NRCS-2009-0007-0001 NRCS Technical Service Provider Assistance NRCS-2009-0007 Technical Service Provider Assistance Rule   2009-01-16T05:00:00Z 2009 1 2009-01-16T05:00:00Z 2009-03-18T03:59:59Z 2011-06-11T17:51:44Z E9-00828 0 0 09000064808233fc
NRCS-2009-0004-0031 NRCS Farm and Ranch Lands Protection Program NRCS-2009-0004 Farm and Ranch Lands Protection Program Rule   2009-01-16T05:00:00Z 2009 1 2009-01-16T05:00:00Z 2009-03-18T03:59:59Z 2011-06-11T17:51:41Z E9-00829 0 0 09000064808232ca
NRCS-2009-0001-0001 NRCS Wildlife Habitat Incentives Program NRCS-2009-0001 Wildlife Habitat Incentive Program Rule   2009-01-16T05:00:00Z 2009 1 2009-01-16T05:00:00Z 2009-03-18T03:59:59Z 2011-06-11T17:51:38Z E9-00827 0 0 09000064808232ec
NRCS-2009-0002-0001 NRCS Wetland Reserve Program NRCS-2009-0002 Wetlands Reserve Program Rule   2009-01-15T05:00:00Z 2009 1 2009-01-15T05:00:00Z 2009-03-17T03:59:59Z 2011-06-11T17:51:40Z E9-00735 0 0 090000648082120a
NRCS-2009-0003-0001 NRCS Environmental Quality Incentives Program NRCS-2009-0003 Environmental Quality Incentives Program Rule   2009-01-15T05:00:00Z 2009 1 2009-01-15T05:00:00Z 2009-03-17T03:59:59Z 2011-06-11T17:51:41Z E9-00530 0 0 090000648082136b
NRCS-2009-0008-0001 NRCS Regional Equity NRCS-2009-0008 Regional Equity Rule   2009-01-13T05:00:00Z 2009 1 2009-01-13T05:00:00Z 2009-03-17T03:59:59Z 2011-06-11T17:51:44Z E9-00492 0 0 090000648081cc93
NRCS-2009-0017-0002 NRCS Agricultural Management Assistance Program (AMA) NRCS-2009-0017 Agricultural Management Assistance Program Rule   2008-11-20T05:00:00Z 2008 11 2008-11-20T05:00:00Z 2009-01-21T04:59:59Z 2011-06-11T17:51:47Z E8-27398 0 0 09000064807b35e1
NRCS-2011-0007-0002 NRCS Compliance with NEPA NRCS-2011-0007 Regulations for Complying With the National Environmental Policy Act Rule   2008-09-23T04:00:00Z 2008 9 2008-09-23T04:00:00Z   2011-06-11T17:51:48Z E8-22090 0 0 090000648071cea3
NRCS-2011-0008-0002 NRCS Plant Materials Centers NRCS-2011-0008 Plant Materials Centers (PMC) Rule   2008-09-03T04:00:00Z 2008 9 2008-09-03T04:00:00Z   2011-02-16T19:32:33Z E8-20401 0 0 09000064806ee233
NRCS-2011-0007-0001 NRCS Compliance with NEPA NRCS-2011-0007 Regulations for Complying With the National Environmental Policy Act Rule   2008-06-25T04:00:00Z 2008 6 2008-06-25T04:00:00Z 2008-07-26T03:59:59Z 2011-06-11T17:51:49Z E8-14122 0 0 090000648063bc9c
NRCS-2011-0008-0001 NRCS Plant Materials Centers NRCS-2011-0008 Plant Materials Centers Rule   2007-12-06T05:00:00Z 2007 12 2007-12-06T05:00:00Z   2011-02-16T19:31:08Z E7-23525 0 0 0900006480370d25
NRCS-2006-0028-0001 NRCS Healthy Forests Reserve Program; Correction NRCS-2006-0028 Healthy Forests Reserve Program; Correction Rule   2006-07-05T04:00:00Z 2006 7 2006-07-05T04:00:00Z   2006-09-02T22:03:12Z E6-10462 0 0 0900006480195ad9
NRCS-2006-0019-0001 NRCS Healthy Forests Reserve Program NRCS-2006-0019 Healthy Forests Reserve Program Rule   2006-05-17T04:00:00Z 2006 5 2006-05-17T04:00:00Z 2006-08-16T03:59:59Z 2006-09-02T22:02:58Z 06-04587 0 0 090000648017419e
NRCS-2006-0018-0001 NRCS Appeal Procedures NRCS-2006-0018 Appeal Procedures Rule   2006-05-16T04:00:00Z 2006 5 2006-05-16T04:00:00Z 2006-06-16T03:59:59Z 2011-06-11T17:51:38Z 06-04572 0 0 0900006480172ee8

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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;