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

40 rows where bill_id = "111-hconres-296" 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 21
  • 1 19
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
111-hconres-296,C001068 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 C001068 Rep. Cohen, Steve [D-TN-9] D TN 2010-11-17 0
111-hconres-296,C001078 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 C001078 Rep. Connolly, Gerald E. [D-VA-11] D VA 2010-09-22 0
111-hconres-296,R000395 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 R000395 Rep. Rogers, Harold [R-KY-5] R KY 2010-09-22 0
111-hconres-296,C001064 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 C001064 Rep. Campbell, John [R-CA-48] R CA 2010-07-20 0
111-hconres-296,M000485 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 M000485 Rep. McIntyre, Mike [D-NC-7] D NC 2010-07-20 0
111-hconres-296,M001178 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 M001178 Rep. Murphy, Scott [D-NY-20] D NY 2010-07-20 0
111-hconres-296,G000552 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 G000552 Rep. Gohmert, Louie [R-TX-1] R TX 2010-07-15 0
111-hconres-296,W000672 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 W000672 Rep. Wolf, Frank R. [R-VA-10] R VA 2010-07-15 0
111-hconres-296,Y000031 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 Y000031 Rep. Young, C. W. Bill [R-FL-10] R FL 2010-07-15 0
111-hconres-296,W000804 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 W000804 Rep. Wittman, Robert J. [R-VA-1] R VA 2010-07-15 0
111-hconres-296,G000554 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 G000554 Rep. Giffords, Gabrielle [D-AZ-8] D AZ 2010-07-15 0
111-hconres-296,B001227 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 B001227 Rep. Brady, Robert A. [D-PA-1] D PA 2010-07-15 0
111-hconres-296,H001046 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 H001046 Rep. Heinrich, Martin [D-NM-1] D NM 2010-07-15 0
111-hconres-296,K000369 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 K000369 Rep. Kissell, Larry [D-NC-8] D NC 2010-07-15 0
111-hconres-296,M001134 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 M001134 Rep. Myrick, Sue Wilkins [R-NC-9] R NC 2010-07-13 0
111-hconres-296,K000220 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 K000220 Rep. Kingston, Jack [R-GA-1] R GA 2010-07-13 0
111-hconres-296,K000360 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 K000360 Rep. Kirk, Mark Steven [R-IL-10] R IL 2010-07-13 0
111-hconres-296,K000363 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 K000363 Rep. Kline, John [R-MN-2] R MN 2010-07-13 0
111-hconres-296,B001254 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 B001254 Rep. Boren, Dan [D-OK-2] D OK 2010-07-13 0
111-hconres-296,O000169 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 O000169 Rep. Owens, William L. [D-NY-23] D NY 2010-07-13 0
111-hconres-296,W000799 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 W000799 Rep. Walz, Timothy J. [D-MN-1] D MN 2010-07-13 0
111-hconres-296,B001245 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 B001245 Del. Bordallo, Madeleine Z. [D-GU-At Large] D GU 2010-07-01 1
111-hconres-296,M001146 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 M001146 Rep. Marshall, Jim [D-GA-8] D GA 2010-07-01 1
111-hconres-296,S001177 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 S001177 Del. Sablan, Gregorio Kilili Camacho [D-MP-At Large] D MP 2010-07-01 1
111-hconres-296,S001179 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 S001179 Rep. Schock, Aaron [R-IL-18] R IL 2010-07-01 1
111-hconres-296,B000208 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 B000208 Rep. Bartlett, Roscoe G. [R-MD-6] R MD 2010-07-01 1
111-hconres-296,C001059 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 C001059 Rep. Costa, Jim [D-CA-20] D CA 2010-07-01 1
111-hconres-296,P000600 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 P000600 Rep. Perriello, Thomas S.P. [D-VA-5] D VA 2010-07-01 1
111-hconres-296,T000238 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 T000238 Rep. Thornberry, Mac [R-TX-13] R TX 2010-07-01 1
111-hconres-296,H001048 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 H001048 Rep. Hunter, Duncan D. [R-CA-52] R CA 2010-07-01 1
111-hconres-296,C001062 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 C001062 Rep. Conaway, K. Michael [R-TX-11] R TX 2010-07-01 1
111-hconres-296,W000795 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 W000795 Rep. Wilson, Joe [R-SC-2] R SC 2010-07-01 1
111-hconres-296,R000575 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 R000575 Rep. Rogers, Mike D. [R-AL-3] R AL 2010-07-01 1
111-hconres-296,J000255 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 J000255 Rep. Jones, Walter B., Jr. [R-NC-3] R NC 2010-07-01 1
111-hconres-296,B001203 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 B001203 Rep. Buyer, Steve [R-IN-4] R IN 2010-07-01 1
111-hconres-296,T000463 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 T000463 Rep. Turner, Michael R. [R-OH-3] R OH 2010-07-01 1
111-hconres-296,L000564 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 L000564 Rep. Lamborn, Doug [R-CO-5] R CO 2010-07-01 1
111-hconres-296,T000260 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 T000260 Rep. Tiahrt, Todd [R-KS-4] R KS 2010-07-01 1
111-hconres-296,S001170 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 S001170 Rep. Shea-Porter, Carol [D-NH-1] D NH 2010-07-01 1
111-hconres-296,I000056 Recognizing the 65th anniversary of the end of World War II. 111-hconres-296 I000056 Rep. Issa, Darrell E. [R-CA-49] R CA 2010-07-01 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);