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

37 rows where bill_id = "109-hconres-3" 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 37
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
109-hconres-3,E000250 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 E000250 Rep. Evans, Lane [D-IL-17] D IL 2006-05-03 0
109-hconres-3,J000126 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 J000126 Rep. Johnson, Eddie Bernice [D-TX-30] D TX 2006-04-06 0
109-hconres-3,C000984 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 C000984 Rep. Cummings, Elijah E. [D-MD-7] D MD 2006-04-06 0
109-hconres-3,L000551 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 L000551 Rep. Lee, Barbara [D-CA-9] D CA 2006-04-06 0
109-hconres-3,W000207 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 W000207 Rep. Watt, Melvin L. [D-NC-12] D NC 2006-04-06 0
109-hconres-3,D000602 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 D000602 Rep. Davis, Artur [D-AL-7] D AL 2006-04-06 0
109-hconres-3,S000185 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 S000185 Rep. Scott, Robert C. "Bobby" [D-VA-3] D VA 2006-04-06 0
109-hconres-3,S001157 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 S001157 Rep. Scott, David [D-GA-13] D GA 2006-04-06 0
109-hconres-3,C001049 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 C001049 Rep. Clay, Wm. Lacy [D-MO-1] D MO 2006-04-06 0
109-hconres-3,C001061 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 C001061 Rep. Cleaver, Emanuel [D-MO-5] D MO 2006-04-06 0
109-hconres-3,B001251 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 B001251 Rep. Butterfield, G. K. [D-NC-1] D NC 2006-04-06 0
109-hconres-3,K000180 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 K000180 Rep. Kilpatrick, Carolyn C. [D-MI-13] D MI 2006-04-06 0
109-hconres-3,M001148 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 M001148 Rep. Meek, Kendrick B. [D-FL-17] D FL 2006-04-06 0
109-hconres-3,O000159 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 O000159 Rep. Owens, Major R. [D-NY-11] D NY 2006-04-06 0
109-hconres-3,C000714 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 C000714 Rep. Conyers, John, Jr. [D-MI-14] D MI 2006-04-06 0
109-hconres-3,J000032 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 J000032 Rep. Jackson-Lee, Sheila [D-TX-18] D TX 2006-04-06 0
109-hconres-3,W000187 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 W000187 Rep. Waters, Maxine [D-CA-35] D CA 2006-04-06 0
109-hconres-3,P000149 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 P000149 Rep. Payne, Donald M. [D-NJ-10] D NJ 2006-04-06 0
109-hconres-3,J000284 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 J000284 Rep. Jones, Stephanie Tubbs [D-OH-11] D OH 2006-04-06 0
109-hconres-3,J000070 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 J000070 Rep. Jefferson, William J. [D-LA-2] D LA 2006-04-06 0
109-hconres-3,L000287 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 L000287 Rep. Lewis, John [D-GA-5] D GA 2006-04-06 0
109-hconres-3,N000147 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 N000147 Del. Norton, Eleanor Holmes [D-DC-At Large] D DC 2006-04-06 0
109-hconres-3,C000537 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 C000537 Rep. Clyburn, James E. [D-SC-6] D SC 2006-04-06 0
109-hconres-3,T000193 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 T000193 Rep. Thompson, Bennie G. [D-MS-2] D MS 2006-04-06 0
109-hconres-3,R000053 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 R000053 Rep. Rangel, Charles B. [D-NY-15] D NY 2006-04-06 0
109-hconres-3,P000588 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 P000588 Rep. Pearce, Stevan [R-NM-2] R NM 2006-04-06 0
109-hconres-3,U000038 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 U000038 Rep. Udall, Mark [D-CO-2] D CO 2006-04-06 0
109-hconres-3,M001137 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 M001137 Rep. Meeks, Gregory W. [D-NY-6] D NY 2006-04-06 0
109-hconres-3,T000326 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 T000326 Rep. Towns, Edolphus [D-NY-10] D NY 2006-04-06 0
109-hconres-3,W000784 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 W000784 Rep. Wynn, Albert Russell [D-MD-4] D MD 2006-04-06 0
109-hconres-3,R000515 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 R000515 Rep. Rush, Bobby L. [D-IL-1] D IL 2006-04-06 0
109-hconres-3,D000096 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 D000096 Rep. Davis, Danny K. [D-IL-7] D IL 2006-04-06 0
109-hconres-3,H000324 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 H000324 Rep. Hastings, Alcee L. [D-FL-23] D FL 2006-04-06 0
109-hconres-3,K000172 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 K000172 Rep. Kildee, Dale E. [D-MI-5] D MI 2006-04-06 0
109-hconres-3,M000714 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 M000714 Rep. Millender-McDonald, Juanita [D-CA-37] D CA 2006-04-06 0
109-hconres-3,B000490 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 B000490 Rep. Bishop, Sanford D., Jr. [D-GA-2] D GA 2006-04-06 0
109-hconres-3,B001245 Expressing the sense of the Congress that schools in the United States should honor the contributions of individuals from the commonwealths, territories, and possessions of the United States by including such contributions in the teaching of United States history. 109-hconres-3 B001245 Del. Bordallo, Madeleine Z. [D-GU-At Large] D GU 2006-03-07 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);