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

22 rows where bill_id = "110-hr-2291" 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 15
  • 1 7
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
110-hr-2291,R000580 To grant immunity from civil liability to any person who voluntarily notifies appropriate security personnel of suspicious activity believed to threaten transportation safety or security or takes reasonable action to mitigate such activity. 110-hr-2291 R000580 Rep. Roskam, Peter J. [R-IL-6] R IL 2007-07-27 0
110-hr-2291,F000440 To grant immunity from civil liability to any person who voluntarily notifies appropriate security personnel of suspicious activity believed to threaten transportation safety or security or takes reasonable action to mitigate such activity. 110-hr-2291 F000440 Rep. Fossella, Vito [R-NY-13] R NY 2007-07-25 0
110-hr-2291,T000238 To grant immunity from civil liability to any person who voluntarily notifies appropriate security personnel of suspicious activity believed to threaten transportation safety or security or takes reasonable action to mitigate such activity. 110-hr-2291 T000238 Rep. Thornberry, Mac [R-TX-13] R TX 2007-07-25 0
110-hr-2291,M000472 To grant immunity from civil liability to any person who voluntarily notifies appropriate security personnel of suspicious activity believed to threaten transportation safety or security or takes reasonable action to mitigate such activity. 110-hr-2291 M000472 Rep. McHugh, John M. [R-NY-23] R NY 2007-07-25 0
110-hr-2291,P000591 To grant immunity from civil liability to any person who voluntarily notifies appropriate security personnel of suspicious activity believed to threaten transportation safety or security or takes reasonable action to mitigate such activity. 110-hr-2291 P000591 Rep. Price, Tom [R-GA-6] R GA 2007-07-19 0
110-hr-2291,S000250 To grant immunity from civil liability to any person who voluntarily notifies appropriate security personnel of suspicious activity believed to threaten transportation safety or security or takes reasonable action to mitigate such activity. 110-hr-2291 S000250 Rep. Sessions, Pete [R-TX-32] R TX 2007-07-19 0
110-hr-2291,L000554 To grant immunity from civil liability to any person who voluntarily notifies appropriate security personnel of suspicious activity believed to threaten transportation safety or security or takes reasonable action to mitigate such activity. 110-hr-2291 L000554 Rep. LoBiondo, Frank A. [R-NJ-2] R NJ 2007-07-19 0
110-hr-2291,W000672 To grant immunity from civil liability to any person who voluntarily notifies appropriate security personnel of suspicious activity believed to threaten transportation safety or security or takes reasonable action to mitigate such activity. 110-hr-2291 W000672 Rep. Wolf, Frank R. [R-VA-10] R VA 2007-07-19 0
110-hr-2291,T000260 To grant immunity from civil liability to any person who voluntarily notifies appropriate security personnel of suspicious activity believed to threaten transportation safety or security or takes reasonable action to mitigate such activity. 110-hr-2291 T000260 Rep. Tiahrt, Todd [R-KS-4] R KS 2007-05-24 0
110-hr-2291,S000522 To grant immunity from civil liability to any person who voluntarily notifies appropriate security personnel of suspicious activity believed to threaten transportation safety or security or takes reasonable action to mitigate such activity. 110-hr-2291 S000522 Rep. Smith, Christopher H. [R-NJ-4] R NJ 2007-05-24 0
110-hr-2291,M001157 To grant immunity from civil liability to any person who voluntarily notifies appropriate security personnel of suspicious activity believed to threaten transportation safety or security or takes reasonable action to mitigate such activity. 110-hr-2291 M001157 Rep. McCaul, Michael T. [R-TX-10] R TX 2007-05-16 0
110-hr-2291,J000255 To grant immunity from civil liability to any person who voluntarily notifies appropriate security personnel of suspicious activity believed to threaten transportation safety or security or takes reasonable action to mitigate such activity. 110-hr-2291 J000255 Rep. Jones, Walter B., Jr. [R-NC-3] R NC 2007-05-16 0
110-hr-2291,F000450 To grant immunity from civil liability to any person who voluntarily notifies appropriate security personnel of suspicious activity believed to threaten transportation safety or security or takes reasonable action to mitigate such activity. 110-hr-2291 F000450 Rep. Foxx, Virginia [R-NC-5] R NC 2007-05-16 0
110-hr-2291,T000463 To grant immunity from civil liability to any person who voluntarily notifies appropriate security personnel of suspicious activity believed to threaten transportation safety or security or takes reasonable action to mitigate such activity. 110-hr-2291 T000463 Rep. Turner, Michael R. [R-OH-3] R OH 2007-05-16 0
110-hr-2291,T000193 To grant immunity from civil liability to any person who voluntarily notifies appropriate security personnel of suspicious activity believed to threaten transportation safety or security or takes reasonable action to mitigate such activity. 110-hr-2291 T000193 Rep. Thompson, Bennie G. [D-MS-2] D MS 2007-05-16 0
110-hr-2291,K000210 To grant immunity from civil liability to any person who voluntarily notifies appropriate security personnel of suspicious activity believed to threaten transportation safety or security or takes reasonable action to mitigate such activity. 110-hr-2291 K000210 Rep. King, Peter T. [R-NY-3] R NY 2007-05-14 1
110-hr-2291,S001154 To grant immunity from civil liability to any person who voluntarily notifies appropriate security personnel of suspicious activity believed to threaten transportation safety or security or takes reasonable action to mitigate such activity. 110-hr-2291 S001154 Rep. Shuster, Bill [R-PA-9] R PA 2007-05-14 1
110-hr-2291,B000575 To grant immunity from civil liability to any person who voluntarily notifies appropriate security personnel of suspicious activity believed to threaten transportation safety or security or takes reasonable action to mitigate such activity. 110-hr-2291 B000575 Rep. Blunt, Roy [R-MO-7] R MO 2007-05-14 1
110-hr-2291,S000097 To grant immunity from civil liability to any person who voluntarily notifies appropriate security personnel of suspicious activity believed to threaten transportation safety or security or takes reasonable action to mitigate such activity. 110-hr-2291 S000097 Rep. Saxton, Jim [R-NJ-3] R NJ 2007-05-14 1
110-hr-2291,M001159 To grant immunity from civil liability to any person who voluntarily notifies appropriate security personnel of suspicious activity believed to threaten transportation safety or security or takes reasonable action to mitigate such activity. 110-hr-2291 M001159 Rep. McMorris Rodgers, Cathy [R-WA-5] R WA 2007-05-14 1
110-hr-2291,F000447 To grant immunity from civil liability to any person who voluntarily notifies appropriate security personnel of suspicious activity believed to threaten transportation safety or security or takes reasonable action to mitigate such activity. 110-hr-2291 F000447 Rep. Feeney, Tom [R-FL-24] R FL 2007-05-14 1
110-hr-2291,K000363 To grant immunity from civil liability to any person who voluntarily notifies appropriate security personnel of suspicious activity believed to threaten transportation safety or security or takes reasonable action to mitigate such activity. 110-hr-2291 K000363 Rep. Kline, John [R-MN-2] R MN 2007-05-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);