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

27 rows where bill_id = "109-hr-4800" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

is_original_cosponsor 2

  • 0 17
  • 1 10
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
109-hr-4800,J000283 POPs, LRTAP POPs, and PIC Implementation Act of 2006 109-hr-4800 J000283 Rep. Jackson, Jesse L., Jr. [D-IL-2] D IL 2006-09-27 0
109-hr-4800,T000266 POPs, LRTAP POPs, and PIC Implementation Act of 2006 109-hr-4800 T000266 Rep. Tierney, John F. [D-MA-6] D MA 2006-09-14 0
109-hr-4800,H000627 POPs, LRTAP POPs, and PIC Implementation Act of 2006 109-hr-4800 H000627 Rep. Hinchey, Maurice D. [D-NY-22] D NY 2006-09-07 0
109-hr-4800,W000738 POPs, LRTAP POPs, and PIC Implementation Act of 2006 109-hr-4800 W000738 Rep. Woolsey, Lynn C. [D-CA-6] D CA 2006-09-07 0
109-hr-4800,S000810 POPs, LRTAP POPs, and PIC Implementation Act of 2006 109-hr-4800 S000810 Rep. Stark, Fortney Pete [D-CA-13] D CA 2006-07-28 0
109-hr-4800,K000336 POPs, LRTAP POPs, and PIC Implementation Act of 2006 109-hr-4800 K000336 Rep. Kucinich, Dennis J. [D-OH-10] D OH 2006-07-28 0
109-hr-4800,P000149 POPs, LRTAP POPs, and PIC Implementation Act of 2006 109-hr-4800 P000149 Rep. Payne, Donald M. [D-NJ-10] D NJ 2006-07-28 0
109-hr-4800,B001242 POPs, LRTAP POPs, and PIC Implementation Act of 2006 109-hr-4800 B001242 Rep. Bishop, Timothy H. [D-NY-1] D NY 2006-07-20 0
109-hr-4800,G000551 POPs, LRTAP POPs, and PIC Implementation Act of 2006 109-hr-4800 G000551 Rep. Grijalva, Raúl M. [D-AZ-7] D AZ 2006-07-19 0
109-hr-4800,E000179 POPs, LRTAP POPs, and PIC Implementation Act of 2006 109-hr-4800 E000179 Rep. Engel, Eliot L. [D-NY-17] D NY 2006-07-11 0
109-hr-4800,M000133 POPs, LRTAP POPs, and PIC Implementation Act of 2006 109-hr-4800 M000133 Rep. Markey, Edward J. [D-MA-7] D MA 2006-07-11 0
109-hr-4800,E000215 POPs, LRTAP POPs, and PIC Implementation Act of 2006 109-hr-4800 E000215 Rep. Eshoo, Anna G. [D-CA-14] D CA 2006-06-20 0
109-hr-4800,R000515 POPs, LRTAP POPs, and PIC Implementation Act of 2006 109-hr-4800 R000515 Rep. Rush, Bobby L. [D-IL-1] D IL 2006-03-07 0
109-hr-4800,I000026 POPs, LRTAP POPs, and PIC Implementation Act of 2006 109-hr-4800 I000026 Rep. Inslee, Jay [D-WA-1] D WA 2006-03-02 0
109-hr-4800,L000551 POPs, LRTAP POPs, and PIC Implementation Act of 2006 109-hr-4800 L000551 Rep. Lee, Barbara [D-CA-9] D CA 2006-03-02 0
109-hr-4800,B001230 POPs, LRTAP POPs, and PIC Implementation Act of 2006 109-hr-4800 B001230 Rep. Baldwin, Tammy [D-WI-2] D WI 2006-03-01 0
109-hr-4800,S001045 POPs, LRTAP POPs, and PIC Implementation Act of 2006 109-hr-4800 S001045 Rep. Stupak, Bart [D-MI-1] D MI 2006-02-28 0
109-hr-4800,P000034 POPs, LRTAP POPs, and PIC Implementation Act of 2006 109-hr-4800 P000034 Rep. Pallone, Frank, Jr. [D-NJ-6] D NJ 2006-02-16 1
109-hr-4800,C001036 POPs, LRTAP POPs, and PIC Implementation Act of 2006 109-hr-4800 C001036 Rep. Capps, Lois [D-CA-23] D CA 2006-02-16 1
109-hr-4800,T000326 POPs, LRTAP POPs, and PIC Implementation Act of 2006 109-hr-4800 T000326 Rep. Towns, Edolphus [D-NY-10] D NY 2006-02-16 1
109-hr-4800,S001145 POPs, LRTAP POPs, and PIC Implementation Act of 2006 109-hr-4800 S001145 Rep. Schakowsky, Janice D. [D-IL-9] D IL 2006-02-16 1
109-hr-4800,W000784 POPs, LRTAP POPs, and PIC Implementation Act of 2006 109-hr-4800 W000784 Rep. Wynn, Albert Russell [D-MD-4] D MD 2006-02-16 1
109-hr-4800,W000215 POPs, LRTAP POPs, and PIC Implementation Act of 2006 109-hr-4800 W000215 Rep. Waxman, Henry A. [D-CA-30] D CA 2006-02-16 1
109-hr-4800,D000355 POPs, LRTAP POPs, and PIC Implementation Act of 2006 109-hr-4800 D000355 Rep. Dingell, John D. [D-MI-15] D MI 2006-02-16 1
109-hr-4800,A000357 POPs, LRTAP POPs, and PIC Implementation Act of 2006 109-hr-4800 A000357 Rep. Allen, Thomas H. [D-ME-1] D ME 2006-02-16 1
109-hr-4800,B000944 POPs, LRTAP POPs, and PIC Implementation Act of 2006 109-hr-4800 B000944 Rep. Brown, Sherrod [D-OH-13] D OH 2006-02-16 1
109-hr-4800,D000197 POPs, LRTAP POPs, and PIC Implementation Act of 2006 109-hr-4800 D000197 Rep. DeGette, Diana [D-CO-1] D CO 2006-02-16 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);