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

61 rows where docket_id = "FRA-1999-6254" sorted by posted_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

posted_year 14

  • 2005 18
  • 2012 5
  • 2019 5
  • 2020 5
  • 2006 4
  • 2008 4
  • 2013 4
  • 2018 4
  • 1999 3
  • 2011 3
  • 2025 3
  • 2000 1
  • 2016 1
  • 2017 1

document_type 4

  • Other 50
  • Notice 4
  • Rule 4
  • Supporting & Related Material 3

agency_id 1

  • FRA 61
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-1999-6254-0061 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 New Document created by Madduri, Sridevi (FRA) Other Decision 2025-10-08T04:00:00Z 2025 10 2025-10-08T04:00:00Z   2025-10-08T19:14:39Z   0 0 09000064b8fee057
FRA-1999-6254-0060 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Petition for Extension of Waiver of Compliance Notice Request for Comments 2025-07-11T04:00:00Z 2025 7 2025-07-11T04:00:00Z 2025-08-12T03:59:59Z 2025-07-11T17:09:33Z 2025-12939 0 0 09000064b8e65954
FRA-1999-6254-0059 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 FRA-1999-6254 Incoming Waiver Extension Petition 2025 Other Waiver 2025-05-06T04:00:00Z 2025 5 2025-05-06T04:00:00Z   2025-05-21T20:27:11Z   0 0 0900006486a93672
FRA-1999-6254-0058 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 U.S. DOT/FRA- Decision Letter 2020 Other Decision 2020-10-14T04:00:00Z 2020 10 2020-10-14T04:00:00Z   2020-10-14T14:53:43Z   0 0 09000064848dff38
FRA-1999-6254-0057 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Petition for Waiver of Compliance Notice Waivers 2020-07-27T04:00:00Z 2020 7 2020-07-27T04:00:00Z   2024-11-06T23:38:43Z 2020-16229 1 0 09000064847a93b8
FRA-1999-6254-0056 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Letter to FRA Requesting Waiver Extension - July 2020 Other Waiver 2020-07-23T04:00:00Z 2020 7 2020-07-23T04:00:00Z   2020-07-23T17:19:33Z   0 0 090000648476e5db
FRA-1999-6254-0055 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Incoming Waiver Extension Petition 2020 Other Waiver 2020-07-23T04:00:00Z 2020 7 2020-07-23T04:00:00Z   2020-07-23T17:18:13Z   0 0 090000648477f716
FRA-1999-6254-0054 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 U.S. DOT/FRA- Waiver Extension Acknowledgement Letter 2020 Other Acknowledgement Letter/Receipt 2020-07-23T04:00:00Z 2020 7 2020-07-23T04:00:00Z   2020-07-23T17:16:06Z   0 0 0900006484780d68
FRA-1999-6254-0053 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Incoming Letter Other Acknowledgement Letter/Receipt 2019-09-20T04:00:00Z 2019 9 2019-09-25T04:00:00Z   2019-09-25T18:12:13Z   0 0 0900006483f8f0fb
FRA-1999-6254-0052 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 U.S. DOT/FRA- SCVTA Decision Letter 2019 Other Decision 2019-08-09T04:00:00Z 2019 8 2019-08-09T04:00:00Z   2019-08-09T18:32:17Z   0 0 0900006483d9146b
FRA-1999-6254-0050 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 U.S. DOT/FRA-1999-6254 Incoming Request 2019 Other Request 2019-04-18T04:00:00Z 2019 4 2019-04-18T04:00:00Z   2024-11-12T22:58:55Z   1 0 0900006483ba516d
FRA-1999-6254-0051 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 U.S. DOT/FRA-1999-6254 Waiver Extension Acknowledgement Letter Other Acknowledgement Letter/Receipt 2019-04-18T04:00:00Z 2019 4 2019-04-18T04:00:00Z   2024-11-12T22:59:01Z   1 0 0900006483bae1c9
FRA-1999-6254-0049 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 U.S. DOT/FRA- Expiration Notice 2019 Other Letter(s) 2019-03-01T05:00:00Z 2019 3 2019-03-01T05:00:00Z   2019-03-01T16:43:11Z   0 0 0900006483aa80d8
FRA-1999-6254-0048 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 U.S. DOT/FRA-SCVTA Decision Letter 2018 Other Decision 2018-09-20T04:00:00Z 2018 9 2018-09-20T04:00:00Z   2018-09-20T18:32:26Z   0 0 0900006483717738
FRA-1999-6254-0047 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Petitions for Waivers of Compliance: Santa Clara Valley Transportation Authority Notice Waivers 2018-05-24T04:00:00Z 2018 5 2018-05-24T04:00:00Z   2024-11-07T01:27:24Z 2018-11079 1 0 09000064832d8985
FRA-1999-6254-0046 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 U.S. DOT/FRA-(SCVTA) Waiver Extension Acknowledgement Letter Other Acknowledgement Letter/Receipt 2018-05-11T04:00:00Z 2018 5 2018-05-11T04:00:00Z   2018-05-11T13:29:39Z   0 0 0900006483258663
FRA-1999-6254-0045 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Waiver Extension 2018 Request Other Waiver 2018-05-11T04:00:00Z 2018 5 2018-05-11T04:00:00Z   2018-05-11T13:25:58Z   0 0 090000648325865f
FRA-1999-6254-0044 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 U.S. DOT/FRA- Expiration Notice Other Waiver 2017-11-21T05:00:00Z 2017 11 2017-11-21T05:00:00Z   2017-11-21T15:43:45Z   0 0 0900006482c4b08c
FRA-1999-6254-0043 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Santa Clara Valley Transportation Authority - Reply Other Reply 2016-02-01T05:00:00Z 2016 2 2016-02-01T05:00:00Z   2024-11-07T23:33:41Z   1 0 0900006481db34d5
FRA-1999-6254-0042 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 U.S. DOT/FRA - Decision Letter - (Santa Clara Valley Transportation Authority - Shared Use) Other Decision 2013-05-14T04:00:00Z 2013 5 2013-05-14T04:00:00Z   2024-11-12T05:18:23Z   1 0 09000064812c4078
FRA-1999-6254-0041 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Petitions for Waivers of Compliance Notice Notice of Receipt of Petition 2013-02-25T05:00:00Z 2013 2 2013-02-25T05:00:00Z 2013-04-12T03:59:59Z 2024-11-07T22:52:49Z 2013-04243 1 0 09000064812069cb
FRA-1999-6254-0040 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 U.S. DOT/FRA - Waiver Extension Acknowledgement Other Acknowledgement Letter/Receipt 2013-01-29T05:00:00Z 2013 1 2013-01-29T05:00:00Z   2024-11-12T05:10:53Z   1 0 0900006481195f8c
FRA-1999-6254-0039 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 U.S. DOT/FRA - Incoming Waiver Extension Request Other Waiver 2013-01-29T05:00:00Z 2013 1 2013-01-29T05:00:00Z   2024-11-12T05:11:52Z   1 0 0900006481195efe
FRA-1999-6254-0038 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 U.S. DOT/FRA - Waiver Expiration Notice Other Waiver 2012-11-21T05:00:00Z 2012 11 2012-11-21T05:00:00Z   2024-11-12T05:08:36Z   1 0 090000648116e4e2
FRA-1999-6254-0037 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 U.S. DOT/FRA - Acknowledgement Letter Other Acknowledgement Letter/Receipt 2012-02-10T05:00:00Z 2012 2 2012-02-10T05:00:00Z   2024-11-07T22:00:58Z   1 0 0900006480fb1033
FRA-1999-6254-0036 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 SCVTA - Waiver Extension Request Other Request 2012-02-10T05:00:00Z 2012 2 2012-02-10T05:00:00Z   2024-11-07T22:25:56Z   1 0 0900006480fb0ef3
FRA-1999-6254-0035 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 U.S. DOT/FRA - Decision Letter (Santa Clara Valley Transportation Authority - Vasona Shared Corridor) Other Decision 2012-02-10T05:00:00Z 2012 2 2012-02-10T05:00:00Z   2024-11-07T22:25:57Z   1 0 0900006480fb0ef1
FRA-1999-6254-0034 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Council for Santa Clara Valley Transportation Authority Other Response(s) 2012-02-06T05:00:00Z 2012 2 2012-02-06T05:00:00Z   2013-03-06T03:33:45Z   0 0 0900006480fad1ad
FRA-1999-6254-0033 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 U.S. DOT/FRA - Acknowledgement Letter Other Acknowledgement Letter/Receipt 2011-07-13T04:00:00Z 2011 7 2011-07-13T04:00:00Z   2013-08-11T03:15:52Z   0 0 0900006480ec17be
FRA-1999-6254-0032 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Santa Clara Valley Transportation Authority - Additional Information Other Additional Information 2011-07-13T04:00:00Z 2011 7 2011-07-13T04:00:00Z   2024-11-07T22:35:22Z   1 0 0900006480ec0ce2
FRA-1999-6254-0031 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Valley Transportation Authority - Additional Information Other Additional Information 2011-06-06T04:00:00Z 2011 6 2011-06-06T04:00:00Z   2013-07-27T23:54:59Z   0 0 0900006480e3c8d4
FRA-1999-6254-0030 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Santa Clara Valley Transportation Authority - Notification of Provisional Removal of a Railroad Switch Providing Entry to a Shared Light Rail Line Other Other 2008-12-18T05:00:00Z 2008 12 2008-12-18T05:00:00Z   2013-07-27T22:29:26Z   0 0 0900006480788345
FRA-1999-6254-0029 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 U.S. DOT/FRA - Response Letter Regarding Review of SCVTA's Letter of April 25, 2008, Regarding Lincoln/UPRR Crossover Other Response(s) 2008-08-06T04:00:00Z 2008 8 2008-08-06T04:00:00Z   2024-11-12T04:16:32Z   1 0 09000064806b031f
FRA-1999-6254-0028 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Petition for Waiver of Compliance Rule Federal Register Publication 2008-06-04T04:00:00Z 2008 6 2008-06-04T04:00:00Z   2008-06-04T14:26:06Z E8-12405 0 0 090000648060fdf4
FRA-1999-6254-0027 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Santa Clara Valley Transportation Authority (SCVTA) - Request for Review & Approval of Removal of All Facilities Associated with the Lincoln/UPRR Crossover Other Request 2008-05-20T04:00:00Z 2008 5 2008-05-20T04:00:00Z   2013-07-27T21:49:39Z   0 0 09000064805ab48f
FRA-1999-6254-0025 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 U.S. DOT/FRA - Petition for Waiver of Compliance - Santa Clara Valley Transportation Authority Rule Federal Register Publication 2006-12-12T05:00:00Z 2006 12 2006-12-12T05:00:00Z 2006-12-13T04:59:59Z 2024-11-08T03:50:53Z   1 0 09000064802a80b9
FRA-1999-6254-0026-0002 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Santa Clara Valley Transportation Authority - Second Supplemental Waiver Petition Other Waiver 2006-12-11T05:00:00Z 2006 12 2006-12-11T05:00:00Z 2006-12-12T04:59:59Z 2024-11-08T03:50:53Z   1 0 09000064802a80bb
FRA-1999-6254-0026-0001 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Santa Clara Valley Transportation Authority - Second Supplemental Waiver Petition Other Waiver 2006-12-11T05:00:00Z 2006 12 2006-12-11T05:00:00Z 2006-12-12T04:59:59Z 2024-11-08T03:50:53Z   1 0 09000064802a80ba
FRA-1999-6254-0024 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 U.S. DOT/FRA - Enclosure Other Waiver 2006-01-12T05:00:00Z 2006 1 2006-01-12T05:00:00Z 2006-01-13T04:59:59Z 2024-11-08T03:50:27Z   1 0 09000064802a80b8
FRA-1999-6254-0022 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Santa Clara Valley Transportation Authority - Correspondence Other Correspondence 2005-11-21T05:00:00Z 2005 11 2005-11-21T05:00:00Z 2005-11-22T04:59:59Z 2024-11-08T03:50:27Z   1 0 09000064802a80b6
FRA-1999-6254-0023 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Santa Clara Valley Transportation Authority - Correspondence re: Waiver Petition (June 22, 2005) Other Correspondence 2005-11-21T05:00:00Z 2005 11 2005-11-21T05:00:00Z 2005-11-22T04:59:59Z 2024-11-08T03:50:27Z   1 0 09000064802a80b7
FRA-1999-6254-0021 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 U.S. DOT/FRA - Reply Other Reply 2005-10-04T04:00:00Z 2005 10 2005-10-04T04:00:00Z 2005-10-05T03:59:59Z 2024-11-08T03:50:26Z   1 0 09000064802a80b5
FRA-1999-6254-0011 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 U.S. DOT/FRA - Approval of Waiver Petition Other Decision 2005-09-02T04:00:00Z 2005 9 2005-09-02T04:00:00Z 2005-09-03T03:59:59Z 2024-11-08T03:49:58Z   1 0 09000064802a80a8
FRA-1999-6254-0017 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Santa Clara Valley Transportation Authority - Decision Other Decision 2005-09-02T04:00:00Z 2005 9 2005-09-02T04:00:00Z 2005-09-03T03:59:59Z 2024-11-08T03:50:26Z   1 0 09000064802a80b0
FRA-1999-6254-0019 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Santa Clara Valley Transportation Authority - "UPRR Harwood Spur" Operations Supporting & Related Material Analysis 2005-09-02T04:00:00Z 2005 9     2024-11-08T03:50:26Z   0 0 09000064802a80b2
FRA-1999-6254-0020 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Santa Clara Valley Transportation Authority - "UPRR Harwood Spur" Operations Supporting & Related Material Analysis 2005-09-02T04:00:00Z 2005 9     2024-11-08T03:50:26Z   0 0 09000064802a80b4
FRA-1999-6254-0014 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Santa Clara Transportation Authority - Inspection Report Other Report 2005-09-02T04:00:00Z 2005 9 2005-09-02T04:00:00Z 2005-09-03T03:59:59Z 2024-11-08T03:49:59Z   1 0 09000064802a80ad
FRA-1999-6254-0012 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 McLeod, Watkinson & Miller - Letter of Clarification Other Letter(s) 2005-09-02T04:00:00Z 2005 9 2005-09-02T04:00:00Z 2005-09-03T03:59:59Z 2024-11-08T03:49:58Z   1 0 09000064802a80ab
FRA-1999-6254-0018 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Santa Clara Valley Transportation Authority - Response to Comments Other Response(s) 2005-09-02T04:00:00Z 2005 9 2005-09-02T04:00:00Z 2005-09-03T03:59:59Z 2024-11-08T03:50:26Z   1 0 09000064802a80b1
FRA-1999-6254-0013 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Santa Clara Valley Transportation Authority - Letter of Clarification Other Letter(s) 2005-09-02T04:00:00Z 2005 9 2005-09-02T04:00:00Z 2005-09-03T03:59:59Z 2024-11-08T03:49:58Z   1 0 09000064802a80ac
FRA-1999-6254-0016 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 State of California - Inspection Report Other Report 2005-09-02T04:00:00Z 2005 9 2005-09-02T04:00:00Z 2005-09-03T03:59:59Z 2024-11-08T03:50:25Z   1 0 09000064802a80af
FRA-1999-6254-0015 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Santa Clara Transportation Authority - Inspection Report Other Report 2005-09-02T04:00:00Z 2005 9 2005-09-02T04:00:00Z 2005-09-03T03:59:59Z 2024-11-08T03:50:25Z   1 0 09000064802a80ae
FRA-1999-6254-0010 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Union Pacific Railroad Company - Letter in Support Other Letter(s) in Support 2005-08-17T04:00:00Z 2005 8 2005-08-17T04:00:00Z 2005-08-18T03:59:59Z 2024-11-08T03:49:58Z   1 0 09000064802a80a7
FRA-1999-6254-0009 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Santa Clara Valley Transportation Authority - Statements & Enclosures to Supplement and Amend a Supplemental Petition for Waiver of Regulations, Dated June 22, 2005 Supporting & Related Material Supplement 2005-08-03T04:00:00Z 2005 8     2024-11-08T03:50:54Z   0 0 09000064802a80c2
FRA-1999-6254-0008 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Santa Clara Valley Transportation Authority - Supplemental Waiver Petition Other Waiver 2005-07-29T04:00:00Z 2005 7 2005-07-29T04:00:00Z 2005-07-30T03:59:59Z 2024-11-08T03:50:54Z   1 0 09000064802a80c1
FRA-1999-6254-0007 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 U.S. DOT/FRA - Grant of Waiver Petition Other Decision 2005-07-27T04:00:00Z 2005 7 2005-07-27T04:00:00Z 2005-07-28T03:59:59Z 2024-11-08T03:50:53Z   1 0 09000064802a80c0
FRA-1999-6254-0006 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 U.S. DOT/FRA - Petition for Waiver of Compliance - Santa Clara Valley Transportation Authority (VTA) Rule Federal Register Publication 2005-07-21T04:00:00Z 2005 7 2005-07-21T04:00:00Z 2005-07-22T03:59:59Z 2024-11-08T03:50:53Z   1 0 09000064802a80bf
FRA-1999-6254-0005 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 U.S. DOT/FRA - Letter Granting Waiver Other Memo, Action Memo or Letter 2000-07-12T04:00:00Z 2000 7 2000-07-12T04:00:00Z 2000-07-13T03:59:59Z 2024-11-08T03:50:53Z   1 0 09000064802a80be
FRA-1999-6254-0004 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Oppenheimer Wolfe Donnelly & Bayh LLP - Response Other Response(s) 1999-12-20T05:00:00Z 1999 12 1999-12-20T05:00:00Z 1999-12-21T04:59:59Z 2024-11-08T03:50:53Z   1 0 09000064802a80bd
FRA-1999-6254-0002 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 U.S. DOT/FRA - Petition for Waivers of Compliance; Petition for Exemption for Technological Improvements Rule Federal Register Publication 1999-11-01T05:00:00Z 1999 11 1999-11-01T05:00:00Z 1999-11-02T04:59:59Z 2024-11-08T03:50:26Z   1 0 09000064802a80b3
FRA-1999-6254-0001 FRA Santa Clara Valley Transportation Authority - Special Notice - Waiver FRA-1999-6254 Santa Clara Valley Transportation Authority - Special Notice - Waiver Other Petition(s) 1999-09-23T04:00:00Z 1999 9 1999-09-23T04:00:00Z 1999-09-24T03:59:59Z 2024-11-08T03:49:58Z   1 0 09000064802a80a6

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