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

166 rows where congress = 111 and result = "Agreed to" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session, question, vote_type, description, legislation_type, present_count, date (date)

result 1

  • Agreed to · 166 ✖

congress 1

  • 111 · 166 ✖

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
111,house,1,962 111 house 1 962 2009-12-11 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-4173 HR 4173 228 198 0 14 https://clerk.house.gov/evs/2009/roll962.xml
111,house,1,964 111 house 1 964 2009-12-11 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-4173 HR 4173 277 149 0 14 https://clerk.house.gov/evs/2009/roll964.xml
111,house,1,953 111 house 1 953 2009-12-10 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-4173 HR 4173 240 182 0 18 https://clerk.house.gov/evs/2009/roll953.xml
111,house,1,955 111 house 1 955 2009-12-10 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-4173 HR 4173 228 202 0 10 https://clerk.house.gov/evs/2009/roll955.xml
111,house,1,956 111 house 1 956 2009-12-10 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-4173 HR 4173 304 124 0 12 https://clerk.house.gov/evs/2009/roll956.xml
111,house,1,899 111 house 1 899 2009-11-18 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3791 HR 3791 358 75 0 7 https://clerk.house.gov/evs/2009/roll899.xml
111,house,1,900 111 house 1 900 2009-11-18 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3791 HR 3791 371 63 0 6 https://clerk.house.gov/evs/2009/roll900.xml
111,house,1,884 111 house 1 884 2009-11-07 On Agreeing to the Amendment YEA-AND-NAY   Agreed to 111-hr-3962 HR 3962 240 194 1 0 https://clerk.house.gov/evs/2009/roll884.xml
111,house,1,869 111 house 1 869 2009-11-06 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2868 HR 2868 253 168 0 19 https://clerk.house.gov/evs/2009/roll869.xml
111,house,1,845 111 house 1 845 2009-11-04 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3639 HR 3639 427 0 0 11 https://clerk.house.gov/evs/2009/roll845.xml
111,house,1,846 111 house 1 846 2009-11-04 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3639 HR 3639 427 0 0 11 https://clerk.house.gov/evs/2009/roll846.xml
111,house,1,847 111 house 1 847 2009-11-04 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3639 HR 3639 251 174 0 13 https://clerk.house.gov/evs/2009/roll847.xml
111,house,1,848 111 house 1 848 2009-11-04 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3639 HR 3639 353 71 0 14 https://clerk.house.gov/evs/2009/roll848.xml
111,house,1,849 111 house 1 849 2009-11-04 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3639 HR 3639 249 173 0 16 https://clerk.house.gov/evs/2009/roll849.xml
111,house,1,828 111 house 1 828 2009-10-29 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3854 HR 3854 370 55 0 13 https://clerk.house.gov/evs/2009/roll828.xml
111,house,1,812 111 house 1 812 2009-10-23 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3619 HR 3619 398 0 0 40 https://clerk.house.gov/evs/2009/roll812.xml
111,house,1,802 111 house 1 802 2009-10-22 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3585 HR 3585 395 24 0 19 https://clerk.house.gov/evs/2009/roll802.xml
111,house,1,803 111 house 1 803 2009-10-22 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3585 HR 3585 414 5 0 19 https://clerk.house.gov/evs/2009/roll803.xml
111,house,1,804 111 house 1 804 2009-10-22 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3585 HR 3585 407 9 0 22 https://clerk.house.gov/evs/2009/roll804.xml
111,house,1,805 111 house 1 805 2009-10-22 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3585 HR 3585 420 0 0 18 https://clerk.house.gov/evs/2009/roll805.xml
111,house,1,806 111 house 1 806 2009-10-22 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3585 HR 3585 410 6 0 22 https://clerk.house.gov/evs/2009/roll806.xml
111,house,1,713 111 house 1 713 2009-09-17 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3221 HR 3221 428 2 0 9 https://clerk.house.gov/evs/2009/roll713.xml
111,house,1,714 111 house 1 714 2009-09-17 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3221 HR 3221 428 0 0 11 https://clerk.house.gov/evs/2009/roll714.xml
111,house,1,715 111 house 1 715 2009-09-17 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3221 HR 3221 425 5 0 9 https://clerk.house.gov/evs/2009/roll715.xml
111,house,1,716 111 house 1 716 2009-09-17 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3221 HR 3221 425 0 0 14 https://clerk.house.gov/evs/2009/roll716.xml
111,house,1,706 111 house 1 706 2009-09-16 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3246 HR 3246 369 62 0 8 https://clerk.house.gov/evs/2009/roll706.xml
111,house,1,707 111 house 1 707 2009-09-16 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3246 HR 3246 416 14 0 9 https://clerk.house.gov/evs/2009/roll707.xml
111,house,1,683 111 house 1 683 2009-07-31 On Agreeing to the Amendment, as Modified RECORDED VOTE   Agreed to 111-hr-3269 HR 3269 242 178 0 13 https://clerk.house.gov/evs/2009/roll683.xml
111,house,1,661 111 house 1 661 2009-07-30 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3326 HR 3326 269 165 0 5 https://clerk.house.gov/evs/2009/roll661.xml
111,house,1,641 111 house 1 641 2009-07-24 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3293 HR 3293 284 137 0 18 https://clerk.house.gov/evs/2009/roll641.xml
111,house,1,578 111 house 1 578 2009-07-17 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3183 HR 3183 424 0 1 14 https://clerk.house.gov/evs/2009/roll578.xml
111,house,1,579 111 house 1 579 2009-07-17 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3183 HR 3183 423 1 0 15 https://clerk.house.gov/evs/2009/roll579.xml
111,house,1,543 111 house 1 543 2009-07-15 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3183 HR 3183 261 172 0 5 https://clerk.house.gov/evs/2009/roll543.xml
111,house,1,544 111 house 1 544 2009-07-15 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3183 HR 3183 362 69 0 7 https://clerk.house.gov/evs/2009/roll544.xml
111,house,1,545 111 house 1 545 2009-07-15 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3183 HR 3183 432 0 0 6 https://clerk.house.gov/evs/2009/roll545.xml
111,house,1,546 111 house 1 546 2009-07-15 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3183 HR 3183 429 4 0 5 https://clerk.house.gov/evs/2009/roll546.xml
111,house,1,547 111 house 1 547 2009-07-15 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3183 HR 3183 431 1 0 6 https://clerk.house.gov/evs/2009/roll547.xml
111,house,1,498 111 house 1 498 2009-07-09 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2997 HR 2997 266 161 0 11 https://clerk.house.gov/evs/2009/roll498.xml
111,house,1,499 111 house 1 499 2009-07-09 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2997 HR 2997 404 27 0 7 https://clerk.house.gov/evs/2009/roll499.xml
111,house,1,500 111 house 1 500 2009-07-09 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2997 HR 2997 426 3 0 9 https://clerk.house.gov/evs/2009/roll500.xml
111,house,1,516 111 house 1 516 2009-07-09 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3081 HR 3081 261 168 0 9 https://clerk.house.gov/evs/2009/roll516.xml
111,house,1,519 111 house 1 519 2009-07-09 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3081 HR 3081 297 135 0 6 https://clerk.house.gov/evs/2009/roll519.xml
111,house,1,521 111 house 1 521 2009-07-09 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-3081 HR 3081 429 2 0 7 https://clerk.house.gov/evs/2009/roll521.xml
111,house,1,483 111 house 1 483 2009-07-08 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2965 HR 2965 427 4 0 7 https://clerk.house.gov/evs/2009/roll483.xml
111,house,1,454 111 house 1 454 2009-06-25 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2647 HR 2647 224 190 0 25 https://clerk.house.gov/evs/2009/roll454.xml
111,house,1,457 111 house 1 457 2009-06-25 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2647 HR 2647 224 193 0 22 https://clerk.house.gov/evs/2009/roll457.xml
111,house,1,458 111 house 1 458 2009-06-25 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2647 HR 2647 416 0 0 23 https://clerk.house.gov/evs/2009/roll458.xml
111,house,1,435 111 house 1 435 2009-06-24 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2892 HR 2892 345 85 0 9 https://clerk.house.gov/evs/2009/roll435.xml
111,house,1,436 111 house 1 436 2009-06-24 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2892 HR 2892 375 55 0 9 https://clerk.house.gov/evs/2009/roll436.xml
111,house,1,437 111 house 1 437 2009-06-24 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2892 HR 2892 282 148 0 9 https://clerk.house.gov/evs/2009/roll437.xml
111,house,1,438 111 house 1 438 2009-06-24 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2892 HR 2892 423 6 0 10 https://clerk.house.gov/evs/2009/roll438.xml
111,house,1,439 111 house 1 439 2009-06-24 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2892 HR 2892 240 187 1 11 https://clerk.house.gov/evs/2009/roll439.xml
111,house,1,442 111 house 1 442 2009-06-24 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2892 HR 2892 349 84 0 6 https://clerk.house.gov/evs/2009/roll442.xml
111,house,1,357 111 house 1 357 2009-06-18 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2847 HR 2847 418 3 0 18 https://clerk.house.gov/evs/2009/roll357.xml
111,house,1,358 111 house 1 358 2009-06-18 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2847 HR 2847 389 35 0 15 https://clerk.house.gov/evs/2009/roll358.xml
111,house,1,363 111 house 1 363 2009-06-18 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2847 HR 2847 343 87 0 9 https://clerk.house.gov/evs/2009/roll363.xml
111,house,1,365 111 house 1 365 2009-06-18 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2847 HR 2847 422 0 0 17 https://clerk.house.gov/evs/2009/roll365.xml
111,house,1,368 111 house 1 368 2009-06-18 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2847 HR 2847 262 162 0 15 https://clerk.house.gov/evs/2009/roll368.xml
111,house,1,371 111 house 1 371 2009-06-18 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2847 HR 2847 417 1 0 21 https://clerk.house.gov/evs/2009/roll371.xml
111,house,1,383 111 house 1 383 2009-06-18 On Agreeing to the Amendment YEA-AND-NAY   Agreed to 111-hr-2847 HR 2847 251 168 0 14 https://clerk.house.gov/evs/2009/roll383.xml
111,house,1,384 111 house 1 384 2009-06-18 On Agreeing to the Amendment YEA-AND-NAY   Agreed to 111-hr-2847 HR 2847 405 1 0 27 https://clerk.house.gov/evs/2009/roll384.xml
111,house,1,388 111 house 1 388 2009-06-18 On Agreeing to the Amendment YEA-AND-NAY   Agreed to 111-hr-2847 HR 2847 405 12 0 16 https://clerk.house.gov/evs/2009/roll388.xml
111,house,1,390 111 house 1 390 2009-06-18 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2847 HR 2847 414 0 0 19 https://clerk.house.gov/evs/2009/roll390.xml
111,house,1,392 111 house 1 392 2009-06-18 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2847 HR 2847 416 1 0 16 https://clerk.house.gov/evs/2009/roll392.xml
111,house,1,394 111 house 1 394 2009-06-18 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2847 HR 2847 411 1 1 20 https://clerk.house.gov/evs/2009/roll394.xml
111,house,1,396 111 house 1 396 2009-06-18 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2847 HR 2847 387 31 0 15 https://clerk.house.gov/evs/2009/roll396.xml
111,house,1,398 111 house 1 398 2009-06-18 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2847 HR 2847 338 74 0 21 https://clerk.house.gov/evs/2009/roll398.xml
111,house,1,400 111 house 1 400 2009-06-18 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2847 HR 2847 413 0 0 20 https://clerk.house.gov/evs/2009/roll400.xml
111,house,1,406 111 house 1 406 2009-06-18 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2847 HR 2847 402 13 0 18 https://clerk.house.gov/evs/2009/roll406.xml
111,house,1,353 111 house 1 353 2009-06-17 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2847 HR 2847 411 14 0 14 https://clerk.house.gov/evs/2009/roll353.xml
111,house,1,354 111 house 1 354 2009-06-17 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2847 HR 2847 425 4 0 10 https://clerk.house.gov/evs/2009/roll354.xml
111,house,1,355 111 house 1 355 2009-06-17 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2847 HR 2847 422 2 0 15 https://clerk.house.gov/evs/2009/roll355.xml
111,house,1,320 111 house 1 320 2009-06-10 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2410 HR 2410 257 171 0 11 https://clerk.house.gov/evs/2009/roll320.xml
111,house,1,322 111 house 1 322 2009-06-10 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2410 HR 2410 429 0 0 10 https://clerk.house.gov/evs/2009/roll322.xml
111,house,1,323 111 house 1 323 2009-06-10 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2410 HR 2410 432 0 0 7 https://clerk.house.gov/evs/2009/roll323.xml
111,house,1,326 111 house 1 326 2009-06-10 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2410 HR 2410 428 3 0 8 https://clerk.house.gov/evs/2009/roll326.xml
111,house,1,304 111 house 1 304 2009-06-04 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2200 HR 2200 219 211 0 9 https://clerk.house.gov/evs/2009/roll304.xml
111,house,1,305 111 house 1 305 2009-06-04 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2200 HR 2200 310 118 0 11 https://clerk.house.gov/evs/2009/roll305.xml
111,house,1,288 111 house 1 288 2009-05-21 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-915 HR 915 420 0 0 19 https://clerk.house.gov/evs/2009/roll288.xml
111,house,1,289 111 house 1 289 2009-05-21 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-915 HR 915 417 2 0 20 https://clerk.house.gov/evs/2009/roll289.xml
111,house,1,279 111 house 1 279 2009-05-20 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2352 HR 2352 427 0 0 12 https://clerk.house.gov/evs/2009/roll279.xml
111,house,1,255 111 house 1 255 2009-05-14 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2187 HR 2187 334 97 0 8 https://clerk.house.gov/evs/2009/roll255.xml
111,house,1,256 111 house 1 256 2009-05-14 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2187 HR 2187 433 0 0 6 https://clerk.house.gov/evs/2009/roll256.xml
111,house,1,257 111 house 1 257 2009-05-14 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2187 HR 2187 433 0 0 6 https://clerk.house.gov/evs/2009/roll257.xml
111,house,1,249 111 house 1 249 2009-05-13 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2187 HR 2187 270 160 0 9 https://clerk.house.gov/evs/2009/roll249.xml
111,house,1,250 111 house 1 250 2009-05-13 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2187 HR 2187 432 2 0 5 https://clerk.house.gov/evs/2009/roll250.xml
111,house,1,251 111 house 1 251 2009-05-13 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-2187 HR 2187 425 7 0 7 https://clerk.house.gov/evs/2009/roll251.xml
111,house,1,238 111 house 1 238 2009-05-07 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-1728 HR 1728 245 176 0 18 https://clerk.house.gov/evs/2009/roll238.xml
111,house,1,225 111 house 1 225 2009-04-30 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-627 HR 627 276 154 0 9 https://clerk.house.gov/evs/2009/roll225.xml
111,house,1,226 111 house 1 226 2009-04-30 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-627 HR 627 284 149 0 6 https://clerk.house.gov/evs/2009/roll226.xml
111,house,1,213 111 house 1 213 2009-04-28 On Agreeing to the Amendment YEA-AND-NAY   Agreed to 111-hres-371 HRES 371 240 179 0 13 https://clerk.house.gov/evs/2009/roll213.xml
111,house,1,200 111 house 1 200 2009-04-23 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-1145 HR 1145 424 0 0 14 https://clerk.house.gov/evs/2009/roll200.xml
111,house,1,201 111 house 1 201 2009-04-23 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-1145 HR 1145 423 1 0 14 https://clerk.house.gov/evs/2009/roll201.xml
111,house,1,180 111 house 1 180 2009-04-01 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-1664 HR 1664 228 198 1 10 https://clerk.house.gov/evs/2009/roll180.xml
111,house,1,181 111 house 1 181 2009-04-01 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-1664 HR 1664 246 180 1 10 https://clerk.house.gov/evs/2009/roll181.xml
111,house,1,157 111 house 1 157 2009-03-26 On Agreeing to the Amendment RECORDED VOTE Federal Land Assistance, Managment and Enhancement Act Agreed to 111-hr-1404 HR 1404 420 0 0 17 https://clerk.house.gov/evs/2009/roll157.xml
111,house,1,158 111 house 1 158 2009-03-26 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-1404 HR 1404 420 0 0 17 https://clerk.house.gov/evs/2009/roll158.xml
111,house,1,159 111 house 1 159 2009-03-26 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-1404 HR 1404 422 0 0 15 https://clerk.house.gov/evs/2009/roll159.xml
111,house,1,160 111 house 1 160 2009-03-26 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-1404 HR 1404 418 2 0 17 https://clerk.house.gov/evs/2009/roll160.xml
111,house,1,133 111 house 1 133 2009-03-18 On Agreeing to the Amendment RECORDED VOTE   Agreed to 111-hr-1388 HR 1388 388 36 0 13 https://clerk.house.gov/evs/2009/roll133.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);