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

80 rows where docket_id = "DOT-OST-2011-0132" sorted by posted_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

posted_year 15

  • 2011 16
  • 2025 9
  • 2015 7
  • 2021 7
  • 2023 6
  • 2012 5
  • 2017 5
  • 2020 5
  • 2014 4
  • 2019 4
  • 2013 3
  • 2018 3
  • 2022 3
  • 2024 2
  • 2016 1

document_type 1

  • Other 80

agency_id 1

  • DOT 80
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
DOT-OST-2011-0132-0081 DOT None DOT-OST-2011-0132 Amended Notice Regarding the Essential Air Service and Alternate Essential Air Service Programs Other Letter(s) 2025-11-17T05:00:00Z 2025 11 2025-11-17T05:00:00Z   2025-11-17T23:17:12Z   0 0 09000064b9086455
DOT-OST-2011-0132-0080 DOT None DOT-OST-2011-0132 Waterloo Regional Airport Board (Correspondence) Other Correspondence 2025-11-04T05:00:00Z 2025 11 2025-11-04T05:00:00Z   2025-11-04T20:05:52Z   1 0 09000064b9069234
DOT-OST-2011-0132-0079 DOT None DOT-OST-2011-0132 City of Waterloo, Iowa (Correspondence) Other Correspondence 2025-11-04T05:00:00Z 2025 11 2025-11-04T05:00:00Z   2025-11-04T20:05:01Z   1 0 09000064b9069232
DOT-OST-2011-0132-0078 DOT None DOT-OST-2011-0132 Amended Notice of Additional Funding for the Essential Air Service and Alternate Essential Air Service Programs Other Letter(s) 2025-10-30T04:00:00Z 2025 10 2025-10-30T04:00:00Z   2025-10-30T21:12:07Z   1 0 09000064b905bc8f
DOT-OST-2011-0132-0076 DOT None DOT-OST-2011-0132 Request for Community Comments Other Request 2025-10-15T04:00:00Z 2025 10 2025-10-15T04:00:00Z   2025-10-15T17:19:24Z   1 0 09000064b901b754
DOT-OST-2011-0132-0077 DOT None DOT-OST-2011-0132 SkyWest Airlines (Proposal) Other Proposal(s) 2025-10-15T04:00:00Z 2025 10 2025-10-15T04:00:00Z   2025-10-15T17:22:33Z   1 0 09000064b901b756
DOT-OST-2011-0132-0075 DOT None DOT-OST-2011-0132 Amended Notice of Additional Funding for the Essential Air Service and Alternate Essential Air Service Programs Other Letter(s) 2025-10-09T04:00:00Z 2025 10 2025-10-09T04:00:00Z   2025-10-09T18:55:16Z   1 0 09000064b8fff388
DOT-OST-2011-0132-0074 DOT None DOT-OST-2011-0132 Notice of Funding Lapse and Impacts on the Essential Air Service and Alternate Air Service Programs Other Letter(s) 2025-10-07T04:00:00Z 2025 10 2025-10-07T04:00:00Z   2025-10-07T22:15:49Z   0 0 09000064b8ff8a42
DOT-OST-2011-0132-0073 DOT None DOT-OST-2011-0132 2025-9-7 Order Requesting Proposals Other Order 2025-09-12T04:00:00Z 2025 9 2025-09-12T04:00:00Z 2025-09-13T03:59:59Z 2025-09-16T19:27:48Z   1 0 09000064b8f76020
DOT-OST-2011-0132-0072 DOT None DOT-OST-2011-0132 Boutique Air (Petition for Reconsideration of Order 2024-2-18) Other Petition(s) 2024-03-06T05:00:00Z 2024 3 2024-03-06T05:00:00Z   2024-11-12T22:26:45Z   1 0 0900006486464e70
DOT-OST-2011-0132-0071 DOT None DOT-OST-2011-0132 2024-2-18 Order Selecting Air Carrier Other Order 2024-02-22T05:00:00Z 2024 2 2024-02-22T05:00:00Z   2024-11-12T22:24:13Z   1 0 09000064864257e8
DOT-OST-2011-0132-0070 DOT None DOT-OST-2011-0132 City of Waterloo, Iowa (Correspondence) Other Correspondence 2023-12-21T05:00:00Z 2023 12 2023-12-21T05:00:00Z   2024-11-12T06:25:19Z   1 0 090000648634e7cd
DOT-OST-2011-0132-0069 DOT None DOT-OST-2011-0132 Sun Country Airlines (Proposal) Other Proposal(s) 2023-11-28T05:00:00Z 2023 11 2023-11-28T05:00:00Z   2024-11-12T06:23:06Z   1 0 09000064862bc60d
DOT-OST-2011-0132-0067 DOT None DOT-OST-2011-0132 American Airlines, Inc. (Proposal) Other Proposal(s) 2023-11-28T05:00:00Z 2023 11 2023-11-28T05:00:00Z   2024-11-12T06:23:06Z   1 0 09000064862bc609
DOT-OST-2011-0132-0066 DOT None DOT-OST-2011-0132 Request for Community Comments Other Request 2023-11-28T05:00:00Z 2023 11 2023-11-28T05:00:00Z   2024-11-12T06:23:06Z   1 0 09000064862bc607
DOT-OST-2011-0132-0068 DOT None DOT-OST-2011-0132 Boutique Air (Proposal) Other Proposal(s) 2023-11-28T05:00:00Z 2023 11 2023-11-28T05:00:00Z   2024-11-12T06:23:06Z   1 0 09000064862bc60b
DOT-OST-2011-0132-0065 DOT None DOT-OST-2011-0132 2023-10-6 Order Requesting Proposals Other Order 2023-10-24T04:00:00Z 2023 10 2023-10-24T04:00:00Z   2024-11-12T06:19:57Z   1 0 090000648612f1a1
DOT-OST-2011-0132-0064 DOT None DOT-OST-2011-0132 2022-1-16 Order Selecting Air Carrier Other Order 2022-01-21T05:00:00Z 2022 1 2022-01-21T05:00:00Z   2024-11-07T00:34:28Z   1 0 0900006484f2e0d4
DOT-OST-2011-0132-0063 DOT None DOT-OST-2011-0132 Ex Parte Correspondence to Honorable Charles Grassley, Honorable Joni K. Ernst, and Honorable Ashley Hinson Other Correspondence 2022-01-13T05:00:00Z 2022 1 2022-01-13T05:00:00Z   2024-11-12T23:32:37Z   1 0 0900006484f1f058
DOT-OST-2011-0132-0062 DOT None DOT-OST-2011-0132 City of Waterloo, Iowa (Correspondence) Other Correspondence 2022-01-04T05:00:00Z 2022 1 2022-01-04T05:00:00Z   2024-11-07T00:35:57Z   1 0 0900006484f0760a
DOT-OST-2011-0132-0061 DOT None DOT-OST-2011-0132 City of Waterloo, Iowa (Correspondence) Other Correspondence 2021-12-10T05:00:00Z 2021 12 2021-12-10T05:00:00Z   2024-11-12T23:35:57Z   1 0 0900006484eb8f7c
DOT-OST-2011-0132-0058 DOT None DOT-OST-2011-0132 American Airlines, Inc. (Proposal) Other Proposal(s) 2021-11-16T05:00:00Z 2021 11 2021-11-16T05:00:00Z   2024-11-12T23:34:32Z   1 0 0900006484e4f8af
DOT-OST-2011-0132-0059 DOT None DOT-OST-2011-0132 Multi-Aero, Inc. dba Air Choice One (Proposal) Other Proposal(s) 2021-11-16T05:00:00Z 2021 11 2021-11-16T05:00:00Z   2024-11-12T23:34:33Z   1 0 0900006484e4f8b1
DOT-OST-2011-0132-0060 DOT None DOT-OST-2011-0132 Request for Community Comments Other Request 2021-11-16T05:00:00Z 2021 11 2021-11-16T05:00:00Z   2024-11-12T23:33:50Z   1 0 0900006484e4fc77
DOT-OST-2011-0132-0057 DOT None DOT-OST-2011-0132 Grant of Request for Extension of Due Date to Submit Proposals Other Agency Response 2021-11-08T05:00:00Z 2021 11 2021-11-08T05:00:00Z   2024-11-07T00:33:09Z   1 0 0900006484e35bc7
DOT-OST-2011-0132-0056 DOT None DOT-OST-2011-0132 2021-10-4 Order Requesting Proposals Other Order 2021-10-06T04:00:00Z 2021 10 2021-10-06T04:00:00Z   2024-11-06T23:51:36Z   1 0 0900006484dbcf16
DOT-OST-2011-0132-0055 DOT None DOT-OST-2011-0132 Notice of Extension Regarding Current Administration and Enforcement of the Essential Air Service Program Other Decision 2021-03-12T05:00:00Z 2021 3 2021-03-17T04:00:00Z   2024-11-12T23:29:54Z   1 0 0900006484a6e949
DOT-OST-2011-0132-0054 DOT None DOT-OST-2011-0132 Notice of Third Extension Regarding Current Administration and Enforcement of the Essential Air Service Program Other Decision 2020-12-23T05:00:00Z 2020 12 2020-12-23T05:00:00Z   2024-11-12T23:27:25Z   1 0 09000064849c5e9f
DOT-OST-2011-0132-0053 DOT None DOT-OST-2011-0132 Notice of Second Extension Regarding Current Administration and Enforcement of the Essential Air Service Program Other Decision 2020-09-22T04:00:00Z 2020 9 2020-09-22T04:00:00Z   2024-11-06T23:38:52Z   1 0 090000648486f399
DOT-OST-2011-0132-0052 DOT None DOT-OST-2011-0132 Notice of Extension Regarding Current Administration and Enforcement of the Essential Air Service Program Other Decision 2020-06-05T04:00:00Z 2020 6 2020-06-05T04:00:00Z   2024-11-12T23:21:39Z   1 0 09000064846d0cdb
DOT-OST-2011-0132-0051 DOT None DOT-OST-2011-0132 Notice Regarding Current Administration and Enforcement of the Essential Air Service Program Other Decision 2020-04-29T04:00:00Z 2020 4 2020-04-29T04:00:00Z   2024-11-12T23:19:01Z   1 0 090000648450d162
DOT-OST-2011-0132-0050 DOT None DOT-OST-2011-0132 2020-2-10 Order Selecting Carrier Other Order 2020-02-18T05:00:00Z 2020 2 2020-02-18T05:00:00Z   2024-11-06T23:32:00Z   1 0 090000648437f89e
DOT-OST-2011-0132-0049 DOT None DOT-OST-2011-0132 City of Waterloo, Iowa (Correspondence) Other Correspondence 2019-11-19T05:00:00Z 2019 11 2019-11-19T05:00:00Z   2024-11-12T23:12:45Z   1 0 090000648417f2ef
DOT-OST-2011-0132-0047 DOT None DOT-OST-2011-0132 American Airlines (Proposal) Other Proposal(s) 2019-10-16T04:00:00Z 2019 10 2019-10-16T04:00:00Z   2024-11-12T23:11:21Z   1 0 09000064840a79a4
DOT-OST-2011-0132-0048 DOT None DOT-OST-2011-0132 Request for Community Comments Other Request 2019-10-16T04:00:00Z 2019 10 2019-10-16T04:00:00Z   2024-11-12T23:10:04Z   1 0 09000064840a7599
DOT-OST-2011-0132-0046 DOT None DOT-OST-2011-0132 2019-9-6 Order Requesting Proposals Other Order 2019-09-13T04:00:00Z 2019 9 2019-09-13T04:00:00Z   2024-11-12T23:07:42Z   1 0 0900006483f590ca
DOT-OST-2011-0132-0045 DOT None DOT-OST-2011-0132 Ex Parte Correspondence to Honorable Charles E. Grassley Other Correspondence 2018-02-22T05:00:00Z 2018 2 2018-02-22T05:00:00Z   2024-11-07T01:23:08Z   1 0 0900006482f5342c
DOT-OST-2011-0132-0044 DOT None DOT-OST-2011-0132 Ex Parte Correspondence to Honorable Charles E. Grassley Other Correspondence 2018-02-05T05:00:00Z 2018 2 2018-02-05T05:00:00Z   2024-11-07T01:21:06Z   1 0 0900006482eed9e7
DOT-OST-2011-0132-0043 DOT None DOT-OST-2011-0132 2018-1-4 Order Re-Selecting Air Carrier Other Order 2018-01-05T05:00:00Z 2018 1 2018-01-05T05:00:00Z   2024-11-07T01:15:58Z   1 0 0900006482d9e269
DOT-OST-2011-0132-0042 DOT None DOT-OST-2011-0132 City of Waterloo, Iowa (Correspondence) Other Correspondence 2017-12-05T05:00:00Z 2017 12 2017-12-05T05:00:00Z   2024-11-07T01:14:12Z   1 0 0900006482ce1b9c
DOT-OST-2011-0132-0040 DOT None DOT-OST-2011-0132 SkyWest Airlines (Proposal) Other Proposal(s) 2017-10-19T04:00:00Z 2017 10 2017-10-19T04:00:00Z   2024-11-07T00:58:35Z   1 0 0900006482be497e
DOT-OST-2011-0132-0041 DOT None DOT-OST-2011-0132 Request for Community Comments Other Request 2017-10-19T04:00:00Z 2017 10 2017-10-19T04:00:00Z   2024-11-07T00:58:35Z   1 0 0900006482be497f
DOT-OST-2011-0132-0039 DOT None DOT-OST-2011-0132 American Airlines (Proposal) Other Proposal(s) 2017-10-19T04:00:00Z 2017 10 2017-10-19T04:00:00Z   2024-11-07T00:58:35Z   1 0 0900006482be497d
DOT-OST-2011-0132-0038 DOT None DOT-OST-2011-0132 2017-8-17 Order Requesting Proposals Other Order 2017-08-15T04:00:00Z 2017 8 2017-08-15T04:00:00Z   2024-11-07T01:08:44Z   1 0 0900006482a36f4b
DOT-OST-2011-0132-0037 DOT None DOT-OST-2011-0132 2016-5-8 Order Requesting Applications Other Order 2016-05-17T04:00:00Z 2016 5 2016-05-17T04:00:00Z   2024-11-07T23:42:15Z   1 0 0900006481fcc242
DOT-OST-2011-0132-0036 DOT None DOT-OST-2011-0132 2015-12-16 Order Re-Selecting Air Carrier Other Order 2015-12-23T05:00:00Z 2015 12 2015-12-23T05:00:00Z   2024-11-11T21:17:05Z   1 0 0900006481dce9b2
DOT-OST-2011-0132-0035 DOT None DOT-OST-2011-0132 Council of the City of Waterloo, Iowa (Correspondence) Other Correspondence 2015-12-22T05:00:00Z 2015 12 2015-12-22T05:00:00Z   2024-11-11T21:12:49Z   1 0 0900006481dc39c7
DOT-OST-2011-0132-0034 DOT None DOT-OST-2011-0132 City of Waterloo, Iowa (Comments) Other Correspondence 2015-11-27T05:00:00Z 2015 11 2015-11-27T05:00:00Z   2024-11-07T23:32:34Z   1 0 0900006481d74724
DOT-OST-2011-0132-0033 DOT None DOT-OST-2011-0132 University of Northern Iowa (Correspondence) Other Correspondence 2015-11-25T05:00:00Z 2015 11 2015-11-25T05:00:00Z   2024-11-07T23:36:00Z   1 0 0900006481d72098
DOT-OST-2011-0132-0030 DOT None DOT-OST-2011-0132 American Airlines Proposal to Provide Essential Air Service at Waterloo, Iowa Other Proposal(s) 2015-11-06T05:00:00Z 2015 11 2015-11-06T05:00:00Z   2024-11-07T23:27:11Z   1 0 0900006481d1afc3
DOT-OST-2011-0132-0031 DOT None DOT-OST-2011-0132 Request for Comments Other Request 2015-11-06T05:00:00Z 2015 11 2015-11-06T05:00:00Z   2024-11-07T23:28:50Z   1 0 0900006481d1b5c2
DOT-OST-2011-0132-0029 DOT None DOT-OST-2011-0132 2015-10-2 Order Requesting Proposals Other Order 2015-10-05T04:00:00Z 2015 10 2015-10-05T04:00:00Z   2024-11-07T23:28:04Z   1 0 0900006481cb152a
DOT-OST-2011-0132-0028 DOT None DOT-OST-2011-0132 2014-3-14 Order Selecting Carrier Other Order 2014-03-28T04:00:00Z 2014 3 2014-03-28T04:00:00Z   2024-11-11T20:50:06Z   1 0 090000648168a1d1
DOT-OST-2011-0132-0027 DOT None DOT-OST-2011-0132 G. Gayden (Correspondence) Other Correspondence 2014-01-14T05:00:00Z 2014 1 2014-01-14T05:00:00Z   2024-11-07T23:02:17Z   1 0 09000064815023b2
DOT-OST-2011-0132-0025 DOT None DOT-OST-2011-0132 Waterloo Regional Airport (Comments) Other Correspondence 2014-01-09T05:00:00Z 2014 1 2014-01-09T05:00:00Z   2024-11-07T23:01:23Z   1 0 09000064814f0b3f
DOT-OST-2011-0132-0026 DOT None DOT-OST-2011-0132 City of Waterloo, Iowa (Comments) Other Correspondence 2014-01-09T05:00:00Z 2014 1 2014-01-09T05:00:00Z   2024-11-07T23:00:08Z   1 0 09000064814f0b41
DOT-OST-2011-0132-0023 DOT None DOT-OST-2011-0132 American Airlines Proposal to Provide Essential Air Service at Waterloo, Iowa Other Proposal(s) 2013-12-04T05:00:00Z 2013 12 2013-12-04T05:00:00Z   2024-11-12T05:24:11Z   1 0 09000064814a603f
DOT-OST-2011-0132-0024 DOT None DOT-OST-2011-0132 Request for Comments Other Request 2013-12-04T05:00:00Z 2013 12 2013-12-04T05:00:00Z   2024-11-12T05:23:35Z   1 0 09000064814a6475
DOT-OST-2011-0132-0022 DOT None DOT-OST-2011-0132 2013-11-3 Order Requesting Proposal Other Order 2013-11-01T04:00:00Z 2013 11 2013-11-01T04:00:00Z   2024-11-12T05:22:11Z   1 0 090000648146cab3
DOT-OST-2011-0132-0021 DOT None DOT-OST-2011-0132 Order 2012-10-8 Setting Final Rates Other Order 2012-10-04T04:00:00Z 2012 10 2012-10-04T04:00:00Z   2024-11-12T05:07:58Z   1 0 0900006481134b8f
DOT-OST-2011-0132-0020 DOT None DOT-OST-2011-0132 Memorandum Other Memo 2012-04-02T04:00:00Z 2012 4 2012-04-02T04:00:00Z   2024-11-07T22:36:02Z   1 0 0900006480fe5cfc
DOT-OST-2011-0132-0019 DOT None DOT-OST-2011-0132 Order 2012-3-15 Extending Service Obligation Other Order 2012-03-23T04:00:00Z 2012 3 2012-03-23T04:00:00Z   2024-11-12T04:46:00Z   1 0 0900006480fdfdfa
DOT-OST-2011-0132-0018 DOT None DOT-OST-2011-0132 2012-2-19 Order Extending Service Obligation Other Order 2012-02-23T05:00:00Z 2012 2 2012-02-23T05:00:00Z   2024-11-12T04:35:48Z   1 0 0900006480fbec67
DOT-OST-2011-0132-0017 DOT None DOT-OST-2011-0132 Order 2012-1-32 Extending Service Obligation Other Order 2012-01-31T05:00:00Z 2012 1 2012-01-31T05:00:00Z   2012-01-31T19:00:36Z   0 0 0900006480fa9f63
DOT-OST-2011-0132-0016 DOT None DOT-OST-2011-0132 2011-12-25 Order Extending Service Obligation Other Order 2011-12-29T05:00:00Z 2011 12 2011-12-29T05:00:00Z   2024-11-12T04:42:16Z   1 0 0900006480f8af79
DOT-OST-2011-0132-0015 DOT None DOT-OST-2011-0132 2011-12-2 Order Selecting Carrier Other Order 2011-12-08T05:00:00Z 2011 12 2011-12-08T05:00:00Z   2011-12-09T14:43:08Z   0 0 0900006480f7ecbd
DOT-OST-2011-0132-0014 DOT None DOT-OST-2011-0132 Scott Krebsbach Other Correspondence 2011-12-08T05:00:00Z 2011 12 2011-12-08T05:00:00Z   2013-07-28T00:09:54Z   0 0 0900006480f7bdf5
DOT-OST-2011-0132-0011 DOT None DOT-OST-2011-0132 Greater Cedar Valley Alliance & Chamber Other Correspondence 2011-12-05T05:00:00Z 2011 12 2011-12-05T05:00:00Z   2013-03-06T03:55:05Z   0 0 0900006480f76d96
DOT-OST-2011-0132-0012 DOT None DOT-OST-2011-0132 Summary of Business & Institutional Preference EAS Choice- Watterloo Regional Airport Other Summary (SUM) 2011-12-05T05:00:00Z 2011 12 2011-12-05T05:00:00Z   2013-03-06T03:55:05Z   0 0 0900006480f7630a
DOT-OST-2011-0132-0013 DOT None DOT-OST-2011-0132 Marcia and John Milner-Brage Other Correspondence 2011-12-05T05:00:00Z 2011 12 2011-12-05T05:00:00Z   2024-11-11T21:35:51Z   1 0 0900006480f7b93c
DOT-OST-2011-0132-0010 DOT None DOT-OST-2011-0132 Order 2011-11-33 Extending Service Obligation Other Order 2011-12-01T05:00:00Z 2011 12 2011-12-01T05:00:00Z   2011-12-01T16:52:13Z   0 0 0900006480f789f2
DOT-OST-2011-0132-0009 DOT None DOT-OST-2011-0132 Waterloo Regional Airport (Support Comments) Other Correspondence 2011-11-28T05:00:00Z 2011 11 2011-11-28T05:00:00Z   2024-11-11T21:37:07Z   1 0 0900006480f7467e
DOT-OST-2011-0132-0008 DOT None DOT-OST-2011-0132 Honorable Buck Clark Other Correspondence 2011-11-28T05:00:00Z 2011 11 2011-11-28T05:00:00Z   2013-03-06T03:55:03Z   0 0 0900006480f7077e
DOT-OST-2011-0132-0007 DOT None DOT-OST-2011-0132 Order 2011-11-8 Extending Service Obligation Other Order 2011-11-07T05:00:00Z 2011 11 2011-11-07T05:00:00Z   2024-11-12T05:04:15Z   1 0 0900006480f670f6
DOT-OST-2011-0132-0006 DOT None DOT-OST-2011-0132 Request for Comment, Waterloo Other Request 2011-10-24T04:00:00Z 2011 10 2011-10-24T04:00:00Z   2013-08-11T03:17:47Z   0 0 0900006480f5a453
DOT-OST-2011-0132-0004 DOT None DOT-OST-2011-0132 American Eagle Airlines Proposal to Provide Essential Air Service at Waterloo, Iowa Other Proposal(s) 2011-10-18T04:00:00Z 2011 10 2011-10-18T04:00:00Z   2024-11-07T22:45:18Z   1 0 0900006480f5378a
DOT-OST-2011-0132-0005 DOT None DOT-OST-2011-0132 SkyWest Airlines' Essential Air Service Proposal for Butt, Bemidji, Sioux City, Aberdeen and Waterloo, Montana Other Proposal(s) 2011-10-18T04:00:00Z 2011 10 2011-10-18T04:00:00Z   2024-11-07T22:43:29Z   1 0 0900006480f54c54
DOT-OST-2011-0132-0003 DOT None DOT-OST-2011-0132 Notice of Extension Other Extension of Time 2011-10-12T04:00:00Z 2011 10 2011-10-12T04:00:00Z   2024-11-12T05:03:17Z   1 0 0900006480f50a89
DOT-OST-2011-0132-0002 DOT None DOT-OST-2011-0132 Order 2011-9-5 Prohibiting Suspension Of Service And Requesting Proposals Other Order 2011-09-13T04:00:00Z 2011 9 2011-09-13T04:00:00Z   2011-09-13T16:56:53Z   0 0 0900006480f173a2
DOT-OST-2011-0132-0001 DOT None DOT-OST-2011-0132 Ninety-Day Notice of Termination of Service Other Letter(s) 2011-07-18T04:00:00Z 2011 7 2011-07-18T04:00:00Z   2024-11-07T22:34:09Z   1 0 0900006480ec3690

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 15.062ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API