documents

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

5 rows where docket_id = "EPA-HQ-OPP-2012-0429" sorted by posted_date descending

✎ View and edit SQL

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)

posted_year 2

agency_id 1

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
EPA-HQ-OPP-2012-0429-0005 EPA None EPA-HQ-OPP-2012-0429 Quinclorac and the Dimethylamine (DMA) Salt of Quinclorac. Acute and Chronic Aggregate Dietary (Food and Drinking Water) Exposure and Risk Assessments for the Proposed Tolerance with No U.S. Registration for Rapeseed Subgroup 20A Supporting & Related Material Risk Assessment 2013-11-29T05:00:00Z 2013 11     2014-01-10T16:24:51Z   0 0 0900006481465c23
EPA-HQ-OPP-2012-0429-0004 EPA None EPA-HQ-OPP-2012-0429 Quinclorac: Risk Assessment to Support Permanent Tolerance for Rapeseed Subgroup 20A Without U.S. Registration Supporting & Related Material Risk Assessment 2013-11-29T05:00:00Z 2013 11     2014-01-10T16:24:51Z   0 0 0900006481465c22
EPA-HQ-OPP-2012-0429-0003 EPA None EPA-HQ-OPP-2012-0429 Pesticide Tolerances: Quinclorac Rule   2013-11-29T05:00:00Z 2013 11 2013-11-29T05:00:00Z 2014-01-29T04:59:59Z 2013-11-29T21:52:21Z 2013-28640 0 0 090000648149f0e3
EPA-HQ-OPP-2012-0429-0001 EPA None EPA-HQ-OPP-2012-0429 Pesticide Petitions Filed for Residues of Pesticide Chemicals in or on Various Commodities Proposed Rule   2012-07-25T04:00:00Z 2012 7 2012-07-25T04:00:00Z 2012-08-25T03:59:59Z 2012-07-27T00:36:29Z 2012-17899 0 0 09000064810afaa3
EPA-HQ-OPP-2012-0429-0002 EPA None EPA-HQ-OPP-2012-0429 BASF Pesticide Petition for Quniclorac on Canola Supporting & Related Material Report 2012-07-25T04:00:00Z 2012 7     2012-07-26T00:36:10Z   0 0 090000648101fd3d

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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;