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

47 rows where bill_id = "99-hr-4197" 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

  • 0 46
  • 1 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
99-hr-4197,A000022 Full Credit Card Cost Disclosure Act 99-hr-4197 A000022 Rep. Ackerman, Gary L. [D-NY-7] D NY 1986-08-01 0
99-hr-4197,W000258 Full Credit Card Cost Disclosure Act 99-hr-4197 W000258 Rep. Weiss, Ted [D-NY-17] D NY 1986-07-22 0
99-hr-4197,O000159 Full Credit Card Cost Disclosure Act 99-hr-4197 O000159 Rep. Owens, Major R. [D-NY-12] D NY 1986-07-22 0
99-hr-4197,F000329 Full Credit Card Cost Disclosure Act 99-hr-4197 F000329 Rep. Fowler, Wyche, Jr. [D-GA-5] D GA 1986-07-22 0
99-hr-4197,R000053 Full Credit Card Cost Disclosure Act 99-hr-4197 R000053 Rep. Rangel, Charles B. [D-NY-16] D NY 1986-07-14 0
99-hr-4197,H000367 Full Credit Card Cost Disclosure Act 99-hr-4197 H000367 Rep. Hawkins, Augustus F. [D-CA-29] D CA 1986-07-14 0
99-hr-4197,S000673 Full Credit Card Cost Disclosure Act 99-hr-4197 S000673 Rep. Solarz, Stephen J. [D-NY-13] D NY 1986-06-19 0
99-hr-4197,H000930 Full Credit Card Cost Disclosure Act 99-hr-4197 H000930 Rep. Hughes, William J. [D-NJ-2] D NJ 1986-06-12 0
99-hr-4197,D000209 Full Credit Card Cost Disclosure Act 99-hr-4197 D000209 Del. de Lugo, Ron [D-VI-At Large] D VI 1986-06-12 0
99-hr-4197,K000009 Full Credit Card Cost Disclosure Act 99-hr-4197 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 1986-05-06 0
99-hr-4197,D000416 Full Credit Card Cost Disclosure Act 99-hr-4197 D000416 Rep. Donnelly, Brian J. [D-MA-11] D MA 1986-05-06 0
99-hr-4197,L000263 Full Credit Card Cost Disclosure Act 99-hr-4197 L000263 Rep. Levin, Sander M. [D-MI-17] D MI 1986-05-06 0
99-hr-4197,G000272 Full Credit Card Cost Disclosure Act 99-hr-4197 G000272 Rep. Gonzalez, Henry B. [D-TX-20] D TX 1986-05-06 0
99-hr-4197,K000259 Full Credit Card Cost Disclosure Act 99-hr-4197 K000259 Rep. Kleczka, Gerald D. [D-WI-4] D WI 1986-05-06 0
99-hr-4197,L000225 Full Credit Card Cost Disclosure Act 99-hr-4197 L000225 Rep. Lehman, Richard H. [D-CA-18] D CA 1986-05-06 0
99-hr-4197,O000001 Full Credit Card Cost Disclosure Act 99-hr-4197 O000001 Rep. Oakar, Mary Rose [D-OH-20] D OH 1986-05-06 0
99-hr-4197,C000754 Full Credit Card Cost Disclosure Act 99-hr-4197 C000754 Rep. Cooper, Jim [D-TN-4] D TN 1986-05-06 0
99-hr-4197,T000316 Full Credit Card Cost Disclosure Act 99-hr-4197 T000316 Rep. Torres, Esteban Edward [D-CA-34] D CA 1986-05-06 0
99-hr-4197,V000087 Full Credit Card Cost Disclosure Act 99-hr-4197 V000087 Rep. Vento, Bruce F. [D-MN-4] D MN 1986-05-06 0
99-hr-4197,G000309 Full Credit Card Cost Disclosure Act 99-hr-4197 G000309 Rep. Gordon, Bart [D-TN-6] D TN 1986-05-06 0
99-hr-4197,H000878 Full Credit Card Cost Disclosure Act 99-hr-4197 H000878 Rep. Hubbard, Carroll, Jr. [D-KY-1] D KY 1986-05-06 0
99-hr-4197,J000256 Full Credit Card Cost Disclosure Act 99-hr-4197 J000256 Rep. Jones, Walter B. [D-NC-1] D NC 1986-05-06 0
99-hr-4197,L000516 Full Credit Card Cost Disclosure Act 99-hr-4197 L000516 Rep. Lundine, Stanley N. [D-NY-34] D NY 1986-05-06 0
99-hr-4197,B000711 Full Credit Card Cost Disclosure Act 99-hr-4197 B000711 Rep. Boxer, Barbara [D-CA-6] D CA 1986-05-06 0
99-hr-4197,S000230 Full Credit Card Cost Disclosure Act 99-hr-4197 S000230 Rep. Seiberling, John F. [D-OH-14] D OH 1986-05-06 0
99-hr-4197,F000339 Full Credit Card Cost Disclosure Act 99-hr-4197 F000339 Rep. Frank, Barney [D-MA-4] D MA 1986-04-17 0
99-hr-4197,F000435 Full Credit Card Cost Disclosure Act 99-hr-4197 F000435 Resident Commissioner Fuster, Jamie B. [D-PR-At Large] D PR 1986-04-17 0
99-hr-4197,M000117 Full Credit Card Cost Disclosure Act 99-hr-4197 M000117 Rep. Manton, Thomas J. [D-NY-9] D NY 1986-04-17 0
99-hr-4197,R000384 Full Credit Card Cost Disclosure Act 99-hr-4197 R000384 Rep. Roemer, Buddy [D-LA-4] D LA 1986-04-17 0
99-hr-4197,N000032 Full Credit Card Cost Disclosure Act 99-hr-4197 N000032 Rep. Nelson, Bill [D-FL-11] D FL 1986-04-17 0
99-hr-4197,F000046 Full Credit Card Cost Disclosure Act 99-hr-4197 F000046 Del. Fauntroy, Walter E. [D-DC-At Large] D DC 1986-04-17 0
99-hr-4197,B001158 Full Credit Card Cost Disclosure Act 99-hr-4197 B001158 Rep. Burton, Sala [D-CA-5] D CA 1986-04-09 0
99-hr-4197,M000826 Full Credit Card Cost Disclosure Act 99-hr-4197 M000826 Rep. Mitchell, Parren J. [D-MD-7] D MD 1986-04-09 0
99-hr-4197,O000163 Full Credit Card Cost Disclosure Act 99-hr-4197 O000163 Rep. Oxley, Michael G. [R-OH-4] R OH 1986-04-09 0
99-hr-4197,S000124 Full Credit Card Cost Disclosure Act 99-hr-4197 S000124 Rep. Scheuer, James H. [D-NY-8] D NY 1986-04-09 0
99-hr-4197,M000527 Full Credit Card Cost Disclosure Act 99-hr-4197 M000527 Rep. McKinney, Stewart B. [R-CT-4] R CT 1986-04-09 0
99-hr-4197,M000206 Full Credit Card Cost Disclosure Act 99-hr-4197 M000206 Rep. Martinez, Matthew G. [D-CA-30] D CA 1986-04-09 0
99-hr-4197,S000081 Full Credit Card Cost Disclosure Act 99-hr-4197 S000081 Rep. Savage, Gus [D-IL-2] D IL 1986-03-05 0
99-hr-4197,L000342 Full Credit Card Cost Disclosure Act 99-hr-4197 L000342 Rep. Lipinski, William O. [D-IL-5] D IL 1986-03-05 0
99-hr-4197,M001057 Full Credit Card Cost Disclosure Act 99-hr-4197 M001057 Rep. Mrazek, Robert J. [D-NY-3] D NY 1986-03-05 0
99-hr-4197,G000047 Full Credit Card Cost Disclosure Act 99-hr-4197 G000047 Rep. Garcia, Robert [D-NY-18] D NY 1986-03-05 0
99-hr-4197,M000249 Full Credit Card Cost Disclosure Act 99-hr-4197 M000249 Rep. Matsui, Robert T. [D-CA-3] D CA 1986-03-05 0
99-hr-4197,S000762 Full Credit Card Cost Disclosure Act 99-hr-4197 S000762 Rep. St Germain, Fernand J. [D-RI-1] D RI 1986-03-05 0
99-hr-4197,B000403 Full Credit Card Cost Disclosure Act 99-hr-4197 B000403 Rep. Bereuter, Doug [R-NE-1] R NE 1986-03-05 0
99-hr-4197,B000392 Full Credit Card Cost Disclosure Act 99-hr-4197 B000392 Rep. Bentley, Helen Delich [R-MD-2] R MD 1986-03-05 0
99-hr-4197,M000992 Full Credit Card Cost Disclosure Act 99-hr-4197 M000992 Rep. Morrison, Bruce A. [D-CT-3] D CT 1986-03-05 0
99-hr-4197,R000459 Full Credit Card Cost Disclosure Act 99-hr-4197 R000459 Rep. Roth, Toby [R-WI-8] R WI 1986-02-19 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);