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 1935-01-03 and state = "OH"
This data as json, copyable, CSV (advanced)
Suggested facets: type, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21720 | 21720 | John Cooper C000757 | rep | OH | 1935-01-03 | 1937-01-03 | Republican | 19 | |||||||||||||
21741 | 21741 | Alvin Donahey D000410 | sen | OH | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
21749 | 21749 | Warren Duffey D000517 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
21764 | 21764 | William Fiesinger F000114 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 13 | |||||||||||||
21802 | 21802 | Peter Hammond H000131 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 11 | |||||||||||||
21816 | 21816 | John Hollister H000728 | rep | OH | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
21861 | 21861 | Leroy Marshall M000158 | rep | OH | 1935-01-03 | 1937-01-03 | Republican | 7 | |||||||||||||
21982 | 21982 | Charles Truax T000386 | rep | OH | 1935-01-03 | 1935-08-09 | Democrat | 0 | |||||||||||||
21993 | 21993 | Mell Underwood U000012 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 11 | |||||||||||||
22141 | 22141 | Thomas Fletcher F000205 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
22216 | 22216 | Byron Harlan H000209 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22245 | 22245 | Frank Kloeb K000271 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22249 | 22249 | Frank Kniffin K000283 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22262 | 22262 | Arthur Lamneck L000040 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 12 | |||||||||||||
22483 | 22483 | William Ashbrook A000306 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 17 | |||||||||||||
22505 | 22505 | Chester Bolton B000606 | rep | OH | 1935-01-03 | 1937-01-03 | Republican | 22 | |||||||||||||
23028 | 23028 | Dow Harter H000294 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 14 | |||||||||||||
23052 | 23052 | Lawrence Imhoff I000010 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 18 | |||||||||||||
23266 | 23266 | Martin Sweeney S001102 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 20 | |||||||||||||
24145 | 24145 | William Thom T000155 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 16 | |||||||||||||
25648 | 25648 | Robert Crosser C000932 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 21 | |||||||||||||
26424 | 26424 | Thomas Jenkins J000088 | rep | OH | 1935-01-03 | 1937-01-03 | Republican | 10 | |||||||||||||
26870 | 26870 | William Hess H000550 | rep | OH | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
26929 | 26929 | James Polk P000408 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
28644 | 28644 | Robert Secrest S000219 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
28747 | 28747 | Stephen Young Y000053 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 0 |
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);