legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: class, district, how, fax, contact_form, office, state_rank, rss_url, end (date)
These facets timed out: start
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44551 | 44551 | Rudy Yakym Y000067 | rep | IN | 2022-11-14 | 2023-01-03 | Republican | 2 | special-election | ||||||||||||
44550 | 44550 | Joseph Sempolinski S001219 | rep | NY | 2022-09-13 | 2023-01-03 | Republican | 23 | 1203 Longworth House Office Building Washington DC 20515-3223 | 202-225-3161 | 1203 Longworth House Office Building | ||||||||||
44549 | 44549 | Patrick Ryan R000579 | rep | NY | 2022-09-13 | 2023-01-03 | Democrat | 19 | 1007 Longworth House Office Building Washington DC 20515-3219 | 202-225-5614 | 1007 Longworth House Office Building | ||||||||||
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 | |||||||||
44547 | 44547 | Brad Finstad F000475 | rep | MN | 2022-08-12 | 2023-01-03 | Republican | 1 | 1433 Longworth House Office Building Washington DC 20515-2301 | 202-225-2472 | 1433 Longworth House Office Building | ||||||||||
44546 | 44546 | Mike Flood F000474 | rep | NE | 2022-07-12 | 2023-01-03 | Republican | 1 | 1514 Longworth House Office Building Washington DC 20515-2701 | 202-225-4806 | 1514 Longworth House Office Building | ||||||||||
44545 | 44545 | Mayra Flores F000473 | rep | TX | 2022-06-21 | 2023-01-03 | Republican | 34 | 307 Cannon House Office Building Washington DC 20515-4334 | 202-225-9901 | 307 Cannon House Office Building | ||||||||||
44544 | 44544 | Connie Conway C001128 | rep | CA | 2022-06-07 | 2023-01-03 | Republican | 22 | 1013 Longworth House Office Building Washington DC 20515-0522 | 202-225-2523 | 1013 Longworth House Office Building | ||||||||||
44543 | 44543 | Sheila Cherfilus-McCormick C001127 | rep | FL | 2022-01-18 | 2023-01-03 | Democrat | 20 | https://cherfilus-mccormick.house.gov | 2365 Rayburn House Office Building Washington DC 20515-0920 | 202-225-1313 | 2365 Rayburn House Office Building | |||||||||
44542 | 44542 | Mike Carey C001126 | rep | OH | 2021-11-04 | 2023-01-03 | Republican | 15 | https://carey.house.gov | 2234 Rayburn House Office Building Washington DC 20515-3515 | 202-225-2015 | 2234 Rayburn House Office Building | |||||||||
44541 | 44541 | Shontel Brown B001313 | rep | OH | 2021-11-04 | 2023-01-03 | Democrat | 11 | https://shontelbrown.house.gov | 2344 Rayburn House Office Building Washington DC 20515-3511 | 202-225-7032 | 2344 Rayburn House Office Building | |||||||||
44540 | 44540 | Jake Ellzey E000071 | rep | TX | 2021-07-30 | 2023-01-03 | Republican | 6 | https://ellzey.house.gov | 1725 Longworth House Office Building Washington DC 20515-4306 | 202-225-2002 | 1725 Longworth House Office Building | |||||||||
44539 | 44539 | Melanie Stansbury S001218 | rep | NM | 2021-06-14 | 2023-01-03 | Democrat | 1 | https://stansbury.house.gov | 1421 Longworth House Office Building Washington DC 20515-3101 | 202-225-6316 | 1421 Longworth House Office Building | |||||||||
44538 | 44538 | Troy Carter C001125 | rep | LA | 2021-05-11 | 2023-01-03 | Democrat | 2 | https://troycarter.house.gov | 506 Cannon House Office Building Washington DC 20515-1802 | 202-225-6636 | 506 Cannon House Office Building | |||||||||
44537 | 44537 | Julia Letlow L000595 | rep | LA | 2021-04-14 | 2023-01-03 | Republican | 5 | https://letlow.house.gov | 1408 Longworth House Office Building Washington DC 20515-1805 | 202-225-8490 | 1408 Longworth House Office Building | |||||||||
44536 | 44536 | Claudia Tenney T000478 | rep | NY | 2021-02-11 | 2023-01-03 | Republican | 22 | https://tenney.house.gov | 1410 Longworth House Office Building Washington DC 20515-3222 | 202-225-3665 | 1410 Longworth House Office Building | |||||||||
44535 | 44535 | Claudia Tenney T000478 | rep | NY | 2017-01-03 | 2019-01-03 | Republican | 22 | https://tenney.house.gov | 512 Cannon House Office Building; Washington DC 20515-3222 | 202-225-3665 | 512 Cannon House Office Building | |||||||||
44534 | 44534 | Raphael Warnock W000790 | sen | GA | 2021-01-20 | 2023-01-03 | 3 | Democrat | special-election | https://www.warnock.senate.gov | 388 Russell Senate Office Building Washington DC 20510 | 202-224-3643 | https://www.warnock.senate.gov/contact/ | 388 Russell Senate Office Building | junior | ||||||
44533 | 44533 | Jon Ossoff O000174 | sen | GA | 2021-01-20 | 2027-01-03 | 2 | Democrat | https://www.ossoff.senate.gov | 455 Russell Senate Office Building Washington DC 20510 | 202-224-3521 | https://www.ossoff.senate.gov/contact-us/ | 455 Russell Senate Office Building | senior | |||||||
44532 | 44532 | Alejandro Padilla P000145 | sen | CA | 2022-11-09 | 2023-01-03 | 3 | Democrat | special-election | https://www.padilla.senate.gov | 112 Hart Senate Office Building Washington DC 20510 | 202-224-3553 | https://www.padilla.senate.gov/contact/ | 112 Hart Senate Office Building | junior | ||||||
44531 | 44531 | Alejandro Padilla P000145 | sen | CA | 2021-01-20 | 2022-11-08 | 3 | Democrat | appointment | https://www.padilla.senate.gov | 112 Hart Senate Office Building Washington DC 20510 | 202-224-3553 | https://www.padilla.senate.gov/contact/ | 112 Hart Senate Office Building | junior | ||||||
44530 | 44530 | Scott Fitzgerald F000471 | rep | WI | 2021-01-03 | 2023-01-03 | Republican | 5 | https://fitzgerald.house.gov | 1507 Longworth House Office Building Washington DC 20515-4905 | 202-225-5101 | 1507 Longworth House Office Building | |||||||||
44529 | 44529 | Marilyn Strickland S001159 | rep | WA | 2021-01-03 | 2023-01-03 | Democrat | 10 | https://strickland.house.gov | 1004 Longworth House Office Building Washington DC 20515-4710 | 202-225-9740 | 1004 Longworth House Office Building | |||||||||
44528 | 44528 | Robert Good G000595 | rep | VA | 2021-01-03 | 2023-01-03 | Republican | 5 | https://good.house.gov | 1213 Longworth House Office Building Washington DC 20515-4605 | 202-225-4711 | 1213 Longworth House Office Building | |||||||||
44527 | 44527 | Clarence Owens O000086 | rep | UT | 2021-01-03 | 2023-01-03 | Republican | 4 | https://owens.house.gov | 1039 Longworth House Office Building Washington DC 20515-4404 | 202-225-3011 | 1039 Longworth House Office Building | |||||||||
44526 | 44526 | Blake Moore M001213 | rep | UT | 2021-01-03 | 2023-01-03 | Republican | 1 | https://blakemoore.house.gov | 1320 Longworth House Office Building Washington DC 20515-4401 | 202-225-0453 | 1320 Longworth House Office Building | |||||||||
44525 | 44525 | Beth Van Duyne V000134 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 24 | https://vanduyne.house.gov | 1337 Longworth House Office Building Washington DC 20515-4324 | 202-225-6605 | 1337 Longworth House Office Building | |||||||||
44524 | 44524 | Ernest Gonzales G000594 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 23 | https://gonzales.house.gov | 1009 Longworth House Office Building Washington DC 20515-4323 | 202-225-4511 | 1009 Longworth House Office Building | |||||||||
44523 | 44523 | Troy Nehls N000026 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 22 | https://nehls.house.gov | 1104 Longworth House Office Building Washington DC 20515-4322 | 202-225-5951 | 1104 Longworth House Office Building | |||||||||
44522 | 44522 | Ronny Jackson J000304 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 13 | https://jackson.house.gov | 118 Cannon House Office Building Washington DC 20515-4313 | 202-225-3706 | 118 Cannon House Office Building | |||||||||
44521 | 44521 | August Pfluger P000048 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 11 | https://pfluger.house.gov | 1531 Longworth House Office Building Washington DC 20515-4311 | 202-225-3605 | 1531 Longworth House Office Building | |||||||||
44520 | 44520 | Patrick Fallon F000246 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 4 | https://fallon.house.gov | 1118 Longworth House Office Building Washington DC 20515-4304 | 202-225-6673 | 1118 Longworth House Office Building | |||||||||
44519 | 44519 | Diana Harshbarger H001086 | rep | TN | 2021-01-03 | 2023-01-03 | Republican | 1 | https://harshbarger.house.gov | 167 Cannon House Office Building Washington DC 20515-4201 | 202-225-6356 | 167 Cannon House Office Building | |||||||||
44518 | 44518 | Nancy Mace M000194 | rep | SC | 2021-01-03 | 2023-01-03 | Republican | 1 | https://mace.house.gov | 212 Cannon House Office Building Washington DC 20515-4001 | 202-225-3176 | 212 Cannon House Office Building | |||||||||
44517 | 44517 | Cliff Bentz B000668 | rep | OR | 2021-01-03 | 2023-01-03 | Republican | 2 | https://bentz.house.gov | 1239 Longworth House Office Building Washington DC 20515-3702 | 202-225-6730 | 1239 Longworth House Office Building | |||||||||
44516 | 44516 | Stephanie Bice B000740 | rep | OK | 2021-01-03 | 2023-01-03 | Republican | 5 | https://bice.house.gov | 1223 Longworth House Office Building Washington DC 20515-3605 | 202-225-2132 | 1223 Longworth House Office Building | |||||||||
44515 | 44515 | Mondaire Jones J000306 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 17 | https://jones.house.gov | 1017 Longworth House Office Building Washington DC 20515-3217 | 202-225-6506 | 1017 Longworth House Office Building | |||||||||
44514 | 44514 | Jamaal Bowman B001223 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 16 | https://bowman.house.gov | 1605 Longworth House Office Building Washington DC 20515-3216 | 202-225-2464 | 1605 Longworth House Office Building | |||||||||
44513 | 44513 | Ritchie Torres T000486 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 15 | https://ritchietorres.house.gov | 317 Cannon House Office Building Washington DC 20515-3215 | 202-225-4361 | 317 Cannon House Office Building | |||||||||
44512 | 44512 | Nicole Malliotakis M000317 | rep | NY | 2021-01-03 | 2023-01-03 | Republican | 11 | https://malliotakis.house.gov | 417 Cannon House Office Building Washington DC 20515-3211 | 202-225-3371 | 417 Cannon House Office Building | |||||||||
44511 | 44511 | Andrew Garbarino G000597 | rep | NY | 2021-01-03 | 2023-01-03 | Republican | 2 | https://garbarino.house.gov | 1516 Longworth House Office Building Washington DC 20515-3202 | 202-225-7896 | 1516 Longworth House Office Building | |||||||||
44510 | 44510 | Teresa Leger Fernandez L000273 | rep | NM | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://fernandez.house.gov | 1432 Longworth House Office Building Washington DC 20515-3103 | 202-225-6190 | 1432 Longworth House Office Building | |||||||||
44509 | 44509 | Yvette Herrell H001084 | rep | NM | 2021-01-03 | 2023-01-03 | Republican | 2 | https://herrell.house.gov | 1305 Longworth House Office Building Washington DC 20515-3102 | 202-225-2365 | 1305 Longworth House Office Building | |||||||||
44508 | 44508 | Madison Cawthorn C001104 | rep | NC | 2021-01-03 | 2023-01-03 | Republican | 11 | https://cawthorn.house.gov | 102 Cannon House Office Building Washington DC 20515-3311 | 202-225-6401 | 102 Cannon House Office Building | |||||||||
44507 | 44507 | Kathy Manning M001135 | rep | NC | 2021-01-03 | 2023-01-03 | Democrat | 6 | https://manning.house.gov | 415 Cannon House Office Building Washington DC 20515-3306 | 202-225-3065 | 415 Cannon House Office Building | |||||||||
44506 | 44506 | Deborah Ross R000305 | rep | NC | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://ross.house.gov | 1208 Longworth House Office Building Washington DC 20515-3302 | 202-225-3032 | 1208 Longworth House Office Building | |||||||||
44505 | 44505 | Matthew Rosendale R000103 | rep | MT | 2021-01-03 | 2023-01-03 | Republican | 0 | https://rosendale.house.gov | 1037 Longworth House Office Building Washington DC 20515-2600 | 202-225-3211 | 1037 Longworth House Office Building | |||||||||
44504 | 44504 | Cori Bush B001224 | rep | MO | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://bush.house.gov | 563 Cannon House Office Building Washington DC 20515-2501 | 202-225-2406 | 563 Cannon House Office Building | |||||||||
44503 | 44503 | Michelle Fischbach F000470 | rep | MN | 2021-01-03 | 2023-01-03 | Republican | 7 | https://fischbach.house.gov | 1237 Longworth House Office Building Washington DC 20515-2307 | 202-225-2165 | 1237 Longworth House Office Building | |||||||||
44502 | 44502 | Lisa McClain M001136 | rep | MI | 2021-01-03 | 2023-01-03 | Republican | 10 | https://mcclain.house.gov | 218 Cannon House Office Building Washington DC 20515-2210 | 202-225-2106 | 218 Cannon House Office Building | |||||||||
44501 | 44501 | Peter Meijer M001186 | rep | MI | 2021-01-03 | 2023-01-03 | Republican | 3 | https://meijer.house.gov | 1508 Longworth House Office Building Washington DC 20515-2203 | 202-225-3831 | 1508 Longworth House Office Building | |||||||||
44500 | 44500 | Jake Auchincloss A000148 | rep | MA | 2021-01-03 | 2023-01-03 | Democrat | 4 | https://auchincloss.house.gov | 1524 Longworth House Office Building Washington DC 20515-2104 | 202-225-5931 | 1524 Longworth House Office Building | |||||||||
44499 | 44499 | Jacob LaTurner L000266 | rep | KS | 2021-01-03 | 2023-01-03 | Republican | 2 | https://laturner.house.gov | 1630 Longworth House Office Building Washington DC 20515-1602 | 202-225-6601 | 1630 Longworth House Office Building | |||||||||
44498 | 44498 | Tracey Mann M000871 | rep | KS | 2021-01-03 | 2023-01-03 | Republican | 1 | https://mann.house.gov | 522 Cannon House Office Building Washington DC 20515-1601 | 202-225-2715 | 522 Cannon House Office Building | |||||||||
44497 | 44497 | Victoria Spartz S000929 | rep | IN | 2021-01-03 | 2023-01-03 | Republican | 5 | https://spartz.house.gov | 1523 Longworth House Office Building Washington DC 20515-1405 | 202-225-2276 | 1523 Longworth House Office Building | |||||||||
44496 | 44496 | Frank Mrvan M001214 | rep | IN | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://mrvan.house.gov | 1607 Longworth House Office Building Washington DC 20515-1401 | 202-225-2461 | 1607 Longworth House Office Building | |||||||||
44495 | 44495 | Mary Miller M001211 | rep | IL | 2021-01-03 | 2023-01-03 | Republican | 15 | https://marymiller.house.gov | 1529 Longworth House Office Building Washington DC 20515-1315 | 202-225-5271 | 1529 Longworth House Office Building | |||||||||
44494 | 44494 | Marie Newman N000192 | rep | IL | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://newman.house.gov | 1022 Longworth House Office Building Washington DC 20515-1303 | 202-225-5701 | 1022 Longworth House Office Building | |||||||||
44493 | 44493 | Randy Feenstra F000446 | rep | IA | 2021-01-03 | 2023-01-03 | Republican | 4 | https://feenstra.house.gov | 1440 Longworth House Office Building Washington DC 20515-1504 | 202-225-4426 | 1440 Longworth House Office Building | |||||||||
44492 | 44492 | Mariannette Miller-Meeks M001215 | rep | IA | 2021-01-03 | 2023-01-03 | Republican | 2 | https://millermeeks.house.gov | 1716 Longworth House Office Building Washington DC 20515-1502 | 202-225-6576 | 1716 Longworth House Office Building | |||||||||
44491 | 44491 | Ashley Hinson H001091 | rep | IA | 2021-01-03 | 2023-01-03 | Republican | 1 | https://hinson.house.gov | 1429 Longworth House Office Building Washington DC 20515-1501 | 202-225-2911 | 1429 Longworth House Office Building | |||||||||
44490 | 44490 | Kaialiʻi Kahele K000396 | rep | HI | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://kahele.house.gov | 1205 Longworth House Office Building Washington DC 20515-1102 | 202-225-4906 | 1205 Longworth House Office Building | |||||||||
44489 | 44489 | Marjorie Greene G000596 | rep | GA | 2021-01-03 | 2023-01-03 | Republican | 14 | https://greene.house.gov | 1023 Longworth House Office Building Washington DC 20515-1014 | 202-225-5211 | 1023 Longworth House Office Building | |||||||||
44488 | 44488 | Andrew Clyde C001116 | rep | GA | 2021-01-03 | 2023-01-03 | Republican | 9 | https://clyde.house.gov | 521 Cannon House Office Building Washington DC 20515-1009 | 202-225-9893 | 521 Cannon House Office Building | |||||||||
44487 | 44487 | Carolyn Bourdeaux B001312 | rep | GA | 2021-01-03 | 2023-01-03 | Democrat | 7 | https://bourdeaux.house.gov | 1319 Longworth House Office Building Washington DC 20515-1007 | 202-225-4272 | 1319 Longworth House Office Building | |||||||||
44486 | 44486 | Nikema Williams W000788 | rep | GA | 2021-01-03 | 2023-01-03 | Democrat | 5 | https://nikemawilliams.house.gov | 1406 Longworth House Office Building Washington DC 20515-1005 | 202-225-3801 | 1406 Longworth House Office Building | |||||||||
44485 | 44485 | Maria Salazar S000168 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 27 | https://salazar.house.gov | 1616 Longworth House Office Building Washington DC 20515-0927 | 202-225-3931 | 1616 Longworth House Office Building | |||||||||
44484 | 44484 | Carlos Gimenez G000593 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 26 | https://gimenez.house.gov | 419 Cannon House Office Building Washington DC 20515-0926 | 202-225-2778 | 419 Cannon House Office Building | |||||||||
44483 | 44483 | Byron Donalds D000032 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 19 | https://donalds.house.gov | 523 Cannon House Office Building Washington DC 20515-0919 | 202-225-2536 | 523 Cannon House Office Building | |||||||||
44482 | 44482 | C. Franklin F000472 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 15 | https://franklin.house.gov | 1517 Longworth House Office Building Washington DC 20515-0915 | 202-225-1252 | 1517 Longworth House Office Building | |||||||||
44481 | 44481 | Katherine Cammack C001039 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 3 | https://cammack.house.gov | 1626 Longworth House Office Building Washington DC 20515-0903 | 202-225-5744 | 1626 Longworth House Office Building | |||||||||
44480 | 44480 | Lauren Boebert B000825 | rep | CO | 2021-01-03 | 2023-01-03 | Republican | 3 | https://boebert.house.gov | 1609 Longworth House Office Building Washington DC 20515-0603 | 202-225-4761 | 1609 Longworth House Office Building | |||||||||
44479 | 44479 | Sara Jacobs J000305 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 53 | https://sarajacobs.house.gov | 1232 Longworth House Office Building Washington DC 20515-0553 | 202-225-2040 | 1232 Longworth House Office Building | |||||||||
44478 | 44478 | Michelle Steel S001135 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 48 | https://steel.house.gov | 1113 Longworth House Office Building Washington DC 20515-0548 | 202-225-2415 | 1113 Longworth House Office Building | |||||||||
44477 | 44477 | Young Kim K000397 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 39 | https://youngkim.house.gov | 1306 Longworth House Office Building Washington DC 20515-0539 | 202-225-4111 | 1306 Longworth House Office Building | |||||||||
44476 | 44476 | Jay Obernolte O000019 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 8 | https://obernolte.house.gov | 1029 Longworth House Office Building Washington DC 20515-0508 | 202-225-5861 | 1029 Longworth House Office Building | |||||||||
44475 | 44475 | Barry Moore M001212 | rep | AL | 2021-01-03 | 2023-01-03 | Republican | 2 | https://barrymoore.house.gov | 1504 Longworth House Office Building Washington DC 20515-0102 | 202-225-2901 | 1504 Longworth House Office Building | |||||||||
44474 | 44474 | Jerry Carl C001054 | rep | AL | 2021-01-03 | 2023-01-03 | Republican | 1 | https://carl.house.gov | 1330 Longworth House Office Building Washington DC 20515-0101 | 202-225-4931 | 1330 Longworth House Office Building | |||||||||
44473 | 44473 | Bill Hagerty H000601 | sen | TN | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.hagerty.senate.gov | 248 Russell Senate Office Building Washington DC 20510 | 202-224-4944 | https://www.hagerty.senate.gov/email-me/ | 248 Russell Senate Office Building | junior | |||||||
44472 | 44472 | John Hickenlooper H000273 | sen | CO | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.hickenlooper.senate.gov | 374 Russell Senate Office Building Washington DC 20510 | 202-224-5941 | https://www.hickenlooper.senate.gov/contact/ | 374 Russell Senate Office Building | junior | |||||||
44471 | 44471 | Tommy Tuberville T000278 | sen | AL | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.tuberville.senate.gov | 142 Russell Senate Office Building Washington DC 20510 | 202-224-4124 | https://www.tuberville.senate.gov/contact/contact-form/ | 142 Russell Senate Office Building | junior | |||||||
44470 | 44470 | David Valadao V000129 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 21 | https://valadao.house.gov | 1728 Longworth House Office Building Washington DC 20515-0521 | 202-225-4695 | 1728 Longworth House Office Building | http://valadao.house.gov/rss.xml | ||||||||
44469 | 44469 | David Valadao V000129 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 21 | https://valadao.house.gov | 1728 Longworth House Office Building; Washington DC 20515-0521 | 202-225-4695 | 202-226-3196 | 1728 Longworth House Office Building | http://valadao.house.gov/rss.xml | |||||||
44468 | 44468 | David Valadao V000129 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 21 | http://valadao.house.gov | 1004 Longworth HOB; Washington DC 20515-0521 | 202-225-4695 | 202-226-3196 | http://valadao.house.gov/contact/ | 1004 Longworth House Office Building | http://valadao.house.gov/rss.xml | ||||||
44467 | 44467 | David Valadao V000129 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 21 | http://valadao.house.gov | 1004 Longworth HOB; Washington DC 20515-0521 | 202-225-4695 | 202-226-3196 | http://valadao.house.gov/contact/ | 1004 Longworth House Office Building | http://valadao.house.gov/rss.xml | ||||||
44466 | 44466 | Pete Sessions S000250 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 17 | https://sessions.house.gov | 2204 Rayburn House Office Building Washington DC 20515-4317 | 202-225-6105 | 2204 Rayburn House Office Building | http://sessions.house.gov/?a=rss.feed | ||||||||
44465 | 44465 | Pete Sessions S000250 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 32 | https://sessions.house.gov | 2233 Rayburn House Office Building; Washington DC 20515-4332 | 202-225-2231 | 202-225-5878 | 2233 Rayburn House Office Building | http://sessions.house.gov/?a=rss.feed | |||||||
44464 | 44464 | Pete Sessions S000250 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 32 | https://sessions.house.gov | 2233 Rayburn HOB; Washington DC 20515-4332 | 202-225-2231 | 202-225-5878 | https://sessions.house.gov/index.cfm/contact-form | 2233 Rayburn House Office Building | http://sessions.house.gov/?a=rss.feed | ||||||
44463 | 44463 | Pete Sessions S000250 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 32 | http://sessions.house.gov | 2233 Rayburn HOB; Washington DC 20515-4332 | 202-225-2231 | 202-225-5878 | https://sessions.house.gov/index.cfm/contact-form | 2233 Rayburn House Office Building | http://sessions.house.gov/?a=rss.feed | ||||||
44462 | 44462 | Pete Sessions S000250 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 32 | http://www.house.gov/sessions | 2233 Rayburn HOB; Washington DC 20515-4332 | 202-225-2231 | 202-225-5878 | http://www.house.gov/sessionsform/emailform.htm | 2233 Rayburn House Office Building | |||||||
44461 | 44461 | Pete Sessions S000250 | rep | TX | 2009-01-06 | 2011-01-03 | Republican | 32 | http://www.house.gov/sessions | ||||||||||||
44460 | 44460 | Pete Sessions S000250 | rep | TX | 2007-01-04 | 2009-01-03 | Republican | 32 | http://www.house.gov/sessions | ||||||||||||
44459 | 44459 | Pete Sessions S000250 | rep | TX | 2005-01-04 | 2007-01-03 | Republican | 32 | http://www.house.gov/sessions | ||||||||||||
44458 | 44458 | Pete Sessions S000250 | rep | TX | 2003-01-07 | 2005-01-03 | Republican | 32 | http://www.house.gov/sessions | ||||||||||||
44457 | 44457 | Pete Sessions S000250 | rep | TX | 2001-01-03 | 2003-01-03 | Republican | 5 | |||||||||||||
44456 | 44456 | Pete Sessions S000250 | rep | TX | 1999-01-06 | 2001-01-03 | Republican | 5 | |||||||||||||
44455 | 44455 | Pete Sessions S000250 | rep | TX | 1997-01-07 | 1999-01-03 | Republican | 5 | |||||||||||||
44454 | 44454 | Darrell Issa I000056 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 50 | https://issa.house.gov | 2300 Rayburn House Office Building Washington DC 20515-0550 | 202-225-5672 | 2300 Rayburn House Office Building | http://issa.house.gov/feed/ | ||||||||
44453 | 44453 | Darrell Issa I000056 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 49 | https://issa.house.gov | 2269 Rayburn House Office Building; Washington DC 20515-0549 | 202-225-3906 | 202-225-3303 | 2269 Rayburn House Office Building | http://issa.house.gov/feed/ | |||||||
44452 | 44452 | Darrell Issa I000056 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 49 | http://issa.house.gov | 2269 Rayburn HOB; Washington DC 20515-0549 | 202-225-3906 | 202-225-3303 | http://issa.house.gov/contact/contact-me | 2269 Rayburn House Office Building | http://issa.house.gov/feed/ |
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);