legislation_cosponsors
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
5 rows where bill_id = "111-hr-4682" sorted by sponsorship_date descending
This data as json, CSV (advanced)
Suggested facets: party, state, sponsorship_date, sponsorship_date (date)
| Link | bill_id | bioguide_id | full_name | party | state | sponsorship_date ▲ | is_original_cosponsor |
|---|---|---|---|---|---|---|---|
| 111-hr-4682,C001037 | America Saving for Personal Investment, Retirement, and Education Act of 2010 111-hr-4682 | C001037 | Rep. Capuano, Michael E. [D-MA-8] | D | MA | 2010-08-10 | 0 |
| 111-hr-4682,L000551 | America Saving for Personal Investment, Retirement, and Education Act of 2010 111-hr-4682 | L000551 | Rep. Lee, Barbara [D-CA-9] | D | CA | 2010-06-10 | 0 |
| 111-hr-4682,T000465 | America Saving for Personal Investment, Retirement, and Education Act of 2010 111-hr-4682 | T000465 | Rep. Tsongas, Niki [D-MA-5] | D | MA | 2010-03-19 | 0 |
| 111-hr-4682,P000265 | America Saving for Personal Investment, Retirement, and Education Act of 2010 111-hr-4682 | P000265 | Rep. Petri, Thomas E. [R-WI-6] | R | WI | 2010-02-24 | 1 |
| 111-hr-4682,C000754 | America Saving for Personal Investment, Retirement, and Education Act of 2010 111-hr-4682 | C000754 | Rep. Cooper, Jim [D-TN-5] | D | TN | 2010-02-24 | 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);