legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
494 rows where "end" is on date 1915-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16739 | 16739 | William Cullop C000975 | rep | IN | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
18142 | 18142 | Albert Cummins C000988 | sen | IA | 1909-03-04 | 1915-03-03 | 3 | Republican | |||||||||||||
23820 | 23820 | James Curley C000996 | rep | MA | 1913-04-07 | 1915-03-03 | Democrat | 12 | |||||||||||||
19637 | 19637 | Charles Curry C001000 | rep | CA | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
17129 | 17129 | Harry Dale D000008 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
16742 | 16742 | Henry Danforth D000029 | rep | NY | 1913-04-07 | 1915-03-03 | Republican | 39 | |||||||||||||
16746 | 16746 | James Davenport D000074 | rep | OK | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
18612 | 18612 | Charles Davis D000093 | rep | MN | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
16342 | 16342 | John Davis D000121 | rep | WV | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
17141 | 17141 | Perl Decker D000184 | rep | MO | 1913-04-07 | 1915-03-03 | Democrat | 15 | |||||||||||||
16343 | 16343 | Frederick Deitrick D000201 | rep | MA | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
17637 | 17637 | Stanley Dent D000256 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16344 | 16344 | Franklin Dershem D000268 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 17 | |||||||||||||
21225 | 21225 | Clement Dickinson D000316 | rep | MO | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
17147 | 17147 | Martin Dies D000337 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16346 | 16346 | Robert Difenderfer D000343 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
18150 | 18150 | William Dillingham D000347 | sen | VT | 1909-03-15 | 1915-03-03 | 3 | Republican | |||||||||||||
17150 | 17150 | Charles Dillon D000348 | rep | SD | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
17157 | 17157 | Lincoln Dixon D000374 | rep | IN | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
16348 | 16348 | Michael Donohoe D000418 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
16349 | 16349 | Jeremiah Donovan D000422 | rep | CT | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
17647 | 17647 | Peter Dooling D000426 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 16 | |||||||||||||
17160 | 17160 | Dudley Doolittle D000427 | rep | KS | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
17652 | 17652 | Frank Doremus D000431 | rep | MI | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
25214 | 25214 | Robert Doughton D000448 | rep | NC | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
16751 | 16751 | Daniel Driscoll D000500 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 42 | |||||||||||||
17163 | 17163 | Dow Drukker D000505 | rep | NJ | 1913-04-07 | 1915-03-03 | Republican | 7 | |||||||||||||
18153 | 18153 | Thomas Dunn D000553 | rep | NY | 1913-04-07 | 1915-03-03 | Republican | 38 | |||||||||||||
18620 | 18620 | Henry Dupré D000561 | rep | LA | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
20320 | 20320 | Leonidas Dyer D000591 | rep | MO | 1913-04-07 | 1915-03-03 | Republican | 12 | |||||||||||||
18626 | 18626 | John Eagan E000001 | rep | NJ | 1913-04-07 | 1915-03-03 | Democrat | 11 | |||||||||||||
21752 | 21752 | Joe Eagle E000003 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
16753 | 16753 | Manuel Earnshaw E000015 | rep | PI | 1913-04-07 | 1915-03-03 | 0 | ||||||||||||||
21243 | 21243 | George Edmonds E000053 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 4 | |||||||||||||
20343 | 20343 | Charles Edwards E000062 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
16350 | 16350 | James Elder E000102 | rep | LA | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
17671 | 17671 | John Esch E000212 | rep | WI | 1913-04-07 | 1915-03-03 | Republican | 7 | |||||||||||||
17678 | 17678 | Albert Estopinal E000224 | rep | LA | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
20359 | 20359 | John Evans E000247 | rep | MT | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
17170 | 17170 | George Fairchild F000005 | rep | NY | 1913-04-07 | 1915-03-03 | Republican | 34 | |||||||||||||
16352 | 16352 | John Faison F000008 | rep | NC | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16353 | 16353 | Jacob Falconer F000009 | rep | WA | 1913-04-07 | 1915-03-03 | Progressive | -1 | |||||||||||||
17687 | 17687 | John Farr F000029 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 10 | |||||||||||||
16356 | 16356 | Harvey Fergusson F000083 | rep | NM | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
17694 | 17694 | Scott Ferris F000091 | rep | OK | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
19696 | 19696 | Simeon Fess F000096 | rep | OH | 1913-04-07 | 1915-03-03 | Republican | 6 | |||||||||||||
18642 | 18642 | William Fields F000113 | rep | KY | 1913-04-07 | 1915-03-03 | Democrat | 9 | |||||||||||||
17180 | 17180 | David Finley F000131 | rep | SC | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
17190 | 17190 | John Fitzgerald F000165 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
16357 | 16357 | Louis Fitzhenry F000172 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 17 | |||||||||||||
21259 | 21259 | Duncan Fletcher F000200 | sen | FL | 1909-03-15 | 1915-03-03 | 3 | Democrat | |||||||||||||
18173 | 18173 | Henry Flood F000210 | rep | VA | 1913-04-07 | 1915-03-03 | Democrat | 10 | |||||||||||||
16362 | 16362 | John Floyd F000222 | rep | AR | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
18185 | 18185 | Joseph Fordney F000271 | rep | MI | 1913-04-07 | 1915-03-03 | Republican | 8 | |||||||||||||
17209 | 17209 | Martin Foster F000309 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 23 | |||||||||||||
16364 | 16364 | Hiram Fowler F000321 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 24 | |||||||||||||
16366 | 16366 | William Francis F000337 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 16 | |||||||||||||
21270 | 21270 | James Frear F000355 | rep | WI | 1913-04-07 | 1915-03-03 | Republican | 10 | |||||||||||||
20391 | 20391 | Burton French F000375 | rep | ID | 1913-04-07 | 1915-03-03 | Republican | -1 | |||||||||||||
17706 | 17706 | Thomas Gallagher G000018 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
16761 | 16761 | Jacob Gallinger G000023 | sen | NH | 1909-03-15 | 1915-03-03 | 3 | Republican | |||||||||||||
19308 | 19308 | James Gallivan G000024 | rep | MA | 1913-04-07 | 1915-03-03 | Democrat | 12 | |||||||||||||
17713 | 17713 | Warren Gard G000048 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
17221 | 17221 | Augustus Gardner G000050 | rep | MA | 1913-04-07 | 1915-03-03 | Republican | 6 | |||||||||||||
21286 | 21286 | John Garner G000074 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 15 | |||||||||||||
20408 | 20408 | Daniel Garrett G000081 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
19323 | 19323 | Finis Garrett G000082 | rep | TN | 1913-04-07 | 1915-03-03 | Democrat | 9 | |||||||||||||
16368 | 16368 | Henry George G000126 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 21 | |||||||||||||
23010 | 23010 | Peter Gerry G000141 | rep | RI | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16369 | 16369 | Michael Gill G000190 | rep | MO | 1913-04-07 | 1915-03-03 | Democrat | 12 | |||||||||||||
18969 | 18969 | Frederick Gillett G000201 | rep | MA | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
16370 | 16370 | Edward Gilmore G000221 | rep | MA | 1913-04-07 | 1915-03-03 | Democrat | 14 | |||||||||||||
16371 | 16371 | Robert Gittins G000228 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 40 | |||||||||||||
23518 | 23518 | Carter Glass G000232 | rep | VA | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
17723 | 17723 | Hannibal Godwin G000250 | rep | NC | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
16373 | 16373 | John Goeke G000252 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
17733 | 17733 | Henry Goldfogle G000260 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 12 | |||||||||||||
18196 | 18196 | James Good G000275 | rep | IA | 1913-04-07 | 1915-03-03 | Republican | 5 | |||||||||||||
16378 | 16378 | Forrest Goodwin G000298 | rep | ME | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
17738 | 17738 | William Goodwin G000304 | rep | AR | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
17224 | 17224 | William Gordon G000317 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 20 | |||||||||||||
20431 | 20431 | Thomas Gore G000323 | sen | OK | 1909-03-15 | 1915-03-03 | 3 | Democrat | |||||||||||||
16379 | 16379 | George Gorman G000327 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16767 | 16767 | Joseph Goulden G000344 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 23 | |||||||||||||
20434 | 20434 | George Graham G000354 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
16382 | 16382 | James Graham G000357 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 21 | |||||||||||||
22187 | 22187 | Finly Gray G000395 | rep | IN | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
19334 | 19334 | William Green G000422 | rep | IA | 1913-04-07 | 1915-03-03 | Republican | 9 | |||||||||||||
19734 | 19734 | Frank Greene G000425 | rep | VT | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
18668 | 18668 | William Greene G000430 | rep | MA | 1913-04-07 | 1915-03-03 | Republican | 15 | |||||||||||||
17236 | 17236 | Alexander Gregg G000441 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
19743 | 19743 | William Griest G000456 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 9 | |||||||||||||
17239 | 17239 | Daniel Griffin G000460 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
16772 | 16772 | Asle Gronna G000491 | sen | ND | 1911-04-04 | 1915-03-03 | 3 | Republican | |||||||||||||
16386 | 16386 | James Gudger G000514 | rep | NC | 1913-04-07 | 1915-03-03 | Democrat | 10 | |||||||||||||
16777 | 16777 | Frank Guernsey G000517 | rep | ME | 1913-04-07 | 1915-03-03 | Republican | 4 | |||||||||||||
17746 | 17746 | James Hamill H000099 | rep | NJ | 1913-04-07 | 1915-03-03 | Democrat | 12 | |||||||||||||
17242 | 17242 | Charles Hamilton H000104 | rep | NY | 1913-04-07 | 1915-03-03 | Republican | 43 | |||||||||||||
17758 | 17758 | Edward Hamilton H000108 | rep | MI | 1913-04-07 | 1915-03-03 | Republican | 4 | |||||||||||||
17249 | 17249 | Courtney Hamlin H000119 | rep | MO | 1913-04-07 | 1915-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);