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-2217" sorted by sponsorship_date descending
This data as json, CSV (advanced)
Suggested facets: party, sponsorship_date (date)
is_original_cosponsor 1
- 1 6
| Link | bill_id | bioguide_id | full_name | party | state | sponsorship_date ▲ | is_original_cosponsor |
|---|---|---|---|---|---|---|---|
| 112-s-2217,J000177 | Rural America Preservation Act of 2012 112-s-2217 | J000177 | Sen. Johnson, Tim [D-SD] | D | SD | 2012-03-21 | 1 |
| 112-s-2217,B000944 | Rural America Preservation Act of 2012 112-s-2217 | B000944 | Sen. Brown, Sherrod [D-OH] | D | OH | 2012-03-21 | 1 |
| 112-s-2217,G000555 | Rural America Preservation Act of 2012 112-s-2217 | G000555 | Sen. Gillibrand, Kirsten E. [D-NY] | D | NY | 2012-03-21 | 1 |
| 112-s-2217,E000285 | Rural America Preservation Act of 2012 112-s-2217 | E000285 | Sen. Enzi, Michael B. [R-WY] | R | WY | 2012-03-21 | 1 |
| 112-s-2217,N000180 | Rural America Preservation Act of 2012 112-s-2217 | N000180 | Sen. Nelson, Ben [D-NE] | D | NE | 2012-03-21 | 1 |
| 112-s-2217,H000206 | Rural America Preservation Act of 2012 112-s-2217 | H000206 | Sen. Harkin, Tom [D-IA] | D | IA | 2012-03-21 | 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);