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 = "96-hconres-430" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party

is_original_cosponsor 1

  • 0 26
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
96-hconres-430,O000010 A concurrent resolution expressing the sense of the Congress with respect to the equal treatment by the United States Government of persons violating the law. 96-hconres-430 O000010 Rep. O'Brien, George M. [R-IL-17] R     0
96-hconres-430,M000926 A concurrent resolution expressing the sense of the Congress with respect to the equal treatment by the United States Government of persons violating the law. 96-hconres-430 M000926 Rep. Moorhead, Carlos J. [R-CA-22] R     0
96-hconres-430,F000088 A concurrent resolution expressing the sense of the Congress with respect to the equal treatment by the United States Government of persons violating the law. 96-hconres-430 F000088 Rep. Ferraro, Geraldine A. [D-NY-9] D     0
96-hconres-430,S000087 A concurrent resolution expressing the sense of the Congress with respect to the equal treatment by the United States Government of persons violating the law. 96-hconres-430 S000087 Rep. Sawyer, Harold S. [R-MI-5] R     0
96-hconres-430,H001022 A concurrent resolution expressing the sense of the Congress with respect to the equal treatment by the United States Government of persons violating the law. 96-hconres-430 H001022 Rep. Hyde, Henry J. [R-IL-6] R     0
96-hconres-430,W000406 A concurrent resolution expressing the sense of the Congress with respect to the equal treatment by the United States Government of persons violating the law. 96-hconres-430 W000406 Rep. Whitehurst, G. William [R-VA-2] R     0
96-hconres-430,B000363 A concurrent resolution expressing the sense of the Congress with respect to the equal treatment by the United States Government of persons violating the law. 96-hconres-430 B000363 Rep. Benjamin, Adam, Jr. [D-IN-1] D     0
96-hconres-430,W000194 A concurrent resolution expressing the sense of the Congress with respect to the equal treatment by the United States Government of persons violating the law. 96-hconres-430 W000194 Rep. Watkins, Wes [D-OK-3] R     0
96-hconres-430,F000286 A concurrent resolution expressing the sense of the Congress with respect to the equal treatment by the United States Government of persons violating the law. 96-hconres-430 F000286 Rep. Forsythe, Edwin B. [R-NJ-6] R     0
96-hconres-430,M000413 A concurrent resolution expressing the sense of the Congress with respect to the equal treatment by the United States Government of persons violating the law. 96-hconres-430 M000413 Rep. McDonald, Lawrence P. [D-GA-7] D     0
96-hconres-430,M001101 A concurrent resolution expressing the sense of the Congress with respect to the equal treatment by the United States Government of persons violating the law. 96-hconres-430 M001101 Rep. Murphy, Morgan F. [D-IL-2] D IL   0
96-hconres-430,S000810 A concurrent resolution expressing the sense of the Congress with respect to the equal treatment by the United States Government of persons violating the law. 96-hconres-430 S000810 Rep. Stark, Fortney Pete [D-CA-9] D     0
96-hconres-430,H000878 A concurrent resolution expressing the sense of the Congress with respect to the equal treatment by the United States Government of persons violating the law. 96-hconres-430 H000878 Rep. Hubbard, Carroll, Jr. [D-KY-1] D     0
96-hconres-430,R000459 A concurrent resolution expressing the sense of the Congress with respect to the equal treatment by the United States Government of persons violating the law. 96-hconres-430 R000459 Rep. Roth, Toby [R-WI-8] R     0
96-hconres-430,R000383 A concurrent resolution expressing the sense of the Congress with respect to the equal treatment by the United States Government of persons violating the law. 96-hconres-430 R000383 Rep. Roe, Robert A. [D-NJ-8] D     0
96-hconres-430,D000269 A concurrent resolution expressing the sense of the Congress with respect to the equal treatment by the United States Government of persons violating the law. 96-hconres-430 D000269 Rep. Derwinski, Edward J. [R-IL-4] R     0
96-hconres-430,S000320 A concurrent resolution expressing the sense of the Congress with respect to the equal treatment by the United States Government of persons violating the law. 96-hconres-430 S000320 Rep. Shelby, Richard C. [D-AL-7] R AL   0
96-hconres-430,F000392 A concurrent resolution expressing the sense of the Congress with respect to the equal treatment by the United States Government of persons violating the law. 96-hconres-430 F000392 Rep. Frost, Martin [D-TX-24] D     0
96-hconres-430,B000862 A concurrent resolution expressing the sense of the Congress with respect to the equal treatment by the United States Government of persons violating the law. 96-hconres-430 B000862 Rep. Brodhead, William [D-MI-17] D     0
96-hconres-430,M000794 A concurrent resolution expressing the sense of the Congress with respect to the equal treatment by the United States Government of persons violating the law. 96-hconres-430 M000794 Rep. Mineta, Norman Y. [D-CA-13] D     0
96-hconres-430,R000262 A concurrent resolution expressing the sense of the Congress with respect to the equal treatment by the United States Government of persons violating the law. 96-hconres-430 R000262 Rep. Rinaldo, Matthew J. [R-NJ-12] R     0
96-hconres-430,Y000014 A concurrent resolution expressing the sense of the Congress with respect to the equal treatment by the United States Government of persons violating the law. 96-hconres-430 Y000014 Rep. Yatron, Gus [D-PA-6] D     0
96-hconres-430,M000136 A concurrent resolution expressing the sense of the Congress with respect to the equal treatment by the United States Government of persons violating the law. 96-hconres-430 M000136 Rep. Marks, Marc L. [R-PA-24] R     0
96-hconres-430,R000543 A concurrent resolution expressing the sense of the Congress with respect to the equal treatment by the United States Government of persons violating the law. 96-hconres-430 R000543 Rep. Russo, Martin A. [D-IL-3] D     0
96-hconres-430,D000446 A concurrent resolution expressing the sense of the Congress with respect to the equal treatment by the United States Government of persons violating the law. 96-hconres-430 D000446 Rep. Dougherty, Charles F. [R-PA-4] R     0
96-hconres-430,Y000033 A concurrent resolution expressing the sense of the Congress with respect to the equal treatment by the United States Government of persons violating the law. 96-hconres-430 Y000033 Rep. Young, Don [R-AK-At Large] R AK   0

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 335.513ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API