legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
19 rows where "start" is on date 1935-01-03 and state = "MI"
This data as json, copyable, CSV (advanced)
Suggested facets: type, end, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21839 | 21839 | Henry Kimball K000183 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
21859 | 21859 | Verner Main M000071 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
22012 | 22012 | Prentiss Brown B000941 | rep | MI | 1935-01-03 | 1936-11-18 | Democrat | 11 | |||||||||||||
22685 | 22685 | Carl Mapes M000119 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 5 | |||||||||||||
22712 | 22712 | Clarence McLeod M000557 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 13 | |||||||||||||
23890 | 23890 | Frank Hook H000757 | rep | MI | 1935-01-03 | 1937-01-03 | Democrat | 12 | |||||||||||||
24709 | 24709 | Arthur Vandenberg V000025 | sen | MI | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
24822 | 24822 | Albert Engel E000178 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 9 | |||||||||||||
24890 | 24890 | John Lesinski L000251 | rep | MI | 1935-01-03 | 1937-01-03 | Democrat | 16 | |||||||||||||
24940 | 24940 | Earl Michener M000693 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
25012 | 25012 | George Sadowski S000011 | rep | MI | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
25138 | 25138 | William Blackney B000515 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 6 | |||||||||||||
25203 | 25203 | Fred Crawford C000889 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 8 | |||||||||||||
25560 | 25560 | Roy Woodruff W000718 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 10 | |||||||||||||
25912 | 25912 | John Dingell D000354 | rep | MI | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
25930 | 25930 | George Dondero D000411 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 17 | |||||||||||||
26138 | 26138 | Jesse Wolcott W000668 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 7 | |||||||||||||
27231 | 27231 | Clare Hoffman H000683 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 4 | |||||||||||||
27416 | 27416 | Louis Rabaut R000001 | rep | MI | 1935-01-03 | 1937-01-03 | Democrat | 14 |
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);