federal_register_agencies

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

2 rows where document_number = "E8-29673"

✎ View and edit SQL

This data as json, CSV (advanced)

Link document_number agency_id
E8-29673,197 Endangered and Threatened Wildlife and Plants; 12-Month Finding on a Petition To List Four Penguin Species as Threatened or Endangered Under the Endangered Species Act and Proposed Rule To List the Southern Rockhopper Penguin in the Campbell Plateau Portion of Its Range E8-29673 Fish and Wildlife Service 197
E8-29673,253 Endangered and Threatened Wildlife and Plants; 12-Month Finding on a Petition To List Four Penguin Species as Threatened or Endangered Under the Endangered Species Act and Proposed Rule To List the Southern Rockhopper Penguin in the Campbell Plateau Portion of Its Range E8-29673 Interior Department 253

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