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

55 rows where bill_id = "112-hres-820" 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 2
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
112-hres-820,P000197 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 P000197 Rep. Pelosi, Nancy [D-CA-8] D CA 2012-12-05 0
112-hres-820,A000361 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 A000361 Rep. Alexander, Rodney [R-LA-5] R LA 2012-11-30 0
112-hres-820,M000087 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 M000087 Rep. Maloney, Carolyn B. [D-NY-14] D NY 2012-11-28 1
112-hres-820,P000034 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 P000034 Rep. Pallone, Frank, Jr. [D-NJ-6] D NJ 2012-11-28 1
112-hres-820,H001047 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 H001047 Rep. Himes, James A. [D-CT-4] D CT 2012-11-28 1
112-hres-820,K000210 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 K000210 Rep. King, Peter T. [R-NY-3] R NY 2012-11-28 1
112-hres-820,L000480 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 L000480 Rep. Lowey, Nita M. [D-NY-18] D NY 2012-11-28 1
112-hres-820,T000471 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 T000471 Rep. Turner, Robert L. [R-NY-9] R NY 2012-11-28 1
112-hres-820,G000569 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 G000569 Rep. Grimm, Michael G. [R-NY-13] R NY 2012-11-28 1
112-hres-820,A000022 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 A000022 Rep. Ackerman, Gary L. [D-NY-5] D NY 2012-11-28 1
112-hres-820,A000210 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 A000210 Rep. Andrews, Robert E. [D-NJ-1] D NJ 2012-11-28 1
112-hres-820,B001242 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 B001242 Rep. Bishop, Timothy H. [D-NY-1] D NY 2012-11-28 1
112-hres-820,B001276 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 B001276 Rep. Buerkle, Ann Marie [R-NY-25] R NY 2012-11-28 1
112-hres-820,C001072 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 C001072 Rep. Carson, Andre [D-IN-7] D IN 2012-11-28 1
112-hres-820,C001084 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 C001084 Rep. Cicilline, David N. [D-RI-1] D RI 2012-11-28 1
112-hres-820,C001067 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 C001067 Rep. Clarke, Yvette D. [D-NY-11] D NY 2012-11-28 1
112-hres-820,C001069 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 C001069 Rep. Courtney, Joe [D-CT-2] D CT 2012-11-28 1
112-hres-820,C001038 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 C001038 Rep. Crowley, Joseph [D-NY-7] D NY 2012-11-28 1
112-hres-820,D000216 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 D000216 Rep. DeLauro, Rosa L. [D-CT-3] D CT 2012-11-28 1
112-hres-820,E000179 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 E000179 Rep. Engel, Eliot L. [D-NY-17] D NY 2012-11-28 1
112-hres-820,F000451 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 F000451 Rep. Fitzpatrick, Michael G. [R-PA-8] R PA 2012-11-28 1
112-hres-820,F000372 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 F000372 Rep. Frelinghuysen, Rodney P. [R-NJ-11] R NJ 2012-11-28 1
112-hres-820,G000548 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 G000548 Rep. Garrett, Scott [R-NJ-5] R NJ 2012-11-28 1
112-hres-820,G000564 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 G000564 Rep. Gibson, Christopher P. [R-NY-20] R NY 2012-11-28 1
112-hres-820,G000553 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 G000553 Rep. Green, Al [D-TX-9] D TX 2012-11-28 1
112-hres-820,H001054 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 H001054 Rep. Hayworth, Nan A. S. [R-NY-19] R NY 2012-11-28 1
112-hres-820,H001038 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 H001038 Rep. Higgins, Brian [D-NY-27] D NY 2012-11-28 1
112-hres-820,H000627 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 H000627 Rep. Hinchey, Maurice D. [D-NY-22] D NY 2012-11-28 1
112-hres-820,H001032 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 H001032 Rep. Holt, Rush [D-NJ-12] D NJ 2012-11-28 1
112-hres-820,I000057 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 I000057 Rep. Israel, Steve [D-NY-2] D NY 2012-11-28 1
112-hres-820,K000375 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 K000375 Rep. Keating, William R. [D-MA-10] D MA 2012-11-28 1
112-hres-820,L000567 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 L000567 Rep. Lance, Leonard [R-NJ-7] R NJ 2012-11-28 1
112-hres-820,L000559 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 L000559 Rep. Langevin, James R. [D-RI-2] D RI 2012-11-28 1
112-hres-820,L000557 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 L000557 Rep. Larson, John B. [D-CT-1] D CT 2012-11-28 1
112-hres-820,L000554 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 L000554 Rep. LoBiondo, Frank A. [R-NJ-2] R NJ 2012-11-28 1
112-hres-820,M001179 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 M001179 Rep. Marino, Tom [R-PA-10] R PA 2012-11-28 1
112-hres-820,M000309 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 M000309 Rep. McCarthy, Carolyn [D-NY-4] D NY 2012-11-28 1
112-hres-820,M001143 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 M001143 Rep. McCollum, Betty [D-MN-4] D MN 2012-11-28 1
112-hres-820,M000312 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 M000312 Rep. McGovern, James P. [D-MA-3] D MA 2012-11-28 1
112-hres-820,M000933 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 M000933 Rep. Moran, James P. [D-VA-8] D VA 2012-11-28 1
112-hres-820,O000169 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 O000169 Rep. Owens, William L. [D-NY-23] D NY 2012-11-28 1
112-hres-820,P000096 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 P000096 Rep. Pascrell, Bill, Jr. [D-NJ-8] D NJ 2012-11-28 1
112-hres-820,R000053 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 R000053 Rep. Rangel, Charles B. [D-NY-15] D NY 2012-11-28 1
112-hres-820,R000585 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 R000585 Rep. Reed, Tom [R-NY-29] R NY 2012-11-28 1
112-hres-820,R000581 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 R000581 Rep. Richardson, Laura [D-CA-37] D CA 2012-11-28 1
112-hres-820,R000588 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 R000588 Rep. Richmond, Cedric L. [D-LA-2] D LA 2012-11-28 1
112-hres-820,R000589 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 R000589 Rep. Rigell, E. Scott [R-VA-2] R VA 2012-11-28 1
112-hres-820,R000594 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 R000594 Rep. Runyan, Jon [R-NJ-3] R NJ 2012-11-28 1
112-hres-820,S001162 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 S001162 Rep. Schwartz, Allyson Y. [D-PA-13] D PA 2012-11-28 1
112-hres-820,S000185 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 S000185 Rep. Scott, Robert C. "Bobby" [D-VA-3] D VA 2012-11-28 1
112-hres-820,S000248 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 S000248 Rep. Serrano, Jose E. [D-NY-16] D NY 2012-11-28 1
112-hres-820,S001165 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 S001165 Rep. Sires, Albio [D-NJ-13] D NJ 2012-11-28 1
112-hres-820,S000480 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 S000480 Rep. Slaughter, Louise McIntosh [D-NY-28] D NY 2012-11-28 1
112-hres-820,T000469 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 T000469 Rep. Tonko, Paul [D-NY-21] D NY 2012-11-28 1
112-hres-820,W000799 Expressing condolences to the victims of Hurricane Sandy, commending the resiliency of the people of New Jersey, New York, Massachusetts, Connecticut, Pennsylvania, Maryland, the District of Columbia, Rhode Island, New Hampshire, West Virginia, and Delaware, and committing to stand by them in the relief and recovery effort. 112-hres-820 W000799 Rep. Walz, Timothy J. [D-MN-1] D MN 2012-11-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);