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

40 rows where bill_id = "103-hconres-281" 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 39
  • 1 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
103-hconres-281,D000275 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 D000275 Rep. Deutsch, Peter [D-FL-20] D FL 1994-10-05 0
103-hconres-281,Z000008 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 Z000008 Rep. Zimmer, Dick [R-NJ-12] R NJ 1994-09-30 0
103-hconres-281,K000262 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 K000262 Rep. Klein, Herbert C. [D-NJ-8] D NJ 1994-09-30 0
103-hconres-281,P000034 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 P000034 Rep. Pallone, Frank, Jr. [D-NJ-6] D NJ 1994-09-29 0
103-hconres-281,F000392 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 F000392 Rep. Frost, Martin [D-TX-24] D TX 1994-09-29 0
103-hconres-281,F000116 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 F000116 Rep. Filner, Bob [D-CA-50] D CA 1994-09-29 0
103-hconres-281,E000179 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 E000179 Rep. Engel, Eliot L. [D-NY-17] D NY 1994-09-29 0
103-hconres-281,B001226 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 B001226 Rep. Barca, Peter [D-WI-1] D WI 1994-09-29 0
103-hconres-281,F000434 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 F000434 Rep. Furse, Elizabeth [D-OR-1] D OR 1994-09-22 0
103-hconres-281,F000128 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 F000128 Rep. Fingerhut, Eric D. [D-OH-19] D OH 1994-09-22 0
103-hconres-281,C000767 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 C000767 Rep. Coppersmith, Sam [D-AZ-1] D AZ 1994-09-22 0
103-hconres-281,G000212 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 G000212 Rep. Gilman, Benjamin A. [R-NY-20] R NY 1994-09-21 0
103-hconres-281,M000843 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 M000843 Rep. Molinari, Susan [R-NY-13] R NY 1994-09-21 0
103-hconres-281,H000712 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 H000712 Rep. Holden, Tim [D-PA-6] D PA 1994-09-21 0
103-hconres-281,F000339 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 F000339 Rep. Frank, Barney [D-MA-4] D MA 1994-09-21 0
103-hconres-281,L000480 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 L000480 Rep. Lowey, Nita M. [D-NY-18] D NY 1994-09-20 0
103-hconres-281,M000117 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 M000117 Rep. Manton, Thomas J. [D-NY-7] D NY 1994-09-20 0
103-hconres-281,B000008 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 B000008 Rep. Bacchus, Jim [D-FL-15] D FL 1994-09-20 0
103-hconres-281,C000107 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 C000107 Rep. Canady, Charles T. [R-FL-12] R FL 1994-09-20 0
103-hconres-281,K000312 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 K000312 Rep. Kopetski, Mike [D-OR-5] D OR 1994-09-20 0
103-hconres-281,K000352 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 K000352 Rep. Kyl, Jon [R-AZ-4] R AZ 1994-09-20 0
103-hconres-281,P000444 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 P000444 Rep. Porter, John Edward [R-IL-10] R IL 1994-09-20 0
103-hconres-281,J000126 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 J000126 Rep. Johnson, Eddie Bernice [D-TX-30] D TX 1994-09-20 0
103-hconres-281,W000779 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 W000779 Rep. Wyden, Ron [D-OR-3] D OR 1994-09-20 0
103-hconres-281,M000100 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 M000100 Rep. Mann, David [D-OH-1] D OH 1994-09-20 0
103-hconres-281,P000555 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 P000555 Rep. Pryce, Deborah [R-OH-15] R OH 1994-09-20 0
103-hconres-281,M000590 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 M000590 Rep. McNulty, Michael R. [D-NY-21] D NY 1994-09-13 0
103-hconres-281,A000210 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 A000210 Rep. Andrews, Robert E. [D-NJ-1] D NJ 1994-09-13 0
103-hconres-281,L000267 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 L000267 Rep. Levy, David A. [R-NY-4] R NY 1994-09-13 0
103-hconres-281,E000174 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 E000174 Rep. Emerson, Bill [R-MO-8] R MO 1994-09-12 0
103-hconres-281,L000305 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 L000305 Rep. Lightfoot, Jim [R-IA-3] R IA 1994-09-12 0
103-hconres-281,R000053 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 R000053 Rep. Rangel, Charles B. [D-NY-15] D NY 1994-09-12 0
103-hconres-281,S000097 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 S000097 Rep. Saxton, Jim [R-NJ-3] R NJ 1994-09-12 0
103-hconres-281,R000435 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 R000435 Rep. Ros-Lehtinen, Ileana [R-FL-18] R FL 1994-09-12 0
103-hconres-281,C000754 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 C000754 Rep. Cooper, Jim [D-TN-4] D TN 1994-09-12 0
103-hconres-281,S000148 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 S000148 Rep. Schumer, Charles E. [D-NY-9] D NY 1994-09-12 0
103-hconres-281,Y000013 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 Y000013 Rep. Yates, Sidney R. [D-IL-9] D IL 1994-09-12 0
103-hconres-281,S000125 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 S000125 Rep. Schiff, Steven [R-NM-1] R NM 1994-09-12 0
103-hconres-281,M000628 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 M000628 Rep. Meek, Carrie P. [D-FL-17] D FL 1994-09-12 0
103-hconres-281,J000187 Expressing the sense of the Congress that the United States Embassy in Israel should, at the earliest possible date, be relocated to the city of Jerusalem. 103-hconres-281 J000187 Rep. Johnston, Harry [D-FL-19] D FL 1994-08-11 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);