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

32 rows where bill_id = "100-hconres-353" 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 32
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
100-hconres-353,M000023 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 M000023 Rep. MacKay, Buddy [D-FL-6] D FL 1988-08-10 1
100-hconres-353,R000383 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 R000383 Rep. Roe, Robert A. [D-NJ-8] D NJ 1988-08-10 1
100-hconres-353,N000032 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 N000032 Rep. Nelson, Bill [D-FL-11] D FL 1988-08-10 1
100-hconres-353,S000479 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 S000479 Rep. Slaughter, D. French, Jr. [R-VA-7] R VA 1988-08-10 1
100-hconres-353,M000398 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 M000398 Rep. McCurdy, Dave [D-OK-4] D OK 1988-08-10 1
100-hconres-353,W000215 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 W000215 Rep. Waxman, Henry A. [D-CA-24] D CA 1988-08-10 1
100-hconres-353,M000941 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 M000941 Rep. Morella, Constance A. [R-MD-8] R MD 1988-08-10 1
100-hconres-353,C000709 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 C000709 Rep. Conte, Silvio O. [R-MA-1] R MA 1988-08-10 1
100-hconres-353,P000005 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 P000005 Rep. Packard, Ron [R-CA-43] R CA 1988-08-10 1
100-hconres-353,L000274 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 L000274 Rep. Lewis, Jerry [R-CA-35] R CA 1988-08-10 1
100-hconres-353,G000021 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 G000021 Rep. Gallegly, Elton [R-CA-21] R CA 1988-08-10 1
100-hconres-353,B000586 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 B000586 Rep. Boehlert, Sherwood [R-NY-25] R NY 1988-08-10 1
100-hconres-353,P000326 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 P000326 Rep. Pickett, Owen B. [D-VA-2] D VA 1988-08-10 1
100-hconres-353,R000189 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 R000189 Rep. Rhodes, John J., III [R-AZ-1] R AZ 1988-08-10 1
100-hconres-353,H000236 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 H000236 Rep. Harris, Claude [D-AL-7] D AL 1988-08-10 1
100-hconres-353,F000208 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 F000208 Rep. Flippo, Ronnie G. [D-AL-5] D AL 1988-08-10 1
100-hconres-353,W000237 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 W000237 Rep. Weber, Vin [R-MN-2] R MN 1988-08-10 1
100-hconres-353,H000901 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 H000901 Rep. Huckaby, Thomas J. (Jerry) [D-LA-5] D LA 1988-08-10 1
100-hconres-353,I000024 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 I000024 Rep. Inhofe, James M. [R-OK-1] R OK 1988-08-10 1
100-hconres-353,S000463 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 S000463 Rep. Skeen, Joe [R-NM-2] R NM 1988-08-10 1
100-hconres-353,M000573 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 M000573 Rep. McMillen, Thomas [D-MD-4] D MD 1988-08-10 1
100-hconres-353,P000229 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 P000229 Rep. Perkins, Carl C. [D-KY-7] D KY 1988-08-10 1
100-hconres-353,N000016 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 N000016 Rep. Neal, Stephen L. [D-NC-5] D NC 1988-08-10 1
100-hconres-353,R000277 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 R000277 Rep. Ritter, Don [R-PA-15] R PA 1988-08-10 1
100-hconres-353,F000053 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 F000053 Rep. Fazio, Vic [D-CA-4] D CA 1988-08-10 1
100-hconres-353,L000264 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 L000264 Rep. Levine, Mel [D-CA-27] D CA 1988-08-10 1
100-hconres-353,G000225 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 G000225 Rep. Gingrich, Newt [R-GA-6] R GA 1988-08-10 1
100-hconres-353,H000390 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 H000390 Rep. Hayes, James A. [D-LA-7] D LA 1988-08-10 1
100-hconres-353,L000295 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 L000295 Rep. Lewis, Thomas F. [R-FL-12] R FL 1988-08-10 1
100-hconres-353,H001018 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 H001018 Rep. Hutto, Earl [D-FL-1] D FL 1988-08-10 1
100-hconres-353,B000431 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 B000431 Rep. Bevill, Tom [D-AL-4] D AL 1988-08-10 1
100-hconres-353,B000229 A concurrent resolution expressing the sense of the Congress that the United States should make the space program a national priority. 100-hconres-353 B000229 Rep. Bateman, Herbert H. [R-VA-1] R VA 1988-08-10 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 538.884ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API