legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
488 rows where "end" is on date 1947-01-03 sorted by district descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26963 | 26963 | Daniel Reed R000113 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 45 | |||||||||||||
25168 | 25168 | John Butler B001179 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 44 | |||||||||||||
24379 | 24379 | Edward Elsaesser E000159 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 43 | |||||||||||||
24259 | 24259 | Walter Andrews A000250 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 42 | |||||||||||||
25056 | 25056 | James Wadsworth W000012 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 41 | |||||||||||||
24076 | 24076 | George Rogers R000394 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 40 | |||||||||||||
26243 | 26243 | William Cole C000617 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 39 | |||||||||||||
27560 | 27560 | John Taber T000001 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 38 | |||||||||||||
25295 | 25295 | Edwin Hall H000050 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 37 | |||||||||||||
23864 | 23864 | Clarence Hancock H000146 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 36 | |||||||||||||
24397 | 24397 | Hadwen Fuller F000404 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 35 | |||||||||||||
27953 | 27953 | Clarence Kilburn K000170 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 34 | |||||||||||||
24202 | 24202 | Samuel Weiss W000257 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 33 | |||||||||||||
25155 | 25155 | Frank Buchanan B001002 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 33 | |||||||||||||
27022 | 27022 | Dean Taylor T000070 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 33 | |||||||||||||
25175 | 25175 | William Byrne B001214 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 32 | |||||||||||||
26314 | 26314 | Herman Eberharter E000029 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 32 | |||||||||||||
26447 | 26447 | Bernard Kearney K000030 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 31 | |||||||||||||
29776 | 29776 | James Fulton F000422 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 31 | |||||||||||||
24877 | 24877 | Jay Le Fevre L000161 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 30 | |||||||||||||
29718 | 29718 | Robert Corbett C000772 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 30 | |||||||||||||
23776 | 23776 | Augustus Bennet B000367 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 29 | |||||||||||||
23797 | 23797 | Howard Campbell C000085 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 29 | |||||||||||||
24073 | 24073 | Robert Rodgers R000373 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 28 | |||||||||||||
25970 | 25970 | Ralph Gamble G000031 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 28 | |||||||||||||
26345 | 26345 | Ralph Gwinn G000541 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 27 | |||||||||||||
26457 | 26457 | Augustine Kelley K000058 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 27 | |||||||||||||
24050 | 24050 | Peter Quinn Q000019 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 26 | |||||||||||||
24704 | 24704 | Harve Tibbott T000263 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 26 | |||||||||||||
25596 | 25596 | Cecil Bishop B000486 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 25 | |||||||||||||
25685 | 25685 | Louis Graham G000360 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 25 | |||||||||||||
27668 | 27668 | Charles Buckley B001024 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 25 | |||||||||||||
23877 | 23877 | James Heidinger H000450 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 24 | |||||||||||||
24310 | 24310 | Roy Clippinger C000529 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 24 | |||||||||||||
24635 | 24635 | Benjamin Rabin R000002 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 24 | |||||||||||||
31201 | 31201 | Thomas Morgan M000958 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 24 | |||||||||||||
23881 | 23881 | Carl Hoffman H000682 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 23 | |||||||||||||
23900 | 23900 | Edouard Izac I000052 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 23 | |||||||||||||
24104 | 24104 | John Snyder S000668 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 23 | |||||||||||||
24906 | 24906 | Walter Lynch L000537 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 23 | |||||||||||||
26644 | 26644 | Charles Vursell V000125 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 23 | |||||||||||||
23789 | 23789 | David Brumbaugh B000976 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 22 | |||||||||||||
26079 | 26079 | John Phillips P000309 | rep | CA | 1945-01-03 | 1947-01-03 | Republican | 22 | |||||||||||||
28790 | 28790 | Frances Bolton B000607 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 22 | |||||||||||||
29422 | 29422 | Adam Powell P000477 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 22 | |||||||||||||
33695 | 33695 | Charles Price P000522 | rep | IL | 1945-01-03 | 1947-01-03 | Democrat | 22 | |||||||||||||
24165 | 24165 | James Torrens T000315 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 21 | |||||||||||||
24443 | 24443 | Chester Gross G000493 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 21 | |||||||||||||
24478 | 24478 | George Howell H000863 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 21 | |||||||||||||
25653 | 25653 | Robert Crosser C000932 | rep | OH | 1945-01-03 | 1947-01-03 | Democrat | 21 | |||||||||||||
28143 | 28143 | Harry Sheppard S000335 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 21 | |||||||||||||
30345 | 30345 | Ovie Fisher F000152 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 21 | |||||||||||||
24770 | 24770 | Sol Bloom B000565 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 20 | |||||||||||||
25997 | 25997 | John Hinshaw H000640 | rep | CA | 1945-01-03 | 1947-01-03 | Republican | 20 | |||||||||||||
26604 | 26604 | Sidney Simpson S000437 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 20 | |||||||||||||
27290 | 27290 | Paul Kilday K000171 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 20 | |||||||||||||
28238 | 28238 | Francis Walter W000108 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 20 | |||||||||||||
29256 | 29256 | Michael Feighan F000060 | rep | OH | 1945-01-03 | 1947-01-03 | Democrat | 20 | |||||||||||||
23837 | 23837 | Samuel Dickstein D000335 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 19 | |||||||||||||
24923 | 24923 | Rolla McMillen M000574 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 19 | |||||||||||||
26038 | 26038 | Arthur Klein K000261 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 19 | |||||||||||||
27801 | 27801 | Leon Gavin G000102 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 19 | |||||||||||||
29306 | 29306 | Michael Kirwan K000244 | rep | OH | 1945-01-03 | 1947-01-03 | Democrat | 19 | |||||||||||||
30482 | 30482 | Chester Holifield H000713 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 19 | |||||||||||||
31626 | 31626 | George Mahon M000065 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 19 | |||||||||||||
24112 | 24112 | Jessie Sumner S001071 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 18 | |||||||||||||
24553 | 24553 | Earl Lewis L000279 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 18 | |||||||||||||
24915 | 24915 | Vito Marcantonio M000122 | rep | NY | 1945-01-03 | 1947-01-03 | American Labor | 18 | |||||||||||||
25103 | 25103 | Francis Worley W000744 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 18 | |||||||||||||
27753 | 27753 | Clyde Doyle D000481 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 18 | |||||||||||||
28515 | 28515 | John Kunkel K000341 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 18 | |||||||||||||
23769 | 23769 | Joseph Baldwin B000093 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 17 | |||||||||||||
24083 | 24083 | Sam Russell R000538 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 17 | |||||||||||||
25935 | 25935 | George Dondero D000411 | rep | MI | 1945-01-03 | 1947-01-03 | Republican | 17 | |||||||||||||
26507 | 26507 | J. McGregor M000460 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 17 | |||||||||||||
27006 | 27006 | Richard Simpson S000436 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 17 | |||||||||||||
28944 | 28944 | Cecil King K000196 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 17 | |||||||||||||
30143 | 30143 | Leslie Arends A000216 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 17 | |||||||||||||
24027 | 24027 | Ellis Patterson P000113 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 16 | |||||||||||||
24148 | 24148 | William Thom T000155 | rep | OH | 1945-01-03 | 1947-01-03 | Democrat | 16 | |||||||||||||
24288 | 24288 | Ellsworth Buck B001016 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 16 | |||||||||||||
24699 | 24699 | Robert Thomason T000189 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 16 | |||||||||||||
24895 | 24895 | John Lesinski L000251 | rep | MI | 1945-01-03 | 1947-01-03 | Democrat | 16 | |||||||||||||
26497 | 26497 | Samuel McConnell M000354 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 16 | |||||||||||||
27748 | 27748 | Everett Dirksen D000360 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 16 | |||||||||||||
24439 | 24439 | Percy Griffiths G000472 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 15 | |||||||||||||
24718 | 24718 | Milton West W000304 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 15 | |||||||||||||
25008 | 25008 | Robert Rich R000209 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 15 | |||||||||||||
25917 | 25917 | John Dingell D000354 | rep | MI | 1945-01-03 | 1947-01-03 | Democrat | 15 | |||||||||||||
27145 | 27145 | Robert Chiperfield C000365 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 15 | |||||||||||||
27356 | 27356 | Gordon McDonough M000414 | rep | CA | 1945-01-03 | 1947-01-03 | Republican | 15 | |||||||||||||
29682 | 29682 | Emanuel Celler C000264 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 15 | |||||||||||||
24491 | 24491 | Anton Johnson J000117 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 14 | |||||||||||||
24640 | 24640 | Leo Rayfiel R000083 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 14 | |||||||||||||
24818 | 24818 | Helen Douglas D000454 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 14 | |||||||||||||
24854 | 24854 | Walter Huber H000898 | rep | OH | 1945-01-03 | 1947-01-03 | Democrat | 14 | |||||||||||||
25274 | 25274 | Wilson Gillette G000206 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 14 | |||||||||||||
25701 | 25701 | Edward Hart H000284 | rep | NJ | 1945-01-03 | 1947-01-03 | Democrat | 14 | |||||||||||||
25753 | 25753 | John Lyle L000525 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 14 | |||||||||||||
27421 | 27421 | Louis Rabaut R000001 | rep | MI | 1945-01-03 | 1947-01-03 | Democrat | 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);