legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
471 rows where "end" is on date 2003-01-03 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: state, class, party, district, start (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44457 | 44457 | Pete Sessions S000250 | rep | TX | 2001-01-03 | 2003-01-03 | Republican | 5 | |||||||||||||
44445 | 44445 | Darrell Issa I000056 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 48 | |||||||||||||
43599 | 43599 | Joe Wilson W000795 | rep | SC | 2001-12-18 | 2003-01-03 | Republican | 2 | |||||||||||||
43574 | 43574 | Maxine Waters W000187 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 35 | |||||||||||||
43542 | 43542 | Nydia Velázquez V000081 | rep | NY | 2001-01-03 | 2003-01-03 | Democrat | 12 | |||||||||||||
43519 | 43519 | Fred Upton U000031 | rep | MI | 2001-01-03 | 2003-01-03 | Republican | 6 | |||||||||||||
43498 | 43498 | Patrick Toomey T000461 | rep | PA | 2001-01-03 | 2003-01-03 | Republican | 15 | |||||||||||||
43486 | 43486 | John Thune T000250 | rep | SD | 2001-01-03 | 2003-01-03 | Republican | 0 | |||||||||||||
43466 | 43466 | Mike Thompson T000460 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
43454 | 43454 | Bennie Thompson T000193 | rep | MS | 2001-01-03 | 2003-01-03 | Democrat | 2 | |||||||||||||
43421 | 43421 | Christopher Smith S000522 | rep | NJ | 2001-01-03 | 2003-01-03 | Republican | 4 | |||||||||||||
43392 | 43392 | Adam Smith S000510 | rep | WA | 2001-01-03 | 2003-01-03 | Democrat | 9 | |||||||||||||
43370 | 43370 | Michael Simpson S001148 | rep | ID | 2001-01-03 | 2003-01-03 | Republican | 2 | |||||||||||||
43358 | 43358 | Brad Sherman S000344 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 24 | |||||||||||||
43325 | 43325 | Robert Scott S000185 | rep | VA | 2001-01-03 | 2003-01-03 | Democrat | 3 | |||||||||||||
43268 | 43268 | Adam Schiff S001150 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 27 | |||||||||||||
43257 | 43257 | Janice Schakowsky S001145 | rep | IL | 2001-01-03 | 2003-01-03 | Democrat | 9 | |||||||||||||
43212 | 43212 | Bobby Rush R000515 | rep | IL | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
43185 | 43185 | Lucille Roybal-Allard R000486 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 33 | |||||||||||||
43160 | 43160 | Harold Rogers R000395 | rep | KY | 2001-01-03 | 2003-01-03 | Republican | 5 | |||||||||||||
43132 | 43132 | David Price P000523 | rep | NC | 2001-01-03 | 2003-01-03 | Democrat | 4 | |||||||||||||
43114 | 43114 | Robert Portman P000449 | rep | OH | 2001-01-03 | 2003-01-03 | Republican | 2 | |||||||||||||
43079 | 43079 | Nancy Pelosi P000197 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 8 | |||||||||||||
43059 | 43059 | Bill Pascrell P000096 | rep | NJ | 2001-01-03 | 2003-01-03 | Democrat | 8 | |||||||||||||
43046 | 43046 | Frank Pallone P000034 | rep | NJ | 2001-01-03 | 2003-01-03 | Democrat | 6 | |||||||||||||
43022 | 43022 | Eleanor Norton N000147 | rep | DC | 2001-01-03 | 2003-01-03 | Democrat | 0 | |||||||||||||
43006 | 43006 | Richard Neal N000015 | rep | MA | 2001-01-03 | 2003-01-03 | Democrat | 2 | |||||||||||||
42989 | 42989 | Grace Napolitano N000179 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 34 | |||||||||||||
42977 | 42977 | Jerrold Nadler N000002 | rep | NY | 2001-01-03 | 2003-01-03 | Democrat | 8 | |||||||||||||
42951 | 42951 | Jerry Moran M000934 | rep | KS | 2001-01-03 | 2003-01-03 | Republican | 1 | |||||||||||||
42929 | 42929 | Gregory Meeks M001137 | rep | NY | 2001-01-03 | 2003-01-03 | Democrat | 6 | |||||||||||||
42884 | 42884 | James McGovern M000312 | rep | MA | 2001-01-03 | 2003-01-03 | Democrat | 3 | |||||||||||||
42871 | 42871 | Betty McCollum M001143 | rep | MN | 2001-01-03 | 2003-01-03 | Democrat | 4 | |||||||||||||
42828 | 42828 | Edward Markey M000133 | rep | MA | 2001-01-03 | 2003-01-03 | Democrat | 7 | |||||||||||||
42804 | 42804 | Carolyn Maloney M000087 | rep | NY | 2001-01-03 | 2003-01-03 | Democrat | 14 | |||||||||||||
42789 | 42789 | Stephen Lynch L000562 | rep | MA | 2001-10-23 | 2003-01-03 | Democrat | 9 | |||||||||||||
42764 | 42764 | Frank Lucas L000491 | rep | OK | 2001-01-03 | 2003-01-03 | Republican | 6 | |||||||||||||
42743 | 42743 | Zoe Lofgren L000397 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 16 | |||||||||||||
42727 | 42727 | Barbara Lee L000551 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 9 | |||||||||||||
42698 | 42698 | John Larson L000557 | rep | CT | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
42686 | 42686 | Rick Larsen L000560 | rep | WA | 2001-01-03 | 2003-01-03 | Democrat | 2 | |||||||||||||
42671 | 42671 | James Langevin L000559 | rep | RI | 2001-01-03 | 2003-01-03 | Democrat | 2 | |||||||||||||
42646 | 42646 | Ron Kind K000188 | rep | WI | 2001-01-03 | 2003-01-03 | Democrat | 3 | |||||||||||||
42621 | 42621 | Marcy Kaptur K000009 | rep | OH | 2001-01-03 | 2003-01-03 | Democrat | 9 | |||||||||||||
42583 | 42583 | Eddie Johnson J000126 | rep | TX | 2001-01-03 | 2003-01-03 | Democrat | 30 | |||||||||||||
42562 | 42562 | Sheila Jackson Lee J000032 | rep | TX | 2001-01-03 | 2003-01-03 | Democrat | 18 | |||||||||||||
42542 | 42542 | Steny Hoyer H000874 | rep | MD | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
42444 | 42444 | Sam Graves G000546 | rep | MO | 2001-01-03 | 2003-01-03 | Republican | 6 | |||||||||||||
42423 | 42423 | Kay Granger G000377 | rep | TX | 2001-01-03 | 2003-01-03 | Republican | 12 | |||||||||||||
42367 | 42367 | Anna Eshoo E000215 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 14 | |||||||||||||
42346 | 42346 | Michael Doyle D000482 | rep | PA | 2001-01-03 | 2003-01-03 | Democrat | 18 | |||||||||||||
42332 | 42332 | Lloyd Doggett D000399 | rep | TX | 2001-01-03 | 2003-01-03 | Democrat | 10 | |||||||||||||
42302 | 42302 | Rosa DeLauro D000216 | rep | CT | 2001-01-03 | 2003-01-03 | Democrat | 3 | |||||||||||||
42286 | 42286 | Diana DeGette D000197 | rep | CO | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
42273 | 42273 | Peter DeFazio D000191 | rep | OR | 2001-01-03 | 2003-01-03 | Democrat | 4 | |||||||||||||
42255 | 42255 | Danny Davis D000096 | rep | IL | 2001-01-03 | 2003-01-03 | Democrat | 7 | |||||||||||||
42162 | 42162 | James Clyburn C000537 | rep | SC | 2001-01-03 | 2003-01-03 | Democrat | 6 | |||||||||||||
42118 | 42118 | Steve Chabot C000266 | rep | OH | 2001-01-03 | 2003-01-03 | Republican | 1 | |||||||||||||
42075 | 42075 | Shelley Capito C001047 | rep | WV | 2001-01-03 | 2003-01-03 | Republican | 2 | |||||||||||||
42064 | 42064 | Ken Calvert C000059 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 43 | |||||||||||||
42045 | 42045 | Richard Burr B001135 | rep | NC | 2001-01-03 | 2003-01-03 | Republican | 5 | |||||||||||||
42001 | 42001 | Kevin Brady B000755 | rep | TX | 2001-01-03 | 2003-01-03 | Republican | 8 | |||||||||||||
41992 | 41992 | John Boozman B001236 | rep | AR | 2001-11-29 | 2003-01-03 | Republican | 3 | |||||||||||||
41985 | 41985 | Roy Blunt B000575 | rep | MO | 2001-01-03 | 2003-01-03 | Republican | 7 | |||||||||||||
41970 | 41970 | Earl Blumenauer B000574 | rep | OR | 2001-01-03 | 2003-01-03 | Democrat | 3 | |||||||||||||
41947 | 41947 | Sanford Bishop B000490 | rep | GA | 2001-01-03 | 2003-01-03 | Democrat | 2 | |||||||||||||
41918 | 41918 | Tammy Baldwin B001230 | rep | WI | 2001-01-03 | 2003-01-03 | Democrat | 2 | |||||||||||||
41906 | 41906 | Robert Aderholt A000055 | rep | AL | 2001-01-03 | 2003-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 | |||||||||||||
41851 | 41851 | Lindsey Graham G000359 | rep | SC | 2001-01-03 | 2003-01-03 | Republican | 3 | |||||||||||||
41843 | 41843 | Richard Durbin D000563 | sen | IL | 1997-01-07 | 2003-01-03 | 2 | Democrat | |||||||||||||
41831 | 41831 | John Cornyn C001056 | sen | TX | 2002-11-30 | 2003-01-03 | 2 | Republican | |||||||||||||
41826 | 41826 | Susan Collins C001035 | sen | ME | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
41819 | 41819 | Roger Wicker W000437 | rep | MS | 2001-01-03 | 2003-01-03 | Republican | 1 | |||||||||||||
41795 | 41795 | Bernard Sanders S000033 | rep | VT | 2001-01-03 | 2003-01-03 | Independent | 0 | Democrat | ||||||||||||
41783 | 41783 | Robert Menendez M000639 | rep | NJ | 2001-01-03 | 2003-01-03 | Democrat | 13 | |||||||||||||
41752 | 41752 | Benjamin Cardin C000141 | rep | MD | 2001-01-03 | 2003-01-03 | Democrat | 3 | |||||||||||||
41734 | 41734 | Sherrod Brown B000944 | rep | OH | 2001-01-03 | 2003-01-03 | Democrat | 13 | |||||||||||||
41678 | 41678 | Don Young Y000033 | rep | AK | 2001-01-03 | 2003-01-03 | Republican | 0 | |||||||||||||
41635 | 41635 | Alcee Hastings H000324 | rep | FL | 2001-01-03 | 2003-01-03 | Democrat | 23 | |||||||||||||
41531 | 41531 | Greg Walden W000791 | rep | OR | 2001-01-03 | 2003-01-03 | Republican | 2 | |||||||||||||
41520 | 41520 | Peter Visclosky V000108 | rep | IN | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
41497 | 41497 | Mac Thornberry T000238 | rep | TX | 2001-01-03 | 2003-01-03 | Republican | 13 | |||||||||||||
41484 | 41484 | John Shimkus S000364 | rep | IL | 2001-01-03 | 2003-01-03 | Republican | 20 | |||||||||||||
41472 | 41472 | José Serrano S000248 | rep | NY | 2001-01-03 | 2003-01-03 | Democrat | 16 | |||||||||||||
41456 | 41456 | F. Sensenbrenner S000244 | rep | WI | 2001-01-03 | 2003-01-03 | Republican | 9 | |||||||||||||
41424 | 41424 | Collin Peterson P000258 | rep | MN | 2001-01-03 | 2003-01-03 | Democrat | 7 | |||||||||||||
41395 | 41395 | Nita Lowey L000480 | rep | NY | 2001-01-03 | 2003-01-03 | Democrat | 18 | |||||||||||||
41355 | 41355 | Peter King K000210 | rep | NY | 2001-01-03 | 2003-01-03 | Republican | 3 | |||||||||||||
41333 | 41333 | Eliot Engel E000179 | rep | NY | 2001-01-03 | 2003-01-03 | Democrat | 17 | |||||||||||||
41317 | 41317 | Susan Davis D000598 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 49 | |||||||||||||
41299 | 41299 | Wm. Clay C001049 | rep | MO | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
41279 | 41279 | Tom Udall U000039 | rep | NM | 2001-01-03 | 2003-01-03 | Democrat | 3 | |||||||||||||
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 | |||||||||||||
41236 | 41236 | John Lewis L000287 | rep | GA | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
41211 | 41211 | John Isakson I000055 | rep | GA | 2001-01-03 | 2003-01-03 | Republican | 6 | |||||||||||||
41199 | 41199 | Elijah Cummings C000984 | rep | MD | 2001-01-03 | 2003-01-03 | Democrat | 7 |
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);