legislation_cosponsors
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
6 rows where bill_id = "116-hr-3477" 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 |
|---|---|---|---|---|---|---|---|
| 116-hr-3477,S001209 | Reclaiming Congressional Trade Authority Act of 2019 116-hr-3477 | S001209 | Rep. Spanberger, Abigail Davis [D-VA-7] | D | VA | 2019-09-06 | 0 |
| 116-hr-3477,H001083 | Reclaiming Congressional Trade Authority Act of 2019 116-hr-3477 | H001083 | Rep. Horn, Kendra S. [D-OK-5] | D | OK | 2019-07-11 | 0 |
| 116-hr-3477,C001063 | Reclaiming Congressional Trade Authority Act of 2019 116-hr-3477 | C001063 | Rep. Cuellar, Henry [D-TX-28] | D | TX | 2019-07-09 | 0 |
| 116-hr-3477,B001292 | Reclaiming Congressional Trade Authority Act of 2019 116-hr-3477 | B001292 | Rep. Beyer, Donald S., Jr. [D-VA-8] | D | VA | 2019-07-09 | 0 |
| 116-hr-3477,C000754 | Reclaiming Congressional Trade Authority Act of 2019 116-hr-3477 | C000754 | Rep. Cooper, Jim [D-TN-5] | D | TN | 2019-06-25 | 1 |
| 116-hr-3477,C001122 | Reclaiming Congressional Trade Authority Act of 2019 116-hr-3477 | C001122 | Rep. Cunningham, Joe [D-SC-1] | D | SC | 2019-06-25 | 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);