legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
502 rows where "end" is on date 1931-03-03 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, party
start (date) 10 ✖
- 1929-04-15 466
- 1925-12-07 26
- 1926-01-01 2
- 1930-01-01 2
- 1928-12-10 1
- 1929-09-02 1
- 1929-11-05 1
- 1929-11-30 1
- 1929-12-11 1
- 1930-12-01 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20006 | 20006 | Daniel Sutherland S001079 | rep | AK | 1929-04-15 | 1931-03-03 | Republican | 0 | |||||||||||||
18989 | 18989 | James Heflin H000446 | sen | AL | 1925-12-07 | 1931-03-03 | 2 | Democrat | |||||||||||||
20770 | 20770 | LaFayette Patterson P000125 | rep | AL | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
21077 | 21077 | Miles Allgood A000156 | rep | AL | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
21087 | 21087 | Edward Almon A000162 | rep | AL | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
21345 | 21345 | Lamar Jeffers J000068 | rep | AL | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
21825 | 21825 | George Huddleston H000903 | rep | AL | 1929-04-15 | 1931-03-03 | Democrat | 9 | |||||||||||||
21868 | 21868 | John McDuffie M000427 | rep | AL | 1929-04-15 | 1931-03-03 | Democrat | 1 | |||||||||||||
21907 | 21907 | William Oliver O000077 | rep | AL | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
22494 | 22494 | William Bankhead B000113 | rep | AL | 1929-04-15 | 1931-03-03 | Democrat | 10 | |||||||||||||
23694 | 23694 | Henry Steagall S000820 | rep | AL | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
27874 | 27874 | Joseph Hill H000598 | rep | AL | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
19920 | 19920 | Pearl Oldfield O000061 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
20058 | 20058 | Otis Wingo W000635 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
20814 | 20814 | Joseph Robinson R000347 | sen | AR | 1925-12-07 | 1931-03-03 | 2 | Democrat | |||||||||||||
21020 | 21020 | Effiegene Wingo W000634 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
21298 | 21298 | David Glover G000243 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
21508 | 21508 | Heartsill Ragon R000009 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
21915 | 21915 | Tilman Parks P000075 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
22121 | 22121 | William Driver D000503 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 1 | |||||||||||||
22156 | 22156 | Claude Fuller F000408 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
20309 | 20309 | Lewis Douglas D000455 | rep | AZ | 1929-04-15 | 1931-03-03 | Democrat | 0 | |||||||||||||
19645 | 19645 | Charles Curry C001000 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
20118 | 20118 | Henry Barbour B000126 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 7 | |||||||||||||
20258 | 20258 | Joe Crail C000864 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 10 | |||||||||||||
20376 | 20376 | Arthur Free F000359 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 8 | |||||||||||||
20914 | 20914 | Philip Swing S001123 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 11 | |||||||||||||
21255 | 21255 | William Evans E000261 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 9 | |||||||||||||
21835 | 21835 | Florence Kahn K000002 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
23364 | 23364 | Albert Carter C000195 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 6 | |||||||||||||
23443 | 23443 | Harry Englebright E000182 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
24541 | 24541 | Clarence Lea L000163 | rep | CA | 1929-04-15 | 1931-03-03 | Democrat | 1 | |||||||||||||
25063 | 25063 | Richard Welch W000265 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
19061 | 19061 | Lawrence Phipps P000317 | sen | CO | 1925-12-07 | 1931-03-03 | 2 | Republican | |||||||||||||
20338 | 20338 | William Eaton E000027 | rep | CO | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20473 | 20473 | Guy Hardy H000195 | rep | CO | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
20950 | 20950 | Charles Timberlake T000281 | rep | CO | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
23280 | 23280 | Edward Taylor T000072 | rep | CO | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
19695 | 19695 | Edward Fenn F000072 | rep | CT | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
19731 | 19731 | James Glynn G000246 | rep | CT | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
20385 | 20385 | Richard Freeman F000366 | rep | CT | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20941 | 20941 | John Tilson T000279 | rep | CT | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
21301 | 21301 | Edward Goss G000334 | rep | CT | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
21886 | 21886 | Schuyler Merritt M000663 | rep | CT | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20478 | 20478 | Daniel Hastings H000325 | sen | DE | 1928-12-10 | 1931-03-03 | 2 | Republican | appointment | ||||||||||||
20534 | 20534 | Robert Houston H000826 | rep | DE | 1929-04-15 | 1931-03-03 | Republican | 0 | |||||||||||||
20317 | 20317 | Herbert Drane D000486 | rep | FL | 1929-04-15 | 1931-03-03 | Democrat | 1 | |||||||||||||
20766 | 20766 | Ruth Owen O000154 | rep | FL | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
21059 | 21059 | Thomas Yon Y000021 | rep | FL | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
23528 | 23528 | Robert Green G000415 | rep | FL | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
19586 | 19586 | Thomas Bell B000348 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 9 | |||||||||||||
19989 | 19989 | Leslie Steele S000835 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
20269 | 20269 | Charles Crisp C000909 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
20347 | 20347 | Charles Edwards E000062 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 1 | |||||||||||||
20476 | 20476 | William Harris H000259 | sen | GA | 1925-12-07 | 1931-03-03 | 2 | Democrat | |||||||||||||
20634 | 20634 | William Lankford L000082 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 11 | |||||||||||||
20642 | 20642 | William Larsen L000103 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 12 | |||||||||||||
20823 | 20823 | Samuel Rutherford R000549 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
21037 | 21037 | William Wright W000773 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
21139 | 21139 | Charles Brand B000767 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
24051 | 24051 | Robert Ramspeck R000032 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
24134 | 24134 | Malcolm Tarver T000045 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
25191 | 25191 | Edward Cox C000831 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
28211 | 28211 | Carl Vinson V000105 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 10 | |||||||||||||
20537 | 20537 | Victor Houston H000828 | rep | HI | 1929-04-15 | 1931-03-03 | Republican | -1 | |||||||||||||
19185 | 19185 | Daniel Steck S000826 | sen | IA | 1926-01-01 | 1931-03-03 | 2 | Democrat | |||||||||||||
19856 | 19856 | Fred Letts L000258 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20157 | 20157 | Ed Campbell C000081 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 11 | |||||||||||||
20208 | 20208 | Cyrenus Cole C000608 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
20298 | 20298 | Lester Dickinson D000323 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 10 | |||||||||||||
20495 | 20495 | Gilbert Haugen H000350 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20612 | 20612 | William Kopp K000314 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20805 | 20805 | Christian Ramseyer R000031 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 6 | |||||||||||||
20819 | 20819 | Thomas Robinson R000352 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
20908 | 20908 | Charles Swanson S001093 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 9 | |||||||||||||
22443 | 22443 | Lloyd Thurston T000257 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 8 | |||||||||||||
22578 | 22578 | Cassius Dowell D000468 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 7 | |||||||||||||
20398 | 20398 | Burton French F000375 | rep | ID | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20866 | 20866 | Addison Smith S000511 | rep | ID | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
22050 | 22050 | William Borah B000634 | sen | ID | 1925-12-07 | 1931-03-03 | 2 | Republican | |||||||||||||
18931 | 18931 | Charles Deneen D000233 | sen | IL | 1925-12-07 | 1931-03-03 | 2 | Republican | |||||||||||||
19664 | 19664 | Edward Denison D000237 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 25 | |||||||||||||
19673 | 19673 | Thomas Doyle D000483 | rep | IL | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
19795 | 19795 | Edward Irwin I000040 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 22 | |||||||||||||
19866 | 19866 | Ruth McCormick M000372 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | -1 | |||||||||||||
19878 | 19878 | Magne Michaelson M000690 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 7 | |||||||||||||
19939 | 19939 | Frank Ramey R000021 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 21 | |||||||||||||
19973 | 19973 | Elliott Sproul S000758 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
20049 | 20049 | Thomas Williams W000542 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 24 | |||||||||||||
20082 | 20082 | Charles Adkins A000057 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 19 | |||||||||||||
20091 | 20091 | John Allen A000131 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 14 | |||||||||||||
20180 | 20180 | Carl Chindblom C000361 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 10 | |||||||||||||
20183 | 20183 | Burnett Chiperfield C000364 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 15 | |||||||||||||
20459 | 20459 | Homer Hall H000053 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 17 | |||||||||||||
20526 | 20526 | William Holaday H000708 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 18 | |||||||||||||
20554 | 20554 | Morton Hull H000944 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20559 | 20559 | William Hull H000946 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 16 | |||||||||||||
20562 | 20562 | James Igoe I000003 | rep | IL | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
20586 | 20586 | William Johnson J000181 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 13 | |||||||||||||
20618 | 20618 | Stanley Kunz K000342 | rep | IL | 1929-04-15 | 1931-03-03 | Democrat | 8 |
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);