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

28 rows where bill_id = "111-hr-5582" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: state, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

  • 1 19
  • 0 9
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
111-hr-5582,F000444 Private Property Rights Protection and Government Accountability Act 111-hr-5582 F000444 Rep. Flake, Jeff [R-AZ-6] R AZ 2010-07-29 0
111-hr-5582,C000556 Private Property Rights Protection and Government Accountability Act 111-hr-5582 C000556 Rep. Coble, Howard [R-NC-6] R NC 2010-07-01 0
111-hr-5582,L000566 Private Property Rights Protection and Government Accountability Act 111-hr-5582 L000566 Rep. Latta, Robert E. [R-OH-5] R OH 2010-07-01 0
111-hr-5582,B001239 Private Property Rights Protection and Government Accountability Act 111-hr-5582 B001239 Rep. Barrett, J. Gresham [R-SC-3] R SC 2010-07-01 0
111-hr-5582,J000285 Private Property Rights Protection and Government Accountability Act 111-hr-5582 J000285 Rep. Johnson, Timothy V. [R-IL-15] R IL 2010-07-01 0
111-hr-5582,B001243 Private Property Rights Protection and Government Accountability Act 111-hr-5582 B001243 Rep. Blackburn, Marsha [R-TN-7] R TN 2010-06-25 0
111-hr-5582,A000361 Private Property Rights Protection and Government Accountability Act 111-hr-5582 A000361 Rep. Alexander, Rodney [R-LA-5] R LA 2010-06-25 0
111-hr-5582,C001062 Private Property Rights Protection and Government Accountability Act 111-hr-5582 C001062 Rep. Conaway, K. Michael [R-TX-11] R TX 2010-06-25 0
111-hr-5582,M001157 Private Property Rights Protection and Government Accountability Act 111-hr-5582 M001157 Rep. McCaul, Michael T. [R-TX-10] R TX 2010-06-25 0
111-hr-5582,B001262 Private Property Rights Protection and Government Accountability Act 111-hr-5582 B001262 Rep. Broun, Paul C. [R-GA-10] R GA 2010-06-23 1
111-hr-5582,L000491 Private Property Rights Protection and Government Accountability Act 111-hr-5582 L000491 Rep. Lucas, Frank D. [R-OK-3] R OK 2010-06-23 1
111-hr-5582,K000363 Private Property Rights Protection and Government Accountability Act 111-hr-5582 K000363 Rep. Kline, John [R-MN-2] R MN 2010-06-23 1
111-hr-5582,S000364 Private Property Rights Protection and Government Accountability Act 111-hr-5582 S000364 Rep. Shimkus, John [R-IL-19] R IL 2010-06-23 1
111-hr-5582,C001048 Private Property Rights Protection and Government Accountability Act 111-hr-5582 C001048 Rep. Culberson, John Abney [R-TX-7] R TX 2010-06-23 1
111-hr-5582,B001149 Private Property Rights Protection and Government Accountability Act 111-hr-5582 B001149 Rep. Burton, Dan [R-IN-5] R IN 2010-06-23 1
111-hr-5582,R000583 Private Property Rights Protection and Government Accountability Act 111-hr-5582 R000583 Rep. Rooney, Thomas J. [R-FL-16] R FL 2010-06-23 1
111-hr-5582,M001158 Private Property Rights Protection and Government Accountability Act 111-hr-5582 M001158 Rep. Marchant, Kenny [R-TX-24] R TX 2010-06-23 1
111-hr-5582,P000599 Private Property Rights Protection and Government Accountability Act 111-hr-5582 P000599 Rep. Posey, Bill [R-FL-15] R FL 2010-06-23 1
111-hr-5582,H000528 Private Property Rights Protection and Government Accountability Act 111-hr-5582 H000528 Rep. Herger, Wally [R-CA-2] R CA 2010-06-23 1
111-hr-5582,S001164 Private Property Rights Protection and Government Accountability Act 111-hr-5582 S001164 Rep. Schmidt, Jean [R-OH-2] R OH 2010-06-23 1
111-hr-5582,S000275 Private Property Rights Protection and Government Accountability Act 111-hr-5582 S000275 Rep. Shadegg, John B. [R-AZ-3] R AZ 2010-06-23 1
111-hr-5582,F000448 Private Property Rights Protection and Government Accountability Act 111-hr-5582 F000448 Rep. Franks, Trent [R-AZ-2] R AZ 2010-06-23 1
111-hr-5582,H000067 Private Property Rights Protection and Government Accountability Act 111-hr-5582 H000067 Rep. Hall, Ralph M. [R-TX-4] R TX 2010-06-23 1
111-hr-5582,R000572 Private Property Rights Protection and Government Accountability Act 111-hr-5582 R000572 Rep. Rogers, Mike J. [R-MI-8] R MI 2010-06-23 1
111-hr-5582,B001248 Private Property Rights Protection and Government Accountability Act 111-hr-5582 B001248 Rep. Burgess, Michael C. [R-TX-26] R TX 2010-06-23 1
111-hr-5582,G000552 Private Property Rights Protection and Government Accountability Act 111-hr-5582 G000552 Rep. Gohmert, Louie [R-TX-1] R TX 2010-06-23 1
111-hr-5582,G000550 Private Property Rights Protection and Government Accountability Act 111-hr-5582 G000550 Rep. Gingrey, Phil [R-GA-11] R GA 2010-06-23 1
111-hr-5582,F000456 Private Property Rights Protection and Government Accountability Act 111-hr-5582 F000456 Rep. Fleming, John [R-LA-4] R LA 2010-06-23 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);