legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
496 rows where "start" is on date 1917-04-02 sorted by rowid descending
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28205 | 28205 | Carl Vinson V000105 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 10 | |||||||||||||
27846 | 27846 | Carl Hayden H000385 | rep | AZ | 1917-04-02 | 1919-03-03 | Democrat | 0 | |||||||||||||
27436 | 27436 | Samuel Rayburn R000082 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
26065 | 26065 | Matthew Neely N000023 | rep | WV | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
25869 | 25869 | Alben Barkley B000145 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
25641 | 25641 | Robert Crosser C000932 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 21 | |||||||||||||
25459 | 25459 | Adolph Sabath S000001 | rep | IL | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
25216 | 25216 | Robert Doughton D000448 | rep | NC | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
24742 | 24742 | Schuyler Bland B000545 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
24607 | 24607 | Kenneth McKellar M000499 | sen | TN | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
24577 | 24577 | Joseph Mansfield M000112 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 9 | |||||||||||||
24535 | 24535 | Clarence Lea L000163 | rep | CA | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
24514 | 24514 | Harold Knutson K000301 | rep | MN | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
24339 | 24339 | John Delaney D000212 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
24313 | 24313 | Thomas Connally C000684 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 11 | |||||||||||||
24186 | 24186 | Zebulon Weaver W000230 | rep | NC | 1917-04-02 | 1919-03-03 | Democrat | 10 | |||||||||||||
24115 | 24115 | Hatton Sumners S001072 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
23747 | 23747 | Wallace White W000396 | rep | ME | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
23713 | 23713 | Allen Treadway T000358 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
23688 | 23688 | Henry Steagall S000820 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
23520 | 23520 | Carter Glass G000232 | rep | VA | 1917-04-02 | 1918-12-16 | Democrat | 6 | |||||||||||||
23297 | 23297 | George Tinkham T000283 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 11 | |||||||||||||
23274 | 23274 | Edward Taylor T000072 | rep | CO | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
23194 | 23194 | Milton Romjue R000418 | rep | MO | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
23184 | 23184 | Jeannette Rankin R000055 | rep | MT | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
23072 | 23072 | Hiram Johnson J000140 | sen | CA | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
23011 | 23011 | Peter Gerry G000141 | sen | RI | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
22792 | 22792 | Christopher Sullivan S001051 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 13 | |||||||||||||
22700 | 22700 | James McAndrews M000296 | rep | IL | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
22676 | 22676 | Carl Mapes M000119 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
22637 | 22637 | John Jones J000236 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 13 | |||||||||||||
22572 | 22572 | Cassius Dowell D000468 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 7 | |||||||||||||
22550 | 22550 | George Darrow D000063 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
22488 | 22488 | William Bankhead B000113 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 10 | |||||||||||||
22481 | 22481 | William Ashbrook A000306 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 17 | |||||||||||||
22417 | 22417 | Bertrand Snell S000652 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 31 | |||||||||||||
22318 | 22318 | Andrew Montague M000861 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
22285 | 22285 | Ernest Lundeen L000514 | rep | MN | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
22221 | 22221 | Byron Harrison H000265 | rep | MS | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
22147 | 22147 | Benjamin Focht F000230 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 17 | |||||||||||||
22080 | 22080 | James Byrnes B001215 | rep | SC | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
22064 | 22064 | James Buchanan B001006 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 10 | |||||||||||||
21998 | 21998 | Riley Wilson W000608 | rep | LA | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
21977 | 21977 | Park Trammell T000353 | sen | FL | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
21961 | 21961 | William Sears S000211 | rep | FL | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
21928 | 21928 | Key Pittman P000372 | sen | NV | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
21901 | 21901 | William Oliver O000077 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
21880 | 21880 | Schuyler Merritt M000663 | rep | CT | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
21847 | 21847 | Frederick Lehlbach L000222 | rep | NJ | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
21842 | 21842 | William King K000216 | sen | UT | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
21819 | 21819 | George Huddleston H000903 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 9 | |||||||||||||
21797 | 21797 | Frederick Hale H000031 | sen | ME | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
21780 | 21780 | Anthony Griffin G000457 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 22 | |||||||||||||
21754 | 21754 | Joe Eagle E000003 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
21711 | 21711 | John Cooper C000757 | rep | OH | 1917-04-02 | 1919-03-03 | Republican | 19 | |||||||||||||
21674 | 21674 | Joseph Byrns B001217 | rep | TN | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
21643 | 21643 | Thomas Blanton B000549 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 16 | |||||||||||||
21630 | 21630 | Isaac Bacharach B000009 | rep | NJ | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
21623 | 21623 | Henry Ashurst A000319 | sen | AZ | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
21588 | 21588 | Henry Watson W000201 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 8 | |||||||||||||
21561 | 21561 | Nathan Strong S001015 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 27 | |||||||||||||
21535 | 21535 | Ashton Shallenberger S000280 | rep | NE | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
21518 | 21518 | Henry Rainey R000014 | rep | IL | 1917-04-02 | 1919-03-03 | Democrat | 20 | |||||||||||||
21490 | 21490 | Edward Pou P000474 | rep | NC | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
21466 | 21466 | James Parker P000062 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 29 | |||||||||||||
21423 | 21423 | Thomas McKeown M000511 | rep | OK | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
21410 | 21410 | Louis McFadden M000434 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 14 | |||||||||||||
21400 | 21400 | James McClintic M000338 | rep | OK | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
21380 | 21380 | Augustine Lonergan L000409 | rep | CT | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
21351 | 21351 | Melville Kelly K000076 | rep | PA | 1917-04-02 | 1919-03-03 | Progressive | 30 | |||||||||||||
21332 | 21332 | William James J000053 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 12 | |||||||||||||
21307 | 21307 | William Hastings H000333 | rep | OK | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
21288 | 21288 | John Garner G000074 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 15 | |||||||||||||
21272 | 21272 | James Frear F000355 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
21245 | 21245 | George Edmonds E000053 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
21227 | 21227 | Clement Dickinson D000316 | rep | MO | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
21197 | 21197 | Denver Church C000387 | rep | CA | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
21152 | 21152 | Frederick Britten B000847 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 9 | |||||||||||||
21133 | 21133 | Charles Brand B000767 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
21097 | 21097 | William Ayres A000354 | rep | KS | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
21081 | 21081 | Edward Almon A000162 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
21031 | 21031 | William Wright W000773 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
21023 | 21023 | William Wood W000706 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
21005 | 21005 | James Wickersham W000438 | rep | AK | 1917-04-02 | 1919-03-03 | Republican | 0 | |||||||||||||
20986 | 20986 | Edward Wason W000185 | rep | NH | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
20968 | 20968 | Albert Vestal V000092 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 8 | |||||||||||||
20944 | 20944 | Charles Timberlake T000281 | rep | CO | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
20935 | 20935 | John Tilson T000279 | rep | CT | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
20918 | 20918 | Henry Temple T000119 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 24 | |||||||||||||
20882 | 20882 | William Stevenson S000895 | rep | SC | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
20878 | 20878 | William Stafford S000777 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
20860 | 20860 | Addison Smith S000511 | rep | ID | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
20834 | 20834 | Thomas Schall S000113 | rep | MN | 1917-04-02 | 1919-03-03 | Progressive | 10 | |||||||||||||
20825 | 20825 | Archie Sanders S000032 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 39 | |||||||||||||
20799 | 20799 | Christian Ramseyer R000031 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
20790 | 20790 | Percy Quin Q000014 | rep | MS | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
20780 | 20780 | Fred Purnell P000573 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 9 | |||||||||||||
20752 | 20752 | John Nelson N000039 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
20702 | 20702 | James McLaughlin M000539 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 9 | |||||||||||||
20670 | 20670 | Nicholas Longworth L000433 | rep | OH | 1917-04-02 | 1919-03-03 | Republican | 1 |
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);