legislation_cosponsors
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
7 rows where bill_id = "96-hr-8087" sorted by sponsorship_date descending
This data as json, CSV (advanced)
Suggested facets: party
is_original_cosponsor 1
- 0 7
| Link | bill_id | bioguide_id | full_name | party | state | sponsorship_date ▲ | is_original_cosponsor |
|---|---|---|---|---|---|---|---|
| 96-hr-8087,J000148 | National Trails System Act Amendments of 1980 96-hr-8087 | J000148 | Rep. Johnson, James P. (Jim) [R-CO-4] | R | 0 | ||
| 96-hr-8087,S000217 | National Trails System Act Amendments of 1980 96-hr-8087 | S000217 | Rep. Sebelius, Keith G. [R-KS-1] | R | 0 | ||
| 96-hr-8087,L000020 | National Trails System Act Amendments of 1980 96-hr-8087 | L000020 | Rep. Lagomarsino, Robert J. [R-CA-19] | R | 0 | ||
| 96-hr-8087,G000515 | National Trails System Act Amendments of 1980 96-hr-8087 | G000515 | Rep. Gudger, V. Lamar [D-NC-11] | D | 0 | ||
| 96-hr-8087,R000165 | National Trails System Act Amendments of 1980 96-hr-8087 | R000165 | Rep. Reuss, Henry S. [D-WI-5] | D | 0 | ||
| 96-hr-8087,B001153 | National Trails System Act Amendments of 1980 96-hr-8087 | B001153 | Rep. Burton, John [D-CA-5] | D | 0 | ||
| 96-hr-8087,M000794 | National Trails System Act Amendments of 1980 96-hr-8087 | M000794 | Rep. Mineta, Norman Y. [D-CA-13] | D | 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);