legislation_cosponsors

Cosponsors for tracked legislation. Distinguishes original cosponsors (signed on at introduction) from later additions. Linked to congress_members via bioguide_id.

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

62 rows where bill_id = "115-hres-1104" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, state, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

  • 1 53
  • 0 9
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
115-hres-1104,A000371 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 A000371 Rep. Aguilar, Pete [D-CA-31] D CA 2018-11-14 0
115-hres-1104,C001080 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 C001080 Rep. Chu, Judy [D-CA-27] D CA 2018-10-26 0
115-hres-1104,S000510 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 S000510 Rep. Smith, Adam [D-WA-9] D WA 2018-10-16 0
115-hres-1104,G000410 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 G000410 Rep. Green, Gene [D-TX-29] D TX 2018-10-16 0
115-hres-1104,W000187 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 W000187 Rep. Waters, Maxine [D-CA-43] D CA 2018-10-05 0
115-hres-1104,E000215 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 E000215 Rep. Eshoo, Anna G. [D-CA-18] D CA 2018-10-05 0
115-hres-1104,D000598 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 D000598 Rep. Davis, Susan A. [D-CA-53] D CA 2018-10-05 0
115-hres-1104,B001245 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 B001245 Del. Bordallo, Madeleine Z. [D-GU-At Large] D GU 2018-10-05 0
115-hres-1104,K000389 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 K000389 Rep. Khanna, Ro [D-CA-17] D CA 2018-10-05 0
115-hres-1104,P000592 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 P000592 Rep. Poe, Ted [R-TX-2] R TX 2018-09-28 1
115-hres-1104,D000624 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 D000624 Rep. Dingell, Debbie [D-MI-12] D MI 2018-09-28 1
115-hres-1104,M001137 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 M001137 Rep. Meeks, Gregory W. [D-NY-5] D NY 2018-09-28 1
115-hres-1104,V000081 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 V000081 Rep. Velazquez, Nydia M. [D-NY-7] D NY 2018-09-28 1
115-hres-1104,N000147 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 N000147 Del. Norton, Eleanor Holmes [D-DC-At Large] D DC 2018-09-28 1
115-hres-1104,J000288 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 J000288 Rep. Johnson, Henry C. "Hank," Jr. [D-GA-4] D GA 2018-09-28 1
115-hres-1104,C001067 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 C001067 Rep. Clarke, Yvette D. [D-NY-9] D NY 2018-09-28 1
115-hres-1104,J000032 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 J000032 Rep. Jackson Lee, Sheila [D-TX-18] D TX 2018-09-28 1
115-hres-1104,M001160 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 M001160 Rep. Moore, Gwen [D-WI-4] D WI 2018-09-28 1
115-hres-1104,B001304 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 B001304 Rep. Brown, Anthony G. [D-MD-4] D MD 2018-09-28 1
115-hres-1104,E000297 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 E000297 Rep. Espaillat, Adriano [D-NY-13] D NY 2018-09-28 1
115-hres-1104,K000382 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 K000382 Rep. Kuster, Ann M. [D-NH-2] D NH 2018-09-28 1
115-hres-1104,T000468 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 T000468 Rep. Titus, Dina [D-NV-1] D NV 2018-09-28 1
115-hres-1104,V000132 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 V000132 Rep. Vela, Filemon [D-TX-34] D TX 2018-09-28 1
115-hres-1104,T000193 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 T000193 Rep. Thompson, Bennie G. [D-MS-2] D MS 2018-09-28 1
115-hres-1104,B001281 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 B001281 Rep. Beatty, Joyce [D-OH-3] D OH 2018-09-28 1
115-hres-1104,L000581 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 L000581 Rep. Lawrence, Brenda L. [D-MI-14] D MI 2018-09-28 1
115-hres-1104,W000822 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 W000822 Rep. Watson Coleman, Bonnie [D-NJ-12] D NJ 2018-09-28 1
115-hres-1104,L000397 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 L000397 Rep. Lofgren, Zoe [D-CA-19] D CA 2018-09-28 1
115-hres-1104,A000370 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 A000370 Rep. Adams, Alma S. [D-NC-12] D NC 2018-09-28 1
115-hres-1104,B001270 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 B001270 Rep. Bass, Karen [D-CA-37] D CA 2018-09-28 1
115-hres-1104,J000126 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 J000126 Rep. Johnson, Eddie Bernice [D-TX-30] D TX 2018-09-28 1
115-hres-1104,B000490 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 B000490 Rep. Bishop, Sanford D., Jr. [D-GA-2] D GA 2018-09-28 1
115-hres-1104,B001251 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 B001251 Rep. Butterfield, G. K. [D-NC-1] D NC 2018-09-28 1
115-hres-1104,C001072 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 C001072 Rep. Carson, Andre [D-IN-7] D IN 2018-09-28 1
115-hres-1104,C001049 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 C001049 Rep. Clay, Wm. Lacy [D-MO-1] D MO 2018-09-28 1
115-hres-1104,C001061 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 C001061 Rep. Cleaver, Emanuel [D-MO-5] D MO 2018-09-28 1
115-hres-1104,D000096 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 D000096 Rep. Davis, Danny K. [D-IL-7] D IL 2018-09-28 1
115-hres-1104,D000627 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 D000627 Rep. Demings, Val Butler [D-FL-10] D FL 2018-09-28 1
115-hres-1104,F000455 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 F000455 Rep. Fudge, Marcia L. [D-OH-11] D OH 2018-09-28 1
115-hres-1104,E000296 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 E000296 Rep. Evans, Dwight [D-PA-2] D PA 2018-09-28 1
115-hres-1104,E000288 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 E000288 Rep. Ellison, Keith [D-MN-5] D MN 2018-09-28 1
115-hres-1104,H000324 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 H000324 Rep. Hastings, Alcee L. [D-FL-20] D FL 2018-09-28 1
115-hres-1104,J000294 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 J000294 Rep. Jeffries, Hakeem S. [D-NY-8] D NY 2018-09-28 1
115-hres-1104,K000385 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 K000385 Rep. Kelly, Robin L. [D-IL-2] D IL 2018-09-28 1
115-hres-1104,L000586 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 L000586 Rep. Lawson, Al, Jr. [D-FL-5] D FL 2018-09-28 1
115-hres-1104,L000287 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 L000287 Rep. Lewis, John [D-GA-5] D GA 2018-09-28 1
115-hres-1104,R000588 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 R000588 Rep. Richmond, Cedric L. [D-LA-2] D LA 2018-09-28 1
115-hres-1104,R000515 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 R000515 Rep. Rush, Bobby L. [D-IL-1] D IL 2018-09-28 1
115-hres-1104,S001185 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 S001185 Rep. Sewell, Terri A. [D-AL-7] D AL 2018-09-28 1
115-hres-1104,V000131 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 V000131 Rep. Veasey, Marc A. [D-TX-33] D TX 2018-09-28 1
115-hres-1104,B001286 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 B001286 Rep. Bustos, Cheri [D-IL-17] D IL 2018-09-28 1
115-hres-1104,M001166 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 M001166 Rep. McNerney, Jerry [D-CA-9] D CA 2018-09-28 1
115-hres-1104,C001101 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 C001101 Rep. Clark, Katherine M. [D-MA-5] D MA 2018-09-28 1
115-hres-1104,G000551 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 G000551 Rep. Grijalva, Raúl M. [D-AZ-3] D AZ 2018-09-28 1
115-hres-1104,P000604 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 P000604 Rep. Payne, Donald M., Jr. [D-NJ-10] D NJ 2018-09-28 1
115-hres-1104,C001097 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 C001097 Rep. Cárdenas, Tony [D-CA-29] D CA 2018-09-28 1
115-hres-1104,E000179 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 E000179 Rep. Engel, Eliot L. [D-NY-16] D NY 2018-09-28 1
115-hres-1104,J000298 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 J000298 Rep. Jayapal, Pramila [D-WA-7] D WA 2018-09-28 1
115-hres-1104,R000606 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 R000606 Rep. Raskin, Jamie [D-MD-8] D MD 2018-09-28 1
115-hres-1104,L000551 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 L000551 Rep. Lee, Barbara [D-CA-13] D CA 2018-09-28 1
115-hres-1104,P000610 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 P000610 Del. Plaskett, Stacey E. [D-VI-At Large] D VI 2018-09-28 1
115-hres-1104,V000130 Supporting the goals and ideals of October as "National Domestic Violence Awareness Month" and expressing the sense of the House of Representatives that Congress should continue to raise awareness of domestic violence and its devastating effects on individuals, families, and communities, and support programs designed to end domestic violence in the United States. 115-hres-1104 V000130 Rep. Vargas, Juan [D-CA-51] D CA 2018-09-28 1

Advanced export

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

CSV options: 

CREATE TABLE legislation_cosponsors (
    bill_id TEXT NOT NULL REFERENCES legislation(bill_id),
    bioguide_id TEXT NOT NULL,
    full_name TEXT,
    party TEXT,
    state TEXT,
    sponsorship_date TEXT,
    is_original_cosponsor INTEGER,
    PRIMARY KEY (bill_id, bioguide_id)
);
CREATE INDEX idx_lc_bioguide ON legislation_cosponsors(bioguide_id);
CREATE INDEX idx_lc_bill ON legislation_cosponsors(bill_id);
CREATE INDEX idx_lc_original ON legislation_cosponsors(is_original_cosponsor);