documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
6 rows where docket_id = "FRA-2010-0058" and posted_year = 2016 sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: subtype, open_for_comment, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FRA-2010-0058-0019 | FRA | Canadian Pacific Railroad - Positive Train Control Plans FRA-2010-0058 | Canadian Pacific (CP) Q3 2016 Quarterly PTC Progress Report | Other | Report | 2016-11-18T05:00:00Z | 2016 | 11 | 2016-11-18T05:00:00Z | 2017-03-01T18:27:03Z | 0 | 0 | 09000064823a1311 | ||
| FRA-2010-0058-0018 | FRA | Canadian Pacific Railroad - Positive Train Control Plans FRA-2010-0058 | Canadian Pacific (CP) Q1/Q2 2016 Quarterly PTC Progress Report | Other | Report | 2016-09-13T04:00:00Z | 2016 | 9 | 2016-09-13T04:00:00Z | 2017-03-01T18:33:00Z | 0 | 0 | 0900006482206dc4 | ||
| FRA-2010-0058-0017 | FRA | Canadian Pacific Railroad - Positive Train Control Plans FRA-2010-0058 | U.S. DOT/FRA- Final Letter | Other | Letter(s) | 2016-07-18T04:00:00Z | 2016 | 7 | 2016-07-18T04:00:00Z | 2024-11-07T23:46:20Z | 1 | 0 | 09000064820bada7 | ||
| FRA-2010-0058-0016 | FRA | Canadian Pacific Railroad - Positive Train Control Plans FRA-2010-0058 | Approval and System Certification of CP Safety Plan (PTCSP) Version 1.0 | Notice | Notice of Availability | 2016-06-15T04:00:00Z | 2016 | 6 | 2016-06-15T04:00:00Z | 2024-11-12T06:09:52Z | 2016-14123 | 1 | 0 | 090000648203d4cb | |
| FRA-2010-0058-0015 | FRA | Canadian Pacific Railroad - Positive Train Control Plans FRA-2010-0058 | Canadian Pacific (CP) 2015 PTC Progress Report | Other | Report | 2016-04-29T04:00:00Z | 2016 | 4 | 2016-04-29T04:00:00Z | 2017-03-01T18:27:39Z | 0 | 0 | 0900006481f99075 | ||
| FRA-2010-0058-0014 | FRA | Canadian Pacific Railroad - Positive Train Control Plans FRA-2010-0058 | U.S. DOT/FRA- Conditional Approval Letter | Other | Letter(s) | 2016-02-09T05:00:00Z | 2016 | 2 | 2016-02-09T05:00:00Z | 2024-11-12T05:51:57Z | 1 | 0 | 0900006481e58d97 |
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;