federal_register_agencies
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
2 rows where document_number = "97-34032"
This data as json, CSV (advanced)
| Link | document_number | agency_id |
|---|---|---|
| 97-34032,12 | Dairy Indemnity Payment Program 97-34032 | Agriculture Department 12 |
| 97-34032,157 | Dairy Indemnity Payment Program 97-34032 | Farm Service Agency 157 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);