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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19989 | 19989 | Leslie Steele S000835 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
19996 | 19996 | Hubert Stephens S000857 | sen | MS | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
19999 | 19999 | George Stobbs S000931 | rep | MA | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20000 | 20000 | Ulysses Stone S000964 | rep | OK | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
20006 | 20006 | Daniel Sutherland S001079 | rep | AK | 1929-04-15 | 1931-03-03 | Republican | 0 | |||||||||||||
20018 | 20018 | Claude Swanson S001094 | sen | VA | 1929-04-15 | 1933-03-03 | 1 | Democrat | |||||||||||||
20024 | 20024 | Charles Thompson T000194 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
20028 | 20028 | Jonathan Wainwright W000023 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 25 | |||||||||||||
20029 | 20029 | Frederic Walcott W000032 | sen | CT | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
20030 | 20030 | Lewis Walker W000063 | rep | KY | 1929-04-15 | 1931-03-03 | Republican | 8 | |||||||||||||
20034 | 20034 | Laurence Watres W000196 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 11 | |||||||||||||
20038 | 20038 | Royal Weller W000277 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | -1 | |||||||||||||
20041 | 20041 | Joseph Whitehead W000400 | rep | VA | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
20049 | 20049 | Thomas Williams W000542 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 24 | |||||||||||||
20058 | 20058 | Otis Wingo W000635 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
20060 | 20060 | John Wolverton W000684 | rep | WV | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
20067 | 20067 | Frederick Zihlman Z000007 | rep | MD | 1929-04-15 | 1931-03-03 | Republican | 6 | |||||||||||||
20078 | 20078 | Ernest Ackerman A000021 | rep | NJ | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
20082 | 20082 | Charles Adkins A000057 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 19 | |||||||||||||
20087 | 20087 | Richard Aldrich A000084 | rep | RI | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20091 | 20091 | John Allen A000131 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 14 | |||||||||||||
20096 | 20096 | Samuel Arentz A000277 | rep | NV | 1929-04-15 | 1931-03-03 | Republican | 0 | |||||||||||||
20106 | 20106 | James Aswell A000321 | rep | LA | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
20110 | 20110 | Carl Bachmann B000012 | rep | WV | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20118 | 20118 | Henry Barbour B000126 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 7 | |||||||||||||
20124 | 20124 | Edward Beers B000312 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 18 | |||||||||||||
20128 | 20128 | Frank Bohn B000596 | rep | MI | 1929-04-15 | 1931-03-03 | Republican | 11 | |||||||||||||
20133 | 20133 | Charles Brand B000766 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 7 | |||||||||||||
20142 | 20142 | Clark Burdick B001075 | rep | RI | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20148 | 20148 | Olger Burtness B001146 | rep | ND | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20151 | 20151 | Robert Butler B001187 | rep | OR | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20155 | 20155 | John Cable C000007 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20157 | 20157 | Ed Campbell C000081 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 11 | |||||||||||||
20165 | 20165 | Guy Campbell C000084 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 36 | |||||||||||||
20170 | 20170 | Harry Canfield C000114 | rep | IN | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
20173 | 20173 | James Chase C000328 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 23 | |||||||||||||
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 | |||||||||||||
20185 | 20185 | Victor Christgau C000378 | rep | MN | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20192 | 20192 | Charles Christopherson C000384 | rep | SD | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20198 | 20198 | Frank Clague C000401 | rep | MN | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20202 | 20202 | Robert Clancy C000412 | rep | MI | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20208 | 20208 | Cyrenus Cole C000608 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
20220 | 20220 | James Collier C000630 | rep | MS | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
20226 | 20226 | Don Colton C000652 | rep | UT | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20228 | 20228 | Edmund Cooke C000730 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 41 | |||||||||||||
20248 | 20248 | Henry Cooper C000752 | rep | WI | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20255 | 20255 | William Coyle C000844 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 30 | |||||||||||||
20258 | 20258 | Joe Crail C000864 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 10 | |||||||||||||
20269 | 20269 | Charles Crisp C000909 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
20279 | 20279 | Frederick Dallinger D000012 | rep | MA | 1929-04-15 | 1931-03-03 | Republican | 8 | |||||||||||||
20283 | 20283 | Frederick Davenport D000070 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 33 | |||||||||||||
20290 | 20290 | Ewin Davis D000098 | rep | TN | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
20298 | 20298 | Lester Dickinson D000323 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 10 | |||||||||||||
20306 | 20306 | Frederick Dominick D000408 | rep | SC | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
20309 | 20309 | Lewis Douglas D000455 | rep | AZ | 1929-04-15 | 1931-03-03 | Democrat | 0 | |||||||||||||
20317 | 20317 | Herbert Drane D000486 | rep | FL | 1929-04-15 | 1931-03-03 | Democrat | 1 | |||||||||||||
20328 | 20328 | Leonidas Dyer D000591 | rep | MO | 1929-04-15 | 1931-03-03 | Republican | 12 | |||||||||||||
20336 | 20336 | Félix Dávila D000090 | rep | PR | 1929-04-15 | 1931-03-03 | Unionist | 0 | |||||||||||||
20338 | 20338 | William Eaton E000027 | rep | CO | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20347 | 20347 | Charles Edwards E000062 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 1 | |||||||||||||
20349 | 20349 | Edmund Erk E000203 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 32 | |||||||||||||
20353 | 20353 | Edward Eslick E000216 | rep | TN | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
20357 | 20357 | Harry Estep E000221 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 35 | |||||||||||||
20366 | 20366 | John Evans E000247 | rep | MT | 1929-04-15 | 1931-03-03 | Democrat | 1 | |||||||||||||
20368 | 20368 | Charles Finley F000130 | rep | KY | 1929-04-15 | 1931-03-03 | Republican | 11 | |||||||||||||
20376 | 20376 | Arthur Free F000359 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 8 | |||||||||||||
20385 | 20385 | Richard Freeman F000366 | rep | CT | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20398 | 20398 | Burton French F000375 | rep | ID | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20406 | 20406 | Milton Garber G000046 | rep | OK | 1929-04-15 | 1931-03-03 | Republican | 8 | |||||||||||||
20414 | 20414 | Daniel Garrett G000081 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
20424 | 20424 | Benjamin Golder G000259 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20428 | 20428 | Godfrey Goodwin G000299 | rep | MN | 1929-04-15 | 1931-03-03 | Republican | 10 | |||||||||||||
20442 | 20442 | George Graham G000354 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20452 | 20452 | Lindley Hadley H000008 | rep | WA | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20456 | 20456 | Fletcher Hale H000030 | rep | NH | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20459 | 20459 | Homer Hall H000053 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 17 | |||||||||||||
20461 | 20461 | Robert Hall H000069 | rep | MS | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
20466 | 20466 | Thomas Hall H000071 | rep | ND | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20473 | 20473 | Guy Hardy H000195 | rep | CO | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
20495 | 20495 | Gilbert Haugen H000350 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20508 | 20508 | Willis Hawley H000379 | rep | OR | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20515 | 20515 | Homer Hoch H000669 | rep | KS | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20519 | 20519 | David Hogg H000702 | rep | IN | 1929-04-15 | 1931-03-03 | Republican | 12 | |||||||||||||
20521 | 20521 | Robert Hogg H000704 | rep | WV | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20526 | 20526 | William Holaday H000708 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 18 | |||||||||||||
20529 | 20529 | David Hopkins H000772 | rep | MO | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20534 | 20534 | Robert Houston H000826 | rep | DE | 1929-04-15 | 1931-03-03 | Republican | 0 | |||||||||||||
20537 | 20537 | Victor Houston H000828 | rep | HI | 1929-04-15 | 1931-03-03 | Republican | -1 | |||||||||||||
20549 | 20549 | Cordell Hull H000940 | rep | TN | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
20572 | 20572 | Albert Johnson J000114 | rep | WA | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
20582 | 20582 | Royal Johnson J000173 | rep | SD | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20586 | 20586 | William Johnson J000181 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 13 | |||||||||||||
20589 | 20589 | Charles Kading K000001 | rep | WI | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20597 | 20597 | Samuel Kendall K000097 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 24 | |||||||||||||
20603 | 20603 | John Ketcham K000151 | rep | MI | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20612 | 20612 | William Kopp K000314 | rep | IA | 1929-04-15 | 1931-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);