home / openregs

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

14 rows where bill_id = "103-hr-4974" 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 14
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
103-hr-4974,C000488 To amend the Mississippi River Corridor Study Commission Act of 1989 to extend the term of the commission established by such Act. 103-hr-4974 C000488 Rep. Clay, William (Bill) [D-MO-1] D MO 1994-08-17 1
103-hr-4974,J000070 To amend the Mississippi River Corridor Study Commission Act of 1989 to extend the term of the commission established by such Act. 103-hr-4974 J000070 Rep. Jefferson, William J. [D-LA-2] D LA 1994-08-17 1
103-hr-4974,B000151 To amend the Mississippi River Corridor Study Commission Act of 1989 to extend the term of the commission established by such Act. 103-hr-4974 B000151 Rep. Barlow, Tom [D-KY-1] D KY 1994-08-17 1
103-hr-4974,L000342 To amend the Mississippi River Corridor Study Commission Act of 1989 to extend the term of the commission established by such Act. 103-hr-4974 L000342 Rep. Lipinski, William O. [D-IL-3] D IL 1994-08-17 1
103-hr-4974,L000169 To amend the Mississippi River Corridor Study Commission Act of 1989 to extend the term of the commission established by such Act. 103-hr-4974 L000169 Rep. Leach, James A. [R-IA-1] R IA 1994-08-17 1
103-hr-4974,G000535 To amend the Mississippi River Corridor Study Commission Act of 1989 to extend the term of the commission established by such Act. 103-hr-4974 G000535 Rep. Gutierrez, Luis V. [D-IL-4] D IL 1994-08-17 1
103-hr-4974,C000794 To amend the Mississippi River Corridor Study Commission Act of 1989 to extend the term of the commission established by such Act. 103-hr-4974 C000794 Rep. Costello, Jerry F. [D-IL-12] D IL 1994-08-17 1
103-hr-4974,O000006 To amend the Mississippi River Corridor Study Commission Act of 1989 to extend the term of the commission established by such Act. 103-hr-4974 O000006 Rep. Oberstar, James L. [D-MN-8] D MN 1994-08-17 1
103-hr-4974,W000326 To amend the Mississippi River Corridor Study Commission Act of 1989 to extend the term of the commission established by such Act. 103-hr-4974 W000326 Rep. Wheat, Alan [D-MO-5] D MO 1994-08-17 1
103-hr-4974,B000072 To amend the Mississippi River Corridor Study Commission Act of 1989 to extend the term of the commission established by such Act. 103-hr-4974 B000072 Rep. Baker, Richard H. [R-LA-6] R LA 1994-08-17 1
103-hr-4974,S000056 To amend the Mississippi River Corridor Study Commission Act of 1989 to extend the term of the commission established by such Act. 103-hr-4974 S000056 Rep. Sangmeister, George E. [D-IL-11] D IL 1994-08-17 1
103-hr-4974,M000865 To amend the Mississippi River Corridor Study Commission Act of 1989 to extend the term of the commission established by such Act. 103-hr-4974 M000865 Rep. Montgomery, G. V. (Sonny) [D-MS-3] D MS 1994-08-17 1
103-hr-4974,L000381 To amend the Mississippi River Corridor Study Commission Act of 1989 to extend the term of the commission established by such Act. 103-hr-4974 L000381 Rep. Lloyd, Marilyn [D-TN-3] D TN 1994-08-17 1
103-hr-4974,F000261 To amend the Mississippi River Corridor Study Commission Act of 1989 to extend the term of the commission established by such Act. 103-hr-4974 F000261 Rep. Ford, Harold E. [D-TN-9] D TN 1994-08-17 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);
Powered by Datasette · Queries took 4.467ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API