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

33 rows where bill_id = "107-hr-3762" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

is_original_cosponsor 2

  • 1 19
  • 0 14
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
107-hr-3762,C001047 Pension Security Act of 2002 107-hr-3762 C001047 Rep. Capito, Shelley Moore [R-WV-2] R WV 2002-03-06 0
107-hr-3762,B000208 Pension Security Act of 2002 107-hr-3762 B000208 Rep. Bartlett, Roscoe G. [R-MD-6] R MD 2002-03-06 0
107-hr-3762,L000111 Pension Security Act of 2002 107-hr-3762 L000111 Rep. Latham, Tom [R-IA-5] R IA 2002-03-06 0
107-hr-3762,T000462 Pension Security Act of 2002 107-hr-3762 T000462 Rep. Tiberi, Patrick J. [R-OH-12] R OH 2002-03-06 0
107-hr-3762,G000152 Pension Security Act of 2002 107-hr-3762 G000152 Rep. Gibbons, Jim [R-NV-2] R NV 2002-03-06 0
107-hr-3762,G000439 Pension Security Act of 2002 107-hr-3762 G000439 Rep. Greenwood, James C. [R-PA-8] R PA 2002-03-06 0
107-hr-3762,R000569 Pension Security Act of 2002 107-hr-3762 R000569 Rep. Reynolds, Thomas M. [R-NY-27] R NY 2002-03-06 0
107-hr-3762,I000055 Pension Security Act of 2002 107-hr-3762 I000055 Rep. Isakson, Johnny [R-GA-6] R GA 2002-03-06 0
107-hr-3762,H001033 Pension Security Act of 2002 107-hr-3762 H001033 Rep. Hart, Melissa A. [R-PA-4] R PA 2002-03-06 0
107-hr-3762,S000244 Pension Security Act of 2002 107-hr-3762 S000244 Rep. Sensenbrenner, F. James, Jr. [R-WI-9] R WI 2002-03-06 0
107-hr-3762,G000545 Pension Security Act of 2002 107-hr-3762 G000545 Rep. Green, Mark [R-WI-8] R WI 2002-03-06 0
107-hr-3762,W000099 Pension Security Act of 2002 107-hr-3762 W000099 Rep. Walsh, James T. [R-NY-25] R NY 2002-03-06 0
107-hr-3762,K000306 Pension Security Act of 2002 107-hr-3762 K000306 Rep. Kolbe, Jim [R-AZ-5] R AZ 2002-03-06 0
107-hr-3762,S001144 Pension Security Act of 2002 107-hr-3762 S001144 Rep. Shays, Christopher [R-CT-4] R CT 2002-03-06 0
107-hr-3762,J000174 Pension Security Act of 2002 107-hr-3762 J000174 Rep. Johnson, Sam [R-TX-3] R TX 2002-02-14 1
107-hr-3762,O000163 Pension Security Act of 2002 107-hr-3762 O000163 Rep. Oxley, Michael G. [R-OH-4] R OH 2002-02-14 1
107-hr-3762,F000441 Pension Security Act of 2002 107-hr-3762 F000441 Rep. Fletcher, Ernie [R-KY-6] R KY 2002-02-14 1
107-hr-3762,P000265 Pension Security Act of 2002 107-hr-3762 P000265 Rep. Petri, Thomas E. [R-WI-6] R WI 2002-02-14 1
107-hr-3762,R000465 Pension Security Act of 2002 107-hr-3762 R000465 Rep. Roukema, Marge [R-NJ-5] R NJ 2002-02-14 1
107-hr-3762,M000508 Pension Security Act of 2002 107-hr-3762 M000508 Rep. McKeon, Howard P. "Buck" [R-CA-25] R CA 2002-02-14 1
107-hr-3762,C000243 Pension Security Act of 2002 107-hr-3762 C000243 Rep. Castle, Michael N. [R-DE-At Large] R DE 2002-02-14 1
107-hr-3762,U000031 Pension Security Act of 2002 107-hr-3762 U000031 Rep. Upton, Fred [R-MI-6] R MI 2002-02-14 1
107-hr-3762,T000458 Pension Security Act of 2002 107-hr-3762 T000458 Rep. Tancredo, Thomas G. [R-CO-6] R CO 2002-02-14 1
107-hr-3762,B001232 Pension Security Act of 2002 107-hr-3762 B001232 Rep. Biggert, Judy [R-IL-13] R IL 2002-02-14 1
107-hr-3762,K000361 Pension Security Act of 2002 107-hr-3762 K000361 Rep. Keller, Ric [R-FL-8] R FL 2002-02-14 1
107-hr-3762,C001048 Pension Security Act of 2002 107-hr-3762 C001048 Rep. Culberson, John Abney [R-TX-7] R TX 2002-02-14 1
107-hr-3762,C000059 Pension Security Act of 2002 107-hr-3762 C000059 Rep. Calvert, Ken [R-CA-43] R CA 2002-02-14 1
107-hr-3762,K000210 Pension Security Act of 2002 107-hr-3762 K000210 Rep. King, Peter T. [R-NY-3] R NY 2002-02-14 1
107-hr-3762,L000553 Pension Security Act of 2002 107-hr-3762 L000553 Rep. LaTourette, Steven C. [R-OH-19] R OH 2002-02-14 1
107-hr-3762,H001030 Pension Security Act of 2002 107-hr-3762 H001030 Rep. Hill, Baron P. [D-IN-9] D IN 2002-02-14 1
107-hr-3762,R000571 Pension Security Act of 2002 107-hr-3762 R000571 Rep. Rehberg, Dennis R. [R-MT-At Large] R MT 2002-02-14 1
107-hr-3762,B001236 Pension Security Act of 2002 107-hr-3762 B001236 Rep. Boozman, John [R-AR-3] R AR 2002-02-14 1
107-hr-3762,W000795 Pension Security Act of 2002 107-hr-3762 W000795 Rep. Wilson, Joe [R-SC-2] R SC 2002-02-14 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);