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

1 row where document_number = "E8-22942"

✎ View and edit SQL

This data as json, CSV (advanced)

Link document_number agency_id
E8-22942,178 City of Los Angeles, CA, Harbor Department of the City of Los Angeles, Board of Harbor Commissioners of the City of Los Angeles, City of Long Beach, California, Harbor Department of the City of Long Beach, and the Board of Harbor Commissioners of the City of Long Beach-Possible Violations of Sections 10(B)(10), 10(D)(1) and 10(D)(4) of the Shipping Act of 1984; Order of Investigation and Hearing E8-22942 Federal Maritime Commission 178

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