legislation_cosponsors
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
6 rows where bill_id = "106-hr-2005" 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 |
|---|---|---|---|---|---|---|---|
| 106-hr-2005,R000386 | Workplace Goods Job Growth and Competitiveness Act of 1999 106-hr-2005 | R000386 | Rep. Rogan, James E. [R-CA-27] | R | CA | 1999-10-01 | 0 |
| 106-hr-2005,G000121 | Workplace Goods Job Growth and Competitiveness Act of 1999 106-hr-2005 | G000121 | Rep. Gekas, George W. [R-PA-17] | R | PA | 1999-09-14 | 0 |
| 106-hr-2005,G000289 | Workplace Goods Job Growth and Competitiveness Act of 1999 106-hr-2005 | G000289 | Rep. Goodlatte, Bob [R-VA-6] | R | VA | 1999-07-22 | 0 |
| 106-hr-2005,K000009 | Workplace Goods Job Growth and Competitiveness Act of 1999 106-hr-2005 | K000009 | Rep. Kaptur, Marcy [D-OH-9] | D | OH | 1999-07-13 | 0 |
| 106-hr-2005,S000480 | Workplace Goods Job Growth and Competitiveness Act of 1999 106-hr-2005 | S000480 | Rep. Slaughter, Louise McIntosh [D-NY-28] | D | NY | 1999-06-07 | 1 |
| 106-hr-2005,S000364 | Workplace Goods Job Growth and Competitiveness Act of 1999 106-hr-2005 | S000364 | Rep. Shimkus, John [R-IL-20] | R | IL | 1999-06-07 | 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);