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 = "111-hconres-42" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: state, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 1

  • 0 26
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
111-hconres-42,G000535 Recognizing the contributions of the New York Public Library's Schomburg Center for Research in Black Culture in educating the people of the United States about the African-American migration experience, and for other purposes. 111-hconres-42 G000535 Rep. Gutierrez, Luis V. [D-IL-4] D IL 2009-11-18 0
111-hconres-42,M001137 Recognizing the contributions of the New York Public Library's Schomburg Center for Research in Black Culture in educating the people of the United States about the African-American migration experience, and for other purposes. 111-hconres-42 M001137 Rep. Meeks, Gregory W. [D-NY-6] D NY 2009-11-18 0
111-hconres-42,L000551 Recognizing the contributions of the New York Public Library's Schomburg Center for Research in Black Culture in educating the people of the United States about the African-American migration experience, and for other purposes. 111-hconres-42 L000551 Rep. Lee, Barbara [D-CA-9] D CA 2009-11-18 0
111-hconres-42,S001177 Recognizing the contributions of the New York Public Library's Schomburg Center for Research in Black Culture in educating the people of the United States about the African-American migration experience, and for other purposes. 111-hconres-42 S001177 Del. Sablan, Gregorio Kilili Camacho [D-MP-At Large] D MP 2009-11-04 0
111-hconres-42,P000596 Recognizing the contributions of the New York Public Library's Schomburg Center for Research in Black Culture in educating the people of the United States about the African-American migration experience, and for other purposes. 111-hconres-42 P000596 Resident Commissioner Pierluisi, Pedro R. [D-PR-At Large] D PR 2009-11-04 0
111-hconres-42,T000193 Recognizing the contributions of the New York Public Library's Schomburg Center for Research in Black Culture in educating the people of the United States about the African-American migration experience, and for other purposes. 111-hconres-42 T000193 Rep. Thompson, Bennie G. [D-MS-2] D MS 2009-10-29 0
111-hconres-42,C001072 Recognizing the contributions of the New York Public Library's Schomburg Center for Research in Black Culture in educating the people of the United States about the African-American migration experience, and for other purposes. 111-hconres-42 C001072 Rep. Carson, Andre [D-IN-7] D IN 2009-10-27 0
111-hconres-42,J000126 Recognizing the contributions of the New York Public Library's Schomburg Center for Research in Black Culture in educating the people of the United States about the African-American migration experience, and for other purposes. 111-hconres-42 J000126 Rep. Johnson, Eddie Bernice [D-TX-30] D TX 2009-10-22 0
111-hconres-42,W000794 Recognizing the contributions of the New York Public Library's Schomburg Center for Research in Black Culture in educating the people of the United States about the African-American migration experience, and for other purposes. 111-hconres-42 W000794 Rep. Watson, Diane E. [D-CA-33] D CA 2009-10-22 0
111-hconres-42,S000185 Recognizing the contributions of the New York Public Library's Schomburg Center for Research in Black Culture in educating the people of the United States about the African-American migration experience, and for other purposes. 111-hconres-42 S000185 Rep. Scott, Robert C. "Bobby" [D-VA-3] D VA 2009-10-21 0
111-hconres-42,F000043 Recognizing the contributions of the New York Public Library's Schomburg Center for Research in Black Culture in educating the people of the United States about the African-American migration experience, and for other purposes. 111-hconres-42 F000043 Rep. Fattah, Chaka [D-PA-2] D PA 2009-10-21 0
111-hconres-42,B000490 Recognizing the contributions of the New York Public Library's Schomburg Center for Research in Black Culture in educating the people of the United States about the African-American migration experience, and for other purposes. 111-hconres-42 B000490 Rep. Bishop, Sanford D., Jr. [D-GA-2] D GA 2009-10-21 0
111-hconres-42,H000636 Recognizing the contributions of the New York Public Library's Schomburg Center for Research in Black Culture in educating the people of the United States about the African-American migration experience, and for other purposes. 111-hconres-42 H000636 Rep. Hinojosa, Ruben [D-TX-15] D TX 2009-10-21 0
111-hconres-42,C000380 Recognizing the contributions of the New York Public Library's Schomburg Center for Research in Black Culture in educating the people of the United States about the African-American migration experience, and for other purposes. 111-hconres-42 C000380 Del. Christensen, Donna M. [D-VI-At Large] D VI 2009-10-21 0
111-hconres-42,G000551 Recognizing the contributions of the New York Public Library's Schomburg Center for Research in Black Culture in educating the people of the United States about the African-American migration experience, and for other purposes. 111-hconres-42 G000551 Rep. Grijalva, Raúl M. [D-AZ-7] D AZ 2009-10-14 0
111-hconres-42,S000248 Recognizing the contributions of the New York Public Library's Schomburg Center for Research in Black Culture in educating the people of the United States about the African-American migration experience, and for other purposes. 111-hconres-42 S000248 Rep. Serrano, Jose E. [D-NY-16] D NY 2009-10-13 0
111-hconres-42,M001148 Recognizing the contributions of the New York Public Library's Schomburg Center for Research in Black Culture in educating the people of the United States about the African-American migration experience, and for other purposes. 111-hconres-42 M001148 Rep. Meek, Kendrick B. [D-FL-17] D FL 2009-10-01 0
111-hconres-42,N000147 Recognizing the contributions of the New York Public Library's Schomburg Center for Research in Black Culture in educating the people of the United States about the African-American migration experience, and for other purposes. 111-hconres-42 N000147 Del. Norton, Eleanor Holmes [D-DC-At Large] D DC 2009-10-01 0
111-hconres-42,C000714 Recognizing the contributions of the New York Public Library's Schomburg Center for Research in Black Culture in educating the people of the United States about the African-American migration experience, and for other purposes. 111-hconres-42 C000714 Rep. Conyers, John, Jr. [D-MI-14] D MI 2009-10-01 0
111-hconres-42,D000096 Recognizing the contributions of the New York Public Library's Schomburg Center for Research in Black Culture in educating the people of the United States about the African-American migration experience, and for other purposes. 111-hconres-42 D000096 Rep. Davis, Danny K. [D-IL-7] D IL 2009-09-15 0
111-hconres-42,J000032 Recognizing the contributions of the New York Public Library's Schomburg Center for Research in Black Culture in educating the people of the United States about the African-American migration experience, and for other purposes. 111-hconres-42 J000032 Rep. Jackson-Lee, Sheila [D-TX-18] D TX 2009-09-09 0
111-hconres-42,F000455 Recognizing the contributions of the New York Public Library's Schomburg Center for Research in Black Culture in educating the people of the United States about the African-American migration experience, and for other purposes. 111-hconres-42 F000455 Rep. Fudge, Marcia L. [D-OH-11] D OH 2009-07-31 0
111-hconres-42,W000207 Recognizing the contributions of the New York Public Library's Schomburg Center for Research in Black Culture in educating the people of the United States about the African-American migration experience, and for other purposes. 111-hconres-42 W000207 Rep. Watt, Melvin L. [D-NC-12] D NC 2009-07-30 0
111-hconres-42,F000116 Recognizing the contributions of the New York Public Library's Schomburg Center for Research in Black Culture in educating the people of the United States about the African-American migration experience, and for other purposes. 111-hconres-42 F000116 Rep. Filner, Bob [D-CA-51] D CA 2009-07-30 0
111-hconres-42,J000288 Recognizing the contributions of the New York Public Library's Schomburg Center for Research in Black Culture in educating the people of the United States about the African-American migration experience, and for other purposes. 111-hconres-42 J000288 Rep. Johnson, Henry C. "Hank," Jr. [D-GA-4] D GA 2009-07-30 0
111-hconres-42,L000287 Recognizing the contributions of the New York Public Library's Schomburg Center for Research in Black Culture in educating the people of the United States about the African-American migration experience, and for other purposes. 111-hconres-42 L000287 Rep. Lewis, John [D-GA-5] D GA 2009-03-25 0

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);