legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
493 rows where "end" is on date 1925-03-03 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: start
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29671 | 29671 | Emanuel Celler C000264 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 10 | |||||||||||||
28208 | 28208 | Carl Vinson V000105 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 10 | |||||||||||||
27871 | 27871 | Joseph Hill H000598 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
27849 | 27849 | Carl Hayden H000385 | rep | AZ | 1923-12-03 | 1925-03-03 | Democrat | 0 | |||||||||||||
27679 | 27679 | Clarence Cannon C000117 | rep | MO | 1923-12-03 | 1925-03-03 | Democrat | 9 | |||||||||||||
27549 | 27549 | John Taber T000001 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 36 | |||||||||||||
27460 | 27460 | Brazilla Reece R000108 | rep | TN | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
27439 | 27439 | Samuel Rayburn R000082 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
26952 | 26952 | Daniel Reed R000113 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 43 | |||||||||||||
25872 | 25872 | Alben Barkley B000145 | rep | KY | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
25642 | 25642 | Robert Crosser C000932 | rep | OH | 1923-12-03 | 1925-03-03 | Democrat | 21 | |||||||||||||
25554 | 25554 | Roy Woodruff W000718 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 10 | |||||||||||||
25462 | 25462 | Adolph Sabath S000001 | rep | IL | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
25434 | 25434 | John Rankin R000056 | rep | MS | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
25348 | 25348 | John Kerr K000138 | rep | NC | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
25219 | 25219 | Robert Doughton D000448 | rep | NC | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
24935 | 24935 | Earl Michener M000693 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
24926 | 24926 | John McSweeney M000606 | rep | OH | 1923-12-03 | 1925-03-03 | Democrat | 16 | |||||||||||||
24776 | 24776 | Alfred Bulwinkle B001056 | rep | NC | 1923-12-03 | 1925-03-03 | Democrat | 9 | |||||||||||||
24759 | 24759 | Sol Bloom B000565 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 19 | |||||||||||||
24745 | 24745 | Schuyler Bland B000545 | rep | VA | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
24652 | 24652 | John Robsion R000358 | rep | KY | 1923-12-03 | 1925-03-03 | Republican | 11 | |||||||||||||
24580 | 24580 | Joseph Mansfield M000112 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 9 | |||||||||||||
24538 | 24538 | Clarence Lea L000163 | rep | CA | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
24517 | 24517 | Harold Knutson K000301 | rep | MN | 1923-12-03 | 1925-03-03 | Republican | 6 | |||||||||||||
24414 | 24414 | Charles Gifford G000169 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 16 | |||||||||||||
24356 | 24356 | Patrick Drewry D000496 | rep | VA | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
24316 | 24316 | Thomas Connally C000684 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 11 | |||||||||||||
24217 | 24217 | Clifton Woodrum W000720 | rep | VA | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
24189 | 24189 | Zebulon Weaver W000230 | rep | NC | 1923-12-03 | 1925-03-03 | Democrat | 10 | |||||||||||||
24168 | 24168 | Millard Tydings T000446 | rep | MD | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
24152 | 24152 | John Thomas T000177 | rep | OK | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
24118 | 24118 | Hatton Sumners S001072 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
23948 | 23948 | Fritz Lanham L000076 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 12 | |||||||||||||
23911 | 23911 | Luther Johnson J000159 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
23826 | 23826 | Samuel Dickstein D000335 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 12 | |||||||||||||
23750 | 23750 | Wallace White W000396 | rep | ME | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
23716 | 23716 | Allen Treadway T000358 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
23691 | 23691 | Henry Steagall S000820 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
23607 | 23607 | Charles McNary M000583 | sen | OR | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
23536 | 23536 | Ulysses Guyer G000538 | rep | KS | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
23521 | 23521 | Carter Glass G000232 | sen | VA | 1920-02-20 | 1925-03-03 | 2 | Democrat | appointment | ||||||||||||
23482 | 23482 | Hampton Fulmer F000417 | rep | SC | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
23455 | 23455 | Hamilton Fish F000142 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 26 | |||||||||||||
23396 | 23396 | Thomas Cullen C000970 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
23356 | 23356 | Arthur Capper C000133 | sen | KS | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
23313 | 23313 | David Walsh W000097 | sen | MA | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
23300 | 23300 | George Tinkham T000283 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 11 | |||||||||||||
23277 | 23277 | Edward Taylor T000072 | rep | CO | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
23196 | 23196 | Milton Romjue R000418 | rep | MO | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
23130 | 23130 | James Mead M000615 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 42 | |||||||||||||
23066 | 23066 | George Johnson J000132 | rep | WV | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
22947 | 22947 | Frank Crowther C000948 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 30 | |||||||||||||
22932 | 22932 | Ross Collins C000642 | rep | MS | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
22807 | 22807 | James Taylor T000083 | rep | TN | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
22795 | 22795 | Christopher Sullivan S001051 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 13 | |||||||||||||
22766 | 22766 | George Seger S000228 | rep | NJ | 1923-12-03 | 1925-03-03 | Republican | 7 | |||||||||||||
22759 | 22759 | John Schafer S000111 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
22723 | 22723 | Samuel McReynolds M000598 | rep | TN | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
22706 | 22706 | Clarence McLeod M000557 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 13 | |||||||||||||
22679 | 22679 | Carl Mapes M000119 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
22666 | 22666 | Robert Luce L000498 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 13 | |||||||||||||
22640 | 22640 | John Jones J000236 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 18 | |||||||||||||
22614 | 22614 | Thomas Goldsborough G000265 | rep | MD | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
22606 | 22606 | Ernest Gibson G000158 | rep | VT | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
22575 | 22575 | Cassius Dowell D000468 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 7 | |||||||||||||
22553 | 22553 | George Darrow D000063 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 7 | |||||||||||||
22491 | 22491 | William Bankhead B000113 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 10 | |||||||||||||
22468 | 22468 | Alva Adams A000028 | sen | CO | 1923-12-03 | 1925-03-03 | 3 | Democrat | appointment | ||||||||||||
22450 | 22450 | Frederick Vinson V000106 | rep | KY | 1923-12-03 | 1925-03-03 | Democrat | 9 | |||||||||||||
22420 | 22420 | Bertrand Snell S000652 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 31 | |||||||||||||
22410 | 22410 | Morris Sheppard S000337 | sen | TX | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
22394 | 22394 | George Schneider S000137 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 9 | |||||||||||||
22386 | 22386 | Morgan Sanders S000037 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
22344 | 22344 | John O’Connor O000030 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 16 | |||||||||||||
22336 | 22336 | George Norris N000139 | sen | NE | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
22321 | 22321 | Andrew Montague M000861 | rep | VA | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
22222 | 22222 | Byron Harrison H000265 | sen | MS | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
22194 | 22194 | Arthur Greenwood G000437 | rep | IN | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
22169 | 22169 | Allard Gasque G000092 | rep | SC | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
22161 | 22161 | Stephen Gambrill G000035 | rep | MD | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
22118 | 22118 | William Driver D000503 | rep | AR | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
22095 | 22095 | William Connery C000694 | rep | MA | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
22083 | 22083 | James Byrnes B001215 | rep | SC | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
22067 | 22067 | James Buchanan B001006 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 10 | |||||||||||||
22054 | 22054 | John Boylan B000726 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 15 | |||||||||||||
22049 | 22049 | William Borah B000634 | sen | ID | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
22027 | 22027 | Robert Bacon B000019 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
22001 | 22001 | Riley Wilson W000608 | rep | LA | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
21987 | 21987 | Mell Underwood U000012 | rep | OH | 1923-12-03 | 1925-03-03 | Democrat | 11 | |||||||||||||
21964 | 21964 | William Sears S000211 | rep | FL | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
21952 | 21952 | John Sandlin S000043 | rep | LA | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
21943 | 21943 | William Rogers R000408 | rep | NH | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
21934 | 21934 | Harry Ransley R000061 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
21920 | 21920 | Randolph Perkins P000237 | rep | NJ | 1923-12-03 | 1925-03-03 | Republican | 6 | |||||||||||||
21912 | 21912 | Tilman Parks P000075 | rep | AR | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
21904 | 21904 | William Oliver O000077 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
21883 | 21883 | Schuyler Merritt M000663 | rep | CT | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
21873 | 21873 | John McSwain M000604 | rep | SC | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
21865 | 21865 | John McDuffie M000427 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 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);