documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
7 rows where docket_id = "FMCSA-1997-2210" and posted_year = 2002 sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FMCSA-1997-2210-0104 | FMCSA | Notice - Commercial Driver Physical Qualifications as Part of the Commercial Driver's License Process FMCSA-1997-2210 | Notice of First Meeting of Negotiated Rulemaking Advisory Committee, July 23, 1996 | Rule | Federal Register Publication | 2002-05-22T04:00:00Z | 2002 | 5 | 2002-05-22T04:00:00Z | 1997-03-25T04:59:59Z | 2019-09-04T13:25:39Z | 0 | 0 | 09000064802a349e | |
| FMCSA-1997-2210-0099 | FMCSA | Notice - Commercial Driver Physical Qualifications as Part of the Commercial Driver's License Process FMCSA-1997-2210 | Notice of Intent to Form a Negotiated Rulemaking Committee on Commercial Driver License and Physical Qualifications Requirements | Rule | Federal Register Publication | 2002-05-22T04:00:00Z | 2002 | 5 | 2002-05-22T04:00:00Z | 1997-03-25T04:59:59Z | 2019-09-04T13:24:53Z | 0 | 0 | 09000064802a3566 | |
| FMCSA-1997-2210-0100 | FMCSA | Notice - Commercial Driver Physical Qualifications as Part of the Commercial Driver's License Process FMCSA-1997-2210 | Notice of Meeting of Negotiated Rulemaking Advisory Committee, November 5, 1996 | Rule | Federal Register Publication | 2002-05-22T04:00:00Z | 2002 | 5 | 2002-05-22T04:00:00Z | 1997-03-25T04:59:59Z | 2019-09-04T13:25:09Z | 0 | 0 | 09000064802a349a | |
| FMCSA-1997-2210-0103 | FMCSA | Notice - Commercial Driver Physical Qualifications as Part of the Commercial Driver's License Process FMCSA-1997-2210 | Notice of Meetings of Negotiated Rulemaking Advisory Committee, August 26, 1996 | Rule | Federal Register Publication | 2002-05-22T04:00:00Z | 2002 | 5 | 2002-05-22T04:00:00Z | 1997-03-25T04:59:59Z | 2019-09-04T13:25:32Z | 0 | 0 | 09000064802a349d | |
| FMCSA-1997-2210-0105 | FMCSA | Notice - Commercial Driver Physical Qualifications as Part of the Commercial Driver's License Process FMCSA-1997-2210 | Advance Notice of Proposed Rulemaking, July 15, 1994 | Rule | Federal Register Publication | 2002-05-22T04:00:00Z | 2002 | 5 | 2002-05-22T04:00:00Z | 1997-03-25T04:59:59Z | 2019-09-04T13:25:53Z | 0 | 0 | 09000064802a349f | |
| FMCSA-1997-2210-0101 | FMCSA | Notice - Commercial Driver Physical Qualifications as Part of the Commercial Driver's License Process FMCSA-1997-2210 | Notice of Meeting of Negotiated Rulemaking Advisory Committee, December 17, 1996 | Rule | Federal Register Publication | 2002-05-22T04:00:00Z | 2002 | 5 | 2002-05-22T04:00:00Z | 1997-03-25T04:59:59Z | 2019-09-04T13:25:17Z | 0 | 0 | 09000064802a349b | |
| FMCSA-1997-2210-0102 | FMCSA | Notice - Commercial Driver Physical Qualifications as Part of the Commercial Driver's License Process FMCSA-1997-2210 | Notice of Meeting of Negotiated Rulemaking Advisory Committee, October 7, 1996 | Rule | Federal Register Publication | 2002-05-22T04:00:00Z | 2002 | 5 | 2002-05-22T04:00:00Z | 1997-03-25T04:59:59Z | 2019-09-04T13:25:25Z | 0 | 0 | 09000064802a349c |
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;