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

44 rows where bill_id = "102-hr-5231" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

  • 1 26
  • 0 18
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
102-hr-5231,C000312 National Competitiveness Act of 1992 102-hr-5231 C000312 Rep. Chapman, Jim [D-TX-1] D TX 1992-08-06 0
102-hr-5231,B000410 National Competitiveness Act of 1992 102-hr-5231 B000410 Rep. Berman, Howard L. [D-CA-26] D CA 1992-07-09 0
102-hr-5231,B001172 National Competitiveness Act of 1992 102-hr-5231 B001172 Rep. Bustamante, Albert G. [D-TX-23] D TX 1992-07-09 0
102-hr-5231,D000209 National Competitiveness Act of 1992 102-hr-5231 D000209 Del. de Lugo, Ron [D-VI-At Large] D VI 1992-07-09 0
102-hr-5231,J000070 National Competitiveness Act of 1992 102-hr-5231 J000070 Rep. Jefferson, William J. [D-LA-2] D LA 1992-07-09 0
102-hr-5231,M000844 National Competitiveness Act of 1992 102-hr-5231 M000844 Rep. Mollohan, Alan B. [D-WV-1] D WV 1992-07-09 0
102-hr-5231,H000930 National Competitiveness Act of 1992 102-hr-5231 H000930 Rep. Hughes, William J. [D-NJ-2] D NJ 1992-07-09 0
102-hr-5231,N000015 National Competitiveness Act of 1992 102-hr-5231 N000015 Rep. Neal, Richard E. [D-MA-2] D MA 1992-07-09 0
102-hr-5231,R000262 National Competitiveness Act of 1992 102-hr-5231 R000262 Rep. Rinaldo, Matthew J. [R-NJ-7] R NJ 1992-07-09 0
102-hr-5231,P000099 National Competitiveness Act of 1992 102-hr-5231 P000099 Rep. Pastor, Ed [D-AZ-2] D AZ 1992-07-09 0
102-hr-5231,T000316 National Competitiveness Act of 1992 102-hr-5231 T000316 Rep. Torres, Esteban Edward [D-CA-34] D CA 1992-07-09 0
102-hr-5231,S000005 National Competitiveness Act of 1992 102-hr-5231 S000005 Rep. Sabo, Martin Olav [D-MN-5] D MN 1992-07-09 0
102-hr-5231,K000009 National Competitiveness Act of 1992 102-hr-5231 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 1992-07-09 0
102-hr-5231,A000226 National Competitiveness Act of 1992 102-hr-5231 A000226 Rep. Atkins, Chester G. [D-MA-5] D MA 1992-07-09 0
102-hr-5231,L000045 National Competitiveness Act of 1992 102-hr-5231 L000045 Rep. Lancaster, H. Martin [D-NC-3] D NC 1992-07-09 0
102-hr-5231,D000327 National Competitiveness Act of 1992 102-hr-5231 D000327 Rep. Dicks, Norman D. [D-WA-6] D WA 1992-07-09 0
102-hr-5231,J000177 National Competitiveness Act of 1992 102-hr-5231 J000177 Rep. Johnson, Tim [D-SD-At Large] D SD 1992-07-09 0
102-hr-5231,K000312 National Competitiveness Act of 1992 102-hr-5231 K000312 Rep. Kopetski, Mike [D-OR-5] D OR 1992-07-09 0
102-hr-5231,B000918 National Competitiveness Act of 1992 102-hr-5231 B000918 Rep. Brown, George E., Jr. [D-CA-36] D CA 1992-05-21 1
102-hr-5231,G000240 National Competitiveness Act of 1992 102-hr-5231 G000240 Rep. Glickman, Dan [D-KS-4] D KS 1992-05-21 1
102-hr-5231,M000794 National Competitiveness Act of 1992 102-hr-5231 M000794 Rep. Mineta, Norman Y. [D-CA-13] D CA 1992-05-21 1
102-hr-5231,T000317 National Competitiveness Act of 1992 102-hr-5231 T000317 Rep. Torricelli, Robert G. [D-NJ-9] D NJ 1992-05-21 1
102-hr-5231,T000243 National Competitiveness Act of 1992 102-hr-5231 T000243 Rep. Thornton, Ray [D-AR-2] D AR 1992-05-21 1
102-hr-5231,R000385 National Competitiveness Act of 1992 102-hr-5231 R000385 Rep. Roemer, Tim [D-IN-3] D IN 1992-05-21 1
102-hr-5231,H000788 National Competitiveness Act of 1992 102-hr-5231 H000788 Rep. Horn, Joan Kelly [D-MO-2] D MO 1992-05-21 1
102-hr-5231,B000657 National Competitiveness Act of 1992 102-hr-5231 B000657 Rep. Boucher, Rick [D-VA-9] D VA 1992-05-21 1
102-hr-5231,T000038 National Competitiveness Act of 1992 102-hr-5231 T000038 Rep. Tanner, John S. [D-TN-8] D TN 1992-05-21 1
102-hr-5231,B000008 National Competitiveness Act of 1992 102-hr-5231 B000008 Rep. Bacchus, Jim [D-FL-11] D FL 1992-05-21 1
102-hr-5231,S001113 National Competitiveness Act of 1992 102-hr-5231 S001113 Rep. Swett, Dick [D-NH-2] D NH 1992-05-21 1
102-hr-5231,E000179 National Competitiveness Act of 1992 102-hr-5231 E000179 Rep. Engel, Eliot L. [D-NY-19] D NY 1992-05-21 1
102-hr-5231,O000085 National Competitiveness Act of 1992 102-hr-5231 O000085 Rep. Olver, John W. [D-MA-1] D MA 1992-05-21 1
102-hr-5231,L000381 National Competitiveness Act of 1992 102-hr-5231 L000381 Rep. Lloyd, Marilyn [D-TN-3] D TN 1992-05-21 1
102-hr-5231,V000112 National Competitiveness Act of 1992 102-hr-5231 V000112 Rep. Volkmer, Harold L. [D-MO-9] D MO 1992-05-21 1
102-hr-5231,W000682 National Competitiveness Act of 1992 102-hr-5231 W000682 Rep. Wolpe, Howard E. [D-MI-3] D MI 1992-05-21 1
102-hr-5231,H000074 National Competitiveness Act of 1992 102-hr-5231 H000074 Rep. Hall, Tony P. [D-OH-3] D OH 1992-05-21 1
102-hr-5231,M000398 National Competitiveness Act of 1992 102-hr-5231 M000398 Rep. McCurdy, Dave [D-OK-4] D OK 1992-05-21 1
102-hr-5231,S000785 National Competitiveness Act of 1992 102-hr-5231 S000785 Rep. Stallings, Richard H. [D-ID-2] D ID 1992-05-21 1
102-hr-5231,T000350 National Competitiveness Act of 1992 102-hr-5231 T000350 Rep. Traficant, James A., Jr. [D-OH-17] D OH 1992-05-21 1
102-hr-5231,N000163 National Competitiveness Act of 1992 102-hr-5231 N000163 Rep. Nowak, Henry [D-NY-33] D NY 1992-05-21 1
102-hr-5231,P000229 National Competitiveness Act of 1992 102-hr-5231 P000229 Rep. Perkins, Carl C. [D-KY-7] D KY 1992-05-21 1
102-hr-5231,M000573 National Competitiveness Act of 1992 102-hr-5231 M000573 Rep. McMillen, Thomas [D-MD-4] D MD 1992-05-21 1
102-hr-5231,N000003 National Competitiveness Act of 1992 102-hr-5231 N000003 Rep. Nagle, Dave R, [D-IA-3] D IA 1992-05-21 1
102-hr-5231,C000868 National Competitiveness Act of 1992 102-hr-5231 C000868 Rep. Cramer, Robert E. (Bud), Jr. [D-AL-5] D AL 1992-05-21 1
102-hr-5231,K000319 National Competitiveness Act of 1992 102-hr-5231 K000319 Rep. Kostmayer, Peter H. [D-PA-8] D PA 1992-05-21 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);