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

23 rows where bill_id = "97-s-1657" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, state, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

  • 0 18
  • 1 5
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
97-s-1657,D000030 A bill entitled the "Uniform Science and Technology Research and Development Utilization Act." 97-s-1657 D000030 Sen. Danforth, John C. [R-MO] R MO 1982-05-27 0
97-s-1657,P000513 A bill entitled the "Uniform Science and Technology Research and Development Utilization Act." 97-s-1657 P000513 Sen. Pressler, Larry [R-SD] R SD 1982-05-27 0
97-s-1657,D000366 A bill entitled the "Uniform Science and Technology Research and Development Utilization Act." 97-s-1657 D000366 Sen. Dixon, Alan J. [D-IL] D IL 1982-05-27 0
97-s-1657,L000174 A bill entitled the "Uniform Science and Technology Research and Development Utilization Act." 97-s-1657 L000174 Sen. Leahy, Patrick J. [D-VT] D VT 1982-05-27 0
97-s-1657,Z000013 A bill entitled the "Uniform Science and Technology Research and Development Utilization Act." 97-s-1657 Z000013 Sen. Zorinsky, Edward [D-NE] D NE 1982-05-27 0
97-s-1657,P000222 A bill entitled the "Uniform Science and Technology Research and Development Utilization Act." 97-s-1657 P000222 Sen. Percy, Charles H. [R-IL] R IL 1982-05-27 0
97-s-1657,G000267 A bill entitled the "Uniform Science and Technology Research and Development Utilization Act." 97-s-1657 G000267 Sen. Goldwater, Barry [R-AZ] R AZ 1982-05-27 0
97-s-1657,D000407 A bill entitled the "Uniform Science and Technology Research and Development Utilization Act." 97-s-1657 D000407 Sen. Domenici, Pete V. [R-NM] R NM 1982-05-27 0
97-s-1657,K000019 A bill entitled the "Uniform Science and Technology Research and Development Utilization Act." 97-s-1657 K000019 Sen. Kasten, Robert W., Jr. [R-WI] R WI 1982-05-27 0
97-s-1657,D000185 A bill entitled the "Uniform Science and Technology Research and Development Utilization Act." 97-s-1657 D000185 Sen. DeConcini, Dennis [D-AZ] D AZ 1982-05-27 0
97-s-1657,H000343 A bill entitled the "Uniform Science and Technology Research and Development Utilization Act." 97-s-1657 H000343 Sen. Hatfield, Mark O. [R-OR] R OR 1982-05-27 0
97-s-1657,M000257 A bill entitled the "Uniform Science and Technology Research and Development Utilization Act." 97-s-1657 M000257 Sen. Mattingly, Mack [R-GA] R GA 1982-05-27 0
97-s-1657,H000374 A bill entitled the "Uniform Science and Technology Research and Development Utilization Act." 97-s-1657 H000374 Sen. Hawkins, Paula [R-FL] R FL 1982-05-27 0
97-s-1657,J000101 A bill entitled the "Uniform Science and Technology Research and Development Utilization Act." 97-s-1657 J000101 Sen. Jepsen, Roger W. [R-IA] R IA 1982-05-27 0
97-s-1657,H000456 A bill entitled the "Uniform Science and Technology Research and Development Utilization Act." 97-s-1657 H000456 Sen. Heinz, John [R-PA] R PA 1982-05-27 0
97-s-1657,H000384 A bill entitled the "Uniform Science and Technology Research and Development Utilization Act." 97-s-1657 H000384 Sen. Hayakawa, Samuel Ichiye [R-CA] R CA 1982-05-27 0
97-s-1657,R000249 A bill entitled the "Uniform Science and Technology Research and Development Utilization Act." 97-s-1657 R000249 Sen. Riegle, Donald W., Jr. [D-MI] D MI 1982-05-27 0
97-s-1657,H000445 A bill entitled the "Uniform Science and Technology Research and Development Utilization Act." 97-s-1657 H000445 Sen. Heflin, Howell [D-AL] D AL 1982-05-27 0
97-s-1657,C000120 A bill entitled the "Uniform Science and Technology Research and Development Utilization Act." 97-s-1657 C000120 Sen. Cannon, Howard W. [D-NV] D NV 1981-09-23 1
97-s-1657,G000333 A bill entitled the "Uniform Science and Technology Research and Development Utilization Act." 97-s-1657 G000333 Sen. Gorton, Slade [R-WA] R WA 1981-09-23 1
97-s-1657,K000017 A bill entitled the "Uniform Science and Technology Research and Development Utilization Act." 97-s-1657 K000017 Sen. Kassebaum, Nancy Landon [R-KS] R KS 1981-09-23 1
97-s-1657,L000504 A bill entitled the "Uniform Science and Technology Research and Development Utilization Act." 97-s-1657 L000504 Sen. Lugar, Richard G. [R-IN] R IN 1981-09-23 1
97-s-1657,S001138 A bill entitled the "Uniform Science and Technology Research and Development Utilization Act." 97-s-1657 S001138 Sen. Symms, Steven D. [R-ID] R ID 1981-09-23 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);