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

14 rows where bill_id = "111-hres-1656" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

is_original_cosponsor 2

  • 1 13
  • 0 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
111-hres-1656,S001157 Raising awareness of hypertension and helping to reverse its prevalence in the United States through education, community programs, culturally competent strategies, research, and efforts to reduce the excess salt content in foods. 111-hres-1656 S001157 Rep. Scott, David [D-GA-13] D GA 2010-09-28 0
111-hres-1656,B001234 Raising awareness of hypertension and helping to reverse its prevalence in the United States through education, community programs, culturally competent strategies, research, and efforts to reduce the excess salt content in foods. 111-hres-1656 B001234 Rep. Baca, Joe [D-CA-43] D CA 2010-09-23 1
111-hres-1656,B000490 Raising awareness of hypertension and helping to reverse its prevalence in the United States through education, community programs, culturally competent strategies, research, and efforts to reduce the excess salt content in foods. 111-hres-1656 B000490 Rep. Bishop, Sanford D., Jr. [D-GA-2] D GA 2010-09-23 1
111-hres-1656,B001245 Raising awareness of hypertension and helping to reverse its prevalence in the United States through education, community programs, culturally competent strategies, research, and efforts to reduce the excess salt content in foods. 111-hres-1656 B001245 Del. Bordallo, Madeleine Z. [D-GU-At Large] D GU 2010-09-23 1
111-hres-1656,B000911 Raising awareness of hypertension and helping to reverse its prevalence in the United States through education, community programs, culturally competent strategies, research, and efforts to reduce the excess salt content in foods. 111-hres-1656 B000911 Rep. Brown, Corrine [D-FL-3] D FL 2010-09-23 1
111-hres-1656,C000380 Raising awareness of hypertension and helping to reverse its prevalence in the United States through education, community programs, culturally competent strategies, research, and efforts to reduce the excess salt content in foods. 111-hres-1656 C000380 Del. Christensen, Donna M. [D-VI-At Large] D VI 2010-09-23 1
111-hres-1656,C001049 Raising awareness of hypertension and helping to reverse its prevalence in the United States through education, community programs, culturally competent strategies, research, and efforts to reduce the excess salt content in foods. 111-hres-1656 C001049 Rep. Clay, Wm. Lacy [D-MO-1] D MO 2010-09-23 1
111-hres-1656,F000455 Raising awareness of hypertension and helping to reverse its prevalence in the United States through education, community programs, culturally competent strategies, research, and efforts to reduce the excess salt content in foods. 111-hres-1656 F000455 Rep. Fudge, Marcia L. [D-OH-11] D OH 2010-09-23 1
111-hres-1656,G000551 Raising awareness of hypertension and helping to reverse its prevalence in the United States through education, community programs, culturally competent strategies, research, and efforts to reduce the excess salt content in foods. 111-hres-1656 G000551 Rep. Grijalva, Raúl M. [D-AZ-7] D AZ 2010-09-23 1
111-hres-1656,J000126 Raising awareness of hypertension and helping to reverse its prevalence in the United States through education, community programs, culturally competent strategies, research, and efforts to reduce the excess salt content in foods. 111-hres-1656 J000126 Rep. Johnson, Eddie Bernice [D-TX-30] D TX 2010-09-23 1
111-hres-1656,M001137 Raising awareness of hypertension and helping to reverse its prevalence in the United States through education, community programs, culturally competent strategies, research, and efforts to reduce the excess salt content in foods. 111-hres-1656 M001137 Rep. Meeks, Gregory W. [D-NY-6] D NY 2010-09-23 1
111-hres-1656,N000147 Raising awareness of hypertension and helping to reverse its prevalence in the United States through education, community programs, culturally competent strategies, research, and efforts to reduce the excess salt content in foods. 111-hres-1656 N000147 Del. Norton, Eleanor Holmes [D-DC-At Large] D DC 2010-09-23 1
111-hres-1656,R000053 Raising awareness of hypertension and helping to reverse its prevalence in the United States through education, community programs, culturally competent strategies, research, and efforts to reduce the excess salt content in foods. 111-hres-1656 R000053 Rep. Rangel, Charles B. [D-NY-15] D NY 2010-09-23 1
111-hres-1656,H000636 Raising awareness of hypertension and helping to reverse its prevalence in the United States through education, community programs, culturally competent strategies, research, and efforts to reduce the excess salt content in foods. 111-hres-1656 H000636 Rep. Hinojosa, Ruben [D-TX-15] D TX 2010-09-23 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);