legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
484 rows where "end" is on date 1927-03-04 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class
start (date) 9 ✖
- 1925-12-07 452
- 1921-04-11 24
- 1924-01-01 2
- 1922-01-01 1
- 1922-01-09 1
- 1923-12-03 1
- 1924-11-13 1
- 1926-08-07 1
- 1926-12-06 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20004 | 20004 | Daniel Sutherland S001079 | rep | AK | 1925-12-07 | 1927-03-04 | Republican | 0 | |||||||||||||
18535 | 18535 | Oscar Underwood U000013 | sen | AL | 1921-04-11 | 1927-03-04 | 3 | Democrat | |||||||||||||
19232 | 19232 | William Bowling B000702 | rep | AL | 1925-12-07 | 1927-03-04 | Democrat | 5 | |||||||||||||
21075 | 21075 | Miles Allgood A000156 | rep | AL | 1925-12-07 | 1927-03-04 | Democrat | 7 | |||||||||||||
21085 | 21085 | Edward Almon A000162 | rep | AL | 1925-12-07 | 1927-03-04 | Democrat | 8 | |||||||||||||
21343 | 21343 | Lamar Jeffers J000068 | rep | AL | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
21823 | 21823 | George Huddleston H000903 | rep | AL | 1925-12-07 | 1927-03-04 | Democrat | 9 | |||||||||||||
21866 | 21866 | John McDuffie M000427 | rep | AL | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
21905 | 21905 | William Oliver O000077 | rep | AL | 1925-12-07 | 1927-03-04 | Democrat | 6 | |||||||||||||
22492 | 22492 | William Bankhead B000113 | rep | AL | 1925-12-07 | 1927-03-04 | Democrat | 10 | |||||||||||||
23692 | 23692 | Henry Steagall S000820 | rep | AL | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
27872 | 27872 | Joseph Hill H000598 | rep | AL | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
19260 | 19260 | Thaddeus Caraway C000139 | sen | AR | 1921-04-11 | 1927-03-04 | 3 | Democrat | |||||||||||||
19453 | 19453 | William Oldfield O000062 | rep | AR | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
19468 | 19468 | James Reed R000119 | rep | AR | 1925-12-07 | 1927-03-04 | Democrat | 6 | |||||||||||||
19509 | 19509 | John Tillman T000276 | rep | AR | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
20056 | 20056 | Otis Wingo W000635 | rep | AR | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
21506 | 21506 | Heartsill Ragon R000009 | rep | AR | 1925-12-07 | 1927-03-04 | Democrat | 5 | |||||||||||||
21913 | 21913 | Tilman Parks P000075 | rep | AR | 1925-12-07 | 1927-03-04 | Democrat | 7 | |||||||||||||
22119 | 22119 | William Driver D000503 | rep | AR | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
18082 | 18082 | Ralph Cameron C000066 | sen | AZ | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
27850 | 27850 | Carl Hayden H000385 | rep | AZ | 1925-12-07 | 1927-03-04 | Democrat | 0 | |||||||||||||
18942 | 18942 | Lawrence Flaherty F000182 | rep | CA | 1925-12-07 | 1927-03-04 | Republican | 5 | |||||||||||||
18944 | 18944 | John Fredericks F000358 | rep | CA | 1925-12-07 | 1927-03-04 | Republican | 10 | |||||||||||||
19033 | 19033 | Walter Lineberger L000331 | rep | CA | 1925-12-07 | 1927-03-04 | Republican | 9 | |||||||||||||
19070 | 19070 | John Raker R000019 | rep | CA | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
19478 | 19478 | Samuel Shortridge S000380 | sen | CA | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
19643 | 19643 | Charles Curry C001000 | rep | CA | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
20116 | 20116 | Henry Barbour B000126 | rep | CA | 1925-12-07 | 1927-03-04 | Republican | 7 | |||||||||||||
20374 | 20374 | Arthur Free F000359 | rep | CA | 1925-12-07 | 1927-03-04 | Republican | 8 | |||||||||||||
20912 | 20912 | Philip Swing S001123 | rep | CA | 1925-12-07 | 1927-03-04 | Republican | 11 | |||||||||||||
21833 | 21833 | Florence Kahn K000002 | rep | CA | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
23362 | 23362 | Albert Carter C000195 | rep | CA | 1925-12-07 | 1927-03-04 | Republican | 6 | |||||||||||||
23441 | 23441 | Harry Englebright E000182 | rep | CA | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
24539 | 24539 | Clarence Lea L000163 | rep | CA | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
25061 | 25061 | Richard Welch W000265 | rep | CA | 1925-12-07 | 1927-03-04 | Republican | 5 | |||||||||||||
18908 | 18908 | Rice Means M000621 | sen | CO | 1924-01-01 | 1927-03-04 | 3 | Republican | |||||||||||||
19516 | 19516 | William Vaile V000004 | rep | CO | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
20471 | 20471 | Guy Hardy H000195 | rep | CO | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
20948 | 20948 | Charles Timberlake T000281 | rep | CO | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
23278 | 23278 | Edward Taylor T000072 | rep | CO | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
19212 | 19212 | Hiram Bingham B000470 | sen | CT | 1924-01-01 | 1927-03-04 | 3 | Republican | |||||||||||||
19693 | 19693 | Edward Fenn F000072 | rep | CT | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
19729 | 19729 | James Glynn G000246 | rep | CT | 1925-12-07 | 1927-03-04 | Republican | 5 | |||||||||||||
20383 | 20383 | Richard Freeman F000366 | rep | CT | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20939 | 20939 | John Tilson T000279 | rep | CT | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
21884 | 21884 | Schuyler Merritt M000663 | rep | CT | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
20532 | 20532 | Robert Houston H000826 | rep | DE | 1925-12-07 | 1927-03-04 | Republican | 0 | |||||||||||||
19112 | 19112 | John Smithwick S000643 | rep | FL | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
20315 | 20315 | Herbert Drane D000486 | rep | FL | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
21261 | 21261 | Duncan Fletcher F000200 | sen | FL | 1921-04-11 | 1927-03-04 | 3 | Democrat | |||||||||||||
21965 | 21965 | William Sears S000211 | rep | FL | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
23526 | 23526 | Robert Green G000415 | rep | FL | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
19030 | 19030 | Gordon Lee L000194 | rep | GA | 1925-12-07 | 1927-03-04 | Democrat | 7 | |||||||||||||
19140 | 19140 | William Upshaw U000026 | rep | GA | 1925-12-07 | 1927-03-04 | Democrat | 5 | |||||||||||||
19584 | 19584 | Thomas Bell B000348 | rep | GA | 1925-12-07 | 1927-03-04 | Democrat | 9 | |||||||||||||
20267 | 20267 | Charles Crisp C000909 | rep | GA | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
20345 | 20345 | Charles Edwards E000062 | rep | GA | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
20632 | 20632 | William Lankford L000082 | rep | GA | 1925-12-07 | 1927-03-04 | Democrat | 11 | |||||||||||||
20640 | 20640 | William Larsen L000103 | rep | GA | 1925-12-07 | 1927-03-04 | Democrat | 12 | |||||||||||||
20821 | 20821 | Samuel Rutherford R000549 | rep | GA | 1925-12-07 | 1927-03-04 | Democrat | 6 | |||||||||||||
21035 | 21035 | William Wright W000773 | rep | GA | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
21137 | 21137 | Charles Brand B000767 | rep | GA | 1925-12-07 | 1927-03-04 | Democrat | 8 | |||||||||||||
25189 | 25189 | Edward Cox C000831 | rep | GA | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
25266 | 25266 | Walter George G000131 | sen | GA | 1922-01-01 | 1927-03-04 | 3 | Democrat | |||||||||||||
28209 | 28209 | Carl Vinson V000105 | rep | GA | 1925-12-07 | 1927-03-04 | Democrat | 10 | |||||||||||||
18994 | 18994 | William Jarrett J000061 | rep | HI | 1925-12-07 | 1927-03-04 | Democrat | -1 | |||||||||||||
19186 | 19186 | David Stewart S000906 | sen | IA | 1926-08-07 | 1927-03-04 | 3 | Republican | appointment | ||||||||||||
19225 | 19225 | William Boies B000597 | rep | IA | 1925-12-07 | 1927-03-04 | Republican | 11 | |||||||||||||
19235 | 19235 | Smith Brookhart B000873 | sen | IA | 1925-12-07 | 1927-03-04 | 2 | Republican | |||||||||||||
19340 | 19340 | William Green G000422 | rep | IA | 1925-12-07 | 1927-03-04 | Republican | 9 | |||||||||||||
19854 | 19854 | Fred Letts L000258 | rep | IA | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20206 | 20206 | Cyrenus Cole C000608 | rep | IA | 1925-12-07 | 1927-03-04 | Republican | 5 | |||||||||||||
20296 | 20296 | Lester Dickinson D000323 | rep | IA | 1925-12-07 | 1927-03-04 | Republican | 10 | |||||||||||||
20493 | 20493 | Gilbert Haugen H000350 | rep | IA | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
20610 | 20610 | William Kopp K000314 | rep | IA | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
20803 | 20803 | Christian Ramseyer R000031 | rep | IA | 1925-12-07 | 1927-03-04 | Republican | 6 | |||||||||||||
20817 | 20817 | Thomas Robinson R000352 | rep | IA | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
22441 | 22441 | Lloyd Thurston T000257 | rep | IA | 1925-12-07 | 1927-03-04 | Republican | 8 | |||||||||||||
22576 | 22576 | Cassius Dowell D000468 | rep | IA | 1925-12-07 | 1927-03-04 | Republican | 7 | |||||||||||||
19331 | 19331 | Frank Gooding G000288 | sen | ID | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
20396 | 20396 | Burton French F000375 | rep | ID | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
20864 | 20864 | Addison Smith S000511 | rep | ID | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
18353 | 18353 | William McKinley M000521 | sen | IL | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
18955 | 18955 | Charles Fuller F000407 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 12 | |||||||||||||
18958 | 18958 | Frank Funk F000428 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 17 | |||||||||||||
18978 | 18978 | John Gorman G000329 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 6 | |||||||||||||
19163 | 19163 | Loren Wheeler W000339 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 21 | |||||||||||||
19383 | 19383 | Edward King K000200 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 15 | |||||||||||||
19416 | 19416 | Martin Madden M000038 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
19465 | 19465 | Henry Rathbone R000068 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | -1 | |||||||||||||
19662 | 19662 | Edward Denison D000237 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 25 | |||||||||||||
19671 | 19671 | Thomas Doyle D000483 | rep | IL | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
19793 | 19793 | Edward Irwin I000040 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 22 | |||||||||||||
19876 | 19876 | Magne Michaelson M000690 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 7 | |||||||||||||
19971 | 19971 | Elliott Sproul S000758 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
20047 | 20047 | Thomas Williams W000542 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 24 | |||||||||||||
20080 | 20080 | Charles Adkins A000057 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 19 | |||||||||||||
20089 | 20089 | John Allen A000131 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 14 | |||||||||||||
20178 | 20178 | Carl Chindblom C000361 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 10 |
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);