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

36 rows where bill_id = "103-hr-4802" 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 1

  • 0 36
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
103-hr-4802,C000653 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 C000653 Rep. Combest, Larry [R-TX-19] R TX 1994-10-04 0
103-hr-4802,S000480 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 S000480 Rep. Slaughter, Louise McIntosh [D-NY-28] D NY 1994-10-04 0
103-hr-4802,K000259 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 K000259 Rep. Kleczka, Gerald D. [D-WI-4] D WI 1994-10-04 0
103-hr-4802,S000522 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 S000522 Rep. Smith, Christopher H. [R-NJ-4] R NJ 1994-10-04 0
103-hr-4802,H000067 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 H000067 Rep. Hall, Ralph M. [D-TX-4] D TX 1994-09-20 0
103-hr-4802,D000222 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 D000222 Rep. Dellums, Ronald V. [D-CA-9] D CA 1994-09-20 0
103-hr-4802,B000177 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 B000177 Rep. Barrett, Thomas M. [D-WI-5] D WI 1994-09-20 0
103-hr-4802,M000639 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 M000639 Rep. Menendez, Robert [D-NJ-13] D NJ 1994-09-20 0
103-hr-4802,S000033 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 S000033 Rep. Sanders, Bernard [I-VT-At Large] I VT 1994-08-17 0
103-hr-4802,S000148 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 S000148 Rep. Schumer, Charles E. [D-NY-9] D NY 1994-08-17 0
103-hr-4802,G000410 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 G000410 Rep. Green, Gene [D-TX-29] D TX 1994-08-17 0
103-hr-4802,C000059 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 C000059 Rep. Calvert, Ken [R-CA-43] R CA 1994-08-17 0
103-hr-4802,P000422 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 P000422 Rep. Pomeroy, Earl [D-ND-At Large] D ND 1994-08-17 0
103-hr-4802,K000009 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 1994-08-17 0
103-hr-4802,J000033 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 J000033 Rep. Jacobs, Andrew, Jr. [D-IN-10] D IN 1994-08-05 0
103-hr-4802,C000071 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 C000071 Rep. Camp, Dave [R-MI-4] R MI 1994-08-05 0
103-hr-4802,F000392 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 F000392 Rep. Frost, Martin [D-TX-24] D TX 1994-08-05 0
103-hr-4802,H000324 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 H000324 Rep. Hastings, Alcee L. [D-FL-23] D FL 1994-08-05 0
103-hr-4802,L000381 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 L000381 Rep. Lloyd, Marilyn [D-TN-3] D TN 1994-08-05 0
103-hr-4802,C000767 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 C000767 Rep. Coppersmith, Sam [D-AZ-1] D AZ 1994-08-05 0
103-hr-4802,K000270 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 K000270 Rep. Klink, Ron [D-PA-4] D PA 1994-08-05 0
103-hr-4802,L000267 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 L000267 Rep. Levy, David A. [R-NY-4] R NY 1994-08-02 0
103-hr-4802,S000663 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 S000663 Rep. Snowe, Olympia J. [R-ME-2] R ME 1994-08-02 0
103-hr-4802,C000107 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 C000107 Rep. Canady, Charles T. [R-FL-12] R FL 1994-08-02 0
103-hr-4802,M000342 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 M000342 Rep. McCloskey, Frank [D-IN-8] D IN 1994-08-02 0
103-hr-4802,L000556 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 L000556 Rep. LaFalce, John J. [D-NY-29] D NY 1994-08-02 0
103-hr-4802,N000015 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 N000015 Rep. Neal, Richard E. [D-MA-2] D MA 1994-08-02 0
103-hr-4802,C000754 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 C000754 Rep. Cooper, Jim [D-TN-4] D TN 1994-07-28 0
103-hr-4802,L000295 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 L000295 Rep. Lewis, Thomas F. [R-FL-16] R FL 1994-07-28 0
103-hr-4802,S001040 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 S001040 Rep. Studds, Gerry E. [D-MA-10] D MA 1994-07-28 0
103-hr-4802,E000174 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 E000174 Rep. Emerson, Bill [R-MO-8] R MO 1994-07-28 0
103-hr-4802,B000918 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 B000918 Rep. Brown, George E., Jr. [D-CA-42] D CA 1994-07-28 0
103-hr-4802,S000749 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 S000749 Rep. Spratt, John M., Jr. [D-SC-5] D SC 1994-07-28 0
103-hr-4802,H000666 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 H000666 Rep. Hobson, David L. [R-OH-7] R OH 1994-07-28 0
103-hr-4802,S000810 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 S000810 Rep. Stark, Fortney Pete [D-CA-13] D CA 1994-07-28 0
103-hr-4802,M000933 To prohibit any charges on telephone bills for calls to 800 numbers. 103-hr-4802 M000933 Rep. Moran, James P. [D-VA-8] D VA 1994-07-28 0

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);