legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
499 rows where "start" is on date 1929-04-15 sorted by district descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, party, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26955 | 26955 | Daniel Reed R000113 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 43 | |||||||||||||
23133 | 23133 | James Mead M000615 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 42 | |||||||||||||
20228 | 20228 | Edmund Cooke C000730 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 41 | |||||||||||||
19656 | 19656 | Stephen Dempsey D000229 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 40 | |||||||||||||
20831 | 20831 | Archie Sanders S000032 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 39 | |||||||||||||
21600 | 21600 | James Whitley W000420 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 38 | |||||||||||||
21554 | 21554 | Gale Stalker S000783 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 37 | |||||||||||||
20165 | 20165 | Guy Campbell C000084 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 36 | |||||||||||||
27552 | 27552 | John Taber T000001 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 36 | |||||||||||||
20357 | 20357 | Harry Estep E000221 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 35 | |||||||||||||
23856 | 23856 | Clarence Hancock H000146 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 35 | |||||||||||||
20899 | 20899 | Patrick Sullivan S001059 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 34 | |||||||||||||
21202 | 21202 | John Clarke C000465 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 34 | |||||||||||||
20283 | 20283 | Frederick Davenport D000070 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 33 | |||||||||||||
21357 | 21357 | Melville Kelly K000076 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 33 | |||||||||||||
19933 | 19933 | Stephen Porter P000447 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 32 | |||||||||||||
20349 | 20349 | Edmund Erk E000203 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 32 | |||||||||||||
23386 | 23386 | Francis Culkin C000968 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 32 | |||||||||||||
21049 | 21049 | Adam Wyant W000776 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 31 | |||||||||||||
22423 | 22423 | Bertrand Snell S000652 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 31 | |||||||||||||
20255 | 20255 | William Coyle C000844 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 30 | |||||||||||||
22950 | 22950 | Frank Crowther C000948 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 30 | |||||||||||||
20851 | 20851 | Milton Shreve S000387 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 29 | |||||||||||||
21472 | 21472 | James Parker P000062 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 29 | |||||||||||||
21207 | 21207 | Thomas Cochran C000566 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 28 | |||||||||||||
21727 | 21727 | Parker Corning C000785 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 28 | |||||||||||||
20776 | 20776 | Harcourt Pratt P000499 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 27 | |||||||||||||
21567 | 21567 | Nathan Strong S001015 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 27 | |||||||||||||
21579 | 21579 | Jesse Swick S001114 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 26 | |||||||||||||
23458 | 23458 | Hamilton Fish F000142 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 26 | |||||||||||||
19664 | 19664 | Edward Denison D000237 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 25 | |||||||||||||
20028 | 20028 | Jonathan Wainwright W000023 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 25 | |||||||||||||
20924 | 20924 | Henry Temple T000119 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 25 | |||||||||||||
20049 | 20049 | Thomas Williams W000542 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 24 | |||||||||||||
20597 | 20597 | Samuel Kendall K000097 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 24 | |||||||||||||
22742 | 22742 | Claude Parsons P000086 | rep | IL | 1929-04-15 | 1931-03-03 | Democrat | 24 | |||||||||||||
23467 | 23467 | James Fitzpatrick F000175 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 24 | |||||||||||||
20173 | 20173 | James Chase C000328 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 23 | |||||||||||||
21456 | 21456 | Frank Oliver O000072 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 23 | |||||||||||||
21618 | 21618 | William Arnold A000300 | rep | IL | 1929-04-15 | 1931-03-03 | Democrat | 23 | |||||||||||||
19795 | 19795 | Edward Irwin I000040 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 22 | |||||||||||||
19873 | 19873 | Franklin Menges M000640 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 22 | |||||||||||||
21786 | 21786 | Anthony Griffin G000457 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 22 | |||||||||||||
22502 | 22502 | Chester Bolton B000606 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 22 | |||||||||||||
19939 | 19939 | Frank Ramey R000021 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 21 | |||||||||||||
21368 | 21368 | Jacob Kurtz K000344 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 21 | |||||||||||||
23497 | 23497 | Joseph Gavagan G000101 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 21 | |||||||||||||
25645 | 25645 | Robert Crosser C000932 | rep | OH | 1929-04-15 | 1931-03-03 | Democrat | 21 | |||||||||||||
20625 | 20625 | Fiorello La Guardia L000007 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 20 | |||||||||||||
20650 | 20650 | James Leech L000209 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 20 | |||||||||||||
20718 | 20718 | Charles Mooney M000887 | rep | OH | 1929-04-15 | 1931-03-03 | Democrat | 20 | |||||||||||||
21523 | 21523 | Henry Rainey R000014 | rep | IL | 1929-04-15 | 1931-03-03 | Democrat | 20 | |||||||||||||
20082 | 20082 | Charles Adkins A000057 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 19 | |||||||||||||
21717 | 21717 | John Cooper C000757 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 19 | |||||||||||||
21743 | 21743 | Isaac Doutrich D000460 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 19 | |||||||||||||
24762 | 24762 | Sol Bloom B000565 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 19 | |||||||||||||
19615 | 19615 | John Carew C000142 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 18 | |||||||||||||
20124 | 20124 | Edward Beers B000312 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 18 | |||||||||||||
20526 | 20526 | William Holaday H000708 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 18 | |||||||||||||
20738 | 20738 | Benjamin Murphy M001089 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 18 | |||||||||||||
22643 | 22643 | John Jones J000236 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 18 | |||||||||||||
23556 | 23556 | Martin Kennedy K000111 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 18 | |||||||||||||
19853 | 19853 | Robert Lee L000203 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 17 | |||||||||||||
19896 | 19896 | William Morgan M000959 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 17 | |||||||||||||
20459 | 20459 | Homer Hall H000053 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 17 | |||||||||||||
20683 | 20683 | Frederick Magrady M000055 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 17 | |||||||||||||
20778 | 20778 | Ruth Pratt P000505 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 17 | |||||||||||||
21649 | 21649 | Thomas Blanton B000549 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 17 | |||||||||||||
19783 | 19783 | Claude Hudspeth H000910 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 16 | |||||||||||||
19798 | 19798 | Rowland Johnston J000197 | rep | MO | 1929-04-15 | 1931-03-03 | Republican | 16 | |||||||||||||
19824 | 19824 | Edgar Kiess K000168 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 16 | |||||||||||||
20559 | 20559 | William Hull H000946 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 16 | |||||||||||||
20695 | 20695 | Charles McClintock M000339 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 16 | |||||||||||||
22347 | 22347 | John O’Connor O000030 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 16 | |||||||||||||
24417 | 24417 | Charles Gifford G000169 | rep | MA | 1929-04-15 | 1931-03-03 | Republican | 16 | |||||||||||||
25001 | 25001 | Robert Rich R000209 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 16 | |||||||||||||
20183 | 20183 | Burnett Chiperfield C000364 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 15 | |||||||||||||
20693 | 20693 | Joe Manlove M000098 | rep | MO | 1929-04-15 | 1931-03-03 | Republican | 15 | |||||||||||||
20725 | 20725 | Charles Moore M000894 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 15 | |||||||||||||
21294 | 21294 | John Garner G000074 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 15 | |||||||||||||
21416 | 21416 | Louis McFadden M000434 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 15 | |||||||||||||
22057 | 22057 | John Boylan B000726 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 15 | |||||||||||||
28531 | 28531 | Joseph Martin M000191 | rep | MA | 1929-04-15 | 1931-03-03 | Republican | 15 | |||||||||||||
19690 | 19690 | Charles Esterly E000222 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 14 | |||||||||||||
19865 | 19865 | Augustus McCloskey M000341 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 14 | |||||||||||||
20091 | 20091 | John Allen A000131 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 14 | |||||||||||||
20840 | 20840 | Francis Seiberling S000229 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 14 | |||||||||||||
21043 | 21043 | Harry Wurzbach W000775 | rep | TX | 1929-04-15 | 1931-03-03 | Republican | 14 | |||||||||||||
22776 | 22776 | William Sirovich S000452 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 14 | |||||||||||||
26116 | 26116 | Dewey Short S000377 | rep | MO | 1929-04-15 | 1931-03-03 | Republican | 14 | |||||||||||||
26652 | 26652 | Richard Wigglesworth W000450 | rep | MA | 1929-04-15 | 1931-03-03 | Republican | 14 | |||||||||||||
19573 | 19573 | Joseph Baird B000054 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 13 | |||||||||||||
19769 | 19769 | Andrew Hickey H000560 | rep | IN | 1929-04-15 | 1931-03-03 | Republican | 13 | |||||||||||||
19815 | 19815 | Charles Kiefner K000167 | rep | MO | 1929-04-15 | 1931-03-03 | Republican | 13 | |||||||||||||
20586 | 20586 | William Johnson J000181 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 13 | |||||||||||||
21012 | 21012 | Guinn Williams W000501 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 13 | |||||||||||||
21171 | 21171 | George Brumm B000978 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 13 | |||||||||||||
22669 | 22669 | Robert Luce L000498 | rep | MA | 1929-04-15 | 1931-03-03 | Republican | 13 | |||||||||||||
22709 | 22709 | Clarence McLeod M000557 | rep | MI | 1929-04-15 | 1931-03-03 | Republican | 13 | |||||||||||||
22798 | 22798 | Christopher Sullivan S001051 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 13 |
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);