documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
53 rows where docket_id = "HUD-2008-0002" sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| HUD-2008-0002-0053 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR–5186–N–53 Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-12-31T00:00:00Z | 2008 | 12 | 2008-12-31T00:00:00Z | 2025-05-21T09:05:36Z | E8-31059 | 0 | 0 | 09000064808090aa | ||
| HUD-2008-0002-0052 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR–5186–N–52 Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-12-24T00:00:00Z | 2008 | 12 | 2008-12-24T00:00:00Z | 2025-05-21T09:05:37Z | E8-30601 | 0 | 0 | 09000064807f8d1d | ||
| HUD-2008-0002-0051 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR–5186–N–51 Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-12-19T00:00:00Z | 2008 | 12 | 2008-12-19T00:00:00Z | 2025-05-21T09:05:38Z | E8-29816 | 0 | 0 | 09000064807e2c78 | ||
| HUD-2008-0002-0050 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR–5186–N–50 Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-12-12T00:00:00Z | 2008 | 12 | 2008-12-12T00:00:00Z | 2025-05-21T09:05:40Z | E8-29144 | 0 | 0 | 09000064807d87ba | ||
| HUD-2008-0002-0049 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR–5186–N–49 Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-12-05T00:00:00Z | 2008 | 12 | 2008-12-05T00:00:00Z | 2025-05-21T09:05:42Z | E8-28629 | 0 | 0 | 09000064807ce0fa | ||
| HUD-2008-0002-0048 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR–5186–N–48 Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-11-28T00:00:00Z | 2008 | 11 | 2008-11-28T00:00:00Z | 2025-05-21T09:05:43Z | E8-28066 | 0 | 0 | 09000064807c3ac3 | ||
| HUD-2008-0002-0047 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR–5186–N–47 Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-11-21T00:00:00Z | 2008 | 11 | 2008-11-21T00:00:00Z | 2025-05-21T09:05:47Z | E8-27383 | 0 | 0 | 09000064807b6e2b | ||
| HUD-2008-0002-0046 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR–5186–N–46 Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-11-14T00:00:00Z | 2008 | 11 | 2008-11-14T00:00:00Z | 2025-05-21T09:06:06Z | E8-26887 | 0 | 0 | 09000064807a8f9b | ||
| HUD-2008-0002-0045 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR–5186–N–45 Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-11-07T00:00:00Z | 2008 | 11 | 2008-11-07T00:00:00Z | 2025-05-21T09:06:15Z | E8-26321 | 0 | 0 | 090000648079c4cc | ||
| HUD-2008-0002-0044 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR–5186–N–44 Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-10-31T00:00:00Z | 2008 | 10 | 2008-10-31T00:00:00Z | 2025-05-21T09:06:18Z | E8-25737 | 0 | 0 | 090000648078769e | ||
| HUD-2008-0002-0043 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR–5186–N–43 Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-10-24T00:00:00Z | 2008 | 10 | 2008-10-24T00:00:00Z | 2025-05-21T09:06:25Z | E8-25140 | 0 | 0 | 0900006480776d80 | ||
| HUD-2008-0002-0042 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR–5186–N–42 Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-10-17T00:00:00Z | 2008 | 10 | 2008-10-17T00:00:00Z | 2025-05-21T09:06:42Z | E8-24533 | 0 | 0 | 0900006480762e0c | ||
| HUD-2008-0002-0041 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR–5186–N–41 Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-10-10T00:00:00Z | 2008 | 10 | 2008-10-10T00:00:00Z | 2025-05-21T09:06:46Z | E8-23786 | 0 | 0 | 09000064807439f3 | ||
| HUD-2008-0002-0040 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR–5186–N–40 Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-10-03T00:00:00Z | 2008 | 10 | 2008-10-03T00:00:00Z | 2025-05-21T09:06:49Z | E8-23007 | 0 | 0 | 0900006480734a3b | ||
| HUD-2008-0002-0039 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-39: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-09-26T00:00:00Z | 2008 | 9 | 2008-09-26T00:00:00Z | 2025-05-21T09:06:51Z | E8-22329 | 0 | 0 | 0900006480727ee1 | ||
| HUD-2008-0002-0038 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-38: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-09-19T00:00:00Z | 2008 | 9 | 2008-09-19T00:00:00Z | 2025-05-21T09:06:53Z | E8-21696 | 0 | 0 | 090000648070f586 | ||
| HUD-2008-0002-0037 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR–5186–N–37: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-09-12T00:00:00Z | 2008 | 9 | 2008-09-12T00:00:00Z | 2025-05-21T09:06:54Z | E8-21002 | 0 | 0 | 0900006480701871 | ||
| HUD-2008-0002-0036 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-36: Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2008-09-05T00:00:00Z | 2008 | 9 | 2008-09-05T00:00:00Z | 2025-05-21T09:06:55Z | E8-20463 | 0 | 0 | 09000064806f291d | ||
| HUD-2008-0002-0035 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-35: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-08-29T00:00:00Z | 2008 | 8 | 2008-08-29T00:00:00Z | 2025-05-21T09:06:56Z | E8-19741 | 0 | 0 | 09000064806e4f2d | ||
| HUD-2008-0002-0034 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-08-22T00:00:00Z | 2008 | 8 | 2008-08-22T00:00:00Z | 2025-05-21T09:06:57Z | E8-19212 | 0 | 0 | 09000064806d2f85 | ||
| HUD-2008-0002-0033 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-33: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-08-15T00:00:00Z | 2008 | 8 | 2008-08-15T00:00:00Z | 2025-05-21T09:06:58Z | E8-18664 | 0 | 0 | 09000064806c58d6 | ||
| HUD-2008-0002-0032 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-32: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-08-08T00:00:00Z | 2008 | 8 | 2008-08-08T00:00:00Z | 2025-05-21T09:07:01Z | E8-18181 | 0 | 0 | 09000064806b7575 | ||
| HUD-2008-0002-0031 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-31: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-08-01T00:00:00Z | 2008 | 8 | 2008-08-01T00:00:00Z | 2025-05-21T09:07:51Z | E8-17360 | 0 | 0 | 09000064806a5f1f | ||
| HUD-2008-0002-0030 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-30: Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2008-07-25T00:00:00Z | 2008 | 7 | 2008-07-25T00:00:00Z | 2025-05-21T09:09:06Z | E8-16752 | 0 | 0 | 09000064806955ba | ||
| HUD-2008-0002-0029 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-29: Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2008-07-18T00:00:00Z | 2008 | 7 | 2008-07-18T00:00:00Z | 2025-05-21T09:10:05Z | E8-16135 | 0 | 0 | 0900006480683382 | ||
| HUD-2008-0002-0028 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-28: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-07-10T00:00:00Z | 2008 | 7 | 2008-07-10T00:00:00Z | 2025-05-21T09:11:06Z | E8-15652 | 0 | 0 | 090000648066382a | ||
| HUD-2008-0002-0027 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-27: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-07-03T00:00:00Z | 2008 | 7 | 2008-07-03T00:00:00Z | 2025-05-21T09:11:11Z | E8-14940 | 0 | 0 | 0900006480653a61 | ||
| HUD-2008-0002-0026 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-26: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-06-27T00:00:00Z | 2008 | 6 | 2008-06-27T00:00:00Z | 2025-05-21T09:11:16Z | E8-14290 | 0 | 0 | 090000648064328d | ||
| HUD-2008-0002-0025 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-25: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-06-20T00:00:00Z | 2008 | 6 | 2008-06-20T00:00:00Z | 2025-05-21T09:11:46Z | E8-13697 | 0 | 0 | 0900006480631a04 | ||
| HUD-2008-0002-0024 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-24: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-06-13T00:00:00Z | 2008 | 6 | 2008-06-13T00:00:00Z | 2025-05-21T09:12:19Z | E8-13163 | 0 | 0 | 0900006480623d69 | ||
| HUD-2008-0002-0023 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-23: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-06-06T00:00:00Z | 2008 | 6 | 2008-06-06T00:00:00Z | 2025-05-21T09:12:56Z | E8-12649 | 0 | 0 | 090000648061438e | ||
| HUD-2008-0002-0022 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-22: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-05-30T00:00:00Z | 2008 | 5 | 2008-05-30T00:00:00Z | 2025-05-21T09:13:01Z | E8-11893 | 0 | 0 | 09000064806072e5 | ||
| HUD-2008-0002-0021 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-21: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-05-23T00:00:00Z | 2008 | 5 | 2008-05-23T00:00:00Z | 2025-05-21T09:13:05Z | E8-11320 | 0 | 0 | 09000064805faac4 | ||
| HUD-2008-0002-0020 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-20: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-05-16T00:00:00Z | 2008 | 5 | 2008-05-16T00:00:00Z | 2025-05-21T09:13:09Z | E8-10630 | 0 | 0 | 09000064805d5385 | ||
| HUD-2008-0002-0019 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-19: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-05-09T00:00:00Z | 2008 | 5 | 2008-05-09T00:00:00Z | 2025-05-21T09:13:20Z | E8-10009 | 0 | 0 | 0900006480557034 | ||
| HUD-2008-0002-0018 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-18: Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2008-05-02T00:00:00Z | 2008 | 5 | 2008-05-02T00:00:00Z | 2025-05-21T09:13:40Z | E8-09388 | 0 | 0 | 0900006480541a66 | ||
| HUD-2008-0002-0017 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-17: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-04-25T00:00:00Z | 2008 | 4 | 2008-04-25T00:00:00Z | 2025-05-21T09:13:45Z | E8-08723 | 0 | 0 | 0900006480532c61 | ||
| HUD-2008-0002-0016 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-16: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-04-23T00:00:00Z | 2008 | 4 | 2008-04-23T00:00:00Z | 2025-05-21T09:13:46Z | E8-08068 | 0 | 0 | 090000648052278f | ||
| HUD-2008-0002-0015 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-15: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-04-11T00:00:00Z | 2008 | 4 | 2008-04-11T00:00:00Z | 2025-05-21T09:13:48Z | E8-07415 | 0 | 0 | 09000064804a516b | ||
| HUD-2008-0002-0014 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-14: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-04-04T00:00:00Z | 2008 | 4 | 2008-04-04T00:00:00Z | 2025-05-21T09:13:51Z | E8-06717 | 0 | 0 | 0900006480439f57 | ||
| HUD-2008-0002-0013 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-13: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-03-28T00:00:00Z | 2008 | 3 | 2008-03-28T00:00:00Z | 2025-05-21T09:13:53Z | E8-06097 | 0 | 0 | 090000648040d251 | ||
| HUD-2008-0002-0012 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-12: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-03-21T00:00:00Z | 2008 | 3 | 2008-03-21T00:00:00Z | 2025-05-21T09:13:55Z | E8-05455 | 0 | 0 | 0900006480402327 | ||
| HUD-2008-0002-0011 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-11: Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2008-03-17T00:00:00Z | 2008 | 3 | 2008-03-17T00:00:00Z | 2025-05-21T09:13:58Z | E8-05105 | 0 | 0 | 09000064803faa12 | ||
| HUD-2008-0002-0010 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-10: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-03-07T00:00:00Z | 2008 | 3 | 2008-03-07T00:00:00Z | 2025-05-21T09:14:00Z | E8-04186 | 0 | 0 | 09000064803eacc0 | ||
| HUD-2008-0002-0009 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-09: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-02-29T00:00:00Z | 2008 | 2 | 2008-02-29T00:00:00Z | 2025-05-21T09:14:01Z | 08-00852 | 0 | 0 | 09000064803d50fd | ||
| HUD-2008-0002-0008 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-08: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-02-22T00:00:00Z | 2008 | 2 | 2008-02-22T00:00:00Z | 2025-05-21T09:14:02Z | 08-00767 | 0 | 0 | 09000064803baf55 | ||
| HUD-2008-0002-0007 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-07: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-02-15T00:00:00Z | 2008 | 2 | 2008-02-15T00:00:00Z | 2025-05-21T09:14:03Z | E8-02589 | 0 | 0 | 09000064803b0167 | ||
| HUD-2008-0002-0006 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-06: Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2008-02-08T00:00:00Z | 2008 | 2 | 2008-02-08T00:00:00Z | 2025-05-21T09:14:04Z | E8-02090 | 0 | 0 | 09000064803aaa9e | ||
| HUD-2008-0002-0005 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-05: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-02-01T00:00:00Z | 2008 | 2 | 2008-02-01T00:00:00Z | 2025-05-21T09:14:05Z | E8-01578 | 0 | 0 | 09000064803a6516 | ||
| HUD-2008-0002-0004 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-04: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-01-25T00:00:00Z | 2008 | 1 | 2008-01-25T00:00:00Z | 2025-05-21T09:14:06Z | 08-00244 | 0 | 0 | 09000064803a240d | ||
| HUD-2008-0002-0003 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-03: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-01-18T00:00:00Z | 2008 | 1 | 2008-01-18T00:00:00Z | 2025-05-21T09:14:07Z | E8-00665 | 0 | 0 | 090000648039d4b8 | ||
| HUD-2008-0002-0002 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-02: Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2008-01-11T00:00:00Z | 2008 | 1 | 2008-01-11T00:00:00Z | 2025-05-21T09:14:08Z | E8-00124 | 0 | 0 | 0900006480399337 | ||
| HUD-2008-0002-0001 | HUD | FR-5186-N-01 Federal Property Suitable as Facilities to Assist the Homeless HUD-2008-0002 | FR-5186-N-01: Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2008-01-04T00:00:00Z | 2008 | 1 | 2008-01-04T00:00:00Z | 2025-05-21T09:14:09Z | E7-25558 | 0 | 0 | 0900006480384bf4 |
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;