legislation_cosponsors
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
7 rows where bill_id = "113-s-2533" sorted by sponsorship_date descending
This data as json, CSV (advanced)
Suggested facets: state, sponsorship_date (date)
is_original_cosponsor 1
- 1 7
| Link | bill_id | bioguide_id | full_name | party | state | sponsorship_date ▲ | is_original_cosponsor |
|---|---|---|---|---|---|---|---|
| 113-s-2533,M000303 | Agency PAYGO for Greenhouse Gases Act 113-s-2533 | M000303 | Sen. McCain, John [R-AZ] | R | AZ | 2014-06-26 | 1 |
| 113-s-2533,R000584 | Agency PAYGO for Greenhouse Gases Act 113-s-2533 | R000584 | Sen. Risch, James E. [R-ID] | R | ID | 2014-06-26 | 1 |
| 113-s-2533,C000880 | Agency PAYGO for Greenhouse Gases Act 113-s-2533 | C000880 | Sen. Crapo, Mike [R-ID] | R | ID | 2014-06-26 | 1 |
| 113-s-2533,J000293 | Agency PAYGO for Greenhouse Gases Act 113-s-2533 | J000293 | Sen. Johnson, Ron [R-WI] | R | WI | 2014-06-26 | 1 |
| 113-s-2533,C000542 | Agency PAYGO for Greenhouse Gases Act 113-s-2533 | C000542 | Sen. Coats, Daniel [R-IN] | R | IN | 2014-06-26 | 1 |
| 113-s-2533,J000291 | Agency PAYGO for Greenhouse Gases Act 113-s-2533 | J000291 | Sen. Johanns, Mike [R-NE] | R | NE | 2014-06-26 | 1 |
| 113-s-2533,T000250 | Agency PAYGO for Greenhouse Gases Act 113-s-2533 | T000250 | Sen. Thune, John [R-SD] | R | SD | 2014-06-26 | 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);