legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
492 rows where "start" is on date 1941-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25206 | 25206 | Fred Crawford C000889 | rep | MI | 1941-01-03 | 1943-01-03 | Republican | 8 | |||||||||||||
23383 | 23383 | Edward Creal C000898 | rep | KY | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
25651 | 25651 | Robert Crosser C000932 | rep | OH | 1941-01-03 | 1943-01-03 | Democrat | 21 | |||||||||||||
22956 | 22956 | Frank Crowther C000948 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 30 | |||||||||||||
23392 | 23392 | Francis Culkin C000968 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 32 | |||||||||||||
23405 | 23405 | Thomas Cullen C000970 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
26274 | 26274 | Paul Cunningham C000993 | rep | IA | 1941-01-03 | 1943-01-03 | Republican | 6 | |||||||||||||
30265 | 30265 | Carl Curtis C001006 | rep | NE | 1941-01-03 | 1943-01-03 | Republican | 4 | |||||||||||||
24335 | 24335 | Thomas D’Alesandro D000007 | rep | MD | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
22960 | 22960 | Colgate Darden D000050 | rep | VA | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
27724 | 27724 | Clifford Davis D000094 | rep | TN | 1941-01-03 | 1943-01-03 | Democrat | 9 | |||||||||||||
22961 | 22961 | Jacob Davis D000108 | rep | OH | 1941-01-03 | 1943-01-03 | Democrat | 6 | |||||||||||||
23407 | 23407 | Stephen Day D000160 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 0 | |||||||||||||
24345 | 24345 | John Delaney D000212 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 7 | |||||||||||||
23409 | 23409 | Charles Dewey D000292 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 9 | |||||||||||||
23835 | 23835 | Samuel Dickstein D000335 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 12 | |||||||||||||
26305 | 26305 | Martin Dies D000338 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
23416 | 23416 | Anthony Dimond D000353 | rep | AK | 1941-01-03 | 1943-01-03 | Democrat | 0 | |||||||||||||
25915 | 25915 | John Dingell D000354 | rep | MI | 1941-01-03 | 1943-01-03 | Democrat | 15 | |||||||||||||
27746 | 27746 | Everett Dirksen D000360 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 16 | |||||||||||||
23423 | 23423 | Wesley Disney D000362 | rep | OK | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
23429 | 23429 | John Ditter D000363 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 17 | |||||||||||||
24350 | 24350 | James Domengeaux D000406 | rep | LA | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
25933 | 25933 | George Dondero D000411 | rep | MI | 1941-01-03 | 1943-01-03 | Republican | 17 | |||||||||||||
25228 | 25228 | Robert Doughton D000448 | rep | NC | 1941-01-03 | 1943-01-03 | Democrat | 9 | |||||||||||||
23433 | 23433 | Fred Douglas D000453 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 33 | |||||||||||||
22962 | 22962 | Le Downs D000475 | rep | CT | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
22969 | 22969 | Wall Doxey D000480 | sen | MS | 1941-01-03 | 1943-01-03 | 2 | Democrat | |||||||||||||
24365 | 24365 | Patrick Drewry D000496 | rep | VA | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
22974 | 22974 | Richard Duncan D000536 | rep | MO | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
26827 | 26827 | Carl Durham D000571 | rep | NC | 1941-01-03 | 1943-01-03 | Democrat | 6 | |||||||||||||
27186 | 27186 | Henry Dworshak D000585 | rep | ID | 1941-01-03 | 1943-01-03 | Republican | 2 | |||||||||||||
25243 | 25243 | Charles Eaton E000023 | rep | NJ | 1941-01-03 | 1943-01-03 | Republican | 5 | |||||||||||||
26312 | 26312 | Herman Eberharter E000029 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 32 | |||||||||||||
22976 | 22976 | Morris Edelstein E000041 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 14 | |||||||||||||
22981 | 22981 | Andrew Edmiston E000051 | rep | WV | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
22982 | 22982 | Thomas Eliot E000107 | rep | MA | 1941-01-03 | 1943-01-03 | Democrat | 9 | |||||||||||||
23437 | 23437 | Joaquin Elizalde E000108 | rep | PI | 1941-01-03 | 1943-01-03 | 0 | ||||||||||||||
24372 | 24372 | Alfred Elliott E000119 | rep | CA | 1941-01-03 | 1943-01-03 | Democrat | 10 | |||||||||||||
22984 | 22984 | Clyde Ellis E000132 | rep | AR | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
25250 | 25250 | Charles Elston E000160 | rep | OH | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
24825 | 24825 | Albert Engel E000178 | rep | MI | 1941-01-03 | 1943-01-03 | Republican | 9 | |||||||||||||
23449 | 23449 | Harry Englebright E000182 | rep | CA | 1941-01-03 | 1943-01-03 | Republican | 2 | |||||||||||||
22989 | 22989 | Charles Faddis F000001 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 25 | |||||||||||||
25256 | 25256 | Frank Fellows F000066 | rep | ME | 1941-01-03 | 1943-01-03 | Republican | 3 | |||||||||||||
27193 | 27193 | Ivor Fenton F000075 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 13 | |||||||||||||
23464 | 23464 | Hamilton Fish F000142 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 26 | |||||||||||||
22991 | 22991 | William Fitzgerald F000169 | rep | CT | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
23473 | 23473 | James Fitzpatrick F000175 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 24 | |||||||||||||
22994 | 22994 | Thomas Flaherty F000183 | rep | MA | 1941-01-03 | 1943-01-03 | Democrat | 11 | |||||||||||||
24386 | 24386 | John Flannagan F000191 | rep | VA | 1941-01-03 | 1943-01-03 | Democrat | 9 | |||||||||||||
22997 | 22997 | John Flannery F000192 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 12 | |||||||||||||
28830 | 28830 | John Fogarty F000233 | rep | RI | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
22999 | 22999 | Alonzo Folger F000240 | rep | NC | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
24391 | 24391 | John Folger F000241 | rep | NC | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
26850 | 26850 | Aime Forand F000255 | rep | RI | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
23003 | 23003 | Aaron Ford F000258 | rep | MS | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
23005 | 23005 | Leland Ford F000264 | rep | CA | 1941-01-03 | 1943-01-03 | Republican | 16 | |||||||||||||
23479 | 23479 | Thomas Ford F000267 | rep | CA | 1941-01-03 | 1943-01-03 | Democrat | 14 | |||||||||||||
23491 | 23491 | Hampton Fulmer F000417 | rep | SC | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
23495 | 23495 | Richard Gale G000014 | rep | MN | 1941-01-03 | 1943-01-03 | Republican | 3 | |||||||||||||
25968 | 25968 | Ralph Gamble G000031 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 25 | |||||||||||||
28846 | 28846 | Ezekiel Gathings G000098 | rep | AR | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
23503 | 23503 | Joseph Gavagan G000101 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 21 | |||||||||||||
24404 | 24404 | Bertrand Gearhart G000111 | rep | CA | 1941-01-03 | 1943-01-03 | Republican | 9 | |||||||||||||
23009 | 23009 | Bernard Gehrmann G000118 | rep | WI | 1941-01-03 | 1943-01-03 | Progressive | 10 | |||||||||||||
24409 | 24409 | Charles Gerlach G000135 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 9 | |||||||||||||
23014 | 23014 | Peter Gerry G000141 | sen | RI | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
23016 | 23016 | Lee Geyer G000147 | rep | CA | 1941-01-03 | 1943-01-03 | Democrat | 17 | |||||||||||||
23847 | 23847 | John Gibson G000163 | rep | GA | 1941-01-03 | 1943-01-03 | Democrat | 8 | |||||||||||||
24423 | 24423 | Charles Gifford G000169 | rep | MA | 1941-01-03 | 1943-01-03 | Republican | 15 | |||||||||||||
23510 | 23510 | Fred Gilchrist G000181 | rep | IA | 1941-01-03 | 1943-01-03 | Republican | 8 | |||||||||||||
25272 | 25272 | Wilson Gillette G000206 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 15 | |||||||||||||
24428 | 24428 | George Gillie G000207 | rep | IN | 1941-01-03 | 1943-01-03 | Republican | 4 | |||||||||||||
28426 | 28426 | Albert Gore G000320 | rep | TN | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
25279 | 25279 | Ed Gossett G000338 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 13 | |||||||||||||
25683 | 25683 | Louis Graham G000360 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 26 | |||||||||||||
25285 | 25285 | Walter Granger G000379 | rep | UT | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
27818 | 27818 | George Grant G000381 | rep | AL | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
24434 | 24434 | Robert Grant G000384 | rep | IN | 1941-01-03 | 1943-01-03 | Republican | 3 | |||||||||||||
23534 | 23534 | Robert Green G000415 | rep | FL | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
26336 | 26336 | Noble Gregory G000447 | rep | KY | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
23018 | 23018 | Joseph Guffey G000519 | sen | PA | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
23544 | 23544 | Ulysses Guyer G000538 | rep | KS | 1941-01-03 | 1943-01-03 | Republican | 2 | |||||||||||||
24448 | 24448 | John Gwynne G000543 | rep | IA | 1941-01-03 | 1943-01-03 | Republican | 3 | |||||||||||||
23023 | 23023 | Harry Haines H000026 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 22 | |||||||||||||
25293 | 25293 | Edwin Hall H000050 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 34 | |||||||||||||
25300 | 25300 | Leonard Hall H000060 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
28863 | 28863 | Charles Halleck H000081 | rep | IN | 1941-01-03 | 1943-01-03 | Republican | 2 | |||||||||||||
23862 | 23862 | Clarence Hancock H000146 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 35 | |||||||||||||
23870 | 23870 | Butler Hare H000200 | rep | SC | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
24456 | 24456 | Forest Harness H000217 | rep | IN | 1941-01-03 | 1943-01-03 | Republican | 5 | |||||||||||||
23026 | 23026 | Vincent Harrington H000231 | rep | IA | 1941-01-03 | 1943-01-03 | Democrat | 9 | |||||||||||||
28447 | 28447 | Oren Harris H000249 | rep | AR | 1941-01-03 | 1943-01-03 | Democrat | 7 | |||||||||||||
23546 | 23546 | Winder Harris H000260 | rep | VA | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
25699 | 25699 | Edward Hart H000284 | rep | NJ | 1941-01-03 | 1943-01-03 | Democrat | 14 | |||||||||||||
23031 | 23031 | Dow Harter H000294 | rep | OH | 1941-01-03 | 1943-01-03 | Democrat | 14 | |||||||||||||
24466 | 24466 | Fred Hartley H000298 | rep | NJ | 1941-01-03 | 1943-01-03 | Republican | 10 | |||||||||||||
23036 | 23036 | Arthur Healey H000423 | rep | MA | 1941-01-03 | 1943-01-03 | Democrat | 8 | |||||||||||||
31035 | 31035 | Felix Hébert H000437 | rep | LA | 1941-01-03 | 1943-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);