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 198007 944312717787 10
2 2 Department of Energy 50048 897906775048 5
3 3 Department of Education 52038 879393798151 1
4 4 Department of Homeland Security 127374 624540691911 15
5 5 Department of Veterans Affairs 91868 532053284202 4
6 6 National Aeronautics and Space Administration 75513 317103641076 1
7 7 Department of Housing and Urban Development 84193 272268542908 8
8 8 Department of Justice 121263 147752357915 9
9 9 Environmental Protection Agency 53351 146375201075 1
10 10 Department of Labor 30553 140296119574 9
11 11 Department of Commerce 89520 139854013289 10
12 12 Department of the Interior 62423 23675794011 1
13 13 Department of Health and Human Services 23445 22236611295 1
14 14 Small Business Administration 8263 7754651251 1
15 15 Department of Agriculture 31838 6561953478 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);