legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
487 rows where "start" is on date 1943-01-06 sorted by district descending
This data as json, copyable, CSV (advanced)
Suggested facets: end, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26962 | 26962 | Daniel Reed R000113 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 43 | |||||||||||||
25167 | 25167 | John Butler B001179 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 42 | |||||||||||||
23626 | 23626 | Joseph Mruk M001058 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 41 | |||||||||||||
24258 | 24258 | Walter Andrews A000250 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 40 | |||||||||||||
25055 | 25055 | James Wadsworth W000012 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 39 | |||||||||||||
23635 | 23635 | Joseph O’Brien O000014 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 38 | |||||||||||||
26242 | 26242 | William Cole C000617 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 37 | |||||||||||||
27559 | 27559 | John Taber T000001 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 36 | |||||||||||||
23863 | 23863 | Clarence Hancock H000146 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 35 | |||||||||||||
25294 | 25294 | Edwin Hall H000050 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 34 | |||||||||||||
23434 | 23434 | Fred Douglas D000453 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 33 | |||||||||||||
23393 | 23393 | Francis Culkin C000968 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 32 | |||||||||||||
23760 | 23760 | James Wright W000762 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 32 | |||||||||||||
24396 | 24396 | Hadwen Fuller F000404 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 32 | |||||||||||||
26313 | 26313 | Herman Eberharter E000029 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 31 | |||||||||||||
27952 | 27952 | Clarence Kilburn K000170 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 31 | |||||||||||||
24201 | 24201 | Samuel Weiss W000257 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 30 | |||||||||||||
26446 | 26446 | Bernard Kearney K000030 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 30 | |||||||||||||
24072 | 24072 | Robert Rodgers R000373 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 29 | |||||||||||||
27021 | 27021 | Dean Taylor T000070 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 29 | |||||||||||||
25174 | 25174 | William Byrne B001214 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 28 | |||||||||||||
26456 | 26456 | Augustine Kelley K000058 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 28 | |||||||||||||
24703 | 24703 | Harve Tibbott T000263 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 27 | |||||||||||||
24876 | 24876 | Jay Le Fevre L000161 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 27 | |||||||||||||
23465 | 23465 | Hamilton Fish F000142 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 26 | |||||||||||||
25684 | 25684 | Louis Graham G000360 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 26 | |||||||||||||
23494 | 23494 | Robert Furlong F000432 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 25 | |||||||||||||
25595 | 25595 | Cecil Bishop B000486 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 25 | |||||||||||||
25969 | 25969 | Ralph Gamble G000031 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 25 | |||||||||||||
23474 | 23474 | James Fitzpatrick F000175 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 24 | |||||||||||||
23876 | 23876 | James Heidinger H000450 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 24 | |||||||||||||
24103 | 24103 | John Snyder S000668 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 24 | |||||||||||||
23788 | 23788 | David Brumbaugh B000976 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 23 | |||||||||||||
23899 | 23899 | Edouard Izac I000052 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 23 | |||||||||||||
26643 | 26643 | Charles Vursell V000125 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 23 | |||||||||||||
27575 | 27575 | James Van Zandt V000069 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 23 | |||||||||||||
27667 | 27667 | Charles Buckley B001024 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 23 | |||||||||||||
23553 | 23553 | Calvin Johnson J000121 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 22 | |||||||||||||
24442 | 24442 | Chester Gross G000493 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 22 | |||||||||||||
24905 | 24905 | Walter Lynch L000537 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 22 | |||||||||||||
26078 | 26078 | John Phillips P000309 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 22 | |||||||||||||
28789 | 28789 | Frances Bolton B000607 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 22 | |||||||||||||
23504 | 23504 | Joseph Gavagan G000101 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 21 | |||||||||||||
24164 | 24164 | James Torrens T000315 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 21 | |||||||||||||
24477 | 24477 | George Howell H000863 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 21 | |||||||||||||
25652 | 25652 | Robert Crosser C000932 | rep | OH | 1943-01-06 | 1945-01-03 | Democrat | 21 | |||||||||||||
28142 | 28142 | Harry Sheppard S000335 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 21 | |||||||||||||
28237 | 28237 | Francis Walter W000108 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 21 | |||||||||||||
30344 | 30344 | Ovie Fisher F000152 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 21 | |||||||||||||
24914 | 24914 | Vito Marcantonio M000122 | rep | NY | 1943-01-06 | 1945-01-03 | American Labor | 20 | |||||||||||||
25996 | 25996 | John Hinshaw H000640 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 20 | |||||||||||||
26603 | 26603 | Sidney Simpson S000437 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 20 | |||||||||||||
27289 | 27289 | Paul Kilday K000171 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 20 | |||||||||||||
27800 | 27800 | Leon Gavin G000102 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 20 | |||||||||||||
29255 | 29255 | Michael Feighan F000060 | rep | OH | 1943-01-06 | 1945-01-03 | Democrat | 20 | |||||||||||||
23741 | 23741 | William Wheat W000327 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 19 | |||||||||||||
24769 | 24769 | Sol Bloom B000565 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 19 | |||||||||||||
24922 | 24922 | Rolla McMillen M000574 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 19 | |||||||||||||
28514 | 28514 | John Kunkel K000341 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 19 | |||||||||||||
29305 | 29305 | Michael Kirwan K000244 | rep | OH | 1943-01-06 | 1945-01-03 | Democrat | 19 | |||||||||||||
30481 | 30481 | Chester Holifield H000713 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 19 | |||||||||||||
31625 | 31625 | George Mahon M000065 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 19 | |||||||||||||
23555 | 23555 | William Johnson J000183 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 18 | |||||||||||||
23563 | 23563 | Martin Kennedy K000111 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 18 | |||||||||||||
24111 | 24111 | Jessie Sumner S001071 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 18 | |||||||||||||
24552 | 24552 | Earl Lewis L000279 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 18 | |||||||||||||
25102 | 25102 | Francis Worley W000744 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 18 | |||||||||||||
27005 | 27005 | Richard Simpson S000436 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 18 | |||||||||||||
23430 | 23430 | John Ditter D000363 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 17 | |||||||||||||
23768 | 23768 | Joseph Baldwin B000093 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 17 | |||||||||||||
24082 | 24082 | Sam Russell R000538 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 17 | |||||||||||||
25934 | 25934 | George Dondero D000411 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 17 | |||||||||||||
26496 | 26496 | Samuel McConnell M000354 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 17 | |||||||||||||
26506 | 26506 | J. McGregor M000460 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 17 | |||||||||||||
28943 | 28943 | Cecil King K000196 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 17 | |||||||||||||
30142 | 30142 | Leslie Arends A000216 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 17 | |||||||||||||
23452 | 23452 | James Fay F000051 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 16 | |||||||||||||
23654 | 23654 | William Rogers R000406 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 16 | |||||||||||||
23663 | 23663 | Thomas Scanlon S000105 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 16 | |||||||||||||
24291 | 24291 | Henderson Carson C000192 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 16 | |||||||||||||
24698 | 24698 | Robert Thomason T000189 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 16 | |||||||||||||
24894 | 24894 | John Lesinski L000251 | rep | MI | 1943-01-06 | 1945-01-03 | Democrat | 16 | |||||||||||||
27747 | 27747 | Everett Dirksen D000360 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 16 | |||||||||||||
23352 | 23352 | Thomas Burchill B001072 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 15 | |||||||||||||
23379 | 23379 | John Costello C000795 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 15 | |||||||||||||
24438 | 24438 | Percy Griffiths G000472 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 15 | |||||||||||||
24717 | 24717 | Milton West W000304 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 15 | |||||||||||||
25273 | 25273 | Wilson Gillette G000206 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 15 | |||||||||||||
25916 | 25916 | John Dingell D000354 | rep | MI | 1943-01-06 | 1945-01-03 | Democrat | 15 | |||||||||||||
27144 | 27144 | Robert Chiperfield C000365 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 15 | |||||||||||||
23480 | 23480 | Thomas Ford F000267 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 14 | |||||||||||||
23570 | 23570 | Richard Kleberg K000257 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 14 | |||||||||||||
23657 | 23657 | Edmund Rowe R000475 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 14 | |||||||||||||
23879 | 23879 | Daniel Hoch H000668 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 14 | |||||||||||||
24490 | 24490 | Anton Johnson J000117 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 14 | |||||||||||||
25700 | 25700 | Edward Hart H000284 | rep | NJ | 1943-01-06 | 1945-01-03 | Democrat | 14 | |||||||||||||
26037 | 26037 | Arthur Klein K000261 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 14 | |||||||||||||
27420 | 27420 | Louis Rabaut R000001 | rep | MI | 1943-01-06 | 1945-01-03 | Democrat | 14 | |||||||||||||
28538 | 28538 | Joseph Martin M000191 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 14 | |||||||||||||
23355 | 23355 | Louis Capozzoli C000132 | rep | NY | 1943-01-06 | 1945-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);