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

16 rows where bill_id = "101-hr-5671" 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 15
  • 1 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
101-hr-5671,L000045 Telephone Consumer Assistance Act 101-hr-5671 L000045 Rep. Lancaster, H. Martin [D-NC-3] D NC 1990-10-24 0
101-hr-5671,F000339 Telephone Consumer Assistance Act 101-hr-5671 F000339 Rep. Frank, Barney [D-MA-4] D MA 1990-10-24 0
101-hr-5671,W000779 Telephone Consumer Assistance Act 101-hr-5671 W000779 Rep. Wyden, Ron [D-OR-3] D OR 1990-10-17 0
101-hr-5671,R000072 Telephone Consumer Assistance Act 101-hr-5671 R000072 Rep. Ravenel, Arthur, Jr. [R-SC-1] R SC 1990-10-17 0
101-hr-5671,D000593 Telephone Consumer Assistance Act 101-hr-5671 D000593 Rep. Dyson, Roy [D-MD-1] D MD 1990-10-16 0
101-hr-5671,F000392 Telephone Consumer Assistance Act 101-hr-5671 F000392 Rep. Frost, Martin [D-TX-24] D TX 1990-10-07 0
101-hr-5671,S000463 Telephone Consumer Assistance Act 101-hr-5671 S000463 Rep. Skeen, Joe [R-NM-2] R NM 1990-10-07 0
101-hr-5671,J000163 Telephone Consumer Assistance Act 101-hr-5671 J000163 Rep. Johnson, Nancy L. [R-CT-6] R CT 1990-10-07 0
101-hr-5671,K000009 Telephone Consumer Assistance Act 101-hr-5671 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 1990-10-01 0
101-hr-5671,P000112 Telephone Consumer Assistance Act 101-hr-5671 P000112 Rep. Patterson, Elizabeth [D-SC-4] D SC 1990-10-01 0
101-hr-5671,D000586 Telephone Consumer Assistance Act 101-hr-5671 D000586 Rep. Dwyer, Bernard J. [D-NJ-6] D NJ 1990-10-01 0
101-hr-5671,T000034 Telephone Consumer Assistance Act 101-hr-5671 T000034 Rep. Tallon, Robert M. (Robin) [D-SC-6] D SC 1990-10-01 0
101-hr-5671,S000810 Telephone Consumer Assistance Act 101-hr-5671 S000810 Rep. Stark, Fortney Pete [D-CA-9] D CA 1990-09-26 0
101-hr-5671,M001057 Telephone Consumer Assistance Act 101-hr-5671 M001057 Rep. Mrazek, Robert J. [D-NY-3] D NY 1990-09-26 0
101-hr-5671,O000069 Telephone Consumer Assistance Act 101-hr-5671 O000069 Rep. Olin, James R. [D-VA-6] D VA 1990-09-26 0
101-hr-5671,S000477 Telephone Consumer Assistance Act 101-hr-5671 S000477 Rep. Slattery, Jim [D-KS-2] D KS 1990-09-19 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);