legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
481 rows where "start" is on date 1989-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
36897 | 36897 | Michael DeWine D000294 | rep | OH | 1989-01-03 | 1991-01-03 | Republican | 7 | |||||||||||||
34381 | 34381 | William Dickinson D000326 | rep | AL | 1989-01-03 | 1991-01-03 | Republican | 2 | |||||||||||||
39241 | 39241 | Norman Dicks D000327 | rep | WA | 1989-01-03 | 1991-01-03 | Democrat | 6 | |||||||||||||
39816 | 39816 | John Dingell D000355 | rep | MI | 1989-01-03 | 1991-01-03 | Democrat | 16 | |||||||||||||
36597 | 36597 | Julian Dixon D000373 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 28 | |||||||||||||
34388 | 34388 | Brian Donnelly D000416 | rep | MA | 1989-01-03 | 1991-01-03 | Democrat | 11 | |||||||||||||
37616 | 37616 | Byron Dorgan D000432 | rep | ND | 1989-01-03 | 1991-01-03 | Democrat | 0 | |||||||||||||
35777 | 35777 | Robert Dornan D000435 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 38 | |||||||||||||
33880 | 33880 | Charles Douglas D000451 | rep | NH | 1989-01-03 | 1991-01-03 | Republican | 2 | |||||||||||||
34397 | 34397 | Thomas Downey D000471 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
39257 | 39257 | David Dreier D000492 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 33 | |||||||||||||
40777 | 40777 | John Duncan D000533 | rep | TN | 1989-01-03 | 1991-01-03 | Republican | 2 | |||||||||||||
41839 | 41839 | Richard Durbin D000563 | rep | IL | 1989-01-03 | 1991-01-03 | Democrat | 20 | |||||||||||||
33883 | 33883 | David Durenberger D000566 | sen | MN | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
34403 | 34403 | Bernard Dwyer D000586 | rep | NJ | 1989-01-03 | 1991-01-03 | Democrat | 6 | |||||||||||||
34409 | 34409 | Mervyn Dymally D000592 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 31 | |||||||||||||
33888 | 33888 | Royden Dyson D000593 | rep | MD | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
34418 | 34418 | Joseph Early E000013 | rep | MA | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
34424 | 34424 | Dennis Eckart E000031 | rep | OH | 1989-01-03 | 1991-01-03 | Democrat | 11 | |||||||||||||
35212 | 35212 | William Edwards E000064 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 10 | |||||||||||||
34432 | 34432 | Marvin Edwards E000077 | rep | OK | 1989-01-03 | 1991-01-03 | Republican | 5 | |||||||||||||
35785 | 35785 | Norvell Emerson E000174 | rep | MO | 1989-01-03 | 1991-01-03 | Republican | 8 | |||||||||||||
41327 | 41327 | Eliot Engel E000179 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 19 | |||||||||||||
35222 | 35222 | Glenn English E000184 | rep | OK | 1989-01-03 | 1991-01-03 | Democrat | 6 | |||||||||||||
34437 | 34437 | Ben Erdreich E000201 | rep | AL | 1989-01-03 | 1991-01-03 | Democrat | 6 | |||||||||||||
35227 | 35227 | Albert Espy E000218 | rep | MS | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
37625 | 37625 | Lane Evans E000250 | rep | IL | 1989-01-03 | 1991-01-03 | Democrat | 17 | |||||||||||||
39829 | 39829 | Eni Faleomavaega F000010 | rep | AS | 1989-01-03 | 1991-01-03 | Democrat | 0 | |||||||||||||
34459 | 34459 | Dante Fascell F000041 | rep | FL | 1989-01-03 | 1991-01-03 | Democrat | 19 | |||||||||||||
33898 | 33898 | Walter Fauntroy F000046 | rep | DC | 1989-01-03 | 1991-01-03 | Democrat | 0 | |||||||||||||
36158 | 36158 | Harris Fawell F000049 | rep | IL | 1989-01-03 | 1991-01-03 | Republican | 13 | |||||||||||||
36168 | 36168 | Victor Fazio F000053 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
34464 | 34464 | Edward Feighan F000059 | rep | OH | 1989-01-03 | 1991-01-03 | Democrat | 19 | |||||||||||||
35795 | 35795 | Jack Fields F000111 | rep | TX | 1989-01-03 | 1991-01-03 | Republican | 8 | |||||||||||||
35242 | 35242 | Hamilton Fish F000141 | rep | NY | 1989-01-03 | 1991-01-03 | Republican | 21 | |||||||||||||
36174 | 36174 | Floyd Flake F000184 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 6 | |||||||||||||
33905 | 33905 | Ronnie Flippo F000208 | rep | AL | 1989-01-03 | 1991-01-03 | Democrat | 5 | |||||||||||||
33913 | 33913 | James Florio F000215 | rep | NJ | 1989-01-03 | 1990-01-16 | Democrat | 1 | |||||||||||||
36183 | 36183 | Thomas Foglietta F000235 | rep | PA | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
35257 | 35257 | Thomas Foley F000239 | rep | WA | 1989-01-03 | 1991-01-03 | Democrat | 5 | |||||||||||||
35807 | 35807 | Harold Ford F000261 | rep | TN | 1989-01-03 | 1991-01-03 | Democrat | 9 | |||||||||||||
35277 | 35277 | William Ford F000270 | rep | MI | 1989-01-03 | 1991-01-03 | Democrat | 15 | |||||||||||||
39273 | 39273 | Barney Frank F000339 | rep | MA | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
33923 | 33923 | William Frenzel F000380 | rep | MN | 1989-01-03 | 1991-01-03 | Republican | 3 | |||||||||||||
37334 | 37334 | Jonas Frost F000392 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 24 | |||||||||||||
34468 | 34468 | Jaime Fuster F000435 | rep | PR | 1989-01-03 | 1991-01-03 | Democrat | 0 | |||||||||||||
39286 | 39286 | Elton Gallegly G000021 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 21 | |||||||||||||
35282 | 35282 | Dean Gallo G000025 | rep | NJ | 1989-01-03 | 1991-01-03 | Republican | 11 | |||||||||||||
33930 | 33930 | Robert Garcia G000047 | rep | NY | 1989-01-03 | 1990-01-07 | Democrat | 18 | |||||||||||||
34481 | 34481 | Joseph Gaydos G000105 | rep | PA | 1989-01-03 | 1991-01-03 | Democrat | 20 | |||||||||||||
36625 | 36625 | Sam Gejdenson G000120 | rep | CT | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
36913 | 36913 | George Gekas G000121 | rep | PA | 1989-01-03 | 1991-01-03 | Republican | 17 | |||||||||||||
37348 | 37348 | Richard Gephardt G000132 | rep | MO | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
35817 | 35817 | Preston Geren G000134 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 12 | |||||||||||||
35834 | 35834 | Sam Gibbons G000153 | rep | FL | 1989-01-03 | 1991-01-03 | Democrat | 7 | |||||||||||||
38062 | 38062 | Paul Gillmor G000210 | rep | OH | 1989-01-03 | 1991-01-03 | Republican | 5 | |||||||||||||
36928 | 36928 | Benjamin Gilman G000212 | rep | NY | 1989-01-03 | 1991-01-03 | Republican | 22 | |||||||||||||
36198 | 36198 | Newton Gingrich G000225 | rep | GA | 1989-01-03 | 1991-01-03 | Republican | 6 | |||||||||||||
35296 | 35296 | Daniel Glickman G000240 | rep | KS | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
36217 | 36217 | Henry González G000272 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 20 | |||||||||||||
36638 | 36638 | William Goodling G000291 | rep | PA | 1989-01-03 | 1991-01-03 | Republican | 19 | |||||||||||||
38557 | 38557 | Barton Gordon G000309 | rep | TN | 1989-01-03 | 1991-01-03 | Democrat | 6 | |||||||||||||
35839 | 35839 | T. Gorton G000333 | sen | WA | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
37356 | 37356 | Porter Goss G000336 | rep | FL | 1989-01-03 | 1991-01-03 | Republican | 13 | |||||||||||||
35306 | 35306 | Willis Gradison G000349 | rep | OH | 1989-01-03 | 1991-01-03 | Republican | 2 | |||||||||||||
35310 | 35310 | Frederick Grandy G000371 | rep | IA | 1989-01-03 | 1991-01-03 | Republican | 6 | |||||||||||||
33932 | 33932 | James Grant G000382 | rep | FL | 1989-01-03 | 1991-01-03 | Republican | 2 | [ { "start": "1989-01-03", "end": "1989-02-21", "party": "Democrat" }, { "start": "1989-02-21", "end": "1991-01-03", "party": "Republican" } ] |
||||||||||||
34494 | 34494 | William Gray G000402 | rep | PA | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
34502 | 34502 | Sedgwick Green G000417 | rep | NY | 1989-01-03 | 1991-01-03 | Republican | 15 | |||||||||||||
34509 | 34509 | Frank Guarini G000511 | rep | NJ | 1989-01-03 | 1991-01-03 | Democrat | 14 | |||||||||||||
35847 | 35847 | Steven Gunderson G000524 | rep | WI | 1989-01-03 | 1991-01-03 | Republican | 3 | |||||||||||||
39860 | 39860 | Ralph Hall H000067 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
36941 | 36941 | Tony Hall H000074 | rep | OH | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
36240 | 36240 | Lee Hamilton H000114 | rep | IN | 1989-01-03 | 1991-01-03 | Democrat | 9 | |||||||||||||
34522 | 34522 | John Hammerschmidt H000124 | rep | AR | 1989-01-03 | 1991-01-03 | Republican | 3 | |||||||||||||
35851 | 35851 | Melton Hancock H000151 | rep | MO | 1989-01-03 | 1991-01-03 | Republican | 7 | |||||||||||||
36952 | 36952 | James Hansen H000172 | rep | UT | 1989-01-03 | 1991-01-03 | Republican | 1 | |||||||||||||
34525 | 34525 | Claude Harris H000236 | rep | AL | 1989-01-03 | 1991-01-03 | Democrat | 7 | |||||||||||||
38079 | 38079 | J. Hastert H000323 | rep | IL | 1989-01-03 | 1991-01-03 | Republican | 14 | |||||||||||||
40674 | 40674 | Orrin Hatch H000338 | sen | UT | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
34531 | 34531 | Charles Hatcher H000340 | rep | GA | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
33946 | 33946 | Augustus Hawkins H000367 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 29 | |||||||||||||
34541 | 34541 | Charles Hayes H000388 | rep | IL | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
35856 | 35856 | James Hayes H000390 | rep | LA | 1989-01-03 | 1991-01-03 | Democrat | 7 | |||||||||||||
37682 | 37682 | Joel Hefley H000444 | rep | CO | 1989-01-03 | 1991-01-03 | Republican | 5 | |||||||||||||
36252 | 36252 | Willie Hefner H000448 | rep | NC | 1989-01-03 | 1991-01-03 | Democrat | 8 | |||||||||||||
33952 | 33952 | Henry Heinz H000456 | sen | PA | 1989-01-03 | 1991-12-31 | 1 | Republican | |||||||||||||
35316 | 35316 | Paul Henry H000514 | rep | MI | 1989-01-03 | 1991-01-03 | Republican | 5 | |||||||||||||
39307 | 39307 | Walter Herger H000528 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 2 | |||||||||||||
34550 | 34550 | Dennis Hertel H000547 | rep | MI | 1989-01-03 | 1991-01-03 | Democrat | 14 | |||||||||||||
33957 | 33957 | John Hiler H000586 | rep | IN | 1989-01-03 | 1991-01-03 | Republican | 3 | |||||||||||||
35319 | 35319 | Peter Hoagland H000652 | rep | NE | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
35323 | 35323 | George Hochbrueckner H000670 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
34553 | 34553 | Clyde Holloway H000729 | rep | LA | 1989-01-03 | 1991-01-03 | Republican | 8 | |||||||||||||
34560 | 34560 | Larry Hopkins H000776 | rep | KY | 1989-01-03 | 1991-01-03 | Republican | 6 | |||||||||||||
34576 | 34576 | Frank Horton H000797 | rep | NY | 1989-01-03 | 1991-01-03 | Republican | 29 | |||||||||||||
37376 | 37376 | Amory Houghton H000814 | rep | NY | 1989-01-03 | 1991-01-03 | Republican | 34 | |||||||||||||
42536 | 42536 | Steny Hoyer H000874 | rep | MD | 1989-01-03 | 1991-01-03 | Democrat | 5 | |||||||||||||
34585 | 34585 | Carroll Hubbard H000878 | rep | KY | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
34593 | 34593 | Thomas Huckaby H000901 | rep | LA | 1989-01-03 | 1991-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);