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

20 rows where bill_id = "105-hconres-96" 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 11
  • 0 9
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
105-hconres-96,O000159 Apologizing for those who suffered as slaves under the Constitution and laws of the United States until 1865. 105-hconres-96 O000159 Rep. Owens, Major R. [D-NY-11] D NY 1997-09-11 0
105-hconres-96,F000434 Apologizing for those who suffered as slaves under the Constitution and laws of the United States until 1865. 105-hconres-96 F000434 Rep. Furse, Elizabeth [D-OR-1] D OR 1997-09-03 0
105-hconres-96,E000179 Apologizing for those who suffered as slaves under the Constitution and laws of the United States until 1865. 105-hconres-96 E000179 Rep. Engel, Eliot L. [D-NY-17] D NY 1997-07-31 0
105-hconres-96,M000309 Apologizing for those who suffered as slaves under the Constitution and laws of the United States until 1865. 105-hconres-96 M000309 Rep. McCarthy, Carolyn [D-NY-4] D NY 1997-06-26 0
105-hconres-96,L000155 Apologizing for those who suffered as slaves under the Constitution and laws of the United States until 1865. 105-hconres-96 L000155 Rep. Lazio, Rick [R-NY-2] R NY 1997-06-17 0
105-hconres-96,C000191 Apologizing for those who suffered as slaves under the Constitution and laws of the United States until 1865. 105-hconres-96 C000191 Rep. Carson, Julia [D-IN-10] D IN 1997-06-17 0
105-hconres-96,D000191 Apologizing for those who suffered as slaves under the Constitution and laws of the United States until 1865. 105-hconres-96 D000191 Rep. DeFazio, Peter A. [D-OR-4] D OR 1997-06-17 0
105-hconres-96,C000488 Apologizing for those who suffered as slaves under the Constitution and laws of the United States until 1865. 105-hconres-96 C000488 Rep. Clay, William (Bill) [D-MO-1] D MO 1997-06-17 0
105-hconres-96,J000032 Apologizing for those who suffered as slaves under the Constitution and laws of the United States until 1865. 105-hconres-96 J000032 Rep. Jackson-Lee, Sheila [D-TX-18] D TX 1997-06-17 0
105-hconres-96,W000267 Apologizing for those who suffered as slaves under the Constitution and laws of the United States until 1865. 105-hconres-96 W000267 Rep. Weldon, Dave [R-FL-15] R FL 1997-06-12 1
105-hconres-96,M000590 Apologizing for those who suffered as slaves under the Constitution and laws of the United States until 1865. 105-hconres-96 M000590 Rep. McNulty, Michael R. [D-NY-21] D NY 1997-06-12 1
105-hconres-96,C000377 Apologizing for those who suffered as slaves under the Constitution and laws of the United States until 1865. 105-hconres-96 C000377 Rep. Christensen, Jon [R-NE-2] R NE 1997-06-12 1
105-hconres-96,L000090 Apologizing for those who suffered as slaves under the Constitution and laws of the United States until 1865. 105-hconres-96 L000090 Rep. Lantos, Tom [D-CA-12] D CA 1997-06-12 1
105-hconres-96,E000194 Apologizing for those who suffered as slaves under the Constitution and laws of the United States until 1865. 105-hconres-96 E000194 Rep. Ensign, John [R-NV-1] R NV 1997-06-12 1
105-hconres-96,K000009 Apologizing for those who suffered as slaves under the Constitution and laws of the United States until 1865. 105-hconres-96 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 1997-06-12 1
105-hconres-96,P000373 Apologizing for those who suffered as slaves under the Constitution and laws of the United States until 1865. 105-hconres-96 P000373 Rep. Pitts, Joseph R. [R-PA-16] R PA 1997-06-12 1
105-hconres-96,T000350 Apologizing for those who suffered as slaves under the Constitution and laws of the United States until 1865. 105-hconres-96 T000350 Rep. Traficant, James A., Jr. [D-OH-17] D OH 1997-06-12 1
105-hconres-96,C000560 Apologizing for those who suffered as slaves under the Constitution and laws of the United States until 1865. 105-hconres-96 C000560 Rep. Coburn, Tom [R-OK-2] R OK 1997-06-12 1
105-hconres-96,B000619 Apologizing for those who suffered as slaves under the Constitution and laws of the United States until 1865. 105-hconres-96 B000619 Rep. Bonior, David E. [D-MI-10] D MI 1997-06-12 1
105-hconres-96,S000587 Apologizing for those who suffered as slaves under the Constitution and laws of the United States until 1865. 105-hconres-96 S000587 Rep. Smith, Linda [R-WA-3] R WA 1997-06-12 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);