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 = "103-hr-5183" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, state, sponsorship_date (date)

is_original_cosponsor 1

  • 1 22
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
103-hr-5183,R000307 Sheep Promotion, Research, and Information Act of 1994 103-hr-5183 R000307 Rep. Roberts, Pat [R-KS-1] R KS 1994-10-05 1
103-hr-5183,S000851 Sheep Promotion, Research, and Information Act of 1994 103-hr-5183 S000851 Rep. Stenholm, Charles W. [D-TX-17] D TX 1994-10-05 1
103-hr-5183,G000524 Sheep Promotion, Research, and Information Act of 1994 103-hr-5183 G000524 Rep. Gunderson, Steve [R-WI-3] R WI 1994-10-05 1
103-hr-5183,R000436 Sheep Promotion, Research, and Information Act of 1994 103-hr-5183 R000436 Rep. Rose, Charlie [D-NC-7] D NC 1994-10-05 1
103-hr-5183,S000607 Sheep Promotion, Research, and Information Act of 1994 103-hr-5183 S000607 Rep. Smith, Robert [R-OR-2] R OR 1994-10-05 1
103-hr-5183,I000026 Sheep Promotion, Research, and Information Act of 1994 103-hr-5183 I000026 Rep. Inslee, Jay [D-WA-4] D WA 1994-10-05 1
103-hr-5183,C000653 Sheep Promotion, Research, and Information Act of 1994 103-hr-5183 C000653 Rep. Combest, Larry [R-TX-19] R TX 1994-10-05 1
103-hr-5183,A000109 Sheep Promotion, Research, and Information Act of 1994 103-hr-5183 A000109 Rep. Allard, Wayne [R-CO-4] R CO 1994-10-05 1
103-hr-5183,S000463 Sheep Promotion, Research, and Information Act of 1994 103-hr-5183 S000463 Rep. Skeen, Joe [R-NM-2] R NM 1994-10-05 1
103-hr-5183,T000162 Sheep Promotion, Research, and Information Act of 1994 103-hr-5183 T000162 Rep. Thomas, Craig [R-WY-At Large] R WY 1994-10-05 1
103-hr-5183,B000617 Sheep Promotion, Research, and Information Act of 1994 103-hr-5183 B000617 Rep. Bonilla, Henry [R-TX-23] R TX 1994-10-05 1
103-hr-5183,M000477 Sheep Promotion, Research, and Information Act of 1994 103-hr-5183 M000477 Rep. McInnis, Scott [R-CO-3] R CO 1994-10-05 1
103-hr-5183,C000880 Sheep Promotion, Research, and Information Act of 1994 103-hr-5183 C000880 Rep. Crapo, Mike [R-ID-2] R ID 1994-10-05 1
103-hr-5183,B000151 Sheep Promotion, Research, and Information Act of 1994 103-hr-5183 B000151 Rep. Barlow, Tom [D-KY-1] D KY 1994-10-05 1
103-hr-5183,H000712 Sheep Promotion, Research, and Information Act of 1994 103-hr-5183 H000712 Rep. Holden, Tim [D-PA-6] D PA 1994-10-05 1
103-hr-5183,P000215 Sheep Promotion, Research, and Information Act of 1994 103-hr-5183 P000215 Rep. Penny, Timothy J. [D-MN-1] D MN 1994-10-05 1
103-hr-5183,V000124 Sheep Promotion, Research, and Information Act of 1994 103-hr-5183 V000124 Rep. Vucanovich, Barbara F. [R-NV-2] R NV 1994-10-05 1
103-hr-5183,V000112 Sheep Promotion, Research, and Information Act of 1994 103-hr-5183 V000112 Rep. Volkmer, Harold L. [D-MO-9] D MO 1994-10-05 1
103-hr-5183,W000520 Sheep Promotion, Research, and Information Act of 1994 103-hr-5183 W000520 Rep. Williams, Pat [D-MT-1] D MT 1994-10-05 1
103-hr-5183,S000583 Sheep Promotion, Research, and Information Act of 1994 103-hr-5183 S000583 Rep. Smith, Lamar [R-TX-21] R TX 1994-10-05 1
103-hr-5183,E000063 Sheep Promotion, Research, and Information Act of 1994 103-hr-5183 E000063 Rep. Edwards, Chet [D-TX-11] D TX 1994-10-05 1
103-hr-5183,J000177 Sheep Promotion, Research, and Information Act of 1994 103-hr-5183 J000177 Rep. Johnson, Tim [D-SD-At Large] D SD 1994-10-05 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);