home / openregs

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

comment_end_date
A FULL UTC INSTANT, not a calendar date, despite the column name: '2026-08-29T03:59:59Z' is 11:59:59 PM EASTERN on 2026-08-28. Federal comment periods close at 11:59:59 PM Eastern, so the UTC calendar date is ONE DAY LATER than the official deadline on every end-of-day close — 444,689 of the 444,690 populated rows (measured 2026-09-06). Convert to America/New_York before presenting a deadline, and compare with julianday(comment_end_date) > julianday('now'): a plain > datetime('now') is a TEXT comparison between two different formats and keeps already-closed dockets matching for up to ~20 hours. The sibling column on open_comments.documents WAS corrected to an Eastern calendar date (queue #498); this one is unchanged and still an instant — the two databases do not agree on grain. (queue #644)
comment_start_date
A FULL UTC INSTANT, not a calendar date, despite the column name — same grain as comment_end_date on this table. Convert to America/New_York before presenting it. (queue #644)

13 rows where docket_id = "EPA-HQ-OPP-2011-1012" sorted by posted_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

document_type 4

  • Supporting & Related Material 8
  • Proposed Rule 2
  • Rule 2
  • Notice 1

posted_year 3

  • 2012 9
  • 2016 3
  • 2015 1

agency_id 1

  • EPA 13
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-2011-1012-0012 EPA Pyriproxyfen – Pesticide Petition (PP# 1E7950) and Registration Requests for use on Bulb Vegetable Group 3-07, Fruiting Vegetable Group 8-10, Citrus Fruit Group 10-10, Pome Fruit Group 11-10, Caneberry Subgroup 13-07A, Bushberry Subgroup 13-07B, Low Growing Berry Subgroup 13-07H and Herb Subgroup 19A EPA-HQ-OPP-2011-1012 Pesticide Tolerances: Pyriproxyfen Rule Final Rule 2016-02-22T05:00:00Z 2016 2 2016-02-22T05:00:00Z 2016-04-23T03:59:59Z 2016-04-22T05:00:24Z 2016-03608 0 0 0900006481e7c07b
EPA-HQ-OPP-2011-1012-0014 EPA Pyriproxyfen – Pesticide Petition (PP# 1E7950) and Registration Requests for use on Bulb Vegetable Group 3-07, Fruiting Vegetable Group 8-10, Citrus Fruit Group 10-10, Pome Fruit Group 11-10, Caneberry Subgroup 13-07A, Bushberry Subgroup 13-07B, Low Growing Berry Subgroup 13-07H and Herb Subgroup 19A EPA-HQ-OPP-2011-1012 Pyriproxyfen. Human Health Risk Assessment for the Petition to Increase the Established Tolerance in/on Tea with a U.S. Registration for Imported Pyriproxyfen-treated tea. Supporting & Related Material Risk Assessment 2016-02-22T05:00:00Z 2016 2     2016-02-23T01:31:42Z   0 0 0900006481e5db94
EPA-HQ-OPP-2011-1012-0013 EPA Pyriproxyfen – Pesticide Petition (PP# 1E7950) and Registration Requests for use on Bulb Vegetable Group 3-07, Fruiting Vegetable Group 8-10, Citrus Fruit Group 10-10, Pome Fruit Group 11-10, Caneberry Subgroup 13-07A, Bushberry Subgroup 13-07B, Low Growing Berry Subgroup 13-07H and Herb Subgroup 19A EPA-HQ-OPP-2011-1012 Sumitomo Chemical Company Notice of Filing Pesticide Petition #4E8326 raising the tolerance for residues of Pyriproxyfen in or on the raw agricultural commodity Tea Supporting & Related Material Petition 2016-02-22T05:00:00Z 2016 2     2016-02-23T01:31:37Z   0 0 0900006481e5db95
EPA-HQ-OPP-2011-1012-0010 EPA Pyriproxyfen – Pesticide Petition (PP# 1E7950) and Registration Requests for use on Bulb Vegetable Group 3-07, Fruiting Vegetable Group 8-10, Citrus Fruit Group 10-10, Pome Fruit Group 11-10, Caneberry Subgroup 13-07A, Bushberry Subgroup 13-07B, Low Growing Berry Subgroup 13-07H and Herb Subgroup 19A EPA-HQ-OPP-2011-1012 Pesticide Petitions: Residues of Pesticide Chemicals in or on Various Commodities Proposed Rule   2015-12-02T05:00:00Z 2015 12 2015-12-02T05:00:00Z 2016-01-05T04:59:59Z 2015-12-09T22:00:33Z 2015-30539 0 0 0900006481d80b27
EPA-HQ-OPP-2011-1012-0006 EPA Pyriproxyfen – Pesticide Petition (PP# 1E7950) and Registration Requests for use on Bulb Vegetable Group 3-07, Fruiting Vegetable Group 8-10, Citrus Fruit Group 10-10, Pome Fruit Group 11-10, Caneberry Subgroup 13-07A, Bushberry Subgroup 13-07B, Low Growing Berry Subgroup 13-07H and Herb Subgroup 19A EPA-HQ-OPP-2011-1012 Pyriproxyfen. Chronic Dietary (Food and Drinking Water) Exposure Assessment for the Petition Proposing Tolerances for Residues of Pyriproxyfen on Herb Subgroup 19A, and the Expansions of Existing Crop Group Uses to Numerous Crop Subgroups Supporting & Related Material Memorandum 2012-12-12T05:00:00Z 2012 12     2012-12-12T15:46:05Z   0 0 0900006481100e3e
EPA-HQ-OPP-2011-1012-0005 EPA Pyriproxyfen – Pesticide Petition (PP# 1E7950) and Registration Requests for use on Bulb Vegetable Group 3-07, Fruiting Vegetable Group 8-10, Citrus Fruit Group 10-10, Pome Fruit Group 11-10, Caneberry Subgroup 13-07A, Bushberry Subgroup 13-07B, Low Growing Berry Subgroup 13-07H and Herb Subgroup 19A EPA-HQ-OPP-2011-1012 Pyriproxyfen. Human Health Risk Assessment for the Request to Add Uses on Herb Subgroup 19A, and the Expansions of Existing Crop Group Uses to Numerous Crop Subgroups Supporting & Related Material Memorandum 2012-12-12T05:00:00Z 2012 12     2012-12-12T15:45:55Z   0 0 0900006481100e3d
EPA-HQ-OPP-2011-1012-0008 EPA Pyriproxyfen – Pesticide Petition (PP# 1E7950) and Registration Requests for use on Bulb Vegetable Group 3-07, Fruiting Vegetable Group 8-10, Citrus Fruit Group 10-10, Pome Fruit Group 11-10, Caneberry Subgroup 13-07A, Bushberry Subgroup 13-07B, Low Growing Berry Subgroup 13-07H and Herb Subgroup 19A EPA-HQ-OPP-2011-1012 Tier I Drinking Water Assessment for New Use of Insect Growth Inhibitor 2-[1-methyl-2- (4-phenoxyphenoxy)ethoxy]pyridine Pyriproxyfen on Herb Subgroup 19A Supporting & Related Material Memorandum 2012-12-12T05:00:00Z 2012 12     2012-12-12T15:45:35Z   0 0 0900006481105b20
EPA-HQ-OPP-2011-1012-0004 EPA Pyriproxyfen – Pesticide Petition (PP# 1E7950) and Registration Requests for use on Bulb Vegetable Group 3-07, Fruiting Vegetable Group 8-10, Citrus Fruit Group 10-10, Pome Fruit Group 11-10, Caneberry Subgroup 13-07A, Bushberry Subgroup 13-07B, Low Growing Berry Subgroup 13-07H and Herb Subgroup 19A EPA-HQ-OPP-2011-1012 Pesticide Tolerances: Pyriproxyfen Rule   2012-12-12T05:00:00Z 2012 12 2012-12-12T05:00:00Z 2013-02-12T04:59:59Z 2012-12-12T15:44:45Z 2012-29978 0 0 0900006481188861
EPA-HQ-OPP-2011-1012-0009 EPA Pyriproxyfen – Pesticide Petition (PP# 1E7950) and Registration Requests for use on Bulb Vegetable Group 3-07, Fruiting Vegetable Group 8-10, Citrus Fruit Group 10-10, Pome Fruit Group 11-10, Caneberry Subgroup 13-07A, Bushberry Subgroup 13-07B, Low Growing Berry Subgroup 13-07H and Herb Subgroup 19A EPA-HQ-OPP-2011-1012 E-mail from Health Effect Divison (HED) to Registation Divison (RD) regarding the Herb Subgroup 19A tolerance Supporting & Related Material E-mail 2012-12-12T05:00:00Z 2012 12     2012-12-12T15:45:45Z   0 0 090000648112a85c
EPA-HQ-OPP-2011-1012-0007 EPA Pyriproxyfen – Pesticide Petition (PP# 1E7950) and Registration Requests for use on Bulb Vegetable Group 3-07, Fruiting Vegetable Group 8-10, Citrus Fruit Group 10-10, Pome Fruit Group 11-10, Caneberry Subgroup 13-07A, Bushberry Subgroup 13-07B, Low Growing Berry Subgroup 13-07H and Herb Subgroup 19A EPA-HQ-OPP-2011-1012 Pyriproxyfen. Amended Use. Expansions of Existing Crop Group/Representative Commodity Uses to Numerous Crop Subgroups, Adding Use on Herb Subgroup 19A. Summary of Analytical Chemistry and Residue Data Supporting & Related Material Memorandum 2012-12-12T05:00:00Z 2012 12     2012-12-12T15:45:25Z   0 0 0900006481100e41
EPA-HQ-OPP-2011-1012-0003 EPA Pyriproxyfen – Pesticide Petition (PP# 1E7950) and Registration Requests for use on Bulb Vegetable Group 3-07, Fruiting Vegetable Group 8-10, Citrus Fruit Group 10-10, Pome Fruit Group 11-10, Caneberry Subgroup 13-07A, Bushberry Subgroup 13-07B, Low Growing Berry Subgroup 13-07H and Herb Subgroup 19A EPA-HQ-OPP-2011-1012 Pesticide Products: Registration Applications to Register New Uses Notice   2012-10-31T04:00:00Z 2012 10 2012-10-31T04:00:00Z 2012-12-01T04:59:59Z 2012-10-31T15:00:43Z 2012-26652 0 0 0900006481156d1f
EPA-HQ-OPP-2011-1012-0001 EPA Pyriproxyfen – Pesticide Petition (PP# 1E7950) and Registration Requests for use on Bulb Vegetable Group 3-07, Fruiting Vegetable Group 8-10, Citrus Fruit Group 10-10, Pome Fruit Group 11-10, Caneberry Subgroup 13-07A, Bushberry Subgroup 13-07B, Low Growing Berry Subgroup 13-07H and Herb Subgroup 19A EPA-HQ-OPP-2011-1012 Pesticide Petitions Filed: Residues of Pesticide Chemicals in or on Various Commodities Proposed Rule   2012-03-14T04:00:00Z 2012 3 2012-03-14T04:00:00Z 2012-04-14T03:59:59Z 2012-03-14T14:18:50Z 2012-06056 0 0 0900006480fd6cb2
EPA-HQ-OPP-2011-1012-0002 EPA Pyriproxyfen – Pesticide Petition (PP# 1E7950) and Registration Requests for use on Bulb Vegetable Group 3-07, Fruiting Vegetable Group 8-10, Citrus Fruit Group 10-10, Pome Fruit Group 11-10, Caneberry Subgroup 13-07A, Bushberry Subgroup 13-07B, Low Growing Berry Subgroup 13-07H and Herb Subgroup 19A EPA-HQ-OPP-2011-1012 Notice of Filing for Pyriproxyfen on Multiple Crops (PP 1E7950) Supporting & Related Material Petition 2012-03-14T04:00:00Z 2012 3     2012-03-14T14:18:50Z   0 0 0900006480f86c7c

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;
Powered by Datasette · Queries took 2.316ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API · Privacy