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 legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, district, rss_url
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||
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 | |||||||||
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 | ||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | ||||||||
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 | ||||||||
41991 | 41991 | Roy Blunt B000575 | sen | MO | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.blunt.senate.gov | 260 Russell Senate Office Building Washington DC 20510 | 202-224-5721 | 202-224-8149 | https://www.blunt.senate.gov/public/index.cfm/contact-roy | 260 Russell Senate Office Building | senior | http://www.blunt.senate.gov/public/?a=rss.feed | |||||
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 | |||||||||
42011 | 42011 | Kevin Brady B000755 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 8 | https://kevinbrady.house.gov | 1011 Longworth House Office Building Washington DC 20515-4308 | 202-225-4901 | 1011 Longworth House Office Building | http://kevinbrady.house.gov/common/rss/index.cfm?rss=49 | ||||||||
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 | |||||||||
42049 | 42049 | Richard Burr B001135 | sen | NC | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.burr.senate.gov | 217 Russell Senate Office Building Washington DC 20510 | 202-224-3154 | 202-228-2981 | https://www.burr.senate.gov/contact | 217 Russell Senate Office Building | senior | http://www.burr.senate.gov/public/index.cfm?fuseaction=rss.feed | |||||
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 | |||||||||
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 | |||||||||
41998 | 41998 | John Boozman B001236 | sen | AR | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.boozman.senate.gov/public | 141 Hart Senate Office Building Washington DC 20510 | 202-224-4843 | 202-228-1371 | https://www.boozman.senate.gov/public/index.cfm/contact | 141 Hart Senate Office Building | senior | http://www.boozman.senate.gov/public/index.cfm/rss/feed | |||||
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 | ||||||||
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/ | ||||||||
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 | ||||||||
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 | ||||||||
41934 | 41934 | Michael Bennet B001267 | sen | CO | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.bennet.senate.gov/public | 261 Russell Senate Office Building Washington DC 20510 | 202-224-5852 | 202-228-5097 | https://www.bennet.senate.gov/public/index.cfm/contact | 261 Russell Senate Office Building | senior | http://www.bennet.senate.gov/rss/feeds/?type=news | |||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
41982 | 41982 | Richard Blumenthal B001277 | sen | CT | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.blumenthal.senate.gov | 706 Hart Senate Office Building Washington DC 20510 | 202-224-2823 | 202-224-9673 | https://www.blumenthal.senate.gov/contact/ | 706 Hart Senate Office Building | senior | http://www.blumenthal.senate.gov/rss/feeds/?type=all | |||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
43732 | 43732 | Julia Brownley B001285 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 26 | https://juliabrownley.house.gov | 2262 Rayburn House Office Building Washington DC 20515-0526 | 202-225-5811 | 2262 Rayburn House Office Building | http://juliabrownley.house.gov/rss.xml | ||||||||
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 | ||||||||
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 | ||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
44423 | 44423 | Dan Bishop B001311 | rep | NC | 2021-01-03 | 2023-01-03 | Republican | 9 | https://danbishop.house.gov | 1207 Longworth House Office Building Washington DC 20515-3309 | 202-225-1976 | 1207 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 | |||||||||
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 | |||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
42237 | 42237 | Michael Crapo C000880 | sen | ID | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.crapo.senate.gov | 239 Dirksen Senate Office Building Washington DC 20510 | 202-224-6142 | 202-228-1375 | https://www.crapo.senate.gov/contact | 239 Dirksen Senate Office Building | senior | ||||||
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 | |||||||||
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 | ||||||||
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 | ||||||||
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 | |||||||||
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 | |||||||||
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 | ||||||||
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 | ||||||||
42252 | 42252 | Henry Cuellar C001063 | rep | TX | 2021-01-03 | 2023-01-03 | Democrat | 28 | https://cuellar.house.gov | 2372 Rayburn House Office Building Washington DC 20515-4328 | 202-225-1640 | 2372 Rayburn House Office Building | http://cuellar.house.gov/news/rss.aspx | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
42230 | 42230 | Joe Courtney C001069 | rep | CT | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://courtney.house.gov | 2449 Rayburn House Office Building Washington DC 20515-0702 | 202-225-2076 | 2449 Rayburn House Office Building | http://courtney.house.gov/index.php?format=feed&type=rss | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
42243 | 42243 | Eric Crawford C001087 | rep | AR | 2021-01-03 | 2023-01-03 | Republican | 1 | https://crawford.house.gov | 2422 Rayburn House Office Building Washington DC 20515-0401 | 202-225-4076 | 2422 Rayburn House Office Building | http://crawford.house.gov/news/rss.aspx | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
43925 | 43925 | Katherine Clark C001101 | rep | MA | 2021-01-03 | 2023-01-03 | Democrat | 5 | https://katherineclark.house.gov | 2448 Rayburn House Office Building Washington DC 20515-2105 | 202-225-2836 | 2448 Rayburn 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 | |||||||||
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 | |||||||||
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 | ||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
44104 | 44104 | Catherine Cortez Masto C001113 | sen | NV | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.cortezmasto.senate.gov | 313 Hart Senate Office Building Washington DC 20510 | 202-224-3542 | https://www.cortezmasto.senate.gov/contact | 313 Hart Senate Office Building | senior | |||||||
44241 | 44241 | John Curtis C001114 | rep | UT | 2021-01-03 | 2023-01-03 | Republican | 3 | https://curtis.house.gov | 2400 Rayburn House Office Building Washington DC 20515-4403 | 202-225-7751 | 2400 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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
44337 | 44337 | Angie Craig C001119 | rep | MN | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://craig.house.gov | 2442 Rayburn House Office Building Washington DC 20515-2302 | 202-225-2271 | 2442 Rayburn House Office Building | |||||||||
44385 | 44385 | Dan Crenshaw C001120 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 2 | https://crenshaw.house.gov | 413 Cannon House Office Building Washington DC 20515-4302 | 202-225-6565 | 413 Cannon House Office Building | |||||||||
44295 | 44295 | Jason Crow C001121 | rep | CO | 2021-01-03 | 2023-01-03 | Democrat | 6 | https://crow.house.gov | 1229 Longworth House Office Building Washington DC 20515-0606 | 202-225-7882 | 1229 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 | |||||||||
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 | |||||||||
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 | |||||||||
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 |
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);