roll_call_votes
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
48 rows where congress = 107 and result = "Bill Passed" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: session, legislation_type, yea_count, nay_count, present_count, not_voting_count, date (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 107,senate,2,249 | 107 | senate | 2 | 249 | 2002-11-19 | On Passage of the Bill H.R. 5005 | H.R. 5005, as amended -- A bill to establish the Department of Homeland Security, and for other purposes. | Bill Passed | 107-hr-5005 | H.R | 5005 | 90 | 9 | 0 | 1 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1072/vote_107_2_00249.xml | |
| 107,senate,2,204 | 107 | senate | 2 | 204 | 2002-08-01 | On Passage of the Bill H.R. 5010 | H.R. 5010, as amended -- A bill making appropriations for the Department of Defense for the fiscal year ending September 30, 2003, and for other purposes. | Bill Passed | 107-hr-5010 | H.R | 5010 | 95 | 3 | 0 | 2 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1072/vote_107_2_00204.xml | |
| 107,senate,2,201 | 107 | senate | 2 | 201 | 2002-07-31 | On Passage of the Bill S. 812 | S. 812, as amended -- A bill to amend the Federal Food, Drug, and Cosmetic Act to provide greater access to affordable pharmaceuticals. | Bill Passed | 107-s-812 | S | 812 | 78 | 21 | 0 | 1 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1072/vote_107_2_00201.xml | |
| 107,senate,2,191 | 107 | senate | 2 | 191 | 2002-07-25 | On Passage of the Bill H.R. 5121 | H.R. 5121, as amended -- A bill making appropriations for the Legislative Branch for the fiscal year ending September 30, 2003, and for other purposes. | Bill Passed | 107-hr-5121 | H.R | 5121 | 85 | 14 | 0 | 1 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1072/vote_107_2_00191.xml | |
| 107,senate,2,181 | 107 | senate | 2 | 181 | 2002-07-18 | On Passage of the Bill H.R. 5011 | H.R. 5011, as amended -- A bill making appropriations for military construction, family housing, and base realignment and closure for the Department of Defense for the fiscal year ending September 30, 2003, and for other purposes. | Bill Passed | 107-hr-5011 | H.R | 5011 | 96 | 3 | 0 | 1 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1072/vote_107_2_00181.xml | |
| 107,senate,2,176 | 107 | senate | 2 | 176 | 2002-07-15 | On Passage of the Bill S. 2673 | S. 2673, as amended -- An original bill to improve quality and transparency in financial reporting and independent audits and accounting services for public companies, to create a Public Company Accounting Oversight Board, to enhance the standard setting process for accounting practices, to strengthen the independence of firms that audit public companies, to increase corporate responsibility and the usefulness of corporate financial disclosure, to protect the objectivity and independence of securities analysts, to improve Securities and Exchange Commission resources and oversight, and for other purposes. | Bill Passed | 107-s-2673 | S | 2673 | 97 | 0 | 0 | 3 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1072/vote_107_2_00176.xml | |
| 107,senate,2,165 | 107 | senate | 2 | 165 | 2002-06-27 | On Passage of the Bill S. 2514 | S. 2514, as amended -- An original bill to authorize appropriations for fiscal year 2003 for military activities of the Department of Defense, for military construction, and for defense activities of the Department of Energy, to prescribe personnel strengths for such fiscal year for the Armed Forces, and for other purposes. | Bill Passed | 107-s-2514 | S | 2514 | 97 | 2 | 0 | 1 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1072/vote_107_2_00165.xml | |
| 107,senate,2,166 | 107 | senate | 2 | 166 | 2002-06-27 | On Passage of the Bill S. 2690 | S. 2690 -- A bill to reaffirm the reference to one Nation under God in the Pledge of Allegiance. | Bill Passed | 107-s-2690 | S | 2690 | 99 | 0 | 0 | 1 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1072/vote_107_2_00166.xml | |
| 107,senate,2,157 | 107 | senate | 2 | 157 | 2002-06-18 | On Passage of the Bill S. 2600 | S. 2600, as amended -- A bill to ensure the continued financial capacity of insurers to provide coverage for risks from terrorism. | Bill Passed | 107-s-2600 | S | 2600 | 84 | 14 | 0 | 2 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1072/vote_107_2_00157.xml | |
| 107,senate,2,154 | 107 | senate | 2 | 154 | 2002-06-14 | On Passage of the Bill H.R. 3275 | H.R. 3275, as amended -- A bill to implement the International Convention for the Suppression of Terrorist Bombings to strengthen criminal laws relating to attacks on places of public use, to implement the International Convention of the Suppression of the Financing of Terrorism, to combat terrorism and defend the Nation against terrorist acts, and for other purposes. | Bill Passed | 107-hr-3275 | H.R | 3275 | 83 | 1 | 0 | 16 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1072/vote_107_2_00154.xml | |
| 107,senate,2,148 | 107 | senate | 2 | 148 | 2002-06-11 | On Passage of the Bill S. 2578 | S. 2578 -- A bill to amend title 31 of the United States Code to increase the public debt limit. | Bill Passed | 107-s-2578 | S | 2578 | 68 | 29 | 0 | 3 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1072/vote_107_2_00148.xml | |
| 107,senate,2,145 | 107 | senate | 2 | 145 | 2002-06-07 | On Passage of the Bill H.R. 4775 | H.R. 4775, as amended -- A bill making supplemental appropriations for the fiscal year ending September 30, 2002, and for other purposes. | Bill Passed | 107-hr-4775 | H.R | 4775 | 71 | 22 | 0 | 7 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1072/vote_107_2_00145.xml | |
| 107,senate,2,130 | 107 | senate | 2 | 130 | 2002-05-23 | On Passage of the Bill H.R. 3009 | H.R. 3009, as amended -- A bill to extend the Andean Trade Preference Act, to grant additional trade benefits under that Act, and for other purposes. | Bill Passed | 107-hr-3009 | H.R | 3009 | 66 | 30 | 0 | 4 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1072/vote_107_2_00130.xml | |
| 107,senate,2,116 | 107 | senate | 2 | 116 | 2002-05-17 | On Passage of the Bill H.R. 3167 | H.R. 3167 -- A bill to endorse the vision of further enlargement of the NATO Alliance articulated by President George W. Bush on June 15, 2001, and by former President William J. Clinton on October 22, 1996, and for other purposes. | Bill Passed | 107-hr-3167 | H.R | 3167 | 85 | 6 | 0 | 9 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1072/vote_107_2_00116.xml | |
| 107,senate,2,94 | 107 | senate | 2 | 94 | 2002-04-25 | On Passage of the Bill H.R. 4 | H.R. 4, as amended -- A bill to enhance energy conservation, research and development and to provide for security and diversity in the energy supply for the American people, and for other purposes. | Bill Passed | 107-hr-4 | H.R | 4 | 88 | 11 | 0 | 1 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1072/vote_107_2_00094.xml | |
| 107,senate,2,65 | 107 | senate | 2 | 65 | 2002-04-11 | On Passage of the Bill S. 565 | S.565, as amended -- A bill to require States and localities to meet uniform and nondiscriminatory election technology and administration requirements applicable to Federal elections, to establish grant programs to provide assistance to States and localities to met those requirements and to improve election technology and the administration of Federal elections, to establish the Election Administration Commission, and for other purposes. | Bill Passed | 107-s-565 | S | 565 | 99 | 1 | 0 | 0 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1072/vote_107_2_00065.xml | |
| 107,senate,2,54 | 107 | senate | 2 | 54 | 2002-03-20 | On Passage of the Bill H.R. 2356 | Passage of H.R. 2356 -- A bill to amend the Federal Election Campaign Act of 1971 to provide bipartisan campaign reform. | Bill Passed | 107-hr-2356 | H.R | 2356 | 60 | 40 | 0 | 0 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1072/vote_107_2_00054.xml | |
| 107,senate,2,30 | 107 | senate | 2 | 30 | 2002-02-13 | On Passage of the Bill H.R. 2646 | H.R. 2646, as amended -- To provide for the continuation of agricultural programs through fiscal year 2007, and for other purposes. | Bill Passed | 107-hr-2646 | H.R | 2646 | 58 | 40 | 0 | 2 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1072/vote_107_2_00030.xml | |
| 107,senate,1,351 | 107 | senate | 1 | 351 | 2001-12-05 | On Passage of the Bill H.R. 10 | H.R. 10, as amended -- An Act to modernize the financing of the railroad retirement system and to provide enhanced benefits to employees and beneficiaries. | Bill Passed | 107-hr-10 | H.R | 10 | 90 | 9 | 0 | 1 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00351.xml | |
| 107,senate,1,332 | 107 | senate | 1 | 332 | 2001-11-08 | On Passage of the Bill H.R. 2883 | H.R. 2883, as amended -- A bill to authorize appropriations for fiscal year 2002 for intelligence and intelligence-related activities of the United States Government, the Community Management Account, and the Central Intelligence Agency Retirement and Disability System, and for other purposes. | Bill Passed | 107-hr-2883 | H.R | 2883 | 100 | 0 | 0 | 0 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00332.xml | |
| 107,senate,1,331 | 107 | senate | 1 | 331 | 2001-11-07 | On Passage of the Bill H.R. 2944 | H.R. 2944, as amended -- A bill making appropriations for the government of the District of Columbia and other activities chargeable in whole or in part against the revenues of said District for the fiscal year ending September 30, 2002, and for other purposes. | Bill Passed | 107-hr-2944 | H.R | 2944 | 75 | 24 | 0 | 1 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00331.xml | |
| 107,senate,1,324 | 107 | senate | 1 | 324 | 2001-11-06 | On Passage of the Bill H.R. 3061 | H.R. 3061, as amended -- A bill making appropriations for the Departments of Labor, Health and Human Services, and Education, and related agencies for the fiscal year ending September 30, 2002, and for other purposes. | Bill Passed | 107-hr-3061 | H.R | 3061 | 89 | 10 | 0 | 1 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00324.xml | |
| 107,senate,1,313 | 107 | senate | 1 | 313 | 2001-10-25 | On Passage of the Bill H.R. 3162 | H.R. 3162 -- A bill to deter and punish terrorist acts in the United States and around the world, to enhance law enforcement investigatory tools, and for other purposes. | Bill Passed | 107-hr-3162 | H.R | 3162 | 98 | 1 | 0 | 1 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00313.xml | |
| 107,senate,1,315 | 107 | senate | 1 | 315 | 2001-10-25 | On Passage of the Bill H.R. 2330 | H.R. 2330, As Passed -- A bill making appropriations for Agriculture, Rural Development, Food and Drug Administration, and Related Agencies programs for the fiscal year ending September 30, 2002, and for other purposes. | Bill Passed | 107-hr-2330 | H.R | 2330 | 91 | 5 | 0 | 4 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00315.xml | |
| 107,senate,1,312 | 107 | senate | 1 | 312 | 2001-10-24 | On Passage of the Bill H.R. 2506 | H.R. 2506, as amended -- A bill making appropriations for foreign operations, export financing, and related programs for the fiscal year ending September 30, 2002, and for other purposes. | Bill Passed | 107-hr-2506 | H.R | 2506 | 96 | 2 | 0 | 2 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00312.xml | |
| 107,senate,1,295 | 107 | senate | 1 | 295 | 2001-10-11 | On Passage of the Bill S. 1447 | S.1447, as amended -- A bill to improve aviation security, and for other purposes. | Bill Passed | 107-s-1447 | S | 1447 | 100 | 0 | 0 | 0 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00295.xml | |
| 107,senate,1,302 | 107 | senate | 1 | 302 | 2001-10-11 | On Passage of the Bill S. 1510 | S.1510 -- A bill to deter and punish terrorist acts in the United States and around the world, to enhance law enforcement investigatory tools, and for other purposes. | Bill Passed | 107-s-1510 | S | 1510 | 96 | 1 | 0 | 3 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00302.xml | |
| 107,senate,1,290 | 107 | senate | 1 | 290 | 2001-10-02 | On Passage of the Bill S. 1438 | S. 1438, as amended -- A bill to authorize appropriations for fiscal year 2002 for military activities of the Department of Defense, for military constructions, and for defense activities of the Department of Energy, to prescribe personnel strengths for such fiscal year for the Armed Forces, and for other purposes. | Bill Passed | 107-s-1438 | S | 1438 | 99 | 0 | 0 | 1 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00290.xml | |
| 107,senate,1,288 | 107 | senate | 1 | 288 | 2001-09-26 | On Passage of the Bill H.R. 2904 | H.R. 2904, as amended -- A bill making appropriations for military construction, family housing, and base realignment and closure for the Department of Defense for the fiscal year ending September 30, 2002, and for other purposes. | Bill Passed | 107-hr-2904 | H.R | 2904 | 97 | 0 | 0 | 3 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00288.xml | |
| 107,senate,1,284 | 107 | senate | 1 | 284 | 2001-09-21 | On Passage of the Bill S. 1450 | S.1450 -- A bill to preserve the continued viability of the United States air transportation system. | Bill Passed | 107-s-1450 | S | 1450 | 96 | 1 | 0 | 3 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00284.xml | |
| 107,senate,1,280 | 107 | senate | 1 | 280 | 2001-09-14 | On Passage of the Bill S. 1426 | S. 1426 -- A bill making emergency supplemental appropriations for fiscal year 2001 for additional disaster assistance, for anti-terrorism initiatives, and for assistance in the recovery from the tragedy that occurred on September 11, 2001, and for other purposes. | Bill Passed | 107-s-1426 | S | 1426 | 96 | 0 | 0 | 4 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00280.xml | |
| 107,senate,1,279 | 107 | senate | 1 | 279 | 2001-09-13 | On Passage of the Bill H.R. 2500 | H.R. 2500, as amended -- A bill making appropriations for the Departments of Commerce, Justice, and State, the Judiciary, and related agencies for the fiscal year ending September 30, 2002, and for other purposes. | Bill Passed | 107-hr-2500 | H.R | 2500 | 97 | 0 | 0 | 3 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00279.xml | |
| 107,senate,1,275 | 107 | senate | 1 | 275 | 2001-09-06 | On Passage of the Bill S. 149 | S.149, as amended -- A bill to provide authority to control exports, and for other purposes. | Bill Passed | 107-s-149 | S | 149 | 85 | 14 | 0 | 1 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00275.xml | |
| 107,senate,1,269 | 107 | senate | 1 | 269 | 2001-08-02 | On Passage of the Bill H.R. 2620 | H.R. 2620 -- A bill making appropriations for the Departments of Veterans Affairs and Housing and Urban Development, and for sundry independent agencies, boards, commissions, corporations, and offices for the fiscal year ending September 30, 2002, and for other purposes. | Bill Passed | 107-hr-2620 | H.R | 2620 | 94 | 5 | 0 | 1 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00269.xml | |
| 107,senate,1,251 | 107 | senate | 1 | 251 | 2001-07-25 | On Passage of the Bill S. 1218 | S. 1218 -- An original bill to extend the authorities of the Iran and Libya Sanctions Act of 1996 until 2006. | Bill Passed | 107-s-1218 | S | 1218 | 96 | 2 | 0 | 2 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00251.xml | |
| 107,senate,1,240 | 107 | senate | 1 | 240 | 2001-07-19 | On Passage of the Bill H.R. 2311 | H.R. 2311, as amended -- A bill making appropriations for energy and water development for the fiscal year ending September 30, 2002, and for other purposes. | Bill Passed | 107-hr-2311 | H.R | 2311 | 97 | 2 | 0 | 1 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00240.xml | |
| 107,senate,1,241 | 107 | senate | 1 | 241 | 2001-07-19 | On Passage of the Bill S. 1172 | S. 1172, as amended -- An original bill making appropriations for the Legislative Branch for the fiscal year ending September 30, 2002, and for other purposes. | Bill Passed | 107-s-1172 | S | 1172 | 88 | 9 | 0 | 3 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00241.xml | |
| 107,senate,1,236 | 107 | senate | 1 | 236 | 2001-07-17 | On Passage of the Bill H.R. 333 | H.R. 333, as amended -- A bill to amend title 11, United States Code, and for other purposes. | Bill Passed | 107-hr-333 | H.R | 333 | 82 | 16 | 1 | 1 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00236.xml | |
| 107,senate,1,228 | 107 | senate | 1 | 228 | 2001-07-10 | On Passage of the Bill H.R. 2216 | H.R. 2216, as amended -- A bill making supplemental appropriations for the fiscal year ending September 30, 2001, and for other purposes. | Bill Passed | 107-hr-2216 | H.R | 2216 | 98 | 1 | 0 | 1 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00228.xml | |
| 107,senate,1,220 | 107 | senate | 1 | 220 | 2001-06-29 | On Passage of the Bill S. 1052 | S.1052, as amended -- A bill to amend the Public Health Service Act and the Employee Retirement Income Security Act of 1974 to protect consumers in managed care plans and other health coverage. | Bill Passed | 107-s-1052 | S | 1052 | 59 | 36 | 0 | 5 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00220.xml | |
| 107,senate,1,192 | 107 | senate | 1 | 192 | 2001-06-14 | On Passage of the Bill H.R. 1 | H.R. 1, as amended -- A bill to close the achievement gap with accountability, flexibility, and choice, so that no child is left behind. | Bill Passed | 107-hr-1 | H.R | 1 | 91 | 8 | 0 | 1 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00192.xml | |
| 107,senate,1,165 | 107 | senate | 1 | 165 | 2001-05-23 | On Passage of the Bill H.R. 1836 | H.R. 1836, as amended -- A bill to provide for reconciliation pursuant to section 104 of the concurrent resolution on the budget for fiscal year 2002. | Bill Passed | 107-hr-1836 | H.R | 1836 | 62 | 38 | 0 | 0 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00165.xml | |
| 107,senate,1,87 | 107 | senate | 1 | 87 | 2001-04-25 | On Passage of the Bill S. 350 | S. 350, as amended -- A bill to amend the Comprehensive Environmental Response, Compensation, and Liability Act of 1980 to promote the cleanup and reuse of brownfields, to provide financial assistance for brownfields revitalization, to enhance State response programs, and for other purposes. | Bill Passed | 107-s-350 | S | 350 | 99 | 0 | 0 | 1 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00087.xml | |
| 107,senate,1,64 | 107 | senate | 1 | 64 | 2001-04-02 | On Passage of the Bill S. 27 | S. 27, as amended -- A bill to amend the Federal Election Campaign Act of 1971 to provide bipartisan campaign reform. | Bill Passed | 107-s-27 | S | 27 | 59 | 41 | 0 | 0 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00064.xml | |
| 107,senate,1,36 | 107 | senate | 1 | 36 | 2001-03-15 | On Passage of the Bill S. 420 | S.420, As Amended -- An original bill to amend title 11, United States Code, and for other purposes. | Bill Passed | 107-s-420 | S | 420 | 83 | 15 | 1 | 1 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00036.xml | |
| 107,senate,1,12 | 107 | senate | 1 | 12 | 2001-02-14 | On Passage of the Bill S. 320 | S. 320 -- A bill to make technical corrections in patent, copyright, and trademark laws. | Bill Passed | 107-s-320 | S | 320 | 98 | 0 | 0 | 2 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00012.xml | |
| 107,senate,1,11 | 107 | senate | 1 | 11 | 2001-02-08 | On Passage of the Bill S. 235 | S.235 -- A bill to provide for enhanced safety, public awareness, and environmental protection in pipeline transportation, and for other purposes. | Bill Passed | 107-s-235 | S | 235 | 98 | 0 | 0 | 2 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00011.xml | |
| 107,senate,1,10 | 107 | senate | 1 | 10 | 2001-02-07 | On Passage of the Bill S. 248 | S.248 -- A bill to amend the Admiral James W. Nance and Meg Donovan Foreign Relations Authorization Act, Fiscal Years 2000 and 2001, to adjust a condition on the payment of arrearages to the United Nations that sets the maximum share of any United Nations peacekeeping operation's budget that may be assessed of any country. | Bill Passed | 107-s-248 | S | 248 | 99 | 0 | 0 | 1 | https://www.senate.gov/legislative/LIS/roll_call_votes/vote1071/vote_107_1_00010.xml |
Advanced export
JSON shape: default, array, newline-delimited, object
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);