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

22 rows where bill_id = "112-hr-5871" 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 14
  • 1 8
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
112-hr-5871,G000569 A Plus Act 112-hr-5871 G000569 Rep. Grimm, Michael G. [R-NY-13] R NY 2012-12-13 0
112-hr-5871,E000288 A Plus Act 112-hr-5871 E000288 Rep. Ellison, Keith [D-MN-5] D MN 2012-11-30 0
112-hr-5871,N000147 A Plus Act 112-hr-5871 N000147 Del. Norton, Eleanor Holmes [D-DC-At Large] D DC 2012-11-15 0
112-hr-5871,D000598 A Plus Act 112-hr-5871 D000598 Rep. Davis, Susan A. [D-CA-53] D CA 2012-11-15 0
112-hr-5871,L000560 A Plus Act 112-hr-5871 L000560 Rep. Larsen, Rick [D-WA-2] D WA 2012-11-15 0
112-hr-5871,C001072 A Plus Act 112-hr-5871 C001072 Rep. Carson, Andre [D-IN-7] D IN 2012-11-15 0
112-hr-5871,C001049 A Plus Act 112-hr-5871 C001049 Rep. Clay, Wm. Lacy [D-MO-1] D MO 2012-11-15 0
112-hr-5871,M000087 A Plus Act 112-hr-5871 M000087 Rep. Maloney, Carolyn B. [D-NY-14] D NY 2012-11-15 0
112-hr-5871,S001150 A Plus Act 112-hr-5871 S001150 Rep. Schiff, Adam B. [D-CA-29] D CA 2012-07-19 0
112-hr-5871,P000598 A Plus Act 112-hr-5871 P000598 Rep. Polis, Jared [D-CO-2] D CO 2012-07-09 0
112-hr-5871,Y000064 A Plus Act 112-hr-5871 Y000064 Rep. Young, Todd [R-IN-9] R IN 2012-07-09 0
112-hr-5871,R000053 A Plus Act 112-hr-5871 R000053 Rep. Rangel, Charles B. [D-NY-15] D NY 2012-06-21 0
112-hr-5871,W000808 A Plus Act 112-hr-5871 W000808 Rep. Wilson, Frederica S. [D-FL-17] D FL 2012-06-21 0
112-hr-5871,A000210 A Plus Act 112-hr-5871 A000210 Rep. Andrews, Robert E. [D-NJ-1] D NJ 2012-06-07 0
112-hr-5871,M001179 A Plus Act 112-hr-5871 M001179 Rep. Marino, Tom [R-PA-10] R PA 2012-05-31 1
112-hr-5871,B001256 A Plus Act 112-hr-5871 B001256 Rep. Bachmann, Michele [R-MN-6] R MN 2012-05-31 1
112-hr-5871,M000404 A Plus Act 112-hr-5871 M000404 Rep. McDermott, Jim [D-WA-7] D WA 2012-05-31 1
112-hr-5871,H000324 A Plus Act 112-hr-5871 H000324 Rep. Hastings, Alcee L. [D-FL-23] D FL 2012-05-31 1
112-hr-5871,C001067 A Plus Act 112-hr-5871 C001067 Rep. Clarke, Yvette D. [D-NY-11] D NY 2012-05-31 1
112-hr-5871,S000810 A Plus Act 112-hr-5871 S000810 Rep. Stark, Fortney Pete [D-CA-13] D CA 2012-05-31 1
112-hr-5871,C001084 A Plus Act 112-hr-5871 C001084 Rep. Cicilline, David N. [D-RI-1] D RI 2012-05-31 1
112-hr-5871,L000559 A Plus Act 112-hr-5871 L000559 Rep. Langevin, James R. [D-RI-2] D RI 2012-05-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);