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

7 rows where document_number = "2016-16459"

✎ View and edit SQL

This data as json, CSV (advanced)

Link document_number agency_id
2016-16459,80 Announcement of Office of Management and Budget's Approval of Collection of Information Contained in “Final Interagency Policy Statement Establishing Joint Standards for Assessing the Diversity Policies and Practices of Entities Regulated by the Agencies.” 2016-16459 Comptroller of the Currency 80
2016-16459,164 Announcement of Office of Management and Budget's Approval of Collection of Information Contained in “Final Interagency Policy Statement Establishing Joint Standards for Assessing the Diversity Policies and Practices of Entities Regulated by the Agencies.” 2016-16459 Federal Deposit Insurance Corporation 164
2016-16459,188 Announcement of Office of Management and Budget's Approval of Collection of Information Contained in “Final Interagency Policy Statement Establishing Joint Standards for Assessing the Diversity Policies and Practices of Entities Regulated by the Agencies.” 2016-16459 Federal Reserve System 188
2016-16459,335 Announcement of Office of Management and Budget's Approval of Collection of Information Contained in “Final Interagency Policy Statement Establishing Joint Standards for Assessing the Diversity Policies and Practices of Entities Regulated by the Agencies.” 2016-16459 National Credit Union Administration 335
2016-16459,466 Announcement of Office of Management and Budget's Approval of Collection of Information Contained in “Final Interagency Policy Statement Establishing Joint Standards for Assessing the Diversity Policies and Practices of Entities Regulated by the Agencies.” 2016-16459 Securities and Exchange Commission 466
2016-16459,497 Announcement of Office of Management and Budget's Approval of Collection of Information Contained in “Final Interagency Policy Statement Establishing Joint Standards for Assessing the Diversity Policies and Practices of Entities Regulated by the Agencies.” 2016-16459 Treasury Department 497
2016-16459,573 Announcement of Office of Management and Budget's Approval of Collection of Information Contained in “Final Interagency Policy Statement Establishing Joint Standards for Assessing the Diversity Policies and Practices of Entities Regulated by the Agencies.” 2016-16459 Consumer Financial Protection Bureau 573

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