documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
8 rows where docket_id = "APHIS-2011-0019" sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: subtype, posted_date, posted_month, last_modified, posted_date (date), comment_start_date (date), comment_end_date (date), last_modified (date)
document_type 3
agency_id 1
- APHIS 8
| 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-2011-0019-0010 | APHIS | Importation of Jackfruit, Pineapple, and Starfruit From Malaysia into the Continental United States APHIS-2011-0019 | Importation of Jackfruit, Pineapple, and Starfruit from Malaysia into the Continental United States | Rule | Final Rule | 2014-03-19T04:00:00Z | 2014 | 3 | 2014-03-19T04:00:00Z | 2014-03-19T13:40:42Z | 2014-06017 | 0 | 0 | 090000648166f1c7 | |
| APHIS-2011-0019-0009 | APHIS | Importation of Jackfruit, Pineapple, and Starfruit From Malaysia into the Continental United States APHIS-2011-0019 | Analysis in Support of Certification that the Rule will not have a Significant Economic Impact on a Substantial Number of Small Entities | Supporting & Related Material | Economic Analysis | 2014-03-17T04:00:00Z | 2014 | 3 | 2014-03-17T20:31:46Z | 0 | 0 | 09000064816623a1 | |||
| APHIS-2011-0019-0005 | APHIS | Importation of Jackfruit, Pineapple, and Starfruit From Malaysia into the Continental United States APHIS-2011-0019 | Importation of Jackfruit, Pineapple, and Starfruit from Malaysia into the Continental United States: Analysis in Support of Certification that the Rule will not have a Significant Economic Impact on a Substantial Number of Small Entities | Supporting & Related Material | Economic Analysis | 2013-05-14T04:00:00Z | 2013 | 5 | 2013-05-14T12:59:24Z | 0 | 0 | 09000064812a36f6 | |||
| APHIS-2011-0019-0006 | APHIS | Importation of Jackfruit, Pineapple, and Starfruit From Malaysia into the Continental United States APHIS-2011-0019 | Importation of Fresh Fruits of Jackfruit (Artocarpus heterophyllus), Pineapple (Ananas comosus), and Starfruit (Averrhoa carambola) with Stems, from Malaysia into the Continental United States: Risk Management Document | Supporting & Related Material | Risk Management Document | 2013-05-14T04:00:00Z | 2013 | 5 | 2013-05-14T12:59:24Z | 0 | 0 | 09000064812a36f7 | |||
| APHIS-2011-0019-0004 | APHIS | Importation of Jackfruit, Pineapple, and Starfruit From Malaysia into the Continental United States APHIS-2011-0019 | Pest List for Starfruit from Malaysia | Supporting & Related Material | Risk Assessment | 2013-05-14T04:00:00Z | 2013 | 5 | 2013-05-14T12:59:24Z | 0 | 0 | 09000064812a36a6 | |||
| APHIS-2011-0019-0003 | APHIS | Importation of Jackfruit, Pineapple, and Starfruit From Malaysia into the Continental United States APHIS-2011-0019 | Pest LIst for Pineapple from Malaysia | Supporting & Related Material | Risk Assessment | 2013-05-14T04:00:00Z | 2013 | 5 | 2013-05-14T12:59:23Z | 0 | 0 | 09000064812a36a5 | |||
| APHIS-2011-0019-0002 | APHIS | Importation of Jackfruit, Pineapple, and Starfruit From Malaysia into the Continental United States APHIS-2011-0019 | Pest List for Jackfruit from Malaysia | Supporting & Related Material | Risk Assessment | 2013-05-14T04:00:00Z | 2013 | 5 | 2013-05-14T12:59:22Z | 0 | 0 | 09000064812a36a4 | |||
| APHIS-2011-0019-0001 | APHIS | Importation of Jackfruit, Pineapple, and Starfruit From Malaysia into the Continental United States APHIS-2011-0019 | Importation of Jackfruit, Pineapple, and Starfruit from Malaysia | Proposed Rule | 2013-05-07T04:00:00Z | 2013 | 5 | 2013-05-07T04:00:00Z | 2013-07-09T03:59:59Z | 2013-07-11T01:01:50Z | 2013-10826 | 0 | 0 | 09000064812bda08 |
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);