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 37212 814879012032 21898285 2009-07-01 2026-01-01
Department of Energy Department of Energy contracts 23483 772955875510 32915550 1978-09-15 2026-04-01
Department of Veterans Affairs Department of Veterans Affairs contracts 43708 443298012915 10142262 1997-08-01 2026-08-17
Department of Transportation Federal Highway Administration grants 32405 355586186702 10973188 2000-11-14 2026-02-27
National Aeronautics and Space Administration National Aeronautics and Space Administration contracts 47024 288660578050 6138579 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 6083 217347138458 35730254 1999-10-01 2026-02-26
Department of Housing and Urban Development Assistant Secretary for Community Planning and Development grants 23552 162771879967 6911170 1994-07-01 2026-03-01
Department of Labor Employment and Training Administration grants 12366 105313724121 8516393 2007-04-01 2026-01-01
Department of Energy Department of Energy grants 23199 92825049892 4001252 1984-03-01 2026-07-01
Department of Transportation Federal Railroad Administration grants 462 77081010651 166842014 2004-09-01 2026-02-01
Department of Housing and Urban Development Assistant Secretary for Public and Indian Housing grants 26682 73883235208 2769029 2007-10-01 2026-02-06
Department of Transportation Federal Aviation Administration grants 31259 73004708832 2335478 2000-06-29 2026-02-25
Department of Homeland Security U.S. Customs and Border Protection contracts 5761 67076611928 11643223 2002-08-08 2026-05-01
Department of Transportation Federal Aviation Administration contracts 47564 66925081255 1407053 1997-04-17 2026-04-01
Environmental Protection Agency Environmental Protection Agency grants 6949 65704080662 9455185 1991-01-01 2026-11-01
Department of Commerce National Institute of Standards and Technology grants 3163 48596104301 15363928 2005-07-01 2026-02-01
Department of Homeland Security Office of Procurement Operations contracts 7388 44342693637 6001988 2003-12-31 2026-07-01
Department of Justice Office of Justice Programs grants 27573 43022263021 1560304 2000-10-01 2025-12-01
Department of Homeland Security U.S. Coast Guard contracts 10237 42786085956 4179553 2001-09-15 2026-11-25
Department of Education Department of Education contracts 6666 35909520892 5386966 2002-08-03 2026-03-03
Department of Homeland Security U.S. Immigration and Customs Enforcement contracts 3327 35232983923 10590016 2002-12-01 2026-03-31
Department of Homeland Security Federal Emergency Management Agency contracts 35939 31285511111 870517 2003-10-17 2026-05-01
Department of Veterans Affairs Under Secretary for Health/Veterans Health Administration grants 8867 30507727599 3440591 2010-08-17 2025-10-01
Department of Labor Office of the Assistant Secretary for Administration and Management contracts 9887 25890885611 2618679 2001-01-01 2026-04-01
Department of Homeland Security Transportation Security Administration contracts 2393 25739424546 10756132 2003-04-11 2026-03-18
Department of Commerce National Oceanic and Atmospheric Administration contracts 38620 24938992088 645753 2003-12-15 2026-10-01
Department of Justice Federal Bureau of Investigation contracts 7317 21615033463 2954084 2008-09-29 2026-09-30
Department of Justice Federal Prison System / Bureau of Prisons contracts 22844 21185798636 927411 2006-05-24 2026-12-16
Department of the Interior U.S. Fish and Wildlife Service grants 31195 20584327671 659859 2001-11-01 2026-07-01
Department of Justice Offices, Boards and Divisions contracts 9241 18313236257 1981737 2005-12-15 2026-05-01
Department of Commerce National Oceanic and Atmospheric Administration grants 10552 18220052798 1726691 2000-10-01 2026-07-01
Department of Health and Human Services Food and Drug Administration contracts 20028 18169299571 907194 2002-07-25 2025-09-30
National Aeronautics and Space Administration National Aeronautics and Space Administration grants 23715 15232777829 642326 1999-10-21 2026-08-01
Department of Homeland Security U.S. Citizenship and Immigration Services contracts 1326 15228830423 11484789 2004-09-30 2026-03-11
Department of Transportation Federal Highway Administration contracts 6715 13685410058 2038035 2002-04-15 2026-04-01
Department of Justice U.S. Marshals Service contracts 4241 13167779434 3104876 2005-07-01 2026-08-13
Department of Housing and Urban Development Department of Housing and Urban Development contracts 4642 12534056759 2700141 2004-08-01 2026-12-16
Department of Commerce U.S. Patent and Trademark Office contracts 3326 10497137801 3156084 2001-10-05 2026-04-01
Department of Commerce U.S. Census Bureau contracts 2732 10256908637 3754358 2005-09-28 2026-03-02
Department of Commerce Economic Development Administration grants 6637 9419131384 1419185 2012-09-14 2025-10-01
Department of Justice Offices, Boards and Divisions grants 12695 8865884619 698376 2005-07-01 2025-10-01
Environmental Protection Agency Environmental Protection Agency contracts 6308 8849687874 1402930 2000-09-27 2026-08-07
Department of Transportation Maritime Administration contracts 4887 8326117307 1703727 2001-08-30 2026-06-27
Department of Transportation National Highway Traffic Safety Administration grants 6074 7406498969 1219377 2009-07-30 2025-10-01
Department of Justice Drug Enforcement Administration contracts 4063 5797783914 1426971 2007-01-01 2026-07-31
Department of Commerce Office of the Secretary contracts 8559 5342952599 624249 2003-10-08 2026-07-31
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 2437 3932439231 1613639 1979-10-15 2026-10-06
Department of Commerce National Institute of Standards and Technology contracts 8136 3788644099 465664 2006-08-04 2026-06-01
Department of the Interior U.S. Fish and Wildlife Service contracts 29410 3437467397 116880 2008-04-04 2025-09-25
Department of Justice Bureau of Alcohol, Tobacco, Firearms and Explosives Acquisition and Property Management Division contracts 1349 3262729208 2418628 2009-04-14 2026-06-15
Department of Transportation Federal Motor Carrier Safety Administration grants 385 3230096455 8389860 2014-10-01 2025-12-01
Department of Homeland Security U.S. Secret Service contracts 1186 3177677720 2679323 2006-06-12 2026-07-12
Small Business Administration Small Business Administration grants 5155 3172626744 615446 2009-09-30 2025-09-30
Department of Homeland Security Federal Law Enforcement Training Center contracts 633 3147737010 4972728 2007-01-11 2026-05-01
Department of Agriculture Animal and Plant Health Inspection Service grants 10557 3012604287 285365 2015-11-19 2025-11-01
Department of Labor Veterans Employment and Training Services grants 2184 2896185548 1326092 2007-07-01 2025-12-01
Department of Transportation Maritime Administration grants 155 2827283169 18240536 2013-03-01 2027-05-30
Department of Transportation National Highway Traffic Safety Administration contracts 2355 2688861775 1141767 1998-09-28 2026-03-01
Department of Health and Human Services Food and Drug Administration grants 2089 2676527800 1281248 1997-09-30 2025-09-30
Department of Agriculture Animal and Plant Health Inspection Service contracts 15957 2472777053 154965 2008-09-15 2024-12-14
Department of Commerce National Telecommunications and Information Administration grants 280 2454396233 8765700 2010-08-01 2025-03-01
Department of Justice Federal Prison Industries / Unicor contracts 3692 2323746550 629400 2013-05-11 2026-03-02
Department of Housing and Urban Development Office of Lead Hazard Control and Healthy Homes grants 808 2318991757 2870039 2009-11-01 2026-03-16
Department of Justice Office of Justice Programs contracts 838 2053546949 2450533 2001-06-15 2026-02-21
Department of Labor Occupational Safety and Health Administration grants 1883 1806232292 959231 2011-10-01 2025-10-01
Department of Housing and Urban Development Assistant Secretary for Housing--Federal Housing Commissioner grants 913 1678531722 1838479 1999-10-01 2025-01-13
Department of Transportation Federal Transit Administration contracts 1294 1586382840 1225952 2004-06-10 2026-03-03
Department of Homeland Security U.S. Coast Guard grants 840 1256887317 1496294 2012-10-01 2025-10-01
Department of Energy Federal Energy Regulatory Commission contracts 1241 1231433485 992291 2008-07-07 2026-03-01
Department of Transportation Federal Railroad Administration contracts 1115 1032993980 926452 1999-05-15 2026-02-24
Department of Transportation Immediate Office of the Secretary of Transportation grants 130 1029304848 7917729 2006-09-06 2025-09-01
Department of Transportation Federal Motor Carrier Safety Administration contracts 495 992940356 2005940 2003-09-01 2026-01-30
Department of Transportation Pipeline and Hazardous Materials Safety Administration grants 90 779805872 8664509 2012-08-23 2025-05-05
Department of Labor Bureau of Labor Statistics grants 1021 698973702 684597 2013-10-01 2025-10-01
Department of Veterans Affairs Directory/National Cemetery Administration grants 224 626674245 2797652 2025-09-01 2025-09-05
Department of Transportation Pipeline and Hazardous Materials Safety Administration contracts 401 599397362 1494756 2004-11-01 2026-03-01
Department of Homeland Security Office of the Inspector General contracts 126 428704858 3402419 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 368 395702635 1075278 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 Labor Office of the Assistant Secretary for Administration and Management grants 139 294045510 2115435 2009-09-29 2025-12-31
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 Homeland Security Cybersecurity and Infrastructure Security Agency grants 23 224087364 9742928 2015-10-01 2024-09-30
Department of Housing and Urban Development Assistant Secretary for Policy Development and Research grants 97 222611460 2294963 2010-09-24 2025-08-09
Department of Labor Bureau of Labor Statistics contracts 836 159629774 190944 2010-11-01 2020-04-27
Department of Homeland Security Immediate Office of the Under Secretary for Management grants 220 144134557 655157 2006-07-01 2026-10-01
Department of Transportation Saint Lawrence Seaway Development Corporation contracts 117 144078954 1231444 2011-03-11 2026-03-23
Department of Labor Office of Inspector General contracts 676 118173938 174813 2011-03-08 2026-03-03
Department of Labor Mine Safety and Health Administration grants 584 105859095 181265 2013-10-01 2025-09-30
Department of Homeland Security Department of Homeland Security grants 71 104669860 1474223 2010-08-01 2018-10-01
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 66 72754501 1102340 2005-08-15 2024-07-22
Department of Justice Office of the Inspector General contracts 97 39379978 405979 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 Department of Commerce contracts 5 15347694 3069538 2022-01-27 2025-01-31
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 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