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 Transportation 178864 895524105126 10
2 2 Department of Energy 49362 888475587694 5
3 3 Department of Education 46746 875353607223 1
4 4 Department of Homeland Security 120389 602947423793 15
5 5 Department of Veterans Affairs 82293 520404294282 4
6 6 National Aeronautics and Space Administration 73718 312015558617 1
7 7 Department of Housing and Urban Development 74665 268279282982 8
8 8 Environmental Protection Agency 52992 146030588912 1
9 9 Department of Justice 114233 144933005115 9
10 10 Department of Labor 30323 139794775811 9
11 11 Department of Commerce 86042 136646197413 10
12 12 Department of the Interior 61813 23558466246 1
13 13 Department of Health and Human Services 22782 21386438070 1
14 14 Small Business Administration 8260 7775100116 1
15 15 Department of Agriculture 31603 6481924022 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);