documents
Data license: Public Domain (U.S. Government data) · Data source: U.S. government sources, plus a few identifier registries; each is listed on the methodology page
- 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)
26 rows where docket_id = "EPA-R06-OAR-2009-0050" sorted by posted_date descending
This data as json, CSV (advanced)
| 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-R06-OAR-2009-0050-0030 | EPA | NM031 New Mexico State Regional Haze SIP EPA-R06-OAR-2009-0050 | NM031.030 Approvals and Promulgations of State Implementation Plans: New Mexico; Regional Haze Rule Requirements for Mandatory Class I Areas. 15 pages syt | Rule | 2012-11-27T05:00:00Z | 2012 | 11 | 2012-11-27T05:00:00Z | 2012-11-27T16:03:28Z | 2012-28591 | 0 | 0 | 09000064811749a8 | ||
| EPA-R06-OAR-2009-0050-0005 | EPA | NM031 New Mexico State Regional Haze SIP EPA-R06-OAR-2009-0050 | NM031.005 New Mexico State Regional Haze SIP submitted to EPA December 1, 2003 (NM-49) - Amendments Part 65 (20.2.65 NMAC), Smoke Management. 65 pages 3.4 MB s22 | Supporting & Related Material | Report | 2012-06-15T04:00:00Z | 2012 | 6 | 2012-06-15T14:25:12Z | 0 | 0 | 0900006480faca95 | |||
| EPA-R06-OAR-2009-0050-0023 | EPA | NM031 New Mexico State Regional Haze SIP EPA-R06-OAR-2009-0050 | NM031.023 EPA Guidance --- Attachments | Supporting & Related Material | Guidance | 2012-06-15T04:00:00Z | 2012 | 6 | 2012-06-15T14:43:58Z | 0 | 0 | 090000648103dcbb | |||
| EPA-R06-OAR-2009-0050-0014 | EPA | NM031 New Mexico State Regional Haze SIP EPA-R06-OAR-2009-0050 | NM031.014 New Mexico State Regional Haze SIP Revision, submitted to EPA June 24, 2011 (NM-106) (3of 10), Enclosures 5 to 11: Section 309(g) SIP. 411 pages 10.0 MB s26 | Supporting & Related Material | State/Tribal Submittal | 2012-06-15T04:00:00Z | 2012 | 6 | 2012-06-15T14:37:13Z | 0 | 0 | 0900006480ffef96 | |||
| EPA-R06-OAR-2009-0050-0017 | EPA | NM031 New Mexico State Regional Haze SIP EPA-R06-OAR-2009-0050 | NM031.017 New Mexico State Regional Haze SIP Revision, submitted to EPA June 24, 2011 (NM-106) (6 of 10), Enclosures 40 to 49: NMED Notice to Intent to Present Technical Testimony - May 2, 2011, Exhibits 7L to 7u with attachments for Exhibits 7L, 7n, 7o, and 7p. 710 pages 6.8 MB s2i | Supporting & Related Material | Report | 2012-06-15T04:00:00Z | 2012 | 6 | 2012-06-15T14:39:16Z | 0 | 0 | 0900006480ffef99 | |||
| EPA-R06-OAR-2009-0050-0006 | EPA | NM031 New Mexico State Regional Haze SIP EPA-R06-OAR-2009-0050 | NM031.006 New Mexico State Regional Haze SIP submitted to EPA December 1, 2003 (NM-49) - Amendments Part 73 (20.2.73 NMAC), Notice of Intent and Emissions Inventory Requirements. This submittal was superseded by revisions approved by EPA August 12, 2010 (75 FR 48860). This submittal is available in Regulations.gov docket EPA-R06-OAR-2005-NM-0009, document EPA-R06-OAR-2005-NM-0009-0004. | Supporting & Related Material | Report | 2012-06-15T04:00:00Z | 2012 | 6 | 2012-06-15T14:28:52Z | 0 | 0 | 0900006480faca96 | |||
| EPA-R06-OAR-2009-0050-0015 | EPA | NM031 New Mexico State Regional Haze SIP EPA-R06-OAR-2009-0050 | NM031.015 New Mexico State Regional Haze SIP Revision, submitted to EPA June 24, 2011 (NM-106) (4 of 10), Enclosures 12 to 27: NMED Notice to Intent to Present Technical Testimony - May 2, 2011, Exhibits 1 to 6. 125 pages 5.9 MB s26 | Supporting & Related Material | Report | 2012-06-15T04:00:00Z | 2012 | 6 | 2012-06-15T14:37:52Z | 0 | 0 | 0900006480ffef97 | |||
| EPA-R06-OAR-2009-0050-0020 | EPA | NM031 New Mexico State Regional Haze SIP EPA-R06-OAR-2009-0050 | NM031.020 New Mexico State Regional Haze SIP Revision, submitted to EPA June 24, 2011 (NM-106) (9 of 10), Enclosures 66 to74: NMED Supplemental Notice to Intent to Present Technical Testimony - May 20, 2011, and Exhibits; NMED Second Notice of Receipt of Comments; and NMED Exhibits presented at June 1, 2011 Hearing. 83 pages 3.0 MB s26 | Supporting & Related Material | Report | 2012-06-15T04:00:00Z | 2012 | 6 | 2012-06-15T14:41:52Z | 0 | 0 | 0900006480ffef9c | |||
| EPA-R06-OAR-2009-0050-0025 | EPA | NM031 New Mexico State Regional Haze SIP EPA-R06-OAR-2009-0050 | NM031.025 New Mexico Dust Control Measures --- Attachments | Supporting & Related Material | 2012-06-15T04:00:00Z | 2012 | 6 | 2012-06-15T14:45:51Z | 0 | 0 | 090000648103dcbd | ||||
| EPA-R06-OAR-2009-0050-0002 | EPA | NM031 New Mexico State Regional Haze SIP EPA-R06-OAR-2009-0050 | NM031.002 New Mexico Regional Haze Technical Support Document --- Attachments | Supporting & Related Material | State/Tribal Submittal | 2012-06-15T04:00:00Z | 2012 | 6 | 2012-06-15T14:23:22Z | 0 | 0 | 090000648082839e | |||
| EPA-R06-OAR-2009-0050-0021 | EPA | NM031 New Mexico State Regional Haze SIP EPA-R06-OAR-2009-0050 | NM031.021 New Mexico State Regional Haze SIP Revision, submitted to EPA June 24, 2011 (NM-106) (10 of 10), Enclosures 78 and 79 [end]: Transcript of Hearing, June 1 and 2; and New Mexico Environmental Improvement Board Statement of Reason for Adoption of SIP Revisions. 380 pages 1.7 MB s26 | Supporting & Related Material | Report | 2012-06-15T04:00:00Z | 2012 | 6 | 2012-06-15T14:42:20Z | 0 | 0 | 0900006480ffefba | |||
| EPA-R06-OAR-2009-0050-0010 | EPA | NM031 New Mexico State Regional Haze SIP EPA-R06-OAR-2009-0050 | NM031.010 Federal Register, January 15, 2009 (74 FR 2392 to 2395), Final Rule; Findings for Failure to Submit State Implementation Plans Required by the 1999 Regional Haze Rule. 4 pages s4t | Supporting & Related Material | Report | 2012-06-15T04:00:00Z | 2012 | 6 | 2012-06-15T14:31:51Z | 0 | 0 | 0900006480facae6 | |||
| EPA-R06-OAR-2009-0050-0008 | EPA | NM031 New Mexico State Regional Haze SIP EPA-R06-OAR-2009-0050 | NM031.008 New Mexico State Regional Haze SIP submitted to EPA December 1, 2003 (NM-49) - Transcripts and Exhibits for the Hearings. 270 pages 14.7 MB s22 | Supporting & Related Material | Report | 2012-06-15T04:00:00Z | 2012 | 6 | 2012-06-15T14:29:52Z | 0 | 0 | 0900006480faca98 | |||
| EPA-R06-OAR-2009-0050-0013 | EPA | NM031 New Mexico State Regional Haze SIP EPA-R06-OAR-2009-0050 | NM031.013 New Mexico State Regional Haze SIP Revision, submitted to EPA June 24, 2011 (NM-106) (2of 10), Enclosures 1 to 4: Revised Section 309 SIP; Appendix K; Revisions to Part 73 Notice of Intent and Emissions Inventory Requirements; and Revisions to Part 81, Western Backstop Sulfur Dioxide Trading Program. 297 pages 3.5 MB s26 | Supporting & Related Material | State/Tribal Submittal | 2012-06-15T04:00:00Z | 2012 | 6 | 2012-06-15T14:36:12Z | 0 | 0 | 0900006480ffef95 | |||
| EPA-R06-OAR-2009-0050-0004 | EPA | NM031 New Mexico State Regional Haze SIP EPA-R06-OAR-2009-0050 | NM031.004 New Mexico State Regional Haze SIP submitted to EPA December 1, 2003 (NM-49) - Amendments Part 60 (20.2.60 NMAC), Open Burning. 237 pages 12.4 MB s22 | Supporting & Related Material | Report | 2012-06-15T04:00:00Z | 2012 | 6 | 2012-06-15T14:24:42Z | 0 | 0 | 0900006480faca94 | |||
| EPA-R06-OAR-2009-0050-0024 | EPA | NM031 New Mexico State Regional Haze SIP EPA-R06-OAR-2009-0050 | NM031.024 Supporting Materials --- Attachments | Supporting & Related Material | 2012-06-15T04:00:00Z | 2012 | 6 | 2012-06-15T14:45:04Z | 0 | 0 | 090000648103dcbc | ||||
| EPA-R06-OAR-2009-0050-0011 | EPA | NM031 New Mexico State Regional Haze SIP EPA-R06-OAR-2009-0050 | NM031.011 New Mexico State Federal Clean Air Act 110(a)(2)(D)(i)(II) Interstate Transport SIP Revision, submitted to EPA June 24, 2011 (NM-106). 421 pages 69.9 MB s23 | Supporting & Related Material | Report | 2012-06-15T04:00:00Z | 2012 | 6 | 2012-06-15T14:33:36Z | 0 | 0 | 0900006480facae9 | |||
| EPA-R06-OAR-2009-0050-0012 | EPA | NM031 New Mexico State Regional Haze SIP EPA-R06-OAR-2009-0050 | NM031.012 New Mexico State Regional Haze SIP Revision, submitted to EPA June 24, 2011 (NM-106) (1 of 10). Cover Letter and List of Enclosures. 6 pages s26 | Supporting & Related Material | Report | 2012-06-15T04:00:00Z | 2012 | 6 | 2012-06-15T14:35:26Z | 0 | 0 | 0900006480facaea | |||
| EPA-R06-OAR-2009-0050-0022 | EPA | NM031 New Mexico State Regional Haze SIP EPA-R06-OAR-2009-0050 | NM031.022 Letter from New Mexico State Environment Department (NMED) to EPA, January 24, 2012, RE New Mexico Dust Control Measures -- Natural Events Action Plans. 1 page s4u | Supporting & Related Material | Report | 2012-06-15T04:00:00Z | 2012 | 6 | 2012-06-15T14:43:01Z | 0 | 0 | 0900006480fff97b | |||
| EPA-R06-OAR-2009-0050-0001 | EPA | NM031 New Mexico State Regional Haze SIP EPA-R06-OAR-2009-0050 | NM031.001 Approvals and Promulgations of State Implementation Plans: New Mexico; Regional Haze Rule Requirements for Mandatory Class I Areas. 41 pages s6f | Proposed Rule | 2012-06-15T04:00:00Z | 2012 | 6 | 2012-06-15T04:00:00Z | 2012-07-17T03:59:59Z | 2012-07-18T02:00:47Z | 2012-14247 | 0 | 0 | 090000648104c4b9 | |
| EPA-R06-OAR-2009-0050-0007 | EPA | NM031 New Mexico State Regional Haze SIP EPA-R06-OAR-2009-0050 | NM031.007 New Mexico State Regional Haze SIP submitted to EPA December 1, 2003 (NM-49) - Amendments Part 81 (20.2.81 NMAC), Western Backstop Sulfur Dioxide Trading Program. 125 pages 5.9 MB s22 | Supporting & Related Material | Report | 2012-06-15T04:00:00Z | 2012 | 6 | 2012-06-15T14:29:20Z | 0 | 0 | 0900006480faca97 | |||
| EPA-R06-OAR-2009-0050-0009 | EPA | NM031 New Mexico State Regional Haze SIP EPA-R06-OAR-2009-0050 | NM031.009 New Mexico State Regional Haze SIP Clarification Letter submitted to EPA January 13, 2009 (NM-49). 1 page s4t | Supporting & Related Material | Report | 2012-06-15T04:00:00Z | 2012 | 6 | 2012-06-15T14:31:15Z | 0 | 0 | 0900006480facae5 | |||
| EPA-R06-OAR-2009-0050-0003 | EPA | NM031 New Mexico State Regional Haze SIP EPA-R06-OAR-2009-0050 | NM031.003 New Mexico State Regional Haze SIP, submitted to EPA December 1, 2003 (NM-49). 410 pages 15.2 MB s22 | Supporting & Related Material | State/Tribal Submittal | 2012-06-15T04:00:00Z | 2012 | 6 | 2012-06-15T14:24:11Z | 0 | 0 | 0900006480ec645a | |||
| EPA-R06-OAR-2009-0050-0018 | EPA | NM031 New Mexico State Regional Haze SIP EPA-R06-OAR-2009-0050 | NM031.018 New Mexico State Regional Haze SIP Revision, submitted to EPA June 24, 2011 (NM-106) (7 of 10), Enclosures 50 to 59: NMED Notice to Intent to Present Technical Testimony - May 2, 2011, Exhibits 8 to 12. 95 pages 3.9 MB s26 | Supporting & Related Material | Report | 2012-06-15T04:00:00Z | 2012 | 6 | 2012-06-15T14:40:15Z | 0 | 0 | 0900006480ffef9a | |||
| EPA-R06-OAR-2009-0050-0016 | EPA | NM031 New Mexico State Regional Haze SIP EPA-R06-OAR-2009-0050 | NM031.016 New Mexico State Regional Haze SIP Revision, submitted to EPA June 24, 2011 (NM-106) (5 of 10), Enclosures 28 to 39: NMED Notice to Intent to Present Technical Testimony - May 2, 2011, Exhibits 7 to 7k. 651 pages 16.4 MB s2i | Supporting & Related Material | Report | 2012-06-15T04:00:00Z | 2012 | 6 | 2012-06-15T14:38:39Z | 0 | 0 | 0900006480ffef98 | |||
| EPA-R06-OAR-2009-0050-0019 | EPA | NM031 New Mexico State Regional Haze SIP EPA-R06-OAR-2009-0050 | NM031.019 New Mexico State Regional Haze SIP Revision, submitted to EPA June 24, 2011 (NM-106) (8 of 10), Enclosures 60 to 65: San Juan Citizens Alliance Comments; Public Service Company of NM and San Juan coal Company NOI to present technical testimony; and NRDC, San Juan Citizens Alliance, and WildEarth Guardians Entry of Appearance. 560 pages 15.0 MB s26 | Supporting & Related Material | Report | 2012-06-15T04:00:00Z | 2012 | 6 | 2012-06-15T14:41:21Z | 0 | 0 | 0900006480ffef9b |
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;