legislation_cosponsors
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
6 rows where bill_id = "112-hr-5848" sorted by sponsorship_date descending
This data as json, CSV (advanced)
Suggested facets: state, sponsorship_date (date)
is_original_cosponsor 1
- 0 6
| Link | bill_id | bioguide_id | full_name | party | state | sponsorship_date ▲ | is_original_cosponsor |
|---|---|---|---|---|---|---|---|
| 112-hr-5848,H001034 | Juror Non-Discrimination Act of 2012 112-hr-5848 | H001034 | Rep. Honda, Michael M. [D-CA-15] | D | CA | 2012-07-31 | 0 |
| 112-hr-5848,S001175 | Juror Non-Discrimination Act of 2012 112-hr-5848 | S001175 | Rep. Speier, Jackie [D-CA-12] | D | CA | 2012-07-18 | 0 |
| 112-hr-5848,B000574 | Juror Non-Discrimination Act of 2012 112-hr-5848 | B000574 | Rep. Blumenauer, Earl [D-OR-3] | D | OR | 2012-07-10 | 0 |
| 112-hr-5848,H001047 | Juror Non-Discrimination Act of 2012 112-hr-5848 | H001047 | Rep. Himes, James A. [D-CT-4] | D | CT | 2012-06-28 | 0 |
| 112-hr-5848,D000598 | Juror Non-Discrimination Act of 2012 112-hr-5848 | D000598 | Rep. Davis, Susan A. [D-CA-53] | D | CA | 2012-06-01 | 0 |
| 112-hr-5848,N000147 | Juror Non-Discrimination Act of 2012 112-hr-5848 | N000147 | Del. Norton, Eleanor Holmes [D-DC-At Large] | D | DC | 2012-05-31 | 0 |
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);