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

26 rows where bill_id = "111-hres-459" 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 2

  • 0 25
  • 1 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
111-hres-459,P000594 Expressing support for designation of "National Safety Month". 111-hres-459 P000594 Rep. Paulsen, Erik [R-MN-3] R MN 2009-09-09 0
111-hres-459,R000582 Expressing support for designation of "National Safety Month". 111-hres-459 R000582 Rep. Roe, David P. [R-TN-1] R TN 2009-07-24 0
111-hres-459,B001232 Expressing support for designation of "National Safety Month". 111-hres-459 B001232 Rep. Biggert, Judy [R-IL-13] R IL 2009-07-23 0
111-hres-459,C000794 Expressing support for designation of "National Safety Month". 111-hres-459 C000794 Rep. Costello, Jerry F. [D-IL-12] D IL 2009-07-23 0
111-hres-459,J000285 Expressing support for designation of "National Safety Month". 111-hres-459 J000285 Rep. Johnson, Timothy V. [R-IL-15] R IL 2009-07-23 0
111-hres-459,H001040 Expressing support for designation of "National Safety Month". 111-hres-459 H001040 Rep. Hare, Phil [D-IL-17] D IL 2009-07-23 0
111-hres-459,B001245 Expressing support for designation of "National Safety Month". 111-hres-459 B001245 Del. Bordallo, Madeleine Z. [D-GU-At Large] D GU 2009-07-16 0
111-hres-459,B000911 Expressing support for designation of "National Safety Month". 111-hres-459 B000911 Rep. Brown, Corrine [D-FL-3] D FL 2009-07-16 0
111-hres-459,D000299 Expressing support for designation of "National Safety Month". 111-hres-459 D000299 Rep. Diaz-Balart, Lincoln [R-FL-21] R FL 2009-07-16 0
111-hres-459,F000454 Expressing support for designation of "National Safety Month". 111-hres-459 F000454 Rep. Foster, Bill [D-IL-14] D IL 2009-07-16 0
111-hres-459,G000556 Expressing support for designation of "National Safety Month". 111-hres-459 G000556 Rep. Grayson, Alan [D-FL-8] D FL 2009-07-16 0
111-hres-459,H001041 Expressing support for designation of "National Safety Month". 111-hres-459 H001041 Rep. Heller, Dean [R-NV-2] R NV 2009-07-16 0
111-hres-459,H001036 Expressing support for designation of "National Safety Month". 111-hres-459 H001036 Rep. Hensarling, Jeb [R-TX-5] R TX 2009-07-16 0
111-hres-459,J000289 Expressing support for designation of "National Safety Month". 111-hres-459 J000289 Rep. Jordan, Jim [R-OH-4] R OH 2009-07-16 0
111-hres-459,L000563 Expressing support for designation of "National Safety Month". 111-hres-459 L000563 Rep. Lipinski, Daniel [D-IL-3] D IL 2009-07-16 0
111-hres-459,M001138 Expressing support for designation of "National Safety Month". 111-hres-459 M001138 Rep. Manzullo, Donald A. [R-IL-16] R IL 2009-07-16 0
111-hres-459,M001165 Expressing support for designation of "National Safety Month". 111-hres-459 M001165 Rep. McCarthy, Kevin [R-CA-22] R CA 2009-07-16 0
111-hres-459,M001157 Expressing support for designation of "National Safety Month". 111-hres-459 M001157 Rep. McCaul, Michael T. [R-TX-10] R TX 2009-07-16 0
111-hres-459,M001156 Expressing support for designation of "National Safety Month". 111-hres-459 M001156 Rep. McHenry, Patrick T. [R-NC-10] R NC 2009-07-16 0
111-hres-459,P000149 Expressing support for designation of "National Safety Month". 111-hres-459 P000149 Rep. Payne, Donald M. [D-NJ-10] D NJ 2009-07-16 0
111-hres-459,Q000023 Expressing support for designation of "National Safety Month". 111-hres-459 Q000023 Rep. Quigley, Mike [D-IL-5] D IL 2009-07-16 0
111-hres-459,S001145 Expressing support for designation of "National Safety Month". 111-hres-459 S001145 Rep. Schakowsky, Janice D. [D-IL-9] D IL 2009-07-16 0
111-hres-459,S001154 Expressing support for designation of "National Safety Month". 111-hres-459 S001154 Rep. Shuster, Bill [R-PA-9] R PA 2009-07-16 0
111-hres-459,S001169 Expressing support for designation of "National Safety Month". 111-hres-459 S001169 Rep. Sestak, Joe [D-PA-7] D PA 2009-07-16 0
111-hres-459,S000364 Expressing support for designation of "National Safety Month". 111-hres-459 S000364 Rep. Shimkus, John [R-IL-19] R IL 2009-07-16 0
111-hres-459,D000096 Expressing support for designation of "National Safety Month". 111-hres-459 D000096 Rep. Davis, Danny K. [D-IL-7] D IL 2009-05-19 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);