legislation_cosponsors
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
25 rows where bill_id = "115-hjres-65" sorted by sponsorship_date descending
This data as json, CSV (advanced)
Suggested facets: state, sponsorship_date, sponsorship_date (date)
| Link | bill_id | bioguide_id | full_name | party | state | sponsorship_date ▲ | is_original_cosponsor |
|---|---|---|---|---|---|---|---|
| 115-hjres-65,S000510 | Every Vote Counts Amendment 115-hjres-65 | S000510 | Rep. Smith, Adam [D-WA-9] | D | WA | 2018-11-09 | 0 |
| 115-hjres-65,L000579 | Every Vote Counts Amendment 115-hjres-65 | L000579 | Rep. Lowenthal, Alan S. [D-CA-47] | D | CA | 2017-11-07 | 0 |
| 115-hjres-65,K000380 | Every Vote Counts Amendment 115-hjres-65 | K000380 | Rep. Kildee, Daniel T. [D-MI-5] | D | MI | 2017-02-14 | 0 |
| 115-hjres-65,S001200 | Every Vote Counts Amendment 115-hjres-65 | S001200 | Rep. Soto, Darren [D-FL-9] | D | FL | 2017-02-14 | 0 |
| 115-hjres-65,B001296 | Every Vote Counts Amendment 115-hjres-65 | B001296 | Rep. Boyle, Brendan F. [D-PA-13] | D | PA | 2017-02-07 | 1 |
| 115-hjres-65,B001285 | Every Vote Counts Amendment 115-hjres-65 | B001285 | Rep. Brownley, Julia [D-CA-26] | D | CA | 2017-02-07 | 1 |
| 115-hjres-65,C001084 | Every Vote Counts Amendment 115-hjres-65 | C001084 | Rep. Cicilline, David N. [D-RI-1] | D | RI | 2017-02-07 | 1 |
| 115-hjres-65,C001068 | Every Vote Counts Amendment 115-hjres-65 | C001068 | Rep. Cohen, Steve [D-TN-9] | D | TN | 2017-02-07 | 1 |
| 115-hjres-65,G000559 | Every Vote Counts Amendment 115-hjres-65 | G000559 | Rep. Garamendi, John [D-CA-3] | D | CA | 2017-02-07 | 1 |
| 115-hjres-65,G000553 | Every Vote Counts Amendment 115-hjres-65 | G000553 | Rep. Green, Al [D-TX-9] | D | TX | 2017-02-07 | 1 |
| 115-hjres-65,L000582 | Every Vote Counts Amendment 115-hjres-65 | L000582 | Rep. Lieu, Ted [D-CA-33] | D | CA | 2017-02-07 | 1 |
| 115-hjres-65,M000312 | Every Vote Counts Amendment 115-hjres-65 | M000312 | Rep. McGovern, James P. [D-MA-2] | D | MA | 2017-02-07 | 1 |
| 115-hjres-65,S001145 | Every Vote Counts Amendment 115-hjres-65 | S001145 | Rep. Schakowsky, Janice D. [D-IL-9] | D | IL | 2017-02-07 | 1 |
| 115-hjres-65,S001193 | Every Vote Counts Amendment 115-hjres-65 | S001193 | Rep. Swalwell, Eric [D-CA-15] | D | CA | 2017-02-07 | 1 |
| 115-hjres-65,V000132 | Every Vote Counts Amendment 115-hjres-65 | V000132 | Rep. Vela, Filemon [D-TX-34] | D | TX | 2017-02-07 | 1 |
| 115-hjres-65,C001069 | Every Vote Counts Amendment 115-hjres-65 | C001069 | Rep. Courtney, Joe [D-CT-2] | D | CT | 2017-02-07 | 1 |
| 115-hjres-65,C001067 | Every Vote Counts Amendment 115-hjres-65 | C001067 | Rep. Clarke, Yvette D. [D-NY-9] | D | NY | 2017-02-07 | 1 |
| 115-hjres-65,E000288 | Every Vote Counts Amendment 115-hjres-65 | E000288 | Rep. Ellison, Keith [D-MN-5] | D | MN | 2017-02-07 | 1 |
| 115-hjres-65,H001068 | Every Vote Counts Amendment 115-hjres-65 | H001068 | Rep. Huffman, Jared [D-CA-2] | D | CA | 2017-02-07 | 1 |
| 115-hjres-65,P000607 | Every Vote Counts Amendment 115-hjres-65 | P000607 | Rep. Pocan, Mark [D-WI-2] | D | WI | 2017-02-07 | 1 |
| 115-hjres-65,S000248 | Every Vote Counts Amendment 115-hjres-65 | S000248 | Rep. Serrano, Jose E. [D-NY-15] | D | NY | 2017-02-07 | 1 |
| 115-hjres-65,S000344 | Every Vote Counts Amendment 115-hjres-65 | S000344 | Rep. Sherman, Brad [D-CA-30] | D | CA | 2017-02-07 | 1 |
| 115-hjres-65,V000130 | Every Vote Counts Amendment 115-hjres-65 | V000130 | Rep. Vargas, Juan [D-CA-51] | D | CA | 2017-02-07 | 1 |
| 115-hjres-65,E000297 | Every Vote Counts Amendment 115-hjres-65 | E000297 | Rep. Espaillat, Adriano [D-NY-13] | D | NY | 2017-02-07 | 1 |
| 115-hjres-65,D000191 | Every Vote Counts Amendment 115-hjres-65 | D000191 | Rep. DeFazio, Peter A. [D-OR-4] | D | OR | 2017-02-07 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);