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 = "FWS-R3-ES-2019-0002" sorted by posted_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

posted_year 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
FWS-R3-ES-2019-0002-0005 FWS Petitions to List Coldwater crayfish, Eleven Point River crayfish, and Spring River crayfish as Endangered or Threatened Species Under the Endangered Species Act of 1973, as Amended FWS-R3-ES-2019-0002 Petition to List 404 Aquatic, Riparian and Wetland Species from the Southeastern United States as Threatened or Endangered Under the Endangered Species Act from the Center for Biological Diversity Supporting & Related Material Petition 2019-04-04T04:00:00Z 2019 4     2019-04-04T13:30:07Z   0 0 0900006483b5f439
FWS-R3-ES-2019-0002-0003 FWS Petitions to List Coldwater crayfish, Eleven Point River crayfish, and Spring River crayfish as Endangered or Threatened Species Under the Endangered Species Act of 1973, as Amended FWS-R3-ES-2019-0002 Species Status Assessment Report - Coldwater Crayfish and Eleven Point River Crayfish Supporting & Related Material Evaluation 2019-04-04T04:00:00Z 2019 4     2019-04-04T13:30:05Z   0 0 0900006483b5ecc4
FWS-R3-ES-2019-0002-0002 FWS Petitions to List Coldwater crayfish, Eleven Point River crayfish, and Spring River crayfish as Endangered or Threatened Species Under the Endangered Species Act of 1973, as Amended FWS-R3-ES-2019-0002 Final - Spring River Crayfish Species Status Assessment Report Supporting & Related Material Evaluation 2019-04-04T04:00:00Z 2019 4     2019-04-04T13:30:04Z   0 0 0900006483b5ecc3
FWS-R3-ES-2019-0002-0001 FWS Petitions to List Coldwater crayfish, Eleven Point River crayfish, and Spring River crayfish as Endangered or Threatened Species Under the Endangered Species Act of 1973, as Amended FWS-R3-ES-2019-0002 Endangered and Threatened Species: 12-Month Findings on Petition to List Coldwater crayfish, Eleven Point River crayfish, and Spring River crayfish as Endangered or Threatened Species Proposed Rule   2019-04-04T04:00:00Z 2019 4 2019-04-04T04:00:00Z   2019-04-04T13:29:07Z 2019-06535 0 0 0900006483b63988
FWS-R3-ES-2019-0002-0004 FWS Petitions to List Coldwater crayfish, Eleven Point River crayfish, and Spring River crayfish as Endangered or Threatened Species Under the Endangered Species Act of 1973, as Amended FWS-R3-ES-2019-0002 Species Status Assessment and Listing Priority Form - Coldwater crayfish, Eleven Point River crayfish, and Spring River crayfish Supporting & Related Material Evaluation 2019-04-04T04:00:00Z 2019 4     2019-04-04T13:30:06Z   0 0 0900006483b5f53a

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;