fr_regs_crossref

Cross-reference linking Federal Register document numbers to Regulations.gov document IDs.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

25 rows where fr_document_number = "2019-19283"

✎ View and edit SQL

This data as json, CSV (advanced)

Link fr_document_number regs_document_id
2019-19283,FMCSA-2001-9561-0074 Qualification of Drivers; Exemption Applications; Vision 2019-19283 Qualification of Drivers; Exemption Applications: Vision FMCSA-2001-9561-0074
2019-19283,FMCSA-2003-15892-0058 Qualification of Drivers; Exemption Applications; Vision 2019-19283 Qualification of Drivers; Exemption Applications: Vision FMCSA-2003-15892-0058
2019-19283,FMCSA-2005-20560-0078 Qualification of Drivers; Exemption Applications; Vision 2019-19283 Qualification of Drivers; Exemption Applications: Vision FMCSA-2005-20560-0078
2019-19283,FMCSA-2005-21254-0053 Qualification of Drivers; Exemption Applications; Vision 2019-19283 Qualification of Drivers; Exemption Applications: Vision FMCSA-2005-21254-0053
2019-19283,FMCSA-2005-21711-0081 Qualification of Drivers; Exemption Applications; Vision 2019-19283 Qualification of Drivers; Exemption Applications: Vision FMCSA-2005-21711-0081
2019-19283,FMCSA-2007-27897-0090 Qualification of Drivers; Exemption Applications; Vision 2019-19283 Qualification of Drivers; Exemption Applications: Vision FMCSA-2007-27897-0090
2019-19283,FMCSA-2008-0266-0051 Qualification of Drivers; Exemption Applications; Vision 2019-19283 Qualification of Drivers; Exemption Applications: Vision FMCSA-2008-0266-0051
2019-19283,FMCSA-2009-0121-0029 Qualification of Drivers; Exemption Applications; Vision 2019-19283 Qualification of Drivers; Exemption Applications: Vision FMCSA-2009-0121-0029
2019-19283,FMCSA-2009-0154-0042 Qualification of Drivers; Exemption Applications; Vision 2019-19283 Qualification of Drivers; Exemption Applications: Vision FMCSA-2009-0154-0042
2019-19283,FMCSA-2010-0327-0023 Qualification of Drivers; Exemption Applications; Vision 2019-19283 Qualification of Drivers; Exemption Applications: Vision FMCSA-2010-0327-0023
2019-19283,FMCSA-2010-0385-0046 Qualification of Drivers; Exemption Applications; Vision 2019-19283 Qualification of Drivers; Exemption Applications: Vision FMCSA-2010-0385-0046
2019-19283,FMCSA-2011-0024-0027 Qualification of Drivers; Exemption Applications; Vision 2019-19283 Qualification of Drivers; Exemption Applications: Vision FMCSA-2011-0024-0027
2019-19283,FMCSA-2011-0092-0035 Qualification of Drivers; Exemption Applications; Vision 2019-19283 Qualification of Drivers; Exemption Applications: Vision FMCSA-2011-0092-0035
2019-19283,FMCSA-2011-0124-0023 Qualification of Drivers; Exemption Applications; Vision 2019-19283 Qualification of Drivers; Exemption Applications: Vision FMCSA-2011-0124-0023
2019-19283,FMCSA-2011-0140-0025 Qualification of Drivers; Exemption Applications; Vision 2019-19283 Qualification of Drivers; Exemption Applications: Vision FMCSA-2011-0140-0025
2019-19283,FMCSA-2011-0142-0025 Qualification of Drivers; Exemption Applications; Vision 2019-19283 Qualification of Drivers; Exemption Applications: Vision FMCSA-2011-0142-0025
2019-19283,FMCSA-2011-0189-0017 Qualification of Drivers; Exemption Applications; Vision 2019-19283 Qualification of Drivers; Exemption Applications: Vision FMCSA-2011-0189-0017
2019-19283,FMCSA-2013-0026-0010 Qualification of Drivers; Exemption Applications; Vision 2019-19283 Qualification of Drivers; Exemption Applications: Vision FMCSA-2013-0026-0010
2019-19283,FMCSA-2013-0027-0026 Qualification of Drivers; Exemption Applications; Vision 2019-19283 Qualification of Drivers; Exemption Applications: Vision FMCSA-2013-0027-0026
2019-19283,FMCSA-2013-0029-0032 Qualification of Drivers; Exemption Applications; Vision 2019-19283 Qualification of Drivers; Exemption Applications: Vision FMCSA-2013-0029-0032
2019-19283,FMCSA-2013-0030-0033 Qualification of Drivers; Exemption Applications; Vision 2019-19283 Qualification of Drivers; Exemption Applications: Vision FMCSA-2013-0030-0033
2019-19283,FMCSA-2013-0165-0029 Qualification of Drivers; Exemption Applications; Vision 2019-19283 Qualification of Drivers; Exemption Applications: Vision FMCSA-2013-0165-0029
2019-19283,FMCSA-2014-0302-0025 Qualification of Drivers; Exemption Applications; Vision 2019-19283 Qualification of Drivers; Exemption Applications: Vision FMCSA-2014-0302-0025
2019-19283,FMCSA-2015-0048-0013 Qualification of Drivers; Exemption Applications; Vision 2019-19283 Qualification of Drivers; Exemption Applications: Vision FMCSA-2015-0048-0013
2019-19283,FMCSA-2015-0049-0014 Qualification of Drivers; Exemption Applications; Vision 2019-19283 Qualification of Drivers; Exemption Applications: Vision FMCSA-2015-0049-0014

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE fr_regs_crossref (
    fr_document_number TEXT REFERENCES federal_register(document_number),
    regs_document_id TEXT REFERENCES documents(id),
    PRIMARY KEY (fr_document_number, regs_document_id)
);
CREATE INDEX idx_crossref_fr ON fr_regs_crossref(fr_document_number);
CREATE INDEX idx_crossref_regs ON fr_regs_crossref(regs_document_id);