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 = "116-hr-8003" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: state, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

  • 0 14
  • 1 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
116-hr-8003,M000687 Helping HOMES Act of 2020 116-hr-8003 M000687 Rep. Mfume, Kweisi [D-MD-7] D MD 2020-12-21 0
116-hr-8003,D000482 Helping HOMES Act of 2020 116-hr-8003 D000482 Rep. Doyle, Michael F. [D-PA-18] D PA 2020-09-29 0
116-hr-8003,C001080 Helping HOMES Act of 2020 116-hr-8003 C001080 Rep. Chu, Judy [D-CA-27] D CA 2020-09-21 0
116-hr-8003,L000586 Helping HOMES Act of 2020 116-hr-8003 L000586 Rep. Lawson, Al, Jr. [D-FL-5] D FL 2020-09-08 0
116-hr-8003,W000826 Helping HOMES Act of 2020 116-hr-8003 W000826 Rep. Wild, Susan [D-PA-7] D PA 2020-09-01 0
116-hr-8003,B001304 Helping HOMES Act of 2020 116-hr-8003 B001304 Rep. Brown, Anthony G. [D-MD-4] D MD 2020-09-01 0
116-hr-8003,F000455 Helping HOMES Act of 2020 116-hr-8003 F000455 Rep. Fudge, Marcia L. [D-OH-11] D OH 2020-09-01 0
116-hr-8003,R000577 Helping HOMES Act of 2020 116-hr-8003 R000577 Rep. Ryan, Tim [D-OH-13] D OH 2020-09-01 0
116-hr-8003,H001081 Helping HOMES Act of 2020 116-hr-8003 H001081 Rep. Hayes, Jahana [D-CT-5] D CT 2020-09-01 0
116-hr-8003,C001072 Helping HOMES Act of 2020 116-hr-8003 C001072 Rep. Carson, Andre [D-IN-7] D IN 2020-08-22 0
116-hr-8003,N000147 Helping HOMES Act of 2020 116-hr-8003 N000147 Del. Norton, Eleanor Holmes [D-DC-At Large] D DC 2020-08-22 0
116-hr-8003,C000754 Helping HOMES Act of 2020 116-hr-8003 C000754 Rep. Cooper, Jim [D-TN-5] D TN 2020-08-22 0
116-hr-8003,L000551 Helping HOMES Act of 2020 116-hr-8003 L000551 Rep. Lee, Barbara [D-CA-13] D CA 2020-08-22 0
116-hr-8003,D000631 Helping HOMES Act of 2020 116-hr-8003 D000631 Rep. Dean, Madeleine [D-PA-4] D PA 2020-08-14 0
116-hr-8003,C001049 Helping HOMES Act of 2020 116-hr-8003 C001049 Rep. Clay, Wm. Lacy [D-MO-1] D MO 2020-08-11 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);