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 state
This data as json, copyable, CSV (advanced)
Suggested facets: class
start (date) 11 ✖
- 1947-01-03 449
- 1943-01-06 24
- 1945-01-03 2
- 1946-01-01 2
- 1946-11-06 2
- 1948-12-31 2
- 1944-03-04 1
- 1946-12-18 1
- 1947-08-26 1
- 1948-04-17 1
- 1948-05-18 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28773 | 28773 | Edward Bartlett B000201 | rep | AK | 1947-01-03 | 1949-01-03 | Democrat | 0 | |||||||||||||
24486 | 24486 | Peterson Jarman J000058 | rep | AL | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
24576 | 24576 | Carter Manasco M000094 | rep | AL | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
24852 | 24852 | Samuel Hobbs H000663 | rep | AL | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
25590 | 25590 | Laurie Battle B000242 | rep | AL | 1947-01-03 | 1949-01-03 | Democrat | 9 | |||||||||||||
27116 | 27116 | Frank Boykin B000725 | rep | AL | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
27821 | 27821 | George Grant G000381 | rep | AL | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
28096 | 28096 | Albert Rains R000018 | rep | AL | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
29546 | 29546 | George Andrews A000206 | rep | AL | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
30699 | 30699 | John Sparkman S000701 | sen | AL | 1946-11-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
31081 | 31081 | Robert Jones J000248 | rep | AL | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
24332 | 24332 | William Cravens C000887 | rep | AR | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
26372 | 26372 | Lawrence Hays H000405 | rep | AR | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
27402 | 27402 | William Norrell N000137 | rep | AR | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
28450 | 28450 | Oren Harris H000249 | rep | AR | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
28717 | 28717 | James Trimble T000373 | rep | AR | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
28849 | 28849 | Ezekiel Gathings G000098 | rep | AR | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
30565 | 30565 | John McClellan M000332 | sen | AR | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
31185 | 31185 | Wilbur Mills M000778 | rep | AR | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
24454 | 24454 | Richard Harless H000212 | rep | AZ | 1947-01-03 | 1949-01-03 | Democrat | 0 | |||||||||||||
25399 | 25399 | John Murdock M001081 | rep | AZ | 1947-01-03 | 1949-01-03 | Democrat | 0 | |||||||||||||
24280 | 24280 | Willis Bradley B000750 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 18 | |||||||||||||
24375 | 24375 | Alfred Elliott E000119 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 10 | |||||||||||||
24390 | 24390 | Charles Fletcher F000199 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 23 | |||||||||||||
24407 | 24407 | Bertrand Gearhart G000111 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
24550 | 24550 | Clarence Lea L000163 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
24819 | 24819 | Helen Douglas D000454 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 14 | |||||||||||||
25072 | 25072 | Richard Welch W000265 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
25124 | 25124 | John Anderson A000196 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 8 | |||||||||||||
25309 | 25309 | Franck Havenner H000356 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
25602 | 25602 | Ernest Bramblett B000762 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 11 | |||||||||||||
25779 | 25779 | C. Poulson P000475 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 13 | |||||||||||||
25998 | 25998 | John Hinshaw H000640 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 20 | |||||||||||||
26024 | 26024 | Justin Johnson J000157 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
26080 | 26080 | John Phillips P000309 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 22 | |||||||||||||
26156 | 26156 | John Allen A000133 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
26840 | 26840 | Clair Engle E000181 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
26886 | 26886 | Donald Jackson J000008 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 16 | |||||||||||||
27357 | 27357 | Gordon McDonough M000414 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 15 | |||||||||||||
28144 | 28144 | Harry Sheppard S000335 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 21 | |||||||||||||
28945 | 28945 | Cecil King K000196 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 17 | |||||||||||||
29507 | 29507 | Richard Nixon N000116 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 12 | |||||||||||||
29949 | 29949 | George Miller M000727 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
30483 | 30483 | Chester Holifield H000713 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 19 | |||||||||||||
24667 | 24667 | Robert Rockwell R000369 | rep | CO | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
24866 | 24866 | Edwin Johnson J000127 | sen | CO | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
26211 | 26211 | John Carroll C000189 | rep | CO | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
26393 | 26393 | William Hill H000613 | rep | CO | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
27713 | 27713 | John Chenoweth C000346 | rep | CO | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
24395 | 24395 | Ellsworth Foote F000250 | rep | CT | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
24618 | 24618 | William Miller M000764 | rep | CT | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
24901 | 24901 | John Lodge L000395 | rep | CT | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
26555 | 26555 | James Patterson P000119 | rep | CT | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
26573 | 26573 | Antoni Sadlak S000009 | rep | CT | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
27521 | 27521 | Horace Seely-Brown S000224 | rep | CT | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
23351 | 23351 | Clayton Buck B001013 | sen | DE | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
28782 | 28782 | James Boggs B000593 | rep | DE | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
24475 | 24475 | Joseph Hendricks H000492 | rep | FL | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
24634 | 24634 | Emory Price P000524 | rep | FL | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
24979 | 24979 | James Peterson P000261 | rep | FL | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
25792 | 25792 | Dwight Rogers R000391 | rep | FL | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
28163 | 28163 | George Smathers S000505 | rep | FL | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
31803 | 31803 | Robert Sikes S000406 | rep | FL | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
24970 | 24970 | Stephen Pace P000002 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
25200 | 25200 | Edward Cox C000831 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
25548 | 25548 | John Wood W000699 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 9 | |||||||||||||
25628 | 25628 | Albert Camp C000070 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
25833 | 25833 | William Wheeler W000342 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
26469 | 26469 | Henderson Lanham L000077 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
26755 | 26755 | Paul Brown B000940 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 10 | |||||||||||||
26940 | 26940 | Prince Preston P000516 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
27170 | 27170 | James Davis D000109 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
28220 | 28220 | Carl Vinson V000105 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
29026 | 29026 | Richard Russell R000536 | sen | GA | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
25666 | 25666 | Joseph Farrington F000034 | rep | HI | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
23758 | 23758 | George Wilson W000581 | sen | IA | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
24451 | 24451 | John Gwynne G000543 | rep | IA | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
25924 | 25924 | James Dolliver D000403 | rep | IA | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
26052 | 26052 | Thomas Martin M000199 | rep | IA | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
26277 | 26277 | Paul Cunningham C000993 | rep | IA | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
26486 | 26486 | Karl Le Compte L000157 | rep | IA | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
26626 | 26626 | Henry Talle T000028 | rep | IA | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
27887 | 27887 | Charles Hoeven H000678 | rep | IA | 1947-01-03 | 1949-01-03 | Republican | 8 | |||||||||||||
27919 | 27919 | Benton Jensen J000100 | rep | IA | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
24432 | 24432 | Abe Goff G000253 | rep | ID | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
25018 | 25018 | John Sanborn S000029 | rep | ID | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
27188 | 27188 | Henry Dworshak D000585 | sen | ID | 1946-01-01 | 1949-01-03 | 2 | Republican | |||||||||||||
23350 | 23350 | Charles Brooks B000874 | sen | IL | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
24311 | 24311 | Roy Clippinger C000529 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 24 | |||||||||||||
24479 | 24479 | George Howell H000863 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 21 | |||||||||||||
24492 | 24492 | Anton Johnson J000117 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 14 | |||||||||||||
24625 | 24625 | Thomas Owens O000160 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
24688 | 24688 | William Stratton S000998 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
24706 | 24706 | Robert Twyman T000444 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
24809 | 24809 | Ralph Church C000390 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 10 | |||||||||||||
24840 | 24840 | Martin Gorski G000332 | rep | IL | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
24924 | 24924 | Rolla McMillen M000574 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 19 | |||||||||||||
25332 | 25332 | Edward Jenison J000080 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 18 | |||||||||||||
25474 | 25474 | Adolph Sabath S000001 | rep | IL | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
25534 | 25534 | Richard Vail V000003 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 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);