-- The Federal Blacklist Is Mostly People - and Three Agencies Run It.
-- Source: public.sam_exclusions (SAM.gov Exclusions), active records only.
-- Re-running these aggregate queries against the 2026-06-20 snapshot reproduces
-- the classification and excluding-agency counts in the committed snapshot.

SELECT classification, count(*) FROM sam_exclusions WHERE status='Active' GROUP BY classification ORDER BY 2 DESC;
-- Individual                    258,536
-- Special Entity Designation     46,866
-- Firm                           16,243
-- Vessel                          2,481

SELECT excluding_agency, count(*) FROM sam_exclusions WHERE status='Active' GROUP BY excluding_agency ORDER BY 2 DESC;
-- HHS    137,396
-- OPM     80,948
-- OFAC    73,853
-- DOJ      6,490
-- HUD      4,464
-- EPA      4,375
-- null     4,335
-- USN      1,736
-- ICE      1,658
-- DLA      1,237
