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

25 rows where bill_id = "115-hconres-61" 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 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
115-hconres-61,H001065 Expressing the sense of Congress that all trade agreements the United States enters into, should provide reasonable access and collaboration of each nation involved in such an agreement, for the purpose of search and recovery activities relating to members of the United States Armed Forces missing in action from prior wars or military conflicts. 115-hconres-61 H001065 Rep. Holding, George [R-NC-2] R NC 2018-07-11 0
115-hconres-61,C001106 Expressing the sense of Congress that all trade agreements the United States enters into, should provide reasonable access and collaboration of each nation involved in such an agreement, for the purpose of search and recovery activities relating to members of the United States Armed Forces missing in action from prior wars or military conflicts. 115-hconres-61 C001106 Rep. Costello, Ryan A. [R-PA-6] R PA 2018-02-02 0
115-hconres-61,M001179 Expressing the sense of Congress that all trade agreements the United States enters into, should provide reasonable access and collaboration of each nation involved in such an agreement, for the purpose of search and recovery activities relating to members of the United States Armed Forces missing in action from prior wars or military conflicts. 115-hconres-61 M001179 Rep. Marino, Tom [R-PA-10] R PA 2018-01-29 0
115-hconres-61,W000799 Expressing the sense of Congress that all trade agreements the United States enters into, should provide reasonable access and collaboration of each nation involved in such an agreement, for the purpose of search and recovery activities relating to members of the United States Armed Forces missing in action from prior wars or military conflicts. 115-hconres-61 W000799 Rep. Walz, Timothy J. [D-MN-1] D MN 2018-01-29 0
115-hconres-61,C001096 Expressing the sense of Congress that all trade agreements the United States enters into, should provide reasonable access and collaboration of each nation involved in such an agreement, for the purpose of search and recovery activities relating to members of the United States Armed Forces missing in action from prior wars or military conflicts. 115-hconres-61 C001096 Rep. Cramer, Kevin [R-ND-At Large] R ND 2018-01-29 0
115-hconres-61,H001059 Expressing the sense of Congress that all trade agreements the United States enters into, should provide reasonable access and collaboration of each nation involved in such an agreement, for the purpose of search and recovery activities relating to members of the United States Armed Forces missing in action from prior wars or military conflicts. 115-hconres-61 H001059 Rep. Hultgren, Randy [R-IL-14] R IL 2017-11-08 0
115-hconres-61,A000374 Expressing the sense of Congress that all trade agreements the United States enters into, should provide reasonable access and collaboration of each nation involved in such an agreement, for the purpose of search and recovery activities relating to members of the United States Armed Forces missing in action from prior wars or military conflicts. 115-hconres-61 A000374 Rep. Abraham, Ralph Lee [R-LA-5] R LA 2017-11-08 0
115-hconres-61,L000567 Expressing the sense of Congress that all trade agreements the United States enters into, should provide reasonable access and collaboration of each nation involved in such an agreement, for the purpose of search and recovery activities relating to members of the United States Armed Forces missing in action from prior wars or military conflicts. 115-hconres-61 L000567 Rep. Lance, Leonard [R-NJ-7] R NJ 2017-11-08 0
115-hconres-61,R000583 Expressing the sense of Congress that all trade agreements the United States enters into, should provide reasonable access and collaboration of each nation involved in such an agreement, for the purpose of search and recovery activities relating to members of the United States Armed Forces missing in action from prior wars or military conflicts. 115-hconres-61 R000583 Rep. Rooney, Thomas J. [R-FL-17] R FL 2017-11-08 0
115-hconres-61,P000588 Expressing the sense of Congress that all trade agreements the United States enters into, should provide reasonable access and collaboration of each nation involved in such an agreement, for the purpose of search and recovery activities relating to members of the United States Armed Forces missing in action from prior wars or military conflicts. 115-hconres-61 P000588 Rep. Pearce, Stevan [R-NM-2] R NM 2017-11-08 0
115-hconres-61,C001090 Expressing the sense of Congress that all trade agreements the United States enters into, should provide reasonable access and collaboration of each nation involved in such an agreement, for the purpose of search and recovery activities relating to members of the United States Armed Forces missing in action from prior wars or military conflicts. 115-hconres-61 C001090 Rep. Cartwright, Matt [D-PA-17] D PA 2017-11-03 0
115-hconres-61,P000606 Expressing the sense of Congress that all trade agreements the United States enters into, should provide reasonable access and collaboration of each nation involved in such an agreement, for the purpose of search and recovery activities relating to members of the United States Armed Forces missing in action from prior wars or military conflicts. 115-hconres-61 P000606 Rep. Pittenger, Robert [R-NC-9] R NC 2017-11-03 0
115-hconres-61,P000592 Expressing the sense of Congress that all trade agreements the United States enters into, should provide reasonable access and collaboration of each nation involved in such an agreement, for the purpose of search and recovery activities relating to members of the United States Armed Forces missing in action from prior wars or military conflicts. 115-hconres-61 P000592 Rep. Poe, Ted [R-TX-2] R TX 2017-11-03 0
115-hconres-61,H001064 Expressing the sense of Congress that all trade agreements the United States enters into, should provide reasonable access and collaboration of each nation involved in such an agreement, for the purpose of search and recovery activities relating to members of the United States Armed Forces missing in action from prior wars or military conflicts. 115-hconres-61 H001064 Rep. Heck, Denny [D-WA-10] D WA 2017-09-25 0
115-hconres-61,P000605 Expressing the sense of Congress that all trade agreements the United States enters into, should provide reasonable access and collaboration of each nation involved in such an agreement, for the purpose of search and recovery activities relating to members of the United States Armed Forces missing in action from prior wars or military conflicts. 115-hconres-61 P000605 Rep. Perry, Scott [R-PA-4] R PA 2017-09-21 0
115-hconres-61,R000608 Expressing the sense of Congress that all trade agreements the United States enters into, should provide reasonable access and collaboration of each nation involved in such an agreement, for the purpose of search and recovery activities relating to members of the United States Armed Forces missing in action from prior wars or military conflicts. 115-hconres-61 R000608 Rep. Rosen, Jacky [D-NV-3] D NV 2017-09-21 0
115-hconres-61,H001045 Expressing the sense of Congress that all trade agreements the United States enters into, should provide reasonable access and collaboration of each nation involved in such an agreement, for the purpose of search and recovery activities relating to members of the United States Armed Forces missing in action from prior wars or military conflicts. 115-hconres-61 H001045 Rep. Harper, Gregg [R-MS-3] R MS 2017-09-18 0
115-hconres-61,D000619 Expressing the sense of Congress that all trade agreements the United States enters into, should provide reasonable access and collaboration of each nation involved in such an agreement, for the purpose of search and recovery activities relating to members of the United States Armed Forces missing in action from prior wars or military conflicts. 115-hconres-61 D000619 Rep. Davis, Rodney [R-IL-13] R IL 2017-06-28 0
115-hconres-61,K000362 Expressing the sense of Congress that all trade agreements the United States enters into, should provide reasonable access and collaboration of each nation involved in such an agreement, for the purpose of search and recovery activities relating to members of the United States Armed Forces missing in action from prior wars or military conflicts. 115-hconres-61 K000362 Rep. King, Steve [R-IA-4] R IA 2017-06-15 0
115-hconres-61,H001067 Expressing the sense of Congress that all trade agreements the United States enters into, should provide reasonable access and collaboration of each nation involved in such an agreement, for the purpose of search and recovery activities relating to members of the United States Armed Forces missing in action from prior wars or military conflicts. 115-hconres-61 H001067 Rep. Hudson, Richard [R-NC-8] R NC 2017-06-15 0
115-hconres-61,P000599 Expressing the sense of Congress that all trade agreements the United States enters into, should provide reasonable access and collaboration of each nation involved in such an agreement, for the purpose of search and recovery activities relating to members of the United States Armed Forces missing in action from prior wars or military conflicts. 115-hconres-61 P000599 Rep. Posey, Bill [R-FL-8] R FL 2017-06-15 0
115-hconres-61,B001269 Expressing the sense of Congress that all trade agreements the United States enters into, should provide reasonable access and collaboration of each nation involved in such an agreement, for the purpose of search and recovery activities relating to members of the United States Armed Forces missing in action from prior wars or military conflicts. 115-hconres-61 B001269 Rep. Barletta, Lou [R-PA-11] R PA 2017-06-12 0
115-hconres-61,A000369 Expressing the sense of Congress that all trade agreements the United States enters into, should provide reasonable access and collaboration of each nation involved in such an agreement, for the purpose of search and recovery activities relating to members of the United States Armed Forces missing in action from prior wars or military conflicts. 115-hconres-61 A000369 Rep. Amodei, Mark E. [R-NV-2] R NV 2017-06-07 0
115-hconres-61,J000255 Expressing the sense of Congress that all trade agreements the United States enters into, should provide reasonable access and collaboration of each nation involved in such an agreement, for the purpose of search and recovery activities relating to members of the United States Armed Forces missing in action from prior wars or military conflicts. 115-hconres-61 J000255 Rep. Jones, Walter B., Jr. [R-NC-3] R NC 2017-06-07 0
115-hconres-61,C001078 Expressing the sense of Congress that all trade agreements the United States enters into, should provide reasonable access and collaboration of each nation involved in such an agreement, for the purpose of search and recovery activities relating to members of the United States Armed Forces missing in action from prior wars or military conflicts. 115-hconres-61 C001078 Rep. Connolly, Gerald E. [D-VA-11] D VA 2017-05-24 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);