legislation_cosponsors
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
7 rows where bill_id = "97-hr-5200" 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 |
|---|---|---|---|---|---|---|---|
| 97-hr-5200,S000465 | School Desegregation Amendments Act 97-hr-5200 | S000465 | Rep. Skelton, Ike [D-MO-4] | D | MO | 1982-03-24 | 0 |
| 97-hr-5200,D000037 | School Desegregation Amendments Act 97-hr-5200 | D000037 | Rep. Daniel, Robert W., Jr. [R-VA-4] | R | VA | 1982-03-24 | 0 |
| 97-hr-5200,B000029 | School Desegregation Amendments Act 97-hr-5200 | B000029 | Rep. Bafalis, L. A. (Skip) [R-FL-10] | R | FL | 1982-03-02 | 0 |
| 97-hr-5200,M000842 | School Desegregation Amendments Act 97-hr-5200 | M000842 | Rep. Molinari, Guy [R-NY-17] | R | NY | 1982-03-02 | 0 |
| 97-hr-5200,M000865 | School Desegregation Amendments Act 97-hr-5200 | M000865 | Rep. Montgomery, G. V. (Sonny) [D-MS-3] | D | MS | 1982-03-02 | 0 |
| 97-hr-5200,M001044 | School Desegregation Amendments Act 97-hr-5200 | M001044 | Rep. Mottl, Ronald M. [D-OH-23] | D | OH | 1982-03-02 | 0 |
| 97-hr-5200,E000174 | School Desegregation Amendments Act 97-hr-5200 | E000174 | Rep. Emerson, Bill [R-MO-10] | R | MO | 1981-12-14 | 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);