legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
495 rows where "start" is on date 1939-01-03
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23568 | 23568 | Richard Kleberg K000257 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 14 | |||||||||||||
23576 | 23576 | William Lambertson L000037 | rep | KS | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
23582 | 23582 | Lawrence Lewis L000291 | rep | CO | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
23590 | 23590 | Melvin Maas M000001 | rep | MN | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
23595 | 23595 | James McGranery M000454 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
23601 | 23601 | Donald McLean M000545 | rep | NJ | 1939-01-03 | 1941-01-03 | Republican | 6 | |||||||||||||
23615 | 23615 | Matthew Merritt M000661 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 0 | |||||||||||||
23621 | 23621 | Boleslaus Monkiewicz M000855 | rep | CT | 1939-01-03 | 1941-01-03 | Republican | 0 | |||||||||||||
23630 | 23630 | John Nichols N000092 | rep | OK | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
23633 | 23633 | Joseph O’Brien O000014 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 38 | |||||||||||||
23640 | 23640 | James O’Leary O000065 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 11 | |||||||||||||
23643 | 23643 | Bolívar Pagán P000013 | rep | PR | 1939-01-03 | 1941-01-03 | Coalitionist | 0 | |||||||||||||
23648 | 23648 | Nat Patton P000142 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
23664 | 23664 | Andrew Schiffler S000126 | rep | WV | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
23670 | 23670 | Leonard Schuetz S000144 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
23678 | 23678 | Joseph Smith S000580 | rep | WV | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
23684 | 23684 | Joe Starnes S000816 | rep | AL | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
23699 | 23699 | Henry Steagall S000820 | rep | AL | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
23702 | 23702 | Foster Stearns S000823 | rep | NH | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
23705 | 23705 | Arthur Stewart S000901 | sen | TN | 1939-01-03 | 1943-01-03 | 2 | Democrat | |||||||||||||
23724 | 23724 | Allen Treadway T000358 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
23729 | 23729 | Beverly Vincent V000100 | rep | KY | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
23733 | 23733 | David Ward W000130 | rep | MD | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
23739 | 23739 | William Wheat W000327 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 19 | |||||||||||||
23744 | 23744 | Benjamin Whelchel W000343 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
23772 | 23772 | William Barry B000191 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
23778 | 23778 | Lyle Boren B000640 | rep | OK | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
23783 | 23783 | Michael Bradley B000743 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
23793 | 23793 | William Burgin B001084 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
23798 | 23798 | Arthur Cannon C000115 | rep | FL | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
23810 | 23810 | John Cochran C000565 | rep | MO | 1939-01-03 | 1941-01-03 | Democrat | 13 | |||||||||||||
23815 | 23815 | John Coffee C000584 | rep | WA | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
23834 | 23834 | Samuel Dickstein D000335 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 12 | |||||||||||||
23840 | 23840 | Sheridan Downey D000469 | sen | CA | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
23853 | 23853 | John Gurney G000532 | sen | SD | 1939-01-03 | 1945-01-03 | 3 | Republican | |||||||||||||
23861 | 23861 | Clarence Hancock H000146 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 35 | |||||||||||||
23869 | 23869 | Butler Hare H000200 | rep | SC | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
23886 | 23886 | Pehr Holmes H000741 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
23892 | 23892 | Frank Hook H000757 | rep | MI | 1939-01-03 | 1941-01-03 | Democrat | 12 | |||||||||||||
23897 | 23897 | Edouard Izac I000052 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 20 | |||||||||||||
23907 | 23907 | Jed Johnson J000150 | rep | OK | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
23919 | 23919 | Luther Johnson J000159 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
23927 | 23927 | Edward Kelly K000071 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
23935 | 23935 | John Kinzer K000231 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 10 | |||||||||||||
23956 | 23956 | Fritz Lanham L000076 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 12 | |||||||||||||
23963 | 23963 | Scott Lucas L000493 | sen | IL | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
23971 | 23971 | Paul Maloney M000091 | rep | LA | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
23979 | 23979 | Andrew May M000272 | rep | KY | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
23985 | 23985 | Daniel McGehee M000446 | rep | MS | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
23996 | 23996 | James Mott M001040 | rep | OR | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
24002 | 24002 | Francis Myers M001127 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
24007 | 24007 | James O’Connor O000029 | rep | MT | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
24013 | 24013 | Emmet O’Neal O000089 | rep | KY | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
24021 | 24021 | John Overton O000146 | sen | LA | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
24024 | 24024 | Luther Patrick P000105 | rep | AL | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
24030 | 24030 | Hugh Peterson P000260 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
24037 | 24037 | William Pittenger P000371 | rep | MN | 1939-01-03 | 1941-01-03 | Republican | 8 | |||||||||||||
24045 | 24045 | David Powers P000488 | rep | NJ | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
24056 | 24056 | Robert Ramspeck R000032 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
24060 | 24060 | Clyde Reed R000112 | sen | KS | 1939-01-03 | 1945-01-03 | 3 | Republican | |||||||||||||
24066 | 24066 | James Robinson R000341 | rep | UT | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
24070 | 24070 | Robert Rodgers R000373 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 29 | |||||||||||||
24086 | 24086 | Dave Satterfield S000069 | rep | VA | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
24092 | 24092 | John Sheridan S000342 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
24101 | 24101 | John Snyder S000668 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 24 | |||||||||||||
24109 | 24109 | Jessie Sumner S001071 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 18 | |||||||||||||
24126 | 24126 | Hatton Sumners S001072 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
24139 | 24139 | Malcolm Tarver T000045 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
24150 | 24150 | Elbert Thomas T000164 | sen | UT | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
24156 | 24156 | John Thomas T000177 | sen | OK | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
24160 | 24160 | John Tolan T000295 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
24172 | 24172 | Millard Tydings T000446 | sen | MD | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
24175 | 24175 | Horace Voorhis V000118 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 12 | |||||||||||||
24181 | 24181 | Robert Wagner W000021 | sen | NY | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
24196 | 24196 | Zebulon Weaver W000230 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 11 | |||||||||||||
24203 | 24203 | Thomas Winter W000645 | rep | KS | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
24213 | 24213 | James Wolfenden W000678 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 8 | |||||||||||||
24225 | 24225 | Clifton Woodrum W000720 | rep | VA | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
24237 | 24237 | Thomas Burch B001069 | rep | VA | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
24256 | 24256 | Walter Andrews A000250 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 40 | |||||||||||||
24267 | 24267 | Charles Bell B000332 | rep | MO | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
24275 | 24275 | Frederick Bradley B000742 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 11 | |||||||||||||
24283 | 24283 | Ralph Brewster B000816 | rep | ME | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
24299 | 24299 | Jerome Clark C000439 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
24305 | 24305 | Charles Clason C000473 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
24323 | 24323 | William Courtney C000810 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
24328 | 24328 | William Cravens C000887 | rep | AR | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
24334 | 24334 | Thomas D’Alesandro D000007 | rep | MD | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
24344 | 24344 | John Delaney D000212 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
24364 | 24364 | Patrick Drewry D000496 | rep | VA | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
24371 | 24371 | Alfred Elliott E000119 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 10 | |||||||||||||
24385 | 24385 | John Flannagan F000191 | rep | VA | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
24403 | 24403 | Bertrand Gearhart G000111 | rep | CA | 1939-01-03 | 1941-01-03 | Republican | 9 | |||||||||||||
24408 | 24408 | Charles Gerlach G000135 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 9 | |||||||||||||
24422 | 24422 | Charles Gifford G000169 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 15 | |||||||||||||
24427 | 24427 | George Gillie G000207 | rep | IN | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
24433 | 24433 | Robert Grant G000384 | rep | IN | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
24441 | 24441 | Chester Gross G000493 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 22 | |||||||||||||
24447 | 24447 | John Gwynne G000543 | rep | IA | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
24455 | 24455 | Forest Harness H000217 | rep | IN | 1939-01-03 | 1941-01-03 | Republican | 5 |
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);