documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
- comment_end_date
- A FULL UTC INSTANT, not a calendar date, despite the column name: '2026-08-29T03:59:59Z' is 11:59:59 PM EASTERN on 2026-08-28. Federal comment periods close at 11:59:59 PM Eastern, so the UTC calendar date is ONE DAY LATER than the official deadline on every end-of-day close — 444,689 of the 444,690 populated rows (measured 2026-09-06). Convert to America/New_York before presenting a deadline, and compare with julianday(comment_end_date) > julianday('now'): a plain > datetime('now') is a TEXT comparison between two different formats and keeps already-closed dockets matching for up to ~20 hours. The sibling column on open_comments.documents WAS corrected to an Eastern calendar date (queue #498); this one is unchanged and still an instant — the two databases do not agree on grain. (queue #644)
- comment_start_date
- A FULL UTC INSTANT, not a calendar date, despite the column name — same grain as comment_end_date on this table. Convert to America/New_York before presenting it. (queue #644)
2,747 rows where agency_id = "FMCSA" and document_type = "Rule" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FMCSA-2025-0109-0011 | FMCSA | Parts and Accessories Necessary for Safe Operation; Spare Fuses FMCSA-2025-0109 | Parts and Accessories Necessary for Safe Operation: Spare Fuses | Rule | Final Rule | 2026-02-19T05:00:00Z | 2026 | 2 | 2026-02-19T05:00:00Z | 2026-03-24T03:59:59Z | 2026-02-19T18:12:38Z | 2026-03262 | 1 | 0 | 09000064b91bd343 |
| FMCSA-2025-0110-0010 | FMCSA | Parts and Accessories Necessary for Safe Operation; Liquid-Burning Flares FMCSA-2025-0110 | Parts and Accessories Necessary for Safe Operation: Liquid-Burning Flares | Rule | Final Rule | 2026-02-19T05:00:00Z | 2026 | 2 | 2026-02-19T05:00:00Z | 2026-02-19T18:10:37Z | 2026-03261 | 0 | 0 | 09000064b91bd3d6 | |
| FMCSA-2025-0119-0009 | FMCSA | Parts and Accessories Necessary for Safe Operation; Brakes on Portable Conveyors FMCSA-2025-0119 | Parts and Accessories Necessary for Safe Operation: Brakes on Portable Conveyors | Rule | Final Rule | 2026-02-19T05:00:00Z | 2026 | 2 | 2026-02-19T05:00:00Z | 2026-02-19T18:11:16Z | 2026-03256 | 0 | 0 | 09000064b91bd38c | |
| FMCSA-2025-0122-0004 | FMCSA | Parts and Accessories Necessary for Safe Operation; License Plate Lamps FMCSA-2025-0122 | Parts and Accessories Necessary for Safe Operation: License Plate Lamps | Rule | Final Rule | 2026-02-19T05:00:00Z | 2026 | 2 | 2026-02-19T05:00:00Z | 2026-02-19T18:09:04Z | 2026-03259 | 0 | 0 | 09000064b91bd408 | |
| FMCSA-2025-0117-0006 | FMCSA | Parts and Accessories Necessary for Safe Operation; Fuel Tank Overfill Restriction FMCSA-2025-0117 | Parts and Accessories Necessary for Safe Operation: Fuel Tank Overfill Restriction | Rule | Final Rule | 2026-02-19T05:00:00Z | 2026 | 2 | 2026-02-19T05:00:00Z | 2026-02-19T18:14:09Z | 2026-03265 | 0 | 0 | 09000064b91b90f9 | |
| FMCSA-2025-0123-0006 | FMCSA | Parts and Accessories Necessary for Safe Operation; Tire Load Markings FMCSA-2025-0123 | Parts and Accessories Necessary for Safe Operation: Tire Load Markings | Rule | Final Rule | 2026-02-19T05:00:00Z | 2026 | 2 | 2026-02-19T05:00:00Z | 2026-02-19T18:06:50Z | 2026-03260 | 0 | 0 | 09000064b91bd48f | |
| FMCSA-2025-0112-0004 | FMCSA | Removal of Obsolete References to “Water Carriers” FMCSA-2025-0112 | Removal of Obsolete References to ``Water Carriers'' | Rule | Final Rule | 2026-02-19T05:00:00Z | 2026 | 2 | 2026-02-19T05:00:00Z | 2026-03-24T03:59:59Z | 2026-02-19T18:06:06Z | 2026-03266 | 1 | 0 | 09000064b91bd496 |
| FMCSA-2025-0113-0005 | FMCSA | Qualifications of Drivers; Vision Standards Grandfathering Provision FMCSA-2025-0113 | Qualifications of Drivers; Vision Standards Grandfathering Provision | Rule | Final Rule | 2026-02-19T05:00:00Z | 2026 | 2 | 2026-02-19T05:00:00Z | 2026-03-24T03:59:59Z | 2026-03-06T10:00:19Z | 2026-03258 | 1 | 0 | 09000064b91bd346 |
| FMCSA-2025-0107-0007 | FMCSA | Parts and Accessories Necessary for Safe Operation; Certification and Labeling Requirements for Rear Impact Protection Guards FMCSA-2025-0107 | Parts and Accessories Necessary for Safe Operation: Certification and Labeling Requirements for Rear Impact Protection Guards | Rule | Final Rule | 2026-02-19T05:00:00Z | 2026 | 2 | 2026-02-19T05:00:00Z | 2026-02-19T18:13:26Z | 2026-03255 | 0 | 0 | 09000064b91b90fb | |
| FMCSA-2025-0115-0007 | FMCSA | Electronic Driver Vehicle Inspection Reports FMCSA-2025-0115 | Electronic Driver Vehicle Inspection Reports | Rule | Final Rule | 2026-02-19T05:00:00Z | 2026 | 2 | 2026-02-19T05:00:00Z | 2026-02-19T18:09:54Z | 2026-03264 | 0 | 0 | 09000064b91bd404 | |
| FMCSA-2025-0120-0005 | FMCSA | Parts and Accessories Necessary for Safe Operation; Auxiliary Fuel Tanks FMCSA-2025-0120 | Parts and Accessories Necessary for Safe Operation: Auxiliary Fuel Tanks | Rule | Final Rule | 2026-02-19T05:00:00Z | 2026 | 2 | 2026-02-19T05:00:00Z | 2026-02-19T18:08:26Z | 2026-03257 | 0 | 0 | 09000064b91bd40c | |
| FMCSA-2025-0118-0007 | FMCSA | Commercial Driver’s License Standards; Requirements and Penalties: Applicability to the Exception for Certain Military Personnel FMCSA-2025-0118 | Commercial Driver's License Standards; Requirements and Penalties: Applicability to the Exception for Certain Military Personnel | Rule | Final Rule | 2026-02-19T05:00:00Z | 2026 | 2 | 2026-02-19T05:00:00Z | 2026-03-24T03:59:59Z | 2026-02-19T18:07:40Z | 2026-03263 | 1 | 0 | 09000064b91bd447 |
| FMCSA-2025-0622-8113 | FMCSA | Restoring Integrity to the Issuance of Non-Domiciled Commercial Drivers Licenses FMCSA-2025-0622 | Restoring Integrity to the Issuance of Non-Domiciled Commercial Drivers Licenses (CDL) | Rule | Final Rule | 2026-02-13T05:00:00Z | 2026 | 2 | 2026-02-13T05:00:00Z | 2026-02-13T19:26:27Z | 2026-02965 | 0 | 0 | 09000064b91aa701 | |
| FMCSA-2024-0121-0077 | FMCSA | Transportation of Fuel for Agricultural Aircraft Operations FMCSA-2024-0121 | Transportation of Fuel for Agricultural Aircraft Operations | Rule | Final Rule | 2026-01-09T05:00:00Z | 2026 | 1 | 2026-01-09T05:00:00Z | 2026-02-10T04:59:59Z | 2026-02-07T13:14:41Z | 2026-00269 | 0 | 0 | 09000064b91202d8 |
| FMCSA-2025-0622-1050 | FMCSA | Restoring Integrity to the Issuance of Non-Domiciled Commercial Drivers Licenses FMCSA-2025-0622 | Commercial Driver's License Standards: Restoring Integrity to the Issuance of Non-Domiciled Commercial Drivers Licenses; Correction | Rule | Correction | 2025-10-02T04:00:00Z | 2025 | 10 | 2025-10-02T04:00:00Z | 2025-11-29T04:59:59Z | 2026-01-03T13:13:20Z | 2025-19230 | 0 | 0 | 09000064b8ff07c4 |
| FMCSA-2025-0622-0001 | FMCSA | Restoring Integrity to the Issuance of Non-Domiciled Commercial Drivers Licenses FMCSA-2025-0622 | Commercial Driver's License Standards: Restoring Integrity to the Issuance of Non-Domiciled Commercial Drivers Licenses | Rule | Final Rule with Request for Comments | 2025-09-29T04:00:00Z | 2025 | 9 | 2025-09-29T04:00:00Z | 2025-11-29T04:59:59Z | 2025-12-31T10:00:25Z | 2025-18869 | 0 | 0 | 09000064b8fe41b2 |
| FMCSA-2025-0106-0001 | FMCSA | Appendix B to 49 CFR Part 386 – Civil Penalties; Paragraph (a)(1) of the Appendix FMCSA-2025-0106 | Civil Penalties | Rule | Final Rule | 2025-05-30T00:00:00Z | 2025 | 5 | 2025-05-30T00:00:00Z | 2025-05-30T16:56:29Z | 2025-09703 | 0 | 0 | 09000064b8dc7c19 | |
| FMCSA-2025-0105-0001 | FMCSA | Motor Carrier Routing Regulations FMCSA-2025-0105 | Motor Carrier Routing | Rule | Final Rule | 2025-05-30T00:00:00Z | 2025 | 5 | 2025-05-30T00:00:00Z | 2025-05-30T16:51:18Z | 2025-09709 | 0 | 0 | 09000064b8dc7c7f | |
| FMCSA-2024-0201-0003 | FMCSA | General Technical, Organizational, Conforming, and Correcting Amendments to the Federal Motor Carrier Safety Regulations FMCSA-2024-0201 | Federal Motor Carrier Safety Regulations; Correction | Rule | Policy Statement | 2025-02-24T05:00:00Z | 2025 | 2 | 2025-02-24T05:00:00Z | 2025-02-24T15:50:09Z | 2025-02968 | 0 | 0 | 0900006486986680 | |
| FMCSA-2024-0201-0002 | FMCSA | General Technical, Organizational, Conforming, and Correcting Amendments to the Federal Motor Carrier Safety Regulations FMCSA-2024-0201 | Federal Motor Carrier Safety Regulations; Correction | Rule | Correction | 2025-01-10T05:00:00Z | 2025 | 1 | 2025-01-10T05:00:00Z | 2025-01-10T13:17:56Z | 2025-00212 | 0 | 0 | 09000064868ad7f3 | |
| FMCSA-2024-0280-0016 | FMCSA | Broker and Freight Forwarder Financial Responsibility; Extension of Compliance Date FMCSA-2024-0280 | Broker and Freight Forwarder Financial Responsibility | Rule | Final Rule | 2024-12-31T05:00:00Z | 2024 | 12 | 2024-12-31T05:00:00Z | 2024-12-31T13:55:59Z | 2024-30509 | 0 | 0 | 0900006486896d75 | |
| FMCSA-2013-0161-0278 | FMCSA | Federal Registers for Applications, Notices, and Orders - Miscellaneous FMCSA-2013-0161 | Revisions to Civil Penalty Amounts, 2025 | Rule | Final Rule | 2024-12-30T05:00:00Z | 2024 | 12 | 2024-12-30T05:00:00Z | 2024-12-30T15:12:13Z | 2024-30608 | 0 | 0 | 0900006486894ec5 | |
| FMCSA-2024-0201-0001 | FMCSA | General Technical, Organizational, Conforming, and Correcting Amendments to the Federal Motor Carrier Safety Regulations FMCSA-2024-0201 | Federal Motor Carrier Safety Regulations; General Technical, Organizational, Conforming, and Correcting Amendments | Rule | Final Rule | 2024-11-18T05:00:00Z | 2024 | 11 | 2024-11-18T05:00:00Z | 2024-11-18T13:37:01Z | 2024-25514 | 0 | 0 | 090000648681fc58 | |
| FMCSA-2024-0073-0003 | FMCSA | Incorporation by Reference; North American Standard Out-of-Service Criteria; Hazardous Materials Safety Permits FMCSA-2024-0073 | Permits; Applications, Issuances, etc.: North American Standard Out-of-Service Criteria; Hazardous Materials Safety Permits | Rule | Final Rule | 2024-08-21T04:00:00Z | 2024 | 8 | 2024-08-21T04:00:00Z | 2024-08-21T16:02:59Z | 2024-18749 | 0 | 0 | 09000064866596c6 | |
| FMCSA-2023-0268-0071 | FMCSA | Fees for the Unified Carrier Registration Plan and Agreement FMCSA-2023-0268 | Fees for the Unified Carrier Registration Plan and Agreement | Rule | Final Rule | 2024-06-17T04:00:00Z | 2024 | 6 | 2024-06-17T04:00:00Z | 2024-06-17T12:47:59Z | 2024-13192 | 0 | 0 | 09000064865b9f83 | |
| FMCSA-2023-0269-0004 | FMCSA | Commercial Driver’s License (CDL) Standards; Incorporation by Reference of a New State Procedures Manual (SPM) FMCSA-2023-0269 | Commercial Driver's License Standards: Incorporation by Reference of a New State Procedures Manual | Rule | Final Rule | 2024-06-13T04:00:00Z | 2024 | 6 | 2024-06-13T04:00:00Z | 2024-07-16T03:59:59Z | 2024-07-16T01:01:33Z | 2024-12882 | 0 | 0 | 09000064865b39cb |
| FMCSA-2023-0007-0007 | FMCSA | Providers of Recreational Activities FMCSA-2023-0007 | Exemption from Operating Authority Regulations for Providers of Recreational Activities | Rule | Final Rule | 2024-02-26T05:00:00Z | 2024 | 2 | 2024-02-26T05:00:00Z | 2024-02-26T14:49:53Z | 2024-03782 | 0 | 0 | 090000648642e383 | |
| FMCSA-2022-0111-0078 | FMCSA | Qualifications of Drivers: Medical Examiner’s Handbook and Medical Advisory Criteria Proposed Regulatory Guidance FMCSA-2022-0111 | Qualifications of Drivers: Medical Examiner's Handbook Regulatory Guidance | Rule | Final Rule | 2024-01-22T05:00:00Z | 2024 | 1 | 2024-01-22T05:00:00Z | 2024-01-22T14:57:05Z | 2024-01056 | 0 | 0 | 09000064863b3077 | |
| FMCSA-2022-0111-0077 | FMCSA | Qualifications of Drivers: Medical Examiner’s Handbook and Medical Advisory Criteria Proposed Regulatory Guidance FMCSA-2022-0111 | Qualifications of Drivers: Medical Advisory Criteria | Rule | Final Rule | 2024-01-19T05:00:00Z | 2024 | 1 | 2024-01-19T05:00:00Z | 2024-01-19T13:58:02Z | 2024-00980 | 0 | 0 | 09000064863abfbb | |
| FMCSA-2023-0174-0003 | FMCSA | General Technical, Organizational, Conforming, and Correcting Amendments to the Federal Motor Carrier Safety Regulations FMCSA-2023-0174 | Federal Motor Carrier Safety Regulations (General Technical, Organizational, Conforming, and Correcting Amendments); Corrections | Rule | Correction | 2024-01-05T05:00:00Z | 2024 | 1 | 2024-01-05T05:00:00Z | 2024-11-12T06:24:38Z | 2024-00016 | 1 | 0 | 090000648637d8fb | |
| FMCSA-2013-0161-0252 | FMCSA | Federal Registers for Applications, Notices, and Orders - Miscellaneous FMCSA-2013-0161 | Revisions to Civil Penalty Amounts, 2024 | Rule | Final Rule | 2023-12-28T05:00:00Z | 2023 | 12 | 2023-12-28T05:00:00Z | 2023-12-28T14:48:58Z | 2023-28066 | 0 | 0 | 09000064863616e6 | |
| FMCSA-2023-0174-0001 | FMCSA | General Technical, Organizational, Conforming, and Correcting Amendments to the Federal Motor Carrier Safety Regulations FMCSA-2023-0174 | Federal Motor Carrier Safety Regulations (General Technical, Organizational, Conforming, and Correcting Amendments) | Rule | Final Rule | 2023-11-17T05:00:00Z | 2023 | 11 | 2023-11-17T05:00:00Z | 2023-12-07T02:04:19Z | 2023-24160 | 0 | 0 | 090000648628cc14 | |
| FMCSA-2016-0102-0436 | FMCSA | Broker and Freight Forwarder Financial Responsibility FMCSA-2016-0102 | Broker and Freight Forwarder Financial Responsibility | Rule | Final Rule | 2023-11-16T05:00:00Z | 2023 | 11 | 2023-11-16T05:00:00Z | 2023-11-16T17:03:52Z | 2023-25312 | 0 | 0 | 0900006486287d1e | |
| FMCSA-2023-0122-0004 | FMCSA | Incorporation by Reference; North American Standard Out-of-Service Criteria; Hazardous Materials Safety Permits FMCSA-2023-0122 | Hazardous Materials Safety Permits: North American Standard Out-of-Service Criteria; Incorporation by Reference | Rule | Final Rule | 2023-11-08T05:00:00Z | 2023 | 11 | 2023-11-08T05:00:00Z | 2023-11-08T15:14:59Z | 2023-24448 | 0 | 0 | 0900006486226df7 | |
| FMCSA-2022-0028-0033 | FMCSA | Clarification to the Applicability of Emergency Exemptions FMCSA-2022-0028 | Clarification to the Applicability of Emergency Exemptions | Rule | Final Rule | 2023-10-13T04:00:00Z | 2023 | 10 | 2023-10-13T04:00:00Z | 2023-10-13T13:04:36Z | 2023-22538 | 0 | 0 | 09000064860cddf7 | |
| FMCSA-2013-0147-0009 | FMCSA | Request for Driver Class Exemption; the Commonwealth of Virginia, Department of Motor Vehicles FMCSA-2013-0147 | Exemption Application: Qualification of Drivers; Skill Performance Evaluation Program; Virginia Department of Motor Vehicles | Rule | Interim Final Rule | 2023-07-06T04:00:00Z | 2023 | 7 | 2023-07-06T04:00:00Z | 2023-08-08T03:59:59Z | 2024-11-07T23:39:01Z | 2023-13731 | 1 | 0 | 0900006485c61e73 |
| FMCSA-2023-0008-0003 | FMCSA | Fees for the Unified Carrier Registration Plan and Agreement FMCSA-2023-0008 | Fees for the Unified Carrier Registration Plan and Agreement | Rule | Final Rule | 2023-06-22T04:00:00Z | 2023 | 6 | 2023-06-22T04:00:00Z | 2023-06-22T12:21:46Z | 2023-13204 | 0 | 0 | 0900006485bb091c | |
| FMCSA-2022-0134-0153 | FMCSA | Request for Comments on Definitions of Broker and Bona Fide Agents FMCSA-2022-0134 | Definitions of Broker and Bona Fide Agents | Rule | Final Rule | 2023-06-16T04:00:00Z | 2023 | 6 | 2023-06-16T04:00:00Z | 2023-06-16T14:19:36Z | 2023-13080 | 0 | 0 | 0900006485b388d5 | |
| FMCSA-2013-0161-0237 | FMCSA | Federal Registers for Applications, Notices, and Orders - Miscellaneous FMCSA-2013-0161 | Procedures for Transportation Workplace Drug and Alcohol Testing Programs: Addition of Oral Fluid Specimen Testing for Drugs | Rule | Final Rule | 2023-05-02T04:00:00Z | 2023 | 5 | 2023-05-02T04:00:00Z | 2023-05-02T12:48:51Z | 2023-08041 | 0 | 0 | 09000064859b7b04 | |
| FMCSA-2013-0161-0228 | FMCSA | Federal Registers for Applications, Notices, and Orders - Miscellaneous FMCSA-2013-0161 | Civil Penalty Amounts | Rule | Final Rule | 2023-01-06T05:00:00Z | 2023 | 1 | 2023-01-06T05:00:00Z | 2023-01-06T15:21:33Z | 2022-28580 | 0 | 0 | 090000648559b25a | |
| FMCSA-2022-0128-0003 | FMCSA | Incorporation by Reference; North American Standard Out-of-Service Criteria; Hazardous Materials Safety Permits FMCSA-2022-0128 | North American Standard Out-of-Service Criteria; Hazardous Materials Safety Permits | Rule | Final Rule | 2022-12-22T05:00:00Z | 2022 | 12 | 2022-12-22T05:00:00Z | 2022-12-22T13:50:42Z | 2022-27774 | 0 | 0 | 090000648554d58b | |
| FMCSA-2021-0188-0002 | FMCSA | Regulatory Guidance Concerning Motor Carriers of Passengers FMCSA-2021-0188 | Applicability of the Registration, Financial Responsibility, and Safety Regulations to Motor Carriers of Passengers | Rule | Final Rule | 2022-12-01T05:00:00Z | 2022 | 12 | 2022-12-01T05:00:00Z | 2023-01-18T04:59:59Z | 2024-11-07T00:45:15Z | 2022-24089 | 1 | 0 | 09000064855089f7 |
| FMCSA-2021-0188-0001 | FMCSA | Regulatory Guidance Concerning Motor Carriers of Passengers FMCSA-2021-0188 | Applicability of the Registration, Financial Responsibility, and Safety Regulations to Motor Carriers of Passengers: Correction | Rule | Final Rule | 2022-11-28T05:00:00Z | 2022 | 11 | 2022-11-28T05:00:00Z | 2023-01-18T04:59:59Z | 2024-11-12T23:47:17Z | 2022-25443 | 1 | 0 | 0900006485504610 |
| FMCSA-2022-0134-0090 | FMCSA | Request for Comments on Definitions of Broker and Bona Fide Agents FMCSA-2022-0134 | Guidance: Definitions of Broker and Bona Fide Agents | Rule | Final Rule with Request for Comments | 2022-11-16T05:00:00Z | 2022 | 11 | 2022-11-16T05:00:00Z | 2024-11-12T23:46:49Z | 2022-24923 | 1 | 0 | 09000064854bb10b | |
| FMCSA-2020-0188-0005 | FMCSA | In the Matter of Z-Trans, LLC and High Gear Haulers, LLC - Petition for Administrative Review of Denial of Petition for Rescission of Record Consolidation Order FMCSA-2020-0188 | Applicability of the Registration, Financial Responsibility, and Safety Regulations to Motor Carriers of Passengers | Rule | 2022-11-15T00:00:00Z | 2022 | 11 | 2024-11-07T00:43:45Z | 0 | 1 | 09000064854b0e37 | ||||
| FMCSA-2022-0149-0001 | FMCSA | General Technical, Organizational, Conforming, and Correcting Amendments to the Federal Motor Carrier Safety Regulations FMCSA-2022-0149 | Federal Motor Carrier Safety Regulations: General Technical, Organizational, Conforming, and Correcting Amendments | Rule | Final Rule | 2022-09-29T04:00:00Z | 2022 | 9 | 2022-09-29T04:00:00Z | 2024-11-07T00:43:05Z | 2022-20644 | 1 | 0 | 0900006485380bf4 | |
| FMCSA-2022-0001-0122 | FMCSA | Fees for the Unified Carrier Registration Plan and Agreement FMCSA-2022-0001 | Fees for the Unified Carrier Registration Plan and Agreement; Correction | Rule | Final Rule | 2022-09-08T04:00:00Z | 2022 | 9 | 2022-09-08T04:00:00Z | 2024-11-07T00:42:50Z | 2022-19354 | 1 | 0 | 09000064852ca51c | |
| FMCSA-2022-0189-0001 | FMCSA | Assessment of the Continued Need for COVID-19 Emergency Declaration, Regulatory Relief for Commercial Motor Vehicle Operations FMCSA-2022-0189 | Assessment of the Continued Need for COVID-19 Emergency Declaration, Regulatory Relief for Commercial Motor Vehicle Operations | Rule | Final Rule | 2022-09-07T04:00:00Z | 2022 | 9 | 2022-09-07T04:00:00Z | 2022-09-22T03:59:59Z | 2022-09-26T13:43:22Z | 2022-19304 | 0 | 0 | 09000064852bf75b |
| FMCSA-2022-0001-0117 | FMCSA | Fees for the Unified Carrier Registration Plan and Agreement FMCSA-2022-0001 | Fees for the Unified Carrier Registration Plan and Agreement | Rule | Final Rule | 2022-09-01T04:00:00Z | 2022 | 9 | 2022-09-01T04:00:00Z | 2024-11-12T23:45:04Z | 2022-18944 | 1 | 0 | 09000064852a2a92 | |
| FMCSA-2020-0205-0009 | FMCSA | Implementation of Household Goods Working Group Recommendations FMCSA-2020-0205 | Implementation of Household Goods Working Group Recommendations | Rule | Final Rule | 2022-04-26T04:00:00Z | 2022 | 4 | 2022-04-26T04:00:00Z | 2024-11-12T23:39:02Z | 2022-08808 | 1 | 0 | 0900006485035a92 | |
| FMCSA-2013-0161-0204 | FMCSA | Federal Registers for Applications, Notices, and Orders - Miscellaneous FMCSA-2013-0161 | Civil Monetary Penalty Inflation Adjustment | Rule | Final Rule | 2022-03-21T04:00:00Z | 2022 | 3 | 2022-03-21T04:00:00Z | 2024-11-12T23:39:11Z | 2022-04456 | 1 | 0 | 0900006484fd6912 | |
| FMCSA-2007-27748-1497 | FMCSA | Minimum Training Requirements for Entry-Level Commercial Motor Vehicle Operators FMCSA-2007-27748 | Minimum Training Requirements for Entry-Level Commercial Motor Vehicle Operators; Correcting amendment | Rule | Final Rule | 2022-03-18T04:00:00Z | 2022 | 3 | 2022-03-18T04:00:00Z | 2024-11-07T00:36:57Z | 2022-05709 | 1 | 0 | 0900006484fd351f | |
| FMCSA-2018-0224-0105 | FMCSA | Records of Violations FMCSA-2018-0224 | Record of Violations | Rule | Final Rule | 2022-03-09T05:00:00Z | 2022 | 3 | 2022-03-09T05:00:00Z | 2024-11-12T23:38:35Z | 2022-04930 | 1 | 0 | 0900006484fc1604 | |
| FMCSA-2021-0037-0022 | FMCSA | Windshields: Authorized Area for Installation of Vehicle Safety Technology FMCSA-2021-0037 | Parts and Accessories Necessary for Safe Operation: Authorized Windshield Area for the Installation of Vehicle Safety Technology | Rule | Final Rule | 2022-03-07T05:00:00Z | 2022 | 3 | 2022-03-07T05:00:00Z | 2024-11-12T23:38:01Z | 2022-03996 | 1 | 0 | 0900006484fbc931 | |
| FMCSA-2019-0049-0142 | FMCSA | Qualifications of Drivers; Vision Standard FMCSA-2019-0049 | Qualification of Drivers: Vision Standard; Correction | Rule | Final Rule | 2022-02-10T05:00:00Z | 2022 | 2 | 2022-02-10T05:00:00Z | 2024-11-12T23:37:00Z | 2022-02758 | 1 | 0 | 0900006484f68059 | |
| FMCSA-2020-0197-0001 | FMCSA | Commercial Driver’s License Standards: Regulatory Guidance Concerning Non-government Entities Conducting the Knowledge Test FMCSA-2020-0197 | Commercial Driver's License Standards: Guidance Concerning Third Party Testers Conducting the Knowledge Test | Rule | Policy Statement | 2022-02-03T05:00:00Z | 2022 | 2 | 2022-02-03T05:00:00Z | 2024-11-07T00:36:48Z | 2022-02165 | 1 | 0 | 0900006484f4ffea | |
| FMCSA-2019-0049-0136 | FMCSA | Qualifications of Drivers; Vision Standard FMCSA-2019-0049 | Qualification of Drivers: Vision Standard | Rule | Final Rule | 2022-01-21T05:00:00Z | 2022 | 1 | 2022-01-21T05:00:00Z | 2024-11-07T00:36:26Z | 2022-01021 | 1 | 0 | 0900006484f2ccfc | |
| FMCSA-2021-0063-0005 | FMCSA | Incorporation by Reference; North American Standard Out-of-Service Criteria; Hazardous Materials Safety FMCSA-2021-0063 | Incorporation by Reference; North American Standard Out-of-Service Criteria; Hazardous Materials Safety Permits | Rule | Final Rule | 2021-12-23T05:00:00Z | 2021 | 12 | 2021-12-23T05:00:00Z | 2024-11-12T23:34:50Z | 2021-27851 | 1 | 0 | 0900006484ee7d37 | |
| FMCSA-2019-0211-0026 | FMCSA | Parts and Accessories Necessary for Safe Operations; Rear Impact Guards and Rear Impact Protection FMCSA-2019-0211 | Parts and Accessories Necessary for Safe Operation: Rear Impact Guards and Rear Impact Protection | Rule | Final Rule | 2021-11-09T05:00:00Z | 2021 | 11 | 2021-11-09T05:00:00Z | 2024-11-07T00:33:10Z | 2021-23796 | 1 | 0 | 0900006484e3798b | |
| FMCSA-2017-0330-0037 | FMCSA | Controlled Substances and Alcohol Testing: State Driver's Licensing Agency Downgrade of Commercial Driver's License - NPRM FMCSA-2017-0330 | Controlled Substances and Alcohol Testing: State Driver's Licensing Agency Non-Issuance/Downgrade of Commercial Driver's License; Correction | Rule | Final Rule | 2021-10-29T04:00:00Z | 2021 | 10 | 2021-10-29T04:00:00Z | 2021-10-29T16:19:39Z | 2021-23596 | 0 | 0 | 0900006484dff9f6 | |
| FMCSA-2021-0132-0001 | FMCSA | General Technical, Organizational, Conforming, and Correcting Amendments to the Federal Motor Carrier Safety Regulations FMCSA-2021-0132 | Federal Motor Carrier Safety Regulations; General Technical, Organizational, Conforming, and Correcting Amendments | Rule | Final Rule | 2021-10-14T04:00:00Z | 2021 | 10 | 2021-10-14T04:00:00Z | 2021-10-14T13:34:56Z | 2021-21228 | 0 | 0 | 0900006484dc515e | |
| FMCSA-2017-0330-0036 | FMCSA | Controlled Substances and Alcohol Testing: State Driver's Licensing Agency Downgrade of Commercial Driver's License - NPRM FMCSA-2017-0330 | Controlled Substances and Alcohol Testing: State Driver's Licensing Agency Non-Issuance/Downgrade of Commercial Driver's License | Rule | Final Rule | 2021-10-07T04:00:00Z | 2021 | 10 | 2021-10-07T04:00:00Z | 2021-10-07T13:18:29Z | 2021-21928 | 0 | 0 | 0900006484dbdbec | |
| FMCSA-2013-0161-0186 | FMCSA | Federal Registers for Applications, Notices, and Orders - Miscellaneous FMCSA-2013-0161 | Brokers of Property; CFR Correction | Rule | Final Rule with Request for Comments | 2021-09-27T04:00:00Z | 2021 | 9 | 2021-09-27T04:00:00Z | 2024-11-07T00:32:09Z | 2021-21058 | 1 | 0 | 0900006484daacfc | |
| FMCSA-2019-0081-0012 | FMCSA | Certification for Conducting Driver or Vehicle Inspections, Safety Audits, or Investigations FMCSA-2019-0081 | Certification for Conducting Driver or Vehicle Inspections, Safety Audits, or Investigations | Rule | Final Rule | 2021-08-27T04:00:00Z | 2021 | 8 | 2021-08-27T04:00:00Z | 2021-08-27T13:42:21Z | 2021-18474 | 0 | 0 | 0900006484cabe2f | |
| FMCSA-2020-0198-0001 | FMCSA | Commercial Driver’s License Standards, Requirements and Penalties; Exclusively Electronic Exchange of Driver History Record Information FMCSA-2020-0198 | Commercial Driver's License Standards: Requirements and Penalties; Exclusively Electronic Exchange of Driver History Record Information | Rule | Final Rule | 2021-07-23T04:00:00Z | 2021 | 7 | 2021-07-23T04:00:00Z | 2021-07-26T13:28:34Z | 2021-15693 | 0 | 0 | 0900006484c0a1c8 | |
| FMCSA-2020-0135-0001 | FMCSA | General Technical, Organizational, Conforming, and Correcting Amendments to the Federal Motor Carrier Safety Regulations FMCSA-2020-0135 | General Technical, Organizational, Conforming, and Correcting Amendments to the Federal Motor Carrier Safety Regulations | Rule | Final Rule | 2021-07-07T04:00:00Z | 2021 | 7 | 2021-07-07T04:00:00Z | 2021-07-07T12:42:36Z | 2021-13888 | 0 | 0 | 0900006484bd5eda | |
| FMCSA-2007-27748-1496 | FMCSA | Minimum Training Requirements for Entry-Level Commercial Motor Vehicle Operators FMCSA-2007-27748 | Extension of Compliance Date for Entry-Level Driver Training | Rule | Final Rule | 2021-06-30T04:00:00Z | 2021 | 6 | 2021-06-30T04:00:00Z | 2024-11-06T23:48:40Z | 2021-13893 | 1 | 0 | 0900006484bc2970 | |
| FMCSA-2018-0152-0017 | FMCSA | Extension of Compliance Dates for Medical Examiner's Certification Integration FMCSA-2018-0152 | Medical Examiner's Certification Integration: Extension of Compliance Dates | Rule | Final Rule | 2021-06-22T00:00:00Z | 2021 | 6 | 2021-06-22T00:00:00Z | 2025-05-12T17:29:31Z | 2021-13177 | 0 | 0 | 0900006484b9ed7e | |
| FMCSA-2013-0161-0176 | FMCSA | Federal Registers for Applications, Notices, and Orders - Miscellaneous FMCSA-2013-0161 | Civil Penalty Amounts | Rule | Policy Statement | 2021-05-03T04:00:00Z | 2021 | 5 | 2021-05-03T04:00:00Z | 2021-05-04T18:22:48Z | 2021-08224 | 0 | 0 | 0900006484ac7c28 | |
| FMCSA-2013-0161-0172 | FMCSA | Federal Registers for Applications, Notices, and Orders - Miscellaneous FMCSA-2013-0161 | Administrative Rulemaking, Guidance, and Enforcement Procedures | Rule | Final Rule | 2021-04-02T04:00:00Z | 2021 | 4 | 2021-04-02T04:00:00Z | 2024-11-06T23:45:53Z | 2021-06416 | 1 | 0 | 0900006484a94cd6 | |
| FMCSA-2016-0341-0015 | FMCSA | Rulemaking Procedures Update FMCSA-2016-0341 | Rulemaking Procedures Update; Delay of Effective Date | Rule | Final Rule | 2021-03-01T05:00:00Z | 2021 | 3 | 2021-03-01T05:00:00Z | 2024-11-12T23:29:44Z | 2021-04110 | 1 | 0 | 0900006484a572ec | |
| FMCSA-2013-0161-0166 | FMCSA | Federal Registers for Applications, Notices, and Orders - Miscellaneous FMCSA-2013-0161 | Revisions to Civil Penalty Amounts | Rule | Final Rule | 2021-01-11T05:00:00Z | 2021 | 1 | 2021-01-11T05:00:00Z | 2024-11-06T23:45:04Z | 2020-25236 | 1 | 0 | 09000064849ec3fa | |
| FMCSA-2016-0341-0014 | FMCSA | Rulemaking Procedures Update FMCSA-2016-0341 | Rulemaking Procedures Update | Rule | Final Rule | 2020-12-31T05:00:00Z | 2020 | 12 | 2020-12-31T05:00:00Z | 2024-11-12T23:26:33Z | 2020-27854 | 1 | 0 | 09000064849d654c | |
| FMCSA-2018-0348-0147 | FMCSA | Hours of Service of Drivers; Definition of Agricultural Commodities FMCSA-2018-0348 | Hours of Service of Drivers: Definition of Agricultural Commodity | Rule | Interim Final Rule | 2020-11-24T05:00:00Z | 2020 | 11 | 2020-11-24T05:00:00Z | 2020-12-25T04:59:59Z | 2024-11-06T23:43:12Z | 2020-25971 | 1 | 0 | 0900006484973332 |
| FMCSA-2019-0075-0014 | FMCSA | Passenger Carrier No-Defect Driver Vehicle Inspection Reports FMCSA-2019-0075 | Passenger Carrier No-Defect Driver Vehicle Inspection Reports | Rule | Final Rule | 2020-08-18T04:00:00Z | 2020 | 8 | 2020-08-18T04:00:00Z | 2025-08-05T16:53:45Z | 2020-15667 | 0 | 0 | 090000648480cdfa | |
| FMCSA-2017-0370-0008 | FMCSA | Amendments to Motor Carrier Safety Assistance Program FMCSA-2017-0370 | Motor Carrier Safety Assistance Program | Rule | Final Rule | 2020-06-24T04:00:00Z | 2020 | 6 | 2020-06-24T04:00:00Z | 2024-11-12T23:22:30Z | 2020-11464 | 1 | 0 | 0900006484704372 | |
| FMCSA-2018-0248-8249 | FMCSA | Hours of Service of Drivers FMCSA-2018-0248 | Hours of Service of Drivers | Rule | Final Rule | 2020-06-01T04:00:00Z | 2020 | 6 | 2020-06-01T04:00:00Z | 2020-07-02T03:59:59Z | 2025-07-07T21:25:30Z | 2020-11469 | 0 | 0 | 09000064846bf683 |
| FMCSA-2019-0068-0005 | FMCSA | North American Standard Out -Of- Service Criteria: Hazardous Materials and Safety Permits; Incorporation by Reference” FMCSA-2019-0068 | Incorporation by Reference; North American Standard Out-of-Service Criteria; Hazardous Materials Safety Permits | Rule | Final Rule | 2020-02-24T05:00:00Z | 2020 | 2 | 2020-02-24T05:00:00Z | 2020-02-24T15:17:53Z | 2020-03129 | 0 | 0 | 09000064843a3233 | |
| FMCSA-2019-0066-0010 | FMCSA | Fees for the Unified Carrier Registration Plan and Agreement FMCSA-2019-0066 | Fees for the Unified Carrier Registration Plan and Agreement | Rule | Final Rule | 2020-02-13T05:00:00Z | 2020 | 2 | 2020-02-13T05:00:00Z | 2024-11-06T23:31:42Z | 2020-01761 | 1 | 0 | 0900006484362dd9 | |
| FMCSA-2007-27748-1474 | FMCSA | Minimum Training Requirements for Entry-Level Commercial Motor Vehicle Operators FMCSA-2007-27748 | Extension of Compliance Date for Entry-Level Driver Training | Rule | Final Rule with Request for Comments | 2020-02-04T05:00:00Z | 2020 | 2 | 2020-02-04T05:00:00Z | 2020-03-21T03:59:59Z | 2024-11-12T23:16:53Z | 2020-01548 | 1 | 0 | 09000064843250d0 |
| FMCSA-2019-0120-0015 | FMCSA | Extension of Compliance Date for States’ Query of the Drug and Alcohol Clearinghouse FMCSA-2019-0120 | States' Query of the Drug and Alcohol Clearinghouse; Extension of Compliance Date | Rule | Final Rule | 2019-12-13T05:00:00Z | 2019 | 12 | 2019-12-13T05:00:00Z | 2019-12-13T20:01:16Z | 2019-26943 | 0 | 0 | 090000648420bebd | |
| FMCSA-2013-0161-0139 | FMCSA | Federal Registers for Applications, Notices, and Orders - Miscellaneous FMCSA-2013-0161 | Revisions to Civil Penalty Amounts | Rule | Final Rule | 2019-10-29T04:00:00Z | 2019 | 10 | 2019-10-29T04:00:00Z | 2024-11-12T23:10:26Z | C1-2019-14101 | 1 | 0 | 0900006484103d26 | |
| FMCSA-2001-11117-0095 | FMCSA | Interim Final Rule: Limitations On the Issuance of Commercial Drivers Licenses with a Hazardous Materials Endorsement FMCSA-2001-11117 | Limitations on the Issuance of Commercial Driver's Licenses with a Hazardous Materials Endorsement | Rule | Final Rule | 2019-10-01T04:00:00Z | 2019 | 10 | 2019-10-01T04:00:00Z | 2024-11-12T23:09:35Z | 2019-20584 | 1 | 0 | 0900006483ff2012 | |
| FMCSA-2013-0161-0136 | FMCSA | Federal Registers for Applications, Notices, and Orders - Miscellaneous FMCSA-2013-0161 | General Technical, Organizational, Conforming, and Correcting Amendments to the Federal Motor Carrier Safety Regulations | Rule | Final Rule | 2019-09-30T04:00:00Z | 2019 | 9 | 2019-09-30T04:00:00Z | 2019-10-29T12:17:25Z | 2019-20591 | 0 | 0 | 0900006483feac78 | |
| FMCSA-2004-19608-28514 | FMCSA | Hours of Service of Drivers FMCSA-2004-19608 | Hours of Service of Drivers-Restart provisions | Rule | Final Rule | 2019-09-12T04:00:00Z | 2019 | 9 | 2019-09-12T04:00:00Z | 2024-11-12T23:08:16Z | 2019-19648 | 1 | 0 | 0900006483f43e60 | |
| FMCSA-2012-0103-0170 | FMCSA | Lease, Rental, and Interchange of Vehicles in Interstate Commerce; For-Hire Motor Carriers of Passengers FMCSA-2012-0103 | Lease and Interchange of Vehicles; Motor Carriers of Passengers | Rule | Final Rule | 2019-08-14T04:00:00Z | 2019 | 8 | 2019-08-14T04:00:00Z | 2019-09-14T03:59:59Z | 2024-11-12T23:06:52Z | 2019-17342 | 1 | 0 | 0900006483e48d2c |
| FMCSA-2013-0161-0131 | FMCSA | Federal Registers for Applications, Notices, and Orders - Miscellaneous FMCSA-2013-0161 | Revisions to Civil Penalty Amounts | Rule | Final Rule | 2019-07-31T04:00:00Z | 2019 | 7 | 2019-07-31T04:00:00Z | 2019-10-29T12:18:03Z | 2019-14101 | 0 | 0 | 0900006483dd4981 | |
| FMCSA-2018-0361-0002 | FMCSA | Lifetime Disqualification for Human Trafficking FMCSA-2018-0361 | Lifetime Disqualification for Human Trafficking; Correction | Rule | Final Rule | 2019-07-30T04:00:00Z | 2019 | 7 | 2019-07-30T04:00:00Z | 2019-09-05T13:13:21Z | 2019-16160 | 0 | 0 | 0900006483dcc418 | |
| FMCSA-2018-0361-0001 | FMCSA | Lifetime Disqualification for Human Trafficking FMCSA-2018-0361 | Lifetime Disqualification for Human Trafficking | Rule | Final Rule | 2019-07-23T04:00:00Z | 2019 | 7 | 2019-07-23T04:00:00Z | 2019-09-05T13:13:10Z | 2019-15611 | 0 | 0 | 0900006483da9f2c | |
| FMCSA-2018-0165-0003 | FMCSA | Incorporation by Reference; North American Standard Out-of-Service Criteria; Hazardous materials Safety Permits FMCSA-2018-0165 | North American Standard Out-of-Service Criteria; Hazardous Materials Safety Permits; Incorporation by Reference | Rule | Final Rule | 2019-07-08T04:00:00Z | 2019 | 7 | 2019-07-08T04:00:00Z | 2024-11-12T23:04:22Z | 2019-14226 | 1 | 0 | 0900006483d65d9b | |
| FMCSA-2017-0371-0014 | FMCSA | Entry Level Driver Training; Commercial Driver’s License Upgrade from Class B to Class A FMCSA-2017-0371 | Commercial Driver's License Upgrade from Class B to Class A; Correction | Rule | Final Rule | 2019-03-21T04:00:00Z | 2019 | 3 | 2019-03-21T04:00:00Z | 2024-11-12T22:57:23Z | 2019-05382 | 1 | 0 | 0900006483b0d175 | |
| FMCSA-2016-0429-0001 | FMCSA | Commercial Driver’s License Standards, Requirements and Penalties; Regulatory Guidance FMCSA-2016-0429 | Regulatory Guidance: Commercial Driver's License Standards, Requirements and Penalties | Rule | Final Rule with Request for Comments | 2019-03-08T05:00:00Z | 2019 | 3 | 2019-03-08T05:00:00Z | 2019-05-08T03:59:59Z | 2024-11-12T22:56:36Z | 2019-04180 | 1 | 0 | 0900006483acdc61 |
| FMCSA-2017-0371-0013 | FMCSA | Entry Level Driver Training; Commercial Driver’s License Upgrade from Class B to Class A FMCSA-2017-0371 | Commercial Driver's License Upgrade from Class B to Class A | Rule | Final Rule | 2019-03-06T05:00:00Z | 2019 | 3 | 2019-03-06T05:00:00Z | 2024-11-12T22:55:42Z | 2019-04044 | 1 | 0 | 0900006483ac249d | |
| FMCSA-2018-0068-0010 | FMCSA | Fees for the Unified Carrier Registration Plan and Agreement, 2019 2020 FMCSA-2018-0068 | Fees for the Unified Carrier Registration Plan and Agreement | Rule | Final Rule | 2018-12-28T05:00:00Z | 2018 | 12 | 2018-12-28T05:00:00Z | 2024-11-12T22:51:51Z | 2018-28170 | 1 | 0 | 09000064839cbe21 | |
| FMCSA-2016-0346-0015 | FMCSA | Commercial Learner’s Permit Validity FMCSA-2016-0346 | Commercial Learner's Permit Validity | Rule | Final Rule | 2018-12-21T05:00:00Z | 2018 | 12 | 2018-12-21T05:00:00Z | 2024-11-12T22:53:15Z | 2018-27779 | 1 | 0 | 09000064839be34e | |
| FMCSA-2012-0103-0167 | FMCSA | Lease, Rental, and Interchange of Vehicles in Interstate Commerce; For-Hire Motor Carriers of Passengers FMCSA-2012-0103 | Lease and Interchange of Vehicles; Motor Carriers of Passengers | Rule | Final Rule | 2018-12-04T05:00:00Z | 2018 | 12 | 2018-12-04T05:00:00Z | 2024-11-12T22:50:40Z | 2018-26249 | 1 | 0 | 09000064839390ba | |
| FMCSA-2001-11117-0092 | FMCSA | Interim Final Rule: Limitations On the Issuance of Commercial Drivers Licenses with a Hazardous Materials Endorsement FMCSA-2001-11117 | Limitations on the Issuance of Commercial Driver's Licenses With a Hazardous Materials Endorsement | Rule | Interim Final Rule | 2018-12-04T05:00:00Z | 2018 | 12 | 2018-12-04T05:00:00Z | 2018-12-20T04:59:59Z | 2019-09-05T13:11:08Z | 2018-26250 | 0 | 0 | 0900006483939695 |
| FMCSA-2013-0161-0127 | FMCSA | Federal Registers for Applications, Notices, and Orders - Miscellaneous FMCSA-2013-0161 | Revisions to Civil Penalty Amounts | Rule | Final Rule | 2018-11-27T05:00:00Z | 2018 | 11 | 2018-11-27T05:00:00Z | 2018-11-27T14:45:42Z | 2018-24930 | 0 | 0 | 09000064838fe7ef | |
| FMCSA-2017-0047-0021 | FMCSA | Military Licensing and State CDL Reciprocity FMCSA-2017-0047 | Military Licensing and State Commercial Driver's License Reciprocity | Rule | Final Rule | 2018-09-28T04:00:00Z | 2018 | 9 | 2018-09-28T04:00:00Z | 2019-09-04T14:54:44Z | 2018-21289 | 0 | 0 | 090000648377f62b | |
| FMCSA-2013-0161-0120 | FMCSA | Federal Registers for Applications, Notices, and Orders - Miscellaneous FMCSA-2013-0161 | General Technical, Organizational, Conforming, and Correcting Amendments to the Federal Motor Carrier Safety Regulations | Rule | Final Rule | 2018-09-27T04:00:00Z | 2018 | 9 | 2018-09-27T04:00:00Z | 2019-10-29T12:20:34Z | 2018-21064 | 0 | 0 | 090000648377a118 |
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;