legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
482 rows where "end" is on date 1951-01-03
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25947 | 25947 | Mathew Ellsworth E000146 | rep | OR | 1949-01-03 | 1951-01-03 | Republican | 4 | |||||||||||||
25956 | 25956 | Antonio Fernández F000085 | rep | NM | 1949-01-03 | 1951-01-03 | Democrat | 0 | |||||||||||||
25972 | 25972 | Ralph Gamble G000031 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 28 | |||||||||||||
25979 | 25979 | William Granahan G000369 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25989 | 25989 | Thomas Hand H000154 | rep | NJ | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
25999 | 25999 | John Hinshaw H000640 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 20 | |||||||||||||
26003 | 26003 | Richard Hoffman H000689 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 10 | |||||||||||||
26018 | 26018 | Clifford Hope H000768 | rep | KS | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
26025 | 26025 | Justin Johnson J000157 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
26029 | 26029 | Woodrow Jones J000263 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 11 | |||||||||||||
26040 | 26040 | Arthur Klein K000261 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 19 | |||||||||||||
26044 | 26044 | Harold Lovre L000468 | rep | SD | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26053 | 26053 | Thomas Martin M000199 | rep | IA | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26073 | 26073 | Charles Nelson N000031 | rep | ME | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
26081 | 26081 | John Phillips P000309 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 22 | |||||||||||||
26089 | 26089 | James Priest P000536 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
26100 | 26100 | Chauncey Reed R000111 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 14 | |||||||||||||
26112 | 26112 | James Richards R000214 | rep | SC | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
26124 | 26124 | Dewey Short S000377 | rep | MO | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
26132 | 26132 | Harold Velde V000082 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 18 | |||||||||||||
26145 | 26145 | Jesse Wolcott W000668 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
26157 | 26157 | John Allen A000133 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
26173 | 26173 | August Andresen A000239 | rep | MN | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26194 | 26194 | Usher Burdick B001079 | rep | ND | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
26204 | 26204 | Homer Capehart C000128 | sen | IN | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
26212 | 26212 | John Carroll C000189 | rep | CO | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
26220 | 26220 | Francis Case C000221 | rep | SD | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
26223 | 26223 | Earl Chudoff C000386 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
26233 | 26233 | Cliff Clevenger C000515 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
26245 | 26245 | William Cole C000617 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 39 | |||||||||||||
26260 | 26260 | Jere Cooper C000755 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
26266 | 26266 | Frederic Coudert C000804 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 17 | |||||||||||||
26278 | 26278 | Paul Cunningham C000993 | rep | IA | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
26316 | 26316 | Herman Eberharter E000029 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 32 | |||||||||||||
26321 | 26321 | Myron George G000129 | rep | KS | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
26329 | 26329 | Thomas Gordon G000316 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
26340 | 26340 | Noble Gregory G000447 | rep | KY | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
26347 | 26347 | Ralph Gwinn G000541 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 27 | |||||||||||||
26355 | 26355 | Robert Hale H000036 | rep | ME | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26360 | 26360 | Cecil Harden H000182 | rep | IN | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
26373 | 26373 | Lawrence Hays H000405 | rep | AR | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
26385 | 26385 | John Heselton H000549 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26394 | 26394 | William Hill H000613 | rep | CO | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
26406 | 26406 | Otis Holmes H000740 | rep | WA | 1949-01-03 | 1951-01-03 | Republican | 4 | |||||||||||||
26414 | 26414 | Benjamin James J000045 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
26431 | 26431 | Thomas Jenkins J000088 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 10 | |||||||||||||
26441 | 26441 | Robert Kean K000029 | rep | NJ | 1949-01-03 | 1951-01-03 | Republican | 12 | |||||||||||||
26449 | 26449 | Bernard Kearney K000030 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 31 | |||||||||||||
26459 | 26459 | Augustine Kelley K000058 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 27 | |||||||||||||
26470 | 26470 | Henderson Lanham L000077 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
26477 | 26477 | Henry Latham L000108 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
26487 | 26487 | Karl Le Compte L000157 | rep | IA | 1949-01-03 | 1951-01-03 | Republican | 4 | |||||||||||||
26499 | 26499 | Samuel McConnell M000354 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 16 | |||||||||||||
26509 | 26509 | J. McGregor M000460 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 17 | |||||||||||||
26522 | 26522 | Arthur Miller M000715 | rep | NE | 1949-01-03 | 1951-01-03 | Republican | 4 | |||||||||||||
26528 | 26528 | Edward Miller M000724 | rep | MD | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26540 | 26540 | Donald Nicholson N000097 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
26550 | 26550 | Joseph O’Hara O000056 | rep | MN | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
26556 | 26556 | James Patterson P000119 | rep | CT | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
26565 | 26565 | Edward Robeson R000329 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
26574 | 26574 | Antoni Sadlak S000009 | rep | CT | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
26582 | 26582 | Errett Scrivner S000194 | rep | KS | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
26587 | 26587 | Hubert Scudder S000198 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26606 | 26606 | Sidney Simpson S000437 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 20 | |||||||||||||
26615 | 26615 | Lawrence Smith S000585 | rep | WI | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26627 | 26627 | Henry Talle T000028 | rep | IA | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
26638 | 26638 | John Vorys V000119 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 12 | |||||||||||||
26646 | 26646 | Charles Vursell V000125 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 24 | |||||||||||||
26662 | 26662 | Richard Wigglesworth W000450 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 13 | |||||||||||||
26668 | 26668 | Alexander Wiley W000465 | sen | WI | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
26686 | 26686 | Charles Wolverton W000683 | rep | NJ | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26700 | 26700 | Leo Allen A000138 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 16 | |||||||||||||
26715 | 26715 | Graham Barden B000139 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
26729 | 26729 | James Beall B000271 | rep | MD | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
26756 | 26756 | Paul Brown B000940 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 10 | |||||||||||||
26786 | 26786 | Gordon Canfield C000113 | rep | NJ | 1949-01-03 | 1951-01-03 | Republican | 8 | |||||||||||||
26793 | 26793 | Albert Carnahan C000162 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
26807 | 26807 | George Christopher C000383 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
26816 | 26816 | Isidore Dollinger D000402 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 24 | |||||||||||||
26831 | 26831 | Carl Durham D000571 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
26841 | 26841 | Clair Engle E000181 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
26854 | 26854 | Aime Forand F000255 | rep | RI | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
26887 | 26887 | Donald Jackson J000008 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 16 | |||||||||||||
26896 | 26896 | Kenneth Keating K000036 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 40 | |||||||||||||
26907 | 26907 | Russell Mack M000021 | rep | WA | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
26919 | 26919 | Toby Morris M000991 | rep | OK | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
26932 | 26932 | James Polk P000408 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
26941 | 26941 | Prince Preston P000516 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
26965 | 26965 | Daniel Reed R000113 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 45 | |||||||||||||
26977 | 26977 | Edward Rees R000132 | rep | KS | 1949-01-03 | 1951-01-03 | Republican | 4 | |||||||||||||
26995 | 26995 | Edith Rogers R000392 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
27008 | 27008 | Richard Simpson S000436 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 17 | |||||||||||||
27015 | 27015 | Wint Smith S000640 | rep | KS | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
27024 | 27024 | Dean Taylor T000070 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 33 | |||||||||||||
27040 | 27040 | Roy Wier W000446 | rep | MN | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
27050 | 27050 | Gardner Withrow W000663 | rep | WI | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
27061 | 27061 | Hugh Addonizio A000054 | rep | NJ | 1949-01-03 | 1951-01-03 | Democrat | 11 | |||||||||||||
27080 | 27080 | Herman Andersen A000179 | rep | MN | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
27093 | 27093 | Cleveland Bailey B000035 | rep | WV | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
27117 | 27117 | Frank Boykin B000725 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 1 |
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);