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

15 rows where bill_id = "112-hres-64" 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 13
  • 0 2
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
112-hres-64,H001034 Honoring the life and work of Robert Sargent Shriver. 112-hres-64 H001034 Rep. Honda, Michael M. [D-CA-15] D CA 2011-02-28 0
112-hres-64,P000265 Honoring the life and work of Robert Sargent Shriver. 112-hres-64 P000265 Rep. Petri, Thomas E. [R-WI-6] R WI 2011-02-28 0
112-hres-64,F000030 Honoring the life and work of Robert Sargent Shriver. 112-hres-64 F000030 Rep. Farr, Sam [D-CA-17] D CA 2011-01-26 1
112-hres-64,M000725 Honoring the life and work of Robert Sargent Shriver. 112-hres-64 M000725 Rep. Miller, George [D-CA-7] D CA 2011-01-26 1
112-hres-64,L000263 Honoring the life and work of Robert Sargent Shriver. 112-hres-64 L000263 Rep. Levin, Sander M. [D-MI-12] D MI 2011-01-26 1
112-hres-64,B001245 Honoring the life and work of Robert Sargent Shriver. 112-hres-64 B001245 Del. Bordallo, Madeleine Z. [D-GU-At Large] D GU 2011-01-26 1
112-hres-64,L000559 Honoring the life and work of Robert Sargent Shriver. 112-hres-64 L000559 Rep. Langevin, James R. [D-RI-2] D RI 2011-01-26 1
112-hres-64,M001143 Honoring the life and work of Robert Sargent Shriver. 112-hres-64 M001143 Rep. McCollum, Betty [D-MN-4] D MN 2011-01-26 1
112-hres-64,M000133 Honoring the life and work of Robert Sargent Shriver. 112-hres-64 M000133 Rep. Markey, Edward J. [D-MA-7] D MA 2011-01-26 1
112-hres-64,M000933 Honoring the life and work of Robert Sargent Shriver. 112-hres-64 M000933 Rep. Moran, James P. [D-VA-8] D VA 2011-01-26 1
112-hres-64,P000523 Honoring the life and work of Robert Sargent Shriver. 112-hres-64 P000523 Rep. Price, David E. [D-NC-4] D NC 2011-01-26 1
112-hres-64,S000248 Honoring the life and work of Robert Sargent Shriver. 112-hres-64 S000248 Rep. Serrano, Jose E. [D-NY-16] D NY 2011-01-26 1
112-hres-64,B000410 Honoring the life and work of Robert Sargent Shriver. 112-hres-64 B000410 Rep. Berman, Howard L. [D-CA-28] D CA 2011-01-26 1
112-hres-64,V000128 Honoring the life and work of Robert Sargent Shriver. 112-hres-64 V000128 Rep. Van Hollen, Chris [D-MD-8] D MD 2011-01-26 1
112-hres-64,M000312 Honoring the life and work of Robert Sargent Shriver. 112-hres-64 M000312 Rep. McGovern, James P. [D-MA-3] D MA 2011-01-26 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);