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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24336 | 24336 | Thomas D’Alesandro D000007 | rep | MD | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
23823 | 23823 | Ralph Daughton D000067 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
27725 | 27725 | Clifford Davis D000094 | rep | TN | 1943-01-06 | 1945-01-03 | Democrat | 10 | |||||||||||||
29204 | 29204 | William Dawson D000158 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
23408 | 23408 | Stephen Day D000160 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
24346 | 24346 | John Delaney D000212 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
23410 | 23410 | Charles Dewey D000292 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 9 | |||||||||||||
23836 | 23836 | Samuel Dickstein D000335 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 12 | |||||||||||||
26306 | 26306 | Martin Dies D000338 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23411 | 23411 | LaVern Dilweg D000349 | rep | WI | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
23417 | 23417 | Anthony Dimond D000353 | rep | AK | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
25916 | 25916 | John Dingell D000354 | rep | MI | 1943-01-06 | 1945-01-03 | Democrat | 15 | |||||||||||||
27747 | 27747 | Everett Dirksen D000360 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 16 | |||||||||||||
23424 | 23424 | Wesley Disney D000362 | rep | OK | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
23430 | 23430 | John Ditter D000363 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 17 | |||||||||||||
24351 | 24351 | James Domengeaux D000406 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
25934 | 25934 | George Dondero D000411 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 17 | |||||||||||||
25229 | 25229 | Robert Doughton D000448 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 9 | |||||||||||||
23434 | 23434 | Fred Douglas D000453 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 33 | |||||||||||||
24366 | 24366 | Patrick Drewry D000496 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
26828 | 26828 | Carl Durham D000571 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
27187 | 27187 | Henry Dworshak D000585 | rep | ID | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
30338 | 30338 | James Eastland E000018 | sen | MS | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
25244 | 25244 | Charles Eaton E000023 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
26313 | 26313 | Herman Eberharter E000029 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 31 | |||||||||||||
23438 | 23438 | Joaquin Elizalde E000108 | rep | PI | 1943-01-06 | 1945-01-03 | 0 | ||||||||||||||
28817 | 28817 | Allen Ellender E000112 | sen | LA | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
24373 | 24373 | Alfred Elliott E000119 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 10 | |||||||||||||
24376 | 24376 | Hubert Ellis E000135 | rep | WV | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
23439 | 23439 | Daniel Ellison E000141 | rep | MD | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
25944 | 25944 | Mathew Ellsworth E000146 | rep | OR | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
23440 | 23440 | William Elmer E000157 | rep | MO | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
25251 | 25251 | Charles Elston E000160 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
24826 | 24826 | Albert Engel E000178 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 9 | |||||||||||||
26838 | 26838 | Clair Engle E000181 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23450 | 23450 | Harry Englebright E000182 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
25664 | 25664 | Joseph Farrington F000034 | rep | HI | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
23452 | 23452 | James Fay F000051 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 16 | |||||||||||||
29255 | 29255 | Michael Feighan F000060 | rep | OH | 1943-01-06 | 1945-01-03 | Democrat | 20 | |||||||||||||
25257 | 25257 | Frank Fellows F000066 | rep | ME | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
27194 | 27194 | Ivor Fenton F000075 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 13 | |||||||||||||
24830 | 24830 | Homer Ferguson F000081 | sen | MI | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
25953 | 25953 | Antonio Fernández F000085 | rep | NM | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
23465 | 23465 | Hamilton Fish F000142 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 26 | |||||||||||||
30344 | 30344 | Ovie Fisher F000152 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 21 | |||||||||||||
23474 | 23474 | James Fitzpatrick F000175 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 24 | |||||||||||||
24387 | 24387 | John Flannagan F000191 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 9 | |||||||||||||
28831 | 28831 | John Fogarty F000233 | rep | RI | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
24392 | 24392 | John Folger F000241 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
26851 | 26851 | Aime Forand F000255 | rep | RI | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
23480 | 23480 | Thomas Ford F000267 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 14 | |||||||||||||
29280 | 29280 | James Fulbright F000401 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
24396 | 24396 | Hadwen Fuller F000404 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 32 | |||||||||||||
23492 | 23492 | Hampton Fulmer F000417 | rep | SC | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23493 | 23493 | Willa Fulmer F000418 | rep | SC | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23494 | 23494 | Robert Furlong F000432 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 25 | |||||||||||||
23496 | 23496 | Richard Gale G000014 | rep | MN | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
24399 | 24399 | James Gallagher G000017 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
25969 | 25969 | Ralph Gamble G000031 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 25 | |||||||||||||
28847 | 28847 | Ezekiel Gathings G000098 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
23504 | 23504 | Joseph Gavagan G000101 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 21 | |||||||||||||
27800 | 27800 | Leon Gavin G000102 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 20 | |||||||||||||
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 | |||||||||||||
23848 | 23848 | John Gibson G000163 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
24424 | 24424 | Charles Gifford G000169 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 9 | |||||||||||||
23511 | 23511 | Fred Gilchrist G000181 | rep | IA | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
23850 | 23850 | Dean Gillespie G000194 | rep | CO | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
25273 | 25273 | Wilson Gillette G000206 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 15 | |||||||||||||
24429 | 24429 | George Gillie G000207 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
23525 | 23525 | Carter Glass G000232 | sen | VA | 1943-01-06 | 1946-05-28 | 2 | Democrat | |||||||||||||
25676 | 25676 | Angier Goodwin G000297 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
26326 | 26326 | Thomas Gordon G000316 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
28427 | 28427 | Albert Gore G000320 | rep | TN | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24838 | 24838 | Martin Gorski G000332 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
25280 | 25280 | Ed Gossett G000338 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 13 | |||||||||||||
25684 | 25684 | Louis Graham G000360 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 26 | |||||||||||||
25286 | 25286 | Walter Granger G000379 | rep | UT | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
27819 | 27819 | George Grant G000381 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
24435 | 24435 | Robert Grant G000384 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
23535 | 23535 | Robert Green G000415 | rep | FL | 1943-01-06 | 1945-01-03 | Democrat | -1 | |||||||||||||
25984 | 25984 | Theodore Green G000418 | sen | RI | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
26337 | 26337 | Noble Gregory G000447 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
23545 | 23545 | Ulysses Guyer G000538 | rep | KS | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
24449 | 24449 | John Gwynne G000543 | rep | IA | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
25690 | 25690 | Harold Hagen H000014 | rep | MN | 1943-01-06 | 1945-01-03 | Farmer-Labor | 9 | |||||||||||||
26352 | 26352 | Robert Hale H000036 | rep | ME | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
25294 | 25294 | Edwin Hall H000050 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 34 | |||||||||||||
25301 | 25301 | Leonard Hall H000060 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
28864 | 28864 | Charles Halleck H000081 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
23863 | 23863 | Clarence Hancock H000146 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 35 | |||||||||||||
23871 | 23871 | Butler Hare H000200 | rep | SC | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
24452 | 24452 | Richard Harless H000212 | rep | AZ | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
24457 | 24457 | Forest Harness H000217 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
28448 | 28448 | Oren Harris H000249 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
23547 | 23547 | Winder Harris H000260 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
25700 | 25700 | Edward Hart H000284 | rep | NJ | 1943-01-06 | 1945-01-03 | Democrat | 14 | |||||||||||||
24467 | 24467 | Fred Hartley H000298 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 10 |
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);