legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
484 rows where "start" is on date 1945-01-03 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24337 | 24337 | Thomas D’Alesandro D000007 | rep | MD | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
23824 | 23824 | Ralph Daughton D000067 | rep | VA | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
27726 | 27726 | Clifford Davis D000094 | rep | TN | 1945-01-03 | 1947-01-03 | Democrat | 10 | |||||||||||||
29205 | 29205 | William Dawson D000158 | rep | IL | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
23825 | 23825 | Emerson De Lacy D000206 | rep | WA | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
31511 | 31511 | James Delaney D000211 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
24347 | 24347 | John Delaney D000212 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 7 | |||||||||||||
25658 | 25658 | Wesley D’Ewart D000281 | rep | MT | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
23837 | 23837 | Samuel Dickstein D000335 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 19 | |||||||||||||
25917 | 25917 | John Dingell D000354 | rep | MI | 1945-01-03 | 1947-01-03 | Democrat | 15 | |||||||||||||
27748 | 27748 | Everett Dirksen D000360 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 16 | |||||||||||||
25923 | 25923 | James Dolliver D000403 | rep | IA | 1945-01-03 | 1947-01-03 | Republican | 6 | |||||||||||||
24352 | 24352 | James Domengeaux D000406 | rep | LA | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
25935 | 25935 | George Dondero D000411 | rep | MI | 1945-01-03 | 1947-01-03 | Republican | 17 | |||||||||||||
23838 | 23838 | Forrest Donnell D000414 | sen | MO | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
25230 | 25230 | Robert Doughton D000448 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 9 | |||||||||||||
23839 | 23839 | Emily Douglas D000452 | rep | IL | 1945-01-03 | 1947-01-03 | Democrat | 0 | |||||||||||||
24818 | 24818 | Helen Douglas D000454 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 14 | |||||||||||||
23841 | 23841 | Sheridan Downey D000469 | sen | CA | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
27753 | 27753 | Clyde Doyle D000481 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 18 | |||||||||||||
24367 | 24367 | Patrick Drewry D000496 | rep | VA | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
26829 | 26829 | Carl Durham D000571 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
23842 | 23842 | Harold Earthman E000016 | rep | TN | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
25245 | 25245 | Charles Eaton E000023 | rep | NJ | 1945-01-03 | 1947-01-03 | Republican | 5 | |||||||||||||
26314 | 26314 | Herman Eberharter E000029 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 32 | |||||||||||||
24374 | 24374 | Alfred Elliott E000119 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 10 | |||||||||||||
24377 | 24377 | Hubert Ellis E000135 | rep | WV | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
25945 | 25945 | Mathew Ellsworth E000146 | rep | OR | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
24379 | 24379 | Edward Elsaesser E000159 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 43 | |||||||||||||
25252 | 25252 | Charles Elston E000160 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 1 | |||||||||||||
24827 | 24827 | Albert Engel E000178 | rep | MI | 1945-01-03 | 1947-01-03 | Republican | 9 | |||||||||||||
26839 | 26839 | Clair Engle E000181 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
23843 | 23843 | Joseph Ervin E000210 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 10 | |||||||||||||
29223 | 29223 | Samuel Ervin E000211 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 10 | |||||||||||||
29235 | 29235 | George Fallon F000012 | rep | MD | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
25665 | 25665 | Joseph Farrington F000034 | rep | HI | 1945-01-03 | 1947-01-03 | Republican | 0 | |||||||||||||
29256 | 29256 | Michael Feighan F000060 | rep | OH | 1945-01-03 | 1947-01-03 | Democrat | 20 | |||||||||||||
25258 | 25258 | Frank Fellows F000066 | rep | ME | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
27195 | 27195 | Ivor Fenton F000075 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 12 | |||||||||||||
25954 | 25954 | Antonio Fernández F000085 | rep | NM | 1945-01-03 | 1947-01-03 | Democrat | 0 | |||||||||||||
27771 | 27771 | Antonio Fernós-Isern F000087 | rep | PR | 1945-01-03 | 1947-01-03 | Popular Democrat | 0 | |||||||||||||
30345 | 30345 | Ovie Fisher F000152 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 21 | |||||||||||||
24388 | 24388 | John Flannagan F000191 | rep | VA | 1945-01-03 | 1947-01-03 | Democrat | 9 | |||||||||||||
32060 | 32060 | Daniel Flood F000209 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 11 | |||||||||||||
28832 | 28832 | John Fogarty F000233 | rep | RI | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
24393 | 24393 | John Folger F000241 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
26852 | 26852 | Aime Forand F000255 | rep | RI | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
29281 | 29281 | James Fulbright F000401 | sen | AR | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
24397 | 24397 | Hadwen Fuller F000404 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 35 | |||||||||||||
29776 | 29776 | James Fulton F000422 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 31 | |||||||||||||
23844 | 23844 | William Gallagher G000019 | rep | MN | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
25970 | 25970 | Ralph Gamble G000031 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 28 | |||||||||||||
23845 | 23845 | Edward Gardner G000051 | rep | OH | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
27790 | 27790 | Julian Gary G000091 | rep | VA | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
28848 | 28848 | Ezekiel Gathings G000098 | rep | AR | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
27801 | 27801 | Leon Gavin G000102 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 19 | |||||||||||||
24406 | 24406 | Bertrand Gearhart G000111 | rep | CA | 1945-01-03 | 1947-01-03 | Republican | 9 | |||||||||||||
23846 | 23846 | James Geelan G000117 | rep | CT | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
25270 | 25270 | Walter George G000131 | sen | GA | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
24411 | 24411 | Charles Gerlach G000135 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 8 | |||||||||||||
23849 | 23849 | John Gibson G000163 | rep | GA | 1945-01-03 | 1947-01-03 | Democrat | 8 | |||||||||||||
24425 | 24425 | Charles Gifford G000169 | rep | MA | 1945-01-03 | 1947-01-03 | Republican | 9 | |||||||||||||
23851 | 23851 | Dean Gillespie G000194 | rep | CO | 1945-01-03 | 1947-01-03 | Republican | 1 | |||||||||||||
25274 | 25274 | Wilson Gillette G000206 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 14 | |||||||||||||
24430 | 24430 | George Gillie G000207 | rep | IN | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
25677 | 25677 | Angier Goodwin G000297 | rep | MA | 1945-01-03 | 1947-01-03 | Republican | 8 | |||||||||||||
26327 | 26327 | Thomas Gordon G000316 | rep | IL | 1945-01-03 | 1947-01-03 | Democrat | 8 | |||||||||||||
28428 | 28428 | Albert Gore G000320 | rep | TN | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
24839 | 24839 | Martin Gorski G000332 | rep | IL | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
25281 | 25281 | Ed Gossett G000338 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 13 | |||||||||||||
25685 | 25685 | Louis Graham G000360 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 25 | |||||||||||||
25978 | 25978 | William Granahan G000369 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
25287 | 25287 | Walter Granger G000379 | rep | UT | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
27820 | 27820 | George Grant G000381 | rep | AL | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
24436 | 24436 | Robert Grant G000384 | rep | IN | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
27830 | 27830 | William Green G000421 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
26338 | 26338 | Noble Gregory G000447 | rep | KY | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
24439 | 24439 | Percy Griffiths G000472 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 15 | |||||||||||||
24443 | 24443 | Chester Gross G000493 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 21 | |||||||||||||
23854 | 23854 | John Gurney G000532 | sen | SD | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
26345 | 26345 | Ralph Gwinn G000541 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 27 | |||||||||||||
24450 | 24450 | John Gwynne G000543 | rep | IA | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
25691 | 25691 | Harold Hagen H000014 | rep | MN | 1945-01-03 | 1947-01-03 | Republican | 9 | |||||||||||||
26353 | 26353 | Robert Hale H000036 | rep | ME | 1945-01-03 | 1947-01-03 | Republican | 1 | |||||||||||||
25295 | 25295 | Edwin Hall H000050 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 37 | |||||||||||||
25302 | 25302 | Leonard Hall H000060 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
28865 | 28865 | Charles Halleck H000081 | rep | IN | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
23864 | 23864 | Clarence Hancock H000146 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 36 | |||||||||||||
25987 | 25987 | Thomas Hand H000154 | rep | NJ | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
23872 | 23872 | Butler Hare H000200 | rep | SC | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
24453 | 24453 | Richard Harless H000212 | rep | AZ | 1945-01-03 | 1947-01-03 | Democrat | 0 | |||||||||||||
24458 | 24458 | Forest Harness H000217 | rep | IN | 1945-01-03 | 1947-01-03 | Republican | 5 | |||||||||||||
28449 | 28449 | Oren Harris H000249 | rep | AR | 1945-01-03 | 1947-01-03 | Democrat | 7 | |||||||||||||
25701 | 25701 | Edward Hart H000284 | rep | NJ | 1945-01-03 | 1947-01-03 | Democrat | 14 | |||||||||||||
24468 | 24468 | Fred Hartley H000298 | rep | NJ | 1945-01-03 | 1947-01-03 | Republican | 10 | |||||||||||||
25308 | 25308 | Franck Havenner H000356 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
27854 | 27854 | Carl Hayden H000385 | sen | AZ | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
26371 | 26371 | Lawrence Hays H000405 | rep | AR | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
23874 | 23874 | Ned Healy H000426 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 13 | |||||||||||||
31037 | 31037 | Felix Hébert H000437 | rep | LA | 1945-01-03 | 1947-01-03 | Democrat | 1 |
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);