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 legislator_id descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24725 | 24725 | Orville Zimmerman Z000009 | rep | MO | 1943-01-06 | 1945-01-03 | Democrat | 10 | |||||||||||||
23760 | 23760 | James Wright W000762 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 32 | |||||||||||||
25102 | 25102 | Francis Worley W000744 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 18 | |||||||||||||
24227 | 24227 | Clifton Woodrum W000720 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
25564 | 25564 | Roy Woodruff W000718 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 10 | |||||||||||||
26683 | 26683 | Charles Wolverton W000683 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
24215 | 24215 | James Wolfenden W000678 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
26142 | 26142 | Jesse Wolcott W000668 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 7 | |||||||||||||
24205 | 24205 | Thomas Winter W000645 | rep | KS | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
28283 | 28283 | William Winstead W000641 | rep | MS | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
23758 | 23758 | George Wilson W000581 | sen | IA | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
28273 | 28273 | Earl Wilson W000572 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 9 | |||||||||||||
23757 | 23757 | Earle Willey W000483 | rep | DE | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
26659 | 26659 | Richard Wigglesworth W000450 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 13 | |||||||||||||
28264 | 28264 | Victor Wickersham W000439 | rep | OK | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
25094 | 25094 | William Whittington W000430 | rep | MS | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
35643 | 35643 | Jamie Whitten W000428 | rep | MS | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23756 | 23756 | Wallace White W000396 | sen | ME | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
25082 | 25082 | Compton White W000361 | rep | ID | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
25074 | 25074 | Kenneth Wherry W000344 | sen | NE | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
23746 | 23746 | Benjamin Whelchel W000343 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 9 | |||||||||||||
23741 | 23741 | William Wheat W000327 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 19 | |||||||||||||
24717 | 24717 | Milton West W000304 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 15 | |||||||||||||
23738 | 23738 | Elmer Wene W000294 | rep | NJ | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
25070 | 25070 | Richard Welch W000265 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
24201 | 24201 | Samuel Weiss W000257 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 30 | |||||||||||||
25827 | 25827 | Alvin Weichel W000252 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 13 | |||||||||||||
24198 | 24198 | Zebulon Weaver W000230 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 12 | |||||||||||||
24184 | 24184 | Thaddeus Wasielewski W000183 | rep | WI | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
23735 | 23735 | David Ward W000130 | rep | MD | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
28237 | 28237 | Francis Walter W000108 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 21 | |||||||||||||
25055 | 25055 | James Wadsworth W000012 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 39 | |||||||||||||
26643 | 26643 | Charles Vursell V000125 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 23 | |||||||||||||
26635 | 26635 | John Vorys V000119 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 12 | |||||||||||||
24177 | 24177 | Horace Voorhis V000118 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 12 | |||||||||||||
28218 | 28218 | Carl Vinson V000105 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
23731 | 23731 | Beverly Vincent V000100 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
27575 | 27575 | James Van Zandt V000069 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 23 | |||||||||||||
23727 | 23727 | William Troutman T000384 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
23726 | 23726 | Allen Treadway T000358 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
25526 | 25526 | Harry Towe T000320 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 9 | |||||||||||||
24164 | 24164 | James Torrens T000315 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 21 | |||||||||||||
24162 | 24162 | John Tolan T000295 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
24703 | 24703 | Harve Tibbott T000263 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 27 | |||||||||||||
24698 | 24698 | Robert Thomason T000189 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 16 | |||||||||||||
25044 | 25044 | John Thomas T000175 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 7 | |||||||||||||
23710 | 23710 | John Thomas T000172 | sen | ID | 1943-01-06 | 1945-12-31 | 2 | Republican | |||||||||||||
28680 | 28680 | Albert Thomas T000156 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
27021 | 27021 | Dean Taylor T000070 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 29 | |||||||||||||
24141 | 24141 | Malcolm Tarver T000045 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
26624 | 26624 | Henry Talle T000028 | rep | IA | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
24131 | 24131 | Joseph Talbot T000018 | rep | CT | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
27559 | 27559 | John Taber T000001 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 36 | |||||||||||||
24689 | 24689 | Frank Sundstrom S001076 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 11 | |||||||||||||
24128 | 24128 | Hatton Sumners S001072 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
24111 | 24111 | Jessie Sumner S001071 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 18 | |||||||||||||
23707 | 23707 | Maurice Sullivan S001058 | rep | NV | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
25506 | 25506 | Lowell Stockman S000936 | rep | OR | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
25501 | 25501 | William Stigler S000923 | rep | OK | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
24107 | 24107 | Paul Stewart S000918 | rep | OK | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
23706 | 23706 | Arthur Stewart S000901 | sen | TN | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
24684 | 24684 | William Stevenson S000896 | rep | WI | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
25496 | 25496 | Karl Stefan S000845 | rep | NE | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
23704 | 23704 | Foster Stearns S000823 | rep | NH | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
23701 | 23701 | Henry Steagall S000820 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
23686 | 23686 | Joe Starnes S000816 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
23681 | 23681 | Winifred Stanley S000798 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
24680 | 24680 | Raymond Springer S000755 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 10 | |||||||||||||
27539 | 27539 | Brent Spence S000717 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
30697 | 30697 | John Sparkman S000701 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
25036 | 25036 | Andrew Somers S000676 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
24103 | 24103 | John Snyder S000668 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 24 | |||||||||||||
29042 | 29042 | Margaret Smith S000590 | rep | ME | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
26612 | 26612 | Lawrence Smith S000585 | rep | WI | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
23680 | 23680 | Joseph Smith S000580 | rep | WV | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
28663 | 28663 | Howard Smith S000554 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
25023 | 25023 | Frederick Smith S000536 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
24096 | 24096 | Roger Slaughter S000481 | rep | MO | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
26603 | 26603 | Sidney Simpson S000437 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 20 | |||||||||||||
27005 | 27005 | Richard Simpson S000436 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 18 | |||||||||||||
31801 | 31801 | Robert Sikes S000406 | rep | FL | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
26121 | 26121 | Dewey Short S000377 | rep | MO | 1943-01-06 | 1945-01-03 | Republican | 7 | |||||||||||||
24094 | 24094 | John Sheridan S000342 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
28142 | 28142 | Harry Sheppard S000335 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 21 | |||||||||||||
25802 | 25802 | Paul Shafer S000277 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
26579 | 26579 | Errett Scrivner S000194 | rep | KS | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
30072 | 30072 | Hugh Scott S000174 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 7 | |||||||||||||
24672 | 24672 | Max Schwabe S000156 | rep | MO | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
23672 | 23672 | Leonard Schuetz S000144 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
23665 | 23665 | Andrew Schiffler S000126 | rep | WV | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
23663 | 23663 | Thomas Scanlon S000105 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 16 | |||||||||||||
23661 | 23661 | Harry Sauthoff S000079 | rep | WI | 1943-01-06 | 1945-01-03 | Progressive | 2 | |||||||||||||
24088 | 24088 | Dave Satterfield S000069 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
25479 | 25479 | Lansdale Sasscer S000067 | rep | MD | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
25014 | 25014 | George Sadowski S000011 | rep | MI | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
25472 | 25472 | Adolph Sabath S000001 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
24082 | 24082 | Sam Russell R000538 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 17 | |||||||||||||
29026 | 29026 | Richard Russell R000536 | sen | GA | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
23657 | 23657 | Edmund Rowe R000475 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 14 | |||||||||||||
24079 | 24079 | William Rowan R000473 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 2 |
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);