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

13 rows where bill_id = "111-hres-958" 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 10
  • 1 3
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
111-hres-958,L000563 Congratulating the United States Men's National Soccer Team for securing a berth at the 2010 FIFA World Cup in South Africa. 111-hres-958 L000563 Rep. Lipinski, Daniel [D-IL-3] D IL 2010-01-26 0
111-hres-958,C000059 Congratulating the United States Men's National Soccer Team for securing a berth at the 2010 FIFA World Cup in South Africa. 111-hres-958 C000059 Rep. Calvert, Ken [R-CA-44] R CA 2009-12-16 0
111-hres-958,L000480 Congratulating the United States Men's National Soccer Team for securing a berth at the 2010 FIFA World Cup in South Africa. 111-hres-958 L000480 Rep. Lowey, Nita M. [D-NY-18] D NY 2009-12-14 0
111-hres-958,G000309 Congratulating the United States Men's National Soccer Team for securing a berth at the 2010 FIFA World Cup in South Africa. 111-hres-958 G000309 Rep. Gordon, Bart [D-TN-6] D TN 2009-12-14 0
111-hres-958,P000587 Congratulating the United States Men's National Soccer Team for securing a berth at the 2010 FIFA World Cup in South Africa. 111-hres-958 P000587 Rep. Pence, Mike [R-IN-6] R IN 2009-12-14 0
111-hres-958,S000749 Congratulating the United States Men's National Soccer Team for securing a berth at the 2010 FIFA World Cup in South Africa. 111-hres-958 S000749 Rep. Spratt, John M., Jr. [D-SC-5] D SC 2009-12-11 0
111-hres-958,M000312 Congratulating the United States Men's National Soccer Team for securing a berth at the 2010 FIFA World Cup in South Africa. 111-hres-958 M000312 Rep. McGovern, James P. [D-MA-3] D MA 2009-12-10 0
111-hres-958,D000482 Congratulating the United States Men's National Soccer Team for securing a berth at the 2010 FIFA World Cup in South Africa. 111-hres-958 D000482 Rep. Doyle, Michael F. [D-PA-14] D PA 2009-12-10 0
111-hres-958,C001079 Congratulating the United States Men's National Soccer Team for securing a berth at the 2010 FIFA World Cup in South Africa. 111-hres-958 C001079 Rep. Cao, Anh "Joseph" [R-LA-2] R LA 2009-12-10 0
111-hres-958,R000462 Congratulating the United States Men's National Soccer Team for securing a berth at the 2010 FIFA World Cup in South Africa. 111-hres-958 R000462 Rep. Rothman, Steven R. [D-NJ-9] D NJ 2009-12-10 0
111-hres-958,M000725 Congratulating the United States Men's National Soccer Team for securing a berth at the 2010 FIFA World Cup in South Africa. 111-hres-958 M000725 Rep. Miller, George [D-CA-7] D CA 2009-12-08 1
111-hres-958,B001228 Congratulating the United States Men's National Soccer Team for securing a berth at the 2010 FIFA World Cup in South Africa. 111-hres-958 B001228 Rep. Bono Mack, Mary [R-CA-45] R CA 2009-12-08 1
111-hres-958,R000578 Congratulating the United States Men's National Soccer Team for securing a berth at the 2010 FIFA World Cup in South Africa. 111-hres-958 R000578 Rep. Reichert, David G. [R-WA-8] R WA 2009-12-08 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);