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 48377 871995591429 5
2 2 Department of Education 43737 855275250910 1
3 3 Department of Transportation 142037 841320280794 10
4 4 Department of Homeland Security 108107 555673301152 15
5 5 Department of Veterans Affairs 51971 484907995311 4
6 6 National Aeronautics and Space Administration 71314 306237275309 1
7 7 Department of Housing and Urban Development 56935 260246806836 8
8 8 Environmental Protection Agency 52248 144211648248 1
9 9 Department of Justice 93393 141515685810 9
10 10 Department of Labor 30114 138962851591 9
11 11 Department of Commerce 82850 134329139772 10
12 12 Department of the Interior 61079 23466481700 1
13 13 Department of Health and Human Services 22257 20965451332 1
14 14 Small Business Administration 8257 7778497296 1
15 15 Department of Agriculture 30459 6244370680 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);