documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
5 rows where docket_id = "FDA-2005-D-0445" and posted_year = 2007 sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: subtype, posted_date, posted_month, posted_date (date), comment_start_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FDA-2005-D-0445-0007 | FDA | Class II Special Controls: Automated Blood Cell Separator Device Operating by Centrifugal or Filtration Separation Principle, re FDA-2012-N-0115 FDA-2005-D-0445 | Guidance for Industry and Food and Drug Administration Staff: Class II Special Controls Guidance Document: Automated Blood Cell Separator Device Operating by Centrifugal or Filtration Separation Principle; Availability | Notice | Notice of Availability | 2007-11-30T05:00:00Z | 2007 | 11 | 2007-11-30T05:00:00Z | 2015-01-20T23:53:18Z | 0 | 0 | 09000064804505f1 | ||
| FDA-2005-D-0445-0008 | FDA | Class II Special Controls: Automated Blood Cell Separator Device Operating by Centrifugal or Filtration Separation Principle, re FDA-2012-N-0115 FDA-2005-D-0445 | Guidance for Industry and Food and Drug Administration Staff: Class II Special Controls Guidance Document: Automated Blood Cell Separator Device Operating by Centrifugal or Filtration Separation Principle; Final Guidance Document | Other | Guidance | 2007-11-30T05:00:00Z | 2007 | 11 | 2015-01-21T00:13:53Z | 0 | 0 | 09000064804505f2 | |||
| FDA-2005-D-0445-0006 | FDA | Class II Special Controls: Automated Blood Cell Separator Device Operating by Centrifugal or Filtration Separation Principle, re FDA-2012-N-0115 FDA-2005-D-0445 | Agency Information Collection Activities ; Announcement of Office of Management and Budget Approval; Guidance for Industry and Food and Drug Administration Staff on Class II Special Controls Guidance Document: Automated Blood Cell Separator Device Operating by Centrifugal or Filtration Separation Principle | Notice | Notice of Approval | 2007-01-22T05:00:00Z | 2007 | 1 | 2007-01-19T05:00:00Z | 2015-01-20T23:28:44Z | 0 | 0 | 09000064804505f0 | ||
| FDA-2005-D-0445-0004 | FDA | Class II Special Controls: Automated Blood Cell Separator Device Operating by Centrifugal or Filtration Separation Principle, re FDA-2012-N-0115 FDA-2005-D-0445 | Supporting Statement for Draft Guidance for Industry and Food and Drug Administration Staff - Class II Special Controls Guidance Document: Automated Blood Cell Separator Device Operating by Centrifugal or Filtration Separation Principle | Supporting & Related Material | SS-Supporting Statement | 2007-01-22T05:00:00Z | 2007 | 1 | 2015-01-21T00:18:50Z | 0 | 0 | 09000064804505ee | |||
| FDA-2005-D-0445-0005 | FDA | Class II Special Controls: Automated Blood Cell Separator Device Operating by Centrifugal or Filtration Separation Principle, re FDA-2012-N-0115 FDA-2005-D-0445 | Supporting Statement for Draft Guidance for Industry and Food and Drug Administration Staff Class II Special Controls Guidance Document Automated Blood Cell Separator Device Operating by Centrifugal or Filtration Separation Principle re FDA 2005 D 0445 0006 | Supporting & Related Material | SS-Supporting Statement | 2007-01-22T05:00:00Z | 2007 | 1 | 2015-01-21T00:18:24Z | 0 | 0 | 09000064804505ef |
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);