legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: type, end, class, party, district, how, fax, contact_form, office, state_rank, rss_url, start (date)
These facets timed out: end
phone 554 ✖
- 202-225-1313 7
- 202-225-1510 7
- 202-225-1956 7
- 202-225-2002 7
- 202-225-2011 7
- 202-225-2015 7
- 202-225-2211 7
- 202-225-2301 7
- 202-225-2472 7
- 202-225-2523 7
- 202-225-2536 7
- 202-225-2726 7
- 202-225-2815 7
- 202-225-2836 7
- 202-225-3115 7
- 202-225-3161 7
- 202-225-3211 7
- 202-225-3365 7
- 202-225-3415 7
- 202-225-3436 7
- 202-225-3465 7
- 202-225-3615 7
- 202-225-3731 7
- 202-225-3801 7
- 202-225-4001 7
- 202-225-4306 7
- 202-225-4404 7
- 202-225-4501 7
- 202-225-4576 7
- 202-225-4741 7
- 202-225-4806 7
- 202-225-4931 7
- 202-225-5126 7
- 202-225-5265 7
- 202-225-5355 7
- 202-225-5501 7
- 202-225-5614 7
- 202-225-5765 7
- 202-225-5961 7
- 202-225-6201 7
- 202-225-6205 7
- 202-225-6216 7
- 202-225-6235 7
- 202-225-6311 7
- 202-225-6316 7
- 202-225-6411 7
- 202-225-6501 7
- 202-225-6636 7
- 202-225-7032 7
- 202-225-7742 7
- 202-225-7751 7
- 202-225-8171 7
- 202-225-8490 7
- 202-225-0123 6
- 202-225-0453 6
- 202-225-0508 6
- 202-225-0773 6
- 202-225-0855 6
- 202-225-1002 6
- 202-225-1188 6
- 202-225-1252 6
- 202-225-1492 6
- 202-225-1605 6
- 202-225-1640 6
- 202-225-1688 6
- 202-225-1766 6
- 202-225-1784 6
- 202-225-1790 6
- 202-225-1880 6
- 202-225-1947 6
- 202-225-1976 6
- 202-225-1986 6
- 202-225-2006 6
- 202-225-2031 6
- 202-225-2040 6
- 202-225-2065 6
- 202-225-2071 6
- 202-225-2076 6
- 202-225-2095 6
- 202-225-2106 6
- 202-225-2111 6
- 202-225-2132 6
- 202-225-2135 6
- 202-225-2161 6
- 202-225-2165 6
- 202-225-2176 6
- 202-225-2190 6
- 202-225-2201 6
- 202-225-2216 6
- 202-225-2231 6
- 202-225-2265 6
- 202-225-2271 6
- 202-225-2276 6
- 202-225-2305 6
- 202-225-2311 6
- 202-225-2315 6
- 202-225-2331 6
- 202-225-2361 6
- 202-225-2365 6
- 202-225-2371 6
- 202-225-2401 6
- 202-225-2406 6
- 202-225-2411 6
- 202-225-2415 6
- 202-225-2431 6
- 202-225-2435 6
- 202-225-2452 6
- 202-225-2461 6
- 202-225-2464 6
- 202-225-2476 6
- 202-225-2501 6
- 202-225-2506 6
- 202-225-2511 6
- 202-225-2531 6
- 202-225-2542 6
- 202-225-2571 6
- 202-225-2576 6
- 202-225-2601 6
- 202-225-2605 6
- 202-225-2611 6
- 202-225-2631 6
- 202-225-2635 6
- 202-225-2645 6
- 202-225-2646 6
- 202-225-2661 6
- 202-225-2665 6
- 202-225-2676 6
- 202-225-2701 6
- 202-225-2706 6
- 202-225-2711 6
- 202-225-2715 6
- 202-225-2721 6
- 202-225-2731 6
- 202-225-2735 6
- 202-225-2777 6
- 202-225-2778 6
- 202-225-2801 6
- 202-225-2811 6
- 202-225-2823 6
- 202-225-2831 6
- 202-225-2861 6
- 202-225-2865 6
- 202-225-2871 6
- 202-225-2876 6
- 202-225-2901 6
- 202-225-2906 6
- 202-225-2911 6
- 202-225-2915 6
- 202-225-2931 6
- 202-225-2939 6
- 202-225-2956 6
- 202-225-2965 6
- 202-225-2976 6
- 202-225-3001 6
- 202-225-3011 6
- 202-225-3015 6
- 202-225-3021 6
- 202-225-3026 6
- 202-225-3031 6
- 202-225-3032 6
- 202-225-3035 6
- 202-225-3061 6
- 202-225-3065 6
- 202-225-3072 6
- 202-225-3076 6
- 202-225-3101 6
- 202-225-3106 6
- 202-225-3111 6
- 202-225-3164 6
- 202-225-3176 6
- 202-225-3201 6
- 202-225-3236 6
- 202-225-3252 6
- 202-225-3261 6
- 202-225-3265 6
- 202-225-3271 6
- 202-225-3306 6
- 202-225-3311 6
- 202-225-3315 6
- 202-225-3335 6
- 202-225-3341 6
- 202-225-3361 6
- 202-225-3371 6
- 202-225-3376 6
- 202-225-3411 6
- 202-225-3452 6
- 202-225-3461 6
- 202-225-3484 6
- 202-225-3501 6
- 202-225-3515 6
- 202-225-3531 6
- 202-225-3536 6
- 202-225-3561 6
- 202-225-3601 6
- 202-225-3605 6
- 202-225-3611 6
- 202-225-3631 6
- 202-225-3635 6
- 202-225-3661 6
- 202-225-3665 6
- 202-225-3671 6
- 202-225-3701 6
- 202-225-3706 6
- 202-225-3711 6
- 202-225-3715 6
- 202-225-3761 6
- 202-225-3765 6
- 202-225-3772 6
- 202-225-3816 6
- 202-225-3826 6
- 202-225-3831 6
- 202-225-3861 6
- 202-225-3864 6
- 202-225-3876 6
- 202-225-3901 6
- 202-225-3906 6
- 202-225-3915 6
- 202-225-3931 6
- 202-225-3965 6
- 202-225-3976 6
- 202-225-4005 6
- 202-225-4011 6
- 202-225-4016 6
- 202-225-4035 6
- 202-225-4061 6
- 202-225-4065 6
- 202-225-4071 6
- 202-225-4076 6
- 202-225-4101 6
- 202-225-4111 6
- 202-225-4115 6
- 202-225-4131 6
- 202-225-4136 6
- 202-225-4146 6
- 202-225-4155 6
- 202-225-4165 6
- 202-225-4172 6
- 202-225-4176 6
- 202-225-4201 6
- 202-225-4211 6
- 202-225-4215 6
- 202-225-4231 6
- 202-225-4236 6
- 202-225-4261 6
- 202-225-4272 6
- 202-225-4276 6
- 202-225-4301 6
- 202-225-4311 6
- 202-225-4315 6
- 202-225-4324 6
- 202-225-4361 6
- 202-225-4365 6
- 202-225-4372 6
- 202-225-4376 6
- 202-225-4401 6
- 202-225-4422 6
- 202-225-4426 6
- 202-225-4431 6
- 202-225-4436 6
- 202-225-4465 6
- 202-225-4476 6
- 202-225-4506 6
- 202-225-4511 6
- 202-225-4531 6
- 202-225-4535 6
- 202-225-4540 6
- 202-225-4561 6
- 202-225-4572 6
- 202-225-4601 6
- 202-225-4611 6
- 202-225-4636 6
- 202-225-4671 6
- 202-225-4676 6
- 202-225-4695 6
- 202-225-4706 6
- 202-225-4711 6
- 202-225-4714 6
- 202-225-4731 6
- 202-225-4735 6
- 202-225-4755 6
- 202-225-4761 6
- 202-225-4765 6
- 202-225-4801 6
- 202-225-4811 6
- 202-225-4831 6
- 202-225-4835 6
- 202-225-4865 6
- 202-225-4872 6
- 202-225-4876 6
- 202-225-4901 6
- 202-225-4906 6
- 202-225-4911 6
- 202-225-4921 6
- 202-225-4961 6
- 202-225-4965 6
- 202-225-5006 6
- 202-225-5015 6
- 202-225-5031 6
- 202-225-5034 6
- 202-225-5037 6
- 202-225-5065 6
- 202-225-5071 6
- 202-225-5076 6
- 202-225-5101 6
- 202-225-5111 6
- 202-225-5121 6
- 202-225-5136 6
- 202-225-5161 6
- 202-225-5206 6
- 202-225-5211 6
- 202-225-5235 6
- 202-225-5256 6
- 202-225-5261 6
- 202-225-5271 6
- 202-225-5301 6
- 202-225-5311 6
- 202-225-5315 6
- 202-225-5330 6
- 202-225-5341 6
- 202-225-5361 6
- 202-225-5401 6
- 202-225-5406 6
- 202-225-5431 6
- 202-225-5435 6
- 202-225-5441 6
- 202-225-5456 6
- 202-225-5464 6
- 202-225-5476 6
- 202-225-5506 6
- 202-225-5516 6
- 202-225-5531 6
- 202-225-5541 6
- 202-225-5546 6
- 202-225-5565 6
- 202-225-5601 6
- 202-225-5611 6
- 202-225-5635 6
- 202-225-5661 6
- 202-225-5665 6
- 202-225-5672 6
- 202-225-5701 6
- 202-225-5705 6
- 202-225-5711 6
- 202-225-5716 6
- 202-225-5731 6
- 202-225-5744 6
- 202-225-5751 6
- 202-225-5755 6
- 202-225-5772 6
- 202-225-5792 6
- 202-225-5801 6
- 202-225-5802 6
- 202-225-5811 6
- 202-225-5816 6
- 202-225-5831 6
- 202-225-5836 6
- 202-225-5861 6
- 202-225-5876 6
- 202-225-5901 6
- 202-225-5905 6
- 202-225-5911 6
- 202-225-5916 6
- 202-225-5931 6
- 202-225-5936 6
- 202-225-5951 6
- 202-225-5965 6
- 202-225-6030 6
- 202-225-6101 6
- 202-225-6105 6
- 202-225-6111 6
- 202-225-6116 6
- 202-225-6131 6
- 202-225-6155 6
- 202-225-6161 6
- 202-225-6165 6
- 202-225-6190 6
- 202-225-6211 6
- 202-225-6231 6
- 202-225-6265 6
- 202-225-6276 6
- 202-225-6306 6
- 202-225-6356 6
- 202-225-6365 6
- 202-225-6401 6
- 202-225-6405 6
- 202-225-6416 6
- 202-225-6435 6
- 202-225-6465 6
- 202-225-6506 6
- 202-225-6511 6
- 202-225-6531 6
- 202-225-6536 6
- 202-225-6565 6
- 202-225-6572 6
- 202-225-6576 6
- 202-225-6601 6
- 202-225-6605 6
- 202-225-6611 6
- 202-225-6631 6
- 202-225-6673 6
- 202-225-6676 6
- 202-225-6730 6
- 202-225-6831 6
- 202-225-7041 6
- 202-225-7084 6
- 202-225-7163 6
- 202-225-7508 6
- 202-225-7761 6
- 202-225-7772 6
- 202-225-7882 6
- 202-225-7896 6
- 202-225-7919 6
- 202-225-7924 6
- 202-225-7931 6
- 202-225-7944 6
- 202-225-8020 6
- 202-225-8045 6
- 202-225-8050 6
- 202-225-8104 6
- 202-225-8203 6
- 202-225-8220 6
- 202-225-8273 6
- 202-225-8351 6
- 202-225-8577 6
- 202-225-8699 6
- 202-225-8885 6
- 202-225-8901 6
- 202-225-9901 6
- 202-224-2235 5
- 202-224-2742 5
- 202-224-3224 5
- 202-224-4124 5
- 202-224-5054 5
- 202-224-5641 5
- 202-225-1555 5
- 202-225-1621 5
- 202-225-9730 5
- 202-225-9740 5
- 202-225-9888 5
- 202-225-9889 5
- 202-225-9890 5
- 202-225-9893 5
- 202-225-9894 5
- 202-225-9895 5
- 202-225-9896 5
- 202-225-9897 5
- 202-224-2651 4
- 202-224-3553 4
- 202-224-3643 4
- 202-224-3934 4
- 202-224-6121 4
- 202-225-2615 4
- 202-224-2023 3
- 202-224-2043 3
- 202-224-2152 3
- 202-224-2315 3
- 202-224-2353 3
- 202-224-2441 3
- 202-224-2523 3
- 202-224-2541 3
- 202-224-2644 3
- 202-224-2752 3
- 202-224-2841 3
- 202-224-2921 3
- 202-224-2934 3
- 202-224-3004 3
- 202-224-3244 3
- 202-224-3254 3
- 202-224-3344 3
- 202-224-3424 3
- 202-224-3441 3
- 202-224-3521 3
- 202-224-3753 3
- 202-224-3841 3
- 202-224-3954 3
- 202-224-4024 3
- 202-224-4041 3
- 202-224-4224 3
- 202-224-4451 3
- 202-224-4521 3
- 202-224-4524 3
- 202-224-4543 3
- 202-224-4642 3
- 202-224-4721 3
- 202-224-4744 3
- 202-224-4774 3
- 202-224-4814 3
- 202-224-4822 3
- 202-224-4944 3
- 202-224-5042 3
- 202-224-5141 3
- 202-224-5251 3
- 202-224-5274 3
- 202-224-5344 3
- 202-224-5521 3
- 202-224-5653 3
- 202-224-5754 3
- 202-224-5824 3
- 202-224-5842 3
- 202-224-5922 3
- 202-224-5941 3
- 202-224-5972 3
- 202-224-6154 3
- 202-224-6221 3
- 202-224-6244 3
- 202-224-6253 3
- 202-224-6324 3
- 202-224-6342 3
- 202-224-6361 3
- 202-224-6441 3
- 202-224-6472 3
- 202-224-6551 3
- 202-224-6621 3
- 202-224-2321 2
- 202-224-2551 2
- 202-224-2621 2
- 202-224-2823 2
- 202-224-2854 2
- 202-224-3041 2
- 202-224-3154 2
- 202-224-3324 2
- 202-224-3353 2
- 202-224-3542 2
- 202-224-3744 2
- 202-224-4242 2
- 202-224-4254 2
- 202-224-4343 2
- 202-224-4623 2
- 202-224-4654 2
- 202-224-4843 2
- 202-224-5244 2
- 202-224-5323 2
- 202-224-5444 2
- 202-224-5623 2
- 202-224-5721 2
- 202-224-5744 2
- 202-224-5852 2
- 202-224-6142 2
- 202-224-6521 2
- 202-224-6542 2
- 202-224-6665 2
- 202-225-2261 1
- 202-225-2561 1
- 202-225-2565 1
- 202-225-2671 1
- 202-225-3401 1
- 202-225-3806 1
- 202-225-4031 1
- 202-225-5061 1
- 202-225-5335 1
- 202-225-5676 1
- 202-225-5871 1
- 202-225-6335 1
- 202-225-6616 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14945 | 14945 | Frank Waskey W000184 | rep | AK | 1905-12-04 | 1907-03-03 | Democrat | 0 | |||||||||||||
15021 | 15021 | Thomas Cale C000042 | rep | AK | 1907-12-02 | 1909-03-03 | Independent | 0 | |||||||||||||
17742 | 17742 | George Grigsby G000474 | rep | AK | 1919-05-19 | 1921-03-03 | 0 | ||||||||||||||
17970 | 17970 | Charles Sulzer S001064 | rep | AK | 1917-04-02 | 1919-03-03 | 0 | ||||||||||||||
17971 | 17971 | Charles Sulzer S001064 | rep | AK | 1919-05-19 | 1921-03-03 | 0 | ||||||||||||||
20002 | 20002 | Daniel Sutherland S001079 | rep | AK | 1921-04-11 | 1923-03-03 | Republican | 0 | |||||||||||||
20003 | 20003 | Daniel Sutherland S001079 | rep | AK | 1923-12-03 | 1925-03-03 | Republican | 0 | |||||||||||||
20004 | 20004 | Daniel Sutherland S001079 | rep | AK | 1925-12-07 | 1927-03-04 | Republican | 0 | |||||||||||||
20005 | 20005 | Daniel Sutherland S001079 | rep | AK | 1927-12-05 | 1929-03-03 | Republican | 0 | |||||||||||||
20006 | 20006 | Daniel Sutherland S001079 | rep | AK | 1929-04-15 | 1931-03-03 | Republican | 0 | |||||||||||||
21001 | 21001 | James Wickersham W000438 | rep | AK | 1909-03-15 | 1911-03-03 | Republican | 0 | |||||||||||||
21002 | 21002 | James Wickersham W000438 | rep | AK | 1911-04-04 | 1913-03-03 | Republican | 0 | |||||||||||||
21003 | 21003 | James Wickersham W000438 | rep | AK | 1913-04-07 | 1915-03-03 | Republican | 0 | |||||||||||||
21004 | 21004 | James Wickersham W000438 | rep | AK | 1915-12-06 | 1917-03-03 | Republican | 0 | |||||||||||||
21005 | 21005 | James Wickersham W000438 | rep | AK | 1917-04-02 | 1919-03-03 | Republican | 0 | |||||||||||||
21006 | 21006 | James Wickersham W000438 | rep | AK | 1919-05-19 | 1921-03-03 | Republican | 0 | |||||||||||||
21007 | 21007 | James Wickersham W000438 | rep | AK | 1931-12-07 | 1933-03-03 | Republican | 0 | |||||||||||||
23412 | 23412 | Anthony Dimond D000353 | rep | AK | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
23413 | 23413 | Anthony Dimond D000353 | rep | AK | 1935-01-03 | 1937-01-03 | Democrat | 0 | |||||||||||||
23414 | 23414 | Anthony Dimond D000353 | rep | AK | 1937-01-05 | 1939-01-03 | Democrat | 0 | |||||||||||||
23415 | 23415 | Anthony Dimond D000353 | rep | AK | 1939-01-03 | 1941-01-03 | Democrat | 0 | |||||||||||||
23416 | 23416 | Anthony Dimond D000353 | rep | AK | 1941-01-03 | 1943-01-03 | Democrat | 0 | |||||||||||||
23417 | 23417 | Anthony Dimond D000353 | rep | AK | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
27839 | 27839 | Ernest Gruening G000508 | sen | AK | 1959-01-07 | 1963-01-03 | 3 | Democrat | |||||||||||||
27840 | 27840 | Ernest Gruening G000508 | sen | AK | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
28617 | 28617 | Ralph Rivers R000282 | rep | AK | 1959-01-07 | 1961-01-03 | Democrat | 0 | |||||||||||||
28618 | 28618 | Ralph Rivers R000282 | rep | AK | 1961-01-03 | 1963-01-03 | Democrat | 0 | |||||||||||||
28619 | 28619 | Ralph Rivers R000282 | rep | AK | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
28620 | 28620 | Ralph Rivers R000282 | rep | AK | 1965-01-04 | 1967-01-03 | Democrat | 0 | |||||||||||||
28772 | 28772 | Edward Bartlett B000201 | rep | AK | 1945-01-03 | 1947-01-03 | Democrat | 0 | |||||||||||||
28773 | 28773 | Edward Bartlett B000201 | rep | AK | 1947-01-03 | 1949-01-03 | Democrat | 0 | |||||||||||||
28774 | 28774 | Edward Bartlett B000201 | rep | AK | 1949-01-03 | 1951-01-03 | Democrat | 0 | |||||||||||||
28775 | 28775 | Edward Bartlett B000201 | rep | AK | 1951-01-03 | 1953-01-03 | Democrat | 0 | |||||||||||||
28776 | 28776 | Edward Bartlett B000201 | rep | AK | 1953-01-03 | 1955-01-03 | Democrat | 0 | |||||||||||||
28777 | 28777 | Edward Bartlett B000201 | rep | AK | 1955-01-05 | 1957-01-03 | Democrat | 0 | |||||||||||||
28778 | 28778 | Edward Bartlett B000201 | rep | AK | 1957-01-03 | 1959-01-03 | Democrat | 0 | |||||||||||||
28779 | 28779 | Edward Bartlett B000201 | sen | AK | 1959-01-07 | 1961-01-03 | 2 | Democrat | |||||||||||||
28780 | 28780 | Edward Bartlett B000201 | sen | AK | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
28781 | 28781 | Edward Bartlett B000201 | sen | AK | 1967-01-10 | 1968-12-11 | 2 | Democrat | |||||||||||||
29420 | 29420 | Howard Pollock P000415 | rep | AK | 1967-01-10 | 1969-01-03 | Republican | 0 | |||||||||||||
29421 | 29421 | Howard Pollock P000415 | rep | AK | 1969-01-03 | 1971-01-03 | Republican | 0 | |||||||||||||
29583 | 29583 | Nicholas Begich B000315 | rep | AK | 1971-01-21 | 1973-01-03 | Democrat | 0 | |||||||||||||
30943 | 30943 | Maurice Gravel G000388 | sen | AK | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
30944 | 30944 | Maurice Gravel G000388 | sen | AK | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
36716 | 36716 | Frank Murkowski M001085 | sen | AK | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
36717 | 36717 | Frank Murkowski M001085 | sen | AK | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
36718 | 36718 | Frank Murkowski M001085 | sen | AK | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
36719 | 36719 | Frank Murkowski M001085 | sen | AK | 1999-01-06 | 2002-12-19 | 3 | Republican | |||||||||||||
37480 | 37480 | Ted Stevens S000888 | sen | AK | 1968-12-24 | 1973-01-03 | 2 | Republican | appointment | ||||||||||||
37481 | 37481 | Ted Stevens S000888 | sen | AK | 1973-01-03 | 1979-01-03 | 2 | Republican | |||||||||||||
37482 | 37482 | Ted Stevens S000888 | sen | AK | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
37483 | 37483 | Ted Stevens S000888 | sen | AK | 1985-01-03 | 1991-01-03 | 2 | Republican | |||||||||||||
37484 | 37484 | Ted Stevens S000888 | sen | AK | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
37485 | 37485 | Ted Stevens S000888 | sen | AK | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
37486 | 37486 | Ted Stevens S000888 | sen | AK | 2003-01-07 | 2009-01-03 | 2 | Republican | http://stevens.senate.gov/ | ||||||||||||
39686 | 39686 | Mark Begich B001265 | sen | AK | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.begich.senate.gov | 111 Russell Senate Office Building Washington DC 20510 | 202-224-3004 | 202-224-2354 | http://www.begich.senate.gov/public/index.cfm?p=EmailSenator | 111 Russell Senate Office Building | junior | http://www.begich.senate.gov/public/?a=rss.feed | |||||
41664 | 41664 | Don Young Y000033 | rep | AK | 1973-03-06 | 1975-01-03 | Republican | 0 | |||||||||||||
41665 | 41665 | Don Young Y000033 | rep | AK | 1975-01-14 | 1977-01-03 | Republican | 0 | |||||||||||||
41666 | 41666 | Don Young Y000033 | rep | AK | 1977-01-04 | 1979-01-03 | Republican | 0 | |||||||||||||
41667 | 41667 | Don Young Y000033 | rep | AK | 1979-01-15 | 1981-01-03 | Republican | 0 | |||||||||||||
41668 | 41668 | Don Young Y000033 | rep | AK | 1981-01-05 | 1983-01-03 | Republican | 0 | |||||||||||||
41669 | 41669 | Don Young Y000033 | rep | AK | 1983-01-03 | 1985-01-03 | Republican | 0 | |||||||||||||
41670 | 41670 | Don Young Y000033 | rep | AK | 1985-01-03 | 1987-01-03 | Republican | 0 | |||||||||||||
41671 | 41671 | Don Young Y000033 | rep | AK | 1987-01-06 | 1989-01-03 | Republican | 0 | |||||||||||||
41672 | 41672 | Don Young Y000033 | rep | AK | 1989-01-03 | 1991-01-03 | Republican | 0 | |||||||||||||
41673 | 41673 | Don Young Y000033 | rep | AK | 1991-01-03 | 1993-01-03 | Republican | 0 | |||||||||||||
41674 | 41674 | Don Young Y000033 | rep | AK | 1993-01-05 | 1995-01-03 | Republican | 0 | |||||||||||||
41675 | 41675 | Don Young Y000033 | rep | AK | 1995-01-04 | 1997-01-03 | Republican | 0 | |||||||||||||
41676 | 41676 | Don Young Y000033 | rep | AK | 1997-01-07 | 1999-01-03 | Republican | 0 | |||||||||||||
41677 | 41677 | Don Young Y000033 | rep | AK | 1999-01-06 | 2001-01-03 | Republican | 0 | |||||||||||||
41678 | 41678 | Don Young Y000033 | rep | AK | 2001-01-03 | 2003-01-03 | Republican | 0 | |||||||||||||
41679 | 41679 | Don Young Y000033 | rep | AK | 2003-01-07 | 2005-01-03 | Republican | 0 | http://www.house.gov/donyoung | ||||||||||||
41680 | 41680 | Don Young Y000033 | rep | AK | 2005-01-04 | 2007-01-03 | Republican | 0 | http://www.house.gov/donyoung | ||||||||||||
41681 | 41681 | Don Young Y000033 | rep | AK | 2007-01-04 | 2009-01-03 | Republican | 0 | http://donyoung.house.gov | ||||||||||||
41682 | 41682 | Don Young Y000033 | rep | AK | 2009-01-06 | 2011-01-03 | Republican | 0 | http://donyoung.house.gov | ||||||||||||
41683 | 41683 | Don Young Y000033 | rep | AK | 2011-01-05 | 2013-01-03 | Republican | 0 | http://donyoung.house.gov | 2314 Rayburn HOB; Washington DC 20515-0201 | 202-225-5765 | 202-225-0425 | http://donyoung.house.gov/Contact/ | 2314 Rayburn House Office Building | |||||||
41684 | 41684 | Don Young Y000033 | rep | AK | 2013-01-03 | 2015-01-03 | Republican | 0 | http://donyoung.house.gov | 2314 Rayburn HOB; Washington DC 20515-0200 | 202-225-5765 | 202-225-0425 | https://donyoung.house.gov/forms/writeyourrep/ | 2314 Rayburn House Office Building | http://donyoung.house.gov/news/rss.aspx | ||||||
41685 | 41685 | Don Young Y000033 | rep | AK | 2015-01-06 | 2017-01-03 | Republican | 0 | http://donyoung.house.gov | 2314 Rayburn HOB; Washington DC 20515-0200 | 202-225-5765 | 202-225-0425 | https://donyoung.house.gov/forms/writeyourrep/ | 2314 Rayburn House Office Building | http://donyoung.house.gov/news/rss.aspx | ||||||
41686 | 41686 | Don Young Y000033 | rep | AK | 2017-01-03 | 2019-01-03 | Republican | 0 | https://donyoung.house.gov | 2314 Rayburn House Office Building; Washington DC 20515-0200 | 202-225-5765 | 202-225-0425 | 2314 Rayburn House Office Building | http://donyoung.house.gov/news/rss.aspx | |||||||
41687 | 41687 | Don Young Y000033 | rep | AK | 2019-01-03 | 2021-01-03 | Republican | 0 | https://donyoung.house.gov | 2314 Rayburn House Office Building Washington DC 20515-0200 | 202-225-5765 | 2314 Rayburn House Office Building | http://donyoung.house.gov/news/rss.aspx | ||||||||
41688 | 41688 | Don Young Y000033 | rep | AK | 2021-01-03 | 2022-03-18 | Republican | 0 | https://donyoung.house.gov | 2314 Rayburn House Office Building Washington DC 20515-0200 | 202-225-5765 | 2314 Rayburn House Office Building | http://donyoung.house.gov/news/rss.aspx | ||||||||
42958 | 42958 | Lisa Murkowski M001153 | sen | AK | 2003-01-07 | 2005-01-03 | 3 | Republican | appointment | http://murkowski.senate.gov/ | |||||||||||
42959 | 42959 | Lisa Murkowski M001153 | sen | AK | 2005-01-04 | 2011-01-03 | 3 | Republican | http://murkowski.senate.gov/ | ||||||||||||
42960 | 42960 | Lisa Murkowski M001153 | sen | AK | 2011-01-05 | 2017-01-03 | 3 | Republican | https://www.murkowski.senate.gov | 709 Hart Senate Office Building Washington DC 20510 | 202-224-6665 | 202-224-5301 | http://www.murkowski.senate.gov/public/index.cfm?p=EMailLisa | 709 Hart Senate Office Building | senior | http://www.murkowski.senate.gov/public/?a=rss.feed | |||||
42961 | 42961 | Lisa Murkowski M001153 | sen | AK | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.murkowski.senate.gov | 522 Hart Senate Office Building Washington DC 20510 | 202-224-6665 | 202-224-5301 | https://www.murkowski.senate.gov/public/index.cfm/contact | 522 Hart Senate Office Building | senior | http://www.murkowski.senate.gov/public/?a=rss.feed | |||||
44072 | 44072 | Dan Sullivan S001198 | sen | AK | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.sullivan.senate.gov | 302 Hart Senate Office Building Washington DC 20510 | 202-224-3004 | https://www.sullivan.senate.gov/contact/email | 302 Hart Senate Office Building | junior | |||||||
44073 | 44073 | Dan Sullivan S001198 | sen | AK | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.sullivan.senate.gov | 302 Hart Senate Office Building Washington DC 20510 | 202-224-3004 | https://www.sullivan.senate.gov/contact/email | 302 Hart Senate Office Building | junior | |||||||
44548 | 44548 | Mary Peltola P000619 | rep | AK | 2022-09-13 | 2023-01-03 | Democrat | 0 | https://peltola.house.gov | 2314 Rayburn House Office Building Washington DC 20515-0200 | 202-225-5765 | 2314 Rayburn House Office Building | |||||||||
2004 | 2004 | John Crowell C000942 | rep | AL | 1817-12-01 | 1819-03-03 | -1 | ||||||||||||||
2005 | 2005 | John Crowell C000942 | rep | AL | 1819-12-06 | 1821-03-03 | Republican | 1 | |||||||||||||
2167 | 2167 | John Walker W000061 | sen | AL | 1819-12-06 | 1823-03-03 | 3 | Republican | |||||||||||||
2360 | 2360 | William Kelly K000079 | sen | AL | 1822-01-01 | 1825-03-03 | 3 | Republican | |||||||||||||
2575 | 2575 | Henry Chambers C000284 | sen | AL | 1825-12-05 | 1827-03-03 | 3 | Jackson | |||||||||||||
2754 | 2754 | Israel Pickens P000322 | sen | AL | 1826-01-01 | 1827-03-03 | 3 | Jackson | |||||||||||||
2891 | 2891 | John McKee M000495 | rep | AL | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2892 | 2892 | John McKee M000495 | rep | AL | 1825-12-05 | 1827-03-03 | Jackson | 2 | |||||||||||||
2893 | 2893 | John McKee M000495 | rep | AL | 1827-12-03 | 1829-03-03 | Jackson | 2 | |||||||||||||
2925 | 2925 | George Owen O000150 | rep | AL | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
2926 | 2926 | George Owen O000150 | rep | AL | 1825-12-05 | 1827-03-03 | Jackson | 3 | |||||||||||||
2927 | 2927 | George Owen O000150 | rep | AL | 1827-12-03 | 1829-03-03 | Jackson | 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);