legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
498 rows where "end" is on date 1941-01-03 sorted by district descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, party, start (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26960 | 26960 | Daniel Reed R000113 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 43 | |||||||||||||
23226 | 23226 | Pius Schwert S000162 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 42 | |||||||||||||
22627 | 22627 | John Harter H000295 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 41 | |||||||||||||
24256 | 24256 | Walter Andrews A000250 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 40 | |||||||||||||
25053 | 25053 | James Wadsworth W000012 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 39 | |||||||||||||
23633 | 23633 | Joseph O’Brien O000014 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 38 | |||||||||||||
26240 | 26240 | William Cole C000617 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 37 | |||||||||||||
27557 | 27557 | John Taber T000001 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 36 | |||||||||||||
23861 | 23861 | Clarence Hancock H000146 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 35 | |||||||||||||
22586 | 22586 | Matthew Dunn D000551 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 34 | |||||||||||||
22663 | 22663 | Bert Lord L000439 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 34 | |||||||||||||
25292 | 25292 | Edwin Hall H000050 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 34 | |||||||||||||
23117 | 23117 | Joseph McArdle M000297 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 33 | |||||||||||||
23432 | 23432 | Fred Douglas D000453 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 33 | |||||||||||||
23391 | 23391 | Francis Culkin C000968 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 32 | |||||||||||||
26311 | 26311 | Herman Eberharter E000029 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 32 | |||||||||||||
22748 | 22748 | Wallace Pierce P000338 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 31 | |||||||||||||
24598 | 24598 | John McDowell M000422 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 31 | |||||||||||||
27950 | 27950 | Clarence Kilburn K000170 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 31 | |||||||||||||
22955 | 22955 | Frank Crowther C000948 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 30 | |||||||||||||
29717 | 29717 | Robert Corbett C000772 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 30 | |||||||||||||
22918 | 22918 | Ernest Cluett C000535 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 29 | |||||||||||||
24070 | 24070 | Robert Rodgers R000373 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 29 | |||||||||||||
22473 | 22473 | Robert Allen A000145 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 28 | |||||||||||||
25172 | 25172 | William Byrne B001214 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 28 | |||||||||||||
23187 | 23187 | Lewis Rockefeller R000362 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 27 | |||||||||||||
24701 | 24701 | Harve Tibbott T000263 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 27 | |||||||||||||
23463 | 23463 | Hamilton Fish F000142 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 26 | |||||||||||||
25682 | 25682 | Louis Graham G000360 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 26 | |||||||||||||
22653 | 22653 | Kent Keller K000056 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 25 | |||||||||||||
22988 | 22988 | Charles Faddis F000001 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 25 | |||||||||||||
25967 | 25967 | Ralph Gamble G000031 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 25 | |||||||||||||
22747 | 22747 | Claude Parsons P000086 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 24 | |||||||||||||
23472 | 23472 | James Fitzpatrick F000175 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 24 | |||||||||||||
24101 | 24101 | John Snyder S000668 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 24 | |||||||||||||
22850 | 22850 | Laurence Arnold A000290 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 23 | |||||||||||||
27573 | 27573 | James Van Zandt V000069 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 23 | |||||||||||||
27665 | 27665 | Charles Buckley B001024 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 23 | |||||||||||||
22506 | 22506 | Chester Bolton B000606 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 22 | |||||||||||||
22544 | 22544 | Edward Curley C000995 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 22 | |||||||||||||
23219 | 23219 | Edwin Schaefer S000110 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 22 | |||||||||||||
24441 | 24441 | Chester Gross G000493 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 22 | |||||||||||||
24903 | 24903 | Walter Lynch L000537 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 22 | |||||||||||||
28787 | 28787 | Frances Bolton B000607 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 22 | |||||||||||||
22600 | 22600 | Frank Fries F000385 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 21 | |||||||||||||
23255 | 23255 | Charles South S000683 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 21 | |||||||||||||
23502 | 23502 | Joseph Gavagan G000101 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 21 | |||||||||||||
25650 | 25650 | Robert Crosser C000932 | rep | OH | 1939-01-03 | 1941-01-03 | Democrat | 21 | |||||||||||||
28235 | 28235 | Francis Walter W000108 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 21 | |||||||||||||
22859 | 22859 | James Barnes B000158 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 20 | |||||||||||||
23059 | 23059 | Benjamin Jarrett J000060 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 20 | |||||||||||||
23268 | 23268 | Martin Sweeney S001102 | rep | OH | 1939-01-03 | 1941-01-03 | Democrat | 20 | |||||||||||||
23897 | 23897 | Edouard Izac I000052 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 20 | |||||||||||||
24912 | 24912 | Vito Marcantonio M000122 | rep | NY | 1939-01-03 | 1941-01-03 | American Labor | 20 | |||||||||||||
27287 | 27287 | Paul Kilday K000171 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 20 | |||||||||||||
23739 | 23739 | William Wheat W000327 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 19 | |||||||||||||
24767 | 24767 | Sol Bloom B000565 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 19 | |||||||||||||
28140 | 28140 | Harry Sheppard S000335 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 19 | |||||||||||||
28512 | 28512 | John Kunkel K000341 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 19 | |||||||||||||
29303 | 29303 | Michael Kirwan K000244 | rep | OH | 1939-01-03 | 1941-01-03 | Democrat | 19 | |||||||||||||
31623 | 31623 | George Mahon M000065 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 19 | |||||||||||||
22587 | 22587 | Thomas Eaton E000026 | rep | CA | 1939-01-03 | 1941-01-03 | Republican | 18 | |||||||||||||
22648 | 22648 | John Jones J000236 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 18 | |||||||||||||
23561 | 23561 | Martin Kennedy K000111 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 18 | |||||||||||||
24109 | 24109 | Jessie Sumner S001071 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 18 | |||||||||||||
24551 | 24551 | Earl Lewis L000279 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 18 | |||||||||||||
27003 | 27003 | Richard Simpson S000436 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 18 | |||||||||||||
22485 | 22485 | William Ashbrook A000306 | rep | OH | 1939-01-03 | 1941-01-03 | Democrat | 17 | |||||||||||||
22501 | 22501 | Bruce Barton B000211 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 17 | |||||||||||||
22602 | 22602 | Clyde Garrett G000080 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 17 | |||||||||||||
23015 | 23015 | Lee Geyer G000147 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 17 | |||||||||||||
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 | |||||||||||||
26504 | 26504 | J. McGregor M000460 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 17 | |||||||||||||
30140 | 30140 | Leslie Arends A000216 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 17 | |||||||||||||
22765 | 22765 | James Seccombe S000218 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 16 | |||||||||||||
23004 | 23004 | Leland Ford F000264 | rep | CA | 1939-01-03 | 1941-01-03 | Republican | 16 | |||||||||||||
23451 | 23451 | James Fay F000051 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 16 | |||||||||||||
24696 | 24696 | Robert Thomason T000189 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 16 | |||||||||||||
24892 | 24892 | John Lesinski L000251 | rep | MI | 1939-01-03 | 1941-01-03 | Democrat | 16 | |||||||||||||
25006 | 25006 | Robert Rich R000209 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 16 | |||||||||||||
27745 | 27745 | Everett Dirksen D000360 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 16 | |||||||||||||
23077 | 23077 | Michael Kennedy K000112 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 15 | |||||||||||||
23208 | 23208 | Albert Rutherford R000546 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 15 | |||||||||||||
23377 | 23377 | John Costello C000795 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 15 | |||||||||||||
24422 | 24422 | Charles Gifford G000169 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 15 | |||||||||||||
24715 | 24715 | Milton West W000304 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 15 | |||||||||||||
25914 | 25914 | John Dingell D000354 | rep | MI | 1939-01-03 | 1941-01-03 | Democrat | 15 | |||||||||||||
27142 | 27142 | Robert Chiperfield C000365 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 15 | |||||||||||||
28646 | 28646 | Robert Secrest S000219 | rep | OH | 1939-01-03 | 1941-01-03 | Democrat | 15 | |||||||||||||
22781 | 22781 | William Sirovich S000452 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 14 | |||||||||||||
22975 | 22975 | Morris Edelstein E000041 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 14 | |||||||||||||
23030 | 23030 | Dow Harter H000294 | rep | OH | 1939-01-03 | 1941-01-03 | Democrat | 14 | |||||||||||||
23148 | 23148 | Guy Moser M001026 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 14 | |||||||||||||
23478 | 23478 | Thomas Ford F000267 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 14 | |||||||||||||
23568 | 23568 | Richard Kleberg K000257 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 14 | |||||||||||||
24488 | 24488 | Anton Johnson J000117 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 14 | |||||||||||||
25698 | 25698 | Edward Hart H000284 | rep | NJ | 1939-01-03 | 1941-01-03 | Democrat | 14 | |||||||||||||
27418 | 27418 | Louis Rabaut R000001 | rep | MI | 1939-01-03 | 1941-01-03 | Democrat | 14 | |||||||||||||
28536 | 28536 | Joseph Martin M000191 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 14 |
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);