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

21 rows where bill_id = "99-hr-5537" 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 18
  • 0 3
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
99-hr-5537,S000477 Foreign Agricultural and Mineral Investment Reform Act of 1986 99-hr-5537 S000477 Rep. Slattery, Jim [D-KS-2] D KS 1986-10-18 0
99-hr-5537,B000229 Foreign Agricultural and Mineral Investment Reform Act of 1986 99-hr-5537 B000229 Rep. Bateman, Herbert H. [R-VA-1] R VA 1986-10-17 0
99-hr-5537,D000065 Foreign Agricultural and Mineral Investment Reform Act of 1986 99-hr-5537 D000065 Rep. Daub, Hal [R-NE-2] R NE 1986-09-26 0
99-hr-5537,C000858 Foreign Agricultural and Mineral Investment Reform Act of 1986 99-hr-5537 C000858 Rep. Craig, Larry E. [R-ID-1] R ID 1986-09-17 1
99-hr-5537,K000322 Foreign Agricultural and Mineral Investment Reform Act of 1986 99-hr-5537 K000322 Rep. Kramer, Ken [R-CO-5] R CO 1986-09-17 1
99-hr-5537,R000307 Foreign Agricultural and Mineral Investment Reform Act of 1986 99-hr-5537 R000307 Rep. Roberts, Pat [R-KS-1] R KS 1986-09-17 1
99-hr-5537,S000795 Foreign Agricultural and Mineral Investment Reform Act of 1986 99-hr-5537 S000795 Rep. Stangeland, Arlan [R-MN-7] R MN 1986-09-17 1
99-hr-5537,L000305 Foreign Agricultural and Mineral Investment Reform Act of 1986 99-hr-5537 L000305 Rep. Lightfoot, Jim [R-IA-5] R IA 1986-09-17 1
99-hr-5537,G000291 Foreign Agricultural and Mineral Investment Reform Act of 1986 99-hr-5537 G000291 Rep. Goodling, William F. [R-PA-19] R PA 1986-09-17 1
99-hr-5537,S000463 Foreign Agricultural and Mineral Investment Reform Act of 1986 99-hr-5537 S000463 Rep. Skeen, Joe [R-NM-2] R NM 1986-09-17 1
99-hr-5537,E000031 Foreign Agricultural and Mineral Investment Reform Act of 1986 99-hr-5537 E000031 Rep. Eckart, Dennis E. [D-OH-11] D OH 1986-09-17 1
99-hr-5537,C000653 Foreign Agricultural and Mineral Investment Reform Act of 1986 99-hr-5537 C000653 Rep. Combest, Larry [R-TX-19] R TX 1986-09-17 1
99-hr-5537,G000225 Foreign Agricultural and Mineral Investment Reform Act of 1986 99-hr-5537 G000225 Rep. Gingrich, Newt [R-GA-6] R GA 1986-09-17 1
99-hr-5537,W000237 Foreign Agricultural and Mineral Investment Reform Act of 1986 99-hr-5537 W000237 Rep. Weber, Vin [R-MN-2] R MN 1986-09-17 1
99-hr-5537,S000143 Foreign Agricultural and Mineral Investment Reform Act of 1986 99-hr-5537 S000143 Rep. Schuette, Bill [R-MI-10] R MI 1986-09-17 1
99-hr-5537,B001149 Foreign Agricultural and Mineral Investment Reform Act of 1986 99-hr-5537 B001149 Rep. Burton, Dan [R-IN-6] R IN 1986-09-17 1
99-hr-5537,E000174 Foreign Agricultural and Mineral Investment Reform Act of 1986 99-hr-5537 E000174 Rep. Emerson, Bill [R-MO-8] R MO 1986-09-17 1
99-hr-5537,M000860 Foreign Agricultural and Mineral Investment Reform Act of 1986 99-hr-5537 M000860 Rep. Monson, David S. [R-UT-2] R UT 1986-09-17 1
99-hr-5537,B000213 Foreign Agricultural and Mineral Investment Reform Act of 1986 99-hr-5537 B000213 Rep. Barton, Joe [R-TX-6] R TX 1986-09-17 1
99-hr-5537,S000607 Foreign Agricultural and Mineral Investment Reform Act of 1986 99-hr-5537 S000607 Rep. Smith, Robert [R-OR-2] R OR 1986-09-17 1
99-hr-5537,D000217 Foreign Agricultural and Mineral Investment Reform Act of 1986 99-hr-5537 D000217 Rep. DeLay, Tom [R-TX-22] R TX 1986-09-17 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);