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

27 rows where bill_id = "99-hr-3349" 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 18
  • 1 9
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
99-hr-3349,R000481 National Commission to Prevent Infant Mortality 99-hr-3349 R000481 Rep. Rowland, J. Roy [D-GA-8] D GA 1986-05-08 0
99-hr-3349,A000214 National Commission to Prevent Infant Mortality 99-hr-3349 A000214 Rep. Applegate, Douglas [D-OH-18] D OH 1985-12-19 0
99-hr-3349,W000426 National Commission to Prevent Infant Mortality 99-hr-3349 W000426 Rep. Whittaker, Bob [R-KS-5] R KS 1985-12-19 0
99-hr-3349,B000657 National Commission to Prevent Infant Mortality 99-hr-3349 B000657 Rep. Boucher, Rick [D-VA-9] D VA 1985-12-19 0
99-hr-3349,P000574 National Commission to Prevent Infant Mortality 99-hr-3349 P000574 Rep. Pursell, Carl D. [R-MI-2] R MI 1985-12-11 0
99-hr-3349,C000809 National Commission to Prevent Infant Mortality 99-hr-3349 C000809 Rep. Courter, Jim [R-NJ-12] R NJ 1985-12-11 0
99-hr-3349,G000025 National Commission to Prevent Infant Mortality 99-hr-3349 G000025 Rep. Gallo, Dean A. [R-NJ-11] R NJ 1985-12-11 0
99-hr-3349,C000079 National Commission to Prevent Infant Mortality 99-hr-3349 C000079 Rep. Campbell, Carroll A., Jr. [R-SC-4] R SC 1985-12-11 0
99-hr-3349,M001057 National Commission to Prevent Infant Mortality 99-hr-3349 M001057 Rep. Mrazek, Robert J. [D-NY-3] D NY 1985-12-11 0
99-hr-3349,M000206 National Commission to Prevent Infant Mortality 99-hr-3349 M000206 Rep. Martinez, Matthew G. [D-CA-30] D CA 1985-12-03 0
99-hr-3349,R000383 National Commission to Prevent Infant Mortality 99-hr-3349 R000383 Rep. Roe, Robert A. [D-NJ-8] D NJ 1985-12-03 0
99-hr-3349,S001077 National Commission to Prevent Infant Mortality 99-hr-3349 S001077 Del. Sunia, Foto I. F. [D-AS-At Large] D AS 1985-12-03 0
99-hr-3349,S000522 National Commission to Prevent Infant Mortality 99-hr-3349 S000522 Rep. Smith, Christopher H. [R-NJ-4] R NJ 1985-12-03 0
99-hr-3349,B000204 National Commission to Prevent Infant Mortality 99-hr-3349 B000204 Rep. Bartlett, Steve [R-TX-3] R TX 1985-12-03 0
99-hr-3349,B000556 National Commission to Prevent Infant Mortality 99-hr-3349 B000556 Rep. Bliley, Tom [R-VA-3] R VA 1985-12-03 0
99-hr-3349,K000307 National Commission to Prevent Infant Mortality 99-hr-3349 K000307 Rep. Kolter, Joseph P. [D-PA-4] D PA 1985-12-03 0
99-hr-3349,R000482 National Commission to Prevent Infant Mortality 99-hr-3349 R000482 Rep. Rowland, John G. [R-CT-5] R CT 1985-12-03 0
99-hr-3349,G000272 National Commission to Prevent Infant Mortality 99-hr-3349 G000272 Rep. Gonzalez, Henry B. [D-TX-20] D TX 1985-12-03 0
99-hr-3349,W000672 National Commission to Prevent Infant Mortality 99-hr-3349 W000672 Rep. Wolf, Frank R. [R-VA-10] R VA 1985-11-06 1
99-hr-3349,K000319 National Commission to Prevent Infant Mortality 99-hr-3349 K000319 Rep. Kostmayer, Peter H. [D-PA-8] D PA 1985-11-06 1
99-hr-3349,L000116 National Commission to Prevent Infant Mortality 99-hr-3349 L000116 Rep. Latta, Delbert L. [R-OH-5] R OH 1985-11-06 1
99-hr-3349,L000020 National Commission to Prevent Infant Mortality 99-hr-3349 L000020 Rep. Lagomarsino, Robert J. [R-CA-19] R CA 1985-11-06 1
99-hr-3349,B000431 National Commission to Prevent Infant Mortality 99-hr-3349 B000431 Rep. Bevill, Tom [D-AL-4] D AL 1985-11-06 1
99-hr-3349,K000190 National Commission to Prevent Infant Mortality 99-hr-3349 K000190 Rep. Kindness, Thomas N. [R-OH-8] R OH 1985-11-06 1
99-hr-3349,D000294 National Commission to Prevent Infant Mortality 99-hr-3349 D000294 Rep. DeWine, Mike [R-OH-7] R OH 1985-11-06 1
99-hr-3349,M000834 National Commission to Prevent Infant Mortality 99-hr-3349 M000834 Rep. Moakley, John Joseph [D-MA-9] D MA 1985-11-06 1
99-hr-3349,T000326 National Commission to Prevent Infant Mortality 99-hr-3349 T000326 Rep. Towns, Edolphus [D-NY-11] D NY 1985-11-06 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);