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 = "96-hr-4598" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, state

is_original_cosponsor 1

  • 0 28
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
96-hr-4598,W000258 Elderly Homeowner's Relief Act 96-hr-4598 W000258 Rep. Weiss, Ted [D-NY-20] D     0
96-hr-4598,W000686 Elderly Homeowner's Relief Act 96-hr-4598 W000686 Del. Won Pat, Antonio B. [D-GU-At Large] D     0
96-hr-4598,B000600 Elderly Homeowner's Relief Act 96-hr-4598 B000600 Rep. Boland, Edward P. [D-MA-2] D     0
96-hr-4598,V000087 Elderly Homeowner's Relief Act 96-hr-4598 V000087 Rep. Vento, Bruce F. [D-MN-4] D     0
96-hr-4598,L000226 Elderly Homeowner's Relief Act 96-hr-4598 L000226 Rep. Lehman, William [D-FL-13] D     0
96-hr-4598,F000209 Elderly Homeowner's Relief Act 96-hr-4598 F000209 Rep. Flood, Daniel J. [D-PA-11] D PA   0
96-hr-4598,Y000014 Elderly Homeowner's Relief Act 96-hr-4598 Y000014 Rep. Yatron, Gus [D-PA-6] D     0
96-hr-4598,S000005 Elderly Homeowner's Relief Act 96-hr-4598 S000005 Rep. Sabo, Martin Olav [D-MN-5] D     0
96-hr-4598,L000556 Elderly Homeowner's Relief Act 96-hr-4598 L000556 Rep. LaFalce, John J. [D-NY-36] D     0
96-hr-4598,D000064 Elderly Homeowner's Relief Act 96-hr-4598 D000064 Rep. Daschle, Thomas A. [D-SD-At Large] D     0
96-hr-4598,S000948 Elderly Homeowner's Relief Act 96-hr-4598 S000948 Rep. Stokes, Louis [D-OH-21] D OH   0
96-hr-4598,D000471 Elderly Homeowner's Relief Act 96-hr-4598 D000471 Rep. Downey, Thomas J. [D-NY-2] D     0
96-hr-4598,O000134 Elderly Homeowner's Relief Act 96-hr-4598 O000134 Rep. Ottinger, Richard L. [D-NY-24] D NY   0
96-hr-4598,S000778 Elderly Homeowner's Relief Act 96-hr-4598 S000778 Rep. Staggers, Harley O. [D-WV-2] D     0
96-hr-4598,L000486 Elderly Homeowner's Relief Act 96-hr-4598 L000486 Rep. Lowry, Mike [D-WA-7] D     0
96-hr-4598,M000365 Elderly Homeowner's Relief Act 96-hr-4598 M000365 Rep. McCormack, Mike [D-WA-4] D     0
96-hr-4598,P000546 Elderly Homeowner's Relief Act 96-hr-4598 P000546 Rep. Pritchard, Joel [R-WA-1] R     0
96-hr-4598,P000121 Elderly Homeowner's Relief Act 96-hr-4598 P000121 Rep. Patterson, Jerry M. [D-CA-38] D     0
96-hr-4598,C000201 Elderly Homeowner's Relief Act 96-hr-4598 C000201 Rep. Carter, Tim Lee [R-KY-5] R     0
96-hr-4598,F000088 Elderly Homeowner's Relief Act 96-hr-4598 F000088 Rep. Ferraro, Geraldine A. [D-NY-9] D     0
96-hr-4598,C000807 Elderly Homeowner's Relief Act 96-hr-4598 C000807 Rep. Coughlin, Lawrence [R-PA-13] R     0
96-hr-4598,J000099 Elderly Homeowner's Relief Act 96-hr-4598 J000099 Rep. Jenrette, John W., Jr. [D-SC-6] D     0
96-hr-4598,M000058 Elderly Homeowner's Relief Act 96-hr-4598 M000058 Rep. Maguire, Andrew [D-NJ-7] D     0
96-hr-4598,M001098 Elderly Homeowner's Relief Act 96-hr-4598 M001098 Rep. Murphy, John M. [D-NY-17] D NY   0
96-hr-4598,N000016 Elderly Homeowner's Relief Act 96-hr-4598 N000016 Rep. Neal, Stephen L. [D-NC-5] D     0
96-hr-4598,B000910 Elderly Homeowner's Relief Act 96-hr-4598 B000910 Rep. Brown, Clarence, Jr. [R-OH-7] R     0
96-hr-4598,W000680 Elderly Homeowner's Relief Act 96-hr-4598 W000680 Rep. Wolff, Lester L. [D-NY-6] D NY   0
96-hr-4598,W000647 Elderly Homeowner's Relief Act 96-hr-4598 W000647 Rep. Wirth, Timothy [D-CO-2] D     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);