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

28 rows where bill_id = "100-hr-3765" 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 21
  • 0 7
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
100-hr-3765,H000390 Commercial Space Launch Act Amendments of 1987 100-hr-3765 H000390 Rep. Hayes, James A. [D-LA-7] D LA 1988-03-09 0
100-hr-3765,L000381 Commercial Space Launch Act Amendments of 1987 100-hr-3765 L000381 Rep. Lloyd, Marilyn [D-TN-3] D TN 1988-03-09 0
100-hr-3765,S000244 Commercial Space Launch Act Amendments of 1987 100-hr-3765 S000244 Rep. Sensenbrenner, F. James, Jr. [R-WI-9] R WI 1988-02-03 0
100-hr-3765,K000309 Commercial Space Launch Act Amendments of 1987 100-hr-3765 K000309 Rep. Konnyu, Ernest L. [R-CA-12] R CA 1988-02-03 0
100-hr-3765,B001036 Commercial Space Launch Act Amendments of 1987 100-hr-3765 B001036 Rep. Buechner, Jack [R-MO-2] R MO 1988-02-03 0
100-hr-3765,H000444 Commercial Space Launch Act Amendments of 1987 100-hr-3765 H000444 Rep. Hefley, Joel [R-CO-5] R CO 1988-02-03 0
100-hr-3765,M000573 Commercial Space Launch Act Amendments of 1987 100-hr-3765 M000573 Rep. McMillen, Thomas [D-MD-4] D MD 1988-02-03 0
100-hr-3765,R000383 Commercial Space Launch Act Amendments of 1987 100-hr-3765 R000383 Rep. Roe, Robert A. [D-NJ-8] D NJ 1987-12-15 1
100-hr-3765,L000506 Commercial Space Launch Act Amendments of 1987 100-hr-3765 L000506 Rep. Lujan, Manuel, Jr. [R-NM-1] R NM 1987-12-15 1
100-hr-3765,W000068 Commercial Space Launch Act Amendments of 1987 100-hr-3765 W000068 Rep. Walker, Robert S. [R-PA-16] R PA 1987-12-15 1
100-hr-3765,B000918 Commercial Space Launch Act Amendments of 1987 100-hr-3765 B000918 Rep. Brown, George E., Jr. [D-CA-36] D CA 1987-12-15 1
100-hr-3765,L000295 Commercial Space Launch Act Amendments of 1987 100-hr-3765 L000295 Rep. Lewis, Thomas F. [R-FL-12] R FL 1987-12-15 1
100-hr-3765,V000112 Commercial Space Launch Act Amendments of 1987 100-hr-3765 V000112 Rep. Volkmer, Harold L. [D-MO-9] D MO 1987-12-15 1
100-hr-3765,P000005 Commercial Space Launch Act Amendments of 1987 100-hr-3765 P000005 Rep. Packard, Ron [R-CA-43] R CA 1987-12-15 1
100-hr-3765,H000067 Commercial Space Launch Act Amendments of 1987 100-hr-3765 H000067 Rep. Hall, Ralph M. [D-TX-4] D TX 1987-12-15 1
100-hr-3765,H000514 Commercial Space Launch Act Amendments of 1987 100-hr-3765 H000514 Rep. Henry, Paul B. [R-MI-5] R MI 1987-12-15 1
100-hr-3765,M000398 Commercial Space Launch Act Amendments of 1987 100-hr-3765 M000398 Rep. McCurdy, Dave [D-OK-4] D OK 1987-12-15 1
100-hr-3765,S000479 Commercial Space Launch Act Amendments of 1987 100-hr-3765 S000479 Rep. Slaughter, D. French, Jr. [R-VA-7] R VA 1987-12-15 1
100-hr-3765,M000794 Commercial Space Launch Act Amendments of 1987 100-hr-3765 M000794 Rep. Mineta, Norman Y. [D-CA-13] D CA 1987-12-15 1
100-hr-3765,M000941 Commercial Space Launch Act Amendments of 1987 100-hr-3765 M000941 Rep. Morella, Constance A. [R-MD-8] R MD 1987-12-15 1
100-hr-3765,M000023 Commercial Space Launch Act Amendments of 1987 100-hr-3765 M000023 Rep. MacKay, Buddy [D-FL-6] D FL 1987-12-15 1
100-hr-3765,T000317 Commercial Space Launch Act Amendments of 1987 100-hr-3765 T000317 Rep. Torricelli, Robert G. [D-NJ-9] D NJ 1987-12-15 1
100-hr-3765,C000312 Commercial Space Launch Act Amendments of 1987 100-hr-3765 C000312 Rep. Chapman, Jim [D-TX-1] D TX 1987-12-15 1
100-hr-3765,N000163 Commercial Space Launch Act Amendments of 1987 100-hr-3765 N000163 Rep. Nowak, Henry [D-NY-33] D NY 1987-12-15 1
100-hr-3765,P000229 Commercial Space Launch Act Amendments of 1987 100-hr-3765 P000229 Rep. Perkins, Carl C. [D-KY-7] D KY 1987-12-15 1
100-hr-3765,N000003 Commercial Space Launch Act Amendments of 1987 100-hr-3765 N000003 Rep. Nagle, Dave R, [D-IA-3] D IA 1987-12-15 1
100-hr-3765,S000462 Commercial Space Launch Act Amendments of 1987 100-hr-3765 S000462 Rep. Skaggs, David E. [D-CO-2] D CO 1987-12-15 1
100-hr-3765,L000020 Commercial Space Launch Act Amendments of 1987 100-hr-3765 L000020 Rep. Lagomarsino, Robert J. [R-CA-19] R CA 1987-12-15 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);