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

8 rows where agency_id = "EPA" and docket_id = "EPA-R06-OAR-2012-0400" sorted by posted_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: posted_date, posted_month, posted_date (date), comment_start_date (date), comment_end_date (date), last_modified (date)

document_type 3

  • Supporting & Related Material 6
  • Proposed Rule 1
  • Rule 1

posted_year 1

  • 2015 8

agency_id 1

  • EPA · 8 ✖
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-2012-0400-0008 EPA None EPA-R06-OAR-2012-0400 NM052.08 Air Quality State Implementation Plans; Approval and Promulgation; New Mexico Albuquerque-Bernalillo County; Infrastructure and Interstate Transport State Implementation Plan for the 2008 Lead National Ambient Air Quality Standards, Final Rule, 3 pages. Rule   2015-12-03T05:00:00Z 2015 12 2015-12-03T05:00:00Z   2015-12-03T17:03:48Z 2015-30541 0 0 0900006481d82b74
EPA-R06-OAR-2012-0400-0006 EPA None EPA-R06-OAR-2012-0400 NM052.06 Albuquerque-Bernalillo County 2014 Annual Network Review for Ambient Air Monitoring submitted to EPA July 10, 2014. 14 pages v9a Supporting & Related Material   2015-09-11T04:00:00Z 2015 9     2015-09-12T00:35:44Z   0 0 0900006481c68bc0
EPA-R06-OAR-2012-0400-0007 EPA None EPA-R06-OAR-2012-0400 NM052.07 EPA Review, February 3, 2015, of Albuquerque-Bernalillo County 2014 Annual Network Review for Ambient Air Monitoring submitted to EPA July 10, 2014. 4 pages v9a Supporting & Related Material   2015-09-11T04:00:00Z 2015 9     2015-09-12T00:36:20Z   0 0 0900006481c68bc1
EPA-R06-OAR-2012-0400-0005 EPA None EPA-R06-OAR-2012-0400 NM052.05 EPA Guidance on Infrastructure State Implementation Plan Elements Required Under the Federal Clean Air Act Sections 110(a)(1) and 110(a)(2) for the 2008 Lead National Ambient Air Quality Standards, EPA Office of Air Quality Planning and Standards, October 14, 2011. 22 pages v9b Supporting & Related Material   2015-09-11T04:00:00Z 2015 9     2015-09-12T00:36:01Z   0 0 0900006481c68bbf
EPA-R06-OAR-2012-0400-0002 EPA None EPA-R06-OAR-2012-0400 NM052.02 EPA Technical Support Document, August 2015, 19 pages v9a Supporting & Related Material State/Tribal Submittal 2015-09-11T04:00:00Z 2015 9     2015-09-12T00:35:36Z   0 0 090000648100f598
EPA-R06-OAR-2012-0400-0003 EPA None EPA-R06-OAR-2012-0400 NM052.03 New Mexico Albuquerque-Bernalillo County SIP To Address Infrastructure Requirements of Section 110 (a)(2)(A)-(M) of the Federal Clean Air Act To Implement the 2008 Lead National Ambient Air Quality Standards, submitted to EPA May 2, 2012 (NM-117). 122 pages 2.5 MB v9b Supporting & Related Material State/Tribal Submittal 2015-09-11T04:00:00Z 2015 9     2015-09-12T00:36:25Z   0 0 0900006481047b9f
EPA-R06-OAR-2012-0400-0004 EPA None EPA-R06-OAR-2012-0400 NM052.04 EPA OAR/OAQPS/AQAD Memorandum, November 7, 2011, RE: Estimated Contribution of Ambient Lead (Pb) to Class I Area Visibility Impairment. 3 pages v9a Supporting & Related Material State/Tribal Submittal 2015-09-11T04:00:00Z 2015 9     2015-09-12T00:36:09Z   0 0 090000648146c853
EPA-R06-OAR-2012-0400-0001 EPA None EPA-R06-OAR-2012-0400 NM052.01 Air Quality State Implementation Plans; Approval and Promulgation; New Mexico; Albuquerque-Bernalillo County; Infrastructure and Interstate Transport State Implementation Plan for the 2008 Lead National Ambient Air Quality Standards, Proposed rule, 5 pages. Proposed Rule   2015-09-11T04:00:00Z 2015 9 2015-09-11T04:00:00Z 2015-10-14T03:59:59Z 2015-09-11T16:58:16Z 2015-22862 0 0 0900006481c68258

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 62.093ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API