spending_agency_summary

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

15 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ name award_count total_spending sub_count
1 1 Department of Transportation 198244 945035568690 10
2 2 Department of Energy 50083 901443423810 5
3 3 Department of Education 52049 879744084479 1
4 4 Department of Homeland Security 128687 626810428357 15
5 5 Department of Veterans Affairs 98032 541063112318 4
6 6 National Aeronautics and Space Administration 75959 318116856189 1
7 7 Department of Housing and Urban Development 84206 272357876468 8
8 8 Department of Justice 124067 148588289187 9
9 9 Environmental Protection Agency 53470 146477266580 1
10 10 Department of Labor 30560 140325296109 9
11 11 Department of Commerce 89560 139962827547 10
12 12 Department of the Interior 62431 23676201267 1
13 13 Department of Health and Human Services 23504 22367537225 1
14 14 Small Business Administration 8264 7754563941 1
15 15 Department of Agriculture 31892 6569657698 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE spending_agency_summary(
  name TEXT,
  award_count,
  total_spending INT,
  sub_count
);
CREATE UNIQUE INDEX idx_sas_agency ON spending_agency_summary(name);