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

26 rows where bill_id = "103-hr-3363" 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

  • 0 24
  • 1 2
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
103-hr-3363,A000022 Immigration Enforcement and Asylum Reform Act of 1993 103-hr-3363 A000022 Rep. Ackerman, Gary L. [D-NY-5] D NY 1994-08-18 0
103-hr-3363,M000843 Immigration Enforcement and Asylum Reform Act of 1993 103-hr-3363 M000843 Rep. Molinari, Susan [R-NY-13] R NY 1994-04-20 0
103-hr-3363,K000009 Immigration Enforcement and Asylum Reform Act of 1993 103-hr-3363 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 1994-04-12 0
103-hr-3363,T000253 Immigration Enforcement and Asylum Reform Act of 1993 103-hr-3363 T000253 Rep. Thurman, Karen L. [D-FL-5] D FL 1994-03-17 0
103-hr-3363,G000225 Immigration Enforcement and Asylum Reform Act of 1993 103-hr-3363 G000225 Rep. Gingrich, Newt [R-GA-6] R GA 1994-03-08 0
103-hr-3363,J000187 Immigration Enforcement and Asylum Reform Act of 1993 103-hr-3363 J000187 Rep. Johnston, Harry [D-FL-19] D FL 1994-02-10 0
103-hr-3363,T000074 Immigration Enforcement and Asylum Reform Act of 1993 103-hr-3363 T000074 Rep. Taylor, Gene [D-MS-5] D MS 1994-02-01 0
103-hr-3363,P000422 Immigration Enforcement and Asylum Reform Act of 1993 103-hr-3363 P000422 Rep. Pomeroy, Earl [D-ND-At Large] D ND 1994-01-26 0
103-hr-3363,B001213 Immigration Enforcement and Asylum Reform Act of 1993 103-hr-3363 B001213 Rep. Byrne, Leslie L. [D-VA-11] D VA 1994-01-26 0
103-hr-3363,C000243 Immigration Enforcement and Asylum Reform Act of 1993 103-hr-3363 C000243 Rep. Castle, Michael N. [R-DE-At Large] R DE 1994-01-26 0
103-hr-3363,C000052 Immigration Enforcement and Asylum Reform Act of 1993 103-hr-3363 C000052 Rep. Callahan, Sonny [R-AL-1] R AL 1994-01-26 0
103-hr-3363,L000342 Immigration Enforcement and Asylum Reform Act of 1993 103-hr-3363 L000342 Rep. Lipinski, William O. [D-IL-3] D IL 1994-01-26 0
103-hr-3363,V000006 Immigration Enforcement and Asylum Reform Act of 1993 103-hr-3363 V000006 Rep. Valentine, Tim [D-NC-2] D NC 1993-11-22 0
103-hr-3363,G000180 Immigration Enforcement and Asylum Reform Act of 1993 103-hr-3363 G000180 Rep. Gilchrest, Wayne T. [R-MD-1] R MD 1993-11-22 0
103-hr-3363,B000151 Immigration Enforcement and Asylum Reform Act of 1993 103-hr-3363 B000151 Rep. Barlow, Tom [D-KY-1] D KY 1993-11-15 0
103-hr-3363,P000259 Immigration Enforcement and Asylum Reform Act of 1993 103-hr-3363 P000259 Rep. Peterson, Douglas (Pete) [D-FL-2] D FL 1993-11-08 0
103-hr-3363,L000480 Immigration Enforcement and Asylum Reform Act of 1993 103-hr-3363 L000480 Rep. Lowey, Nita M. [D-NY-18] D NY 1993-11-08 0
103-hr-3363,H000712 Immigration Enforcement and Asylum Reform Act of 1993 103-hr-3363 H000712 Rep. Holden, Tim [D-PA-6] D PA 1993-11-04 0
103-hr-3363,J000177 Immigration Enforcement and Asylum Reform Act of 1993 103-hr-3363 J000177 Rep. Johnson, Tim [D-SD-At Large] D SD 1993-11-04 0
103-hr-3363,C000107 Immigration Enforcement and Asylum Reform Act of 1993 103-hr-3363 C000107 Rep. Canady, Charles T. [R-FL-12] R FL 1993-11-03 0
103-hr-3363,R000465 Immigration Enforcement and Asylum Reform Act of 1993 103-hr-3363 R000465 Rep. Roukema, Marge [R-NJ-5] R NJ 1993-11-02 0
103-hr-3363,C000059 Immigration Enforcement and Asylum Reform Act of 1993 103-hr-3363 C000059 Rep. Calvert, Ken [R-CA-43] R CA 1993-11-02 0
103-hr-3363,C000994 Immigration Enforcement and Asylum Reform Act of 1993 103-hr-3363 C000994 Rep. Cunningham, Randy (Duke) [R-CA-51] R CA 1993-11-02 0
103-hr-3363,S000822 Immigration Enforcement and Asylum Reform Act of 1993 103-hr-3363 S000822 Rep. Stearns, Cliff [R-FL-6] R FL 1993-11-02 0
103-hr-3363,S000148 Immigration Enforcement and Asylum Reform Act of 1993 103-hr-3363 S000148 Rep. Schumer, Charles E. [D-NY-9] D NY 1993-10-26 1
103-hr-3363,M000350 Immigration Enforcement and Asylum Reform Act of 1993 103-hr-3363 M000350 Rep. McCollum, Bill [R-FL-8] R FL 1993-10-26 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);