legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
486 rows where "end" is on date 1949-01-03 sorted by rowid 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28163 | 28163 | George Smathers S000505 | rep | FL | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
28144 | 28144 | Harry Sheppard S000335 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 21 | |||||||||||||
28106 | 28106 | Roy Riehlman R000250 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 36 | |||||||||||||
28096 | 28096 | Albert Rains R000018 | rep | AL | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
28058 | 28058 | Thomas O’Brien O000016 | rep | IL | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
28042 | 28042 | Albin Norblad N000133 | rep | OR | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
28036 | 28036 | Thruston Morton M001022 | rep | KY | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
28027 | 28027 | Almer Monroney M000859 | rep | OK | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
27954 | 27954 | Clarence Kilburn K000170 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 34 | |||||||||||||
27919 | 27919 | Benton Jensen J000100 | rep | IA | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
27901 | 27901 | Walter Horan H000786 | rep | WA | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
27887 | 27887 | Charles Hoeven H000678 | rep | IA | 1947-01-03 | 1949-01-03 | Republican | 8 | |||||||||||||
27821 | 27821 | George Grant G000381 | rep | AL | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
27802 | 27802 | Leon Gavin G000102 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 19 | |||||||||||||
27791 | 27791 | Julian Gary G000091 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
27772 | 27772 | Antonio Fernós-Isern F000087 | rep | PR | 1947-01-03 | 1949-01-03 | Popular Democrat | 0 | |||||||||||||
27749 | 27749 | Everett Dirksen D000360 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 16 | |||||||||||||
27727 | 27727 | Clifford Davis D000094 | rep | TN | 1947-01-03 | 1949-01-03 | Democrat | 10 | |||||||||||||
27713 | 27713 | John Chenoweth C000346 | rep | CO | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
27691 | 27691 | Clarence Cannon C000117 | rep | MO | 1947-01-03 | 1949-01-03 | Democrat | 9 | |||||||||||||
27669 | 27669 | Charles Buckley B001024 | rep | NY | 1947-01-03 | 1949-01-03 | Democrat | 25 | |||||||||||||
27644 | 27644 | John Bennett B000377 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 12 | |||||||||||||
27610 | 27610 | James Auchincloss A000227 | rep | NJ | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
27594 | 27594 | John Kennedy K000107 | rep | MA | 1947-01-03 | 1949-01-03 | Democrat | 11 | |||||||||||||
27576 | 27576 | James Van Zandt V000069 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 22 | |||||||||||||
27561 | 27561 | John Taber T000001 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 38 | |||||||||||||
27541 | 27541 | Brent Spence S000717 | rep | KY | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
27521 | 27521 | Horace Seely-Brown S000224 | rep | CT | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
27502 | 27502 | Leverett Saltonstall S000021 | sen | MA | 1945-01-03 | 1949-01-03 | 2 | Republican | |||||||||||||
27494 | 27494 | Absalom Robertson R000317 | sen | VA | 1946-11-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
27480 | 27480 | John Riley R000260 | rep | SC | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
27451 | 27451 | Samuel Rayburn R000082 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
27402 | 27402 | William Norrell N000137 | rep | AR | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
27372 | 27372 | Chester Merrow M000664 | rep | NH | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
27357 | 27357 | Gordon McDonough M000414 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 15 | |||||||||||||
27348 | 27348 | Noah Mason M000224 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 12 | |||||||||||||
27307 | 27307 | Thomas Lane L000065 | rep | MA | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
27291 | 27291 | Paul Kilday K000171 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 20 | |||||||||||||
27280 | 27280 | Carey Kefauver K000044 | rep | TN | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
27268 | 27268 | Carroll Kearns K000032 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 28 | |||||||||||||
27260 | 27260 | Walter Judd J000278 | rep | MN | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
27237 | 27237 | Clare Hoffman H000683 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
27217 | 27217 | Burr Harrison H000264 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
27196 | 27196 | Ivor Fenton F000075 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 12 | |||||||||||||
27188 | 27188 | Henry Dworshak D000585 | sen | ID | 1946-01-01 | 1949-01-03 | 2 | Republican | |||||||||||||
27170 | 27170 | James Davis D000109 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
27146 | 27146 | Robert Chiperfield C000365 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 15 | |||||||||||||
27132 | 27132 | Overton Brooks B000884 | rep | LA | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
27116 | 27116 | Frank Boykin B000725 | rep | AL | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
27079 | 27079 | Herman Andersen A000179 | rep | MN | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
27023 | 27023 | Dean Taylor T000070 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 33 | |||||||||||||
27014 | 27014 | Wint Smith S000640 | rep | KS | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
27007 | 27007 | Richard Simpson S000436 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 17 | |||||||||||||
26994 | 26994 | Edith Rogers R000392 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
26976 | 26976 | Edward Rees R000132 | rep | KS | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
26964 | 26964 | Daniel Reed R000113 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 45 | |||||||||||||
26940 | 26940 | Prince Preston P000516 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
26918 | 26918 | Toby Morris M000991 | rep | OK | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
26906 | 26906 | Russell Mack M000021 | rep | WA | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
26895 | 26895 | Kenneth Keating K000036 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 40 | |||||||||||||
26886 | 26886 | Donald Jackson J000008 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 16 | |||||||||||||
26875 | 26875 | William Hess H000550 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
26853 | 26853 | Aime Forand F000255 | rep | RI | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
26840 | 26840 | Clair Engle E000181 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
26830 | 26830 | Carl Durham D000571 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
26785 | 26785 | Gordon Canfield C000113 | rep | NJ | 1947-01-03 | 1949-01-03 | Republican | 8 | |||||||||||||
26755 | 26755 | Paul Brown B000940 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 10 | |||||||||||||
26728 | 26728 | James Beall B000271 | rep | MD | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
26714 | 26714 | Graham Barden B000139 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
26699 | 26699 | Leo Allen A000138 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 13 | |||||||||||||
26685 | 26685 | Charles Wolverton W000683 | rep | NJ | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
26661 | 26661 | Richard Wigglesworth W000450 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 13 | |||||||||||||
26645 | 26645 | Charles Vursell V000125 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 23 | |||||||||||||
26637 | 26637 | John Vorys V000119 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 12 | |||||||||||||
26626 | 26626 | Henry Talle T000028 | rep | IA | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
26614 | 26614 | Lawrence Smith S000585 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
26605 | 26605 | Sidney Simpson S000437 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 20 | |||||||||||||
26581 | 26581 | Errett Scrivner S000194 | rep | KS | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
26573 | 26573 | Antoni Sadlak S000009 | rep | CT | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
26555 | 26555 | James Patterson P000119 | rep | CT | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
26549 | 26549 | Joseph O’Hara O000056 | rep | MN | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
26539 | 26539 | Donald Nicholson N000097 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
26527 | 26527 | Edward Miller M000724 | rep | MD | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
26521 | 26521 | Arthur Miller M000715 | rep | NE | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
26508 | 26508 | J. McGregor M000460 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 17 | |||||||||||||
26498 | 26498 | Samuel McConnell M000354 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 16 | |||||||||||||
26486 | 26486 | Karl Le Compte L000157 | rep | IA | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
26476 | 26476 | Henry Latham L000108 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
26469 | 26469 | Henderson Lanham L000077 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
26458 | 26458 | Augustine Kelley K000058 | rep | PA | 1947-01-03 | 1949-01-03 | Democrat | 27 | |||||||||||||
26448 | 26448 | Bernard Kearney K000030 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 31 | |||||||||||||
26440 | 26440 | Robert Kean K000029 | rep | NJ | 1947-01-03 | 1949-01-03 | Republican | 12 | |||||||||||||
26430 | 26430 | Thomas Jenkins J000088 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 10 | |||||||||||||
26405 | 26405 | Otis Holmes H000740 | rep | WA | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
26393 | 26393 | William Hill H000613 | rep | CO | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
26384 | 26384 | John Heselton H000549 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
26372 | 26372 | Lawrence Hays H000405 | rep | AR | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
26354 | 26354 | Robert Hale H000036 | rep | ME | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
26346 | 26346 | Ralph Gwinn G000541 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 27 | |||||||||||||
26339 | 26339 | Noble Gregory G000447 | rep | KY | 1947-01-03 | 1949-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);