legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
502 rows where "end" is on date 1931-03-03 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19723 | 19723 | Isauro Gabaldon G000001 | rep | PI | 1929-04-15 | 1931-03-03 | 0 | ||||||||||||||
21459 | 21459 | Camilo Osias O000118 | rep | PI | 1929-04-15 | 1931-03-03 | 0 | ||||||||||||||
21793 | 21793 | Pedro Guevara G000518 | rep | PI | 1929-04-15 | 1931-03-03 | 0 | ||||||||||||||
18914 | 18914 | Coleman Blease B000553 | sen | SC | 1925-12-07 | 1931-03-03 | 2 | Democrat | |||||||||||||
18989 | 18989 | James Heflin H000446 | sen | AL | 1925-12-07 | 1931-03-03 | 2 | Democrat | |||||||||||||
19080 | 19080 | Joseph Ransdell R000059 | sen | LA | 1925-12-07 | 1931-03-03 | 2 | Democrat | |||||||||||||
19108 | 19108 | Furnifold Simmons S000415 | sen | NC | 1925-12-07 | 1931-03-03 | 2 | Democrat | |||||||||||||
19185 | 19185 | Daniel Steck S000826 | sen | IA | 1926-01-01 | 1931-03-03 | 2 | Democrat | |||||||||||||
19586 | 19586 | Thomas Bell B000348 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 9 | |||||||||||||
19593 | 19593 | John Box B000710 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
19597 | 19597 | William Brock B000850 | sen | TN | 1929-09-02 | 1931-03-03 | 2 | Democrat | appointment | ||||||||||||
19615 | 19615 | John Carew C000142 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 18 | |||||||||||||
19621 | 19621 | John Casey C000223 | rep | PA | 1929-04-15 | 1931-03-03 | Democrat | 12 | |||||||||||||
19669 | 19669 | John Dorsey D000440 | rep | KY | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
19673 | 19673 | Thomas Doyle D000483 | rep | IL | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
19709 | 19709 | Hubert Fisher F000149 | rep | TN | 1929-04-15 | 1931-03-03 | Democrat | 10 | |||||||||||||
19761 | 19761 | William Hammer H000123 | rep | NC | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
19783 | 19783 | Claude Hudspeth H000910 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 16 | |||||||||||||
19796 | 19796 | Hinton James J000050 | rep | NC | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
19832 | 19832 | David Kincheloe K000187 | rep | KY | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
19853 | 19853 | Robert Lee L000203 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 17 | |||||||||||||
19864 | 19864 | Whitmell Martin M000201 | rep | LA | 1929-04-15 | 1931-03-03 | Democrat | -1 | |||||||||||||
19865 | 19865 | Augustus McCloskey M000341 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 14 | |||||||||||||
19891 | 19891 | Robert Moore M000915 | rep | VA | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
19908 | 19908 | David O’Connell O000022 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 9 | |||||||||||||
19911 | 19911 | Jeremiah O’Connell O000023 | rep | RI | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
19918 | 19918 | James O’Connor O000028 | rep | LA | 1929-04-15 | 1931-03-03 | Democrat | 1 | |||||||||||||
19920 | 19920 | Pearl Oldfield O000061 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
19938 | 19938 | John Quayle Q000008 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
19968 | 19968 | James Spearing S000708 | rep | LA | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
19987 | 19987 | Charles Stedman S000827 | rep | NC | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
19989 | 19989 | Leslie Steele S000835 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
20038 | 20038 | Royal Weller W000277 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | -1 | |||||||||||||
20041 | 20041 | Joseph Whitehead W000400 | rep | VA | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
20058 | 20058 | Otis Wingo W000635 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
20072 | 20072 | Ben Williamson W000550 | sen | KY | 1930-01-01 | 1931-03-03 | 2 | Democrat | |||||||||||||
20106 | 20106 | James Aswell A000321 | rep | LA | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
20135 | 20135 | Sam Bratton B000774 | sen | NM | 1925-12-07 | 1931-03-03 | 2 | Democrat | |||||||||||||
20170 | 20170 | Harry Canfield C000114 | rep | IN | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
20220 | 20220 | James Collier C000630 | rep | MS | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
20269 | 20269 | Charles Crisp C000909 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
20290 | 20290 | Ewin Davis D000098 | rep | TN | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
20306 | 20306 | Frederick Dominick D000408 | rep | SC | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
20309 | 20309 | Lewis Douglas D000455 | rep | AZ | 1929-04-15 | 1931-03-03 | Democrat | 0 | |||||||||||||
20317 | 20317 | Herbert Drane D000486 | rep | FL | 1929-04-15 | 1931-03-03 | Democrat | 1 | |||||||||||||
20347 | 20347 | Charles Edwards E000062 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 1 | |||||||||||||
20353 | 20353 | Edward Eslick E000216 | rep | TN | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
20366 | 20366 | John Evans E000247 | rep | MT | 1929-04-15 | 1931-03-03 | Democrat | 1 | |||||||||||||
20414 | 20414 | Daniel Garrett G000081 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
20461 | 20461 | Robert Hall H000069 | rep | MS | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
20476 | 20476 | William Harris H000259 | sen | GA | 1925-12-07 | 1931-03-03 | 2 | Democrat | |||||||||||||
20549 | 20549 | Cordell Hull H000940 | rep | TN | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
20562 | 20562 | James Igoe I000003 | rep | IL | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
20618 | 20618 | Stanley Kunz K000342 | rep | IL | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
20634 | 20634 | William Lankford L000082 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 11 | |||||||||||||
20642 | 20642 | William Larsen L000103 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 12 | |||||||||||||
20662 | 20662 | John Linthicum L000340 | rep | MD | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
20718 | 20718 | Charles Mooney M000887 | rep | OH | 1929-04-15 | 1931-03-03 | Democrat | 20 | |||||||||||||
20729 | 20729 | John Moore M000905 | rep | KY | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
20766 | 20766 | Ruth Owen O000154 | rep | FL | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
20770 | 20770 | LaFayette Patterson P000125 | rep | AL | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
20796 | 20796 | Percy Quin Q000014 | rep | MS | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
20814 | 20814 | Joseph Robinson R000347 | sen | AR | 1925-12-07 | 1931-03-03 | 2 | Democrat | |||||||||||||
20823 | 20823 | Samuel Rutherford R000549 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
20888 | 20888 | William Stevenson S000895 | rep | SC | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
20960 | 20960 | Henry Tucker T000399 | rep | VA | 1929-04-15 | 1931-03-03 | Democrat | 10 | |||||||||||||
20983 | 20983 | Thomas Walsh W000104 | sen | MT | 1925-12-07 | 1931-03-03 | 2 | Democrat | |||||||||||||
21012 | 21012 | Guinn Williams W000501 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 13 | |||||||||||||
21020 | 21020 | Effiegene Wingo W000634 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
21037 | 21037 | William Wright W000773 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
21059 | 21059 | Thomas Yon Y000021 | rep | FL | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
21070 | 21070 | Charles Abernethy A000015 | rep | NC | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
21077 | 21077 | Miles Allgood A000156 | rep | AL | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
21087 | 21087 | Edward Almon A000162 | rep | AL | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
21093 | 21093 | Oscar Auf Der Heide A000338 | rep | NJ | 1929-04-15 | 1931-03-03 | Democrat | 11 | |||||||||||||
21102 | 21102 | William Ayres A000354 | rep | KS | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
21124 | 21124 | Loring Black B000505 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
21139 | 21139 | Charles Brand B000767 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
21147 | 21147 | Clay Briggs B000826 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
21166 | 21166 | Gordon Browning B000959 | rep | TN | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
21182 | 21182 | Thomas Busby B001163 | rep | MS | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
21187 | 21187 | Patrick Carley C000149 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
21238 | 21238 | John Douglass D000459 | rep | MA | 1929-04-15 | 1931-03-03 | Democrat | 10 | |||||||||||||
21294 | 21294 | John Garner G000074 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 15 | |||||||||||||
21298 | 21298 | David Glover G000243 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
21312 | 21312 | William Hastings H000333 | rep | OK | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
21327 | 21327 | Edgar Howard H000836 | rep | NE | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
21345 | 21345 | Lamar Jeffers J000068 | rep | AL | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
21362 | 21362 | Bolivar Kemp K000085 | rep | LA | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
21376 | 21376 | George Lindsay L000325 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
21387 | 21387 | Ralph Lozier L000489 | rep | MO | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
21406 | 21406 | James McClintic M000338 | rep | OK | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
21428 | 21428 | Thomas McKeown M000511 | rep | OK | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
21435 | 21435 | Jacob Milligan M000766 | rep | MO | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
21441 | 21441 | John Morehead M000939 | rep | NE | 1929-04-15 | 1931-03-03 | Democrat | 1 | |||||||||||||
21456 | 21456 | Frank Oliver O000072 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 23 | |||||||||||||
21496 | 21496 | Edward Pou P000474 | rep | NC | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
21502 | 21502 | Anning Prall P000495 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 11 | |||||||||||||
21508 | 21508 | Heartsill Ragon R000009 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
21523 | 21523 | Henry Rainey R000014 | rep | IL | 1929-04-15 | 1931-03-03 | Democrat | 20 |
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);