legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
24 rows where "end" is on date 1977-01-03 and state = "OH"
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, party, start (date)
Link | rowid ▼ | legislator_id | type | state | start | end | class | party | district | how | party_affiliations | url | caucus | address | phone | fax | contact_form | office | state_rank | rss_url | end-type |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30875 | 30875 | Donald Clancy C000409 | rep | OH | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
30988 | 30988 | Wayne Hays H000408 | rep | OH | 1975-01-14 | 1977-01-03 | Democrat | 18 | |||||||||||||
31224 | 31224 | Charles Mosher M001031 | rep | OH | 1975-01-14 | 1977-01-03 | Republican | 13 | |||||||||||||
31334 | 31334 | James Stanton S000803 | rep | OH | 1975-01-14 | 1977-01-03 | Democrat | 20 | |||||||||||||
31484 | 31484 | Charles Carney C000164 | rep | OH | 1975-01-14 | 1977-01-03 | Democrat | 19 | |||||||||||||
31885 | 31885 | Charles Whalen W000317 | rep | OH | 1975-01-14 | 1977-01-03 | Republican | 3 | |||||||||||||
31940 | 31940 | Thomas Ashley A000222 | rep | OH | 1975-01-14 | 1977-01-03 | Democrat | 9 | |||||||||||||
32023 | 32023 | Samuel Devine D000279 | rep | OH | 1975-01-14 | 1977-01-03 | Republican | 12 | |||||||||||||
32107 | 32107 | William Harsha H000281 | rep | OH | 1975-01-14 | 1977-01-03 | Republican | 6 | |||||||||||||
32386 | 32386 | Charles Vanik V000047 | rep | OH | 1975-01-14 | 1977-01-03 | Democrat | 22 | |||||||||||||
32453 | 32453 | John Ashbrook A000221 | rep | OH | 1975-01-14 | 1977-01-03 | Republican | 17 | |||||||||||||
32528 | 32528 | Clarence Brown B000910 | rep | OH | 1975-01-14 | 1977-01-03 | Republican | 7 | |||||||||||||
32693 | 32693 | Tennyson Guyer G000537 | rep | OH | 1975-01-14 | 1977-01-03 | Republican | 4 | |||||||||||||
32790 | 32790 | Ronald Mottl M001044 | rep | OH | 1975-01-14 | 1977-01-03 | Democrat | 23 | |||||||||||||
32863 | 32863 | John Stanton S000804 | rep | OH | 1975-01-14 | 1977-01-03 | Republican | 11 | |||||||||||||
33323 | 33323 | Thomas Kindness K000190 | rep | OH | 1975-01-14 | 1977-01-03 | Republican | 8 | |||||||||||||
33406 | 33406 | John Seiberling S000230 | rep | OH | 1975-01-14 | 1977-01-03 | Democrat | 14 | |||||||||||||
33645 | 33645 | Delbert Latta L000116 | rep | OH | 1975-01-14 | 1977-01-03 | Republican | 5 | |||||||||||||
34014 | 34014 | Howard Metzenbaum M000678 | sen | OH | 1976-12-29 | 1977-01-03 | 1 | Democrat | |||||||||||||
34755 | 34755 | Clarence Miller M000718 | rep | OH | 1975-01-14 | 1977-01-03 | Republican | 10 | |||||||||||||
35069 | 35069 | Chalmers Wylie W000781 | rep | OH | 1975-01-14 | 1977-01-03 | Republican | 15 | |||||||||||||
35299 | 35299 | Willis Gradison G000349 | rep | OH | 1975-01-14 | 1977-01-03 | Republican | 1 | |||||||||||||
36401 | 36401 | Louis Stokes S000948 | rep | OH | 1975-01-14 | 1977-01-03 | Democrat | 21 | |||||||||||||
38294 | 38294 | Ralph Regula R000141 | rep | OH | 1975-01-14 | 1977-01-03 | Republican | 16 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [legislator_terms] ( [legislator_id] TEXT REFERENCES [legislators]([id]), [type] TEXT, [state] TEXT, [start] TEXT, [end] TEXT, [class] INTEGER, [party] TEXT , [district] INTEGER, [how] TEXT, [party_affiliations] TEXT, [url] TEXT, [caucus] TEXT, [address] TEXT, [phone] TEXT, [fax] TEXT, [contact_form] TEXT, [office] TEXT, [state_rank] TEXT, [rss_url] TEXT, [end-type] TEXT);