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

49 rows where bill_id = "103-hr-820" 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 37
  • 0 12
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
103-hr-820,H000627 National Competitiveness Act of 1994 103-hr-820 H000627 Rep. Hinchey, Maurice D. [D-NY-26] D NY 1993-05-03 0
103-hr-820,D000327 National Competitiveness Act of 1994 103-hr-820 D000327 Rep. Dicks, Norman D. [D-WA-6] D WA 1993-05-03 0
103-hr-820,E000250 National Competitiveness Act of 1994 103-hr-820 E000250 Rep. Evans, Lane [D-IL-17] D IL 1993-05-03 0
103-hr-820,H000930 National Competitiveness Act of 1994 103-hr-820 H000930 Rep. Hughes, William J. [D-NJ-2] D NJ 1993-05-03 0
103-hr-820,L000045 National Competitiveness Act of 1994 103-hr-820 L000045 Rep. Lancaster, H. Martin [D-NC-3] D NC 1993-05-03 0
103-hr-820,L000556 National Competitiveness Act of 1994 103-hr-820 L000556 Rep. LaFalce, John J. [D-NY-29] D NY 1993-05-03 0
103-hr-820,M000015 National Competitiveness Act of 1994 103-hr-820 M000015 Rep. Machtley, Ronald K. [R-RI-1] R RI 1993-05-03 0
103-hr-820,K000270 National Competitiveness Act of 1994 103-hr-820 K000270 Rep. Klink, Ron [D-PA-4] D PA 1993-05-03 0
103-hr-820,M000844 National Competitiveness Act of 1994 103-hr-820 M000844 Rep. Mollohan, Alan B. [D-WV-1] D WV 1993-05-03 0
103-hr-820,K000009 National Competitiveness Act of 1994 103-hr-820 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 1993-05-03 0
103-hr-820,S000332 National Competitiveness Act of 1994 103-hr-820 S000332 Rep. Shepherd, Karen [D-UT-2] D UT 1993-05-03 0
103-hr-820,M000627 National Competitiveness Act of 1994 103-hr-820 M000627 Rep. Meehan, Martin T. [D-MA-5] D MA 1993-05-03 0
103-hr-820,B000918 National Competitiveness Act of 1994 103-hr-820 B000918 Rep. Brown, George E., Jr. [D-CA-42] D CA 1993-02-04 1
103-hr-820,M000794 National Competitiveness Act of 1994 103-hr-820 M000794 Rep. Mineta, Norman Y. [D-CA-15] D CA 1993-02-04 1
103-hr-820,L000381 National Competitiveness Act of 1994 103-hr-820 L000381 Rep. Lloyd, Marilyn [D-TN-3] D TN 1993-02-04 1
103-hr-820,G000240 National Competitiveness Act of 1994 103-hr-820 G000240 Rep. Glickman, Dan [D-KS-4] D KS 1993-02-04 1
103-hr-820,V000112 National Competitiveness Act of 1994 103-hr-820 V000112 Rep. Volkmer, Harold L. [D-MO-9] D MO 1993-02-04 1
103-hr-820,B000586 National Competitiveness Act of 1994 103-hr-820 B000586 Rep. Boehlert, Sherwood [R-NY-23] R NY 1993-02-04 1
103-hr-820,H000067 National Competitiveness Act of 1994 103-hr-820 H000067 Rep. Hall, Ralph M. [D-TX-4] D TX 1993-02-04 1
103-hr-820,M000398 National Competitiveness Act of 1994 103-hr-820 M000398 Rep. McCurdy, Dave [D-OK-4] D OK 1993-02-04 1
103-hr-820,H000514 National Competitiveness Act of 1994 103-hr-820 H000514 Rep. Henry, Paul B. [R-MI-3] R MI 1993-02-04 1
103-hr-820,T000317 National Competitiveness Act of 1994 103-hr-820 T000317 Rep. Torricelli, Robert G. [D-NJ-9] D NJ 1993-02-04 1
103-hr-820,B000657 National Competitiveness Act of 1994 103-hr-820 B000657 Rep. Boucher, Rick [D-VA-9] D VA 1993-02-04 1
103-hr-820,T000350 National Competitiveness Act of 1994 103-hr-820 T000350 Rep. Traficant, James A., Jr. [D-OH-17] D OH 1993-02-04 1
103-hr-820,H000390 National Competitiveness Act of 1994 103-hr-820 H000390 Rep. Hayes, James A. [D-LA-7] D LA 1993-02-04 1
103-hr-820,B000008 National Competitiveness Act of 1994 103-hr-820 B000008 Rep. Bacchus, Jim [D-FL-15] D FL 1993-02-04 1
103-hr-820,R000385 National Competitiveness Act of 1994 103-hr-820 R000385 Rep. Roemer, Tim [D-IN-3] D IN 1993-02-04 1
103-hr-820,C000868 National Competitiveness Act of 1994 103-hr-820 C000868 Rep. Cramer, Robert E. (Bud), Jr. [D-AL-5] D AL 1993-02-04 1
103-hr-820,S001113 National Competitiveness Act of 1994 103-hr-820 S001113 Rep. Swett, Dick [D-NH-2] D NH 1993-02-04 1
103-hr-820,B000134 National Competitiveness Act of 1994 103-hr-820 B000134 Rep. Barcia, James A. [D-MI-5] D MI 1993-02-04 1
103-hr-820,K000262 National Competitiveness Act of 1994 103-hr-820 K000262 Rep. Klein, Herbert C. [D-NJ-8] D NJ 1993-02-04 1
103-hr-820,F000128 National Competitiveness Act of 1994 103-hr-820 F000128 Rep. Fingerhut, Eric D. [D-OH-19] D OH 1993-02-04 1
103-hr-820,M000466 National Competitiveness Act of 1994 103-hr-820 M000466 Rep. McHale, Paul [D-PA-15] D PA 1993-02-04 1
103-hr-820,B000287 National Competitiveness Act of 1994 103-hr-820 B000287 Rep. Becerra, Xavier [D-CA-30] D CA 1993-02-04 1
103-hr-820,H000213 National Competitiveness Act of 1994 103-hr-820 H000213 Rep. Harman, Jane [D-CA-36] D CA 1993-02-04 1
103-hr-820,J000120 National Competitiveness Act of 1994 103-hr-820 J000120 Rep. Johnson, Don [D-GA-10] D GA 1993-02-04 1
103-hr-820,C000767 National Competitiveness Act of 1994 103-hr-820 C000767 Rep. Coppersmith, Sam [D-AZ-1] D AZ 1993-02-04 1
103-hr-820,E000215 National Competitiveness Act of 1994 103-hr-820 E000215 Rep. Eshoo, Anna G. [D-CA-14] D CA 1993-02-04 1
103-hr-820,I000026 National Competitiveness Act of 1994 103-hr-820 I000026 Rep. Inslee, Jay [D-WA-4] D WA 1993-02-04 1
103-hr-820,J000126 National Competitiveness Act of 1994 103-hr-820 J000126 Rep. Johnson, Eddie Bernice [D-TX-30] D TX 1993-02-04 1
103-hr-820,M000795 National Competitiveness Act of 1994 103-hr-820 M000795 Rep. Minge, David [D-MN-2] D MN 1993-02-04 1
103-hr-820,S000185 National Competitiveness Act of 1994 103-hr-820 S000185 Rep. Scott, Robert C. "Bobby" [D-VA-3] D VA 1993-02-04 1
103-hr-820,W000738 National Competitiveness Act of 1994 103-hr-820 W000738 Rep. Woolsey, Lynn C. [D-CA-6] D CA 1993-02-04 1
103-hr-820,M000926 National Competitiveness Act of 1994 103-hr-820 M000926 Rep. Moorhead, Carlos J. [R-CA-27] R CA 1993-02-04 1
103-hr-820,R000141 National Competitiveness Act of 1994 103-hr-820 R000141 Rep. Regula, Ralph [R-OH-16] R OH 1993-02-04 1
103-hr-820,R000243 National Competitiveness Act of 1994 103-hr-820 R000243 Rep. Ridge, Thomas J. [R-PA-21] R PA 1993-02-04 1
103-hr-820,T000243 National Competitiveness Act of 1994 103-hr-820 T000243 Rep. Thornton, Ray [D-AR-2] D AR 1993-02-04 1
103-hr-820,E000179 National Competitiveness Act of 1994 103-hr-820 E000179 Rep. Engel, Eliot L. [D-NY-17] D NY 1993-02-04 1
103-hr-820,O000085 National Competitiveness Act of 1994 103-hr-820 O000085 Rep. Olver, John W. [D-MA-1] D MA 1993-02-04 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);