Nomination Confirmation Rates by Congress

Confirmation, withdrawal, return, and rejection rates for presidential nominations by Congress.

Custom SQL query returning 20 rows (hide) 

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, 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

Edit SQL

This data as json, CSV

congresstotalconfirmedwithdrawnreturnedrejectedconfirm_pct
100 1533 1325 2 177 1 86.4
101 1675 1480 0 131 0 88.4
102 1574 1298 0 233 0 82.5
103 2033 1835 0 175 0 90.3
104 1336 1097 0 196 0 82.1
105 1460 1280 0 132 0 87.7
106 1450 1173 0 247 0 80.9
107 2321 1854 0 380 0 79.9
108 2056 1774 0 236 0 86.3
109 2201 1916 0 237 0 87.1
110 2153 1844 0 232 0 85.6
111 2442 2201 0 203 0 90.1
112 2070 1868 0 161 0 90.2
113 2221 1694 0 495 0 76.3
114 1931 1595 0 300 0 82.6
115 2654 2175 0 416 0 82.0
116 2378 2009 0 324 0 84.5
117 2783 2344 0 354 0 84.2
118 2299 1898 0 369 0 82.6
119 1497 1136 0 113 0 75.9