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

58 rows where bill_id = "111-hres-710" 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

  • 1 51
  • 0 7
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
111-hres-710,F000030 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 F000030 Rep. Farr, Sam [D-CA-17] D CA 2009-09-10 0
111-hres-710,M001174 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 M001174 Rep. McMahon, Michael E. [D-NY-13] D NY 2009-09-10 0
111-hres-710,M000087 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 M000087 Rep. Maloney, Carolyn B. [D-NY-14] D NY 2009-09-10 0
111-hres-710,B001251 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 B001251 Rep. Butterfield, G. K. [D-NC-1] D NC 2009-09-10 0
111-hres-710,G000410 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 G000410 Rep. Green, Gene [D-TX-29] D TX 2009-09-10 0
111-hres-710,C001079 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 C001079 Rep. Cao, Anh "Joseph" [R-LA-2] R LA 2009-09-10 0
111-hres-710,M001149 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 M001149 Rep. Michaud, Michael H. [D-ME-2] D ME 2009-09-10 0
111-hres-710,A000364 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 A000364 Rep. Adler, John H. [D-NJ-3] D NJ 2009-07-31 1
111-hres-710,B000716 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 B000716 Rep. Boyd, Allen [D-FL-2] D FL 2009-07-31 1
111-hres-710,B001260 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 B001260 Rep. Buchanan, Vern [R-FL-13] R FL 2009-07-31 1
111-hres-710,C001036 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 C001036 Rep. Capps, Lois [D-CA-23] D CA 2009-07-31 1
111-hres-710,C001075 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 C001075 Rep. Cassidy, Bill [R-LA-6] R LA 2009-07-31 1
111-hres-710,C000243 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 C000243 Rep. Castle, Michael N. [R-DE-At Large] R DE 2009-07-31 1
111-hres-710,D000598 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 D000598 Rep. Davis, Susan A. [D-CA-53] D CA 2009-07-31 1
111-hres-710,D000210 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 D000210 Rep. Delahunt, Bill [D-MA-10] D MA 2009-07-31 1
111-hres-710,D000216 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 D000216 Rep. DeLauro, Rosa L. [D-CT-3] D CT 2009-07-31 1
111-hres-710,D000327 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 D000327 Rep. Dicks, Norman D. [D-WA-6] D WA 2009-07-31 1
111-hres-710,F000339 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 F000339 Rep. Frank, Barney [D-MA-4] D MA 2009-07-31 1
111-hres-710,H001039 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 H001039 Rep. Hall, John J. [D-NY-19] D NY 2009-07-31 1
111-hres-710,H000213 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 H000213 Rep. Harman, Jane [D-CA-36] D CA 2009-07-31 1
111-hres-710,H001032 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 H001032 Rep. Holt, Rush [D-NJ-12] D NJ 2009-07-31 1
111-hres-710,K000113 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 K000113 Rep. Kennedy, Patrick J. [D-RI-1] D RI 2009-07-31 1
111-hres-710,K000370 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 K000370 Rep. Kosmas, Suzanne M. [D-FL-24] D FL 2009-07-31 1
111-hres-710,L000559 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 L000559 Rep. Langevin, James R. [D-RI-2] D RI 2009-07-31 1
111-hres-710,L000560 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 L000560 Rep. Larsen, Rick [D-WA-2] D WA 2009-07-31 1
111-hres-710,L000551 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 L000551 Rep. Lee, Barbara [D-CA-9] D CA 2009-07-31 1
111-hres-710,L000554 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 L000554 Rep. LoBiondo, Frank A. [R-NJ-2] R NJ 2009-07-31 1
111-hres-710,L000480 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 L000480 Rep. Lowey, Nita M. [D-NY-18] D NY 2009-07-31 1
111-hres-710,L000562 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 L000562 Rep. Lynch, Stephen F. [D-MA-9] D MA 2009-07-31 1
111-hres-710,I000026 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 I000026 Rep. Inslee, Jay [D-WA-1] D WA 2009-07-31 1
111-hres-710,M001155 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 M001155 Rep. Mack, Connie [R-FL-14] R FL 2009-07-31 1
111-hres-710,M000133 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 M000133 Rep. Markey, Edward J. [D-MA-7] D MA 2009-07-31 1
111-hres-710,M000312 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 M000312 Rep. McGovern, James P. [D-MA-3] D MA 2009-07-31 1
111-hres-710,M000485 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 M000485 Rep. McIntyre, Mike [D-NC-7] D NC 2009-07-31 1
111-hres-710,M001161 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 M001161 Rep. Melancon, Charlie [D-LA-3] D LA 2009-07-31 1
111-hres-710,M000725 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 M000725 Rep. Miller, George [D-CA-7] D CA 2009-07-31 1
111-hres-710,N000179 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 N000179 Rep. Napolitano, Grace F. [D-CA-38] D CA 2009-07-31 1
111-hres-710,P000034 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 P000034 Rep. Pallone, Frank, Jr. [D-NJ-6] D NJ 2009-07-31 1
111-hres-710,P000149 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 P000149 Rep. Payne, Donald M. [D-NJ-10] D NJ 2009-07-31 1
111-hres-710,P000596 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 P000596 Resident Commissioner Pierluisi, Pedro R. [D-PR-At Large] D PR 2009-07-31 1
111-hres-710,P000599 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 P000599 Rep. Posey, Bill [R-FL-15] R FL 2009-07-31 1
111-hres-710,P000586 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 P000586 Rep. Putnam, Adam H. [R-FL-12] R FL 2009-07-31 1
111-hres-710,R000583 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 R000583 Rep. Rooney, Thomas J. [R-FL-16] R FL 2009-07-31 1
111-hres-710,R000462 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 R000462 Rep. Rothman, Steven R. [D-NJ-9] D NJ 2009-07-31 1
111-hres-710,S001168 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 S001168 Rep. Sarbanes, John P. [D-MD-3] D MD 2009-07-31 1
111-hres-710,S001150 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 S001150 Rep. Schiff, Adam B. [D-CA-29] D CA 2009-07-31 1
111-hres-710,S000185 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 S000185 Rep. Scott, Robert C. "Bobby" [D-VA-3] D VA 2009-07-31 1
111-hres-710,S001170 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 S001170 Rep. Shea-Porter, Carol [D-NH-1] D NH 2009-07-31 1
111-hres-710,S001165 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 S001165 Rep. Sires, Albio [D-NJ-13] D NJ 2009-07-31 1
111-hres-710,S001175 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 S001175 Rep. Speier, Jackie [D-CA-12] D CA 2009-07-31 1
111-hres-710,S000810 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 S000810 Rep. Stark, Fortney Pete [D-CA-13] D CA 2009-07-31 1
111-hres-710,W000804 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 W000804 Rep. Wittman, Robert J. [R-VA-1] R VA 2009-07-31 1
111-hres-710,W000793 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 W000793 Rep. Wu, David [D-OR-1] D OR 2009-07-31 1
111-hres-710,R000486 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 R000486 Rep. Roybal-Allard, Lucille [D-CA-34] D CA 2009-07-31 1
111-hres-710,S000522 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 S000522 Rep. Smith, Christopher H. [R-NJ-4] R NJ 2009-07-31 1
111-hres-710,M001137 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 M001137 Rep. Meeks, Gregory W. [D-NY-6] D NY 2009-07-31 1
111-hres-710,B001257 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 B001257 Rep. Bilirakis, Gus M. [R-FL-9] R FL 2009-07-31 1
111-hres-710,S000248 Supporting the goals and ideals of "National Estuaries Day". 111-hres-710 S000248 Rep. Serrano, Jose E. [D-NY-16] D NY 2009-07-31 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);