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

24 rows where bill_id = "104-hres-45" 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 15
  • 1 9
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
104-hres-45,S000248 To express the sense of the House regarding calculation of the Consumer Price Index. 104-hres-45 S000248 Rep. Serrano, Jose E. [D-NY-16] D NY 1995-05-02 0
104-hres-45,W000738 To express the sense of the House regarding calculation of the Consumer Price Index. 104-hres-45 W000738 Rep. Woolsey, Lynn C. [D-CA-6] D CA 1995-03-02 0
104-hres-45,L000342 To express the sense of the House regarding calculation of the Consumer Price Index. 104-hres-45 L000342 Rep. Lipinski, William O. [D-IL-3] D IL 1995-03-02 0
104-hres-45,J000177 To express the sense of the House regarding calculation of the Consumer Price Index. 104-hres-45 J000177 Rep. Johnson, Tim [D-SD-At Large] D SD 1995-03-02 0
104-hres-45,D000191 To express the sense of the House regarding calculation of the Consumer Price Index. 104-hres-45 D000191 Rep. DeFazio, Peter A. [D-OR-4] D OR 1995-03-02 0
104-hres-45,S000810 To express the sense of the House regarding calculation of the Consumer Price Index. 104-hres-45 S000810 Rep. Stark, Fortney Pete [D-CA-13] D CA 1995-02-21 0
104-hres-45,E000215 To express the sense of the House regarding calculation of the Consumer Price Index. 104-hres-45 E000215 Rep. Eshoo, Anna G. [D-CA-14] D CA 1995-02-21 0
104-hres-45,D000275 To express the sense of the House regarding calculation of the Consumer Price Index. 104-hres-45 D000275 Rep. Deutsch, Peter [D-FL-20] D FL 1995-02-21 0
104-hres-45,R000281 To express the sense of the House regarding calculation of the Consumer Price Index. 104-hres-45 R000281 Rep. Rivers, Lynn N. [D-MI-13] D MI 1995-02-21 0
104-hres-45,W000520 To express the sense of the House regarding calculation of the Consumer Price Index. 104-hres-45 W000520 Rep. Williams, Pat [D-MT-At Large] D MT 1995-02-21 0
104-hres-45,R000011 To express the sense of the House regarding calculation of the Consumer Price Index. 104-hres-45 R000011 Rep. Rahall, Nick J., II [D-WV-3] D WV 1995-02-21 0
104-hres-45,D000222 To express the sense of the House regarding calculation of the Consumer Price Index. 104-hres-45 D000222 Rep. Dellums, Ronald V. [D-CA-9] D CA 1995-02-21 0
104-hres-45,S000148 To express the sense of the House regarding calculation of the Consumer Price Index. 104-hres-45 S000148 Rep. Schumer, Charles E. [D-NY-9] D NY 1995-02-03 0
104-hres-45,G000410 To express the sense of the House regarding calculation of the Consumer Price Index. 104-hres-45 G000410 Rep. Green, Gene [D-TX-29] D TX 1995-02-03 0
104-hres-45,W000779 To express the sense of the House regarding calculation of the Consumer Price Index. 104-hres-45 W000779 Rep. Wyden, Ron [D-OR-3] D OR 1995-02-03 0
104-hres-45,B000644 To express the sense of the House regarding calculation of the Consumer Price Index. 104-hres-45 B000644 Rep. Borski, Robert A. [D-PA-3] D PA 1995-01-26 1
104-hres-45,D000482 To express the sense of the House regarding calculation of the Consumer Price Index. 104-hres-45 D000482 Rep. Doyle, Michael F. [D-PA-18] D PA 1995-01-26 1
104-hres-45,M000466 To express the sense of the House regarding calculation of the Consumer Price Index. 104-hres-45 M000466 Rep. McHale, Paul [D-PA-15] D PA 1995-01-26 1
104-hres-45,E000179 To express the sense of the House regarding calculation of the Consumer Price Index. 104-hres-45 E000179 Rep. Engel, Eliot L. [D-NY-17] D NY 1995-01-26 1
104-hres-45,D000216 To express the sense of the House regarding calculation of the Consumer Price Index. 104-hres-45 D000216 Rep. DeLauro, Rosa L. [D-CT-3] D CT 1995-01-26 1
104-hres-45,H000627 To express the sense of the House regarding calculation of the Consumer Price Index. 104-hres-45 H000627 Rep. Hinchey, Maurice D. [D-NY-26] D NY 1995-01-26 1
104-hres-45,B000287 To express the sense of the House regarding calculation of the Consumer Price Index. 104-hres-45 B000287 Rep. Becerra, Xavier [D-CA-30] D CA 1995-01-26 1
104-hres-45,M000404 To express the sense of the House regarding calculation of the Consumer Price Index. 104-hres-45 M000404 Rep. McDermott, Jim [D-WA-7] D WA 1995-01-26 1
104-hres-45,L000480 To express the sense of the House regarding calculation of the Consumer Price Index. 104-hres-45 L000480 Rep. Lowey, Nita M. [D-NY-18] D NY 1995-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);