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

43 rows where bill_id = "105-hr-641" 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 25
  • 0 18
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
105-hr-641,T000024 Right to Life Act of 1997 105-hr-641 T000024 Rep. Talent, Jim [R-MO-2] R MO 1998-01-28 0
105-hr-641,S000718 Right to Life Act of 1997 105-hr-641 S000718 Rep. Spence, Floyd [R-SC-2] R SC 1997-11-05 0
105-hr-641,T000260 Right to Life Act of 1997 105-hr-641 T000260 Rep. Tiahrt, Todd [R-KS-4] R KS 1997-09-03 0
105-hr-641,C000071 Right to Life Act of 1997 105-hr-641 C000071 Rep. Camp, Dave [R-MI-4] R MI 1997-07-17 0
105-hr-641,P000148 Right to Life Act of 1997 105-hr-641 P000148 Rep. Paxon, Bill [R-NY-27] R NY 1997-07-09 0
105-hr-641,M000388 Right to Life Act of 1997 105-hr-641 M000388 Rep. McCrery, Jim [R-LA-4] R LA 1997-07-09 0
105-hr-641,J000174 Right to Life Act of 1997 105-hr-641 J000174 Rep. Johnson, Sam [R-TX-3] R TX 1997-07-09 0
105-hr-641,H000067 Right to Life Act of 1997 105-hr-641 H000067 Rep. Hall, Ralph M. [D-TX-4] D TX 1997-06-04 0
105-hr-641,P000323 Right to Life Act of 1997 105-hr-641 P000323 Rep. Pickering, Charles W. "Chip" [R-MS-3] R MS 1997-05-06 0
105-hr-641,S000364 Right to Life Act of 1997 105-hr-641 S000364 Rep. Shimkus, John [R-IL-20] R IL 1997-04-23 0
105-hr-641,M000481 Right to Life Act of 1997 105-hr-641 M000481 Rep. McIntosh, David M. [R-IN-2] R IN 1997-04-16 0
105-hr-641,W000210 Right to Life Act of 1997 105-hr-641 W000210 Rep. Watts, J. C., Jr. [R-OK-4] R OK 1997-04-16 0
105-hr-641,H000807 Right to Life Act of 1997 105-hr-641 H000807 Rep. Hostettler, John N. [R-IN-8] R IN 1997-04-09 0
105-hr-641,P000583 Right to Life Act of 1997 105-hr-641 P000583 Rep. Paul, Ron [R-TX-14] R TX 1997-03-10 0
105-hr-641,S001143 Right to Life Act of 1997 105-hr-641 S001143 Rep. Souder, Mark E. [R-IN-4] R IN 1997-03-10 0
105-hr-641,C000345 Right to Life Act of 1997 105-hr-641 C000345 Rep. Chenoweth-Hage, Helen [R-ID-1] R ID 1997-02-13 0
105-hr-641,L000096 Right to Life Act of 1997 105-hr-641 L000096 Rep. Largent, Steve [R-OK-1] R OK 1997-02-13 0
105-hr-641,P000005 Right to Life Act of 1997 105-hr-641 P000005 Rep. Packard, Ron [R-CA-48] R CA 1997-02-13 0
105-hr-641,B000013 Right to Life Act of 1997 105-hr-641 B000013 Rep. Bachus, Spencer [R-AL-6] R AL 1997-02-06 1
105-hr-641,B000134 Right to Life Act of 1997 105-hr-641 B000134 Rep. Barcia, James A. [D-MI-5] D MI 1997-02-06 1
105-hr-641,B000169 Right to Life Act of 1997 105-hr-641 B000169 Rep. Barr, Bob [R-GA-7] R GA 1997-02-06 1
105-hr-641,B000208 Right to Life Act of 1997 105-hr-641 B000208 Rep. Bartlett, Roscoe G. [R-MD-6] R MD 1997-02-06 1
105-hr-641,B000213 Right to Life Act of 1997 105-hr-641 B000213 Rep. Barton, Joe [R-TX-6] R TX 1997-02-06 1
105-hr-641,B001066 Right to Life Act of 1997 105-hr-641 B001066 Rep. Bunning, Jim [R-KY-4] R KY 1997-02-06 1
105-hr-641,B001149 Right to Life Act of 1997 105-hr-641 B001149 Rep. Burton, Dan [R-IN-6] R IN 1997-02-06 1
105-hr-641,C000560 Right to Life Act of 1997 105-hr-641 C000560 Rep. Coburn, Tom [R-OK-2] R OK 1997-02-06 1
105-hr-641,C000873 Right to Life Act of 1997 105-hr-641 C000873 Rep. Crane, Philip M. [R-IL-8] R IL 1997-02-06 1
105-hr-641,D000312 Right to Life Act of 1997 105-hr-641 D000312 Rep. Dickey, Jay [R-AR-4] R AR 1997-02-06 1
105-hr-641,E000172 Right to Life Act of 1997 105-hr-641 E000172 Rep. Emerson, Jo Ann [R-MO-8] R MO 1997-02-06 1
105-hr-641,F000257 Right to Life Act of 1997 105-hr-641 F000257 Rep. Forbes, Michael P. [R-NY-1] R NY 1997-02-06 1
105-hr-641,H000172 Right to Life Act of 1997 105-hr-641 H000172 Rep. Hansen, James V. [R-UT-1] R UT 1997-02-06 1
105-hr-641,H000605 Right to Life Act of 1997 105-hr-641 H000605 Rep. Hill, Rick [R-MT-At Large] R MT 1997-02-06 1
105-hr-641,H000676 Right to Life Act of 1997 105-hr-641 H000676 Rep. Hoekstra, Peter [R-MI-2] R MI 1997-02-06 1
105-hr-641,I000023 Right to Life Act of 1997 105-hr-641 I000023 Rep. Inglis, Bob [R-SC-4] R SC 1997-02-06 1
105-hr-641,L000293 Right to Life Act of 1997 105-hr-641 L000293 Rep. Lewis, Ron [R-KY-2] R KY 1997-02-06 1
105-hr-641,M001134 Right to Life Act of 1997 105-hr-641 M001134 Rep. Myrick, Sue Wilkins [R-NC-9] R NC 1997-02-06 1
105-hr-641,P000049 Right to Life Act of 1997 105-hr-641 P000049 Rep. Pappas, Michael [R-NJ-12] R NJ 1997-02-06 1
105-hr-641,P000265 Right to Life Act of 1997 105-hr-641 P000265 Rep. Petri, Thomas E. [R-WI-6] R WI 1997-02-06 1
105-hr-641,P000373 Right to Life Act of 1997 105-hr-641 P000373 Rep. Pitts, Joseph R. [R-PA-16] R PA 1997-02-06 1
105-hr-641,S000522 Right to Life Act of 1997 105-hr-641 S000522 Rep. Smith, Christopher H. [R-NJ-4] R NJ 1997-02-06 1
105-hr-641,S000822 Right to Life Act of 1997 105-hr-641 S000822 Rep. Stearns, Cliff [R-FL-6] R FL 1997-02-06 1
105-hr-641,T000074 Right to Life Act of 1997 105-hr-641 T000074 Rep. Taylor, Gene [D-MS-5] D MS 1997-02-06 1
105-hr-641,Y000033 Right to Life Act of 1997 105-hr-641 Y000033 Rep. Young, Don [R-AK-At Large] R AK 1997-02-06 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);