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

24 rows where bill_id = "109-hr-6169" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

is_original_cosponsor 2

  • 0 15
  • 1 9
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
109-hr-6169,G000289 Post-Abortion Depression Research and Care Act 109-hr-6169 G000289 Rep. Goodlatte, Bob [R-VA-6] R VA 2006-09-27 0
109-hr-6169,H001029 Post-Abortion Depression Research and Care Act 109-hr-6169 H001029 Rep. Hayes, Robin [R-NC-8] R NC 2006-09-27 0
109-hr-6169,D000597 Post-Abortion Depression Research and Care Act 109-hr-6169 D000597 Rep. Davis, Jo Ann [R-VA-1] R VA 2006-09-27 0
109-hr-6169,N000182 Post-Abortion Depression Research and Care Act 109-hr-6169 N000182 Rep. Neugebauer, Randy [R-TX-19] R TX 2006-09-27 0
109-hr-6169,F000448 Post-Abortion Depression Research and Care Act 109-hr-6169 F000448 Rep. Franks, Trent [R-AZ-2] R AZ 2006-09-27 0
109-hr-6169,K000358 Post-Abortion Depression Research and Care Act 109-hr-6169 K000358 Rep. Kennedy, Mark R. [R-MN-6] R MN 2006-09-27 0
109-hr-6169,W000795 Post-Abortion Depression Research and Care Act 109-hr-6169 W000795 Rep. Wilson, Joe [R-SC-2] R SC 2006-09-27 0
109-hr-6169,F000452 Post-Abortion Depression Research and Care Act 109-hr-6169 F000452 Resident Commissioner Fortuno, Luis G. [R-PR-At Large] R PR 2006-09-27 0
109-hr-6169,B001149 Post-Abortion Depression Research and Care Act 109-hr-6169 B001149 Rep. Burton, Dan [R-IN-5] R IN 2006-09-27 0
109-hr-6169,P000588 Post-Abortion Depression Research and Care Act 109-hr-6169 P000588 Rep. Pearce, Stevan [R-NM-2] R NM 2006-09-27 0
109-hr-6169,G000548 Post-Abortion Depression Research and Care Act 109-hr-6169 G000548 Rep. Garrett, Scott [R-NJ-5] R NJ 2006-09-27 0
109-hr-6169,R000409 Post-Abortion Depression Research and Care Act 109-hr-6169 R000409 Rep. Rohrabacher, Dana [R-CA-46] R CA 2006-09-27 0
109-hr-6169,M001156 Post-Abortion Depression Research and Care Act 109-hr-6169 M001156 Rep. McHenry, Patrick T. [R-NC-10] R NC 2006-09-27 0
109-hr-6169,M001158 Post-Abortion Depression Research and Care Act 109-hr-6169 M001158 Rep. Marchant, Kenny [R-TX-24] R TX 2006-09-27 0
109-hr-6169,R000570 Post-Abortion Depression Research and Care Act 109-hr-6169 R000570 Rep. Ryan, Paul [R-WI-1] R WI 2006-09-27 0
109-hr-6169,S000522 Post-Abortion Depression Research and Care Act 109-hr-6169 S000522 Rep. Smith, Christopher H. [R-NJ-4] R NJ 2006-09-25 1
109-hr-6169,S001143 Post-Abortion Depression Research and Care Act 109-hr-6169 S001143 Rep. Souder, Mark E. [R-IN-3] R IN 2006-09-25 1
109-hr-6169,R000566 Post-Abortion Depression Research and Care Act 109-hr-6169 R000566 Rep. Ryun, Jim [R-KS-2] R KS 2006-09-25 1
109-hr-6169,A000358 Post-Abortion Depression Research and Care Act 109-hr-6169 A000358 Rep. Akin, W. Todd [R-MO-2] R MO 2006-09-25 1
109-hr-6169,M001152 Post-Abortion Depression Research and Care Act 109-hr-6169 M001152 Rep. Musgrave, Marilyn N. [R-CO-4] R CO 2006-09-25 1
109-hr-6169,H001033 Post-Abortion Depression Research and Care Act 109-hr-6169 H001033 Rep. Hart, Melissa A. [R-PA-4] R PA 2006-09-25 1
109-hr-6169,T000260 Post-Abortion Depression Research and Care Act 109-hr-6169 T000260 Rep. Tiahrt, Todd [R-KS-4] R KS 2006-09-25 1
109-hr-6169,P000587 Post-Abortion Depression Research and Care Act 109-hr-6169 P000587 Rep. Pence, Mike [R-IN-6] R IN 2006-09-25 1
109-hr-6169,G000552 Post-Abortion Depression Research and Care Act 109-hr-6169 G000552 Rep. Gohmert, Louie [R-TX-1] R TX 2006-09-25 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);