documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
522 rows where agency_id = "USCG", document_type = "Rule" and posted_year = 2017 sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: subtype, posted_month, comment_end_date, withdrawn, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| USCG-2017-1077-0001 | USCG | None USCG-2017-1077 | Safety Zone; Mississippi River, Baton Rouge, LA | Rule | Temporary Rule | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2017-12-29T13:56:38Z | 2017-28145 | 0 | 0 | 0900006482d8330c | |
| USCG-2017-1031-0002 | USCG | None USCG-2017-1031 | Drawbridge Operation Regulation; Passaic River, Newark, NJ | Rule | Temporary Rule | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T14:51:43Z | 2017-28008 | 0 | 0 | 0900006482d7acb3 | ||
| USCG-2017-0161-0007 | USCG | None USCG-2017-0161 | Drawbridge Operation Regulation; Canaveral Barge Canal, Canaveral, FL | Rule | Temporary Rule | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T14:44:04Z | 2017-27969 | 0 | 0 | 0900006482d7acb2 | ||
| USCG-2017-1109-0001 | USCG | None USCG-2017-1109 | Drawbridge Operation Regulation; Columbia River, Vancouver, WA | Rule | Temporary Rule | 2017-12-27T05:00:00Z | 2017 | 12 | 2017-12-27T14:46:28Z | 2017-27923 | 0 | 0 | 0900006482d76346 | ||
| USCG-2017-0967-0002 | USCG | None USCG-2017-0967 | Drawbridge Operation Regulation; Atlantic Intracoastal Waterway, Alligator River, Columbia, NC | Rule | Temporary Rule | 2017-12-26T05:00:00Z | 2017 | 12 | 2017-12-26T14:35:27Z | 2017-27718 | 0 | 0 | 0900006482d726d7 | ||
| USCG-2017-1048-0001 | USCG | None USCG-2017-1048 | Drawbridge Operations: Merrimack River, Newburyport, MA | Rule | Temporary Rule | 2017-12-22T05:00:00Z | 2017 | 12 | 2017-12-22T15:52:00Z | 2017-27642 | 0 | 0 | 0900006482d56b16 | ||
| USCG-2017-1071-0001 | USCG | None USCG-2017-1071 | Safety Zone; Captain of the Port Boston Fireworks Display Zone, Boston Harbor, Boston, MA | Rule | Temporary Rule | 2017-12-22T05:00:00Z | 2017 | 12 | 2017-12-26T14:42:22Z | 2017-27582 | 0 | 0 | 0900006482d56ac7 | ||
| USCG-2017-1007-0001 | USCG | None USCG-2017-1007 | 2016 Quarterly Listings; Safety Zones, Security Zones, Special Local Regulations, Drawbridge Operation Regulations and Regulated Navigation Areas | Rule | Temporary Rule | 2017-12-20T05:00:00Z | 2017 | 12 | 2017-12-20T15:39:59Z | 2017-27404 | 0 | 0 | 0900006482d3f36a | ||
| USCG-2017-0311-0003 | USCG | None USCG-2017-0311 | Drawbridge Operation Regulation; Quantuck Canal, Westhampton Beach, NY | Rule | Temporary Rule | 2017-12-20T05:00:00Z | 2017 | 12 | 2017-12-20T15:39:15Z | 2017-27403 | 0 | 0 | 0900006482d3e4e5 | ||
| USCG-2017-0694-0001 | USCG | None USCG-2017-0694 | 2016 Quarterly Listings; Safety Zones, Security Zones, Special Local Regulations, Drawbridge Operation Regulations and Regulated Navigation Areas | Rule | Temporary Rule | 2017-12-20T05:00:00Z | 2017 | 12 | 2017-12-20T15:39:40Z | 2017-27409 | 0 | 0 | 0900006482d3f3cf | ||
| USCG-2017-1074-0001 | USCG | None USCG-2017-1074 | Drawbridge Operation Regulation; San Leandro Bay, Between Alameda and Bay Farm Island, CA | Rule | Temporary Rule | 2017-12-20T05:00:00Z | 2017 | 12 | 2017-12-20T15:40:32Z | 2017-27386 | 0 | 0 | 0900006482d3f4bf | ||
| USCG-2017-1027-0001 | USCG | None USCG-2017-1027 | Drawbridge Operation Regulation; Sacramento River, Sacramento, CA | Rule | Temporary Rule | 2017-12-20T05:00:00Z | 2017 | 12 | 2017-12-20T14:44:53Z | 2017-27323 | 0 | 0 | 0900006482d3f40d | ||
| USCG-2017-0994-0003 | USCG | None USCG-2017-0994 | Safety Zone; Spa Creek, Annapolis, MD | Rule | Temporary Rule | 2017-12-20T05:00:00Z | 2017 | 12 | 2017-12-20T14:58:08Z | 2017-27381 | 0 | 0 | 0900006482d3f368 | ||
| USCG-2017-1026-0001 | USCG | None USCG-2017-1026 | Drawbridge Operation Regulation; Newark Bay, Newark, NJ | Rule | Temporary Rule | 2017-12-19T05:00:00Z | 2017 | 12 | 2017-12-19T05:00:00Z | 2018-04-01T03:59:59Z | 2018-03-25T01:01:01Z | 2017-27298 | 0 | 0 | 0900006482d3aebf |
| USCG-2016-0776-0002 | USCG | None USCG-2016-0776 | Drawbridge Operation Regulation; Ashley River, Charleston, SC | Rule | Final Rule | 2017-12-15T05:00:00Z | 2017 | 12 | 2017-12-15T05:00:00Z | 2017-12-15T14:37:02Z | 2017-26998 | 0 | 0 | 0900006482d1290d | |
| USCG-2017-0916-0001 | USCG | None USCG-2017-0916 | Special Local Regulation; Southern California Annual Marine Events for the San Diego Captain of the Port Zone—San Diego Parade of Lights | Rule | Temporary Rule | 2017-12-15T05:00:00Z | 2017 | 12 | 2017-12-15T05:00:00Z | 2017-12-15T14:20:26Z | 2017-27111 | 0 | 0 | 0900006482d128b6 | |
| USCG-2016-0531-0003 | USCG | None USCG-2016-0531 | Vessel Documentation Regulations- Technical Amendments | Rule | Correction | 2017-12-14T05:00:00Z | 2017 | 12 | 2017-12-14T15:53:50Z | C1-2017-20023 | 0 | 0 | 0900006482d08f29 | ||
| USCG-2017-1053-0003 | USCG | None USCG-2017-1053 | Safety Zone; Delaware River, Pipeline Removal, Marcus Hook, PA | Rule | Notice of Interim Rule | 2017-12-14T05:00:00Z | 2017 | 12 | 2017-12-14T05:00:00Z | 2018-01-17T04:59:59Z | 2018-01-17T02:04:40Z | 2017-26935 | 0 | 0 | 0900006482d08e76 |
| USCG-2017-1075-0001 | USCG | None USCG-2017-1075 | Drawbridge Operation Regulation; Carquinez Strait, at Martinez, CA | Rule | Temporary Rule | 2017-12-13T05:00:00Z | 2017 | 12 | 2017-12-13T15:37:51Z | 2017-26768 | 0 | 0 | 0900006482d01f0a | ||
| USCG-2017-0986-0001 | USCG | None USCG-2017-0986 | Safety Zone; Lower Mississippi River, New Orleans, LA | Rule | Temporary Rule | 2017-12-11T05:00:00Z | 2017 | 12 | 2017-12-11T16:25:51Z | 2017-26561 | 0 | 0 | 0900006482cf743b | ||
| USCG-2017-1072-0001 | USCG | None USCG-2017-1072 | Drawbridge Operation Regulation; Columbia River, Vancouver, WA | Rule | Temporary Rule | 2017-12-11T05:00:00Z | 2017 | 12 | 2017-12-11T16:18:17Z | 2017-26573 | 0 | 0 | 0900006482cf72b6 | ||
| USCG-2017-1067-0001 | USCG | None USCG-2017-1067 | Safety Zone; Sector Key West COTP Zone Post Storm Recovery, Atlantic Ocean, FL | Rule | Notice of Interim Rule | 2017-12-08T05:00:00Z | 2017 | 12 | 2017-12-08T05:00:00Z | 2018-01-09T04:59:59Z | 2017-12-17T14:00:18Z | 2017-26462 | 0 | 0 | 0900006482cf2a31 |
| USCG-2017-1069-0001 | USCG | None USCG-2017-1069 | Drawbridge Operation Regulation; Middle River, Between Bacon Island and Lower Jones Tract, CA | Rule | Temporary Rule | 2017-12-08T05:00:00Z | 2017 | 12 | 2017-12-08T15:56:32Z | 2017-26463 | 0 | 0 | 0900006482cf2a7f | ||
| USCG-2017-1064-0001 | USCG | None USCG-2017-1064 | Safety Zones: Ohio River, Ironton, OH | Rule | Temporary Rule | 2017-12-08T05:00:00Z | 2017 | 12 | 2017-12-08T15:47:29Z | 2017-26476 | 0 | 0 | 0900006482cf28de | ||
| USCG-2017-0595-0003 | USCG | None USCG-2017-0595 | Drawbridge Operation Regulation; Jamaica Bay, Queens, NY | Rule | Temporary Rule | 2017-12-07T05:00:00Z | 2017 | 12 | 2017-12-07T05:00:00Z | 2018-02-06T04:59:59Z | 2017-12-07T16:13:42Z | 2017-26431 | 0 | 0 | 0900006482ced68f |
| USCG-2017-1038-0001 | USCG | None USCG-2017-1038 | Drawbridge Operation Regulation; Rigolets Pass, Slidell, LA | Rule | Temporary Rule | 2017-12-05T05:00:00Z | 2017 | 12 | 2017-12-05T15:17:59Z | 2017-26094 | 0 | 0 | 0900006482cdbfad | ||
| USCG-2017-0982-0003 | USCG | None USCG-2017-0982 | Safety Zones: Mamala Bay, Oahu, HI | Rule | Temporary Rule | 2017-12-05T05:00:00Z | 2017 | 12 | 2017-12-05T15:03:22Z | 2017-26142 | 0 | 0 | 0900006482cdb5ed | ||
| USCG-2017-0995-0001 | USCG | None USCG-2017-0995 | Drawbridge Operation Regulation; Atlantic Intracoastal Waterway, Albemarle and Chesapeake Canal, Chesapeake, VA | Rule | Temporary Rule | 2017-12-01T05:00:00Z | 2017 | 12 | 2017-12-01T15:43:07Z | 2017-26072 | 0 | 0 | 0900006482cc9c3e | ||
| USCG-2017-0977-0001 | USCG | None USCG-2017-0977 | Safety Zone, Savannah River, Savannah, GA | Rule | Temporary Rule | 2017-11-29T05:00:00Z | 2017 | 11 | 2017-11-29T14:32:29Z | 2017-25751 | 0 | 0 | 0900006482cbbad0 | ||
| USCG-2017-0935-0004 | USCG | None USCG-2017-0935 | Safety Zone; Delaware River, Marcus Hook, PA | Rule | Temporary Rule | 2017-11-29T05:00:00Z | 2017 | 11 | 2017-11-29T14:37:50Z | 2017-25749 | 0 | 0 | 0900006482cbbd2b | ||
| USCG-2017-1053-0001 | USCG | None USCG-2017-1053 | Safety Zone; Delaware River, Pipeline Removal, Marcus Hook, PA | Rule | Temporary Rule | 2017-11-28T05:00:00Z | 2017 | 11 | 2017-11-28T14:48:34Z | 2017-25613 | 0 | 0 | 0900006482cb67b2 | ||
| USCG-2017-0595-0002 | USCG | None USCG-2017-0595 | Drawbridge Operation Regulation; Jamaica Bay, Queens, NY | Rule | Withdrawal | 2017-11-27T05:00:00Z | 2017 | 11 | 2017-12-05T16:19:10Z | 2017-25532 | 0 | 0 | 0900006482cae39a | ||
| USCG-2017-0944-0001 | USCG | None USCG-2017-0944 | Special Local Regulations; Charleston Harbor Christmas Parade of Boats, Charleston, SC | Rule | Temporary Rule | 2017-11-27T05:00:00Z | 2017 | 11 | 2017-11-27T05:00:00Z | 2017-11-27T14:17:31Z | 2017-25533 | 0 | 0 | 0900006482cae425 | |
| USCG-2017-0573-0002 | USCG | None USCG-2017-0573 | Drawbridge Operation Regulation; Southern Branch of the Elizabeth River, Chesapeake, VA | Rule | Temporary Rule | 2017-11-22T05:00:00Z | 2017 | 11 | 2017-11-22T16:20:58Z | 2017-25250 | 0 | 0 | 0900006482c9eaff | ||
| USCG-2016-0561-0002 | USCG | None USCG-2016-0561 | Drawbridge Operation Regulation; Upper Mississippi River, IA | Rule | Final Rule | 2017-11-21T05:00:00Z | 2017 | 11 | 2017-11-21T16:00:34Z | 2017-25197 | 0 | 0 | 0900006482c98418 | ||
| USCG-2017-1031-0001 | USCG | None USCG-2017-1031 | rawbridge Operation Regulation; Passaic River, Newark, NJ | Rule | Temporary Rule | 2017-11-21T05:00:00Z | 2017 | 11 | 2017-11-21T15:54:20Z | 2017-25157 | 0 | 0 | 0900006482c983d2 | ||
| USCG-2017-0598-0002 | USCG | None USCG-2017-0598 | Special Local Regulation; Gulf of Mexico; Englewood, FL | Rule | Final Rule | 2017-11-21T05:00:00Z | 2017 | 11 | 2017-11-21T14:41:37Z | 2017-25182 | 0 | 0 | 0900006482c9895b | ||
| USCG-2017-1028-0002 | USCG | None USCG-2017-1028 | Safety Zone; Atlantic Ocean, Rehoboth Beach, DE | Rule | Correction | 2017-11-16T05:00:00Z | 2017 | 11 | 2017-11-16T20:57:22Z | 2017-24805 | 0 | 0 | 0900006482c83726 | ||
| USCG-2015-0427-0001 | USCG | None USCG-2015-0427 | Special Local Regulation; Mavericks Surf Competition, Half Moon Bay, CA | Rule | Final Rule | 2017-11-16T05:00:00Z | 2017 | 11 | 2017-11-16T20:44:49Z | 2017-24840 | 0 | 0 | 0900006482c83771 | ||
| USCG-2017-0985-0001 | USCG | None USCG-2017-0985 | Safety Zone; Annual Fireworks Display on the Ohio River, Monongahela River, Allegheny River, Pittsburgh, PA | Rule | Temporary Rule | 2017-11-16T05:00:00Z | 2017 | 11 | 2017-11-16T20:54:49Z | 2017-24820 | 0 | 0 | 0900006482c83632 | ||
| USCG-2017-0042-0001 | USCG | None USCG-2017-0042 | Safety Zones; Humboldt Bay Bar, Eureka, CA, Noyo River Entrance, Ft. Bragg, CA, and Crescent City Harbor Entrance Channel, Crescent City, CA | Rule | Temporary Rule | 2017-11-16T05:00:00Z | 2017 | 11 | 2017-11-16T05:00:00Z | 2018-01-16T04:59:59Z | 2017-12-10T02:00:41Z | 2017-24842 | 0 | 0 | 0900006482c836c9 |
| USCG-2017-0758-0001 | USCG | None USCG-2017-0758 | Drawbridge Operation Regulation; Delaware River, Tacony, PA, and Palmyra, NJ | Rule | Temporary Rule | 2017-11-13T05:00:00Z | 2017 | 11 | 2017-11-13T15:16:03Z | 2017-24468 | 0 | 0 | 0900006482c6a36a | ||
| USCG-2017-0990-0001 | USCG | None USCG-2017-0990 | Safety Zone; City of Oswego Fireworks Display; Oswego River, Oswego, NY | Rule | Temporary Rule | 2017-11-13T05:00:00Z | 2017 | 11 | 2017-11-13T15:10:08Z | 2017-24498 | 0 | 0 | 0900006482c6a2d9 | ||
| USCG-2017-1011-0002 | USCG | None USCG-2017-1011 | Safety Zone, Delaware River; Pipeline Removal | Rule | Correction | 2017-11-13T05:00:00Z | 2017 | 11 | 2017-11-13T15:14:04Z | 2017-24508 | 0 | 0 | 0900006482c6a333 | ||
| USCG-2017-0983-0001 | USCG | None USCG-2017-0983 | Drawbridge Operation Regulation; Hutchinson River, Mount Vernon, NY | Rule | Temporary Rule | 2017-11-09T05:00:00Z | 2017 | 11 | 2017-11-09T16:56:19Z | 2017-24378 | 0 | 0 | 0900006482c60710 | ||
| USCG-2017-1034-0001 | USCG | None USCG-2017-1034 | Safety Zone; Port of Ponce Turning Basin, Bah de Ponce, Ponce, PR | Rule | Temporary Rule | 2017-11-09T05:00:00Z | 2017 | 11 | 2017-11-09T17:04:53Z | 2017-24375 | 0 | 0 | 0900006482c60654 | ||
| USCG-2017-1028-0001 | USCG | None USCG-2017-1028 | Safety Zone; Atlantic Ocean, Rehoboth Beach, DE | Rule | Temporary Rule | 2017-11-09T05:00:00Z | 2017 | 11 | 2017-11-09T16:52:32Z | 2017-24377 | 0 | 0 | 0900006482c6070d | ||
| USCG-2017-0991-0001 | USCG | None USCG-2017-0991 | Drawbridge Operation Regulation; Hackensack River, Jersey City, NJ | Rule | Temporary Rule | 2017-11-09T05:00:00Z | 2017 | 11 | 2017-11-09T15:53:03Z | 2017-24376 | 0 | 0 | 0900006482c606d7 | ||
| USCG-2017-0976-0001 | USCG | None USCG-2017-0976 | Drawbridge Operation Regulation; Lake Washington, Seattle, WA | Rule | Final Rule | 2017-11-08T05:00:00Z | 2017 | 11 | 2017-11-08T16:05:07Z | 2017-24292 | 0 | 0 | 0900006482c5816e | ||
| USCG-2017-0982-0002 | USCG | None USCG-2017-0982 | Safety Zone; Mamala Bay, Oahu, HI | Rule | Temporary Rule | 2017-11-08T05:00:00Z | 2017 | 11 | 2017-11-08T16:10:43Z | 2017-24290 | 0 | 0 | 0900006482c58368 | ||
| USCG-2017-0972-0001 | USCG | None USCG-2017-0972 | Special Local Regulations; Key West World Championship, Atlantic Ocean, Key West, FL | Rule | Temporary Rule | 2017-11-08T05:00:00Z | 2017 | 11 | 2017-11-08T16:12:08Z | 2017-24291 | 0 | 0 | 0900006482c582d0 | ||
| USCG-2017-1011-0001 | USCG | None USCG-2017-1011 | Safety Zone, Delaware River; Pipeline Removal | Rule | Temporary Rule | 2017-11-06T05:00:00Z | 2017 | 11 | 2017-11-06T15:28:16Z | 2017-24068 | 0 | 0 | 0900006482c482c1 | ||
| USCG-2017-0979-0001 | USCG | None USCG-2017-0979 | Drawbridge Operation Regulation; Kent Island Narrows, Grasonville, MD | Rule | Temporary Rule | 2017-11-03T04:00:00Z | 2017 | 11 | 2017-11-03T14:03:00Z | 2017-24028 | 0 | 0 | 0900006482c3daf1 | ||
| USCG-2017-0967-0001 | USCG | None USCG-2017-0967 | Drawbridge Operation Regulation; Atlantic Intracoastal Waterway, Alligator River, Columbia, NC | Rule | Temporary Rule | 2017-11-01T04:00:00Z | 2017 | 11 | 2017-11-01T15:26:05Z | 2017-23745 | 0 | 0 | 0900006482c2e800 | ||
| USCG-2017-0552-0007 | USCG | None USCG-2017-0552 | Special Local Regulation; Atlantic Ocean, Ft. Lauderdale, FL | Rule | Final Rule | 2017-11-01T04:00:00Z | 2017 | 11 | 2017-11-01T15:18:25Z | 2017-23708 | 0 | 0 | 0900006482c2e726 | ||
| USCG-2017-0932-0001 | USCG | None USCG-2017-0932 | Safety Zone; Illinois River, Beardstown, IL | Rule | Temporary Rule | 2017-11-01T04:00:00Z | 2017 | 11 | 2017-11-01T15:21:44Z | 2017-23820 | 0 | 0 | 0900006482c2e7aa | ||
| USCG-2017-1012-0001 | USCG | None USCG-2017-1012 | Drawbridge Operation Regulation; China Basin, San Francisco, CA | Rule | Temporary Rule | 2017-10-31T04:00:00Z | 2017 | 10 | 2017-10-31T14:29:18Z | 2017-23608 | 0 | 0 | 0900006482c285e2 | ||
| USCG-2017-0891-0001 | USCG | None USCG-2017-0891 | Safety Zone; Monongahela River, Monongahela, PA | Rule | Temporary Rule | 2017-10-31T04:00:00Z | 2017 | 10 | 2017-10-31T14:44:52Z | 2017-23652 | 0 | 0 | 0900006482c2875b | ||
| USCG-2017-0973-0001 | USCG | None USCG-2017-0973 | Safety Zone, Savannah River, Savannah, GA | Rule | Temporary Rule | 2017-10-31T04:00:00Z | 2017 | 10 | 2017-10-31T14:31:20Z | 2017-23616 | 0 | 0 | 0900006482c285e7 | ||
| USCG-2017-0162-0002 | USCG | None USCG-2017-0162 | Drawbridge Operation Regulation; Nanticoke River, Seaford, DE | Rule | Final Rule | 2017-10-30T04:00:00Z | 2017 | 10 | 2017-10-30T13:28:31Z | 2017-23559 | 0 | 0 | 0900006482c21eab | ||
| USCG-2016-1012-0006 | USCG | None USCG-2016-1012 | Recreational Boat Flotation Standards- Update of Outboard Engine Weight Test Requirements | Rule | Final Rule | 2017-10-27T04:00:00Z | 2017 | 10 | 2017-10-27T14:38:18Z | 2017-23384 | 0 | 0 | 0900006482c104a7 | ||
| USCG-2017-0936-0001 | USCG | None USCG-2017-0936 | Drawbridge Operation Regulation; Snake Creek; Islamorada, FL | Rule | Temporary Rule | 2017-10-26T04:00:00Z | 2017 | 10 | 2017-10-26T14:55:01Z | 2017-23320 | 0 | 0 | 0900006482c0a247 | ||
| USCG-2017-0778-0002 | USCG | None USCG-2017-0778 | Drawbridge Operation Regulation; Atlantic Intracoastal Waterway, Indian River, Titusville, FL | Rule | Temporary Rule | 2017-10-26T04:00:00Z | 2017 | 10 | 2017-10-30T12:52:17Z | 2017-23322 | 0 | 0 | 0900006482c0a30e | ||
| USCG-2017-0048-0002 | USCG | None USCG-2017-0048 | Drawbridge Operation Regulation; Reynolds Channel, Lawrence, NY | Rule | Temporary Rule | 2017-10-24T04:00:00Z | 2017 | 10 | 2017-10-30T14:20:41Z | 2017-23053 | 0 | 0 | 0900006482bfd466 | ||
| USCG-2017-0982-0001 | USCG | None USCG-2017-0982 | Safety Zones: Mamala Bay, Oahu, HI | Rule | Temporary Rule | 2017-10-24T04:00:00Z | 2017 | 10 | 2017-10-30T14:29:24Z | 2017-22992 | 0 | 0 | 0900006482bfd3dd | ||
| USCG-2017-0890-0001 | USCG | None USCG-2017-0890 | Regulated Navigation Area; Beals Island Bridge Replacement, Moosabec Reach, Jonesport, ME | Rule | Final Rule with Request for Comments | 2017-10-24T04:00:00Z | 2017 | 10 | 2017-10-24T04:00:00Z | 2018-01-23T04:59:59Z | 2017-10-30T13:06:52Z | 2017-23049 | 0 | 0 | 0900006482bfda16 |
| USCG-2017-0923-0001 | USCG | None USCG-2017-0923 | Safety Zone; Light the Night Leukemia and Lymphoma Society Fireworks, Maumee River, Toledo, OH | Rule | Temporary Rule | 2017-10-23T04:00:00Z | 2017 | 10 | 2017-10-30T14:28:16Z | 2017-22948 | 0 | 0 | 0900006482bf730f | ||
| USCG-2017-0858-0001 | USCG | None USCG-2017-0858 | Special Local Regulations: Clinch River, Oak Ridge, TN | Rule | Temporary Rule | 2017-10-18T04:00:00Z | 2017 | 10 | 2017-10-18T14:45:58Z | 2017-22595 | 0 | 0 | 0900006482bddd71 | ||
| USCG-2017-0913-0001 | USCG | None USCG-2017-0913 | Safety Zones: Ohio River, Cincinnati, OH | Rule | Temporary Rule | 2017-10-18T04:00:00Z | 2017 | 10 | 2017-10-18T14:48:30Z | 2017-22594 | 0 | 0 | 0900006482bdde7e | ||
| USCG-2016-0257-0017 | USCG | None USCG-2016-0257 | Drawbridge Operation Regulation; Delaware River, Pennsauken Township, NJ | Rule | Temporary Rule | 2017-10-18T04:00:00Z | 2017 | 10 | 2017-10-18T04:00:00Z | 2018-01-16T04:59:59Z | 2018-01-12T02:03:46Z | 2017-22639 | 0 | 0 | 0900006482bdd8d4 |
| USCG-2017-0817-0001 | USCG | None USCG-2017-0817 | Safety Zone; Cumberland River, Nashville, TN | Rule | Temporary Rule | 2017-10-18T04:00:00Z | 2017 | 10 | 2017-10-18T14:36:08Z | 2017-22592 | 0 | 0 | 0900006482bdd7e6 | ||
| USCG-2017-0966-0001 | USCG | None USCG-2017-0966 | Drawbridge Operation Regulation; Cerritos Channel, Long Beach, CA | Rule | Temporary Rule | 2017-10-16T04:00:00Z | 2017 | 10 | 2017-10-16T14:29:49Z | 2017-22293 | 0 | 0 | 0900006482bcdf6d | ||
| USCG-2016-0437-0064 | USCG | None USCG-2016-0437 | Update to Alternative Planning Criteria National Guidelines | Rule | Temporary Rule | 2017-10-16T04:00:00Z | 2017 | 10 | 2017-10-16T14:24:41Z | 2017-22333 | 0 | 0 | 0900006482bcde59 | ||
| USCG-2017-0959-0001 | USCG | None USCG-2017-0959 | Drawbridge Operation Regulation; Grand Lake, Calcasieu Parish, Louisiana | Rule | Temporary Rule | 2017-10-16T04:00:00Z | 2017 | 10 | 2017-10-16T13:43:07Z | 2017-22292 | 0 | 0 | 0900006482bcd9a0 | ||
| USCG-2011-0228-0033 | USCG | Safety Zone; Brandon Road Lock & Dam to Lake Michigan including Des Plaines River, Chicago Sanitary & Ship Canal, Chicago River, & Calumet-Saganashkee Channel, Chicago, IL USCG-2011-0228 | Safety Zone, Brandon Road Lock and Dam to Lake Michigan Including Des Plaines River, Chicago Sani-tary and Ship Canal, Chicago River, and Calumet-Saganashkee Channel, Chicago, IL | Rule | Temporary Rule | 2017-10-13T04:00:00Z | 2017 | 10 | 2017-10-13T15:12:00Z | 2017-22227 | 0 | 0 | 0900006482bc6adb | ||
| USCG-2017-0942-0001 | USCG | None USCG-2017-0942 | Safety Zone; Upper Mississippi River, St. Louis, MO | Rule | Temporary Rule | 2017-10-13T04:00:00Z | 2017 | 10 | 2017-10-13T14:57:57Z | 2017-22168 | 0 | 0 | 0900006482bc695d | ||
| USCG-2017-0968-0001 | USCG | None USCG-2017-0968 | Special Local Regulation; Fautasi Ocean Challenge Canoe Race, Pago Pago Harbor, American Samoa | Rule | Temporary Rule | 2017-10-13T04:00:00Z | 2017 | 10 | 2017-10-13T15:07:40Z | 2017-22191 | 0 | 0 | 0900006482bc6a59 | ||
| USCG-2017-0808-0003 | USCG | None USCG-2017-0808 | Safety Zone; Patapsco River, Northwest and Inner Harbors; Baltimore, MD | Rule | Correction | 2017-10-13T04:00:00Z | 2017 | 10 | 2017-10-13T15:03:07Z | 2017-21959 | 0 | 0 | 0900006482bc698c | ||
| USCG-2017-0947-0001 | USCG | None USCG-2017-0947 | Safety Zone, Delaware River; Dredging | Rule | Temporary Rule | 2017-10-13T04:00:00Z | 2017 | 10 | 2017-10-13T15:14:28Z | 2017-21979 | 0 | 0 | 0900006482bc6adc | ||
| USCG-2017-0960-0001 | USCG | None USCG-2017-0960 | Drawbridge Operation Regulation; Willamette River, Portland, OR | Rule | Temporary Rule | 2017-10-13T04:00:00Z | 2017 | 10 | 2017-10-13T15:09:47Z | 2017-22169 | 0 | 0 | 0900006482bc6a5d | ||
| USCG-2017-0917-0001 | USCG | None USCG-2017-0917 | Safety Zone; Main Branch of the Chicago River, Oktoberfest, Chicago, IL | Rule | Temporary Rule | 2017-10-13T04:00:00Z | 2017 | 10 | 2017-10-13T04:00:00Z | 2017-10-13T14:56:11Z | 2017-22219 | 0 | 0 | 0900006482bc6369 | |
| USCG-2017-0939-0001 | USCG | None USCG-2017-0939 | Safety Zone; Sector Key West COTP Zone Post Storm Recovery, Atlantic Ocean, FL | Rule | Temporary Rule | 2017-10-12T04:00:00Z | 2017 | 10 | 2017-10-12T13:00:57Z | 2017-22040 | 0 | 0 | 0900006482bc0cab | ||
| USCG-2017-0963-0001 | USCG | None USCG-2017-0963 | Drawbridge Operation Regulation; Sacramento River, Sacramento, CA | Rule | Temporary Rule | 2017-10-11T04:00:00Z | 2017 | 10 | 2017-10-11T14:11:48Z | 2017-21924 | 0 | 0 | 0900006482bbb0d1 | ||
| USCG-2017-0801-0001 | USCG | None USCG-2017-0801 | Safety Zone; Atlantic Intracoastal Waterway, Socastee, SC | Rule | Temporary Rule | 2017-10-11T04:00:00Z | 2017 | 10 | 2017-10-11T04:00:00Z | 2017-11-14T04:59:59Z | 2017-10-11T14:18:11Z | 2017-21868 | 0 | 0 | 0900006482bbb51c |
| USCG-2017-0792-0001 | USCG | None USCG-2017-0792 | Safety Zone; Atlantic Intracoastal Waterway, Camp Lejeune, NC | Rule | Temporary Rule | 2017-10-10T04:00:00Z | 2017 | 10 | 2017-10-10T13:21:39Z | 2017-21709 | 0 | 0 | 0900006482bb2134 | ||
| USCG-2017-0909-0001 | USCG | None USCG-2017-0909 | Special Local Regulations; Marine Events Within the Fifth Coast Guard District | Rule | Temporary Rule | 2017-10-06T04:00:00Z | 2017 | 10 | 2017-10-06T14:24:46Z | 2017-21570 | 0 | 0 | 0900006482ba4fc3 | ||
| USCG-2017-0875-0001 | USCG | None USCG-2017-0875 | Special Local Regulation; Ohio River, Louisville, KY | Rule | Temporary Rule | 2017-10-05T04:00:00Z | 2017 | 10 | 2017-10-05T13:39:00Z | 2017-21468 | 0 | 0 | 0900006482b9efa1 | ||
| USCG-2017-0585-0002 | USCG | None USCG-2017-0585 | Safety Zone; Upper Mississippi River, Crystal City, MO | Rule | Final Rule | 2017-10-04T04:00:00Z | 2017 | 10 | 2017-10-04T14:53:32Z | 2017-21256 | 0 | 0 | 0900006482b9869d | ||
| USCG-2017-0826-0002 | USCG | None USCG-2017-0826 | Drawbridge Operations: Willamette River, Portland, OR; Cancellation | Rule | Temporary Rule | 2017-10-03T04:00:00Z | 2017 | 10 | 2017-10-03T14:39:07Z | 2017-21169 | 0 | 0 | 0900006482b937b8 | ||
| USCG-2017-0812-0001 | USCG | None USCG-2017-0812 | Special Local Regulations: Cumberland River, Nashville, TN | Rule | Temporary Rule | 2017-10-03T04:00:00Z | 2017 | 10 | 2017-10-03T14:12:26Z | 2017-21166 | 0 | 0 | 0900006482b935e5 | ||
| USCG-2017-0918-0001 | USCG | None USCG-2017-0918 | Drawbridge Operation Regulation; Sacramento River, Sacramento, CA | Rule | Temporary Rule | 2017-10-03T04:00:00Z | 2017 | 10 | 2017-10-03T14:36:15Z | 2017-21099 | 0 | 0 | 0900006482b937b3 | ||
| USCG-2017-0577-0003 | USCG | None USCG-2017-0577 | Safety Zones: Blue Angels Air Show, St. Johns River, Jacksonville, FL | Rule | Temporary Rule | 2017-10-03T04:00:00Z | 2017 | 10 | 2017-10-10T19:23:17Z | 2017-21196 | 0 | 0 | 0900006482b935ee | ||
| USCG-2017-0886-0001 | USCG | None USCG-2017-0886 | Safety Zones: Roanoke River, Plymouth, NC | Rule | Temporary Rule | 2017-10-03T04:00:00Z | 2017 | 10 | 2017-10-03T14:32:03Z | 2017-21100 | 0 | 0 | 0900006482b93773 | ||
| USCG-2017-0808-0001 | USCG | None USCG-2017-0808 | Safety Zone; Patapsco River, Northwest and Inner Harbors; Baltimore, MD | Rule | Temporary Rule | 2017-10-03T04:00:00Z | 2017 | 10 | 2017-10-04T14:10:02Z | 2017-21180 | 0 | 0 | 0900006482b92f99 | ||
| USCG-2017-0937-0001 | USCG | None USCG-2017-0937 | Safety Zones: Belt Parkway Bridge Construction, Gerritsen Inlet; Brooklyn, NY | Rule | Temporary Rule | 2017-10-03T04:00:00Z | 2017 | 10 | 2017-10-03T04:00:00Z | 2019-01-01T04:59:59Z | 2017-10-03T14:19:03Z | 2017-21232 | 0 | 0 | 0900006482b935e6 |
| USCG-2017-0727-0001 | USCG | None USCG-2017-0727 | Special Local Regulation; Tennessee River, Chattanooga, TN | Rule | Temporary Rule | 2017-10-03T04:00:00Z | 2017 | 10 | 2017-10-03T14:46:31Z | 2017-21165 | 0 | 0 | 0900006482b93728 | ||
| USCG-2017-0927-0001 | USCG | None USCG-2017-0927 | Drawbridge Operation Regulation; James River, Hopewell, VA | Rule | Temporary Rule | 2017-10-02T04:00:00Z | 2017 | 10 | 2017-10-02T13:18:37Z | 2017-21066 | 0 | 0 | 0900006482b8fda8 | ||
| USCG-2015-1081-0008 | USCG | None USCG-2015-1081 | Safety Zones; Annual Events Requiring Safety Zones in the Captain of the Port Lake Michigan Zone- CornFestival Fireworks | Rule | Temporary Rule | 2017-10-02T04:00:00Z | 2017 | 10 | 2017-10-02T13:29:14Z | 2017-21041 | 0 | 0 | 0900006482b8feb0 | ||
| USCG-2017-0880-0001 | USCG | None USCG-2017-0880 | Drawbridge Operation Regulation; Plum Island River, Newbury, MA | Rule | Temporary Rule | 2017-10-02T04:00:00Z | 2017 | 10 | 2017-10-02T13:25:16Z | 2017-21067 | 0 | 0 | 0900006482b8fead | ||
| USCG-2017-0878-0001 | USCG | None USCG-2017-0878 | Drawbridge Operation Regulation; Pequonnock River, Bridgeport, CT | Rule | Temporary Rule | 2017-10-02T04:00:00Z | 2017 | 10 | 2017-10-02T13:32:15Z | 2017-21068 | 0 | 0 | 0900006482b8fef9 |
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;