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 district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25186 | 25186 | Jesse Combs C000655 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
25200 | 25200 | Edward Cox C000831 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
25303 | 25303 | Leonard Hall H000060 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
25360 | 25360 | John Kerr K000138 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
25503 | 25503 | William Stigler S000923 | rep | OK | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
25508 | 25508 | Lowell Stockman S000936 | rep | OR | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
25534 | 25534 | Richard Vail V000003 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
25659 | 25659 | Wesley D’Ewart D000281 | rep | MT | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
25988 | 25988 | Thomas Hand H000154 | rep | NJ | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
26219 | 26219 | Francis Case C000221 | rep | SD | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
26283 | 26283 | William Dawson D000155 | rep | UT | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
26393 | 26393 | William Hill H000613 | rep | CO | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
26549 | 26549 | Joseph O’Hara O000056 | rep | MN | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
26581 | 26581 | Errett Scrivner S000194 | rep | KS | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
26626 | 26626 | Henry Talle T000028 | rep | IA | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
26840 | 26840 | Clair Engle E000181 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
26875 | 26875 | William Hess H000550 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
27480 | 27480 | John Riley R000260 | rep | SC | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
27521 | 27521 | Horace Seely-Brown S000224 | rep | CT | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
27821 | 27821 | George Grant G000381 | rep | AL | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
28833 | 28833 | John Fogarty F000233 | rep | RI | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
28866 | 28866 | Charles Halleck H000081 | rep | IN | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
28877 | 28877 | Porter Hardy H000197 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
29044 | 29044 | Margaret Smith S000590 | rep | ME | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
29610 | 29610 | Thomas Boggs B000594 | rep | LA | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
30276 | 30276 | Glenn Davis D000102 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
30878 | 30878 | Norris Cotton C000802 | rep | NH | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
31185 | 31185 | Wilbur Mills M000778 | rep | AR | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
33002 | 33002 | Henry Jackson J000013 | rep | WA | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
35645 | 35645 | Jamie Whitten W000428 | rep | MS | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
24290 | 24290 | Raymond Burke B001096 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
24338 | 24338 | Thomas D’Alesandro D000007 | rep | MD | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
24353 | 24353 | James Domengeaux D000406 | rep | LA | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
24395 | 24395 | Ellsworth Foote F000250 | rep | CT | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
24437 | 24437 | Robert Grant G000384 | rep | IN | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
24451 | 24451 | John Gwynne G000543 | rep | IA | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
24571 | 24571 | George MacKinnon M000027 | rep | MN | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
24623 | 24623 | Fred Norman N000135 | rep | WA | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
24669 | 24669 | Edward Rohrbough R000410 | rep | WV | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
24686 | 24686 | William Stevenson S000896 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
24931 | 24931 | Herbert Meyer M000680 | rep | KS | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
24970 | 24970 | Stephen Pace P000002 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
25096 | 25096 | William Whittington W000430 | rep | MS | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
25259 | 25259 | Frank Fellows F000066 | rep | ME | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
25487 | 25487 | Hardie Scott S000172 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
25498 | 25498 | Karl Stefan S000845 | rep | NE | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
25581 | 25581 | Homer Angell A000257 | rep | OR | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
25618 | 25618 | Fred Busbey B001161 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
25636 | 25636 | William Cole C000614 | rep | MO | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
25804 | 25804 | Paul Shafer S000277 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
26024 | 26024 | Justin Johnson J000157 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
26476 | 26476 | Henry Latham L000108 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
26714 | 26714 | Graham Barden B000139 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
26906 | 26906 | Russell Mack M000021 | rep | WA | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
27280 | 27280 | Carey Kefauver K000044 | rep | TN | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
27610 | 27610 | James Auchincloss A000227 | rep | NJ | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
27713 | 27713 | John Chenoweth C000346 | rep | CO | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
27791 | 27791 | Julian Gary G000091 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
28036 | 28036 | Thruston Morton M001022 | rep | KY | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
28321 | 28321 | Lindley Beckworth B000296 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
28717 | 28717 | James Trimble T000373 | rep | AR | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
29408 | 29408 | Philip Philbin P000303 | rep | MA | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
29546 | 29546 | George Andrews A000206 | rep | AL | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
29801 | 29801 | Edward Garmatz G000071 | rep | MD | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
30316 | 30316 | William Dorn D000434 | rep | SC | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
30803 | 30803 | Carl Albert A000073 | rep | OK | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
31803 | 31803 | Robert Sikes S000406 | rep | FL | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
24271 | 24271 | Charles Bell B000332 | rep | MO | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
24286 | 24286 | John Brophy B000891 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
24332 | 24332 | William Cravens C000887 | rep | AR | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
24349 | 24349 | Edward Devitt D000280 | rep | MN | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
24368 | 24368 | Patrick Drewry D000496 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
24378 | 24378 | Hubert Ellis E000135 | rep | WV | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
24431 | 24431 | George Gillie G000207 | rep | IN | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
24493 | 24493 | Glen Johnson J000133 | rep | OK | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
24507 | 24507 | Robert Jones J000249 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
24572 | 24572 | Franklin Maloney M000089 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
24594 | 24594 | Frank Mathews M000233 | rep | NJ | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
24613 | 24613 | Gregory McMahon M000560 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
24667 | 24667 | Robert Rockwell R000369 | rep | CO | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
24840 | 24840 | Martin Gorski G000332 | rep | IL | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
24852 | 24852 | Samuel Hobbs H000663 | rep | AL | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
24901 | 24901 | John Lodge L000395 | rep | CT | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
25309 | 25309 | Franck Havenner H000356 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
25612 | 25612 | Joseph Bryson B000999 | rep | SC | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
25628 | 25628 | Albert Camp C000070 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
25946 | 25946 | Mathew Ellsworth E000146 | rep | OR | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
26405 | 26405 | Otis Holmes H000740 | rep | WA | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
26486 | 26486 | Karl Le Compte L000157 | rep | IA | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
26521 | 26521 | Arthur Miller M000715 | rep | NE | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
26976 | 26976 | Edward Rees R000132 | rep | KS | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
27132 | 27132 | Overton Brooks B000884 | rep | LA | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
27237 | 27237 | Clare Hoffman H000683 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
27451 | 27451 | Samuel Rayburn R000082 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
28163 | 28163 | George Smathers S000505 | rep | FL | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
28362 | 28362 | Frank Chelf C000342 | rep | KY | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
28380 | 28380 | Harold Cooley C000736 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
28429 | 28429 | Albert Gore G000320 | rep | TN | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
29236 | 29236 | George Fallon F000012 | rep | MD | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
29511 | 29511 | Watkins Abbitt A000002 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 4 |
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);