legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,365 rows where state = "NC" sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: class, state_rank, start (date), end (date)
party >10 ✖
- Democrat 745
- Republican 396
- Whig 74
- Jackson 59
- Federalist 35
- Populist 11
- Adams 6
- American 5
- Ind. Republican-Democrat 4
- Anti-Administration 2
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||
44425 | 44425 | Gregory Murphy M001210 | rep | NC | 2021-01-03 | 2023-01-03 | Republican | 3 | https://gregmurphy.house.gov | 313 Cannon House Office Building Washington DC 20515-3303 | 202-225-3415 | 313 Cannon House Office Building | |||||||||
44424 | 44424 | Gregory Murphy M001210 | rep | NC | 2019-09-17 | 2021-01-03 | Republican | 3 | https://gregmurphy.house.gov/ | 2333 Rayburn House Office Building Washington DC 20515-3303 | 202-225-3415 | https://gregmurphy.house.gov/contact/email | 2333 Rayburn 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 | |||||||||
44422 | 44422 | Dan Bishop B001311 | rep | NC | 2019-09-17 | 2021-01-03 | Republican | 9 | https://danbishop.house.gov/ | 132 Cannon House Office Building Washington DC 20515-3309 | 202-225-1976 | https://danbishop.house.gov/contact/email | 132 Cannon 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 | |||||||||
44188 | 44188 | Ted Budd B001305 | rep | NC | 2019-01-03 | 2021-01-03 | Republican | 13 | https://budd.house.gov | 118 Cannon House Office Building Washington DC 20515-3313 | 202-225-4531 | 118 Cannon House Office Building | |||||||||
44187 | 44187 | Ted Budd B001305 | rep | NC | 2017-01-03 | 2019-01-03 | Republican | 13 | https://budd.house.gov | 118 Cannon House Office Building; Washington DC 20515-3313 | 202-225-4531 | 118 Cannon House Office Building | |||||||||
44077 | 44077 | Thom Tillis T000476 | sen | NC | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.tillis.senate.gov | 113 Dirksen Senate Office Building Washington DC 20510 | 202-224-6342 | https://www.tillis.senate.gov/public/index.cfm/email-me | 113 Dirksen Senate Office Building | junior | |||||||
44076 | 44076 | Thom Tillis T000476 | sen | NC | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.tillis.senate.gov | 113 Dirksen Senate Office Building Washington DC 20510 | 202-224-6342 | https://www.tillis.senate.gov/public/index.cfm/email-me | 113 Dirksen Senate Office Building | junior | |||||||
44019 | 44019 | David Rouzer R000603 | rep | NC | 2021-01-03 | 2023-01-03 | Republican | 7 | https://rouzer.house.gov | 2333 Rayburn House Office Building Washington DC 20515-3307 | 202-225-2731 | 2333 Rayburn House Office Building | |||||||||
44018 | 44018 | David Rouzer R000603 | rep | NC | 2019-01-03 | 2021-01-03 | Republican | 7 | https://rouzer.house.gov | 2439 Rayburn House Office Building Washington DC 20515-3307 | 202-225-2731 | 2439 Rayburn House Office Building | |||||||||
44017 | 44017 | David Rouzer R000603 | rep | NC | 2017-01-03 | 2019-01-03 | Republican | 7 | https://rouzer.house.gov | 424 Cannon House Office Building; Washington DC 20515-3307 | 202-225-2731 | 202-225-5773 | 424 Cannon House Office Building | ||||||||
44016 | 44016 | David Rouzer R000603 | rep | NC | 2015-01-06 | 2017-01-03 | Republican | 7 | https://rouzer.house.gov | 424 Cannon HOB; Washington DC 20515-3307 | 202-225-2731 | 202-225-5773 | 424 Cannon House Office Building | ||||||||
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 | |||||||||
43934 | 43934 | Alma Adams A000370 | rep | NC | 2019-01-03 | 2021-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 | |||||||||
43933 | 43933 | Alma Adams A000370 | rep | NC | 2017-01-03 | 2019-01-03 | Democrat | 12 | https://adams.house.gov | 222 Cannon House Office Building; Washington DC 20515-3312 | 202-225-1510 | 202-225-1512 | 222 Cannon House Office Building | ||||||||
43932 | 43932 | Alma Adams A000370 | rep | NC | 2015-01-06 | 2017-01-03 | Democrat | 12 | http://adams.house.gov | 222 Cannon HOB; Washington DC 20515-3312 | 202-225-1510 | 202-225-1512 | http://adams.house.gov/contact | 222 Cannon House Office Building | |||||||
43931 | 43931 | Alma Adams A000370 | rep | NC | 2014-11-12 | 2015-01-03 | Democrat | 12 | http://adams.house.gov/ | 2304 Rayburn HOB; Washington DC 20515-3312 | 202-225-1510 | http://adams.house.gov/contact | 2304 Rayburn House Office Building | ||||||||
43807 | 43807 | Richard Hudson H001067 | rep | NC | 2021-01-03 | 2023-01-03 | Republican | 8 | https://hudson.house.gov | 2112 Rayburn House Office Building Washington DC 20515-3308 | 202-225-3715 | 2112 Rayburn House Office Building | http://hudson.house.gov/rss.xml | ||||||||
43806 | 43806 | Richard Hudson H001067 | rep | NC | 2019-01-03 | 2021-01-03 | Republican | 8 | https://hudson.house.gov | 2112 Rayburn House Office Building Washington DC 20515-3308 | 202-225-3715 | 2112 Rayburn House Office Building | http://hudson.house.gov/rss.xml | ||||||||
43805 | 43805 | Richard Hudson H001067 | rep | NC | 2017-01-03 | 2019-01-03 | Republican | 8 | https://hudson.house.gov | 429 Cannon House Office Building; Washington DC 20515-3308 | 202-225-3715 | 704-782-1004 | 429 Cannon House Office Building | http://hudson.house.gov/rss.xml | |||||||
43804 | 43804 | Richard Hudson H001067 | rep | NC | 2015-01-06 | 2017-01-03 | Republican | 8 | http://hudson.house.gov | 429 Cannon HOB; Washington DC 20515-3308 | 202-225-3715 | 704-782-1004 | https://hudson.house.gov/email-me | 429 Cannon House Office Building | http://hudson.house.gov/rss.xml | ||||||
43803 | 43803 | Richard Hudson H001067 | rep | NC | 2013-01-03 | 2015-01-03 | Republican | 8 | http://hudson.house.gov | 429 Cannon HOB; Washington DC 20515-3308 | 202-225-3715 | 704-782-1004 | https://hudson.house.gov/email-me | 429 Cannon House Office Building | http://hudson.house.gov/rss.xml | ||||||
43142 | 43142 | David Price P000523 | rep | NC | 2021-01-03 | 2023-01-03 | Democrat | 4 | https://price.house.gov | 2108 Rayburn House Office Building Washington DC 20515-3304 | 202-225-1784 | 2108 Rayburn House Office Building | http://price.house.gov/index.php?format=feed&type=rss | ||||||||
43141 | 43141 | David Price P000523 | rep | NC | 2019-01-03 | 2021-01-03 | Democrat | 4 | https://price.house.gov | 2108 Rayburn House Office Building Washington DC 20515-3304 | 202-225-1784 | 2108 Rayburn House Office Building | http://price.house.gov/index.php?format=feed&type=rss | ||||||||
43140 | 43140 | David Price P000523 | rep | NC | 2017-01-03 | 2019-01-03 | Democrat | 4 | https://price.house.gov | 2108 Rayburn House Office Building; Washington DC 20515-3304 | 202-225-1784 | 202-225-2014 | 2108 Rayburn House Office Building | http://price.house.gov/index.php?format=feed&type=rss | |||||||
43139 | 43139 | David Price P000523 | rep | NC | 2015-01-06 | 2017-01-03 | Democrat | 4 | http://price.house.gov | 2108 Rayburn HOB; Washington DC 20515-3304 | 202-225-1784 | 202-225-2014 | https://price.house.gov/contact | 2108 Rayburn House Office Building | http://price.house.gov/index.php?format=feed&type=rss | ||||||
43138 | 43138 | David Price P000523 | rep | NC | 2013-01-03 | 2015-01-03 | Democrat | 4 | http://price.house.gov | 2162 Rayburn HOB; Washington DC 20515-3304 | 202-225-1784 | 202-225-2014 | https://price.house.gov/contact | 2162 Rayburn House Office Building | http://price.house.gov/index.php?format=feed&type=rss | ||||||
43137 | 43137 | David Price P000523 | rep | NC | 2011-01-05 | 2013-01-03 | Democrat | 4 | http://price.house.gov | 2162 Rayburn HOB; Washington DC 20515-3304 | 202-225-1784 | 202-225-2014 | http://price.house.gov/contact/contact_form.shtml | 2162 Rayburn House Office Building | |||||||
43136 | 43136 | David Price P000523 | rep | NC | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://price.house.gov | ||||||||||||
43135 | 43135 | David Price P000523 | rep | NC | 2007-01-04 | 2009-01-03 | Democrat | 4 | http://price.house.gov | ||||||||||||
43134 | 43134 | David Price P000523 | rep | NC | 2005-01-04 | 2007-01-03 | Democrat | 4 | http://www.house.gov/price | ||||||||||||
43133 | 43133 | David Price P000523 | rep | NC | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/price | ||||||||||||
43132 | 43132 | David Price P000523 | rep | NC | 2001-01-03 | 2003-01-03 | Democrat | 4 | |||||||||||||
43131 | 43131 | David Price P000523 | rep | NC | 1999-01-06 | 2001-01-03 | Democrat | 4 | |||||||||||||
43130 | 43130 | David Price P000523 | rep | NC | 1997-01-07 | 1999-01-03 | Democrat | 4 | |||||||||||||
43129 | 43129 | David Price P000523 | rep | NC | 1993-01-05 | 1995-01-03 | Democrat | 4 | |||||||||||||
43128 | 43128 | David Price P000523 | rep | NC | 1991-01-03 | 1993-01-03 | Democrat | 4 | |||||||||||||
43127 | 43127 | David Price P000523 | rep | NC | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
43126 | 43126 | David Price P000523 | rep | NC | 1987-01-06 | 1989-01-03 | Democrat | 4 | |||||||||||||
42903 | 42903 | Patrick McHenry M001156 | rep | NC | 2021-01-03 | 2023-01-03 | Republican | 10 | https://mchenry.house.gov | 2004 Rayburn House Office Building Washington DC 20515-3310 | 202-225-2576 | 2004 Rayburn House Office Building | http://mchenry.house.gov/news/rss.aspx | ||||||||
42902 | 42902 | Patrick McHenry M001156 | rep | NC | 2019-01-03 | 2021-01-03 | Republican | 10 | https://mchenry.house.gov | 2004 Rayburn House Office Building Washington DC 20515-3310 | 202-225-2576 | 2004 Rayburn House Office Building | http://mchenry.house.gov/news/rss.aspx | ||||||||
42901 | 42901 | Patrick McHenry M001156 | rep | NC | 2017-01-03 | 2019-01-03 | Republican | 10 | https://mchenry.house.gov | 2334 Rayburn House Office Building; Washington DC 20515-3310 | 202-225-2576 | 202-225-0316 | 2334 Rayburn House Office Building | http://mchenry.house.gov/news/rss.aspx | |||||||
42900 | 42900 | Patrick McHenry M001156 | rep | NC | 2015-01-06 | 2017-01-03 | Republican | 10 | http://mchenry.house.gov | 2334 Rayburn HOB; Washington DC 20515-3310 | 202-225-2576 | 202-225-0316 | http://mchenry.house.gov/contact/zipauth.htm | 2334 Rayburn House Office Building | http://mchenry.house.gov/news/rss.aspx | ||||||
42899 | 42899 | Patrick McHenry M001156 | rep | NC | 2013-01-03 | 2015-01-03 | Republican | 10 | http://mchenry.house.gov | 2334 Rayburn HOB; Washington DC 20515-3310 | 202-225-2576 | 202-225-0316 | http://mchenry.house.gov/contact/zipauth.htm | 2334 Rayburn House Office Building | http://mchenry.house.gov/news/rss.aspx | ||||||
42898 | 42898 | Patrick McHenry M001156 | rep | NC | 2011-01-05 | 2013-01-03 | Republican | 10 | http://www.house.gov/mchenry | 224 Cannon HOB; Washington DC 20515-3310 | 202-225-2576 | 202-225-0316 | http://mchenry.house.gov/zipauth.htm | 224 Cannon House Office Building | |||||||
42897 | 42897 | Patrick McHenry M001156 | rep | NC | 2009-01-06 | 2011-01-03 | Republican | 10 | http://www.house.gov/mchenry | ||||||||||||
42896 | 42896 | Patrick McHenry M001156 | rep | NC | 2007-01-04 | 2009-01-03 | Republican | 10 | http://www.house.gov/mchenry | ||||||||||||
42895 | 42895 | Patrick McHenry M001156 | rep | NC | 2005-01-04 | 2007-01-03 | Republican | 10 | |||||||||||||
42392 | 42392 | Virginia Foxx F000450 | rep | NC | 2021-01-03 | 2023-01-03 | Republican | 5 | https://foxx.house.gov | 2462 Rayburn House Office Building Washington DC 20515-3305 | 202-225-2071 | 2462 Rayburn House Office Building | http://foxx.house.gov/common/rss/?rss=55 | ||||||||
42391 | 42391 | Virginia Foxx F000450 | rep | NC | 2019-01-03 | 2021-01-03 | Republican | 5 | https://foxx.house.gov | 2462 Rayburn House Office Building Washington DC 20515-3305 | 202-225-2071 | 2462 Rayburn House Office Building | http://foxx.house.gov/common/rss/?rss=55 | ||||||||
42390 | 42390 | Virginia Foxx F000450 | rep | NC | 2017-01-03 | 2019-01-03 | Republican | 5 | https://foxx.house.gov | 2262 Rayburn House Office Building; Washington DC 20515-3305 | 202-225-2071 | 202-225-2995 | 2262 Rayburn House Office Building | http://foxx.house.gov/common/rss/?rss=55 | |||||||
42389 | 42389 | Virginia Foxx F000450 | rep | NC | 2015-01-06 | 2017-01-03 | Republican | 5 | http://foxx.house.gov | 2350 Rayburn HOB; Washington DC 20515-3305 | 202-225-2071 | 202-225-2995 | https://foxx.house.gov/forms/writeyourrep/?zip5=&zip4= | 2350 Rayburn House Office Building | http://foxx.house.gov/common/rss/?rss=55 | ||||||
42388 | 42388 | Virginia Foxx F000450 | rep | NC | 2013-01-03 | 2015-01-03 | Republican | 5 | http://foxx.house.gov | 2350 Rayburn HOB; Washington DC 20515-3305 | 202-225-2071 | 202-225-2995 | https://foxx.house.gov/forms/writeyourrep/?zip5=&zip4= | 2350 Rayburn House Office Building | http://foxx.house.gov/common/rss/?rss=55 | ||||||
42387 | 42387 | Virginia Foxx F000450 | rep | NC | 2011-01-05 | 2013-01-03 | Republican | 5 | http://foxx.house.gov | 1230 Longworth HOB; Washington DC 20515-3305 | 202-225-2071 | 202-225-2995 | http://www.house.gov/formfoxx/IMA/issue_subscribe.htm | 1230 Longworth House Office Building | |||||||
42386 | 42386 | Virginia Foxx F000450 | rep | NC | 2009-01-06 | 2011-01-03 | Republican | 5 | http://foxx.house.gov | ||||||||||||
42385 | 42385 | Virginia Foxx F000450 | rep | NC | 2007-01-04 | 2009-01-03 | Republican | 5 | http://foxx.house.gov | ||||||||||||
42384 | 42384 | Virginia Foxx F000450 | rep | NC | 2005-01-04 | 2007-01-03 | Republican | 5 | |||||||||||||
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/ | ||||||||
42058 | 42058 | George Butterfield B001251 | rep | NC | 2019-01-03 | 2021-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/ | ||||||||
42057 | 42057 | George Butterfield B001251 | rep | NC | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://butterfield.house.gov | 2080 Rayburn House Office Building; Washington DC 20515-3301 | 202-225-3101 | 202-225-3354 | 2080 Rayburn House Office Building | http://butterfield.house.gov/rss/press-releases.xml/ | |||||||
42056 | 42056 | George Butterfield B001251 | rep | NC | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://butterfield.house.gov | 2305 Rayburn HOB; Washington DC 20515-3301 | 202-225-3101 | 202-225-3354 | https://butterfield.house.gov/email-congressman-butterfield | 2305 Rayburn House Office Building | http://butterfield.house.gov/rss/press-releases.xml/ | ||||||
42055 | 42055 | George Butterfield B001251 | rep | NC | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://butterfield.house.gov | 2305 Rayburn HOB; Washington DC 20515-3301 | 202-225-3101 | 202-225-3354 | https://butterfield.house.gov/email-congressman-butterfield | 2305 Rayburn House Office Building | http://butterfield.house.gov/rss/press-releases.xml/ | ||||||
42054 | 42054 | George Butterfield B001251 | rep | NC | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://www.house.gov/butterfield | 2305 Rayburn HOB; Washington DC 20515-3301 | 202-225-3101 | 202-225-3354 | http://butterfield.house.gov/contactinfo.asp | 2305 Rayburn House Office Building | |||||||
42053 | 42053 | George Butterfield B001251 | rep | NC | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/butterfield | ||||||||||||
42052 | 42052 | George Butterfield B001251 | rep | NC | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/butterfield | ||||||||||||
42051 | 42051 | George Butterfield B001251 | rep | NC | 2005-01-04 | 2007-01-03 | Democrat | 1 | |||||||||||||
42050 | 42050 | George Butterfield B001251 | rep | NC | 2004-07-21 | 2005-01-03 | Democrat | 1 | http://www.house.gov/butterfield/ | ||||||||||||
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 | |||||
42048 | 42048 | Richard Burr B001135 | sen | NC | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.burr.senate.gov | 217 Russell Senate Office Building Washington DC 20510 | 202-224-3154 | 202-228-2981 | http://www.burr.senate.gov/public/index.cfm?FuseAction=Contact.ContactForm | 217 Russell Senate Office Building | senior | http://www.burr.senate.gov/public/index.cfm?fuseaction=rss.feed | |||||
42047 | 42047 | Richard Burr B001135 | sen | NC | 2005-01-04 | 2011-01-03 | 3 | Republican | http://burr.senate.gov | ||||||||||||
42046 | 42046 | Richard Burr B001135 | rep | NC | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/burr | ||||||||||||
42045 | 42045 | Richard Burr B001135 | rep | NC | 2001-01-03 | 2003-01-03 | Republican | 5 | |||||||||||||
42044 | 42044 | Richard Burr B001135 | rep | NC | 1999-01-06 | 2001-01-03 | Republican | 5 | |||||||||||||
42043 | 42043 | Richard Burr B001135 | rep | NC | 1997-01-07 | 1999-01-03 | Republican | 5 | |||||||||||||
42042 | 42042 | Richard Burr B001135 | rep | NC | 1995-01-04 | 1997-01-03 | Republican | 5 | |||||||||||||
41587 | 41587 | Mark Walker W000819 | rep | NC | 2019-01-03 | 2021-01-03 | Republican | 6 | https://walker.house.gov | 1725 Longworth House Office Building Washington DC 20515-3306 | 202-225-3065 | 1725 Longworth House Office Building | |||||||||
41586 | 41586 | Mark Walker W000819 | rep | NC | 2017-01-03 | 2019-01-03 | Republican | 6 | https://walker.house.gov | 1305 Longworth House Office Building; Washington DC 20515-3306 | 202-225-3065 | 202-225-8611 | 1305 Longworth House Office Building | ||||||||
41585 | 41585 | Mark Walker W000819 | rep | NC | 2015-01-06 | 2017-01-03 | Republican | 6 | https://walker.house.gov | 312 Cannon HOB; Washington DC 20515-3306 | 202-225-3065 | 202-225-8611 | 312 Cannon House Office Building | ||||||||
41569 | 41569 | George Holding H001065 | rep | NC | 2019-01-03 | 2021-01-03 | Republican | 2 | https://holding.house.gov | 1110 Longworth House Office Building Washington DC 20515-3302 | 202-225-3032 | 1110 Longworth House Office Building | http://holding.house.gov/rss.xml | ||||||||
41568 | 41568 | George Holding H001065 | rep | NC | 2017-01-03 | 2019-01-03 | Republican | 2 | https://holding.house.gov | 1110 Longworth House Office Building; Washington DC 20515-3302 | 202-225-3032 | 919-782-4490 | 1110 Longworth House Office Building | http://holding.house.gov/rss.xml | |||||||
41567 | 41567 | George Holding H001065 | rep | NC | 2015-01-06 | 2017-01-03 | Republican | 13 | http://holding.house.gov | 507 Cannon HOB; Washington DC 20515-3313 | 202-225-3032 | 919-782-4490 | https://holding.house.gov/contact/email-me | 507 Cannon House Office Building | http://holding.house.gov/rss.xml | ||||||
41566 | 41566 | George Holding H001065 | rep | NC | 2013-01-03 | 2015-01-03 | Republican | 13 | http://holding.house.gov | 507 Cannon HOB; Washington DC 20515-3313 | 202-225-3032 | 919-782-4490 | https://holding.house.gov/contact/email-me | 507 Cannon House Office Building | http://holding.house.gov/rss.xml | ||||||
41225 | 41225 | Mark Meadows M001187 | rep | NC | 2019-01-03 | 2020-03-30 | Republican | 11 | https://meadows.house.gov | 2160 Rayburn House Office Building; Washington DC 20515-3311 | 202-225-6401 | 2160 Rayburn House Office Building | http://meadows.house.gov/rss/press-releases.xml | ||||||||
41224 | 41224 | Mark Meadows M001187 | rep | NC | 2017-01-03 | 2019-01-03 | Republican | 11 | https://meadows.house.gov | 1024 Longworth House Office Building; Washington DC 20515-3311 | 202-225-6401 | 202-226-6422 | 1024 Longworth House Office Building | http://meadows.house.gov/rss/press-releases.xml | |||||||
41223 | 41223 | Mark Meadows M001187 | rep | NC | 2015-01-06 | 2017-01-03 | Republican | 11 | https://meadows.house.gov | 1024 Longworth HOB; Washington DC 20515-3311 | 202-225-6401 | 202-226-6422 | https://meadows.house.gov/email-me | 1024 Longworth House Office Building | http://meadows.house.gov/rss/press-releases.xml | ||||||
41222 | 41222 | Mark Meadows M001187 | rep | NC | 2013-01-03 | 2015-01-03 | Republican | 11 | http://meadows.house.gov | 1516 Longworth HOB; Washington DC 20515-3311 | 202-225-6401 | https://meadows.house.gov/email-me | 1516 Longworth House Office Building | http://meadows.house.gov/rss/press-releases.xml | |||||||
41186 | 41186 | Walter Jones J000255 | rep | NC | 2019-01-04 | 2019-02-10 | Republican | 3 | https://jones.house.gov | 2333 Rayburn House Office Building; Washington DC 20515-3303 | 202-225-3415 | 2333 Rayburn House Office Building | http://jones.house.gov/rss.xml | ||||||||
41185 | 41185 | Walter Jones J000255 | rep | NC | 2017-01-03 | 2019-01-03 | Republican | 3 | https://jones.house.gov | 2333 Rayburn House Office Building; Washington DC 20515-3303 | 202-225-3415 | 202-225-3286 | 2333 Rayburn House Office Building | http://jones.house.gov/rss.xml | |||||||
41184 | 41184 | Walter Jones J000255 | rep | NC | 2015-01-06 | 2017-01-03 | Republican | 3 | http://jones.house.gov | 2333 Rayburn HOB; Washington DC 20515-3303 | 202-225-3415 | 202-225-3286 | https://jones.house.gov/contact-me/email-me | 2333 Rayburn House Office Building | http://jones.house.gov/rss.xml | ||||||
41183 | 41183 | Walter Jones J000255 | rep | NC | 2013-01-03 | 2015-01-03 | Republican | 3 | http://jones.house.gov | 2333 Rayburn HOB; Washington DC 20515-3303 | 202-225-3415 | 202-225-3286 | https://jones.house.gov/contact-me/email-me | 2333 Rayburn House Office Building | http://jones.house.gov/rss.xml | ||||||
41182 | 41182 | Walter Jones J000255 | rep | NC | 2011-01-05 | 2013-01-03 | Republican | 3 | http://jones.house.gov | 2333 Rayburn HOB; Washington DC 20515-3303 | 202-225-3415 | 202-225-3286 | http://jones.house.gov/contact_form_email.cfm | 2333 Rayburn House Office Building | |||||||
41181 | 41181 | Walter Jones J000255 | rep | NC | 2009-01-06 | 2011-01-03 | Republican | 3 | http://jones.house.gov | ||||||||||||
41180 | 41180 | Walter Jones J000255 | rep | NC | 2007-01-04 | 2009-01-03 | Republican | 3 | http://jones.house.gov | ||||||||||||
41179 | 41179 | Walter Jones J000255 | rep | NC | 2005-01-04 | 2007-01-03 | Republican | 3 | http://jones.house.gov | ||||||||||||
41178 | 41178 | Walter Jones J000255 | rep | NC | 2003-01-07 | 2005-01-03 | Republican | 3 | http://jones.house.gov | ||||||||||||
41177 | 41177 | Walter Jones J000255 | rep | NC | 2001-01-03 | 2003-01-03 | Republican | 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);