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

53 rows where agency_id = "ITA" and document_type = "Proposed Rule" sorted by posted_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

posted_year 15

  • 2012 10
  • 2011 8
  • 2016 5
  • 2020 5
  • 2010 4
  • 2013 4
  • 2006 3
  • 2008 3
  • 2022 3
  • 2007 2
  • 2023 2
  • 2014 1
  • 2019 1
  • 2024 1
  • 2025 1

document_type 1

  • Proposed Rule · 53 ✖

agency_id 1

  • ITA · 53 ✖
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
ITA-2025-0003-0001 ITA Determining and Applying Unaffiliated Reseller Assessment Rates; Application of Alternative Comparison Methodology in Antidumping Proceedings; Modification or Removal of Countervailing Duty Expedited Reviews ITA-2025-0003 Determining and Applying Unaffiliated Reseller Assessment Rates; Countervailing Duty Expedited Reviews Proposed Rule   2025-06-04T04:00:00Z 2025 6 2025-06-04T04:00:00Z 2025-07-08T03:59:59Z 2025-07-09T09:00:35Z 2025-10158 0 0 09000064b8dd7a81
ITA-2024-0005-0001 ITA Regulations Enhancing the Administration of the Antidumping and Countervailing Duty Trade Remedy Laws ITA-2024-0005 Administration of the Antidumping and Countervailing Duty Trade Remedy Laws Proposed Rule   2024-07-12T04:00:00Z 2024 7 2024-07-12T04:00:00Z 2024-09-11T03:59:59Z 2024-09-12T01:00:37Z 2024-15086 0 0 09000064865eb268
ITA-2023-0007-0001 ITA Foreign-Trade Zones Board Proceedings ITA-2023-0007 Board Proceedings Proposed Rule   2023-07-13T04:00:00Z 2023 7 2023-07-13T04:00:00Z 2023-07-11T03:59:59Z 2023-07-13T17:45:31Z 2023-12123 0 0 0900006485aeb3a0
ITA-2023-0003-0001 ITA Regulations Improving and Strengthening the Enforcement of Trade Remedies Through the Administration of the Antidumping and Countervailing Duty Laws ITA-2023-0003 Improving and Strengthening the Enforcement of Trade Remedies Through the Administration of the Antidumping and Countervailing Duty Laws Proposed Rule   2023-05-09T04:00:00Z 2023 5 2023-05-09T04:00:00Z 2023-07-11T03:59:59Z 2023-07-12T01:01:16Z 2023-09052 0 0 09000064859e4696
ITA-2022-0013-0001 ITA Administrative Protective Order, Service, and Other Procedures in Antidumping and Countervailing Duty Proceedings ITA-2022-0013 Administrative Protective Order, Service, and Other Procedures in Antidumping and Countervailing Duty Proceedings Proposed Rule   2022-11-28T05:00:00Z 2022 11 2022-11-28T05:00:00Z 2022-12-29T04:59:59Z 2022-12-29T02:01:16Z 2022-25675 0 0 0900006485504650
ITA-2022-0012-0001 ITA Determining the Existence of A Particular Market Situation that Distorts Costs of Production ITA-2022-0012 Determining the Existence of a Particular Market Situation that Distorts Costs of Production Proposed Rule   2022-11-18T05:00:00Z 2022 11 2022-11-18T05:00:00Z 2022-12-19T04:59:59Z 2022-12-20T02:00:43Z 2022-25216 0 0 09000064854d02a2
ITA-2022-0006-0001 ITA Procedures Covering Suspension of Liquidation, Duties and Estimated Duties in Accord with Presidential Proclamation 10414 ITA-2022-0006 Procedures Covering Suspension of Liquidation, Duties and Estimated Duties Proposed Rule   2022-07-01T04:00:00Z 2022 7 2022-07-01T04:00:00Z 2022-08-02T03:59:59Z 2022-08-03T01:00:35Z 2022-14241 0 0 09000064851ae626
ITA-2020-0001-0051 ITA Modifications to Regulations to Improve Administration and Enforcement of Antidumping and Countervailing Duty Laws ITA-2020-0001 Regulations to Improve Administration and Enforcement of Antidumping and Countervailing Duty Laws; Extension of Comment Period to Allow Submissions of Rebuttal Comments and Requirement of Electronic Submission of Comments and Rebuttal Comments Proposed Rule   2020-09-28T04:00:00Z 2020 9 2020-09-28T04:00:00Z 2020-09-29T03:59:59Z 2020-09-30T01:03:15Z 2020-20037 0 0 090000648484f26d
ITA-2020-0001-0001 ITA Modifications to Regulations to Improve Administration and Enforcement of Antidumping and Countervailing Duty Laws ITA-2020-0001 Improving Administration and Enforcement of Antidumping and Countervailing Duty Laws Proposed Rule   2020-08-13T04:00:00Z 2020 8 2020-08-13T04:00:00Z 2020-09-15T03:59:59Z 2020-09-16T01:02:30Z 2020-15283 0 0 09000064847fa52a
ITA_FRDOC_0001-6227 ITA Recently Posted ITA Rules and Notices. ITA_FRDOC_0001 Steel Import Monitoring and Analysis System: Modification of Regulations; Correction Proposed Rule   2020-06-22T04:00:00Z 2020 6 2020-06-22T04:00:00Z   2020-06-22T11:51:41Z 2020-12947 0 0 09000064846fdd87
ITA_FRDOC_0001-6085 ITA Recently Posted ITA Rules and Notices. ITA_FRDOC_0001 Aluminum Import Monitoring and Analysis System Proposed Rule   2020-04-29T04:00:00Z 2020 4 2020-04-29T04:00:00Z 2020-05-30T03:59:59Z 2020-05-30T01:02:19Z 2020-07791 0 0 090000648450bca8
ITA_FRDOC_0001-6004 ITA Recently Posted ITA Rules and Notices. ITA_FRDOC_0001 Modification of Regulations Regarding the Steel Import Monitoring and Analysis System Proposed Rule   2020-03-30T04:00:00Z 2020 3 2020-03-30T04:00:00Z 2020-04-30T03:59:59Z 2020-05-01T01:02:15Z 2020-06213 0 0 0900006484476db9
ITA-2019-0002-0002 ITA Modification of Regulations Regarding Benefit and Specificity in Countervailing Duty Proceedings ITA-2019-0002 Modification of Regulations Regarding Benefit and Specificity in Countervailing Duty Proceedings Proposed Rule   2019-05-28T04:00:00Z 2019 5 2019-05-28T04:00:00Z 2019-06-28T03:59:59Z 2019-07-03T01:04:05Z 2019-11197 0 0 0900006483ccb561
ITA-2016-0008-0001 ITA Steel Import Monitoring and Analysis System ITA-2016-0008 Steel Import Monitoring and Analysis System Proposed Rule   2016-10-13T04:00:00Z 2016 10 2016-10-13T04:00:00Z 2016-11-15T04:59:59Z 2016-11-15T02:01:09Z 2016-24649 0 0 09000064822f2f87
ITA-2016-0009-0001 ITA Modification of Regulations Regarding Basis for Normal Value ITA-2016-0009 Modification of Regulations Regarding Basis for Normal Value Proposed Rule   2016-08-25T04:00:00Z 2016 8 2016-08-25T04:00:00Z 2016-09-27T03:59:59Z 2016-09-27T01:00:53Z 2016-20417 0 0 090000648219bd62
ITA-2016-0005-0001 ITA Advance Notice of Proposed Rulemaking and Reiteration of the Current Trade Fair Certification Program. ITA-2016-0005 Clarification and Update of the Trade Fair Certification Program Proposed Rule   2016-07-29T04:00:00Z 2016 7 2016-07-29T04:00:00Z 2016-08-20T03:59:59Z 2016-08-20T01:00:28Z 2016-17414 0 0 0900006482138bca
ITA_FRDOC_0001-2796 ITA Recently Posted ITA Rules and Notices. ITA_FRDOC_0001 Price Adjustments in Antidumping Duty Proceedings Proposed Rule   2016-06-20T04:00:00Z 2016 6 2016-06-20T04:00:00Z 2016-07-06T03:59:59Z 2016-06-20T11:50:07Z 2016-14427 0 0 090000648204f9c8
ITA-2016-0001-0006 ITA Modification of Regulation Regarding Written Argument: Establishing Word Limits for Case and Rebuttal Briefs in Antidumping and Countervailing Duty Proceedings ITA-2016-0001 Word Limits for Case and Rebuttal Briefs in Antidumping and Countervailing Duty Proceedings Proposed Rule   2016-05-20T04:00:00Z 2016 5 2016-05-20T04:00:00Z 2016-06-21T03:59:59Z 2016-06-24T01:01:08Z 2016-11864 0 0 0900006481fe3ba1
ITA-2015-0001-0002 ITA Proposed Rule Amendment to Price Adjustment Regulations (79 FR 78742) (Dep't of Commerce Dec 31 2014) ITA-2015-0001 Price Adjustments in Antidumping Duty Proceedings Proposed Rule   2014-12-31T05:00:00Z 2014 12 2014-12-31T05:00:00Z 2015-01-31T04:59:59Z 2015-02-04T17:47:03Z 2014-30664 0 0 090000648199be8d
ITA-2013-0001-0001 ITA Modification of Regulations Regarding Time Limits for Submission of Information Pertaining To Requests for Sampling In Antidumping Duty Administrative Reviews ITA-2013-0001 Time Limits for Submission of Information Pertaining to Requests for Sampling in Antidumping Duty Administrative Reviews Proposed Rule   2013-11-19T05:00:00Z 2013 11 2013-11-19T05:00:00Z 2014-01-01T04:59:59Z 2014-01-14T20:47:52Z 2013-27442 0 0 09000064814895b7
ITA-2013-0002-0001 ITA Non-Application of Previously Withdrawn Regulatory Provisions Governing Targeted Dumping in Antidumping Duty Investigations ITA-2013-0002 Non-Application of Previously Withdrawn Regulatory Provisions Governing Targeted Dumping in Antidumping Duty Investigations Proposed Rule   2013-10-18T04:00:00Z 2013 10 2013-10-18T04:00:00Z 2013-11-19T04:59:59Z 2013-11-24T03:19:16Z 2013-23646 0 0 09000064814549d4
ITA_FRDOC_0001-0735 ITA Recently Posted ITA Rules and Notices. ITA_FRDOC_0001 Non-Application of Previously Withdrawn Regulatory Provisions Governing Targeted Dumping in Antidumping Duty Investigations Proposed Rule   2013-10-01T04:00:00Z 2013 10 2013-10-01T04:00:00Z 2013-11-01T03:59:59Z 2013-10-01T13:15:10Z 2013-23646 0 0 09000064814422bb
ITA-2012-0006-0002 ITA Modification of Regulation Regarding the Extension of Time Limits for Submissions in Antidumping (AD) and Countervailing Duty (CVD) Proceedings ITA-2012-0006 Extension of Time Limits Proposed Rule   2013-01-16T05:00:00Z 2013 1 2013-01-16T05:00:00Z 2013-03-19T03:59:59Z 2013-03-19T02:02:32Z 2013-00833 0 0 09000064811c05f9
ITA-2012-0005-0002 ITA Steel Import Monitoring and Analysis System ITA-2012-0005 Steel Import Monitoring and Analysis System Proposed Rule   2012-11-13T05:00:00Z 2012 11 2012-11-13T05:00:00Z 2012-12-14T04:59:59Z 2012-12-14T03:00:43Z 2012-27539 0 0 0900006481165ea9
ITA_FRDOC_0001-0153 ITA Recently Posted ITA Rules and Notices. ITA_FRDOC_0001 Steel Import Monitoring and Analysis System Proposed Rule   2012-11-13T05:00:00Z 2012 11 2012-11-13T05:00:00Z 2012-12-14T04:59:59Z 2012-11-13T14:48:36Z 2012-27539 0 0 0900006481165c7a
ITA_FRDOC_0001-0048 ITA Recently Posted ITA Rules and Notices. ITA_FRDOC_0001 Definition of Factual Information and Time Limits for Submission of Factual Information Proposed Rule   2012-08-23T04:00:00Z 2012 8 2012-08-23T04:00:00Z 2012-09-25T03:59:59Z 2012-08-23T13:06:00Z 2012-20785 0 0 09000064810ec248
ITA_FRDOC_0001-0038 ITA Recently Posted ITA Rules and Notices. ITA_FRDOC_0001 Definition of Factual Information and Time Limits for Submission of Factual Information: Correction Proposed Rule   2012-07-17T04:00:00Z 2012 7 2012-07-17T04:00:00Z   2012-08-01T15:41:40Z 2012-17284 0 0 090000648109da7e
ITA_FRDOC_0001-0037 ITA Recently Posted ITA Rules and Notices. ITA_FRDOC_0001 Definition of Factual Information and Time Limits for Submission of Factual Information Proposed Rule   2012-07-10T04:00:00Z 2012 7 2012-07-10T04:00:00Z 2012-08-25T03:59:59Z 2012-07-10T13:14:17Z 2012-16715 0 0 0900006481082686
ITA-2012-0004-0001 ITA Modification of Regulations Regarding the Definition of Factual Information and Time Limits for Submission of Factual Information ITA-2012-0004 Modification of Regulations Regarding the Definition of Factual Information and Time Limits for Submission of Factual Information Proposed Rule Notice of Proposed Rulemaking (NPRM) 2012-07-10T04:00:00Z 2012 7 2012-07-10T04:00:00Z 2012-09-25T03:59:59Z 2012-09-25T02:01:00Z 2012-16715 0 0 0900006481082d11
ITA-2012-0002-0001 ITA Proposed Modification to Regulation Concerning the Use of Market Economy Input Prices in Non-Market Economy Proceedings ITA-2012-0002 Use of Market Economy Input Prices in Nonmarket Economy Proceedings Proposed Rule   2012-06-28T04:00:00Z 2012 6 2012-06-28T04:00:00Z 2012-07-31T03:59:59Z 2012-08-01T17:17:41Z 2012-15436 0 0 090000648106d0f8
ITA-2012-0003-0001 ITA Regulation Strengthening Accountability of Attorneys and Non-Attorney Representatives Appearing before the Department ITA-2012-0003 Regulation Strengthening Accountability of Attorneys and Non-Attorney Representatives Appearing Before the Department Proposed Rule Notice of Proposed Rulemaking (NPRM) 2012-06-26T04:00:00Z 2012 6 2012-06-26T04:00:00Z 2012-08-11T03:59:59Z 2012-08-11T02:01:33Z   0 0 09000064810680a8
ITA-2012-0003-0003 ITA Regulation Strengthening Accountability of Attorneys and Non-Attorney Representatives Appearing before the Department ITA-2012-0003 Duplicate Proposed Rule   2012-06-26T00:00:00Z 2012 6     2012-08-01T17:52:57Z   0 1 09000064810686b3
ITA_FRDOC_0001-0031 ITA Recently Posted ITA Rules and Notices. ITA_FRDOC_0001 Withdrawal of Regulations: Imports of Cotton Woven Fabric, Short Supply Procedures Proposed Rule   2012-02-03T05:00:00Z 2012 2 2012-02-03T05:00:00Z 2012-04-04T03:59:59Z 2012-02-03T14:04:44Z 2012-02227 0 0 0900006480facf0a
ITA-2011-0005-0001 ITA Modification of Regulations Regarding the Practice of Accepting Bonds During the Provisional Measures Period in Antidumping and Countervailing Duty Investigations ITA-2011-0005 Modification of Regulations Regarding the Practice of Accepting Bonds During the Provisional Measures Period in Antidumping and Countervailing Duty Investigations Proposed Rule   2011-05-03T04:00:00Z 2011 5 2011-05-03T04:00:00Z 2011-05-27T03:59:59Z 2011-06-11T17:31:05Z   0 0 0900006480c3e320
ITA-2010-0012-0004 ITA Foreign-Trade Zones in the United States Proposed Rule; Request for Comments. ITA-2010-0012 Proposed Revisions to the FTZ Regulations Proposed Rule   2011-05-03T04:00:00Z 2011 5 2011-05-03T04:00:00Z 2011-05-27T03:59:59Z 2011-06-11T17:31:01Z 2011-05387 0 0 0900006480c3e39d
ITA_FRDOC_0001-0026 ITA Recently Posted ITA Rules and Notices. ITA_FRDOC_0001 Antidumping and Countervailing Duty Investigations: Acceptance of Bonds During Provisional Measures Period Proposed Rule   2011-04-26T00:00:00Z 2011 4     2011-06-11T17:31:06Z   0 1 0900006480c39799
ITA-2011-0001-0001 ITA Proposed Modification to Regulation Concerning the Revocation of Antidumping and Countervailing Duty Orders: ITA-2011-0001 Modification to Regulation Concerning the Revocation of Antidumping and Countervailing Duty Orders Proposed Rule   2011-03-21T04:00:00Z 2011 3 2011-03-21T04:00:00Z 2011-04-21T03:59:59Z 2011-06-11T17:31:02Z 2011-06019 0 0 0900006480c0c7ba
ITA-2010-0011-0062 ITA Antidumping Proceedings: Calculation of the Weighted Average Dumping Margin and Assessment Rate in Certain Antidumping Duty Proceedings ITA-2010-0011 Antidumping Proceedings: Calculation of Weighted Average Dumping Margin and Assessment Rate Proposed Rule   2011-03-04T00:00:00Z 2011 3     2011-06-11T17:30:59Z   0 1 0900006480c00648
ITA-2010-0011-0063 ITA Antidumping Proceedings: Calculation of the Weighted Average Dumping Margin and Assessment Rate in Certain Antidumping Duty Proceedings ITA-2010-0011 Antidumping Proceedings: Calculation of Weighted Average Dumping Margin and Assessment Rate Proposed Rule   2011-02-01T05:00:00Z 2011 2 2011-02-01T05:00:00Z 2011-02-19T04:59:59Z 2011-06-11T17:31:01Z 2011-01946 0 0 0900006480bd7ad3
ITA-2010-0012-0001 ITA Foreign-Trade Zones in the United States Proposed Rule; Request for Comments. ITA-2010-0012 Proposed rule; request for comments Proposed Rule   2011-01-27T05:00:00Z 2011 1 2011-01-27T05:00:00Z 2011-06-28T03:59:59Z 2011-06-16T20:49:08Z   0 0 0900006480bd3eaa
ITA-2010-0011-0001 ITA Antidumping Proceedings: Calculation of the Weighted Average Dumping Margin and Assessment Rate in Certain Antidumping Duty Proceedings ITA-2010-0011 Antidumping Proceedings: Calculation of the Weighted Average Dumping Margin and Assessment Rate in Certain Antidumping Duty Proceedings Proposed Rule   2011-01-21T05:00:00Z 2011 1 2011-01-21T05:00:00Z 2011-02-19T04:59:59Z 2011-06-11T17:31:00Z   0 0 0900006480bcf822
ITA-2010-0011-0002 ITA Antidumping Proceedings: Calculation of the Weighted Average Dumping Margin and Assessment Rate in Certain Antidumping Duty Proceedings ITA-2010-0011 Antidumping Proceedings: Calculation of the Weighted Average Dumping Margin and Assessment Rate in Certain Antidumping Duty Proceedings Proposed Rule   2010-12-28T05:00:00Z 2010 12 2010-12-28T05:00:00Z 2011-02-19T04:59:59Z 2011-06-11T17:31:00Z 2010-32632 0 0 0900006480bc0bad
ITA-2010-0003-0001 ITA Antidumping and Countervailing Duty Proceedings: Electronic Filing Procedures; APO Procedures; Proposed Rule ITA-2010-0003 Antidumping and Countervailing Duty Proceedings: Electronic Filing Procedures; Administrative Protective Order Procedures Proposed Rule   2010-07-28T04:00:00Z 2010 7 2010-07-28T04:00:00Z 2010-09-28T03:59:59Z 2011-06-11T17:30:59Z 2010-18389 0 0 0900006480b225a9
ITA-2020-0005-0011 ITA Quarterly Update to Cheese Subject to an In-Quota Rate of Duty ITA-2020-0005 Import Administration IA ACCESS Pilot Program Proposed Rule   2010-06-21T00:00:00Z 2010 6     2023-09-27T18:53:06Z   0 1 0900006480b06f6c
ITA-2010-0002-0001 ITA Import Administration IA ACCESS Pilot Program ITA-2010-0002 Import Administration IA ACCESS Pilot Program Proposed Rule   2010-06-08T04:00:00Z 2010 6 2010-06-08T04:00:00Z 2010-07-09T03:59:59Z 2010-06-10T13:26:58Z 2010-13733 0 0 0900006480afe35c
ITA-2009-0002-0001 ITA Changes in Procedures for Florence Agreement Program ITA-2009-0002 Changes in Procedures for Florence Agreement Program Proposed Rule   2008-12-17T05:00:00Z 2008 12 2008-12-17T05:00:00Z 2009-01-17T04:59:59Z 2011-06-11T17:30:58Z E8-29128 0 0 09000064807def46
ITA-2009-0001-0001 ITA Steel Import Monitoring and Analysis System ITA-2009-0001 Steel Import Monitoring and Analysis System Proposed Rule   2008-12-12T05:00:00Z 2008 12 2008-12-12T05:00:00Z 2009-01-13T04:59:59Z 2011-06-11T17:30:58Z E8-28683 0 0 09000064807d8853
ITA_FRDOC_0001-0006 ITA Recently Posted ITA Rules and Notices. ITA_FRDOC_0001 Changes in the Insular Possessions Watch, Watch Movement and Jewelry Programs 2008 Proposed Rule   2008-08-21T04:00:00Z 2008 8 2008-08-21T04:00:00Z 2008-09-23T03:59:59Z 2011-06-11T17:31:07Z E8-19411 0 0 09000064806d13a1
ITA-2007-0018-0001 ITA Changes in the Insular Possessions Watch, Watch Movement and Jewelry Programs 2006 ITA-2007-0018 Changes in the Insular Possessions Watch, Watch Movement and Jewelry Programs 2006 Proposed Rule   2007-01-24T05:00:00Z 2007 1 2007-01-24T05:00:00Z 2007-02-24T04:59:59Z 2011-06-11T17:30:56Z 07-00294 0 0 09000064801f6c40
ITA-2007-0004-0001 ITA Antidumping and Countervailing Duty Proceedings: Documents Submission Procedures; APO Procedures; Proposed Rule ITA-2007-0004 Antidumping and Countervailing Duty Proceedings: Documents Submission Procedures; APO Procedures; Proposed Rule Proposed Rule   2007-01-08T05:00:00Z 2007 1 2007-01-08T05:00:00Z 2007-03-01T04:59:59Z 2011-06-11T17:30:56Z 06-09969 0 0 09000064801f2ddf
ITA-2006-0386-0001 ITA Office of Insular Affairs; Insular Possessions Watch, Watch Movement and Jewelry Programs ITA-2006-0386 Office of Insular Affairs; Insular Possessions Watch, Watch Movement and Jewelry Programs Proposed Rule   2006-10-20T04:00:00Z 2006 10 2006-10-20T04:00:00Z 2006-11-21T04:59:59Z 2011-06-11T17:30:55Z 06-08818 0 0 09000064801d7b89
ITA-2006-0267-0001 ITA Procedures for Importation of Supplies for Use in Emergency Relief Work ITA-2006-0267 Procedures for Importation of Supplies for Use in Emergency Relief Work Proposed Rule   2006-06-22T04:00:00Z 2006 6 2006-06-22T04:00:00Z 2006-07-25T03:59:59Z 2011-06-11T17:30:55Z 06-05612 0 0 090000648018dc94
ITA-2006-0246-0001 ITA Mexican Cement Import Licensing System ITA-2006-0246 Mexican Cement Import Licensing System Proposed Rule   2006-05-31T04:00:00Z 2006 5 2006-05-31T04:00:00Z 2006-07-01T03:59:59Z 2011-06-11T17:30:55Z E6-08402 0 0 090000648017dc01

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