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

4 rows where docket_id = "EPA-HQ-RCRA-1997-0007" sorted by posted_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

posted_year 2

agency_id 1

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-1997-0007-0004 EPA None EPA-HQ-RCRA-1997-0007 MEMORANDUM TO THE RCRA DOCKET REGARDING EPA'S DETERMINATION THAT THERE WILL BE ADEQUATE NATIONAL CAPACITY THROUGH 2019, WITH THE EFFECT THAT ALL STATES WILL CONTINUE TO BE ELIGIBLE TO RECEIVE SUPERFUND TRUST FUNDS Supporting & Related Material Other 1998-12-09T05:00:00Z 1998 12     2006-10-23T19:30:36Z   0 0 09000064800dc38c
EPA-HQ-RCRA-1997-0007-0003 EPA None EPA-HQ-RCRA-1997-0007 MEMORANDUM TO THE RCRA DOCKET REGARDING ADDITIONAL SOURCE MATERIAL PERTAINING TO UPDATE FOR THE NATIONAL CAPACITY ASSESSMENT PURSUANT TO CERCLA 104(C)(9) Supporting & Related Material Other 1998-04-24T04:00:00Z 1998 4     2006-10-23T19:30:36Z   0 0 09000064800dc388
EPA-HQ-RCRA-1997-0007-0002 EPA None EPA-HQ-RCRA-1997-0007 NATIONAL CAPACITY ASSESSMENT REPORT: CAPACITY PLANNING PURSUANT TO CERCLA SECTION 104(C)(9) Supporting & Related Material Other 1997-01-22T05:00:00Z 1997 1     2006-10-23T19:30:36Z   0 0 09000064800dc385
EPA-HQ-RCRA-1997-0007-0001 EPA None EPA-HQ-RCRA-1997-0007 CERCLA 104(c)(9) Capacity Assurance Planning; National Capacity Assessment Report; Notice of Availability of Final Report Notice Federal Register Document 1997-01-15T05:00:00Z 1997 1     2008-01-08T21:22:31Z 2156 0 0 09000064800dc382

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;