home / openregs

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

66 rows where bill_id = "100-hr-4848" 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 35
  • 0 31
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
100-hr-4848,K000172 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 K000172 Rep. Kildee, Dale E. [D-MI-7] D MI 1988-07-07 0
100-hr-4848,C000312 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 C000312 Rep. Chapman, Jim [D-TX-1] D TX 1988-07-07 0
100-hr-4848,W000654 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 W000654 Rep. Wise, Robert E., Jr. [D-WV-3] D WV 1988-07-07 0
100-hr-4848,S000785 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 S000785 Rep. Stallings, Richard H. [D-ID-2] D ID 1988-07-07 0
100-hr-4848,P000328 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 P000328 Rep. Pickle, J. J. [D-TX-10] D TX 1988-06-22 0
100-hr-4848,V000027 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 V000027 Rep. Vander Jagt, Guy [R-MI-9] R MI 1988-06-22 0
100-hr-4848,A000215 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 A000215 Rep. Archer, Bill [R-TX-7] R TX 1988-06-22 0
100-hr-4848,F000380 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 F000380 Rep. Frenzel, Bill [R-MN-3] R MN 1988-06-22 0
100-hr-4848,R000053 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 R000053 Rep. Rangel, Charles B. [D-NY-16] D NY 1988-06-22 0
100-hr-4848,S000810 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 S000810 Rep. Stark, Fortney Pete [D-CA-9] D CA 1988-06-22 0
100-hr-4848,G000349 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 G000349 Rep. Gradison, Willis D., Jr. [R-OH-2] R OH 1988-06-22 0
100-hr-4848,S000146 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 S000146 Rep. Schulze, Richard T. [R-PA-5] R PA 1988-06-22 0
100-hr-4848,J000083 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 J000083 Rep. Jenkins, Edgar L. [D-GA-9] D GA 1988-06-22 0
100-hr-4848,P000170 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 P000170 Rep. Pease, Donald J. [D-OH-13] D OH 1988-06-22 0
100-hr-4848,A000213 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 A000213 Rep. Anthony, Beryl, Jr. [D-AR-4] D AR 1988-06-22 0
100-hr-4848,D000416 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 D000416 Rep. Donnelly, Brian J. [D-MA-11] D MA 1988-06-22 0
100-hr-4848,T000188 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 T000188 Rep. Thomas, William M. [R-CA-20] R CA 1988-06-22 0
100-hr-4848,B000919 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 B000919 Rep. Brown, Hank [R-CO-4] R CO 1988-06-22 0
100-hr-4848,G000445 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 G000445 Rep. Gregg, Judd [R-NH-2] R NH 1988-06-22 0
100-hr-4848,M000458 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 M000458 Rep. McGrath, Raymond J. [R-NY-5] R NY 1988-06-22 0
100-hr-4848,D000432 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 D000432 Rep. Dorgan, Byron L. [D-ND-At Large] D ND 1988-06-22 0
100-hr-4848,K000118 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 K000118 Rep. Kennelly, Barbara B. [D-CT-1] D CT 1988-06-22 0
100-hr-4848,A000209 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 A000209 Rep. Andrews, Michael [D-TX-25] D TX 1988-06-22 0
100-hr-4848,C000293 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 C000293 Rep. Chandler, Rod D. [R-WA-8] R WA 1988-06-22 0
100-hr-4848,L000263 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 L000263 Rep. Levin, Sander M. [D-MI-17] D MI 1988-06-22 0
100-hr-4848,M000881 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 M000881 Rep. Moody, Jim [D-WI-5] D WI 1988-06-22 0
100-hr-4848,R000436 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 R000436 Rep. Rose, Charlie [D-NC-7] D NC 1988-06-22 0
100-hr-4848,L000381 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 L000381 Rep. Lloyd, Marilyn [D-TN-3] D TN 1988-06-22 0
100-hr-4848,P000112 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 P000112 Rep. Patterson, Elizabeth [D-SC-4] D SC 1988-06-22 0
100-hr-4848,J000033 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 J000033 Rep. Jacobs, Andrew, Jr. [D-IN-10] D IN 1988-06-22 0
100-hr-4848,F000208 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 F000208 Rep. Flippo, Ronnie G. [D-AL-5] D AL 1988-06-22 0
100-hr-4848,F000239 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 F000239 Rep. Foley, Thomas S. [D-WA-5] D WA 1988-06-16 1
100-hr-4848,C000581 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 C000581 Rep. Coelho, Anthony Lee [D-CA-15] D CA 1988-06-16 1
100-hr-4848,R000374 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 R000374 Rep. Rodino, Peter W., Jr. [D-NJ-10] D NJ 1988-06-16 1
100-hr-4848,B000880 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 B000880 Rep. Brooks, Jack B. [D-TX-9] D TX 1988-06-16 1
100-hr-4848,D000355 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 D000355 Rep. Dingell, John D. [D-MI-16] D MI 1988-06-16 1
100-hr-4848,F000041 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 F000041 Rep. Fascell, Dante B. [D-FL-19] D FL 1988-06-16 1
100-hr-4848,S000762 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 S000762 Rep. St Germain, Fernand J. [D-RI-1] D RI 1988-06-16 1
100-hr-4848,P000218 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 P000218 Rep. Pepper, Claude [D-FL-18] D FL 1988-06-16 1
100-hr-4848,D000203 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 D000203 Rep. de la Garza, E. [D-TX-15] D TX 1988-06-16 1
100-hr-4848,J000256 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 J000256 Rep. Jones, Walter B. [D-NC-1] D NC 1988-06-16 1
100-hr-4848,R000383 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 R000383 Rep. Roe, Robert A. [D-NJ-8] D NJ 1988-06-16 1
100-hr-4848,L000556 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 L000556 Rep. LaFalce, John J. [D-NY-32] D NY 1988-06-16 1
100-hr-4848,H000367 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 H000367 Rep. Hawkins, Augustus F. [D-CA-29] D CA 1988-06-16 1
100-hr-4848,A000189 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 A000189 Rep. Anderson, Glenn M. [D-CA-32] D CA 1988-06-16 1
100-hr-4848,A000224 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 A000224 Rep. Aspin, Les [D-WI-1] D WI 1988-06-16 1
100-hr-4848,G000153 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 G000153 Rep. Gibbons, Sam [D-FL-7] D FL 1988-06-16 1
100-hr-4848,B000620 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 B000620 Rep. Bonker, Don [D-WA-3] D WA 1988-06-16 1
100-hr-4848,D000471 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 D000471 Rep. Downey, Thomas J. [D-NY-2] D NY 1988-06-16 1
100-hr-4848,R000543 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 R000543 Rep. Russo, Martin A. [D-IL-3] D IL 1988-06-16 1
100-hr-4848,M000249 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 M000249 Rep. Matsui, Robert T. [D-CA-3] D CA 1988-06-16 1
100-hr-4848,G000511 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 G000511 Rep. Guarini, Frank J. [D-NJ-14] D NJ 1988-06-16 1
100-hr-4848,M000688 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 M000688 Rep. Mica, Daniel Andrew [D-FL-14] D FL 1988-06-16 1
100-hr-4848,F000046 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 F000046 Del. Fauntroy, Walter E. [D-DC-At Large] D DC 1988-06-16 1
100-hr-4848,S001115 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 S001115 Rep. Swift, Al [D-WA-2] D WA 1988-06-16 1
100-hr-4848,S000294 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 S000294 Rep. Sharp, Philip R. [D-IN-2] D IN 1988-06-16 1
100-hr-4848,W000682 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 W000682 Rep. Wolpe, Howard E. [D-MI-3] D MI 1988-06-16 1
100-hr-4848,S000465 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 S000465 Rep. Skelton, Ike [D-MO-4] D MO 1988-06-16 1
100-hr-4848,H000340 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 H000340 Rep. Hatcher, Charles [D-GA-2] D GA 1988-06-16 1
100-hr-4848,K000020 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 K000020 Rep. Kastenmeier, Robert W. [D-WI-2] D WI 1988-06-16 1
100-hr-4848,H000930 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 H000930 Rep. Hughes, William J. [D-NJ-2] D NJ 1988-06-16 1
100-hr-4848,B000432 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 B000432 Rep. Biaggi, Mario [D-NY-19] D NY 1988-06-16 1
100-hr-4848,G000309 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 G000309 Rep. Gordon, Bart [D-TN-6] D TN 1988-06-16 1
100-hr-4848,P000523 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 P000523 Rep. Price, David E. [D-NC-4] D NC 1988-06-16 1
100-hr-4848,P000215 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 P000215 Rep. Penny, Timothy J. [D-MN-1] D MN 1988-06-16 1
100-hr-4848,R000354 Omnibus Trade and Competitiveness Act of 1988 100-hr-4848 R000354 Rep. Robinson, Tommy F. [D-AR-2] D AR 1988-06-16 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);
Powered by Datasette · Queries took 130.396ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API