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

21 rows where bill_id = "111-hr-4889" 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 14
  • 0 7
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
111-hr-4889,B001248 GSE Bailout Elimination and Taxpayer Protection Act 111-hr-4889 B001248 Rep. Burgess, Michael C. [R-TX-26] R TX 2010-05-13 0
111-hr-4889,M001147 GSE Bailout Elimination and Taxpayer Protection Act 111-hr-4889 M001147 Rep. McCotter, Thaddeus G. [R-MI-11] R MI 2010-04-22 0
111-hr-4889,S000244 GSE Bailout Elimination and Taxpayer Protection Act 111-hr-4889 S000244 Rep. Sensenbrenner, F. James, Jr. [R-WI-5] R WI 2010-04-15 0
111-hr-4889,B001149 GSE Bailout Elimination and Taxpayer Protection Act 111-hr-4889 B001149 Rep. Burton, Dan [R-IN-5] R IN 2010-04-15 0
111-hr-4889,B000013 GSE Bailout Elimination and Taxpayer Protection Act 111-hr-4889 B000013 Rep. Bachus, Spencer [R-AL-6] R AL 2010-03-25 0
111-hr-4889,M001177 GSE Bailout Elimination and Taxpayer Protection Act 111-hr-4889 M001177 Rep. McClintock, Tom [R-CA-4] R CA 2010-03-25 0
111-hr-4889,J000255 GSE Bailout Elimination and Taxpayer Protection Act 111-hr-4889 J000255 Rep. Jones, Walter B., Jr. [R-NC-3] R NC 2010-03-25 0
111-hr-4889,P000587 GSE Bailout Elimination and Taxpayer Protection Act 111-hr-4889 P000587 Rep. Pence, Mike [R-IN-6] R IN 2010-03-19 1
111-hr-4889,P000591 GSE Bailout Elimination and Taxpayer Protection Act 111-hr-4889 P000591 Rep. Price, Tom [R-GA-6] R GA 2010-03-19 1
111-hr-4889,F000444 GSE Bailout Elimination and Taxpayer Protection Act 111-hr-4889 F000444 Rep. Flake, Jeff [R-AZ-6] R AZ 2010-03-19 1
111-hr-4889,M001158 GSE Bailout Elimination and Taxpayer Protection Act 111-hr-4889 M001158 Rep. Marchant, Kenny [R-TX-24] R TX 2010-03-19 1
111-hr-4889,A000358 GSE Bailout Elimination and Taxpayer Protection Act 111-hr-4889 A000358 Rep. Akin, W. Todd [R-MO-2] R MO 2010-03-19 1
111-hr-4889,B000208 GSE Bailout Elimination and Taxpayer Protection Act 111-hr-4889 B000208 Rep. Bartlett, Roscoe G. [R-MD-6] R MD 2010-03-19 1
111-hr-4889,L000566 GSE Bailout Elimination and Taxpayer Protection Act 111-hr-4889 L000566 Rep. Latta, Robert E. [R-OH-5] R OH 2010-03-19 1
111-hr-4889,P000373 GSE Bailout Elimination and Taxpayer Protection Act 111-hr-4889 P000373 Rep. Pitts, Joseph R. [R-PA-16] R PA 2010-03-19 1
111-hr-4889,S001164 GSE Bailout Elimination and Taxpayer Protection Act 111-hr-4889 S001164 Rep. Schmidt, Jean [R-OH-2] R OH 2010-03-19 1
111-hr-4889,G000548 GSE Bailout Elimination and Taxpayer Protection Act 111-hr-4889 G000548 Rep. Garrett, Scott [R-NJ-5] R NJ 2010-03-19 1
111-hr-4889,O000168 GSE Bailout Elimination and Taxpayer Protection Act 111-hr-4889 O000168 Rep. Olson, Pete [R-TX-22] R TX 2010-03-19 1
111-hr-4889,D000533 GSE Bailout Elimination and Taxpayer Protection Act 111-hr-4889 D000533 Rep. Duncan, John J., Jr. [R-TN-2] R TN 2010-03-19 1
111-hr-4889,P000585 GSE Bailout Elimination and Taxpayer Protection Act 111-hr-4889 P000585 Rep. Platts, Todd Russell [R-PA-19] R PA 2010-03-19 1
111-hr-4889,S000583 GSE Bailout Elimination and Taxpayer Protection Act 111-hr-4889 S000583 Rep. Smith, Lamar [R-TX-21] R TX 2010-03-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);