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

5 rows where docket_id = "EPA-HQ-RCRA-2002-0033" and posted_year = 2003 sorted by posted_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

posted_year 1

  • 2003 · 5 ✖

document_type 1

  • Supporting & Related Material 5

agency_id 1

  • EPA 5
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-RCRA-2002-0033-0047 EPA None EPA-HQ-RCRA-2002-0033 Comments from EPA Region IX on Draft Guidance for Evaluating the Vapor Intrusion to Indoor Air Pathway from Groundwater and Soils Supporting & Related Material Other 2003-08-28T04:00:00Z 2003 8     2006-10-23T20:15:51Z   0 0 09000064800e1422
EPA-HQ-RCRA-2002-0033-0042 EPA None EPA-HQ-RCRA-2002-0033 Letter from the United States Environmental Protection Agency, Region 10, Regarding Comments on the OSWER Draft Guidance for Evaluating the Vapor Intrusion to Indoor Air Pathway from Groundwater and Soils Supporting & Related Material Other 2003-06-23T04:00:00Z 2003 6     2006-10-23T20:15:51Z   0 0 09000064800e13de
EPA-HQ-RCRA-2002-0033-0044 EPA None EPA-HQ-RCRA-2002-0033 Letter from the United States EPA, Region VIII, Regarding the Draft Guidance for Evaluating the Vapor Intrusion to Indoor Air Pathway from Groundwater and Soils Supporting & Related Material Other 2003-06-23T04:00:00Z 2003 6     2006-10-23T20:15:51Z   0 0 09000064800e13f8
EPA-HQ-RCRA-2002-0033-0043 EPA None EPA-HQ-RCRA-2002-0033 Comments from EPA Region III on Draft Guidance for Evaluating the Vapor Intrusion to Indoor Air Pathway from Groundwater and Soils Supporting & Related Material Other 2003-06-23T04:00:00Z 2003 6     2006-10-23T20:15:51Z   0 0 09000064800e13ec
EPA-HQ-RCRA-2002-0033-0045 EPA None EPA-HQ-RCRA-2002-0033 Comments on the Vapor Intrusion Guidance, Scientific Analysis Team, Indoor Environmental Division/ORIA/OAR Supporting & Related Material Other 2003-06-23T04:00:00Z 2003 6     2006-10-23T20:15:51Z   0 0 09000064800e1406

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