legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
499 rows where "end" is on date 1921-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17643 | 17643 | Arthur Dewalt D000288 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 13 | |||||||||||||
21228 | 21228 | Clement Dickinson D000316 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
20293 | 20293 | Lester Dickinson D000323 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
18151 | 18151 | William Dillingham D000347 | sen | VT | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
20301 | 20301 | Frederick Dominick D000408 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
17646 | 17646 | Jerome Donovan D000423 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 21 | |||||||||||||
17650 | 17650 | Peter Dooling D000426 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 15 | |||||||||||||
17655 | 17655 | Frank Doremus D000431 | rep | MI | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
25217 | 25217 | Robert Doughton D000448 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
22573 | 22573 | Cassius Dowell D000468 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
20312 | 20312 | Herbert Drane D000486 | rep | FL | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
24354 | 24354 | Patrick Drewry D000496 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
19674 | 19674 | James Dunbar D000525 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18156 | 18156 | Thomas Dunn D000553 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 38 | |||||||||||||
18623 | 18623 | Henry Dupré D000561 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
20323 | 20323 | Leonidas Dyer D000591 | rep | MO | 1919-05-19 | 1921-03-03 | Republican | 12 | |||||||||||||
18629 | 18629 | John Eagan E000001 | rep | NJ | 1919-05-19 | 1921-03-03 | Democrat | 11 | |||||||||||||
21755 | 21755 | Joe Eagle E000003 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
18158 | 18158 | Leonard Echols E000030 | rep | WV | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
21246 | 21246 | George Edmonds E000053 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
19678 | 19678 | Richard Elliott E000127 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
17660 | 17660 | Franklin Ellsworth E000145 | rep | MN | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
18162 | 18162 | John Elston E000161 | rep | CA | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
17663 | 17663 | Henry Emerson E000171 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 22 | |||||||||||||
17674 | 17674 | John Esch E000212 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
17681 | 17681 | Albert Estopinal E000224 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
17682 | 17682 | Charles Evans E000234 | rep | NV | 1919-05-19 | 1921-03-03 | Democrat | 0 | |||||||||||||
20362 | 20362 | John Evans E000247 | rep | MT | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
18165 | 18165 | Robert Evans E000256 | rep | NE | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18634 | 18634 | Louis Fairfield F000007 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 12 | |||||||||||||
17690 | 17690 | John Farr F000029 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
17697 | 17697 | Scott Ferris F000091 | rep | OK | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
19699 | 19699 | Simeon Fess F000096 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
18645 | 18645 | William Fields F000113 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
23453 | 23453 | Hamilton Fish F000142 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 26 | |||||||||||||
19704 | 19704 | Hubert Fisher F000149 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
17701 | 17701 | John Fitzgerald F000164 | rep | MA | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
21260 | 21260 | Duncan Fletcher F000200 | sen | FL | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
18176 | 18176 | Henry Flood F000210 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
22148 | 22148 | Benjamin Focht F000230 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 17 | |||||||||||||
18188 | 18188 | Joseph Fordney F000271 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
18649 | 18649 | Israel Foster F000306 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
21273 | 21273 | James Frear F000355 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
20380 | 20380 | Richard Freeman F000366 | rep | CT | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
20393 | 20393 | Burton French F000375 | rep | ID | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17703 | 17703 | Alvan Fuller F000405 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 9 | |||||||||||||
18952 | 18952 | Charles Fuller F000407 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 12 | |||||||||||||
19718 | 19718 | Isauro Gabaldon G000001 | rep | PI | 1919-05-19 | 1921-03-03 | 0 | ||||||||||||||
17709 | 17709 | Thomas Gallagher G000018 | rep | IL | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
19311 | 19311 | James Gallivan G000024 | rep | MA | 1919-05-19 | 1921-03-03 | Democrat | 12 | |||||||||||||
17712 | 17712 | Harry Gandy G000037 | rep | SD | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
18652 | 18652 | James Ganly G000038 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 24 | |||||||||||||
17716 | 17716 | Warren Gard G000048 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
17719 | 17719 | Mahlon Garland G000068 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | -1 | |||||||||||||
21289 | 21289 | John Garner G000074 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 15 | |||||||||||||
19326 | 19326 | Finis Garrett G000082 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
17523 | 17523 | Edward Gay G000104 | sen | LA | 1918-01-01 | 1921-03-03 | 3 | Democrat | |||||||||||||
18972 | 18972 | Frederick Gillett G000201 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
19727 | 19727 | James Glynn G000246 | rep | CT | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
17726 | 17726 | Hannibal Godwin G000250 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
17734 | 17734 | Henry Goldfogle G000260 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 12 | |||||||||||||
18199 | 18199 | James Good G000275 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
17736 | 17736 | Louis Goodall G000276 | rep | ME | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17741 | 17741 | William Goodwin G000304 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
18201 | 18201 | Wells Goodykoontz G000308 | rep | WV | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
20432 | 20432 | Thomas Gore G000323 | sen | OK | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
18205 | 18205 | Norman Gould G000342 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 36 | |||||||||||||
20437 | 20437 | George Graham G000354 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
18657 | 18657 | William Graham G000364 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 14 | |||||||||||||
19337 | 19337 | William Green G000422 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 9 | |||||||||||||
19737 | 19737 | Frank Greene G000425 | rep | VT | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
18671 | 18671 | William Greene G000430 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 15 | |||||||||||||
19746 | 19746 | William Griest G000456 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 9 | |||||||||||||
21781 | 21781 | Anthony Griffin G000457 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 22 | |||||||||||||
17742 | 17742 | George Grigsby G000474 | rep | AK | 1919-05-19 | 1921-03-03 | 0 | ||||||||||||||
16773 | 16773 | Asle Gronna G000491 | sen | ND | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
20447 | 20447 | Lindley Hadley H000008 | rep | WA | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
17749 | 17749 | James Hamill H000099 | rep | NJ | 1919-05-19 | 1921-03-03 | Democrat | 12 | |||||||||||||
17761 | 17761 | Edward Hamilton H000108 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
18032 | 18032 | Warren Harding H000192 | sen | OH | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
20468 | 20468 | Guy Hardy H000195 | rep | CO | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18213 | 18213 | Rufus Hardy H000198 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
18215 | 18215 | John Harreld H000227 | rep | OK | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
19344 | 19344 | Thomas Harrison H000277 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
17764 | 17764 | Reuben Haskell H000319 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
21308 | 21308 | William Hastings H000333 | rep | OK | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
20490 | 20490 | Gilbert Haugen H000350 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
20503 | 20503 | Willis Hawley H000379 | rep | OR | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
27847 | 27847 | Carl Hayden H000385 | rep | AZ | 1919-05-19 | 1921-03-03 | Democrat | 0 | |||||||||||||
18217 | 18217 | Edward Hays H000403 | rep | MO | 1919-05-19 | 1921-03-03 | Republican | 14 | |||||||||||||
17771 | 17771 | Harvey Helm H000461 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | -1 | |||||||||||||
17525 | 17525 | Charles Henderson H000477 | sen | NV | 1918-01-12 | 1921-03-03 | 3 | Democrat | appointment | ||||||||||||
17773 | 17773 | Benigno Hernández H000532 | rep | NM | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
19351 | 19351 | Ira Hersey H000544 | rep | ME | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
17774 | 17774 | Hugh Hersman H000546 | rep | CA | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
19764 | 19764 | Andrew Hickey H000560 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 13 | |||||||||||||
18223 | 18223 | Frederick Hicks H000564 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17775 | 17775 | William Hill H000610 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 34 | |||||||||||||
20510 | 20510 | Homer Hoch H000669 | rep | KS | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
25327 | 25327 | Clyde Hoey H000679 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 9 |
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);