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 legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: party, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29511 | 29511 | Watkins Abbitt A000002 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
29526 | 29526 | Thomas Abernethy A000016 | rep | MS | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
30803 | 30803 | Carl Albert A000073 | rep | OK | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
25117 | 25117 | Asa Allen A000114 | rep | LA | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
26156 | 26156 | John Allen A000133 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
26699 | 26699 | Leo Allen A000138 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 13 | |||||||||||||
24251 | 24251 | James Almond A000163 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
27079 | 27079 | Herman Andersen A000179 | rep | MN | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
25124 | 25124 | John Anderson A000196 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 8 | |||||||||||||
29546 | 29546 | George Andrews A000206 | rep | AL | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
30144 | 30144 | Leslie Arends A000216 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 17 | |||||||||||||
27610 | 27610 | James Auchincloss A000227 | rep | NJ | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
26172 | 26172 | August Andresen A000239 | rep | MN | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
24260 | 24260 | Walter Andrews A000250 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 42 | |||||||||||||
25581 | 25581 | Homer Angell A000257 | rep | OR | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
24263 | 24263 | Samuel Arnold A000296 | rep | MO | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
25128 | 25128 | Claude Bakewell B000080 | rep | MO | 1947-01-03 | 1949-01-03 | Republican | 11 | |||||||||||||
23345 | 23345 | Joseph Ball B000099 | sen | MN | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
24264 | 24264 | Parke Banta B000119 | rep | MO | 1947-01-03 | 1949-01-03 | Republican | 8 | |||||||||||||
26714 | 26714 | Graham Barden B000139 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
25587 | 25587 | Frank Barrett B000176 | rep | WY | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
28773 | 28773 | Edward Bartlett B000201 | rep | AK | 1947-01-03 | 1949-01-03 | Democrat | 0 | |||||||||||||
24737 | 24737 | George Bates B000232 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
25135 | 25135 | Joseph Bates B000237 | rep | KY | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
25590 | 25590 | Laurie Battle B000242 | rep | AL | 1947-01-03 | 1949-01-03 | Democrat | 9 | |||||||||||||
26728 | 26728 | James Beall B000271 | rep | MD | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
28321 | 28321 | Lindley Beckworth B000296 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
24271 | 24271 | Charles Bell B000332 | rep | MO | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
25851 | 25851 | George Bender B000356 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
27644 | 27644 | John Bennett B000377 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 12 | |||||||||||||
24274 | 24274 | Marion Bennett B000379 | rep | MO | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
33814 | 33814 | Lloyd Bentsen B000401 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 15 | |||||||||||||
25597 | 25597 | Cecil Bishop B000486 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 25 | |||||||||||||
25143 | 25143 | William Blackney B000515 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
24757 | 24757 | Schuyler Bland B000545 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
30165 | 30165 | John Blatnik B000550 | rep | MN | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
24771 | 24771 | Sol Bloom B000565 | rep | NY | 1947-01-03 | 1949-01-03 | Democrat | 20 | |||||||||||||
28782 | 28782 | James Boggs B000593 | rep | DE | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
29610 | 29610 | Thomas Boggs B000594 | rep | LA | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
28791 | 28791 | Frances Bolton B000607 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 22 | |||||||||||||
28333 | 28333 | Herbert Bonner B000621 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
27116 | 27116 | Frank Boykin B000725 | rep | AL | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
24280 | 24280 | Willis Bradley B000750 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 18 | |||||||||||||
25602 | 25602 | Ernest Bramblett B000762 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 11 | |||||||||||||
25152 | 25152 | Walter Brehm B000794 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 11 | |||||||||||||
25881 | 25881 | Henry Bridges B000823 | sen | NH | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
23350 | 23350 | Charles Brooks B000874 | sen | IL | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
27132 | 27132 | Overton Brooks B000884 | rep | LA | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
24286 | 24286 | John Brophy B000891 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
24728 | 24728 | Joseph Broughton B000894 | sen | NC | 1948-12-31 | 1949-01-03 | 2 | Democrat | |||||||||||||
28347 | 28347 | Clarence Brown B000909 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
26755 | 26755 | Paul Brown B000940 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 10 | |||||||||||||
25612 | 25612 | Joseph Bryson B000999 | rep | SC | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
25156 | 25156 | Frank Buchanan B001002 | rep | PA | 1947-01-03 | 1949-01-03 | Democrat | 33 | |||||||||||||
23351 | 23351 | Clayton Buck B001013 | sen | DE | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
24289 | 24289 | Ellsworth Buck B001016 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 16 | |||||||||||||
27669 | 27669 | Charles Buckley B001024 | rep | NY | 1947-01-03 | 1949-01-03 | Democrat | 25 | |||||||||||||
25161 | 25161 | Howard Buffett B001039 | rep | NE | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
24787 | 24787 | Alfred Bulwinkle B001056 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 11 | |||||||||||||
24290 | 24290 | Raymond Burke B001096 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
31453 | 31453 | Omar Burleson B001111 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 17 | |||||||||||||
25163 | 25163 | Clarence Burton B001148 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
25618 | 25618 | Fred Busbey B001161 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
25169 | 25169 | John Butler B001179 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 44 | |||||||||||||
25176 | 25176 | William Byrne B001214 | rep | NY | 1947-01-03 | 1949-01-03 | Democrat | 32 | |||||||||||||
29651 | 29651 | John Byrnes B001216 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 8 | |||||||||||||
25628 | 25628 | Albert Camp C000070 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
26785 | 26785 | Gordon Canfield C000113 | rep | NJ | 1947-01-03 | 1949-01-03 | Republican | 8 | |||||||||||||
27691 | 27691 | Clarence Cannon C000117 | rep | MO | 1947-01-03 | 1949-01-03 | Democrat | 9 | |||||||||||||
23360 | 23360 | Arthur Capper C000133 | sen | KS | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
26211 | 26211 | John Carroll C000189 | rep | CO | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
24292 | 24292 | Henderson Carson C000192 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 16 | |||||||||||||
30224 | 30224 | Clifford Case C000220 | rep | NJ | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
26219 | 26219 | Francis Case C000221 | rep | SD | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
29683 | 29683 | Emanuel Celler C000264 | rep | NY | 1947-01-03 | 1949-01-03 | Democrat | 15 | |||||||||||||
24293 | 24293 | E. Chadwick C000268 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
24801 | 24801 | Virgil Chapman C000317 | rep | KY | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
28362 | 28362 | Frank Chelf C000342 | rep | KY | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
27713 | 27713 | John Chenoweth C000346 | rep | CO | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
27146 | 27146 | Robert Chiperfield C000365 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 15 | |||||||||||||
24809 | 24809 | Ralph Church C000390 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 10 | |||||||||||||
24303 | 24303 | Jerome Clark C000439 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
24309 | 24309 | Charles Clason C000473 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
26232 | 26232 | Cliff Clevenger C000515 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
24311 | 24311 | Roy Clippinger C000529 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 24 | |||||||||||||
24312 | 24312 | Howard Coffin C000590 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 13 | |||||||||||||
25182 | 25182 | Albert Cole C000606 | rep | KS | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
25636 | 25636 | William Cole C000614 | rep | MO | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
26244 | 26244 | William Cole C000617 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 39 | |||||||||||||
29703 | 29703 | William Colmer C000645 | rep | MS | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
25186 | 25186 | Jesse Combs C000655 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
28380 | 28380 | Harold Cooley C000736 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
26259 | 26259 | Jere Cooper C000755 | rep | TN | 1947-01-03 | 1949-01-03 | Democrat | 9 | |||||||||||||
28802 | 28802 | John Cooper C000758 | sen | KY | 1946-01-01 | 1949-01-03 | 2 | Republican | |||||||||||||
29719 | 29719 | Robert Corbett C000772 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 30 | |||||||||||||
24812 | 24812 | Guy Cordon C000774 | sen | OR | 1944-03-04 | 1949-01-03 | 2 | Republican | appointment | ||||||||||||
30878 | 30878 | Norris Cotton C000802 | rep | NH | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
26265 | 26265 | Frederic Coudert C000804 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 17 | |||||||||||||
24327 | 24327 | William Courtney C000810 | rep | TN | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
25200 | 25200 | Edward Cox C000831 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 2 |
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);