documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
30 rows where docket_id = "USCG-2011-0551" sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: title, subtype, posted_date, posted_month, comment_end_date, last_modified, posted_date (date), comment_start_date (date), comment_end_date (date), last_modified (date)
document_type 3
agency_id 1
- USCG 30
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| USCG-2011-0551-0109 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | Special Local Regulation and Safety Zone; America's Cup Sailing Events, San Francisco, CA | Supporting & Related Material | 2014-02-12T05:00:00Z | 2014 | 2 | 2017-03-10T22:43:23Z | 0 | 0 | 090000648154ec06 | ||||
| USCG-2011-0551-0108 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | TFR: Safety Zones: America's Cup Safety Zone and No Loitering Area, San Francisco, CA (Federal Register Publication) | Rule | Temporary Rule | 2013-07-05T04:00:00Z | 2013 | 7 | 2013-07-05T04:00:00Z | 2017-03-10T22:22:28Z | 2013-16164 | 0 | 0 | 090000648135833a | |
| USCG-2011-0551-0107 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | TIR: Special Local Regulations: Revision of 2013 America's Cup Regulated Area, San Francisco Bay; San Francisco, CA (Federal Register Publication) | Rule | Temporary Rule | 2013-07-02T04:00:00Z | 2013 | 7 | 2013-07-02T04:00:00Z | 2013-08-02T03:59:59Z | 2017-03-10T22:22:27Z | 2013-15809 | 0 | 0 | 0900006481351807 |
| USCG-2011-0551-0106 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | TFR: Special Local Regulations and Safety Zones: America's Cup Sailing Events, San Francisco, CA (Federal Register Publication) | Rule | Temporary Rule | 2013-06-03T04:00:00Z | 2013 | 6 | 2013-06-03T04:00:00Z | 2017-03-10T22:22:19Z | 2013-12998 | 0 | 0 | 09000064813071fe | |
| USCG-2011-0551-0105 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | Finding of No Significant Impact | Supporting & Related Material | 2012-12-28T05:00:00Z | 2012 | 12 | 2017-03-10T22:42:46Z | 0 | 0 | 090000648119cb0b | ||||
| USCG-2011-0551-0104 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | TFR: Special Local Regulations and Safety Zones: America's Cup Sailing Events, San Francisco, CA; Correction (Federal Register Publication) | Rule | Temporary Rule | 2012-12-10T05:00:00Z | 2012 | 12 | 2012-12-10T05:00:00Z | 2017-03-10T22:22:05Z | 2012-29751 | 0 | 0 | 0900006481184762 | |
| USCG-2011-0551-0102 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | Environmental Analysis (8/14/2012) | Supporting & Related Material | 2012-08-22T04:00:00Z | 2012 | 8 | 2012-08-22T14:25:27Z | 0 | 0 | 09000064810e7c44 | ||||
| USCG-2011-0551-0101 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | TFR: Special Local Regulations and Safety Zones: Americas Cup World Series Regattas, San Francisco Bay, San Francisco, CA (Federal Register Publication) | Rule | Temporary Rule | 2012-08-21T04:00:00Z | 2012 | 8 | 2012-08-21T04:00:00Z | 2017-03-10T22:21:56Z | 2012-20465 | 0 | 0 | 09000064810e6b3f | |
| USCG-2011-0551-0100 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | Special Local Regulations and Safety Zones: America's Cup Sailing Events, San Francisco, CA (Federal Register Publication) | Rule | Final Rule | 2012-08-03T04:00:00Z | 2012 | 8 | 2012-08-03T04:00:00Z | 2017-03-10T22:21:54Z | 2012-18840 | 0 | 0 | 09000064810c0967 | |
| USCG-2011-0551-0099 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | ACWS Program Calendar August 2012 | Supporting & Related Material | 2012-08-02T04:00:00Z | 2012 | 8 | 2012-08-02T13:27:15Z | 0 | 0 | 09000064810bca7a | ||||
| USCG-2011-0551-0098 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | Environmental Checklist (7/9/2012) | Supporting & Related Material | 2012-07-31T04:00:00Z | 2012 | 7 | 2012-07-31T13:08:52Z | 0 | 0 | 09000064810b2a0c | ||||
| USCG-2011-0551-0095 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | Environmental Assessment for the Establishment of the Special Local Regulation for the 34th America's Cup San Francisco Bay, California | Supporting & Related Material | 2012-07-18T04:00:00Z | 2012 | 7 | 2012-07-18T15:20:46Z | 0 | 0 | 090000648109eb66 | ||||
| USCG-2011-0551-0097 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | Finding of No Significant Impact for the Establishment of Special Local Regulation for the 34th America's Cup, San Francisco Bay, CA | Supporting & Related Material | 2012-07-18T04:00:00Z | 2012 | 7 | 2012-07-18T15:56:44Z | 0 | 0 | 090000648109eb6c | ||||
| USCG-2011-0551-0096 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | USCG Primary Regulated Areas - 34th American's Cup Races | Supporting & Related Material | 2012-07-18T04:00:00Z | 2012 | 7 | 2012-07-18T15:36:39Z | 0 | 0 | 090000648109eb68 | ||||
| USCG-2011-0551-0094 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | TFR: Safety Zones; Special Local Regulations: America's Cup Sailing Events, San Francisco, CA (Federal Register Publication) | Rule | Temporary Rule | 2012-07-17T04:00:00Z | 2012 | 7 | 2012-07-17T04:00:00Z | 2012-07-17T14:03:23Z | 2012-17305 | 0 | 0 | 090000648109d9c3 | |
| USCG-2011-0551-0043 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | PR: Special Local Safety Zones: America's Cup Sailing Events, San Francisco, CA; Environmental Assessment; Availability (Federal Register Publication) | Proposed Rule | Notice of Proposed Rulemaking (NPRM) | 2012-04-17T04:00:00Z | 2012 | 4 | 2012-04-17T04:00:00Z | 2012-05-01T03:59:59Z | 2017-03-10T22:26:11Z | 2012-09070 | 0 | 0 | 0900006480ff278b |
| USCG-2011-0551-0028 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | ACRM Memo 6 April 2012 | Supporting & Related Material | 2012-04-13T04:00:00Z | 2012 | 4 | 2017-03-10T22:42:40Z | 0 | 0 | 0900006480fee6c3 | ||||
| USCG-2011-0551-0029 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | Draft Environmental Assessment | Supporting & Related Material | 2012-04-13T04:00:00Z | 2012 | 4 | 2012-04-13T20:28:32Z | 0 | 0 | 0900006480fee6d5 | ||||
| USCG-2011-0551-0026 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | U.S. DHS/USCG - Supplemental Material: USCG Meeting Minutes-PICYA-24 March 2012 | Supporting & Related Material | 2012-03-28T04:00:00Z | 2012 | 3 | 2017-03-10T22:42:40Z | 0 | 0 | 0900006480fe1b84 | ||||
| USCG-2011-0551-0027 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | U.S. DHS/USCG - Supplemental Material:USCG Meeting Minutes-SPV-21March2012 | Supporting & Related Material | 2012-03-28T04:00:00Z | 2012 | 3 | 2017-03-10T22:42:40Z | 0 | 0 | 0900006480fe1b86 | ||||
| USCG-2011-0551-0023 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | U.S. DHS/CG - See Attachment | Supporting & Related Material | 2012-03-15T04:00:00Z | 2012 | 3 | 2012-03-15T16:40:15Z | 0 | 0 | 0900006480fd7d34 | ||||
| USCG-2011-0551-0024 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | U.S. DHS/CG - See Attachment | Supporting & Related Material | 2012-03-15T04:00:00Z | 2012 | 3 | 2012-03-15T16:40:15Z | 0 | 0 | 0900006480fd7d36 | ||||
| USCG-2011-0551-0025 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | U.S. DHS/CG - See Attachment | Supporting & Related Material | 2012-03-15T04:00:00Z | 2012 | 3 | 2012-03-15T16:40:15Z | 0 | 0 | 0900006480fd7e93 | ||||
| USCG-2011-0551-0022 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | U.S. DHS/CG - See Attachment | Supporting & Related Material | 2012-03-15T04:00:00Z | 2012 | 3 | 2012-03-15T16:40:15Z | 0 | 0 | 0900006480fd7d32 | ||||
| USCG-2011-0551-0016 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | USCG/DHS - See Attachment | Supporting & Related Material | 2012-03-06T05:00:00Z | 2012 | 3 | 2012-03-06T15:54:25Z | 0 | 0 | 0900006480fcfd33 | ||||
| USCG-2011-0551-0015 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | USCG/DHS - See Attachment | Supporting & Related Material | 2012-03-06T05:00:00Z | 2012 | 3 | 2012-03-06T15:34:10Z | 0 | 0 | 0900006480fcfd31 | ||||
| USCG-2011-0551-0004 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | October 2011 Outreach Minutes | Supporting & Related Material | 2012-02-06T05:00:00Z | 2012 | 2 | 2012-02-06T20:11:44Z | 0 | 0 | 0900006480faea36 | ||||
| USCG-2011-0551-0005 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | October 2011 Outreach Presentation | Supporting & Related Material | 2012-02-06T05:00:00Z | 2012 | 2 | 2012-02-06T19:17:49Z | 0 | 0 | 0900006480faea38 | ||||
| USCG-2011-0551-0003 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | AC34_NPRM_Regulated_Areas | Supporting & Related Material | 2012-02-02T05:00:00Z | 2012 | 2 | 2012-02-02T14:48:32Z | 0 | 0 | 0900006480fab8f7 | ||||
| USCG-2011-0551-0001 | USCG | Safety Zone: America's Cup Sailing Event USCG-2011-0551 | NPRM: Special Local Regulations and Safety Zones: America's Cup Sailing Events, San Francisco, CA (Federal Register Publication) | Proposed Rule | Notice of Proposed Rulemaking (NPRM) | 2012-01-30T05:00:00Z | 2012 | 1 | 2012-01-30T05:00:00Z | 2012-05-01T03:59:59Z | 2017-03-10T22:26:02Z | 2012-01907 | 0 | 0 | 0900006480fa8de2 |
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;