legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
481 rows where "start" is on date 1915-12-06 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28204 | 28204 | Carl Vinson V000105 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 10 | |||||||||||||
27845 | 27845 | Carl Hayden H000385 | rep | AZ | 1915-12-06 | 1917-03-03 | Democrat | 0 | |||||||||||||
27435 | 27435 | Samuel Rayburn R000082 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
26064 | 26064 | Matthew Neely N000023 | rep | WV | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
25868 | 25868 | Alben Barkley B000145 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
25640 | 25640 | Robert Crosser C000932 | rep | OH | 1915-12-06 | 1917-03-03 | Democrat | 21 | |||||||||||||
25458 | 25458 | Adolph Sabath S000001 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
25215 | 25215 | Robert Doughton D000448 | rep | NC | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
25048 | 25048 | James Wadsworth W000012 | sen | NY | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
24606 | 24606 | Kenneth McKellar M000499 | rep | TN | 1915-12-06 | 1917-03-03 | Democrat | 10 | |||||||||||||
24114 | 24114 | Hatton Sumners S001072 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
23712 | 23712 | Allen Treadway T000358 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
23687 | 23687 | Henry Steagall S000820 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
23519 | 23519 | Carter Glass G000232 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
23296 | 23296 | George Tinkham T000283 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 11 | |||||||||||||
23273 | 23273 | Edward Taylor T000072 | rep | CO | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
22786 | 22786 | Ellison Smith S000530 | sen | SC | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
22699 | 22699 | James McAndrews M000296 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
22675 | 22675 | Carl Mapes M000119 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
22571 | 22571 | Cassius Dowell D000468 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 7 | |||||||||||||
22549 | 22549 | George Darrow D000063 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 6 | |||||||||||||
22480 | 22480 | William Ashbrook A000306 | rep | OH | 1915-12-06 | 1917-03-03 | Democrat | 17 | |||||||||||||
22416 | 22416 | Bertrand Snell S000652 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 31 | |||||||||||||
22377 | 22377 | Michael Reilly R000155 | rep | WI | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
22317 | 22317 | Andrew Montague M000861 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
22270 | 22270 | David Lewis L000277 | rep | MD | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
22220 | 22220 | Byron Harrison H000265 | rep | MS | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
22188 | 22188 | Finly Gray G000395 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
22146 | 22146 | Benjamin Focht F000230 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 17 | |||||||||||||
22079 | 22079 | James Byrnes B001215 | rep | SC | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
22063 | 22063 | James Buchanan B001006 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 10 | |||||||||||||
21997 | 21997 | Riley Wilson W000608 | rep | LA | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
21960 | 21960 | William Sears S000211 | rep | FL | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
21900 | 21900 | William Oliver O000077 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
21846 | 21846 | Frederick Lehlbach L000222 | rep | NJ | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
21818 | 21818 | George Huddleston H000903 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
21753 | 21753 | Joe Eagle E000003 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
21710 | 21710 | John Cooper C000757 | rep | OH | 1915-12-06 | 1917-03-03 | Republican | 19 | |||||||||||||
21673 | 21673 | Joseph Byrns B001217 | rep | TN | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
21629 | 21629 | Isaac Bacharach B000009 | rep | NJ | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
21587 | 21587 | Henry Watson W000201 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 8 | |||||||||||||
21534 | 21534 | Ashton Shallenberger S000280 | rep | NE | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
21517 | 21517 | Henry Rainey R000014 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | 20 | |||||||||||||
21489 | 21489 | Edward Pou P000474 | rep | NC | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
21465 | 21465 | James Parker P000062 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 29 | |||||||||||||
21409 | 21409 | Louis McFadden M000434 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 14 | |||||||||||||
21399 | 21399 | James McClintic M000338 | rep | OK | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
21331 | 21331 | William James J000053 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 12 | |||||||||||||
21306 | 21306 | William Hastings H000333 | rep | OK | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
21287 | 21287 | John Garner G000074 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 15 | |||||||||||||
21271 | 21271 | James Frear F000355 | rep | WI | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
21260 | 21260 | Duncan Fletcher F000200 | sen | FL | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
21244 | 21244 | George Edmonds E000053 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
21226 | 21226 | Clement Dickinson D000316 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
21196 | 21196 | Denver Church C000387 | rep | CA | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
21151 | 21151 | Frederick Britten B000847 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 9 | |||||||||||||
21096 | 21096 | William Ayres A000354 | rep | KS | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
21080 | 21080 | Edward Almon A000162 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
21022 | 21022 | William Wood W000706 | rep | IN | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
21004 | 21004 | James Wickersham W000438 | rep | AK | 1915-12-06 | 1917-03-03 | Republican | 0 | |||||||||||||
20985 | 20985 | Edward Wason W000185 | rep | NH | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
20943 | 20943 | Charles Timberlake T000281 | rep | CO | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
20934 | 20934 | John Tilson T000279 | rep | CT | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
20917 | 20917 | Henry Temple T000119 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 24 | |||||||||||||
20877 | 20877 | William Stafford S000777 | rep | WI | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
20859 | 20859 | Addison Smith S000511 | rep | ID | 1915-12-06 | 1917-03-03 | Republican | -1 | |||||||||||||
20833 | 20833 | Thomas Schall S000113 | rep | MN | 1915-12-06 | 1917-03-03 | Progressive | 10 | |||||||||||||
20798 | 20798 | Christian Ramseyer R000031 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 6 | |||||||||||||
20789 | 20789 | Percy Quin Q000014 | rep | MS | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
20751 | 20751 | John Nelson N000039 | rep | WI | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
20701 | 20701 | James McLaughlin M000539 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 9 | |||||||||||||
20669 | 20669 | Nicholas Longworth L000433 | rep | OH | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
20655 | 20655 | John Linthicum L000340 | rep | MD | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
20575 | 20575 | Royal Johnson J000173 | rep | SD | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
20565 | 20565 | Albert Johnson J000114 | rep | WA | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
20543 | 20543 | Cordell Hull H000940 | rep | TN | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
20501 | 20501 | Willis Hawley H000379 | rep | OR | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
20488 | 20488 | Gilbert Haugen H000350 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
20445 | 20445 | Lindley Hadley H000008 | rep | WA | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
20435 | 20435 | George Graham G000354 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
20432 | 20432 | Thomas Gore G000323 | sen | OK | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
20378 | 20378 | Richard Freeman F000366 | rep | CT | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
20360 | 20360 | John Evans E000247 | rep | MT | 1915-12-06 | 1917-03-03 | Democrat | -1 | |||||||||||||
20344 | 20344 | Charles Edwards E000062 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
20321 | 20321 | Leonidas Dyer D000591 | rep | MO | 1915-12-06 | 1917-03-03 | Republican | 12 | |||||||||||||
20272 | 20272 | Frederick Dallinger D000012 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 8 | |||||||||||||
20262 | 20262 | Charles Crisp C000909 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
20242 | 20242 | Henry Cooper C000752 | rep | WI | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
20213 | 20213 | James Collier C000630 | rep | MS | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
20182 | 20182 | Burnett Chiperfield C000364 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | -1 | |||||||||||||
20099 | 20099 | James Aswell A000321 | rep | LA | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
20051 | 20051 | Otis Wingo W000635 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
20042 | 20042 | Thomas Williams W000542 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 24 | |||||||||||||
19992 | 19992 | Hubert Stephens S000857 | rep | MS | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
19980 | 19980 | Charles Stedman S000827 | rep | NC | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
19957 | 19957 | Charles Sloan S000491 | rep | NE | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
19926 | 19926 | Stephen Porter P000447 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 29 | |||||||||||||
19867 | 19867 | Roscoe McCulloch M000392 | rep | OH | 1915-12-06 | 1917-03-03 | Republican | 16 | |||||||||||||
19857 | 19857 | Whitmell Martin M000201 | rep | LA | 1915-12-06 | 1917-03-03 | Progressive | 3 | |||||||||||||
19825 | 19825 | David Kincheloe K000187 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 2 |
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);