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

25 rows where bill_id = "111-hr-4586" 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 22
  • 0 3
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
111-hr-4586,C001048 Mortgage E-Verify Act of 2010 111-hr-4586 C001048 Rep. Culberson, John Abney [R-TX-7] R TX 2010-03-03 0
111-hr-4586,G000021 Mortgage E-Verify Act of 2010 111-hr-4586 G000021 Rep. Gallegly, Elton [R-CA-24] R CA 2010-02-23 0
111-hr-4586,M001147 Mortgage E-Verify Act of 2010 111-hr-4586 M001147 Rep. McCotter, Thaddeus G. [R-MI-11] R MI 2010-02-23 0
111-hr-4586,M001156 Mortgage E-Verify Act of 2010 111-hr-4586 M001156 Rep. McHenry, Patrick T. [R-NC-10] R NC 2010-02-03 1
111-hr-4586,L000564 Mortgage E-Verify Act of 2010 111-hr-4586 L000564 Rep. Lamborn, Doug [R-CO-5] R CO 2010-02-03 1
111-hr-4586,L000571 Mortgage E-Verify Act of 2010 111-hr-4586 L000571 Rep. Lummis, Cynthia M. [R-WY-At Large] R WY 2010-02-03 1
111-hr-4586,P000599 Mortgage E-Verify Act of 2010 111-hr-4586 P000599 Rep. Posey, Bill [R-FL-15] R FL 2010-02-03 1
111-hr-4586,H001036 Mortgage E-Verify Act of 2010 111-hr-4586 H001036 Rep. Hensarling, Jeb [R-TX-5] R TX 2010-02-03 1
111-hr-4586,B001248 Mortgage E-Verify Act of 2010 111-hr-4586 B001248 Rep. Burgess, Michael C. [R-TX-26] R TX 2010-02-03 1
111-hr-4586,K000362 Mortgage E-Verify Act of 2010 111-hr-4586 K000362 Rep. King, Steve [R-IA-5] R IA 2010-02-03 1
111-hr-4586,B000461 Mortgage E-Verify Act of 2010 111-hr-4586 B000461 Rep. Bilbray, Brian P. [R-CA-50] R CA 2010-02-03 1
111-hr-4586,B001250 Mortgage E-Verify Act of 2010 111-hr-4586 B001250 Rep. Bishop, Rob [R-UT-1] R UT 2010-02-03 1
111-hr-4586,C001064 Mortgage E-Verify Act of 2010 111-hr-4586 C001064 Rep. Campbell, John [R-CA-48] R CA 2010-02-03 1
111-hr-4586,G000552 Mortgage E-Verify Act of 2010 111-hr-4586 G000552 Rep. Gohmert, Louie [R-TX-1] R TX 2010-02-03 1
111-hr-4586,L000569 Mortgage E-Verify Act of 2010 111-hr-4586 L000569 Rep. Luetkemeyer, Blaine [R-MO-9] R MO 2010-02-03 1
111-hr-4586,G000550 Mortgage E-Verify Act of 2010 111-hr-4586 G000550 Rep. Gingrey, Phil [R-GA-11] R GA 2010-02-03 1
111-hr-4586,P000373 Mortgage E-Verify Act of 2010 111-hr-4586 P000373 Rep. Pitts, Joseph R. [R-PA-16] R PA 2010-02-03 1
111-hr-4586,R000582 Mortgage E-Verify Act of 2010 111-hr-4586 R000582 Rep. Roe, David P. [R-TN-1] R TN 2010-02-03 1
111-hr-4586,B000208 Mortgage E-Verify Act of 2010 111-hr-4586 B000208 Rep. Bartlett, Roscoe G. [R-MD-6] R MD 2010-02-03 1
111-hr-4586,F000456 Mortgage E-Verify Act of 2010 111-hr-4586 F000456 Rep. Fleming, John [R-LA-4] R LA 2010-02-03 1
111-hr-4586,S001164 Mortgage E-Verify Act of 2010 111-hr-4586 S001164 Rep. Schmidt, Jean [R-OH-2] R OH 2010-02-03 1
111-hr-4586,G000377 Mortgage E-Verify Act of 2010 111-hr-4586 G000377 Rep. Granger, Kay [R-TX-12] R TX 2010-02-03 1
111-hr-4586,F000453 Mortgage E-Verify Act of 2010 111-hr-4586 F000453 Rep. Fallin, Mary [R-OK-5] R OK 2010-02-03 1
111-hr-4586,A000358 Mortgage E-Verify Act of 2010 111-hr-4586 A000358 Rep. Akin, W. Todd [R-MO-2] R MO 2010-02-03 1
111-hr-4586,B000755 Mortgage E-Verify Act of 2010 111-hr-4586 B000755 Rep. Brady, Kevin [R-TX-8] R TX 2010-02-03 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);