home / openregs

Federal Spending by Sub-Agency

Total grants and contracts broken down by sub-agency within each parent agency, with award counts and totals.

Custom SQL query returning 111 rows (hide)

SELECT agency, sub_agency, award_category, COUNT(*) AS award_count, CAST(SUM(award_amount) AS INTEGER) AS total_amount, CAST(AVG(award_amount) AS INTEGER) AS avg_amount, MIN(start_date) AS earliest, MAX(start_date) AS latest FROM spending_awards WHERE sub_agency IS NOT NULL AND sub_agency != '' GROUP BY agency, sub_agency, award_category ORDER BY total_amount DESC

Edit SQL

This data as json, CSV

agencysub_agencyaward_categoryaward_counttotal_amountavg_amountearliestlatest
Department of Education Department of Education grants 37044 818579139008 22097482 2009-07-01 2026-03-17
Department of Energy Department of Energy contracts 23700 777706320734 32814612 1978-09-15 2026-05-02
Department of Veterans Affairs Department of Veterans Affairs contracts 42858 453607466722 10583962 1997-08-01 2026-08-01
Department of Transportation Federal Highway Administration grants 31364 363573693390 11592070 1998-08-01 2026-04-15
National Aeronautics and Space Administration National Aeronautics and Space Administration contracts 47448 290846261979 6129789 1962-05-01 2026-12-13
Department of Homeland Security Federal Emergency Management Agency grants 38598 272557008563 7061428 1994-09-28 2026-03-23
Department of Transportation Federal Transit Administration grants 6053 218686781550 36128660 1999-10-01 2026-04-07
Department of Housing and Urban Development Assistant Secretary for Community Planning and Development grants 23658 166173916486 7024005 1994-07-01 2026-08-13
Environmental Protection Agency Environmental Protection Agency grants 24306 122317883024 5032415 1991-01-01 2026-11-01
Department of Labor Employment and Training Administration grants 11900 102012054602 8572441 2007-04-01 2026-01-01
Department of Energy Department of Energy grants 23336 92929905254 3982255 1984-03-01 2026-07-01
Department of Housing and Urban Development Assistant Secretary for Public and Indian Housing grants 26368 76636245740 2906411 2007-10-01 2026-04-01
Department of Homeland Security U.S. Customs and Border Protection contracts 5763 76309382157 13241260 2002-08-08 2026-05-01
Department of Transportation Federal Aviation Administration grants 31354 73159122564 2333326 2000-06-29 2026-04-13
Department of Transportation Federal Railroad Administration grants 432 68302104913 158106724 2004-09-01 2026-02-01
Department of Transportation Federal Aviation Administration contracts 45909 68146703059 1484386 1997-04-17 2026-06-01
Department of Commerce National Institute of Standards and Technology grants 3168 48638137576 15352947 2005-07-01 2026-04-01
Department of Homeland Security Office of Procurement Operations contracts 7427 44789496607 6030631 2003-12-31 2026-08-01
Department of Homeland Security U.S. Coast Guard contracts 9807 43550961748 4440803 2001-09-15 2027-02-15
Department of Justice Office of Justice Programs grants 27664 43198167179 1561530 2000-10-01 2025-12-01
Department of Education Department of Education contracts 6693 36696111902 5482759 2002-08-03 2026-04-30
Department of Homeland Security U.S. Immigration and Customs Enforcement contracts 3275 36491848207 11142549 2002-12-01 2026-05-04
Department of Homeland Security Federal Emergency Management Agency contracts 36022 31359652003 870569 2003-10-17 2026-05-04
Department of Veterans Affairs Under Secretary for Health/Veterans Health Administration grants 8831 30637945182 3469363 2010-08-17 2025-10-01
Department of Labor Office of the Assistant Secretary for Administration and Management contracts 9934 26266417757 2644092 2001-01-01 2026-07-01
Department of Homeland Security Transportation Security Administration contracts 2355 25815082773 10961818 2003-04-11 2026-04-07
Department of Commerce National Oceanic and Atmospheric Administration contracts 38841 25301669366 651416 2003-12-15 2026-10-01
Environmental Protection Agency Environmental Protection Agency contracts 27942 21893765224 783543 1997-09-15 2026-08-07
Department of Justice Federal Bureau of Investigation contracts 7335 21878536271 2982758 2008-09-29 2026-10-10
Department of Justice Federal Prison System / Bureau of Prisons contracts 22744 21791447186 958118 2006-05-24 2026-12-16
Department of the Interior U.S. Fish and Wildlife Service grants 30986 19965556384 644341 2001-11-01 2026-07-01
Department of Justice Offices, Boards and Divisions contracts 9176 18461975194 2011985 2005-12-15 2026-05-01
Department of Health and Human Services Food and Drug Administration contracts 20167 18283144191 906587 2002-07-25 2026-08-12
Department of Commerce National Oceanic and Atmospheric Administration grants 10552 18277286998 1732115 2000-10-01 2026-07-01
National Aeronautics and Space Administration National Aeronautics and Space Administration grants 23866 15391013329 644892 1999-10-21 2026-12-01
Department of Homeland Security U.S. Citizenship and Immigration Services contracts 1344 15387219782 11448824 2004-09-30 2026-05-14
Department of Transportation Federal Highway Administration contracts 6825 13841329867 2028033 2002-04-15 2026-10-01
Department of Justice U.S. Marshals Service contracts 4097 13726032771 3350264 2005-07-01 2026-08-13
Department of Housing and Urban Development Department of Housing and Urban Development contracts 4670 12605612239 2699274 2004-08-01 2026-12-16
Department of Commerce U.S. Patent and Trademark Office contracts 3343 10595425744 3169436 2001-10-05 2026-07-31
Department of Commerce U.S. Census Bureau contracts 2735 10300111685 3766037 2005-09-28 2026-04-16
Department of Commerce Economic Development Administration grants 6643 9147050547 1376945 2012-09-14 2025-11-01
Department of Justice Offices, Boards and Divisions grants 12712 8877271420 698337 2005-07-01 2026-01-01
Department of Transportation Maritime Administration contracts 4951 8468282810 1710418 2001-08-30 2026-06-27
Department of Transportation National Highway Traffic Safety Administration grants 6109 8101414367 1326144 2009-07-30 2026-04-16
Department of Justice Drug Enforcement Administration contracts 3767 5861234431 1555942 2007-01-01 2027-03-31
Department of Commerce Office of the Secretary contracts 8714 5411500944 621012 2003-10-08 2026-08-20
Small Business Administration Small Business Administration contracts 3227 4757362801 1474237 2010-01-25 2025-04-01
Department of Labor Employment and Training Administration contracts 577 4755204720 8241256 2001-01-01 2020-03-18
Department of Transportation Immediate Office of the Secretary of Transportation contracts 2467 3966110863 1607665 1979-10-15 2026-12-01
Department of Commerce National Institute of Standards and Technology contracts 8174 3803177635 465277 2006-08-04 2026-07-01
Department of the Interior U.S. Fish and Wildlife Service contracts 30093 3500925315 116336 2008-04-04 2026-06-01
Department of Justice Bureau of Alcohol, Tobacco, Firearms and Explosives Acquisition and Property Management Division contracts 1344 3288018872 2446442 2009-04-14 2026-06-15
Department of Homeland Security Federal Law Enforcement Training Center contracts 621 3229414191 5200344 2007-01-11 2026-05-01
Department of Homeland Security U.S. Secret Service contracts 1138 3216535903 2826481 2006-06-12 2026-07-12
Department of Agriculture Animal and Plant Health Inspection Service grants 10823 3159575195 291931 2015-11-19 2026-09-01
Department of Transportation Federal Motor Carrier Safety Administration grants 353 3088546035 8749422 2014-10-01 2025-12-01
Department of Agriculture Animal and Plant Health Inspection Service contracts 19636 3084795485 157098 2008-09-15 2026-06-01
Department of Transportation Maritime Administration grants 171 3058803796 17887741 2013-03-01 2027-05-30
Small Business Administration Small Business Administration grants 5030 3021134494 600623 2009-09-30 2025-09-30
Department of Labor Veterans Employment and Training Services grants 2094 2762698361 1319340 2007-07-01 2025-12-01
Department of Transportation National Highway Traffic Safety Administration contracts 2369 2722761723 1149329 1998-09-28 2026-04-03
Department of Health and Human Services Food and Drug Administration grants 2090 2682307141 1283400 1997-09-30 2026-03-01
Department of Housing and Urban Development Office of Lead Hazard Control and Healthy Homes grants 858 2523990769 2941714 2009-11-01 2026-04-15
Department of Commerce National Telecommunications and Information Administration grants 280 2452711260 8759683 2010-08-01 2025-03-01
Department of Justice Federal Prison Industries / Unicor contracts 3611 2334736271 646562 2013-05-11 2026-05-01
Department of Justice Office of Justice Programs contracts 851 2058686837 2419138 2001-06-15 2026-04-01
Department of Labor Occupational Safety and Health Administration grants 1756 1706199002 971639 2011-10-01 2025-09-30
Department of Housing and Urban Development Assistant Secretary for Housing--Federal Housing Commissioner grants 911 1679691608 1843788 1999-10-01 2025-01-13
Department of Transportation Federal Transit Administration contracts 1321 1592035972 1205174 2004-06-10 2026-04-15
Department of Energy Federal Energy Regulatory Commission contracts 1259 1270173532 1008874 2008-07-07 2026-07-29
Department of Homeland Security U.S. Coast Guard grants 840 1256887317 1496294 2012-10-01 2025-10-01
Department of Transportation Federal Railroad Administration contracts 1111 1054841573 949452 1999-05-15 2026-04-01
Department of Transportation Immediate Office of the Secretary of Transportation grants 128 1044287402 8158495 2006-09-06 2026-03-02
Department of Transportation Federal Motor Carrier Safety Administration contracts 502 1005187243 2002365 2003-09-01 2026-04-03
Department of Transportation Pipeline and Hazardous Materials Safety Administration grants 85 757368677 8910219 2012-08-23 2025-05-05
Department of Labor Bureau of Labor Statistics grants 912 665046703 729217 2013-10-01 2024-10-01
Department of Veterans Affairs Directory/National Cemetery Administration grants 224 625690609 2793261 2025-09-01 2025-09-05
Department of Transportation Pipeline and Hazardous Materials Safety Administration contracts 411 606604122 1475922 2004-11-01 2026-04-16
Department of Homeland Security Office of the Inspector General contracts 126 427531054 3393103 2012-09-27 2025-12-31
Department of Homeland Security Countering Weapons of Mass Destruction grants 112 422765290 3774690 2006-07-01 2024-09-30
Department of Housing and Urban Development Assistant Secretary for Fair Housing and Equal Opportunity grants 365 395175155 1082671 2010-06-21 2025-10-01
Department of Commerce Minority Business Development Agency grants 339 377588483 1113830 2011-04-01 2023-09-01
Department of Homeland Security Office of the Under Secretary for Science and Technology grants 69 271293603 3931791 2012-09-01 2024-06-07
Department of Labor Office of the Assistant Secretary for Administration and Management grants 129 250648933 1943014 2009-09-29 2025-12-31
Department of Housing and Urban Development Assistant Secretary for Policy Development and Research grants 103 230445356 2237333 2010-09-24 2026-04-01
Department of Homeland Security Cybersecurity and Infrastructure Security Agency grants 23 224087364 9742928 2015-10-01 2024-09-30
Department of Labor Bureau of Labor Statistics contracts 836 159629774 190944 2010-11-01 2020-04-27
Department of Transportation Saint Lawrence Seaway Development Corporation contracts 122 144300858 1182793 2011-03-11 2026-03-23
Department of Homeland Security Immediate Office of the Under Secretary for Management grants 220 144134557 655157 2006-07-01 2026-10-01
Department of Labor Office of Inspector General contracts 678 118447780 174701 2011-03-08 2026-04-28
Department of Homeland Security Department of Homeland Security grants 71 104669860 1474223 2010-08-01 2018-10-01
Department of Labor Mine Safety and Health Administration grants 568 103276200 181824 2013-10-01 2025-09-30
Department of Labor President's Committee on Employment of the Handicapped grants 16 101827386 6364211 2012-09-17 2025-04-01
Department of Homeland Security U.S. Citizenship and Immigration Services grants 291 88242712 303239 2014-01-01 2024-11-22
Department of Energy Assistant Secretary for Fossil Energy grants 60 69281084 1154684 2005-08-15 2024-07-22
Department of Justice Office of the Inspector General contracts 92 39579373 430210 2015-10-02 2026-02-25
Department of Labor Mine Safety and Health Administration contracts 688 36020512 52355 2008-05-14 2020-04-21
Department of Labor Office of Job Corps grants 26 25379855 976148 2020-06-30 2020-06-30
Department of Veterans Affairs Department of Veterans Affairs grants 17 25250886 1485346 2018-09-30 2018-09-30
Department of Homeland Security U.S. Secret Service grants 1 21850000 21850000 2024-06-10 2024-06-10
Department of Energy Assistant Secretary for Conservation and Renewable Energy grants 19 19550516 1028974 2009-11-01 2017-10-01
Department of Commerce International Trade Administration grants 53 11754375 221780 2013-01-01 2023-10-01
Department of Veterans Affairs Under Secretary for Benefits/Veterans Benefits Administration grants 41 11641910 283949 2016-09-30 2024-09-01
Department of Commerce Department of Commerce contracts 3 7441388 2480462 2022-02-01 2025-01-31
Department of Commerce U.S. Census Bureau grants 5 5283764 1056752 2017-01-01 2021-09-01
Department of Homeland Security Office of Procurement Operations grants 2 2799249 1399624 2022-09-30 2022-09-30
Department of Homeland Security U.S. Immigration and Customs Enforcement grants 2 2438201 1219100 2018-09-30 2023-09-30
Department of Housing and Urban Development Chief Procurement Officer contracts 1 1152672 1152672 2021-03-01 2021-03-01
Department of Housing and Urban Development Department of Housing and Urban Development grants 1 576808 576808 2011-08-01 2011-08-01
Department of Energy Assistant Secretary for Congressional and Intergovernmental Affairs grants 3 360307 120102 2016-09-15 2016-09-15
Powered by Datasette · Queries took 1173.521ms