nomination_rates (view)

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

20 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: withdrawn, rejected, pending, confirm_pct

congress total confirmed withdrawn returned rejected pending confirm_pct
100 1533 1325 2 177 1 28 86.4
101 1675 1480 0 131 0 64 88.4
102 1574 1298 0 233 0 43 82.5
103 2033 1835 0 175 0 23 90.3
104 1336 1097 0 196 0 43 82.1
105 1460 1280 0 132 0 48 87.7
106 1450 1173 0 247 0 30 80.9
107 2321 1854 0 380 0 87 79.9
108 2056 1774 0 236 0 46 86.3
109 2201 1916 0 237 0 48 87.1
110 2153 1844 0 232 0 77 85.6
111 2442 2201 0 203 0 38 90.1
112 2070 1868 0 161 0 41 90.2
113 2221 1694 0 495 0 32 76.3
114 1931 1595 0 300 0 36 82.6
115 2654 2175 0 416 0 63 82.0
116 2378 2009 0 324 0 45 84.5
117 2783 2344 0 354 0 85 84.2
118 2299 1898 0 369 0 32 82.6
119 1497 1136 0 113 0 248 75.9

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW nomination_rates AS
SELECT
    congress,
    COUNT(*) AS total,
    SUM(CASE WHEN status = 'Confirmed' THEN 1 ELSE 0 END) AS confirmed,
    SUM(CASE WHEN status = 'Withdrawn' THEN 1 ELSE 0 END) AS withdrawn,
    SUM(CASE WHEN status = 'Returned' THEN 1 ELSE 0 END) AS returned,
    SUM(CASE WHEN status = 'Rejected' THEN 1 ELSE 0 END) AS rejected,
    SUM(CASE WHEN status = 'Pending' THEN 1 ELSE 0 END) AS pending,
    ROUND(100.0 * SUM(CASE WHEN status = 'Confirmed' THEN 1 ELSE 0 END) / COUNT(*), 1) AS confirm_pct
FROM nominations
GROUP BY congress
ORDER BY congress;