federal_register_agencies

Junction table linking Federal Register documents to their publishing agencies.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

2 rows where document_number = "E7-4707"

✎ View and edit SQL

This data as json, CSV (advanced)

Link document_number agency_id
E7-4707,54 Implementation of Tariff Rate Quota Established Under Title V of the Trade and Development Act of 2000 as Amended by the Trade Act of 2002, the Miscellaneous Trade Act of 2004, and the Pension Protection Act of 2006, for Imports of Certain Worsted Wool; Proposed Collection Extension; Comment Request E7-4707 Commerce Department 54
E7-4707,261 Implementation of Tariff Rate Quota Established Under Title V of the Trade and Development Act of 2000 as Amended by the Trade Act of 2002, the Miscellaneous Trade Act of 2004, and the Pension Protection Act of 2006, for Imports of Certain Worsted Wool; Proposed Collection Extension; Comment Request E7-4707 International Trade Administration 261

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE federal_register_agencies (
    document_number TEXT REFERENCES federal_register(document_number),
    agency_id INTEGER REFERENCES agencies(id),
    PRIMARY KEY (document_number, agency_id)
);
CREATE INDEX idx_fra_agency ON federal_register_agencies(agency_id);