legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
472 rows where "end" is on date 2023-01-03 sorted by url
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, party, state_rank, start (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||
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 | ||||||||||
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 | ||||||||||
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 | ||||||||||
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 | ||||||||||
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 | ||||||||||
44551 | 44551 | Rudy Yakym Y000067 | rep | IN | 2022-11-14 | 2023-01-03 | Republican | 2 | special-election | ||||||||||||
43935 | 43935 | Alma Adams A000370 | rep | NC | 2021-01-03 | 2023-01-03 | Democrat | 12 | https://adams.house.gov | 2436 Rayburn House Office Building Washington DC 20515-3312 | 202-225-1510 | 2436 Rayburn House Office Building | |||||||||
43402 | 43402 | Adam Smith S000510 | rep | WA | 2021-01-03 | 2023-01-03 | Democrat | 9 | https://adamsmith.house.gov | 2264 Rayburn House Office Building Washington DC 20515-4709 | 202-225-8901 | 2264 Rayburn House Office Building | http://www.house.gov/news/rss.aspx | ||||||||
41916 | 41916 | Robert Aderholt A000055 | rep | AL | 2021-01-03 | 2023-01-03 | Republican | 4 | https://aderholt.house.gov | 266 Cannon House Office Building Washington DC 20515-0104 | 202-225-4876 | 266 Cannon House Office Building | http://aderholt.house.gov/common/rss//index.cfm?rss=20 | ||||||||
43410 | 43410 | Adrian Smith S001172 | rep | NE | 2021-01-03 | 2023-01-03 | Republican | 3 | https://adriansmith.house.gov | 502 Cannon House Office Building Washington DC 20515-2703 | 202-225-6435 | 502 Cannon House Office Building | http://adriansmith.house.gov/rss.xml | ||||||||
43959 | 43959 | Pete Aguilar A000371 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 31 | https://aguilar.house.gov | 109 Cannon House Office Building Washington DC 20515-0531 | 202-225-3201 | 109 Cannon House Office Building | |||||||||
42463 | 42463 | Al Green G000553 | rep | TX | 2021-01-03 | 2023-01-03 | Democrat | 9 | https://algreen.house.gov | 2347 Rayburn House Office Building Washington DC 20515-4309 | 202-225-7508 | 2347 Rayburn House Office Building | http://algreen.house.gov/rss.xml | ||||||||
43987 | 43987 | Rick Allen A000372 | rep | GA | 2021-01-03 | 2023-01-03 | Republican | 12 | https://allen.house.gov | 570 Cannon House Office Building Washington DC 20515-1012 | 202-225-2823 | 570 Cannon House Office Building | |||||||||
44399 | 44399 | Colin Allred A000376 | rep | TX | 2021-01-03 | 2023-01-03 | Democrat | 32 | https://allred.house.gov | 114 Cannon House Office Building Washington DC 20515-4332 | 202-225-2231 | 114 Cannon House Office Building | |||||||||
43660 | 43660 | Mark Amodei A000369 | rep | NV | 2021-01-03 | 2023-01-03 | Republican | 2 | https://amodei.house.gov | 104 Cannon House Office Building Washington DC 20515-2802 | 202-225-6155 | 104 Cannon House Office Building | http://amodei.house.gov/common/rss//?rss=49 | ||||||||
44331 | 44331 | Andy Levin L000592 | rep | MI | 2021-01-03 | 2023-01-03 | Democrat | 9 | https://andylevin.house.gov | 312 Cannon House Office Building Washington DC 20515-2209 | 202-225-4961 | 312 Cannon House Office Building | |||||||||
44180 | 44180 | Anthony Brown B001304 | rep | MD | 2021-01-03 | 2023-01-03 | Democrat | 4 | https://anthonybrown.house.gov | 1323 Longworth House Office Building Washington DC 20515-2004 | 202-225-8699 | 1323 Longworth House Office Building | |||||||||
44363 | 44363 | Anthony Gonzalez G000588 | rep | OH | 2021-01-03 | 2023-01-03 | Republican | 16 | https://anthonygonzalez.house.gov | 2458 Rayburn House Office Building Washington DC 20515-3516 | 202-225-3876 | 2458 Rayburn House Office Building | |||||||||
44347 | 44347 | Kelly Armstrong A000377 | rep | ND | 2021-01-03 | 2023-01-03 | Republican | 0 | https://armstrong.house.gov | 1740 Longworth House Office Building Washington DC 20515-3400 | 202-225-2611 | 1740 Longworth House Office Building | |||||||||
44220 | 44220 | Jodey Arrington A000375 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 19 | https://arrington.house.gov | 1107 Longworth House Office Building Washington DC 20515-4319 | 202-225-4005 | 1107 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 | |||||||||
43310 | 43310 | Austin Scott S001189 | rep | GA | 2021-01-03 | 2023-01-03 | Republican | 8 | https://austinscott.house.gov | 2417 Rayburn House Office Building Washington DC 20515-1008 | 202-225-6531 | 2417 Rayburn House Office Building | http://austinscott.house.gov/index.php?format=feed&type=rss | ||||||||
44307 | 44307 | Cynthia Axne A000378 | rep | IA | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://axne.house.gov | 1034 Longworth House Office Building Washington DC 20515-1503 | 202-225-5476 | 1034 Longworth House Office Building | |||||||||
44047 | 44047 | Brian Babin B001291 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 36 | https://babin.house.gov | 2236 Rayburn House Office Building Washington DC 20515-4336 | 202-225-1555 | 2236 Rayburn House Office Building | |||||||||
44192 | 44192 | Don Bacon B001298 | rep | NE | 2021-01-03 | 2023-01-03 | Republican | 2 | https://bacon.house.gov | 1024 Longworth House Office Building Washington DC 20515-2702 | 202-225-4155 | 1024 Longworth House Office Building | |||||||||
44317 | 44317 | James Baird B001307 | rep | IN | 2021-01-03 | 2023-01-03 | Republican | 4 | https://baird.house.gov | 1314 Longworth House Office Building Washington DC 20515-1404 | 202-225-5037 | 1314 Longworth House Office Building | |||||||||
44259 | 44259 | Troy Balderson B001306 | rep | OH | 2021-01-03 | 2023-01-03 | Republican | 12 | https://balderson.house.gov | 2429 Rayburn House Office Building Washington DC 20515-3512 | 202-225-5355 | 2429 Rayburn House Office Building | |||||||||
44165 | 44165 | Jim Banks B001299 | rep | IN | 2021-01-03 | 2023-01-03 | Republican | 3 | https://banks.house.gov | 1713 Longworth House Office Building Washington DC 20515-1403 | 202-225-4436 | 1713 Longworth House Office Building | |||||||||
43785 | 43785 | Garland Barr B001282 | rep | KY | 2021-01-03 | 2023-01-03 | Republican | 6 | https://barr.house.gov | 2430 Rayburn House Office Building Washington DC 20515-1706 | 202-225-4706 | 2430 Rayburn House Office Building | http://barr.house.gov/rss.xml | ||||||||
44126 | 44126 | Nanette Barragán B001300 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 44 | https://barragan.house.gov | 2246 Rayburn House Office Building Washington DC 20515-0544 | 202-225-8220 | 2246 Rayburn 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 | |||||||||
41931 | 41931 | Karen Bass B001270 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 37 | https://bass.house.gov | 2021 Rayburn House Office Building Washington DC 20515-0537 | 202-225-7084 | 2021 Rayburn House Office Building | http://bass.house.gov/rss.xml | ||||||||
43843 | 43843 | Joyce Beatty B001281 | rep | OH | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://beatty.house.gov | 2303 Rayburn House Office Building Washington DC 20515-3503 | 202-225-4324 | 2303 Rayburn House Office Building | http://beatty.house.gov/rss.xml | ||||||||
43464 | 43464 | Bennie Thompson T000193 | rep | MS | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://benniethompson.house.gov | 2466 Rayburn House Office Building Washington DC 20515-2402 | 202-225-5876 | 2466 Rayburn House Office Building | http://benniethompson.house.gov/index.php?format=feed&type=rss | ||||||||
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 | |||||||||
43722 | 43722 | Ami Bera B001287 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 7 | https://bera.house.gov | 172 Cannon House Office Building Washington DC 20515-0507 | 202-225-5716 | 172 Cannon House Office Building | http://bera.house.gov/rss.xml | ||||||||
44186 | 44186 | Jack Bergman B001301 | rep | MI | 2021-01-03 | 2023-01-03 | Republican | 1 | https://bergman.house.gov | 566 Cannon House Office Building Washington DC 20515-2201 | 202-225-4735 | 566 Cannon House Office Building | |||||||||
44051 | 44051 | Donald Beyer B001292 | rep | VA | 2021-01-03 | 2023-01-03 | Democrat | 8 | https://beyer.house.gov | 1119 Longworth House Office Building Washington DC 20515-4608 | 202-225-4376 | 1119 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 | |||||||||
44114 | 44114 | Andy Biggs B001302 | rep | AZ | 2021-01-03 | 2023-01-03 | Republican | 5 | https://biggs.house.gov | 171 Cannon House Office Building Washington DC 20515-0305 | 202-225-2635 | 171 Cannon House Office Building | |||||||||
41942 | 41942 | Gus Bilirakis B001257 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 12 | https://bilirakis.house.gov | 2354 Rayburn House Office Building Washington DC 20515-0912 | 202-225-5755 | 2354 Rayburn House Office Building | http://bilirakis.house.gov/index.php?format=feed&type=rss | ||||||||
42578 | 42578 | Bill Johnson J000292 | rep | OH | 2021-01-03 | 2023-01-03 | Republican | 6 | https://billjohnson.house.gov | 2336 Rayburn House Office Building Washington DC 20515-3506 | 202-225-5705 | 2336 Rayburn House Office Building | http://billjohnson.house.gov/constituentservices/opendoorsschedule.htm | ||||||||
41957 | 41957 | Sanford Bishop B000490 | rep | GA | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://bishop.house.gov | 2407 Rayburn House Office Building Washington DC 20515-1002 | 202-225-3631 | 2407 Rayburn House Office Building | http://bishop.house.gov/rss.xml | ||||||||
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 | |||||||||
41980 | 41980 | Earl Blumenauer B000574 | rep | OR | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://blumenauer.house.gov | 1111 Longworth House Office Building Washington DC 20515-3703 | 202-225-4811 | 1111 Longworth House Office Building | http://blumenauer.house.gov/index.php?format=feed&type=rss | ||||||||
44132 | 44132 | Lisa Blunt Rochester B001303 | rep | DE | 2021-01-03 | 2023-01-03 | Democrat | 0 | https://bluntrochester.house.gov | 1724 Longworth House Office Building Washington DC 20515-0800 | 202-225-4165 | 1724 Longworth House Office Building | |||||||||
43335 | 43335 | Robert Scott S000185 | rep | VA | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://bobbyscott.house.gov | 2328 Rayburn House Office Building Washington DC 20515-4603 | 202-225-8351 | 2328 Rayburn House Office Building | http://www.house.gov/index.php?format=feed&type=rss | ||||||||
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 | |||||||||
43666 | 43666 | Suzanne Bonamici B001278 | rep | OR | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://bonamici.house.gov | 2231 Rayburn House Office Building Washington DC 20515-3701 | 202-225-0855 | 2231 Rayburn House Office Building | http://bonamici.house.gov/rss.xml | ||||||||
43991 | 43991 | Mike Bost B001295 | rep | IL | 2021-01-03 | 2023-01-03 | Republican | 12 | https://bost.house.gov | 1211 Longworth House Office Building Washington DC 20515-1312 | 202-225-5661 | 1211 Longworth 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 | |||||||||
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 | |||||||||
44043 | 44043 | Brendan Boyle B001296 | rep | PA | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://boyle.house.gov | 1133 Longworth House Office Building Washington DC 20515-3802 | 202-225-6111 | 1133 Longworth House Office Building | |||||||||
42017 | 42017 | Mo Brooks B001274 | rep | AL | 2021-01-03 | 2023-01-03 | Republican | 5 | https://brooks.house.gov | 2185 Rayburn House Office Building Washington DC 20515-0105 | 202-225-4801 | 2185 Rayburn House Office Building | http://brooks.house.gov/rss/press-releases.xml | ||||||||
42025 | 42025 | Vern Buchanan B001260 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 16 | https://buchanan.house.gov | 2110 Rayburn House Office Building Washington DC 20515-0916 | 202-225-5015 | 2110 Rayburn House Office Building | http://buchanan.house.gov/index.php?option=com_bca-rss-syndicator&feed_id=2 | ||||||||
43971 | 43971 | Ken Buck B001297 | rep | CO | 2021-01-03 | 2023-01-03 | Republican | 4 | https://buck.house.gov | 2455 Rayburn House Office Building Washington DC 20515-0604 | 202-225-4676 | 2455 Rayburn House Office Building | |||||||||
42031 | 42031 | Larry Bucshon B001275 | rep | IN | 2021-01-03 | 2023-01-03 | Republican | 8 | https://bucshon.house.gov | 2313 Rayburn House Office Building Washington DC 20515-1408 | 202-225-4636 | 2313 Rayburn House Office Building | http://bucshon.house.gov/rss.xml | ||||||||
44189 | 44189 | Ted Budd B001305 | rep | NC | 2021-01-03 | 2023-01-03 | Republican | 13 | https://budd.house.gov | 103 Cannon House Office Building Washington DC 20515-3313 | 202-225-4531 | 103 Cannon House Office Building | |||||||||
43975 | 43975 | Earl Carter C001103 | rep | GA | 2021-01-03 | 2023-01-03 | Republican | 1 | https://buddycarter.house.gov | 2432 Rayburn House Office Building Washington DC 20515-1001 | 202-225-5831 | 2432 Rayburn House Office Building | |||||||||
44379 | 44379 | Tim Burchett B001309 | rep | TN | 2021-01-03 | 2023-01-03 | Republican | 2 | https://burchett.house.gov | 1122 Longworth House Office Building Washington DC 20515-4202 | 202-225-5435 | 1122 Longworth House Office Building | |||||||||
42041 | 42041 | Michael Burgess B001248 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 26 | https://burgess.house.gov | 2161 Rayburn House Office Building Washington DC 20515-4326 | 202-225-7772 | 2161 Rayburn House Office Building | http://burgess.house.gov/news/rss.aspx | ||||||||
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 | |||||||||
43780 | 43780 | Cheri Bustos B001286 | rep | IL | 2021-01-03 | 2023-01-03 | Democrat | 17 | https://bustos.house.gov | 1233 Longworth House Office Building Washington DC 20515-1317 | 202-225-5905 | 1233 Longworth House Office Building | http://bustos.house.gov/rss.xml | ||||||||
42059 | 42059 | George Butterfield B001251 | rep | NC | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://butterfield.house.gov | 2080 Rayburn House Office Building Washington DC 20515-3301 | 202-225-3101 | 2080 Rayburn House Office Building | http://butterfield.house.gov/rss/press-releases.xml/ | ||||||||
42074 | 42074 | Ken Calvert C000059 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 42 | https://calvert.house.gov | 2205 Rayburn House Office Building Washington DC 20515-0542 | 202-225-1986 | 2205 Rayburn House Office Building | http://calvert.house.gov/news/rss.aspx | ||||||||
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 | |||||||||
44123 | 44123 | Salud Carbajal C001112 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 24 | https://carbajal.house.gov | 2331 Rayburn House Office Building Washington DC 20515-0524 | 202-225-3601 | 2331 Rayburn House Office Building | |||||||||
43737 | 43737 | Tony Cárdenas C001097 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 29 | https://cardenas.house.gov | 2438 Rayburn House Office Building Washington DC 20515-0529 | 202-225-6131 | 2438 Rayburn House Office Building | http://cardenas.house.gov/rss.xml | ||||||||
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 | |||||||||
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 | |||||||||
42091 | 42091 | André Carson C001072 | rep | IN | 2021-01-03 | 2023-01-03 | Democrat | 7 | https://carson.house.gov | 2135 Rayburn House Office Building Washington DC 20515-1407 | 202-225-4011 | 2135 Rayburn House Office Building | http://carson.house.gov/index.php?option=com_bca-rss-syndicator&feed_id=1 | ||||||||
42101 | 42101 | John Carter C001051 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 31 | https://carter.house.gov | 2208 Rayburn House Office Building Washington DC 20515-4331 | 202-225-3864 | 2208 Rayburn House Office Building | http://carter.house.gov/common/rss/?rss=40 | ||||||||
43863 | 43863 | Matthew Cartwright C001090 | rep | PA | 2021-01-03 | 2023-01-03 | Democrat | 8 | https://cartwright.house.gov | 2102 Rayburn House Office Building Washington DC 20515-3808 | 202-225-5546 | 2102 Rayburn House Office Building | http://cartwright.house.gov/rss.xml | ||||||||
44275 | 44275 | Ed Case C001055 | rep | HI | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://case.house.gov | 2210 Rayburn House Office Building Washington DC 20515-1101 | 202-225-2726 | 2210 Rayburn House Office Building | |||||||||
44313 | 44313 | Sean Casten C001117 | rep | IL | 2021-01-03 | 2023-01-03 | Democrat | 6 | https://casten.house.gov | 2440 Rayburn House Office Building Washington DC 20515-1306 | 202-225-4561 | 2440 Rayburn House Office Building | |||||||||
42114 | 42114 | Kathy Castor C001066 | rep | FL | 2021-01-03 | 2023-01-03 | Democrat | 14 | https://castor.house.gov | 2052 Rayburn House Office Building Washington DC 20515-0914 | 202-225-3376 | 2052 Rayburn House Office Building | http://castor.house.gov/news/rss.aspx | ||||||||
43880 | 43880 | Joaquin Castro C001091 | rep | TX | 2021-01-03 | 2023-01-03 | Democrat | 20 | https://castro.house.gov | 2241 Rayburn House Office Building Washington DC 20515-4320 | 202-225-3236 | 2241 Rayburn House Office Building | http://castro.house.gov/rss.xml | ||||||||
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 | |||||||||
42127 | 42127 | Steve Chabot C000266 | rep | OH | 2021-01-03 | 2023-01-03 | Republican | 1 | https://chabot.house.gov | 2408 Rayburn House Office Building Washington DC 20515-3501 | 202-225-2216 | 2408 Rayburn House Office Building | http://chabot.house.gov/common/rss/index.cfm?rss=49 | ||||||||
44229 | 44229 | Liz Cheney C001109 | rep | WY | 2021-01-03 | 2023-01-03 | Republican | 0 | https://cheney.house.gov | 416 Cannon House Office Building Washington DC 20515-5000 | 202-225-2311 | 416 Cannon 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 | |||||||||
43431 | 43431 | Christopher Smith S000522 | rep | NJ | 2021-01-03 | 2023-01-03 | Republican | 4 | https://chrissmith.house.gov | 2373 Rayburn House Office Building Washington DC 20515-3004 | 202-225-3765 | 2373 Rayburn House Office Building | http://chrissmith.house.gov/news/rss.aspx | ||||||||
42134 | 42134 | Judy Chu C001080 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 27 | https://chu.house.gov | 2423 Rayburn House Office Building Washington DC 20515-0527 | 202-225-5464 | 2423 Rayburn House Office Building | http://chu.house.gov/rss.xml | ||||||||
44311 | 44311 | Jesús García G000586 | rep | IL | 2021-01-03 | 2023-01-03 | Democrat | 4 | https://chuygarcia.house.gov | 1519 Longworth House Office Building Washington DC 20515-1304 | 202-225-8203 | 1519 Longworth House Office Building | |||||||||
42140 | 42140 | David Cicilline C001084 | rep | RI | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://cicilline.house.gov | 2233 Rayburn House Office Building Washington DC 20515-3901 | 202-225-4911 | 2233 Rayburn House Office Building | http://cicilline.house.gov/rss.xml | ||||||||
42148 | 42148 | Yvette Clarke C001067 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 9 | https://clarke.house.gov | 2058 Rayburn House Office Building Washington DC 20515-3209 | 202-225-6231 | 2058 Rayburn House Office Building | http://clarke.house.gov/news/rss.aspx | ||||||||
44174 | 44174 | Clay Higgins H001077 | rep | LA | 2021-01-03 | 2023-01-03 | Republican | 3 | https://clayhiggins.house.gov | 572 Cannon House Office Building Washington DC 20515-1803 | 202-225-2031 | 572 Cannon House Office Building | |||||||||
42157 | 42157 | Emanuel Cleaver C001061 | rep | MO | 2021-01-03 | 2023-01-03 | Democrat | 5 | https://cleaver.house.gov | 2335 Rayburn House Office Building Washington DC 20515-2505 | 202-225-4535 | 2335 Rayburn House Office Building | http://cleaver.house.gov/rss.xml | ||||||||
44403 | 44403 | Ben Cline C001118 | rep | VA | 2021-01-03 | 2023-01-03 | Republican | 6 | https://cline.house.gov | 2443 Rayburn House Office Building Washington DC 20515-4606 | 202-225-5431 | 2443 Rayburn House Office Building | |||||||||
44256 | 44256 | Michael Cloud C001115 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 27 | https://cloud.house.gov | 512 Cannon House Office Building Washington DC 20515-4327 | 202-225-7742 | 512 Cannon House Office Building | |||||||||
42172 | 42172 | James Clyburn C000537 | rep | SC | 2021-01-03 | 2023-01-03 | Democrat | 6 | https://clyburn.house.gov | 274 Cannon House Office Building Washington DC 20515-4006 | 202-225-3315 | 274 Cannon House Office Building | http://clyburn.house.gov/rss.xml | ||||||||
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 | |||||||||
42180 | 42180 | Steve Cohen C001068 | rep | TN | 2021-01-03 | 2023-01-03 | Democrat | 9 | https://cohen.house.gov | 2104 Rayburn House Office Building Washington DC 20515-4209 | 202-225-3265 | 2104 Rayburn House Office Building | http://cohen.house.gov/rss.xml | ||||||||
42190 | 42190 | Tom Cole C001053 | rep | OK | 2021-01-03 | 2023-01-03 | Republican | 4 | https://cole.house.gov | 2207 Rayburn House Office Building Washington DC 20515-3604 | 202-225-6165 | 2207 Rayburn House Office Building | http://cole.house.gov/rss.xml | ||||||||
44097 | 44097 | James Comer C001108 | rep | KY | 2021-01-03 | 2023-01-03 | Republican | 1 | https://comer.house.gov | 2410 Rayburn House Office Building Washington DC 20515-1701 | 202-225-3115 | 2410 Rayburn House Office Building | https://comer.house.gov/rss.xml | ||||||||
42197 | 42197 | Gerald Connolly C001078 | rep | VA | 2021-01-03 | 2023-01-03 | Democrat | 11 | https://connolly.house.gov | 2238 Rayburn House Office Building Washington DC 20515-4611 | 202-225-1492 | 2238 Rayburn House Office Building | http://connolly.house.gov/common/rss//index.cfm?rss=44 | ||||||||
42213 | 42213 | Jim Cooper C000754 | rep | TN | 2021-01-03 | 2023-01-03 | Democrat | 5 | https://cooper.house.gov | 1536 Longworth House Office Building Washington DC 20515-4205 | 202-225-4311 | 1536 Longworth House Office Building | http://cooper.house.gov/index.php?format=feed&type=rss | ||||||||
44129 | 44129 | J. Correa C001110 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 46 | https://correa.house.gov | 2301 Rayburn House Office Building Washington DC 20515-0546 | 202-225-2965 | 2301 Rayburn House Office Building | |||||||||
42222 | 42222 | Jim Costa C001059 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 16 | https://costa.house.gov | 2081 Rayburn House Office Building Washington DC 20515-0516 | 202-225-3341 | 2081 Rayburn House Office Building | http://costa.house.gov/index.php?format=feed&type=rss |
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);