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

22 rows where bill_id = "101-hr-4081" 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

  • 0 13
  • 1 9
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
101-hr-4081,M000736 Civil Rights Protections Act of 1990 101-hr-4081 M000736 Rep. Miller, John R. [R-WA-1] R WA 1990-05-15 0
101-hr-4081,B001036 Civil Rights Protections Act of 1990 101-hr-4081 B001036 Rep. Buechner, Jack [R-MO-2] R MO 1990-05-15 0
101-hr-4081,B000919 Civil Rights Protections Act of 1990 101-hr-4081 B000919 Rep. Brown, Hank [R-CO-4] R CO 1990-04-25 0
101-hr-4081,P000005 Civil Rights Protections Act of 1990 101-hr-4081 P000005 Rep. Packard, Ron [R-CA-43] R CA 1990-03-29 0
101-hr-4081,K000352 Civil Rights Protections Act of 1990 101-hr-4081 K000352 Rep. Kyl, Jon [R-AZ-4] R AZ 1990-03-22 0
101-hr-4081,S000583 Civil Rights Protections Act of 1990 101-hr-4081 S000583 Rep. Smith, Lamar [R-TX-21] R TX 1990-03-15 0
101-hr-4081,R000072 Civil Rights Protections Act of 1990 101-hr-4081 R000072 Rep. Ravenel, Arthur, Jr. [R-SC-1] R SC 1990-03-15 0
101-hr-4081,S000244 Civil Rights Protections Act of 1990 101-hr-4081 S000244 Rep. Sensenbrenner, F. James, Jr. [R-WI-9] R WI 1990-03-15 0
101-hr-4081,H000586 Civil Rights Protections Act of 1990 101-hr-4081 H000586 Rep. Hiler, John Patrick [R-IN-3] R IN 1990-03-15 0
101-hr-4081,M000041 Civil Rights Protections Act of 1990 101-hr-4081 M000041 Rep. Madigan, Edward R. [R-IL-15] R IL 1990-03-15 0
101-hr-4081,S000675 Civil Rights Protections Act of 1990 101-hr-4081 S000675 Rep. Solomon, Gerald B. H. [R-NY-24] R NY 1990-03-15 0
101-hr-4081,N000106 Civil Rights Protections Act of 1990 101-hr-4081 N000106 Rep. Nielson, Howard C. [R-UT-3] R UT 1990-03-15 0
101-hr-4081,H000124 Civil Rights Protections Act of 1990 101-hr-4081 H000124 Rep. Hammerschmidt, John P. [R-AR-3] R AR 1990-03-15 0
101-hr-4081,G000524 Civil Rights Protections Act of 1990 101-hr-4081 G000524 Rep. Gunderson, Steve [R-WI-3] R WI 1990-02-22 1
101-hr-4081,R000465 Civil Rights Protections Act of 1990 101-hr-4081 R000465 Rep. Roukema, Marge [R-NJ-5] R NJ 1990-02-22 1
101-hr-4081,T000053 Civil Rights Protections Act of 1990 101-hr-4081 T000053 Rep. Tauke, Thomas Joseph [R-IA-2] R IA 1990-02-22 1
101-hr-4081,F000049 Civil Rights Protections Act of 1990 101-hr-4081 F000049 Rep. Fawell, Harris W. [R-IL-13] R IL 1990-02-22 1
101-hr-4081,G000371 Civil Rights Protections Act of 1990 101-hr-4081 G000371 Rep. Grandy, Fred [R-IA-6] R IA 1990-02-22 1
101-hr-4081,R000354 Civil Rights Protections Act of 1990 101-hr-4081 R000354 Rep. Robinson, Tommy F. [R-AR-2] R AR 1990-02-22 1
101-hr-4081,D000294 Civil Rights Protections Act of 1990 101-hr-4081 D000294 Rep. DeWine, Mike [R-OH-7] R OH 1990-02-22 1
101-hr-4081,M000692 Civil Rights Protections Act of 1990 101-hr-4081 M000692 Rep. Michel, Robert H. [R-IL-18] R IL 1990-02-22 1
101-hr-4081,G000225 Civil Rights Protections Act of 1990 101-hr-4081 G000225 Rep. Gingrich, Newt [R-GA-6] R GA 1990-02-22 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);