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

40 rows where bill_id = "96-hr-7873" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party

is_original_cosponsor 1

  • 0 40
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
96-hr-7873,R000374 Gasohol Competition Act of 1980 96-hr-7873 R000374 Rep. Rodino, Peter W., Jr. [D-NJ-10] D     0
96-hr-7873,B000298 Gasohol Competition Act of 1980 96-hr-7873 B000298 Rep. Bedell, Berkley W. [D-IA-6] D     0
96-hr-7873,D000064 Gasohol Competition Act of 1980 96-hr-7873 D000064 Rep. Daschle, Thomas A. [D-SD-At Large] D     0
96-hr-7873,G000240 Gasohol Competition Act of 1980 96-hr-7873 G000240 Rep. Glickman, Dan [D-KS-4] D     0
96-hr-7873,B000363 Gasohol Competition Act of 1980 96-hr-7873 B000363 Rep. Benjamin, Adam, Jr. [D-IN-1] D     0
96-hr-7873,C000201 Gasohol Competition Act of 1980 96-hr-7873 C000201 Rep. Carter, Tim Lee [R-KY-5] R     0
96-hr-7873,C000709 Gasohol Competition Act of 1980 96-hr-7873 C000709 Rep. Conte, Silvio O. [R-MA-1] R     0
96-hr-7873,D000446 Gasohol Competition Act of 1980 96-hr-7873 D000446 Rep. Dougherty, Charles F. [R-PA-4] R     0
96-hr-7873,E000043 Gasohol Competition Act of 1980 96-hr-7873 E000043 Rep. Edgar, Robert W. [D-PA-7] D     0
96-hr-7873,E000064 Gasohol Competition Act of 1980 96-hr-7873 E000064 Rep. Edwards, Don [D-CA-10] D     0
96-hr-7873,E000175 Gasohol Competition Act of 1980 96-hr-7873 E000175 Rep. Emery, David F. [R-ME-1] R     0
96-hr-7873,F000046 Gasohol Competition Act of 1980 96-hr-7873 F000046 Del. Fauntroy, Walter E. [D-DC-At Large] D     0
96-hr-7873,F000088 Gasohol Competition Act of 1980 96-hr-7873 F000088 Rep. Ferraro, Geraldine A. [D-NY-9] D     0
96-hr-7873,F000078 Gasohol Competition Act of 1980 96-hr-7873 F000078 Rep. Fenwick, Millicent H. [R-NJ-5] R     0
96-hr-7873,F000123 Gasohol Competition Act of 1980 96-hr-7873 F000123 Rep. Findley, Paul [R-IL-20] R     0
96-hr-7873,F000161 Gasohol Competition Act of 1980 96-hr-7873 F000161 Rep. Fithian, Floyd J. [D-IN-2] D     0
96-hr-7873,F000392 Gasohol Competition Act of 1980 96-hr-7873 F000392 Rep. Frost, Martin [D-TX-24] D     0
96-hr-7873,G000402 Gasohol Competition Act of 1980 96-hr-7873 G000402 Rep. Gray, William H., III [D-PA-2] D     0
96-hr-7873,H000206 Gasohol Competition Act of 1980 96-hr-7873 H000206 Rep. Harkin, Tom [D-IA-5] D IA   0
96-hr-7873,H000241 Gasohol Competition Act of 1980 96-hr-7873 H000241 Rep. Harris, Herbert E., II [D-VA-8] D     0
96-hr-7873,H000449 Gasohol Competition Act of 1980 96-hr-7873 H000449 Rep. Heftel, Cecil [D-HI-1] D     0
96-hr-7873,H000722 Gasohol Competition Act of 1980 96-hr-7873 H000722 Rep. Hollenbeck, Harold C. [R-NJ-9] R     0
96-hr-7873,K000172 Gasohol Competition Act of 1980 96-hr-7873 K000172 Rep. Kildee, Dale E. [D-MI-7] D     0
96-hr-7873,L000169 Gasohol Competition Act of 1980 96-hr-7873 L000169 Rep. Leach, James A. [R-IA-1] R     0
96-hr-7873,L000187 Gasohol Competition Act of 1980 96-hr-7873 L000187 Rep. Lederer, Raymond F. [D-PA-3] D     0
96-hr-7873,L000413 Gasohol Competition Act of 1980 96-hr-7873 L000413 Rep. Long, Clarence D. [D-MD-2] D     0
96-hr-7873,L000516 Gasohol Competition Act of 1980 96-hr-7873 L000516 Rep. Lundine, Stanley N. [D-NY-39] D     0
96-hr-7873,M000794 Gasohol Competition Act of 1980 96-hr-7873 M000794 Rep. Mineta, Norman Y. [D-CA-13] D     0
96-hr-7873,M000826 Gasohol Competition Act of 1980 96-hr-7873 M000826 Rep. Mitchell, Parren J. [D-MD-7] D     0
96-hr-7873,R000383 Gasohol Competition Act of 1980 96-hr-7873 R000383 Rep. Roe, Robert A. [D-NJ-8] D     0
96-hr-7873,S000465 Gasohol Competition Act of 1980 96-hr-7873 S000465 Rep. Skelton, Ike [D-MO-4] D     0
96-hr-7873,S000716 Gasohol Competition Act of 1980 96-hr-7873 S000716 Rep. Spellman, Gladys Noon [D-MD-5] D     0
96-hr-7873,T000053 Gasohol Competition Act of 1980 96-hr-7873 T000053 Rep. Tauke, Thomas Joseph [R-IA-2] R     0
96-hr-7873,V000024 Gasohol Competition Act of 1980 96-hr-7873 V000024 Rep. Van Deerlin, Lionel [D-CA-42] D CA   0
96-hr-7873,W000044 Gasohol Competition Act of 1980 96-hr-7873 W000044 Rep. Walgren, Doug [D-PA-18] D     0
96-hr-7873,W000227 Gasohol Competition Act of 1980 96-hr-7873 W000227 Rep. Weaver, James H. [D-OR-4] D     0
96-hr-7873,W000520 Gasohol Competition Act of 1980 96-hr-7873 W000520 Rep. Williams, Pat [D-MT-At Large] D     0
96-hr-7873,W000682 Gasohol Competition Act of 1980 96-hr-7873 W000682 Rep. Wolpe, Howard E. [D-MI-3] D     0
96-hr-7873,Y000014 Gasohol Competition Act of 1980 96-hr-7873 Y000014 Rep. Yatron, Gus [D-PA-6] D     0
96-hr-7873,R000012 Gasohol Competition Act of 1980 96-hr-7873 R000012 Rep. Railsback, Thomas F. [R-IL-19] R     0

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 115.483ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API