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 = "110-hr-926" 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 17
  • 1 9
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
110-hr-926,K000363 STOPP Act of 2007 110-hr-926 K000363 Rep. Kline, John [R-MN-2] R MN 2007-10-23 0
110-hr-926,A000055 STOPP Act of 2007 110-hr-926 A000055 Rep. Aderholt, Robert B. [R-AL-4] R AL 2007-06-25 0
110-hr-926,M001147 STOPP Act of 2007 110-hr-926 M001147 Rep. McCotter, Thaddeus G. [R-MI-11] R MI 2007-06-14 0
110-hr-926,N000182 STOPP Act of 2007 110-hr-926 N000182 Rep. Neugebauer, Randy [R-TX-19] R TX 2007-05-21 0
110-hr-926,B001258 STOPP Act of 2007 110-hr-926 B001258 Rep. Boyda, Nancy E. [D-KS-2] D KS 2007-05-17 0
110-hr-926,W000798 STOPP Act of 2007 110-hr-926 W000798 Rep. Walberg, Timothy [R-MI-7] R MI 2007-05-15 0
110-hr-926,K000364 STOPP Act of 2007 110-hr-926 K000364 Rep. Kuhl, John R. "Randy", Jr. [R-NY-29] R NY 2007-05-15 0
110-hr-926,P000149 STOPP Act of 2007 110-hr-926 P000149 Rep. Payne, Donald M. [D-NJ-10] D NJ 2007-05-08 0
110-hr-926,M001157 STOPP Act of 2007 110-hr-926 M001157 Rep. McCaul, Michael T. [R-TX-10] R TX 2007-03-20 0
110-hr-926,B000657 STOPP Act of 2007 110-hr-926 B000657 Rep. Boucher, Rick [D-VA-9] D VA 2007-02-27 0
110-hr-926,S001158 STOPP Act of 2007 110-hr-926 S001158 Rep. Salazar, John T. [D-CO-3] D CO 2007-02-27 0
110-hr-926,H001030 STOPP Act of 2007 110-hr-926 H001030 Rep. Hill, Baron P. [D-IN-9] D IN 2007-02-16 0
110-hr-926,T000074 STOPP Act of 2007 110-hr-926 T000074 Rep. Taylor, Gene [D-MS-4] D MS 2007-02-16 0
110-hr-926,S001171 STOPP Act of 2007 110-hr-926 S001171 Rep. Shuler, Heath [D-NC-11] D NC 2007-02-16 0
110-hr-926,B001252 STOPP Act of 2007 110-hr-926 B001252 Rep. Barrow, John [D-GA-12] D GA 2007-02-16 0
110-hr-926,M000485 STOPP Act of 2007 110-hr-926 M000485 Rep. McIntyre, Mike [D-NC-7] D NC 2007-02-16 0
110-hr-926,B000420 STOPP Act of 2007 110-hr-926 B000420 Rep. Berry, Marion [D-AR-1] D AR 2007-02-16 0
110-hr-926,G000289 STOPP Act of 2007 110-hr-926 G000289 Rep. Goodlatte, Bob [R-VA-6] R VA 2007-02-08 1
110-hr-926,B000716 STOPP Act of 2007 110-hr-926 B000716 Rep. Boyd, Allen [D-FL-2] D FL 2007-02-08 1
110-hr-926,D000605 STOPP Act of 2007 110-hr-926 D000605 Rep. Drake, Thelma D. [R-VA-2] R VA 2007-02-08 1
110-hr-926,D000191 STOPP Act of 2007 110-hr-926 D000191 Rep. DeFazio, Peter A. [D-OR-4] D OR 2007-02-08 1
110-hr-926,S000583 STOPP Act of 2007 110-hr-926 S000583 Rep. Smith, Lamar [R-TX-21] R TX 2007-02-08 1
110-hr-926,L000491 STOPP Act of 2007 110-hr-926 L000491 Rep. Lucas, Frank D. [R-OK-3] R OK 2007-02-08 1
110-hr-926,K000362 STOPP Act of 2007 110-hr-926 K000362 Rep. King, Steve [R-IA-5] R IA 2007-02-08 1
110-hr-926,K000336 STOPP Act of 2007 110-hr-926 K000336 Rep. Kucinich, Dennis J. [D-OH-10] D OH 2007-02-08 1
110-hr-926,W000187 STOPP Act of 2007 110-hr-926 W000187 Rep. Waters, Maxine [D-CA-35] D CA 2007-02-08 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);