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

24 rows where bill_id = "108-hr-4597" 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 20
  • 0 4
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
108-hr-4597,D000216 National Dairy Equity Act of 2004 108-hr-4597 D000216 Rep. DeLauro, Rosa L. [D-CT-3] D CT 2004-09-30 0
108-hr-4597,A000210 National Dairy Equity Act of 2004 108-hr-4597 A000210 Rep. Andrews, Robert E. [D-NJ-1] D NJ 2004-09-28 0
108-hr-4597,A000357 National Dairy Equity Act of 2004 108-hr-4597 A000357 Rep. Allen, Thomas H. [D-ME-1] D ME 2004-09-13 0
108-hr-4597,K000210 National Dairy Equity Act of 2004 108-hr-4597 K000210 Rep. King, Peter T. [R-NY-3] R NY 2004-06-18 0
108-hr-4597,M000472 National Dairy Equity Act of 2004 108-hr-4597 M000472 Rep. McHugh, John M. [R-NY-23] R NY 2004-06-16 1
108-hr-4597,S000033 National Dairy Equity Act of 2004 108-hr-4597 S000033 Rep. Sanders, Bernard [I-VT-At Large] I VT 2004-06-16 1
108-hr-4597,E000226 National Dairy Equity Act of 2004 108-hr-4597 E000226 Rep. Etheridge, Bob [D-NC-2] D NC 2004-06-16 1
108-hr-4597,O000007 National Dairy Equity Act of 2004 108-hr-4597 O000007 Rep. Obey, David R. [D-WI-7] D WI 2004-06-16 1
108-hr-4597,S001152 National Dairy Equity Act of 2004 108-hr-4597 S001152 Rep. Simmons, Rob [R-CT-2] R CT 2004-06-16 1
108-hr-4597,B000586 National Dairy Equity Act of 2004 108-hr-4597 B000586 Rep. Boehlert, Sherwood [R-NY-24] R NY 2004-06-16 1
108-hr-4597,M000312 National Dairy Equity Act of 2004 108-hr-4597 M000312 Rep. McGovern, James P. [D-MA-3] D MA 2004-06-16 1
108-hr-4597,J000163 National Dairy Equity Act of 2004 108-hr-4597 J000163 Rep. Johnson, Nancy L. [R-CT-5] R CT 2004-06-16 1
108-hr-4597,Q000016 National Dairy Equity Act of 2004 108-hr-4597 Q000016 Rep. Quinn, Jack [R-NY-27] R NY 2004-06-16 1
108-hr-4597,H000814 National Dairy Equity Act of 2004 108-hr-4597 H000814 Rep. Houghton, Amo [R-NY-29] R NY 2004-06-16 1
108-hr-4597,W000099 National Dairy Equity Act of 2004 108-hr-4597 W000099 Rep. Walsh, James T. [R-NY-25] R NY 2004-06-16 1
108-hr-4597,T000424 National Dairy Equity Act of 2004 108-hr-4597 T000424 Rep. Turner, Jim [D-TX-2] D TX 2004-06-16 1
108-hr-4597,S000480 National Dairy Equity Act of 2004 108-hr-4597 S000480 Rep. Slaughter, Louise McIntosh [D-NY-28] D NY 2004-06-16 1
108-hr-4597,O000085 National Dairy Equity Act of 2004 108-hr-4597 O000085 Rep. Olver, John W. [D-MA-1] D MA 2004-06-16 1
108-hr-4597,H000627 National Dairy Equity Act of 2004 108-hr-4597 H000627 Rep. Hinchey, Maurice D. [D-NY-22] D NY 2004-06-16 1
108-hr-4597,S001149 National Dairy Equity Act of 2004 108-hr-4597 S001149 Rep. Sweeney, John E. [R-NY-20] R NY 2004-06-16 1
108-hr-4597,M000590 National Dairy Equity Act of 2004 108-hr-4597 M000590 Rep. McNulty, Michael R. [D-NY-21] D NY 2004-06-16 1
108-hr-4597,L000553 National Dairy Equity Act of 2004 108-hr-4597 L000553 Rep. LaTourette, Steven C. [R-OH-14] R OH 2004-06-16 1
108-hr-4597,K000078 National Dairy Equity Act of 2004 108-hr-4597 K000078 Rep. Kelly, Sue W. [R-NY-19] R NY 2004-06-16 1
108-hr-4597,L000559 National Dairy Equity Act of 2004 108-hr-4597 L000559 Rep. Langevin, James R. [D-RI-2] D RI 2004-06-16 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);