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 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class
start (date) 10 ✖
- 1949-01-03 447
- 1945-01-03 27
- 1945-03-12 1
- 1948-01-01 1
- 1949-03-29 1
- 1949-05-17 1
- 1949-12-02 1
- 1950-11-27 1
- 1950-11-29 1
- 1950-12-01 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29512 | 29512 | Watkins Abbitt A000002 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
29527 | 29527 | Thomas Abernethy A000016 | rep | MS | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
27061 | 27061 | Hugh Addonizio A000054 | rep | NJ | 1949-01-03 | 1951-01-03 | Democrat | 11 | |||||||||||||
29114 | 29114 | George Aiken A000062 | sen | VT | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
30804 | 30804 | Carl Albert A000073 | rep | OK | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
25118 | 25118 | Asa Allen A000114 | rep | LA | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
26157 | 26157 | John Allen A000133 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
26700 | 26700 | Leo Allen A000138 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 16 | |||||||||||||
27080 | 27080 | Herman Andersen A000179 | rep | MN | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
25125 | 25125 | John Anderson A000196 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 8 | |||||||||||||
29547 | 29547 | George Andrews A000206 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
30145 | 30145 | Leslie Arends A000216 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 17 | |||||||||||||
29559 | 29559 | Wayne Aspinall A000225 | rep | CO | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
27611 | 27611 | James Auchincloss A000227 | rep | NJ | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
26173 | 26173 | August Andresen A000239 | rep | MN | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
25582 | 25582 | Homer Angell A000257 | rep | OR | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
27093 | 27093 | Cleveland Bailey B000035 | rep | WV | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
26715 | 26715 | Graham Barden B000139 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
29571 | 29571 | Walter Baring B000141 | rep | NV | 1949-01-03 | 1951-01-03 | Democrat | 0 | |||||||||||||
25588 | 25588 | Frank Barrett B000176 | rep | WY | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
30821 | 30821 | William Barrett B000178 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
28774 | 28774 | Edward Bartlett B000201 | rep | AK | 1949-01-03 | 1951-01-03 | Democrat | 0 | |||||||||||||
24738 | 24738 | George Bates B000232 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
25136 | 25136 | Joseph Bates B000237 | rep | KY | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
29129 | 29129 | William Bates B000239 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
25591 | 25591 | Laurie Battle B000242 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
26729 | 26729 | James Beall B000271 | rep | MD | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
28322 | 28322 | Lindley Beckworth B000296 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
34233 | 34233 | Charles Bennett B000371 | rep | FL | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
27645 | 27645 | John Bennett B000377 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 12 | |||||||||||||
33815 | 33815 | Lloyd Bentsen B000401 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 15 | |||||||||||||
24741 | 24741 | Andrew Biemiller B000448 | rep | WI | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
25598 | 25598 | Cecil Bishop B000486 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 26 | |||||||||||||
25144 | 25144 | William Blackney B000515 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
24758 | 24758 | Schuyler Bland B000545 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
30166 | 30166 | John Blatnik B000550 | rep | MN | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
24772 | 24772 | Sol Bloom B000565 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 20 | |||||||||||||
28783 | 28783 | James Boggs B000593 | rep | DE | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
29611 | 29611 | Thomas Boggs B000594 | rep | LA | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
32489 | 32489 | Richard Bolling B000605 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
28792 | 28792 | Frances Bolton B000607 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 22 | |||||||||||||
24773 | 24773 | William Bolton B000609 | rep | MD | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
28334 | 28334 | Herbert Bonner B000621 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25146 | 25146 | Reva Bosone B000649 | rep | UT | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
27117 | 27117 | Frank Boykin B000725 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25603 | 25603 | Ernest Bramblett B000762 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 11 | |||||||||||||
25148 | 25148 | Edward Breen B000792 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
25153 | 25153 | Walter Brehm B000794 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 11 | |||||||||||||
27133 | 27133 | Overton Brooks B000884 | rep | LA | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
28348 | 28348 | Clarence Brown B000909 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
26756 | 26756 | Paul Brown B000940 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 10 | |||||||||||||
25613 | 25613 | Joseph Bryson B000999 | rep | SC | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
25157 | 25157 | Frank Buchanan B001002 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 33 | |||||||||||||
27670 | 27670 | Charles Buckley B001024 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 25 | |||||||||||||
24774 | 24774 | James Buckley B001028 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
24788 | 24788 | Alfred Bulwinkle B001056 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 11 | |||||||||||||
26194 | 26194 | Usher Burdick B001079 | rep | ND | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
24789 | 24789 | Thomas Burke B001100 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
31454 | 31454 | Omar Burleson B001111 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 17 | |||||||||||||
25888 | 25888 | Maurice Burnside B001131 | rep | WV | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
25164 | 25164 | Clarence Burton B001148 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
25177 | 25177 | William Byrne B001214 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 32 | |||||||||||||
29652 | 29652 | John Byrnes B001216 | rep | WI | 1949-01-03 | 1951-01-03 | Republican | 8 | |||||||||||||
25629 | 25629 | Albert Camp C000070 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
26786 | 26786 | Gordon Canfield C000113 | rep | NJ | 1949-01-03 | 1951-01-03 | Republican | 8 | |||||||||||||
27692 | 27692 | Clarence Cannon C000117 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
26204 | 26204 | Homer Capehart C000128 | sen | IN | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
27706 | 27706 | Frank Carlson C000154 | sen | KS | 1950-11-29 | 1951-01-03 | 3 | Republican | |||||||||||||
25891 | 25891 | Frank Carlyle C000156 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
26793 | 26793 | Albert Carnahan C000162 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
26212 | 26212 | John Carroll C000189 | rep | CO | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
30225 | 30225 | Clifford Case C000220 | rep | NJ | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
26220 | 26220 | Francis Case C000221 | rep | SD | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
24790 | 24790 | Anthony Cavalcante C000259 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 23 | |||||||||||||
29684 | 29684 | Emanuel Celler C000264 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 15 | |||||||||||||
25896 | 25896 | Richard Chatham C000336 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
28363 | 28363 | Frank Chelf C000342 | rep | KY | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
24803 | 24803 | Chester Chesney C000347 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 11 | |||||||||||||
27147 | 27147 | Robert Chiperfield C000365 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 19 | |||||||||||||
26807 | 26807 | George Christopher C000383 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
26223 | 26223 | Earl Chudoff C000386 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
24810 | 24810 | Ralph Church C000390 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 13 | |||||||||||||
25179 | 25179 | Louis Clemente C000504 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
25108 | 25108 | Earle Clements C000506 | sen | KY | 1950-11-27 | 1951-01-03 | 3 | Democrat | |||||||||||||
26233 | 26233 | Cliff Clevenger C000515 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
24811 | 24811 | Robert Coffey C000586 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 26 | |||||||||||||
25183 | 25183 | Albert Cole C000606 | rep | KS | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26245 | 26245 | William Cole C000617 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 39 | |||||||||||||
29704 | 29704 | William Colmer C000645 | rep | MS | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
25187 | 25187 | Jesse Combs C000655 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
28381 | 28381 | Harold Cooley C000736 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
26260 | 26260 | Jere Cooper C000755 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
29720 | 29720 | Robert Corbett C000772 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 30 | |||||||||||||
30879 | 30879 | Norris Cotton C000802 | rep | NH | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
26266 | 26266 | Frederic Coudert C000804 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 17 | |||||||||||||
25201 | 25201 | Edward Cox C000831 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25210 | 25210 | Fred Crawford C000889 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 8 | |||||||||||||
24814 | 24814 | Thurman Crook C000926 | rep | IN | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
25655 | 25655 | Robert Crosser C000932 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 21 | |||||||||||||
26278 | 26278 | Paul Cunningham C000993 | rep | IA | 1949-01-03 | 1951-01-03 | Republican | 5 |
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);