documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
11 rows where docket_id = "NOAA-2006-0073" sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: title, posted_month, last_modified, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| NOAA-2006-0073-0011 | NOAA | Fisheries of the Caribbean, Gulf of Mexico, and South Atlantic; Coastal Migratory Pelagic Resources of the Gulf of Mexico and South Atlantic; Trip Limit Increase NOAA-2006-0073 | Fisheries of the Caribbean, Gulf of Mexico, and South Atlantic; Coastal Migratory Pelagic Resources of the Gulf of Mexico and South Atlantic; Closure | Rule | 2007-04-11T04:00:00Z | 2007 | 4 | 2007-04-11T04:00:00Z | 2011-12-01T21:40:59Z | 07-01801 | 0 | 0 | 0900006480223fa8 | ||
| NOAA-2006-0073-0010 | NOAA | Fisheries of the Caribbean, Gulf of Mexico, and South Atlantic; Coastal Migratory Pelagic Resources of the Gulf of Mexico and South Atlantic; Trip Limit Increase NOAA-2006-0073 | Fisheries of the Caribbean, Gulf of Mexico, and South Atlantic; Coastal Migratory Pelagic Resources of the Gulf of Mexico and South Atlantic; Trip Limit Reduction | Rule | 2007-03-07T05:00:00Z | 2007 | 3 | 2007-03-07T05:00:00Z | 2011-12-01T21:40:55Z | 07-01015 | 0 | 0 | 090000648020e8c8 | ||
| NOAA-2006-0073-0009 | NOAA | Fisheries of the Caribbean, Gulf of Mexico, and South Atlantic; Coastal Migratory Pelagic Resources of the Gulf of Mexico and South Atlantic; Trip Limit Increase NOAA-2006-0073 | Fisheries of the Caribbean, Gulf of Mexico, and South Atlantic; Coastal Migratory Pelagic Resources of the Gulf of Mexico and South Atlantic; Trip Limit Reduction | Rule | 2007-02-06T05:00:00Z | 2007 | 2 | 2007-02-06T05:00:00Z | 2011-12-01T21:40:51Z | 07-00504 | 0 | 0 | 09000064801fb0a6 | ||
| NOAA-2006-0073-0008 | NOAA | Fisheries of the Caribbean, Gulf of Mexico, and South Atlantic; Coastal Migratory Pelagic Resources of the Gulf of Mexico and South Atlantic; Trip Limit Increase NOAA-2006-0073 | Fisheries of the Caribbean, Gulf of Mexico, and South Atlantic; Coastal Migratory Pelagic Resources of the Gulf of Mexico and South Atlantic; Closure | Rule | 2007-01-29T05:00:00Z | 2007 | 1 | 2007-01-29T05:00:00Z | 2011-12-01T21:40:50Z | 07-00351 | 0 | 0 | 09000064801f828e | ||
| NOAA-2006-0073-0007 | NOAA | Fisheries of the Caribbean, Gulf of Mexico, and South Atlantic; Coastal Migratory Pelagic Resources of the Gulf of Mexico and South Atlantic; Trip Limit Increase NOAA-2006-0073 | Fisheries of the Caribbean, Gulf of Mexico, and South Atlantic; Coastal Migratory Pelagic Resources of the Gulf of Mexico and South Atlantic; Trip Limit Increase | Rule | 2007-01-23T05:00:00Z | 2007 | 1 | 2007-01-23T05:00:00Z | 2011-12-01T21:40:50Z | E7-00945 | 0 | 0 | 09000064801f6685 | ||
| NOAA-2006-0073-0006 | NOAA | Fisheries of the Caribbean, Gulf of Mexico, and South Atlantic; Coastal Migratory Pelagic Resources of the Gulf of Mexico and South Atlantic; Trip Limit Increase NOAA-2006-0073 | Fisheries of the Caribbean, Gulf of Mexico, and South Atlantic; Coastal Migratory Pelagic Resources of the Gulf of Mexico and South Atlantic; Trip Limit Reduction | Rule | 2006-11-28T05:00:00Z | 2006 | 11 | 2006-11-28T05:00:00Z | 2011-12-01T21:40:44Z | 06-09439 | 0 | 0 | 09000064801e5fdf | ||
| NOAA-2006-0073-0005 | NOAA | Fisheries of the Caribbean, Gulf of Mexico, and South Atlantic; Coastal Migratory Pelagic Resources of the Gulf of Mexico and South Atlantic; Trip Limit Increase NOAA-2006-0073 | Fisheries of the Caribbean, Gulf of Mexico, and South Atlantic; Coastal Migratory Pelagic Resources of the Gulf of Mexico and South Atlantic; Closure | Rule | 2006-10-06T04:00:00Z | 2006 | 10 | 2006-10-06T04:00:00Z | 2011-12-01T21:40:39Z | 06-08535 | 0 | 0 | 09000064801d273a | ||
| NOAA-2006-0073-0004 | NOAA | Fisheries of the Caribbean, Gulf of Mexico, and South Atlantic; Coastal Migratory Pelagic Resources of the Gulf of Mexico and South Atlantic; Trip Limit Increase NOAA-2006-0073 | Fisheries of the Caribbean, Gulf of Mexico, and South Atlantic; Coastal Migratory Pelagic Resources of the Gulf of Mexico and South Atlantic; Closure | Rule | 2006-03-15T05:00:00Z | 2006 | 3 | 2006-03-15T05:00:00Z | 2011-12-01T21:40:16Z | 06-02504 | 0 | 0 | 0900006480145f4b | ||
| NOAA-2006-0073-0003 | NOAA | Fisheries of the Caribbean, Gulf of Mexico, and South Atlantic; Coastal Migratory Pelagic Resources of the Gulf of Mexico and South Atlantic; Trip Limit Increase NOAA-2006-0073 | Fisheries of the Caribbean, Gulf of Mexico, and South Atlantic; Coastal Migratory Pelagic Resources of the Gulf of Mexico and South Atlantic; Closure | Rule | 2006-03-09T05:00:00Z | 2006 | 3 | 2006-03-09T05:00:00Z | 2011-12-01T21:40:15Z | 06-02254 | 0 | 0 | 0900006480141f6f | ||
| NOAA-2006-0073-0002 | NOAA | Fisheries of the Caribbean, Gulf of Mexico, and South Atlantic; Coastal Migratory Pelagic Resources of the Gulf of Mexico and South Atlantic; Trip Limit Increase NOAA-2006-0073 | Fisheries of the Caribbean, Gulf of Mexico, and South Atlantic; Coastal Migratory Pelagic Resources of the Gulf of Mexico and South Atlantic; Trip Limit Reduction | Rule | 2006-02-28T05:00:00Z | 2006 | 2 | 2006-02-28T05:00:00Z | 2011-12-01T21:40:14Z | 06-01859 | 0 | 0 | 090000648013ac4e | ||
| NOAA-2006-0073-0001 | NOAA | Fisheries of the Caribbean, Gulf of Mexico, and South Atlantic; Coastal Migratory Pelagic Resources of the Gulf of Mexico and South Atlantic; Trip Limit Increase NOAA-2006-0073 | Fisheries of the Caribbean, Gulf of Mexico, and South Atlantic; Coastal Migratory Pelagic Resources of the Gulf of Mexico and South Atlantic; Trip Limit Increase | Rule | 2006-01-31T05:00:00Z | 2006 | 1 | 2006-01-31T05:00:00Z | 2011-12-01T21:40:11Z | 06-00886 | 0 | 0 | 090000648012210c |
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;