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

13 rows where bill_id = "99-hr-4872" 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 12
  • 1 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
99-hr-4872,Y000014 Navajo-Hopi Relocation Moratorium Act 99-hr-4872 Y000014 Rep. Yatron, Gus [D-PA-6] D PA 1986-10-09 0
99-hr-4872,B000711 Navajo-Hopi Relocation Moratorium Act 99-hr-4872 B000711 Rep. Boxer, Barbara [D-CA-6] D CA 1986-09-23 0
99-hr-4872,L000516 Navajo-Hopi Relocation Moratorium Act 99-hr-4872 L000516 Rep. Lundine, Stanley N. [D-NY-34] D NY 1986-09-11 0
99-hr-4872,D000586 Navajo-Hopi Relocation Moratorium Act 99-hr-4872 D000586 Rep. Dwyer, Bernard J. [D-NJ-6] D NJ 1986-08-11 0
99-hr-4872,B000410 Navajo-Hopi Relocation Moratorium Act 99-hr-4872 B000410 Rep. Berman, Howard L. [D-CA-26] D CA 1986-08-08 0
99-hr-4872,A000226 Navajo-Hopi Relocation Moratorium Act 99-hr-4872 A000226 Rep. Atkins, Chester G. [D-MA-5] D MA 1986-07-16 0
99-hr-4872,C000809 Navajo-Hopi Relocation Moratorium Act 99-hr-4872 C000809 Rep. Courter, Jim [R-NJ-12] R NJ 1986-07-16 0
99-hr-4872,W000227 Navajo-Hopi Relocation Moratorium Act 99-hr-4872 W000227 Rep. Weaver, James H. [D-OR-4] D OR 1986-07-16 0
99-hr-4872,M000881 Navajo-Hopi Relocation Moratorium Act 99-hr-4872 M000881 Rep. Moody, Jim [D-WI-5] D WI 1986-07-16 0
99-hr-4872,G000240 Navajo-Hopi Relocation Moratorium Act 99-hr-4872 G000240 Rep. Glickman, Dan [D-KS-4] D KS 1986-07-16 0
99-hr-4872,K000319 Navajo-Hopi Relocation Moratorium Act 99-hr-4872 K000319 Rep. Kostmayer, Peter H. [D-PA-8] D PA 1986-07-16 0
99-hr-4872,M000794 Navajo-Hopi Relocation Moratorium Act 99-hr-4872 M000794 Rep. Mineta, Norman Y. [D-CA-13] D CA 1986-06-24 0
99-hr-4872,B001158 Navajo-Hopi Relocation Moratorium Act 99-hr-4872 B001158 Rep. Burton, Sala [D-CA-5] D CA 1986-06-18 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);