legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
499 rows where "end" is on date 1921-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18952 | 18952 | Charles Fuller F000407 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 12 | |||||||||||||
19161 | 19161 | Loren Wheeler W000339 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 21 | |||||||||||||
19184 | 19184 | Frank Smith S000534 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 17 | |||||||||||||
19380 | 19380 | Edward King K000200 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 15 | |||||||||||||
19413 | 19413 | Martin Madden M000038 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
19659 | 19659 | Edward Denison D000237 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 25 | |||||||||||||
20044 | 20044 | Thomas Williams W000542 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 24 | |||||||||||||
20175 | 20175 | Carl Chindblom C000361 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
21051 | 21051 | Richard Yates Y000011 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | -1 | |||||||||||||
21153 | 21153 | Frederick Britten B000847 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 9 | |||||||||||||
21519 | 21519 | Henry Rainey R000014 | rep | IL | 1919-05-19 | 1921-03-03 | Democrat | 20 | |||||||||||||
22701 | 22701 | James McAndrews M000296 | rep | IL | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
25460 | 25460 | Adolph Sabath S000001 | rep | IL | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
18040 | 18040 | John Benham B000361 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
18052 | 18052 | Oscar Bland B000542 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
18295 | 18295 | Milton Kraus K000323 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 11 | |||||||||||||
18319 | 18319 | Oscar Luhring L000505 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
18634 | 18634 | Louis Fairfield F000007 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 12 | |||||||||||||
18768 | 18768 | Merrill Moores M000928 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
18835 | 18835 | Everett Sanders S000034 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
19536 | 19536 | James Watson W000203 | sen | IN | 1916-01-01 | 1921-03-03 | 3 | Republican | |||||||||||||
19674 | 19674 | James Dunbar D000525 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
19678 | 19678 | Richard Elliott E000127 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
19764 | 19764 | Andrew Hickey H000560 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 13 | |||||||||||||
20781 | 20781 | Fred Purnell P000573 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 9 | |||||||||||||
20969 | 20969 | Albert Vestal V000092 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
21024 | 21024 | William Wood W000706 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
18091 | 18091 | Philip Campbell C000097 | rep | KS | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18732 | 18732 | Edward Little L000349 | rep | KS | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
19131 | 19131 | Jasper Tincher T000282 | rep | KS | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
19193 | 19193 | Daniel Anthony A000261 | rep | KS | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
19277 | 19277 | Charles Curtis C001008 | sen | KS | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
19539 | 19539 | Hays White W000374 | rep | KS | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
20510 | 20510 | Homer Hoch H000669 | rep | KS | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
20891 | 20891 | James Strong S001011 | rep | KS | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
21098 | 21098 | William Ayres A000354 | rep | KS | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
16688 | 16688 | John Beckham B000293 | sen | KY | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
17771 | 17771 | Harvey Helm H000461 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | -1 | |||||||||||||
17973 | 17973 | King Swope S001129 | rep | KY | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
18383 | 18383 | Charles Ogden O000042 | rep | KY | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
18580 | 18580 | James Cantrill C000126 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
18645 | 18645 | William Fields F000113 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
19001 | 19001 | Ben Johnson J000118 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
19016 | 19016 | John Langley L000072 | rep | KY | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
19092 | 19092 | Arthur Rouse R000466 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
19127 | 19127 | Robert Thomas T000185 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
19827 | 19827 | David Kincheloe K000187 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
24650 | 24650 | John Robsion R000358 | rep | KY | 1919-05-19 | 1921-03-03 | Republican | 11 | |||||||||||||
25870 | 25870 | Alben Barkley B000145 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
17523 | 17523 | Edward Gay G000104 | sen | LA | 1918-01-01 | 1921-03-03 | 3 | Democrat | |||||||||||||
17681 | 17681 | Albert Estopinal E000224 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
17909 | 17909 | Jared Sanders S000035 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
17991 | 17991 | John Watkins W000193 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
18623 | 18623 | Henry Dupré D000561 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
19388 | 19388 | Ladislas Lazaro L000153 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
19859 | 19859 | Whitmell Martin M000201 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
19913 | 19913 | James O’Connor O000028 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
20101 | 20101 | James Aswell A000321 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
21999 | 21999 | Riley Wilson W000608 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
17701 | 17701 | John Fitzgerald F000164 | rep | MA | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
17703 | 17703 | Alvan Fuller F000405 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 9 | |||||||||||||
17877 | 17877 | Richard Olney O000080 | rep | MA | 1919-05-19 | 1921-03-03 | Democrat | 14 | |||||||||||||
17885 | 17885 | Michael Phelan P000291 | rep | MA | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
18317 | 18317 | Willfred Lufkin L000503 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
18550 | 18550 | Joseph Walsh W000101 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 16 | |||||||||||||
18671 | 18671 | William Greene G000430 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 15 | |||||||||||||
18796 | 18796 | Calvin Paige P000024 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18864 | 18864 | Peter Tague T000014 | rep | MA | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
18892 | 18892 | Samuel Winslow W000639 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
18972 | 18972 | Frederick Gillett G000201 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
19084 | 19084 | John Rogers R000400 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
19311 | 19311 | James Gallivan G000024 | rep | MA | 1919-05-19 | 1921-03-03 | Democrat | 12 | |||||||||||||
20274 | 20274 | Frederick Dallinger D000012 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
22664 | 22664 | Robert Luce L000498 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 13 | |||||||||||||
23298 | 23298 | George Tinkham T000283 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 11 | |||||||||||||
23714 | 23714 | Allen Treadway T000358 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
16969 | 16969 | John Smith S000577 | sen | MD | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
17539 | 17539 | William Andrews A000253 | rep | MD | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17561 | 17561 | Carville Benson B000387 | rep | MD | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
17627 | 17627 | Charles Coady C000541 | rep | MD | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
18781 | 18781 | Sydney Mudd M001060 | rep | MD | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
20062 | 20062 | Frederick Zihlman Z000007 | rep | MD | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
20657 | 20657 | John Linthicum L000340 | rep | MD | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
17736 | 17736 | Louis Goodall G000276 | rep | ME | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
18419 | 18419 | John Peters P000253 | rep | ME | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
19351 | 19351 | Ira Hersey H000544 | rep | ME | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
23748 | 23748 | Wallace White W000396 | rep | ME | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
17634 | 17634 | Gilbert Currie C000998 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
17655 | 17655 | Frank Doremus D000431 | rep | MI | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
17761 | 17761 | Edward Hamilton H000108 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
17874 | 17874 | Charles Nichols N000090 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 13 | |||||||||||||
18188 | 18188 | Joseph Fordney F000271 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
18270 | 18270 | Patrick Kelley K000061 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
18853 | 18853 | John Smith S000573 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
19099 | 19099 | Frank Scott S000169 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 11 | |||||||||||||
19631 | 19631 | Louis Cramton C000870 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
20703 | 20703 | James McLaughlin M000539 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 9 | |||||||||||||
21333 | 21333 | William James J000053 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 12 | |||||||||||||
22677 | 22677 | Carl Mapes M000119 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
22705 | 22705 | Clarence McLeod M000557 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 13 |
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);