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

28 rows where bill_id = "97-hconres-168" 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 25
  • 0 3
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
97-hconres-168,H000930 A concurrent resolution expressing the sense of the Congress that there should be established in Greece a permanent site for the summer Olympic Games. 97-hconres-168 H000930 Rep. Hughes, William J. [D-NJ-2] D NJ 1981-12-16 0
97-hconres-168,B000538 A concurrent resolution expressing the sense of the Congress that there should be established in Greece a permanent site for the summer Olympic Games. 97-hconres-168 B000538 Rep. Blanchard, James [D-MI-18] D MI 1981-11-12 0
97-hconres-168,M000794 A concurrent resolution expressing the sense of the Congress that there should be established in Greece a permanent site for the summer Olympic Games. 97-hconres-168 M000794 Rep. Mineta, Norman Y. [D-CA-13] D CA 1981-11-12 0
97-hconres-168,O000134 A concurrent resolution expressing the sense of the Congress that there should be established in Greece a permanent site for the summer Olympic Games. 97-hconres-168 O000134 Rep. Ottinger, Richard L. [D-NY-24] D NY 1981-10-02 1
97-hconres-168,B000318 A concurrent resolution expressing the sense of the Congress that there should be established in Greece a permanent site for the summer Olympic Games. 97-hconres-168 B000318 Rep. Beilenson, Anthony C. [D-CA-23] D CA 1981-10-02 1
97-hconres-168,M000264 A concurrent resolution expressing the sense of the Congress that there should be established in Greece a permanent site for the summer Olympic Games. 97-hconres-168 M000264 Rep. Mavroules, Nicholas [D-MA-6] D MA 1981-10-02 1
97-hconres-168,D000269 A concurrent resolution expressing the sense of the Congress that there should be established in Greece a permanent site for the summer Olympic Games. 97-hconres-168 D000269 Rep. Derwinski, Edward J. [R-IL-4] R IL 1981-10-02 1
97-hconres-168,L000556 A concurrent resolution expressing the sense of the Congress that there should be established in Greece a permanent site for the summer Olympic Games. 97-hconres-168 L000556 Rep. LaFalce, John J. [D-NY-36] D NY 1981-10-02 1
97-hconres-168,F000286 A concurrent resolution expressing the sense of the Congress that there should be established in Greece a permanent site for the summer Olympic Games. 97-hconres-168 F000286 Rep. Forsythe, Edwin B. [R-NJ-6] R NJ 1981-10-02 1
97-hconres-168,W000779 A concurrent resolution expressing the sense of the Congress that there should be established in Greece a permanent site for the summer Olympic Games. 97-hconres-168 W000779 Rep. Wyden, Ron [D-OR-3] D OR 1981-10-02 1
97-hconres-168,F000329 A concurrent resolution expressing the sense of the Congress that there should be established in Greece a permanent site for the summer Olympic Games. 97-hconres-168 F000329 Rep. Fowler, Wyche, Jr. [D-GA-5] D GA 1981-10-02 1
97-hconres-168,O000006 A concurrent resolution expressing the sense of the Congress that there should be established in Greece a permanent site for the summer Olympic Games. 97-hconres-168 O000006 Rep. Oberstar, James L. [D-MN-8] D MN 1981-10-02 1
97-hconres-168,P000444 A concurrent resolution expressing the sense of the Congress that there should be established in Greece a permanent site for the summer Olympic Games. 97-hconres-168 P000444 Rep. Porter, John Edward [R-IL-10] R IL 1981-10-02 1
97-hconres-168,E000043 A concurrent resolution expressing the sense of the Congress that there should be established in Greece a permanent site for the summer Olympic Games. 97-hconres-168 E000043 Rep. Edgar, Robert W. [D-PA-7] D PA 1981-10-02 1
97-hconres-168,B000403 A concurrent resolution expressing the sense of the Congress that there should be established in Greece a permanent site for the summer Olympic Games. 97-hconres-168 B000403 Rep. Bereuter, Doug [R-NE-1] R NE 1981-10-02 1
97-hconres-168,R000232 A concurrent resolution expressing the sense of the Congress that there should be established in Greece a permanent site for the summer Olympic Games. 97-hconres-168 R000232 Rep. Richmond, Frederick W. [D-NY-14] D NY 1981-10-02 1
97-hconres-168,F000053 A concurrent resolution expressing the sense of the Congress that there should be established in Greece a permanent site for the summer Olympic Games. 97-hconres-168 F000053 Rep. Fazio, Vic [D-CA-4] D CA 1981-10-02 1
97-hconres-168,F000270 A concurrent resolution expressing the sense of the Congress that there should be established in Greece a permanent site for the summer Olympic Games. 97-hconres-168 F000270 Rep. Ford, William D. [D-MI-15] D MI 1981-10-02 1
97-hconres-168,L000517 A concurrent resolution expressing the sense of the Congress that there should be established in Greece a permanent site for the summer Olympic Games. 97-hconres-168 L000517 Rep. Lungren, Daniel E. [R-CA-34] R CA 1981-10-02 1
97-hconres-168,C000871 A concurrent resolution expressing the sense of the Congress that there should be established in Greece a permanent site for the summer Olympic Games. 97-hconres-168 C000871 Rep. Crane, Daniel B. [R-IL-22] R IL 1981-10-02 1
97-hconres-168,K000172 A concurrent resolution expressing the sense of the Congress that there should be established in Greece a permanent site for the summer Olympic Games. 97-hconres-168 K000172 Rep. Kildee, Dale E. [D-MI-7] D MI 1981-10-02 1
97-hconres-168,L000508 A concurrent resolution expressing the sense of the Congress that there should be established in Greece a permanent site for the summer Olympic Games. 97-hconres-168 L000508 Rep. Luken, Thomas A. [D-OH-2] D OH 1981-10-02 1
97-hconres-168,C000581 A concurrent resolution expressing the sense of the Congress that there should be established in Greece a permanent site for the summer Olympic Games. 97-hconres-168 C000581 Rep. Coelho, Anthony Lee [D-CA-15] D CA 1981-10-02 1
97-hconres-168,S000423 A concurrent resolution expressing the sense of the Congress that there should be established in Greece a permanent site for the summer Olympic Games. 97-hconres-168 S000423 Rep. Simon, Paul [D-IL-24] D IL 1981-10-02 1
97-hconres-168,D000593 A concurrent resolution expressing the sense of the Congress that there should be established in Greece a permanent site for the summer Olympic Games. 97-hconres-168 D000593 Rep. Dyson, Roy [D-MD-1] D MD 1981-10-02 1
97-hconres-168,W000682 A concurrent resolution expressing the sense of the Congress that there should be established in Greece a permanent site for the summer Olympic Games. 97-hconres-168 W000682 Rep. Wolpe, Howard E. [D-MI-3] D MI 1981-10-02 1
97-hconres-168,S000522 A concurrent resolution expressing the sense of the Congress that there should be established in Greece a permanent site for the summer Olympic Games. 97-hconres-168 S000522 Rep. Smith, Christopher H. [R-NJ-4] R NJ 1981-10-02 1
97-hconres-168,S000230 A concurrent resolution expressing the sense of the Congress that there should be established in Greece a permanent site for the summer Olympic Games. 97-hconres-168 S000230 Rep. Seiberling, John F. [D-OH-14] D OH 1981-10-02 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 68.67ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API