roll_call_votes

Roll call votes in the House and Senate, Congresses 106–119. Includes vote question, result, and linked bill.

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

5,278 rows where result = "Failed" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

congress 14

result 1

  • Failed · 5,278 ✖

chamber 1

Link congress chamber session roll_call_number date ▲ question vote_type description result bill_id legislation_type legislation_number yea_count nay_count present_count not_voting_count source_url
119,house,2,293 119 house 2 293 2026-09-02 On Motion to Suspend the Rules and Pass 2/3 Yea-And-Nay 2/3 Yea-And-Nay Failed 119-hjres-1 HJRES 1 212 206 0 15 https://clerk.house.gov/evs/2026/roll293.xml
119,house,2,290 119 house 2 290 2026-09-01 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-9436 HR 9436 202 212 0 18 https://clerk.house.gov/evs/2026/roll290.xml
119,house,2,274 119 house 2 274 2026-07-22 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       207 224 0 6 https://clerk.house.gov/evs/2026/roll274.xml
119,house,2,276 119 house 2 276 2026-07-22 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       175 254 0 7 https://clerk.house.gov/evs/2026/roll276.xml
119,house,2,277 119 house 2 277 2026-07-22 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-8800 HR 8800 213 216 0 2 https://clerk.house.gov/evs/2026/roll277.xml
119,house,2,279 119 house 2 279 2026-07-22 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-7008 HR 7008 211 218 0 2 https://clerk.house.gov/evs/2026/roll279.xml
119,house,2,255 119 house 2 255 2026-07-21 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       65 361 0 10 https://clerk.house.gov/evs/2026/roll255.xml
119,house,2,256 119 house 2 256 2026-07-21 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       61 360 0 15 https://clerk.house.gov/evs/2026/roll256.xml
119,house,2,257 119 house 2 257 2026-07-21 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       65 359 0 12 https://clerk.house.gov/evs/2026/roll257.xml
119,house,2,259 119 house 2 259 2026-07-21 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       208 219 0 9 https://clerk.house.gov/evs/2026/roll259.xml
119,house,2,261 119 house 2 261 2026-07-21 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       212 216 0 8 https://clerk.house.gov/evs/2026/roll261.xml
119,house,2,262 119 house 2 262 2026-07-21 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       201 224 0 11 https://clerk.house.gov/evs/2026/roll262.xml
119,house,2,263 119 house 2 263 2026-07-21 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       61 365 0 10 https://clerk.house.gov/evs/2026/roll263.xml
119,house,2,264 119 house 2 264 2026-07-21 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       76 350 0 10 https://clerk.house.gov/evs/2026/roll264.xml
119,house,2,266 119 house 2 266 2026-07-21 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       212 217 0 7 https://clerk.house.gov/evs/2026/roll266.xml
119,house,2,269 119 house 2 269 2026-07-21 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       214 216 0 7 https://clerk.house.gov/evs/2026/roll269.xml
119,house,2,270 119 house 2 270 2026-07-21 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-6955 HR 6955 210 216 0 5 https://clerk.house.gov/evs/2026/roll270.xml
119,house,2,249 119 house 2 249 2026-07-16 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-9237 HR 9237 210 211 0 10 https://clerk.house.gov/evs/2026/roll249.xml
119,house,2,241 119 house 2 241 2026-07-15 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       79 348 0 9 https://clerk.house.gov/evs/2026/roll241.xml
119,house,2,242 119 house 2 242 2026-07-15 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       178 247 0 11 https://clerk.house.gov/evs/2026/roll242.xml
119,house,2,243 119 house 2 243 2026-07-15 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       104 314 10 9 https://clerk.house.gov/evs/2026/roll243.xml
119,house,2,244 119 house 2 244 2026-07-15 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       6 421 0 10 https://clerk.house.gov/evs/2026/roll244.xml
119,house,2,245 119 house 2 245 2026-07-15 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       136 291 0 9 https://clerk.house.gov/evs/2026/roll245.xml
119,house,2,246 119 house 2 246 2026-07-15 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-8595 HR 8595 209 216 0 6 https://clerk.house.gov/evs/2026/roll246.xml
119,house,2,239 119 house 2 239 2026-07-14 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-1181 HR 1181 208 217 0 6 https://clerk.house.gov/evs/2026/roll239.xml
119,house,2,231 119 house 2 231 2026-06-30 On Agreeing to the Resolution Recorded Vote Recorded Vote Failed 119-hres-1398 HRES 1398 198 224 0 9 https://clerk.house.gov/evs/2026/roll231.xml
119,house,2,232 119 house 2 232 2026-06-30 On Agreeing to the Resolution Yea-and-Nay Yea-and-Nay Failed 119-hconres-108 HCONRES 108 189 235 0 7 https://clerk.house.gov/evs/2026/roll232.xml
119,house,2,221 119 house 2 221 2026-06-11 On Motion to Suspend the Rules and Pass 2/3 Yea-And-Nay 2/3 Yea-And-Nay Failed       198 218 0 15 https://clerk.house.gov/evs/2026/roll221.xml
119,house,2,219 119 house 2 219 2026-06-10 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-8464 HR 8464 209 213 0 9 https://clerk.house.gov/evs/2026/roll219.xml
119,house,2,213 119 house 2 213 2026-06-09 On Motion to Commit Yea-and-Nay Yea-and-Nay Failed 119-s-2 S 2 211 215 0 4 https://clerk.house.gov/evs/2026/roll213.xml
119,house,2,201 119 house 2 201 2026-06-04 On Agreeing to the Resolution Yea-and-Nay Yea-and-Nay Failed 119-hconres-84 HCONRES 84 92 324 2 12 https://clerk.house.gov/evs/2026/roll201.xml
119,house,2,204 119 house 2 204 2026-06-04 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-8646 HR 8646 210 212 0 8 https://clerk.house.gov/evs/2026/roll204.xml
119,house,2,197 119 house 2 197 2026-06-03 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-7726 HR 7726 210 213 0 7 https://clerk.house.gov/evs/2026/roll197.xml
119,house,2,187 119 house 2 187 2026-05-21 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-1329 HR 1329 209 209 0 12 https://clerk.house.gov/evs/2026/roll187.xml
119,house,2,188 119 house 2 188 2026-05-21 On Passage Yea-and-Nay Yea-and-Nay Failed 119-hr-1329 HR 1329 204 216 0 10 https://clerk.house.gov/evs/2026/roll188.xml
119,house,2,189 119 house 2 189 2026-05-21 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-1041 HR 1041 208 210 0 12 https://clerk.house.gov/evs/2026/roll189.xml
119,house,2,183 119 house 2 183 2026-05-20 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-2616 HR 2616 207 208 0 15 https://clerk.house.gov/evs/2026/roll183.xml
119,house,2,174 119 house 2 174 2026-05-15 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       80 333 0 22 https://clerk.house.gov/evs/2026/roll174.xml
119,house,2,168 119 house 2 168 2026-05-14 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-6260 HR 6260 210 213 0 7 https://clerk.house.gov/evs/2026/roll168.xml
119,house,2,170 119 house 2 170 2026-05-14 On Agreeing to the Resolution Yea-and-Nay Yea-and-Nay Failed 119-hconres-75 HCONRES 75 212 212 0 6 https://clerk.house.gov/evs/2026/roll170.xml
119,house,2,172 119 house 2 172 2026-05-14 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-8365 HR 8365 210 213 0 7 https://clerk.house.gov/evs/2026/roll172.xml
119,house,2,163 119 house 2 163 2026-05-13 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-1346 HR 1346 112 309 0 9 https://clerk.house.gov/evs/2026/roll163.xml
119,house,2,144 119 house 2 144 2026-04-30 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       210 216 0 9 https://clerk.house.gov/evs/2026/roll144.xml
119,house,2,147 119 house 2 147 2026-04-30 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       69 355 0 11 https://clerk.house.gov/evs/2026/roll147.xml
119,house,2,149 119 house 2 149 2026-04-30 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       187 239 0 10 https://clerk.house.gov/evs/2026/roll149.xml
119,house,2,151 119 house 2 151 2026-04-30 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       186 238 0 11 https://clerk.house.gov/evs/2026/roll151.xml
119,house,2,153 119 house 2 153 2026-04-30 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-7567 HR 7567 211 214 0 5 https://clerk.house.gov/evs/2026/roll153.xml
119,house,2,133 119 house 2 133 2026-04-22 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-4690 HR 4690 203 214 0 13 https://clerk.house.gov/evs/2026/roll133.xml
119,house,2,135 119 house 2 135 2026-04-22 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-6387 HR 6387 206 214 0 10 https://clerk.house.gov/evs/2026/roll135.xml
119,house,2,123 119 house 2 123 2026-04-17 On Agreeing to the Amendment Yea-and-Nay Yea-and-Nay Failed       200 220 0 11 https://clerk.house.gov/evs/2026/roll123.xml
119,house,2,124 119 house 2 124 2026-04-17 On Agreeing to the Resolution Recorded Vote Recorded Vote Failed 119-hres-1175 HRES 1175 197 228 0 6 https://clerk.house.gov/evs/2026/roll124.xml
119,house,2,114 119 house 2 114 2026-04-16 On Agreeing to the Resolution Yea-and-Nay Yea-and-Nay Failed 119-hconres-40 HCONRES 40 213 214 1 3 https://clerk.house.gov/evs/2026/roll114.xml
119,house,2,115 119 house 2 115 2026-04-16 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-6409 HR 6409 213 215 0 3 https://clerk.house.gov/evs/2026/roll115.xml
119,house,2,117 119 house 2 117 2026-04-16 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-6398 HR 6398 213 216 0 2 https://clerk.house.gov/evs/2026/roll117.xml
119,house,2,103 119 house 2 103 2026-03-26 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-8029 HR 8029 210 215 0 7 https://clerk.house.gov/evs/2026/roll103.xml
119,house,2,100 119 house 2 100 2026-03-25 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-5103 HR 5103 207 214 0 11 https://clerk.house.gov/evs/2026/roll100.xml
119,house,2,92 119 house 2 92 2026-03-18 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-556 HR 556 206 209 0 17 https://clerk.house.gov/evs/2026/roll092.xml
119,house,2,95 119 house 2 95 2026-03-18 On Motion to Suspend the Rules and Pass 2/3 Yea-And-Nay 2/3 Yea-And-Nay Failed 119-hjres-139 HJRES 139 211 207 0 14 https://clerk.house.gov/evs/2026/roll095.xml
119,house,2,85 119 house 2 85 2026-03-05 On Agreeing to the Resolution Yea-and-Nay Yea-and-Nay Failed 119-hconres-38 HCONRES 38 212 219 0 1 https://clerk.house.gov/evs/2026/roll085.xml
119,house,2,86 119 house 2 86 2026-03-05 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-7744 HR 7744 212 217 0 3 https://clerk.house.gov/evs/2026/roll086.xml
119,house,2,77 119 house 2 77 2026-02-25 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-4758 HR 4758 198 208 0 26 https://clerk.house.gov/evs/2026/roll077.xml
119,house,2,72 119 house 2 72 2026-02-24 On Motion to Suspend the Rules and Pass 2/3 Yea-And-Nay 2/3 Yea-And-Nay Failed 119-s-2503 S 2503 264 133 0 35 https://clerk.house.gov/evs/2026/roll072.xml
119,house,2,75 119 house 2 75 2026-02-24 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-4626 HR 4626 197 208 0 27 https://clerk.house.gov/evs/2026/roll075.xml
119,house,2,63 119 house 2 63 2026-02-11 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-3617 HR 3617 214 215 0 3 https://clerk.house.gov/evs/2026/roll063.xml
119,house,2,66 119 house 2 66 2026-02-11 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-261 HR 261 214 216 0 2 https://clerk.house.gov/evs/2026/roll066.xml
119,house,2,68 119 house 2 68 2026-02-11 On Motion to Commit Yea-and-Nay Yea-and-Nay Failed 119-s-1383 S 1383 214 217 0 1 https://clerk.house.gov/evs/2026/roll068.xml
119,house,2,60 119 house 2 60 2026-02-10 On Agreeing to the Resolution Recorded Vote Recorded Vote Failed 119-hres-1042 HRES 1042 214 217 0 1 https://clerk.house.gov/evs/2026/roll060.xml
119,house,2,54 119 house 2 54 2026-02-04 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-4090 HR 4090 209 212 0 11 https://clerk.house.gov/evs/2026/roll054.xml
119,house,2,43 119 house 2 43 2026-01-22 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       164 268 0 4 https://clerk.house.gov/evs/2026/roll043.xml
119,house,2,44 119 house 2 44 2026-01-22 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       136 291 0 9 https://clerk.house.gov/evs/2026/roll044.xml
119,house,2,46 119 house 2 46 2026-01-22 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-6359 HR 6359 213 216 0 2 https://clerk.house.gov/evs/2026/roll046.xml
119,house,2,48 119 house 2 48 2026-01-22 On Agreeing to the Resolution Yea-and-Nay Yea-and-Nay Failed 119-hconres-68 HCONRES 68 215 215 0 1 https://clerk.house.gov/evs/2026/roll048.xml
119,house,2,36 119 house 2 36 2026-01-21 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-6945 HR 6945 209 213 0 9 https://clerk.house.gov/evs/2026/roll036.xml
119,house,2,30 119 house 2 30 2026-01-15 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-2988 HR 2988 206 210 0 15 https://clerk.house.gov/evs/2026/roll030.xml
119,house,2,26 119 house 2 26 2026-01-14 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       163 257 1 16 https://clerk.house.gov/evs/2026/roll026.xml
119,house,2,27 119 house 2 27 2026-01-14 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       127 291 0 18 https://clerk.house.gov/evs/2026/roll027.xml
119,house,2,18 119 house 2 18 2026-01-13 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-2262 HR 2262 209 213 0 9 https://clerk.house.gov/evs/2026/roll018.xml
119,house,2,19 119 house 2 19 2026-01-13 On Passage Yea-and-Nay Yea-and-Nay Failed 119-hr-2262 HR 2262 209 215 0 7 https://clerk.house.gov/evs/2026/roll019.xml
119,house,2,20 119 house 2 20 2026-01-13 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-2270 HR 2270 209 213 0 9 https://clerk.house.gov/evs/2026/roll020.xml
119,house,2,21 119 house 2 21 2026-01-13 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-2312 HR 2312 209 215 0 7 https://clerk.house.gov/evs/2026/roll021.xml
119,house,2,22 119 house 2 22 2026-01-13 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-4593 HR 4593 209 215 0 7 https://clerk.house.gov/evs/2026/roll022.xml
119,house,2,8 119 house 2 8 2026-01-08 Passage, Objections of the President To The Contrary Notwithstanding 2/3 Yea-And-Nay 2/3 Yea-And-Nay Failed 119-hr-504 HR 504 236 188 0 7 https://clerk.house.gov/evs/2026/roll008.xml
119,house,2,9 119 house 2 9 2026-01-08 Passage, Objections of the President To The Contrary Notwithstanding 2/3 Yea-And-Nay 2/3 Yea-And-Nay Failed 119-hr-131 HR 131 248 177 1 5 https://clerk.house.gov/evs/2026/roll009.xml
119,house,1,352 119 house 1 352 2025-12-18 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       205 220 0 14 https://clerk.house.gov/evs/2025/roll352.xml
119,house,1,353 119 house 1 353 2025-12-18 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       208 214 0 16 https://clerk.house.gov/evs/2025/roll353.xml
119,house,1,354 119 house 1 354 2025-12-18 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       204 217 0 17 https://clerk.house.gov/evs/2025/roll354.xml
119,house,1,355 119 house 1 355 2025-12-18 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-4776 HR 4776 206 211 0 16 https://clerk.house.gov/evs/2025/roll355.xml
119,house,1,357 119 house 1 357 2025-12-18 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-1366 HR 1366 205 213 0 15 https://clerk.house.gov/evs/2025/roll357.xml
119,house,1,359 119 house 1 359 2025-12-18 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-845 HR 845 204 213 0 16 https://clerk.house.gov/evs/2025/roll359.xml
119,house,1,361 119 house 1 361 2025-12-18 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-498 HR 498 204 212 0 17 https://clerk.house.gov/evs/2025/roll361.xml
119,house,1,345 119 house 1 345 2025-12-17 On Agreeing to the Resolution Yea-and-Nay Yea-and-Nay Failed 119-hconres-61 HCONRES 61 210 216 0 7 https://clerk.house.gov/evs/2025/roll345.xml
119,house,1,346 119 house 1 346 2025-12-17 On Agreeing to the Resolution Yea-and-Nay Yea-and-Nay Failed 119-hconres-64 HCONRES 64 211 213 0 9 https://clerk.house.gov/evs/2025/roll346.xml
119,house,1,348 119 house 1 348 2025-12-17 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-6703 HR 6703 210 218 0 5 https://clerk.house.gov/evs/2025/roll348.xml
119,house,1,350 119 house 1 350 2025-12-17 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-3492 HR 3492 210 218 0 5 https://clerk.house.gov/evs/2025/roll350.xml
119,house,1,339 119 house 1 339 2025-12-16 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-4371 HR 4371 208 218 0 7 https://clerk.house.gov/evs/2025/roll339.xml
119,house,1,341 119 house 1 341 2025-12-16 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-3632 HR 3632 207 218 0 8 https://clerk.house.gov/evs/2025/roll341.xml
119,house,1,333 119 house 1 333 2025-12-12 On Motion to Recommit Yea-and-Nay Yea-and-Nay Failed 119-hr-3668 HR 3668 194 204 0 34 https://clerk.house.gov/evs/2025/roll333.xml
119,house,1,325 119 house 1 325 2025-12-11 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       54 374 0 11 https://clerk.house.gov/evs/2025/roll325.xml
119,house,1,326 119 house 1 326 2025-12-11 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       211 219 0 8 https://clerk.house.gov/evs/2025/roll326.xml
119,house,1,327 119 house 1 327 2025-12-11 On Agreeing to the Amendment Recorded Vote Recorded Vote Failed       214 215 0 9 https://clerk.house.gov/evs/2025/roll327.xml

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE roll_call_votes (
    congress INTEGER NOT NULL,
    chamber TEXT NOT NULL,
    session INTEGER,
    roll_call_number INTEGER NOT NULL,
    date TEXT,
    question TEXT,
    vote_type TEXT,
    description TEXT,
    result TEXT,
    bill_id TEXT,
    legislation_type TEXT,
    legislation_number TEXT,
    yea_count INTEGER,
    nay_count INTEGER,
    present_count INTEGER,
    not_voting_count INTEGER,
    source_url TEXT,
    PRIMARY KEY (congress, chamber, session, roll_call_number)
);
CREATE INDEX idx_rcv_date ON roll_call_votes(date);
CREATE INDEX idx_rcv_bill ON roll_call_votes(bill_id);
CREATE INDEX idx_rcv_congress ON roll_call_votes(congress);
CREATE INDEX idx_rcv_result ON roll_call_votes(result);
CREATE INDEX idx_rcv_compound ON roll_call_votes(congress, chamber, session, roll_call_number);