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

37 rows where bill_id = "106-hr-906" 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 26
  • 0 11
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
106-hr-906,H000627 Civic Participation and Rehabilitation Act of 1999 106-hr-906 H000627 Rep. Hinchey, Maurice D. [D-NY-26] D NY 1999-06-10 0
106-hr-906,C001037 Civic Participation and Rehabilitation Act of 1999 106-hr-906 C001037 Rep. Capuano, Michael E. [D-MA-8] D MA 1999-06-10 0
106-hr-906,P000197 Civic Participation and Rehabilitation Act of 1999 106-hr-906 P000197 Rep. Pelosi, Nancy [D-CA-8] D CA 1999-06-10 0
106-hr-906,M000797 Civic Participation and Rehabilitation Act of 1999 106-hr-906 M000797 Rep. Mink, Patsy T. [D-HI-2] D HI 1999-06-10 0
106-hr-906,S000810 Civic Participation and Rehabilitation Act of 1999 106-hr-906 S000810 Rep. Stark, Fortney Pete [D-CA-13] D CA 1999-06-10 0
106-hr-906,E000179 Civic Participation and Rehabilitation Act of 1999 106-hr-906 E000179 Rep. Engel, Eliot L. [D-NY-17] D NY 1999-06-07 0
106-hr-906,F000339 Civic Participation and Rehabilitation Act of 1999 106-hr-906 F000339 Rep. Frank, Barney [D-MA-4] D MA 1999-05-04 0
106-hr-906,B000918 Civic Participation and Rehabilitation Act of 1999 106-hr-906 B000918 Rep. Brown, George E., Jr. [D-CA-42] D CA 1999-03-25 0
106-hr-906,W000207 Civic Participation and Rehabilitation Act of 1999 106-hr-906 W000207 Rep. Watt, Melvin L. [D-NC-12] D NC 1999-03-10 0
106-hr-906,N000147 Civic Participation and Rehabilitation Act of 1999 106-hr-906 N000147 Del. Norton, Eleanor Holmes [D-DC-At Large] D DC 1999-03-10 0
106-hr-906,F000010 Civic Participation and Rehabilitation Act of 1999 106-hr-906 F000010 Del. Faleomavaega, Eni F. H. [D-AS-At Large] D AS 1999-03-10 0
106-hr-906,F000392 Civic Participation and Rehabilitation Act of 1999 106-hr-906 F000392 Rep. Frost, Martin [D-TX-24] D TX 1999-03-02 1
106-hr-906,R000053 Civic Participation and Rehabilitation Act of 1999 106-hr-906 R000053 Rep. Rangel, Charles B. [D-NY-15] D NY 1999-03-02 1
106-hr-906,J000032 Civic Participation and Rehabilitation Act of 1999 106-hr-906 J000032 Rep. Jackson-Lee, Sheila [D-TX-18] D TX 1999-03-02 1
106-hr-906,M000627 Civic Participation and Rehabilitation Act of 1999 106-hr-906 M000627 Rep. Meehan, Martin T. [D-MA-5] D MA 1999-03-02 1
106-hr-906,W000187 Civic Participation and Rehabilitation Act of 1999 106-hr-906 W000187 Rep. Waters, Maxine [D-CA-35] D CA 1999-03-02 1
106-hr-906,C000537 Civic Participation and Rehabilitation Act of 1999 106-hr-906 C000537 Rep. Clyburn, James E. [D-SC-6] D SC 1999-03-02 1
106-hr-906,L000287 Civic Participation and Rehabilitation Act of 1999 106-hr-906 L000287 Rep. Lewis, John [D-GA-5] D GA 1999-03-02 1
106-hr-906,M000628 Civic Participation and Rehabilitation Act of 1999 106-hr-906 M000628 Rep. Meek, Carrie P. [D-FL-17] D FL 1999-03-02 1
106-hr-906,D000096 Civic Participation and Rehabilitation Act of 1999 106-hr-906 D000096 Rep. Davis, Danny K. [D-IL-7] D IL 1999-03-02 1
106-hr-906,B000944 Civic Participation and Rehabilitation Act of 1999 106-hr-906 B000944 Rep. Brown, Sherrod [D-OH-13] D OH 1999-03-02 1
106-hr-906,M001137 Civic Participation and Rehabilitation Act of 1999 106-hr-906 M001137 Rep. Meeks, Gregory W. [D-NY-6] D NY 1999-03-02 1
106-hr-906,T000193 Civic Participation and Rehabilitation Act of 1999 106-hr-906 T000193 Rep. Thompson, Bennie G. [D-MS-2] D MS 1999-03-02 1
106-hr-906,R000515 Civic Participation and Rehabilitation Act of 1999 106-hr-906 R000515 Rep. Rush, Bobby L. [D-IL-1] D IL 1999-03-02 1
106-hr-906,O000159 Civic Participation and Rehabilitation Act of 1999 106-hr-906 O000159 Rep. Owens, Major R. [D-NY-11] D NY 1999-03-02 1
106-hr-906,K000180 Civic Participation and Rehabilitation Act of 1999 106-hr-906 K000180 Rep. Kilpatrick, Carolyn C. [D-MI-15] D MI 1999-03-02 1
106-hr-906,W000784 Civic Participation and Rehabilitation Act of 1999 106-hr-906 W000784 Rep. Wynn, Albert Russell [D-MD-4] D MD 1999-03-02 1
106-hr-906,J000283 Civic Participation and Rehabilitation Act of 1999 106-hr-906 J000283 Rep. Jackson, Jesse L., Jr. [D-IL-2] D IL 1999-03-02 1
106-hr-906,H000324 Civic Participation and Rehabilitation Act of 1999 106-hr-906 H000324 Rep. Hastings, Alcee L. [D-FL-23] D FL 1999-03-02 1
106-hr-906,F000043 Civic Participation and Rehabilitation Act of 1999 106-hr-906 F000043 Rep. Fattah, Chaka [D-PA-2] D PA 1999-03-02 1
106-hr-906,L000551 Civic Participation and Rehabilitation Act of 1999 106-hr-906 L000551 Rep. Lee, Barbara [D-CA-9] D CA 1999-03-02 1
106-hr-906,C000984 Civic Participation and Rehabilitation Act of 1999 106-hr-906 C000984 Rep. Cummings, Elijah E. [D-MD-7] D MD 1999-03-02 1
106-hr-906,H000621 Civic Participation and Rehabilitation Act of 1999 106-hr-906 H000621 Rep. Hilliard, Earl F. [D-AL-7] D AL 1999-03-02 1
106-hr-906,B001227 Civic Participation and Rehabilitation Act of 1999 106-hr-906 B001227 Rep. Brady, Robert A. [D-PA-1] D PA 1999-03-02 1
106-hr-906,F000262 Civic Participation and Rehabilitation Act of 1999 106-hr-906 F000262 Rep. Ford, Harold E., Jr. [D-TN-9] D TN 1999-03-02 1
106-hr-906,J000284 Civic Participation and Rehabilitation Act of 1999 106-hr-906 J000284 Rep. Jones, Stephanie Tubbs [D-OH-11] D OH 1999-03-02 1
106-hr-906,S001145 Civic Participation and Rehabilitation Act of 1999 106-hr-906 S001145 Rep. Schakowsky, Janice D. [D-IL-9] D IL 1999-03-02 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);