legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
27 rows where "end" is on date 1929-03-03 and state = "IL"
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19384 | 19384 | Edward King K000200 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 15 | |||||||||||||
19417 | 19417 | Martin Madden M000038 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
19466 | 19466 | Henry Rathbone R000068 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | -1 | |||||||||||||
19663 | 19663 | Edward Denison D000237 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 25 | |||||||||||||
19672 | 19672 | Thomas Doyle D000483 | rep | IL | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
19794 | 19794 | Edward Irwin I000040 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 22 | |||||||||||||
19877 | 19877 | Magne Michaelson M000690 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 7 | |||||||||||||
19972 | 19972 | Elliott Sproul S000758 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
20048 | 20048 | Thomas Williams W000542 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 24 | |||||||||||||
20081 | 20081 | Charles Adkins A000057 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 19 | |||||||||||||
20090 | 20090 | John Allen A000131 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 14 | |||||||||||||
20179 | 20179 | Carl Chindblom C000361 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 10 | |||||||||||||
20458 | 20458 | Homer Hall H000053 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 17 | |||||||||||||
20525 | 20525 | William Holaday H000708 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 18 | |||||||||||||
20553 | 20553 | Morton Hull H000944 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20558 | 20558 | William Hull H000946 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 16 | |||||||||||||
20561 | 20561 | James Igoe I000003 | rep | IL | 1927-12-05 | 1929-03-03 | Democrat | 6 | |||||||||||||
20585 | 20585 | William Johnson J000181 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 13 | |||||||||||||
20617 | 20617 | Stanley Kunz K000342 | rep | IL | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
21055 | 21055 | Richard Yates Y000011 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | -1 | |||||||||||||
21157 | 21157 | Frederick Britten B000847 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 9 | |||||||||||||
21391 | 21391 | James Major M000073 | rep | IL | 1927-12-05 | 1929-03-03 | Democrat | 21 | |||||||||||||
21522 | 21522 | Henry Rainey R000014 | rep | IL | 1927-12-05 | 1929-03-03 | Democrat | 20 | |||||||||||||
21528 | 21528 | Frank Reid R000145 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 11 | |||||||||||||
21617 | 21617 | William Arnold A000300 | rep | IL | 1927-12-05 | 1929-03-03 | Democrat | 23 | |||||||||||||
21661 | 21661 | John Buckbee B001020 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 12 | |||||||||||||
25464 | 25464 | Adolph Sabath S000001 | rep | IL | 1927-12-05 | 1929-03-03 | Democrat | 5 |
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);