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

1 row where regs_document_id = "EPA-R06-OAR-2014-0754-0045"

✎ View and edit SQL

This data as json, CSV (advanced)

Link fr_document_number regs_document_id
2015-01164,EPA-R06-OAR-2014-0754-0045 Approval and Promulgation of Implementation Plans; Texas and Oklahoma; Regional Haze State Implementation Plans; Interstate Transport State Implementation Plan To Address Pollution Affecting Visibility and Regional Haze; Federal Implementation Plan for Regional Haze and Interstate Transport of Pollution Affecting Visibility; Extension of Comment Period 2015-01164 TX166.045. Proposed rule, extension of comment period to April 20, 2015, RE: Texas and Oklahoma; Regional Haze SIP published December 16, 2014 (79 FR 74818) --- NOTE: Before or on February 17, 2015, please submit comments to document EPA-R06-OAR-2014-0754-0001. After February 17, 2015, comments submitted via Regulations.gov will have to be submitted to this Federal Register document. EPA-R06-OAR-2014-0754-0045

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);