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

4 rows where fr_document_number = "2025-01866"

✎ View and edit SQL

This data as json, CSV (advanced)

Link fr_document_number regs_document_id
2025-01866,EPA-HQ-OAR-2022-0872-0102 Delay of Effective Date for 4 Final Regulations Published by the Environmental Protection Agency Between November 29, 2024, and December 31, 2024 2025-01866 Delay of Effective Date for 4 Final Regulations Published between November 29, 2024, and December 31, 2024 EPA-HQ-OAR-2022-0872-0102
2025-01866,EPA-HQ-OPPT-2020-0642-0730 Delay of Effective Date for 4 Final Regulations Published by the Environmental Protection Agency Between November 29, 2024, and December 31, 2024 2025-01866 Delay of Effective Date for 4 Final Regulations Published between November 29, 2024, and December 31, 2024 EPA-HQ-OPPT-2020-0642-0730
2025-01866,EPA-R05-OAR-2023-0498-0007 Delay of Effective Date for 4 Final Regulations Published by the Environmental Protection Agency Between November 29, 2024, and December 31, 2024 2025-01866 Delay of Effective Date for 4 Final Regulations Published between November 29, 2024, and December 31, 2024 EPA-R05-OAR-2023-0498-0007
2025-01866,EPA-R09-OAR-2023-0649-0012 Delay of Effective Date for 4 Final Regulations Published by the Environmental Protection Agency Between November 29, 2024, and December 31, 2024 2025-01866 Delay of Effective Date for 4 Final Regulations Published between November 29, 2024, and December 31, 2024 EPA-R09-OAR-2023-0649-0012

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 357.517ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API