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

17 rows where bill_id = "103-hres-557" 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 13
  • 1 4
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
103-hres-557,M000404 Commending the Police Athletic League. 103-hres-557 M000404 Rep. McDermott, Jim [D-WA-7] D WA 1994-10-07 0
103-hres-557,J000126 Commending the Police Athletic League. 103-hres-557 J000126 Rep. Johnson, Eddie Bernice [D-TX-30] D TX 1994-10-07 0
103-hres-557,L000342 Commending the Police Athletic League. 103-hres-557 L000342 Rep. Lipinski, William O. [D-IL-3] D IL 1994-10-07 0
103-hres-557,B000177 Commending the Police Athletic League. 103-hres-557 B000177 Rep. Barrett, Thomas M. [D-WI-5] D WI 1994-10-07 0
103-hres-557,A000022 Commending the Police Athletic League. 103-hres-557 A000022 Rep. Ackerman, Gary L. [D-NY-5] D NY 1994-10-07 0
103-hres-557,B000619 Commending the Police Athletic League. 103-hres-557 B000619 Rep. Bonior, David E. [D-MI-10] D MI 1994-10-07 0
103-hres-557,C000754 Commending the Police Athletic League. 103-hres-557 C000754 Rep. Cooper, Jim [D-TN-4] D TN 1994-10-07 0
103-hres-557,F000184 Commending the Police Athletic League. 103-hres-557 F000184 Rep. Flake, Floyd H. [D-NY-6] D NY 1994-10-07 0
103-hres-557,F000328 Commending the Police Athletic League. 103-hres-557 F000328 Rep. Fowler, Tillie [R-FL-4] R FL 1994-10-07 0
103-hres-557,S000480 Commending the Police Athletic League. 103-hres-557 S000480 Rep. Slaughter, Louise McIntosh [D-NY-28] D NY 1994-10-07 0
103-hres-557,W000207 Commending the Police Athletic League. 103-hres-557 W000207 Rep. Watt, Melvin L. [D-NC-12] D NC 1994-10-07 0
103-hres-557,B000318 Commending the Police Athletic League. 103-hres-557 B000318 Rep. Beilenson, Anthony C. [D-CA-24] D CA 1994-10-07 0
103-hres-557,D000216 Commending the Police Athletic League. 103-hres-557 D000216 Rep. DeLauro, Rosa L. [D-CT-3] D CT 1994-10-07 0
103-hres-557,M000206 Commending the Police Athletic League. 103-hres-557 M000206 Rep. Martinez, Matthew G. [D-CA-31] D CA 1994-09-30 1
103-hres-557,S000148 Commending the Police Athletic League. 103-hres-557 S000148 Rep. Schumer, Charles E. [D-NY-9] D NY 1994-09-30 1
103-hres-557,S000822 Commending the Police Athletic League. 103-hres-557 S000822 Rep. Stearns, Cliff [R-FL-6] R FL 1994-09-30 1
103-hres-557,W000177 Commending the Police Athletic League. 103-hres-557 W000177 Rep. Washington, Craig A. [D-TX-18] D TX 1994-09-30 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);