documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1,180 rows where agency_id = "USTR" and document_type = "Notice" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| USTR_FRDOC_0001-0926 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Charter Amendments, Establishments, Renewals and Terminations: Industry Trade Advisory Committees, Request for Membership Application | Notice | 2026-03-12T04:00:00Z | 2026 | 3 | 2026-03-12T04:00:00Z | 2026-03-12T16:56:01Z | 2026-04861 | 0 | 0 | 09000064b9210324 | ||
| USTR_FRDOC_0001-0925 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Charter Amendments, Establishments, Renewals and Terminations: Intergovernmental Policy Advisory Committee on Trade; Requests for Nominations | Notice | 2026-03-04T05:00:00Z | 2026 | 3 | 2026-03-04T05:00:00Z | 2026-03-04T17:56:40Z | 2026-04245 | 0 | 0 | 09000064b91ef9ac | ||
| USTR_FRDOC_0001-0924 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Charter Amendments, Establishments, Renewals and Terminations: Advisory Committee for Trade Policy and Negotiations; Requests for Nominations | Notice | 2026-03-04T05:00:00Z | 2026 | 3 | 2026-03-04T05:00:00Z | 2026-03-04T17:56:38Z | 2026-04242 | 0 | 0 | 09000064b91ef9a9 | ||
| USTR_FRDOC_0001-0922 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Charter Amendments, Establishments, Renewals and Terminations: Trade Advisory Committee on Africa; Requests for Nominations | Notice | 2026-03-04T05:00:00Z | 2026 | 3 | 2026-03-04T05:00:00Z | 2026-03-04T17:55:32Z | 2026-04243 | 0 | 0 | 09000064b91ed689 | ||
| USTR_FRDOC_0001-0923 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Charter Amendments, Establishments, Renewals and Terminations: Trade and Environment Policy Advisory Committee; Requests for Nominations | Notice | 2026-03-04T05:00:00Z | 2026 | 3 | 2026-03-04T05:00:00Z | 2026-03-04T17:55:42Z | 2026-04246 | 0 | 0 | 09000064b91eef60 | ||
| USTR_FRDOC_0001-0921 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Design of a Plurilateral Agreement on Trade in Critical Minerals and Policy Actions to Strengthen the Resilience of Critical Mineral Supply Chains | Notice | 2026-02-26T05:00:00Z | 2026 | 2 | 2026-02-26T05:00:00Z | 2026-03-20T03:59:59Z | 2026-03-13T09:00:24Z | 2026-03868 | 1 | 0 | 09000064b91deb45 | |
| USTR_FRDOC_0001-0920 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Procurement Thresholds for Implementation of the Trade Agreements Act | Notice | 2026-02-03T05:00:00Z | 2026 | 2 | 2026-02-03T05:00:00Z | 2026-02-03T17:30:24Z | 2026-02106 | 0 | 0 | 09000064b918c738 | ||
| USTR_FRDOC_0001-0919 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Procurement Thresholds for Implementation of the Trade Agreements Act of 1979 | Notice | 2026-01-02T05:00:00Z | 2026 | 1 | 2026-01-02T05:00:00Z | 2026-01-13T23:37:34Z | 2025-24130 | 0 | 0 | 09000064b9114024 | ||
| USTR_FRDOC_0001-0918 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Allocation of the WTO Tariff-Rate Quota Volumes for Beef | Notice | 2025-12-31T05:00:00Z | 2025 | 12 | 2025-12-31T05:00:00Z | 2025-12-31T18:03:22Z | 2025-24120 | 0 | 0 | 09000064b9113fcd | ||
| USTR_FRDOC_0001-0916 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Nicaragua's Acts, Policies, and Practices Related to Labor Rights, Human Rights and Fundamental Freedoms, and the Rule of Law | Notice | 2025-12-29T05:00:00Z | 2025 | 12 | 2025-12-29T05:00:00Z | 2025-12-29T17:44:41Z | 2025-23892 | 0 | 0 | 09000064b910a2cd | ||
| USTR_FRDOC_0001-0917 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | China's Acts, Policies, and Practices Related to Targeting of the Semiconductor Industry for Dominance | Notice | 2025-12-29T05:00:00Z | 2025 | 12 | 2025-12-29T05:00:00Z | 2025-12-29T17:45:13Z | 2025-23912 | 0 | 0 | 09000064b910a41e | ||
| USTR_FRDOC_0001-0914 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Certain Tariff-Related Elements of the Framework for a United States-Switzerland-Liechtenstein Agreement on Fair, Balanced, and Reciprocal Trade | Notice | 2025-12-18T05:00:00Z | 2025 | 12 | 2025-12-18T05:00:00Z | 2025-12-18T17:23:44Z | 2025-23316 | 0 | 0 | 09000064b90eaa49 | ||
| USTR_FRDOC_0001-0915 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Determination: Trade Surplus in Certain Sugar and Syrup Goods and Sugar-Containing Products of Chile, Morocco, Costa Rica, the Dominican Republic, El Salvador, Guatemala, Honduras, Nicaragua, Peru, Colombia, and Panama | Notice | 2025-12-18T05:00:00Z | 2025 | 12 | 2025-12-18T05:00:00Z | 2025-12-18T17:23:58Z | 2025-23315 | 0 | 0 | 09000064b90ee68d | ||
| USTR_FRDOC_0001-0913 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Nicaragua's Acts, Policies, and Practices Related to Labor Rights, Human Rights and Fundamental Freedoms, and the Rule of Law | Notice | 2025-12-12T05:00:00Z | 2025 | 12 | 2025-12-12T05:00:00Z | 2025-12-12T17:23:49Z | 2025-22690 | 0 | 0 | 09000064b90c85ea | ||
| USTR-2025-0243-0001 | USTR | 2026 Special 301 Review: Identification of Countries Under Section 182 of the Trade Act of 1974: Request for Public Comment and Announcement of Public Hearing USTR-2025-0243 | 2026 Special 301 Review: Identification of Countries Under Section 182 of the Trade Act of 1974: Request for Public Comment and Announcement of Public Hearing | Notice | 2025-12-11T05:00:00Z | 2025 | 12 | 2025-12-11T05:00:00Z | 2026-02-26T04:59:59Z | 2026-02-27T20:34:35Z | 2025-22571 | 0 | 0 | 09000064b90c309b | |
| USTR_FRDOC_0001-0911 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Performance Review Board Membership | Notice | 2025-12-10T05:00:00Z | 2025 | 12 | 2025-12-10T05:00:00Z | 2025-12-10T18:05:49Z | 2025-22460 | 0 | 0 | 09000064b90c154f | ||
| USTR_FRDOC_0001-0910 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Operation of the United States-Mexico-Canada Agreement With Respect to Trade in Automotive Goods | Notice | 2025-12-05T05:00:00Z | 2025 | 12 | 2025-12-05T05:00:00Z | 2025-12-05T18:27:15Z | 2025-22105 | 0 | 0 | 09000064b90ade86 | ||
| USTR_FRDOC_0001-0909 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Implementing Certain Tariff-Related Elements of the U.S.-Korea Strategic Trade and Investment Deal | Notice | 2025-12-04T05:00:00Z | 2025 | 12 | 2025-12-04T05:00:00Z | 2025-12-04T18:14:41Z | 2025-21940 | 0 | 0 | 09000064b90ade2c | ||
| USTR_FRDOC_0001-0908 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Product Exclusion Extensions: China's Acts, Policies, and Practices Related to Technology Transfer, Intellectual Property, and Innovation | Notice | 2025-12-01T05:00:00Z | 2025 | 12 | 2025-12-01T05:00:00Z | 2025-12-01T18:00:12Z | 2025-21671 | 0 | 0 | 09000064b90a2749 | ||
| USTR_FRDOC_0001-0907 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Hearings, Meetings, Proceedings, etc.: United States-Mexico-Canada Agreement Environment Committee | Notice | 2025-11-26T05:00:00Z | 2025 | 11 | 2025-11-26T05:00:00Z | 2025-11-26T18:38:36Z | 2025-21292 | 0 | 0 | 09000064b909eb49 | ||
| USTR-2025-0208-0002 | USTR | Applications for Inclusion on the Binational Panels Roster(April 1, 2026-March 31, 2027)Under the United States-Mexico -Canada Agreement(USMCA) USTR-2025-0208 | Applications for Inclusion on the Binational Panels Roster under the United States-Mexico-Canada Agreement | Notice | 2025-11-25T05:00:00Z | 2025 | 11 | 2025-11-25T05:00:00Z | 2025-12-13T04:59:59Z | 2025-12-13T10:00:30Z | 2025-21083 | 0 | 0 | 09000064b90995ea | |
| USTR_FRDOC_0001-0905 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Modification of Section 301 Action: China's Targeting of the Maritime, Logistics, and Shipbuilding Sectors for Dominance | Notice | 2025-11-13T05:00:00Z | 2025 | 11 | 2025-11-13T05:00:00Z | 2025-11-13T19:04:06Z | 2025-19873 | 0 | 0 | 09000064b907fab9 | ||
| USTR_FRDOC_0001-0904 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Suspending Section 301 Action for One Year: China's Targeting of the Maritime, Logistics, and Shipbuilding Sectors for Dominance | Notice | 2025-11-10T05:00:00Z | 2025 | 11 | 2025-11-10T05:00:00Z | 2025-11-10T17:57:44Z | 2025-19839 | 0 | 0 | 09000064b907595b | ||
| USTR_FRDOC_0001-0903 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Hearings, Meetings, Proceedings, etc.: Change to Date for Public Hearing Relating to the Operation of the Agreement between the United States of America, the United Mexican States, and Canada | Notice | 2025-11-07T05:00:00Z | 2025 | 11 | 2025-11-07T05:00:00Z | 2025-11-07T18:01:24Z | 2025-19816 | 0 | 0 | 09000064b90722c3 | ||
| USTR_FRDOC_0001-0902 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Hearings, Meetings, Proceedings, etc.: Third United States-Mexico-Canada Agreement Labor Council Meeting | Notice | 2025-11-07T05:00:00Z | 2025 | 11 | 2025-11-07T05:00:00Z | 2025-11-07T18:01:22Z | 2025-19818 | 0 | 0 | 09000064b90722bf | ||
| USTR_FRDOC_0001-0901 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Hearings, Meetings, Proceedings, etc.: Initiation of Section 301 Investigation: China's Implementation of Commitments under the Phase One Agreement | Notice | 2025-10-28T04:00:00Z | 2025 | 10 | 2025-10-28T04:00:00Z | 2025-10-28T16:07:46Z | 2025-19679 | 0 | 0 | 09000064b9055349 | ||
| USTR_FRDOC_0001-0900 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Determination and Request for Comments: Action Pursuant to Section 301; Nicaragua's Acts, Policies, and Practices Related to Labor Rights, Human Rights and Fundamental Freedoms, and the Rule of Law | Notice | 2025-10-23T04:00:00Z | 2025 | 10 | 2025-10-23T04:00:00Z | 2025-10-23T16:04:49Z | 2025-19635 | 0 | 0 | 09000064b904ce14 | ||
| USTR_FRDOC_0001-0899 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Section 301 Action: China's Targeting of the Maritime, Logistics, and Shipbuilding Sectors for Dominance | Notice | 2025-10-16T04:00:00Z | 2025 | 10 | 2025-10-16T04:00:00Z | 2025-10-16T15:03:54Z | 2025-19568 | 0 | 0 | 09000064b901aa7a | ||
| USTR-2025-0010-0007 | USTR | Request for Comments and Notice of Public Hearing Russia's Implementation of Its World Trade Organization Commitments USTR-2025-0010 | Cancellation of Public Hearing: Concerning Russia's Implementation of its WTO Commitments | Notice | 2025-10-15T04:00:00Z | 2025 | 10 | 2025-10-15T04:00:00Z | 2025-10-15T20:17:45Z | 2025-19539 | 0 | 0 | 09000064b901aa4b | ||
| USTR-2025-0015-0013 | USTR | Request for Comments and Notice of Public Hearing China's Compliance with World Trade Organization Commitments USTR-2025-0015 | Postponement of Public Hearing: China's Compliance With World Trade Organization Commitments | Notice | 2025-10-07T04:00:00Z | 2025 | 10 | 2025-10-07T04:00:00Z | 2025-10-14T18:16:30Z | 2025-19488 | 0 | 0 | 09000064b8ff793d | ||
| USTR_FRDOC_0001-0896 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Certain Tariff-Related Elements of the U.S.-EU Framework on an Agreement on Reciprocal, Fair, and Balanced Trade | Notice | 2025-09-25T04:00:00Z | 2025 | 9 | 2025-09-25T04:00:00Z | 2025-09-25T16:03:20Z | 2025-18660 | 0 | 0 | 09000064b8fdc22c | ||
| USTR_FRDOC_0001-0895 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Hearings, Meetings, Proceedings, etc.: Operation of the Agreement between the United States of America, the United Mexican States, and Canada | Notice | 2025-09-17T04:00:00Z | 2025 | 9 | 2025-09-17T04:00:00Z | 2025-09-17T16:33:05Z | 2025-18010 | 0 | 0 | 09000064b8fa6140 | ||
| USTR_FRDOC_0001-0894 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Exclusions in the Section 301 Investigation of China's Acts, Policies, and Practices Related to Technology Transfer, Intellectual Property, and Innovation | Notice | 2025-09-16T04:00:00Z | 2025 | 9 | 2025-09-16T04:00:00Z | 2025-09-16T16:37:32Z | 2025-17894 | 0 | 0 | 09000064b8f96c16 | ||
| USTR-2025-0016-0001 | USTR | Request for Comments on Significant Foreign Trade Barriers for the 2026 National Trade Estimate Report USTR-2025-0016 | Request for Comments on Significant Foreign Trade Barriers for the 2026 National Trade Estimate Report | Notice | 2025-09-15T04:00:00Z | 2025 | 9 | 2025-09-15T04:00:00Z | 2025-10-31T03:59:59Z | 2025-10-31T09:00:10Z | 2025-17782 | 0 | 0 | 09000064b8f890c1 | |
| USTR-2023-0008-0022 | USTR | Request for Comments and Notice of Public Hearing Concerning China’s Compliance with WTO Commitments USTR-2023-0008 | Cancellation of Public Hearing Concerning China's Compliance with WTO Commitments | Notice | 2025-09-09T04:00:00Z | 2025 | 9 | 2025-09-09T04:00:00Z | 2025-09-10T02:26:42Z | 0 | 0 | 09000064b8f5d24d | |||
| USTR-2023-0007-0004 | USTR | Request for Comments and Notice of Public Hearing Concerning Russia’s Implementation of its WTO Commitments USTR-2023-0007 | Cancellation of Public Hearing Russia's Implementation of WTO Commitments | Notice | 2025-09-09T04:00:00Z | 2025 | 9 | 2025-09-09T04:00:00Z | 2025-09-10T02:17:45Z | 0 | 0 | 09000064b8f5fb43 | |||
| USTR_FRDOC_0001-0892 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Product Exclusion Extensions: China's Acts, Policies, and Practices Related to Technology Transfer, Intellectual Property, and Innovation | Notice | 2025-09-02T04:00:00Z | 2025 | 9 | 2025-09-02T04:00:00Z | 2025-09-02T16:02:39Z | 2025-16733 | 0 | 0 | 09000064b8f324a2 | ||
| USTR-2025-0018-0002 | USTR | 2025 Special 301 Out-of-Cycle Review of Notorious Markets: Comment Request USTR-2025-0018 | 2025 Review of Notorious Markets for Counterfeiting and Piracy | Notice | 2025-08-18T04:00:00Z | 2025 | 8 | 2025-08-18T04:00:00Z | 2025-10-02T03:59:59Z | 2025-10-24T00:31:19Z | 2025-15675 | 0 | 0 | 09000064b8f049d1 | |
| USTR-2025-0015-0001 | USTR | Request for Comments and Notice of Public Hearing China's Compliance with World Trade Organization Commitments USTR-2025-0015 | China's Compliance with World Trade Organization Commitments | Notice | 2025-08-18T04:00:00Z | 2025 | 8 | 2025-08-18T04:00:00Z | 2025-09-25T03:59:59Z | 2025-09-25T09:01:37Z | 2025-15655 | 0 | 0 | 09000064b8f044f6 | |
| USTR_FRDOC_0001-0889 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Fiscal Year 2026 Tariff-Rate Quota Allocations: Raw Cane Sugar, Refined and Specialty Sugar, and Sugar-Containing Products | Notice | 2025-08-15T04:00:00Z | 2025 | 8 | 2025-08-15T04:00:00Z | 2025-08-15T16:43:34Z | 2025-15543 | 0 | 0 | 09000064b8f008b5 | ||
| USTR-2025-0010-0001 | USTR | Request for Comments and Notice of Public Hearing Russia's Implementation of Its World Trade Organization Commitments USTR-2025-0010 | Russia's Implementation of Its World Trade Organization Commitments | Notice | 2025-08-12T04:00:00Z | 2025 | 8 | 2025-08-12T04:00:00Z | 2025-10-02T03:59:59Z | 2025-10-02T09:00:21Z | 2025-15294 | 0 | 0 | 09000064b8ef8b1d | |
| USTR_FRDOC_0001-0887 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Status of Algeria Under the Tariff Act of 1930, As Amended | Notice | 2025-07-21T04:00:00Z | 2025 | 7 | 2025-07-21T04:00:00Z | 2025-07-21T16:30:41Z | 2025-13590 | 0 | 0 | 09000064b8e8bbb6 | ||
| USTR_FRDOC_0001-0886 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Hearings, Meetings, Proceedings, etc.: Initiation of Section 301 Investigation: Brazil's Acts, Policies, and Practices Related to Digital Trade and Electronic Payment Services; Unfair, Preferential Tariffs; Anti-Corruption Enforcement; Intellectual Property Protection; Ethanol Market Access; and Illegal Deforestation | Notice | 2025-07-18T04:00:00Z | 2025 | 7 | 2025-07-18T04:00:00Z | 2025-07-18T16:27:11Z | 2025-13498 | 0 | 0 | 09000064b8e8283f | ||
| USTR-2025-0014-0001 | USTR | Biennial Review of Country Eligibility for Benefits under the Caribbean Basin Initiative for Calendar Year 2025 USTR-2025-0014 | Biennial Review of Country Eligibility for Benefits under the Caribbean Basin Initiative for Calendar Year 2025 | Notice | 2025-06-16T04:00:00Z | 2025 | 6 | 2025-06-16T04:00:00Z | 2025-07-17T03:59:59Z | 2025-07-17T09:00:26Z | 2025-10953 | 0 | 0 | 09000064b8e1208a | |
| USTR_FRDOC_0001-0884 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Proposed Action in Section 301 Investigation of China's Targeting of the Maritime, Logistics, and Shipbuilding Sectors for Dominance | Notice | 2025-06-12T00:00:00Z | 2025 | 6 | 2025-06-12T00:00:00Z | 2025-06-12T16:27:27Z | 2025-10660 | 0 | 0 | 09000064b8dfd44b | ||
| USTR_FRDOC_0001-0883 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Product Exclusion Extensions: China's Acts, Policies, and Practices Related to Technology Transfer, Intellectual Property, and Innovation | Notice | 2025-06-05T00:00:00Z | 2025 | 6 | 2025-06-05T00:00:00Z | 2025-06-05T16:13:29Z | 2025-10203 | 0 | 0 | 09000064b8dd9827 | ||
| USTR-2025-0012-0001 | USTR | Annual Review of Country Eligibility for Benefits Under the African Growth and Opportunity Act for Calendar Year 2026 USTR-2025-0012 | Annual Review of Country Eligibility for Benefits under the African Growth and Opportunity Act for Calendar Year 2026 | Notice | 2025-05-30T04:00:00Z | 2025 | 5 | 2025-05-30T04:00:00Z | 2025-08-01T03:59:59Z | 2025-08-01T09:00:57Z | 2025-09795 | 0 | 0 | 09000064b8dcb18e | |
| USTR_FRDOC_0001-0881 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Foreign Nations Freeloading on American-Financed Innovation | Notice | 2025-05-30T04:00:00Z | 2025 | 5 | 2025-05-30T04:00:00Z | 2025-06-17T19:26:25Z | 2025-09757 | 0 | 0 | 09000064b8dc7c13 | ||
| USTR_FRDOC_0001-0880 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Initiation of Section 301 Investigation: China's Targeting the Maritime, Logistics, and Shipbuilding Sectors for Dominance | Notice | 2025-04-23T04:00:00Z | 2025 | 4 | 2025-04-23T04:00:00Z | 2025-04-23T12:21:20Z | 2025-06927 | 0 | 0 | 0900006486aad5df | ||
| USTR_FRDOC_0001-0879 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Proposed Action in Section 301 Investigation of China's Targeting of the Maritime, Logistics, and Shipbuilding Sectors for Dominance | Notice | 2025-02-27T05:00:00Z | 2025 | 2 | 2025-02-27T05:00:00Z | 2025-02-27T12:36:02Z | 2025-03134 | 0 | 0 | 0900006486994516 | ||
| USTR_FRDOC_0001-0878 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Reviewing and Identifying Unfair Trade Practices and Initiating All Necessary Actions to Investigate Harm from Non-Reciprocal Trade Arrangements | Notice | 2025-02-25T05:00:00Z | 2025 | 2 | 2025-02-25T05:00:00Z | 2025-03-12T03:59:59Z | 2025-03-13T01:00:22Z | 2025-03047 | 0 | 0 | 090000648698e83b | |
| USTR_FRDOC_0001-0877 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Section 301 Determination: China's Targeting of the Maritime, Logistics, and Shipbuilding Sectors for Dominance | Notice | 2025-01-23T05:00:00Z | 2025 | 1 | 2025-01-23T05:00:00Z | 2025-01-23T13:12:10Z | 2025-01540 | 0 | 0 | 09000064868f2b7a | ||
| USTR_FRDOC_0001-0876 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Initiation of Section 301 Investigation: China's Acts, Policies, and Practices Related to Targeting of the Semiconductor Industry for Dominance | Notice | 2024-12-30T05:00:00Z | 2024 | 12 | 2024-12-30T05:00:00Z | 2024-12-30T13:35:53Z | 2024-31306 | 0 | 0 | 0900006486894f8a | ||
| USTR_FRDOC_0001-0875 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | 2025 Tariff Rate Quota Quantity Limitations under the U.S.-Australia Free Trade Agreement; Correction | Notice | 2024-12-26T05:00:00Z | 2024 | 12 | 2024-12-26T05:00:00Z | 2024-12-26T13:42:08Z | 2024-30657 | 0 | 0 | 090000648688c652 | ||
| USTR_FRDOC_0001-0874 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | China's Acts, Policies, and Practices Related to Technology Transfer, Intellectual Property, and Innovation; Modification | Notice | 2024-12-16T05:00:00Z | 2024 | 12 | 2024-12-16T05:00:00Z | 2024-12-16T13:39:05Z | 2024-29462 | 0 | 0 | 0900006486874049 | ||
| USTR_FRDOC_0001-0873 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Initiation of Section 301 Investigation: Nicaragua's Acts, Policies, and Practices Related to Labor Rights, Human Rights, and Rule of Law | Notice | 2024-12-13T05:00:00Z | 2024 | 12 | 2024-12-13T05:00:00Z | 2024-12-13T13:10:56Z | 2024-29422 | 0 | 0 | 090000648686c251 | ||
| USTR_FRDOC_0001-0872 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | 2025 Tariff Rate Quota Quantity Limitations under the U.S.-Australia Free Trade Agreement | Notice | 2024-12-11T05:00:00Z | 2024 | 12 | 2024-12-11T05:00:00Z | 2024-12-11T13:45:57Z | 2024-29070 | 0 | 0 | 0900006486861be4 | ||
| USTR_FRDOC_0001-0871 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Determination of Trade Surplus: Certain Sugar and Syrup Goods and Sugar-Containing Products of Chile, Morocco, Costa Rica, the Dominican Republic, El Salvador, Guatemala, Honduras, Nicaragua, Peru, Colombia, and Panama | Notice | 2024-12-11T05:00:00Z | 2024 | 12 | 2024-12-11T05:00:00Z | 2024-12-11T13:45:36Z | 2024-29071 | 0 | 0 | 0900006486861baf | ||
| USTR-2024-0023-0001 | USTR | 2025 Special 301 Review: Identification of Countries Under Section 182 of the Trade Act of 1974: Request for Public Comment and Announcement of Public Hearing USTR-2024-0023 | 2025 Special 301 Review: Identification of Countries Under Section 182 of the Trade Act of 1974: Request for Public Comment and Announcement of Public Hearing | Notice | 2024-12-06T05:00:00Z | 2024 | 12 | 2024-12-06T05:00:00Z | 2025-02-27T04:59:59Z | 2025-02-28T02:00:30Z | 2024-28559 | 0 | 0 | 090000648684aed5 | |
| USTR_FRDOC_0001-0869 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Request for Application: Indigenous Peoples' Representative on the Observer Delegation from the United States to the Partnership Council of the Indigenous Peoples Economic and Trade Cooperation Arrangement | Notice | 2024-10-29T04:00:00Z | 2024 | 10 | 2024-10-29T04:00:00Z | 2024-12-07T04:59:59Z | 2024-11-27T02:00:53Z | 2024-25111 | 0 | 0 | 09000064867ea8fd | |
| USTR-2024-0018-0002 | USTR | Applications for Inclusion on the Binational Panels Roster(April 1, 2025-March 31, 2026)Under the United States-Mexico-Canada Agreement USTR-2024-0018 | Request for Application: Binational Panels Roster under the United States-Mexico-Canada Agreement | Notice | 2024-10-21T04:00:00Z | 2024 | 10 | 2024-10-21T04:00:00Z | 2024-11-30T04:59:59Z | 2024-11-30T02:00:41Z | 2024-24232 | 0 | 0 | 09000064867db58a | |
| USTR-2024-0018-0001 | USTR | Applications for Inclusion on the Binational Panels Roster(April 1, 2025-March 31, 2026)Under the United States-Mexico-Canada Agreement USTR-2024-0018 | Revised Fiscal Year 2008 Tariff-Rate Quota Allocations for Refined Sugar--Re-allocation of Refined Sugar Previously Assigned to Mexico | Notice | 2024-10-21T04:00:00Z | 2024 | 10 | 2024-10-21T04:00:00Z | 2024-10-21T16:38:18Z | E8-25937 | 0 | 0 | 0900006480784df0 | ||
| USTR_FRDOC_0001-0867 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Section 301 Investigation of China's Acts, Policies and Practices Related to Technology Transfer, Intellectual Property and Innovation: Procedures for Requests to Exclude Certain Machinery Used in Domestic Manufacturing | Notice | 2024-10-17T04:00:00Z | 2024 | 10 | 2024-10-17T04:00:00Z | 2024-10-17T12:12:46Z | 2024-23880 | 0 | 0 | 09000064867d2b7d | ||
| USTR-2024-0019-0001 | USTR | Potential Import Prohibitions on Certain Products From the People’s Republic of China Pursuant to the Pelly Amendment USTR-2024-0019 | Potential Import Prohibitions on Certain Products from the People's Republic of China Pursuant to the Pelly Amendment | Notice | 2024-10-15T04:00:00Z | 2024 | 10 | 2024-10-15T04:00:00Z | 2024-11-15T04:59:59Z | 2024-11-15T02:00:27Z | 2024-23639 | 0 | 0 | 09000064867ce7c9 | |
| USTR-2024-0011-0004 | USTR | Request for Comments and Notice of Public Hearing Concerning Russia’s Implementation of its WTO Commitments USTR-2024-0011 | Hearings, Meetings, Proceedings, etc.: Russia's Implementation of its World Trade Organization Commitments; Cancellation | Notice | 2024-09-27T04:00:00Z | 2024 | 9 | 2024-09-27T04:00:00Z | 2024-09-27T16:52:32Z | 2024-22165 | 0 | 0 | 090000648679969f | ||
| USTR_FRDOC_0001-0863 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | List of Countries Denying Fair Market Opportunities for Government-Funded Airport Construction Projects | Notice | 2024-09-24T04:00:00Z | 2024 | 9 | 2024-09-24T04:00:00Z | 2024-09-24T12:21:41Z | 2024-21772 | 0 | 0 | 0900006486777a2d | ||
| USTR_FRDOC_0001-0864 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | China's Acts, Policies and Practices Related to Technology Transfer, Intellectual Property and Innovation | Notice | 2024-09-24T04:00:00Z | 2024 | 9 | 2024-09-24T04:00:00Z | 2024-09-24T12:23:56Z | 2024-21773 | 0 | 0 | 0900006486777c2e | ||
| USTR_FRDOC_0001-0862 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | China's Acts, Policies and Practices Related to Technology Transfer, Intellectual Property and Innovation; Modification | Notice | 2024-09-18T04:00:00Z | 2024 | 9 | 2024-09-18T04:00:00Z | 2024-09-18T12:21:48Z | 2024-21217 | 0 | 0 | 090000648673fdd5 | ||
| USTR-2024-0017-0001 | USTR | Request for Comment: United States-European Union Trade and Technology Council Global Trade Challenges Working Group USTR-2024-0017 | Request for Comment: United States-European Union Trade and Technology Council Global Trade Challenges Working Group | Notice | 2024-09-05T04:00:00Z | 2024 | 9 | 2024-09-05T04:00:00Z | 2024-10-22T03:59:59Z | 2024-10-30T01:00:42Z | 2024-19881 | 0 | 0 | 09000064866c2b9a | |
| USTR-2024-0015-0001 | USTR | Request for Comments: Significant Foreign Trade Barriers for the 2025 National Trade Estimate Report USTR-2024-0015 | Request for Comments: Significant Foreign Trade Barriers for the 2025 National Trade Estimate Report | Notice | 2024-09-03T04:00:00Z | 2024 | 9 | 2024-09-03T04:00:00Z | 2024-10-18T03:59:59Z | 2024-10-24T01:00:40Z | 2024-19694 | 0 | 0 | 09000064866bd5d8 | |
| USTR-2024-0014-0001 | USTR | WTO Dispute: (DS623) Inflation Reduction Act (China) USTR-2024-0014 | World Trade Organization Dispute Settlement: Certain Tax Credits Under the Inflation Reduction Act (China) | Notice | 2024-08-27T04:00:00Z | 2024 | 8 | 2024-08-27T04:00:00Z | 2024-09-27T03:59:59Z | 2024-09-28T01:00:55Z | 2024-19248 | 0 | 0 | 09000064866aa126 | |
| USTR-2024-0013-0001 | USTR | 2024 Special 301 Out-of-Cycle Review of Notorious Markets: Comment Request USTR-2024-0013 | 2024 Review of Notorious Markets for Counterfeiting and Piracy | Notice | 2024-08-16T04:00:00Z | 2024 | 8 | 2024-08-16T04:00:00Z | 2024-10-17T03:59:59Z | 2024-10-23T14:09:43Z | 2024-18337 | 0 | 0 | 090000648664da38 | |
| USTR_FRDOC_0001-0857 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: 301 Exclusion Requests | Notice | 2024-08-15T04:00:00Z | 2024 | 8 | 2024-08-15T04:00:00Z | 2024-09-17T03:59:59Z | 2024-09-17T01:01:07Z | 2024-18190 | 0 | 0 | 0900006486649bf7 | |
| USTR_FRDOC_0001-0856 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Conforming Amendments to Reinstated Exclusions: China's Acts, Policies and Practices Related to Technology Transfer, Intellectual Property, and Innovation | Notice | 2024-08-06T04:00:00Z | 2024 | 8 | 2024-08-06T04:00:00Z | 2024-08-06T12:13:19Z | 2024-17360 | 0 | 0 | 090000648661fe9e | ||
| USTR-2024-0011-0001 | USTR | Request for Comments and Notice of Public Hearing Concerning Russia’s Implementation of its WTO Commitments USTR-2024-0011 | Request for Comments and Notice of Public Hearing Concerning Russia’s Implementation of its WTO Commitments | Notice | 2024-08-05T04:00:00Z | 2024 | 8 | 2024-08-05T04:00:00Z | 2024-09-19T03:59:59Z | 2024-09-19T01:01:07Z | 2024-17229 | 0 | 0 | 090000648661b4f6 | |
| USTR-2024-0012-0001 | USTR | Request for Comments and Notice of Public Hearing Concerning China’s Compliance with WTO Commitments USTR-2024-0012 | Request for Comments and Notice of Public Hearing Concerning China’s Compliance with WTO Commitments | Notice | 2024-08-05T04:00:00Z | 2024 | 8 | 2024-08-05T04:00:00Z | 2024-09-11T03:59:59Z | 2024-09-14T01:00:54Z | 2024-17235 | 0 | 0 | 090000648661b4f4 | |
| USTR-2024-0010-0001 | USTR | Request for Comments and Public Hearing About the Administration’s Action Following a Determination of Import Injury With Regard to Fine Denier Polyester Staple Fiber (PSF) USTR-2024-0010 | Request for Comments and Public Hearing About the Administration’s Action Following a Determination of Import Injury With Regard to Fine Denier Polyester Staple Fiber (PSF) | Notice | 2024-08-05T04:00:00Z | 2024 | 8 | 2024-08-05T04:00:00Z | 2024-09-17T03:59:59Z | 2024-09-18T01:00:53Z | 2024-17138 | 0 | 0 | 090000648661be72 | |
| USTR_FRDOC_0001-0852 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Fiscal Year 2025 Tariff-Rate Quota Allocation: Raw Cane Sugar, Refined and Specialty Sugar, and Sugar-Containing Products | Notice | 2024-07-26T04:00:00Z | 2024 | 7 | 2024-07-26T04:00:00Z | 2024-07-26T12:07:52Z | 2024-16487 | 0 | 0 | 0900006486606dfb | ||
| USTR_FRDOC_0001-0851 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Korea's Completion of Applicable Procedures to Give Effect to a Modification to the Rules of Origin of the U.S.-Korea Free Trade Agreement | Notice | 2024-07-02T04:00:00Z | 2024 | 7 | 2024-07-02T04:00:00Z | 2024-07-02T12:11:12Z | 2024-14094 | 0 | 0 | 09000064865d67cc | ||
| USTR-2024-0009-0001 | USTR | Request for Comments on Americas Partnership for Economic Prosperity – Trade Track USTR-2024-0009 | Request for Comments: Americas Partnership for Economic Prosperity—Trade Track | Notice | 2024-06-20T04:00:00Z | 2024 | 6 | 2024-06-20T04:00:00Z | 2024-07-23T03:59:59Z | 2024-07-24T01:01:11Z | 2024-13470 | 0 | 0 | 09000064865bf8df | |
| USTR_FRDOC_0001-0849 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Fiscal Year 2022 Service Contract Inventory | Notice | 2024-06-18T04:00:00Z | 2024 | 6 | 2024-06-18T04:00:00Z | 2024-06-20T12:33:23Z | 2024-13302 | 0 | 0 | 09000064865bcd12 | ||
| USTR-2024-0008-0001 | USTR | Request for Comments - Reinstatement of the Collection of Information Titled ‘301 Exclusion Requests’ USTR-2024-0008 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: 301 Exclusion Requests | Notice | 2024-05-31T04:00:00Z | 2024 | 5 | 2024-05-31T04:00:00Z | 2024-07-31T03:59:59Z | 2024-08-01T01:00:56Z | 2024-12003 | 0 | 0 | 090000648658e2ad | |
| USTR_FRDOC_0001-0847 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Exclusion: China's Acts, Policies, and Practices Related to Technology Transfer, Intellectual Property, and Innovation | Notice | 2024-05-30T04:00:00Z | 2024 | 5 | 2024-05-30T04:00:00Z | 2024-05-30T11:50:46Z | 2024-11904 | 0 | 0 | 090000648658b4f8 | ||
| USTR_FRDOC_0001-0846 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Request for Comments on Proposed Modifications and Machinery Exclusion Process in Four-Year Review of Actions Taken in the Section 301 Investigation: China's Acts, Policies, and Practices Related to Technology Transfer, Intellectual Property, and Innovation | Notice | 2024-05-28T04:00:00Z | 2024 | 5 | 2024-05-28T04:00:00Z | 2024-05-28T15:14:36Z | 2024-11634 | 0 | 0 | 09000064865868fe | ||
| USTR-2024-0006-0001 | USTR | Annual Review of Country Eligibility for Benefits Under the African Growth and Opportunity Act for Calendar Year 2025 USTR-2024-0006 | Annual Review of Country Eligibility for Benefits under the African Growth and Opportunity Act for Calendar Year 2025 | Notice | 2024-05-14T04:00:00Z | 2024 | 5 | 2024-05-14T04:00:00Z | 2024-07-12T03:59:59Z | 2024-07-13T01:00:53Z | 2024-10482 | 0 | 0 | 0900006486562ee4 | |
| USTR_FRDOC_0001-0844 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Initiation of Section 301 Investigation: China's Acts, Policies, and Practices Targeting the Maritime, Logistics, and Shipbuilding Sectors for Dominance | Notice | 2024-04-22T04:00:00Z | 2024 | 4 | 2024-04-22T04:00:00Z | 2024-04-22T12:39:33Z | 2024-08515 | 0 | 0 | 09000064864e3fcb | ||
| USTR_FRDOC_0001-0843 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Requests for Nominations: Seasonal and Perishable Agricultural Products Advisory Committee, Establishment | Notice | 2024-04-16T04:00:00Z | 2024 | 4 | 2024-04-16T04:00:00Z | 2024-04-16T12:25:00Z | 2024-07953 | 0 | 0 | 09000064864da8cd | ||
| USTR-2024-0002-0010 | USTR | Request for Comments on Promoting Supply Chain Resilience USTR-2024-0002 | Hearings, Meetings, Proceedings, etc.: Promoting Supply Chain Resilience | Notice | 2024-04-03T04:00:00Z | 2024 | 4 | 2024-04-03T04:00:00Z | 2024-04-03T16:15:46Z | 2024-06975 | 0 | 0 | 09000064864b7d5e | ||
| USTR_FRDOC_0001-0841 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Fiscal Year 2024 Allocation of Additional Tariff-Rate Quota Volume: Raw Cane Sugar | Notice | 2024-03-19T04:00:00Z | 2024 | 3 | 2024-03-19T04:00:00Z | 2024-03-19T12:14:47Z | 2024-05763 | 0 | 0 | 090000648648425e | ||
| USTR-2024-0003-0001 | USTR | Holding Docket USTR-2024-0003 | Fiscal Year 2011 Tariff-rate Quota Allocations: Raw Cane Sugar, Refined and Specialty Sugar, and Sugar-containing Products; Revision | Notice | 2024-03-07T05:00:00Z | 2024 | 3 | 2024-03-07T05:00:00Z | 2024-03-07T22:24:13Z | 2010-21524 | 0 | 0 | 0900006480b3e0ee | ||
| USTR-2024-0002-0002 | USTR | Request for Comments on Promoting Supply Chain Resilience USTR-2024-0002 | Promoting Supply Chain Resilience | Notice | 2024-03-07T05:00:00Z | 2024 | 3 | 2024-03-07T05:00:00Z | 2024-06-05T03:59:59Z | 2024-06-06T01:00:26Z | 2024-04869 | 0 | 0 | 0900006486469091 | |
| USTR-2023-0013-0022 | USTR | Request for Comments and Announcing Public Hearing Concerning the Operation of the United States-Mexico-Canada Agreement with Respect to Trade in Automotive Goods USTR-2023-0013 | Post-Hearing Comments: Operation of the United States-Mexico-Canada Agreement with Respect to Trade in Automotive Goods | Notice | 2024-02-14T05:00:00Z | 2024 | 2 | 2024-02-14T05:00:00Z | 2024-02-29T04:59:59Z | 2024-02-29T02:00:22Z | 2024-03050 | 0 | 0 | 0900006486406de0 | |
| USTR_FRDOC_0001-0838 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Performance Review Board Members | Notice | 2024-02-09T05:00:00Z | 2024 | 2 | 2024-02-09T05:00:00Z | 2024-02-09T14:49:15Z | 2024-02714 | 0 | 0 | 09000064863f78f3 | ||
| USTR_FRDOC_0001-0837 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Exclusion: China's Acts, Policies and Practices Related to Technology Transfer, Intellectual Property, and Innovation | Notice | 2024-01-19T05:00:00Z | 2024 | 1 | 2024-01-19T05:00:00Z | 2024-01-19T13:43:17Z | 2024-01023 | 0 | 0 | 09000064863ac0dd | ||
| USTR_FRDOC_0001-0836 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | 2024 Tariff Rate Quota Quantity Limitations under the U.S.-Australia Free Trade Agreement | Notice | 2024-01-09T05:00:00Z | 2024 | 1 | 2024-01-09T05:00:00Z | 2024-01-09T13:05:28Z | 2024-00227 | 0 | 0 | 090000648638886d | ||
| USTR_FRDOC_0001-0835 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Exclusion: China's Acts, Policies and Practices Related to Technology Transfer, Intellectual Property and Innovation | Notice | 2023-12-29T05:00:00Z | 2023 | 12 | 2023-12-29T05:00:00Z | 2023-12-29T13:38:40Z | 2023-28770 | 0 | 0 | 0900006486365bdc | ||
| USTR_FRDOC_0001-0834 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Reallocation of Unused Fiscal Year 2024 World Trade Organization Tariff-Rate Quota Volume for Raw Cane Sugar | Notice | 2023-12-26T05:00:00Z | 2023 | 12 | 2023-12-26T05:00:00Z | 2023-12-26T13:23:29Z | 2023-28340 | 0 | 0 | 0900006486359edd | ||
| USTR_FRDOC_0001-0833 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Determinations of Trade Surplus: Certain Sugar and Syrup Goods and Sugar-Containing Products of Chile, Morocco, Costa Rica, the Dominican Republic, El Salvador, Guatemala, Honduras, Nicaragua, Peru, Colombia and Panama; Correction | Notice | 2023-12-22T05:00:00Z | 2023 | 12 | 2023-12-22T05:00:00Z | 2023-12-22T13:13:05Z | 2023-27761 | 0 | 0 | 0900006486351318 | ||
| USTR_FRDOC_0001-0832 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Determinations of Trade Surplus: Certain Sugar and Syrup Goods and Sugar-Containing Products of Chile, Morocco, Costa Rica, the Dominican Republic, El Salvador, Guatemala, Honduras, Nicaragua, Peru, Colombia and Panama | Notice | 2023-12-13T05:00:00Z | 2023 | 12 | 2023-12-13T05:00:00Z | 2023-12-13T13:14:53Z | 2023-27311 | 0 | 0 | 09000064863304b9 | ||
| USTR_FRDOC_0001-0831 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Procurement Thresholds for Implementation of the Trade Agreements Act | Notice | 2023-12-08T05:00:00Z | 2023 | 12 | 2023-12-08T05:00:00Z | 2023-12-08T13:09:28Z | 2023-27024 | 0 | 0 | 0900006486316538 |
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;