openregs: documents: 7 rows where docket_id = "EPA-HQ-OPP-2014-0285" and posted_year = 2016 sorted by posted

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

7 rows where docket_id = "EPA-HQ-OPP-2014-0285" and posted_year = 2016 sorted by posted_date descending

descending

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	object_id
EPA-HQ-OPP-2014-0285-0014	EPA	None EPA-HQ-OPP-2014-0285	Pesticide Tolerances: Mandestrobin	Rule		2016-10-11T04:00:00Z	2016	10	2016-10-11T04:00:00Z	2016-12-13T04:59:59Z	2016-10-14T21:37:37Z	2016-24492	09000064822d1c04
EPA-HQ-OPP-2014-0285-0011	EPA	None EPA-HQ-OPP-2014-0285	Final Registration Decision of the New Active Ingredient Mandestrobin A Fungicide for Agricultural Crop Uses of Subgroup 13-07F Small Fruit Vine Climbing (except Fuzzy Kiwifruit) and Subgroup 13-07G Low Growing Berry (except Cranberry). A Fungicide for Turf Use Sites Including Golf Courses, Sod Farms, Recreational/ Athletic Fields, and Commercial/Residential Lawns.	Supporting & Related Material	Decision	2016-10-04T04:00:00Z	2016	10			2016-10-06T01:39:08Z		0900006482290fdb
EPA-HQ-OPP-2014-0285-0009	EPA	None EPA-HQ-OPP-2014-0285	Proposed Registration Decision for New Active Mandestrobin	Supporting & Related Material	Decision	2016-08-24T04:00:00Z	2016	8			2016-09-11T04:05:26Z		0900006482194cf8
EPA-HQ-OPP-2014-0285-0006	EPA	None EPA-HQ-OPP-2014-0285	EFED's Analysis of Valent's Proposed Changes to Application Scenarios for Mandestrobin	Supporting & Related Material	Risk Assessment	2016-08-24T04:00:00Z	2016	8			2016-09-11T04:05:31Z		0900006481fc3d14
EPA-HQ-OPP-2014-0285-0007	EPA	None EPA-HQ-OPP-2014-0285	Mandestrobin: Section 3 New Chemical Registration Environmental Fate and Ecological Risk Assessment	Supporting & Related Material	Risk Assessment	2016-08-24T04:00:00Z	2016	8			2016-09-11T04:05:46Z		0900006481fc3a64
EPA-HQ-OPP-2014-0285-0008	EPA	None EPA-HQ-OPP-2014-0285	Mandestrobin. Human Health Risk Assessment for Proposed Foliar Uses on Small Fruit Vine Climbing (Except Fuzzy Kiwifruit) (Subgroup l 3-07F), Low Growing Berry (Subgroup l 3-07G) (Except Cranberry), Rapeseed (Subgroup 20A), Turf, and Seed Treatment Uses on Com (Field, Pop, Sweet), Sorghum Grain (Milo), Legume Vegetables (Crop Group 6) (Except Cowpea and Field Pea), and Rapeseed (Subgroup 20A).	Supporting & Related Material	Risk Assessment	2016-08-24T04:00:00Z	2016	8			2016-09-11T04:05:36Z		0900006481fc3a65
EPA-HQ-OPP-2014-0285-0005	EPA	None EPA-HQ-OPP-2014-0285	Public Participation for the Conditional Registration of Fungicide S-2200 Mandestrobin	Other	Public Participation	2016-08-24T04:00:00Z	2016	8	2016-08-24T04:00:00Z	2016-09-24T03:59:59Z	2016-09-24T13:01:27Z		0900006482197705

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;