documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
50 rows where docket_id = "EPA-R08-OAR-2019-0007" and posted_year = 2019 sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: posted_date, posted_month, comment_start_date, posted_date (date), comment_start_date (date), last_modified (date)
| 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-R08-OAR-2019-0007-0050 | EPA | None EPA-R08-OAR-2019-0007 | TurtlesEast Part 2 TAT Enerplus | Other | 2019-11-22T05:00:00Z | 2019 | 11 | 2019-11-22T05:00:00Z | 2019-11-23T02:08:17Z | 0 | 0 | 090000648419a82c | |||
| EPA-R08-OAR-2019-0007-0048 | EPA | None EPA-R08-OAR-2019-0007 | Minot Grady 26-35H Pad Part 2 App to EPA | Other | 2019-10-04T04:00:00Z | 2019 | 10 | 2019-10-04T04:00:00Z | 2019-10-05T00:38:07Z | 0 | 0 | 090000648402290c | |||
| EPA-R08-OAR-2019-0007-0049 | EPA | None EPA-R08-OAR-2019-0007 | Pad 118 Registration Pt 2 | Other | 2019-10-04T04:00:00Z | 2019 | 10 | 2019-10-04T04:00:00Z | 2019-10-05T00:38:20Z | 0 | 0 | 090000648402290d | |||
| EPA-R08-OAR-2019-0007-0043 | EPA | None EPA-R08-OAR-2019-0007 | AfricanAnimalsNorth_Tribal Part 2 TAT Enerplus | Other | 2019-09-05T04:00:00Z | 2019 | 9 | 2019-09-05T04:00:00Z | 2019-09-06T01:45:54Z | 0 | 0 | 0900006483eef4c4 | |||
| EPA-R08-OAR-2019-0007-0041 | EPA | None EPA-R08-OAR-2019-0007 | AAFishWest REG TAT Enerplu | Other | 2019-09-05T04:00:00Z | 2019 | 9 | 2019-09-05T04:00:00Z | 2019-09-06T01:46:46Z | 0 | 0 | 0900006483eef4c2 | |||
| EPA-R08-OAR-2019-0007-0046 | EPA | None EPA-R08-OAR-2019-0007 | Peppers Pad Part2 TAT Enerplus | Other | 2019-09-05T04:00:00Z | 2019 | 9 | 2019-09-05T04:00:00Z | 2019-09-06T01:47:04Z | 0 | 0 | 0900006483eef716 | |||
| EPA-R08-OAR-2019-0007-0045 | EPA | None EPA-R08-OAR-2019-0007 | Ducks Pad Part 2 TAT Enerplus | Other | 2019-09-05T04:00:00Z | 2019 | 9 | 2019-09-05T04:00:00Z | 2019-09-06T01:47:21Z | 0 | 0 | 0900006483eef715 | |||
| EPA-R08-OAR-2019-0007-0042 | EPA | None EPA-R08-OAR-2019-0007 | African Animals REG TAT Enerplus | Other | 2019-09-05T04:00:00Z | 2019 | 9 | 2019-09-05T04:00:00Z | 2019-09-06T01:46:11Z | 0 | 0 | 0900006483eef4c3 | |||
| EPA-R08-OAR-2019-0007-0044 | EPA | None EPA-R08-OAR-2019-0007 | Bags Part1 TAT Enerplus | Other | 2019-09-05T04:00:00Z | 2019 | 9 | 2019-09-05T04:00:00Z | 2019-09-06T01:47:38Z | 0 | 0 | 0900006483eef714 | |||
| EPA-R08-OAR-2019-0007-0047 | EPA | None EPA-R08-OAR-2019-0007 | Vegetation North Part2 TAT Enerplus | Other | 2019-09-05T04:00:00Z | 2019 | 9 | 2019-09-05T04:00:00Z | 2019-09-06T01:46:29Z | 0 | 0 | 0900006483eef717 | |||
| EPA-R08-OAR-2019-0007-0040 | EPA | None EPA-R08-OAR-2019-0007 | GreekGods_Tribal Part 2 TAT Enerplus | Other | 2019-08-16T04:00:00Z | 2019 | 8 | 2019-08-16T04:00:00Z | 2019-08-17T00:51:19Z | 0 | 0 | 0900006483e65382 | |||
| EPA-R08-OAR-2019-0007-0036 | EPA | None EPA-R08-OAR-2019-0007 | MetalsNorth Part1 Mod TAT Enerplus | Other | 2019-07-11T04:00:00Z | 2019 | 7 | 2019-07-11T04:00:00Z | 2019-07-12T00:43:17Z | 0 | 0 | 0900006483d7e225 | |||
| EPA-R08-OAR-2019-0007-0039 | EPA | None EPA-R08-OAR-2019-0007 | WeathersNorth Part1 TAT Enerplus | Other | 2019-07-11T04:00:00Z | 2019 | 7 | 2019-07-11T04:00:00Z | 2019-07-12T00:42:31Z | 0 | 0 | 0900006483d7e228 | |||
| EPA-R08-OAR-2019-0007-0037 | EPA | None EPA-R08-OAR-2019-0007 | TurtlesEast_TribalFIP_Part1 TAT Enerplus | Other | 2019-07-11T04:00:00Z | 2019 | 7 | 2019-07-11T04:00:00Z | 2019-07-12T00:43:02Z | 0 | 0 | 0900006483d7e226 | |||
| EPA-R08-OAR-2019-0007-0038 | EPA | None EPA-R08-OAR-2019-0007 | Weathers South Part1 TAT Enerplus | Other | 2019-07-11T04:00:00Z | 2019 | 7 | 2019-07-11T04:00:00Z | 2019-07-12T00:42:47Z | 0 | 0 | 0900006483d7e227 | |||
| EPA-R08-OAR-2019-0007-0019 | EPA | None EPA-R08-OAR-2019-0007 | Sewing West Part1 Enerplus TAT | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:25:09Z | 0 | 0 | 0900006483a32fb1 | |||
| EPA-R08-OAR-2019-0007-0006 | EPA | None EPA-R08-OAR-2019-0007 | Dogs_TribalNSR_Part2 | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:29:32Z | 0 | 0 | 0900006483a32fa4 | |||
| EPA-R08-OAR-2019-0007-0027 | EPA | None EPA-R08-OAR-2019-0007 | TribalFIP_Horns_Part2Registration | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:21:57Z | 0 | 0 | 0900006483a32fbb | |||
| EPA-R08-OAR-2019-0007-0025 | EPA | None EPA-R08-OAR-2019-0007 | TribalFIP_Cactus_Part2 | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:21:16Z | 0 | 0 | 0900006483a32fb9 | |||
| EPA-R08-OAR-2019-0007-0026 | EPA | None EPA-R08-OAR-2019-0007 | TribalFIP_Cranes_Part2Registration | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:21:37Z | 0 | 0 | 0900006483a32fba | |||
| EPA-R08-OAR-2019-0007-0016 | EPA | None EPA-R08-OAR-2019-0007 | MetalsEast_Part1_TribalFIP | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:26:10Z | 0 | 0 | 0900006483a32fae | |||
| EPA-R08-OAR-2019-0007-0028 | EPA | None EPA-R08-OAR-2019-0007 | TribalFIP_MarsupialsEast_Part1 | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:22:19Z | 0 | 0 | 0900006483a32fbc | |||
| EPA-R08-OAR-2019-0007-0033 | EPA | None EPA-R08-OAR-2019-0007 | TribalFIP_SnakesEast_Part2 | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:24:06Z | 0 | 0 | 0900006483a32fc1 | |||
| EPA-R08-OAR-2019-0007-0029 | EPA | None EPA-R08-OAR-2019-0007 | TribalFIP_MarsupialsEast_Part2 | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:22:38Z | 0 | 0 | 0900006483a32fbd | |||
| EPA-R08-OAR-2019-0007-0005 | EPA | None EPA-R08-OAR-2019-0007 | Dogs Pad Part 1 | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:29:54Z | 0 | 0 | 0900006483a32fa3 | |||
| EPA-R08-OAR-2019-0007-0008 | EPA | None EPA-R08-OAR-2019-0007 | EA_complete_part 1 | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:28:53Z | 0 | 0 | 0900006483a32fa6 | |||
| EPA-R08-OAR-2019-0007-0004 | EPA | None EPA-R08-OAR-2019-0007 | Bugs Pad Part 1 | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:30:14Z | 0 | 0 | 0900006483a32fa2 | |||
| EPA-R08-OAR-2019-0007-0007 | EPA | None EPA-R08-OAR-2019-0007 | Ducks_TribalFIP_Part1 Enerplus TAT | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:29:11Z | 0 | 0 | 0900006483a32fa5 | |||
| EPA-R08-OAR-2019-0007-0031 | EPA | None EPA-R08-OAR-2019-0007 | TribalFIP_Part2Registration_Landforms | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:23:22Z | 0 | 0 | 0900006483a32fbf | |||
| EPA-R08-OAR-2019-0007-0018 | EPA | None EPA-R08-OAR-2019-0007 | Mountains_TribalFIP_Part1 | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:25:31Z | 0 | 0 | 0900006483a32fb0 | |||
| EPA-R08-OAR-2019-0007-0035 | EPA | None EPA-R08-OAR-2019-0007 | TribesWest_TribalNSR_Part1 | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:24:49Z | 0 | 0 | 0900006483a32fc3 | |||
| EPA-R08-OAR-2019-0007-0002 | EPA | None EPA-R08-OAR-2019-0007 | Bags_Tribal Part2 Enerplus TAT | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:31:14Z | 0 | 0 | 0900006483a331b7 | |||
| EPA-R08-OAR-2019-0007-0034 | EPA | None EPA-R08-OAR-2019-0007 | TribesEast_TribalNSR_Part1 | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:24:26Z | 0 | 0 | 0900006483a32fc2 | |||
| EPA-R08-OAR-2019-0007-0001 | EPA | None EPA-R08-OAR-2019-0007 | Bags Pad Part2 Enerplus TAT 2018 | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:30:53Z | 0 | 0 | 0900006483a331b6 | |||
| EPA-R08-OAR-2019-0007-0012 | EPA | None EPA-R08-OAR-2019-0007 | Fool Bear EA_TandE | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:28:14Z | 0 | 0 | 0900006483a32faa | |||
| EPA-R08-OAR-2019-0007-0014 | EPA | None EPA-R08-OAR-2019-0007 | Grains_TribalNSR_Part2 | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:27:34Z | 0 | 0 | 0900006483a32fac | |||
| EPA-R08-OAR-2019-0007-0017 | EPA | None EPA-R08-OAR-2019-0007 | MetalsNorth_Part1_TribalFIP | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:25:50Z | 0 | 0 | 0900006483a32faf | |||
| EPA-R08-OAR-2019-0007-0011 | EPA | None EPA-R08-OAR-2019-0007 | Enerplus Shrubs Part2 Reg | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:27:52Z | 0 | 0 | 0900006483a32fa9 | |||
| EPA-R08-OAR-2019-0007-0020 | EPA | None EPA-R08-OAR-2019-0007 | Shrubs Pad Part 1 | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:19:34Z | 0 | 0 | 0900006483a32fb2 | |||
| EPA-R08-OAR-2019-0007-0009 | EPA | None EPA-R08-OAR-2019-0007 | EA_complete_part 2 | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:28:34Z | 0 | 0 | 0900006483a32fa7 | |||
| EPA-R08-OAR-2019-0007-0015 | EPA | None EPA-R08-OAR-2019-0007 | Horns_TribalNSR_Part1 | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:26:32Z | 0 | 0 | 0900006483a32fad | |||
| EPA-R08-OAR-2019-0007-0024 | EPA | None EPA-R08-OAR-2019-0007 | TribalFIP_Cactus_Part1 | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:20:57Z | 0 | 0 | 0900006483a32fb8 | |||
| EPA-R08-OAR-2019-0007-0023 | EPA | None EPA-R08-OAR-2019-0007 | TribalFIP_BrughBear_Part2Registration | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:20:37Z | 0 | 0 | 0900006483a32fb7 | |||
| EPA-R08-OAR-2019-0007-0032 | EPA | None EPA-R08-OAR-2019-0007 | TribalFIP_Part2Registration_Spices | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:23:44Z | 0 | 0 | 0900006483a32fc0 | |||
| EPA-R08-OAR-2019-0007-0022 | EPA | None EPA-R08-OAR-2019-0007 | THPO letter_Fool Bear pad | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:20:16Z | 0 | 0 | 0900006483a32fb4 | |||
| EPA-R08-OAR-2019-0007-0003 | EPA | None EPA-R08-OAR-2019-0007 | Birds_NSR_Registration_7.2017 | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:30:34Z | 0 | 0 | 0900006483a32fa1 | |||
| EPA-R08-OAR-2019-0007-0030 | EPA | None EPA-R08-OAR-2019-0007 | TribalFIP_Part2Registration_BrughBear | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:22:59Z | 0 | 0 | 0900006483a32fbe | |||
| EPA-R08-OAR-2019-0007-0010 | EPA | None EPA-R08-OAR-2019-0007 | Enerplus Example Sufficient ESA-NHPA Documentation | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:26:53Z | 0 | 0 | 0900006483a32fa8 | |||
| EPA-R08-OAR-2019-0007-0013 | EPA | None EPA-R08-OAR-2019-0007 | Grains_TribalNSR_Part1 | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:27:14Z | 0 | 0 | 0900006483a32fab | |||
| EPA-R08-OAR-2019-0007-0021 | EPA | None EPA-R08-OAR-2019-0007 | Spices_TribalNSR_Part1 | Other | 2019-02-01T05:00:00Z | 2019 | 2 | 2019-02-01T05:00:00Z | 2019-02-02T02:19:56Z | 0 | 0 | 0900006483a32fb3 |
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;