legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
300 rows where party = "Republican" and "start" is on date 1929-04-15
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19571 | 19571 | Henry Allen A000126 | sen | KS | 1929-04-15 | 1931-03-03 | 3 | Republican | appointment | ||||||||||||
19573 | 19573 | Joseph Baird B000054 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 13 | |||||||||||||
19587 | 19587 | Robert Blackburn B000509 | rep | KY | 1929-04-15 | 1931-03-03 | Republican | 7 | |||||||||||||
19596 | 19596 | Elbert Brigham B000832 | rep | VT | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
19606 | 19606 | Edward Browne B000955 | rep | WI | 1929-04-15 | 1931-03-03 | Republican | 8 | |||||||||||||
19625 | 19625 | William Chalmers C000274 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 9 | |||||||||||||
19626 | 19626 | Linwood Clark C000446 | rep | MD | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
19627 | 19627 | John Craddock C000849 | rep | KY | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
19636 | 19636 | Louis Cramton C000870 | rep | MI | 1929-04-15 | 1931-03-03 | Republican | 7 | |||||||||||||
19645 | 19645 | Charles Curry C001000 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
19647 | 19647 | Bronson Cutting C001028 | sen | NM | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
19656 | 19656 | Stephen Dempsey D000229 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 40 | |||||||||||||
19664 | 19664 | Edward Denison D000237 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 25 | |||||||||||||
19676 | 19676 | James Dunbar D000525 | rep | IN | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
19683 | 19683 | Richard Elliott E000127 | rep | IN | 1929-04-15 | 1931-03-03 | Republican | 6 | |||||||||||||
19688 | 19688 | Edgar Ellis E000133 | rep | MO | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
19690 | 19690 | Charles Esterly E000222 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 14 | |||||||||||||
19695 | 19695 | Edward Fenn F000072 | rep | CT | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
19702 | 19702 | Simeon Fess F000096 | sen | OH | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
19714 | 19714 | Roy Fitzgerald F000166 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
19717 | 19717 | Franklin Fort F000287 | rep | NJ | 1929-04-15 | 1931-03-03 | Republican | 9 | |||||||||||||
19724 | 19724 | Jacob Garber G000045 | rep | VA | 1929-04-15 | 1931-03-03 | Republican | 7 | |||||||||||||
19731 | 19731 | James Glynn G000246 | rep | CT | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
19732 | 19732 | Phillips Goldsborough G000262 | sen | MD | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
19740 | 19740 | Frank Greene G000425 | sen | VT | 1929-04-15 | 1930-12-17 | 1 | Republican | |||||||||||||
19751 | 19751 | William Griest G000456 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 10 | |||||||||||||
19755 | 19755 | Albert Hall H000042 | rep | IN | 1929-04-15 | 1931-03-03 | Republican | 11 | |||||||||||||
19756 | 19756 | Thomas Halsey H000091 | rep | MO | 1929-04-15 | 1931-03-03 | Republican | 6 | |||||||||||||
19762 | 19762 | Henry Hatfield H000342 | sen | WV | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
19763 | 19763 | Felix Hebert H000436 | sen | RI | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
19769 | 19769 | Andrew Hickey H000560 | rep | IN | 1929-04-15 | 1931-03-03 | Republican | 13 | |||||||||||||
19771 | 19771 | Harold Hoffman H000685 | rep | NJ | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
19773 | 19773 | Robert Howell H000868 | sen | NE | 1929-04-15 | 1933-12-31 | 1 | Republican | |||||||||||||
19777 | 19777 | Grant Hudson H000908 | rep | MI | 1929-04-15 | 1931-03-03 | Republican | 6 | |||||||||||||
19792 | 19792 | James Hughes H000924 | rep | WV | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
19795 | 19795 | Edward Irwin I000040 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 22 | |||||||||||||
19797 | 19797 | Fred Johnson J000130 | rep | NE | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
19798 | 19798 | Rowland Johnston J000197 | rep | MO | 1929-04-15 | 1931-03-03 | Republican | 16 | |||||||||||||
19799 | 19799 | Charles Jonas J000205 | rep | NC | 1929-04-15 | 1931-03-03 | Republican | 9 | |||||||||||||
19800 | 19800 | William Kaynor K000024 | rep | MA | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
19801 | 19801 | Hamilton Kean K000026 | sen | NJ | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
19809 | 19809 | Charles Kearns K000033 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 6 | |||||||||||||
19810 | 19810 | Elva Kendall K000091 | rep | KY | 1929-04-15 | 1931-03-03 | Republican | 9 | |||||||||||||
19815 | 19815 | Charles Kiefner K000167 | rep | MO | 1929-04-15 | 1931-03-03 | Republican | 13 | |||||||||||||
19824 | 19824 | Edgar Kiess K000168 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 16 | |||||||||||||
19834 | 19834 | Franklin Korell K000317 | rep | OR | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
19845 | 19845 | Florian Lampert L000041 | rep | WI | 1929-04-15 | 1931-03-03 | Republican | 6 | |||||||||||||
19847 | 19847 | Katherine Langley L000073 | rep | KY | 1929-04-15 | 1931-03-03 | Republican | 10 | |||||||||||||
19852 | 19852 | Elmer Leatherwood L000181 | rep | UT | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
19856 | 19856 | Fred Letts L000258 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
19866 | 19866 | Ruth McCormick M000372 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | -1 | |||||||||||||
19873 | 19873 | Franklin Menges M000640 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 22 | |||||||||||||
19878 | 19878 | Magne Michaelson M000690 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 7 | |||||||||||||
19885 | 19885 | John Miller M000739 | rep | WA | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
19896 | 19896 | William Morgan M000959 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 17 | |||||||||||||
19897 | 19897 | Judson Newhall N000067 | rep | KY | 1929-04-15 | 1931-03-03 | Republican | 6 | |||||||||||||
19903 | 19903 | Walter Newton N000079 | rep | MN | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
19912 | 19912 | Charles O’Connor O000027 | rep | OK | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
19921 | 19921 | John Palmer P000043 | rep | MO | 1929-04-15 | 1931-03-03 | Republican | 7 | |||||||||||||
19923 | 19923 | Roscoe Patterson P000127 | sen | MO | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
19933 | 19933 | Stephen Porter P000447 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 32 | |||||||||||||
19934 | 19934 | George Pritchard P000544 | rep | NC | 1929-04-15 | 1931-03-03 | Republican | 10 | |||||||||||||
19939 | 19939 | Frank Ramey R000021 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 21 | |||||||||||||
19942 | 19942 | David Reed R000114 | sen | PA | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
19943 | 19943 | Charles Roark R000294 | rep | KY | 1929-04-15 | 1931-03-03 | Republican | -1 | |||||||||||||
19945 | 19945 | Arthur Robinson R000332 | sen | IN | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
19948 | 19948 | Harry Rowbottom R000474 | rep | IN | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
19952 | 19952 | Willis Sears S000212 | rep | NE | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
19953 | 19953 | Joseph Shaffer S000278 | rep | VA | 1929-04-15 | 1931-03-03 | Republican | 9 | |||||||||||||
19954 | 19954 | Albert Simms S000420 | rep | NM | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
19959 | 19959 | Charles Sloan S000491 | rep | NE | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
19964 | 19964 | John Speaks S000707 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 12 | |||||||||||||
19973 | 19973 | Elliott Sproul S000758 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
19977 | 19977 | William Sproul S000759 | rep | KS | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
19999 | 19999 | George Stobbs S000931 | rep | MA | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20000 | 20000 | Ulysses Stone S000964 | rep | OK | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
20006 | 20006 | Daniel Sutherland S001079 | rep | AK | 1929-04-15 | 1931-03-03 | Republican | 0 | |||||||||||||
20024 | 20024 | Charles Thompson T000194 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
20028 | 20028 | Jonathan Wainwright W000023 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 25 | |||||||||||||
20029 | 20029 | Frederic Walcott W000032 | sen | CT | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
20030 | 20030 | Lewis Walker W000063 | rep | KY | 1929-04-15 | 1931-03-03 | Republican | 8 | |||||||||||||
20034 | 20034 | Laurence Watres W000196 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 11 | |||||||||||||
20049 | 20049 | Thomas Williams W000542 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 24 | |||||||||||||
20060 | 20060 | John Wolverton W000684 | rep | WV | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
20067 | 20067 | Frederick Zihlman Z000007 | rep | MD | 1929-04-15 | 1931-03-03 | Republican | 6 | |||||||||||||
20078 | 20078 | Ernest Ackerman A000021 | rep | NJ | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
20082 | 20082 | Charles Adkins A000057 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 19 | |||||||||||||
20087 | 20087 | Richard Aldrich A000084 | rep | RI | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20091 | 20091 | John Allen A000131 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 14 | |||||||||||||
20096 | 20096 | Samuel Arentz A000277 | rep | NV | 1929-04-15 | 1931-03-03 | Republican | 0 | |||||||||||||
20110 | 20110 | Carl Bachmann B000012 | rep | WV | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20118 | 20118 | Henry Barbour B000126 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 7 | |||||||||||||
20124 | 20124 | Edward Beers B000312 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 18 | |||||||||||||
20128 | 20128 | Frank Bohn B000596 | rep | MI | 1929-04-15 | 1931-03-03 | Republican | 11 | |||||||||||||
20133 | 20133 | Charles Brand B000766 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 7 | |||||||||||||
20142 | 20142 | Clark Burdick B001075 | rep | RI | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20148 | 20148 | Olger Burtness B001146 | rep | ND | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20151 | 20151 | Robert Butler B001187 | rep | OR | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20155 | 20155 | John Cable C000007 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20157 | 20157 | Ed Campbell C000081 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 11 |
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);