legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
497 rows where "start" is on date 1913-04-07 sorted by rowid 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19190 | 19190 | Daniel Anthony A000261 | rep | KS | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
19154 | 19154 | Francis Warren W000164 | sen | WY | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
19146 | 19146 | Anderson Walters W000109 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | -1 | |||||||||||||
19124 | 19124 | Robert Thomas T000185 | rep | KY | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
19106 | 19106 | Furnifold Simmons S000415 | sen | NC | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
19089 | 19089 | Arthur Rouse R000466 | rep | KY | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
19081 | 19081 | John Rogers R000400 | rep | MA | 1913-04-07 | 1915-03-03 | Republican | 5 | |||||||||||||
19078 | 19078 | Joseph Ransdell R000059 | sen | LA | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
19064 | 19064 | John Raker R000019 | rep | CA | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
19024 | 19024 | Gordon Lee L000194 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
19013 | 19013 | John Langley L000072 | rep | KY | 1913-04-07 | 1915-03-03 | Republican | 10 | |||||||||||||
18998 | 18998 | Ben Johnson J000118 | rep | KY | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
18984 | 18984 | James Heflin H000446 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
18969 | 18969 | Frederick Gillett G000201 | rep | MA | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
18919 | 18919 | Charles Carter C000196 | rep | OK | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
18901 | 18901 | George Young Y000036 | rep | ND | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
18889 | 18889 | Samuel Winslow W000639 | rep | MA | 1913-04-07 | 1915-03-03 | Republican | 4 | |||||||||||||
18868 | 18868 | Horace Towner T000325 | rep | IA | 1913-04-07 | 1915-03-03 | Republican | 8 | |||||||||||||
18850 | 18850 | John Smith S000573 | rep | MI | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
18843 | 18843 | Isaac Sherwood S000355 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 9 | |||||||||||||
18823 | 18823 | Daniel Riordan R000264 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 11 | |||||||||||||
18799 | 18799 | Frank Park P000051 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
18793 | 18793 | Calvin Paige P000024 | rep | MA | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
18773 | 18773 | Luther Mott M001041 | rep | NY | 1913-04-07 | 1915-03-03 | Republican | 32 | |||||||||||||
18750 | 18750 | John McKenzie M000506 | rep | IL | 1913-04-07 | 1915-03-03 | Republican | 13 | |||||||||||||
18714 | 18714 | Claude Kitchin K000250 | rep | NC | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
18702 | 18702 | Julius Kahn K000003 | rep | CA | 1913-04-07 | 1915-03-03 | Republican | 4 | |||||||||||||
18686 | 18686 | Benjamin Humphreys H000960 | rep | MS | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
18668 | 18668 | William Greene G000430 | rep | MA | 1913-04-07 | 1915-03-03 | Republican | 15 | |||||||||||||
18642 | 18642 | William Fields F000113 | rep | KY | 1913-04-07 | 1915-03-03 | Democrat | 9 | |||||||||||||
18626 | 18626 | John Eagan E000001 | rep | NJ | 1913-04-07 | 1915-03-03 | Democrat | 11 | |||||||||||||
18620 | 18620 | Henry Dupré D000561 | rep | LA | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
18612 | 18612 | Charles Davis D000093 | rep | MN | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
18587 | 18587 | Frank Clark C000430 | rep | FL | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
18577 | 18577 | James Cantrill C000126 | rep | KY | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
18565 | 18565 | Sydney Anderson A000233 | rep | MN | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
18543 | 18543 | Andrew Volstead V000114 | rep | MN | 1913-04-07 | 1915-03-03 | Republican | 7 | |||||||||||||
18533 | 18533 | Oscar Underwood U000013 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 9 | |||||||||||||
18521 | 18521 | Peter Ten Eyck T000126 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 28 | |||||||||||||
18516 | 18516 | Samuel Taylor T000100 | rep | AR | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
18499 | 18499 | Halvor Steenerson S000842 | rep | MN | 1913-04-07 | 1915-03-03 | Republican | 9 | |||||||||||||
18486 | 18486 | Campbell Slemp S000486 | rep | VA | 1913-04-07 | 1915-03-03 | Republican | 9 | |||||||||||||
18478 | 18478 | Thomas Sisson S000456 | rep | MS | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
18463 | 18463 | William Rucker R000494 | rep | MO | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
18416 | 18416 | John Peters P000253 | rep | ME | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
18409 | 18409 | Richard Parker P000070 | rep | NJ | 1913-04-07 | 1915-03-03 | Republican | 9 | |||||||||||||
18396 | 18396 | Lemuel Padgett P000012 | rep | TN | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
18377 | 18377 | John Nolan N000124 | rep | CA | 1913-04-07 | 1915-03-03 | Republican | 5 | |||||||||||||
18367 | 18367 | Franklin Mondell M000852 | rep | WY | 1913-04-07 | 1915-03-03 | Republican | 0 | |||||||||||||
18330 | 18330 | James Mann M000104 | rep | IL | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
18309 | 18309 | Irvine Lenroot L000241 | rep | WI | 1913-04-07 | 1915-03-03 | Republican | 11 | |||||||||||||
18297 | 18297 | Aaron Kreider K000327 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 18 | |||||||||||||
18282 | 18282 | Moses Kinkaid K000221 | rep | NE | 1913-04-07 | 1915-03-03 | Republican | 6 | |||||||||||||
18272 | 18272 | Ambrose Kennedy K000100 | rep | RI | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
18267 | 18267 | Patrick Kelley K000061 | rep | MI | 1913-04-07 | 1915-03-03 | Republican | -1 | |||||||||||||
18262 | 18262 | Jonah Kalanianaole K000004 | rep | HI | 1913-04-07 | 1915-03-03 | Republican | -1 | |||||||||||||
18244 | 18244 | Henderson Jacoway J000041 | rep | AR | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
18210 | 18210 | Rufus Hardy H000198 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
18196 | 18196 | James Good G000275 | rep | IA | 1913-04-07 | 1915-03-03 | Republican | 5 | |||||||||||||
18185 | 18185 | Joseph Fordney F000271 | rep | MI | 1913-04-07 | 1915-03-03 | Republican | 8 | |||||||||||||
18173 | 18173 | Henry Flood F000210 | rep | VA | 1913-04-07 | 1915-03-03 | Democrat | 10 | |||||||||||||
18153 | 18153 | Thomas Dunn D000553 | rep | NY | 1913-04-07 | 1915-03-03 | Republican | 38 | |||||||||||||
18129 | 18129 | Ira Copley C000770 | rep | IL | 1913-04-07 | 1915-03-03 | Republican | 11 | |||||||||||||
18118 | 18118 | Walter Chandler C000297 | rep | NY | 1913-04-07 | 1915-03-03 | Progressive | 19 | |||||||||||||
18088 | 18088 | Philip Campbell C000097 | rep | KS | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
18044 | 18044 | Fred Blackmon B000514 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
18027 | 18027 | James Young Y000040 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
18009 | 18009 | Richard Whaley W000319 | rep | SC | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
18001 | 18001 | Edwin Webb W000231 | rep | NC | 1913-04-07 | 1915-03-03 | Democrat | 9 | |||||||||||||
17992 | 17992 | Walter Watson W000206 | rep | VA | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
17988 | 17988 | John Watkins W000193 | rep | LA | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
17974 | 17974 | Joseph Thompson T000210 | rep | OK | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
17968 | 17968 | Thomas Sterling S000872 | sen | SD | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
17963 | 17963 | Augustus Stanley S000796 | rep | KY | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
17952 | 17952 | John Small S000500 | rep | NC | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
17941 | 17941 | Thetus Sims S000441 | rep | TN | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
17931 | 17931 | John Shields S000363 | sen | TN | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
17927 | 17927 | Sam Sells S000235 | rep | TN | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
17922 | 17922 | Thomas Scully S000206 | rep | NJ | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
17917 | 17917 | Edward Saunders S000077 | rep | VA | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
17890 | 17890 | James Ragsdale R000010 | rep | SC | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
17886 | 17886 | Edmund Platt P000379 | rep | NY | 1913-04-07 | 1915-03-03 | Republican | 26 | |||||||||||||
17882 | 17882 | Michael Phelan P000291 | rep | MA | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
17879 | 17879 | Robert Owen O000153 | sen | OK | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
17866 | 17866 | Knute Nelson N000040 | sen | MN | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
17856 | 17856 | Dick Morgan M000947 | rep | OK | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
17850 | 17850 | Joseph Moore M000906 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
17842 | 17842 | John Moon M000884 | rep | TN | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
17820 | 17820 | James Maher M000063 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
17814 | 17814 | Asbury Lever L000259 | rep | SC | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
17804 | 17804 | John Lesher L000250 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 16 | |||||||||||||
17800 | 17800 | William Kettner K000155 | rep | CA | 1913-04-07 | 1915-03-03 | Democrat | 11 | |||||||||||||
17798 | 17798 | William Kenyon K000129 | sen | IA | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
17793 | 17793 | Charles Kennedy K000104 | rep | IA | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
17783 | 17783 | William Igoe I000005 | rep | MO | 1913-04-07 | 1915-03-03 | Democrat | 11 | |||||||||||||
17781 | 17781 | Willis Hulings H000939 | rep | PA | 1913-04-07 | 1915-03-03 | Progressive | 28 | |||||||||||||
17777 | 17777 | Edward Holland H000716 | rep | VA | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
17768 | 17768 | Harvey Helm H000461 | rep | KY | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
17758 | 17758 | Edward Hamilton H000108 | rep | MI | 1913-04-07 | 1915-03-03 | Republican | 4 | |||||||||||||
17746 | 17746 | James Hamill H000099 | rep | NJ | 1913-04-07 | 1915-03-03 | Democrat | 12 |
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);