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 sorted by state
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18956 | 18956 | Frank Funk F000428 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 17 | |||||||||||||
18977 | 18977 | John Gorman G000329 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 6 | |||||||||||||
19162 | 19162 | Loren Wheeler W000339 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 21 | |||||||||||||
19381 | 19381 | Edward King K000200 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 15 | |||||||||||||
19414 | 19414 | Martin Madden M000038 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
19660 | 19660 | Edward Denison D000237 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 25 | |||||||||||||
19874 | 19874 | Magne Michaelson M000690 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 7 | |||||||||||||
19969 | 19969 | Elliott Sproul S000758 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
20045 | 20045 | Thomas Williams W000542 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 24 | |||||||||||||
20176 | 20176 | Carl Chindblom C000361 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 10 | |||||||||||||
20614 | 20614 | Stanley Kunz K000342 | rep | IL | 1921-04-11 | 1923-03-03 | Democrat | 8 | |||||||||||||
21052 | 21052 | Richard Yates Y000011 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | -1 | |||||||||||||
21154 | 21154 | Frederick Britten B000847 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 9 | |||||||||||||
25461 | 25461 | Adolph Sabath S000001 | rep | IL | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
17362 | 17362 | Harry New N000059 | sen | IN | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
18041 | 18041 | John Benham B000361 | rep | IN | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
18053 | 18053 | Oscar Bland B000542 | rep | IN | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18296 | 18296 | Milton Kraus K000323 | rep | IN | 1921-04-11 | 1923-03-03 | Republican | 11 | |||||||||||||
18320 | 18320 | Oscar Luhring L000505 | rep | IN | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18635 | 18635 | Louis Fairfield F000007 | rep | IN | 1921-04-11 | 1923-03-03 | Republican | 12 | |||||||||||||
18769 | 18769 | Merrill Moores M000928 | rep | IN | 1921-04-11 | 1923-03-03 | Republican | 7 | |||||||||||||
18836 | 18836 | Everett Sanders S000034 | rep | IN | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
19675 | 19675 | James Dunbar D000525 | rep | IN | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
19679 | 19679 | Richard Elliott E000127 | rep | IN | 1921-04-11 | 1923-03-03 | Republican | 6 | |||||||||||||
19765 | 19765 | Andrew Hickey H000560 | rep | IN | 1921-04-11 | 1923-03-03 | Republican | 13 | |||||||||||||
20782 | 20782 | Fred Purnell P000573 | rep | IN | 1921-04-11 | 1923-03-03 | Republican | 9 | |||||||||||||
20970 | 20970 | Albert Vestal V000092 | rep | IN | 1921-04-11 | 1923-03-03 | Republican | 8 | |||||||||||||
21025 | 21025 | William Wood W000706 | rep | IN | 1921-04-11 | 1923-03-03 | Republican | 10 | |||||||||||||
18042 | 18042 | Richard Bird B000479 | rep | KS | 1921-04-11 | 1923-03-03 | Republican | 8 | |||||||||||||
18092 | 18092 | Philip Campbell C000097 | rep | KS | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18733 | 18733 | Edward Little L000349 | rep | KS | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
19132 | 19132 | Jasper Tincher T000282 | rep | KS | 1921-04-11 | 1923-03-03 | Republican | 7 | |||||||||||||
19194 | 19194 | Daniel Anthony A000261 | rep | KS | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
19540 | 19540 | Hays White W000374 | rep | KS | 1921-04-11 | 1923-03-03 | Republican | 6 | |||||||||||||
20511 | 20511 | Homer Hoch H000669 | rep | KS | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
20892 | 20892 | James Strong S001011 | rep | KS | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
18384 | 18384 | Charles Ogden O000042 | rep | KY | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
18581 | 18581 | James Cantrill C000126 | rep | KY | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
18646 | 18646 | William Fields F000113 | rep | KY | 1921-04-11 | 1923-03-03 | Democrat | 9 | |||||||||||||
19002 | 19002 | Ben Johnson J000118 | rep | KY | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
19017 | 19017 | John Langley L000072 | rep | KY | 1921-04-11 | 1923-03-03 | Republican | 10 | |||||||||||||
19093 | 19093 | Arthur Rouse R000466 | rep | KY | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
19128 | 19128 | Robert Thomas T000185 | rep | KY | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
19828 | 19828 | David Kincheloe K000187 | rep | KY | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
20416 | 20416 | Ralph Gilbert G000177 | rep | KY | 1921-04-11 | 1923-03-03 | Democrat | 8 | |||||||||||||
24651 | 24651 | John Robsion R000358 | rep | KY | 1921-04-11 | 1923-03-03 | Republican | 11 | |||||||||||||
25871 | 25871 | Alben Barkley B000145 | rep | KY | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
18624 | 18624 | Henry Dupré D000561 | rep | LA | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
18638 | 18638 | George Favrot F000048 | rep | LA | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
19389 | 19389 | Ladislas Lazaro L000153 | rep | LA | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
19860 | 19860 | Whitmell Martin M000201 | rep | LA | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
19914 | 19914 | James O’Connor O000028 | rep | LA | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
20102 | 20102 | James Aswell A000321 | rep | LA | 1921-04-11 | 1923-03-03 | Democrat | 8 | |||||||||||||
21951 | 21951 | John Sandlin S000043 | rep | LA | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
22000 | 22000 | Riley Wilson W000608 | rep | LA | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
18318 | 18318 | Willfred Lufkin L000503 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 6 | |||||||||||||
18321 | 18321 | Robert Maloney M000092 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 7 | |||||||||||||
18551 | 18551 | Joseph Walsh W000101 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 16 | |||||||||||||
18672 | 18672 | William Greene G000430 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 15 | |||||||||||||
18742 | 18742 | Henry Lodge L000393 | sen | MA | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
18797 | 18797 | Calvin Paige P000024 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18865 | 18865 | Peter Tague T000014 | rep | MA | 1921-04-11 | 1923-03-03 | Democrat | 10 | |||||||||||||
18893 | 18893 | Samuel Winslow W000639 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
18973 | 18973 | Frederick Gillett G000201 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
19085 | 19085 | John Rogers R000400 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
19302 | 19302 | Louis Frothingham F000395 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 14 | |||||||||||||
19312 | 19312 | James Gallivan G000024 | rep | MA | 1921-04-11 | 1923-03-03 | Democrat | 12 | |||||||||||||
20275 | 20275 | Frederick Dallinger D000012 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 8 | |||||||||||||
20962 | 20962 | Charles Underhill U000006 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 9 | |||||||||||||
21607 | 21607 | Abram Andrew A000240 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 6 | |||||||||||||
22665 | 22665 | Robert Luce L000498 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 13 | |||||||||||||
23299 | 23299 | George Tinkham T000283 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 11 | |||||||||||||
23715 | 23715 | Allen Treadway T000358 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
24413 | 24413 | Charles Gifford G000169 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 16 | |||||||||||||
17212 | 17212 | Joseph France F000333 | sen | MD | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
18050 | 18050 | Albert Blakeney B000535 | rep | MD | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18782 | 18782 | Sydney Mudd M001060 | rep | MD | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
18990 | 18990 | John Hill H000597 | rep | MD | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
20063 | 20063 | Frederick Zihlman Z000007 | rep | MD | 1921-04-11 | 1923-03-03 | Republican | 6 | |||||||||||||
20658 | 20658 | John Linthicum L000340 | rep | MD | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
22613 | 22613 | Thomas Goldsborough G000265 | rep | MD | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
18420 | 18420 | John Peters P000253 | rep | ME | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
19352 | 19352 | Ira Hersey H000544 | rep | ME | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
20740 | 20740 | John Nelson N000038 | rep | ME | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
21112 | 21112 | Carroll Beedy B000307 | rep | ME | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
21797 | 21797 | Frederick Hale H000031 | sen | ME | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
23749 | 23749 | Wallace White W000396 | rep | ME | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
17495 | 17495 | Charles Townsend T000330 | sen | MI | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
18066 | 18066 | Vincent Brennan B000800 | rep | MI | 1921-04-11 | 1923-03-03 | Republican | 13 | |||||||||||||
18126 | 18126 | George Codd C000579 | rep | MI | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18189 | 18189 | Joseph Fordney F000271 | rep | MI | 1921-04-11 | 1923-03-03 | Republican | 8 | |||||||||||||
18190 | 18190 | William Frankhauser F000341 | rep | MI | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18271 | 18271 | Patrick Kelley K000061 | rep | MI | 1921-04-11 | 1923-03-03 | Republican | 6 | |||||||||||||
18854 | 18854 | John Smith S000573 | rep | MI | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
19100 | 19100 | Frank Scott S000169 | rep | MI | 1921-04-11 | 1923-03-03 | Republican | 11 | |||||||||||||
19632 | 19632 | Louis Cramton C000870 | rep | MI | 1921-04-11 | 1923-03-03 | Republican | 7 | |||||||||||||
20599 | 20599 | John Ketcham K000151 | rep | MI | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
20704 | 20704 | James McLaughlin M000539 | rep | MI | 1921-04-11 | 1923-03-03 | Republican | 9 | |||||||||||||
21334 | 21334 | William James J000053 | rep | MI | 1921-04-11 | 1923-03-03 | Republican | 12 | |||||||||||||
22678 | 22678 | Carl Mapes M000119 | rep | MI | 1921-04-11 | 1923-03-03 | Republican | 5 |
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);