documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
7 rows where docket_id = "FRA-2010-0039" and posted_year = 2017 sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: subtype, posted_date, posted_month, comment_start_date, 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-0039-0016 | FRA | South Florida Regional Transportation Authority (SFRV) “Tri-Rail” FRA-2010-0039 | South Florida Regional Transportation Authority (SFRV/Tri-Rail) Q3 2017 PTC Progress Report | Other | Report | 2017-11-30T05:00:00Z | 2017 | 11 | 2017-11-30T05:00:00Z | 2017-11-30T20:23:30Z | 0 | 0 | 0900006482cc5cea | ||
| FRA-2010-0039-0017 | FRA | South Florida Regional Transportation Authority (SFRV) “Tri-Rail” FRA-2010-0039 | Response to SFRTA's Request for Alternative Schedule and Sequence - RSD testing territory request | Other | Response(s) | 2017-11-30T05:00:00Z | 2017 | 11 | 2017-11-30T05:00:00Z | 2024-11-07T01:12:17Z | 1 | 0 | 0900006482cc5fdb | ||
| FRA-2010-0039-0015 | FRA | South Florida Regional Transportation Authority (SFRV) “Tri-Rail” FRA-2010-0039 | South Florida Regional Transportation Authority (SFRV/Tri-Rail) Q2 2017 PTC Progress Report | Other | Report | 2017-08-15T04:00:00Z | 2017 | 8 | 2017-08-15T04:00:00Z | 2017-08-15T15:37:09Z | 0 | 0 | 0900006482a32dc6 | ||
| FRA-2010-0039-0014 | FRA | South Florida Regional Transportation Authority (SFRV) “Tri-Rail” FRA-2010-0039 | South Florida Regional Transportation Authority (SFRV) Q1 2017 PTC Progress Report | Other | Report | 2017-05-17T04:00:00Z | 2017 | 5 | 2017-05-17T04:00:00Z | 2017-05-17T13:50:45Z | 0 | 0 | 09000064825d05d5 | ||
| FRA-2010-0039-0013 | FRA | South Florida Regional Transportation Authority (SFRV) “Tri-Rail” FRA-2010-0039 | South Florida Regional Transportation Authority (SFRTA/Tri-Rail) 2016 Annual PTC Progress Report | Other | Report | 2017-04-25T04:00:00Z | 2017 | 4 | 2017-04-25T04:00:00Z | 2017-04-25T17:51:06Z | 0 | 0 | 0900006482574355 | ||
| FRA-2010-0039-0012 | FRA | South Florida Regional Transportation Authority (SFRV) “Tri-Rail” FRA-2010-0039 | South Florida Regional Transportation Authority (SFRV) PTC Implementation Plan (PTCIP) Version 5.0 | Other | Report | 2017-03-10T05:00:00Z | 2017 | 3 | 2017-03-10T05:00:00Z | 2017-03-10T18:19:51Z | 0 | 0 | 090000648250070f | ||
| FRA-2010-0039-0011 | FRA | South Florida Regional Transportation Authority (SFRV) “Tri-Rail” FRA-2010-0039 | South Florida Regional Transportation Authority (SFRTA/Tri-Rail) Q4 2016 Quarterly PTC Progress Report | Other | Report | 2017-02-16T05:00:00Z | 2017 | 2 | 2017-02-16T05:00:00Z | 2017-02-16T15:00:07Z | 0 | 0 | 09000064824c701a |
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;