documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
5 rows where docket_id = "APHIS-2022-0038" sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: posted_date, posted_month, posted_date (date), comment_start_date (date), comment_end_date (date), last_modified (date)
document_type 2
agency_id 1
- APHIS 5
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| APHIS-2022-0038-0005 | APHIS | Importation of table beet root from the United Kingdom into the Continental United States, Hawaii, Puerto Rico, and the US Virgin Islands APHIS-2022-0038 | Imports: Fresh Table Beet Root for Consumption from the United Kingdom | Notice | Determinations | 2024-09-27T04:00:00Z | 2024 | 9 | 2024-09-27T04:00:00Z | 2024-09-27T12:59:03Z | 2024-22396 | 0 | 0 | 09000064867958bd | |
| APHIS-2022-0038-0002 | APHIS | Importation of table beet root from the United Kingdom into the Continental United States, Hawaii, Puerto Rico, and the US Virgin Islands APHIS-2022-0038 | Economic Effects Assessment - Importation of United Kingdom beet roots into the United States | Supporting & Related Material | Environmental Assessment | 2023-08-23T04:00:00Z | 2023 | 8 | 2023-08-23T13:36:46Z | 0 | 0 | 0900006485eca902 | |||
| APHIS-2022-0038-0003 | APHIS | Importation of table beet root from the United Kingdom into the Continental United States, Hawaii, Puerto Rico, and the US Virgin Islands APHIS-2022-0038 | Risk Management Document - Importation of table beet root from the United Kingdom | Supporting & Related Material | Risk Management Document | 2023-08-23T04:00:00Z | 2023 | 8 | 2023-08-23T13:37:24Z | 0 | 0 | 0900006485eca903 | |||
| APHIS-2022-0038-0001 | APHIS | Importation of table beet root from the United Kingdom into the Continental United States, Hawaii, Puerto Rico, and the US Virgin Islands APHIS-2022-0038 | Imports: Fresh Table Beet Root (Beta vulgaris L.) from the United Kingdom into the Continental United States, Hawaii, Puerto Rico, and the U.S. Virgin Islands, Pest Risk Analysis | Notice | Availability of Document | 2023-08-23T04:00:00Z | 2023 | 8 | 2023-08-23T04:00:00Z | 2023-10-24T03:59:59Z | 2023-08-23T13:14:27Z | 2023-18111 | 0 | 0 | 0900006485ed8cfc |
| APHIS-2022-0038-0004 | APHIS | Importation of table beet root from the United Kingdom into the Continental United States, Hawaii, Puerto Rico, and the US Virgin Islands APHIS-2022-0038 | Pest Risk Assessment - Importation of table beet Root from the United Kingdom | Supporting & Related Material | Risk Assessment | 2023-08-23T04:00:00Z | 2023 | 8 | 2023-08-23T13:39:40Z | 0 | 0 | 0900006485eca904 |
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);