home / openregs

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

24 rows where fr_document_number = "2016-08058"

✎ View and edit SQL

This data as json, CSV (advanced)

Link fr_document_number regs_document_id
2016-08058,FMCSA-1999-5748-0104 Qualification of Drivers; Exemption Applications; Vision 2016-08058 Qualification of Drivers; Exemption Applications: Vision FMCSA-1999-5748-0104
2016-08058,FMCSA-1999-6480-0098 Qualification of Drivers; Exemption Applications; Vision 2016-08058 Qualification of Drivers; Exemption Applications: Vision FMCSA-1999-6480-0098
2016-08058,FMCSA-2003-15892-0043 Qualification of Drivers; Exemption Applications; Vision 2016-08058 Qualification of Drivers; Exemption Applications: Vision FMCSA-2003-15892-0043
2016-08058,FMCSA-2003-16241-0043 Qualification of Drivers; Exemption Applications; Vision 2016-08058 Qualification of Drivers; Exemption Applications: Vision FMCSA-2003-16241-0043
2016-08058,FMCSA-2003-16564-0050 Qualification of Drivers; Exemption Applications; Vision 2016-08058 Qualification of Drivers; Exemption Applications: Vision FMCSA-2003-16564-0050
2016-08058,FMCSA-2005-22194-0080 Qualification of Drivers; Exemption Applications; Vision 2016-08058 Qualification of Drivers; Exemption Applications: Vision FMCSA-2005-22194-0080
2016-08058,FMCSA-2005-23099-0042 Qualification of Drivers; Exemption Applications; Vision 2016-08058 Qualification of Drivers; Exemption Applications: Vision FMCSA-2005-23099-0042
2016-08058,FMCSA-2005-23238-0035 Qualification of Drivers; Exemption Applications; Vision 2016-08058 Qualification of Drivers; Exemption Applications: Vision FMCSA-2005-23238-0035
2016-08058,FMCSA-2006-23773-0046 Qualification of Drivers; Exemption Applications; Vision 2016-08058 Qualification of Drivers; Exemption Applications: Vision FMCSA-2006-23773-0046
2016-08058,FMCSA-2007-0071-0025 Qualification of Drivers; Exemption Applications; Vision 2016-08058 Qualification of Drivers; Exemption Applications: Vision FMCSA-2007-0071-0025
2016-08058,FMCSA-2007-28695-0018 Qualification of Drivers; Exemption Applications; Vision 2016-08058 Qualification of Drivers; Exemption Applications: Vision FMCSA-2007-28695-0018
2016-08058,FMCSA-2008-0231-0023 Qualification of Drivers; Exemption Applications; Vision 2016-08058 Qualification of Drivers; Exemption Applications: Vision FMCSA-2008-0231-0023
2016-08058,FMCSA-2009-0011-0010 Qualification of Drivers; Exemption Applications; Vision 2016-08058 Qualification of Drivers; Exemption Applications: Vision FMCSA-2009-0011-0010
2016-08058,FMCSA-2009-0086-0013 Qualification of Drivers; Exemption Applications; Vision 2016-08058 Qualification of Drivers; Exemption Applications: Vision FMCSA-2009-0086-0013
2016-08058,FMCSA-2009-0154-0022 Qualification of Drivers; Exemption Applications; Vision 2016-08058 Qualification of Drivers; Exemption Applications: Vision FMCSA-2009-0154-0022
2016-08058,FMCSA-2009-0291-0014 Qualification of Drivers; Exemption Applications; Vision 2016-08058 Qualification of Drivers; Exemption Applications: Vision FMCSA-2009-0291-0014
2016-08058,FMCSA-2009-0321-0024 Qualification of Drivers; Exemption Applications; Vision 2016-08058 Qualification of Drivers; Exemption Applications: Vision FMCSA-2009-0321-0024
2016-08058,FMCSA-2011-0299-0007 Qualification of Drivers; Exemption Applications; Vision 2016-08058 Qualification of Drivers; Exemption Applications: Vision FMCSA-2011-0299-0007
2016-08058,FMCSA-2011-0324-0006 Qualification of Drivers; Exemption Applications; Vision 2016-08058 Qualification of Drivers; Exemption Applications: Vision FMCSA-2011-0324-0006
2016-08058,FMCSA-2011-0365-0006 Qualification of Drivers; Exemption Applications; Vision 2016-08058 Qualification of Drivers; Exemption Applications: Vision FMCSA-2011-0365-0006
2016-08058,FMCSA-2011-0366-0005 Qualification of Drivers; Exemption Applications; Vision 2016-08058 Qualification of Drivers; Exemption Applications: Vision FMCSA-2011-0366-0005
2016-08058,FMCSA-2011-0378-0005 Qualification of Drivers; Exemption Applications; Vision 2016-08058 Qualification of Drivers; Exemption Applications: Vision FMCSA-2011-0378-0005
2016-08058,FMCSA-2013-0170-0008 Qualification of Drivers; Exemption Applications; Vision 2016-08058 Qualification of Drivers; Exemption Applications: Vision FMCSA-2013-0170-0008
2016-08058,FMCSA-2014-0002-0005 Qualification of Drivers; Exemption Applications; Vision 2016-08058 Qualification of Drivers; Exemption Applications: Vision FMCSA-2014-0002-0005

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);
Powered by Datasette · Queries took 3.562ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API