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

18 rows where bill_id = "112-hconres-59" 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

  • 1 17
  • 0 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
112-hconres-59,F000445 Declaring that it is the policy of the United States to support and facilitate Israel in maintaining defensible borders and that it is contrary to United States policy and national security to have the borders of Israel return to the armistice lines that existed on June 4, 1967. 112-hconres-59 F000445 Rep. Forbes, J. Randy [R-VA-4] R VA 2011-06-21 0
112-hconres-59,B001274 Declaring that it is the policy of the United States to support and facilitate Israel in maintaining defensible borders and that it is contrary to United States policy and national security to have the borders of Israel return to the armistice lines that existed on June 4, 1967. 112-hconres-59 B001274 Rep. Brooks, Mo [R-AL-5] R AL 2011-06-03 1
112-hconres-59,R000053 Declaring that it is the policy of the United States to support and facilitate Israel in maintaining defensible borders and that it is contrary to United States policy and national security to have the borders of Israel return to the armistice lines that existed on June 4, 1967. 112-hconres-59 R000053 Rep. Rangel, Charles B. [D-NY-15] D NY 2011-06-03 1
112-hconres-59,L000567 Declaring that it is the policy of the United States to support and facilitate Israel in maintaining defensible borders and that it is contrary to United States policy and national security to have the borders of Israel return to the armistice lines that existed on June 4, 1967. 112-hconres-59 L000567 Rep. Lance, Leonard [R-NJ-7] R NJ 2011-06-03 1
112-hconres-59,L000564 Declaring that it is the policy of the United States to support and facilitate Israel in maintaining defensible borders and that it is contrary to United States policy and national security to have the borders of Israel return to the armistice lines that existed on June 4, 1967. 112-hconres-59 L000564 Rep. Lamborn, Doug [R-CO-5] R CO 2011-06-03 1
112-hconres-59,G000569 Declaring that it is the policy of the United States to support and facilitate Israel in maintaining defensible borders and that it is contrary to United States policy and national security to have the borders of Israel return to the armistice lines that existed on June 4, 1967. 112-hconres-59 G000569 Rep. Grimm, Michael G. [R-NY-13] R NY 2011-06-03 1
112-hconres-59,M001180 Declaring that it is the policy of the United States to support and facilitate Israel in maintaining defensible borders and that it is contrary to United States policy and national security to have the borders of Israel return to the armistice lines that existed on June 4, 1967. 112-hconres-59 M001180 Rep. McKinley, David B. [R-WV-1] R WV 2011-06-03 1
112-hconres-59,D000615 Declaring that it is the policy of the United States to support and facilitate Israel in maintaining defensible borders and that it is contrary to United States policy and national security to have the borders of Israel return to the armistice lines that existed on June 4, 1967. 112-hconres-59 D000615 Rep. Duncan, Jeff [R-SC-3] R SC 2011-06-03 1
112-hconres-59,Y000063 Declaring that it is the policy of the United States to support and facilitate Israel in maintaining defensible borders and that it is contrary to United States policy and national security to have the borders of Israel return to the armistice lines that existed on June 4, 1967. 112-hconres-59 Y000063 Rep. Yoder, Kevin [R-KS-3] R KS 2011-06-03 1
112-hconres-59,K000210 Declaring that it is the policy of the United States to support and facilitate Israel in maintaining defensible borders and that it is contrary to United States policy and national security to have the borders of Israel return to the armistice lines that existed on June 4, 1967. 112-hconres-59 K000210 Rep. King, Peter T. [R-NY-3] R NY 2011-06-03 1
112-hconres-59,W000810 Declaring that it is the policy of the United States to support and facilitate Israel in maintaining defensible borders and that it is contrary to United States policy and national security to have the borders of Israel return to the armistice lines that existed on June 4, 1967. 112-hconres-59 W000810 Rep. Woodall, Rob [R-GA-7] R GA 2011-06-03 1
112-hconres-59,G000552 Declaring that it is the policy of the United States to support and facilitate Israel in maintaining defensible borders and that it is contrary to United States policy and national security to have the borders of Israel return to the armistice lines that existed on June 4, 1967. 112-hconres-59 G000552 Rep. Gohmert, Louie [R-TX-1] R TX 2011-06-03 1
112-hconres-59,W000796 Declaring that it is the policy of the United States to support and facilitate Israel in maintaining defensible borders and that it is contrary to United States policy and national security to have the borders of Israel return to the armistice lines that existed on June 4, 1967. 112-hconres-59 W000796 Rep. Westmoreland, Lynn A. [R-GA-3] R GA 2011-06-03 1
112-hconres-59,D000613 Declaring that it is the policy of the United States to support and facilitate Israel in maintaining defensible borders and that it is contrary to United States policy and national security to have the borders of Israel return to the armistice lines that existed on June 4, 1967. 112-hconres-59 D000613 Rep. Dold, Robert J. [R-IL-10] R IL 2011-06-03 1
112-hconres-59,F000448 Declaring that it is the policy of the United States to support and facilitate Israel in maintaining defensible borders and that it is contrary to United States policy and national security to have the borders of Israel return to the armistice lines that existed on June 4, 1967. 112-hconres-59 F000448 Rep. Franks, Trent [R-AZ-2] R AZ 2011-06-03 1
112-hconres-59,S001155 Declaring that it is the policy of the United States to support and facilitate Israel in maintaining defensible borders and that it is contrary to United States policy and national security to have the borders of Israel return to the armistice lines that existed on June 4, 1967. 112-hconres-59 S001155 Rep. Sullivan, John [R-OK-1] R OK 2011-06-03 1
112-hconres-59,H001054 Declaring that it is the policy of the United States to support and facilitate Israel in maintaining defensible borders and that it is contrary to United States policy and national security to have the borders of Israel return to the armistice lines that existed on June 4, 1967. 112-hconres-59 H001054 Rep. Hayworth, Nan A. S. [R-NY-19] R NY 2011-06-03 1
112-hconres-59,T000470 Declaring that it is the policy of the United States to support and facilitate Israel in maintaining defensible borders and that it is contrary to United States policy and national security to have the borders of Israel return to the armistice lines that existed on June 4, 1967. 112-hconres-59 T000470 Rep. Tipton, Scott R. [R-CO-3] R CO 2011-06-03 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);