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 = "HHS-2006-0196-0001"

✎ View and edit SQL

This data as json, CSV (advanced)

Link fr_document_number regs_document_id
E6-14908,HHS-2006-0196-0001 Office of Public Health Emergency Preparedness; Draft HHS Public Health Emergency Medical Countermeasures Enterprise (PHEMCE) Strategy for Chemical, Biological, Radiological and Nuclear (CBRN) Threats 1 E6-14908 \1\ This Strategy excludes pandemic influenza which is addressed in the HHS Pandemic Influenza Plan, a blueprint for pandemic influenza preparation and response. It provides guidance to national, state, and local policy makers and health departments. The HHS Pandemic Influenza Plan includes an overview of the threat of pandemic influenza, a description of the relationship of this document to other HHS-2006-0196-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);