legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
475 rows where "start" is on date 1997-01-07 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, end, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44455 | 44455 | Pete Sessions S000250 | rep | TX | 1997-01-07 | 1999-01-03 | Republican | 5 | |||||||||||||
43572 | 43572 | Maxine Waters W000187 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 35 | |||||||||||||
43540 | 43540 | Nydia Velázquez V000081 | rep | NY | 1997-01-07 | 1999-01-03 | Democrat | 12 | |||||||||||||
43517 | 43517 | Fred Upton U000031 | rep | MI | 1997-01-07 | 1999-01-03 | Republican | 6 | |||||||||||||
43484 | 43484 | John Thune T000250 | rep | SD | 1997-01-07 | 1999-01-03 | Republican | 0 | |||||||||||||
43452 | 43452 | Bennie Thompson T000193 | rep | MS | 1997-01-07 | 1999-01-03 | Democrat | 2 | |||||||||||||
43419 | 43419 | Christopher Smith S000522 | rep | NJ | 1997-01-07 | 1999-01-03 | Republican | 4 | |||||||||||||
43390 | 43390 | Adam Smith S000510 | rep | WA | 1997-01-07 | 1999-01-03 | Democrat | 9 | |||||||||||||
43356 | 43356 | Brad Sherman S000344 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 24 | |||||||||||||
43323 | 43323 | Robert Scott S000185 | rep | VA | 1997-01-07 | 1999-01-03 | Democrat | 3 | |||||||||||||
43294 | 43294 | Charles Schumer S000148 | rep | NY | 1997-01-07 | 1999-01-03 | Democrat | 9 | |||||||||||||
43210 | 43210 | Bobby Rush R000515 | rep | IL | 1997-01-07 | 1999-01-03 | Democrat | 1 | |||||||||||||
43183 | 43183 | Lucille Roybal-Allard R000486 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 33 | |||||||||||||
43158 | 43158 | Harold Rogers R000395 | rep | KY | 1997-01-07 | 1999-01-03 | Republican | 5 | |||||||||||||
43130 | 43130 | David Price P000523 | rep | NC | 1997-01-07 | 1999-01-03 | Democrat | 4 | |||||||||||||
43112 | 43112 | Robert Portman P000449 | rep | OH | 1997-01-07 | 1999-01-03 | Republican | 2 | |||||||||||||
43077 | 43077 | Nancy Pelosi P000197 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 8 | |||||||||||||
43057 | 43057 | Bill Pascrell P000096 | rep | NJ | 1997-01-07 | 1999-01-03 | Democrat | 8 | |||||||||||||
43044 | 43044 | Frank Pallone P000034 | rep | NJ | 1997-01-07 | 1999-01-03 | Democrat | 6 | |||||||||||||
43020 | 43020 | Eleanor Norton N000147 | rep | DC | 1997-01-07 | 1999-01-03 | Democrat | 0 | |||||||||||||
43004 | 43004 | Richard Neal N000015 | rep | MA | 1997-01-07 | 1999-01-03 | Democrat | 2 | |||||||||||||
42975 | 42975 | Jerrold Nadler N000002 | rep | NY | 1997-01-07 | 1999-01-03 | Democrat | 8 | |||||||||||||
42949 | 42949 | Jerry Moran M000934 | rep | KS | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
42927 | 42927 | Gregory Meeks M001137 | rep | NY | 1997-01-07 | 1999-01-03 | Democrat | 6 | |||||||||||||
42882 | 42882 | James McGovern M000312 | rep | MA | 1997-01-07 | 1999-01-03 | Democrat | 3 | |||||||||||||
42826 | 42826 | Edward Markey M000133 | rep | MA | 1997-01-07 | 1999-01-03 | Democrat | 7 | |||||||||||||
42802 | 42802 | Carolyn Maloney M000087 | rep | NY | 1997-01-07 | 1999-01-03 | Democrat | 14 | |||||||||||||
42762 | 42762 | Frank Lucas L000491 | rep | OK | 1997-01-07 | 1999-01-03 | Republican | 6 | |||||||||||||
42741 | 42741 | Zoe Lofgren L000397 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 16 | |||||||||||||
42644 | 42644 | Ron Kind K000188 | rep | WI | 1997-01-07 | 1999-01-03 | Democrat | 3 | |||||||||||||
42619 | 42619 | Marcy Kaptur K000009 | rep | OH | 1997-01-07 | 1999-01-03 | Democrat | 9 | |||||||||||||
42581 | 42581 | Eddie Johnson J000126 | rep | TX | 1997-01-07 | 1999-01-03 | Democrat | 30 | |||||||||||||
42560 | 42560 | Sheila Jackson Lee J000032 | rep | TX | 1997-01-07 | 1999-01-03 | Democrat | 18 | |||||||||||||
42540 | 42540 | Steny Hoyer H000874 | rep | MD | 1997-01-07 | 1999-01-03 | Democrat | 5 | |||||||||||||
42421 | 42421 | Kay Granger G000377 | rep | TX | 1997-01-07 | 1999-01-03 | Republican | 12 | |||||||||||||
42365 | 42365 | Anna Eshoo E000215 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 14 | |||||||||||||
42344 | 42344 | Michael Doyle D000482 | rep | PA | 1997-01-07 | 1999-01-03 | Democrat | 18 | |||||||||||||
42330 | 42330 | Lloyd Doggett D000399 | rep | TX | 1997-01-07 | 1999-01-03 | Democrat | 10 | |||||||||||||
42300 | 42300 | Rosa DeLauro D000216 | rep | CT | 1997-01-07 | 1999-01-03 | Democrat | 3 | |||||||||||||
42284 | 42284 | Diana DeGette D000197 | rep | CO | 1997-01-07 | 1999-01-03 | Democrat | 1 | |||||||||||||
42271 | 42271 | Peter DeFazio D000191 | rep | OR | 1997-01-07 | 1999-01-03 | Democrat | 4 | |||||||||||||
42253 | 42253 | Danny Davis D000096 | rep | IL | 1997-01-07 | 1999-01-03 | Democrat | 7 | |||||||||||||
42233 | 42233 | Michael Crapo C000880 | rep | ID | 1997-01-07 | 1999-01-03 | Republican | 2 | |||||||||||||
42160 | 42160 | James Clyburn C000537 | rep | SC | 1997-01-07 | 1999-01-03 | Democrat | 6 | |||||||||||||
42116 | 42116 | Steve Chabot C000266 | rep | OH | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
42062 | 42062 | Ken Calvert C000059 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 43 | |||||||||||||
42043 | 42043 | Richard Burr B001135 | rep | NC | 1997-01-07 | 1999-01-03 | Republican | 5 | |||||||||||||
41999 | 41999 | Kevin Brady B000755 | rep | TX | 1997-01-07 | 1999-01-03 | Republican | 8 | |||||||||||||
41983 | 41983 | Roy Blunt B000575 | rep | MO | 1997-01-07 | 1999-01-03 | Republican | 7 | |||||||||||||
41968 | 41968 | Earl Blumenauer B000574 | rep | OR | 1997-01-07 | 1999-01-03 | Democrat | 3 | |||||||||||||
41945 | 41945 | Sanford Bishop B000490 | rep | GA | 1997-01-07 | 1999-01-03 | Democrat | 2 | |||||||||||||
41904 | 41904 | Robert Aderholt A000055 | rep | AL | 1997-01-07 | 1999-01-03 | Republican | 4 | |||||||||||||
41879 | 41879 | John Reed R000122 | sen | RI | 1997-01-07 | 2003-01-03 | 2 | Democrat | |||||||||||||
41868 | 41868 | Mitch McConnell M000355 | sen | KY | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
41861 | 41861 | James Inhofe I000024 | sen | OK | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
41849 | 41849 | Lindsey Graham G000359 | rep | SC | 1997-01-07 | 1999-01-03 | Republican | 3 | |||||||||||||
41843 | 41843 | Richard Durbin D000563 | sen | IL | 1997-01-07 | 2003-01-03 | 2 | Democrat | |||||||||||||
41826 | 41826 | Susan Collins C001035 | sen | ME | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
41817 | 41817 | Roger Wicker W000437 | rep | MS | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
41801 | 41801 | Debbie Stabenow S000770 | rep | MI | 1997-01-07 | 1999-01-03 | Democrat | 8 | |||||||||||||
41793 | 41793 | Bernard Sanders S000033 | rep | VT | 1997-01-07 | 1999-01-03 | Independent | 0 | Democrat | ||||||||||||
41781 | 41781 | Robert Menendez M000639 | rep | NJ | 1997-01-07 | 1999-01-03 | Democrat | 13 | |||||||||||||
41750 | 41750 | Benjamin Cardin C000141 | rep | MD | 1997-01-07 | 1999-01-03 | Democrat | 3 | |||||||||||||
41732 | 41732 | Sherrod Brown B000944 | rep | OH | 1997-01-07 | 1999-01-03 | Democrat | 13 | |||||||||||||
41676 | 41676 | Don Young Y000033 | rep | AK | 1997-01-07 | 1999-01-03 | Republican | 0 | |||||||||||||
41633 | 41633 | Alcee Hastings H000324 | rep | FL | 1997-01-07 | 1999-01-03 | Democrat | 23 | |||||||||||||
41518 | 41518 | Peter Visclosky V000108 | rep | IN | 1997-01-07 | 1999-01-03 | Democrat | 1 | |||||||||||||
41495 | 41495 | Mac Thornberry T000238 | rep | TX | 1997-01-07 | 1999-01-03 | Republican | 13 | |||||||||||||
41482 | 41482 | John Shimkus S000364 | rep | IL | 1997-01-07 | 1999-01-03 | Republican | 20 | |||||||||||||
41470 | 41470 | José Serrano S000248 | rep | NY | 1997-01-07 | 1999-01-03 | Democrat | 16 | |||||||||||||
41454 | 41454 | F. Sensenbrenner S000244 | rep | WI | 1997-01-07 | 1999-01-03 | Republican | 9 | |||||||||||||
41422 | 41422 | Collin Peterson P000258 | rep | MN | 1997-01-07 | 1999-01-03 | Democrat | 7 | |||||||||||||
41393 | 41393 | Nita Lowey L000480 | rep | NY | 1997-01-07 | 1999-01-03 | Democrat | 18 | |||||||||||||
41353 | 41353 | Peter King K000210 | rep | NY | 1997-01-07 | 1999-01-03 | Republican | 3 | |||||||||||||
41331 | 41331 | Eliot Engel E000179 | rep | NY | 1997-01-07 | 1999-01-03 | Democrat | 17 | |||||||||||||
41274 | 41274 | Pat Roberts R000307 | sen | KS | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
41262 | 41262 | Michael Enzi E000285 | sen | WY | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
41234 | 41234 | John Lewis L000287 | rep | GA | 1997-01-07 | 1999-01-03 | Democrat | 5 | |||||||||||||
41197 | 41197 | Elijah Cummings C000984 | rep | MD | 1997-01-07 | 1999-01-03 | Democrat | 7 | |||||||||||||
41175 | 41175 | Walter Jones J000255 | rep | NC | 1997-01-07 | 1999-01-03 | Republican | 3 | |||||||||||||
41118 | 41118 | Marshall Sanford S000051 | rep | SC | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
41060 | 41060 | Lamar Smith S000583 | rep | TX | 1997-01-07 | 1999-01-03 | Republican | 21 | |||||||||||||
41025 | 41025 | Edward Royce R000487 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 39 | |||||||||||||
41002 | 41002 | Ileana Ros-Lehtinen R000435 | rep | FL | 1997-01-07 | 1999-01-03 | Republican | 18 | |||||||||||||
40978 | 40978 | Dana Rohrabacher R000409 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 45 | |||||||||||||
40924 | 40924 | Frank LoBiondo L000554 | rep | NJ | 1997-01-07 | 1999-01-03 | Republican | 2 | |||||||||||||
40912 | 40912 | Sander Levin L000263 | rep | MI | 1997-01-07 | 1999-01-03 | Democrat | 12 | |||||||||||||
40885 | 40885 | Sam Johnson J000174 | rep | TX | 1997-01-07 | 1999-01-03 | Republican | 3 | |||||||||||||
40849 | 40849 | Luis Gutiérrez G000535 | rep | IL | 1997-01-07 | 1999-01-03 | Democrat | 4 | |||||||||||||
40836 | 40836 | Gene Green G000410 | rep | TX | 1997-01-07 | 1999-01-03 | Democrat | 29 | |||||||||||||
40819 | 40819 | Bob Goodlatte G000289 | rep | VA | 1997-01-07 | 1999-01-03 | Republican | 6 | |||||||||||||
40806 | 40806 | Rodney Frelinghuysen F000372 | rep | NJ | 1997-01-07 | 1999-01-03 | Republican | 11 | |||||||||||||
40781 | 40781 | John Duncan D000533 | rep | TN | 1997-01-07 | 1999-01-03 | Republican | 2 | |||||||||||||
40700 | 40700 | Joe Barton B000213 | rep | TX | 1997-01-07 | 1999-01-03 | Republican | 6 | |||||||||||||
40624 | 40624 | Thad Cochran C000567 | sen | MS | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
40607 | 40607 | Louise Slaughter S000480 | rep | NY | 1997-01-07 | 1999-01-03 | Democrat | 28 | |||||||||||||
40571 | 40571 | John Conyers C000714 | rep | MI | 1997-01-07 | 1999-01-03 | Democrat | 14 | |||||||||||||
40525 | 40525 | Jefferson Sessions S001141 | sen | AL | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
40514 | 40514 | Xavier Becerra B000287 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 30 | |||||||||||||
40488 | 40488 | Matt Salmon S000018 | rep | AZ | 1997-01-07 | 1999-01-03 | Republican | 1 |
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);