legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
495 rows where "start" is on date 1939-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22955 | 22955 | Frank Crowther C000948 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 30 | |||||||||||||
23391 | 23391 | Francis Culkin C000968 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 32 | |||||||||||||
23404 | 23404 | Thomas Cullen C000970 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
22541 | 22541 | Fred Cummings C000985 | rep | CO | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
22544 | 22544 | Edward Curley C000995 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 22 | |||||||||||||
30264 | 30264 | Carl Curtis C001006 | rep | NE | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
24334 | 24334 | Thomas D’Alesandro D000007 | rep | MD | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
22547 | 22547 | John Daly D000014 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
22548 | 22548 | John Danaher D000025 | sen | CT | 1939-01-03 | 1945-01-03 | 3 | Republican | |||||||||||||
22959 | 22959 | Colgate Darden D000050 | rep | VA | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
22560 | 22560 | George Darrow D000063 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 7 | |||||||||||||
27723 | 27723 | Clifford Davis D000094 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
22563 | 22563 | James Davis D000111 | sen | PA | 1939-01-03 | 1945-01-03 | 3 | Republican | |||||||||||||
24344 | 24344 | John Delaney D000212 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
26290 | 26290 | John Dempsey D000228 | rep | NM | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
22570 | 22570 | René De Rouen D000265 | rep | LA | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
23834 | 23834 | Samuel Dickstein D000335 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 12 | |||||||||||||
26304 | 26304 | Martin Dies D000338 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
23415 | 23415 | Anthony Dimond D000353 | rep | AK | 1939-01-03 | 1941-01-03 | Democrat | 0 | |||||||||||||
25914 | 25914 | John Dingell D000354 | rep | MI | 1939-01-03 | 1941-01-03 | Democrat | 15 | |||||||||||||
27745 | 27745 | Everett Dirksen D000360 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 16 | |||||||||||||
23422 | 23422 | Wesley Disney D000362 | rep | OK | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
23428 | 23428 | John Ditter D000363 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 17 | |||||||||||||
25932 | 25932 | George Dondero D000411 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 17 | |||||||||||||
25227 | 25227 | Robert Doughton D000448 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
23432 | 23432 | Fred Douglas D000453 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 33 | |||||||||||||
22582 | 22582 | Cassius Dowell D000468 | rep | IA | 1939-01-03 | 1941-01-03 | Republican | 6 | |||||||||||||
23840 | 23840 | Sheridan Downey D000469 | sen | CA | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
22968 | 22968 | Wall Doxey D000480 | rep | MS | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
24364 | 24364 | Patrick Drewry D000496 | rep | VA | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
22973 | 22973 | Richard Duncan D000536 | rep | MO | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
22586 | 22586 | Matthew Dunn D000551 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 34 | |||||||||||||
26826 | 26826 | Carl Durham D000571 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
27185 | 27185 | Henry Dworshak D000585 | rep | ID | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
25242 | 25242 | Charles Eaton E000023 | rep | NJ | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
22587 | 22587 | Thomas Eaton E000026 | rep | CA | 1939-01-03 | 1941-01-03 | Republican | 18 | |||||||||||||
26311 | 26311 | Herman Eberharter E000029 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 32 | |||||||||||||
22975 | 22975 | Morris Edelstein E000041 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 14 | |||||||||||||
22980 | 22980 | Andrew Edmiston E000051 | rep | WV | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
23436 | 23436 | Joaquin Elizalde E000108 | rep | PI | 1939-01-03 | 1941-01-03 | 0 | ||||||||||||||
24371 | 24371 | Alfred Elliott E000119 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 10 | |||||||||||||
22983 | 22983 | Clyde Ellis E000132 | rep | AR | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
25249 | 25249 | Charles Elston E000160 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
24824 | 24824 | Albert Engel E000178 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 9 | |||||||||||||
23448 | 23448 | Harry Englebright E000182 | rep | CA | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
22590 | 22590 | Marcellus Evans E000253 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
22988 | 22988 | Charles Faddis F000001 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 25 | |||||||||||||
23451 | 23451 | James Fay F000051 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 16 | |||||||||||||
27192 | 27192 | Ivor Fenton F000075 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 13 | |||||||||||||
22593 | 22593 | Phillip Ferguson F000082 | rep | OK | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
22598 | 22598 | Joachim Fernández F000086 | rep | LA | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
23463 | 23463 | Hamilton Fish F000142 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 26 | |||||||||||||
23472 | 23472 | James Fitzpatrick F000175 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 24 | |||||||||||||
22993 | 22993 | Thomas Flaherty F000183 | rep | MA | 1939-01-03 | 1941-01-03 | Democrat | 11 | |||||||||||||
24385 | 24385 | John Flannagan F000191 | rep | VA | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
22996 | 22996 | John Flannery F000192 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 12 | |||||||||||||
22998 | 22998 | Alonzo Folger F000240 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
23002 | 23002 | Aaron Ford F000258 | rep | MS | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
23004 | 23004 | Leland Ford F000264 | rep | CA | 1939-01-03 | 1941-01-03 | Republican | 16 | |||||||||||||
23478 | 23478 | Thomas Ford F000267 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 14 | |||||||||||||
22600 | 22600 | Frank Fries F000385 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 21 | |||||||||||||
23490 | 23490 | Hampton Fulmer F000417 | rep | SC | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
25967 | 25967 | Ralph Gamble G000031 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 25 | |||||||||||||
22602 | 22602 | Clyde Garrett G000080 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 17 | |||||||||||||
22603 | 22603 | Fred Gartner G000087 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
28845 | 28845 | Ezekiel Gathings G000098 | rep | AR | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
23502 | 23502 | Joseph Gavagan G000101 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 21 | |||||||||||||
24403 | 24403 | Bertrand Gearhart G000111 | rep | CA | 1939-01-03 | 1941-01-03 | Republican | 9 | |||||||||||||
23008 | 23008 | Bernard Gehrmann G000118 | rep | WI | 1939-01-03 | 1941-01-03 | Progressive | 10 | |||||||||||||
25269 | 25269 | Walter George G000131 | sen | GA | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
24408 | 24408 | Charles Gerlach G000135 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 9 | |||||||||||||
23015 | 23015 | Lee Geyer G000147 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 17 | |||||||||||||
22604 | 22604 | Florence Gibbs G000155 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
22605 | 22605 | Willis Gibbs G000156 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
22612 | 22612 | Ernest Gibson G000158 | sen | VT | 1939-01-03 | 1941-01-03 | 3 | Republican | |||||||||||||
24422 | 24422 | Charles Gifford G000169 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 15 | |||||||||||||
23509 | 23509 | Fred Gilchrist G000181 | rep | IA | 1939-01-03 | 1941-01-03 | Republican | 8 | |||||||||||||
24834 | 24834 | Guy Gillette G000205 | sen | IA | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
24427 | 24427 | George Gillie G000207 | rep | IN | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
22622 | 22622 | Thomas Goldsborough G000265 | rep | MD | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
22623 | 22623 | Robert Goodwin G000303 | rep | IA | 1939-01-03 | 1941-01-03 | Republican | 6 | |||||||||||||
28425 | 28425 | Albert Gore G000320 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
25278 | 25278 | Ed Gossett G000338 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 13 | |||||||||||||
25682 | 25682 | Louis Graham G000360 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 26 | |||||||||||||
27817 | 27817 | George Grant G000381 | rep | AL | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
24433 | 24433 | Robert Grant G000384 | rep | IN | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
23533 | 23533 | Robert Green G000415 | rep | FL | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
26335 | 26335 | Noble Gregory G000447 | rep | KY | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
22625 | 22625 | John Griffith G000469 | rep | LA | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
22626 | 22626 | Harry Griswold G000484 | rep | WI | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
24441 | 24441 | Chester Gross G000493 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 22 | |||||||||||||
23853 | 23853 | John Gurney G000532 | sen | SD | 1939-01-03 | 1945-01-03 | 3 | Republican | |||||||||||||
23543 | 23543 | Ulysses Guyer G000538 | rep | KS | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
24447 | 24447 | John Gwynne G000543 | rep | IA | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
25292 | 25292 | Edwin Hall H000050 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 34 | |||||||||||||
25299 | 25299 | Leonard Hall H000060 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
28862 | 28862 | Charles Halleck H000081 | rep | IN | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
23861 | 23861 | Clarence Hancock H000146 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 35 | |||||||||||||
23869 | 23869 | Butler Hare H000200 | rep | SC | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
24455 | 24455 | Forest Harness H000217 | rep | IN | 1939-01-03 | 1941-01-03 | Republican | 5 |
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);