legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
480 rows where "start" is on date 1935-01-03 sorted by district descending
This data as json, copyable, CSV (advanced)
Suggested facets: party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26958 | 26958 | Daniel Reed R000113 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 43 | |||||||||||||
23136 | 23136 | James Mead M000615 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 42 | |||||||||||||
22868 | 22868 | Alfred Beiter B000320 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 41 | |||||||||||||
24254 | 24254 | Walter Andrews A000250 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 40 | |||||||||||||
25051 | 25051 | James Wadsworth W000012 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 39 | |||||||||||||
21750 | 21750 | James Duffy D000519 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 38 | |||||||||||||
26238 | 26238 | William Cole C000617 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 37 | |||||||||||||
27555 | 27555 | John Taber T000001 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 36 | |||||||||||||
23859 | 23859 | Clarence Hancock H000146 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 35 | |||||||||||||
22584 | 22584 | Matthew Dunn D000551 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 34 | |||||||||||||
22661 | 22661 | Bert Lord L000439 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 34 | |||||||||||||
21970 | 21970 | Frederick Sisson S000455 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 33 | |||||||||||||
22132 | 22132 | Henry Ellenbogen E000111 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 33 | |||||||||||||
21899 | 21899 | Theodore Moritz M000962 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 32 | |||||||||||||
23389 | 23389 | Francis Culkin C000968 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 32 | |||||||||||||
22374 | 22374 | James Quinn Q000017 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 31 | |||||||||||||
22426 | 22426 | Bertrand Snell S000652 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 31 | |||||||||||||
21656 | 21656 | Joshua Brooks B000882 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 30 | |||||||||||||
22953 | 22953 | Frank Crowther C000948 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 30 | |||||||||||||
21973 | 21973 | William Thomas T000187 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 29 | |||||||||||||
22104 | 22104 | Charles Crosby C000928 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 29 | |||||||||||||
21642 | 21642 | William Berlin B000409 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 28 | |||||||||||||
21730 | 21730 | Parker Corning C000785 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 28 | |||||||||||||
22183 | 22183 | Philip Goodwin G000302 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 27 | |||||||||||||
22192 | 22192 | Joseph Gray G000399 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 27 | |||||||||||||
22126 | 22126 | Charles Eckert E000032 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 26 | |||||||||||||
23461 | 23461 | Hamilton Fish F000142 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 26 | |||||||||||||
22306 | 22306 | Charles Millard M000709 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 25 | |||||||||||||
22651 | 22651 | Kent Keller K000056 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 25 | |||||||||||||
22986 | 22986 | Charles Faddis F000001 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 25 | |||||||||||||
22745 | 22745 | Claude Parsons P000086 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 24 | |||||||||||||
23470 | 23470 | James Fitzpatrick F000175 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 24 | |||||||||||||
24099 | 24099 | John Snyder S000668 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 24 | |||||||||||||
21621 | 21621 | William Arnold A000300 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 23 | |||||||||||||
22180 | 22180 | Don Gingery G000224 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 23 | |||||||||||||
27663 | 27663 | Charles Buckley B001024 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 23 | |||||||||||||
21789 | 21789 | Anthony Griffin G000457 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 22 | |||||||||||||
22505 | 22505 | Chester Bolton B000606 | rep | OH | 1935-01-03 | 1937-01-03 | Republican | 22 | |||||||||||||
22542 | 22542 | Edward Curley C000995 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 22 | |||||||||||||
23021 | 23021 | Harry Haines H000026 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 22 | |||||||||||||
23217 | 23217 | Edwin Schaefer S000110 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 22 | |||||||||||||
21862 | 21862 | Harry Mason M000214 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 21 | |||||||||||||
23253 | 23253 | Charles South S000683 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 21 | |||||||||||||
23500 | 23500 | Joseph Gavagan G000101 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 21 | |||||||||||||
25648 | 25648 | Robert Crosser C000932 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 21 | |||||||||||||
28233 | 28233 | Francis Walter W000108 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 21 | |||||||||||||
21669 | 21669 | George Burnham B001124 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 20 | |||||||||||||
21747 | 21747 | Denis Driscoll D000501 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 20 | |||||||||||||
22291 | 22291 | Fontaine Maverick M000263 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 20 | |||||||||||||
23266 | 23266 | Martin Sweeney S001102 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 20 | |||||||||||||
23961 | 23961 | Scott Lucas L000493 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 20 | |||||||||||||
24911 | 24911 | Vito Marcantonio M000122 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 20 | |||||||||||||
21705 | 21705 | Samuel Collins C000643 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 19 | |||||||||||||
21720 | 21720 | John Cooper C000757 | rep | OH | 1935-01-03 | 1937-01-03 | Republican | 19 | |||||||||||||
21740 | 21740 | Donald Dobbins D000382 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 19 | |||||||||||||
21746 | 21746 | Isaac Doutrich D000460 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 19 | |||||||||||||
24765 | 24765 | Sol Bloom B000565 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 19 | |||||||||||||
31621 | 31621 | George Mahon M000065 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 19 | |||||||||||||
22151 | 22151 | Benjamin Focht F000230 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 18 | |||||||||||||
22302 | 22302 | James Meeks M000631 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 18 | |||||||||||||
22402 | 22402 | Byron Scott S000165 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 18 | |||||||||||||
22646 | 22646 | John Jones J000236 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 18 | |||||||||||||
23052 | 23052 | Lawrence Imhoff I000010 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 18 | |||||||||||||
23559 | 23559 | Martin Kennedy K000111 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 18 | |||||||||||||
21652 | 21652 | Thomas Blanton B000549 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 17 | |||||||||||||
22093 | 22093 | Charles Colden C000605 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 17 | |||||||||||||
22371 | 22371 | Theodore Peyser P000281 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 17 | |||||||||||||
22483 | 22483 | William Ashbrook A000306 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 17 | |||||||||||||
23426 | 23426 | John Ditter D000363 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 17 | |||||||||||||
25930 | 25930 | George Dondero D000411 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 17 | |||||||||||||
30138 | 30138 | Leslie Arends A000216 | rep | IL | 1935-01-03 | 1937-01-03 | Republican | 17 | |||||||||||||
22112 | 22112 | John Dockweiler D000387 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 16 | |||||||||||||
22350 | 22350 | John O’Connor O000030 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 16 | |||||||||||||
24145 | 24145 | William Thom T000155 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 16 | |||||||||||||
24694 | 24694 | Robert Thomason T000189 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 16 | |||||||||||||
24890 | 24890 | John Lesinski L000251 | rep | MI | 1935-01-03 | 1937-01-03 | Democrat | 16 | |||||||||||||
25004 | 25004 | Robert Rich R000209 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 16 | |||||||||||||
27743 | 27743 | Everett Dirksen D000360 | rep | IL | 1935-01-03 | 1937-01-03 | Republican | 16 | |||||||||||||
21606 | 21606 | Jackson Adair A000025 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
21738 | 21738 | Charles Dietrich D000340 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
22060 | 22060 | John Boylan B000726 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
23375 | 23375 | John Costello C000795 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
24420 | 24420 | Charles Gifford G000169 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 15 | |||||||||||||
24713 | 24713 | Milton West W000304 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
25912 | 25912 | John Dingell D000354 | rep | MI | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
28644 | 28644 | Robert Secrest S000219 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
21942 | 21942 | William Richardson R000230 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 14 | |||||||||||||
22439 | 22439 | Chester Thompson T000197 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 14 | |||||||||||||
22779 | 22779 | William Sirovich S000452 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 14 | |||||||||||||
23028 | 23028 | Dow Harter H000294 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 14 | |||||||||||||
23476 | 23476 | Thomas Ford F000267 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 14 | |||||||||||||
23566 | 23566 | Richard Kleberg K000257 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 14 | |||||||||||||
25696 | 25696 | Edward Hart H000284 | rep | NJ | 1935-01-03 | 1937-01-03 | Democrat | 14 | |||||||||||||
27416 | 27416 | Louis Rabaut R000001 | rep | MI | 1935-01-03 | 1937-01-03 | Democrat | 14 | |||||||||||||
28534 | 28534 | Joseph Martin M000191 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 14 | |||||||||||||
21764 | 21764 | William Fiesinger F000114 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 13 | |||||||||||||
22178 | 22178 | James Gildea G000182 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 13 | |||||||||||||
22294 | 22294 | William McFarlane M000440 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 13 | |||||||||||||
22712 | 22712 | Clarence McLeod M000557 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 13 | |||||||||||||
22801 | 22801 | Christopher Sullivan S001051 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 13 |
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);