legislation_cosponsors
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
7 rows where bill_id = "116-hr-8565" 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-8565,N000147 | Childrenâs Protection Act of 2020 116-hr-8565 | N000147 | Del. Norton, Eleanor Holmes [D-DC-At Large] | D | DC | 2020-12-16 | 0 |
| 116-hr-8565,C001078 | Childrenâs Protection Act of 2020 116-hr-8565 | C001078 | Rep. Connolly, Gerald E. [D-VA-11] | D | VA | 2020-12-16 | 0 |
| 116-hr-8565,C000754 | Childrenâs Protection Act of 2020 116-hr-8565 | C000754 | Rep. Cooper, Jim [D-TN-5] | D | TN | 2020-12-16 | 0 |
| 116-hr-8565,R000606 | Childrenâs Protection Act of 2020 116-hr-8565 | R000606 | Rep. Raskin, Jamie [D-MD-8] | D | MD | 2020-12-16 | 0 |
| 116-hr-8565,K000389 | Childrenâs Protection Act of 2020 116-hr-8565 | K000389 | Rep. Khanna, Ro [D-CA-17] | D | CA | 2020-12-16 | 0 |
| 116-hr-8565,P000618 | Childrenâs Protection Act of 2020 116-hr-8565 | P000618 | Rep. Porter, Katie [D-CA-45] | D | CA | 2020-12-16 | 0 |
| 116-hr-8565,P000617 | Childrenâs Protection Act of 2020 116-hr-8565 | P000617 | Rep. Pressley, Ayanna [D-MA-7] | D | MA | 2020-10-09 | 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);