legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
481 rows where "start" is on date 1915-12-06 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19817 | 19817 | Edgar Kiess K000168 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 15 | |||||||||||||
19802 | 19802 | Charles Kearns K000033 | rep | OH | 1915-12-06 | 1917-03-03 | Republican | 6 | |||||||||||||
19744 | 19744 | William Griest G000456 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 9 | |||||||||||||
19735 | 19735 | Frank Greene G000425 | rep | VT | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
19725 | 19725 | James Glynn G000246 | rep | CT | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
19697 | 19697 | Simeon Fess F000096 | rep | OH | 1915-12-06 | 1917-03-03 | Republican | 7 | |||||||||||||
19665 | 19665 | Clarence Dill D000345 | rep | WA | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
19657 | 19657 | Edward Denison D000237 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 25 | |||||||||||||
19649 | 19649 | Stephen Dempsey D000229 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 40 | |||||||||||||
19638 | 19638 | Charles Curry C001000 | rep | CA | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
19629 | 19629 | Louis Cramton C000870 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 7 | |||||||||||||
19617 | 19617 | John Casey C000223 | rep | PA | 1915-12-06 | 1917-03-03 | Democrat | 11 | |||||||||||||
19608 | 19608 | John Carew C000142 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 17 | |||||||||||||
19599 | 19599 | Edward Browne B000955 | rep | WI | 1915-12-06 | 1917-03-03 | Republican | 8 | |||||||||||||
19579 | 19579 | Thomas Bell B000348 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
19520 | 19520 | William Vare V000071 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
19504 | 19504 | John Tillman T000276 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
19490 | 19490 | Reed Smoot S000644 | sen | UT | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
19481 | 19481 | Nicholas Sinnott S000450 | rep | OR | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
19472 | 19472 | Thomas Rubey R000491 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 16 | |||||||||||||
19457 | 19457 | Lee Overman O000140 | sen | NC | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
19448 | 19448 | William Oldfield O000062 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
19429 | 19429 | John Morin M000961 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 31 | |||||||||||||
19418 | 19418 | Walter Magee M000049 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 35 | |||||||||||||
19411 | 19411 | Martin Madden M000038 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
19386 | 19386 | Ladislas Lazaro L000153 | rep | LA | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
19378 | 19378 | Edward King K000200 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 15 | |||||||||||||
19368 | 19368 | Wesley Jones J000257 | sen | WA | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
19342 | 19342 | Thomas Harrison H000277 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
19335 | 19335 | William Green G000422 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 9 | |||||||||||||
19324 | 19324 | Finis Garrett G000082 | rep | TN | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
19309 | 19309 | James Gallivan G000024 | rep | MA | 1915-12-06 | 1917-03-03 | Democrat | 12 | |||||||||||||
19280 | 19280 | Porter Dale D000009 | rep | VT | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
19277 | 19277 | Charles Curtis C001008 | sen | KS | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
19257 | 19257 | Thaddeus Caraway C000139 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
19249 | 19249 | Thomas Butler B001192 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 7 | |||||||||||||
19214 | 19214 | Eugene Black B000495 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
19191 | 19191 | Daniel Anthony A000261 | rep | KS | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
19171 | 19171 | Harry Woodyard W000737 | rep | WV | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
19159 | 19159 | Loren Wheeler W000339 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 21 | |||||||||||||
19125 | 19125 | Robert Thomas T000185 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
19097 | 19097 | Frank Scott S000169 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 11 | |||||||||||||
19090 | 19090 | Arthur Rouse R000466 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
19082 | 19082 | John Rogers R000400 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
19065 | 19065 | John Raker R000019 | rep | CA | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
19025 | 19025 | Gordon Lee L000194 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
19014 | 19014 | John Langley L000072 | rep | KY | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
18999 | 18999 | Ben Johnson J000118 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
18985 | 18985 | James Heflin H000446 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
18970 | 18970 | Frederick Gillett G000201 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
18950 | 18950 | Charles Fuller F000407 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 12 | |||||||||||||
18920 | 18920 | Charles Carter C000196 | rep | OK | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
18902 | 18902 | George Young Y000036 | rep | ND | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
18895 | 18895 | James Wise W000650 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
18890 | 18890 | Samuel Winslow W000639 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
18876 | 18876 | Charles Ward W000129 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 27 | |||||||||||||
18869 | 18869 | Horace Towner T000325 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 8 | |||||||||||||
18862 | 18862 | Peter Tague T000014 | rep | MA | 1915-12-06 | 1917-03-03 | Democrat | 10 | |||||||||||||
18856 | 18856 | Homer Snyder S000666 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 33 | |||||||||||||
18851 | 18851 | John Smith S000573 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
18844 | 18844 | Isaac Sherwood S000355 | rep | OH | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
18824 | 18824 | Daniel Riordan R000264 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 11 | |||||||||||||
18800 | 18800 | Frank Park P000051 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
18794 | 18794 | Calvin Paige P000024 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
18779 | 18779 | Sydney Mudd M001060 | rep | MD | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
18774 | 18774 | Luther Mott M001041 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 32 | |||||||||||||
18766 | 18766 | Merrill Moores M000928 | rep | IN | 1915-12-06 | 1917-03-03 | Republican | 7 | |||||||||||||
18751 | 18751 | John McKenzie M000506 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 13 | |||||||||||||
18715 | 18715 | Claude Kitchin K000250 | rep | NC | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
18703 | 18703 | Julius Kahn K000003 | rep | CA | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
18687 | 18687 | Benjamin Humphreys H000960 | rep | MS | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
18676 | 18676 | Harry Hull H000941 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
18669 | 18669 | William Greene G000430 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 15 | |||||||||||||
18643 | 18643 | William Fields F000113 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
18627 | 18627 | John Eagan E000001 | rep | NJ | 1915-12-06 | 1917-03-03 | Democrat | 11 | |||||||||||||
18621 | 18621 | Henry Dupré D000561 | rep | LA | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
18613 | 18613 | Charles Davis D000093 | rep | MN | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
18588 | 18588 | Frank Clark C000430 | rep | FL | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
18578 | 18578 | James Cantrill C000126 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
18566 | 18566 | Sydney Anderson A000233 | rep | MN | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
18548 | 18548 | Joseph Walsh W000101 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 16 | |||||||||||||
18544 | 18544 | Andrew Volstead V000114 | rep | MN | 1915-12-06 | 1917-03-03 | Republican | 7 | |||||||||||||
18534 | 18534 | Oscar Underwood U000013 | sen | AL | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
18517 | 18517 | Samuel Taylor T000100 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
18510 | 18510 | Burton Sweet S001106 | rep | IA | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
18504 | 18504 | Walter Stiness S000927 | rep | RI | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
18500 | 18500 | Halvor Steenerson S000842 | rep | MN | 1915-12-06 | 1917-03-03 | Republican | 9 | |||||||||||||
18487 | 18487 | Campbell Slemp S000486 | rep | VA | 1915-12-06 | 1917-03-03 | Republican | 9 | |||||||||||||
18479 | 18479 | Thomas Sisson S000456 | rep | MS | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
18472 | 18472 | Isaac Siegel S000404 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 20 | |||||||||||||
18464 | 18464 | William Rucker R000494 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
18448 | 18448 | William Rodenberg R000371 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 22 | |||||||||||||
18436 | 18436 | Edwin Ricketts R000236 | rep | OH | 1915-12-06 | 1917-03-03 | Republican | 11 | |||||||||||||
18427 | 18427 | Charles Reavis R000101 | rep | NE | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
18417 | 18417 | John Peters P000253 | rep | ME | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
18410 | 18410 | Richard Parker P000070 | rep | NJ | 1915-12-06 | 1917-03-03 | Republican | 9 | |||||||||||||
18397 | 18397 | Lemuel Padgett P000012 | rep | TN | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
18378 | 18378 | John Nolan N000124 | rep | CA | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
18368 | 18368 | Franklin Mondell M000852 | rep | WY | 1915-12-06 | 1917-03-03 | Republican | 0 | |||||||||||||
18350 | 18350 | William McKinley M000521 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 19 |
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);