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

30 rows where bill_id = "109-hr-3255" 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 29
  • 1 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
109-hr-3255,M001159 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 M001159 Rep. McMorris Rodgers, Cathy [R-WA-5] R WA 2006-11-13 0
109-hr-3255,C000071 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 C000071 Rep. Camp, Dave [R-MI-4] R MI 2006-05-24 0
109-hr-3255,N000182 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 N000182 Rep. Neugebauer, Randy [R-TX-19] R TX 2006-05-18 0
109-hr-3255,S001152 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 S001152 Rep. Simmons, Rob [R-CT-2] R CT 2006-05-17 0
109-hr-3255,P000591 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 P000591 Rep. Price, Tom [R-GA-6] R GA 2006-05-17 0
109-hr-3255,M001158 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 M001158 Rep. Marchant, Kenny [R-TX-24] R TX 2006-03-28 0
109-hr-3255,B000716 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 B000716 Rep. Boyd, Allen [D-FL-2] D FL 2006-03-15 0
109-hr-3255,B001247 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 B001247 Rep. Brown-Waite, Ginny [R-FL-5] R FL 2006-03-07 0
109-hr-3255,W000795 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 W000795 Rep. Wilson, Joe [R-SC-2] R SC 2006-02-28 0
109-hr-3255,E000092 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 E000092 Rep. Ehlers, Vernon J. [R-MI-3] R MI 2006-02-28 0
109-hr-3255,A000358 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 A000358 Rep. Akin, W. Todd [R-MO-2] R MO 2006-02-15 0
109-hr-3255,W000268 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 W000268 Rep. Weldon, Curt [R-PA-7] R PA 2006-02-14 0
109-hr-3255,O000159 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 O000159 Rep. Owens, Major R. [D-NY-11] D NY 2006-02-08 0
109-hr-3255,B001243 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 B001243 Rep. Blackburn, Marsha [R-TN-7] R TN 2006-02-08 0
109-hr-3255,D000603 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 D000603 Rep. Davis, Geoff [R-KY-4] R KY 2006-02-08 0
109-hr-3255,H000762 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 H000762 Rep. Hooley, Darlene [D-OR-5] D OR 2006-02-01 0
109-hr-3255,K000172 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 K000172 Rep. Kildee, Dale E. [D-MI-5] D MI 2006-01-31 0
109-hr-3255,T000460 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 T000460 Rep. Thompson, Mike [D-CA-1] D CA 2005-11-15 0
109-hr-3255,H000712 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 H000712 Rep. Holden, Tim [D-PA-17] D PA 2005-10-26 0
109-hr-3255,S001045 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 S001045 Rep. Stupak, Bart [D-MI-1] D MI 2005-10-26 0
109-hr-3255,T000038 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 T000038 Rep. Tanner, John S. [D-TN-8] D TN 2005-10-17 0
109-hr-3255,M001140 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 M001140 Rep. Moore, Dennis [D-KS-3] D KS 2005-10-06 0
109-hr-3255,C000754 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 C000754 Rep. Cooper, Jim [D-TN-5] D TN 2005-09-20 0
109-hr-3255,D000599 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 D000599 Rep. Davis, Lincoln [D-TN-4] D TN 2005-09-14 0
109-hr-3255,B001254 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 B001254 Rep. Boren, Dan [D-OK-2] D OK 2005-09-13 0
109-hr-3255,B000657 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 B000657 Rep. Boucher, Rick [D-VA-9] D VA 2005-09-07 0
109-hr-3255,M000485 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 M000485 Rep. McIntyre, Mike [D-NC-7] D NC 2005-07-22 0
109-hr-3255,S000749 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 S000749 Rep. Spratt, John M., Jr. [D-SC-5] D SC 2005-07-22 0
109-hr-3255,B001251 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 B001251 Rep. Butterfield, G. K. [D-NC-1] D NC 2005-07-14 0
109-hr-3255,S001143 Fire Protection Improvement and Correction Act of 2005 109-hr-3255 S001143 Rep. Souder, Mark E. [R-IN-3] R IN 2005-07-12 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);