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

23 rows where bill_id = "112-hr-6439" 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 15
  • 1 8
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
112-hr-6439,G000567 Keep the Forest in the Family Estate Tax Act of 2012 112-hr-6439 G000567 Rep. Griffin, Tim [R-AR-2] R AR 2012-12-19 0
112-hr-6439,W000809 Keep the Forest in the Family Estate Tax Act of 2012 112-hr-6439 W000809 Rep. Womack, Steve [R-AR-3] R AR 2012-11-15 0
112-hr-6439,W000800 Keep the Forest in the Family Estate Tax Act of 2012 112-hr-6439 W000800 Rep. Welch, Peter [D-VT-At Large] D VT 2012-10-19 0
112-hr-6439,P000601 Keep the Forest in the Family Estate Tax Act of 2012 112-hr-6439 P000601 Rep. Palazzo, Steven M. [R-MS-4] R MS 2012-10-05 0
112-hr-6439,J000255 Keep the Forest in the Family Estate Tax Act of 2012 112-hr-6439 J000255 Rep. Jones, Walter B., Jr. [R-NC-3] R NC 2012-10-05 0
112-hr-6439,W000791 Keep the Forest in the Family Estate Tax Act of 2012 112-hr-6439 W000791 Rep. Walden, Greg [R-OR-2] R OR 2012-09-28 0
112-hr-6439,O000169 Keep the Forest in the Family Estate Tax Act of 2012 112-hr-6439 O000169 Rep. Owens, William L. [D-NY-23] D NY 2012-09-25 0
112-hr-6439,B000490 Keep the Forest in the Family Estate Tax Act of 2012 112-hr-6439 B000490 Rep. Bishop, Sanford D., Jr. [D-GA-2] D GA 2012-09-25 0
112-hr-6439,A000361 Keep the Forest in the Family Estate Tax Act of 2012 112-hr-6439 A000361 Rep. Alexander, Rodney [R-LA-5] R LA 2012-09-21 0
112-hr-6439,M000485 Keep the Forest in the Family Estate Tax Act of 2012 112-hr-6439 M000485 Rep. McIntyre, Mike [D-NC-7] D NC 2012-09-21 0
112-hr-6439,B001255 Keep the Forest in the Family Estate Tax Act of 2012 112-hr-6439 B001255 Rep. Boustany, Charles W., Jr. [R-LA-7] R LA 2012-09-21 0
112-hr-6439,F000458 Keep the Forest in the Family Estate Tax Act of 2012 112-hr-6439 F000458 Rep. Fincher, Stephen Lee [R-TN-8] R TN 2012-09-21 0
112-hr-6439,S001180 Keep the Forest in the Family Estate Tax Act of 2012 112-hr-6439 S001180 Rep. Schrader, Kurt [D-OR-5] D OR 2012-09-21 0
112-hr-6439,P000258 Keep the Forest in the Family Estate Tax Act of 2012 112-hr-6439 P000258 Rep. Peterson, Collin C. [D-MN-7] D MN 2012-09-21 0
112-hr-6439,R000578 Keep the Forest in the Family Estate Tax Act of 2012 112-hr-6439 R000578 Rep. Reichert, David G. [R-WA-8] R WA 2012-09-20 0
112-hr-6439,M001149 Keep the Forest in the Family Estate Tax Act of 2012 112-hr-6439 M001149 Rep. Michaud, Michael H. [D-ME-2] D ME 2012-09-19 1
112-hr-6439,R000587 Keep the Forest in the Family Estate Tax Act of 2012 112-hr-6439 R000587 Rep. Ribble, Reid J. [R-WI-8] R WI 2012-09-19 1
112-hr-6439,B001244 Keep the Forest in the Family Estate Tax Act of 2012 112-hr-6439 B001244 Rep. Bonner, Jo [R-AL-1] R AL 2012-09-19 1
112-hr-6439,H000528 Keep the Forest in the Family Estate Tax Act of 2012 112-hr-6439 H000528 Rep. Herger, Wally [R-CA-2] R CA 2012-09-19 1
112-hr-6439,T000467 Keep the Forest in the Family Estate Tax Act of 2012 112-hr-6439 T000467 Rep. Thompson, Glenn [R-PA-5] R PA 2012-09-19 1
112-hr-6439,B001243 Keep the Forest in the Family Estate Tax Act of 2012 112-hr-6439 B001243 Rep. Blackburn, Marsha [R-TN-7] R TN 2012-09-19 1
112-hr-6439,D000533 Keep the Forest in the Family Estate Tax Act of 2012 112-hr-6439 D000533 Rep. Duncan, John J., Jr. [R-TN-2] R TN 2012-09-19 1
112-hr-6439,K000369 Keep the Forest in the Family Estate Tax Act of 2012 112-hr-6439 K000369 Rep. Kissell, Larry [D-NC-8] D NC 2012-09-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);