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

34 rows where bill_id = "99-hconres-196" 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 24
  • 1 10
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
99-hconres-196,V000006 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 V000006 Rep. Valentine, Tim [D-NC-2] D NC 1985-10-03 0
99-hconres-196,W000647 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 W000647 Rep. Wirth, Timothy [D-CO-2] D CO 1985-10-03 0
99-hconres-196,R000053 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 R000053 Rep. Rangel, Charles B. [D-NY-16] D NY 1985-10-03 0
99-hconres-196,L000263 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 L000263 Rep. Levin, Sander M. [D-MI-17] D MI 1985-10-03 0
99-hconres-196,B000410 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 B000410 Rep. Berman, Howard L. [D-CA-26] D CA 1985-10-03 0
99-hconres-196,B000160 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 B000160 Rep. Barnes, Michael D. [D-MD-8] D MD 1985-10-03 0
99-hconres-196,H000367 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 H000367 Rep. Hawkins, Augustus F. [D-CA-29] D CA 1985-09-30 0
99-hconres-196,W000215 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 W000215 Rep. Waxman, Henry A. [D-CA-24] D CA 1985-09-30 0
99-hconres-196,L000371 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 L000371 Rep. Livingston, Bob [R-LA-1] R LA 1985-09-30 0
99-hconres-196,G000511 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 G000511 Rep. Guarini, Frank J. [D-NJ-14] D NJ 1985-09-30 0
99-hconres-196,B000997 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 B000997 Rep. Bryant, John W. [D-TX-5] D TX 1985-09-30 0
99-hconres-196,F000435 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 F000435 Resident Commissioner Fuster, Jamie B. [D-PR-At Large] D PR 1985-09-30 0
99-hconres-196,M000826 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 M000826 Rep. Mitchell, Parren J. [D-MD-7] D MD 1985-09-30 0
99-hconres-196,B000298 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 B000298 Rep. Bedell, Berkley W. [D-IA-6] D IA 1985-09-30 0
99-hconres-196,M000303 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 M000303 Rep. McCain, John [R-AZ-1] R AZ 1985-09-30 0
99-hconres-196,A000209 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 A000209 Rep. Andrews, Michael [D-TX-25] D TX 1985-09-30 0
99-hconres-196,F000339 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 F000339 Rep. Frank, Barney [D-MA-4] D MA 1985-09-30 0
99-hconres-196,B000711 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 B000711 Rep. Boxer, Barbara [D-CA-6] D CA 1985-09-30 0
99-hconres-196,M001057 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 M001057 Rep. Mrazek, Robert J. [D-NY-3] D NY 1985-09-30 0
99-hconres-196,M000206 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 M000206 Rep. Martinez, Matthew G. [D-CA-30] D CA 1985-09-30 0
99-hconres-196,R000229 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 R000229 Rep. Richardson, Bill [D-NM-3] D NM 1985-09-30 0
99-hconres-196,M000992 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 M000992 Rep. Morrison, Bruce A. [D-CT-3] D CT 1985-09-30 0
99-hconres-196,R000383 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 R000383 Rep. Roe, Robert A. [D-NJ-8] D NJ 1985-09-30 0
99-hconres-196,L000237 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 L000237 Rep. Leland, Mickey [D-TX-18] D TX 1985-09-30 0
99-hconres-196,S000463 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 S000463 Rep. Skeen, Joe [R-NM-2] R NM 1985-09-20 1
99-hconres-196,S000142 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 S000142 Rep. Schroeder, Patricia [D-CO-1] D CO 1985-09-20 1
99-hconres-196,T000316 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 T000316 Rep. Torres, Esteban Edward [D-CA-34] D CA 1985-09-20 1
99-hconres-196,B001172 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 B001172 Rep. Bustamante, Albert G. [D-TX-23] D TX 1985-09-20 1
99-hconres-196,H000874 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 H000874 Rep. Hoyer, Steny H. [D-MD-5] D MD 1985-09-20 1
99-hconres-196,D000563 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 D000563 Rep. Durbin, Richard J. [D-IL-20] D IL 1985-09-20 1
99-hconres-196,C000581 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 C000581 Rep. Coelho, Anthony Lee [D-CA-15] D CA 1985-09-20 1
99-hconres-196,S000453 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 S000453 Rep. Sisisky, Norman [D-VA-4] D VA 1985-09-20 1
99-hconres-196,M000794 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 M000794 Rep. Mineta, Norman Y. [D-CA-13] D CA 1985-09-20 1
99-hconres-196,B001158 A concurrent resolution expressing the sense of the Congress in support of the provision of disaster assistance for the victims of the earthquake in Mexico on September 19, 1985. 99-hconres-196 B001158 Rep. Burton, Sala [D-CA-5] D CA 1985-09-20 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);