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 state descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18370 | 18370 | Franklin Mondell M000852 | rep | WY | 1919-05-19 | 1921-03-03 | Republican | 0 | |||||||||||||
19155 | 19155 | Francis Warren W000164 | sen | WY | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
17657 | 17657 | Davis Elkins E000109 | sen | WV | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
18057 | 18057 | George Bowers B000690 | rep | WV | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
18158 | 18158 | Leonard Echols E000030 | rep | WV | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
18201 | 18201 | Wells Goodykoontz G000308 | rep | WV | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
18814 | 18814 | Stuart Reed R000127 | rep | WV | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
19173 | 19173 | Harry Woodyard W000737 | rep | WV | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
26066 | 26066 | Matthew Neely N000023 | rep | WV | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
17674 | 17674 | John Esch E000212 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
17833 | 17833 | James Monahan M000849 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
17899 | 17899 | Clifford Randall R000038 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
18123 | 18123 | David Classon C000474 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 9 | |||||||||||||
18289 | 18289 | John Kleczka K000260 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
18374 | 18374 | Adolphus Nelson N000029 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 11 | |||||||||||||
19142 | 19142 | Edward Voigt V000110 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
19208 | 19208 | Victor Berger B000407 | rep | WI | 1919-05-19 | 1921-03-03 | Socialist | -1 | |||||||||||||
19601 | 19601 | Edward Browne B000955 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
19840 | 19840 | Florian Lampert L000041 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
21273 | 21273 | James Frear F000355 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
18884 | 18884 | John Webster W000240 | rep | WA | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
19880 | 19880 | John Miller M000739 | rep | WA | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
20447 | 20447 | Lindley Hadley H000008 | rep | WA | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
20567 | 20567 | Albert Johnson J000114 | rep | WA | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
20901 | 20901 | John Summers S001067 | rep | WA | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
19282 | 19282 | Porter Dale D000009 | rep | VT | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
19737 | 19737 | Frank Greene G000425 | rep | VT | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
16475 | 16475 | Thomas Martin M000200 | sen | VA | 1919-05-19 | 1919-11-12 | 2 | Democrat | |||||||||||||
17610 | 17610 | Charles Carlin C000151 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | -1 | |||||||||||||
17780 | 17780 | Edward Holland H000716 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
17920 | 17920 | Edward Saunders S000077 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
17995 | 17995 | Walter Watson W000206 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
18176 | 18176 | Henry Flood F000210 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
18249 | 18249 | Rorer James J000052 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
18489 | 18489 | Campbell Slemp S000486 | rep | VA | 1919-05-19 | 1921-03-03 | Republican | 9 | |||||||||||||
18556 | 18556 | James Woods W000723 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
19344 | 19344 | Thomas Harrison H000277 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
19886 | 19886 | Robert Moore M000915 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
22319 | 22319 | Andrew Montague M000861 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
24354 | 24354 | Patrick Drewry D000496 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
24743 | 24743 | Schuyler Bland B000545 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
17827 | 17827 | James Mays M000290 | rep | UT | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
18006 | 18006 | Milton Welling W000278 | rep | UT | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
17559 | 17559 | Carlos Bee B000303 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 14 | |||||||||||||
18014 | 18014 | James Wilson W000593 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 12 | |||||||||||||
18030 | 18030 | James Young Y000040 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
18213 | 18213 | Rufus Hardy H000198 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
18413 | 18413 | Lucian Parrish P000083 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 13 | |||||||||||||
19216 | 19216 | Eugene Black B000495 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
19588 | 19588 | John Box B000710 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
19778 | 19778 | Claude Hudspeth H000910 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 16 | |||||||||||||
21142 | 21142 | Clay Briggs B000826 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
21289 | 21289 | John Garner G000074 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 15 | |||||||||||||
21644 | 21644 | Thomas Blanton B000549 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 17 | |||||||||||||
21755 | 21755 | Joe Eagle E000003 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
22065 | 22065 | James Buchanan B001006 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
22410 | 22410 | Morris Sheppard S000337 | sen | TX | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
22638 | 22638 | John Jones J000236 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 18 | |||||||||||||
23946 | 23946 | Fritz Lanham L000076 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 12 | |||||||||||||
24116 | 24116 | Hatton Sumners S001072 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
24314 | 24314 | Thomas Connally C000684 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 11 | |||||||||||||
24578 | 24578 | Joseph Mansfield M000112 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
27437 | 27437 | Samuel Rayburn R000082 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
17845 | 17845 | John Moon M000884 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
17930 | 17930 | Sam Sells S000235 | rep | TN | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
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 | |||||||||||||
18399 | 18399 | Lemuel Padgett P000012 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
19326 | 19326 | Finis Garrett G000082 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
19704 | 19704 | Hubert Fisher F000149 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
20285 | 20285 | Ewin Davis D000098 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
20545 | 20545 | Cordell Hull H000940 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
21675 | 21675 | Joseph Byrns B001217 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
22805 | 22805 | James Taylor T000083 | rep | TN | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
17712 | 17712 | Harry Gandy G000037 | rep | SD | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
17969 | 17969 | Thomas Sterling S000872 | sen | SD | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
20187 | 20187 | Charles Christopherson C000384 | rep | SD | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
20577 | 20577 | Royal Johnson J000173 | rep | SD | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
17644 | 17644 | Nathaniel Dial D000298 | sen | SC | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
17817 | 17817 | Asbury Lever L000259 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
17824 | 17824 | Edward Mann M000101 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
17871 | 17871 | Samuel Nicholls N000088 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
17893 | 17893 | James Ragsdale R000010 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
18012 | 18012 | Richard Whaley W000319 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
18508 | 18508 | Philip Stoll S000951 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
20301 | 20301 | Frederick Dominick D000408 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
20883 | 20883 | William Stevenson S000895 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
22081 | 22081 | James Byrnes B001215 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
17629 | 17629 | LeBaron Colt C000651 | sen | RI | 1919-05-19 | 1924-08-18 | 2 | Republican | |||||||||||||
18275 | 18275 | Ambrose Kennedy K000100 | rep | RI | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18506 | 18506 | Walter Stiness S000927 | rep | RI | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
20137 | 20137 | Clark Burdick B001075 | rep | RI | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
20331 | 20331 | Félix Dávila D000090 | rep | PR | 1919-05-19 | 1921-03-03 | Unionist | 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 | ||||||||||||||
17632 | 17632 | Peter Costello C000796 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
17643 | 17643 | Arthur Dewalt D000288 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 13 | |||||||||||||
17690 | 17690 | John Farr F000029 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
17719 | 17719 | Mahlon Garland G000068 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | -1 |
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);