legislation_cosponsors
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
6 rows where bill_id = "110-hr-5543" sorted by sponsorship_date descending
This data as json, CSV (advanced)
Suggested facets: party, sponsorship_date, sponsorship_date (date)
| Link | bill_id | bioguide_id | full_name | party | state | sponsorship_date ▲ | is_original_cosponsor |
|---|---|---|---|---|---|---|---|
| 110-hr-5543,G000554 | Women's Retirement Security Act of 2008 110-hr-5543 | G000554 | Rep. Giffords, Gabrielle [D-AZ-8] | D | AZ | 2008-07-17 | 0 |
| 110-hr-5543,C001068 | Women's Retirement Security Act of 2008 110-hr-5543 | C001068 | Rep. Cohen, Steve [D-TN-9] | D | TN | 2008-04-23 | 0 |
| 110-hr-5543,B001247 | Women's Retirement Security Act of 2008 110-hr-5543 | B001247 | Rep. Brown-Waite, Ginny [R-FL-5] | R | FL | 2008-03-13 | 0 |
| 110-hr-5543,M001166 | Women's Retirement Security Act of 2008 110-hr-5543 | M001166 | Rep. McNerney, Jerry [D-CA-11] | D | CA | 2008-03-13 | 0 |
| 110-hr-5543,E000187 | Women's Retirement Security Act of 2008 110-hr-5543 | E000187 | Rep. English, Phil [R-PA-3] | R | PA | 2008-03-06 | 1 |
| 110-hr-5543,B001231 | Women's Retirement Security Act of 2008 110-hr-5543 | B001231 | Rep. Berkley, Shelley [D-NV-1] | D | NV | 2008-03-06 | 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);