home / openregs

OGE senior officials by department

Count of named PAS (Presidentially Appointed, Senate-Confirmed) officials per department, with filing counts.

Custom SQL query returning 39 rows (hide)

SELECT department, COUNT(DISTINCT filer_slug) AS distinct_officials,
    COUNT(*) AS n_filings
FROM oge_pas_filings
GROUP BY department
ORDER BY distinct_officials DESC

Edit SQL

This data as json, CSV

departmentdistinct_officialsn_filings
Department of Transportation 13 102
Federal Reserve System Board of Governors 12 58
Office of Director of National Intelligence 8 42
Department of Defense/Office of The Secretary 7 30
Department of The Interior 7 37
Department of Homeland Security 6 43
Office of Management and Budget 6 23
Department of Health and Human Services 5 29
Department of Housing and Urban Development 5 16
Department of Justice 5 28
Department of State 5 23
Department of The Treasury 5 28
Department of Veterans Affairs 5 20
Department of Education 4 28
Department of Energy 4 42
Department of Agriculture 3 11
Department of The Air Force 3 28
Department of The Navy 3 22
National Aeronautics and Space Administration 3 16
Office of National Drug Control Policy 3 25
Office of Personnel Management 3 18
Office of Science and Technology Policy 3 24
Office of the National Cyber Director 3 18
Social Security Administration 3 16
Central Intelligence Agency 2 11
Council of Economic Advisers 2 9
Department Of Energy 2 2
Department of The Army 2 6
Millennium Challenge Corporation 2 11
National Science Foundation 2 8
Office Of Director Of National Intelligence 2 2
Office of The Us Trade Representative 2 5
Agency for International Development (AID) 1 2
Consumer Financial Protection Bureau 1 1
Department Of Labor 1 1
Department of Commerce 1 5
Department of Labor 1 4
Federal Housing Finance Agency 1 4
Office Of The Us Trade Representative 1 1
Powered by Datasette · Queries took 8.064ms