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

25 rows where bill_id = "100-hr-4899" 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 21
  • 0 4
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
100-hr-4899,M000941 Public Housing Gateway Act of 1988 100-hr-4899 M000941 Rep. Morella, Constance A. [R-MD-8] R MD 1988-10-19 0
100-hr-4899,R000374 Public Housing Gateway Act of 1988 100-hr-4899 R000374 Rep. Rodino, Peter W., Jr. [D-NJ-10] D NJ 1988-10-19 0
100-hr-4899,J000163 Public Housing Gateway Act of 1988 100-hr-4899 J000163 Rep. Johnson, Nancy L. [R-CT-6] R CT 1988-10-19 0
100-hr-4899,K000009 Public Housing Gateway Act of 1988 100-hr-4899 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 1988-10-19 0
100-hr-4899,B000431 Public Housing Gateway Act of 1988 100-hr-4899 B000431 Rep. Bevill, Tom [D-AL-4] D AL 1988-09-14 1
100-hr-4899,P000326 Public Housing Gateway Act of 1988 100-hr-4899 P000326 Rep. Pickett, Owen B. [D-VA-2] D VA 1988-09-14 1
100-hr-4899,F000339 Public Housing Gateway Act of 1988 100-hr-4899 F000339 Rep. Frank, Barney [D-MA-4] D MA 1988-09-14 1
100-hr-4899,M000687 Public Housing Gateway Act of 1988 100-hr-4899 M000687 Rep. Mfume, Kweisi [D-MD-7] D MD 1988-09-14 1
100-hr-4899,C000141 Public Housing Gateway Act of 1988 100-hr-4899 C000141 Rep. Cardin, Benjamin L. [D-MD-3] D MD 1988-09-14 1
100-hr-4899,T000356 Public Housing Gateway Act of 1988 100-hr-4899 T000356 Rep. Traxler, Bob [D-MI-8] D MI 1988-09-14 1
100-hr-4899,A000226 Public Housing Gateway Act of 1988 100-hr-4899 A000226 Rep. Atkins, Chester G. [D-MA-5] D MA 1988-09-14 1
100-hr-4899,C000634 Public Housing Gateway Act of 1988 100-hr-4899 C000634 Rep. Collins, Cardiss [D-IL-7] D IL 1988-09-14 1
100-hr-4899,V000087 Public Housing Gateway Act of 1988 100-hr-4899 V000087 Rep. Vento, Bruce F. [D-MN-4] D MN 1988-09-14 1
100-hr-4899,M000249 Public Housing Gateway Act of 1988 100-hr-4899 M000249 Rep. Matsui, Robert T. [D-CA-3] D CA 1988-09-14 1
100-hr-4899,E000064 Public Housing Gateway Act of 1988 100-hr-4899 E000064 Rep. Edwards, Don [D-CA-10] D CA 1988-09-14 1
100-hr-4899,B000711 Public Housing Gateway Act of 1988 100-hr-4899 B000711 Rep. Boxer, Barbara [D-CA-6] D CA 1988-09-14 1
100-hr-4899,C000488 Public Housing Gateway Act of 1988 100-hr-4899 C000488 Rep. Clay, William (Bill) [D-MO-1] D MO 1988-09-14 1
100-hr-4899,R000053 Public Housing Gateway Act of 1988 100-hr-4899 R000053 Rep. Rangel, Charles B. [D-NY-16] D NY 1988-09-14 1
100-hr-4899,K000110 Public Housing Gateway Act of 1988 100-hr-4899 K000110 Rep. Kennedy, Joseph P., II [D-MA-8] D MA 1988-09-14 1
100-hr-4899,O000001 Public Housing Gateway Act of 1988 100-hr-4899 O000001 Rep. Oakar, Mary Rose [D-OH-20] D OH 1988-09-14 1
100-hr-4899,F000046 Public Housing Gateway Act of 1988 100-hr-4899 F000046 Del. Fauntroy, Walter E. [D-DC-At Large] D DC 1988-09-14 1
100-hr-4899,A000022 Public Housing Gateway Act of 1988 100-hr-4899 A000022 Rep. Ackerman, Gary L. [D-NY-7] D NY 1988-09-14 1
100-hr-4899,M000473 Public Housing Gateway Act of 1988 100-hr-4899 M000473 Rep. McHugh, Matthew F. [D-NY-28] D NY 1988-09-14 1
100-hr-4899,B000410 Public Housing Gateway Act of 1988 100-hr-4899 B000410 Rep. Berman, Howard L. [D-CA-26] D CA 1988-09-14 1
100-hr-4899,F000215 Public Housing Gateway Act of 1988 100-hr-4899 F000215 Rep. Florio, James J. [D-NJ-1] D NJ 1988-09-14 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);