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

20 rows where bill_id = "108-hr-1242" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

is_original_cosponsor 1

  • 0 20
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
108-hr-1242,M001154 Child Care Public-Private Partnership Act of 2003 108-hr-1242 M001154 Rep. Miller, Brad [D-NC-13] D NC 2004-07-13 0
108-hr-1242,G000535 Child Care Public-Private Partnership Act of 2003 108-hr-1242 G000535 Rep. Gutierrez, Luis V. [D-IL-4] D IL 2003-06-03 0
108-hr-1242,O000159 Child Care Public-Private Partnership Act of 2003 108-hr-1242 O000159 Rep. Owens, Major R. [D-NY-11] D NY 2003-04-10 0
108-hr-1242,K000009 Child Care Public-Private Partnership Act of 2003 108-hr-1242 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 2003-04-10 0
108-hr-1242,C000754 Child Care Public-Private Partnership Act of 2003 108-hr-1242 C000754 Rep. Cooper, Jim [D-TN-5] D TN 2003-04-10 0
108-hr-1242,A000357 Child Care Public-Private Partnership Act of 2003 108-hr-1242 A000357 Rep. Allen, Thomas H. [D-ME-1] D ME 2003-04-10 0
108-hr-1242,E000250 Child Care Public-Private Partnership Act of 2003 108-hr-1242 E000250 Rep. Evans, Lane [D-IL-17] D IL 2003-04-10 0
108-hr-1242,F000010 Child Care Public-Private Partnership Act of 2003 108-hr-1242 F000010 Del. Faleomavaega, Eni F. H. [D-AS-At Large] D AS 2003-03-26 0
108-hr-1242,B001245 Child Care Public-Private Partnership Act of 2003 108-hr-1242 B001245 Del. Bordallo, Madeleine Z. [D-GU-At Large] D GU 2003-03-26 0
108-hr-1242,M000627 Child Care Public-Private Partnership Act of 2003 108-hr-1242 M000627 Rep. Meehan, Martin T. [D-MA-5] D MA 2003-03-26 0
108-hr-1242,D000598 Child Care Public-Private Partnership Act of 2003 108-hr-1242 D000598 Rep. Davis, Susan A. [D-CA-53] D CA 2003-03-26 0
108-hr-1242,B000911 Child Care Public-Private Partnership Act of 2003 108-hr-1242 B000911 Rep. Brown, Corrine [D-FL-3] D FL 2003-03-20 0
108-hr-1242,H000627 Child Care Public-Private Partnership Act of 2003 108-hr-1242 H000627 Rep. Hinchey, Maurice D. [D-NY-22] D NY 2003-03-20 0
108-hr-1242,F000392 Child Care Public-Private Partnership Act of 2003 108-hr-1242 F000392 Rep. Frost, Martin [D-TX-24] D TX 2003-03-20 0
108-hr-1242,C001037 Child Care Public-Private Partnership Act of 2003 108-hr-1242 C001037 Rep. Capuano, Michael E. [D-MA-8] D MA 2003-03-20 0
108-hr-1242,W000738 Child Care Public-Private Partnership Act of 2003 108-hr-1242 W000738 Rep. Woolsey, Lynn C. [D-CA-6] D CA 2003-03-20 0
108-hr-1242,G000551 Child Care Public-Private Partnership Act of 2003 108-hr-1242 G000551 Rep. Grijalva, Raúl M. [D-AZ-7] D AZ 2003-03-20 0
108-hr-1242,M000714 Child Care Public-Private Partnership Act of 2003 108-hr-1242 M000714 Rep. Millender-McDonald, Juanita [D-CA-37] D CA 2003-03-20 0
108-hr-1242,S001145 Child Care Public-Private Partnership Act of 2003 108-hr-1242 S001145 Rep. Schakowsky, Janice D. [D-IL-9] D IL 2003-03-20 0
108-hr-1242,J000032 Child Care Public-Private Partnership Act of 2003 108-hr-1242 J000032 Rep. Jackson-Lee, Sheila [D-TX-18] D TX 2003-03-20 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);