legislation_cosponsors
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
6 rows where bill_id = "112-s-1005" sorted by sponsorship_date descending
This data as json, CSV (advanced)
Suggested facets: sponsorship_date, sponsorship_date (date)
| Link | bill_id | bioguide_id | full_name | party | state | sponsorship_date ▲ | is_original_cosponsor |
|---|---|---|---|---|---|---|---|
| 112-s-1005,C000560 | Parental Notification and Intervention Act of 2011 112-s-1005 | C000560 | Sen. Coburn, Tom [R-OK] | R | OK | 2012-05-24 | 0 |
| 112-s-1005,G000359 | Parental Notification and Intervention Act of 2011 112-s-1005 | G000359 | Sen. Graham, Lindsey [R-SC] | R | SC | 2011-05-16 | 1 |
| 112-s-1005,R000584 | Parental Notification and Intervention Act of 2011 112-s-1005 | R000584 | Sen. Risch, James E. [R-ID] | R | ID | 2011-05-16 | 1 |
| 112-s-1005,C000542 | Parental Notification and Intervention Act of 2011 112-s-1005 | C000542 | Sen. Coats, Daniel [R-IN] | R | IN | 2011-05-16 | 1 |
| 112-s-1005,T000250 | Parental Notification and Intervention Act of 2011 112-s-1005 | T000250 | Sen. Thune, John [R-SD] | R | SD | 2011-05-16 | 1 |
| 112-s-1005,J000291 | Parental Notification and Intervention Act of 2011 112-s-1005 | J000291 | Sen. Johanns, Mike [R-NE] | R | NE | 2011-05-16 | 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);