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

62 rows where docket_id = "DOT-OST-2012-0002" and posted_year = 2012 sorted by posted_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

posted_year 1

  • 2012 · 62 ✖

document_type 1

  • Other 62

agency_id 1

  • DOT 62
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-2012-0002-0062 DOT None DOT-OST-2012-0002 2012-12-19 Consent Order (World Travel Network, LLC) - Violations of 14 CFR 399.84 and 49 U.S.C. § 41712 Other Order 2012-12-28T05:00:00Z 2012 12 2012-12-28T05:00:00Z   2024-11-12T05:09:25Z   1 0 090000648119e1f9
DOT-OST-2012-0002-0060 DOT None DOT-OST-2012-0002 2012-12-16 Consent Order (Scott's Air LLC d/b/a Island Air Express) Violations of 49 U.S.C. §§ 41101 and 41712 Other Order 2012-12-28T05:00:00Z 2012 12 2012-12-28T05:00:00Z   2024-11-12T05:11:06Z   1 0 090000648119e02d
DOT-OST-2012-0002-0061 DOT None DOT-OST-2012-0002 2012-12-17 Consent Order Violations of 49 U.S.C. § 41712 and 14 CFR 257.5 and 399.84 Other Order 2012-12-28T05:00:00Z 2012 12 2012-12-28T05:00:00Z   2012-12-28T17:07:41Z   0 0 090000648119e02f
DOT-OST-2012-0002-0059 DOT None DOT-OST-2012-0002 2012-12-1 Consent Order (Vision Airlines, Inc.) Violations of 49 U.S.C. § 41712 and 14 CFR Parts 212 and 380 Other Order 2012-12-05T05:00:00Z 2012 12 2012-12-05T05:00:00Z   2024-11-12T05:08:27Z   1 0 090000648117fefb
DOT-OST-2012-0002-0058 DOT None DOT-OST-2012-0002 2012-11-36 Consent Order - Airtrade International, Inc. (Violations of 49 U.S.C. § 41712, 14 CFR 257.5, and Order 2011-4-21) Other Order 2012-11-30T05:00:00Z 2012 11 2012-11-30T05:00:00Z   2012-11-30T18:31:26Z   0 0 090000648117af5d
DOT-OST-2012-0002-0057 DOT None DOT-OST-2012-0002 2012-11-29 Consent Order (Travelzoo Inc.) - Violations of 49 U.S.C. § 41712 and 14 CFR 257.5 Other Order 2012-11-26T05:00:00Z 2012 11 2012-11-26T05:00:00Z   2024-11-12T05:08:39Z   1 0 090000648117367e
DOT-OST-2012-0002-0056 DOT None DOT-OST-2012-0002 2012-11-27 Consent Order (STI Travel, LLC) Violations of 49 U.S.C. § 41712 and 14 CFR 399.84(a) Other Order 2012-11-23T05:00:00Z 2012 11 2012-11-23T05:00:00Z   2024-11-12T05:10:44Z   1 0 0900006481171ae3
DOT-OST-2012-0002-0055 DOT None DOT-OST-2012-0002 2012-11-26 Consent Order (Malaysia Airline System Bhd) Violations of Article 17 of the Montreal Convention and 49 U.S.C. § 41712 Other Order 2012-11-21T05:00:00Z 2012 11 2012-11-21T05:00:00Z   2024-11-12T05:08:35Z   1 0 09000064811703d3
DOT-OST-2012-0002-0054 DOT None DOT-OST-2012-0002 2012-11-6 Consent Order (AeroSvit Airlines) - Violations of 14 CFR Part 382 and 49 U.S.C. § 41705 Other Order 2012-11-08T05:00:00Z 2012 11 2012-11-08T05:00:00Z   2024-11-11T20:43:42Z   1 0 0900006481162d9d
DOT-OST-2012-0002-0053 DOT None DOT-OST-2012-0002 2012-11-03 Consent Order (Mauiva, LLC) Violations of 49 U.S.C. §§ 41101 and 41712 and 14 CFR Part 380 Other Order 2012-11-06T05:00:00Z 2012 11 2012-11-06T05:00:00Z   2012-11-06T19:13:56Z   0 0 090000648115fee1
DOT-OST-2012-0002-0052 DOT None DOT-OST-2012-0002 2012-11-1 Consent Order (Societe Air France) – Violations of 49 U.S.C. § 41712 and 14 CFR 399.84(a) Other Order 2012-11-01T04:00:00Z 2012 11 2012-11-01T04:00:00Z   2024-11-11T20:42:56Z   1 0 09000064811592bf
DOT-OST-2012-0002-0051 DOT None DOT-OST-2012-0002 2012-10-20 Consent Order - (I-Jet Aviation, LLC) Violations of 49 U.S.C. §§ 41101 and 41712 and 14 CFR Part 399 Other Order 2012-10-19T04:00:00Z 2012 10 2012-10-19T04:00:00Z   2024-11-12T05:05:16Z   1 0 0900006481148da5
DOT-OST-2012-0002-0049 DOT None DOT-OST-2012-0002 2012-10-12 Consent Order (Qantas Airways Limited) - Violations of 14 CFR 399.85(b) and 49 U.S.C. § 41712 Other Order 2012-10-11T04:00:00Z 2012 10 2012-10-11T04:00:00Z   2024-11-11T20:42:30Z   1 0 090000648113cf04
DOT-OST-2012-0002-0050 DOT None DOT-OST-2012-0002 2012-10-13 Consent Order (Worldwide Travel, Inc.) - Violations of 49 U.S.C. § 41712 and 14 CFR 399.84 Other Order 2012-10-11T04:00:00Z 2012 10 2012-10-11T04:00:00Z   2024-11-11T20:41:52Z   1 0 090000648113d570
DOT-OST-2012-0002-0048 DOT None DOT-OST-2012-0002 2012-10-4 Consent Order - 734758 Ontario, Limited, d/b/a FlightNetwork.com - Violations of 49 U.S.C. § 41712 and 14 CFR 399.84 Other Order 2012-10-05T04:00:00Z 2012 10 2012-10-05T04:00:00Z   2024-11-12T05:06:22Z   1 0 0900006481135c6a
DOT-OST-2012-0002-0047 DOT None DOT-OST-2012-0002 2012-10-2 Consent Order - Jetstar Airways Pty Limited Other Order 2012-10-05T04:00:00Z 2012 10 2012-10-05T04:00:00Z   2024-11-11T20:42:08Z   1 0 09000064811353b5
DOT-OST-2012-0002-0046 DOT None DOT-OST-2012-0002 2012-10-3 Consent Order (TEM Enterprises d/b/a Xtra Airways) - Violations of 49 U.S.C. § 41712 and 14 CFR Parts 212 and 380 Other Order 2012-10-02T04:00:00Z 2012 10 2012-10-02T04:00:00Z   2024-11-11T20:41:33Z   1 0 09000064811313a8
DOT-OST-2012-0002-0045 DOT None DOT-OST-2012-0002 2012-10-1 Consent Order (British Airways Plc) - Violations of Articles 17 and 19 of the Montreal Convention, 14 CFR 399.84 and 49 U.S.C. § 41712 Other Order 2012-10-01T04:00:00Z 2012 10 2012-10-01T04:00:00Z   2024-11-12T05:08:07Z   1 0 090000648112ff8e
DOT-OST-2012-0002-0044 DOT None DOT-OST-2012-0002 2012-10-1 Consent Order (British Airways Plc) - 2012-10-1 Consent Order (British Airways Plc) -Violations of Articles 17 and 19 of the Montreal Convention, 14 CFR 399.84 and 49 U.S.C. § 41712 Other   2012-10-01T00:00:00Z 2012 10     2024-11-12T05:07:04Z   0 1 090000648112f6d5
DOT-OST-2012-0002-0043 DOT None DOT-OST-2012-0002 2012-9-21 Consent Order (Pakistan International Airlines Corporation) - Violations of 49 U.S.C. § 41712 and 14 CFR Part 259 Other Order 2012-09-19T04:00:00Z 2012 9 2012-09-19T04:00:00Z   2024-11-12T05:07:01Z   1 0 090000648111f089
DOT-OST-2012-0002-0041 DOT None DOT-OST-2012-0002 2012-9-18 Consent Order (Air China, Limited) - Violations of Article 17 of the Montreal Convention and 49 U.S.C. § 41712 Other Order 2012-09-17T04:00:00Z 2012 9 2012-09-17T04:00:00Z   2024-11-11T20:43:06Z   1 0 090000648111a61a
DOT-OST-2012-0002-0042 DOT None DOT-OST-2012-0002 2012-9-19 Consent Order (Solar Tours, Inc.) - Violations of 49 U.S.C. § 41712 and 14 CFR 257.5 Other Order 2012-09-17T04:00:00Z 2012 9 2012-09-17T04:00:00Z   2024-11-11T20:43:05Z   1 0 090000648111a65d
DOT-OST-2012-0002-0040 DOT None DOT-OST-2012-0002 2012-9-1 Consent Order (JSC Aeroflot) - Violations of 14 CFR 259.5(b)(4) and 399.84(a), and 49 U.S.C. § 41712 Other Order 2012-09-04T04:00:00Z 2012 9 2012-09-04T04:00:00Z   2024-11-11T20:40:53Z   1 0 0900006481100bb0
DOT-OST-2012-0002-0039 DOT None DOT-OST-2012-0002 2012-8-34 Consent Order (Travel Today, Inc.) - Violations of 14 CFR 399.84 and 49 U.S.C. § 41712 Other Order 2012-08-30T04:00:00Z 2012 8 2012-08-30T04:00:00Z   2018-02-23T18:54:46Z   0 0 09000064810fb767
DOT-OST-2012-0002-0038 DOT None DOT-OST-2012-0002 2012-8-33 Consent Order (Aerolineas Argentinas S.A.) - Violations of 14 CFR 399.84(a) and 49 U.S.C. § 41712 Other Order 2012-08-29T04:00:00Z 2012 8 2012-08-29T04:00:00Z   2024-11-11T20:40:33Z   1 0 09000064810f865a
DOT-OST-2012-0002-0037 DOT None DOT-OST-2012-0002 2012-8-28 Consent Order (Royal Jordanian Airlines) - Violations of 14 CFR 399.84(a), 399.85(b), and 49 U.S.C. § 41712 Other Order 2012-08-21T04:00:00Z 2012 8 2012-08-21T04:00:00Z   2024-11-11T20:40:33Z   1 0 09000064810e81e8
DOT-OST-2012-0002-0036 DOT None DOT-OST-2012-0002 2012-8-27 Consent Order (Compagnie Nationale Royal Air Maroc) - Violations of 14 CFR 399.85(b) and 49 U.S.C. § 41712 Other Order 2012-08-21T04:00:00Z 2012 8 2012-08-21T04:00:00Z   2012-08-22T14:03:40Z   0 0 09000064810e81e4
DOT-OST-2012-0002-0035 DOT None DOT-OST-2012-0002 2012-8-26 Consent Order (EgyptAir Airlines Company) - Violations of 14 CFR 399.85(b) and 259.5(b)(4) and 49 U.S.C. § 41712 Other Order 2012-08-21T04:00:00Z 2012 8 2012-08-21T04:00:00Z   2012-08-21T20:04:28Z   0 0 09000064810e81e2
DOT-OST-2012-0002-0033 DOT None DOT-OST-2012-0002 2012-8-24 Consent Order (Orbitz Worldwide, LLC) - Violations of 14 CFR 399.85(b) and 49 U.S.C. § 41712 Other Order 2012-08-20T04:00:00Z 2012 8 2012-08-20T04:00:00Z   2012-08-20T18:24:33Z   0 0 09000064810e55be
DOT-OST-2012-0002-0034 DOT None DOT-OST-2012-0002 2012-8-25 Consent Order (JetBlue Airways Corporation) - Violations of 14 CFR Part 259 and 49 U.S.C. § 41712 Other Order 2012-08-20T04:00:00Z 2012 8 2012-08-20T04:00:00Z   2024-11-11T20:42:21Z   1 0 09000064810e561b
DOT-OST-2012-0002-0032 DOT None DOT-OST-2012-0002 2012-8-4 Consent Order (Santa Barbara Airlines) - Violations of 14 CFR 399.85(b) Other Order 2012-08-02T04:00:00Z 2012 8 2012-08-02T04:00:00Z   2024-11-07T22:44:32Z   1 0 09000064810bf7a9
DOT-OST-2012-0002-0030 DOT None DOT-OST-2012-0002 2012-8-2 Consent Order (Pacific For Less, Inc.) - Violations of 49 U.S.C. § 41712 and 14 CFR 399.84(a) Other Order 2012-08-02T04:00:00Z 2012 8 2012-08-02T04:00:00Z   2024-11-11T20:40:08Z   1 0 09000064810bf9e5
DOT-OST-2012-0002-0031 DOT None DOT-OST-2012-0002 2012-8-3 Consent Order (Philippine Airlines, Inc.) - Violations of 14 CFR 399.84(a) and 49 U.S.C. § 41712 Other Order 2012-08-02T04:00:00Z 2012 8 2012-08-02T04:00:00Z   2024-11-11T20:40:42Z   1 0 09000064810bfa50
DOT-OST-2012-0002-0028 DOT None DOT-OST-2012-0002 2012-7-30 Consent Order (Travel Velocity.com LP) - Violations of 49 U.S.C. § 41712 and 14 CFR 399.84 Other Order 2012-07-27T04:00:00Z 2012 7 2012-07-27T04:00:00Z   2012-07-27T17:52:34Z   0 0 09000064810b4b20
DOT-OST-2012-0002-0029 DOT None DOT-OST-2012-0002 2012-7-31 Consent Order (Caribbean Sun Airlines d/b/a World Atlantic Airlines) - Violations of 49 U.S.C. § 41712 and 14 CFR Parts 212 and 380 Other Order 2012-07-27T04:00:00Z 2012 7 2012-07-27T04:00:00Z   2024-11-07T22:44:48Z   1 0 09000064810b4b29
DOT-OST-2012-0002-0027 DOT None DOT-OST-2012-0002 2012-7-16 Consent Order (Trip Advisor, LLC) - Violations of 49 U.S.C. § 41712 and 14 CFR 257.5 and 399.84(a) Other Order 2012-07-13T04:00:00Z 2012 7 2012-07-13T04:00:00Z   2012-07-13T16:12:14Z   0 0 0900006481095308
DOT-OST-2012-0002-0026 DOT None DOT-OST-2012-0002 2012-7-13 Consent Order (Vision Airlines, Inc.) - Violations of 14 CFR 382 and 399 and 49 U.S.C. §§ 41705 and 41712 Other Order 2012-07-12T04:00:00Z 2012 7 2012-07-12T04:00:00Z   2024-11-07T22:42:00Z   1 0 0900006481089990
DOT-OST-2012-0002-0025 DOT None DOT-OST-2012-0002 2012-7-1 Consent Order (Bahamasair Holdings Limited) - Violations of 49 U.S.C. § 41712 and 14 CFR 221.107(d) and Part 374 Other Order 2012-07-03T04:00:00Z 2012 7 2012-07-03T04:00:00Z   2024-11-07T22:41:53Z   1 0 0900006481078f30
DOT-OST-2012-0002-0024 DOT None DOT-OST-2012-0002 2012-6-15 Consent Order (Concesionaria Vuela Compania de Aviacion, S.A.P.I. de C.V.) - Violations of 14 CFR 399.85(b) and 49 U.S.C. § 41712 Other Order 2012-06-22T04:00:00Z 2012 6 2012-06-22T04:00:00Z   2024-11-07T22:41:24Z   1 0 090000648105ef58
DOT-OST-2012-0002-0023 DOT None DOT-OST-2012-0002 2012-5-22 Consent Order (Virgin America, Inc.) - Violations of 14 CFR Part 382 and 49 U.S.C. §§ 41310, 41702, 41705, and 41712 Other Order 2012-05-24T04:00:00Z 2012 5 2012-05-24T04:00:00Z   2024-11-07T22:29:58Z   1 0 090000648101b75d
DOT-OST-2012-0002-0022 DOT None DOT-OST-2012-0002 2012-5-7 Consent Order (People Express Airlines, Inc.) - Violations of 49 U.S.C. § 41101 and 14 CFR 201.5(a) Other Order 2012-05-09T04:00:00Z 2012 5 2012-05-09T04:00:00Z   2024-11-07T22:16:53Z   1 0 0900006481009057
DOT-OST-2012-0002-0021 DOT None DOT-OST-2012-0002 2012-5-4 Consent Order (Air India, Limited) - Violations of 49 U.S.C. § 41712 and 41712 and 14 CFR 259.6 and 399.85(d) Other Order 2012-05-03T04:00:00Z 2012 5 2012-05-03T04:00:00Z   2024-11-07T22:16:00Z   1 0 09000064810043a3
DOT-OST-2012-0002-0020 DOT None DOT-OST-2012-0002 2012-5-2 Consent Order (Atlantic Southeast Airlines, Inc.) - Compliance with 49 U.S.C. §§ 40127(a), 41702, 41310, and 41712 Other Order 2012-05-02T04:00:00Z 2012 5 2012-05-02T04:00:00Z   2024-11-07T22:18:56Z   1 0 09000064810039b7
DOT-OST-2012-0002-0019 DOT None DOT-OST-2012-0002 2012-4-24 Consent Order (Swift Jet, Inc.) - Violations of 49 U.S.C. §§ 41301 and 41712 and 14 CFR 212.9(b)(1) Other Order 2012-04-19T04:00:00Z 2012 4 2012-04-19T04:00:00Z   2024-11-07T22:15:00Z   1 0 0900006480ff4973
DOT-OST-2012-0002-0016 DOT None DOT-OST-2012-0002 2012-4-15 Consent Order (Frontier Airlines, Inc.) - Violations of 49 U.S.C. §§ 41705 and 41712 Other Order 2012-04-13T04:00:00Z 2012 4 2012-04-13T04:00:00Z   2012-04-13T14:32:19Z   0 0 0900006480fef2c1
DOT-OST-2012-0002-0018 DOT None DOT-OST-2012-0002 2012-4-17 Consent Order (Private Air, Inc.) - Violations of 49 U.S.C. §§ 41301 and 41712 Other Order 2012-04-13T04:00:00Z 2012 4 2012-04-13T04:00:00Z   2012-04-13T15:04:16Z   0 0 0900006480fef66c
DOT-OST-2012-0002-0017 DOT None DOT-OST-2012-0002 2012-4-16 Consent Order (Pilatus PC-12 Centre Canada, Inc.) - Violations of 49 U.S.C. § 41712 and 14 CFR Part 294 Other Order 2012-04-13T04:00:00Z 2012 4 2012-04-13T04:00:00Z   2024-11-12T04:47:28Z   1 0 0900006480fef467
DOT-OST-2012-0002-0015 DOT None DOT-OST-2012-0002 2012-3-18 Consent Order (International Jet Management GmbH) - Violations of 49 U.S.C. §§ 41301, 41703, and 41712 Other Order 2012-03-29T04:00:00Z 2012 3 2012-03-29T04:00:00Z   2012-03-29T19:17:50Z   0 0 0900006480fe3edf
DOT-OST-2012-0002-0014 DOT None DOT-OST-2012-0002 2012-3-1 Consent Order - (Qantas Airways Limited) - Violations of 49 U.S.C. § 41712 and 14 CFR Part 399.84 Other Order 2012-03-02T05:00:00Z 2012 3 2012-03-02T05:00:00Z   2024-11-12T04:36:03Z   1 0 0900006480fcd1d6
DOT-OST-2012-0002-0013 DOT None DOT-OST-2012-0002 2012-2-23 Consent Order - (Unister USA, LLC, d/b/a Flights24.com) - Violations of 49 U.S.C. § 41712 and 14 CFR Parts 399 and 257 Other Order 2012-03-01T05:00:00Z 2012 3 2012-03-01T05:00:00Z   2024-11-12T04:44:26Z   1 0 0900006480fcac84
DOT-OST-2012-0002-0012 DOT None DOT-OST-2012-0002 2012-2-20 Consent Order (Twin Air Calypso Limited, Inc.) Violations of 49 U.S.C. §§ 41101, 41712, and 41738, 14 CFR Part 298, and Order 2005-3-38 Other Order 2012-02-24T05:00:00Z 2012 2 2012-02-24T05:00:00Z   2024-11-07T22:02:05Z   1 0 0900006480fc05a3
DOT-OST-2012-0002-0011 DOT None DOT-OST-2012-0002 2012-2-10 Consent Order (Allegiant Air, LLC) - Violations of 14 CFR Parts 382 and 399, and 49 U.S.C. §§ 41705, 41702 and 41712 Other Order 2012-02-15T05:00:00Z 2012 2 2012-02-15T05:00:00Z   2024-11-12T04:26:12Z   1 0 0900006480fb6fe1
DOT-OST-2012-0002-0008 DOT None DOT-OST-2012-0002 Consent Order 2012-1-20 (Spirit Airlines, Inc.) Violations of 14 CFR Part 382 and 49 U.S.C. §§ 41310, 41702, 41705, and 41712 Other Order 2012-01-27T05:00:00Z 2012 1 2012-01-27T05:00:00Z   2024-11-07T22:28:11Z   1 0 0900006480fa768c
DOT-OST-2012-0002-0009 DOT None DOT-OST-2012-0002 Consent Order 2012-1-21 (Finnair Plc) Violations of 49 U.S.C. § 41712 and 14 CFR 399.84 Other Order 2012-01-27T05:00:00Z 2012 1 2012-01-27T05:00:00Z   2024-11-07T21:55:50Z   1 0 0900006480fa7690
DOT-OST-2012-0002-0010 DOT None DOT-OST-2012-0002 2012-1-22 Consent Order - (Aviation Services, Ltd., d/b/a Freedom Air) - Violations of 49 U.S.C. § 41712 Other Order 2012-01-27T05:00:00Z 2012 1 2012-01-27T05:00:00Z   2024-11-07T22:25:45Z   1 0 0900006480fa74ca
DOT-OST-2012-0002-0005 DOT None DOT-OST-2012-0002 2012-1-13 Consent Order (Polskie Linie Lotnicze LOT S.A.) - Violations of 49 U.S.C. § 41712 and 14 CFR 399.84 Other Order 2012-01-23T05:00:00Z 2012 1 2012-01-23T05:00:00Z   2024-11-12T04:19:10Z   1 0 0900006480fa155b
DOT-OST-2012-0002-0006 DOT None DOT-OST-2012-0002 2012-1-14 Consent Order (Asiana Airlines) - Violations of 49 U.S.C. § 41712 and 14 CFR 399.84 Other Order 2012-01-23T05:00:00Z 2012 1 2012-01-23T05:00:00Z   2024-11-07T22:25:20Z   1 0 0900006480fa164c
DOT-OST-2012-0002-0007 DOT None DOT-OST-2012-0002 2012-1-15 Consent Order (Alitalia Compagnia Aerea Italiana SpA) - Violations of Article 19 of the Montreal Convention and 49 U.S.C. § 41712 Other Order 2012-01-23T05:00:00Z 2012 1 2012-01-23T05:00:00Z   2024-11-07T21:51:51Z   1 0 0900006480fa1654
DOT-OST-2012-0002-0004 DOT None DOT-OST-2012-0002 2012-1-8 Consent Order Other Order 2012-01-18T05:00:00Z 2012 1 2012-01-18T05:00:00Z   2024-11-07T21:53:06Z   1 0 0900006480f99e1f
DOT-OST-2012-0002-0003 DOT None DOT-OST-2012-0002 2012-1-5 Consent Order Other Order 2012-01-10T05:00:00Z 2012 1 2012-01-10T05:00:00Z   2024-11-11T21:36:22Z   1 0 0900006480f91cc3
DOT-OST-2012-0002-0002 DOT None DOT-OST-2012-0002 2012-1-5 Consent Order (Imagine Tours & Travel, L.L.C.) - Violations of 49 U.S.C. § 41712 and 399.84 Other   2012-01-09T00:00:00Z 2012 1     2024-11-07T22:27:23Z   0 1 0900006480f9170a
DOT-OST-2012-0002-0001 DOT None DOT-OST-2012-0002 2012-1-1 Consent Order Other Order 2012-01-04T05:00:00Z 2012 1 2012-01-04T05:00:00Z   2024-11-07T22:09:26Z   1 0 0900006480f8db57

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