legislation_cosponsors
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
5 rows where bill_id = "112-hr-3983" sorted by sponsorship_date descending
This data as json, CSV (advanced)
Suggested facets: party, state, sponsorship_date (date)
is_original_cosponsor 1
- 1 5
| Link | bill_id | bioguide_id | full_name | party | state | sponsorship_date ▲ | is_original_cosponsor |
|---|---|---|---|---|---|---|---|
| 112-hr-3983,W000800 | Strengthening America's Public Schools Through Promoting Foreign Investment Act 112-hr-3983 | W000800 | Rep. Welch, Peter [D-VT-At Large] | D | VT | 2012-02-08 | 1 |
| 112-hr-3983,G000564 | Strengthening America's Public Schools Through Promoting Foreign Investment Act 112-hr-3983 | G000564 | Rep. Gibson, Christopher P. [R-NY-20] | R | NY | 2012-02-08 | 1 |
| 112-hr-3983,M001149 | Strengthening America's Public Schools Through Promoting Foreign Investment Act 112-hr-3983 | M001149 | Rep. Michaud, Michael H. [D-ME-2] | D | ME | 2012-02-08 | 1 |
| 112-hr-3983,T000469 | Strengthening America's Public Schools Through Promoting Foreign Investment Act 112-hr-3983 | T000469 | Rep. Tonko, Paul [D-NY-21] | D | NY | 2012-02-08 | 1 |
| 112-hr-3983,H000627 | Strengthening America's Public Schools Through Promoting Foreign Investment Act 112-hr-3983 | H000627 | Rep. Hinchey, Maurice D. [D-NY-22] | D | NY | 2012-02-08 | 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);