home / openregs

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

59 rows where docket_id = "FMCSA-2003-14223" sorted by posted_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, subtype, posted_month, open_for_comment, posted_date (date), comment_start_date (date), comment_end_date (date), last_modified (date)

posted_year 16

  • 2009 10
  • 2007 8
  • 2021 6
  • 2011 5
  • 2005 4
  • 2017 4
  • 2019 4
  • 2008 3
  • 2013 3
  • 2015 3
  • 2003 2
  • 2010 2
  • 2018 2
  • 2012 1
  • 2014 1
  • 2016 1

document_type 2

  • Rule 34
  • Notice 25

agency_id 1

  • FMCSA 59
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
FMCSA-2003-14223-0072 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications: Vision Notice Notice of Intent 2021-12-10T05:00:00Z 2021 12 2021-12-10T05:00:00Z   2024-11-07T00:35:19Z 2021-26797 1 0 0900006484eb8637
FMCSA-2003-14223-0071 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications: Vision Notice Request for Comments 2021-09-29T04:00:00Z 2021 9 2021-09-29T04:00:00Z 2021-09-04T03:59:59Z 2024-11-07T00:31:19Z 2021-16540 1 0 0900006484db1995
FMCSA-2003-14223-0070 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications: Vision Notice Request for Comments 2021-08-05T04:00:00Z 2021 8 2021-08-05T04:00:00Z 2021-09-04T03:59:59Z 2024-11-06T23:50:03Z 2021-16540 1 0 0900006484c2cb3a
FMCSA-2003-14223-0069 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications: Vision Notice Notice of Intent 2021-08-05T04:00:00Z 2021 8 2021-08-05T04:00:00Z   2021-08-05T13:26:53Z 2021-12341 0 0 0900006484baea0b
FMCSA-2003-14223-0068 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications: Vision Notice Notice of Final Rule 2021-05-13T04:00:00Z 2021 5 2021-05-13T04:00:00Z   2024-11-12T23:30:36Z 2021-10096 1 0 0900006484af9920
FMCSA-2003-14223-0067 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications: Vision Notice Request for Comments 2021-03-25T04:00:00Z 2021 3 2021-03-25T04:00:00Z 2021-04-27T03:59:59Z 2024-11-12T23:29:58Z 2021-06149 1 0 0900006484a7a31e
FMCSA-2003-14223-0066 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications: Vision Notice Notice of Docketing 2019-08-05T04:00:00Z 2019 8 2019-08-05T04:00:00Z   2024-11-12T23:05:34Z 2019-16644 1 0 0900006483df57b8
FMCSA-2003-14223-0064 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications: Vision Notice Request for Comments 2019-05-14T04:00:00Z 2019 5 2019-05-14T04:00:00Z 2019-06-14T03:59:59Z 2024-11-12T23:00:59Z 2019-09938 1 0 0900006483c7b505
FMCSA-2003-14223-0065 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications: Vision Notice Notice of Intent 2019-05-14T04:00:00Z 2019 5 2019-05-14T04:00:00Z   2024-11-12T23:01:48Z 2019-09939 1 0 0900006483c7b9f3
FMCSA-2003-14223-0063 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications: Vision Notice Request for Comments 2019-03-20T04:00:00Z 2019 3 2019-03-20T04:00:00Z 2019-04-20T03:59:59Z 2024-11-12T22:57:34Z 2019-05296 1 0 0900006483b06393
FMCSA-2003-14223-0062 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications: Vision Notice Notice of Docketing 2018-05-30T04:00:00Z 2018 5 2018-05-30T04:00:00Z   2024-11-07T01:26:55Z 2018-11409 1 0 0900006483310a07
FMCSA-2003-14223-0061 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications: Vision Notice Request for Comments 2018-02-15T05:00:00Z 2018 2 2018-02-15T05:00:00Z 2018-03-20T03:59:59Z 2024-11-07T01:22:23Z 2018-03060 1 0 0900006482f34d36
FMCSA-2003-14223-0060 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications: Vision Notice Notice of Intent 2017-07-27T04:00:00Z 2017 7 2017-07-27T04:00:00Z   2024-11-07T01:07:36Z 2017-15830 1 0 09000064829770da
FMCSA-2003-14223-0059 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications: Vision Notice Notice of Intent 2017-05-23T04:00:00Z 2017 5 2017-05-23T04:00:00Z   2024-11-07T00:59:48Z 2017-10566 1 0 0900006482600f34
FMCSA-2003-14223-0058 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications: Vision Notice Notice of Intent 2017-04-21T04:00:00Z 2017 4 2017-04-21T04:00:00Z 2017-05-23T03:59:59Z 2017-04-21T15:00:52Z 2017-08079 0 0 0900006482566c3a
FMCSA-2003-14223-0057 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications: Vision Notice Request for Comments 2017-03-27T04:00:00Z 2017 3 2017-03-27T04:00:00Z 2017-04-27T03:59:59Z 2024-11-07T00:55:07Z 2017-05970 1 0 0900006482529178
FMCSA-2003-14223-0056 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications: Vision Notice Notice of Docketing 2016-11-23T05:00:00Z 2016 11 2016-11-23T05:00:00Z   2024-11-12T06:16:07Z 2016-28228 1 0 09000064823bc92f
FMCSA-2003-14223-0055 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications: Vision Notice Request for Comments 2015-11-02T05:00:00Z 2015 11 2015-11-02T05:00:00Z 2015-12-03T04:59:59Z 2024-11-12T05:49:10Z 2015-27884 1 0 0900006481d0285a
FMCSA-2003-14223-0053 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications: Vision Notice Request for Comments 2015-03-27T04:00:00Z 2015 3 2015-03-27T04:00:00Z 2015-04-28T03:59:59Z 2024-11-07T23:15:19Z 2015-07049 1 0 0900006481a6c396
FMCSA-2003-14223-0052 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications: Vision Notice Request for Comments 2015-03-27T04:00:00Z 2015 3 2015-03-27T04:00:00Z 2015-04-28T03:59:59Z 2024-11-12T05:34:38Z 2015-07046 1 0 0900006481a6c65c
FMCSA-2003-14223-0051 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications: Vision Notice Request for Comments 2014-07-02T04:00:00Z 2014 7 2014-07-02T04:00:00Z 2014-08-02T03:59:59Z 2024-11-12T05:26:40Z 2014-15570 1 0 0900006481786ed5
FMCSA-2003-14223-0050 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications: Vision Notice Request for Comments 2013-12-26T05:00:00Z 2013 12 2013-12-26T05:00:00Z 2014-01-28T04:59:59Z 2024-11-07T23:00:43Z 2013-30852 1 0 09000064814dc4e8
FMCSA-2003-14223-0049 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications: Vision Notice Request for Comments 2013-04-16T04:00:00Z 2013 4 2013-04-16T04:00:00Z 2013-05-17T03:59:59Z 2024-11-11T20:44:56Z 2013-08878 1 0 0900006481295f55
FMCSA-2003-14223-0048 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications: Vision Notice Request for Comments 2013-03-27T04:00:00Z 2013 3 2013-03-27T04:00:00Z 2013-04-27T03:59:59Z 2024-11-07T22:47:54Z 2013-07105 1 0 0900006481247ad2
FMCSA-2003-14223-0047 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications; Vision Notice Request for Comments 2012-07-11T04:00:00Z 2012 7 2012-07-11T04:00:00Z 2012-08-11T03:59:59Z 2024-11-07T22:41:52Z 2012-16889 1 0 0900006481086c75
FMCSA-2003-14223-0045 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications; Vision Rule Federal Register Publication 2011-06-10T04:00:00Z 2011 6 2011-06-10T04:00:00Z 2011-07-12T03:59:59Z 2011-06-10T13:27:31Z 2011-14463 0 0 0900006480e441a8
FMCSA-2003-14223-0046 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications; Vision Rule Federal Register Publication 2011-06-10T04:00:00Z 2011 6 2011-06-10T04:00:00Z 2011-07-12T03:59:59Z 2011-06-10T13:34:03Z 2011-14461 0 0 0900006480e441b0
FMCSA-2003-14223-0044 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications; Vision Rule Federal Register Publication 2011-05-05T04:00:00Z 2011 5 2011-05-05T04:00:00Z 2011-06-07T03:59:59Z 2011-05-05T13:20:49Z 2011-11007 0 0 0900006480c3fe44
FMCSA-2003-14223-0043 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications; Vision Rule Federal Register Publication 2011-04-18T04:00:00Z 2011 4 2011-04-18T04:00:00Z 2011-05-19T03:59:59Z 2011-04-18T14:57:20Z 2011-09321 0 0 0900006480c2ec0f
FMCSA-2003-14223-0042 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications; Vision Rule Federal Register Publication 2011-03-29T04:00:00Z 2011 3 2011-03-29T04:00:00Z 2011-04-29T03:59:59Z 2024-11-12T04:57:37Z 2011-07252 1 0 0900006480c12843
FMCSA-2003-14223-0041 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualifications of Drivers: Exemption Renewals; Vision Rule Federal Register Publication 2010-08-24T04:00:00Z 2010 8 2010-08-24T04:00:00Z   2010-08-24T15:08:42Z 2010-20973 0 0 0900006480b391bb
FMCSA-2003-14223-0040 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications; Vision Rule Federal Register Publication 2010-07-06T04:00:00Z 2010 7 2010-07-06T04:00:00Z 2010-08-03T03:59:59Z 2024-11-07T22:19:07Z 2010-16180 1 0 0900006480b138d1
FMCSA-2003-14223-0039 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Renewals; Vision Rule Federal Register Publication 2009-09-01T04:00:00Z 2009 9 2009-09-01T04:00:00Z   2018-03-23T18:27:21Z E9-21018 0 0 0900006480a1a717
FMCSA-2003-14223-0038 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Renewals; Vision Rule Federal Register Publication 2009-07-29T04:00:00Z 2009 7 2009-07-29T04:00:00Z   2009-07-29T17:49:15Z E9-17975 0 0 09000064809fd73f
FMCSA-2003-14223-0037 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Renewals; Vision Rule Federal Register Publication 2009-07-28T04:00:00Z 2009 7 2009-07-28T04:00:00Z   2009-07-28T19:21:02Z E9-17972 0 0 09000064809fc49a
FMCSA-2003-14223-0036 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications; Vision Rule Federal Register Publication 2009-07-15T04:00:00Z 2009 7 2009-07-15T04:00:00Z 2009-08-15T03:59:59Z 2009-07-15T18:19:15Z E9-16593 0 0 09000064809f2046
FMCSA-2003-14223-0034 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications; Vision Rule Interim Final Rule 2009-06-02T04:00:00Z 2009 6 2009-06-02T04:00:00Z 2009-07-03T03:59:59Z 2009-06-02T16:51:00Z E9-12774 0 0 09000064809c28ee
FMCSA-2003-14223-0035 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications; Vision Rule Federal Register Publication 2009-06-02T04:00:00Z 2009 6 2009-06-02T04:00:00Z 2009-07-03T03:59:59Z 2009-06-02T18:34:31Z E9-12773 0 0 09000064809c3227
FMCSA-2003-14223-0033 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Renewals; Vision Rule Federal Register Publication 2009-05-05T04:00:00Z 2009 5 2009-05-05T04:00:00Z   2009-05-05T16:36:31Z E9-10339 0 0 0900006480975ea4
FMCSA-2003-14223-0032 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications; Vision Rule Federal Register Publication 2009-04-28T04:00:00Z 2009 4 2009-04-28T04:00:00Z 2009-05-29T03:59:59Z 2009-04-28T18:27:32Z E9-09613 0 0 090000648096e619
FMCSA-2003-14223-0031 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications; Vision Rule Federal Register Publication 2009-03-20T04:00:00Z 2009 3 2009-03-20T04:00:00Z 2009-04-21T03:59:59Z 2009-03-20T20:03:54Z E9-06060 0 0 0900006480923f41
FMCSA-2003-14223-0030 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Renewals; Vision Correction Rule Federal Register Publication 2009-02-06T05:00:00Z 2009 2 2009-02-06T05:00:00Z   2024-11-12T04:29:22Z E9-02437 1 0 0900006480848b07
FMCSA-2003-14223-0029 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Renewals; Vision Rule Federal Register Publication 2008-09-09T04:00:00Z 2008 9 2008-09-09T04:00:00Z   2024-11-07T21:54:17Z E8-20890 1 0 09000064806fad39
FMCSA-2003-14223-0027 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications; Vision Rule Federal Register Publication 2008-07-21T04:00:00Z 2008 7 2008-07-21T04:00:00Z 2008-08-21T03:59:59Z 2024-11-12T04:15:57Z E8-16618 1 0 090000648068a2bc
FMCSA-2003-14223-0026 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Renewals; Vision Rule Federal Register Publication 2008-01-28T05:00:00Z 2008 1 2008-01-28T05:00:00Z   2024-11-07T21:47:46Z E7-25490 1 0 0900006480381726
FMCSA-2003-14223-0024 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Qualification of Drivers; Exemption Applications; Vision Rule Federal Register Publication 2007-11-15T05:00:00Z 2007 11 2007-11-15T05:00:00Z 2007-12-18T04:59:59Z 2024-11-07T21:49:09Z E7-22352 1 0 0900006480364898
FMCSA-2003-14223-0023 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Notice of Final Disposition Rule Federal Register Publication 2007-08-09T04:00:00Z 2007 8 2007-08-09T04:00:00Z 2007-08-10T03:59:59Z 2024-11-07T16:52:49Z   1 0 09000064802ba967
FMCSA-2003-14223-0022 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Notice of Final Disposition Rule Federal Register Publication 2007-07-24T04:00:00Z 2007 7 2007-07-24T04:00:00Z 2007-07-25T03:59:59Z 2024-11-07T21:44:54Z   1 0 090000648038382d
FMCSA-2003-14223-0019 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Notice of Renewal of Exemptions; Request for Comments Rule Federal Register Publication 2007-06-20T04:00:00Z 2007 6 2007-06-20T04:00:00Z 2007-06-21T03:59:59Z 2024-11-07T16:52:27Z   1 0 09000064802ba963
FMCSA-2003-14223-0016 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Notice of Renewal of Exemptions; Request for Comments Rule Federal Register Publication 2007-06-13T04:00:00Z 2007 6 2007-06-13T04:00:00Z 2007-06-14T03:59:59Z 2024-11-07T16:52:26Z   1 0 09000064802ba960
FMCSA-2003-14223-0015 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Notice of Renewal of Exemptions; Request for Comments Rule Federal Register Publication 2007-05-18T04:00:00Z 2007 5 2007-05-18T04:00:00Z 2007-05-19T03:59:59Z 2024-11-07T21:44:54Z   1 0 090000648038382c
FMCSA-2003-14223-0014 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Notice of Renewal of Exemptions; Request for Comments Rule Federal Register Publication 2007-05-16T04:00:00Z 2007 5 2007-05-16T04:00:00Z 2007-05-17T03:59:59Z 2024-11-07T21:44:54Z   1 0 090000648038382b
FMCSA-2003-14223-0012 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Notice of Renewal of Exemptions; Request for Comments Rule Federal Register Publication 2007-04-13T04:00:00Z 2007 4 2007-04-13T04:00:00Z 2007-04-14T03:59:59Z 2024-11-07T21:44:52Z   1 0 090000648038382a
FMCSA-2003-14223-0010 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 U.S. DOT/FMCSA - Notice of Renewal of Exemption; Request for Comments Rule Federal Register Publication 2005-12-14T05:00:00Z 2005 12 2005-12-14T05:00:00Z 2005-12-15T04:59:59Z 2024-11-07T16:52:26Z   1 0 09000064802ba95d
FMCSA-2003-14223-0008 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 U.S. DOT/FMCSA - Notice of Renewal of Exemption; Request for Comments Rule Federal Register Publication 2005-11-08T05:00:00Z 2005 11 2005-11-08T05:00:00Z 2005-11-09T04:59:59Z 2024-11-07T16:52:50Z   1 0 09000064802ba96c
FMCSA-2003-14223-0007 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 U.S. DOT/FMCSA - Notice of Renewal of Exemption; Request for Comments Rule Federal Register Publication 2005-10-20T04:00:00Z 2005 10 2005-10-20T04:00:00Z 2005-10-21T03:59:59Z 2024-11-07T21:44:54Z   1 0 090000648038382e
FMCSA-2003-14223-0005 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 U.S. DOT/FMCSA - Notice of Renewal of Exemption; Request for Comments Rule Federal Register Publication 2005-05-16T04:00:00Z 2005 5 2005-05-16T04:00:00Z 2005-05-17T03:59:59Z 2024-11-07T16:52:50Z   1 0 09000064802ba96a
FMCSA-2003-14223-0003 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 U.S. DOT/FMCSA - Notice of Final Disposition Rule Federal Register Publication 2003-04-21T04:00:00Z 2003 4 2003-04-21T04:00:00Z 2003-04-22T03:59:59Z 2024-11-07T16:52:50Z   1 0 09000064802ba968
FMCSA-2003-14223-0001 FMCSA Qualification of Drivers; Exemption Applications; Vision FMCSA-2003-14223 Notice of Application for Exemption from the Vision Standard; Request for Comments Rule Federal Register Publication 2003-03-04T05:00:00Z 2003 3 2003-03-04T05:00:00Z 2003-03-05T04:59:59Z 2024-11-07T16:52:26Z   1 0 09000064802ba959

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;
Powered by Datasette · Queries took 768.832ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API