legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
482 rows where "start" is on date 1969-01-03 sorted by district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29475 | 29475 | Richard Roudebush R000464 | rep | IN | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
29666 | 29666 | Earle Cabell C000002 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
29714 | 29714 | William Colmer C000645 | rep | MS | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
29869 | 29869 | James Kee K000038 | rep | WV | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
29967 | 29967 | John Monagan M000847 | rep | CT | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
29980 | 29980 | Frank Morse M001009 | rep | MA | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
30111 | 30111 | Standish Thompson T000217 | rep | GA | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
30368 | 30368 | Peter Frelinghuysen F000371 | rep | NJ | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
30375 | 30375 | Thomas Gettys G000144 | rep | SC | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
30478 | 30478 | Lawrence Hogan H000692 | rep | MD | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
30594 | 30594 | Wilmer Mizell M000833 | rep | NC | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
30797 | 30797 | Gerald Ford F000260 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
30939 | 30939 | Richard Fulton F000424 | rep | TN | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
30948 | 30948 | William Green G000420 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
31062 | 31062 | John Jarman J000057 | rep | OK | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
31114 | 31114 | John Kluczynski K000273 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
31248 | 31248 | Otto Passman P000098 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
31551 | 31551 | Walter Flowers F000218 | rep | AL | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
31572 | 31572 | Donald Fraser F000350 | rep | MN | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
31577 | 31577 | Louis Frey F000381 | rep | FL | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
31834 | 31834 | Joe Skubitz S000472 | rep | KS | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
31983 | 31983 | Tim Carter C000201 | rep | KY | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
32499 | 32499 | Richard Bolling B000605 | rep | MO | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
32816 | 32816 | Henry Reuss R000165 | rep | WI | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
32911 | 32911 | Phillip Burton B001156 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
33543 | 33543 | Wilbur Daniel D000038 | rep | VA | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
33642 | 33642 | Delbert Latta L000116 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
35247 | 35247 | Thomas Foley F000239 | rep | WA | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
35587 | 35587 | Neal Smith S000596 | rep | IA | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
29139 | 29139 | William Bates B000239 | rep | MA | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
29174 | 29174 | William Cahill C000019 | rep | NJ | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
29388 | 29388 | Thomas Meskill M000667 | rep | CT | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
29470 | 29470 | Daniel Ronan R000420 | rep | IL | 1969-01-03 | 1969-08-13 | Democrat | 6 | |||||||||||||
29541 | 29541 | William Anderson A000203 | rep | TN | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
29581 | 29581 | John Beall B000272 | rep | MD | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
29834 | 29834 | Seymour Halpern H000085 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
29855 | 29855 | William Hull H000947 | rep | MO | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
29946 | 29946 | John McMillan M000568 | rep | SC | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
30035 | 30035 | Richard Poff P000401 | rep | VA | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
30126 | 30126 | John Watts W000212 | rep | KY | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
30192 | 30192 | William Bray B000778 | rep | IN | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
30213 | 30213 | John Camp C000073 | rep | OK | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
30238 | 30238 | Charles Chamberlain C000275 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
30542 | 30542 | William Mailliard M000070 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
30560 | 30560 | Wiley Mayne M000286 | rep | IA | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
30622 | 30622 | John Rarick R000065 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
30778 | 30778 | John Zwach Z000016 | rep | MN | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
31014 | 31014 | Floyd Hicks H000563 | rep | WA | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
31564 | 31564 | John Flynt F000229 | rep | GA | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
31585 | 31585 | Michael Harrington H000230 | rep | MA | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
31841 | 31841 | William Steiger S000847 | rep | WI | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
31858 | 31858 | Olin Teague T000110 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
31969 | 31969 | John Buchanan B001008 | rep | AL | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
32104 | 32104 | William Harsha H000281 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
32235 | 32235 | Lunsford Preyer P000520 | rep | NC | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
32972 | 32972 | Edwin Forsythe F000286 | rep | NJ | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
35078 | 35078 | Gus Yatron Y000014 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
35824 | 35824 | Sam Gibbons G000153 | rep | FL | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
29180 | 29180 | Jeffery Cohelan C000596 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
29279 | 29279 | Samuel Friedel F000384 | rep | MD | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
29329 | 29329 | Melvin Laird L000024 | rep | WI | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
29335 | 29335 | Odin Langen L000069 | rep | MN | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
29354 | 29354 | John Marsh M000148 | rep | VA | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
29607 | 29607 | Leonard Blanton B000548 | rep | TN | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
29769 | 29769 | Edwin Edwards E000067 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
29827 | 29827 | Durward Hall H000049 | rep | MO | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
29891 | 29891 | Alton Lennon L000240 | rep | NC | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
30290 | 30290 | John Davis D000122 | rep | GA | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
30680 | 30680 | William Scherle S000121 | rep | IA | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
30758 | 30758 | William Widnall W000445 | rep | NJ | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
30762 | 30762 | Lawrence Williams W000525 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
30965 | 30965 | James Haley H000041 | rep | FL | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
31139 | 31139 | Torbert Macdonald M000005 | rep | MA | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
32525 | 32525 | Clarence Brown B000910 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
33097 | 33097 | Carl Perkins P000230 | rep | KY | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
33216 | 33216 | Joseph Addabbo A000052 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
33472 | 33472 | Brockman Adams A000031 | rep | WA | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
34064 | 34064 | Donald Riegle R000249 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
34161 | 34161 | George Bush B001166 | rep | TX | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
34188 | 34188 | Frank Annunzio A000212 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
35694 | 35694 | Tom Bevill B000431 | rep | AL | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
35950 | 35950 | John Myers M001130 | rep | IN | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
38730 | 38730 | David Obey O000007 | rep | WI | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
29190 | 29190 | William Cramer C000869 | rep | FL | 1969-01-03 | 1971-01-03 | Republican | 8 | |||||||||||||
29234 | 29234 | Robert Everett E000266 | rep | TN | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
29301 | 29301 | Charles Joelson J000108 | rep | NJ | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
29604 | 29604 | Jackson Betts B000426 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 8 | |||||||||||||
29662 | 29662 | John Byrnes B001216 | rep | WI | 1969-01-03 | 1971-01-03 | Republican | 8 | |||||||||||||
29900 | 29900 | Speedy Long L000429 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
29960 | 29960 | George Miller M000727 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
30176 | 30176 | John Blatnik B000550 | rep | MN | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
30469 | 30469 | James Harvey H000306 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 8 | |||||||||||||
30659 | 30659 | Earl Ruth R000545 | rep | NC | 1969-01-03 | 1971-01-03 | Republican | 8 | |||||||||||||
30684 | 30684 | William Scott S000189 | rep | VA | 1969-01-03 | 1971-01-03 | Republican | 8 | |||||||||||||
30774 | 30774 | Roger Zion Z000010 | rep | IN | 1969-01-03 | 1971-01-03 | Republican | 8 | |||||||||||||
30851 | 30851 | Edward Biester B000451 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 8 | |||||||||||||
30953 | 30953 | Gilbert Gude G000513 | rep | MD | 1969-01-03 | 1971-01-03 | Republican | 8 | |||||||||||||
31092 | 31092 | Robert Jones J000248 | rep | AL | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
31354 | 31354 | Williamson Stuckey S001039 | rep | GA | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
32050 | 32050 | Robert Eckhardt E000035 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 8 |
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);