legislation_cosponsors
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
8 rows where bill_id = "113-hr-96" 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 |
|---|---|---|---|---|---|---|---|
| 113-hr-96,C001090 | Cameras in the Courtroom Act 113-hr-96 | C001090 | Rep. Cartwright, Matt [D-PA-17] | D | PA | 2013-07-16 | 0 |
| 113-hr-96,C001068 | Cameras in the Courtroom Act 113-hr-96 | C001068 | Rep. Cohen, Steve [D-TN-9] | D | TN | 2013-07-16 | 0 |
| 113-hr-96,Q000023 | Cameras in the Courtroom Act 113-hr-96 | Q000023 | Rep. Quigley, Mike [D-IL-5] | D | IL | 2013-05-06 | 0 |
| 113-hr-96,C001084 | Cameras in the Courtroom Act 113-hr-96 | C001084 | Rep. Cicilline, David N. [D-RI-1] | D | RI | 2013-04-25 | 0 |
| 113-hr-96,Y000062 | Cameras in the Courtroom Act 113-hr-96 | Y000062 | Rep. Yarmuth, John A. [D-KY-3] | D | KY | 2013-04-24 | 0 |
| 113-hr-96,M000933 | Cameras in the Courtroom Act 113-hr-96 | M000933 | Rep. Moran, James P. [D-VA-8] | D | VA | 2013-04-23 | 0 |
| 113-hr-96,V000128 | Cameras in the Courtroom Act 113-hr-96 | V000128 | Rep. Van Hollen, Chris [D-MD-8] | D | MD | 2013-04-23 | 0 |
| 113-hr-96,P000592 | Cameras in the Courtroom Act 113-hr-96 | P000592 | Rep. Poe, Ted [R-TX-2] | R | TX | 2013-01-03 | 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);