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 state
This data as json, copyable, CSV (advanced)
end (date) 7 ✖
- 1945-01-03 456
- 1949-01-03 24
- 1945-12-31 2
- 1947-01-03 2
- 1944-02-25 1
- 1946-05-28 1
- 1948-09-27 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23417 | 23417 | Anthony Dimond D000353 | rep | AK | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
23348 | 23348 | John Bankhead B000111 | sen | AL | 1943-01-06 | 1947-01-03 | 2 | Democrat | |||||||||||||
23627 | 23627 | John Newsome N000073 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 9 | |||||||||||||
23686 | 23686 | Joe Starnes S000816 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
23701 | 23701 | Henry Steagall S000820 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
24484 | 24484 | Peterson Jarman J000058 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
24574 | 24574 | Carter Manasco M000094 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
24850 | 24850 | Samuel Hobbs H000663 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
27114 | 27114 | Frank Boykin B000725 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
27819 | 27819 | George Grant G000381 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
29544 | 29544 | George Andrews A000206 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
30697 | 30697 | John Sparkman S000701 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
24330 | 24330 | William Cravens C000887 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
26370 | 26370 | Lawrence Hays H000405 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
27400 | 27400 | William Norrell N000137 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
28448 | 28448 | Oren Harris H000249 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
28847 | 28847 | Ezekiel Gathings G000098 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
29280 | 29280 | James Fulbright F000401 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
30565 | 30565 | John McClellan M000332 | sen | AR | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
31183 | 31183 | Wilbur Mills M000778 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
24452 | 24452 | Richard Harless H000212 | rep | AZ | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
25397 | 25397 | John Murdock M001081 | rep | AZ | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
23371 | 23371 | Albert Carter C000195 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
23379 | 23379 | John Costello C000795 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 15 | |||||||||||||
23450 | 23450 | Harry Englebright E000182 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
23480 | 23480 | Thomas Ford F000267 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 14 | |||||||||||||
23555 | 23555 | William Johnson J000183 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 18 | |||||||||||||
23654 | 23654 | William Rogers R000406 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 16 | |||||||||||||
23656 | 23656 | Thomas Rolph R000413 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
23899 | 23899 | Edouard Izac I000052 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 23 | |||||||||||||
24017 | 24017 | George Outland O000137 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 11 | |||||||||||||
24162 | 24162 | John Tolan T000295 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
24177 | 24177 | Horace Voorhis V000118 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 12 | |||||||||||||
24373 | 24373 | Alfred Elliott E000119 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 10 | |||||||||||||
24405 | 24405 | Bertrand Gearhart G000111 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 9 | |||||||||||||
24548 | 24548 | Clarence Lea L000163 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
25070 | 25070 | Richard Welch W000265 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
25122 | 25122 | John Anderson A000196 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
25778 | 25778 | C. Poulson P000475 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 13 | |||||||||||||
25996 | 25996 | John Hinshaw H000640 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 20 | |||||||||||||
26022 | 26022 | Justin Johnson J000157 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
26078 | 26078 | John Phillips P000309 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 22 | |||||||||||||
26838 | 26838 | Clair Engle E000181 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
28142 | 28142 | Harry Sheppard S000335 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 21 | |||||||||||||
28943 | 28943 | Cecil King K000196 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 17 | |||||||||||||
30481 | 30481 | Chester Holifield H000713 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 19 | |||||||||||||
23584 | 23584 | Lawrence Lewis L000291 | rep | CO | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
23850 | 23850 | Dean Gillespie G000194 | rep | CO | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
24665 | 24665 | Robert Rockwell R000369 | rep | CO | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
24866 | 24866 | Edwin Johnson J000127 | sen | CO | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
26391 | 26391 | William Hill H000613 | rep | CO | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
27711 | 27711 | John Chenoweth C000346 | rep | CO | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
23374 | 23374 | C. Compton C000661 | rep | CT | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
23612 | 23612 | John McWilliams M000611 | rep | CT | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
23622 | 23622 | Boleslaus Monkiewicz M000855 | rep | CT | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
23965 | 23965 | Clare Luce L000497 | rep | CT | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
24131 | 24131 | Joseph Talbot T000018 | rep | CT | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
24617 | 24617 | William Miller M000764 | rep | CT | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
23351 | 23351 | Clayton Buck B001013 | sen | DE | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
23757 | 23757 | Earle Willey W000483 | rep | DE | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
23535 | 23535 | Robert Green G000415 | rep | FL | 1943-01-06 | 1945-01-03 | Democrat | -1 | |||||||||||||
23800 | 23800 | Arthur Cannon C000115 | rep | FL | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24473 | 24473 | Joseph Hendricks H000492 | rep | FL | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
24632 | 24632 | Emory Price P000524 | rep | FL | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
24977 | 24977 | James Peterson P000261 | rep | FL | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
31801 | 31801 | Robert Sikes S000406 | rep | FL | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
23746 | 23746 | Benjamin Whelchel W000343 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 9 | |||||||||||||
23848 | 23848 | John Gibson G000163 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
24032 | 24032 | Hugh Peterson P000260 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
24058 | 24058 | Robert Ramspeck R000032 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
24141 | 24141 | Malcolm Tarver T000045 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
24968 | 24968 | Stephen Pace P000002 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
25198 | 25198 | Edward Cox C000831 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
25626 | 25626 | Albert Camp C000070 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
26753 | 26753 | Paul Brown B000940 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 10 | |||||||||||||
28218 | 28218 | Carl Vinson V000105 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
29026 | 29026 | Richard Russell R000536 | sen | GA | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
25664 | 25664 | Joseph Farrington F000034 | rep | HI | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
23511 | 23511 | Fred Gilchrist G000181 | rep | IA | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
23758 | 23758 | George Wilson W000581 | sen | IA | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
24449 | 24449 | John Gwynne G000543 | rep | IA | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
26050 | 26050 | Thomas Martin M000199 | rep | IA | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
26275 | 26275 | Paul Cunningham C000993 | rep | IA | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
26484 | 26484 | Karl Le Compte L000157 | rep | IA | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
26624 | 26624 | Henry Talle T000028 | rep | IA | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
27885 | 27885 | Charles Hoeven H000678 | rep | IA | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
27917 | 27917 | Benton Jensen J000100 | rep | IA | 1943-01-06 | 1945-01-03 | Republican | 7 | |||||||||||||
23710 | 23710 | John Thomas T000172 | sen | ID | 1943-01-06 | 1945-12-31 | 2 | Republican | |||||||||||||
25082 | 25082 | Compton White W000361 | rep | ID | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
27187 | 27187 | Henry Dworshak D000585 | rep | ID | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
23350 | 23350 | Charles Brooks B000874 | sen | IL | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
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 | |||||||||||||
23553 | 23553 | Calvin Johnson J000121 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 22 | |||||||||||||
23672 | 23672 | Leonard Schuetz S000144 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
23741 | 23741 | William Wheat W000327 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 19 | |||||||||||||
23876 | 23876 | James Heidinger H000450 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 24 | |||||||||||||
24079 | 24079 | William Rowan R000473 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
24111 | 24111 | Jessie Sumner S001071 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 18 | |||||||||||||
24477 | 24477 | George Howell H000863 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 21 |
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);