documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
5 rows where docket_id = "CDC_FRDOC_0001" and posted_year = 2020 sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: posted_month, posted_date (date), comment_start_date (date), comment_end_date (date), last_modified (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CDC_FRDOC_0001-0122 | CDC | Recently Posted CDC Rules and Notices. CDC_FRDOC_0001 | Control of Communicable Diseases; Foreign Quarantine: Suspension of the Right to Introduce and Prohibition of Introduction of Persons into United States from Designated Foreign Countries or Places for Public Health Purposes | Rule | 2020-09-11T04:00:00Z | 2020 | 9 | 2020-09-11T04:00:00Z | 2020-09-11T11:47:59Z | 2020-20036 | 0 | 0 | 0900006484851fcf | ||
| CDC_FRDOC_0001-0121 | CDC | Recently Posted CDC Rules and Notices. CDC_FRDOC_0001 | Control of Communicable Diseases: Importation of Human Remains | Rule | 2020-07-15T04:00:00Z | 2020 | 7 | 2020-07-15T04:00:00Z | 2020-08-15T03:59:59Z | 2020-07-15T11:56:50Z | 2020-12931 | 0 | 0 | 0900006484763917 | |
| CDC_FRDOC_0001-0118 | CDC | Recently Posted CDC Rules and Notices. CDC_FRDOC_0001 | Order Suspending Introduction of Persons from a Country Where a Communicable Disease Exists | Rule | 2020-03-24T04:00:00Z | 2020 | 3 | 2020-03-24T04:00:00Z | 2020-03-24T12:00:19Z | 2020-06241 | 0 | 0 | 09000064844635f1 | ||
| CDC_FRDOC_0001-0116 | CDC | Recently Posted CDC Rules and Notices. CDC_FRDOC_0001 | World Trade Center Health Program: Petition 025-Parkinson's Disease and Parkinsonism, Including Heavy Metal-Induced Parkinsonism; Finding of Insufficient Evidence | Proposed Rule | 2020-02-19T05:00:00Z | 2020 | 2 | 2020-02-19T05:00:00Z | 2020-02-19T12:48:10Z | 2020-02991 | 0 | 0 | 0900006484386901 | ||
| CDC_FRDOC_0001-0114 | CDC | Recently Posted CDC Rules and Notices. CDC_FRDOC_0001 | Control of Communicable Diseases; Foreign Quarantine | Rule | 2020-02-12T05:00:00Z | 2020 | 2 | 2020-02-12T05:00:00Z | 2020-03-14T03:59:59Z | 2020-03-14T01:01:30Z | 2020-02731 | 0 | 0 | 09000064843581e4 |
Advanced export
JSON shape: default, array, newline-delimited, object
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;