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

41 rows where bill_id = "99-hr-5352" 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 39
  • 0 2
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
99-hr-5352,H000448 International Narcotics Control Act of 1986 99-hr-5352 H000448 Rep. Hefner, W. G. (Bill) [D-NC-8] D NC 1986-08-15 0
99-hr-5352,A000189 International Narcotics Control Act of 1986 99-hr-5352 A000189 Rep. Anderson, Glenn M. [D-CA-32] D CA 1986-08-15 0
99-hr-5352,H000114 International Narcotics Control Act of 1986 99-hr-5352 H000114 Rep. Hamilton, Lee H. [D-IN-9] D IN 1986-08-07 1
99-hr-5352,Y000014 International Narcotics Control Act of 1986 99-hr-5352 Y000014 Rep. Yatron, Gus [D-PA-6] D PA 1986-08-07 1
99-hr-5352,S000673 International Narcotics Control Act of 1986 99-hr-5352 S000673 Rep. Solarz, Stephen J. [D-NY-13] D NY 1986-08-07 1
99-hr-5352,B000620 International Narcotics Control Act of 1986 99-hr-5352 B000620 Rep. Bonker, Don [D-WA-3] D WA 1986-08-07 1
99-hr-5352,S001040 International Narcotics Control Act of 1986 99-hr-5352 S001040 Rep. Studds, Gerry E. [D-MA-10] D MA 1986-08-07 1
99-hr-5352,M000688 International Narcotics Control Act of 1986 99-hr-5352 M000688 Rep. Mica, Daniel Andrew [D-FL-14] D FL 1986-08-07 1
99-hr-5352,B000160 International Narcotics Control Act of 1986 99-hr-5352 B000160 Rep. Barnes, Michael D. [D-MD-8] D MD 1986-08-07 1
99-hr-5352,W000682 International Narcotics Control Act of 1986 99-hr-5352 W000682 Rep. Wolpe, Howard E. [D-MI-3] D MI 1986-08-07 1
99-hr-5352,G000120 International Narcotics Control Act of 1986 99-hr-5352 G000120 Rep. Gejdenson, Sam [D-CT-2] D CT 1986-08-07 1
99-hr-5352,D000592 International Narcotics Control Act of 1986 99-hr-5352 D000592 Rep. Dymally, Mervyn M. [D-CA-31] D CA 1986-08-07 1
99-hr-5352,L000090 International Narcotics Control Act of 1986 99-hr-5352 L000090 Rep. Lantos, Tom [D-CA-11] D CA 1986-08-07 1
99-hr-5352,K000319 International Narcotics Control Act of 1986 99-hr-5352 K000319 Rep. Kostmayer, Peter H. [D-PA-8] D PA 1986-08-07 1
99-hr-5352,T000317 International Narcotics Control Act of 1986 99-hr-5352 T000317 Rep. Torricelli, Robert G. [D-NJ-9] D NJ 1986-08-07 1
99-hr-5352,S000586 International Narcotics Control Act of 1986 99-hr-5352 S000586 Rep. Smith, Lawrence [D-FL-16] D FL 1986-08-07 1
99-hr-5352,B000410 International Narcotics Control Act of 1986 99-hr-5352 B000410 Rep. Berman, Howard L. [D-CA-26] D CA 1986-08-07 1
99-hr-5352,R000146 International Narcotics Control Act of 1986 99-hr-5352 R000146 Rep. Reid, Harry [D-NV-1] D NV 1986-08-07 1
99-hr-5352,L000264 International Narcotics Control Act of 1986 99-hr-5352 L000264 Rep. Levine, Mel [D-CA-27] D CA 1986-08-07 1
99-hr-5352,F000059 International Narcotics Control Act of 1986 99-hr-5352 F000059 Rep. Feighan, Edward F. [D-OH-19] D OH 1986-08-07 1
99-hr-5352,A000022 International Narcotics Control Act of 1986 99-hr-5352 A000022 Rep. Ackerman, Gary L. [D-NY-7] D NY 1986-08-07 1
99-hr-5352,M000023 International Narcotics Control Act of 1986 99-hr-5352 M000023 Rep. MacKay, Buddy [D-FL-6] D FL 1986-08-07 1
99-hr-5352,U000001 International Narcotics Control Act of 1986 99-hr-5352 U000001 Rep. Udall, Morris K. [D-AZ-2] D AZ 1986-08-07 1
99-hr-5352,G000047 International Narcotics Control Act of 1986 99-hr-5352 G000047 Rep. Garcia, Robert [D-NY-18] D NY 1986-08-07 1
99-hr-5352,B000890 International Narcotics Control Act of 1986 99-hr-5352 B000890 Rep. Broomfield, William S. [R-MI-18] R MI 1986-08-07 1
99-hr-5352,G000212 International Narcotics Control Act of 1986 99-hr-5352 G000212 Rep. Gilman, Benjamin A. [R-NY-22] R NY 1986-08-07 1
99-hr-5352,L000020 International Narcotics Control Act of 1986 99-hr-5352 L000020 Rep. Lagomarsino, Robert J. [R-CA-19] R CA 1986-08-07 1
99-hr-5352,L000169 International Narcotics Control Act of 1986 99-hr-5352 L000169 Rep. Leach, James A. [R-IA-1] R IA 1986-08-07 1
99-hr-5352,R000459 International Narcotics Control Act of 1986 99-hr-5352 R000459 Rep. Roth, Toby [R-WI-8] R WI 1986-08-07 1
99-hr-5352,S000663 International Narcotics Control Act of 1986 99-hr-5352 S000663 Rep. Snowe, Olympia J. [R-ME-2] R ME 1986-08-07 1
99-hr-5352,H001022 International Narcotics Control Act of 1986 99-hr-5352 H001022 Rep. Hyde, Henry J. [R-IL-6] R IL 1986-08-07 1
99-hr-5352,S000675 International Narcotics Control Act of 1986 99-hr-5352 S000675 Rep. Solomon, Gerald B. H. [R-NY-24] R NY 1986-08-07 1
99-hr-5352,B000403 International Narcotics Control Act of 1986 99-hr-5352 B000403 Rep. Bereuter, Doug [R-NE-1] R NE 1986-08-07 1
99-hr-5352,S000409 International Narcotics Control Act of 1986 99-hr-5352 S000409 Rep. Siljander, Mark D. [R-MI-4] R MI 1986-08-07 1
99-hr-5352,Z000014 International Narcotics Control Act of 1986 99-hr-5352 Z000014 Rep. Zschau, Edwin V. W. [R-CA-12] R CA 1986-08-07 1
99-hr-5352,D000435 International Narcotics Control Act of 1986 99-hr-5352 D000435 Rep. Dornan, Robert K. [R-CA-38] R CA 1986-08-07 1
99-hr-5352,S000522 International Narcotics Control Act of 1986 99-hr-5352 S000522 Rep. Smith, Christopher H. [R-NJ-4] R NJ 1986-08-07 1
99-hr-5352,M000019 International Narcotics Control Act of 1986 99-hr-5352 M000019 Rep. Mack, Connie, III [R-FL-13] R FL 1986-08-07 1
99-hr-5352,D000294 International Narcotics Control Act of 1986 99-hr-5352 D000294 Rep. DeWine, Mike [R-OH-7] R OH 1986-08-07 1
99-hr-5352,B001149 International Narcotics Control Act of 1986 99-hr-5352 B001149 Rep. Burton, Dan [R-IN-6] R IN 1986-08-07 1
99-hr-5352,M000303 International Narcotics Control Act of 1986 99-hr-5352 M000303 Rep. McCain, John [R-AZ-1] R AZ 1986-08-07 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);