documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
58 rows where docket_id = "FWS-HQ-MB-2015-0034" 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), comment_end_date (date), last_modified (date)
document_type 3
agency_id 1
- FWS 58
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FWS-HQ-MB-2015-0034-0077 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Migratory Bird Hunting: Certain Federal Indian Reservations and Ceded Lands; 2016-17 Season | Rule | 2016-09-09T04:00:00Z | 2016 | 9 | 2016-09-09T04:00:00Z | 2016-09-09T13:41:30Z | 2016-21739 | 0 | 0 | 09000064821e76bd | ||
| FWS-HQ-MB-2015-0034-0076 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Migratory Bird Hunting: Seasons and Bag and Possession Limits for Certain Game Birds | Rule | 2016-08-16T04:00:00Z | 2016 | 8 | 2016-08-16T04:00:00Z | 2016-08-16T13:34:26Z | 2016-19447 | 0 | 0 | 0900006482178a58 | ||
| FWS-HQ-MB-2015-0034-0075 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Migratory Bird Hunting: Seasons and Bag and Possession Limits for Certain Migratory Game Birds | Rule | 2016-07-25T04:00:00Z | 2016 | 7 | 2016-07-25T04:00:00Z | 2016-07-25T12:59:41Z | 2016-17330 | 0 | 0 | 0900006482119529 | ||
| FWS-HQ-MB-2015-0034-0062 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Jicarilla 2016 Proposal | Supporting & Related Material | Background Material | 2016-06-14T04:00:00Z | 2016 | 6 | 2016-06-14T15:49:48Z | 0 | 0 | 0900006482038683 | |||
| FWS-HQ-MB-2015-0034-0071 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | White Mntn 2016 Proposal | Supporting & Related Material | Background Material | 2016-06-14T04:00:00Z | 2016 | 6 | 2016-06-14T15:49:49Z | 0 | 0 | 090000648203868c | |||
| FWS-HQ-MB-2015-0034-0058 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Flathead 2016 Proposal | Supporting & Related Material | Background Material | 2016-06-14T04:00:00Z | 2016 | 6 | 2016-06-14T15:49:47Z | 0 | 0 | 090000648203864e | |||
| FWS-HQ-MB-2015-0034-0059 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Fond du Lac 2016 Proposal to FWS | Supporting & Related Material | Background Material | 2016-06-14T04:00:00Z | 2016 | 6 | 2016-06-14T15:49:48Z | 0 | 0 | 090000648203864f | |||
| FWS-HQ-MB-2015-0034-0061 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | GTB - 2016-17 Migratory Bird Hunting Regs | Supporting & Related Material | Background Material | 2016-06-14T04:00:00Z | 2016 | 6 | 2016-06-14T15:49:48Z | 0 | 0 | 0900006482038682 | |||
| FWS-HQ-MB-2015-0034-0064 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Little Traverse Bay 2016 Proposal | Supporting & Related Material | Background Material | 2016-06-14T04:00:00Z | 2016 | 6 | 2016-06-14T15:49:49Z | 0 | 0 | 0900006482038685 | |||
| FWS-HQ-MB-2015-0034-0060 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | GLIFWC Migratory Bird Proposal 2016-17-3 | Supporting & Related Material | Background Material | 2016-06-14T04:00:00Z | 2016 | 6 | 2016-06-14T15:49:48Z | 0 | 0 | 0900006482038681 | |||
| FWS-HQ-MB-2015-0034-0069 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Spokane Proposal 2016 | Supporting & Related Material | Background Material | 2016-06-14T04:00:00Z | 2016 | 6 | 2016-06-14T15:49:49Z | 0 | 0 | 090000648203868a | |||
| FWS-HQ-MB-2015-0034-0063 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Kalispel 2016 Proposal | Supporting & Related Material | Background Material | 2016-06-14T04:00:00Z | 2016 | 6 | 2016-06-16T12:18:38Z | 0 | 0 | 0900006482038684 | |||
| FWS-HQ-MB-2015-0034-0066 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Makah_Migratory_Proposed_Seasons_2016 | Supporting & Related Material | Background Material | 2016-06-14T04:00:00Z | 2016 | 6 | 2016-06-14T15:49:49Z | 0 | 0 | 0900006482038687 | |||
| FWS-HQ-MB-2015-0034-0068 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Saginaw Chippewa 2016 proposal | Supporting & Related Material | Background Material | 2016-06-14T04:00:00Z | 2016 | 6 | 2016-06-14T15:49:49Z | 0 | 0 | 0900006482038689 | |||
| FWS-HQ-MB-2015-0034-0070 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | SWINOMISH INDIAN TRIBAL COMMUNITY WATERFOWL 2016-2017 | Supporting & Related Material | Background Material | 2016-06-14T04:00:00Z | 2016 | 6 | 2016-06-16T12:18:39Z | 0 | 0 | 090000648203868b | |||
| FWS-HQ-MB-2015-0034-0065 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Lower Brule Proposal 2016 | Supporting & Related Material | Background Material | 2016-06-14T04:00:00Z | 2016 | 6 | 2016-06-14T15:49:49Z | 0 | 0 | 0900006482038686 | |||
| FWS-HQ-MB-2015-0034-0067 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Oneida 2016 Proposal | Supporting & Related Material | Background Material | 2016-06-14T04:00:00Z | 2016 | 6 | 2016-06-14T15:49:49Z | 0 | 0 | 0900006482038688 | |||
| FWS-HQ-MB-2015-0034-0051 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Migratory Bird Hunting: Certain Federal Indian Reservations and Ceded Lands for the 2016-17 Season | Proposed Rule | 2016-05-27T04:00:00Z | 2016 | 5 | 2016-05-27T04:00:00Z | 2016-06-28T03:59:59Z | 2016-06-28T01:01:02Z | 2016-12576 | 0 | 0 | 0900006481ff8fca | |
| FWS-HQ-MB-2015-0034-0050 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Migratory Bird Hunting: Final Frameworks for Migratory Bird Hunting Regulations; Corrections | Rule | 2016-04-12T04:00:00Z | 2016 | 4 | 2016-04-12T04:00:00Z | 2016-04-12T13:35:19Z | 2016-08326 | 0 | 0 | 0900006481f61156 | ||
| FWS-HQ-MB-2015-0034-0049 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | FONSI and EA 2016 | Supporting & Related Material | EA and FONSI | 2016-03-28T04:00:00Z | 2016 | 3 | 2016-03-28T18:32:33Z | 0 | 0 | 0900006481ee4fe9 | |||
| FWS-HQ-MB-2015-0034-0047 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Final Rule | Rule | 2016-03-28T04:00:00Z | 2016 | 3 | 2016-03-28T04:00:00Z | 2016-03-28T12:32:35Z | 2016-06601 | 0 | 0 | 0900006481ee1f96 | ||
| FWS-HQ-MB-2015-0034-0048 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Consult on Proposed 16-19 MGB Hunt Regs | Supporting & Related Material | Report | 2016-03-28T04:00:00Z | 2016 | 3 | 2016-03-28T18:32:11Z | 0 | 0 | 0900006481ee4fe8 | |||
| FWS-HQ-MB-2015-0034-0038 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Status of Snipe, Gallinules, Rails, and Coot - 2015 | Supporting & Related Material | Report | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T15:24:03Z | 0 | 0 | 0900006481d8bac6 | |||
| FWS-HQ-MB-2015-0034-0013 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | 10/21/215 DOI FWS-Meeting Day 2 | Supporting & Related Material | Meeting Transcripts | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T14:53:34Z | 0 | 0 | 0900006481d8ba80 | |||
| FWS-HQ-MB-2015-0034-0017 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Atlantic Flyway Council Eastern Management - Doves Unit 2016-17 Recommendation | Supporting & Related Material | Report | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T15:02:53Z | 0 | 0 | 0900006481d8bab1 | |||
| FWS-HQ-MB-2015-0034-0020 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | American Woodcock Harvest Strategy Briefing Memo 2016-17 | Supporting & Related Material | Technical Support Document | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T15:07:19Z | 0 | 0 | 0900006481d8bab4 | |||
| FWS-HQ-MB-2015-0034-0032 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Mourning Dove Population Status 2015 | Supporting & Related Material | Technical Support Document | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T15:19:57Z | 0 | 0 | 0900006481d8bac0 | |||
| FWS-HQ-MB-2015-0034-0033 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Pacific Flyway Council Recommendations September 2015 | Supporting & Related Material | Report | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T15:20:30Z | 0 | 0 | 0900006481d8bac1 | |||
| FWS-HQ-MB-2015-0034-0012 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | 10/20/2015 DOI FWS-Meeting Day 1 | Supporting & Related Material | Meeting Transcripts | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T14:51:25Z | 0 | 0 | 0900006481d8ba7f | |||
| FWS-HQ-MB-2015-0034-0030 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Mourning Dove Briefing Memo 2016-17 | Supporting & Related Material | Memorandum | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T15:18:05Z | 0 | 0 | 0900006481d8babe | |||
| FWS-HQ-MB-2015-0034-0031 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Mourning Dove Harvest Strategy error memo 2015 | Supporting & Related Material | Memorandum | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T15:18:43Z | 0 | 0 | 0900006481d8babf | |||
| FWS-HQ-MB-2015-0034-0037 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Service Regulations Committee Meeting Agenda | Supporting & Related Material | Meeting Summary | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T15:23:28Z | 0 | 0 | 0900006481d8bac5 | |||
| FWS-HQ-MB-2015-0034-0021 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Attendance Sheet - 10/20/2015 | Supporting & Related Material | Meeting Transcripts | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T15:08:05Z | 0 | 0 | 0900006481d8bab5 | |||
| FWS-HQ-MB-2015-0034-0022 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Attendance Sheet - 10/21/2015 | Supporting & Related Material | Meeting Transcripts | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T15:08:43Z | 0 | 0 | 0900006481d8bab6 | |||
| FWS-HQ-MB-2015-0034-0023 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Band-Tailed Pigeon Index Briefing Memo 2016-17 | Supporting & Related Material | Memorandum | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T15:11:29Z | 0 | 0 | 0900006481d8bab7 | |||
| FWS-HQ-MB-2015-0034-0024 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Band-Tailed Pigeon Population Status 2015 | Supporting & Related Material | Report | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T15:13:21Z | 0 | 0 | 0900006481d8bab8 | |||
| FWS-HQ-MB-2015-0034-0036 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Service Regulations Committee Meeting 2-day agenda | Supporting & Related Material | Meeting Summary | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T15:22:53Z | 0 | 0 | 0900006481d8bac4 | |||
| FWS-HQ-MB-2015-0034-0011 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Migratory Bird Hunting; Proposed Frameworks for Migratory Bird Hunting Regulations, | Proposed Rule | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T05:00:00Z | 2016-01-12T04:59:59Z | 2016-01-13T00:52:08Z | 2015-31169 | 0 | 0 | 0900006481d9d527 | |
| FWS-HQ-MB-2015-0034-0035 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | SEIS & Adaptive Harvest Report | Supporting & Related Material | Report | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T15:22:07Z | 0 | 0 | 0900006481d8bac3 | |||
| FWS-HQ-MB-2015-0034-0019 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | American Woodcock Status Report, 2015 | Supporting & Related Material | Report | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T15:06:31Z | 0 | 0 | 0900006481d8bab3 | |||
| FWS-HQ-MB-2015-0034-0025 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Canvasback Briefing Memo 2016-17 | Supporting & Related Material | Memorandum | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T15:14:41Z | 0 | 0 | 0900006481d8bab9 | |||
| FWS-HQ-MB-2015-0034-0015 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | American Black Duck Harvest Management Recommendation 2016-2017 | Supporting & Related Material | Report | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T14:57:07Z | 0 | 0 | 0900006481d8ba82 | |||
| FWS-HQ-MB-2015-0034-0018 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Adaptive Harvest Management Report 2016 Hunting Season | Supporting & Related Material | Report | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T15:03:32Z | 0 | 0 | 0900006481d8bab2 | |||
| FWS-HQ-MB-2015-0034-0026 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Central Flyway Council Recommendation 8 Youth Hunt Age Definition | Supporting & Related Material | Technical Support Document | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T15:15:36Z | 0 | 0 | 0900006481d8baba | |||
| FWS-HQ-MB-2015-0034-0027 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Central Flyway Council Recommendations and Letter | Supporting & Related Material | Technical Support Document | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T15:16:17Z | 0 | 0 | 0900006481d8babb | |||
| FWS-HQ-MB-2015-0034-0039 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Waterfowl Status Report 2015 | Supporting & Related Material | Report | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T15:24:36Z | 0 | 0 | 0900006481d8bac7 | |||
| FWS-HQ-MB-2015-0034-0014 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | 2015 Mid-Continent Sandhill Cranes Final Report | Supporting & Related Material | Report | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T14:54:24Z | 0 | 0 | 0900006481d8ba81 | |||
| FWS-HQ-MB-2015-0034-0034 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Sandhill Crane Status Report - 2015 | Supporting & Related Material | Report | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T15:21:05Z | 0 | 0 | 0900006481d8bac2 | |||
| FWS-HQ-MB-2015-0034-0016 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Atlantic Flyway Recommendations Oct 2015 | Supporting & Related Material | Technical Support Document | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T14:59:40Z | 0 | 0 | 0900006481d8bab0 | |||
| FWS-HQ-MB-2015-0034-0028 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Mississippi Flyway Council Recommendations Sept. 2015 | Supporting & Related Material | Technical Support Document | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T15:16:54Z | 0 | 0 | 0900006481d8babc | |||
| FWS-HQ-MB-2015-0034-0029 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Migratory Bird Hunting Activity and Harvest for the 2013-14 and 2014-15 Hunting Seasons (1) | Supporting & Related Material | Report | 2015-12-11T05:00:00Z | 2015 | 12 | 2015-12-11T15:17:30Z | 0 | 0 | 0900006481d8babd | |||
| FWS-HQ-MB-2015-0034-0003 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Migratory Bird Hunting: Proposed 2016-17 Migratory Game Bird Hunting Regulations (Preliminary) With Requests for Indian Tribal Proposals; Meetngs | Proposed Rule | 2015-08-06T04:00:00Z | 2015 | 8 | 2015-08-06T04:00:00Z | 2016-01-16T04:59:59Z | 2015-12-24T22:00:50Z | 2015-19318 | 0 | 0 | 0900006481bc7553 | |
| FWS-HQ-MB-2015-0034-0007 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Adaptive Harvest Management SEIS Report | Supporting & Related Material | Report | 2015-08-06T04:00:00Z | 2015 | 8 | 2015-08-06T13:01:09Z | 0 | 0 | 0900006481bc4b84 | |||
| FWS-HQ-MB-2015-0034-0006 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | 2016 SRC Attendance - June 25 | Supporting & Related Material | Meeting Summary | 2015-08-06T04:00:00Z | 2015 | 8 | 2015-08-06T13:01:08Z | 0 | 0 | 0900006481bc4b83 | |||
| FWS-HQ-MB-2015-0034-0004 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | 2015 June 25 DOI-FWS Preliminary Meeting | Supporting & Related Material | Meeting Summary | 2015-08-06T04:00:00Z | 2015 | 8 | 2015-08-06T13:01:08Z | 0 | 0 | 0900006481bc4b81 | |||
| FWS-HQ-MB-2015-0034-0005 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | 2015 June SRC Agenda | Supporting & Related Material | Meeting Summary | 2015-08-06T04:00:00Z | 2015 | 8 | 2015-08-06T13:01:08Z | 0 | 0 | 0900006481bc4b82 | |||
| FWS-HQ-MB-2015-0034-0002 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Economic Analysis of the Migratory Bird Hunting Regulations for the 2013-2014 Season | Supporting & Related Material | Report | 2015-07-15T04:00:00Z | 2015 | 7 | 2015-07-15T21:33:45Z | 0 | 0 | 0900006481b89465 | |||
| FWS-HQ-MB-2015-0034-0001 | FWS | 2016-17 Annual Migratory Bird Hunting FWS-HQ-MB-2015-0034 | Meetings: Migratory Bird Hunting Service Regulations Committee | Proposed Rule | 2015-05-27T04:00:00Z | 2015 | 5 | 2015-05-27T04:00:00Z | 2015-05-27T14:08:45Z | 2015-12665 | 0 | 0 | 0900006481b04efb |
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;