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 = "CDC-2019-0015-0019"

✎ View and edit SQL

This data as json, CSV (advanced)

Link fr_document_number regs_document_id
2022-14906,CDC-2019-0015-0019 Publication of Skin Notation Profile Documents for Chlorodiphenyl (54% Chlorine) (CAS: 11097-69-1), Diacetyl and 2,3-Pentanedione (CAS: 431-03-8; 600-14-6), Dioxane (CAS: 123-91-1), Beta Chloroprene (CAS: 126-99-8), and 2,4-Toluene Diisocyanate, 2,6-Toluene Diisocyanate, and 2,4- and 2,6-Toluene Diisocyanate Mixture (CAS: 584-84-9; 91-08-7; 26471-62-5 (as a Mixture)) 2022-14906 Publication of Skin Notation Profile Documents for Chlorodiphenyl (54% Chlorine) (CAS: 11097–69–1), Diacetyl and 2,3-Pentanedione (CAS: 431–03–8; 600–14–6), Dioxane (CAS: 123–91–1), Beta Chloroprene(CAS: 126–99–8), and 2,4-Toluene Diisocyanate, 2,6- Toluene Diisocyanate, and 2,4- and 2,6- Toluene Diisocyanate Mixture (CAS: 584–84–9; 91–08–7; 26471–62–5) CDC-2019-0015-0019

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