legislation
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
31 rows where bill_type = "sconres" and policy_area = "Crime and Law Enforcement" sorted by introduced_date descending
This data as json, CSV (advanced)
Suggested facets: bill_number, title, introduced_date, latest_action_date, latest_action_text, sponsor_name, sponsor_state, sponsor_party, sponsor_bioguide_id, cosponsor_count, summary_text, update_date, introduced_date (date), latest_action_date (date), update_date (date)
| bill_id | congress | bill_type | bill_number | title | policy_area | introduced_date ▲ | latest_action_date | latest_action_text | origin_chamber | sponsor_name | sponsor_state | sponsor_party | sponsor_bioguide_id | cosponsor_count | summary_text | update_date | url |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 119-sconres-25 | 119 | sconres | 25 | A concurrent resolution recognizing the 15th anniversary of the January 8, 2011, Tucson, Arizona, shooting and honoring the survivors and victims, including former Congresswoman Gabby Giffords, a gun violence survivor and one of the most influential voices of courage in the United States in the fight to end gun violence. | Crime and Law Enforcement | 2026-01-08 | 2026-02-13 | Held at the desk. | Senate | Sen. Gillibrand, Kirsten E. [D-NY] | NY | D | G000555 | 41 | 2026-02-14T09:06:07Z | ||
| 119-sconres-15 | 119 | sconres | 15 | A concurrent resolution expressing support for America's law enforcement professionals. | Crime and Law Enforcement | 2025-06-18 | 2025-06-23 | Held at the desk. | Senate | Sen. Cassidy, Bill [R-LA] | LA | R | C001075 | 11 | 2025-09-30T16:21:44Z | ||
| 118-sconres-38 | 118 | sconres | 38 | A concurrent resolution expressing the sense of Congress that Operation Legend was successful in reducing and combating violent crime in the largest cities of the United States and that a future presidential administration committed to enforcing and maintaining law and order should consider implementing a similar policy. | Crime and Law Enforcement | 2024-07-24 | 2024-07-24 | Referred to the Committee on the Judiciary. (text: CR S5347) | Senate | Sen. Blackburn, Marsha [R-TN] | TN | R | B001243 | 9 | 2025-07-21T19:32:26Z | ||
| 116-sconres-52 | 116 | sconres | 52 | A concurrent resolution to correct the enrollment of S. 3312. | Crime and Law Enforcement | 2020-12-14 | 2020-12-20 | Message on Senate action sent to the House. | Senate | Sen. Cornyn, John [R-TX] | TX | R | C001056 | 1 | This concurrent resolution directs the Secretary of the Senate to make corrections in the enrollment of S. 3312 (Crisis Stabilization and Community Reentry Act of 2020), which authorizes the Department of Justice to award grants to provide clinical services for individuals with serious mental illness and substance use disorders who need post-release mental health services. The resolution expands the entities that are eligible for grants to include Indian tribes, units of local government, and community-based nonprofit organizations. | 2023-01-11T13:43:45Z | |
| 116-sconres-40 | 116 | sconres | 40 | A concurrent resolution expressing the sense of Congress that undue restrictions on the right of law-abiding gun owners to carry a firearm for self-defense outside of the home violate the Second Amendment to the Constitution of the United States. | Crime and Law Enforcement | 2020-06-23 | 2020-06-23 | Referred to the Committee on the Judiciary. (text: CR S3159) | Senate | Sen. Loeffler, Kelly [R-GA] | GA | R | L000594 | 0 | This concurrent resolution expresses the sense of Congress that undue restrictions on the right of law-abiding gun owners to carry a firearm for self-defense outside of the home violate the Second Amendment to the Constitution. | 2023-01-11T13:46:06Z | |
| 115-sconres-28 | 115 | sconres | 28 | A concurrent resolution providing for a correction in the enrollment of S. 782. | Crime and Law Enforcement | 2017-10-26 | 2017-11-02 | Motion to reconsider laid on the table Agreed to without objection. | Senate | Sen. Cornyn, John [R-TX] | TX | R | C001056 | 0 | (This measure has not been amended since it was introduced. The summary of that version is repeated here.) Directs the Secretary of the Senate to make specified technical corrections in the enrollment of S. 782 (PROTECT Our Children Act of 2017). | 2023-01-11T13:38:12Z | |
| 114-sconres-6 | 114 | sconres | 6 | A concurrent resolution expressing the sense of Congress that John Arthur "Jack" Johnson should receive a posthumous pardon for the racially motivated conviction in 1913 that diminished the athletic, cultural, and historic significance of Jack Johnson and unduly tarnished his reputation. | Crime and Law Enforcement | 2015-02-26 | 2015-02-26 | Referred to the Committee on the Judiciary. (text of measure as introduced: CR S1172) | Senate | Sen. McCain, John [R-AZ] | AZ | R | M000303 | 1 | Expresses the sense of Congress that Jack Johnson (the first African-American professional boxer to hold the title of Heavyweight Champion of the World) should receive a posthumous pardon to expunge from the annals of American criminal justice a racially motivated abuse of the federal government's prosecutorial authority and to recognize his athletic and cultural contributions to society. | 2023-01-11T13:28:16Z | |
| 113-sconres-29 | 113 | sconres | 29 | A concurrent resolution expressing the sense of the Congress that children trafficked in the United States be treated as victims of crime, and not as perpetrators. | Crime and Law Enforcement | 2013-11-21 | 2013-11-21 | Referred to the Committee on the Judiciary. (text of measure as introduced: CR S8467) | Senate | Sen. Hatch, Orrin G. [R-UT] | UT | R | H000338 | 8 | Expressing the sense of Congress that: (1) law enforcement, judges, child welfare agencies, and the public should treat children being trafficked for sex as victims of child abuse; (2) every effort should be made to arrest and hold accountable both traffickers and buyers of children for sex, in accordance with federal laws to protect victims of trafficking and state child protection laws; (3) the child welfare system requires reform to better prevent domestic child sex trafficking and aid the victims; and (4) such system should identify, assess, and provide supportive services to children in its care who are victims of sex trafficking or at risk of becoming such victims. Expresses support for: (1) survivors of domestic sex trafficking, including for the services they need to heal; and (2) an end to demand for girls by declaring that our nation's daughters are not for sale and that any person who purchases a child for sex should be held accountable with the full force of the law. | 2023-01-11T13:23:41Z | |
| 113-sconres-5 | 113 | sconres | 5 | A concurrent resolution expressing the sense of Congress that John Arthur "Jack" Johnson should receive a posthumous pardon for the racially motivated conviction in 1913 that diminished the athletic, cultural, and historic significance of Jack Johnson and unduly tarnished his reputation. | Crime and Law Enforcement | 2013-03-05 | 2013-04-18 | Referred to the House Committee on the Judiciary. | Senate | Sen. McCain, John [R-AZ] | AZ | R | M000303 | 2 | (This measure has not been amended since it was introduced. The summary of that version is repeated here.) Expresses the sense of Congress that Jack Johnson (the first African-American professional boxer to hold the title of Heavyweight Champion of the World) should receive a posthumous pardon to expunge from the annals of American criminal justice a racially motivated abuse of the federal government's prosecutorial authority and to recognize his athletic and cultural contributions to society. | 2022-11-15T16:32:25Z | |
| 112-sconres-53 | 112 | sconres | 53 | A concurrent resolution honoring the victims of the Aurora, Colorado, movie theater shooting and condemning the atrocities that occurred in Aurora, Colorado. | Crime and Law Enforcement | 2012-07-24 | 2012-07-24 | Referred to the Committee on the Judiciary. (text of measure as introduced: CR S5309) | Senate | Sen. Udall, Mark [D-CO] | CO | D | U000038 | 99 | Condemns the atrocities that occurred in Aurora, Colorado, on July 20, 2012. Offers condolences to the families, friends, and loved ones of those who were killed. Expresses hope for the rapid and complete recovery of the wounded. Applauds the hard work and dedication exhibited by the hundreds of officials and others who offered support and assistance. Honors the resilience of the community of Aurora and Colorado. | 2021-12-20T15:36:38Z | |
| 112-sconres-22 | 112 | sconres | 22 | A concurrent resolution expressing the sense of Congress that John Arthur "Jack" Johnson should receive a posthumous pardon for the racially motivated conviction in 1913 that diminished the athletic, cultural, and heroic significance of Jack Johnson and unduly tarnished his reputation. | Crime and Law Enforcement | 2011-05-24 | 2011-05-24 | Referred to the Committee on the Judiciary. (text of measure as introduced: CR S3280) | Senate | Sen. McCain, John [R-AZ] | AZ | R | M000303 | 1 | Expresses the sense of Congress that Jack Johnson (the first African-American professional boxer to hold the title of Heavyweight Champion of the World) should receive a posthumous pardon to expunge from the annals of American criminal justice a racially motivated abuse of the federal government's prosecutorial authority and to recognize his athletic and cultural contributions to society. | 2019-02-20T22:45:01Z | |
| 111-sconres-29 | 111 | sconres | 29 | A concurrent resolution expressing the sense of the Congress that John Arthur "Jack" Johnson should receive a posthumous pardon for the racially motivated conviction in 1913 that diminished the athletic, cultural, and historic significance of Jack Johnson and unduly tarnished his reputation. | Crime and Law Enforcement | 2009-06-16 | 2009-07-29 | Motion to reconsider laid on the table Agreed to without objection. | Senate | Sen. McCain, John [R-AZ] | AZ | R | M000303 | 3 | (This measure has not been amended since it was introduced. The summary of that version is repeated here.)Expresses the sense of Congress that Jack Johnson (the first African-American professional boxer to hold the title of Heavyweight Champion of the World) should receive a posthumous pardon to expunge from the annals of American criminal justice a racially motivated abuse of the federal government's prosecutorial authority and to recognize his athletic and cultural contributions to society. | 2023-01-11T13:18:34Z | |
| 111-sconres-22 | 111 | sconres | 22 | A concurrent resolution supporting the goals and ideals of National Sexual Assault Awareness and Prevention Month 2009. | Crime and Law Enforcement | 2009-04-30 | 2009-04-30 | Referred to the Committee on the Judiciary. (text of measure as introduced: CR S4979) | Senate | Sen. Casey, Robert P., Jr. [D-PA] | PA | D | C001070 | 1 | Expresses support for the goals and ideals of National Sexual Assault Awareness and Prevention Month 2009. Calls for recognition of: (1) national and community organizations and private sector supporters for their work in promoting awareness about sexual assault, providing information and treatment to its survivors, and increasing the number of successful prosecutions of its perpetrators; and (2) public safety, law enforcement, and health professionals for their hard work and innovative strategies to increase the percentage of sexual assault cases that result in the prosecution and incarceration of the offenders. Urges national and community organizations, private businesses, colleges and universities, and the media to promote, through such Month, awareness of sexual violence and strategies to decrease the incidence of sexual assault. | 2023-01-11T13:19:20Z | |
| 111-sconres-16 | 111 | sconres | 16 | A concurrent resolution expressing the sense of the Senate that the President of the United States should exercise his constitutional authority to pardon posthumously John Arthur "Jack" Johnson for the racially motivated conviction in 1913 that diminished the athletic, cultural, and historic significance of Jack Johnson and unduly tarnished his reputation. | Crime and Law Enforcement | 2009-04-01 | 2009-04-01 | Referred to the Committee on the Judiciary. (text of measure as introduced: CR S4196-4197) | Senate | Sen. McCain, John [R-AZ] | AZ | R | M000303 | 1 | Calls for the President to grant a pardon, posthumously, to Jack Johnson (the first African-American professional boxer to hold the title of Heavyweight Champion of the World) to expunge from the annals of American criminal justice a racially motivated abuse of the federal government's prosecutorial authority and to recognize his athletic and cultural contributions to society. | 2023-01-11T13:19:20Z | |
| 109-sconres-112 | 109 | sconres | 112 | A concurrent resolution relating to correcting a clerical error in the enrollment of S. 3693. | Crime and Law Enforcement | 2006-07-20 | 2006-07-29 | Motion to reconsider laid on the table Agreed to without objection. | Senate | Sen. Reid, Harry [D-NV] | NV | D | R000146 | 0 | (This measure has not been amended since it was introduced. The summary of that version is repeated here.)Directs the Secretary of the Senate to make a correction in the enrollment of S. 3693 (technical corrections to the Violence Against Women and Department of Justice Reauthorization Act of 2005) relating to provisions of the Immigration and Naturalization Act granting waivers of inadmissibility to aliens who are victims of domestic violence. | 2023-01-12T17:52:26Z | |
| 109-sconres-102 | 109 | sconres | 102 | A concurrent resolution condemning the decision by the city of St. Denis, France, to name a street in honor of Mumia Abu-Jamal, the convicted murderer of Philadelphia Police Officer Danny Faulkner. | Crime and Law Enforcement | 2006-06-15 | 2006-06-15 | Referred to the Committee on Foreign Relations. (text of measure as introduced: CR S5967) | Senate | Sen. Santorum, Rick [R-PA] | PA | R | S000059 | 0 | Condemns the murder of Philadelphia Police Officer Danny Faulkner. Urges the municipal government of St. Denis, France, to change the name of Rue Mumia Abu-Jamal and, if such action is not taken by the municipal government of St. Denis, urges the government of France to take appropriate action against St. Denis to change the name of Rue Mumia Abu-Jamal. Commends all police officers in the United States and throughout the world for their commitment to public service and public safety. | 2023-01-13T04:50:35Z | |
| 109-sconres-3 | 109 | sconres | 3 | A concurrent resolution expressing the sense of the Congress with respect to the murder of Emmett Till. | Crime and Law Enforcement | 2005-01-24 | 2005-01-24 | Referred to the Committee on the Judiciary. (text of measure as introduced: CR S369-370) | Senate | Sen. Schumer, Charles E. [D-NY] | NY | D | S000148 | 1 | Calls on: (1) all authorities with jurisdiction, including the Department of Justice (DOJ) and the State of Mississippi, to expeditiously bring those responsible for the 1955 murder of Emmett Till to justice and provide all the resources necessary to ensure a timely and thorough investigation; and (2) DOJ to fully report the findings of the investigation to Congress. | 2019-11-15T21:55:34Z | |
| 108-sconres-150 | 108 | sconres | 150 | A concurrent resolution expressing the sense of Congress with respect to the murder of Emmett Till. | Crime and Law Enforcement | 2004-11-19 | 2004-11-19 | Referred to the Committee on the Judiciary. (text of measure as introduced: CR 11/20/2004 S11650-11651) | Senate | Sen. Schumer, Charles E. [D-NY] | NY | D | S000148 | 1 | Calls on: (1) all authorities with jurisdiction, including the Department of Justice (DOJ) and the State of Mississippi, to expeditiously bring those responsible for the 1955 murder of Emmett Till to justice and provide all the resources necessary to ensure a timely and thorough investigation; and (2) DOJ to fully report the findings of the investigation to Congress. | 2023-01-14T22:48:29Z | |
| 108-sconres-77 | 108 | sconres | 77 | A concurrent resolution expressing the sense of Congress supporting vigorous enforcement of the Federal obscenity laws. | Crime and Law Enforcement | 2003-10-28 | 2003-12-10 | Referred to the Subcommittee on Crime, Terrorism, and Homeland Security. | Senate | Sen. Sessions, Jeff [R-AL] | AL | R | S001141 | 5 | (This measure has not been amended since it was introduced. The summary of that version is repeated here.) Calls for vigorous enforcement of Federal obscenity laws. | 2023-01-15T09:17:40Z | |
| 106-sconres-120 | 106 | sconres | 120 | A concurrent resolution to express the sense of Congress regarding the need to pass legislation to increase penalties on perpetrators of hate crimes. | Crime and Law Enforcement | 2000-06-07 | 2000-06-07 | Referred to the Committee on the Judiciary. (text of measure as introduced: CR S4694) | Senate | Sen. Robb, Charles S. [D-VA] | VA | D | R000295 | 2 | Declares that Congress: (1) needs to pass legislation to set penalties for persons who commit acts of violence against other persons because of the actual or perceived race, color, religion, national origin, gender, sexual orientation, or disability of any person; (2) condemns the culture of hate and the hate groups that foster such violent acts; (3) commends the communities throughout our Nation that are united in condemning such acts of hate in their neighborhoods, and the efforts of Federal, state, and local law enforcement officials; (4) reaffirms its commitment to a society that fully respects and protects all people. | 2025-07-21T19:32:26Z | |
| 104-sconres-72 | 104 | sconres | 72 | A concurrent resolution expressing the sense of the Congress that the President should categorically disavow any intention of issuing a pardon to James or Susan McDougal or to Jim Guy Tucker. | Crime and Law Enforcement | 1996-09-27 | 1996-09-27 | Referred to the Committee on Judiciary. | Senate | Sen. Shelby, Richard C. [R-AL] | AL | R | S000320 | 11 | Urges the President to categorically disavow any intention of issuing a presidential pardon to James or Susan McDougal or Jim Guy Tucker, and thereby affirm the principle that, in the U.S. justice system, no person is above the law. | 2025-07-21T19:32:26Z | |
| 103-sconres-12 | 103 | sconres | 12 | A concurrent resolution to recognize the herioc sacrifice of the Special Agents of the Bureau of Alcohol, Tobacco and Firearms in Waco, Texas. | Crime and Law Enforcement | 1993-03-02 | 1993-03-31 | Sponsor introductory remarks on measure. (CR S4061) | Senate | Sen. DeConcini, Dennis [D-AZ] | AZ | D | D000185 | 9 | Declares that the sacrifice and dedication of the agents of the Bureau of Alcohol, Tobacco and Firearms is a cornerstone of our system of justice and cause for both sorrow and pride. | 2025-01-02T17:28:31Z | |
| 101-sconres-130 | 101 | sconres | 130 | A concurrent resolution to express the sense of the Congress that the States should make every effort to adopt a Victims of Crime Bill of Rights. | Crime and Law Enforcement | 1990-05-16 | 1990-05-16 | Referred to the Committee on Judiciary. | Senate | Sen. Dole, Robert J. [R-KS] | KS | R | D000401 | 0 | Calls for States to adopt as goals of a Victims of Crime Bill of Rights to: (1) treat victims with compassion and respect, and protect them from the accused, throughout the criminal justice process; (2) require the person convicted of the crime to provide at least partial compensation to the victim for damages resulting from the crime; (3) grant victims the right to reasonable assurance that the accused will be tried in an expeditious manner, the right to be present at all proceedings related to the offense, except under certain circumstances, and the right to information about the conviction, sentencing, and imprisonment of the person who committed the crime; (4) give victims a statutorily-designated advisory role in decisions involving prosecutorial discretion and in deciding the early release status of the person convicted; (5) reform the exclusionary rule; and (6) ensure that victims will never be forced to endure again the consequences of the original crime. | 2025-07-21T19:32:26Z | |
| 99-sconres-106 | 99 | sconres | 106 | A concurrent resolution expressing the sense of the Congress with respect to certain amounts proposed by the President to be rescinded. | Crime and Law Enforcement | 1986-02-05 | 1986-02-05 | Referred to the Committee on Appropriations. | Senate | Sen. Specter, Arlen [R-PA] | PA | R | S000709 | 52 | Expresses the sense of the Congress that certain amounts appropriated for the Office of Juvenile Justice and Delinquency Prevention of the Department of Justice which have been proposed for rescission by the President shall be made available for obligation and expended as originally intended. | 2025-01-14T18:18:18Z | |
| 98-sconres-152 | 98 | sconres | 152 | A concurrent resolution to express the sense of the Congress regarding the failure of the government of Bolivia to eradicate its illegal narcotics industry. | Crime and Law Enforcement | 1984-10-04 | 1984-10-04 | Referred to the Committee on Foreign Relations. | Senate | Sen. Hawkins, Paula [R-FL] | FL | R | H000374 | 0 | Expresses the concern of the Congress over the failure of Bolivia to eradicate its illegal narcotics industry. Expresses the intention of Congress to take into account as a major factor in its consideration of future direct and indirect aid to Bolivia any continued failure by Bolivia to eradicate such industry. | 2025-01-14T19:00:46Z | |
| 98-sconres-133 | 98 | sconres | 133 | A concurrent resolution to express the sense of the Congress that television stations should publicize kidnapped children cases. | Crime and Law Enforcement | 1984-08-07 | 1984-08-07 | Referred to the Committee on Commerce. | Senate | Sen. Hawkins, Paula [R-FL] | FL | R | H000374 | 6 | Expresses the sense of Congress that the major television networks, their affiliates, and independent stations should broadcast public service announcements publicizing kidnapped children cases. | 2025-01-14T18:51:33Z | |
| 98-sconres-120 | 98 | sconres | 120 | A concurrent resolution expressing the sense of the Congress that the legislatures of the States should develop and enact legislation designed to provide child victims of sexual assault with protection and assistance during administrative and judicial proceedings. | Crime and Law Enforcement | 1984-06-08 | 1984-10-01 | Referred to House Committee on The Judiciary. | Senate | Sen. Hawkins, Paula [R-FL] | FL | R | H000374 | 16 | Expresses the sense of the Congress that the National Conference of State Legislatures should survey the States to compile and categorize child protection legislation. Declares that State legislatures should consider and enact laws which contain innovative approaches to the handling of child sexual abuse cases and which protect the victims' legal rights. Specifies a list of considerations including: (1) the establishment of interdisciplinary teams of professionals; (2) the selection of a victim-witness advocate; (3) the establishment of special procedures for child-victim testimony; and (4) the establishment of procedures to check the criminal records of adults working with children. | 2025-01-14T19:03:55Z | |
| 98-sconres-88 | 98 | sconres | 88 | A concurrent resolution expressing the sense of the Congress that the Secretary of State should request the Organization of American States to consider as soon as possible the question of the involvement by the Government of Cuba in drug dealing, smuggling, and trafficking in the Western Hemisphere. | Crime and Law Enforcement | 1984-01-24 | 1984-01-24 | Referred to the Committee on Foreign Relations. | Senate | Sen. Chiles, Lawton [D-FL] | FL | D | C000356 | 23 | Expresses the sense of the Congress that the Secretary of State should request the Organization of American States to consider the question of the involvement by Cuba in drug trafficking and the need for international inspections and factfinding hearings regarding such problem. | 2025-01-14T19:00:46Z | |
| 98-sconres-89 | 98 | sconres | 89 | A concurrent resolution urging the President to direct the Permanent Representative of the United States to the United Nations to bring before the United Nations the question of the involvement by the Government of Cuba in drug dealing, smuggling, and trafficking. | Crime and Law Enforcement | 1984-01-24 | 1984-01-24 | Referred to the Committee on Foreign Relations. | Senate | Sen. Chiles, Lawton [D-FL] | FL | D | C000356 | 23 | Expresses the sense of the Congress that the President should take steps to place the question of the involvement by Cuba in drug trafficking on the United Nations' agenda and to request of U.N. agencies investigations and reports regarding such problem. | 2025-01-14T19:00:46Z | |
| 94-sconres-135 | 94 | sconres | 135 | Resolutions disapproving certain action of the council of the District of Columbia. | Crime and Law Enforcement | 1976-08-27 | 1976-08-27 | Referred to Senate Committee on the District of Columbia. | Senate | Sen. Bartlett, Dewey F. [R-OK] | OK | R | B000200 | 0 | States that the Congress disapproves of the Firearms Control Regulations Act of 1975 passed by the Council of the District of Columbia. | 2024-08-01T19:33:45Z | |
| 94-sconres-30 | 94 | sconres | 30 | A concurrent resolution recognizing the role of Frank Wills in the Watergate Affair. | Crime and Law Enforcement | 1975-04-10 | 1975-04-10 | Referred to Senate Committee on the Judiciary. | Senate | Sen. Mathias, Charles McC., Jr. [R-MD] | MD | R | M000241 | 0 | Expresses appreciation to Mr. Frank Wills on behalf of the People of the United States for his discovery and reporting of the Watergate break-in. Directs that every effort be made to assist him in obtaining employment in a position commensurate with his experience. | 2025-07-21T19:32:26Z |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE legislation (
bill_id TEXT PRIMARY KEY,
congress INTEGER,
bill_type TEXT,
bill_number INTEGER,
title TEXT,
policy_area TEXT,
introduced_date TEXT,
latest_action_date TEXT,
latest_action_text TEXT,
origin_chamber TEXT,
sponsor_name TEXT,
sponsor_state TEXT,
sponsor_party TEXT,
sponsor_bioguide_id TEXT,
cosponsor_count INTEGER DEFAULT 0,
summary_text TEXT,
update_date TEXT,
url TEXT
);
CREATE INDEX idx_leg_congress ON legislation(congress);
CREATE INDEX idx_leg_type ON legislation(bill_type);
CREATE INDEX idx_leg_policy ON legislation(policy_area);
CREATE INDEX idx_leg_date ON legislation(introduced_date);
CREATE INDEX idx_leg_sponsor ON legislation(sponsor_name);
CREATE INDEX idx_leg_sponsor_bioguide ON legislation(sponsor_bioguide_id);