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

15 rows where bill_id = "117-hres-1007" 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 12
  • 0 3
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
117-hres-1007,S000344 Supporting the designation of Vaisakhi, April 14 of each year, as "National Sikh Day". 117-hres-1007 S000344 Rep. Sherman, Brad [D-CA-30] D CA 2022-06-03 0
117-hres-1007,C001101 Supporting the designation of Vaisakhi, April 14 of each year, as "National Sikh Day". 117-hres-1007 C001101 Rep. Clark, Katherine M. [D-MA-5] D MA 2022-06-03 0
117-hres-1007,S001215 Supporting the designation of Vaisakhi, April 14 of each year, as "National Sikh Day". 117-hres-1007 S001215 Rep. Stevens, Haley M. [D-MI-11] D MI 2022-06-03 0
117-hres-1007,B001270 Supporting the designation of Vaisakhi, April 14 of each year, as "National Sikh Day". 117-hres-1007 B001270 Rep. Bass, Karen [D-CA-37] D CA 2022-03-28 1
117-hres-1007,T000469 Supporting the designation of Vaisakhi, April 14 of each year, as "National Sikh Day". 117-hres-1007 T000469 Rep. Tonko, Paul [D-NY-20] D NY 2022-03-28 1
117-hres-1007,F000466 Supporting the designation of Vaisakhi, April 14 of each year, as "National Sikh Day". 117-hres-1007 F000466 Rep. Fitzpatrick, Brian K. [R-PA-1] R PA 2022-03-28 1
117-hres-1007,M001204 Supporting the designation of Vaisakhi, April 14 of each year, as "National Sikh Day". 117-hres-1007 M001204 Rep. Meuser, Daniel [R-PA-9] R PA 2022-03-28 1
117-hres-1007,S001193 Supporting the designation of Vaisakhi, April 14 of each year, as "National Sikh Day". 117-hres-1007 S001193 Rep. Swalwell, Eric [D-CA-15] D CA 2022-03-28 1
117-hres-1007,K000391 Supporting the designation of Vaisakhi, April 14 of each year, as "National Sikh Day". 117-hres-1007 K000391 Rep. Krishnamoorthi, Raja [D-IL-8] D IL 2022-03-28 1
117-hres-1007,N000188 Supporting the designation of Vaisakhi, April 14 of each year, as "National Sikh Day". 117-hres-1007 N000188 Rep. Norcross, Donald [D-NJ-1] D NJ 2022-03-28 1
117-hres-1007,K000394 Supporting the designation of Vaisakhi, April 14 of each year, as "National Sikh Day". 117-hres-1007 K000394 Rep. Kim, Andy [D-NJ-3] D NJ 2022-03-28 1
117-hres-1007,G000559 Supporting the designation of Vaisakhi, April 14 of each year, as "National Sikh Day". 117-hres-1007 G000559 Rep. Garamendi, John [D-CA-3] D CA 2022-03-28 1
117-hres-1007,N000015 Supporting the designation of Vaisakhi, April 14 of each year, as "National Sikh Day". 117-hres-1007 N000015 Rep. Neal, Richard E. [D-MA-1] D MA 2022-03-28 1
117-hres-1007,B001296 Supporting the designation of Vaisakhi, April 14 of each year, as "National Sikh Day". 117-hres-1007 B001296 Rep. Boyle, Brendan F. [D-PA-2] D PA 2022-03-28 1
117-hres-1007,V000129 Supporting the designation of Vaisakhi, April 14 of each year, as "National Sikh Day". 117-hres-1007 V000129 Rep. Valadao, David G. [R-CA-21] R CA 2022-03-28 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);