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

department	distinct_officials	n_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