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 party descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, end, party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23345 | 23345 | Joseph Ball B000099 | sen | MN | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
23350 | 23350 | Charles Brooks B000874 | sen | IL | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
23351 | 23351 | Clayton Buck B001013 | sen | DE | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
23353 | 23353 | Harlan Bushfield B001168 | sen | SD | 1943-01-06 | 1948-09-27 | 2 | Republican | |||||||||||||
23360 | 23360 | Arthur Capper C000133 | sen | KS | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
23361 | 23361 | Chester Carrier C000181 | rep | KY | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
23371 | 23371 | Albert Carter C000195 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
23374 | 23374 | C. Compton C000661 | rep | CT | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
23393 | 23393 | Francis Culkin C000968 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 32 | |||||||||||||
23408 | 23408 | Stephen Day D000160 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
23410 | 23410 | Charles Dewey D000292 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 9 | |||||||||||||
23430 | 23430 | John Ditter D000363 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 17 | |||||||||||||
23434 | 23434 | Fred Douglas D000453 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 33 | |||||||||||||
23439 | 23439 | Daniel Ellison E000141 | rep | MD | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
23440 | 23440 | William Elmer E000157 | rep | MO | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
23450 | 23450 | Harry Englebright E000182 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
23465 | 23465 | Hamilton Fish F000142 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 26 | |||||||||||||
23496 | 23496 | Richard Gale G000014 | rep | MN | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
23511 | 23511 | Fred Gilchrist G000181 | rep | IA | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
23545 | 23545 | Ulysses Guyer G000538 | rep | KS | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
23551 | 23551 | Albert Hawkes H000365 | sen | NJ | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
23552 | 23552 | Harry Jeffrey J000073 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
23553 | 23553 | Calvin Johnson J000121 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 22 | |||||||||||||
23555 | 23555 | William Johnson J000183 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 18 | |||||||||||||
23578 | 23578 | William Lambertson L000037 | rep | KS | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
23592 | 23592 | Melvin Maas M000001 | rep | MN | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
23603 | 23603 | Donald McLean M000545 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
23611 | 23611 | Charles McNary M000583 | sen | OR | 1943-01-06 | 1944-02-25 | 2 | Republican | |||||||||||||
23612 | 23612 | John McWilliams M000611 | rep | CT | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
23618 | 23618 | Louis Miller M000745 | rep | MO | 1943-01-06 | 1945-01-03 | Republican | 11 | |||||||||||||
23620 | 23620 | Thomas Miller M000756 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 12 | |||||||||||||
23622 | 23622 | Boleslaus Monkiewicz M000855 | rep | CT | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
23623 | 23623 | Edward Moore M000895 | sen | OK | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
23626 | 23626 | Joseph Mruk M001058 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 41 | |||||||||||||
23635 | 23635 | Joseph O’Brien O000014 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 38 | |||||||||||||
23651 | 23651 | Charles Pracht P000494 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
23652 | 23652 | Joseph Pratt P000503 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
23653 | 23653 | Edward Robertson R000320 | sen | WY | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
23656 | 23656 | Thomas Rolph R000413 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
23657 | 23657 | Edmund Rowe R000475 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 14 | |||||||||||||
23665 | 23665 | Andrew Schiffler S000126 | rep | WV | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
23681 | 23681 | Winifred Stanley S000798 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
23704 | 23704 | Foster Stearns S000823 | rep | NH | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
23710 | 23710 | John Thomas T000172 | sen | ID | 1943-01-06 | 1945-12-31 | 2 | Republican | |||||||||||||
23726 | 23726 | Allen Treadway T000358 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
23727 | 23727 | William Troutman T000384 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
23741 | 23741 | William Wheat W000327 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 19 | |||||||||||||
23756 | 23756 | Wallace White W000396 | sen | ME | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
23757 | 23757 | Earle Willey W000483 | rep | DE | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
23758 | 23758 | George Wilson W000581 | sen | IA | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
23768 | 23768 | Joseph Baldwin B000093 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 17 | |||||||||||||
23788 | 23788 | David Brumbaugh B000976 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 23 | |||||||||||||
23850 | 23850 | Dean Gillespie G000194 | rep | CO | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
23863 | 23863 | Clarence Hancock H000146 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 35 | |||||||||||||
23876 | 23876 | James Heidinger H000450 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 24 | |||||||||||||
23888 | 23888 | Pehr Holmes H000741 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
23937 | 23937 | John Kinzer K000231 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 10 | |||||||||||||
23944 | 23944 | Charles La Follette L000003 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
23965 | 23965 | Clare Luce L000497 | rep | CT | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
23998 | 23998 | James Mott M001040 | rep | OR | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
24039 | 24039 | William Pittenger P000371 | rep | MN | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
24047 | 24047 | David Powers P000488 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
24072 | 24072 | Robert Rodgers R000373 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 29 | |||||||||||||
24111 | 24111 | Jessie Sumner S001071 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 18 | |||||||||||||
24131 | 24131 | Joseph Talbot T000018 | rep | CT | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
24205 | 24205 | Thomas Winter W000645 | rep | KS | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
24215 | 24215 | James Wolfenden W000678 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
24258 | 24258 | Walter Andrews A000250 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 40 | |||||||||||||
24261 | 24261 | Samuel Arnold A000296 | rep | MO | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
24272 | 24272 | Marion Bennett B000379 | rep | MO | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
24277 | 24277 | Frederick Bradley B000742 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 11 | |||||||||||||
24287 | 24287 | Ellsworth Buck B001016 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 11 | |||||||||||||
24291 | 24291 | Henderson Carson C000192 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 16 | |||||||||||||
24307 | 24307 | Charles Clason C000473 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
24376 | 24376 | Hubert Ellis E000135 | rep | WV | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
24396 | 24396 | Hadwen Fuller F000404 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 32 | |||||||||||||
24399 | 24399 | James Gallagher G000017 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
24405 | 24405 | Bertrand Gearhart G000111 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 9 | |||||||||||||
24410 | 24410 | Charles Gerlach G000135 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 9 | |||||||||||||
24424 | 24424 | Charles Gifford G000169 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 9 | |||||||||||||
24429 | 24429 | George Gillie G000207 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
24435 | 24435 | Robert Grant G000384 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
24438 | 24438 | Percy Griffiths G000472 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 15 | |||||||||||||
24442 | 24442 | Chester Gross G000493 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 22 | |||||||||||||
24449 | 24449 | John Gwynne G000543 | rep | IA | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
24457 | 24457 | Forest Harness H000217 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
24467 | 24467 | Fred Hartley H000298 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 10 | |||||||||||||
24477 | 24477 | George Howell H000863 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 21 | |||||||||||||
24490 | 24490 | Anton Johnson J000117 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 14 | |||||||||||||
24499 | 24499 | Noble Johnson J000165 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
24505 | 24505 | Robert Jones J000249 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
24510 | 24510 | Bartel Jonkman J000264 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
24527 | 24527 | Harold Knutson K000301 | rep | MN | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
24532 | 24532 | Gerald Landis L000052 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 7 | |||||||||||||
24552 | 24552 | Earl Lewis L000279 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 18 | |||||||||||||
24557 | 24557 | Henry Lodge L000394 | sen | MA | 1943-01-06 | 1945-01-03 | 2 | Republican | |||||||||||||
24595 | 24595 | Edward McCowen M000374 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
24617 | 24617 | William Miller M000764 | rep | CT | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
24622 | 24622 | Fred Norman N000135 | rep | WA | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
24628 | 24628 | Walter Ploeser P000387 | rep | MO | 1943-01-06 | 1945-01-03 | Republican | 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);