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

37 rows where bill_id = "111-hres-1503" 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 25
  • 1 12
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
111-hres-1503,K000366 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 K000366 Rep. Klein, Ron [D-FL-22] D FL 2010-09-22 0
111-hres-1503,B001260 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 B001260 Rep. Buchanan, Vern [R-FL-13] R FL 2010-09-15 0
111-hres-1503,M001166 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 M001166 Rep. McNerney, Jerry [D-CA-11] D CA 2010-09-15 0
111-hres-1503,M001148 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 M001148 Rep. Meek, Kendrick B. [D-FL-17] D FL 2010-09-15 0
111-hres-1503,L000287 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 L000287 Rep. Lewis, John [D-GA-5] D GA 2010-09-15 0
111-hres-1503,B000652 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 B000652 Rep. Boswell, Leonard L. [D-IA-3] D IA 2010-09-15 0
111-hres-1503,B001242 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 B001242 Rep. Bishop, Timothy H. [D-NY-1] D NY 2010-09-15 0
111-hres-1503,L000551 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 L000551 Rep. Lee, Barbara [D-CA-9] D CA 2010-09-15 0
111-hres-1503,B000410 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 B000410 Rep. Berman, Howard L. [D-CA-28] D CA 2010-09-15 0
111-hres-1503,K000370 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 K000370 Rep. Kosmas, Suzanne M. [D-FL-24] D FL 2010-09-15 0
111-hres-1503,S000810 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 S000810 Rep. Stark, Fortney Pete [D-CA-13] D CA 2010-09-15 0
111-hres-1503,M001155 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 M001155 Rep. Mack, Connie [R-FL-14] R FL 2010-09-15 0
111-hres-1503,S000248 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 S000248 Rep. Serrano, Jose E. [D-NY-16] D NY 2010-09-15 0
111-hres-1503,D000216 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 D000216 Rep. DeLauro, Rosa L. [D-CT-3] D CT 2010-09-15 0
111-hres-1503,M000485 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 M000485 Rep. McIntyre, Mike [D-NC-7] D NC 2010-09-15 0
111-hres-1503,W000793 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 W000793 Rep. Wu, David [D-OR-1] D OR 2010-09-15 0
111-hres-1503,C000380 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 C000380 Del. Christensen, Donna M. [D-VI-At Large] D VI 2010-09-15 0
111-hres-1503,H001042 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 H001042 Rep. Hirono, Mazie K. [D-HI-2] D HI 2010-09-15 0
111-hres-1503,W000738 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 W000738 Rep. Woolsey, Lynn C. [D-CA-6] D CA 2010-09-15 0
111-hres-1503,G000559 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 G000559 Rep. Garamendi, John [D-CA-10] D CA 2010-09-14 0
111-hres-1503,S001169 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 S001169 Rep. Sestak, Joe [D-PA-7] D PA 2010-08-10 0
111-hres-1503,C000243 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 C000243 Rep. Castle, Michael N. [R-DE-At Large] R DE 2010-07-30 0
111-hres-1503,H000712 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 H000712 Rep. Holden, Tim [D-PA-17] D PA 2010-07-30 0
111-hres-1503,S001170 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 S001170 Rep. Shea-Porter, Carol [D-NH-1] D NH 2010-07-30 0
111-hres-1503,R000486 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 R000486 Rep. Roybal-Allard, Lucille [D-CA-34] D CA 2010-07-13 0
111-hres-1503,C001069 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 C001069 Rep. Courtney, Joe [D-CT-2] D CT 2010-07-01 1
111-hres-1503,L000480 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 L000480 Rep. Lowey, Nita M. [D-NY-18] D NY 2010-07-01 1
111-hres-1503,S001175 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 S001175 Rep. Speier, Jackie [D-CA-12] D CA 2010-07-01 1
111-hres-1503,L000554 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 L000554 Rep. LoBiondo, Frank A. [R-NJ-2] R NJ 2010-07-01 1
111-hres-1503,H000324 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 H000324 Rep. Hastings, Alcee L. [D-FL-23] D FL 2010-07-01 1
111-hres-1503,F000030 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 F000030 Rep. Farr, Sam [D-CA-17] D CA 2010-07-01 1
111-hres-1503,C001078 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 C001078 Rep. Connolly, Gerald E. [D-VA-11] D VA 2010-07-01 1
111-hres-1503,Y000031 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 Y000031 Rep. Young, C. W. Bill [R-FL-10] R FL 2010-07-01 1
111-hres-1503,W000797 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 W000797 Rep. Wasserman Schultz, Debbie [D-FL-20] D FL 2010-07-01 1
111-hres-1503,B000716 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 B000716 Rep. Boyd, Allen [D-FL-2] D FL 2010-07-01 1
111-hres-1503,P000599 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 P000599 Rep. Posey, Bill [R-FL-15] R FL 2010-07-01 1
111-hres-1503,C001036 Expressing support for the goals and ideals of National Estuaries Day, and for other purposes. 111-hres-1503 C001036 Rep. Capps, Lois [D-CA-23] D 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);