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

27 rows where bill_id = "100-sjres-340" 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 23
  • 1 4
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
100-sjres-340,C000269 A designating November 27 through December 3, 1988, as "National Sir Winston Churchill Recognition Week". 100-sjres-340 C000269 Sen. Chafee, John H. [R-RI] R RI 1988-10-21 0
100-sjres-340,S000888 A designating November 27 through December 3, 1988, as "National Sir Winston Churchill Recognition Week". 100-sjres-340 S000888 Sen. Stevens, Ted [R-AK] R AK 1988-10-21 0
100-sjres-340,D000185 A designating November 27 through December 3, 1988, as "National Sir Winston Churchill Recognition Week". 100-sjres-340 D000185 Sen. DeConcini, Dennis [D-AZ] D AZ 1988-10-20 0
100-sjres-340,B000243 A designating November 27 through December 3, 1988, as "National Sir Winston Churchill Recognition Week". 100-sjres-340 B000243 Sen. Baucus, Max [D-MT] D MT 1988-10-20 0
100-sjres-340,B001077 A designating November 27 through December 3, 1988, as "National Sir Winston Churchill Recognition Week". 100-sjres-340 B001077 Sen. Burdick, Quentin N. [D-ND] D ND 1988-10-20 0
100-sjres-340,D000566 A designating November 27 through December 3, 1988, as "National Sir Winston Churchill Recognition Week". 100-sjres-340 D000566 Sen. Durenberger, Dave [R-MN] R MN 1988-10-20 0
100-sjres-340,M000250 A designating November 27 through December 3, 1988, as "National Sir Winston Churchill Recognition Week". 100-sjres-340 M000250 Sen. Matsunaga, Spark M. [D-HI] D HI 1988-10-20 0
100-sjres-340,P000193 A designating November 27 through December 3, 1988, as "National Sir Winston Churchill Recognition Week". 100-sjres-340 P000193 Sen. Pell, Claiborne [D-RI] D RI 1988-10-20 0
100-sjres-340,Q000007 A designating November 27 through December 3, 1988, as "National Sir Winston Churchill Recognition Week". 100-sjres-340 Q000007 Sen. Quayle, Dan [R-IN] R IN 1988-10-20 0
100-sjres-340,K000148 A designating November 27 through December 3, 1988, as "National Sir Winston Churchill Recognition Week". 100-sjres-340 K000148 Sen. Kerry, John F. [D-MA] D MA 1988-10-20 0
100-sjres-340,B000639 A designating November 27 through December 3, 1988, as "National Sir Winston Churchill Recognition Week". 100-sjres-340 B000639 Sen. Boren, David L. [D-OK] D OK 1988-10-20 0
100-sjres-340,G000072 A designating November 27 through December 3, 1988, as "National Sir Winston Churchill Recognition Week". 100-sjres-340 G000072 Sen. Garn, E. J. (Jake) [R-UT] R UT 1988-10-20 0
100-sjres-340,H000725 A designating November 27 through December 3, 1988, as "National Sir Winston Churchill Recognition Week". 100-sjres-340 H000725 Sen. Hollings, Ernest F. [D-SC] D SC 1988-10-20 0
100-sjres-340,P000556 A designating November 27 through December 3, 1988, as "National Sir Winston Churchill Recognition Week". 100-sjres-340 P000556 Sen. Pryor, David H. [D-AR] D AR 1988-10-20 0
100-sjres-340,S000423 A designating November 27 through December 3, 1988, as "National Sir Winston Churchill Recognition Week". 100-sjres-340 S000423 Sen. Simon, Paul [D-IL] D IL 1988-10-20 0
100-sjres-340,S001138 A designating November 27 through December 3, 1988, as "National Sir Winston Churchill Recognition Week". 100-sjres-340 S001138 Sen. Symms, Steven D. [R-ID] R ID 1988-10-20 0
100-sjres-340,T000254 A designating November 27 through December 3, 1988, as "National Sir Winston Churchill Recognition Week". 100-sjres-340 T000254 Sen. Thurmond, Strom [R-SC] R SC 1988-10-20 0
100-sjres-340,W000154 A designating November 27 through December 3, 1988, as "National Sir Winston Churchill Recognition Week". 100-sjres-340 W000154 Sen. Warner, John [R-VA] R VA 1988-10-20 0
100-sjres-340,M001085 A designating November 27 through December 3, 1988, as "National Sir Winston Churchill Recognition Week". 100-sjres-340 M001085 Sen. Murkowski, Frank H. [R-AK] R AK 1988-10-14 0
100-sjres-340,N000171 A designating November 27 through December 3, 1988, as "National Sir Winston Churchill Recognition Week". 100-sjres-340 N000171 Sen. Nunn, Sam [D-GA] D GA 1988-10-11 0
100-sjres-340,H000463 A designating November 27 through December 3, 1988, as "National Sir Winston Churchill Recognition Week". 100-sjres-340 H000463 Sen. Helms, Jesse [R-NC] R NC 1988-10-11 0
100-sjres-340,B000611 A designating November 27 through December 3, 1988, as "National Sir Winston Churchill Recognition Week". 100-sjres-340 B000611 Sen. Bond, Christopher S. [R-MO] R MO 1988-10-07 0
100-sjres-340,B000780 A designating November 27 through December 3, 1988, as "National Sir Winston Churchill Recognition Week". 100-sjres-340 B000780 Sen. Breaux, John B. [D-LA] D LA 1988-10-05 0
100-sjres-340,M001054 A designating November 27 through December 3, 1988, as "National Sir Winston Churchill Recognition Week". 100-sjres-340 M001054 Sen. Moynihan, Daniel Patrick [D-NY] D NY 1988-10-04 1
100-sjres-340,D000030 A designating November 27 through December 3, 1988, as "National Sir Winston Churchill Recognition Week". 100-sjres-340 D000030 Sen. Danforth, John C. [R-MO] R MO 1988-10-04 1
100-sjres-340,W000607 A designating November 27 through December 3, 1988, as "National Sir Winston Churchill Recognition Week". 100-sjres-340 W000607 Sen. Wilson, Pete [R-CA] R CA 1988-10-04 1
100-sjres-340,D000366 A designating November 27 through December 3, 1988, as "National Sir Winston Churchill Recognition Week". 100-sjres-340 D000366 Sen. Dixon, Alan J. [D-IL] D IL 1988-10-04 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);