legislation_cosponsors
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
22 rows where bill_id = "115-s-2525" 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-s-2525,K000393 | First Amendment Defense Act 115-s-2525 | K000393 | Sen. Kennedy, John [R-LA] | R | LA | 2018-03-13 | 0 |
| 115-s-2525,R000595 | First Amendment Defense Act 115-s-2525 | R000595 | Sen. Rubio, Marco [R-FL] | R | FL | 2018-03-08 | 1 |
| 115-s-2525,C000880 | First Amendment Defense Act 115-s-2525 | C000880 | Sen. Crapo, Mike [R-ID] | R | ID | 2018-03-08 | 1 |
| 115-s-2525,H000338 | First Amendment Defense Act 115-s-2525 | H000338 | Sen. Hatch, Orrin G. [R-UT] | R | UT | 2018-03-08 | 1 |
| 115-s-2525,I000024 | First Amendment Defense Act 115-s-2525 | I000024 | Sen. Inhofe, James M. [R-OK] | R | OK | 2018-03-08 | 1 |
| 115-s-2525,B000575 | First Amendment Defense Act 115-s-2525 | B000575 | Sen. Blunt, Roy [R-MO] | R | MO | 2018-03-08 | 1 |
| 115-s-2525,R000584 | First Amendment Defense Act 115-s-2525 | R000584 | Sen. Risch, James E. [R-ID] | R | ID | 2018-03-08 | 1 |
| 115-s-2525,W000437 | First Amendment Defense Act 115-s-2525 | W000437 | Sen. Wicker, Roger F. [R-MS] | R | MS | 2018-03-08 | 1 |
| 115-s-2525,E000285 | First Amendment Defense Act 115-s-2525 | E000285 | Sen. Enzi, Michael B. [R-WY] | R | WY | 2018-03-08 | 1 |
| 115-s-2525,J000293 | First Amendment Defense Act 115-s-2525 | J000293 | Sen. Johnson, Ron [R-WI] | R | WI | 2018-03-08 | 1 |
| 115-s-2525,R000605 | First Amendment Defense Act 115-s-2525 | R000605 | Sen. Rounds, Mike [R-SD] | R | SD | 2018-03-08 | 1 |
| 115-s-2525,B001261 | First Amendment Defense Act 115-s-2525 | B001261 | Sen. Barrasso, John [R-WY] | R | WY | 2018-03-08 | 1 |
| 115-s-2525,S001197 | First Amendment Defense Act 115-s-2525 | S001197 | Sen. Sasse, Ben [R-NE] | R | NE | 2018-03-08 | 1 |
| 115-s-2525,H001061 | First Amendment Defense Act 115-s-2525 | H001061 | Sen. Hoeven, John [R-ND] | R | ND | 2018-03-08 | 1 |
| 115-s-2525,T000250 | First Amendment Defense Act 115-s-2525 | T000250 | Sen. Thune, John [R-SD] | R | SD | 2018-03-08 | 1 |
| 115-s-2525,P000603 | First Amendment Defense Act 115-s-2525 | P000603 | Sen. Paul, Rand [R-KY] | R | KY | 2018-03-08 | 1 |
| 115-s-2525,P000612 | First Amendment Defense Act 115-s-2525 | P000612 | Sen. Perdue, David [R-GA] | R | GA | 2018-03-08 | 1 |
| 115-s-2525,S001184 | First Amendment Defense Act 115-s-2525 | S001184 | Sen. Scott, Tim [R-SC] | R | SC | 2018-03-08 | 1 |
| 115-s-2525,C001095 | First Amendment Defense Act 115-s-2525 | C001095 | Sen. Cotton, Tom [R-AR] | R | AR | 2018-03-08 | 1 |
| 115-s-2525,B001236 | First Amendment Defense Act 115-s-2525 | B001236 | Sen. Boozman, John [R-AR] | R | AR | 2018-03-08 | 1 |
| 115-s-2525,C001098 | First Amendment Defense Act 115-s-2525 | C001098 | Sen. Cruz, Ted [R-TX] | R | TX | 2018-03-08 | 1 |
| 115-s-2525,M000934 | First Amendment Defense Act 115-s-2525 | M000934 | Sen. Moran, Jerry [R-KS] | R | KS | 2018-03-08 | 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);