legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
485 rows where "start" is on date 1947-01-03 sorted by legislator_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24327 | 24327 | William Courtney C000810 | rep | TN | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
25200 | 25200 | Edward Cox C000831 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
24332 | 24332 | William Cravens C000887 | rep | AR | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
25209 | 25209 | Fred Crawford C000889 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 8 | |||||||||||||
25654 | 25654 | Robert Crosser C000932 | rep | OH | 1947-01-03 | 1949-01-03 | Democrat | 21 | |||||||||||||
24333 | 24333 | William Crow C000939 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 23 | |||||||||||||
26277 | 26277 | Paul Cunningham C000993 | rep | IA | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
30268 | 30268 | Carl Curtis C001006 | rep | NE | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
28396 | 28396 | Paul Dague D000004 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
24338 | 24338 | Thomas D’Alesandro D000007 | rep | MD | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
27727 | 27727 | Clifford Davis D000094 | rep | TN | 1947-01-03 | 1949-01-03 | Democrat | 10 | |||||||||||||
30276 | 30276 | Glenn Davis D000102 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
27170 | 27170 | James Davis D000109 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
26283 | 26283 | William Dawson D000155 | rep | UT | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
29206 | 29206 | William Dawson D000158 | rep | IL | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
25906 | 25906 | Charles Deane D000175 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
24348 | 24348 | John Delaney D000212 | rep | NY | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
24349 | 24349 | Edward Devitt D000280 | rep | MN | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
25659 | 25659 | Wesley D’Ewart D000281 | rep | MT | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
25918 | 25918 | John Dingell D000354 | rep | MI | 1947-01-03 | 1949-01-03 | Democrat | 15 | |||||||||||||
27749 | 27749 | Everett Dirksen D000360 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 16 | |||||||||||||
25924 | 25924 | James Dolliver D000403 | rep | IA | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
24353 | 24353 | James Domengeaux D000406 | rep | LA | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
25936 | 25936 | George Dondero D000411 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 17 | |||||||||||||
30302 | 30302 | Harold Donohue D000419 | rep | MA | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
30316 | 30316 | William Dorn D000434 | rep | SC | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
25231 | 25231 | Robert Doughton D000448 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 9 | |||||||||||||
24819 | 24819 | Helen Douglas D000454 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 14 | |||||||||||||
24368 | 24368 | Patrick Drewry D000496 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
26830 | 26830 | Carl Durham D000571 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
25246 | 25246 | Charles Eaton E000023 | rep | NJ | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
26315 | 26315 | Herman Eberharter E000029 | rep | PA | 1947-01-03 | 1949-01-03 | Democrat | 32 | |||||||||||||
24369 | 24369 | Zales Ecton E000037 | sen | MT | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
24375 | 24375 | Alfred Elliott E000119 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 10 | |||||||||||||
24378 | 24378 | Hubert Ellis E000135 | rep | WV | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
25946 | 25946 | Mathew Ellsworth E000146 | rep | OR | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
24380 | 24380 | Edward Elsaesser E000159 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 43 | |||||||||||||
25253 | 25253 | Charles Elston E000160 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
24828 | 24828 | Albert Engel E000178 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
26840 | 26840 | Clair Engle E000181 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
30921 | 30921 | Joseph Evins E000273 | rep | TN | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
29236 | 29236 | George Fallon F000012 | rep | MD | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
25666 | 25666 | Joseph Farrington F000034 | rep | HI | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
29257 | 29257 | Michael Feighan F000060 | rep | OH | 1947-01-03 | 1949-01-03 | Democrat | 20 | |||||||||||||
25259 | 25259 | Frank Fellows F000066 | rep | ME | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
27196 | 27196 | Ivor Fenton F000075 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 12 | |||||||||||||
25955 | 25955 | Antonio Fernández F000085 | rep | NM | 1947-01-03 | 1949-01-03 | Democrat | 0 | |||||||||||||
27772 | 27772 | Antonio Fernós-Isern F000087 | rep | PR | 1947-01-03 | 1949-01-03 | Popular Democrat | 0 | |||||||||||||
30346 | 30346 | Ovie Fisher F000152 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 21 | |||||||||||||
25671 | 25671 | Ralph Flanders F000190 | sen | VT | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
24389 | 24389 | John Flannagan F000191 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 9 | |||||||||||||
24390 | 24390 | Charles Fletcher F000199 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 23 | |||||||||||||
28833 | 28833 | John Fogarty F000233 | rep | RI | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
24394 | 24394 | John Folger F000241 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
24395 | 24395 | Ellsworth Foote F000250 | rep | CT | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
26853 | 26853 | Aime Forand F000255 | rep | RI | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
24398 | 24398 | Hadwen Fuller F000404 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 35 | |||||||||||||
29777 | 29777 | James Fulton F000422 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 31 | |||||||||||||
24400 | 24400 | James Gallagher G000017 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
25971 | 25971 | Ralph Gamble G000031 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 28 | |||||||||||||
29801 | 29801 | Edward Garmatz G000071 | rep | MD | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
27791 | 27791 | Julian Gary G000091 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
28849 | 28849 | Ezekiel Gathings G000098 | rep | AR | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
27802 | 27802 | Leon Gavin G000102 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 19 | |||||||||||||
24407 | 24407 | Bertrand Gearhart G000111 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
24412 | 24412 | Charles Gerlach G000135 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 8 | |||||||||||||
24426 | 24426 | Charles Gifford G000169 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
25275 | 25275 | Wilson Gillette G000206 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 14 | |||||||||||||
24431 | 24431 | George Gillie G000207 | rep | IN | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
24432 | 24432 | Abe Goff G000253 | rep | ID | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
25678 | 25678 | Angier Goodwin G000297 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 8 | |||||||||||||
26328 | 26328 | Thomas Gordon G000316 | rep | IL | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
28429 | 28429 | Albert Gore G000320 | rep | TN | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
24840 | 24840 | Martin Gorski G000332 | rep | IL | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
25282 | 25282 | Ed Gossett G000338 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 13 | |||||||||||||
25686 | 25686 | Louis Graham G000360 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 25 | |||||||||||||
25288 | 25288 | Walter Granger G000379 | rep | UT | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
27821 | 27821 | George Grant G000381 | rep | AL | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
24437 | 24437 | Robert Grant G000384 | rep | IN | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
26339 | 26339 | Noble Gregory G000447 | rep | KY | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
24440 | 24440 | Percy Griffiths G000472 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 15 | |||||||||||||
24444 | 24444 | Chester Gross G000493 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 21 | |||||||||||||
26346 | 26346 | Ralph Gwinn G000541 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 27 | |||||||||||||
24451 | 24451 | John Gwynne G000543 | rep | IA | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
25692 | 25692 | Harold Hagen H000014 | rep | MN | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
26354 | 26354 | Robert Hale H000036 | rep | ME | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
25296 | 25296 | Edwin Hall H000050 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 37 | |||||||||||||
25303 | 25303 | Leonard Hall H000060 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
28866 | 28866 | Charles Halleck H000081 | rep | IN | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
25988 | 25988 | Thomas Hand H000154 | rep | NJ | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
28877 | 28877 | Porter Hardy H000197 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
24454 | 24454 | Richard Harless H000212 | rep | AZ | 1947-01-03 | 1949-01-03 | Democrat | 0 | |||||||||||||
24459 | 24459 | Forest Harness H000217 | rep | IN | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
28450 | 28450 | Oren Harris H000249 | rep | AR | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
27217 | 27217 | Burr Harrison H000264 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
25702 | 25702 | Edward Hart H000284 | rep | NJ | 1947-01-03 | 1949-01-03 | Democrat | 14 | |||||||||||||
24469 | 24469 | Fred Hartley H000298 | rep | NJ | 1947-01-03 | 1949-01-03 | Republican | 10 | |||||||||||||
28460 | 28460 | Ralph Harvey H000310 | rep | IN | 1947-01-03 | 1949-01-03 | Republican | 10 | |||||||||||||
25309 | 25309 | Franck Havenner H000356 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
26372 | 26372 | Lawrence Hays H000405 | rep | AR | 1947-01-03 | 1949-01-03 | Democrat | 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);