legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
499 rows where "start" is on date 1929-04-15 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22769 | 22769 | George Seger S000228 | rep | NJ | 1929-04-15 | 1931-03-03 | Republican | 7 | |||||||||||||
22762 | 22762 | John Schafer S000111 | rep | WI | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
22742 | 22742 | Claude Parsons P000086 | rep | IL | 1929-04-15 | 1931-03-03 | Democrat | 24 | |||||||||||||
22726 | 22726 | Samuel McReynolds M000598 | rep | TN | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
22717 | 22717 | Thomas McMillan M000572 | rep | SC | 1929-04-15 | 1931-03-03 | Democrat | 1 | |||||||||||||
22709 | 22709 | Clarence McLeod M000557 | rep | MI | 1929-04-15 | 1931-03-03 | Republican | 13 | |||||||||||||
22682 | 22682 | Carl Mapes M000119 | rep | MI | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
22669 | 22669 | Robert Luce L000498 | rep | MA | 1929-04-15 | 1931-03-03 | Republican | 13 | |||||||||||||
22643 | 22643 | John Jones J000236 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 18 | |||||||||||||
22617 | 22617 | Thomas Goldsborough G000265 | rep | MD | 1929-04-15 | 1931-03-03 | Democrat | 1 | |||||||||||||
22609 | 22609 | Ernest Gibson G000158 | rep | VT | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
22578 | 22578 | Cassius Dowell D000468 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 7 | |||||||||||||
22565 | 22565 | René De Rouen D000265 | rep | LA | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
22556 | 22556 | George Darrow D000063 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 7 | |||||||||||||
22502 | 22502 | Chester Bolton B000606 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 22 | |||||||||||||
22494 | 22494 | William Bankhead B000113 | rep | AL | 1929-04-15 | 1931-03-03 | Democrat | 10 | |||||||||||||
22443 | 22443 | Lloyd Thurston T000257 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 8 | |||||||||||||
22423 | 22423 | Bertrand Snell S000652 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 31 | |||||||||||||
22397 | 22397 | George Schneider S000137 | rep | WI | 1929-04-15 | 1931-03-03 | Republican | 9 | |||||||||||||
22389 | 22389 | Morgan Sanders S000037 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
22378 | 22378 | Michael Reilly R000155 | rep | WI | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
22357 | 22357 | Vincent Palmisano P000046 | rep | MD | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
22347 | 22347 | John O’Connor O000030 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 16 | |||||||||||||
22324 | 22324 | Andrew Montague M000861 | rep | VA | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
22251 | 22251 | Paul Kvale K000350 | rep | MN | 1929-04-15 | 1931-03-03 | Farmer-Labor | 7 | |||||||||||||
22209 | 22209 | Franklin Hancock H000147 | rep | NC | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
22197 | 22197 | Arthur Greenwood G000437 | rep | IN | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
22172 | 22172 | Allard Gasque G000092 | rep | SC | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
22164 | 22164 | Stephen Gambrill G000035 | rep | MD | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
22156 | 22156 | Claude Fuller F000408 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
22121 | 22121 | William Driver D000503 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 1 | |||||||||||||
22098 | 22098 | William Connery C000694 | rep | MA | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
22070 | 22070 | James Buchanan B001006 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 10 | |||||||||||||
22057 | 22057 | John Boylan B000726 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 15 | |||||||||||||
22030 | 22030 | Robert Bacon B000019 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
22004 | 22004 | Riley Wilson W000608 | rep | LA | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
21990 | 21990 | Mell Underwood U000012 | rep | OH | 1929-04-15 | 1931-03-03 | Democrat | 11 | |||||||||||||
21983 | 21983 | Charles Turpin T000433 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 12 | |||||||||||||
21979 | 21979 | Park Trammell T000353 | sen | FL | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
21975 | 21975 | John Townsend T000335 | sen | DE | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
21955 | 21955 | John Sandlin S000043 | rep | LA | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
21937 | 21937 | Harry Ransley R000061 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
21930 | 21930 | Key Pittman P000372 | sen | NV | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
21923 | 21923 | Randolph Perkins P000237 | rep | NJ | 1929-04-15 | 1931-03-03 | Republican | 6 | |||||||||||||
21915 | 21915 | Tilman Parks P000075 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
21907 | 21907 | William Oliver O000077 | rep | AL | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
21892 | 21892 | Numa Montet M000862 | rep | LA | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
21886 | 21886 | Schuyler Merritt M000663 | rep | CT | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
21876 | 21876 | John McSwain M000604 | rep | SC | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
21868 | 21868 | John McDuffie M000427 | rep | AL | 1929-04-15 | 1931-03-03 | Democrat | 1 | |||||||||||||
21853 | 21853 | Frederick Lehlbach L000222 | rep | NJ | 1929-04-15 | 1931-03-03 | Republican | 10 | |||||||||||||
21844 | 21844 | William King K000216 | sen | UT | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
21835 | 21835 | Florence Kahn K000002 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
21825 | 21825 | George Huddleston H000903 | rep | AL | 1929-04-15 | 1931-03-03 | Democrat | 9 | |||||||||||||
21808 | 21808 | Samuel Hill H000607 | rep | WA | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
21799 | 21799 | Frederick Hale H000031 | sen | ME | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
21793 | 21793 | Pedro Guevara G000518 | rep | PI | 1929-04-15 | 1931-03-03 | 0 | ||||||||||||||
21786 | 21786 | Anthony Griffin G000457 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 22 | |||||||||||||
21776 | 21776 | William Gregory G000448 | rep | KY | 1929-04-15 | 1931-03-03 | Democrat | 1 | |||||||||||||
21769 | 21769 | William Granfield G000372 | rep | MA | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
21766 | 21766 | Lynn Frazier F000354 | sen | ND | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
21743 | 21743 | Isaac Doutrich D000460 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 19 | |||||||||||||
21731 | 21731 | Oliver Cross C000931 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 11 | |||||||||||||
21727 | 21727 | Parker Corning C000785 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 28 | |||||||||||||
21722 | 21722 | Royal Copeland C000769 | sen | NY | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
21717 | 21717 | John Cooper C000757 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 19 | |||||||||||||
21706 | 21706 | Francis Condon C000673 | rep | RI | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
21680 | 21680 | Joseph Byrns B001217 | rep | TN | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
21662 | 21662 | John Buckbee B001020 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 12 | |||||||||||||
21657 | 21657 | William Brunner B000981 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
21649 | 21649 | Thomas Blanton B000549 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 17 | |||||||||||||
21636 | 21636 | Isaac Bacharach B000009 | rep | NJ | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
21625 | 21625 | Henry Ashurst A000319 | sen | AZ | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
21618 | 21618 | William Arnold A000300 | rep | IL | 1929-04-15 | 1931-03-03 | Democrat | 23 | |||||||||||||
21611 | 21611 | Abram Andrew A000240 | rep | MA | 1929-04-15 | 1931-03-03 | Republican | 6 | |||||||||||||
21600 | 21600 | James Whitley W000420 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 38 | |||||||||||||
21594 | 21594 | Henry Watson W000201 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 9 | |||||||||||||
21579 | 21579 | Jesse Swick S001114 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 26 | |||||||||||||
21567 | 21567 | Nathan Strong S001015 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 27 | |||||||||||||
21554 | 21554 | Gale Stalker S000783 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 37 | |||||||||||||
21548 | 21548 | James Sinclair S000442 | rep | ND | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
21529 | 21529 | Frank Reid R000145 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 11 | |||||||||||||
21523 | 21523 | Henry Rainey R000014 | rep | IL | 1929-04-15 | 1931-03-03 | Democrat | 20 | |||||||||||||
21508 | 21508 | Heartsill Ragon R000009 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
21502 | 21502 | Anning Prall P000495 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 11 | |||||||||||||
21496 | 21496 | Edward Pou P000474 | rep | NC | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
21478 | 21478 | Hubert Peavey P000174 | rep | WI | 1929-04-15 | 1931-03-03 | Republican | 11 | |||||||||||||
21472 | 21472 | James Parker P000062 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 29 | |||||||||||||
21459 | 21459 | Camilo Osias O000118 | rep | PI | 1929-04-15 | 1931-03-03 | 0 | ||||||||||||||
21456 | 21456 | Frank Oliver O000072 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 23 | |||||||||||||
21441 | 21441 | John Morehead M000939 | rep | NE | 1929-04-15 | 1931-03-03 | Democrat | 1 | |||||||||||||
21435 | 21435 | Jacob Milligan M000766 | rep | MO | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
21428 | 21428 | Thomas McKeown M000511 | rep | OK | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
21416 | 21416 | Louis McFadden M000434 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 15 | |||||||||||||
21406 | 21406 | James McClintic M000338 | rep | OK | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
21387 | 21387 | Ralph Lozier L000489 | rep | MO | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
21376 | 21376 | George Lindsay L000325 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
21368 | 21368 | Jacob Kurtz K000344 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 21 | |||||||||||||
21362 | 21362 | Bolivar Kemp K000085 | rep | LA | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
21357 | 21357 | Melville Kelly K000076 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 33 |
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);