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

50 rows where bill_id = "99-hr-4128" 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

  • 1 27
  • 0 23
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
99-hr-4128,O000107 Bankruptcy Judgeship Act of 1986 99-hr-4128 O000107 Rep. Ortiz, Solomon P. [D-TX-27] D TX 1986-07-24 0
99-hr-4128,R000146 Bankruptcy Judgeship Act of 1986 99-hr-4128 R000146 Rep. Reid, Harry [D-NV-1] D NV 1986-03-20 0
99-hr-4128,M000249 Bankruptcy Judgeship Act of 1986 99-hr-4128 M000249 Rep. Matsui, Robert T. [D-CA-3] D CA 1986-03-20 0
99-hr-4128,W000044 Bankruptcy Judgeship Act of 1986 99-hr-4128 W000044 Rep. Walgren, Doug [D-PA-18] D PA 1986-03-20 0
99-hr-4128,A000103 Bankruptcy Judgeship Act of 1986 99-hr-4128 A000103 Rep. Alexander, Bill [D-AR-1] D AR 1986-03-06 0
99-hr-4128,L000381 Bankruptcy Judgeship Act of 1986 99-hr-4128 L000381 Rep. Lloyd, Marilyn [D-TN-3] D TN 1986-03-06 0
99-hr-4128,B000298 Bankruptcy Judgeship Act of 1986 99-hr-4128 B000298 Rep. Bedell, Berkley W. [D-IA-6] D IA 1986-02-27 0
99-hr-4128,S000586 Bankruptcy Judgeship Act of 1986 99-hr-4128 S000586 Rep. Smith, Lawrence [D-FL-16] D FL 1986-02-27 0
99-hr-4128,S000622 Bankruptcy Judgeship Act of 1986 99-hr-4128 S000622 Rep. Smith, Virginia [R-NE-3] R NE 1986-02-27 0
99-hr-4128,T000326 Bankruptcy Judgeship Act of 1986 99-hr-4128 T000326 Rep. Towns, Edolphus [D-NY-11] D NY 1986-02-27 0
99-hr-4128,R000053 Bankruptcy Judgeship Act of 1986 99-hr-4128 R000053 Rep. Rangel, Charles B. [D-NY-16] D NY 1986-02-27 0
99-hr-4128,T000316 Bankruptcy Judgeship Act of 1986 99-hr-4128 T000316 Rep. Torres, Esteban Edward [D-CA-34] D CA 1986-02-27 0
99-hr-4128,M000794 Bankruptcy Judgeship Act of 1986 99-hr-4128 M000794 Rep. Mineta, Norman Y. [D-CA-13] D CA 1986-02-27 0
99-hr-4128,M001057 Bankruptcy Judgeship Act of 1986 99-hr-4128 M001057 Rep. Mrazek, Robert J. [D-NY-3] D NY 1986-02-27 0
99-hr-4128,G000511 Bankruptcy Judgeship Act of 1986 99-hr-4128 G000511 Rep. Guarini, Frank J. [D-NJ-14] D NJ 1986-02-19 0
99-hr-4128,H000840 Bankruptcy Judgeship Act of 1986 99-hr-4128 H000840 Rep. Howard, James J. [D-NJ-3] D NJ 1986-02-19 0
99-hr-4128,F000046 Bankruptcy Judgeship Act of 1986 99-hr-4128 F000046 Del. Fauntroy, Walter E. [D-DC-At Large] D DC 1986-02-19 0
99-hr-4128,M000206 Bankruptcy Judgeship Act of 1986 99-hr-4128 M000206 Rep. Martinez, Matthew G. [D-CA-30] D CA 1986-02-19 0
99-hr-4128,A000209 Bankruptcy Judgeship Act of 1986 99-hr-4128 A000209 Rep. Andrews, Michael [D-TX-25] D TX 1986-02-19 0
99-hr-4128,B001158 Bankruptcy Judgeship Act of 1986 99-hr-4128 B001158 Rep. Burton, Sala [D-CA-5] D CA 1986-02-19 0
99-hr-4128,M000999 Bankruptcy Judgeship Act of 1986 99-hr-4128 M000999 Rep. Morrison, Sid [R-WA-4] R WA 1986-02-19 0
99-hr-4128,F000339 Bankruptcy Judgeship Act of 1986 99-hr-4128 F000339 Rep. Frank, Barney [D-MA-4] D MA 1986-02-19 0
99-hr-4128,S000148 Bankruptcy Judgeship Act of 1986 99-hr-4128 S000148 Rep. Schumer, Charles E. [D-NY-10] D NY 1986-02-19 0
99-hr-4128,B000880 Bankruptcy Judgeship Act of 1986 99-hr-4128 B000880 Rep. Brooks, Jack B. [D-TX-9] D TX 1986-02-05 1
99-hr-4128,E000064 Bankruptcy Judgeship Act of 1986 99-hr-4128 E000064 Rep. Edwards, Don [D-CA-10] D CA 1986-02-05 1
99-hr-4128,H000930 Bankruptcy Judgeship Act of 1986 99-hr-4128 H000930 Rep. Hughes, William J. [D-NJ-2] D NJ 1986-02-05 1
99-hr-4128,S001139 Bankruptcy Judgeship Act of 1986 99-hr-4128 S001139 Rep. Synar, Mike [D-OK-2] D OK 1986-02-05 1
99-hr-4128,B000410 Bankruptcy Judgeship Act of 1986 99-hr-4128 B000410 Rep. Berman, Howard L. [D-CA-26] D CA 1986-02-05 1
99-hr-4128,D000203 Bankruptcy Judgeship Act of 1986 99-hr-4128 D000203 Rep. de la Garza, E. [D-TX-15] D TX 1986-02-05 1
99-hr-4128,F000239 Bankruptcy Judgeship Act of 1986 99-hr-4128 F000239 Rep. Foley, Thomas S. [D-WA-5] D WA 1986-02-05 1
99-hr-4128,S000596 Bankruptcy Judgeship Act of 1986 99-hr-4128 S000596 Rep. Smith, Neal Edward [D-IA-4] D IA 1986-02-05 1
99-hr-4128,G000153 Bankruptcy Judgeship Act of 1986 99-hr-4128 G000153 Rep. Gibbons, Sam [D-FL-7] D FL 1986-02-05 1
99-hr-4128,J000232 Bankruptcy Judgeship Act of 1986 99-hr-4128 J000232 Rep. Jones, James R. [D-OK-1] D OK 1986-02-05 1
99-hr-4128,S000785 Bankruptcy Judgeship Act of 1986 99-hr-4128 S000785 Rep. Stallings, Richard H. [D-ID-2] D ID 1986-02-05 1
99-hr-4128,C000846 Bankruptcy Judgeship Act of 1986 99-hr-4128 C000846 Rep. Coyne, William J. [D-PA-14] D PA 1986-02-05 1
99-hr-4128,M001088 Bankruptcy Judgeship Act of 1986 99-hr-4128 M001088 Rep. Murphy, Austin J. [D-PA-22] D PA 1986-02-05 1
99-hr-4128,M000826 Bankruptcy Judgeship Act of 1986 99-hr-4128 M000826 Rep. Mitchell, Parren J. [D-MD-7] D MD 1986-02-05 1
99-hr-4128,D000586 Bankruptcy Judgeship Act of 1986 99-hr-4128 D000586 Rep. Dwyer, Bernard J. [D-NJ-6] D NJ 1986-02-05 1
99-hr-4128,T000317 Bankruptcy Judgeship Act of 1986 99-hr-4128 T000317 Rep. Torricelli, Robert G. [D-NJ-9] D NJ 1986-02-05 1
99-hr-4128,B001172 Bankruptcy Judgeship Act of 1986 99-hr-4128 B001172 Rep. Bustamante, Albert G. [D-TX-23] D TX 1986-02-05 1
99-hr-4128,M000702 Bankruptcy Judgeship Act of 1986 99-hr-4128 M000702 Rep. Mikulski, Barbara A. [D-MD-3] D MD 1986-02-05 1
99-hr-4128,P000229 Bankruptcy Judgeship Act of 1986 99-hr-4128 P000229 Rep. Perkins, Carl C. [D-KY-7] D KY 1986-02-05 1
99-hr-4128,S000749 Bankruptcy Judgeship Act of 1986 99-hr-4128 S000749 Rep. Spratt, John M., Jr. [D-SC-5] D SC 1986-02-05 1
99-hr-4128,D000267 Bankruptcy Judgeship Act of 1986 99-hr-4128 D000267 Rep. Derrick, Butler C. [D-SC-3] D SC 1986-02-05 1
99-hr-4128,E000250 Bankruptcy Judgeship Act of 1986 99-hr-4128 E000250 Rep. Evans, Lane [D-IL-17] D IL 1986-02-05 1
99-hr-4128,R000384 Bankruptcy Judgeship Act of 1986 99-hr-4128 R000384 Rep. Roemer, Buddy [D-LA-4] D LA 1986-02-05 1
99-hr-4128,H000388 Bankruptcy Judgeship Act of 1986 99-hr-4128 H000388 Rep. Hayes, Charles A. [D-IL-1] D IL 1986-02-05 1
99-hr-4128,B000971 Bankruptcy Judgeship Act of 1986 99-hr-4128 B000971 Rep. Bruce, Terry L. [D-IL-19] D IL 1986-02-05 1
99-hr-4128,C000312 Bankruptcy Judgeship Act of 1986 99-hr-4128 C000312 Rep. Chapman, Jim [D-TX-1] D TX 1986-02-05 1
99-hr-4128,E000259 Bankruptcy Judgeship Act of 1986 99-hr-4128 E000259 Rep. Evans, Cooper [R-IA-3] R IA 1986-02-05 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);