legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
487 rows where "start" is on date 1943-01-06 sorted by district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23597 | 23597 | James McGranery M000454 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23612 | 23612 | John McWilliams M000611 | rep | CT | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
23632 | 23632 | John Nichols N000092 | rep | OK | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23652 | 23652 | Joseph Pratt P000503 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
23661 | 23661 | Harry Sauthoff S000079 | rep | WI | 1943-01-06 | 1945-01-03 | Progressive | 2 | |||||||||||||
23704 | 23704 | Foster Stearns S000823 | rep | NH | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
23731 | 23731 | Beverly Vincent V000100 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23738 | 23738 | Elmer Wene W000294 | rep | NJ | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23765 | 23765 | Harry Baldwin B000086 | rep | MD | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23774 | 23774 | William Barry B000191 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23823 | 23823 | Ralph Daughton D000067 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23972 | 23972 | Paul Maloney M000091 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
24009 | 24009 | James O’Connor O000029 | rep | MT | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
24068 | 24068 | James Robinson R000341 | rep | UT | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
24079 | 24079 | William Rowan R000473 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
24307 | 24307 | Charles Clason C000473 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
24632 | 24632 | Emory Price P000524 | rep | FL | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
24672 | 24672 | Max Schwabe S000156 | rep | MO | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
24861 | 24861 | John Jennings J000096 | rep | TN | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
24944 | 24944 | Earl Michener M000693 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
25159 | 25159 | Howard Buffett B001039 | rep | NE | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
25198 | 25198 | Edward Cox C000831 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
25358 | 25358 | John Kerr K000138 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
25501 | 25501 | William Stigler S000923 | rep | OK | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
25506 | 25506 | Lowell Stockman S000936 | rep | OR | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
26217 | 26217 | Francis Case C000221 | rep | SD | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
26306 | 26306 | Martin Dies D000338 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
26391 | 26391 | William Hill H000613 | rep | CO | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
26547 | 26547 | Joseph O’Hara O000056 | rep | MN | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
26579 | 26579 | Errett Scrivner S000194 | rep | KS | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
26624 | 26624 | Henry Talle T000028 | rep | IA | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
26838 | 26838 | Clair Engle E000181 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
26873 | 26873 | William Hess H000550 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
27187 | 27187 | Henry Dworshak D000585 | rep | ID | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
27819 | 27819 | George Grant G000381 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
28831 | 28831 | John Fogarty F000233 | rep | RI | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
28864 | 28864 | Charles Halleck H000081 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
29042 | 29042 | Margaret Smith S000590 | rep | ME | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
31183 | 31183 | Wilbur Mills M000778 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
32246 | 32246 | Jennings Randolph R000046 | rep | WV | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
33000 | 33000 | Henry Jackson J000013 | rep | WA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
35643 | 35643 | Jamie Whitten W000428 | rep | MS | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23374 | 23374 | C. Compton C000661 | rep | CT | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
23496 | 23496 | Richard Gale G000014 | rep | MN | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
23552 | 23552 | Harry Jeffrey J000073 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
23701 | 23701 | Henry Steagall S000820 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
23785 | 23785 | Michael Bradley B000743 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
23871 | 23871 | Butler Hare H000200 | rep | SC | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
24015 | 24015 | Emmet O’Neal O000089 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
24088 | 24088 | Dave Satterfield S000069 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
24107 | 24107 | Paul Stewart S000918 | rep | OK | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
24205 | 24205 | Thomas Winter W000645 | rep | KS | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
24336 | 24336 | Thomas D’Alesandro D000007 | rep | MD | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
24351 | 24351 | James Domengeaux D000406 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
24435 | 24435 | Robert Grant G000384 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
24449 | 24449 | John Gwynne G000543 | rep | IA | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
24622 | 24622 | Fred Norman N000135 | rep | WA | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
24668 | 24668 | Edward Rohrbough R000410 | rep | WV | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
24684 | 24684 | William Stevenson S000896 | rep | WI | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
24968 | 24968 | Stephen Pace P000002 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
24985 | 24985 | Joseph Pfeifer P000285 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
25094 | 25094 | William Whittington W000430 | rep | MS | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
25257 | 25257 | Frank Fellows F000066 | rep | ME | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
25496 | 25496 | Karl Stefan S000845 | rep | NE | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
25579 | 25579 | Homer Angell A000257 | rep | OR | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
25617 | 25617 | Fred Busbey B001161 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
25634 | 25634 | William Cole C000614 | rep | MO | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
25802 | 25802 | Paul Shafer S000277 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
26022 | 26022 | Justin Johnson J000157 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
26712 | 26712 | Graham Barden B000139 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
27278 | 27278 | Carey Kefauver K000044 | rep | TN | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
27608 | 27608 | James Auchincloss A000227 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
27711 | 27711 | John Chenoweth C000346 | rep | CO | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
28319 | 28319 | Lindley Beckworth B000296 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
29280 | 29280 | James Fulbright F000401 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
29406 | 29406 | Philip Philbin P000303 | rep | MA | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
29544 | 29544 | George Andrews A000206 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
31801 | 31801 | Robert Sikes S000406 | rep | FL | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
23361 | 23361 | Chester Carrier C000181 | rep | KY | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
23384 | 23384 | Edward Creal C000898 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
23406 | 23406 | Thomas Cullen C000970 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
23439 | 23439 | Daniel Ellison E000141 | rep | MD | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
23592 | 23592 | Melvin Maas M000001 | rep | MN | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
23656 | 23656 | Thomas Rolph R000413 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
23780 | 23780 | Lyle Boren B000640 | rep | OK | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
23800 | 23800 | Arthur Cannon C000115 | rep | FL | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
23888 | 23888 | Pehr Holmes H000741 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
23965 | 23965 | Clare Luce L000497 | rep | CT | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
24047 | 24047 | David Powers P000488 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
24094 | 24094 | John Sheridan S000342 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24184 | 24184 | Thaddeus Wasielewski W000183 | rep | WI | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24269 | 24269 | Charles Bell B000332 | rep | MO | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24330 | 24330 | William Cravens C000887 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24366 | 24366 | Patrick Drewry D000496 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24376 | 24376 | Hubert Ellis E000135 | rep | WV | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
24429 | 24429 | George Gillie G000207 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
24505 | 24505 | Robert Jones J000249 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
24665 | 24665 | Robert Rockwell R000369 | rep | CO | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
24838 | 24838 | Martin Gorski G000332 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24850 | 24850 | Samuel Hobbs H000663 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 4 |
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);