legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
485 rows where "start" is on date 1947-01-03 sorted by state
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26328 | 26328 | Thomas Gordon G000316 | rep | IL | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
26605 | 26605 | Sidney Simpson S000437 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 20 | |||||||||||||
26645 | 26645 | Charles Vursell V000125 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 23 | |||||||||||||
26699 | 26699 | Leo Allen A000138 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 13 | |||||||||||||
27146 | 27146 | Robert Chiperfield C000365 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 15 | |||||||||||||
27348 | 27348 | Noah Mason M000224 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 12 | |||||||||||||
27749 | 27749 | Everett Dirksen D000360 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 16 | |||||||||||||
28058 | 28058 | Thomas O’Brien O000016 | rep | IL | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
29206 | 29206 | William Dawson D000158 | rep | IL | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
30144 | 30144 | Leslie Arends A000216 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 17 | |||||||||||||
33696 | 33696 | Charles Price P000522 | rep | IL | 1947-01-03 | 1949-01-03 | Democrat | 22 | |||||||||||||
24431 | 24431 | George Gillie G000207 | rep | IN | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
24437 | 24437 | Robert Grant G000384 | rep | IN | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
24459 | 24459 | Forest Harness H000217 | rep | IN | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
24501 | 24501 | Noble Johnson J000165 | rep | IN | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
24534 | 24534 | Gerald Landis L000052 | rep | IN | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
24569 | 24569 | Louis Ludlow L000501 | rep | IN | 1947-01-03 | 1949-01-03 | Democrat | 11 | |||||||||||||
24619 | 24619 | Edward Mitchell M000809 | rep | IN | 1947-01-03 | 1949-01-03 | Republican | 8 | |||||||||||||
24682 | 24682 | Raymond Springer S000755 | rep | IN | 1947-01-03 | 1949-01-03 | Republican | 10 | |||||||||||||
25729 | 25729 | William Jenner J000093 | sen | IN | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
28275 | 28275 | Earl Wilson W000572 | rep | IN | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
28460 | 28460 | Ralph Harvey H000310 | rep | IN | 1947-01-03 | 1949-01-03 | Republican | 10 | |||||||||||||
28866 | 28866 | Charles Halleck H000081 | rep | IN | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
31145 | 31145 | Ray Madden M000039 | rep | IN | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
24931 | 24931 | Herbert Meyer M000680 | rep | KS | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
25182 | 25182 | Albert Cole C000606 | rep | KS | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
26017 | 26017 | Clifford Hope H000768 | rep | KS | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
26581 | 26581 | Errett Scrivner S000194 | rep | KS | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
26976 | 26976 | Edward Rees R000132 | rep | KS | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
27014 | 27014 | Wint Smith S000640 | rep | KS | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
24555 | 24555 | William Lewis L000296 | rep | KY | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
24615 | 24615 | Wendell Meade M000619 | rep | KY | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
24663 | 24663 | John Robsion R000358 | rep | KY | 1947-01-03 | 1948-02-17 | Republican | 9 | |||||||||||||
24801 | 24801 | Virgil Chapman C000317 | rep | KY | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
25107 | 25107 | Earle Clements C000506 | rep | KY | 1947-01-03 | 1948-01-06 | Democrat | 2 | |||||||||||||
25135 | 25135 | Joseph Bates B000237 | rep | KY | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
26339 | 26339 | Noble Gregory G000447 | rep | KY | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
27541 | 27541 | Brent Spence S000717 | rep | KY | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
28036 | 28036 | Thruston Morton M001022 | rep | KY | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
28362 | 28362 | Frank Chelf C000342 | rep | KY | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
24353 | 24353 | James Domengeaux D000406 | rep | LA | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
25117 | 25117 | Asa Allen A000114 | rep | LA | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
25365 | 25365 | Henry Larcade L000095 | rep | LA | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
27132 | 27132 | Overton Brooks B000884 | rep | LA | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
28576 | 28576 | James Morrison M000995 | rep | LA | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
29610 | 29610 | Thomas Boggs B000594 | rep | LA | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
31038 | 31038 | Felix Hébert H000437 | rep | LA | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
31237 | 31237 | Otto Passman P000098 | rep | LA | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
24309 | 24309 | Charles Clason C000473 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
24426 | 24426 | Charles Gifford G000169 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
24558 | 24558 | Henry Lodge L000394 | sen | MA | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
24737 | 24737 | George Bates B000232 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
25324 | 25324 | Christian Herter H000548 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 10 | |||||||||||||
25678 | 25678 | Angier Goodwin G000297 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 8 | |||||||||||||
26384 | 26384 | John Heselton H000549 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
26539 | 26539 | Donald Nicholson N000097 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
26661 | 26661 | Richard Wigglesworth W000450 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 13 | |||||||||||||
26994 | 26994 | Edith Rogers R000392 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
27307 | 27307 | Thomas Lane L000065 | rep | MA | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
27594 | 27594 | John Kennedy K000107 | rep | MA | 1947-01-03 | 1949-01-03 | Democrat | 11 | |||||||||||||
28540 | 28540 | Joseph Martin M000191 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 14 | |||||||||||||
29374 | 29374 | John McCormack M000364 | rep | MA | 1947-01-03 | 1949-01-03 | Democrat | 12 | |||||||||||||
29408 | 29408 | Philip Philbin P000303 | rep | MA | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
30302 | 30302 | Harold Donohue D000419 | rep | MA | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
24338 | 24338 | Thomas D’Alesandro D000007 | rep | MD | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
24614 | 24614 | Hugh Meade M000617 | rep | MD | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
24624 | 24624 | Herbert O’Conor O000032 | sen | MD | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
25481 | 25481 | Lansdale Sasscer S000067 | rep | MD | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
26527 | 26527 | Edward Miller M000724 | rep | MD | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
26728 | 26728 | James Beall B000271 | rep | MD | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
29236 | 29236 | George Fallon F000012 | rep | MD | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
29801 | 29801 | Edward Garmatz G000071 | rep | MD | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
24285 | 24285 | Ralph Brewster B000816 | sen | ME | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25259 | 25259 | Frank Fellows F000066 | rep | ME | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
26354 | 26354 | Robert Hale H000036 | rep | ME | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
29044 | 29044 | Margaret Smith S000590 | rep | ME | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
24279 | 24279 | Frederick Bradley B000742 | rep | MI | 1947-01-03 | 1947-05-24 | Republican | 11 | |||||||||||||
24312 | 24312 | Howard Coffin C000590 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 13 | |||||||||||||
24512 | 24512 | Bartel Jonkman J000264 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
24711 | 24711 | Arthur Vandenberg V000025 | sen | MI | 1947-01-03 | 1951-04-18 | 1 | Republican | |||||||||||||
24720 | 24720 | Harold Youngblood Y000058 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 14 | |||||||||||||
24828 | 24828 | Albert Engel E000178 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
24896 | 24896 | John Lesinski L000251 | rep | MI | 1947-01-03 | 1949-01-03 | Democrat | 16 | |||||||||||||
24946 | 24946 | Earl Michener M000693 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
25016 | 25016 | George Sadowski S000011 | rep | MI | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
25143 | 25143 | William Blackney B000515 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
25209 | 25209 | Fred Crawford C000889 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 8 | |||||||||||||
25566 | 25566 | Roy Woodruff W000718 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 10 | |||||||||||||
25804 | 25804 | Paul Shafer S000277 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
25918 | 25918 | John Dingell D000354 | rep | MI | 1947-01-03 | 1949-01-03 | Democrat | 15 | |||||||||||||
25936 | 25936 | George Dondero D000411 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 17 | |||||||||||||
26144 | 26144 | Jesse Wolcott W000668 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
27237 | 27237 | Clare Hoffman H000683 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
27644 | 27644 | John Bennett B000377 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 12 | |||||||||||||
24349 | 24349 | Edward Devitt D000280 | rep | MN | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
24529 | 24529 | Harold Knutson K000301 | rep | MN | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
24571 | 24571 | George MacKinnon M000027 | rep | MN | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
25692 | 25692 | Harold Hagen H000014 | rep | MN | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
25821 | 25821 | Edward Thye T000259 | sen | MN | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
26172 | 26172 | August Andresen A000239 | rep | MN | 1947-01-03 | 1949-01-03 | Republican | 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);