legislation_cosponsors
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
8 rows where bill_id = "118-s-2041" 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 |
|---|---|---|---|---|---|---|---|
| 118-s-2041,E000295 | End Government Shutdowns Act 118-s-2041 | E000295 | Sen. Ernst, Joni [R-IA] | R | IA | 2023-09-21 | 0 |
| 118-s-2041,D000618 | End Government Shutdowns Act 118-s-2041 | D000618 | Sen. Daines, Steve [R-MT] | R | MT | 2023-09-12 | 0 |
| 118-s-2041,R000584 | End Government Shutdowns Act 118-s-2041 | R000584 | Sen. Risch, James E. [R-ID] | R | ID | 2023-06-15 | 1 |
| 118-s-2041,C001047 | End Government Shutdowns Act 118-s-2041 | C001047 | Sen. Capito, Shelley Moore [R-WV] | R | WV | 2023-06-15 | 1 |
| 118-s-2041,W000437 | End Government Shutdowns Act 118-s-2041 | W000437 | Sen. Wicker, Roger F. [R-MS] | R | MS | 2023-06-15 | 1 |
| 118-s-2041,C000880 | End Government Shutdowns Act 118-s-2041 | C000880 | Sen. Crapo, Mike [R-ID] | R | ID | 2023-06-15 | 1 |
| 118-s-2041,R000595 | End Government Shutdowns Act 118-s-2041 | R000595 | Sen. Rubio, Marco [R-FL] | R | FL | 2023-06-15 | 1 |
| 118-s-2041,L000577 | End Government Shutdowns Act 118-s-2041 | L000577 | Sen. Lee, Mike [R-UT] | R | UT | 2023-06-15 | 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);