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

11 rows where bill_id = "106-hconres-101" 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

Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
106-hconres-101,E000282 Expressing the sense of the Congress that Social Security reform measures should not force State and local government employees into Social Security coverage. 106-hconres-101 E000282 Rep. Ewing, Thomas W. [R-IL-15] R IL 2000-04-11 0
106-hconres-101,H001029 Expressing the sense of the Congress that Social Security reform measures should not force State and local government employees into Social Security coverage. 106-hconres-101 H001029 Rep. Hayes, Robin [R-NC-8] R NC 1999-07-21 0
106-hconres-101,R000570 Expressing the sense of the Congress that Social Security reform measures should not force State and local government employees into Social Security coverage. 106-hconres-101 R000570 Rep. Ryan, Paul [R-WI-1] R WI 1999-07-21 0
106-hconres-101,D000595 Expressing the sense of the Congress that Social Security reform measures should not force State and local government employees into Social Security coverage. 106-hconres-101 D000595 Rep. DeMint, Jim [R-SC-4] R SC 1999-07-21 0
106-hconres-101,L000553 Expressing the sense of the Congress that Social Security reform measures should not force State and local government employees into Social Security coverage. 106-hconres-101 L000553 Rep. LaTourette, Steven C. [R-OH-19] R OH 1999-06-29 0
106-hconres-101,T000458 Expressing the sense of the Congress that Social Security reform measures should not force State and local government employees into Social Security coverage. 106-hconres-101 T000458 Rep. Tancredo, Thomas G. [R-CO-6] R CO 1999-05-06 1
106-hconres-101,T000459 Expressing the sense of the Congress that Social Security reform measures should not force State and local government employees into Social Security coverage. 106-hconres-101 T000459 Rep. Terry, Lee [R-NE-2] R NE 1999-05-06 1
106-hconres-101,F000441 Expressing the sense of the Congress that Social Security reform measures should not force State and local government employees into Social Security coverage. 106-hconres-101 F000441 Rep. Fletcher, Ernie [R-KY-6] R KY 1999-05-06 1
106-hconres-101,O000164 Expressing the sense of the Congress that Social Security reform measures should not force State and local government employees into Social Security coverage. 106-hconres-101 O000164 Rep. Ose, Doug [R-CA-3] R CA 1999-05-06 1
106-hconres-101,S001148 Expressing the sense of the Congress that Social Security reform measures should not force State and local government employees into Social Security coverage. 106-hconres-101 S001148 Rep. Simpson, Michael K. [R-ID-2] R ID 1999-05-06 1
106-hconres-101,K000357 Expressing the sense of the Congress that Social Security reform measures should not force State and local government employees into Social Security coverage. 106-hconres-101 K000357 Rep. Kuykendall, Steven T. [R-CA-36] R CA 1999-05-06 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);