legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
498 rows where "end" is on date 1923-03-03
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18340 | 18340 | William Mason M000228 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | -1 | |||||||||||||
18344 | 18344 | Clifton McArthur M000298 | rep | OR | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18345 | 18345 | Washington McCormick M000373 | rep | MT | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18355 | 18355 | Joseph McLaughlin M000540 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | -1 | |||||||||||||
18357 | 18357 | Isaac McPherson M000592 | rep | MO | 1921-04-11 | 1923-03-03 | Republican | 15 | |||||||||||||
18358 | 18358 | Frank Millspaugh M000781 | rep | MO | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18371 | 18371 | Franklin Mondell M000852 | rep | WY | 1921-04-11 | 1923-03-03 | Republican | 0 | |||||||||||||
18372 | 18372 | Néstor Montoya M000877 | rep | NM | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18375 | 18375 | Adolphus Nelson N000029 | rep | WI | 1921-04-11 | 1923-03-03 | Republican | 11 | |||||||||||||
18381 | 18381 | John Nolan N000124 | rep | CA | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
18382 | 18382 | Miner Norton N000154 | rep | OH | 1921-04-11 | 1923-03-03 | Republican | 20 | |||||||||||||
18384 | 18384 | Charles Ogden O000042 | rep | KY | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
18385 | 18385 | Archibald Olpp O000082 | rep | NJ | 1921-04-11 | 1923-03-03 | Republican | 11 | |||||||||||||
18389 | 18389 | James Overstreet O000143 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
18400 | 18400 | Lemuel Padgett P000012 | rep | TN | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
18412 | 18412 | Richard Parker P000070 | rep | NJ | 1921-04-11 | 1923-03-03 | Republican | 9 | |||||||||||||
18414 | 18414 | Lucian Parrish P000083 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 13 | |||||||||||||
18415 | 18415 | John Paul P000143 | rep | VA | 1921-04-11 | 1923-03-03 | Republican | 7 | |||||||||||||
18420 | 18420 | John Peters P000253 | rep | ME | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18421 | 18421 | Andrew Petersen P000257 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 9 | |||||||||||||
18422 | 18422 | Joseph Pringey P000542 | rep | OK | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
18424 | 18424 | Amos Radcliffe R000005 | rep | NJ | 1921-04-11 | 1923-03-03 | Republican | 7 | |||||||||||||
18426 | 18426 | Lilius Rainey R000017 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
18430 | 18430 | Charles Reavis R000101 | rep | NE | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18432 | 18432 | John Reber R000102 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 12 | |||||||||||||
18435 | 18435 | Marion Rhodes R000190 | rep | MO | 1921-04-11 | 1923-03-03 | Republican | 13 | |||||||||||||
18438 | 18438 | Edwin Ricketts R000236 | rep | OH | 1921-04-11 | 1923-03-03 | Republican | 11 | |||||||||||||
18440 | 18440 | Carl Riddick R000237 | rep | MT | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18441 | 18441 | Alice Robertson R000318 | rep | OK | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18451 | 18451 | William Rodenberg R000371 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 22 | |||||||||||||
18454 | 18454 | John Rose R000437 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 19 | |||||||||||||
18455 | 18455 | Albert Rossdale R000457 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 23 | |||||||||||||
18467 | 18467 | William Rucker R000494 | rep | MO | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
18468 | 18468 | Thomas Ryan R000560 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 15 | |||||||||||||
18469 | 18469 | Lon Scott S000181 | rep | TN | 1921-04-11 | 1923-03-03 | Republican | 8 | |||||||||||||
18470 | 18470 | Guy Shaw S000306 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 20 | |||||||||||||
18471 | 18471 | Samuel Shelton S000328 | rep | MO | 1921-04-11 | 1923-03-03 | Republican | 16 | |||||||||||||
18475 | 18475 | Isaac Siegel S000404 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 20 | |||||||||||||
18482 | 18482 | Thomas Sisson S000456 | rep | MS | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
18490 | 18490 | Campbell Slemp S000486 | rep | VA | 1921-04-11 | 1923-03-03 | Republican | 9 | |||||||||||||
18503 | 18503 | Halvor Steenerson S000842 | rep | MN | 1921-04-11 | 1923-03-03 | Republican | 9 | |||||||||||||
18507 | 18507 | Walter Stiness S000927 | rep | RI | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18509 | 18509 | Philip Stoll S000951 | rep | SC | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
18513 | 18513 | Burton Sweet S001106 | rep | IA | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18514 | 18514 | Chester Taylor T000069 | rep | AR | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
18520 | 18520 | Samuel Taylor T000100 | rep | AR | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
18522 | 18522 | Peter Ten Eyck T000126 | rep | NY | 1921-04-11 | 1923-03-03 | Democrat | 28 | |||||||||||||
18523 | 18523 | Roy Thorpe T000245 | rep | NE | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18537 | 18537 | Lester Volk V000111 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 10 | |||||||||||||
18547 | 18547 | Andrew Volstead V000114 | rep | MN | 1921-04-11 | 1923-03-03 | Republican | 7 | |||||||||||||
18551 | 18551 | Joseph Walsh W000101 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 16 | |||||||||||||
18553 | 18553 | Thomas Watson W000205 | sen | GA | 1921-04-11 | 1923-03-03 | 3 | Democrat | |||||||||||||
18557 | 18557 | James Woods W000723 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
18558 | 18558 | Thomas Bayard B000252 | sen | DE | 1922-11-08 | 1923-03-03 | 1 | Democrat | |||||||||||||
18560 | 18560 | Rebecca Felton F000069 | sen | GA | 1922-10-03 | 1923-03-03 | 3 | Democrat | appointment | ||||||||||||
18562 | 18562 | Charles Rawson R000075 | sen | IA | 1922-02-24 | 1923-03-03 | 2 | Republican | appointment | ||||||||||||
18569 | 18569 | Sydney Anderson A000233 | rep | MN | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18581 | 18581 | James Cantrill C000126 | rep | KY | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
18591 | 18591 | Frank Clark C000430 | rep | FL | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
18599 | 18599 | William Cockran C000575 | rep | NY | 1921-04-11 | 1923-03-03 | Democrat | 16 | |||||||||||||
18602 | 18602 | Raymond Cole C000613 | rep | OH | 1921-04-11 | 1923-03-03 | Republican | 8 | |||||||||||||
18616 | 18616 | Charles Davis D000093 | rep | MN | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18624 | 18624 | Henry Dupré D000561 | rep | LA | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
18635 | 18635 | Louis Fairfield F000007 | rep | IN | 1921-04-11 | 1923-03-03 | Republican | 12 | |||||||||||||
18638 | 18638 | George Favrot F000048 | rep | LA | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
18646 | 18646 | William Fields F000113 | rep | KY | 1921-04-11 | 1923-03-03 | Democrat | 9 | |||||||||||||
18650 | 18650 | Israel Foster F000306 | rep | OH | 1921-04-11 | 1923-03-03 | Republican | 10 | |||||||||||||
18658 | 18658 | William Graham G000364 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 14 | |||||||||||||
18672 | 18672 | William Greene G000430 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 15 | |||||||||||||
18674 | 18674 | James Hooker H000759 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
18679 | 18679 | Harry Hull H000941 | rep | IA | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18690 | 18690 | Benjamin Humphreys H000960 | rep | MS | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
18693 | 18693 | Andrieus Jones J000210 | sen | NM | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
18706 | 18706 | Julius Kahn K000003 | rep | CA | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
18718 | 18718 | Claude Kitchin K000250 | rep | NC | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
18725 | 18725 | Robert La Follette L000004 | sen | WI | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
18727 | 18727 | Oscar Larson L000104 | rep | MN | 1921-04-11 | 1923-03-03 | Republican | 8 | |||||||||||||
18733 | 18733 | Edward Little L000349 | rep | KS | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18742 | 18742 | Henry Lodge L000393 | sen | MA | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
18744 | 18744 | William Logan L000406 | rep | SC | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
18746 | 18746 | James MacLafferty M000028 | rep | CA | 1921-04-11 | 1923-03-03 | Republican | 6 | |||||||||||||
18754 | 18754 | John McKenzie M000506 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 13 | |||||||||||||
18757 | 18757 | George McLean M000547 | sen | CT | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
18763 | 18763 | Allen Moore M000890 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 19 | |||||||||||||
18769 | 18769 | Merrill Moores M000928 | rep | IN | 1921-04-11 | 1923-03-03 | Republican | 7 | |||||||||||||
18777 | 18777 | Luther Mott M001041 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 32 | |||||||||||||
18782 | 18782 | Sydney Mudd M001060 | rep | MD | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
18784 | 18784 | Mae Nolan N000125 | rep | CA | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
18786 | 18786 | Charles O’Brien O000008 | rep | NJ | 1921-04-11 | 1923-03-03 | Democrat | 12 | |||||||||||||
18791 | 18791 | Henry Osborne O000112 | rep | CA | 1921-04-11 | 1923-03-03 | Republican | 10 | |||||||||||||
18797 | 18797 | Calvin Paige P000024 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18803 | 18803 | Frank Park P000051 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
18807 | 18807 | John Rainey R000015 | rep | IL | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
18811 | 18811 | James Reed R000118 | sen | MO | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
18815 | 18815 | Stuart Reed R000127 | rep | WV | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18827 | 18827 | Daniel Riordan R000264 | rep | NY | 1921-04-11 | 1923-03-03 | Democrat | 11 | |||||||||||||
18829 | 18829 | Sidney Roach R000289 | rep | MO | 1921-04-11 | 1923-03-03 | Republican | 8 | |||||||||||||
18831 | 18831 | Benjamin Rosenbloom R000441 | rep | WV | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18836 | 18836 | Everett Sanders S000034 | rep | IN | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
18854 | 18854 | John Smith S000573 | rep | MI | 1921-04-11 | 1923-03-03 | Republican | 3 |
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);