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 party
This data as json, copyable, CSV (advanced)
Suggested facets: party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16753 | 16753 | Manuel Earnshaw E000015 | rep | PI | 1913-04-07 | 1915-03-03 | 0 | ||||||||||||||
16933 | 16933 | Manuel Quezon Q000009 | rep | PI | 1913-04-07 | 1915-03-03 | 0 | ||||||||||||||
15829 | 15829 | John Thornton T000241 | sen | LA | 1910-01-01 | 1915-03-03 | 3 | Democrat | |||||||||||||
16254 | 16254 | Timothy Ansberry A000259 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
16259 | 16259 | Augustus Bacon B000014 | sen | GA | 1913-04-07 | 1915-03-03 | 2 | Democrat | |||||||||||||
16260 | 16260 | Jacob Baker B000065 | rep | NJ | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16261 | 16261 | William Baltz B000107 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 22 | |||||||||||||
16282 | 16282 | Charles Bartlett B000199 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
16289 | 16289 | James Beall B000270 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
16291 | 16291 | Charles Borchers B000635 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 19 | |||||||||||||
16292 | 16292 | Stanley Bowdle B000679 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
16293 | 16293 | Robert Bremner B000796 | rep | NJ | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
16294 | 16294 | Franklin Brockson B000853 | rep | DE | 1913-04-07 | 1915-03-03 | Democrat | 0 | |||||||||||||
16295 | 16295 | Lathrop Brown B000937 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
16324 | 16324 | Albert Burleson B001110 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 10 | |||||||||||||
16325 | 16325 | Jacob Cantor C000125 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 20 | |||||||||||||
16326 | 16326 | Wooda Carr C000180 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 23 | |||||||||||||
16327 | 16327 | John Clancy C000411 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 35 | |||||||||||||
16336 | 16336 | Henry Clayton C000495 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16337 | 16337 | Maurice Connolly C000699 | rep | IA | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16340 | 16340 | James Covington C000816 | rep | MD | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
16342 | 16342 | John Davis D000121 | rep | WV | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
16343 | 16343 | Frederick Deitrick D000201 | rep | MA | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
16344 | 16344 | Franklin Dershem D000268 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 17 | |||||||||||||
16346 | 16346 | Robert Difenderfer D000343 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
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 | |||||||||||||
16350 | 16350 | James Elder E000102 | rep | LA | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
16352 | 16352 | John Faison F000008 | rep | NC | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16356 | 16356 | Harvey Fergusson F000083 | rep | NM | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
16357 | 16357 | Louis Fitzhenry F000172 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 17 | |||||||||||||
16362 | 16362 | John Floyd F000222 | rep | AR | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
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 | |||||||||||||
16368 | 16368 | Henry George G000126 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 21 | |||||||||||||
16369 | 16369 | Michael Gill G000190 | rep | MO | 1913-04-07 | 1915-03-03 | Democrat | 12 | |||||||||||||
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 | |||||||||||||
16373 | 16373 | John Goeke G000252 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
16379 | 16379 | George Gorman G000327 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16382 | 16382 | James Graham G000357 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 21 | |||||||||||||
16386 | 16386 | James Gudger G000514 | rep | NC | 1913-04-07 | 1915-03-03 | Democrat | 10 | |||||||||||||
16390 | 16390 | Winfield Hammond H000135 | rep | MN | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16391 | 16391 | Christopher Harris H000235 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
16396 | 16396 | Francis Harrison H000268 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 20 | |||||||||||||
16402 | 16402 | Richmond Hobson H000667 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
16404 | 16404 | Stephen Hoxworth H000873 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 15 | |||||||||||||
16419 | 16419 | William Kennedy K000117 | rep | CT | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
16420 | 16420 | George Kindel K000189 | rep | CO | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
16423 | 16423 | Eugene Kinkead K000222 | rep | NJ | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
16424 | 16424 | Sanford Kirkpatrick K000237 | rep | IA | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
16432 | 16432 | George Konig K000308 | rep | MD | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16435 | 16435 | Charles Korbly K000316 | rep | IN | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
16436 | 16436 | Claude L’Engle L000548 | rep | FL | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
16444 | 16444 | Robert Lee L000202 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 12 | |||||||||||||
16450 | 16450 | George Legaré L000219 | rep | SC | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
16453 | 16453 | Jefferson Levy L000268 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 14 | |||||||||||||
16456 | 16456 | James Logue L000407 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
16460 | 16460 | John Maguire M000060 | rep | NE | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
16461 | 16461 | Bryan Mahan M000061 | rep | CT | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16470 | 16470 | Lewis Martin M000193 | rep | NJ | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
16476 | 16476 | George McClellan M000330 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 27 | |||||||||||||
16478 | 16478 | Walter McCoy M000376 | rep | NJ | 1913-04-07 | 1915-03-03 | Democrat | 9 | |||||||||||||
16487 | 16487 | Herman Metz M000677 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 10 | |||||||||||||
16489 | 16489 | John Mitchell M000820 | rep | MA | 1913-04-07 | 1915-03-03 | Democrat | 13 | |||||||||||||
16490 | 16490 | William Mulkey M001070 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16498 | 16498 | William Murray M001117 | rep | MA | 1913-04-07 | 1915-03-03 | Democrat | 10 | |||||||||||||
16500 | 16500 | George Neeley N000022 | rep | KS | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
16501 | 16501 | James O’Brien O000012 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 9 | |||||||||||||
16502 | 16502 | Frank O’Hair O000052 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 18 | |||||||||||||
16503 | 16503 | Denis O’Leary O000064 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16506 | 16506 | Alexander Palmer P000035 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 26 | |||||||||||||
16525 | 16525 | Irvin Pepper P000220 | rep | IA | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16529 | 16529 | Andrew Peters P000251 | rep | MA | 1913-04-07 | 1915-03-03 | Democrat | 11 | |||||||||||||
16530 | 16530 | John Peterson P000262 | rep | IN | 1913-04-07 | 1915-03-03 | Democrat | 10 | |||||||||||||
16535 | 16535 | James Post P000454 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
16538 | 16538 | Eugene Reed R000116 | rep | NH | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
16540 | 16540 | Thomas Reilly R000156 | rep | CT | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16548 | 16548 | William Richardson R000227 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
16551 | 16551 | Seaborn Roddenbery R000370 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16555 | 16555 | John Rothermel R000461 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 13 | |||||||||||||
16558 | 16558 | Harry Seldomridge S000234 | rep | CO | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16567 | 16567 | William Sharp S000296 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 14 | |||||||||||||
16568 | 16568 | Frank Smith S000535 | rep | MD | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
16595 | 16595 | Raymond Stevens S000885 | rep | NH | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16596 | 16596 | Lawrence Stringer S001005 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
16599 | 16599 | Timothy Sullivan S001061 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 13 | |||||||||||||
16601 | 16601 | Charles Talcott T000023 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 33 | |||||||||||||
16602 | 16602 | Benjamin Taylor T000066 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 25 | |||||||||||||
16611 | 16611 | George Taylor T000078 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
16612 | 16612 | Thomas Thacher T000140 | rep | MA | 1913-04-07 | 1915-03-03 | Democrat | 16 | |||||||||||||
16620 | 16620 | Edward Townsend T000332 | rep | NJ | 1913-04-07 | 1915-03-03 | Democrat | 10 | |||||||||||||
16622 | 16622 | William Tuttle T000439 | rep | NJ | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
16624 | 16624 | Edwin Underhill U000007 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 37 | |||||||||||||
16626 | 16626 | Horace Vaughan V000075 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
16627 | 16627 | Henry Vollmer V000113 | rep | IA | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16629 | 16629 | Allan Walsh W000095 | rep | NJ | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
16630 | 16630 | Claude Weaver W000224 | rep | OK | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
16638 | 16638 | John Whitacre W000347 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 18 | |||||||||||||
16645 | 16645 | Frank Wilson W000580 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 3 |
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);