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

68 rows where bill_id = "111-hres-1014" 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 1

  • 0 68
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
111-hres-1014,D000602 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 D000602 Rep. Davis, Artur [D-AL-7] D AL 2010-02-02 0
111-hres-1014,E000179 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 E000179 Rep. Engel, Eliot L. [D-NY-17] D NY 2010-02-02 0
111-hres-1014,L000480 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 L000480 Rep. Lowey, Nita M. [D-NY-18] D NY 2010-02-02 0
111-hres-1014,E000288 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 E000288 Rep. Ellison, Keith [D-MN-5] D MN 2010-02-02 0
111-hres-1014,W000795 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 W000795 Rep. Wilson, Joe [R-SC-2] R SC 2010-02-02 0
111-hres-1014,S000510 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 S000510 Rep. Smith, Adam [D-WA-9] D WA 2010-02-02 0
111-hres-1014,S001143 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 S001143 Rep. Souder, Mark E. [R-IN-3] R IN 2010-02-02 0
111-hres-1014,S000344 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 S000344 Rep. Sherman, Brad [D-CA-27] D CA 2010-02-02 0
111-hres-1014,S000250 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 S000250 Rep. Sessions, Pete [R-TX-32] R TX 2010-02-02 0
111-hres-1014,C001049 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 C001049 Rep. Clay, Wm. Lacy [D-MO-1] D MO 2010-01-27 0
111-hres-1014,M000133 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 M000133 Rep. Markey, Edward J. [D-MA-7] D MA 2010-01-27 0
111-hres-1014,S001162 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 S001162 Rep. Schwartz, Allyson Y. [D-PA-13] D PA 2010-01-27 0
111-hres-1014,C001037 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 C001037 Rep. Capuano, Michael E. [D-MA-8] D MA 2010-01-27 0
111-hres-1014,D000598 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 D000598 Rep. Davis, Susan A. [D-CA-53] D CA 2010-01-27 0
111-hres-1014,D000299 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 D000299 Rep. Diaz-Balart, Lincoln [R-FL-21] R FL 2010-01-27 0
111-hres-1014,H001047 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 H001047 Rep. Himes, James A. [D-CT-4] D CT 2010-01-27 0
111-hres-1014,H001038 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 H001038 Rep. Higgins, Brian [D-NY-27] D NY 2010-01-27 0
111-hres-1014,T000462 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 T000462 Rep. Tiberi, Patrick J. [R-OH-12] R OH 2010-01-27 0
111-hres-1014,M000725 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 M000725 Rep. Miller, George [D-CA-7] D CA 2010-01-27 0
111-hres-1014,C001068 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 C001068 Rep. Cohen, Steve [D-TN-9] D TN 2010-01-27 0
111-hres-1014,M000485 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 M000485 Rep. McIntyre, Mike [D-NC-7] D NC 2010-01-27 0
111-hres-1014,J000032 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 J000032 Rep. Jackson Lee, Sheila [D-TX-18] D TX 2010-01-27 0
111-hres-1014,L000287 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 L000287 Rep. Lewis, John [D-GA-5] D GA 2010-01-27 0
111-hres-1014,P000096 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 P000096 Rep. Pascrell, Bill, Jr. [D-NJ-8] D NJ 2010-01-27 0
111-hres-1014,G000553 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 G000553 Rep. Green, Al [D-TX-9] D TX 2010-01-27 0
111-hres-1014,C001072 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 C001072 Rep. Carson, Andre [D-IN-7] D IN 2010-01-27 0
111-hres-1014,R000462 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 R000462 Rep. Rothman, Steven R. [D-NJ-9] D NJ 2010-01-27 0
111-hres-1014,W000792 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 W000792 Rep. Weiner, Anthony D. [D-NY-9] D NY 2010-01-27 0
111-hres-1014,M001149 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 M001149 Rep. Michaud, Michael H. [D-ME-2] D ME 2010-01-26 0
111-hres-1014,W000797 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 W000797 Rep. Wasserman Schultz, Debbie [D-FL-20] D FL 2010-01-26 0
111-hres-1014,L000567 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 L000567 Rep. Lance, Leonard [R-NJ-7] R NJ 2010-01-26 0
111-hres-1014,M001159 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 M001159 Rep. McMorris Rodgers, Cathy [R-WA-5] R WA 2010-01-26 0
111-hres-1014,M001171 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 M001171 Rep. Maffei, Daniel B. [D-NY-25] D NY 2010-01-26 0
111-hres-1014,K000360 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 K000360 Rep. Kirk, Mark Steven [R-IL-10] R IL 2010-01-26 0
111-hres-1014,K000365 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 K000365 Rep. Kagen, Steve [D-WI-8] D WI 2010-01-26 0
111-hres-1014,W000672 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 W000672 Rep. Wolf, Frank R. [R-VA-10] R VA 2010-01-26 0
111-hres-1014,P000585 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 P000585 Rep. Platts, Todd Russell [R-PA-19] R PA 2010-01-26 0
111-hres-1014,H001032 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 H001032 Rep. Holt, Rush [D-NJ-12] D NJ 2010-01-26 0
111-hres-1014,P000149 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 P000149 Rep. Payne, Donald M. [D-NJ-10] D NJ 2010-01-26 0
111-hres-1014,M001173 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 M001173 Rep. Massa, Eric J. J. [D-NY-29] D NY 2010-01-26 0
111-hres-1014,I000057 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 I000057 Rep. Israel, Steve [D-NY-2] D NY 2010-01-26 0
111-hres-1014,P000597 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 P000597 Rep. Pingree, Chellie [D-ME-1] D ME 2010-01-26 0
111-hres-1014,K000366 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 K000366 Rep. Klein, Ron [D-FL-22] D FL 2010-01-26 0
111-hres-1014,M001148 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 M001148 Rep. Meek, Kendrick B. [D-FL-17] D FL 2010-01-26 0
111-hres-1014,S001165 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 S001165 Rep. Sires, Albio [D-NJ-13] D NJ 2010-01-26 0
111-hres-1014,B001235 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 B001235 Rep. Brown, Henry E., Jr. [R-SC-1] R SC 2010-01-26 0
111-hres-1014,F000455 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 F000455 Rep. Fudge, Marcia L. [D-OH-11] D OH 2010-01-26 0
111-hres-1014,B000911 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 B000911 Rep. Brown, Corrine [D-FL-3] D FL 2010-01-26 0
111-hres-1014,M000087 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 M000087 Rep. Maloney, Carolyn B. [D-NY-14] D NY 2010-01-26 0
111-hres-1014,D000210 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 D000210 Rep. Delahunt, Bill [D-MA-10] D MA 2010-01-26 0
111-hres-1014,T000469 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 T000469 Rep. Tonko, Paul [D-NY-21] D NY 2010-01-26 0
111-hres-1014,M001140 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 M001140 Rep. Moore, Dennis [D-KS-3] D KS 2010-01-26 0
111-hres-1014,N000002 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 N000002 Rep. Nadler, Jerrold [D-NY-8] D NY 2010-01-26 0
111-hres-1014,L000554 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 L000554 Rep. LoBiondo, Frank A. [R-NJ-2] R NJ 2010-01-26 0
111-hres-1014,C001067 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 C001067 Rep. Clarke, Yvette D. [D-NY-11] D NY 2010-01-26 0
111-hres-1014,S000248 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 S000248 Rep. Serrano, Jose E. [D-NY-16] D NY 2010-01-26 0
111-hres-1014,C000984 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 C000984 Rep. Cummings, Elijah E. [D-MD-7] D MD 2010-01-26 0
111-hres-1014,M000312 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 M000312 Rep. McGovern, James P. [D-MA-3] D MA 2010-01-26 0
111-hres-1014,N000147 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 N000147 Del. Norton, Eleanor Holmes [D-DC-At Large] D DC 2010-01-26 0
111-hres-1014,M001137 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 M001137 Rep. Meeks, Gregory W. [D-NY-6] D NY 2010-01-26 0
111-hres-1014,H001043 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 H001043 Rep. Hodes, Paul W. [D-NH-2] D NH 2010-01-26 0
111-hres-1014,F000450 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 F000450 Rep. Foxx, Virginia [R-NC-5] R NC 2010-01-19 0
111-hres-1014,F000339 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 F000339 Rep. Frank, Barney [D-MA-4] D MA 2010-01-19 0
111-hres-1014,B001149 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 B001149 Rep. Burton, Dan [R-IN-5] R IN 2010-01-19 0
111-hres-1014,M001174 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 M001174 Rep. McMahon, Michael E. [D-NY-13] D NY 2010-01-19 0
111-hres-1014,H000712 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 H000712 Rep. Holden, Tim [D-PA-17] D PA 2010-01-19 0
111-hres-1014,A000364 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 A000364 Rep. Adler, John H. [D-NJ-3] D NJ 2010-01-19 0
111-hres-1014,M000309 Recognizing and supporting the goals and ideals of North American Inclusion Month. 111-hres-1014 M000309 Rep. McCarthy, Carolyn [D-NY-4] D NY 2010-01-19 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);