legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: class, party, how, phone, contact_form, office, state_rank, rss_url, end (date)
These facets timed out: start
fax 575 ✖
- 202-225-4975 5
- 202-225-4987 5
- 202-225-5933 5
- 202-225-5974 5
- 202-225-6798 5
- 202-225-6942 5
- 202-225-7313 5
- 202-225-7856 5
- 202-226-0326 5
- 202-226-2356 5
- 202-226-7840 5
- 202-225-0003 4
- 202-225-0011 4
- 202-225-0017 4
- 202-225-0027 4
- 202-225-0072 4
- 202-225-0074 4
- 202-225-0076 4
- 202-225-0088 4
- 202-225-0145 4
- 202-225-0182 4
- 202-225-0207 4
- 202-225-0235 4
- 202-225-0254 4
- 202-225-0316 4
- 202-225-0350 4
- 202-225-0351 4
- 202-225-0375 4
- 202-225-0378 4
- 202-225-0425 4
- 202-225-0437 4
- 202-225-0464 4
- 202-225-0546 4
- 202-225-0562 4
- 202-225-0566 4
- 202-225-0697 4
- 202-225-0764 4
- 202-225-0778 4
- 202-225-0816 4
- 202-225-0819 4
- 202-225-0940 4
- 202-225-0999 4
- 202-225-1012 4
- 202-225-1031 4
- 202-225-1100 4
- 202-225-1166 4
- 202-225-1168 4
- 202-225-1171 4
- 202-225-1339 4
- 202-225-1485 4
- 202-225-1512 4
- 202-225-1541 4
- 202-225-1593 4
- 202-225-1641 4
- 202-225-1783 4
- 202-225-1844 4
- 202-225-1909 4
- 202-225-1915 4
- 202-225-1968 4
- 202-225-1985 4
- 202-225-1988 4
- 202-225-2004 4
- 202-225-2014 4
- 202-225-2082 4
- 202-225-2203 4
- 202-225-2313 4
- 202-225-2356 4
- 202-225-2422 4
- 202-225-2455 4
- 202-225-2486 4
- 202-225-2493 4
- 202-225-2558 4
- 202-225-2807 4
- 202-225-2908 4
- 202-225-2919 4
- 202-225-2943 4
- 202-225-2944 4
- 202-225-2946 4
- 202-225-2947 4
- 202-225-2948 4
- 202-225-2995 4
- 202-225-3002 4
- 202-225-3004 4
- 202-225-3012 4
- 202-225-3013 4
- 202-225-3029 4
- 202-225-3038 4
- 202-225-3052 4
- 202-225-3059 4
- 202-225-3071 4
- 202-225-3073 4
- 202-225-3084 4
- 202-225-3094 4
- 202-225-3103 4
- 202-225-3132 4
- 202-225-3143 4
- 202-225-3178 4
- 202-225-3186 4
- 202-225-3190 4
- 202-225-3193 4
- 202-225-3216 4
- 202-225-3251 4
- 202-225-3284 4
- 202-225-3286 4
- 202-225-3290 4
- 202-225-3303 4
- 202-225-3307 4
- 202-225-3317 4
- 202-225-3318 4
- 202-225-3332 4
- 202-225-3336 4
- 202-225-3354 4
- 202-225-3377 4
- 202-225-3389 4
- 202-225-3392 4
- 202-225-3393 4
- 202-225-3394 4
- 202-225-3402 4
- 202-225-3404 4
- 202-225-3407 4
- 202-225-3433 4
- 202-225-3478 4
- 202-225-3486 4
- 202-225-3494 4
- 202-225-3512 4
- 202-225-3516 4
- 202-225-3521 4
- 202-225-3529 4
- 202-225-3719 4
- 202-225-3984 4
- 202-225-4042 4
- 202-225-4060 4
- 202-225-4085 4
- 202-225-4099 4
- 202-225-4282 4
- 202-225-4300 4
- 202-225-4335 4
- 202-225-4381 4
- 202-225-4382 4
- 202-225-4392 4
- 202-225-4403 4
- 202-225-4420 4
- 202-225-4628 4
- 202-225-4656 4
- 202-225-4669 4
- 202-225-4696 4
- 202-225-4709 4
- 202-225-4886 4
- 202-225-4890 4
- 202-225-4977 4
- 202-225-4986 4
- 202-225-5077 4
- 202-225-5144 4
- 202-225-5163 4
- 202-225-5241 4
- 202-225-5278 4
- 202-225-5444 4
- 202-225-5467 4
- 202-225-5513 4
- 202-225-5517 4
- 202-225-5524 4
- 202-225-5547 4
- 202-225-5587 4
- 202-225-5590 4
- 202-225-5602 4
- 202-225-5603 4
- 202-225-5604 4
- 202-225-5609 4
- 202-225-5620 4
- 202-225-5629 4
- 202-225-5633 4
- 202-225-5638 4
- 202-225-5639 4
- 202-225-5641 4
- 202-225-5652 4
- 202-225-5657 4
- 202-225-5658 4
- 202-225-5663 4
- 202-225-5679 4
- 202-225-5683 4
- 202-225-5686 4
- 202-225-5687 4
- 202-225-5699 4
- 202-225-5712 4
- 202-225-5713 4
- 202-225-5739 4
- 202-225-5758 4
- 202-225-5759 4
- 202-225-5773 4
- 202-225-5774 4
- 202-225-5776 4
- 202-225-5782 4
- 202-225-5796 4
- 202-225-5797 4
- 202-225-5820 4
- 202-225-5823 4
- 202-225-5828 4
- 202-225-5857 4
- 202-225-5870 4
- 202-225-5878 4
- 202-225-5879 4
- 202-225-5880 4
- 202-225-5886 4
- 202-225-5893 4
- 202-225-5898 4
- 202-225-5903 4
- 202-225-5907 4
- 202-225-5914 4
- 202-225-5915 4
- 202-225-5955 4
- 202-225-5976 4
- 202-225-6001 4
- 202-225-6025 4
- 202-225-6281 4
- 202-225-6328 4
- 202-225-6351 4
- 202-225-6356 4
- 202-225-6440 4
- 202-225-6475 4
- 202-225-6754 4
- 202-225-6790 4
- 202-225-6887 4
- 202-225-6923 4
- 202-225-7074 4
- 202-225-7564 4
- 202-225-7711 4
- 202-225-7768 4
- 202-225-7810 4
- 202-225-7822 4
- 202-225-7854 4
- 202-225-7926 4
- 202-225-7986 4
- 202-225-8112 4
- 202-225-8135 4
- 202-225-8216 4
- 202-225-8221 4
- 202-225-8259 4
- 202-225-8272 4
- 202-225-8354 4
- 202-225-8440 4
- 202-225-8576 4
- 202-225-8611 4
- 202-225-8628 4
- 202-225-8671 4
- 202-225-8698 4
- 202-225-8757 4
- 202-225-8890 4
- 202-225-8913 4
- 202-225-8941 4
- 202-225-9061 4
- 202-225-9073 4
- 202-225-9177 4
- 202-225-9219 4
- 202-225-9308 4
- 202-225-9322 4
- 202-225-9420 4
- 202-225-9460 4
- 202-225-9594 4
- 202-225-9629 4
- 202-225-9665 4
- 202-225-9679 4
- 202-225-9681 4
- 202-225-9817 4
- 202-225-9903 4
- 202-226-0092 4
- 202-226-0112 4
- 202-226-0280 4
- 202-226-0327 4
- 202-226-0333 4
- 202-226-0335 4
- 202-226-0341 4
- 202-226-0347 4
- 202-226-0350 4
- 202-226-0371 4
- 202-226-0386 4
- 202-226-0577 4
- 202-226-0585 4
- 202-226-0611 4
- 202-226-0621 4
- 202-226-0683 4
- 202-226-0691 4
- 202-226-0757 4
- 202-226-0771 4
- 202-226-0776 4
- 202-226-0777 4
- 202-226-0778 4
- 202-226-0779 4
- 202-226-0792 4
- 202-226-0828 4
- 202-226-0893 4
- 202-226-1000 4
- 202-226-1012 4
- 202-226-1033 4
- 202-226-1035 4
- 202-226-1134 4
- 202-226-1177 4
- 202-226-1224 4
- 202-226-1230 4
- 202-226-1298 4
- 202-226-1463 4
- 202-226-1477 4
- 202-226-1528 4
- 202-226-1606 4
- 202-226-2019 4
- 202-226-2269 4
- 202-226-2279 4
- 202-226-2638 4
- 202-226-3717 4
- 202-226-4169 4
- 202-226-4249 4
- 202-226-4386 4
- 202-226-4523 4
- 202-226-4623 4
- 202-226-4888 4
- 202-226-5172 4
- 202-226-6299 4
- 202-226-6599 4
- 202-226-6866 4
- 202-226-6890 4
- 202-226-6962 4
- 202-226-8485 4
- 202-226-9567 4
- 202-226-9669 4
- 202-228-6362 4
- 202-347-0956 4
- 202- 225-2185 3
- 202- 225-3549 3
- 202- 225-4744 3
- 202- 225-5124 3
- 202- 225-5662 3
- 202- 225-5729 3
- 202- 225-9511 3
- 202- 226-6559 3
- 202-225-0016 3
- 202-225-0096 3
- 202-225-0129 3
- 202-225-0148 3
- 202-225-0271 3
- 202-225-0285 3
- 202-225-0688 3
- 202-225-0704 3
- 202-225-1589 3
- 202-225-1765 3
- 202-225-1891 3
- 202-225-1984 3
- 202-225-1992 3
- 202-225-2013 3
- 202-225-2193 3
- 202-225-2202 3
- 202-225-2256 3
- 202-225-2291 3
- 202-225-2504 3
- 202-225-2515 3
- 202-225-2595 3
- 202-225-2699 3
- 202-225-3057 3
- 202-225-3240 3
- 202-225-3414 3
- 202-225-3462 3
- 202-225-3489 3
- 202-225-3547 3
- 202-225-4160 3
- 202-225-4218 3
- 202-225-4583 3
- 202-225-5392 3
- 202-225-5615 3
- 202-225-5632 3
- 202-225-5681 3
- 202-225-5688 3
- 202-225-5724 3
- 202-225-5859 3
- 202-225-6197 3
- 202-225-6393 3
- 202-225-6791 3
- 202-225-7018 3
- 202-225-8039 3
- 202-225-8398 3
- 202-225-8714 3
- 202-225-9048 3
- 202-225-9249 3
- 202-225-9497 3
- 202-225-9615 3
- 202-225-9731 3
- 202-225-9764 3
- 202-225-9770 3
- 202-226-0396 3
- 202-226-0544 3
- 202-226-0821 3
- 202-226-1169 3
- 202-226-1170 3
- 202-226-2052 3
- 202-226-3196 3
- 202-226-5452 3
- 202-226-6422 3
- 202-226-7290 3
- 202-226-9739 3
- 202-228-1153 3
- 202-228-2862 3
- 202-228-3398 3
- 309-786-3720 3
- 512-473-8946 3
- 530-534-7800 3
- 561-998-9048 3
- 570-341-1055 3
- 704-782-1004 3
- 765-747-5586 3
- 801-364-5551 3
- 843-521-2535 3
- 918-935-2716 3
- 919-782-4490 3
- 202-224-0044 2
- 202-224-0238 2
- 202-224-1651 2
- 202-224-1724 2
- 202-224-1946 2
- 202-224-2499 2
- 202-224-2573 2
- 202-224-2693 2
- 202-224-3149 2
- 202-224-3416 2
- 202-224-3479 2
- 202-224-3514 2
- 202-224-3808 2
- 202-224-4680 2
- 202-224-5301 2
- 202-224-6020 2
- 202-224-6295 2
- 202-224-6331 2
- 202-224-7776 2
- 202-224-7999 2
- 202-224-8149 2
- 202-224-8594 2
- 202-224-9450 2
- 202-224-9673 2
- 202-225-0699 2
- 202-225-0837 2
- 202-225-1238 2
- 202-225-1655 2
- 202-225-2154 2
- 202-225-2563 2
- 202-225-3119 2
- 202-225-3289 2
- 202-225-3301 2
- 202-225-4580 2
- 202-225-5709 2
- 202-225-5822 2
- 202-225-5910 2
- 202-225-6498 2
- 202-225-6583 2
- 202-225-6666 2
- 202-225-9702 2
- 202-225-9742 2
- 202-226-9870 2
- 202-228-0282 2
- 202-228-0284 2
- 202-228-0285 2
- 202-228-0325 2
- 202-228-0359 2
- 202-228-0378 2
- 202-228-0380 2
- 202-228-0400 2
- 202-228-0514 2
- 202-228-0566 2
- 202-228-0604 2
- 202-228-0724 2
- 202-228-0776 2
- 202-228-1371 2
- 202-228-1373 2
- 202-228-1375 2
- 202-228-2183 2
- 202-228-2186 2
- 202-228-2190 2
- 202-228-2197 2
- 202-228-2717 2
- 202-228-2856 2
- 202-228-2981 2
- 202-228-3027 2
- 202-228-3075 2
- 202-228-3194 2
- 202-228-3261 2
- 202-228-3954 2
- 202-228-3997 2
- 202-228-5097 2
- 202-228-5429 2
- 202-228-5765 2
- 202-228-6321 2
- 202-228-6326 2
- 202-228-6363 2
- 202-228-6966 2
- 217-791-6168 2
- 920-230-7262 2
- 200-226-9739 1
- 202- 225-3289 1
- 202- 225-5396 1
- 202- 225-6211 1
- 202- 226-1272 1
- 202- 226-3944 1
- 202-224-0103 1
- 202-224-0454 1
- 202-224-0515 1
- 202-224-0776 1
- 202-224-1388 1
- 202-224-2126 1
- 202-224-2207 1
- 202-224-2354 1
- 202-224-2852 1
- 202-224-4952 1
- 202-224-6008 1
- 202-224-6747 1
- 202-224-7327 1
- 202-224-7665 1
- 202-224-7981 1
- 202-224-8378 1
- 202-224-8525 1
- 202-224-8858 1
- 202-224-9075 1
- 202-224-9369 1
- 202-224-9735 1
- 202-224-9750 1
- 202-224-9787 1
- 202-225-0032 1
- 202-225-0181 1
- 202-225-0899 1
- 202-225-1018 1
- 202-225-1314 1
- 202-225-1740 1
- 202-225-2016 1
- 202-225-2052 1
- 202-225-2122 1
- 202-225-2237 1
- 202-225-2266 1
- 202-225-2667 1
- 202-225-2695 1
- 202-225-2961 1
- 202-225-3196 1
- 202-225-3382 1
- 202-225-3479 1
- 202-225-3973 1
- 202-225-4036 1
- 202-225-5284 1
- 202-225-5608 1
- 202-225-5730 1
- 202-225-5745 1
- 202-225-5851 1
- 202-225-7452 1
- 202-225-7830 1
- 202-225-9187 1
- 202-225-9690 1
- 202-225-9783 1
- 202-226-0218 1
- 202-226-0346 1
- 202-226-0439 1
- 202-226-0774 1
- 202-226-0996 1
- 202-226-1176 1
- 202-226-1272 1
- 202-226-2274 1
- 202-226-3805 1
- 202-226-6553 1
- 202-228-0002 1
- 202-228-0012 1
- 202-228-0360 1
- 202-228-0436 1
- 202-228-0908 1
- 202-228-1236 1
- 202-228-1325 1
- 202-228-1820 1
- 202-228-2072 1
- 202-228-2563 1
- 202-228-4054 1
- 202-228-4611 1
- 202-228-5061 1
- 202-228-5143 1
- 202-228-6753 1
- 210-927-4903 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25111 | 25111 | Fred Aandahl A000001 | rep | ND | 1951-01-03 | 1953-01-03 | Republican | 0 | |||||||||||||
29511 | 29511 | Watkins Abbitt A000002 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
29512 | 29512 | Watkins Abbitt A000002 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
29513 | 29513 | Watkins Abbitt A000002 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
29514 | 29514 | Watkins Abbitt A000002 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
29515 | 29515 | Watkins Abbitt A000002 | rep | VA | 1955-01-05 | 1957-01-03 | Democrat | 4 | |||||||||||||
29516 | 29516 | Watkins Abbitt A000002 | rep | VA | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
29517 | 29517 | Watkins Abbitt A000002 | rep | VA | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
29518 | 29518 | Watkins Abbitt A000002 | rep | VA | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
29519 | 29519 | Watkins Abbitt A000002 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
29520 | 29520 | Watkins Abbitt A000002 | rep | VA | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
29521 | 29521 | Watkins Abbitt A000002 | rep | VA | 1967-01-10 | 1969-01-03 | Democrat | 4 | |||||||||||||
29522 | 29522 | Watkins Abbitt A000002 | rep | VA | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
29523 | 29523 | Watkins Abbitt A000002 | rep | VA | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
2373 | 2373 | Joel Abbott A000003 | rep | GA | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2374 | 2374 | Joel Abbott A000003 | rep | GA | 1819-12-06 | 1821-03-03 | Republican | -1 | |||||||||||||
2375 | 2375 | Joel Abbott A000003 | rep | GA | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2376 | 2376 | Joel Abbott A000003 | rep | GA | 1823-12-01 | 1825-03-03 | Republican | -1 | |||||||||||||
5588 | 5588 | Amos Abbott A000004 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 3 | |||||||||||||
5589 | 5589 | Amos Abbott A000004 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 3 | |||||||||||||
5590 | 5590 | Amos Abbott A000004 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
12886 | 12886 | Jo Abbott A000005 | rep | TX | 1887-12-05 | 1889-03-03 | Democrat | 6 | |||||||||||||
12887 | 12887 | Jo Abbott A000005 | rep | TX | 1889-12-02 | 1891-03-03 | Democrat | 6 | |||||||||||||
12888 | 12888 | Jo Abbott A000005 | rep | TX | 1891-12-07 | 1893-03-03 | Democrat | 6 | |||||||||||||
12889 | 12889 | Jo Abbott A000005 | rep | TX | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
12890 | 12890 | Jo Abbott A000005 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 6 | |||||||||||||
8493 | 8493 | Joseph Abbott A000006 | sen | NC | 1868-01-01 | 1871-03-03 | 2 | Republican | |||||||||||||
9440 | 9440 | Josiah Abbott A000007 | rep | MA | 1875-12-06 | 1877-03-03 | Democrat | 4 | |||||||||||||
6971 | 6971 | Nehemiah Abbott A000008 | rep | ME | 1857-12-07 | 1859-03-03 | Republican | 3 | |||||||||||||
32430 | 32430 | James Abdnor A000009 | rep | SD | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
32431 | 32431 | James Abdnor A000009 | rep | SD | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
32432 | 32432 | James Abdnor A000009 | rep | SD | 1977-01-04 | 1979-01-03 | Republican | 2 | |||||||||||||
32433 | 32433 | James Abdnor A000009 | rep | SD | 1979-01-15 | 1981-01-03 | Republican | 2 | |||||||||||||
32434 | 32434 | James Abdnor A000009 | sen | SD | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
25846 | 25846 | Hazel Abel A000010 | sen | NE | 1954-01-01 | 1955-01-03 | 2 | Republican | |||||||||||||
27602 | 27602 | Homer Abele A000011 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 10 | |||||||||||||
6486 | 6486 | James Abercrombie A000012 | rep | AL | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6487 | 6487 | James Abercrombie A000012 | rep | AL | 1853-12-05 | 1855-03-03 | Whig | 2 | |||||||||||||
16662 | 16662 | John Abercrombie A000013 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
16663 | 16663 | John Abercrombie A000013 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | -1 | |||||||||||||
38394 | 38394 | Neil Abercrombie A000014 | rep | HI | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
38395 | 38395 | Neil Abercrombie A000014 | rep | HI | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
38396 | 38396 | Neil Abercrombie A000014 | rep | HI | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
38397 | 38397 | Neil Abercrombie A000014 | rep | HI | 1995-01-04 | 1997-01-03 | Democrat | 1 | |||||||||||||
38398 | 38398 | Neil Abercrombie A000014 | rep | HI | 1997-01-07 | 1999-01-03 | Democrat | 1 | |||||||||||||
38399 | 38399 | Neil Abercrombie A000014 | rep | HI | 1999-01-06 | 2001-01-03 | Democrat | 1 | |||||||||||||
38400 | 38400 | Neil Abercrombie A000014 | rep | HI | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
38401 | 38401 | Neil Abercrombie A000014 | rep | HI | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/abercrombie | ||||||||||||
38402 | 38402 | Neil Abercrombie A000014 | rep | HI | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/abercrombie | ||||||||||||
38403 | 38403 | Neil Abercrombie A000014 | rep | HI | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/abercrombie | ||||||||||||
38404 | 38404 | Neil Abercrombie A000014 | rep | HI | 2009-01-06 | 2010-03-01 | Democrat | 1 | http://www.house.gov/abercrombie | ||||||||||||
21066 | 21066 | Charles Abernethy A000015 | rep | NC | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
21067 | 21067 | Charles Abernethy A000015 | rep | NC | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
21068 | 21068 | Charles Abernethy A000015 | rep | NC | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
21069 | 21069 | Charles Abernethy A000015 | rep | NC | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
21070 | 21070 | Charles Abernethy A000015 | rep | NC | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
21071 | 21071 | Charles Abernethy A000015 | rep | NC | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
21072 | 21072 | Charles Abernethy A000015 | rep | NC | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
29524 | 29524 | Thomas Abernethy A000016 | rep | MS | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
29525 | 29525 | Thomas Abernethy A000016 | rep | MS | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
29526 | 29526 | Thomas Abernethy A000016 | rep | MS | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
29527 | 29527 | Thomas Abernethy A000016 | rep | MS | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
29528 | 29528 | Thomas Abernethy A000016 | rep | MS | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
29529 | 29529 | Thomas Abernethy A000016 | rep | MS | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
29530 | 29530 | Thomas Abernethy A000016 | rep | MS | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
29531 | 29531 | Thomas Abernethy A000016 | rep | MS | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
29532 | 29532 | Thomas Abernethy A000016 | rep | MS | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
29533 | 29533 | Thomas Abernethy A000016 | rep | MS | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
29534 | 29534 | Thomas Abernethy A000016 | rep | MS | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
29535 | 29535 | Thomas Abernethy A000016 | rep | MS | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
29536 | 29536 | Thomas Abernethy A000016 | rep | MS | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
29537 | 29537 | Thomas Abernethy A000016 | rep | MS | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
29538 | 29538 | Thomas Abernethy A000016 | rep | MS | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
30136 | 30136 | James Abourezk A000017 | rep | SD | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
30137 | 30137 | James Abourezk A000017 | sen | SD | 1973-01-03 | 1979-01-03 | 2 | Democrat | |||||||||||||
30800 | 30800 | Bella Abzug A000018 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 19 | |||||||||||||
30801 | 30801 | Bella Abzug A000018 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 20 | |||||||||||||
30802 | 30802 | Bella Abzug A000018 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 20 | |||||||||||||
14962 | 14962 | Ernest Acheson A000019 | rep | PA | 1895-12-02 | 1897-03-03 | Republican | 24 | |||||||||||||
14963 | 14963 | Ernest Acheson A000019 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 24 | |||||||||||||
14964 | 14964 | Ernest Acheson A000019 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 24 | |||||||||||||
14965 | 14965 | Ernest Acheson A000019 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 24 | |||||||||||||
14966 | 14966 | Ernest Acheson A000019 | rep | PA | 1903-11-09 | 1905-03-03 | Republican | 24 | |||||||||||||
14967 | 14967 | Ernest Acheson A000019 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 24 | |||||||||||||
14968 | 14968 | Ernest Acheson A000019 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 24 | |||||||||||||
8798 | 8798 | Ephraim Acker A000020 | rep | PA | 1871-03-04 | 1873-03-03 | Democrat | 6 | |||||||||||||
20073 | 20073 | Ernest Ackerman A000021 | rep | NJ | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
20074 | 20074 | Ernest Ackerman A000021 | rep | NJ | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
20075 | 20075 | Ernest Ackerman A000021 | rep | NJ | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
20076 | 20076 | Ernest Ackerman A000021 | rep | NJ | 1925-12-07 | 1927-03-04 | Republican | 5 | |||||||||||||
20077 | 20077 | Ernest Ackerman A000021 | rep | NJ | 1927-12-05 | 1929-03-03 | Republican | 5 | |||||||||||||
20078 | 20078 | Ernest Ackerman A000021 | rep | NJ | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
20079 | 20079 | Ernest Ackerman A000021 | rep | NJ | 1931-12-07 | 1933-03-03 | Republican | 5 | |||||||||||||
39084 | 39084 | Gary Ackerman A000022 | rep | NY | 1983-01-03 | 1985-01-03 | Democrat | 7 | |||||||||||||
39085 | 39085 | Gary Ackerman A000022 | rep | NY | 1985-01-03 | 1987-01-03 | Democrat | 7 | |||||||||||||
39086 | 39086 | Gary Ackerman A000022 | rep | NY | 1987-01-06 | 1989-01-03 | Democrat | 7 | |||||||||||||
39087 | 39087 | Gary Ackerman A000022 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 7 | |||||||||||||
39088 | 39088 | Gary Ackerman A000022 | rep | NY | 1991-01-03 | 1993-01-03 | Democrat | 7 | |||||||||||||
39089 | 39089 | Gary Ackerman A000022 | rep | NY | 1993-01-05 | 1995-01-03 | Democrat | 5 | |||||||||||||
39090 | 39090 | Gary Ackerman A000022 | rep | NY | 1995-01-04 | 1997-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);