legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
478 rows where "start" is on date 1971-01-21 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: end, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29583 | 29583 | Nicholas Begich B000315 | rep | AK | 1971-01-21 | 1973-01-03 | Democrat | 0 | |||||||||||||
29543 | 29543 | Elizabeth Andrews A000205 | rep | AL | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
29558 | 29558 | George Andrews A000206 | rep | AL | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
31093 | 31093 | Robert Jones J000248 | rep | AL | 1971-01-21 | 1973-01-03 | Democrat | 8 | |||||||||||||
31552 | 31552 | Walter Flowers F000218 | rep | AL | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
31970 | 31970 | John Buchanan B001008 | rep | AL | 1971-01-21 | 1973-01-03 | Republican | 6 | |||||||||||||
32951 | 32951 | William Edwards E000084 | rep | AL | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
33686 | 33686 | William Nichols N000095 | rep | AL | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
34372 | 34372 | William Dickinson D000326 | rep | AL | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
35695 | 35695 | Tom Bevill B000431 | rep | AL | 1971-01-21 | 1973-01-03 | Democrat | 7 | |||||||||||||
31197 | 31197 | Wilbur Mills M000778 | rep | AR | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
34163 | 34163 | William Alexander A000103 | rep | AR | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
34513 | 34513 | John Hammerschmidt H000124 | rep | AR | 1971-01-21 | 1973-01-03 | Republican | 3 | |||||||||||||
34849 | 34849 | David Pryor P000556 | rep | AR | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
29772 | 29772 | Paul Fannin F000013 | sen | AZ | 1971-01-21 | 1977-01-03 | 1 | Republican | |||||||||||||
31339 | 31339 | Sam Steiger S000846 | rep | AZ | 1971-01-21 | 1973-01-03 | Republican | 3 | |||||||||||||
32832 | 32832 | John Rhodes R000188 | rep | AZ | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
35018 | 35018 | Morris Udall U000001 | rep | AZ | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
29961 | 29961 | George Miller M000727 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 8 | |||||||||||||
30062 | 30062 | John Schmitz S000133 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 35 | |||||||||||||
30089 | 30089 | H. Smith S000545 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 20 | |||||||||||||
30116 | 30116 | John Tunney T000410 | sen | CA | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
30442 | 30442 | Charles Gubser G000512 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 10 | |||||||||||||
30449 | 30449 | Richard Hanna H000164 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 34 | |||||||||||||
30495 | 30495 | Chester Holifield H000713 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 19 | |||||||||||||
30506 | 30506 | Craig Hosmer H000802 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 32 | |||||||||||||
30543 | 30543 | William Mailliard M000070 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 6 | |||||||||||||
30557 | 30557 | Robert Mathias M000242 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 18 | |||||||||||||
30724 | 30724 | Charles Teague T000109 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 13 | |||||||||||||
30738 | 30738 | Victor Veysey V000093 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 38 | |||||||||||||
30743 | 30743 | Jerome Waldie W000035 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 14 | |||||||||||||
30843 | 30843 | Alphonzo Bell B000330 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 28 | |||||||||||||
31278 | 31278 | Jerry Pettis P000272 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 33 | |||||||||||||
31293 | 31293 | Thomas Rees R000134 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 26 | |||||||||||||
31378 | 31378 | Burt Talcott T000022 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 12 | |||||||||||||
31503 | 31503 | Delwin Clawson C000476 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 23 | |||||||||||||
31617 | 31617 | Robert Leggett L000221 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
31655 | 31655 | John McFall M000436 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 15 | |||||||||||||
31684 | 31684 | John Moss M001035 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
31827 | 31827 | Bernice Sisk S000454 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 16 | |||||||||||||
31889 | 31889 | Charles Wiggins W000448 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 25 | |||||||||||||
32005 | 32005 | James Corman C000780 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 22 | |||||||||||||
32137 | 32137 | Harold Johnson J000135 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
32371 | 32371 | Lionel Van Deerlin V000024 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 37 | |||||||||||||
32393 | 32393 | Charles Wilson W000571 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 31 | |||||||||||||
32407 | 32407 | Robert Wilson W000610 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 36 | |||||||||||||
32560 | 32560 | Donald Clausen C000475 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
32586 | 32586 | George Danielson D000043 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 29 | |||||||||||||
32684 | 32684 | Barry Goldwater G000268 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 27 | |||||||||||||
32766 | 32766 | Paul McCloskey M000343 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 11 | |||||||||||||
32845 | 32845 | John Rousselot R000469 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 24 | |||||||||||||
32912 | 32912 | Phillip Burton B001156 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
33937 | 33937 | Augustus Hawkins H000367 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 21 | |||||||||||||
34175 | 34175 | Glenn Anderson A000189 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 17 | |||||||||||||
34902 | 34902 | Edward Roybal R000485 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 30 | |||||||||||||
35203 | 35203 | William Edwards E000064 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 9 | |||||||||||||
36142 | 36142 | Ronald Dellums D000222 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 7 | |||||||||||||
29570 | 29570 | Wayne Aspinall A000225 | rep | CO | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
29930 | 29930 | James McKevitt M000513 | rep | CO | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
30200 | 30200 | Donald Brotzman B000893 | rep | CO | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
31547 | 31547 | Frank Evans E000240 | rep | CO | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
29968 | 29968 | John Monagan M000847 | rep | CT | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
30384 | 30384 | Ella Grasso G000387 | rep | CT | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
30706 | 30706 | Robert Steele S000836 | rep | CT | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
32082 | 32082 | Robert Giaimo G000151 | rep | CT | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
32574 | 32574 | William Cotter C000799 | rep | CT | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
33170 | 33170 | Lowell Weicker W000253 | sen | CT | 1971-01-21 | 1977-01-03 | 1 | Republican | |||||||||||||
33670 | 33670 | Stewart McKinney M000527 | rep | CT | 1971-01-21 | 1973-01-03 | Republican | 4 | |||||||||||||
33889 | 33889 | Walter Fauntroy F000046 | rep | DC | 1971-01-21 | 1973-01-03 | Democrat | 0 | |||||||||||||
31408 | 31408 | Pierre du Pont D000558 | rep | DE | 1971-01-21 | 1973-01-03 | Republican | 0 | |||||||||||||
36019 | 36019 | William Roth R000460 | sen | DE | 1971-01-21 | 1977-01-03 | 1 | Republican | |||||||||||||
30966 | 30966 | James Haley H000041 | rep | FL | 1971-01-21 | 1973-01-03 | Democrat | 7 | |||||||||||||
31436 | 31436 | J. Burke B001091 | rep | FL | 1971-01-21 | 1973-01-03 | Republican | 10 | |||||||||||||
31578 | 31578 | Louis Frey F000381 | rep | FL | 1971-01-21 | 1973-01-03 | Republican | 5 | |||||||||||||
31760 | 31760 | Paul Rogers R000401 | rep | FL | 1971-01-21 | 1973-01-03 | Democrat | 9 | |||||||||||||
31815 | 31815 | Robert Sikes S000406 | rep | FL | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
32919 | 32919 | Lawton Chiles C000356 | sen | FL | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
33274 | 33274 | Don Fuqua F000430 | rep | FL | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
33530 | 33530 | William Chappell C000321 | rep | FL | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
34053 | 34053 | Claude Pepper P000218 | rep | FL | 1971-01-21 | 1973-01-03 | Democrat | 11 | |||||||||||||
34244 | 34244 | Charles Bennett B000371 | rep | FL | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
34450 | 34450 | Dante Fascell F000041 | rep | FL | 1971-01-21 | 1973-01-03 | Democrat | 12 | |||||||||||||
35825 | 35825 | Sam Gibbons G000153 | rep | FL | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
39622 | 39622 | C. Young Y000031 | rep | FL | 1971-01-21 | 1973-01-03 | Republican | 8 | |||||||||||||
29822 | 29822 | George Hagan H000010 | rep | GA | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
30112 | 30112 | Standish Thompson T000217 | rep | GA | 1971-01-21 | 1973-01-03 | Republican | 5 | |||||||||||||
30163 | 30163 | Benjamin Blackburn B000506 | rep | GA | 1971-01-21 | 1973-01-03 | Republican | 4 | |||||||||||||
30291 | 30291 | John Davis D000122 | rep | GA | 1971-01-21 | 1973-01-03 | Democrat | 7 | |||||||||||||
31127 | 31127 | Phillip Landrum L000054 | rep | GA | 1971-01-21 | 1973-01-03 | Democrat | 9 | |||||||||||||
31347 | 31347 | Robert Stephens S000860 | rep | GA | 1971-01-21 | 1973-01-03 | Democrat | 10 | |||||||||||||
31355 | 31355 | Williamson Stuckey S001039 | rep | GA | 1971-01-21 | 1973-01-03 | Democrat | 8 | |||||||||||||
31565 | 31565 | John Flynt F000229 | rep | GA | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
32156 | 32156 | Marvin Mathis M000244 | rep | GA | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
32513 | 32513 | Jack Brinkley B000839 | rep | GA | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
29775 | 29775 | Hiram Fong F000245 | sen | HI | 1971-01-21 | 1977-01-03 | 1 | Republican | |||||||||||||
34007 | 34007 | Spark Matsunaga M000250 | rep | HI | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
37030 | 37030 | Patsy Mink M000797 | rep | HI | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
29883 | 29883 | John Kyl K000351 | rep | IA | 1971-01-21 | 1973-01-03 | Republican | 4 | |||||||||||||
30070 | 30070 | Frederick Schwengel S000161 | rep | IA | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
30425 | 30425 | Harold Gross G000495 | rep | IA | 1971-01-21 | 1973-01-03 | Republican | 3 |
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);