legislation_cosponsors
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
21 rows where bill_id = "115-s-3091" 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-3091,S001198 | Protect Kids and Parents Act 115-s-3091 | S001198 | Sen. Sullivan, Dan [R-AK] | R | AK | 2018-06-20 | 0 |
| 115-s-3091,H001079 | Protect Kids and Parents Act 115-s-3091 | H001079 | Sen. Hyde-Smith, Cindy [R-MS] | R | MS | 2018-06-20 | 0 |
| 115-s-3091,K000393 | Protect Kids and Parents Act 115-s-3091 | K000393 | Sen. Kennedy, John [R-LA] | R | LA | 2018-06-20 | 0 |
| 115-s-3091,B001261 | Protect Kids and Parents Act 115-s-3091 | B001261 | Sen. Barrasso, John [R-WY] | R | WY | 2018-06-19 | 1 |
| 115-s-3091,B000575 | Protect Kids and Parents Act 115-s-3091 | B000575 | Sen. Blunt, Roy [R-MO] | R | MO | 2018-06-19 | 1 |
| 115-s-3091,C000880 | Protect Kids and Parents Act 115-s-3091 | C000880 | Sen. Crapo, Mike [R-ID] | R | ID | 2018-06-19 | 1 |
| 115-s-3091,D000618 | Protect Kids and Parents Act 115-s-3091 | D000618 | Sen. Daines, Steve [R-MT] | R | MT | 2018-06-19 | 1 |
| 115-s-3091,E000295 | Protect Kids and Parents Act 115-s-3091 | E000295 | Sen. Ernst, Joni [R-IA] | R | IA | 2018-06-19 | 1 |
| 115-s-3091,H000338 | Protect Kids and Parents Act 115-s-3091 | H000338 | Sen. Hatch, Orrin G. [R-UT] | R | UT | 2018-06-19 | 1 |
| 115-s-3091,H001061 | Protect Kids and Parents Act 115-s-3091 | H001061 | Sen. Hoeven, John [R-ND] | R | ND | 2018-06-19 | 1 |
| 115-s-3091,I000024 | Protect Kids and Parents Act 115-s-3091 | I000024 | Sen. Inhofe, James M. [R-OK] | R | OK | 2018-06-19 | 1 |
| 115-s-3091,R000584 | Protect Kids and Parents Act 115-s-3091 | R000584 | Sen. Risch, James E. [R-ID] | R | ID | 2018-06-19 | 1 |
| 115-s-3091,R000605 | Protect Kids and Parents Act 115-s-3091 | R000605 | Sen. Rounds, Mike [R-SD] | R | SD | 2018-06-19 | 1 |
| 115-s-3091,R000307 | Protect Kids and Parents Act 115-s-3091 | R000307 | Sen. Roberts, Pat [R-KS] | R | KS | 2018-06-19 | 1 |
| 115-s-3091,R000595 | Protect Kids and Parents Act 115-s-3091 | R000595 | Sen. Rubio, Marco [R-FL] | R | FL | 2018-06-19 | 1 |
| 115-s-3091,S001197 | Protect Kids and Parents Act 115-s-3091 | S001197 | Sen. Sasse, Ben [R-NE] | R | NE | 2018-06-19 | 1 |
| 115-s-3091,S001184 | Protect Kids and Parents Act 115-s-3091 | S001184 | Sen. Scott, Tim [R-SC] | R | SC | 2018-06-19 | 1 |
| 115-s-3091,T000461 | Protect Kids and Parents Act 115-s-3091 | T000461 | Sen. Toomey, Patrick [R-PA] | R | PA | 2018-06-19 | 1 |
| 115-s-3091,Y000064 | Protect Kids and Parents Act 115-s-3091 | Y000064 | Sen. Young, Todd [R-IN] | R | IN | 2018-06-19 | 1 |
| 115-s-3091,L000577 | Protect Kids and Parents Act 115-s-3091 | L000577 | Sen. Lee, Mike [R-UT] | R | UT | 2018-06-19 | 1 |
| 115-s-3091,W000437 | Protect Kids and Parents Act 115-s-3091 | W000437 | Sen. Wicker, Roger F. [R-MS] | R | MS | 2018-06-19 | 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);