legislation_cosponsors
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
2 rows where bill_id = "101-hr-5545" sorted by sponsorship_date descending
This data as json, CSV (advanced)
Suggested facets: sponsorship_date (date)
is_original_cosponsor 1
- 1 2
| Link | bill_id | bioguide_id | full_name | party | state | sponsorship_date ▲ | is_original_cosponsor |
|---|---|---|---|---|---|---|---|
| 101-hr-5545,M000306 | To amend title 18, United States Code, to permit the Attorney General to grant permanent resident status for certain alien participants in the witness security program. 101-hr-5545 | M000306 | Rep. McCandless, Alfred A. (Al) [R-CA-37] | R | CA | 1990-08-03 | 1 |
| 101-hr-5545,S000125 | To amend title 18, United States Code, to permit the Attorney General to grant permanent resident status for certain alien participants in the witness security program. 101-hr-5545 | S000125 | Rep. Schiff, Steven [R-NM-1] | R | NM | 1990-08-03 | 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);