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

37 rows where bill_id = "101-hr-4733" 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 35
  • 1 2
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
101-hr-4733,S000673 Young American Workers' Bill of Rights 101-hr-4733 S000673 Rep. Solarz, Stephen J. [D-NY-13] D NY 1990-08-03 0
101-hr-4733,W000258 Young American Workers' Bill of Rights 101-hr-4733 W000258 Rep. Weiss, Ted [D-NY-17] D NY 1990-08-03 0
101-hr-4733,R000383 Young American Workers' Bill of Rights 101-hr-4733 R000383 Rep. Roe, Robert A. [D-NJ-8] D NJ 1990-08-03 0
101-hr-4733,G000105 Young American Workers' Bill of Rights 101-hr-4733 G000105 Rep. Gaydos, Joseph M. [D-PA-20] D PA 1990-08-03 0
101-hr-4733,P000197 Young American Workers' Bill of Rights 101-hr-4733 P000197 Rep. Pelosi, Nancy [D-CA-5] D CA 1990-07-26 0
101-hr-4733,F000235 Young American Workers' Bill of Rights 101-hr-4733 F000235 Rep. Foglietta, Thomas M. [D-PA-1] D PA 1990-07-26 0
101-hr-4733,M000992 Young American Workers' Bill of Rights 101-hr-4733 M000992 Rep. Morrison, Bruce A. [D-CT-3] D CT 1990-07-26 0
101-hr-4733,S000810 Young American Workers' Bill of Rights 101-hr-4733 S000810 Rep. Stark, Fortney Pete [D-CA-9] D CA 1990-07-26 0
101-hr-4733,M000458 Young American Workers' Bill of Rights 101-hr-4733 M000458 Rep. McGrath, Raymond J. [R-NY-5] R NY 1990-07-26 0
101-hr-4733,S000005 Young American Workers' Bill of Rights 101-hr-4733 S000005 Rep. Sabo, Martin Olav [D-MN-5] D MN 1990-07-26 0
101-hr-4733,M000590 Young American Workers' Bill of Rights 101-hr-4733 M000590 Rep. McNulty, Michael R. [D-NY-23] D NY 1990-07-26 0
101-hr-4733,K000009 Young American Workers' Bill of Rights 101-hr-4733 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 1990-07-26 0
101-hr-4733,P000215 Young American Workers' Bill of Rights 101-hr-4733 P000215 Rep. Penny, Timothy J. [D-MN-1] D MN 1990-07-26 0
101-hr-4733,C000634 Young American Workers' Bill of Rights 101-hr-4733 C000634 Rep. Collins, Cardiss [D-IL-7] D IL 1990-07-26 0
101-hr-4733,M000725 Young American Workers' Bill of Rights 101-hr-4733 M000725 Rep. Miller, George [D-CA-7] D CA 1990-07-26 0
101-hr-4733,H000074 Young American Workers' Bill of Rights 101-hr-4733 H000074 Rep. Hall, Tony P. [D-OH-3] D OH 1990-07-26 0
101-hr-4733,B000410 Young American Workers' Bill of Rights 101-hr-4733 B000410 Rep. Berman, Howard L. [D-CA-26] D CA 1990-07-26 0
101-hr-4733,D000592 Young American Workers' Bill of Rights 101-hr-4733 D000592 Rep. Dymally, Mervyn M. [D-CA-31] D CA 1990-07-26 0
101-hr-4733,D000222 Young American Workers' Bill of Rights 101-hr-4733 D000222 Rep. Dellums, Ronald V. [D-CA-8] D CA 1990-07-26 0
101-hr-4733,B000648 Young American Workers' Bill of Rights 101-hr-4733 B000648 Rep. Bosco, Douglas H. [D-CA-1] D CA 1990-07-26 0
101-hr-4733,B000644 Young American Workers' Bill of Rights 101-hr-4733 B000644 Rep. Borski, Robert A. [D-PA-3] D PA 1990-07-26 0
101-hr-4733,F000261 Young American Workers' Bill of Rights 101-hr-4733 F000261 Rep. Ford, Harold E. [D-TN-9] D TN 1990-07-26 0
101-hr-4733,O000006 Young American Workers' Bill of Rights 101-hr-4733 O000006 Rep. Oberstar, James L. [D-MN-8] D MN 1990-07-26 0
101-hr-4733,B000711 Young American Workers' Bill of Rights 101-hr-4733 B000711 Rep. Boxer, Barbara [D-CA-6] D CA 1990-07-26 0
101-hr-4733,H000547 Young American Workers' Bill of Rights 101-hr-4733 H000547 Rep. Hertel, Dennis M. [D-MI-14] D MI 1990-07-26 0
101-hr-4733,K000319 Young American Workers' Bill of Rights 101-hr-4733 K000319 Rep. Kostmayer, Peter H. [D-PA-8] D PA 1990-07-26 0
101-hr-4733,G000272 Young American Workers' Bill of Rights 101-hr-4733 G000272 Rep. Gonzalez, Henry B. [D-TX-20] D TX 1990-07-26 0
101-hr-4733,F000046 Young American Workers' Bill of Rights 101-hr-4733 F000046 Del. Fauntroy, Walter E. [D-DC-At Large] D DC 1990-07-26 0
101-hr-4733,D000209 Young American Workers' Bill of Rights 101-hr-4733 D000209 Del. de Lugo, Ron [D-VI-At Large] D VI 1990-07-26 0
101-hr-4733,M000249 Young American Workers' Bill of Rights 101-hr-4733 M000249 Rep. Matsui, Robert T. [D-CA-3] D CA 1990-07-26 0
101-hr-4733,D000586 Young American Workers' Bill of Rights 101-hr-4733 D000586 Rep. Dwyer, Bernard J. [D-NJ-6] D NJ 1990-07-26 0
101-hr-4733,L000287 Young American Workers' Bill of Rights 101-hr-4733 L000287 Rep. Lewis, John [D-GA-5] D GA 1990-07-26 0
101-hr-4733,J000187 Young American Workers' Bill of Rights 101-hr-4733 J000187 Rep. Johnston, Harry [D-FL-14] D FL 1990-07-26 0
101-hr-4733,F000392 Young American Workers' Bill of Rights 101-hr-4733 F000392 Rep. Frost, Martin [D-TX-24] D TX 1990-07-26 0
101-hr-4733,F000208 Young American Workers' Bill of Rights 101-hr-4733 F000208 Rep. Flippo, Ronnie G. [D-AL-5] D AL 1990-07-26 0
101-hr-4733,S000148 Young American Workers' Bill of Rights 101-hr-4733 S000148 Rep. Schumer, Charles E. [D-NY-10] D NY 1990-05-03 1
101-hr-4733,L000090 Young American Workers' Bill of Rights 101-hr-4733 L000090 Rep. Lantos, Tom [D-CA-11] D CA 1990-05-03 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);