home / openregs

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

42 rows where agency_id = 302

✎ View and edit SQL

This data as json, CSV (advanced)

Link document_number agency_id
01-31128,302 Notice of Intent To Seek Approval To Collect Information 01-31128 National Agricultural Library 302
02-16418,302 Notice of Intent To Seek Approval To Collect Information 02-16418 National Agricultural Library 302
02-17487,302 Notice of Intent to Seek Approval to Collect Information 02-17487 National Agricultural Library 302
02-27099,302 Notice of Intent To Seek Approval To Collect Information 02-27099 National Agricultural Library 302
02-6591,302 Notice of Intent to Seek Approval to Collect Information 02-6591 National Agricultural Library 302
02-7468,302 Notice of Intent To Seek Approval To Collect Information 02-7468 National Agricultural Library 302
03-28220,302 Notice of Intent To Seek Approval to Collect Information 03-28220 National Agricultural Library 302
04-24603,302 Notice of Intent To Seek Approval To Collect Information 04-24603 National Agricultural Library 302
04-27601,302 Notice of Intent To Seek Approval To Collect Information 04-27601 National Agricultural Library 302
2010-8258,302 Notice of Intent to Seek Approval To Collect Information 2010-8258 National Agricultural Library 302
2011-18052,302 Notice of Intent To Seek Approval To Collect Information 2011-18052 National Agricultural Library 302
2011-31748,302 Notice of Intent To Seek Approval To Collect Information 2011-31748 National Agricultural Library 302
2011-6437,302 Notice of Intent To Seek Approval To Collect Information 2011-6437 National Agricultural Library 302
2012-19936,302 Notice of Intent To Seek Approval To Collect Information 2012-19936 National Agricultural Library 302
2012-2816,302 Notice of Intent To Seek Approval To Collect Information 2012-2816 National Agricultural Library 302
2012-5432,302 Notice of Intent To Request an Extension of a Currently Approved Information Collection 2012-5432 National Agricultural Library 302
2012-7568,302 Notice of Intent To Seek Approval To Collect Information 2012-7568 National Agricultural Library 302
2014-07224,302 Notice of Intent To Seek Approval To Collect Information 2014-07224 National Agricultural Library 302
2014-11197,302 Notice of Intent To Seek Approval To Collect Information 2014-11197 National Agricultural Library 302
2015-06608,302 Notice of Intent To Seek Approval To Collect Information 2015-06608 National Agricultural Library 302
2015-09475,302 Notice of Intent To Request an Extension of a Currently Approved Information Collection 2015-09475 National Agricultural Library 302
2015-15737,302 Notice of Intent To Seek Approval To Collect Information 2015-15737 National Agricultural Library 302
2015-24258,302 Notice of Intent To Seek Approval To Collect Information 2015-24258 National Agricultural Library 302
2016-14604,302 Notice of Intent To Seek Approval To Collect Information 2016-14604 National Agricultural Library 302
2018-07039,302 Notice of Intent To Seek Approval To Collect Information 2018-07039 National Agricultural Library 302
2018-11582,302 Notice of Intent To Renew a Currently Approved Information Collection 2018-11582 National Agricultural Library 302
2019-20094,302 Notice of Intent To Seek Approval To Collect Information 2019-20094 National Agricultural Library 302
2021-16139,302 Notice of Intent To Renew a Currently Approved Information Collection 2021-16139 National Agricultural Library 302
2022-24320,302 Notice of Intent To Seek Approval To Collect Information 2022-24320 National Agricultural Library 302
2023-20579,302 Notice of Stakeholder Listening Sessions Regarding Increasing Public Access to the Results of USDA-Funded Research 2023-20579 National Agricultural Library 302
2024-01673,302 Notice of Second Interested Party Feedback Period Regarding Increasing Public Access to the Results of USDA-Funded Research 2024-01673 National Agricultural Library 302
2024-12958,302 Notice of Intent To Seek Approval To Collect Information 2024-12958 National Agricultural Library 302
2024-17447,302 Notice of Intent To Renew a Currently Approved Information Collection 2024-17447 National Agricultural Library 302
95-31097,302 Availability of Information 95-31097 National Agricultural Library 302
E6-1792,302 Notice of Intent To Seek Approval To Collect Information E6-1792 National Agricultural Library 302
E6-4703,302 Notice of Intent To Seek Approval To Collect Information E6-4703 National Agricultural Library 302
E7-16847,302 Notice of Intent To Seek Approval To Collect Information E7-16847 National Agricultural Library 302
E7-19213,302 Notice of Intent To Seek Approval To Collect Information E7-19213 National Agricultural Library 302
E8-25255,302 Notice of Intent To Seek Approval To Collect Information E8-25255 National Agricultural Library 302
E8-29948,302 Notice of Intent To Seek Renewal of Existing Information Collection E8-29948 National Agricultural Library 302
E9-15685,302 Notice of Intent To Seek Approval To Collect Information E9-15685 National Agricultural Library 302
E9-25228,302 Notice of Intent To Seek Approval To Collect Information E9-25228 National Agricultural Library 302

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);
Powered by Datasette · Queries took 50.09ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API