legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
480 rows where "start" is on date 1949-01-03 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: type, end, party
end (date) 8 ✖
- 1951-01-03 447
- 1955-01-03 27
- 1949-03-06 1
- 1949-12-31 1
- 1950-11-30 1
- 1951-03-08 1
- 1951-12-31 1
- 1954-06-19 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28774 | 28774 | Edward Bartlett B000201 | rep | AK | 1949-01-03 | 1951-01-03 | Democrat | 0 | |||||||||||||
24853 | 24853 | Samuel Hobbs H000663 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
25569 | 25569 | Edward deGraffenried D000198 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
25591 | 25591 | Laurie Battle B000242 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
27117 | 27117 | Frank Boykin B000725 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
27763 | 27763 | Carl Elliott E000120 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
27822 | 27822 | George Grant G000381 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
28097 | 28097 | Albert Rains R000018 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
29547 | 29547 | George Andrews A000206 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
30700 | 30700 | John Sparkman S000701 | sen | AL | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
31082 | 31082 | Robert Jones J000248 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
25515 | 25515 | Boyd Tackett T000005 | rep | AR | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
26373 | 26373 | Lawrence Hays H000405 | rep | AR | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
27403 | 27403 | William Norrell N000137 | rep | AR | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
28451 | 28451 | Oren Harris H000249 | rep | AR | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
28718 | 28718 | James Trimble T000373 | rep | AR | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
28850 | 28850 | Ezekiel Gathings G000098 | rep | AR | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
30566 | 30566 | John McClellan M000332 | sen | AR | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
31186 | 31186 | Wilbur Mills M000778 | rep | AR | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25400 | 25400 | John Murdock M001081 | rep | AZ | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25774 | 25774 | Harold Patten P000107 | rep | AZ | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
24820 | 24820 | Helen Douglas D000454 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 14 | |||||||||||||
25073 | 25073 | Richard Welch W000265 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
25076 | 25076 | Cecil White W000359 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
25125 | 25125 | John Anderson A000196 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 8 | |||||||||||||
25310 | 25310 | Franck Havenner H000356 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
25382 | 25382 | Clinton McKinnon M000528 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 23 | |||||||||||||
25540 | 25540 | Thomas Werdel W000298 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 10 | |||||||||||||
25603 | 25603 | Ernest Bramblett B000762 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 11 | |||||||||||||
25780 | 25780 | C. Poulson P000475 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 13 | |||||||||||||
25999 | 25999 | John Hinshaw H000640 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 20 | |||||||||||||
26025 | 26025 | Justin Johnson J000157 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
26081 | 26081 | John Phillips P000309 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 22 | |||||||||||||
26157 | 26157 | John Allen A000133 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
26587 | 26587 | Hubert Scudder S000198 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26841 | 26841 | Clair Engle E000181 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
26887 | 26887 | Donald Jackson J000008 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 16 | |||||||||||||
27358 | 27358 | Gordon McDonough M000414 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 15 | |||||||||||||
27754 | 27754 | Clyde Doyle D000481 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 18 | |||||||||||||
28131 | 28131 | John Shelley S000327 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
28145 | 28145 | Harry Sheppard S000335 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 21 | |||||||||||||
28946 | 28946 | Cecil King K000196 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 17 | |||||||||||||
29508 | 29508 | Richard Nixon N000116 | rep | CA | 1949-01-03 | 1950-11-30 | Republican | 12 | |||||||||||||
29950 | 29950 | George Miller M000727 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
30484 | 30484 | Chester Holifield H000713 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 19 | |||||||||||||
24867 | 24867 | Edwin Johnson J000127 | sen | CO | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
24918 | 24918 | John Marsalis M000144 | rep | CO | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
26212 | 26212 | John Carroll C000189 | rep | CO | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
26394 | 26394 | William Hill H000613 | rep | CO | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
29559 | 29559 | Wayne Aspinall A000225 | rep | CO | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
24902 | 24902 | John Lodge L000395 | rep | CT | 1949-01-03 | 1951-01-03 | Republican | 4 | |||||||||||||
25100 | 25100 | Chase Woodhouse W000714 | rep | CT | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25380 | 25380 | John McGuire M000465 | rep | CT | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
26556 | 26556 | James Patterson P000119 | rep | CT | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
26574 | 26574 | Antoni Sadlak S000009 | rep | CT | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
31296 | 31296 | Abraham Ribicoff R000191 | rep | CT | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25964 | 25964 | Joseph Frear F000356 | sen | DE | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
28783 | 28783 | James Boggs B000593 | rep | DE | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
24980 | 24980 | James Peterson P000261 | rep | FL | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25793 | 25793 | Dwight Rogers R000391 | rep | FL | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
28164 | 28164 | George Smathers S000505 | rep | FL | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
28895 | 28895 | Albert Herlong H000530 | rep | FL | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
31804 | 31804 | Robert Sikes S000406 | rep | FL | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
34233 | 34233 | Charles Bennett B000371 | rep | FL | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
24971 | 24971 | Stephen Pace P000002 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
25201 | 25201 | Edward Cox C000831 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25549 | 25549 | John Wood W000699 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
25629 | 25629 | Albert Camp C000070 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
25834 | 25834 | William Wheeler W000342 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
26470 | 26470 | Henderson Lanham L000077 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
26756 | 26756 | Paul Brown B000940 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 10 | |||||||||||||
26941 | 26941 | Prince Preston P000516 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
27171 | 27171 | James Davis D000109 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
28221 | 28221 | Carl Vinson V000105 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
29027 | 29027 | Richard Russell R000536 | sen | GA | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
25667 | 25667 | Joseph Farrington F000034 | rep | HI | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
24835 | 24835 | Guy Gillette G000205 | sen | IA | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
25925 | 25925 | James Dolliver D000403 | rep | IA | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
26053 | 26053 | Thomas Martin M000199 | rep | IA | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26278 | 26278 | Paul Cunningham C000993 | rep | IA | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
26487 | 26487 | Karl Le Compte L000157 | rep | IA | 1949-01-03 | 1951-01-03 | Republican | 4 | |||||||||||||
26627 | 26627 | Henry Talle T000028 | rep | IA | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
27888 | 27888 | Charles Hoeven H000678 | rep | IA | 1949-01-03 | 1951-01-03 | Republican | 8 | |||||||||||||
27920 | 27920 | Benton Jensen J000100 | rep | IA | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
30414 | 30414 | Harold Gross G000495 | rep | IA | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
24949 | 24949 | Bert Miller M000716 | sen | ID | 1949-01-03 | 1949-12-31 | 2 | Democrat | |||||||||||||
25019 | 25019 | John Sanborn S000029 | rep | ID | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
25084 | 25084 | Compton White W000361 | rep | ID | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
24774 | 24774 | James Buckley B001028 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
24803 | 24803 | Chester Chesney C000347 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 11 | |||||||||||||
24810 | 24810 | Ralph Church C000390 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 13 | |||||||||||||
24841 | 24841 | Martin Gorski G000332 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
24900 | 24900 | Neil Linehan L000332 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
24925 | 24925 | Rolla McMillen M000574 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 22 | |||||||||||||
25333 | 25333 | Edward Jenison J000080 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 23 | |||||||||||||
25475 | 25475 | Adolph Sabath S000001 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
25598 | 25598 | Cecil Bishop B000486 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 26 | |||||||||||||
25731 | 25731 | Edgar Jonas J000207 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 12 | |||||||||||||
26003 | 26003 | Richard Hoffman H000689 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 10 | |||||||||||||
26100 | 26100 | Chauncey Reed R000111 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 14 |
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);