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

23 rows where bill_id = "108-hr-1007" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: state, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

  • 0 22
  • 1 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
108-hr-1007,M000309 Homeland Security Block Grant Act of 2003 108-hr-1007 M000309 Rep. McCarthy, Carolyn [D-NY-4] D NY 2003-06-04 0
108-hr-1007,M001137 Homeland Security Block Grant Act of 2003 108-hr-1007 M001137 Rep. Meeks, Gregory W. [D-NY-6] D NY 2003-05-21 0
108-hr-1007,B001242 Homeland Security Block Grant Act of 2003 108-hr-1007 B001242 Rep. Bishop, Timothy H. [D-NY-1] D NY 2003-03-27 0
108-hr-1007,F000262 Homeland Security Block Grant Act of 2003 108-hr-1007 F000262 Rep. Ford, Harold E., Jr. [D-TN-9] D TN 2003-03-27 0
108-hr-1007,M000714 Homeland Security Block Grant Act of 2003 108-hr-1007 M000714 Rep. Millender-McDonald, Juanita [D-CA-37] D CA 2003-03-20 0
108-hr-1007,L000397 Homeland Security Block Grant Act of 2003 108-hr-1007 L000397 Rep. Lofgren, Zoe [D-CA-16] D CA 2003-03-20 0
108-hr-1007,W000794 Homeland Security Block Grant Act of 2003 108-hr-1007 W000794 Rep. Watson, Diane E. [D-CA-33] D CA 2003-03-20 0
108-hr-1007,H001034 Homeland Security Block Grant Act of 2003 108-hr-1007 H001034 Rep. Honda, Michael M. [D-CA-15] D CA 2003-03-20 0
108-hr-1007,R000486 Homeland Security Block Grant Act of 2003 108-hr-1007 R000486 Rep. Roybal-Allard, Lucille [D-CA-34] D CA 2003-03-20 0
108-hr-1007,E000215 Homeland Security Block Grant Act of 2003 108-hr-1007 E000215 Rep. Eshoo, Anna G. [D-CA-14] D CA 2003-03-20 0
108-hr-1007,D000598 Homeland Security Block Grant Act of 2003 108-hr-1007 D000598 Rep. Davis, Susan A. [D-CA-53] D CA 2003-03-20 0
108-hr-1007,W000738 Homeland Security Block Grant Act of 2003 108-hr-1007 W000738 Rep. Woolsey, Lynn C. [D-CA-6] D CA 2003-03-20 0
108-hr-1007,F000030 Homeland Security Block Grant Act of 2003 108-hr-1007 F000030 Rep. Farr, Sam [D-CA-17] D CA 2003-03-20 0
108-hr-1007,S001156 Homeland Security Block Grant Act of 2003 108-hr-1007 S001156 Rep. Sánchez, Linda T. [D-CA-39] D CA 2003-03-18 0
108-hr-1007,C001055 Homeland Security Block Grant Act of 2003 108-hr-1007 C001055 Rep. Case, Ed [D-HI-2] D HI 2003-03-18 0
108-hr-1007,I000057 Homeland Security Block Grant Act of 2003 108-hr-1007 I000057 Rep. Israel, Steve [D-NY-2] D NY 2003-03-11 0
108-hr-1007,C001038 Homeland Security Block Grant Act of 2003 108-hr-1007 C001038 Rep. Crowley, Joseph [D-NY-7] D NY 2003-03-11 0
108-hr-1007,M000316 Homeland Security Block Grant Act of 2003 108-hr-1007 M000316 Rep. McCarthy, Karen [D-MO-5] D MO 2003-03-11 0
108-hr-1007,F000010 Homeland Security Block Grant Act of 2003 108-hr-1007 F000010 Del. Faleomavaega, Eni F. H. [D-AS-At Large] D AS 2003-03-11 0
108-hr-1007,F000392 Homeland Security Block Grant Act of 2003 108-hr-1007 F000392 Rep. Frost, Martin [D-TX-24] D TX 2003-03-11 0
108-hr-1007,R000576 Homeland Security Block Grant Act of 2003 108-hr-1007 R000576 Rep. Ruppersberger, C. A. Dutch [D-MD-2] D MD 2003-03-11 0
108-hr-1007,B000410 Homeland Security Block Grant Act of 2003 108-hr-1007 B000410 Rep. Berman, Howard L. [D-CA-28] D CA 2003-03-11 0
108-hr-1007,S000030 Homeland Security Block Grant Act of 2003 108-hr-1007 S000030 Rep. Sanchez, Loretta [D-CA-47] D CA 2003-02-27 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);