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

7 rows where docket_id = "EPA-HQ-OPP-2003-0248" and posted_year = 2014 sorted by posted_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

posted_year 1

  • 2014 · 7 ✖

document_type 1

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-OPP-2003-0248-0094 EPA None EPA-HQ-OPP-2003-0248 Post-RED PDCI: Creosote (022003) Product Specific Data Call In Response ID # PDCI-022003-30244 Coal Tar Supporting & Related Material   2014-01-31T05:00:00Z 2014 1     2014-01-31T20:23:32Z   0 0 0900006480fad0cb
EPA-HQ-OPP-2003-0248-0093 EPA None EPA-HQ-OPP-2003-0248 Post-RED PDCI: Creosote (025003) Creosote oil (Note: Derived from any source) ID # PDCI-025003-30245 Product Specific Data Call In Response Supporting & Related Material   2014-01-31T05:00:00Z 2014 1     2014-01-31T20:23:32Z   0 0 0900006480fad0bc
EPA-HQ-OPP-2003-0248-0096 EPA None EPA-HQ-OPP-2003-0248 Post-RED PDCI: Creosote (025004) ID # PDCI-025004-30247 Product Specfic Data Call In Response Coal Tar Creosote Supporting & Related Material   2014-01-31T05:00:00Z 2014 1     2014-01-31T20:23:33Z   0 0 0900006480fad0fd
EPA-HQ-OPP-2003-0248-0095 EPA None EPA-HQ-OPP-2003-0248 Post-RED GDCI: Creosote (025004) ID # GDCI-025004-30249 Generic Data Call In Response Coal Tar Creosote Supporting & Related Material   2014-01-31T05:00:00Z 2014 1     2014-01-31T20:23:32Z   0 0 0900006480fad0f1
EPA-HQ-OPP-2003-0248-0090 EPA None EPA-HQ-OPP-2003-0248 Post-RED GDCI: Creosote (022003) Generic Data Call In Response 0139 Coal Tar/Creosote Supporting & Related Material   2014-01-31T05:00:00Z 2014 1     2014-01-31T20:23:31Z   0 0 0900006480fad07e
EPA-HQ-OPP-2003-0248-0092 EPA None EPA-HQ-OPP-2003-0248 Post-RED GDCI: Creosote (025003) Generic Data Call In Response Creosote Oil (Note: Derived from any source) Supporting & Related Material   2014-01-31T05:00:00Z 2014 1     2014-01-31T20:23:32Z   0 0 0900006480fad0b8
EPA-HQ-OPP-2003-0248-0091 EPA None EPA-HQ-OPP-2003-0248 Post-RED PDCI: Creosote (022003)ID # PDCI-022003-30244 Product Specific Coal Tar Data Call In Response Supporting & Related Material   2014-01-31T05:00:00Z 2014 1     2014-01-31T20:23:31Z   0 0 0900006480fad0a4

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;