Sub-tier agencies (view)

Bureaus and components within top-tier agencies.

1,492 rows

✎ View and edit SQL

subtier_agency_id create_date update_date subtier_code abbreviation name embedding embedding_generated_at
1 2018-01-31 19:52:54.150044 2019-11-04 22:39:51.468022 0000   The Legislative Branch    
2 2018-01-31 19:52:54.163631 2019-11-04 22:39:51.468022 0001   Congress, Generally, No Additional Specification Available    
1496 2026-09-19 00:37:31.420127 2026-09-19 00:37:31.420127 0002   United State Capitol Police    
1475 2019-11-04 22:39:51.468022 2019-11-04 22:39:51.468022 0010   The Senate    
1482 2020-03-14 00:55:54.883131 2020-03-14 00:55:54.883131 0011 SAA The United States Senate Sergeant at Arms    
1476 2019-11-04 22:39:51.468022 2019-11-04 22:39:51.468022 0050   The House of Representatives    
3 2018-01-31 19:52:54.175812 2019-11-04 22:39:51.468022 0099   Joint House and Senate Entities    
6 2018-01-31 19:52:54.218082 2019-06-14 21:33:08.330042 0100 AOC Architect of the Capitol    
7 2018-01-31 19:52:54.235732 2019-06-14 21:33:08.471522 0300 LOC Library of Congress    
8 2018-01-31 19:52:54.247769 2019-11-04 22:39:51.468022 0361   Library of Congress Trust Fund Board    
9 2018-01-31 19:52:54.260268 2019-11-04 22:39:51.468022 0362   Permanent Committee for the Oliver Wendell Holmes Devise    
4 2018-01-31 19:52:54.187948 2019-06-14 21:33:08.164065 0363 FLICC Federal Library and Information Center Committee    
10 2018-01-31 19:52:54.279013 2020-01-22 03:39:13.424853 0400 GPO United States Government Publishing Office    
11 2018-01-31 19:52:54.296486 2019-06-14 21:33:08.932334 0500 GAO Government Accountability Office    
12 2018-01-31 19:52:54.308567 2019-11-04 22:39:51.468022 0501   Comptroller General of the United States    
13 2018-01-31 19:52:54.321028 2019-11-04 22:39:51.468022 0559   GAO, Except Comptroller General    
14 2018-01-31 19:52:54.340486 2019-06-14 21:33:09.291247 0800 CBO Congressional Budget Office    
15 2018-01-31 19:52:54.357846 2019-11-04 22:39:51.468022 0900   Legislative Branch Boards and Commissions    
19 2018-01-31 19:52:54.406421 2019-11-04 22:39:51.468022 0901 CSCE Commission on Security and Cooperation In Europe    
16 2018-01-31 19:52:54.369882 2019-06-14 21:33:09.516336 0902 USBG Botanic Garden    
17 2018-01-31 19:52:54.381843 2019-06-14 21:33:09.684751 0904 OOC Office of Compliance    
1424 2018-01-31 19:53:12.660484 2019-11-04 22:39:51.468022 0905   Dwight D. Eisenhower Memorial Commission    
20 2018-01-31 19:52:54.418520 2019-11-04 22:39:51.468022 0911   Commission on Agricultural Workers    
21 2018-01-31 19:52:54.430680 2019-11-04 22:39:51.468022 0914   John C. Stennis Center for Public Service Training and Development    
22 2018-01-31 19:52:54.442813 2019-11-04 22:39:51.468022 0915   Advisory Commission on Electronic Commerce    
23 2018-01-31 19:52:54.455185 2019-11-04 22:39:51.468022 0916   National Commission on Terrorism    
1427 2018-01-31 19:53:12.714617 2019-06-14 21:33:40.372993 0923 CECC Congressional-Executive Commission on People's Republic of China    
24 2018-01-31 19:52:54.467269 2019-11-04 22:39:51.468022 0929   U.S. Capitol Preservation Commission    
1431 2018-01-31 19:53:12.787051 2019-06-14 21:33:40.480183 0938 ALBC Abraham Lincoln Bicentennial Commission    
18 2018-01-31 19:52:54.394281 2019-11-04 22:39:51.468022 0945   Open World Leadership Center    
5 2018-01-31 19:52:54.200396 2019-11-04 22:39:51.468022 0962   Permanent Committee for the Oliver Wendell Holmes Devise    
25 2018-01-31 19:52:54.479433 2019-06-14 21:33:10.485054 0973 9-11 COMMISSION National Commission on Terrorist Attacks Upon the United States    
26 2018-01-31 19:52:54.491568 2019-11-04 22:39:51.468022 0975   Commission on the Review of the Overseas Military Facility Structure of the United States    
27 2018-01-31 19:52:54.503641 2019-11-04 22:39:51.468022 0977 AMC Antitrust Modernization Commission    
28 2018-01-31 19:52:54.521392 2019-11-04 22:39:51.468022 1000   The Judicial Branch    
30 2018-01-31 19:52:54.545533 2019-06-14 21:33:11.129253 1001 SCOTUS Supreme Court of the United States    
36 2018-01-31 19:52:54.618798 2019-11-04 22:39:51.468022 1002   U.S. Courts of Appeals-Judicial Circuits (Except Federal Circuit)    
37 2018-01-31 19:52:54.630890 2019-06-14 21:33:11.983687 1003 CAFC U.S. Court of Appeals for the Federal Circuit    
38 2018-01-31 19:52:54.643035 2019-06-14 21:33:12.006746 1004 USCIT U.S. Court of International Trade    
41 2018-01-31 19:52:54.679519 2019-06-14 21:33:12.082447 1005 CFC U.S. Court of Federal Claims    
42 2018-01-31 19:52:54.692029 2019-11-04 22:39:51.468022 1012   U.S. District and Territorial Courts    
43 2018-01-31 19:52:54.704322 2019-11-04 22:39:51.468022 1018 JPML U.S. Judicial Panel on Multidistrict Litigation    
31 2018-01-31 19:52:54.557605 2019-11-04 22:39:51.468022 1019   Temporary Emergency Court of Appeals    
44 2018-01-31 19:52:54.716541 2019-11-04 22:39:51.468022 1021   Bankruptcy Courts    
45 2018-01-31 19:52:54.728974 2019-11-04 22:39:51.468022 1023 FD Federal Public Defenders    
46 2018-01-31 19:52:54.741074 2019-11-04 22:39:51.468022 1025   Court Security    
39 2018-01-31 19:52:54.655377 2019-06-14 21:33:12.033130 1027 AO Administrative Office of the U.S. Courts    
40 2018-01-31 19:52:54.667454 2019-06-14 21:33:12.061988 1028 FJC Federal Judicial Center    
29 2018-01-31 19:52:54.533481 2019-06-14 21:33:11.011067 1030 USSC United States Sentencing Commission    
47 2018-01-31 19:52:54.753100 2019-11-04 22:39:51.468022 1037   Special Rail Reorganization Court    
32 2018-01-31 19:52:54.569643 2019-11-04 22:39:51.468022 1050   Chief Justice of the United States    
33 2018-01-31 19:52:54.581801 2019-11-04 22:39:51.468022 1051   Associate Justices of the Supreme Court    
34 2018-01-31 19:52:54.594551 2019-11-04 22:39:51.468022 1059   Supreme Court, Except Justices    
35 2018-01-31 19:52:54.606703 2019-06-14 21:33:11.820177 1060 USJC Judicial Conference of the United States    
48 2018-01-31 19:52:54.770629 2019-06-14 21:33:12.207042 1100 EOP Executive Office of the President    
49 2018-01-31 19:52:54.782644 2019-06-14 21:33:12.224824 1101 POTUS President of the United States    
50 2018-01-31 19:52:54.794949 2019-06-14 21:33:12.256018 1102 NSC National Security Council    
51 2018-01-31 19:52:54.807076 2019-06-14 21:33:12.352606 1103 OMB Office of Management and Budget    
52 2018-01-31 19:52:54.819081 2019-06-14 21:33:12.493325 1105 OA Office of Administration    
53 2018-01-31 19:52:54.831276 2019-06-14 21:33:12.601980 1109 USTR Office of the United States Trade Representative    
54 2018-01-31 19:52:54.844132 2019-11-04 22:39:51.468022 1110   Office of Policy Development    
55 2018-01-31 19:52:54.863638 2019-06-14 21:33:12.731794 1112 OSTP Office of Science and Technology Policy    
56 2018-01-31 19:52:54.875978 2019-06-14 21:33:12.759975 1113 CEA Council of Economic Advisors    
57 2018-01-31 19:52:54.891035 2019-11-04 22:39:51.468022 1117   White House Office    
58 2018-01-31 19:52:54.904509 2019-11-04 22:39:51.468022 1118   Executive Residence at the White House    
59 2018-01-31 19:52:54.916622 2019-06-14 21:33:12.863798 1119 CEQ Council on Environmental Quality    
60 2018-01-31 19:52:54.928755 2019-11-04 22:39:51.468022 1120   National Critical Materials Council    
61 2018-01-31 19:52:54.941074 2019-06-14 21:33:12.930664 1121 OMB Director, OMB    
62 2018-01-31 19:52:54.953219 2019-11-04 22:39:51.468022 1123   White House Conference on Indian Education    
63 2018-01-31 19:52:54.965350 2019-06-14 21:33:13.004667 1127 ONDCP Office of the National Drug Control Policy    
64 2018-01-31 19:52:54.977616 2019-06-14 21:33:13.018455 1129 OMB OMB, Except Director    
65 2018-01-31 19:52:54.989737 2019-11-04 22:39:51.468022 1130   National Space Council    
66 2018-01-31 19:52:55.001833 2019-11-04 22:39:51.468022 1140   President's Council on Sustainable Development    
67 2018-01-31 19:52:55.024224 2019-06-14 21:33:13.064400 1141 USADF African Development Foundation    
68 2018-01-31 19:52:55.044350 2019-06-14 21:33:13.085061 1143 IAF Inter-American Foundation    
89 2018-01-31 19:52:55.306614 2019-06-14 21:33:13.525067 1145 PC Peace Corps    
69 2018-01-31 19:52:55.056547 2019-11-04 22:39:51.468022 1148   Office of Homeland Security    
70 2018-01-31 19:52:55.068763 2019-11-04 22:39:51.468022 1150   International Development Cooperation Agency (Excludes OPIC)    
71 2018-01-31 19:52:55.081219 2019-06-14 21:33:13.127071 1151 IDCA Office of the Director, IDCA    
72 2018-01-31 19:52:55.093343 2019-06-14 21:33:29.744981 1152 USAID Agency for International Development    
90 2018-01-31 19:52:55.324153 2019-06-14 21:33:13.584080 1153 USTDA United States Trade and Development Agency    
73 2018-01-31 19:52:55.105504 2019-06-14 21:33:13.141675 1160 VPOTUS Office of the Vice President of the United States    
74 2018-01-31 19:52:55.117652 2019-11-04 22:39:51.468022 1162   Development Coordination Committee    
75 2018-01-31 19:52:55.129856 2019-11-04 22:39:51.468022 1165   White House Commission on Presidential Scholars    
76 2018-01-31 19:52:55.142302 2019-11-04 22:39:51.468022 1170   Commission on the Intelligence Capabilities of the U.S. Regarding Weapons of Mass Destruction    
77 2018-01-31 19:52:55.154461 2019-11-04 22:39:51.468022 11CA   West African Rice Development Association    
78 2018-01-31 19:52:55.166614 2019-06-14 21:33:13.213600 11DA IDA International Development Association    
79 2018-01-31 19:52:55.179033 2019-06-14 21:33:13.234278 11DB ADF African Development Fund    
80 2018-01-31 19:52:55.191162 2019-06-14 21:33:13.258723 11DE ADB Asian Development Bank    
81 2018-01-31 19:52:55.203369 2019-06-14 21:33:13.284690 11DF IFC International Finance Corporation    
82 2018-01-31 19:52:55.215855 2019-06-14 21:33:13.310807 11DG IFAD International Fund for Agricultural Development    
83 2018-01-31 19:52:55.228107 2019-06-14 21:33:13.330935 11DH IADB Inter-American Development Bank    
91 2018-01-31 19:52:55.336351 2019-11-04 22:39:51.468022 11DK EBRD European Bank for Reconstruction and Development    
84 2018-01-31 19:52:55.240348 2019-06-14 21:33:13.349797 11DM IMF International Monetary Fund    
92 2018-01-31 19:52:55.348524 2019-06-14 21:33:13.651243 11DN NADB North American Development Bank    
85 2018-01-31 19:52:55.252449 2019-06-14 21:33:13.372882 11DR WORLD BANK International Bank for Reconstruction and Development    
93 2018-01-31 19:52:55.360602 2019-06-14 21:33:13.690120 11DT IADB Inter-American Defense Board    
94 2018-01-31 19:52:55.372732 2019-11-04 22:39:51.468022 11DW MIGA Multilateral Investment Guarantee Agency    
86 2018-01-31 19:52:55.264543 2019-06-14 21:33:13.405931 11EA CGIAR Consultative Group on International Agricultural Research    
87 2018-01-31 19:52:55.276880 2019-06-14 21:33:13.443997 11RF MFO Multinational Force and Observers    

Next page

Download this data

CSV · JSON

View definition 
CREATE VIEW subtier_agency AS SELECT * FROM read_parquet(main.list_value('/data/usaspending/subtier_agency.parquet'));