legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
487 rows where "start" is on date 1943-01-06
This data as json, copyable, CSV (advanced)
end (date) 2 ✖
- 1945-01-03 375
- 1949-01-03 12
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23760 | 23760 | James Wright W000762 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 32 | |||||||||||||
23765 | 23765 | Harry Baldwin B000086 | rep | MD | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23768 | 23768 | Joseph Baldwin B000093 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 17 | |||||||||||||
23774 | 23774 | William Barry B000191 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23780 | 23780 | Lyle Boren B000640 | rep | OK | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
23785 | 23785 | Michael Bradley B000743 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
23788 | 23788 | David Brumbaugh B000976 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 23 | |||||||||||||
23795 | 23795 | William Burgin B001084 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
23800 | 23800 | Arthur Cannon C000115 | rep | FL | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
23812 | 23812 | John Cochran C000565 | rep | MO | 1943-01-06 | 1945-01-03 | Democrat | 13 | |||||||||||||
23817 | 23817 | John Coffee C000584 | rep | WA | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
23821 | 23821 | James Curley C000996 | rep | MA | 1943-01-06 | 1945-01-03 | Democrat | 11 | |||||||||||||
23823 | 23823 | Ralph Daughton D000067 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23836 | 23836 | Samuel Dickstein D000335 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 12 | |||||||||||||
23848 | 23848 | John Gibson G000163 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
23850 | 23850 | Dean Gillespie G000194 | rep | CO | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
23863 | 23863 | Clarence Hancock H000146 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 35 | |||||||||||||
23871 | 23871 | Butler Hare H000200 | rep | SC | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
23876 | 23876 | James Heidinger H000450 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 24 | |||||||||||||
23879 | 23879 | Daniel Hoch H000668 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 14 | |||||||||||||
23888 | 23888 | Pehr Holmes H000741 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
23899 | 23899 | Edouard Izac I000052 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 23 | |||||||||||||
23909 | 23909 | Jed Johnson J000150 | rep | OK | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
23921 | 23921 | Luther Johnson J000159 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
23937 | 23937 | John Kinzer K000231 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 10 | |||||||||||||
23944 | 23944 | Charles La Follette L000003 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
23958 | 23958 | Fritz Lanham L000076 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 12 | |||||||||||||
23965 | 23965 | Clare Luce L000497 | rep | CT | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
23972 | 23972 | Paul Maloney M000091 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23981 | 23981 | Andrew May M000272 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
23987 | 23987 | Daniel McGehee M000446 | rep | MS | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
23990 | 23990 | Charles McKenzie M000504 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
23998 | 23998 | James Mott M001040 | rep | OR | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
24000 | 24000 | John Murphy M001099 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 11 | |||||||||||||
24004 | 24004 | Francis Myers M001127 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
24009 | 24009 | James O’Connor O000029 | rep | MT | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
24015 | 24015 | Emmet O’Neal O000089 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
24017 | 24017 | George Outland O000137 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 11 | |||||||||||||
24032 | 24032 | Hugh Peterson P000260 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
24039 | 24039 | William Pittenger P000371 | rep | MN | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
24047 | 24047 | David Powers P000488 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
24058 | 24058 | Robert Ramspeck R000032 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
24068 | 24068 | James Robinson R000341 | rep | UT | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
24072 | 24072 | Robert Rodgers R000373 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 29 | |||||||||||||
24077 | 24077 | Carlos Romulo R000419 | rep | PI | 1943-01-06 | 1945-01-03 | 0 | ||||||||||||||
24079 | 24079 | William Rowan R000473 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
24082 | 24082 | Sam Russell R000538 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 17 | |||||||||||||
24088 | 24088 | Dave Satterfield S000069 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
24094 | 24094 | John Sheridan S000342 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24096 | 24096 | Roger Slaughter S000481 | rep | MO | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
24103 | 24103 | John Snyder S000668 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 24 | |||||||||||||
24107 | 24107 | Paul Stewart S000918 | rep | OK | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
24111 | 24111 | Jessie Sumner S001071 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 18 | |||||||||||||
24128 | 24128 | Hatton Sumners S001072 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
24131 | 24131 | Joseph Talbot T000018 | rep | CT | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
24141 | 24141 | Malcolm Tarver T000045 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
24162 | 24162 | John Tolan T000295 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
24164 | 24164 | James Torrens T000315 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 21 | |||||||||||||
24177 | 24177 | Horace Voorhis V000118 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 12 | |||||||||||||
24184 | 24184 | Thaddeus Wasielewski W000183 | rep | WI | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24198 | 24198 | Zebulon Weaver W000230 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 12 | |||||||||||||
24201 | 24201 | Samuel Weiss W000257 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 30 | |||||||||||||
24205 | 24205 | Thomas Winter W000645 | rep | KS | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
24215 | 24215 | James Wolfenden W000678 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
24227 | 24227 | Clifton Woodrum W000720 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
24239 | 24239 | Thomas Burch B001069 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
24258 | 24258 | Walter Andrews A000250 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 40 | |||||||||||||
24261 | 24261 | Samuel Arnold A000296 | rep | MO | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
24269 | 24269 | Charles Bell B000332 | rep | MO | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24272 | 24272 | Marion Bennett B000379 | rep | MO | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
24277 | 24277 | Frederick Bradley B000742 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 11 | |||||||||||||
24287 | 24287 | Ellsworth Buck B001016 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 11 | |||||||||||||
24291 | 24291 | Henderson Carson C000192 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 16 | |||||||||||||
24301 | 24301 | Jerome Clark C000439 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
24307 | 24307 | Charles Clason C000473 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
24325 | 24325 | William Courtney C000810 | rep | TN | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
24330 | 24330 | William Cravens C000887 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24336 | 24336 | Thomas D’Alesandro D000007 | rep | MD | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
24346 | 24346 | John Delaney D000212 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
24351 | 24351 | James Domengeaux D000406 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
24366 | 24366 | Patrick Drewry D000496 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24373 | 24373 | Alfred Elliott E000119 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 10 | |||||||||||||
24376 | 24376 | Hubert Ellis E000135 | rep | WV | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
24387 | 24387 | John Flannagan F000191 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 9 | |||||||||||||
24392 | 24392 | John Folger F000241 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
24396 | 24396 | Hadwen Fuller F000404 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 32 | |||||||||||||
24399 | 24399 | James Gallagher G000017 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
24405 | 24405 | Bertrand Gearhart G000111 | rep | CA | 1943-01-06 | 1945-01-03 | Republican | 9 | |||||||||||||
24410 | 24410 | Charles Gerlach G000135 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 9 | |||||||||||||
24424 | 24424 | Charles Gifford G000169 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 9 | |||||||||||||
24429 | 24429 | George Gillie G000207 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
24435 | 24435 | Robert Grant G000384 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
24438 | 24438 | Percy Griffiths G000472 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 15 | |||||||||||||
24442 | 24442 | Chester Gross G000493 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 22 | |||||||||||||
24449 | 24449 | John Gwynne G000543 | rep | IA | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
24452 | 24452 | Richard Harless H000212 | rep | AZ | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
24457 | 24457 | Forest Harness H000217 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
24467 | 24467 | Fred Hartley H000298 | rep | NJ | 1943-01-06 | 1945-01-03 | Republican | 10 | |||||||||||||
24473 | 24473 | Joseph Hendricks H000492 | rep | FL | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
24477 | 24477 | George Howell H000863 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 21 |
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);