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)

Suggested facets: sub_count

Link rowid ▼ name award_count total_spending sub_count
1 1 Department of Energy 48011 867105024213 5
2 2 Department of Education 43878 850788532924 1
3 3 Department of Transportation 144423 838205737083 10
4 4 Department of Homeland Security 108545 543542437838 15
5 5 Department of Veterans Affairs 52857 474469307556 4
6 6 National Aeronautics and Space Administration 70739 303893355879 1
7 7 Department of Housing and Urban Development 57064 253806738991 8
8 8 Department of Labor 30883 142202142069 9
9 9 Department of Justice 93950 139647182034 9
10 10 Department of Commerce 82407 133924294262 10
11 11 Environmental Protection Agency 13257 74553768536 1
12 12 Department of the Interior 60605 24021795069 1
13 13 Department of Health and Human Services 22117 20845827371 1
14 14 Small Business Administration 8382 7929989545 1
15 15 Department of Agriculture 26514 5485381340 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);