documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
10 rows where docket_id = "DOT-OST-1995-825" sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: subtype, posted_date, posted_month, comment_start_date, comment_end_date, last_modified, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DOT-OST-1995-825-0010 | DOT | Mexicargo S.A. de C.V. - Exemption - Mexico - U.S. DOT-OST-1995-825 | Mexicargo, S.A. DE C.V. - Exemption/Renewal - Mexico-United States All-Cargo Charter | Other | Application-Other | 1998-12-09T05:00:00Z | 1998 | 12 | 1998-12-09T05:00:00Z | 1999-01-05T04:59:59Z | 2024-11-12T02:34:28Z | 1 | 0 | 090000648030d73d | |
| DOT-OST-1995-825-0009 | DOT | Mexicargo S.A. de C.V. - Exemption - Mexico - U.S. DOT-OST-1995-825 | 98-2-2 Order | Other | Order | 1998-02-04T05:00:00Z | 1998 | 2 | 1998-02-04T05:00:00Z | 1998-02-27T04:59:59Z | 2024-11-12T02:34:45Z | 1 | 0 | 090000648030d745 | |
| DOT-OST-1995-825-0008 | DOT | Mexicargo S.A. de C.V. - Exemption - Mexico - U.S. DOT-OST-1995-825 | Notice of Action Taken re: Mexicargo, S.A. de C.V. | Notice | Notice | 1998-01-05T05:00:00Z | 1998 | 1 | 1998-01-05T05:00:00Z | 1998-01-06T04:59:59Z | 2024-11-12T02:34:45Z | 1 | 0 | 090000648030d744 | |
| DOT-OST-1995-825-0007 | DOT | Mexicargo S.A. de C.V. - Exemption - Mexico - U.S. DOT-OST-1995-825 | Mexicargo, S.A. de C.V. - Exemption/Renewal - All Cargo Charters - Mexico-United States | Other | Application-Other | 1997-11-24T05:00:00Z | 1997 | 11 | 1997-11-24T05:00:00Z | 1997-11-25T04:59:59Z | 2024-11-12T02:34:45Z | 1 | 0 | 090000648030d743 | |
| DOT-OST-1995-825-0006 | DOT | Mexicargo S.A. de C.V. - Exemption - Mexico - U.S. DOT-OST-1995-825 | 97-3-13 Order | Other | Order | 1997-03-12T05:00:00Z | 1997 | 3 | 1997-03-12T05:00:00Z | 1997-03-13T04:59:59Z | 2024-11-12T02:34:45Z | 1 | 0 | 090000648030d742 | |
| DOT-OST-1995-825-0005 | DOT | Mexicargo S.A. de C.V. - Exemption - Mexico - U.S. DOT-OST-1995-825 | Notice of Action Taken re Mexicargo, S.A. de C.V. | Notice | Notice | 1996-12-10T05:00:00Z | 1996 | 12 | 1996-12-10T05:00:00Z | 1996-12-11T04:59:59Z | 2024-11-12T02:34:45Z | 1 | 0 | 090000648030d741 | |
| DOT-OST-1995-825-0004 | DOT | Mexicargo S.A. de C.V. - Exemption - Mexico - U.S. DOT-OST-1995-825 | Mexicargo, S.A. de C.V. - Renewal/Exemption - All-Cargo Charters | Other | Application-Other | 1996-11-08T05:00:00Z | 1996 | 11 | 1996-11-08T05:00:00Z | 1996-11-09T04:59:59Z | 2024-11-12T02:34:44Z | 1 | 0 | 090000648030d740 | |
| DOT-OST-1995-825-0003 | DOT | Mexicargo S.A. de C.V. - Exemption - Mexico - U.S. DOT-OST-1995-825 | 96-1-45 Order | Other | Order | 1996-02-05T05:00:00Z | 1996 | 2 | 1996-02-05T05:00:00Z | 1996-02-06T04:59:59Z | 2024-11-12T02:34:44Z | 1 | 0 | 090000648030d73f | |
| DOT-OST-1995-825-0001 | DOT | Mexicargo S.A. de C.V. - Exemption - Mexico - U.S. DOT-OST-1995-825 | Mexicargo S.A. de C.V. - Exemption - Mexico - U.S. | Other | Application-Other | 1995-11-13T05:00:00Z | 1995 | 11 | 1995-11-13T05:00:00Z | 1995-11-14T04:59:59Z | 2024-11-12T02:34:27Z | 1 | 0 | 090000648030d73c | |
| DOT-OST-1995-825-0002 | DOT | Mexicargo S.A. de C.V. - Exemption - Mexico - U.S. DOT-OST-1995-825 | Notice of Action Taken regarding Mexicargo, S.A. de C.V. | Notice | Notice | 1995-11-13T05:00:00Z | 1995 | 11 | 1995-11-13T05:00:00Z | 1995-11-14T04:59:59Z | 2024-11-12T02:34:28Z | 1 | 0 | 090000648030d73e |
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;