legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
498 rows where "start" is on date 1919-05-19 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: type
end (date) 9 ✖
- 1921-03-03 466
- 1925-03-03 25
- 1919-11-12 1
- 1920-11-01 1
- 1921-03-04 1
- 1922-11-18 1
- 1923-03-03 1
- 1923-12-31 1
- 1924-08-18 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17742 | 17742 | George Grigsby G000474 | rep | AK | 1919-05-19 | 1921-03-03 | 0 | ||||||||||||||
17971 | 17971 | Charles Sulzer S001064 | rep | AK | 1919-05-19 | 1921-03-03 | 0 | ||||||||||||||
18025 | 18025 | Teodoro Yangco Y000004 | rep | PI | 1919-05-19 | 1921-03-03 | 0 | ||||||||||||||
18146 | 18146 | Jaime De Veyra D000276 | rep | PI | 1919-05-19 | 1921-03-03 | 0 | ||||||||||||||
19718 | 19718 | Isauro Gabaldon G000001 | rep | PI | 1919-05-19 | 1921-03-03 | 0 | ||||||||||||||
16475 | 16475 | Thomas Martin M000200 | sen | VA | 1919-05-19 | 1919-11-12 | 2 | Democrat | |||||||||||||
17538 | 17538 | Joshua Alexander A000098 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
17540 | 17540 | John Babka B000007 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 21 | |||||||||||||
17558 | 17558 | John Bankhead B000110 | sen | AL | 1919-05-19 | 1921-03-03 | 2 | Democrat | |||||||||||||
17559 | 17559 | Carlos Bee B000303 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 14 | |||||||||||||
17561 | 17561 | Carville Benson B000387 | rep | MD | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
17562 | 17562 | William Bland B000547 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
17570 | 17570 | Charles Booher B000626 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
17579 | 17579 | Clement Brumbaugh B000975 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 12 | |||||||||||||
17590 | 17590 | John Burnett B001121 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
17593 | 17593 | Charles Caldwell C000030 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
17603 | 17603 | Ezekiel Candler C000110 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
17610 | 17610 | Charles Carlin C000151 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | -1 | |||||||||||||
17623 | 17623 | James Clark C000437 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
17627 | 17627 | Charles Coady C000541 | rep | MD | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
17640 | 17640 | Stanley Dent D000256 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
17643 | 17643 | Arthur Dewalt D000288 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 13 | |||||||||||||
17644 | 17644 | Nathaniel Dial D000298 | sen | SC | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
17697 | 17697 | Scott Ferris F000091 | rep | OK | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
17701 | 17701 | John Fitzgerald F000164 | rep | MA | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
17709 | 17709 | Thomas Gallagher G000018 | rep | IL | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
17712 | 17712 | Harry Gandy G000037 | rep | SD | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
17716 | 17716 | Warren Gard G000048 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
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 | |||||||||||||
17741 | 17741 | William Goodwin G000304 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
17749 | 17749 | James Hamill H000099 | rep | NJ | 1919-05-19 | 1921-03-03 | Democrat | 12 | |||||||||||||
17771 | 17771 | Harvey Helm H000461 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | -1 | |||||||||||||
17774 | 17774 | Hugh Hersman H000546 | rep | CA | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
17780 | 17780 | Edward Holland H000716 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
17786 | 17786 | William Igoe I000005 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 11 | |||||||||||||
17787 | 17787 | John Johnston J000190 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
17803 | 17803 | William Kettner K000155 | rep | CA | 1919-05-19 | 1921-03-03 | Democrat | 11 | |||||||||||||
17807 | 17807 | John Lesher L000250 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 16 | |||||||||||||
17817 | 17817 | Asbury Lever L000259 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
17823 | 17823 | James Maher M000063 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
17824 | 17824 | Edward Mann M000101 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
17827 | 17827 | James Mays M000290 | rep | UT | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
17830 | 17830 | Cornelius McGlennon M000450 | rep | NJ | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
17831 | 17831 | Richard McKiniry M000517 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 23 | |||||||||||||
17832 | 17832 | Patrick McLane M000536 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
17845 | 17845 | John Moon M000884 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
17871 | 17871 | Samuel Nicholls N000088 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
17877 | 17877 | Richard Olney O000080 | rep | MA | 1919-05-19 | 1921-03-03 | Democrat | 14 | |||||||||||||
17880 | 17880 | Robert Owen O000153 | sen | OK | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
17881 | 17881 | Herbert Pell P000194 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 17 | |||||||||||||
17885 | 17885 | Michael Phelan P000291 | rep | MA | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
17893 | 17893 | James Ragsdale R000010 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
17903 | 17903 | Leonidas Robinson R000348 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
17904 | 17904 | Joseph Rowan R000472 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 19 | |||||||||||||
17909 | 17909 | Jared Sanders S000035 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
17920 | 17920 | Edward Saunders S000077 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
17925 | 17925 | Thomas Scully S000206 | rep | NJ | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
17932 | 17932 | John Shields S000363 | sen | TN | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
17944 | 17944 | Thetus Sims S000441 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
17955 | 17955 | John Small S000500 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
17957 | 17957 | Thomas Smith S000619 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 16 | |||||||||||||
17964 | 17964 | Augustus Stanley S000796 | sen | KY | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
17967 | 17967 | Henry Steele S000831 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 26 | |||||||||||||
17977 | 17977 | Joseph Thompson T000210 | rep | OK | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
17980 | 17980 | Carl Van Dyke V000034 | rep | MN | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
17983 | 17983 | William Venable V000086 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
17991 | 17991 | John Watkins W000193 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
17995 | 17995 | Walter Watson W000206 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
18004 | 18004 | Edwin Webb W000231 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
18006 | 18006 | Milton Welling W000278 | rep | UT | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
18008 | 18008 | Benjamin Welty W000291 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
18012 | 18012 | Richard Whaley W000319 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
18014 | 18014 | James Wilson W000593 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 12 | |||||||||||||
18015 | 18015 | John Wilson W000600 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 22 | |||||||||||||
18030 | 18030 | James Young Y000040 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
18047 | 18047 | Fred Blackmon B000514 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
18067 | 18067 | Samuel Brinson B000840 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
18176 | 18176 | Henry Flood F000210 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
18213 | 18213 | Rufus Hardy H000198 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
18247 | 18247 | Henderson Jacoway J000041 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
18249 | 18249 | Rorer James J000052 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
18253 | 18253 | Paul Johnson J000166 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
18388 | 18388 | James Overstreet O000143 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
18399 | 18399 | Lemuel Padgett P000012 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
18413 | 18413 | Lucian Parrish P000083 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 13 | |||||||||||||
18425 | 18425 | Lilius Rainey R000017 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
18466 | 18466 | William Rucker R000494 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
18481 | 18481 | Thomas Sisson S000456 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
18508 | 18508 | Philip Stoll S000951 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
18519 | 18519 | Samuel Taylor T000100 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
18556 | 18556 | James Woods W000723 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
18580 | 18580 | James Cantrill C000126 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
18590 | 18590 | Frank Clark C000430 | rep | FL | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
18623 | 18623 | Henry Dupré D000561 | rep | LA | 1919-05-19 | 1921-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);