documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
53 rows where docket_id = "HUD-2010-0002" sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: posted_month, withdrawn, 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-2010-0002-0053 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5477–N–06 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2011-02-14T00:00:00Z | 2011 | 2 | 2025-05-21T08:55:02Z | 0 | 1 | 0900006480bee46d | ||||
| HUD-2010-0002-0052 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–51 Federal Properties Suitable as Facilities to Assist Homeless | Notice | 2010-12-30T00:00:00Z | 2010 | 12 | 2010-12-30T00:00:00Z | 2025-05-21T08:55:21Z | 2010-32792 | 0 | 0 | 0900006480bc2752 | ||
| HUD-2010-0002-0051 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–50 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2010-12-23T00:00:00Z | 2010 | 12 | 2010-12-23T00:00:00Z | 2025-05-21T08:55:26Z | 2010-32011 | 0 | 0 | 0900006480bbe4e7 | ||
| HUD-2010-0002-0050 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–49 Federal Property Suitable as Facilities to Assist Homeless | Notice | 2010-12-17T00:00:00Z | 2010 | 12 | 2010-12-17T00:00:00Z | 2025-05-21T08:55:29Z | 2010-31365 | 0 | 0 | 0900006480bb917d | ||
| HUD-2010-0002-0049 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–48 Federal Property Suitable as Facilities To Assist Homeless | Notice | 2010-12-10T00:00:00Z | 2010 | 12 | 2010-12-10T00:00:00Z | 2025-05-21T08:55:31Z | 2010-30691 | 0 | 0 | 0900006480bb396c | ||
| HUD-2010-0002-0048 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–47 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2010-12-03T00:00:00Z | 2010 | 12 | 2010-12-03T00:00:00Z | 2025-05-21T08:55:34Z | 2010-30245 | 0 | 0 | 0900006480bad6f9 | ||
| HUD-2010-0002-0047 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–46 Federal Properties Suitable as Facilities to Assist Homeless | Notice | 2010-11-26T00:00:00Z | 2010 | 11 | 2010-11-26T00:00:00Z | 2025-05-21T08:55:35Z | 2010-29535 | 0 | 0 | 0900006480ba4318 | ||
| HUD-2010-0002-0046 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–45 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2010-11-19T00:00:00Z | 2010 | 11 | 2010-11-19T00:00:00Z | 2025-05-21T08:55:36Z | 2010-28858 | 0 | 0 | 0900006480b9b147 | ||
| HUD-2010-0002-0045 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–44 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2010-11-12T00:00:00Z | 2010 | 11 | 2010-11-12T00:00:00Z | 2025-05-21T08:55:39Z | 2010-28281 | 0 | 0 | 0900006480b87398 | ||
| HUD-2010-0002-0044 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–43 Federal Property Suitable as Facilities to Assist Homeless | Notice | 2010-11-05T00:00:00Z | 2010 | 11 | 2010-11-05T00:00:00Z | 2025-05-21T08:55:41Z | 2010-27681 | 0 | 0 | 0900006480b82502 | ||
| HUD-2010-0002-0043 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–42 Federal Property Suitable as Facilities to Assist Homeless | Notice | 2010-10-29T00:00:00Z | 2010 | 10 | 2010-10-29T00:00:00Z | 2025-05-21T08:55:43Z | 2010-27072 | 0 | 0 | 0900006480b7aaef | ||
| HUD-2010-0002-0042 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–41 Federal Property Suitable as Facilities to Assist Homeless | Notice | 2010-10-22T00:00:00Z | 2010 | 10 | 2010-10-22T00:00:00Z | 2025-05-21T08:55:45Z | 2010-26293 | 0 | 0 | 0900006480b75232 | ||
| HUD-2010-0002-0041 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–40 Federal Property Suitable as Facilities to Assist Homeless | Notice | 2010-10-15T00:00:00Z | 2010 | 10 | 2010-10-15T00:00:00Z | 2025-05-21T08:55:48Z | 2010-25763 | 0 | 0 | 0900006480b6fcd1 | ||
| HUD-2010-0002-0040 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–39 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2010-10-08T00:00:00Z | 2010 | 10 | 2010-10-08T00:00:00Z | 2025-05-21T08:55:51Z | 2010-25025 | 0 | 0 | 0900006480b6a09e | ||
| HUD-2010-0002-0039 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–38 Federal Property Suitable as Facilities to Assist Homeless | Notice | 2010-10-01T00:00:00Z | 2010 | 10 | 2010-10-01T00:00:00Z | 2025-05-21T08:55:53Z | 2010-24345 | 0 | 0 | 0900006480b65126 | ||
| HUD-2010-0002-0038 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–37 Federal Property Suitable as Facilities to Assist Homeless | Notice | 2010-09-24T00:00:00Z | 2010 | 9 | 2010-09-24T00:00:00Z | 2025-05-21T08:55:56Z | 2010-23580 | 0 | 0 | 0900006480b5d85e | ||
| HUD-2010-0002-0037 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–36 Federal Property Suitable as Facilities to Assist Homeless | Notice | 2010-09-17T00:00:00Z | 2010 | 9 | 2010-09-17T00:00:00Z | 2025-05-21T08:56:30Z | 2010-22918 | 0 | 0 | 0900006480b51e07 | ||
| HUD-2010-0002-0036 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR-5375-N-35 Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2010-09-10T00:00:00Z | 2010 | 9 | 2010-09-10T00:00:00Z | 2025-05-21T08:56:38Z | 2010-22441 | 0 | 0 | 0900006480b4b376 | ||
| HUD-2010-0002-0035 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2010-09-03T00:00:00Z | 2010 | 9 | 2010-09-03T00:00:00Z | 2025-05-21T08:56:45Z | 2010-21731 | 0 | 0 | 0900006480b444eb | ||
| HUD-2010-0002-0034 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–33 Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2010-08-27T00:00:00Z | 2010 | 8 | 2010-08-27T00:00:00Z | 2025-05-21T08:56:58Z | 2010-21062 | 0 | 0 | 0900006480b3c3ee | ||
| HUD-2010-0002-0033 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–32 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2010-08-20T00:00:00Z | 2010 | 8 | 2010-08-20T00:00:00Z | 2025-05-21T08:57:05Z | 2010-20342 | 0 | 0 | 0900006480b3624c | ||
| HUD-2010-0002-0032 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR-5375-N-31 Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2010-08-13T00:00:00Z | 2010 | 8 | 2010-08-13T00:00:00Z | 2025-05-21T08:57:10Z | 2010-19744 | 0 | 0 | 0900006480b2f863 | ||
| HUD-2010-0002-0031 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–30 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2010-08-06T00:00:00Z | 2010 | 8 | 2010-08-06T00:00:00Z | 2025-05-21T08:57:16Z | 2010-19082 | 0 | 0 | 0900006480b2abe6 | ||
| HUD-2010-0002-0030 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–29 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2010-07-30T00:00:00Z | 2010 | 7 | 2010-07-30T00:00:00Z | 2025-05-21T08:57:26Z | 2010-18423 | 0 | 0 | 0900006480b24796 | ||
| HUD-2010-0002-0029 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–28 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2010-07-23T00:00:00Z | 2010 | 7 | 2010-07-23T00:00:00Z | 2025-05-21T08:57:35Z | 2010-17727 | 0 | 0 | 0900006480b1fd6d | ||
| HUD-2010-0002-0028 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–27 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2010-07-16T00:00:00Z | 2010 | 7 | 2010-07-16T00:00:00Z | 2025-05-21T08:57:52Z | 2010-17059 | 0 | 0 | 0900006480b1b281 | ||
| HUD-2010-0002-0027 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–26 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2010-07-09T00:00:00Z | 2010 | 7 | 2010-07-09T00:00:00Z | 2025-05-21T08:57:55Z | 2010-16507 | 0 | 0 | 0900006480b15f54 | ||
| HUD-2010-0002-0026 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–25 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2010-07-02T00:00:00Z | 2010 | 7 | 2010-07-02T00:00:00Z | 2025-05-21T08:57:57Z | 2010-15716 | 0 | 0 | 0900006480b10f14 | ||
| HUD-2010-0002-0025 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–24 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2010-06-25T00:00:00Z | 2010 | 6 | 2010-06-25T00:00:00Z | 2025-05-21T08:57:59Z | 2010-15090 | 0 | 0 | 0900006480b09fd7 | ||
| HUD-2010-0002-0024 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–23 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2010-06-18T00:00:00Z | 2010 | 6 | 2010-06-18T00:00:00Z | 2025-05-21T08:58:05Z | 2010-14446 | 0 | 0 | 0900006480b05567 | ||
| HUD-2010-0002-0023 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–22 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2010-06-11T00:00:00Z | 2010 | 6 | 2010-06-11T00:00:00Z | 2025-05-21T08:58:17Z | 2010-13692 | 0 | 0 | 0900006480b00269 | ||
| HUD-2010-0002-0022 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–21 Federal Property Suitable as Facilities to Assist the Homeless; Republication | Notice | 2010-06-04T00:00:00Z | 2010 | 6 | 2010-06-04T00:00:00Z | 2025-05-21T08:58:32Z | R1-2010-13257 | 0 | 0 | 0900006480afbb0a | ||
| HUD-2010-0002-0021 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–21 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2010-06-02T00:00:00Z | 2010 | 6 | 2010-06-02T00:00:00Z | 2025-05-21T08:58:35Z | 2010-13257 | 0 | 0 | 0900006480afa12e | ||
| HUD-2010-0002-0020 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–20 Federal Property Suitable as Facilities To Assist Homeless | Notice | 2010-05-28T00:00:00Z | 2010 | 5 | 2010-05-28T00:00:00Z | 2025-05-21T08:58:44Z | 2010-12574 | 0 | 0 | 0900006480af58da | ||
| HUD-2010-0002-0019 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–19 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2010-05-21T00:00:00Z | 2010 | 5 | 2010-05-21T00:00:00Z | 2025-05-21T08:58:52Z | 2010-11838 | 0 | 0 | 0900006480af19ae | ||
| HUD-2010-0002-0018 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–18 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2010-05-14T00:00:00Z | 2010 | 5 | 2010-05-14T00:00:00Z | 2025-05-21T08:58:58Z | 2010-11188 | 0 | 0 | 0900006480aed914 | ||
| HUD-2010-0002-0017 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–17 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2010-05-07T00:00:00Z | 2010 | 5 | 2010-05-07T00:00:00Z | 2025-05-21T08:59:09Z | 2010-10422 | 0 | 0 | 0900006480ae8ac1 | ||
| HUD-2010-0002-0016 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR-5375-N-16 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2010-04-30T00:00:00Z | 2010 | 4 | 2010-04-30T00:00:00Z | 2025-05-21T08:59:11Z | 2010-09766 | 0 | 0 | 0900006480ae435c | ||
| HUD-2010-0002-0015 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–15 Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2010-04-23T00:00:00Z | 2010 | 4 | 2010-04-23T00:00:00Z | 2025-05-21T08:59:12Z | 2010-09136 | 0 | 0 | 0900006480ade685 | ||
| HUD-2010-0002-0014 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–14 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2010-04-16T00:00:00Z | 2010 | 4 | 2010-04-16T00:00:00Z | 2025-05-21T08:59:16Z | 2010-08427 | 0 | 0 | 0900006480ad9285 | ||
| HUD-2010-0002-0013 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–13 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2010-04-09T00:00:00Z | 2010 | 4 | 2010-04-09T00:00:00Z | 2025-05-21T08:59:18Z | 2010-07765 | 0 | 0 | 0900006480ad3f61 | ||
| HUD-2010-0002-0012 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–12 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2010-04-02T00:00:00Z | 2010 | 4 | 2010-04-02T00:00:00Z | 2025-05-21T08:59:20Z | 2010-07272 | 0 | 0 | 0900006480acede9 | ||
| HUD-2010-0002-0011 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–11 Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2010-03-26T00:00:00Z | 2010 | 3 | 2010-03-26T00:00:00Z | 2025-05-21T08:59:23Z | 2010-06342 | 0 | 0 | 0900006480ac93c1 | ||
| HUD-2010-0002-0010 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–10 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2010-03-19T00:00:00Z | 2010 | 3 | 2010-03-19T00:00:00Z | 2025-05-21T08:59:27Z | 2010-05745 | 0 | 0 | 0900006480ac1879 | ||
| HUD-2010-0002-0009 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–09 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2010-03-12T00:00:00Z | 2010 | 3 | 2010-03-12T00:00:00Z | 2025-05-21T08:59:38Z | 2010-05015 | 0 | 0 | 0900006480abc22a | ||
| HUD-2010-0002-0008 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–08 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2010-03-05T00:00:00Z | 2010 | 3 | 2010-03-05T00:00:00Z | 2025-05-21T09:01:20Z | 2010-04281 | 0 | 0 | 0900006480ab5e5c | ||
| HUD-2010-0002-0007 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–07 Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2010-02-26T00:00:00Z | 2010 | 2 | 2010-02-26T00:00:00Z | 2025-05-21T09:01:54Z | 2010-03606 | 0 | 0 | 0900006480aaf46d | ||
| HUD-2010-0002-0006 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–06 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2010-02-12T00:00:00Z | 2010 | 2 | 2010-02-12T00:00:00Z | 2025-05-21T09:03:11Z | 2010-02822 | 0 | 0 | 0900006480a91ab2 | ||
| HUD-2010-0002-0005 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–05 Federal Property Suitable as Facilities to Assist the Homeless | Notice | 2010-02-05T00:00:00Z | 2010 | 2 | 2010-02-05T00:00:00Z | 2025-05-21T09:03:16Z | 2010-02209 | 0 | 0 | 0900006480a8e90c | ||
| HUD-2010-0002-0004 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–04 Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2010-01-29T00:00:00Z | 2010 | 1 | 2010-01-29T00:00:00Z | 2025-05-21T09:03:19Z | 2010-01483 | 0 | 0 | 0900006480a87147 | ||
| HUD-2010-0002-0003 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–03 Federal Property Suitable as Facilities to Help the Homeless | Notice | 2010-01-22T00:00:00Z | 2010 | 1 | 2010-01-22T00:00:00Z | 2025-05-21T09:03:21Z | 2010-00964 | 0 | 0 | 0900006480a81ff8 | ||
| HUD-2010-0002-0002 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–02 Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2010-01-15T00:00:00Z | 2010 | 1 | 2010-01-15T00:00:00Z | 2025-05-21T09:03:22Z | 2010-00346 | 0 | 0 | 0900006480a7dd0f | ||
| HUD-2010-0002-0001 | HUD | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless HUD-2010-0002 | FR–5375–N–01 Federal Property Suitable as Facilities To Assist the Homeless | Notice | 2010-01-08T00:00:00Z | 2010 | 1 | 2010-01-08T00:00:00Z | 2025-05-21T09:03:24Z | E9-31169 | 0 | 0 | 0900006480a798b7 |
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;