legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
495 rows where "start" is on date 1923-12-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20615 | 20615 | Stanley Kunz K000342 | rep | IL | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
21053 | 21053 | Richard Yates Y000011 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | -1 | |||||||||||||
21155 | 21155 | Frederick Britten B000847 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 9 | |||||||||||||
21390 | 21390 | James Major M000073 | rep | IL | 1923-12-03 | 1925-03-03 | Democrat | 21 | |||||||||||||
21520 | 21520 | Henry Rainey R000014 | rep | IL | 1923-12-03 | 1925-03-03 | Democrat | 20 | |||||||||||||
21526 | 21526 | Frank Reid R000145 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 11 | |||||||||||||
21615 | 21615 | William Arnold A000300 | rep | IL | 1923-12-03 | 1925-03-03 | Democrat | 23 | |||||||||||||
25462 | 25462 | Adolph Sabath S000001 | rep | IL | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
18604 | 18604 | Samuel Cook C000727 | rep | IN | 1923-12-03 | 1925-03-03 | Democrat | 11 | |||||||||||||
18636 | 18636 | Louis Fairfield F000007 | rep | IN | 1923-12-03 | 1925-03-03 | Republican | 12 | |||||||||||||
18770 | 18770 | Merrill Moores M000928 | rep | IN | 1923-12-03 | 1925-03-03 | Republican | 7 | |||||||||||||
18809 | 18809 | Samuel Ralston R000020 | sen | IN | 1923-12-03 | 1925-12-31 | 1 | Democrat | |||||||||||||
18837 | 18837 | Everett Sanders S000034 | rep | IN | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
18888 | 18888 | William Wilson W000621 | rep | IN | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
19316 | 19316 | Frank Gardner G000053 | rep | IN | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
19680 | 19680 | Richard Elliott E000127 | rep | IN | 1923-12-03 | 1925-03-03 | Republican | 6 | |||||||||||||
19766 | 19766 | Andrew Hickey H000560 | rep | IN | 1923-12-03 | 1925-03-03 | Republican | 13 | |||||||||||||
20167 | 20167 | Harry Canfield C000114 | rep | IN | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
20783 | 20783 | Fred Purnell P000573 | rep | IN | 1923-12-03 | 1925-03-03 | Republican | 9 | |||||||||||||
20971 | 20971 | Albert Vestal V000092 | rep | IN | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
21026 | 21026 | William Wood W000706 | rep | IN | 1923-12-03 | 1925-03-03 | Republican | 10 | |||||||||||||
22194 | 22194 | Arthur Greenwood G000437 | rep | IN | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
18734 | 18734 | Edward Little L000349 | rep | KS | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
19133 | 19133 | Jasper Tincher T000282 | rep | KS | 1923-12-03 | 1925-03-03 | Republican | 7 | |||||||||||||
19195 | 19195 | Daniel Anthony A000261 | rep | KS | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
19541 | 19541 | Hays White W000374 | rep | KS | 1923-12-03 | 1925-03-03 | Republican | 6 | |||||||||||||
19974 | 19974 | William Sproul S000759 | rep | KS | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
20512 | 20512 | Homer Hoch H000669 | rep | KS | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
20893 | 20893 | James Strong S001011 | rep | KS | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
21099 | 21099 | William Ayres A000354 | rep | KS | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
23536 | 23536 | Ulysses Guyer G000538 | rep | KS | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
18582 | 18582 | James Cantrill C000126 | rep | KY | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
18647 | 18647 | William Fields F000113 | rep | KY | 1923-12-03 | 1925-03-03 | Democrat | 9 | |||||||||||||
18771 | 18771 | Joseph Morris M000981 | rep | KY | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
19003 | 19003 | Ben Johnson J000118 | rep | KY | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
19018 | 19018 | John Langley L000072 | rep | KY | 1923-12-03 | 1925-03-03 | Republican | 10 | |||||||||||||
19094 | 19094 | Arthur Rouse R000466 | rep | KY | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
19129 | 19129 | Robert Thomas T000185 | rep | KY | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
19829 | 19829 | David Kincheloe K000187 | rep | KY | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
20417 | 20417 | Ralph Gilbert G000177 | rep | KY | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
20926 | 20926 | Maurice Thatcher T000142 | rep | KY | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
22450 | 22450 | Frederick Vinson V000106 | rep | KY | 1923-12-03 | 1925-03-03 | Democrat | 9 | |||||||||||||
24652 | 24652 | John Robsion R000358 | rep | KY | 1923-12-03 | 1925-03-03 | Republican | 11 | |||||||||||||
25872 | 25872 | Alben Barkley B000145 | rep | KY | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
18625 | 18625 | Henry Dupré D000561 | rep | LA | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
18639 | 18639 | George Favrot F000048 | rep | LA | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
19390 | 19390 | Ladislas Lazaro L000153 | rep | LA | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
19861 | 19861 | Whitmell Martin M000201 | rep | LA | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
19915 | 19915 | James O’Connor O000028 | rep | LA | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
19965 | 19965 | James Spearing S000708 | rep | LA | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
20103 | 20103 | James Aswell A000321 | rep | LA | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
21952 | 21952 | John Sandlin S000043 | rep | LA | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
22001 | 22001 | Riley Wilson W000608 | rep | LA | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
18673 | 18673 | William Greene G000430 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 15 | |||||||||||||
18729 | 18729 | Robert Leach L000171 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 15 | |||||||||||||
18743 | 18743 | Henry Lodge L000393 | sen | MA | 1923-12-03 | 1924-11-09 | 1 | Republican | |||||||||||||
18798 | 18798 | Calvin Paige P000024 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
18866 | 18866 | Peter Tague T000014 | rep | MA | 1923-12-03 | 1925-03-03 | Democrat | 10 | |||||||||||||
18894 | 18894 | Samuel Winslow W000639 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
18974 | 18974 | Frederick Gillett G000201 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
19086 | 19086 | John Rogers R000400 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
19303 | 19303 | Louis Frothingham F000395 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 14 | |||||||||||||
19313 | 19313 | James Gallivan G000024 | rep | MA | 1923-12-03 | 1925-03-03 | Democrat | 12 | |||||||||||||
20276 | 20276 | Frederick Dallinger D000012 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
20963 | 20963 | Charles Underhill U000006 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 9 | |||||||||||||
21608 | 21608 | Abram Andrew A000240 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 6 | |||||||||||||
22095 | 22095 | William Connery C000694 | rep | MA | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
22666 | 22666 | Robert Luce L000498 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 13 | |||||||||||||
23300 | 23300 | George Tinkham T000283 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 11 | |||||||||||||
23716 | 23716 | Allen Treadway T000358 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
24414 | 24414 | Charles Gifford G000169 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 16 | |||||||||||||
18573 | 18573 | William Bruce B000972 | sen | MD | 1923-12-03 | 1929-03-03 | 1 | Democrat | |||||||||||||
18783 | 18783 | Sydney Mudd M001060 | rep | MD | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
18991 | 18991 | John Hill H000597 | rep | MD | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
20064 | 20064 | Frederick Zihlman Z000007 | rep | MD | 1923-12-03 | 1925-03-03 | Republican | 6 | |||||||||||||
20659 | 20659 | John Linthicum L000340 | rep | MD | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
22161 | 22161 | Stephen Gambrill G000035 | rep | MD | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
22614 | 22614 | Thomas Goldsborough G000265 | rep | MD | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
24168 | 24168 | Millard Tydings T000446 | rep | MD | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
19353 | 19353 | Ira Hersey H000544 | rep | ME | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
20741 | 20741 | John Nelson N000038 | rep | ME | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
21113 | 21113 | Carroll Beedy B000307 | rep | ME | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
21798 | 21798 | Frederick Hale H000031 | sen | ME | 1923-12-03 | 1929-03-03 | 1 | Republican | |||||||||||||
23750 | 23750 | Wallace White W000396 | rep | ME | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
18640 | 18640 | Woodbridge Ferris F000092 | sen | MI | 1923-12-03 | 1928-03-23 | 1 | Democrat | |||||||||||||
18855 | 18855 | John Smith S000573 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
19101 | 19101 | Frank Scott S000169 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 11 | |||||||||||||
19164 | 19164 | Arthur Williams W000490 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
19633 | 19633 | Louis Cramton C000870 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 7 | |||||||||||||
19774 | 19774 | Grant Hudson H000908 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 6 | |||||||||||||
20200 | 20200 | Robert Clancy C000412 | rep | MI | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
20600 | 20600 | John Ketcham K000151 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
20705 | 20705 | James McLaughlin M000539 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 9 | |||||||||||||
20976 | 20976 | Bird Vincent V000101 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
21335 | 21335 | William James J000053 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 12 | |||||||||||||
22679 | 22679 | Carl Mapes M000119 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
22706 | 22706 | Clarence McLeod M000557 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 13 | |||||||||||||
24935 | 24935 | Earl Michener M000693 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
25554 | 25554 | Roy Woodruff W000718 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 10 | |||||||||||||
18570 | 18570 | Sydney Anderson A000233 | rep | MN | 1923-12-03 | 1925-03-03 | Republican | 1 |
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);