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

26 rows where bill_id = "103-hconres-288" 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 26
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
103-hconres-288,G000120 Expressing the sense of the Congress with respect to children infected with AIDS in Romania. 103-hconres-288 G000120 Rep. Gejdenson, Sam [D-CT-2] D CT 1994-08-19 1
103-hconres-288,G000291 Expressing the sense of the Congress with respect to children infected with AIDS in Romania. 103-hconres-288 G000291 Rep. Goodling, William F. [R-PA-19] R PA 1994-08-19 1
103-hconres-288,L000090 Expressing the sense of the Congress with respect to children infected with AIDS in Romania. 103-hconres-288 L000090 Rep. Lantos, Tom [D-CA-12] D CA 1994-08-19 1
103-hconres-288,L000169 Expressing the sense of the Congress with respect to children infected with AIDS in Romania. 103-hconres-288 L000169 Rep. Leach, James A. [R-IA-1] R IA 1994-08-19 1
103-hconres-288,A000022 Expressing the sense of the Congress with respect to children infected with AIDS in Romania. 103-hconres-288 A000022 Rep. Ackerman, Gary L. [D-NY-5] D NY 1994-08-19 1
103-hconres-288,H001022 Expressing the sense of the Congress with respect to children infected with AIDS in Romania. 103-hconres-288 H001022 Rep. Hyde, Henry J. [R-IL-6] R IL 1994-08-19 1
103-hconres-288,E000179 Expressing the sense of the Congress with respect to children infected with AIDS in Romania. 103-hconres-288 E000179 Rep. Engel, Eliot L. [D-NY-17] D NY 1994-08-19 1
103-hconres-288,S000522 Expressing the sense of the Congress with respect to children infected with AIDS in Romania. 103-hconres-288 S000522 Rep. Smith, Christopher H. [R-NJ-4] R NJ 1994-08-19 1
103-hconres-288,F000010 Expressing the sense of the Congress with respect to children infected with AIDS in Romania. 103-hconres-288 F000010 Del. Faleomavaega, Eni F. H. [D-AS-At Large] D AS 1994-08-19 1
103-hconres-288,M000684 Expressing the sense of the Congress with respect to children infected with AIDS in Romania. 103-hconres-288 M000684 Rep. Meyers, Jan [R-KS-3] R KS 1994-08-19 1
103-hconres-288,B000644 Expressing the sense of the Congress with respect to children infected with AIDS in Romania. 103-hconres-288 B000644 Rep. Borski, Robert A. [D-PA-3] D PA 1994-08-19 1
103-hconres-288,G000021 Expressing the sense of the Congress with respect to children infected with AIDS in Romania. 103-hconres-288 G000021 Rep. Gallegly, Elton [R-CA-23] R CA 1994-08-19 1
103-hconres-288,A000210 Expressing the sense of the Congress with respect to children infected with AIDS in Romania. 103-hconres-288 A000210 Rep. Andrews, Robert E. [D-NJ-1] D NJ 1994-08-19 1
103-hconres-288,B000104 Expressing the sense of the Congress with respect to children infected with AIDS in Romania. 103-hconres-288 B000104 Rep. Ballenger, Cass [R-NC-10] R NC 1994-08-19 1
103-hconres-288,B000944 Expressing the sense of the Congress with respect to children infected with AIDS in Romania. 103-hconres-288 B000944 Rep. Brown, Sherrod [D-OH-13] D OH 1994-08-19 1
103-hconres-288,R000409 Expressing the sense of the Congress with respect to children infected with AIDS in Romania. 103-hconres-288 R000409 Rep. Rohrabacher, Dana [R-CA-45] R CA 1994-08-19 1
103-hconres-288,M000523 Expressing the sense of the Congress with respect to children infected with AIDS in Romania. 103-hconres-288 M000523 Rep. McKinney, Cynthia A. [D-GA-11] D GA 1994-08-19 1
103-hconres-288,L000267 Expressing the sense of the Congress with respect to children infected with AIDS in Romania. 103-hconres-288 L000267 Rep. Levy, David A. [R-NY-4] R NY 1994-08-19 1
103-hconres-288,H000324 Expressing the sense of the Congress with respect to children infected with AIDS in Romania. 103-hconres-288 H000324 Rep. Hastings, Alcee L. [D-FL-23] D FL 1994-08-19 1
103-hconres-288,D000299 Expressing the sense of the Congress with respect to children infected with AIDS in Romania. 103-hconres-288 D000299 Rep. Diaz-Balart, Lincoln [R-FL-21] R FL 1994-08-19 1
103-hconres-288,F000128 Expressing the sense of the Congress with respect to children infected with AIDS in Romania. 103-hconres-288 F000128 Rep. Fingerhut, Eric D. [D-OH-19] D OH 1994-08-19 1
103-hconres-288,R000487 Expressing the sense of the Congress with respect to children infected with AIDS in Romania. 103-hconres-288 R000487 Rep. Royce, Edward R. [R-CA-39] R CA 1994-08-19 1
103-hconres-288,D000275 Expressing the sense of the Congress with respect to children infected with AIDS in Romania. 103-hconres-288 D000275 Rep. Deutsch, Peter [D-FL-20] D FL 1994-08-19 1
103-hconres-288,W000672 Expressing the sense of the Congress with respect to children infected with AIDS in Romania. 103-hconres-288 W000672 Rep. Wolf, Frank R. [R-VA-10] R VA 1994-08-19 1
103-hconres-288,W000784 Expressing the sense of the Congress with respect to children infected with AIDS in Romania. 103-hconres-288 W000784 Rep. Wynn, Albert Russell [D-MD-4] D MD 1994-08-19 1
103-hconres-288,G000535 Expressing the sense of the Congress with respect to children infected with AIDS in Romania. 103-hconres-288 G000535 Rep. Gutierrez, Luis V. [D-IL-4] D IL 1994-08-19 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 7.725ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API