legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
26 rows where "start" is on date 1981-01-05 and state = "OH"
This data as json, copyable, CSV (advanced)
Suggested facets: type, end, party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32445 | 32445 | Jean Ashbrook A000220 | rep | OH | 1981-01-05 | 1983-01-03 | Republican | 17 | |||||||||||||
32456 | 32456 | John Ashbrook A000221 | rep | OH | 1981-01-05 | 1983-01-03 | Republican | 17 | |||||||||||||
32531 | 32531 | Clarence Brown B000910 | rep | OH | 1981-01-05 | 1983-01-03 | Republican | 7 | |||||||||||||
32696 | 32696 | Tennyson Guyer G000537 | rep | OH | 1981-01-05 | 1983-01-03 | Republican | 4 | |||||||||||||
32793 | 32793 | Ronald Mottl M001044 | rep | OH | 1981-01-05 | 1983-01-03 | Democrat | 23 | |||||||||||||
32855 | 32855 | Robert Shamansky S000282 | rep | OH | 1981-01-05 | 1983-01-03 | Democrat | 12 | |||||||||||||
32866 | 32866 | John Stanton S000804 | rep | OH | 1981-01-05 | 1983-01-03 | Republican | 11 | |||||||||||||
32880 | 32880 | Edward Weber W000235 | rep | OH | 1981-01-05 | 1983-01-03 | Republican | 9 | |||||||||||||
33174 | 33174 | Lyle Williams W000528 | rep | OH | 1981-01-05 | 1983-01-03 | Republican | 19 | |||||||||||||
33326 | 33326 | Thomas Kindness K000190 | rep | OH | 1981-01-05 | 1983-01-03 | Republican | 8 | |||||||||||||
33409 | 33409 | John Seiberling S000230 | rep | OH | 1981-01-05 | 1983-01-03 | Democrat | 14 | |||||||||||||
33648 | 33648 | Delbert Latta L000116 | rep | OH | 1981-01-05 | 1983-01-03 | Republican | 5 | |||||||||||||
33989 | 33989 | Thomas Luken L000508 | rep | OH | 1981-01-05 | 1983-01-03 | Democrat | 2 | |||||||||||||
34420 | 34420 | Dennis Eckart E000031 | rep | OH | 1981-01-05 | 1983-01-03 | Democrat | 22 | |||||||||||||
34727 | 34727 | Bob McEwen M000432 | rep | OH | 1981-01-05 | 1983-01-03 | Republican | 6 | |||||||||||||
34758 | 34758 | Clarence Miller M000718 | rep | OH | 1981-01-05 | 1983-01-03 | Republican | 10 | |||||||||||||
34804 | 34804 | Mary Oakar O000001 | rep | OH | 1981-01-05 | 1983-01-03 | Democrat | 20 | |||||||||||||
34824 | 34824 | Donald Pease P000170 | rep | OH | 1981-01-05 | 1983-01-03 | Democrat | 13 | |||||||||||||
35072 | 35072 | Chalmers Wylie W000781 | rep | OH | 1981-01-05 | 1983-01-03 | Republican | 15 | |||||||||||||
35101 | 35101 | Douglas Applegate A000214 | rep | OH | 1981-01-05 | 1983-01-03 | Democrat | 18 | |||||||||||||
35287 | 35287 | John Glenn G000236 | sen | OH | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
35302 | 35302 | Willis Gradison G000349 | rep | OH | 1981-01-05 | 1983-01-03 | Republican | 1 | |||||||||||||
36404 | 36404 | Louis Stokes S000948 | rep | OH | 1981-01-05 | 1983-01-03 | Democrat | 21 | |||||||||||||
36937 | 36937 | Tony Hall H000074 | rep | OH | 1981-01-05 | 1983-01-03 | Democrat | 3 | |||||||||||||
37820 | 37820 | Michael Oxley O000163 | rep | OH | 1981-01-05 | 1983-01-03 | Republican | 4 | |||||||||||||
38297 | 38297 | Ralph Regula R000141 | rep | OH | 1981-01-05 | 1983-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);