legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
506 rows where "end" is on date 1919-03-03 sorted by legislator_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24339 | 24339 | John Delaney D000212 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
19650 | 19650 | Stephen Dempsey D000229 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 40 | |||||||||||||
19658 | 19658 | Edward Denison D000237 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 25 | |||||||||||||
17639 | 17639 | Stanley Dent D000256 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
17144 | 17144 | George Denton D000258 | rep | IN | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
18145 | 18145 | Jaime De Veyra D000276 | rep | PI | 1917-04-02 | 1919-03-03 | 0 | ||||||||||||||
17642 | 17642 | Arthur Dewalt D000288 | rep | PA | 1917-04-02 | 1919-03-03 | Democrat | 13 | |||||||||||||
21227 | 21227 | Clement Dickinson D000316 | rep | MO | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
17149 | 17149 | Martin Dies D000337 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
19666 | 19666 | Clarence Dill D000345 | rep | WA | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
17152 | 17152 | Charles Dillon D000348 | rep | SD | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17159 | 17159 | Lincoln Dixon D000374 | rep | IN | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
20300 | 20300 | Frederick Dominick D000408 | rep | SC | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
17645 | 17645 | Jerome Donovan D000423 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 21 | |||||||||||||
17649 | 17649 | Peter Dooling D000426 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 16 | |||||||||||||
17162 | 17162 | Dudley Doolittle D000427 | rep | KS | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
17654 | 17654 | Frank Doremus D000431 | rep | MI | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
25216 | 25216 | Robert Doughton D000448 | rep | NC | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
22572 | 22572 | Cassius Dowell D000468 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 7 | |||||||||||||
20311 | 20311 | Herbert Drane D000486 | rep | FL | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17522 | 17522 | Irving Drew D000495 | sen | NH | 1918-09-02 | 1919-03-03 | 3 | Republican | appointment | ||||||||||||
17165 | 17165 | Dow Drukker D000505 | rep | NJ | 1917-04-02 | 1919-03-03 | Republican | 7 | |||||||||||||
18155 | 18155 | Thomas Dunn D000553 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 38 | |||||||||||||
18622 | 18622 | Henry Dupré D000561 | rep | LA | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
20322 | 20322 | Leonidas Dyer D000591 | rep | MO | 1917-04-02 | 1919-03-03 | Republican | 12 | |||||||||||||
18628 | 18628 | John Eagan E000001 | rep | NJ | 1917-04-02 | 1919-03-03 | Democrat | 11 | |||||||||||||
21754 | 21754 | Joe Eagle E000003 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
21245 | 21245 | George Edmonds E000053 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
19677 | 19677 | Richard Elliott E000127 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
17659 | 17659 | Franklin Ellsworth E000145 | rep | MN | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
18161 | 18161 | John Elston E000161 | rep | CA | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
17662 | 17662 | Henry Emerson E000171 | rep | OH | 1917-04-02 | 1919-03-03 | Republican | 22 | |||||||||||||
17673 | 17673 | John Esch E000212 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 7 | |||||||||||||
17166 | 17166 | Frederick Essen E000219 | rep | MO | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
17680 | 17680 | Albert Estopinal E000224 | rep | LA | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
20361 | 20361 | John Evans E000247 | rep | MT | 1917-04-02 | 1919-03-03 | Democrat | -1 | |||||||||||||
18935 | 18935 | Benjamin Fairchild F000004 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 24 | |||||||||||||
17172 | 17172 | George Fairchild F000005 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 34 | |||||||||||||
18633 | 18633 | Louis Fairfield F000007 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 12 | |||||||||||||
17684 | 17684 | Albert Fall F000011 | sen | NM | 1913-03-04 | 1919-03-03 | 2 | Republican | |||||||||||||
17689 | 17689 | John Farr F000029 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
18939 | 18939 | Bert Fernald F000084 | sen | ME | 1916-01-01 | 1919-03-03 | 2 | Republican | |||||||||||||
17696 | 17696 | Scott Ferris F000091 | rep | OK | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
19698 | 19698 | Simeon Fess F000096 | rep | OH | 1917-04-02 | 1919-03-03 | Republican | 7 | |||||||||||||
18644 | 18644 | William Fields F000113 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 9 | |||||||||||||
17182 | 17182 | David Finley F000131 | rep | SC | 1917-04-02 | 1919-03-03 | Democrat | -1 | |||||||||||||
19703 | 19703 | Hubert Fisher F000149 | rep | TN | 1917-04-02 | 1919-03-03 | Democrat | 10 | |||||||||||||
17192 | 17192 | John Fitzgerald F000165 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
18175 | 18175 | Henry Flood F000210 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 10 | |||||||||||||
17194 | 17194 | Joseph Flynn F000228 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
22147 | 22147 | Benjamin Focht F000230 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 17 | |||||||||||||
18187 | 18187 | Joseph Fordney F000271 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 8 | |||||||||||||
17205 | 17205 | George Foss F000295 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
17211 | 17211 | Martin Foster F000309 | rep | IL | 1917-04-02 | 1919-03-03 | Democrat | 23 | |||||||||||||
17213 | 17213 | George Francis F000335 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 18 | |||||||||||||
21272 | 21272 | James Frear F000355 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
20379 | 20379 | Richard Freeman F000366 | rep | CT | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
20392 | 20392 | Burton French F000375 | rep | ID | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
17702 | 17702 | Alvan Fuller F000405 | rep | MA | 1917-04-02 | 1919-03-03 | Ind. Republican | 9 | |||||||||||||
18951 | 18951 | Charles Fuller F000407 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 12 | |||||||||||||
17708 | 17708 | Thomas Gallagher G000018 | rep | IL | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
16762 | 16762 | Jacob Gallinger G000023 | sen | NH | 1915-12-06 | 1919-03-03 | 3 | Republican | |||||||||||||
19310 | 19310 | James Gallivan G000024 | rep | MA | 1917-04-02 | 1919-03-03 | Democrat | 12 | |||||||||||||
17711 | 17711 | Harry Gandy G000037 | rep | SD | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
17715 | 17715 | Warren Gard G000048 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
17223 | 17223 | Augustus Gardner G000050 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
17718 | 17718 | Mahlon Garland G000068 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
21288 | 21288 | John Garner G000074 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 15 | |||||||||||||
20409 | 20409 | Daniel Garrett G000081 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | -1 | |||||||||||||
19325 | 19325 | Finis Garrett G000082 | rep | TN | 1917-04-02 | 1919-03-03 | Democrat | 9 | |||||||||||||
18971 | 18971 | Frederick Gillett G000201 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
19726 | 19726 | James Glynn G000246 | rep | CT | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
17725 | 17725 | Hannibal Godwin G000250 | rep | NC | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
16377 | 16377 | Nathan Goff G000255 | sen | WV | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
18198 | 18198 | James Good G000275 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
17735 | 17735 | Louis Goodall G000276 | rep | ME | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17740 | 17740 | William Goodwin G000304 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
17226 | 17226 | William Gordon G000317 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 20 | |||||||||||||
18204 | 18204 | Norman Gould G000342 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 36 | |||||||||||||
20436 | 20436 | George Graham G000354 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
18656 | 18656 | William Graham G000364 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 14 | |||||||||||||
17228 | 17228 | Edward Gray G000393 | rep | NJ | 1917-04-02 | 1919-03-03 | Republican | 8 | |||||||||||||
17230 | 17230 | Oscar Gray G000401 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
19336 | 19336 | William Green G000422 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 9 | |||||||||||||
19736 | 19736 | Frank Greene G000425 | rep | VT | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
18670 | 18670 | William Greene G000430 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 15 | |||||||||||||
17238 | 17238 | Alexander Gregg G000441 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
19745 | 19745 | William Griest G000456 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 9 | |||||||||||||
21780 | 21780 | Anthony Griffin G000457 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 22 | |||||||||||||
17241 | 17241 | Daniel Griffin G000460 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
17524 | 17524 | Walter Guion G000522 | sen | LA | 1918-04-22 | 1919-03-03 | 3 | Democrat | appointment | ||||||||||||
20446 | 20446 | Lindley Hadley H000008 | rep | WA | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
17748 | 17748 | James Hamill H000099 | rep | NJ | 1917-04-02 | 1919-03-03 | Democrat | 12 | |||||||||||||
17244 | 17244 | Charles Hamilton H000104 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 43 | |||||||||||||
17760 | 17760 | Edward Hamilton H000108 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
17251 | 17251 | Courtney Hamlin H000119 | rep | MO | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
16658 | 16658 | Thomas Hardwick H000193 | sen | GA | 1914-01-01 | 1919-03-03 | 2 | Democrat | |||||||||||||
18212 | 18212 | Rufus Hardy H000198 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
22221 | 22221 | Byron Harrison H000265 | rep | MS | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
19343 | 19343 | Thomas Harrison H000277 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 7 |
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);