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 = "112-hr-6511" 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

  • 1 15
  • 0 13
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
112-hr-6511,S001189 To require investigations into and a report on the September 11-13, 2012, attacks on the United States missions in Libya, Egypt, and Yemen, and for other purposes. 112-hr-6511 S001189 Rep. Scott, Austin [R-GA-8] R GA 2012-12-19 0
112-hr-6511,F000445 To require investigations into and a report on the September 11-13, 2012, attacks on the United States missions in Libya, Egypt, and Yemen, and for other purposes. 112-hr-6511 F000445 Rep. Forbes, J. Randy [R-VA-4] R VA 2012-12-04 0
112-hr-6511,A000369 To require investigations into and a report on the September 11-13, 2012, attacks on the United States missions in Libya, Egypt, and Yemen, and for other purposes. 112-hr-6511 A000369 Rep. Amodei, Mark E. [R-NV-2] R NV 2012-10-26 0
112-hr-6511,S001184 To require investigations into and a report on the September 11-13, 2012, attacks on the United States missions in Libya, Egypt, and Yemen, and for other purposes. 112-hr-6511 S001184 Rep. Scott, Tim [R-SC-1] R SC 2012-10-26 0
112-hr-6511,H001054 To require investigations into and a report on the September 11-13, 2012, attacks on the United States missions in Libya, Egypt, and Yemen, and for other purposes. 112-hr-6511 H001054 Rep. Hayworth, Nan A. S. [R-NY-19] R NY 2012-10-26 0
112-hr-6511,W000672 To require investigations into and a report on the September 11-13, 2012, attacks on the United States missions in Libya, Egypt, and Yemen, and for other purposes. 112-hr-6511 W000672 Rep. Wolf, Frank R. [R-VA-10] R VA 2012-10-26 0
112-hr-6511,M001157 To require investigations into and a report on the September 11-13, 2012, attacks on the United States missions in Libya, Egypt, and Yemen, and for other purposes. 112-hr-6511 M001157 Rep. McCaul, Michael T. [R-TX-10] R TX 2012-10-26 0
112-hr-6511,M001139 To require investigations into and a report on the September 11-13, 2012, attacks on the United States missions in Libya, Egypt, and Yemen, and for other purposes. 112-hr-6511 M001139 Rep. Miller, Gary G. [R-CA-42] R CA 2012-10-26 0
112-hr-6511,G000289 To require investigations into and a report on the September 11-13, 2012, attacks on the United States missions in Libya, Egypt, and Yemen, and for other purposes. 112-hr-6511 G000289 Rep. Goodlatte, Bob [R-VA-6] R VA 2012-10-26 0
112-hr-6511,C001048 To require investigations into and a report on the September 11-13, 2012, attacks on the United States missions in Libya, Egypt, and Yemen, and for other purposes. 112-hr-6511 C001048 Rep. Culberson, John Abney [R-TX-7] R TX 2012-10-26 0
112-hr-6511,R000575 To require investigations into and a report on the September 11-13, 2012, attacks on the United States missions in Libya, Egypt, and Yemen, and for other purposes. 112-hr-6511 R000575 Rep. Rogers, Mike D. [R-AL-3] R AL 2012-10-26 0
112-hr-6511,J000292 To require investigations into and a report on the September 11-13, 2012, attacks on the United States missions in Libya, Egypt, and Yemen, and for other purposes. 112-hr-6511 J000292 Rep. Johnson, Bill [R-OH-6] R OH 2012-10-26 0
112-hr-6511,L000567 To require investigations into and a report on the September 11-13, 2012, attacks on the United States missions in Libya, Egypt, and Yemen, and for other purposes. 112-hr-6511 L000567 Rep. Lance, Leonard [R-NJ-7] R NJ 2012-10-19 0
112-hr-6511,W000807 To require investigations into and a report on the September 11-13, 2012, attacks on the United States missions in Libya, Egypt, and Yemen, and for other purposes. 112-hr-6511 W000807 Rep. West, Allen B. [R-FL-22] R FL 2012-09-21 1
112-hr-6511,W000795 To require investigations into and a report on the September 11-13, 2012, attacks on the United States missions in Libya, Egypt, and Yemen, and for other purposes. 112-hr-6511 W000795 Rep. Wilson, Joe [R-SC-2] R SC 2012-09-21 1
112-hr-6511,S000244 To require investigations into and a report on the September 11-13, 2012, attacks on the United States missions in Libya, Egypt, and Yemen, and for other purposes. 112-hr-6511 S000244 Rep. Sensenbrenner, F. James, Jr. [R-WI-5] R WI 2012-09-21 1
112-hr-6511,B001273 To require investigations into and a report on the September 11-13, 2012, attacks on the United States missions in Libya, Egypt, and Yemen, and for other purposes. 112-hr-6511 B001273 Rep. Black, Diane [R-TN-6] R TN 2012-09-21 1
112-hr-6511,M001179 To require investigations into and a report on the September 11-13, 2012, attacks on the United States missions in Libya, Egypt, and Yemen, and for other purposes. 112-hr-6511 M001179 Rep. Marino, Tom [R-PA-10] R PA 2012-09-21 1
112-hr-6511,G000567 To require investigations into and a report on the September 11-13, 2012, attacks on the United States missions in Libya, Egypt, and Yemen, and for other purposes. 112-hr-6511 G000567 Rep. Griffin, Tim [R-AR-2] R AR 2012-09-21 1
112-hr-6511,G000566 To require investigations into and a report on the September 11-13, 2012, attacks on the United States missions in Libya, Egypt, and Yemen, and for other purposes. 112-hr-6511 G000566 Rep. Gowdy, Trey [R-SC-4] R SC 2012-09-21 1
112-hr-6511,B001243 To require investigations into and a report on the September 11-13, 2012, attacks on the United States missions in Libya, Egypt, and Yemen, and for other purposes. 112-hr-6511 B001243 Rep. Blackburn, Marsha [R-TN-7] R TN 2012-09-21 1
112-hr-6511,F000458 To require investigations into and a report on the September 11-13, 2012, attacks on the United States missions in Libya, Egypt, and Yemen, and for other purposes. 112-hr-6511 F000458 Rep. Fincher, Stephen Lee [R-TN-8] R TN 2012-09-21 1
112-hr-6511,F000448 To require investigations into and a report on the September 11-13, 2012, attacks on the United States missions in Libya, Egypt, and Yemen, and for other purposes. 112-hr-6511 F000448 Rep. Franks, Trent [R-AZ-2] R AZ 2012-09-21 1
112-hr-6511,L000564 To require investigations into and a report on the September 11-13, 2012, attacks on the United States missions in Libya, Egypt, and Yemen, and for other purposes. 112-hr-6511 L000564 Rep. Lamborn, Doug [R-CO-5] R CO 2012-09-21 1
112-hr-6511,K000369 To require investigations into and a report on the September 11-13, 2012, attacks on the United States missions in Libya, Egypt, and Yemen, and for other purposes. 112-hr-6511 K000369 Rep. Kissell, Larry [D-NC-8] D NC 2012-09-21 1
112-hr-6511,B001276 To require investigations into and a report on the September 11-13, 2012, attacks on the United States missions in Libya, Egypt, and Yemen, and for other purposes. 112-hr-6511 B001276 Rep. Buerkle, Ann Marie [R-NY-25] R NY 2012-09-21 1
112-hr-6511,H001052 To require investigations into and a report on the September 11-13, 2012, attacks on the United States missions in Libya, Egypt, and Yemen, and for other purposes. 112-hr-6511 H001052 Rep. Harris, Andy [R-MD-1] R MD 2012-09-21 1
112-hr-6511,R000572 To require investigations into and a report on the September 11-13, 2012, attacks on the United States missions in Libya, Egypt, and Yemen, and for other purposes. 112-hr-6511 R000572 Rep. Rogers, Mike J. [R-MI-8] R MI 2012-09-21 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);