documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
60 rows where docket_id = "FRA-2006-24812" and document_type = "Other" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FRA-2006-24812-0084 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | BNSF Detector Health Analysis January 5, 2026 | Other | Report | 2026-02-18T05:00:00Z | 2026 | 2 | 2026-02-18T05:00:00Z | 2026-02-18T18:58:19Z | 0 | 0 | 09000064b91b2480 | ||
| FRA-2006-24812-0083 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | BNSF Detector Health Analysis Data for prior months | Other | Report | 2025-12-23T05:00:00Z | 2025 | 12 | 2025-12-23T05:00:00Z | 2025-12-23T20:48:58Z | 0 | 0 | 09000064b91077a9 | ||
| FRA-2006-24812-0082 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | BNSF Monthly Submissions of Detector Health & Status Reports | Other | Report | 2025-12-01T05:00:00Z | 2025 | 12 | 2025-12-01T05:00:00Z | 2025-12-01T18:32:45Z | 0 | 0 | 09000064b909aedf | ||
| FRA-2006-24812-0081 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | FRA-2006-24812 BNSF Trains Quarterly Update Sept 25 2025 | Other | Report | 2025-11-21T05:00:00Z | 2025 | 11 | 2025-11-21T05:00:00Z | 2025-11-21T21:57:00Z | 0 | 0 | 09000064b908ddd8 | ||
| FRA-2006-24812-0080 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | BNSF Detector Health Data for prior months | Other | Report | 2025-09-29T04:00:00Z | 2025 | 9 | 2025-09-29T04:00:00Z | 2025-09-29T17:23:39Z | 0 | 0 | 09000064b8fdd07f | ||
| FRA-2006-24812-0079 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | BNSF Detector Health Analysis May 5, 2025 & June 5 2025 | Other | Report | 2025-06-18T04:00:00Z | 2025 | 6 | 2025-06-18T04:00:00Z | 2025-06-18T23:07:37Z | 0 | 0 | 09000064b8e146e4 | ||
| FRA-2006-24812-0078 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | BNSF Monthly Submission of Detector Health & Status Report | Other | Report | 2025-04-22T04:00:00Z | 2025 | 4 | 2025-04-22T04:00:00Z | 2025-04-22T12:32:03Z | 0 | 0 | 0900006486aa7398 | ||
| FRA-2006-24812-0077 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | BNSF Monthly Submission of Detector Health & Status Report | Other | Report | 2025-03-19T04:00:00Z | 2025 | 3 | 2025-03-19T04:00:00Z | 2025-03-19T17:24:49Z | 0 | 0 | 0900006486a0bada | ||
| FRA-2006-24812-0076 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | FRA-2006-24812 BNSF Letter on Condition 9 Feb 2025 | Other | Letter(s) | 2025-02-20T05:00:00Z | 2025 | 2 | 2025-02-20T05:00:00Z | 2025-02-20T20:32:55Z | 0 | 0 | 090000648697352a | ||
| FRA-2006-24812-0075 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | Quarterly Update January 24 2025 | Other | Report | 2025-02-18T05:00:00Z | 2025 | 2 | 2025-02-18T05:00:00Z | 2025-02-18T15:35:16Z | 0 | 0 | 09000064869538a4 | ||
| FRA-2006-24812-0074 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | BNSF Monthly Submission of Detector Health & Status Reporting | Other | Report | 2025-01-28T05:00:00Z | 2025 | 1 | 2025-01-28T05:00:00Z | 2025-01-28T15:53:02Z | 0 | 0 | 0900006486906ccb | ||
| FRA-2006-24812-0073 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | BNSF Support Data - Monthly Submission of Detector Health & Status Report - October & November Reports | Other | Report | 2024-12-10T05:00:00Z | 2024 | 12 | 2024-12-10T05:00:00Z | 2024-12-10T16:26:52Z | 0 | 0 | 09000064868587d7 | ||
| FRA-2006-24812-0072 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | Quarterly Review Presentation w/ FRA & Labor Post Waiver Re-Approval - Dates 7/31/2024 and 10/31/2024 | Other | Additional Information | 2024-11-14T05:00:00Z | 2024 | 11 | 2024-11-14T05:00:00Z | 2024-11-14T19:45:02Z | 0 | 0 | 09000064867f51d5 | ||
| FRA-2006-24812-0071 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | BNSF Quarterly Data & Conditions Review | Other | Additional Information | 2024-11-14T05:00:00Z | 2024 | 11 | 2024-11-14T05:00:00Z | 2024-11-14T19:42:11Z | 0 | 0 | 090000648680a9d9 | ||
| FRA-2006-24812-0070 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | BNSF Support Data - Monthly Submission of Detector Health & Status Report | Other | Report | 2024-10-30T04:00:00Z | 2024 | 10 | 2024-10-30T04:00:00Z | 2024-10-30T16:48:09Z | 0 | 0 | 09000064867eaad8 | ||
| FRA-2006-24812-0069 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | Monthly Detector Health & Status | Other | Report | 2024-09-26T04:00:00Z | 2024 | 9 | 2024-09-26T04:00:00Z | 2024-09-26T11:47:13Z | 0 | 0 | 0900006486779e8a | ||
| FRA-2006-24812-0067 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | BNSF Monthly Submission of Detector Health & Status Report | Other | Report | 2024-09-26T04:00:00Z | 2024 | 9 | 2024-09-26T04:00:00Z | 2024-09-26T11:47:01Z | 0 | 0 | 0900006486779bab | ||
| FRA-2006-24812-0068 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | BNSF Quarterly Review w/ FRA & Labor | Other | Report | 2024-09-26T04:00:00Z | 2024 | 9 | 2024-09-26T04:00:00Z | 2024-09-26T11:47:07Z | 0 | 0 | 0900006486779cc5 | ||
| FRA-2006-24812-0066 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | FRA-2006-24812 Decision Letter 2024 | Other | Decision | 2024-04-24T04:00:00Z | 2024 | 4 | 2024-04-24T04:00:00Z | 2024-04-24T19:20:14Z | 0 | 0 | 09000064864ec0c0 | ||
| FRA-2006-24812-0065 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | FRA-2006-24812 IAM Comment Apr 10 2024 | Other | Additional Information | 2024-04-19T04:00:00Z | 2024 | 4 | 2024-04-19T04:00:00Z | 2024-04-19T16:42:11Z | 0 | 0 | 09000064864d2f1b | ||
| FRA-2006-24812-0064 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | FRA-2006-24812 BNSF Response - BRC Comment April 3 2024 | Other | Response(s) | 2024-04-09T04:00:00Z | 2024 | 4 | 2024-04-09T04:00:00Z | 2024-04-09T17:01:23Z | 0 | 0 | 09000064864c1cba | ||
| FRA-2006-24812-0063 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | FRA-2006-24812 Comment from BRC March 2024 | Other | Response(s) | 2024-04-02T04:00:00Z | 2024 | 4 | 2024-04-02T04:00:00Z | 2024-04-02T19:09:06Z | 0 | 0 | 09000064864b28e5 | ||
| FRA-2006-24812-0061 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | FRA-2006-24812 FRA Response Letter 3.18 2024 | Other | Action Memo or Letter | 2024-03-29T04:00:00Z | 2024 | 3 | 2024-03-29T04:00:00Z | 2024-03-29T16:39:48Z | 0 | 0 | 090000648649907e | ||
| FRA-2006-24812-0060 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | FRA-2006-24812 FRA Response Letter 3.25 2024 | Other | Response(s) | 2024-03-29T04:00:00Z | 2024 | 3 | 2024-03-29T04:00:00Z | 2024-03-29T16:37:39Z | 0 | 0 | 0900006486499080 | ||
| FRA-2006-24812-0059 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | FRA-2006-24812 Incoming Letter 3.20 2024 | Other | Action Memo or Letter | 2024-03-29T04:00:00Z | 2024 | 3 | 2024-03-29T04:00:00Z | 2024-03-29T16:36:32Z | 0 | 0 | 090000648649956c | ||
| FRA-2006-24812-0058 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | FRA-2006-24812 Incoming Letter - Status Request 3.13 2024 | Other | Action Memo or Letter | 2024-03-27T04:00:00Z | 2024 | 3 | 2024-03-27T04:00:00Z | 2024-03-27T14:20:30Z | 0 | 0 | 0900006486498ff7 | ||
| FRA-2006-24812-0057 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | FRA-2006-24812 BNSF 1702 List Oct 20 2023 | Other | Report | 2023-10-31T04:00:00Z | 2023 | 10 | 2023-10-31T04:00:00Z | 2023-10-31T15:19:13Z | 0 | 0 | 0900006486187ffe | ||
| FRA-2006-24812-0056 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | FRA-2006-24812 BNSF 1702 Data Analysis July 2023 | Other | Additional Information | 2023-10-26T04:00:00Z | 2023 | 10 | 2023-10-26T04:00:00Z | 2023-10-26T15:11:24Z | 0 | 0 | 090000648613b539 | ||
| FRA-2006-24812-0052 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | FRA-2006-24812 Incoming Revised Waiver Petition May 2023 | Other | Petition(s) | 2023-05-31T04:00:00Z | 2023 | 5 | 2023-05-31T04:00:00Z | 2023-05-31T12:43:31Z | 0 | 0 | 0900006485a7002d | ||
| FRA-2006-24812-0051 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | FRA-2006-24812 Incoming Waiver Extension Petition Apr 2023 | Other | Waiver | 2023-04-25T04:00:00Z | 2023 | 4 | 2023-04-25T04:00:00Z | 2025-06-22T00:27:15Z | 1 | 0 | 090000648597b3e1 | ||
| FRA-2006-24812-0050 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | FRA-2006-24812 Inc Letter - Phone Number Update 2022 | Other | Action Memo or Letter | 2022-10-14T04:00:00Z | 2022 | 10 | 2022-10-14T04:00:00Z | 2022-10-14T17:24:02Z | 0 | 0 | 0900006485400bd3 | ||
| FRA-2006-24812-0049 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | U.S. DOT/FRA-BNSF Decision Letter 2018 | Other | Decision | 2018-10-23T04:00:00Z | 2018 | 10 | 2018-10-23T04:00:00Z | 2018-10-23T14:10:38Z | 0 | 0 | 090000648383a3e0 | ||
| FRA-2006-24812-0048 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | U.S. DOT/FRA-Waiver Acknowledgment Letter 2018 | Other | Acknowledgement Letter/Receipt | 2018-07-10T04:00:00Z | 2018 | 7 | 2018-07-10T04:00:00Z | 2018-07-10T19:01:44Z | 0 | 0 | 09000064834cab4d | ||
| FRA-2006-24812-0047 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | Waiver Extension Request 2018 | Other | Request | 2018-07-06T04:00:00Z | 2018 | 7 | 2018-07-06T04:00:00Z | 2018-07-06T14:13:20Z | 0 | 0 | 09000064834adcc4 | ||
| FRA-2006-24812-0046 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | Waiver Expiration Letter | Other | Action Memo or Letter | 2018-01-29T05:00:00Z | 2018 | 1 | 2018-01-29T05:00:00Z | 2018-01-29T21:22:40Z | 0 | 0 | 0900006482e776ce | ||
| FRA-2006-24812-0045 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | BNSF Railway - Quarterly Update | Other | Report | 2016-11-02T04:00:00Z | 2016 | 11 | 2016-11-02T04:00:00Z | 2024-11-12T06:16:14Z | 1 | 0 | 0900006482369943 | ||
| FRA-2006-24812-0044 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | U.S. DOT/FRA - Decision Letter - Extended Haul Trains | Other | Decision | 2015-11-19T05:00:00Z | 2015 | 11 | 2015-11-19T05:00:00Z | 2015-11-19T18:28:15Z | 0 | 0 | 0900006481d5691b | ||
| FRA-2006-24812-0043 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | U.S. DOT/FRA- Decision Letter - BNSF - Extended Haul Trains | Other | Decision | 2015-10-19T04:00:00Z | 2015 | 10 | 2015-10-19T04:00:00Z | 2015-10-19T13:28:06Z | 0 | 0 | 0900006481ccebfd | ||
| FRA-2006-24812-0042 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | U.S. DOT/FRA- BNSF - Waiver Expansion Acknowledgement Letter" | Other | Acknowledgement Letter/Receipt | 2015-10-15T04:00:00Z | 2015 | 10 | 2015-06-11T04:00:00Z | 2015-10-15T18:28:49Z | 0 | 0 | 0900006481ccd503 | ||
| FRA-2006-24812-0041 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | BNSF Railway Company - Incoming Waiver Request 9-9-15 | Other | Request | 2015-10-06T04:00:00Z | 2015 | 10 | 2015-10-06T04:00:00Z | 2015-10-06T18:53:32Z | 0 | 0 | 0900006481caf301 | ||
| FRA-2006-24812-0038 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | U.S. DOT/FRA - Transcript of May 21, 2015 Public Hearing | Other | Transcript(s) | 2015-06-11T04:00:00Z | 2015 | 6 | 2015-06-11T04:00:00Z | 2024-11-07T23:23:24Z | 1 | 0 | 0900006481b19f81 | ||
| FRA-2006-24812-0037 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | U.S. DOT/FAA - Transcript of Statement | Other | Transcript(s) | 2015-06-11T04:00:00Z | 2015 | 6 | 2015-06-11T04:00:00Z | 2024-11-11T20:56:24Z | 1 | 0 | 0900006481b1654f | ||
| FRA-2006-24812-0034 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | BNSF Petition of Waiver of Compliance | Other | Petition(s) | 2015-03-19T04:00:00Z | 2015 | 3 | 2015-03-19T04:00:00Z | 2025-02-01T21:24:39Z | 1 | 0 | 0900006481a5153f | ||
| FRA-2006-24812-0033 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | U.S. DOT/FRA - Decision Letter - (BNSF - Extended Haul Trains) | Other | Decision | 2013-07-25T04:00:00Z | 2013 | 7 | 2013-07-25T04:00:00Z | 2025-10-11T09:31:58Z | 1 | 0 | 090000648137c055 | ||
| FRA-2006-24812-0029 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | CSX Transportation - Letter of Support | Other | Letter(s) in Support | 2013-04-18T04:00:00Z | 2013 | 4 | 2013-04-18T04:00:00Z | 2024-11-11T20:47:36Z | 1 | 0 | 0900006481298cfb | ||
| FRA-2006-24812-0025 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | U.S. DOT/FRA - BRC Opposition Letter | Other | Letter(s) in Opposition | 2013-04-03T04:00:00Z | 2013 | 4 | 2013-04-03T04:00:00Z | 2024-11-11T20:47:20Z | 1 | 0 | 0900006481265aaa | ||
| FRA-2006-24812-0021 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | U.S. DOT/FRA - Acknowledgement Letter (Request to "add additional extended haul trains") | Other | Acknowledgement Letter/Receipt | 2012-10-18T04:00:00Z | 2012 | 10 | 2012-10-18T04:00:00Z | 2024-11-12T05:06:00Z | 1 | 0 | 09000064811470bc | ||
| FRA-2006-24812-0020 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | BNSF Railway Company - Waiver Request | Other | Request | 2012-07-19T04:00:00Z | 2012 | 7 | 2012-07-19T04:00:00Z | 2024-11-07T22:42:20Z | 1 | 0 | 09000064810a49c6 | ||
| FRA-2006-24812-0019 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | U.S. DOT/FRA - Decision Letter | Other | Decision | 2012-01-11T05:00:00Z | 2012 | 1 | 2012-01-11T05:00:00Z | 2024-11-08T03:47:19Z | 1 | 0 | 0900006480f923da | ||
| FRA-2006-24812-0016 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | BNSF - Additional Information | Other | Additional Information | 2011-08-17T04:00:00Z | 2011 | 8 | 2011-08-17T04:00:00Z | 2013-08-11T03:16:38Z | 0 | 0 | 0900006480ee30e5 | ||
| FRA-2006-24812-0015 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | BNSF - Additional Information | Other | Additional Information | 2011-07-08T04:00:00Z | 2011 | 7 | 2011-07-08T04:00:00Z | 2024-11-07T22:36:47Z | 1 | 0 | 0900006480eb81d7 | ||
| FRA-2006-24812-0014 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | BNSF Railway Company - Request for Change in Inspection Schedule | Other | Request | 2011-06-09T04:00:00Z | 2011 | 6 | 2011-06-09T04:00:00Z | 2024-11-07T22:30:56Z | 1 | 0 | 0900006480e4294c | ||
| FRA-2006-24812-0013 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | BNSF Railway Company - Permission to Change Inspection Schedule | Other | Request | 2011-05-12T04:00:00Z | 2011 | 5 | 2011-05-12T04:00:00Z | 2024-11-12T05:00:11Z | 1 | 0 | 0900006480c40571 | ||
| FRA-2006-24812-0012 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | BNSF Railway Company - Withdrawal of Waiver Request | Other | Withdrawal | 2011-03-02T05:00:00Z | 2011 | 3 | 2011-03-02T05:00:00Z | 2024-11-07T22:30:25Z | 1 | 0 | 0900006480bfce2e | ||
| FRA-2006-24812-0011 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | BNSF Railway Company - Request to Change Inspection Points | Other | Request | 2011-02-24T05:00:00Z | 2011 | 2 | 2011-02-24T05:00:00Z | 2024-11-12T05:00:03Z | 1 | 0 | 0900006480bf05de | ||
| FRA-2006-24812-0010 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | U.S. DOT/FRA - Decision Letter | Other | Decision | 2007-03-22T04:00:00Z | 2007 | 3 | 2007-03-22T04:00:00Z | 2007-03-23T03:59:59Z | 2024-11-08T04:28:42Z | 1 | 0 | 09000064802b4a6f | |
| FRA-2006-24812-0006 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | U.S. DOT/FRA - Letter to BNSF Regarding the Review Process for their Extension Request | Other | Letter(s) | 2006-12-26T05:00:00Z | 2006 | 12 | 2006-12-26T05:00:00Z | 2006-12-27T04:59:59Z | 2024-11-08T04:28:43Z | 1 | 0 | 09000064802b4a74 | |
| FRA-2006-24812-0004 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | Burlington Northern Santa Fe Corporation - Waiver Petition | Other | Waiver | 2006-11-27T05:00:00Z | 2006 | 11 | 2006-11-27T05:00:00Z | 2006-11-28T04:59:59Z | 2024-11-08T04:28:42Z | 1 | 0 | 09000064802b4a72 | |
| FRA-2006-24812-0003 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | U.S. DOT/FRA - Decision Letter on Waiver Petition | Other | Decision | 2006-07-21T04:00:00Z | 2006 | 7 | 2006-07-21T04:00:00Z | 2006-07-22T03:59:59Z | 2024-11-08T04:28:42Z | 1 | 0 | 09000064802b4a71 | |
| FRA-2006-24812-0001 | FRA | Burlington Northern Santa Fe Corporation - Waiver Petition FRA-2006-24812 | Burlington Northern Santa Fe Corporation - Waiver Petition | Other | Waiver | 2006-05-16T04:00:00Z | 2006 | 5 | 2006-05-16T04:00:00Z | 2006-05-17T03:59:59Z | 2024-11-16T19:27:30Z | 1 | 0 | 09000064802b4a6d |
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;