legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
488 rows where "end" is on date 1943-01-03 sorted by caucus
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23242 | 23242 | Kenneth Simpson S000433 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 17 | |||||||||||||
23243 | 23243 | Francis Smith S000532 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
23247 | 23247 | John Smith S000572 | rep | CT | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
23252 | 23252 | Martin Smith S000591 | rep | WA | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
23256 | 23256 | Charles South S000683 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 21 | |||||||||||||
23257 | 23257 | George Spencer S000724 | sen | AR | 1941-04-01 | 1943-01-03 | 2 | Democrat | appointment | ||||||||||||
23263 | 23263 | William Sutphin S001086 | rep | NJ | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
23269 | 23269 | Martin Sweeney S001102 | rep | OH | 1941-01-03 | 1943-01-03 | Democrat | 20 | |||||||||||||
23286 | 23286 | Edward Taylor T000072 | rep | CO | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
23288 | 23288 | Rudolph Tenerowicz T000124 | rep | MI | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
23293 | 23293 | David Terry T000133 | rep | AR | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
23295 | 23295 | Lewis Thill T000153 | rep | WI | 1941-01-03 | 1943-01-03 | Republican | 5 | |||||||||||||
23309 | 23309 | George Tinkham T000283 | rep | MA | 1941-01-03 | 1943-01-03 | Republican | 10 | |||||||||||||
23312 | 23312 | Albert Vreeland V000121 | rep | NJ | 1941-01-03 | 1943-01-03 | Republican | 11 | |||||||||||||
23328 | 23328 | Clyde Williams W000494 | rep | MO | 1941-01-03 | 1943-01-03 | Democrat | 8 | |||||||||||||
23331 | 23331 | Oscar Youngdahl Y000059 | rep | MN | 1941-01-03 | 1943-01-03 | Republican | 5 | |||||||||||||
23332 | 23332 | Arthur Nelson N000030 | sen | MN | 1942-01-01 | 1943-01-03 | 2 | Republican | |||||||||||||
23340 | 23340 | Hugh Shott S000381 | sen | WV | 1942-01-01 | 1943-01-03 | 2 | Republican | |||||||||||||
23342 | 23342 | Josiah Bailey B000046 | sen | NC | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
23344 | 23344 | Joseph Ball B000099 | sen | MN | 1940-10-14 | 1943-01-03 | 2 | Republican | appointment | ||||||||||||
23347 | 23347 | John Bankhead B000111 | sen | AL | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
23349 | 23349 | Charles Brooks B000874 | sen | IL | 1940-01-01 | 1943-01-03 | 2 | Republican | |||||||||||||
23354 | 23354 | Louis Capozzoli C000132 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 13 | |||||||||||||
23359 | 23359 | Arthur Capper C000133 | sen | KS | 1937-01-05 | 1943-01-03 | 2 | Republican | |||||||||||||
23370 | 23370 | Albert Carter C000195 | rep | CA | 1941-01-03 | 1943-01-03 | Republican | 6 | |||||||||||||
23372 | 23372 | Albert Chandler C000290 | sen | KY | 1939-10-10 | 1943-01-03 | 2 | Democrat | appointment | ||||||||||||
23378 | 23378 | John Costello C000795 | rep | CA | 1941-01-03 | 1943-01-03 | Democrat | 15 | |||||||||||||
23383 | 23383 | Edward Creal C000898 | rep | KY | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
23392 | 23392 | Francis Culkin C000968 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 32 | |||||||||||||
23405 | 23405 | Thomas Cullen C000970 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
23407 | 23407 | Stephen Day D000160 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 0 | |||||||||||||
23409 | 23409 | Charles Dewey D000292 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 9 | |||||||||||||
23416 | 23416 | Anthony Dimond D000353 | rep | AK | 1941-01-03 | 1943-01-03 | Democrat | 0 | |||||||||||||
23423 | 23423 | Wesley Disney D000362 | rep | OK | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
23429 | 23429 | John Ditter D000363 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 17 | |||||||||||||
23433 | 23433 | Fred Douglas D000453 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 33 | |||||||||||||
23437 | 23437 | Joaquin Elizalde E000108 | rep | PI | 1941-01-03 | 1943-01-03 | 0 | ||||||||||||||
23449 | 23449 | Harry Englebright E000182 | rep | CA | 1941-01-03 | 1943-01-03 | Republican | 2 | |||||||||||||
23464 | 23464 | Hamilton Fish F000142 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 26 | |||||||||||||
23473 | 23473 | James Fitzpatrick F000175 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 24 | |||||||||||||
23479 | 23479 | Thomas Ford F000267 | rep | CA | 1941-01-03 | 1943-01-03 | Democrat | 14 | |||||||||||||
23491 | 23491 | Hampton Fulmer F000417 | rep | SC | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
23495 | 23495 | Richard Gale G000014 | rep | MN | 1941-01-03 | 1943-01-03 | Republican | 3 | |||||||||||||
23503 | 23503 | Joseph Gavagan G000101 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 21 | |||||||||||||
23510 | 23510 | Fred Gilchrist G000181 | rep | IA | 1941-01-03 | 1943-01-03 | Republican | 8 | |||||||||||||
23524 | 23524 | Carter Glass G000232 | sen | VA | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
23534 | 23534 | Robert Green G000415 | rep | FL | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
23544 | 23544 | Ulysses Guyer G000538 | rep | KS | 1941-01-03 | 1943-01-03 | Republican | 2 | |||||||||||||
23546 | 23546 | Winder Harris H000260 | rep | VA | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
23549 | 23549 | Carl Hatch H000334 | sen | NM | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
23554 | 23554 | William Johnson J000183 | rep | CA | 1941-01-03 | 1943-01-03 | Republican | 18 | |||||||||||||
23562 | 23562 | Martin Kennedy K000111 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 18 | |||||||||||||
23569 | 23569 | Richard Kleberg K000257 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 14 | |||||||||||||
23577 | 23577 | William Lambertson L000037 | rep | KS | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
23583 | 23583 | Lawrence Lewis L000291 | rep | CO | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
23591 | 23591 | Melvin Maas M000001 | rep | MN | 1941-01-03 | 1943-01-03 | Republican | 4 | |||||||||||||
23596 | 23596 | James McGranery M000454 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
23602 | 23602 | Donald McLean M000545 | rep | NJ | 1941-01-03 | 1943-01-03 | Republican | 6 | |||||||||||||
23610 | 23610 | Charles McNary M000583 | sen | OR | 1937-01-05 | 1943-01-03 | 2 | Republican | |||||||||||||
23616 | 23616 | Matthew Merritt M000661 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 0 | |||||||||||||
23619 | 23619 | Thomas Miller M000756 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 12 | |||||||||||||
23631 | 23631 | John Nichols N000092 | rep | OK | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
23634 | 23634 | Joseph O’Brien O000014 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 38 | |||||||||||||
23636 | 23636 | Wilbert O’Daniel O000034 | sen | TX | 1941-01-03 | 1943-01-03 | 2 | Democrat | |||||||||||||
23641 | 23641 | James O’Leary O000065 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 11 | |||||||||||||
23644 | 23644 | Bolívar Pagán P000013 | rep | PR | 1941-01-03 | 1943-01-03 | Coalitionist | 0 | |||||||||||||
23649 | 23649 | Nat Patton P000142 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 7 | |||||||||||||
23655 | 23655 | Thomas Rolph R000413 | rep | CA | 1941-01-03 | 1943-01-03 | Republican | 4 | |||||||||||||
23660 | 23660 | Harry Sauthoff S000079 | rep | WI | 1941-01-03 | 1943-01-03 | Progressive | 2 | |||||||||||||
23662 | 23662 | Thomas Scanlon S000105 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 30 | |||||||||||||
23671 | 23671 | Leonard Schuetz S000144 | rep | IL | 1941-01-03 | 1943-01-03 | Democrat | 7 | |||||||||||||
23679 | 23679 | Joseph Smith S000580 | rep | WV | 1941-01-03 | 1943-01-03 | Democrat | 6 | |||||||||||||
23685 | 23685 | Joe Starnes S000816 | rep | AL | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
23700 | 23700 | Henry Steagall S000820 | rep | AL | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
23703 | 23703 | Foster Stearns S000823 | rep | NH | 1941-01-03 | 1943-01-03 | Republican | 2 | |||||||||||||
23705 | 23705 | Arthur Stewart S000901 | sen | TN | 1939-01-03 | 1943-01-03 | 2 | Democrat | |||||||||||||
23709 | 23709 | John Thomas T000172 | sen | ID | 1940-01-27 | 1943-01-03 | 2 | Republican | appointment | ||||||||||||
23725 | 23725 | Allen Treadway T000358 | rep | MA | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
23730 | 23730 | Beverly Vincent V000100 | rep | KY | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
23734 | 23734 | David Ward W000130 | rep | MD | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
23737 | 23737 | Elmer Wene W000294 | rep | NJ | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
23740 | 23740 | William Wheat W000327 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 19 | |||||||||||||
23745 | 23745 | Benjamin Whelchel W000343 | rep | GA | 1941-01-03 | 1943-01-03 | Democrat | 9 | |||||||||||||
23755 | 23755 | Wallace White W000396 | sen | ME | 1937-01-05 | 1943-01-03 | 2 | Republican | |||||||||||||
23759 | 23759 | James Wright W000762 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 34 | |||||||||||||
23767 | 23767 | Joseph Baldwin B000093 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 17 | |||||||||||||
23773 | 23773 | William Barry B000191 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
23779 | 23779 | Lyle Boren B000640 | rep | OK | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
23784 | 23784 | Michael Bradley B000743 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
23794 | 23794 | William Burgin B001084 | rep | NC | 1941-01-03 | 1943-01-03 | Democrat | 8 | |||||||||||||
23799 | 23799 | Arthur Cannon C000115 | rep | FL | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
23811 | 23811 | John Cochran C000565 | rep | MO | 1941-01-03 | 1943-01-03 | Democrat | 13 | |||||||||||||
23816 | 23816 | John Coffee C000584 | rep | WA | 1941-01-03 | 1943-01-03 | Democrat | 6 | |||||||||||||
23835 | 23835 | Samuel Dickstein D000335 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 12 | |||||||||||||
23847 | 23847 | John Gibson G000163 | rep | GA | 1941-01-03 | 1943-01-03 | Democrat | 8 | |||||||||||||
23862 | 23862 | Clarence Hancock H000146 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 35 | |||||||||||||
23870 | 23870 | Butler Hare H000200 | rep | SC | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
23875 | 23875 | James Heidinger H000450 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 24 | |||||||||||||
23887 | 23887 | Pehr Holmes H000741 | rep | MA | 1941-01-03 | 1943-01-03 | Republican | 4 | |||||||||||||
23893 | 23893 | Frank Hook H000757 | rep | MI | 1941-01-03 | 1943-01-03 | Democrat | 12 |
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);