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

37 rows where bill_id = "100-hjres-620" 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

  • 1 33
  • 0 4
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
100-hjres-620,C000293 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 C000293 Rep. Chandler, Rod D. [R-WA-8] R WA 1988-08-08 0
100-hjres-620,J000072 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 J000072 Rep. Jeffords, James M. [R-VT-At Large] R VT 1988-08-04 0
100-hjres-620,D000435 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 D000435 Rep. Dornan, Robert K. [R-CA-38] R CA 1988-08-04 0
100-hjres-620,S000663 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 S000663 Rep. Snowe, Olympia J. [R-ME-2] R ME 1988-08-04 0
100-hjres-620,C000919 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 C000919 Rep. Crockett, George W., Jr. [D-MI-13] D MI 1988-07-14 1
100-hjres-620,L000020 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 L000020 Rep. Lagomarsino, Robert J. [R-CA-19] R CA 1988-07-14 1
100-hjres-620,F000041 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 F000041 Rep. Fascell, Dante B. [D-FL-19] D FL 1988-07-14 1
100-hjres-620,B000890 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 B000890 Rep. Broomfield, William S. [R-MI-18] R MI 1988-07-14 1
100-hjres-620,H000114 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 H000114 Rep. Hamilton, Lee H. [D-IN-9] D IN 1988-07-14 1
100-hjres-620,G000212 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 G000212 Rep. Gilman, Benjamin A. [R-NY-22] R NY 1988-07-14 1
100-hjres-620,S000673 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 S000673 Rep. Solarz, Stephen J. [D-NY-13] D NY 1988-07-14 1
100-hjres-620,W000258 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 W000258 Rep. Weiss, Ted [D-NY-17] D NY 1988-07-14 1
100-hjres-620,B000403 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 B000403 Rep. Bereuter, Doug [R-NE-1] R NE 1988-07-14 1
100-hjres-620,B000620 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 B000620 Rep. Bonker, Don [D-WA-3] D WA 1988-07-14 1
100-hjres-620,S000522 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 S000522 Rep. Smith, Christopher H. [R-NJ-4] R NJ 1988-07-14 1
100-hjres-620,L000090 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 L000090 Rep. Lantos, Tom [D-CA-11] D CA 1988-07-14 1
100-hjres-620,M000736 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 M000736 Rep. Miller, John R. [R-WA-1] R WA 1988-07-14 1
100-hjres-620,G000120 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 G000120 Rep. Gejdenson, Sam [D-CT-2] D CT 1988-07-14 1
100-hjres-620,W000682 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 W000682 Rep. Wolpe, Howard E. [D-MI-3] D MI 1988-07-14 1
100-hjres-620,A000226 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 A000226 Rep. Atkins, Chester G. [D-MA-5] D MA 1988-07-14 1
100-hjres-620,F000059 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 F000059 Rep. Feighan, Edward F. [D-OH-19] D OH 1988-07-14 1
100-hjres-620,T000317 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 T000317 Rep. Torricelli, Robert G. [D-NJ-9] D NJ 1988-07-14 1
100-hjres-620,K000319 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 K000319 Rep. Kostmayer, Peter H. [D-PA-8] D PA 1988-07-14 1
100-hjres-620,A000022 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 A000022 Rep. Ackerman, Gary L. [D-NY-7] D NY 1988-07-14 1
100-hjres-620,O000156 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 O000156 Rep. Owens, Wayne [D-UT-2] D UT 1988-07-14 1
100-hjres-620,S001077 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 S001077 Del. Sunia, Foto I. F. [D-AS-At Large] D AS 1988-07-14 1
100-hjres-620,B000551 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 B000551 Del. Blaz, Ben G. [R-GU-At Large] R GU 1988-07-14 1
100-hjres-620,L000169 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 L000169 Rep. Leach, James A. [R-IA-1] R IA 1988-07-14 1
100-hjres-620,B000462 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 B000462 Rep. Bilbray, James H. [D-NV-1] D NV 1988-07-14 1
100-hjres-620,L000264 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 L000264 Rep. Levine, Mel [D-CA-27] D CA 1988-07-14 1
100-hjres-620,D000294 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 D000294 Rep. DeWine, Mike [R-OH-7] R OH 1988-07-14 1
100-hjres-620,F000435 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 F000435 Resident Commissioner Fuster, Jamie B. [D-PR-At Large] D PR 1988-07-14 1
100-hjres-620,B000410 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 B000410 Rep. Berman, Howard L. [D-CA-26] D CA 1988-07-14 1
100-hjres-620,R000229 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 R000229 Rep. Richardson, Bill [D-NM-3] D NM 1988-07-14 1
100-hjres-620,S001040 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 S001040 Rep. Studds, Gerry E. [D-MA-10] D MA 1988-07-14 1
100-hjres-620,S000586 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 S000586 Rep. Smith, Lawrence [D-FL-16] D FL 1988-07-14 1
100-hjres-620,M000688 A joint resolution expressing the support of the United States for the restoration of full and genuine democracy in Chile and calling upon the Government of Chile to take the steps necessary to assure that the will of the Chilean people is freely, fully, and accurately expressed in the upcoming plebiscite. 100-hjres-620 M000688 Rep. Mica, Daniel Andrew [D-FL-14] D FL 1988-07-14 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 6.378ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API