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

37 rows where bill_id = "103-hr-3397" 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

  • 0 35
  • 1 2
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
103-hr-3397,S000094 Presidential FEMA Reform Act of 1993 103-hr-3397 S000094 Rep. Sawyer, Tom [D-OH-14] D OH 1994-10-07 0
103-hr-3397,U000014 Presidential FEMA Reform Act of 1993 103-hr-3397 U000014 Del. Underwood, Robert A. [D-GU-At Large] D GU 1994-08-19 0
103-hr-3397,B000318 Presidential FEMA Reform Act of 1993 103-hr-3397 B000318 Rep. Beilenson, Anthony C. [D-CA-24] D CA 1994-08-10 0
103-hr-3397,M000291 Presidential FEMA Reform Act of 1993 103-hr-3397 M000291 Rep. Mazzoli, Romano L. [D-KY-3] D KY 1994-08-03 0
103-hr-3397,K000009 Presidential FEMA Reform Act of 1993 103-hr-3397 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 1994-08-03 0
103-hr-3397,D000299 Presidential FEMA Reform Act of 1993 103-hr-3397 D000299 Rep. Diaz-Balart, Lincoln [R-FL-21] R FL 1994-07-21 0
103-hr-3397,M000129 Presidential FEMA Reform Act of 1993 103-hr-3397 M000129 Rep. Margolies-Mezvinsky, Marjorie [D-PA-13] D PA 1994-07-21 0
103-hr-3397,E000179 Presidential FEMA Reform Act of 1993 103-hr-3397 E000179 Rep. Engel, Eliot L. [D-NY-17] D NY 1994-07-21 0
103-hr-3397,C000488 Presidential FEMA Reform Act of 1993 103-hr-3397 C000488 Rep. Clay, William (Bill) [D-MO-1] D MO 1994-07-21 0
103-hr-3397,H000627 Presidential FEMA Reform Act of 1993 103-hr-3397 H000627 Rep. Hinchey, Maurice D. [D-NY-26] D NY 1994-06-22 0
103-hr-3397,T000024 Presidential FEMA Reform Act of 1993 103-hr-3397 T000024 Rep. Talent, Jim [R-MO-2] R MO 1994-06-22 0
103-hr-3397,T000193 Presidential FEMA Reform Act of 1993 103-hr-3397 T000193 Rep. Thompson, Bennie G. [D-MS-2] D MS 1994-06-22 0
103-hr-3397,S000522 Presidential FEMA Reform Act of 1993 103-hr-3397 S000522 Rep. Smith, Christopher H. [R-NJ-4] R NJ 1994-04-12 0
103-hr-3397,C000537 Presidential FEMA Reform Act of 1993 103-hr-3397 C000537 Rep. Clyburn, James E. [D-SC-6] D SC 1994-04-12 0
103-hr-3397,A000214 Presidential FEMA Reform Act of 1993 103-hr-3397 A000214 Rep. Applegate, Douglas [D-OH-18] D OH 1994-04-12 0
103-hr-3397,V000006 Presidential FEMA Reform Act of 1993 103-hr-3397 V000006 Rep. Valentine, Tim [D-NC-2] D NC 1994-03-09 0
103-hr-3397,M000350 Presidential FEMA Reform Act of 1993 103-hr-3397 M000350 Rep. McCollum, Bill [R-FL-8] R FL 1994-03-09 0
103-hr-3397,P000215 Presidential FEMA Reform Act of 1993 103-hr-3397 P000215 Rep. Penny, Timothy J. [D-MN-1] D MN 1994-03-09 0
103-hr-3397,C000059 Presidential FEMA Reform Act of 1993 103-hr-3397 C000059 Rep. Calvert, Ken [R-CA-43] R CA 1994-03-09 0
103-hr-3397,M000795 Presidential FEMA Reform Act of 1993 103-hr-3397 M000795 Rep. Minge, David [D-MN-2] D MN 1994-02-23 0
103-hr-3397,M000797 Presidential FEMA Reform Act of 1993 103-hr-3397 M000797 Rep. Mink, Patsy T. [D-HI-2] D HI 1994-02-23 0
103-hr-3397,M000639 Presidential FEMA Reform Act of 1993 103-hr-3397 M000639 Rep. Menendez, Robert [D-NJ-13] D NJ 1994-02-23 0
103-hr-3397,S000119 Presidential FEMA Reform Act of 1993 103-hr-3397 S000119 Rep. Schenk, Lynn [D-CA-49] D CA 1994-01-26 0
103-hr-3397,D000203 Presidential FEMA Reform Act of 1993 103-hr-3397 D000203 Rep. de la Garza, E. [D-TX-15] D TX 1994-01-26 0
103-hr-3397,N000002 Presidential FEMA Reform Act of 1993 103-hr-3397 N000002 Rep. Nadler, Jerrold [D-NY-8] D NY 1994-01-26 0
103-hr-3397,D000275 Presidential FEMA Reform Act of 1993 103-hr-3397 D000275 Rep. Deutsch, Peter [D-FL-20] D FL 1994-01-26 0
103-hr-3397,S000480 Presidential FEMA Reform Act of 1993 103-hr-3397 S000480 Rep. Slaughter, Louise McIntosh [D-NY-28] D NY 1994-01-26 0
103-hr-3397,U000031 Presidential FEMA Reform Act of 1993 103-hr-3397 U000031 Rep. Upton, Fred [R-MI-6] R MI 1994-01-26 0
103-hr-3397,T000350 Presidential FEMA Reform Act of 1993 103-hr-3397 T000350 Rep. Traficant, James A., Jr. [D-OH-17] D OH 1993-11-18 0
103-hr-3397,S000185 Presidential FEMA Reform Act of 1993 103-hr-3397 S000185 Rep. Scott, Robert C. "Bobby" [D-VA-3] D VA 1993-11-18 0
103-hr-3397,F000116 Presidential FEMA Reform Act of 1993 103-hr-3397 F000116 Rep. Filner, Bob [D-CA-50] D CA 1993-11-18 0
103-hr-3397,G000021 Presidential FEMA Reform Act of 1993 103-hr-3397 G000021 Rep. Gallegly, Elton [R-CA-23] R CA 1993-11-18 0
103-hr-3397,M001120 Presidential FEMA Reform Act of 1993 103-hr-3397 M001120 Rep. Murtha, John P. [D-PA-12] D PA 1993-11-18 0
103-hr-3397,F000392 Presidential FEMA Reform Act of 1993 103-hr-3397 F000392 Rep. Frost, Martin [D-TX-24] D TX 1993-11-18 0
103-hr-3397,B000028 Presidential FEMA Reform Act of 1993 103-hr-3397 B000028 Rep. Baesler, Scotty [D-KY-6] D KY 1993-11-18 0
103-hr-3397,H000874 Presidential FEMA Reform Act of 1993 103-hr-3397 H000874 Rep. Hoyer, Steny H. [D-MD-5] D MD 1993-10-28 1
103-hr-3397,W000268 Presidential FEMA Reform Act of 1993 103-hr-3397 W000268 Rep. Weldon, Curt [R-PA-7] R PA 1993-10-28 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);