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

16 rows where bill_id = "117-hres-1306" 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 10
  • 1 6
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
117-hres-1306,C001061 Expressing the support of the House of Representatives for the designation of "Public Radio Music Day" and its deep appreciation for the role of public radio music stations in serving listeners, musicians, and hundreds of communities in the United States. 117-hres-1306 C001061 Rep. Cleaver, Emanuel [D-MO-5] D MO 2022-10-18 0
117-hres-1306,C001112 Expressing the support of the House of Representatives for the designation of "Public Radio Music Day" and its deep appreciation for the role of public radio music stations in serving listeners, musicians, and hundreds of communities in the United States. 117-hres-1306 C001112 Rep. Carbajal, Salud O. [D-CA-24] D CA 2022-10-11 0
117-hres-1306,P000604 Expressing the support of the House of Representatives for the designation of "Public Radio Music Day" and its deep appreciation for the role of public radio music stations in serving listeners, musicians, and hundreds of communities in the United States. 117-hres-1306 P000604 Rep. Payne, Donald M., Jr. [D-NJ-10] D NJ 2022-10-07 0
117-hres-1306,B001301 Expressing the support of the House of Representatives for the designation of "Public Radio Music Day" and its deep appreciation for the role of public radio music stations in serving listeners, musicians, and hundreds of communities in the United States. 117-hres-1306 B001301 Rep. Bergman, Jack [R-MI-1] R MI 2022-09-29 0
117-hres-1306,U000031 Expressing the support of the House of Representatives for the designation of "Public Radio Music Day" and its deep appreciation for the role of public radio music stations in serving listeners, musicians, and hundreds of communities in the United States. 117-hres-1306 U000031 Rep. Upton, Fred [R-MI-6] R MI 2022-09-28 0
117-hres-1306,H001038 Expressing the support of the House of Representatives for the designation of "Public Radio Music Day" and its deep appreciation for the role of public radio music stations in serving listeners, musicians, and hundreds of communities in the United States. 117-hres-1306 H001038 Rep. Higgins, Brian [D-NY-26] D NY 2022-09-28 0
117-hres-1306,M001206 Expressing the support of the House of Representatives for the designation of "Public Radio Music Day" and its deep appreciation for the role of public radio music stations in serving listeners, musicians, and hundreds of communities in the United States. 117-hres-1306 M001206 Rep. Morelle, Joseph D. [D-NY-25] D NY 2022-09-20 0
117-hres-1306,B001313 Expressing the support of the House of Representatives for the designation of "Public Radio Music Day" and its deep appreciation for the role of public radio music stations in serving listeners, musicians, and hundreds of communities in the United States. 117-hres-1306 B001313 Rep. Brown, Shontel M. [D-OH-11] D OH 2022-09-19 0
117-hres-1306,C001110 Expressing the support of the House of Representatives for the designation of "Public Radio Music Day" and its deep appreciation for the role of public radio music stations in serving listeners, musicians, and hundreds of communities in the United States. 117-hres-1306 C001110 Rep. Correa, J. Luis [D-CA-46] D CA 2022-09-19 0
117-hres-1306,J000298 Expressing the support of the House of Representatives for the designation of "Public Radio Music Day" and its deep appreciation for the role of public radio music stations in serving listeners, musicians, and hundreds of communities in the United States. 117-hres-1306 J000298 Rep. Jayapal, Pramila [D-WA-7] D WA 2022-09-19 0
117-hres-1306,F000466 Expressing the support of the House of Representatives for the designation of "Public Radio Music Day" and its deep appreciation for the role of public radio music stations in serving listeners, musicians, and hundreds of communities in the United States. 117-hres-1306 F000466 Rep. Fitzpatrick, Brian K. [R-PA-1] R PA 2022-07-29 1
117-hres-1306,E000296 Expressing the support of the House of Representatives for the designation of "Public Radio Music Day" and its deep appreciation for the role of public radio music stations in serving listeners, musicians, and hundreds of communities in the United States. 117-hres-1306 E000296 Rep. Evans, Dwight [D-PA-3] D PA 2022-07-29 1
117-hres-1306,L000590 Expressing the support of the House of Representatives for the designation of "Public Radio Music Day" and its deep appreciation for the role of public radio music stations in serving listeners, musicians, and hundreds of communities in the United States. 117-hres-1306 L000590 Rep. Lee, Susie [D-NV-3] D NV 2022-07-29 1
117-hres-1306,B000574 Expressing the support of the House of Representatives for the designation of "Public Radio Music Day" and its deep appreciation for the role of public radio music stations in serving listeners, musicians, and hundreds of communities in the United States. 117-hres-1306 B000574 Rep. Blumenauer, Earl [D-OR-3] D OR 2022-07-29 1
117-hres-1306,N000147 Expressing the support of the House of Representatives for the designation of "Public Radio Music Day" and its deep appreciation for the role of public radio music stations in serving listeners, musicians, and hundreds of communities in the United States. 117-hres-1306 N000147 Del. Norton, Eleanor Holmes [D-DC-At Large] D DC 2022-07-29 1
117-hres-1306,H001085 Expressing the support of the House of Representatives for the designation of "Public Radio Music Day" and its deep appreciation for the role of public radio music stations in serving listeners, musicians, and hundreds of communities in the United States. 117-hres-1306 H001085 Rep. Houlahan, Chrissy [D-PA-6] D PA 2022-07-29 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);