legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
506 rows where "end" is on date 1919-03-03 sorted by party descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20330 | 20330 | Félix Dávila D000090 | rep | PR | 1917-04-02 | 1919-03-03 | Unionist | 0 | |||||||||||||
18314 | 18314 | Meyer London L000408 | rep | NY | 1917-04-02 | 1919-03-03 | Socialist | 12 | |||||||||||||
16377 | 16377 | Nathan Goff G000255 | sen | WV | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
16585 | 16585 | William Smith S000629 | sen | MI | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
16636 | 16636 | John Weeks W000246 | sen | MA | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
16695 | 16695 | James Brady B000753 | sen | ID | 1915-12-06 | 1919-03-03 | 3 | Republican | |||||||||||||
16762 | 16762 | Jacob Gallinger G000023 | sen | NH | 1915-12-06 | 1919-03-03 | 3 | Republican | |||||||||||||
17059 | 17059 | Richard Austin A000341 | rep | TN | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
17060 | 17060 | Mark Bacon B000018 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
17074 | 17074 | William Birch B000476 | rep | NJ | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
17075 | 17075 | Orrin Bleakley B000552 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 28 | |||||||||||||
17082 | 17082 | James Britt B000846 | rep | NC | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
17095 | 17095 | John Capstick C000136 | rep | NJ | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
17097 | 17097 | William Carter C000205 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 13 | |||||||||||||
17103 | 17103 | William Cary C000218 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
17104 | 17104 | Henry Clark C000433 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 25 | |||||||||||||
17108 | 17108 | Daniel Comstock C000663 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
17118 | 17118 | Edward Cooper C000748 | rep | WV | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
17140 | 17140 | James Davidson D000084 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
17152 | 17152 | Charles Dillon D000348 | rep | SD | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17165 | 17165 | Dow Drukker D000505 | rep | NJ | 1917-04-02 | 1919-03-03 | Republican | 7 | |||||||||||||
17166 | 17166 | Frederick Essen E000219 | rep | MO | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
17172 | 17172 | George Fairchild F000005 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 34 | |||||||||||||
17205 | 17205 | George Foss F000295 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
17213 | 17213 | George Francis F000335 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 18 | |||||||||||||
17223 | 17223 | Augustus Gardner G000050 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
17228 | 17228 | Edward Gray G000393 | rep | NJ | 1917-04-02 | 1919-03-03 | Republican | 8 | |||||||||||||
17244 | 17244 | Charles Hamilton H000104 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 43 | |||||||||||||
17258 | 17258 | Everis Hayes H000389 | rep | CA | 1917-04-02 | 1919-03-03 | Republican | 8 | |||||||||||||
17260 | 17260 | Robert Heaton H000433 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 12 | |||||||||||||
17261 | 17261 | Victor Heintz H000455 | rep | OH | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
17265 | 17265 | Henry Helgesen H000459 | rep | ND | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17283 | 17283 | Ebenezer Hill H000591 | rep | CT | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
17293 | 17293 | David Hollingsworth H000726 | rep | OH | 1917-04-02 | 1919-03-03 | Republican | 18 | |||||||||||||
17337 | 17337 | William La Follette L000006 | rep | WA | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
17354 | 17354 | Jacob Meeker M000629 | rep | MO | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
17359 | 17359 | Clarence Miller M000717 | rep | MN | 1917-04-02 | 1919-03-03 | Republican | 8 | |||||||||||||
17365 | 17365 | Patrick Norton N000156 | rep | ND | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
17385 | 17385 | Caleb Powers P000487 | rep | KY | 1917-04-02 | 1919-03-03 | Republican | 11 | |||||||||||||
17387 | 17387 | Harry Pratt P000500 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 37 | |||||||||||||
17394 | 17394 | Edwin Roberts R000309 | rep | NV | 1917-04-02 | 1919-03-03 | Republican | 0 | |||||||||||||
17396 | 17396 | Charles Rowland R000480 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 21 | |||||||||||||
17404 | 17404 | George Scott S000170 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 11 | |||||||||||||
17406 | 17406 | John Scott S000180 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
17456 | 17456 | John Sterling S000870 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 17 | |||||||||||||
17467 | 17467 | Cyrus Sulloway S001063 | rep | NH | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17472 | 17472 | Oscar Swift S001118 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 9 | |||||||||||||
17476 | 17476 | Robert Switzer S001124 | rep | OH | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
17489 | 17489 | Thomas Templeton T000121 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 11 | |||||||||||||
17496 | 17496 | William Waldow W000039 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 42 | |||||||||||||
17519 | 17519 | Frank Woods W000721 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
17520 | 17520 | David Baird B000052 | sen | NJ | 1918-02-23 | 1919-03-03 | 2 | Republican | appointment | ||||||||||||
17522 | 17522 | Irving Drew D000495 | sen | NH | 1918-09-02 | 1919-03-03 | 3 | Republican | appointment | ||||||||||||
17528 | 17528 | Frederick Mulkey M001069 | sen | OR | 1918-01-01 | 1919-03-03 | 2 | Republican | |||||||||||||
17541 | 17541 | John Baer B000027 | rep | ND | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17574 | 17574 | William Browning B000961 | rep | NJ | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17628 | 17628 | LeBaron Colt C000651 | sen | RI | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
17631 | 17631 | Peter Costello C000796 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
17633 | 17633 | Gilbert Currie C000998 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
17659 | 17659 | Franklin Ellsworth E000145 | rep | MN | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
17662 | 17662 | Henry Emerson E000171 | rep | OH | 1917-04-02 | 1919-03-03 | Republican | 22 | |||||||||||||
17673 | 17673 | John Esch E000212 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 7 | |||||||||||||
17684 | 17684 | Albert Fall F000011 | sen | NM | 1913-03-04 | 1919-03-03 | 2 | Republican | |||||||||||||
17689 | 17689 | John Farr F000029 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
17718 | 17718 | Mahlon Garland G000068 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
17735 | 17735 | Louis Goodall G000276 | rep | ME | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17760 | 17760 | Edward Hamilton H000108 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
17763 | 17763 | Reuben Haskell H000319 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
17788 | 17788 | Niels Juul J000282 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 7 | |||||||||||||
17795 | 17795 | Charles Kennedy K000104 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17798 | 17798 | William Kenyon K000129 | sen | IA | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
17828 | 17828 | Joseph McCormick M000369 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
17852 | 17852 | Joseph Moore M000906 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
17858 | 17858 | Dick Morgan M000947 | rep | OK | 1917-04-02 | 1919-03-03 | Republican | 8 | |||||||||||||
17866 | 17866 | Knute Nelson N000040 | sen | MN | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
17873 | 17873 | Charles Nichols N000090 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 13 | |||||||||||||
17888 | 17888 | Edmund Platt P000379 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 26 | |||||||||||||
17894 | 17894 | John Ramsey R000027 | rep | NJ | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
17906 | 17906 | Frederick Rowe R000476 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
17911 | 17911 | Rollin Sanford S000053 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 28 | |||||||||||||
17929 | 17929 | Sam Sells S000235 | rep | TN | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17968 | 17968 | Thomas Sterling S000872 | sen | SD | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
18022 | 18022 | William Wilson W000624 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
18051 | 18051 | Oscar Bland B000542 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
18056 | 18056 | George Bowers B000690 | rep | WV | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
18076 | 18076 | Sherman Burroughs B001138 | rep | NH | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
18090 | 18090 | Philip Campbell C000097 | rep | KS | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
18113 | 18113 | Joseph Cannon C000121 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 18 | |||||||||||||
18116 | 18116 | Thomas Chandler C000295 | rep | OK | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
18120 | 18120 | Walter Chandler C000297 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 19 | |||||||||||||
18122 | 18122 | David Classon C000474 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 9 | |||||||||||||
18131 | 18131 | Ira Copley C000770 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 11 | |||||||||||||
18137 | 18137 | Thomas Crago C000853 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
18155 | 18155 | Thomas Dunn D000553 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 38 | |||||||||||||
18161 | 18161 | John Elston E000161 | rep | CA | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
18187 | 18187 | Joseph Fordney F000271 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 8 | |||||||||||||
18198 | 18198 | James Good G000275 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
18204 | 18204 | Norman Gould G000342 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 36 | |||||||||||||
18222 | 18222 | Frederick Hicks H000564 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
18233 | 18233 | James Husted H001005 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 25 |
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);