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 legislator_id descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24727 | 24727 | Orville Zimmerman Z000009 | rep | MO | 1947-01-03 | 1949-01-03 | Democrat | 10 | |||||||||||||
24720 | 24720 | Harold Youngblood Y000058 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 14 | |||||||||||||
25104 | 25104 | Francis Worley W000744 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 18 | |||||||||||||
25566 | 25566 | Roy Woodruff W000718 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 10 | |||||||||||||
25548 | 25548 | John Wood W000699 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 9 | |||||||||||||
26685 | 26685 | Charles Wolverton W000683 | rep | NJ | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
26144 | 26144 | Jesse Wolcott W000668 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
28285 | 28285 | William Winstead W000641 | rep | MS | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
25837 | 25837 | Joseph Wilson W000604 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
28275 | 28275 | Earl Wilson W000572 | rep | IN | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
28739 | 28739 | John Williams W000518 | sen | DE | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
29067 | 29067 | John Williams W000517 | rep | MS | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
26661 | 26661 | Richard Wigglesworth W000450 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 13 | |||||||||||||
25096 | 25096 | William Whittington W000430 | rep | MS | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
35645 | 35645 | Jamie Whitten W000428 | rep | MS | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
25833 | 25833 | William Wheeler W000342 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
24719 | 24719 | Milton West W000304 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 15 | |||||||||||||
25072 | 25072 | Richard Welch W000265 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
25829 | 25829 | Alvin Weichel W000252 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 13 | |||||||||||||
25825 | 25825 | Arthur Watkins W000190 | sen | UT | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
28239 | 28239 | Francis Walter W000108 | rep | PA | 1947-01-03 | 1949-01-03 | Democrat | 20 | |||||||||||||
25057 | 25057 | James Wadsworth W000012 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 41 | |||||||||||||
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 | |||||||||||||
28220 | 28220 | Carl Vinson V000105 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
27576 | 27576 | James Van Zandt V000069 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 22 | |||||||||||||
24711 | 24711 | Arthur Vandenberg V000025 | sen | MI | 1947-01-03 | 1951-04-18 | 1 | Republican | |||||||||||||
25534 | 25534 | Richard Vail V000003 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
24706 | 24706 | Robert Twyman T000444 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
28717 | 28717 | James Trimble T000373 | rep | AR | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
25528 | 25528 | Harry Towe T000320 | rep | NJ | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
28187 | 28187 | Thor Tollefson T000298 | rep | WA | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
24705 | 24705 | Harve Tibbott T000263 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 26 | |||||||||||||
25821 | 25821 | Edward Thye T000259 | sen | MN | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
28694 | 28694 | Clark Thompson T000198 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 9 | |||||||||||||
24700 | 24700 | Robert Thomason T000189 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 16 | |||||||||||||
25046 | 25046 | John Thomas T000175 | rep | NJ | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
28682 | 28682 | Albert Thomas T000156 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
31847 | 31847 | Olin Teague T000110 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
27023 | 27023 | Dean Taylor T000070 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 33 | |||||||||||||
26626 | 26626 | Henry Talle T000028 | rep | IA | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
27561 | 27561 | John Taber T000001 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 38 | |||||||||||||
24691 | 24691 | Frank Sundstrom S001076 | rep | NJ | 1947-01-03 | 1949-01-03 | Republican | 11 | |||||||||||||
24688 | 24688 | William Stratton S000998 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
25508 | 25508 | Lowell Stockman S000936 | rep | OR | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
25503 | 25503 | William Stigler S000923 | rep | OK | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
24686 | 24686 | William Stevenson S000896 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
33155 | 33155 | John Stennis S000852 | sen | MS | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
25498 | 25498 | Karl Stefan S000845 | rep | NE | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
25813 | 25813 | Thomas Stanley S000797 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
28168 | 28168 | Katharine St. George S000764 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 29 | |||||||||||||
24682 | 24682 | Raymond Springer S000755 | rep | IN | 1947-01-03 | 1949-01-03 | Republican | 10 | |||||||||||||
27541 | 27541 | Brent Spence S000717 | rep | KY | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
25038 | 25038 | Andrew Somers S000676 | rep | NY | 1947-01-03 | 1949-01-03 | Democrat | 10 | |||||||||||||
24677 | 24677 | Melvin Snyder S000670 | rep | WV | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
27014 | 27014 | Wint Smith S000640 | rep | KS | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
29044 | 29044 | Margaret Smith S000590 | rep | ME | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
26614 | 26614 | Lawrence Smith S000585 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
28665 | 28665 | Howard Smith S000554 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
25810 | 25810 | Howard Smith S000553 | sen | NJ | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25025 | 25025 | Frederick Smith S000536 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 8 | |||||||||||||
28163 | 28163 | George Smathers S000505 | rep | FL | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
26605 | 26605 | Sidney Simpson S000437 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 20 | |||||||||||||
27007 | 27007 | Richard Simpson S000436 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 17 | |||||||||||||
31803 | 31803 | Robert Sikes S000406 | rep | FL | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
26123 | 26123 | Dewey Short S000377 | rep | MO | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
28144 | 28144 | Harry Sheppard S000335 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 21 | |||||||||||||
25804 | 25804 | Paul Shafer S000277 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
27521 | 27521 | Horace Seely-Brown S000224 | rep | CT | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
26581 | 26581 | Errett Scrivner S000194 | rep | KS | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
30073 | 30073 | Hugh Scott S000174 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
25487 | 25487 | Hardie Scott S000172 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
24676 | 24676 | James Scoblick S000163 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 10 | |||||||||||||
24674 | 24674 | Max Schwabe S000156 | rep | MO | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
25485 | 25485 | George Schwabe S000155 | rep | OK | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
25481 | 25481 | Lansdale Sasscer S000067 | rep | MD | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
24671 | 24671 | George Sarbacher S000063 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
25018 | 25018 | John Sanborn S000029 | rep | ID | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
25016 | 25016 | George Sadowski S000011 | rep | MI | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
26573 | 26573 | Antoni Sadlak S000009 | rep | CT | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
25474 | 25474 | Adolph Sabath S000001 | rep | IL | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
24670 | 24670 | Charles Russell R000522 | rep | NV | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
25452 | 25452 | Robert Ross R000453 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
30643 | 30643 | John Rooney R000424 | rep | NY | 1947-01-03 | 1949-01-03 | Democrat | 12 | |||||||||||||
24669 | 24669 | Edward Rohrbough R000410 | rep | WV | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
26994 | 26994 | Edith Rogers R000392 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
25792 | 25792 | Dwight Rogers R000391 | rep | FL | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
24667 | 24667 | Robert Rockwell R000369 | rep | CO | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
24663 | 24663 | John Robsion R000358 | rep | KY | 1947-01-03 | 1948-02-17 | Republican | 9 | |||||||||||||
24649 | 24649 | Charles Robertson R000319 | rep | ND | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
24646 | 24646 | Ross Rizley R000288 | rep | OK | 1947-01-03 | 1949-01-03 | Republican | 8 | |||||||||||||
29446 | 29446 | Lucius Rivers R000280 | rep | SC | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
27480 | 27480 | John Riley R000260 | rep | SC | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
28106 | 28106 | Roy Riehlman R000250 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 36 | |||||||||||||
26111 | 26111 | James Richards R000214 | rep | SC | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
25009 | 25009 | Robert Rich R000209 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 15 | |||||||||||||
25787 | 25787 | Kenneth Regan R000140 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 16 | |||||||||||||
24642 | 24642 | Albert Reeves R000137 | rep | MO | 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 |
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);