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

35 rows where bill_id = "106-hr-2986" 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 34
  • 0 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
106-hr-2986,R000487 State Initiative Fairness Act 106-hr-2986 R000487 Rep. Royce, Edward R. [R-CA-39] R CA 1999-10-12 0
106-hr-2986,B000461 State Initiative Fairness Act 106-hr-2986 B000461 Rep. Bilbray, Brian P. [R-CA-49] R CA 1999-09-30 1
106-hr-2986,B000996 State Initiative Fairness Act 106-hr-2986 B000996 Rep. Bryant, Ed [R-TN-7] R TN 1999-09-30 1
106-hr-2986,B001203 State Initiative Fairness Act 106-hr-2986 B001203 Rep. Buyer, Steve [R-IN-5] R IN 1999-09-30 1
106-hr-2986,C000059 State Initiative Fairness Act 106-hr-2986 C000059 Rep. Calvert, Ken [R-CA-43] R CA 1999-09-30 1
106-hr-2986,C000100 State Initiative Fairness Act 106-hr-2986 C000100 Rep. Campbell, Tom [R-CA-15] R CA 1999-09-30 1
106-hr-2986,C000116 State Initiative Fairness Act 106-hr-2986 C000116 Rep. Cannon, Chris [R-UT-3] R UT 1999-09-30 1
106-hr-2986,C000873 State Initiative Fairness Act 106-hr-2986 C000873 Rep. Crane, Philip M. [R-IL-8] R IL 1999-09-30 1
106-hr-2986,C000994 State Initiative Fairness Act 106-hr-2986 C000994 Rep. Cunningham, Randy (Duke) [R-CA-51] R CA 1999-09-30 1
106-hr-2986,D000429 State Initiative Fairness Act 106-hr-2986 D000429 Rep. Doolittle, John T. [R-CA-4] R CA 1999-09-30 1
106-hr-2986,D000492 State Initiative Fairness Act 106-hr-2986 D000492 Rep. Dreier, David [R-CA-28] R CA 1999-09-30 1
106-hr-2986,F000238 State Initiative Fairness Act 106-hr-2986 F000238 Rep. Foley, Mark [R-FL-16] R FL 1999-09-30 1
106-hr-2986,G000021 State Initiative Fairness Act 106-hr-2986 G000021 Rep. Gallegly, Elton [R-CA-23] R CA 1999-09-30 1
106-hr-2986,G000359 State Initiative Fairness Act 106-hr-2986 G000359 Rep. Graham, Lindsey [R-SC-3] R SC 1999-09-30 1
106-hr-2986,G000289 State Initiative Fairness Act 106-hr-2986 G000289 Rep. Goodlatte, Bob [R-VA-6] R VA 1999-09-30 1
106-hr-2986,H000413 State Initiative Fairness Act 106-hr-2986 H000413 Rep. Hayworth, J. D. [R-AZ-6] R AZ 1999-09-30 1
106-hr-2986,H000528 State Initiative Fairness Act 106-hr-2986 H000528 Rep. Herger, Wally [R-CA-2] R CA 1999-09-30 1
106-hr-2986,H000981 State Initiative Fairness Act 106-hr-2986 H000981 Rep. Hunter, Duncan [R-CA-52] R CA 1999-09-30 1
106-hr-2986,H001022 State Initiative Fairness Act 106-hr-2986 H001022 Rep. Hyde, Henry J. [R-IL-6] R IL 1999-09-30 1
106-hr-2986,J000082 State Initiative Fairness Act 106-hr-2986 J000082 Rep. Jenkins, William L. [R-TN-1] R TN 1999-09-30 1
106-hr-2986,K000357 State Initiative Fairness Act 106-hr-2986 K000357 Rep. Kuykendall, Steven T. [R-CA-36] R CA 1999-09-30 1
106-hr-2986,L000274 State Initiative Fairness Act 106-hr-2986 L000274 Rep. Lewis, Jerry [R-CA-40] R CA 1999-09-30 1
106-hr-2986,M000350 State Initiative Fairness Act 106-hr-2986 M000350 Rep. McCollum, Bill [R-FL-8] R FL 1999-09-30 1
106-hr-2986,M001139 State Initiative Fairness Act 106-hr-2986 M001139 Rep. Miller, Gary G. [R-CA-41] R CA 1999-09-30 1
106-hr-2986,P000005 State Initiative Fairness Act 106-hr-2986 P000005 Rep. Packard, Ron [R-CA-48] R CA 1999-09-30 1
106-hr-2986,P000419 State Initiative Fairness Act 106-hr-2986 P000419 Rep. Pombo, Richard W. [R-CA-11] R CA 1999-09-30 1
106-hr-2986,R000386 State Initiative Fairness Act 106-hr-2986 R000386 Rep. Rogan, James E. [R-CA-27] R CA 1999-09-30 1
106-hr-2986,R000409 State Initiative Fairness Act 106-hr-2986 R000409 Rep. Rohrabacher, Dana [R-CA-45] R CA 1999-09-30 1
106-hr-2986,S000018 State Initiative Fairness Act 106-hr-2986 S000018 Rep. Salmon, Matt [R-AZ-1] R AZ 1999-09-30 1
106-hr-2986,S000275 State Initiative Fairness Act 106-hr-2986 S000275 Rep. Shadegg, John B. [R-AZ-4] R AZ 1999-09-30 1
106-hr-2986,S000718 State Initiative Fairness Act 106-hr-2986 S000718 Rep. Spence, Floyd [R-SC-2] R SC 1999-09-30 1
106-hr-2986,S001149 State Initiative Fairness Act 106-hr-2986 S001149 Rep. Sweeney, John E. [R-NY-22] R NY 1999-09-30 1
106-hr-2986,O000164 State Initiative Fairness Act 106-hr-2986 O000164 Rep. Ose, Doug [R-CA-3] R CA 1999-09-30 1
106-hr-2986,T000188 State Initiative Fairness Act 106-hr-2986 T000188 Rep. Thomas, William M. [R-CA-21] R CA 1999-09-30 1
106-hr-2986,R000004 State Initiative Fairness Act 106-hr-2986 R000004 Rep. Radanovich, George [R-CA-19] R CA 1999-09-30 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);