home / openregs

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

68 rows where bill_id = "105-hr-2955" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

is_original_cosponsor 2

  • 0 59
  • 1 9
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
105-hr-2955,S000051 Border Improvement and Immigration Act of 1997 105-hr-2955 S000051 Rep. Sanford, Marshall (Mark) [R-SC-1] R SC 1998-09-10 0
105-hr-2955,H000636 Border Improvement and Immigration Act of 1997 105-hr-2955 H000636 Rep. Hinojosa, Ruben [D-TX-15] D TX 1998-09-10 0
105-hr-2955,S000948 Border Improvement and Immigration Act of 1997 105-hr-2955 S000948 Rep. Stokes, Louis [D-OH-11] D OH 1998-09-10 0
105-hr-2955,L000551 Border Improvement and Immigration Act of 1997 105-hr-2955 L000551 Rep. Lee, Barbara [D-CA-9] D CA 1998-09-10 0
105-hr-2955,T000193 Border Improvement and Immigration Act of 1997 105-hr-2955 T000193 Rep. Thompson, Bennie G. [D-MS-2] D MS 1998-09-10 0
105-hr-2955,L000342 Border Improvement and Immigration Act of 1997 105-hr-2955 L000342 Rep. Lipinski, William O. [D-IL-3] D IL 1998-08-05 0
105-hr-2955,S000749 Border Improvement and Immigration Act of 1997 105-hr-2955 S000749 Rep. Spratt, John M., Jr. [D-SC-5] D SC 1998-08-05 0
105-hr-2955,B000944 Border Improvement and Immigration Act of 1997 105-hr-2955 B000944 Rep. Brown, Sherrod [D-OH-13] D OH 1998-08-05 0
105-hr-2955,W000314 Border Improvement and Immigration Act of 1997 105-hr-2955 W000314 Rep. Wexler, Robert [D-FL-19] D FL 1998-08-04 0
105-hr-2955,S000718 Border Improvement and Immigration Act of 1997 105-hr-2955 S000718 Rep. Spence, Floyd [R-SC-2] R SC 1998-08-04 0
105-hr-2955,M000090 Border Improvement and Immigration Act of 1997 105-hr-2955 M000090 Rep. Maloney, James H. [D-CT-5] D CT 1998-08-04 0
105-hr-2955,J000283 Border Improvement and Immigration Act of 1997 105-hr-2955 J000283 Rep. Jackson, Jesse L., Jr. [D-IL-2] D IL 1998-07-30 0
105-hr-2955,P000099 Border Improvement and Immigration Act of 1997 105-hr-2955 P000099 Rep. Pastor, Ed [D-AZ-2] D AZ 1998-07-30 0
105-hr-2955,S000005 Border Improvement and Immigration Act of 1997 105-hr-2955 S000005 Rep. Sabo, Martin Olav [D-MN-5] D MN 1998-07-27 0
105-hr-2955,O000107 Border Improvement and Immigration Act of 1997 105-hr-2955 O000107 Rep. Ortiz, Solomon P. [D-TX-27] D TX 1998-07-27 0
105-hr-2955,R000170 Border Improvement and Immigration Act of 1997 105-hr-2955 R000170 Rep. Reyes, Silvestre [D-TX-16] D TX 1998-07-27 0
105-hr-2955,M000797 Border Improvement and Immigration Act of 1997 105-hr-2955 M000797 Rep. Mink, Patsy T. [D-HI-2] D HI 1998-07-21 0
105-hr-2955,S000597 Border Improvement and Immigration Act of 1997 105-hr-2955 S000597 Rep. Smith, Nick [R-MI-7] R MI 1998-07-21 0
105-hr-2955,D000210 Border Improvement and Immigration Act of 1997 105-hr-2955 D000210 Rep. Delahunt, William D. [D-MA-10] D MA 1998-07-20 0
105-hr-2955,R000568 Border Improvement and Immigration Act of 1997 105-hr-2955 R000568 Rep. Rodriguez, Ciro D. [D-TX-28] D TX 1998-07-20 0
105-hr-2955,S000480 Border Improvement and Immigration Act of 1997 105-hr-2955 S000480 Rep. Slaughter, Louise McIntosh [D-NY-28] D NY 1998-07-20 0
105-hr-2955,G000535 Border Improvement and Immigration Act of 1997 105-hr-2955 G000535 Rep. Gutierrez, Luis V. [D-IL-4] D IL 1998-07-20 0
105-hr-2955,M000312 Border Improvement and Immigration Act of 1997 105-hr-2955 M000312 Rep. McGovern, James P. [D-MA-3] D MA 1998-07-15 0
105-hr-2955,B000081 Border Improvement and Immigration Act of 1997 105-hr-2955 B000081 Rep. Baldacci, John Elias [D-ME-2] D ME 1998-07-14 0
105-hr-2955,L000287 Border Improvement and Immigration Act of 1997 105-hr-2955 L000287 Rep. Lewis, John [D-GA-5] D GA 1998-07-14 0
105-hr-2955,P000326 Border Improvement and Immigration Act of 1997 105-hr-2955 P000326 Rep. Pickett, Owen B. [D-VA-2] D VA 1998-06-17 0
105-hr-2955,P000263 Border Improvement and Immigration Act of 1997 105-hr-2955 P000263 Rep. Peterson, John E. [R-PA-5] R PA 1998-06-17 0
105-hr-2955,K000210 Border Improvement and Immigration Act of 1997 105-hr-2955 K000210 Rep. King, Peter T. [R-NY-3] R NY 1998-06-05 0
105-hr-2955,A000357 Border Improvement and Immigration Act of 1997 105-hr-2955 A000357 Rep. Allen, Thomas H. [D-ME-1] D ME 1998-06-05 0
105-hr-2955,Y000013 Border Improvement and Immigration Act of 1997 105-hr-2955 Y000013 Rep. Yates, Sidney R. [D-IL-9] D IL 1998-06-05 0
105-hr-2955,B000586 Border Improvement and Immigration Act of 1997 105-hr-2955 B000586 Rep. Boehlert, Sherwood [R-NY-23] R NY 1998-06-05 0
105-hr-2955,D000327 Border Improvement and Immigration Act of 1997 105-hr-2955 D000327 Rep. Dicks, Norman D. [D-WA-6] D WA 1998-06-03 0
105-hr-2955,G000212 Border Improvement and Immigration Act of 1997 105-hr-2955 G000212 Rep. Gilman, Benjamin A. [R-NY-20] R NY 1998-06-03 0
105-hr-2955,C000100 Border Improvement and Immigration Act of 1997 105-hr-2955 C000100 Rep. Campbell, Tom [R-CA-15] R CA 1998-05-12 0
105-hr-2955,P000148 Border Improvement and Immigration Act of 1997 105-hr-2955 P000148 Rep. Paxon, Bill [R-NY-27] R NY 1998-05-12 0
105-hr-2955,F000339 Border Improvement and Immigration Act of 1997 105-hr-2955 F000339 Rep. Frank, Barney [D-MA-4] D MA 1998-05-12 0
105-hr-2955,U000031 Border Improvement and Immigration Act of 1997 105-hr-2955 U000031 Rep. Upton, Fred [R-MI-6] R MI 1998-05-12 0
105-hr-2955,K000288 Border Improvement and Immigration Act of 1997 105-hr-2955 K000288 Rep. Knollenberg, Joe [R-MI-11] R MI 1998-04-30 0
105-hr-2955,H000605 Border Improvement and Immigration Act of 1997 105-hr-2955 H000605 Rep. Hill, Rick [R-MT-At Large] R MT 1998-04-30 0
105-hr-2955,S000033 Border Improvement and Immigration Act of 1997 105-hr-2955 S000033 Rep. Sanders, Bernard [I-VT-At Large] I VT 1998-04-28 0
105-hr-2955,E000187 Border Improvement and Immigration Act of 1997 105-hr-2955 E000187 Rep. English, Phil [R-PA-21] R PA 1998-04-28 0
105-hr-2955,K000008 Border Improvement and Immigration Act of 1997 105-hr-2955 K000008 Rep. Kanjorski, Paul E. [D-PA-11] D PA 1998-04-28 0
105-hr-2955,K000306 Border Improvement and Immigration Act of 1997 105-hr-2955 K000306 Rep. Kolbe, Jim [R-AZ-5] R AZ 1998-04-28 0
105-hr-2955,S000248 Border Improvement and Immigration Act of 1997 105-hr-2955 S000248 Rep. Serrano, Jose E. [D-NY-16] D NY 1998-04-21 0
105-hr-2955,S000510 Border Improvement and Immigration Act of 1997 105-hr-2955 S000510 Rep. Smith, Adam [D-WA-9] D WA 1998-04-21 0
105-hr-2955,S001078 Border Improvement and Immigration Act of 1997 105-hr-2955 S001078 Rep. Sununu, John E. [R-NH-1] R NH 1998-04-01 0
105-hr-2955,M000404 Border Improvement and Immigration Act of 1997 105-hr-2955 M000404 Rep. McDermott, Jim [D-WA-7] D WA 1998-04-01 0
105-hr-2955,H000627 Border Improvement and Immigration Act of 1997 105-hr-2955 H000627 Rep. Hinchey, Maurice D. [D-NY-26] D NY 1998-03-24 0
105-hr-2955,K000274 Border Improvement and Immigration Act of 1997 105-hr-2955 K000274 Rep. Klug, Scott L. [R-WI-2] R WI 1998-03-11 0
105-hr-2955,O000006 Border Improvement and Immigration Act of 1997 105-hr-2955 O000006 Rep. Oberstar, James L. [D-MN-8] D MN 1998-03-03 0
105-hr-2955,D000114 Border Improvement and Immigration Act of 1997 105-hr-2955 D000114 Rep. Davis, Jim [D-FL-11] D FL 1998-03-03 0
105-hr-2955,M000249 Border Improvement and Immigration Act of 1997 105-hr-2955 M000249 Rep. Matsui, Robert T. [D-CA-5] D CA 1998-02-25 0
105-hr-2955,K000180 Border Improvement and Immigration Act of 1997 105-hr-2955 K000180 Rep. Kilpatrick, Carolyn C. [D-MI-15] D MI 1998-02-24 0
105-hr-2955,B000617 Border Improvement and Immigration Act of 1997 105-hr-2955 B000617 Rep. Bonilla, Henry [R-TX-23] R TX 1998-02-04 0
105-hr-2955,L000553 Border Improvement and Immigration Act of 1997 105-hr-2955 L000553 Rep. LaTourette, Steven C. [R-OH-19] R OH 1998-02-04 0
105-hr-2955,H000712 Border Improvement and Immigration Act of 1997 105-hr-2955 H000712 Rep. Holden, Tim [D-PA-6] D PA 1998-01-27 0
105-hr-2955,M000669 Border Improvement and Immigration Act of 1997 105-hr-2955 M000669 Rep. Metcalf, Jack [R-WA-2] R WA 1998-01-27 0
105-hr-2955,L000263 Border Improvement and Immigration Act of 1997 105-hr-2955 L000263 Rep. Levin, Sander M. [D-MI-12] D MI 1997-11-13 0
105-hr-2955,P000422 Border Improvement and Immigration Act of 1997 105-hr-2955 P000422 Rep. Pomeroy, Earl [D-ND-At Large] D ND 1997-11-12 0
105-hr-2955,C000714 Border Improvement and Immigration Act of 1997 105-hr-2955 C000714 Rep. Conyers, John, Jr. [D-MI-14] D MI 1997-11-08 1
105-hr-2955,M000472 Border Improvement and Immigration Act of 1997 105-hr-2955 M000472 Rep. McHugh, John M. [R-NY-24] R NY 1997-11-08 1
105-hr-2955,H000814 Border Improvement and Immigration Act of 1997 105-hr-2955 H000814 Rep. Houghton, Amo [R-NY-31] R NY 1997-11-08 1
105-hr-2955,Q000016 Border Improvement and Immigration Act of 1997 105-hr-2955 Q000016 Rep. Quinn, Jack [R-NY-30] R NY 1997-11-08 1
105-hr-2955,B000403 Border Improvement and Immigration Act of 1997 105-hr-2955 B000403 Rep. Bereuter, Doug [R-NE-1] R NE 1997-11-08 1
105-hr-2955,F000434 Border Improvement and Immigration Act of 1997 105-hr-2955 F000434 Rep. Furse, Elizabeth [D-OR-1] D OR 1997-11-08 1
105-hr-2955,S001045 Border Improvement and Immigration Act of 1997 105-hr-2955 S001045 Rep. Stupak, Bart [D-MI-1] D MI 1997-11-08 1
105-hr-2955,P000258 Border Improvement and Immigration Act of 1997 105-hr-2955 P000258 Rep. Peterson, Collin C. [D-MN-7] D MN 1997-11-08 1
105-hr-2955,W000099 Border Improvement and Immigration Act of 1997 105-hr-2955 W000099 Rep. Walsh, James T. [R-NY-25] R NY 1997-11-08 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);
Powered by Datasette · Queries took 2.016ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API · Privacy