legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
483 rows where "start" is on date 1937-01-05 sorted by district descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26959 | 26959 | Daniel Reed R000113 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 43 | |||||||||||||
22869 | 22869 | Alfred Beiter B000320 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 41 | |||||||||||||
24255 | 24255 | Walter Andrews A000250 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 40 | |||||||||||||
25052 | 25052 | James Wadsworth W000012 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 39 | |||||||||||||
22240 | 22240 | George Kelly K000072 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 38 | |||||||||||||
26239 | 26239 | William Cole C000617 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 37 | |||||||||||||
27556 | 27556 | John Taber T000001 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 36 | |||||||||||||
23860 | 23860 | Clarence Hancock H000146 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 35 | |||||||||||||
22585 | 22585 | Matthew Dunn D000551 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 34 | |||||||||||||
22662 | 22662 | Bert Lord L000439 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 34 | |||||||||||||
22133 | 22133 | Henry Ellenbogen E000111 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 33 | |||||||||||||
23431 | 23431 | Fred Douglas D000453 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 33 | |||||||||||||
23390 | 23390 | Francis Culkin C000968 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 32 | |||||||||||||
26310 | 26310 | Herman Eberharter E000029 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 32 | |||||||||||||
22375 | 22375 | James Quinn Q000017 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 31 | |||||||||||||
22427 | 22427 | Bertrand Snell S000652 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 31 | |||||||||||||
22106 | 22106 | Peter De Muth D000225 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 30 | |||||||||||||
22954 | 22954 | Frank Crowther C000948 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 30 | |||||||||||||
22105 | 22105 | Charles Crosby C000928 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 29 | |||||||||||||
22917 | 22917 | Ernest Cluett C000535 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 29 | |||||||||||||
22472 | 22472 | Robert Allen A000145 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 28 | |||||||||||||
25171 | 25171 | William Byrne B001214 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 28 | |||||||||||||
22184 | 22184 | Philip Goodwin G000302 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 27 | |||||||||||||
22193 | 22193 | Joseph Gray G000399 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 27 | |||||||||||||
23186 | 23186 | Lewis Rockefeller R000362 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 27 | |||||||||||||
22127 | 22127 | Charles Eckert E000032 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 26 | |||||||||||||
23462 | 23462 | Hamilton Fish F000142 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 26 | |||||||||||||
22307 | 22307 | Charles Millard M000709 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 25 | |||||||||||||
22652 | 22652 | Kent Keller K000056 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 25 | |||||||||||||
22987 | 22987 | Charles Faddis F000001 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 25 | |||||||||||||
25966 | 25966 | Ralph Gamble G000031 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 25 | |||||||||||||
22746 | 22746 | Claude Parsons P000086 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 24 | |||||||||||||
23471 | 23471 | James Fitzpatrick F000175 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 24 | |||||||||||||
24100 | 24100 | John Snyder S000668 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 24 | |||||||||||||
22181 | 22181 | Don Gingery G000224 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 23 | |||||||||||||
22849 | 22849 | Laurence Arnold A000290 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 23 | |||||||||||||
27664 | 27664 | Charles Buckley B001024 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 23 | |||||||||||||
22137 | 22137 | Anthony Fleger F000195 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 22 | |||||||||||||
22543 | 22543 | Edward Curley C000995 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 22 | |||||||||||||
23022 | 23022 | Harry Haines H000026 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 22 | |||||||||||||
23218 | 23218 | Edwin Schaefer S000110 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 22 | |||||||||||||
22599 | 22599 | Frank Fries F000385 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 21 | |||||||||||||
23254 | 23254 | Charles South S000683 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 21 | |||||||||||||
23501 | 23501 | Joseph Gavagan G000101 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 21 | |||||||||||||
25649 | 25649 | Robert Crosser C000932 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 21 | |||||||||||||
28234 | 28234 | Francis Walter W000108 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 21 | |||||||||||||
22265 | 22265 | James Lanzetta L000091 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 20 | |||||||||||||
22292 | 22292 | Fontaine Maverick M000263 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 20 | |||||||||||||
23058 | 23058 | Benjamin Jarrett J000060 | rep | PA | 1937-01-05 | 1939-01-03 | Republican | 20 | |||||||||||||
23267 | 23267 | Martin Sweeney S001102 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 20 | |||||||||||||
23896 | 23896 | Edouard Izac I000052 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 20 | |||||||||||||
23962 | 23962 | Scott Lucas L000493 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 20 | |||||||||||||
22383 | 22383 | Hugh Rigney R000256 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 19 | |||||||||||||
22433 | 22433 | Guy Swope S001127 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 19 | |||||||||||||
24766 | 24766 | Sol Bloom B000565 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 19 | |||||||||||||
28139 | 28139 | Harry Sheppard S000335 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 19 | |||||||||||||
29302 | 29302 | Michael Kirwan K000244 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 19 | |||||||||||||
31622 | 31622 | George Mahon M000065 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 19 | |||||||||||||
22152 | 22152 | Benjamin Focht F000230 | rep | PA | 1937-01-05 | 1939-01-03 | Republican | 18 | |||||||||||||
22303 | 22303 | James Meeks M000631 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 18 | |||||||||||||
22403 | 22403 | Byron Scott S000165 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 18 | |||||||||||||
22647 | 22647 | John Jones J000236 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 18 | |||||||||||||
23053 | 23053 | Lawrence Imhoff I000010 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 18 | |||||||||||||
23560 | 23560 | Martin Kennedy K000111 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 18 | |||||||||||||
27002 | 27002 | Richard Simpson S000436 | rep | PA | 1937-01-05 | 1939-01-03 | Republican | 18 | |||||||||||||
22094 | 22094 | Charles Colden C000605 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 17 | |||||||||||||
22372 | 22372 | Theodore Peyser P000281 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 17 | |||||||||||||
22484 | 22484 | William Ashbrook A000306 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 17 | |||||||||||||
22500 | 22500 | Bruce Barton B000211 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 17 | |||||||||||||
22601 | 22601 | Clyde Garrett G000080 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 17 | |||||||||||||
23427 | 23427 | John Ditter D000363 | rep | PA | 1937-01-05 | 1939-01-03 | Republican | 17 | |||||||||||||
25931 | 25931 | George Dondero D000411 | rep | MI | 1937-01-05 | 1939-01-03 | Republican | 17 | |||||||||||||
30139 | 30139 | Leslie Arends A000216 | rep | IL | 1937-01-05 | 1939-01-03 | Republican | 17 | |||||||||||||
22113 | 22113 | John Dockweiler D000387 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 16 | |||||||||||||
22351 | 22351 | John O’Connor O000030 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 16 | |||||||||||||
24146 | 24146 | William Thom T000155 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 16 | |||||||||||||
24695 | 24695 | Robert Thomason T000189 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 16 | |||||||||||||
24891 | 24891 | John Lesinski L000251 | rep | MI | 1937-01-05 | 1939-01-03 | Democrat | 16 | |||||||||||||
25005 | 25005 | Robert Rich R000209 | rep | PA | 1937-01-05 | 1939-01-03 | Republican | 16 | |||||||||||||
27744 | 27744 | Everett Dirksen D000360 | rep | IL | 1937-01-05 | 1939-01-03 | Republican | 16 | |||||||||||||
22053 | 22053 | Lewis Boyer B000724 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 15 | |||||||||||||
22061 | 22061 | John Boylan B000726 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 15 | |||||||||||||
23207 | 23207 | Albert Rutherford R000546 | rep | PA | 1937-01-05 | 1939-01-03 | Republican | 15 | |||||||||||||
23376 | 23376 | John Costello C000795 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 15 | |||||||||||||
24421 | 24421 | Charles Gifford G000169 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 15 | |||||||||||||
24714 | 24714 | Milton West W000304 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 15 | |||||||||||||
25913 | 25913 | John Dingell D000354 | rep | MI | 1937-01-05 | 1939-01-03 | Democrat | 15 | |||||||||||||
28645 | 28645 | Robert Secrest S000219 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 15 | |||||||||||||
22440 | 22440 | Chester Thompson T000197 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 14 | |||||||||||||
22780 | 22780 | William Sirovich S000452 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 14 | |||||||||||||
23029 | 23029 | Dow Harter H000294 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 14 | |||||||||||||
23147 | 23147 | Guy Moser M001026 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 14 | |||||||||||||
23477 | 23477 | Thomas Ford F000267 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 14 | |||||||||||||
23567 | 23567 | Richard Kleberg K000257 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 14 | |||||||||||||
25697 | 25697 | Edward Hart H000284 | rep | NJ | 1937-01-05 | 1939-01-03 | Democrat | 14 | |||||||||||||
27417 | 27417 | Louis Rabaut R000001 | rep | MI | 1937-01-05 | 1939-01-03 | Democrat | 14 | |||||||||||||
28535 | 28535 | Joseph Martin M000191 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 14 | |||||||||||||
22179 | 22179 | James Gildea G000182 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 13 | |||||||||||||
22295 | 22295 | William McFarlane M000440 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 13 | |||||||||||||
22802 | 22802 | Christopher Sullivan S001051 | rep | NY | 1937-01-05 | 1939-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);