home / openregs

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

34 rows where bill_id = "105-hr-871" 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 22
  • 1 12
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
105-hr-871,M000312 Domestic Violence Victims Housing Act 105-hr-871 M000312 Rep. McGovern, James P. [D-MA-3] D MA 1998-01-27 0
105-hr-871,C000846 Domestic Violence Victims Housing Act 105-hr-871 C000846 Rep. Coyne, William J. [D-PA-14] D PA 1997-11-13 0
105-hr-871,A000210 Domestic Violence Victims Housing Act 105-hr-871 A000210 Rep. Andrews, Robert E. [D-NJ-1] D NJ 1997-06-26 0
105-hr-871,H000874 Domestic Violence Victims Housing Act 105-hr-871 H000874 Rep. Hoyer, Steny H. [D-MD-5] D MD 1997-05-14 0
105-hr-871,K000009 Domestic Violence Victims Housing Act 105-hr-871 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 1997-05-08 0
105-hr-871,L000287 Domestic Violence Victims Housing Act 105-hr-871 L000287 Rep. Lewis, John [D-GA-5] D GA 1997-05-08 0
105-hr-871,B000490 Domestic Violence Victims Housing Act 105-hr-871 B000490 Rep. Bishop, Sanford D., Jr. [D-GA-2] D GA 1997-04-24 0
105-hr-871,S000510 Domestic Violence Victims Housing Act 105-hr-871 S000510 Rep. Smith, Adam [D-WA-9] D WA 1997-04-17 0
105-hr-871,S000033 Domestic Violence Victims Housing Act 105-hr-871 S000033 Rep. Sanders, Bernard [I-VT-At Large] I VT 1997-04-14 0
105-hr-871,B000400 Domestic Violence Victims Housing Act 105-hr-871 B000400 Rep. Bentsen, Ken [D-TX-25] D TX 1997-04-14 0
105-hr-871,D000222 Domestic Violence Victims Housing Act 105-hr-871 D000222 Rep. Dellums, Ronald V. [D-CA-9] D CA 1997-04-14 0
105-hr-871,F000434 Domestic Violence Victims Housing Act 105-hr-871 F000434 Rep. Furse, Elizabeth [D-OR-1] D OR 1997-04-14 0
105-hr-871,R000515 Domestic Violence Victims Housing Act 105-hr-871 R000515 Rep. Rush, Bobby L. [D-IL-1] D IL 1997-03-20 0
105-hr-871,F000235 Domestic Violence Victims Housing Act 105-hr-871 F000235 Rep. Foglietta, Thomas M. [D-PA-1] D PA 1997-03-20 0
105-hr-871,L000480 Domestic Violence Victims Housing Act 105-hr-871 L000480 Rep. Lowey, Nita M. [D-NY-18] D NY 1997-03-20 0
105-hr-871,M000117 Domestic Violence Victims Housing Act 105-hr-871 M000117 Rep. Manton, Thomas J. [D-NY-7] D NY 1997-03-20 0
105-hr-871,G000535 Domestic Violence Victims Housing Act 105-hr-871 G000535 Rep. Gutierrez, Luis V. [D-IL-4] D IL 1997-03-20 0
105-hr-871,C000191 Domestic Violence Victims Housing Act 105-hr-871 C000191 Rep. Carson, Julia [D-IN-10] D IN 1997-03-11 0
105-hr-871,E000250 Domestic Violence Victims Housing Act 105-hr-871 E000250 Rep. Evans, Lane [D-IL-17] D IL 1997-03-11 0
105-hr-871,R000486 Domestic Violence Victims Housing Act 105-hr-871 R000486 Rep. Roybal-Allard, Lucille [D-CA-33] D CA 1997-03-11 0
105-hr-871,K000336 Domestic Violence Victims Housing Act 105-hr-871 K000336 Rep. Kucinich, Dennis J. [D-OH-10] D OH 1997-03-11 0
105-hr-871,F000010 Domestic Violence Victims Housing Act 105-hr-871 F000010 Del. Faleomavaega, Eni F. H. [D-AS-At Large] D AS 1997-03-11 0
105-hr-871,L000342 Domestic Violence Victims Housing Act 105-hr-871 L000342 Rep. Lipinski, William O. [D-IL-3] D IL 1997-02-27 1
105-hr-871,J000032 Domestic Violence Victims Housing Act 105-hr-871 J000032 Rep. Jackson-Lee, Sheila [D-TX-18] D TX 1997-02-27 1
105-hr-871,C000714 Domestic Violence Victims Housing Act 105-hr-871 C000714 Rep. Conyers, John, Jr. [D-MI-14] D MI 1997-02-27 1
105-hr-871,N000147 Domestic Violence Victims Housing Act 105-hr-871 N000147 Del. Norton, Eleanor Holmes [D-DC-At Large] D DC 1997-02-27 1
105-hr-871,L000556 Domestic Violence Victims Housing Act 105-hr-871 L000556 Rep. LaFalce, John J. [D-NY-29] D NY 1997-02-27 1
105-hr-871,O000006 Domestic Violence Victims Housing Act 105-hr-871 O000006 Rep. Oberstar, James L. [D-MN-8] D MN 1997-02-27 1
105-hr-871,B000911 Domestic Violence Victims Housing Act 105-hr-871 B000911 Rep. Brown, Corrine [D-FL-3] D FL 1997-02-27 1
105-hr-871,J000070 Domestic Violence Victims Housing Act 105-hr-871 J000070 Rep. Jefferson, William J. [D-LA-2] D LA 1997-02-27 1
105-hr-871,F000392 Domestic Violence Victims Housing Act 105-hr-871 F000392 Rep. Frost, Martin [D-TX-24] D TX 1997-02-27 1
105-hr-871,P000197 Domestic Violence Victims Housing Act 105-hr-871 P000197 Rep. Pelosi, Nancy [D-CA-8] D CA 1997-02-27 1
105-hr-871,D000191 Domestic Violence Victims Housing Act 105-hr-871 D000191 Rep. DeFazio, Peter A. [D-OR-4] D OR 1997-02-27 1
105-hr-871,S000480 Domestic Violence Victims Housing Act 105-hr-871 S000480 Rep. Slaughter, Louise McIntosh [D-NY-28] D NY 1997-02-27 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);
Powered by Datasette · Queries took 114.468ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API