legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by district
This data as json, copyable, CSV (advanced)
Suggested facets: party, district, how, phone, contact_form, office, state_rank, rss_url, start (date)
These facets timed out: end
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | Richard Bassett B000226 | sen | DE | 1789-03-04 | 1793-03-03 | 2 | Anti-Administration | |||||||||||||
7 | 7 | Tristram Dalton D000013 | sen | MA | 1789-03-04 | 1791-03-03 | 1 | Pro-Administration | |||||||||||||
8 | 8 | Jonathan Elmer E000155 | sen | NJ | 1789-03-04 | 1791-03-03 | 1 | Pro-Administration | |||||||||||||
9 | 9 | William Few F000100 | sen | GA | 1789-03-04 | 1793-03-03 | 2 | Anti-Administration | |||||||||||||
12 | 12 | William Grayson G000403 | sen | VA | 1789-03-04 | 1791-03-03 | 1 | Anti-Administration | |||||||||||||
14 | 14 | Benjamin Hawkins H000368 | sen | NC | 1789-03-04 | 1795-03-03 | 3 | Pro-Administration | |||||||||||||
16 | 16 | Ralph Izard I000053 | sen | SC | 1789-03-04 | 1795-03-03 | 3 | Pro-Administration | |||||||||||||
17 | 17 | William Johnson J000182 | sen | CT | 1789-03-04 | 1791-12-31 | 3 | Pro-Administration | |||||||||||||
18 | 18 | Samuel Johnston J000198 | sen | NC | 1789-03-04 | 1793-03-03 | 2 | Pro-Administration | |||||||||||||
19 | 19 | Richard Lee L000201 | sen | VA | 1789-03-04 | 1793-03-03 | 2 | Anti-Administration | |||||||||||||
20 | 20 | William Maclay M000031 | sen | PA | 1789-03-04 | 1791-03-03 | 1 | Anti-Administration | |||||||||||||
22 | 22 | Robert Morris M000985 | sen | PA | 1789-03-04 | 1795-03-03 | 3 | Pro-Administration | |||||||||||||
24 | 24 | William Paterson P000102 | sen | NJ | 1789-03-04 | 1791-03-03 | 2 | Pro-Administration | |||||||||||||
29 | 29 | Philemon Dickinson D000324 | sen | NJ | 1790-01-01 | 1793-03-03 | 2 | Pro-Administration | |||||||||||||
30 | 30 | John Walker W000059 | sen | VA | 1790-01-01 | 1791-03-03 | 1 | Pro-Administration | |||||||||||||
34 | 34 | Aaron Burr B001133 | sen | NY | 1791-10-24 | 1797-03-03 | 1 | Republican | |||||||||||||
35 | 35 | George Cabot C000009 | sen | MA | 1791-10-24 | 1797-03-03 | 1 | Federalist | |||||||||||||
36 | 36 | Charles Carroll C000185 | sen | MD | 1789-03-04 | 1791-03-03 | 1 | Pro-Administration | |||||||||||||
37 | 37 | Charles Carroll C000185 | sen | MD | 1791-10-24 | 1793-03-03 | 1 | ||||||||||||||
38 | 38 | Oliver Ellsworth E000147 | sen | CT | 1789-03-04 | 1791-03-03 | 1 | Pro-Administration | |||||||||||||
39 | 39 | Oliver Ellsworth E000147 | sen | CT | 1791-10-24 | 1797-03-03 | 1 | Federalist | |||||||||||||
46 | 46 | George Read R000091 | sen | DE | 1789-03-04 | 1791-03-03 | 1 | Pro-Administration | |||||||||||||
47 | 47 | George Read R000091 | sen | DE | 1791-10-24 | 1793-12-31 | 1 | ||||||||||||||
48 | 48 | Moses Robinson R000350 | sen | VT | 1791-10-24 | 1796-10-15 | 1 | Anti-Administration | |||||||||||||
54 | 54 | Roger Sherman S000349 | sen | CT | 1791-10-24 | 1793-12-31 | 3 | Pro-Administration | |||||||||||||
70 | 70 | John Edwards E000075 | sen | KY | 1792-01-01 | 1795-03-03 | 3 | Anti-Administration | |||||||||||||
71 | 71 | Richard Potts P000473 | sen | MD | 1793-01-10 | 1796-10-14 | 1 | Federalist | |||||||||||||
79 | 79 | William Bradford B000739 | sen | RI | 1793-12-02 | 1797-12-31 | 2 | Federalist | |||||||||||||
93 | 93 | Frederick Frelinghuysen F000368 | sen | NJ | 1793-12-02 | 1797-03-03 | 2 | Federalist | |||||||||||||
107 | 107 | Alexander Martin M000166 | sen | NC | 1793-12-02 | 1799-03-03 | 2 | Republican | |||||||||||||
112 | 112 | Stephen Mitchell M000828 | sen | CT | 1793-12-02 | 1795-03-03 | 3 | Pro-Administration | |||||||||||||
120 | 120 | Caleb Strong S001009 | sen | MA | 1789-03-04 | 1793-03-03 | 2 | Pro-Administration | |||||||||||||
121 | 121 | Caleb Strong S001009 | sen | MA | 1793-12-02 | 1797-03-03 | 2 | Federalist | |||||||||||||
128 | 128 | John Vining V000104 | sen | DE | 1793-12-02 | 1799-03-03 | 2 | Federalist | |||||||||||||
137 | 137 | Paine Wingate W000633 | sen | NH | 1789-03-04 | 1793-03-03 | 2 | Anti-Administration | |||||||||||||
139 | 139 | Henry Tazewell T000107 | sen | VA | 1794-01-01 | 1799-03-03 | 2 | Republican | |||||||||||||
140 | 140 | George Walton W000114 | sen | GA | 1795-11-16 | 1796-02-20 | 2 | Federalist | |||||||||||||
145 | 145 | William Bingham B000474 | sen | PA | 1795-12-07 | 1801-03-03 | 3 | Federalist | |||||||||||||
147 | 147 | Timothy Bloodworth B000563 | sen | NC | 1795-12-07 | 1801-03-03 | 3 | Republican | |||||||||||||
167 | 167 | James Gunn G000526 | sen | GA | 1789-03-04 | 1795-03-03 | 3 | Federalist | |||||||||||||
168 | 168 | James Gunn G000526 | sen | GA | 1795-12-07 | 1801-03-03 | 3 | Federalist | |||||||||||||
176 | 176 | John Henry H000508 | sen | MD | 1789-03-04 | 1795-03-03 | 3 | Pro-Administration | |||||||||||||
177 | 177 | John Henry H000508 | sen | MD | 1795-12-07 | 1797-12-31 | 3 | Federalist | |||||||||||||
178 | 178 | John Langdon L000067 | sen | NH | 1789-03-04 | 1795-03-03 | 3 | Democratic Republican | |||||||||||||
179 | 179 | John Langdon L000067 | sen | NH | 1795-12-07 | 1801-03-03 | 3 | Republican | |||||||||||||
185 | 185 | Humphrey Marshall M000155 | sen | KY | 1795-12-07 | 1801-03-03 | 3 | Federalist | |||||||||||||
200 | 200 | Elijah Paine P000026 | sen | VT | 1795-12-07 | 1801-03-03 | 3 | Federalist | |||||||||||||
205 | 205 | Jacob Read R000092 | sen | SC | 1795-12-07 | 1801-03-03 | 3 | Federalist | |||||||||||||
221 | 221 | Jonathan Trumbull T000389 | sen | CT | 1795-12-07 | 1797-03-03 | 3 | Federalist | |||||||||||||
224 | 224 | William Blount B000570 | sen | TN | 1796-01-01 | 1797-12-31 | 2 | Republican | |||||||||||||
229 | 229 | Benjamin Goodhue G000286 | sen | MA | 1796-06-11 | 1797-03-03 | 1 | Federalist | |||||||||||||
230 | 230 | Benjamin Goodhue G000286 | sen | MA | 1797-03-04 | 1800-11-08 | 1 | Federalist | |||||||||||||
231 | 231 | John Howard H000841 | sen | MD | 1796-12-05 | 1797-03-04 | 1 | Federalist | |||||||||||||
232 | 232 | John Howard H000841 | sen | MD | 1797-03-04 | 1803-03-03 | 1 | Federalist | |||||||||||||
234 | 234 | John Hunter H000982 | sen | SC | 1796-01-01 | 1799-03-03 | 2 | Republican | |||||||||||||
237 | 237 | John Laurance L000120 | sen | NY | 1796-01-01 | 1801-03-03 | 3 | Federalist | |||||||||||||
238 | 238 | Josiah Tattnall T000052 | sen | GA | 1796-01-01 | 1799-03-03 | 2 | Republican | |||||||||||||
252 | 252 | Nathaniel Chipman C000369 | sen | VT | 1797-05-15 | 1803-03-03 | 1 | Federalist | |||||||||||||
261 | 261 | Theodore Foster F000313 | sen | RI | 1790-06-12 | 1791-03-03 | 1 | Federalist | |||||||||||||
262 | 262 | Theodore Foster F000313 | sen | RI | 1791-03-04 | 1797-03-03 | 1 | Federalist | |||||||||||||
263 | 263 | Theodore Foster F000313 | sen | RI | 1797-05-15 | 1803-03-03 | 1 | Republican | |||||||||||||
271 | 271 | Henry Latimer L000115 | sen | DE | 1795-12-07 | 1797-03-03 | 1 | Federalist | |||||||||||||
272 | 272 | Henry Latimer L000115 | sen | DE | 1797-05-15 | 1801-12-31 | 1 | Federalist | |||||||||||||
273 | 273 | James Lloyd L000377 | sen | MD | 1797-05-15 | 1801-03-03 | 3 | Federalist | |||||||||||||
278 | 278 | Stevens Mason M000226 | sen | VA | 1794-01-01 | 1797-03-03 | 1 | Republican | |||||||||||||
279 | 279 | Stevens Mason M000226 | sen | VA | 1797-05-15 | 1803-03-03 | 1 | Republican | |||||||||||||
285 | 285 | James Ross R000448 | sen | PA | 1794-01-01 | 1797-03-03 | 1 | Federalist | |||||||||||||
286 | 286 | James Ross R000448 | sen | PA | 1797-05-15 | 1803-03-03 | 1 | Federalist | |||||||||||||
287 | 287 | John Rutherfurd R000550 | sen | NJ | 1791-10-24 | 1797-03-03 | 1 | Federalist | |||||||||||||
288 | 288 | John Rutherfurd R000550 | sen | NJ | 1797-05-15 | 1799-03-03 | 1 | Federalist | |||||||||||||
289 | 289 | Philip Schuyler S000154 | sen | NY | 1789-03-04 | 1791-03-03 | 1 | Pro-Administration | |||||||||||||
290 | 290 | Philip Schuyler S000154 | sen | NY | 1797-05-15 | 1799-03-03 | 1 | Federalist | |||||||||||||
317 | 317 | Joshua Clayton C000497 | sen | DE | 1798-01-01 | 1799-03-03 | 2 | Federalist | |||||||||||||
318 | 318 | John Hobart H000661 | sen | NY | 1798-01-01 | 1799-03-03 | 1 | Federalist | |||||||||||||
319 | 319 | William North N000142 | sen | NY | 1798-01-01 | 1799-03-03 | 1 | Federalist | |||||||||||||
320 | 320 | James Watson W000202 | sen | NY | 1798-01-01 | 1801-03-03 | 1 | Federalist | |||||||||||||
328 | 328 | John Brown B000929 | sen | KY | 1792-06-18 | 1793-03-03 | 2 | Republican | |||||||||||||
329 | 329 | John Brown B000929 | sen | KY | 1793-03-04 | 1799-03-03 | 2 | Republican | |||||||||||||
330 | 330 | John Brown B000929 | sen | KY | 1799-12-02 | 1805-03-03 | 2 | Republican | |||||||||||||
334 | 334 | William Cocke C000572 | sen | TN | 1796-01-01 | 1797-03-03 | 1 | Republican | |||||||||||||
335 | 335 | William Cocke C000572 | sen | TN | 1799-12-02 | 1805-03-03 | 2 | Republican | |||||||||||||
341 | 341 | Franklin Davenport D000069 | sen | NJ | 1798-12-05 | 1799-03-03 | 1 | Federalist | |||||||||||||
347 | 347 | Jonathan Dayton D000165 | sen | NJ | 1799-12-02 | 1805-03-03 | 2 | Federalist | |||||||||||||
353 | 353 | Samuel Dexter D000296 | sen | MA | 1799-12-02 | 1801-03-03 | 2 | Federalist | |||||||||||||
374 | 374 | Ray Greene G000427 | sen | RI | 1797-05-15 | 1799-03-03 | 2 | Federalist | |||||||||||||
375 | 375 | Ray Greene G000427 | sen | RI | 1799-12-02 | 1801-12-31 | 2 | Federalist | |||||||||||||
397 | 397 | Samuel Livermore L000364 | sen | NH | 1793-12-02 | 1799-03-03 | 2 | Federalist | |||||||||||||
398 | 398 | Samuel Livermore L000364 | sen | NH | 1799-12-02 | 1801-12-31 | 2 | Federalist | |||||||||||||
426 | 426 | Theodore Sedgwick S000222 | sen | MA | 1796-01-01 | 1799-03-03 | 2 | Federalist | |||||||||||||
448 | 448 | Dwight Foster F000301 | sen | MA | 1800-01-01 | 1803-12-31 | 2 | Federalist | |||||||||||||
453 | 453 | William Hindman H000629 | sen | MD | 1800-01-01 | 1801-03-03 | 3 | Federalist | |||||||||||||
454 | 454 | Gouverneur Morris M000976 | sen | NY | 1800-01-01 | 1803-03-03 | 1 | Federalist | |||||||||||||
459 | 459 | John Breckinridge B000787 | sen | KY | 1801-12-07 | 1805-12-31 | 3 | Republican | |||||||||||||
464 | 464 | John Colhoun C000627 | sen | SC | 1801-12-07 | 1803-03-03 | 3 | Republican | |||||||||||||
468 | 468 | Christopher Ellery E000114 | sen | RI | 1801-12-07 | 1805-03-03 | 2 | Republican | |||||||||||||
494 | 494 | James Jackson J000017 | sen | GA | 1793-12-02 | 1795-12-31 | 2 | Republican | |||||||||||||
495 | 495 | James Jackson J000017 | sen | GA | 1801-12-07 | 1807-03-03 | 3 | Republican | |||||||||||||
502 | 502 | George Logan L000401 | sen | PA | 1801-12-07 | 1807-03-03 | 3 | Republican | |||||||||||||
512 | 512 | John Muhlenberg M001066 | sen | PA | 1801-12-07 | 1801-12-31 | 3 | Democratic Republican | |||||||||||||
513 | 513 | Aaron Ogden O000041 | sen | NJ | 1801-12-07 | 1803-03-03 | 1 | Federalist |
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);