legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
499 rows where "end" is on date 1921-03-03 sorted by district descending
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26950 | 26950 | Daniel Reed R000113 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 43 | |||||||||||||
23128 | 23128 | James Mead M000615 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 42 | |||||||||||||
19401 | 19401 | Clarence MacGregor M000009 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 41 | |||||||||||||
19651 | 19651 | Stephen Dempsey D000229 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 40 | |||||||||||||
20826 | 20826 | Archie Sanders S000032 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 39 | |||||||||||||
18156 | 18156 | Thomas Dunn D000553 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 38 | |||||||||||||
18227 | 18227 | Alanson Houghton H000813 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 37 | |||||||||||||
18205 | 18205 | Norman Gould G000342 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 36 | |||||||||||||
19420 | 19420 | Walter Magee M000049 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 35 | |||||||||||||
17775 | 17775 | William Hill H000610 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 34 | |||||||||||||
18858 | 18858 | Homer Snyder S000666 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 33 | |||||||||||||
18776 | 18776 | Luther Mott M001041 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 32 | |||||||||||||
20160 | 20160 | Guy Campbell C000084 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 32 | |||||||||||||
19431 | 19431 | John Morin M000961 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 31 | |||||||||||||
22418 | 22418 | Bertrand Snell S000652 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 31 | |||||||||||||
21352 | 21352 | Melville Kelly K000076 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 30 | |||||||||||||
22945 | 22945 | Frank Crowther C000948 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 30 | |||||||||||||
19928 | 19928 | Stephen Porter P000447 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 29 | |||||||||||||
21467 | 21467 | James Parker P000062 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 29 | |||||||||||||
17782 | 17782 | Willis Hulings H000939 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 28 | |||||||||||||
17912 | 17912 | Rollin Sanford S000053 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 28 | |||||||||||||
18878 | 18878 | Charles Ward W000129 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 27 | |||||||||||||
21562 | 21562 | Nathan Strong S001015 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 27 | |||||||||||||
17889 | 17889 | Edmund Platt P000379 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 26 | |||||||||||||
17967 | 17967 | Henry Steele S000831 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 26 | |||||||||||||
23453 | 23453 | Hamilton Fish F000142 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 26 | |||||||||||||
18234 | 18234 | James Husted H001005 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 25 | |||||||||||||
19659 | 19659 | Edward Denison D000237 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 25 | |||||||||||||
20846 | 20846 | Milton Shreve S000387 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 25 | |||||||||||||
18652 | 18652 | James Ganly G000038 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 24 | |||||||||||||
20044 | 20044 | Thomas Williams W000542 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 24 | |||||||||||||
20919 | 20919 | Henry Temple T000119 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 24 | |||||||||||||
17831 | 17831 | Richard McKiniry M000517 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 23 | |||||||||||||
18071 | 18071 | Edwin Brooks B000877 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 23 | |||||||||||||
20592 | 20592 | Samuel Kendall K000097 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 23 | |||||||||||||
17663 | 17663 | Henry Emerson E000171 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 22 | |||||||||||||
18015 | 18015 | John Wilson W000600 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 22 | |||||||||||||
18450 | 18450 | William Rodenberg R000371 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 22 | |||||||||||||
21781 | 21781 | Anthony Griffin G000457 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 22 | |||||||||||||
17540 | 17540 | John Babka B000007 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 21 | |||||||||||||
17646 | 17646 | Jerome Donovan D000423 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 21 | |||||||||||||
18255 | 18255 | Evan Jones J000217 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 21 | |||||||||||||
19161 | 19161 | Loren Wheeler W000339 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 21 | |||||||||||||
18069 | 18069 | Edward Brooks B000876 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 20 | |||||||||||||
18474 | 18474 | Isaac Siegel S000404 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 20 | |||||||||||||
20714 | 20714 | Charles Mooney M000887 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 20 | |||||||||||||
21519 | 21519 | Henry Rainey R000014 | rep | IL | 1919-05-19 | 1921-03-03 | Democrat | 20 | |||||||||||||
17904 | 17904 | Joseph Rowan R000472 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 19 | |||||||||||||
18352 | 18352 | William McKinley M000521 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 19 | |||||||||||||
18453 | 18453 | John Rose R000437 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 19 | |||||||||||||
21712 | 21712 | John Cooper C000757 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 19 | |||||||||||||
18114 | 18114 | Joseph Cannon C000121 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 18 | |||||||||||||
18300 | 18300 | Aaron Kreider K000327 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 18 | |||||||||||||
19610 | 19610 | John Carew C000142 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 18 | |||||||||||||
20733 | 20733 | Benjamin Murphy M001089 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 18 | |||||||||||||
22638 | 22638 | John Jones J000236 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 18 | |||||||||||||
17881 | 17881 | Herbert Pell P000194 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 17 | |||||||||||||
19184 | 19184 | Frank Smith S000534 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 17 | |||||||||||||
21644 | 21644 | Thomas Blanton B000549 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 17 | |||||||||||||
22148 | 22148 | Benjamin Focht F000230 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 17 | |||||||||||||
22482 | 22482 | William Ashbrook A000306 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 17 | |||||||||||||
17807 | 17807 | John Lesher L000250 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 16 | |||||||||||||
17957 | 17957 | Thomas Smith S000619 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 16 | |||||||||||||
18241 | 18241 | Clifford Ireland I000030 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 16 | |||||||||||||
18550 | 18550 | Joseph Walsh W000101 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 16 | |||||||||||||
19474 | 19474 | Thomas Rubey R000491 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 16 | |||||||||||||
19778 | 19778 | Claude Hudspeth H000910 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 16 | |||||||||||||
19869 | 19869 | Roscoe McCulloch M000392 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 16 | |||||||||||||
17650 | 17650 | Peter Dooling D000426 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 15 | |||||||||||||
18356 | 18356 | Isaac McPherson M000592 | rep | MO | 1919-05-19 | 1921-03-03 | Republican | 15 | |||||||||||||
18671 | 18671 | William Greene G000430 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 15 | |||||||||||||
19380 | 19380 | Edward King K000200 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 15 | |||||||||||||
19819 | 19819 | Edgar Kiess K000168 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 15 | |||||||||||||
20720 | 20720 | Charles Moore M000894 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 15 | |||||||||||||
21289 | 21289 | John Garner G000074 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 15 | |||||||||||||
17559 | 17559 | Carlos Bee B000303 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 14 | |||||||||||||
17877 | 17877 | Richard Olney O000080 | rep | MA | 1919-05-19 | 1921-03-03 | Democrat | 14 | |||||||||||||
18217 | 18217 | Edward Hays H000403 | rep | MO | 1919-05-19 | 1921-03-03 | Republican | 14 | |||||||||||||
18657 | 18657 | William Graham G000364 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 14 | |||||||||||||
19054 | 19054 | Nathan Perlman P000239 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 14 | |||||||||||||
19287 | 19287 | Martin Davey D000080 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 14 | |||||||||||||
20621 | 20621 | Fiorello La Guardia L000007 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 14 | |||||||||||||
21411 | 21411 | Louis McFadden M000434 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 14 | |||||||||||||
17643 | 17643 | Arthur Dewalt D000288 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 13 | |||||||||||||
17874 | 17874 | Charles Nichols N000090 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 13 | |||||||||||||
18413 | 18413 | Lucian Parrish P000083 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 13 | |||||||||||||
18434 | 18434 | Marion Rhodes R000190 | rep | MO | 1919-05-19 | 1921-03-03 | Republican | 13 | |||||||||||||
18753 | 18753 | John McKenzie M000506 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 13 | |||||||||||||
19202 | 19202 | James Begg B000314 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 13 | |||||||||||||
19764 | 19764 | Andrew Hickey H000560 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 13 | |||||||||||||
22664 | 22664 | Robert Luce L000498 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 13 | |||||||||||||
22705 | 22705 | Clarence McLeod M000557 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 13 | |||||||||||||
22793 | 22793 | Christopher Sullivan S001051 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 13 | |||||||||||||
17579 | 17579 | Clement Brumbaugh B000975 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 12 | |||||||||||||
17734 | 17734 | Henry Goldfogle G000260 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 12 | |||||||||||||
17749 | 17749 | James Hamill H000099 | rep | NJ | 1919-05-19 | 1921-03-03 | Democrat | 12 | |||||||||||||
18014 | 18014 | James Wilson W000593 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 12 | |||||||||||||
18431 | 18431 | John Reber R000102 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 12 | |||||||||||||
18634 | 18634 | Louis Fairfield F000007 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 12 | |||||||||||||
18952 | 18952 | Charles Fuller F000407 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 12 |
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);