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 district descending
This data as json, copyable, CSV (advanced)
Suggested facets: end, class, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26961 | 26961 | Daniel Reed R000113 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 43 | |||||||||||||
23227 | 23227 | Pius Schwert S000162 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 42 | |||||||||||||
25166 | 25166 | John Butler B001179 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 42 | |||||||||||||
22870 | 22870 | Alfred Beiter B000320 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 41 | |||||||||||||
24257 | 24257 | Walter Andrews A000250 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 40 | |||||||||||||
25054 | 25054 | James Wadsworth W000012 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 39 | |||||||||||||
23634 | 23634 | Joseph O’Brien O000014 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 38 | |||||||||||||
26241 | 26241 | William Cole C000617 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 37 | |||||||||||||
27558 | 27558 | John Taber T000001 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 36 | |||||||||||||
23862 | 23862 | Clarence Hancock H000146 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 35 | |||||||||||||
23759 | 23759 | James Wright W000762 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 34 | |||||||||||||
25293 | 25293 | Edwin Hall H000050 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 34 | |||||||||||||
23118 | 23118 | Joseph McArdle M000297 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 33 | |||||||||||||
23433 | 23433 | Fred Douglas D000453 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 33 | |||||||||||||
28905 | 28905 | Elmer Holland H000717 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 33 | |||||||||||||
23392 | 23392 | Francis Culkin C000968 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 32 | |||||||||||||
26312 | 26312 | Herman Eberharter E000029 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 32 | |||||||||||||
24200 | 24200 | Samuel Weiss W000257 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 31 | |||||||||||||
27951 | 27951 | Clarence Kilburn K000170 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 31 | |||||||||||||
22956 | 22956 | Frank Crowther C000948 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 30 | |||||||||||||
23662 | 23662 | Thomas Scanlon S000105 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 30 | |||||||||||||
22919 | 22919 | Ernest Cluett C000535 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 29 | |||||||||||||
24071 | 24071 | Robert Rodgers R000373 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 29 | |||||||||||||
25173 | 25173 | William Byrne B001214 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 28 | |||||||||||||
26455 | 26455 | Augustine Kelley K000058 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 28 | |||||||||||||
23188 | 23188 | Lewis Rockefeller R000362 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 27 | |||||||||||||
24702 | 24702 | Harve Tibbott T000263 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 27 | |||||||||||||
23464 | 23464 | Hamilton Fish F000142 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 26 | |||||||||||||
25683 | 25683 | Louis Graham G000360 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 26 | |||||||||||||
22989 | 22989 | Charles Faddis F000001 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 25 | |||||||||||||
25594 | 25594 | Cecil Bishop B000486 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 25 | |||||||||||||
25968 | 25968 | Ralph Gamble G000031 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 25 | |||||||||||||
23473 | 23473 | James Fitzpatrick F000175 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 24 | |||||||||||||
23875 | 23875 | James Heidinger H000450 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 24 | |||||||||||||
24102 | 24102 | John Snyder S000668 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 24 | |||||||||||||
22851 | 22851 | Laurence Arnold A000290 | rep | IL | 1941-01-03 | 1943-01-03 | Democrat | 23 | |||||||||||||
27574 | 27574 | James Van Zandt V000069 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 23 | |||||||||||||
27666 | 27666 | Charles Buckley B001024 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 23 | |||||||||||||
23023 | 23023 | Harry Haines H000026 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 22 | |||||||||||||
23220 | 23220 | Edwin Schaefer S000110 | rep | IL | 1941-01-03 | 1943-01-03 | Democrat | 22 | |||||||||||||
24904 | 24904 | Walter Lynch L000537 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 22 | |||||||||||||
28788 | 28788 | Frances Bolton B000607 | rep | OH | 1941-01-03 | 1943-01-03 | Republican | 22 | |||||||||||||
23256 | 23256 | Charles South S000683 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 21 | |||||||||||||
23503 | 23503 | Joseph Gavagan G000101 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 21 | |||||||||||||
24476 | 24476 | George Howell H000863 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 21 | |||||||||||||
25651 | 25651 | Robert Crosser C000932 | rep | OH | 1941-01-03 | 1943-01-03 | Democrat | 21 | |||||||||||||
28236 | 28236 | Francis Walter W000108 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 21 | |||||||||||||
22860 | 22860 | James Barnes B000158 | rep | IL | 1941-01-03 | 1943-01-03 | Democrat | 20 | |||||||||||||
23060 | 23060 | Benjamin Jarrett J000060 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 20 | |||||||||||||
23269 | 23269 | Martin Sweeney S001102 | rep | OH | 1941-01-03 | 1943-01-03 | Democrat | 20 | |||||||||||||
23898 | 23898 | Edouard Izac I000052 | rep | CA | 1941-01-03 | 1943-01-03 | Democrat | 20 | |||||||||||||
24913 | 24913 | Vito Marcantonio M000122 | rep | NY | 1941-01-03 | 1943-01-03 | American Labor | 20 | |||||||||||||
27288 | 27288 | Paul Kilday K000171 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 20 | |||||||||||||
23740 | 23740 | William Wheat W000327 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 19 | |||||||||||||
24768 | 24768 | Sol Bloom B000565 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 19 | |||||||||||||
28141 | 28141 | Harry Sheppard S000335 | rep | CA | 1941-01-03 | 1943-01-03 | Democrat | 19 | |||||||||||||
28513 | 28513 | John Kunkel K000341 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 19 | |||||||||||||
29304 | 29304 | Michael Kirwan K000244 | rep | OH | 1941-01-03 | 1943-01-03 | Democrat | 19 | |||||||||||||
31624 | 31624 | George Mahon M000065 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 19 | |||||||||||||
23054 | 23054 | Lawrence Imhoff I000010 | rep | OH | 1941-01-03 | 1943-01-03 | Democrat | 18 | |||||||||||||
23554 | 23554 | William Johnson J000183 | rep | CA | 1941-01-03 | 1943-01-03 | Republican | 18 | |||||||||||||
23562 | 23562 | Martin Kennedy K000111 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 18 | |||||||||||||
24110 | 24110 | Jessie Sumner S001071 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 18 | |||||||||||||
25101 | 25101 | Francis Worley W000744 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 18 | |||||||||||||
27004 | 27004 | Richard Simpson S000436 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 18 | |||||||||||||
23016 | 23016 | Lee Geyer G000147 | rep | CA | 1941-01-03 | 1943-01-03 | Democrat | 17 | |||||||||||||
23242 | 23242 | Kenneth Simpson S000433 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 17 | |||||||||||||
23429 | 23429 | John Ditter D000363 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 17 | |||||||||||||
23767 | 23767 | Joseph Baldwin B000093 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 17 | |||||||||||||
24081 | 24081 | Sam Russell R000538 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 17 | |||||||||||||
25933 | 25933 | George Dondero D000411 | rep | MI | 1941-01-03 | 1943-01-03 | Republican | 17 | |||||||||||||
26505 | 26505 | J. McGregor M000460 | rep | OH | 1941-01-03 | 1943-01-03 | Republican | 17 | |||||||||||||
28942 | 28942 | Cecil King K000196 | rep | CA | 1941-01-03 | 1943-01-03 | Democrat | 17 | |||||||||||||
30141 | 30141 | Leslie Arends A000216 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 17 | |||||||||||||
23005 | 23005 | Leland Ford F000264 | rep | CA | 1941-01-03 | 1943-01-03 | Republican | 16 | |||||||||||||
23175 | 23175 | William Pheiffer P000288 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 16 | |||||||||||||
24147 | 24147 | William Thom T000155 | rep | OH | 1941-01-03 | 1943-01-03 | Democrat | 16 | |||||||||||||
24697 | 24697 | Robert Thomason T000189 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 16 | |||||||||||||
24893 | 24893 | John Lesinski L000251 | rep | MI | 1941-01-03 | 1943-01-03 | Democrat | 16 | |||||||||||||
25007 | 25007 | Robert Rich R000209 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 16 | |||||||||||||
27746 | 27746 | Everett Dirksen D000360 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 16 | |||||||||||||
23078 | 23078 | Michael Kennedy K000112 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 15 | |||||||||||||
23209 | 23209 | Albert Rutherford R000546 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 15 | |||||||||||||
23378 | 23378 | John Costello C000795 | rep | CA | 1941-01-03 | 1943-01-03 | Democrat | 15 | |||||||||||||
24423 | 24423 | Charles Gifford G000169 | rep | MA | 1941-01-03 | 1943-01-03 | Republican | 15 | |||||||||||||
24716 | 24716 | Milton West W000304 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 15 | |||||||||||||
25272 | 25272 | Wilson Gillette G000206 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 15 | |||||||||||||
25915 | 25915 | John Dingell D000354 | rep | MI | 1941-01-03 | 1943-01-03 | Democrat | 15 | |||||||||||||
27143 | 27143 | Robert Chiperfield C000365 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 15 | |||||||||||||
28647 | 28647 | Robert Secrest S000219 | rep | OH | 1941-01-03 | 1943-01-03 | Democrat | 15 | |||||||||||||
22976 | 22976 | Morris Edelstein E000041 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 14 | |||||||||||||
23031 | 23031 | Dow Harter H000294 | rep | OH | 1941-01-03 | 1943-01-03 | Democrat | 14 | |||||||||||||
23149 | 23149 | Guy Moser M001026 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 14 | |||||||||||||
23479 | 23479 | Thomas Ford F000267 | rep | CA | 1941-01-03 | 1943-01-03 | Democrat | 14 | |||||||||||||
23569 | 23569 | Richard Kleberg K000257 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 14 | |||||||||||||
24489 | 24489 | Anton Johnson J000117 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 14 | |||||||||||||
25699 | 25699 | Edward Hart H000284 | rep | NJ | 1941-01-03 | 1943-01-03 | Democrat | 14 | |||||||||||||
26036 | 26036 | Arthur Klein K000261 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 14 | |||||||||||||
27419 | 27419 | Louis Rabaut R000001 | rep | MI | 1941-01-03 | 1943-01-03 | Democrat | 14 | |||||||||||||
28537 | 28537 | Joseph Martin M000191 | rep | MA | 1941-01-03 | 1943-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);