documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
13 rows where docket_id = "USTR_FRDOC_0001" and posted_year = 2016 sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: posted_date, posted_month, comment_start_date, last_modified, posted_date (date), comment_start_date (date), last_modified (date)
| 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-0403 | 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 | 2016-12-23T05:00:00Z | 2016 | 12 | 2016-12-23T05:00:00Z | 2020-03-30T17:48:45Z | 2016-30926 | 0 | 0 | 090000648243386d | ||
| USTR_FRDOC_0001-0400 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Freedom of Information Act Policies and Procedures | Rule | 2016-12-15T05:00:00Z | 2016 | 12 | 2016-12-15T05:00:00Z | 2020-03-30T17:48:45Z | 2016-29985 | 0 | 0 | 090000648240b624 | ||
| USTR_FRDOC_0001-0399 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Production or Disclosure of Records, Information and Employee Testimony in Legal Proceedings | Rule | 2016-12-13T05:00:00Z | 2016 | 12 | 2016-12-13T05:00:00Z | 2020-03-30T17:48:45Z | 2016-29875 | 0 | 0 | 09000064823fe787 | ||
| USTR_FRDOC_0001-0397 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Generalized System of Preferences: Import Statistics Relating to Competitive Need Limitations | Notice | 2016-11-16T05:00:00Z | 2016 | 11 | 2016-11-16T05:00:00Z | 2020-03-30T17:48:45Z | 2016-27542 | 0 | 0 | 0900006482398c70 | ||
| USTR_FRDOC_0001-0386 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Waivers: Discriminatory Purchasing Requirements with Respect to Goods and Services of the Republic of Moldova | Notice | 2016-07-29T04:00:00Z | 2016 | 7 | 2016-07-29T04:00:00Z | 2020-03-30T17:48:45Z | 2016-17973 | 0 | 0 | 0900006482138cc6 | ||
| USTR_FRDOC_0001-0380 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Fiscal Year 2017 Tariff-Rate Quota Allocations: Raw Cane Sugar, Refined and Specialty Sugar and Sugar-Containing Products | Notice | 2016-05-27T04:00:00Z | 2016 | 5 | 2016-05-27T04:00:00Z | 2020-03-30T17:48:44Z | 2016-12495 | 0 | 0 | 0900006481ff8eac | ||
| USTR_FRDOC_0001-0381 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Fiscal Year 2016 Tariff-Rate Quota Allocations: Additional Tariff-Rate Quota Volume for Raw Cane Sugar | Notice | 2016-05-27T04:00:00Z | 2016 | 5 | 2016-05-27T04:00:00Z | 2020-03-30T17:48:44Z | 2016-12496 | 0 | 0 | 0900006481ff8f80 | ||
| USTR_FRDOC_0001-0379 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Determination Regarding Waiver of Discriminatory Purchasing Requirements with Respect to Goods and Services of Ukraine | Notice | 2016-05-18T04:00:00Z | 2016 | 5 | 2016-05-18T04:00:00Z | 2020-03-30T17:48:44Z | 2016-11669 | 0 | 0 | 0900006481fda103 | ||
| USTR_FRDOC_0001-0377 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | List of Countries Denying Fair Market Opportunities for Government-Funded Airport Construction Projects | Notice | 2016-04-26T04:00:00Z | 2016 | 4 | 2016-04-26T04:00:00Z | 2020-03-30T17:48:44Z | 2016-09608 | 0 | 0 | 0900006481f8df57 | ||
| USTR_FRDOC_0001-0374 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Reallocation of Unused Fiscal Year 2016 Tariff-Rate Quota Volume for Raw Cane Sugar | Notice | 2016-03-08T05:00:00Z | 2016 | 3 | 2016-03-08T05:00:00Z | 2020-03-30T17:48:44Z | 2016-05203 | 0 | 0 | 0900006481eb1f51 | ||
| USTR_FRDOC_0001-0371 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Intent to Initiate Covered Agreement Negotiations with the European Union | Notice | 2016-01-19T05:00:00Z | 2016 | 1 | 2016-01-19T05:00:00Z | 2020-03-30T17:48:44Z | 2016-00856 | 0 | 0 | 0900006481e18b7b | ||
| USTR_FRDOC_0001-0370 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | International Trade Data System Visa Requirements under the African Growth and Opportunity Act | Notice | 2016-01-19T05:00:00Z | 2016 | 1 | 2016-01-19T05:00:00Z | 2020-03-30T17:48:44Z | 2016-00838 | 0 | 0 | 0900006481e18b72 | ||
| USTR_FRDOC_0001-0369 | USTR | Recently Posted USTR Rules and Notices. USTR_FRDOC_0001 | Agreement on Government Procurement: Effective Date of Amendments for the Republic of Korea | Notice | 2016-01-12T05:00:00Z | 2016 | 1 | 2016-01-12T05:00:00Z | 2020-03-30T17:48:43Z | 2016-00437 | 0 | 0 | 0900006481e01c26 |
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;