documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
9 rows where docket_id = "CDC_FRDOC_0001" and posted_year = 2012 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-0033 | CDC | Recently Posted CDC Rules and Notices. CDC_FRDOC_0001 | Possession, Use, and Transfer of Select Agents and Toxins: Biennial Review; Technical Correction | Rule | 2012-12-04T05:00:00Z | 2012 | 12 | 2012-12-04T05:00:00Z | 2012-12-04T15:54:00Z | 2012-28784 | 0 | 0 | 090000648117e4e9 | ||
| CDC_FRDOC_0001-0032 | CDC | Recently Posted CDC Rules and Notices. CDC_FRDOC_0001 | Influenza Viruses Containing Hemagglutinin from Goose/Guangdong/1/96 Lineage | Proposed Rule | 2012-10-17T04:00:00Z | 2012 | 10 | 2012-10-17T04:00:00Z | 2012-12-18T04:59:59Z | 2012-12-18T03:01:41Z | 2012-25377 | 0 | 0 | 09000064811448d4 | |
| CDC_FRDOC_0001-0031 | CDC | Recently Posted CDC Rules and Notices. CDC_FRDOC_0001 | World Trade Center Health Program: Addition of Certain Types of Cancer to the List of WTC-Related Health Conditions | Rule | 2012-10-12T04:00:00Z | 2012 | 10 | 2012-10-12T04:00:00Z | 2012-10-12T12:37:10Z | 2012-25142 | 0 | 0 | 090000648113e3b5 | ||
| CDC_FRDOC_0001-0028 | CDC | Recently Posted CDC Rules and Notices. CDC_FRDOC_0001 | World Trade Center Health Program: Addition of Certain Types of Cancer to List of WTC-Related Health Conditions | Rule | 2012-09-12T04:00:00Z | 2012 | 9 | 2012-09-12T04:00:00Z | 2012-09-12T14:10:51Z | 2012-22304 | 0 | 0 | 09000064811132d9 | ||
| CDC_FRDOC_0001-0027 | CDC | Recently Posted CDC Rules and Notices. CDC_FRDOC_0001 | Open-Circuit Self-Contained Breathing Apparatus Remaining Service-Life Indicator Performance Requirements | Proposed Rule | 2012-06-25T04:00:00Z | 2012 | 6 | 2012-06-25T04:00:00Z | 2012-08-25T03:59:59Z | 2012-08-25T02:04:00Z | 2012-14764 | 0 | 0 | 09000064810639c4 | |
| CDC_FRDOC_0001-0026 | CDC | Recently Posted CDC Rules and Notices. CDC_FRDOC_0001 | Establishment of User Fees for Filovirus Testing of Nonhuman Primate Liver Samples | Rule | 2012-06-15T04:00:00Z | 2012 | 6 | 2012-06-15T04:00:00Z | 2012-06-15T13:19:15Z | 2012-14603 | 0 | 0 | 090000648104c33c | ||
| CDC_FRDOC_0001-0024 | CDC | Recently Posted CDC Rules and Notices. CDC_FRDOC_0001 | World Trade Center Health Program Requirements: Addition of New WTC-Related Health Conditions | Rule | 2012-04-25T04:00:00Z | 2012 | 4 | 2012-04-25T04:00:00Z | 2012-04-25T12:32:23Z | 2012-09425 | 0 | 0 | 0900006480ffaf9d | ||
| CDC_FRDOC_0001-0023 | CDC | Recently Posted CDC Rules and Notices. CDC_FRDOC_0001 | Approval Tests and Standards for Closed-Circuit Escape Respirators | Rule | 2012-03-08T05:00:00Z | 2012 | 3 | 2012-03-08T05:00:00Z | 2012-03-08T13:26:33Z | 2012-04691 | 0 | 0 | 0900006480fd1bee | ||
| CDC_FRDOC_0001-0019 | CDC | Recently Posted CDC Rules and Notices. CDC_FRDOC_0001 | Specifications for Medical Examinations of Underground Coal Miners | Proposed Rule | 2012-01-09T05:00:00Z | 2012 | 1 | 2012-01-09T05:00:00Z | 2012-03-10T04:59:59Z | 2012-01-09T12:50:22Z | 2011-33164 | 0 | 0 | 0900006480f90477 |
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;