legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by end
This data as json, copyable, CSV (advanced)
Suggested facets: state, class, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | 2 | Theodorick Bland B000546 | rep | VA | 1789-03-04 | 1791-03-03 | 9 | ||||||||||||||
3 | 3 | Aedanus Burke B001086 | rep | SC | 1789-03-04 | 1791-03-03 | 2 | ||||||||||||||
4 | 4 | Daniel Carroll C000187 | rep | MD | 1789-03-04 | 1791-03-03 | 6 | ||||||||||||||
5 | 5 | George Clymer C000538 | rep | PA | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
6 | 6 | Benjamin Contee C000710 | rep | MD | 1789-03-04 | 1791-03-03 | 3 | ||||||||||||||
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 | |||||||||||||
10 | 10 | William Floyd F000224 | rep | NY | 1789-03-04 | 1791-03-03 | 1 | ||||||||||||||
11 | 11 | George Gale G000012 | rep | MD | 1789-03-04 | 1791-03-03 | 5 | ||||||||||||||
12 | 12 | William Grayson G000403 | sen | VA | 1789-03-04 | 1791-03-03 | 1 | Anti-Administration | |||||||||||||
13 | 13 | Jonathan Grout G000500 | rep | MA | 1789-03-04 | 1791-03-03 | 8 | ||||||||||||||
15 | 15 | Benjamin Huntington H000995 | rep | CT | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
20 | 20 | William Maclay M000031 | sen | PA | 1789-03-04 | 1791-03-03 | 1 | Anti-Administration | |||||||||||||
21 | 21 | George Mathews M000234 | rep | GA | 1789-03-04 | 1791-03-03 | 3 | ||||||||||||||
23 | 23 | George Partridge P000092 | rep | MA | 1789-03-04 | 1791-03-03 | 5 | ||||||||||||||
24 | 24 | William Paterson P000102 | sen | NJ | 1789-03-04 | 1791-03-03 | 2 | Pro-Administration | |||||||||||||
25 | 25 | William Smith S000624 | rep | MD | 1789-03-04 | 1791-03-03 | 4 | ||||||||||||||
26 | 26 | Michael Stone S000961 | rep | MD | 1789-03-04 | 1791-03-03 | 1 | ||||||||||||||
27 | 27 | Jeremiah Van Rensselaer V000053 | rep | NY | 1789-03-04 | 1791-03-03 | 6 | ||||||||||||||
28 | 28 | Henry Wynkoop W000783 | rep | PA | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
30 | 30 | John Walker W000059 | sen | VA | 1790-01-01 | 1791-03-03 | 1 | Pro-Administration | |||||||||||||
31 | 31 | John Ashe A000307 | rep | NC | 1789-03-04 | 1791-03-03 | 1 | ||||||||||||||
36 | 36 | Charles Carroll C000185 | sen | MD | 1789-03-04 | 1791-03-03 | 1 | Pro-Administration | |||||||||||||
38 | 38 | Oliver Ellsworth E000147 | sen | CT | 1789-03-04 | 1791-03-03 | 1 | Pro-Administration | |||||||||||||
40 | 40 | Elbridge Gerry G000139 | rep | MA | 1789-03-04 | 1791-03-03 | 3 | ||||||||||||||
42 | 42 | Daniel Huger H000916 | rep | SC | 1789-03-04 | 1791-03-03 | 3 | ||||||||||||||
46 | 46 | George Read R000091 | sen | DE | 1789-03-04 | 1791-03-03 | 1 | Pro-Administration | |||||||||||||
50 | 50 | Joshua Seney S000242 | rep | MD | 1789-03-04 | 1791-03-03 | 2 | ||||||||||||||
53 | 53 | Roger Sherman S000349 | rep | CT | 1789-03-04 | 1791-03-03 | Pro-Administration | -1 | |||||||||||||
55 | 55 | Peter Silvester S000412 | rep | NY | 1789-03-04 | 1791-03-03 | 5 | ||||||||||||||
57 | 57 | John Steele S000832 | rep | NC | 1789-03-04 | 1791-03-03 | 4 | ||||||||||||||
60 | 60 | Jonathan Sturges S001047 | rep | CT | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
62 | 62 | Thomas Tucker T000403 | rep | SC | 1789-03-04 | 1791-03-03 | 5 | ||||||||||||||
65 | 65 | Alexander White W000352 | rep | VA | 1789-03-04 | 1791-03-03 | 1 | ||||||||||||||
67 | 67 | Hugh Williamson W000551 | rep | NC | 1789-03-04 | 1791-03-03 | Federalist | 2 | |||||||||||||
74 | 74 | Elias Boudinot B000661 | rep | NJ | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
80 | 80 | Lambert Cadwalader C000012 | rep | NJ | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
89 | 89 | Thomas Fitzsimons F000178 | rep | PA | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
97 | 97 | Samuel Griffin G000466 | rep | VA | 1789-03-04 | 1791-03-03 | 10 | ||||||||||||||
104 | 104 | Richard Lee L000200 | rep | VA | 1789-03-04 | 1791-03-03 | 4 | ||||||||||||||
118 | 118 | Thomas Scott S000186 | rep | PA | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
126 | 126 | John Vining V000104 | rep | DE | 1789-03-04 | 1791-03-03 | Pro-Administration | 0 | |||||||||||||
129 | 129 | Jeremiah Wadsworth W000013 | rep | CT | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
141 | 141 | Fisher Ames A000174 | rep | MA | 1789-03-04 | 1791-03-03 | Federalist | 1 | |||||||||||||
146 | 146 | Timothy Bloodworth B000563 | rep | NC | 1789-03-04 | 1791-03-03 | 3 | ||||||||||||||
148 | 148 | Benjamin Bourne B000669 | rep | RI | 1789-03-04 | 1791-03-03 | Federalist | 1 | |||||||||||||
153 | 153 | Isaac Coles C000624 | rep | VA | 1789-03-04 | 1791-03-03 | Republican | 6 | |||||||||||||
171 | 171 | John Hathorn H000348 | rep | NY | 1789-03-04 | 1791-03-03 | Republican | 4 | |||||||||||||
180 | 180 | George Leonard L000246 | rep | MA | 1789-03-04 | 1791-03-03 | Federalist | 7 | |||||||||||||
186 | 186 | Frederick Muhlenberg M001063 | rep | PA | 1789-03-04 | 1791-03-03 | Pro-administration | -1 | |||||||||||||
196 | 196 | John Page P000018 | rep | VA | 1789-03-04 | 1791-03-03 | Republican | 7 | |||||||||||||
218 | 218 | Jonathan Trumbull T000389 | rep | CT | 1789-03-04 | 1791-03-03 | Federalist | -1 | |||||||||||||
225 | 225 | Benjamin Goodhue G000286 | rep | MA | 1789-03-04 | 1791-03-03 | Federalist | 2 | |||||||||||||
235 | 235 | John Laurance L000120 | rep | NY | 1789-03-04 | 1791-03-03 | 2 | ||||||||||||||
261 | 261 | Theodore Foster F000313 | sen | RI | 1790-06-12 | 1791-03-03 | 1 | Federalist | |||||||||||||
289 | 289 | Philip Schuyler S000154 | sen | NY | 1789-03-04 | 1791-03-03 | 1 | Pro-Administration | |||||||||||||
291 | 291 | Thomas Sinnickson S000448 | rep | NJ | 1789-03-04 | 1791-03-03 | Federalist | -1 | |||||||||||||
302 | 302 | William Smith S000633 | rep | SC | 1789-03-04 | 1791-03-03 | Federalist | 1 | |||||||||||||
326 | 326 | John Brown B000929 | rep | VA | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
376 | 376 | Thomas Hartley H000299 | rep | PA | 1789-03-04 | 1791-03-03 | Federalist | -1 | |||||||||||||
395 | 395 | Samuel Livermore L000364 | rep | NH | 1789-03-04 | 1791-03-03 | Federalist | -1 | |||||||||||||
410 | 410 | Josiah Parker P000065 | rep | VA | 1789-03-04 | 1791-03-03 | Federalist | 8 | |||||||||||||
423 | 423 | Theodore Sedgwick S000222 | rep | MA | 1789-03-04 | 1791-03-03 | Federalist | 4 | |||||||||||||
433 | 433 | George Thatcher T000141 | rep | MA | 1789-03-04 | 1791-03-03 | Federalist | 6 | |||||||||||||
473 | 473 | Abiel Foster F000297 | rep | NH | 1789-03-04 | 1791-03-03 | Federalist | -1 | |||||||||||||
493 | 493 | James Jackson J000017 | rep | GA | 1789-03-04 | 1791-03-03 | Republican | 1 | |||||||||||||
509 | 509 | John Muhlenberg M001066 | rep | PA | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
584 | 584 | Daniel Hiester H000570 | rep | PA | 1789-03-04 | 1791-03-03 | Republican | -1 | |||||||||||||
645 | 645 | Andrew Moore M000891 | rep | VA | 1789-03-04 | 1791-03-03 | Democratic Republican | 3 | |||||||||||||
656 | 656 | Abraham Baldwin B000084 | rep | GA | 1789-03-04 | 1791-03-03 | Democratic Republican | 2 | |||||||||||||
758 | 758 | Thomas Sumter S001073 | rep | SC | 1789-03-04 | 1791-03-03 | 4 | ||||||||||||||
933 | 933 | James Madison M000043 | rep | VA | 1789-03-04 | 1791-03-03 | Republican | 5 | |||||||||||||
1154 | 1154 | William Giles G000183 | rep | VA | 1790-12-07 | 1791-03-03 | Republican | 9 | |||||||||||||
1164 | 1164 | Nicholas Gilman G000215 | rep | NH | 1789-03-04 | 1791-03-03 | Democratic Republican | -1 | |||||||||||||
1276 | 1276 | Egbert Benson B000388 | rep | NY | 1789-03-04 | 1791-03-03 | Federalist | 3 | |||||||||||||
1397 | 1397 | James Schureman S000150 | rep | NJ | 1789-03-04 | 1791-03-03 | Federalist | -1 | |||||||||||||
1699 | 1699 | John Sevier S000257 | rep | NC | 1789-03-04 | 1791-03-03 | Republican | 5 | |||||||||||||
1791 | 1791 | James Monroe M000858 | sen | VA | 1790-11-09 | 1791-03-03 | 1 | Anti-Administration | |||||||||||||
17 | 17 | William Johnson J000182 | sen | CT | 1789-03-04 | 1791-12-31 | 3 | Pro-Administration | |||||||||||||
327 | 327 | John Brown B000929 | rep | VA | 1791-03-04 | 1792-06-01 | -1 | ||||||||||||||
2368 | 2368 | John Taylor T000086 | sen | VA | 1792-10-18 | 1793-03-02 | 2 | ||||||||||||||
1 | 1 | Richard Bassett B000226 | sen | DE | 1789-03-04 | 1793-03-03 | 2 | Anti-Administration | |||||||||||||
9 | 9 | William Few F000100 | sen | GA | 1789-03-04 | 1793-03-03 | 2 | Anti-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 | |||||||||||||
29 | 29 | Philemon Dickinson D000324 | sen | NJ | 1790-01-01 | 1793-03-03 | 2 | Pro-Administration | |||||||||||||
32 | 32 | John Ashe A000307 | rep | NC | 1791-10-24 | 1793-03-03 | 3 | ||||||||||||||
33 | 33 | Robert Barnwell B000167 | rep | SC | 1791-10-24 | 1793-03-03 | 2 | ||||||||||||||
37 | 37 | Charles Carroll C000185 | sen | MD | 1791-10-24 | 1793-03-03 | 1 | ||||||||||||||
41 | 41 | Elbridge Gerry G000139 | rep | MA | 1791-10-24 | 1793-03-03 | 3 | ||||||||||||||
43 | 43 | Daniel Huger H000916 | rep | SC | 1791-10-24 | 1793-03-03 | 3 | ||||||||||||||
44 | 44 | Israel Jacobs J000036 | rep | PA | 1791-10-24 | 1793-03-03 | 3 | ||||||||||||||
45 | 45 | Philip Key K000158 | rep | MD | 1791-10-24 | 1793-03-03 | 1 | ||||||||||||||
49 | 49 | Cornelius Schoonmaker S000140 | rep | NY | 1791-10-24 | 1793-03-03 | 4 | ||||||||||||||
51 | 51 | Joshua Seney S000242 | rep | MD | 1791-10-24 | 1793-03-03 | 2 | ||||||||||||||
52 | 52 | Upton Sheredine S000340 | rep | MD | 1791-10-24 | 1793-03-03 | 6 | ||||||||||||||
56 | 56 | Peter Silvester S000412 | rep | NY | 1791-10-24 | 1793-03-03 | 5 | ||||||||||||||
58 | 58 | John Steele S000832 | rep | NC | 1791-10-24 | 1793-03-03 | 1 | ||||||||||||||
59 | 59 | Samuel Sterett S000866 | rep | MD | 1791-10-24 | 1793-03-03 | 4 | ||||||||||||||
61 | 61 | Jonathan Sturges S001047 | rep | CT | 1791-10-24 | 1793-03-03 | -1 |
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);