documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
46 rows where docket_id = "TSA-2004-19147" sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: subtype, posted_month, comment_start_date, comment_end_date, open_for_comment, posted_date (date), comment_start_date (date), comment_end_date (date), last_modified (date)
document_type 4
- Notice 21
- Supporting & Related Material 15
- Other 7
- Rule 3
agency_id 1
- TSA 46
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TSA-2004-19147-0435 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | Flight Training Security Program | Rule | Final Rule | 2024-05-01T04:00:00Z | 2024 | 5 | 2024-05-01T04:00:00Z | 2024-05-07T19:04:12Z | 2024-08800 | 0 | 0 | 090000648652cadc | |
| TSA-2004-19147-0433 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | U.S. DHS/TSA - Fee Development Report for Flight Training Security Program (FTSP) Final Rule (December 2023) | Supporting & Related Material | Report | 2024-04-30T04:00:00Z | 2024 | 4 | 2024-04-30T14:31:18Z | 0 | 0 | 09000064865287b2 | |||
| TSA-2004-19147-0434 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | U.S. DHS/TSA - Flight Training Security Program Final Rulemaking - Final Regulatory Impact Analysis (May 1, 2024) | Supporting & Related Material | Regulatory Analysis | 2024-04-30T04:00:00Z | 2024 | 4 | 2024-04-30T14:33:18Z | 0 | 0 | 09000064865287b5 | |||
| TSA-2004-19147-0432 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Flight Training Security | Notice | 30 Day Proposed Information Collection | 2022-01-19T05:00:00Z | 2022 | 1 | 2022-01-19T05:00:00Z | 2022-02-19T04:59:59Z | 2022-01-19T14:07:39Z | 2022-00894 | 0 | 0 | 0900006484f26ebf |
| TSA-2004-19147-0431 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Flight Training Security | Notice | 60 Day Proposed Information Collection | 2021-08-25T04:00:00Z | 2021 | 8 | 2021-08-25T04:00:00Z | 2021-10-26T03:59:59Z | 2024-10-27T00:04:22Z | 2021-18225 | 0 | 0 | 0900006484ca350e |
| TSA-2004-19147-0430 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | Exemption from Regulatory Requirements Limiting the Initiation of Flight Training to 180 Days or Less for Aliens Who Have an Approved Security Threat Assessment | Notice | Notice of Intent | 2020-05-21T04:00:00Z | 2020 | 5 | 2020-05-21T04:00:00Z | 2020-05-21T20:23:38Z | 2020-10960 | 0 | 0 | 090000648465b6da | |
| TSA-2004-19147-0428 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | 30DY PRA Notice: Extension of Agency Information Collection Activity Under OMB Review: Flight Training for Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees (Original) | Other | Supplement (SUP) | 2018-11-01T04:00:00Z | 2018 | 11 | 2018-11-01T04:00:00Z | 2018-11-01T12:23:41Z | 0 | 0 | 0900006483878223 | ||
| TSA-2004-19147-0427 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Flight Training for Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees | Notice | 30 Day Proposed Information Collection | 2018-10-31T04:00:00Z | 2018 | 10 | 2018-10-31T04:00:00Z | 2018-12-01T04:59:59Z | 2018-10-31T12:22:52Z | 2018-23815 | 0 | 0 | 0900006483873227 |
| TSA-2004-19147-0424 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | Memo for Record to Docket on Meeting of May 23, 2018, with FSANA on Reopening Comment Period | Supporting & Related Material | Supplement | 2018-07-10T04:00:00Z | 2018 | 7 | 2018-07-10T18:18:18Z | 0 | 0 | 09000064834cbbe1 | |||
| TSA-2004-19147-0422 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Flight Training for Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees | Notice | 60 Day Proposed Information Collection | 2018-07-06T04:00:00Z | 2018 | 7 | 2018-07-06T04:00:00Z | 2018-09-05T03:59:59Z | 2018-09-05T01:04:29Z | 2018-14482 | 0 | 0 | 09000064834b4abe |
| TSA-2004-19147-0423 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | 60DY PRA Notice: Intent to Request Revision From OMB of One Current Public Collection of Information: Flight Training for Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees (Original) | Other | Supplement (SUP) | 2018-07-06T04:00:00Z | 2018 | 7 | 2018-07-06T04:00:00Z | 2018-07-06T17:10:21Z | 0 | 0 | 09000064834b75fa | ||
| TSA-2004-19147-0370 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | Interim Final Rule; Reopening of Comment Period (Original) | Other | Supplement (SUP) | 2018-05-21T04:00:00Z | 2018 | 5 | 2018-05-21T04:00:00Z | 2018-05-21T12:53:25Z | 0 | 0 | 09000064832800d7 | ||
| TSA-2004-19147-0369 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | Flight Training for Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees; Reopening of Comment Period | Rule | Final Rule with Request for Comments | 2018-05-18T04:00:00Z | 2018 | 5 | 2018-05-18T04:00:00Z | 2018-06-19T03:59:59Z | 2018-06-20T01:04:13Z | 2018-10637 | 0 | 0 | 090000648327d7d8 |
| TSA-2004-19147-0368 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Flight Training for Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees | Notice | 30 Day Proposed Information Collection | 2015-06-18T04:00:00Z | 2015 | 6 | 2015-06-18T04:00:00Z | 2015-07-21T03:59:59Z | 2015-06-18T14:00:50Z | 2015-14976 | 0 | 0 | 0900006481b44c19 |
| TSA-2004-19147-0367 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | Intent to Request Renewal From OMB of One Current Public Collection of Information: Flight Training for Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees | Other | Supplement (SUP) | 2015-04-16T04:00:00Z | 2015 | 4 | 2015-04-16T04:00:00Z | 2015-04-16T12:59:10Z | 0 | 0 | 0900006481a98433 | ||
| TSA-2004-19147-0366 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Flight Training for Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees | Notice | 60 Day Proposed Information Collection | 2015-03-10T04:00:00Z | 2015 | 3 | 2015-03-10T04:00:00Z | 2015-05-12T03:59:59Z | 2015-03-10T14:29:42Z | 2015-05465 | 0 | 0 | 0900006481a37b05 |
| TSA-2004-19147-0365 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | Notice; 30Day PRA: Extension of Agency Information Collection Activity Under OMB Review: Flight Training for Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees (Original) | Notice | 30 Day Proposed Information Collection | 2012-02-01T05:00:00Z | 2012 | 2 | 2012-02-01T05:00:00Z | 2012-02-01T15:51:00Z | 0 | 0 | 0900006480faad3f | ||
| TSA-2004-19147-0364 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Flight Training for Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees (Federal Register Publication) | Notice | Request for Comments | 2012-01-31T05:00:00Z | 2012 | 1 | 2012-01-31T05:00:00Z | 2012-03-02T04:59:59Z | 2012-02-01T14:21:59Z | 2012-02024 | 0 | 0 | 0900006480fa985f |
| TSA-2004-19147-0362 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Flight Training for Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees (Federal Register Publication) | Notice | Notice of Change | 2011-09-21T04:00:00Z | 2011 | 9 | 2011-09-21T04:00:00Z | 2011-11-22T04:59:59Z | 2024-11-12T05:02:31Z | 2011-24158 | 1 | 0 | 0900006480f256ef |
| TSA-2004-19147-0361 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | 60Day PRA: Intent to Request Renewal From OMB of One Current Public Collection of Information: Flight Training for Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees (Original) | Other | OMB Review | 2011-09-19T04:00:00Z | 2011 | 9 | 2011-09-19T04:00:00Z | 2011-09-19T17:36:45Z | 0 | 0 | 0900006480f221b1 | ||
| TSA-2004-19147-0360 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | Intent To Request Renewal From OMB of One Current Public Collection of Information: Flight Training for Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees (Federal Register Publication) | Notice | Notice | 2009-10-27T04:00:00Z | 2009 | 10 | 2009-10-27T04:00:00Z | 2009-12-29T04:59:59Z | 2009-10-27T18:36:40Z | E9-25758 | 0 | 0 | 0900006480a4bfd2 |
| TSA-2004-19147-0348 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | Alien Flight Student Progra Recurrent Training Fees (Original) | Other | Other | 2009-04-22T04:00:00Z | 2009 | 4 | 2009-04-22T04:00:00Z | 2009-04-22T12:13:26Z | 0 | 0 | 0900006480963a39 | ||
| TSA-2004-19147-0347 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | Alien Flight Student Program Recurrent Training Fees (Federal Register Publication) | Notice | Notice | 2009-04-13T04:00:00Z | 2009 | 4 | 2009-04-13T04:00:00Z | 2011-06-11T18:01:53Z | E9-08349 | 0 | 0 | 09000064809519dd | |
| TSA-2004-19147-0346 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | Extension of Agency Information Collection Activity Under OMB Review: Flight Training for Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees (Original) | Notice | Notice | 2008-09-03T04:00:00Z | 2008 | 9 | 2008-09-03T04:00:00Z | 2024-11-07T21:54:18Z | 1 | 0 | 09000064806eebfd | ||
| TSA-2004-19147-0345 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | Extension of Agency Information Collection Activity Under OMB Review: Flight Training for Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees (Federal Register Publication) | Notice | Notice | 2008-08-13T04:00:00Z | 2008 | 8 | 2008-08-13T04:00:00Z | 2008-09-13T03:59:59Z | 2024-11-12T04:16:18Z | E8-18737 | 1 | 0 | 09000064806c1170 |
| TSA-2004-19147-0344 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | U.S. DHS/TSA - OMB 1652-0021 PRA 60DY Renewal Notice; Flight Training for Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees (Original) | Notice | Notice | 2008-06-18T04:00:00Z | 2008 | 6 | 2008-06-18T04:00:00Z | 2008-06-18T12:04:27Z | 0 | 0 | 090000648062cbfb | ||
| TSA-2004-19147-0343 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | Intent To Request Renewal From OMB of One Current Public Collection of Information: Flight Training for Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees (Fed. Reg. Publ.) | Notice | Notice | 2008-06-06T04:00:00Z | 2008 | 6 | 2008-06-06T04:00:00Z | 2008-08-09T03:59:59Z | 2008-06-17T23:20:05Z | E8-12755 | 0 | 0 | 090000648061430c |
| TSA-2004-19147-0341 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | U.S. DHS/TSA - Notice - (OFR Publication) OMB 1652-0021 PRA 30DY Renewal Notice; Flight Training for Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees | Notice | Notice | 2005-03-30T05:00:00Z | 2005 | 3 | 2005-03-30T05:00:00Z | 2005-03-31T04:59:59Z | 2024-11-07T17:09:16Z | 1 | 0 | 09000064802bfb91 | |
| TSA-2004-19147-0340 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | U.S. DHS/TSA HQ - OMB 1652-0021 PRA 30DY Renewal Notice; Flight Training for Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees (Original) | Notice | Notice | 2005-03-25T05:00:00Z | 2005 | 3 | 2005-03-25T05:00:00Z | 2005-03-26T04:59:59Z | 2024-11-07T17:09:16Z | 1 | 0 | 09000064802bfb90 | |
| TSA-2004-19147-0339 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | U.S. DHS/TSA HQ - Notice - (Original) OMB 1652-0021 PRA 60DY Renewal Notice; Flight Training for Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees (Original) | Notice | Notice | 2005-03-25T05:00:00Z | 2005 | 3 | 2005-03-25T05:00:00Z | 2005-03-26T04:59:59Z | 2024-11-07T17:09:16Z | 1 | 0 | 09000064802bfb8e | |
| TSA-2004-19147-0337 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | U.S. DHS/TSA HQ - Response - Interpretation of "Flight Training" for Aircraft with an MTOW of 12,500 Pounds or Less and Exemption from Certain "Recurrent Training" Information Submission Requirements Contained in 49 CFR part 1552" | Supporting & Related Material | Supplement | 2005-01-05T05:00:00Z | 2005 | 1 | 2024-11-07T17:09:02Z | 0 | 0 | 09000064802bfb8c | |||
| TSA-2004-19147-0338 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | U.S. DHS/TSA HQ - OMB 1652-0021 PRA 60DY Renewal Notice; Flight Training for Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees | Notice | Notice | 2004-11-26T05:00:00Z | 2004 | 11 | 2004-11-26T05:00:00Z | 2004-11-27T04:59:59Z | 2024-11-07T17:09:03Z | 1 | 0 | 09000064802bfb8d | |
| TSA-2004-19147-0333 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | U.S. DHS/TSA HQ - Meeting with Aircraft Owners and Pilot Association | Supporting & Related Material | Supplement | 2004-11-19T05:00:00Z | 2004 | 11 | 2024-11-07T17:09:02Z | 0 | 0 | 09000064802bfb88 | |||
| TSA-2004-19147-0330 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | U.S. DHS/TSA HQ, Office of the Chief Counsel, TSA-2 - Meeting with Aircraft Owners and Pilots Association | Supporting & Related Material | Supplement | 2004-11-16T05:00:00Z | 2004 | 11 | 2024-11-07T17:09:02Z | 0 | 0 | 09000064802bfb85 | |||
| TSA-2004-19147-0331 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | U.S. DHS/TSA HQ - Meeting Summary with Flight School Industry Representatives | Supporting & Related Material | Supplement | 2004-11-16T05:00:00Z | 2004 | 11 | 2024-11-07T17:09:02Z | 0 | 0 | 09000064802bfb86 | |||
| TSA-2004-19147-0324 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | U.S. DHS/TSA HQ - Notice | Notice | Notice | 2004-10-29T04:00:00Z | 2004 | 10 | 2004-10-29T04:00:00Z | 2004-10-30T03:59:59Z | 2024-11-08T04:31:28Z | 1 | 0 | 09000064802bfb7e | |
| TSA-2004-19147-0321 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | U.S. DHS/TSA Meeting with Aircraft Owners Representatives | Supporting & Related Material | Supplement | 2004-10-25T04:00:00Z | 2004 | 10 | 2024-11-08T04:31:28Z | 0 | 0 | 09000064802bfb7b | |||
| TSA-2004-19147-0319 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | U.S./DHS/TSA - Meeting with Flight School Industry Representatives | Supporting & Related Material | Supplement | 2004-10-25T04:00:00Z | 2004 | 10 | 2024-11-08T04:31:28Z | 0 | 0 | 09000064802bfb78 | |||
| TSA-2004-19147-0320 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | U.S. DHS/TSA - Meeting with the Aircraft Owners and Pilots Association | Supporting & Related Material | Supplement | 2004-10-25T04:00:00Z | 2004 | 10 | 2024-11-08T04:31:28Z | 0 | 0 | 09000064802bfb7a | |||
| TSA-2004-19147-0226 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | U.S. DHS/TSA HQ - Interpretation of Certain Definitions and Exemptions from Certain Requirements Contained in 49 CFR Part 1552 | Supporting & Related Material | Supplement | 2004-10-20T04:00:00Z | 2004 | 10 | 2024-11-07T17:10:54Z | 0 | 0 | 09000064802bfb0e | |||
| TSA-2004-19147-0227 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | U.S. DHS/TSA - Response to AOPA's Request for Clarification of Several Provisions in the Alien Pilot IFR | Supporting & Related Material | Supplement | 2004-10-20T04:00:00Z | 2004 | 10 | 2024-11-07T17:10:54Z | 0 | 0 | 09000064802bfb0f | |||
| TSA-2004-19147-0215 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | U.S. DHS/TSA - Interpretative Response to University Aviation Association | Supporting & Related Material | Supplement | 2004-10-19T04:00:00Z | 2004 | 10 | 2024-11-07T17:10:40Z | 0 | 0 | 09000064802bfb00 | |||
| TSA-2004-19147-0001 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | U.S. DOT/TSA - Interim Final Rule; Request for Comments (Fed. Reg. Publ.) | Rule | Federal Register Publication | 2004-09-20T04:00:00Z | 2004 | 9 | 2004-09-20T04:00:00Z | 2004-09-21T03:59:59Z | 2024-11-08T04:30:11Z | 1 | 0 | 09000064802bfa63 | |
| TSA-2004-19147-0003 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | U.S. DOT/TSA- Fee Report for Flight Training for Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees | Supporting & Related Material | Supplement | 2004-09-20T04:00:00Z | 2004 | 9 | 2024-11-08T04:30:54Z | 0 | 0 | 09000064802bfb63 | |||
| TSA-2004-19147-0004 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | U.S. DOT/TSA - Interim Final Rule; Request for Comments (Original) | Other | Other | 2004-09-20T04:00:00Z | 2004 | 9 | 2004-09-20T04:00:00Z | 2004-09-21T03:59:59Z | 2024-11-07T17:09:16Z | 1 | 0 | 09000064802bfb98 | |
| TSA-2004-19147-0002 | TSA | Flight Training For Aliens and Other Designated Individuals; Security Awareness Training for Flight School Employees TSA-2004-19147 | U.S. DOT/TSA - Draft Preliminary Regulatory Evaluation. Regulatory Flexibility Determination, Trade Impact Assessment, and Unfunded Manages Assessment | Supporting & Related Material | Supplement | 2004-09-20T04:00:00Z | 2004 | 9 | 2024-11-07T17:10:12Z | 0 | 0 | 09000064802bfadf |
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;