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

41 rows where bill_id = "97-hconres-152" 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 29
  • 0 12
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
97-hconres-152,G000524 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 G000524 Rep. Gunderson, Steve [R-WI-3] R WI 1981-12-16 0
97-hconres-152,S000303 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 S000303 Rep. Shaw, E. Clay, Jr. [R-FL-12] R FL 1981-12-16 0
97-hconres-152,M000826 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 M000826 Rep. Mitchell, Parren J. [D-MD-7] D MD 1981-07-09 0
97-hconres-152,F000088 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 F000088 Rep. Ferraro, Geraldine A. [D-NY-9] D NY 1981-07-09 0
97-hconres-152,E000198 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 E000198 Rep. Erdahl, Arlen [R-MN-1] R MN 1981-07-09 0
97-hconres-152,M000839 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 M000839 Rep. Moffett, Toby [D-CT-6] D CT 1981-07-09 0
97-hconres-152,C000714 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 C000714 Rep. Conyers, John, Jr. [D-MI-1] D MI 1981-06-26 0
97-hconres-152,C000788 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 C000788 Resident Commissioner Corrada, Baltasar [I-PR-At Large] I PR 1981-06-26 0
97-hconres-152,J000072 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 J000072 Rep. Jeffords, James M. [R-VT-At Large] R VT 1981-06-26 0
97-hconres-152,M000692 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 M000692 Rep. Michel, Robert H. [R-IL-18] R IL 1981-06-26 0
97-hconres-152,O000007 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 O000007 Rep. Obey, David R. [D-WI-7] D WI 1981-06-26 0
97-hconres-152,S000005 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 S000005 Rep. Sabo, Martin Olav [D-MN-5] D MN 1981-06-26 0
97-hconres-152,B000160 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 B000160 Rep. Barnes, Michael D. [D-MD-8] D MD 1981-06-22 1
97-hconres-152,B000298 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 B000298 Rep. Bedell, Berkley W. [D-IA-6] D IA 1981-06-22 1
97-hconres-152,B000318 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 B000318 Rep. Beilenson, Anthony C. [D-CA-23] D CA 1981-06-22 1
97-hconres-152,B000619 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 B000619 Rep. Bonior, David E. [D-MI-12] D MI 1981-06-22 1
97-hconres-152,D000017 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 D000017 Rep. D'Amours, Norman E. [D-NH-1] D NH 1981-06-22 1
97-hconres-152,E000031 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 E000031 Rep. Eckart, Dennis E. [D-OH-22] D OH 1981-06-22 1
97-hconres-152,E000043 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 E000043 Rep. Edgar, Robert W. [D-PA-7] D PA 1981-06-22 1
97-hconres-152,E000064 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 E000064 Rep. Edwards, Don [D-CA-10] D CA 1981-06-22 1
97-hconres-152,F000041 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 F000041 Rep. Fascell, Dante B. [D-FL-15] D FL 1981-06-22 1
97-hconres-152,F000235 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 F000235 Rep. Foglietta, Thomas M. [D-PA-1] D PA 1981-06-22 1
97-hconres-152,F000286 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 F000286 Rep. Forsythe, Edwin B. [R-NJ-6] R NJ 1981-06-22 1
97-hconres-152,F000329 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 F000329 Rep. Fowler, Wyche, Jr. [D-GA-5] D GA 1981-06-22 1
97-hconres-152,F000339 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 F000339 Rep. Frank, Barney [D-MA-4] D MA 1981-06-22 1
97-hconres-152,F000380 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 F000380 Rep. Frenzel, Bill [R-MN-3] R MN 1981-06-22 1
97-hconres-152,G000445 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 G000445 Rep. Gregg, Judd [R-NH-2] R NH 1981-06-22 1
97-hconres-152,H000722 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 H000722 Rep. Hollenbeck, Harold C. [R-NJ-9] R NJ 1981-06-22 1
97-hconres-152,H000747 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 H000747 Rep. Holt, Marjorie S. [R-MD-4] R MD 1981-06-22 1
97-hconres-152,H000797 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 H000797 Rep. Horton, Frank J. [R-NY-34] R NY 1981-06-22 1
97-hconres-152,M000808 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 M000808 Rep. Mitchell, Donald J. [R-NY-31] R NY 1981-06-22 1
97-hconres-152,M000834 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 M000834 Rep. Moakley, John Joseph [D-MA-9] D MA 1981-06-22 1
97-hconres-152,V000087 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 V000087 Rep. Vento, Bruce F. [D-MN-4] D MN 1981-06-22 1
97-hconres-152,W000258 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 W000258 Rep. Weiss, Ted [D-NY-20] D NY 1981-06-22 1
97-hconres-152,W000636 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 W000636 Rep. Winn, Larry, Jr. [R-KS-3] R KS 1981-06-22 1
97-hconres-152,O000134 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 O000134 Rep. Ottinger, Richard L. [D-NY-24] D NY 1981-06-22 1
97-hconres-152,M000794 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 M000794 Rep. Mineta, Norman Y. [D-CA-13] D CA 1981-06-22 1
97-hconres-152,K000172 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 K000172 Rep. Kildee, Dale E. [D-MI-7] D MI 1981-06-22 1
97-hconres-152,M000133 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 M000133 Rep. Markey, Edward J. [D-MA-7] D MA 1981-06-22 1
97-hconres-152,G000153 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 G000153 Rep. Gibbons, Sam [D-FL-7] D FL 1981-06-22 1
97-hconres-152,B000620 A concurrent resolution expressing the sense of the Congress concerning the establishment of a North American Air Quality Commission. 97-hconres-152 B000620 Rep. Bonker, Don [D-WA-3] D WA 1981-06-22 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);