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 fr_document_number = "E7-25326"

✎ View and edit SQL

This data as json, CSV (advanced)

Link fr_document_number regs_document_id
E7-25326,FERC-2007-2149-0001 SBER Royal Mills, LLC; Notice of Application Tendered for Filing With the Commission, Soliciting Additional Study Requests, and Establishing a Deadline for Submission of Final Amendments E7-25326 December 19, 2007. Take notice that the following hydroelectric application has been filed with the Commission and is available for public inspection. a. Type of Application: Exemption From Licensing. b. Project No.: P-12557-001. c. Date Filed: December 12, 2007. d. Applicant: SBER Royal Mills, LLC. e. Name of Project: Royal Mills Hydroelectric Project. f. Location: On the South Bran FERC-2007-2149-0001

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