legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by id_cspan descending
This data as json, copyable, CSV (advanced)
id | name | id_bioguide | id_govtrack | id_icpsr | id_wikipedia | id_wikidata | id_google_entity_id | name_first | name_last | bio_birthday | bio_gender | id_house_history | name_middle | name_nickname | id_ballotpedia | name_suffix | id_bioguide_previous | id_house_history_alternate | other_names | id_thomas | id_cspan ▲ | id_votesmart | id_lis | name_official_full | id_opensecrets | id_fec | id_maplight | leadership_roles | family |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
G000571 | Tulsi Gabbard | G000571 | 412532 | 21324 | Tulsi Gabbard | Q32620 | kg:/m/0cnyrfq | Tulsi | Gabbard | 1981-04-12 | F | 15032387167 | Tulsi Gabbard | 02122 | 1025291 | 129306 | Tulsi Gabbard | N00033281 | [ "H2HI02508" ] |
1756 | |||||||||
B001262 | Paul Broun | B001262 | 412252 | 20753 | Paul Broun | Q2059020 | kg:/m/02vzlfc | Paul | Broun | 1946-05-14 | M | 10422 | C. | Paul C. Broun | Jr. | 01882 | 1025092 | 70001 | Paul C. Broun | N00028986 | [ "H8GA10049", "S6GA00101", "H0GA03017" ] |
733 | |||||||
B001261 | John Barrasso | B001261 | 412251 | 40707 | John Barrasso | Q720521 | kg:/m/02rsm32 | John | Barrasso | 1952-07-21 | M | A. | John Barrasso | 01881 | 1024777 | 52662 | S317 | John Barrasso | N00006236 | [ "S6WY00068" ] |
732 | [ { "title": "Senate Republican Conference Chair", "chamber": "senate", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "Senate Republican Conference Chair", "chamber": "senate", "start": "2021-01-03" } ] |
|||||||
G000567 | Tim Griffin | G000567 | 412401 | 21107 | Tim Griffin | Q2435200 | kg:/m/02q0d3q | Tim | Griffin | 1968-08-21 | M | 14286 | Tim Griffin | 01990 | 1024660 | 119213 | Tim Griffin | N00031297 | [ "H0AR02107" ] |
1415 | |||||||||
J000300 | Doug Jones | J000300 | 412741 | 41705 | Doug Jones (politician) | Q30122825 | kg:/g/11dyzdzg1j | Doug | Jones | 1954-05-04 | M | Doug Jones (Alabama) | 1024592 | 176464 | S393 | Doug Jones | N00024817 | [ "S0AL00156" ] |
2252 | ||||||||||
S001198 | Dan Sullivan | S001198 | 412665 | 41500 | Dan Sullivan (U.S. senator) | Q5218668 | kg:/m/07s4r4q | Dan | Sullivan | 1964-11-13 | M | Daniel S. Sullivan | 02290 | 1023262 | 114964 | S383 | Dan Sullivan | N00035774 | [ "S4AK00214" ] |
2121 | |||||||||
W000817 | Elizabeth Warren | W000817 | 412542 | 41301 | Elizabeth Warren | Q434706 | kg:/m/01qh39 | Elizabeth | Warren | 1949-06-22 | F | 15032390639 | Elizabeth Warren | 02182 | 1023023 | 141272 | S366 | Elizabeth Warren | N00033492 | [ "S2MA00170" ] |
1766 | ||||||||
S001171 | Heath Shuler | S001171 | 412225 | 20737 | Heath Shuler | Q1592517 | kg:/m/0728_t | Heath | Shuler | 1971-12-31 | M | 22598 | 01859 | 1022886 | 57781 | Heath Shuler | N00027655 | [ "H6NC11172" ] |
|||||||||||
S001168 | John Sarbanes | S001168 | 412212 | 20724 | John Sarbanes | Q984509 | kg:/m/08_r8n | John | Sarbanes | 1962-05-22 | M | 22592 | P. | John Sarbanes | 01854 | 1022884 | 66575 | John P. Sarbanes | N00027751 | [ "H6MD03292" ] |
697 | [ { "name": "Senator Paul Sarbanes", "relation": "son" } ] |
|||||||
L000565 | David Loebsack | L000565 | 412209 | 20720 | Dave Loebsack | Q771586 | kg:/m/0gtmqs | David | Loebsack | 1952-12-23 | M | 17307 | Dave Loebsack | 01846 | 1022883 | 68964 | David Loebsack | N00027741 | [ "H6IA02146" ] |
694 | |||||||||
J000289 | Jim Jordan | J000289 | 412226 | 20738 | Jim Jordan (American politician) | Q186215 | kg:/m/04l4x5 | Jim | Jordan | 1964-02-17 | M | 16067 | Jim Jordan | 01868 | 1022879 | 8158 | Jim Jordan | N00027894 | [ "H6OH04082" ] |
711 | |||||||||
C001068 | Steve Cohen | C001068 | 412236 | 20748 | Steve Cohen | Q512330 | kg:/m/04l8cr | Steve | Cohen | 1949-05-24 | M | 11800 | Steve Cohen | 01878 | 1022876 | 24340 | Steve Cohen | N00003225 | [ "H6TN09068" ] |
721 | |||||||||
C001067 | Yvette Clarke | C001067 | 412221 | 20733 | Yvette Clarke | Q461679 | kg:/m/06h90t | Yvette | Clarke | 1964-11-21 | F | 11798 | D. | Yvette D. Clarke | 01864 | 1022875 | 44741 | Yvette D. Clarke | N00026961 | [ "H4NY11138" ] |
706 | ||||||||
C001066 | Kathy Castor | C001066 | 412195 | 20708 | Kathy Castor | Q458492 | kg:/m/0dq1v6 | Kathy | Castor | 1966-08-20 | F | 11796 | Kathy Castor | 01839 | 1022874 | 53825 | Kathy Castor | N00027514 | [ "H6FL11126", "H6FL11134" ] |
682 | |||||||||
B001257 | Gus Bilirakis | B001257 | 412250 | 20758 | Gus Bilirakis | Q1555314 | kg:/m/0dy3z1 | Gus | Bilirakis | 1963-02-08 | M | 10413 | M. | Gus M. Bilirakis | 01838 | 1022873 | 17318 | Gus M. Bilirakis | N00027462 | [ "H6FL09070" ] |
731 | [ { "name": "Michael Bilirakis", "relation": "son" } ] |
|||||||
A000362 | Jason Altmire | A000362 | 412231 | 20743 | Jason Altmire | Q606309 | kg:/m/0dzy2v | Jason | Altmire | 1968-03-07 | M | 8759 | 01873 | 1022872 | 59999 | Jason Altmire | N00027664 | [ "H6PA04110" ] |
|||||||||||
G000555 | Kirsten Gillibrand | G000555 | 412223 | 20735 | Kirsten Gillibrand | Q22222 | kg:/m/0gnfc4 | Kirsten | Gillibrand | 1966-12-09 | F | 14269 | E. | Kirsten Gillibrand | 01866 | 1022862 | 65147 | S331 | Kirsten E. Gillibrand | N00027658 | [ "H6NY20167", "S0NY00410" ] |
708 | |||||||
L000564 | Doug Lamborn | L000564 | 412191 | 20704 | Doug Lamborn | Q371106 | kg:/m/0fsgdd | Doug | Lamborn | 1954-05-24 | M | 17305 | Doug Lamborn | 01834 | 1022846 | 2698 | Doug Lamborn | N00028133 | [ "H6CO05159" ] |
678 | |||||||||
S001172 | Adrian Smith | S001172 | 412217 | 20729 | Adrian Smith (politician) | Q373443 | kg:/m/0c505n | Adrian | Smith | 1970-12-19 | M | 22600 | Adrian Smith | 01860 | 1022845 | 21284 | Adrian Smith | N00027623 | [ "H6NE03115" ] |
702 | |||||||||
W000798 | Tim Walberg | W000798 | 412213 | 20725 | Tim Walberg | Q978618 | kg:/m/0d7n3m | Tim | Walberg | 1951-04-12 | M | 24179 | Tim Walberg | 01855 | 1022844 | 8618 | Tim Walberg | N00026368 | [ "H4MI07103" ] |
698 | |||||||||
S001173 | Zachary Space | S001173 | 412229 | 20741 | Zack Space | Q139887 | kg:/m/0bfzwz | Zachary | Space | 1961-01-27 | M | 22602 | T. | Zack | 01871 | 1022842 | 56847 | N00027902 | [ "H6OH18157" ] |
||||||||||
E000288 | Keith Ellison | E000288 | 412215 | 20727 | Keith Ellison | Q40589 | kg:/m/0dlwms | Keith | Ellison | 1963-08-04 | M | 12957 | Maurice | Keith Ellison | 01857 | 1022556 | 38982 | Keith Ellison | N00028257 | [ "H6MN05183" ] |
700 | ||||||||
S001165 | Albio Sires | S001165 | 412186 | 20542 | Albio Sires | Q527509 | kg:/m/08bt8r | Albio | Sires | 1951-01-26 | M | 22587 | Albio Sires | 01818 | 1022293 | 22510 | Albio Sires | N00027523 | [ "H6NJ13191" ] |
673 | |||||||||
W000801 | Charles Wilson | W000801 | 412227 | 20739 | Charlie Wilson (Ohio politician) | Q139136 | kg:/m/07z0kw | Charles | Wilson | 1943-01-18 | M | 24185 | A. | 01869 | 1022147 | 10092 | N00003528 | [ "H6OH06095" ] |
|||||||||||
H001039 | John Hall | H001039 | 412222 | 20734 | John Hall (New York politician) | Q1406115 | kg:/m/0bf27d | John | Hall | 1948-07-23 | M | 15574 | J. | 01865 | 1022042 | 69119 | N00027888 | [ "H6NY19144" ] |
|||||||||||
R000580 | Peter Roskam | R000580 | 412202 | 20715 | Peter Roskam | Q968214 | kg:/m/0gj190 | Peter | Roskam | 1961-09-13 | M | 20803 | J. | Peter Roskam | 01848 | 1021912 | 6382 | Peter J. Roskam | N00004719 | [ "H6IL06117", "H8IL13051" ] |
689 | ||||||||
G000554 | Gabrielle Giffords | G000554 | 412188 | 20701 | Gabby Giffords | Q193703 | kg:/m/0dvl98 | Gabrielle | Giffords | 1970-06-08 | F | 14267 | 01831 | 1021830 | 28507 | N00027829 | [ "H6AZ08038" ] |
||||||||||||
S001170 | Carol Shea-Porter | S001170 | 412219 | 20731 | Carol Shea-Porter | Q434112 | kg:/m/0fvcl4 | Carol | Shea-Porter | 1952-12-02 | F | 22596 | Carol Shea-Porter | 01861 | 1021773 | 65891 | Carol Shea-Porter | N00028091 | [ "H6NH01230" ] |
704 | |||||||||
K000365 | Steve Kagen | K000365 | 412240 | 20751 | Steve Kagen | Q512567 | kg:/m/026f_6w | Steve | Kagen | 1949-12-12 | M | 16554 | 01880 | 1021765 | 66021 | N00027618 | [ "H6WI08122" ] |
||||||||||||
K000372 | Mary Jo Kilroy | K000372 | 412285 | 20942 | Mary Jo Kilroy | Q6779928 | kg:/m/0c7ccn | Mary Jo | Kilroy | 1949-04-30 | F | 16567 | 01948 | 1021679 | 95759 | N00027778 | [ "H6OH15104" ] |
||||||||||||
M001166 | Jerry McNerney | M001166 | 412189 | 20702 | Jerry McNerney | Q1344743 | kg:/m/07zk65 | Jerry | McNerney | 1951-06-18 | M | 18803 | Jerry McNerney | 01832 | 1021667 | 29474 | Jerry McNerney | N00026926 | [ "H4CA11081" ] |
676 | |||||||||
Y000062 | John Yarmuth | Y000062 | 412211 | 20723 | John Yarmuth | Q699970 | kg:/m/0bb00g | John | Yarmuth | 1947-11-04 | M | 21106 | A. | John Yarmuth | 01853 | 1021662 | 58579 | John A. Yarmuth | N00028073 | [ "H6KY03124" ] |
696 | ||||||||
B001260 | Vern Buchanan | B001260 | 412196 | 20709 | Vern Buchanan | Q2517229 | kg:/m/0gtjsp | Vern | Buchanan | 1951-05-08 | M | 10419 | Vern Buchanan | 01840 | 1021626 | 66247 | Vern Buchanan | N00027626 | [ "H6FL13148" ] |
683 | |||||||||
T000468 | Dina Titus | T000468 | 412318 | 20927 | Dina Titus | Q524440 | kg:/m/07hwl2 | Dina | Titus | 1950-05-23 | F | 23215 | Dina Titus | 01940 | 1021622 | 2629 | Dina Titus | N00030191 | [ "H8NV03036" ] |
800 | |||||||||
H001040 | Phil Hare | H001040 | 412204 | 20716 | Phil Hare | Q3378787 | kg:/m/0f8dxt | Phil | Hare | 1949-02-21 | M | 15576 | 01849 | 1021566 | 66451 | N00028234 | [ "H6IL17155" ] |
||||||||||||
E000289 | Brad Ellsworth | E000289 | 412206 | 20718 | Brad Ellsworth | Q528991 | kg:/m/09fhjx | Brad | Ellsworth | 1958-09-11 | M | 12959 | 01851 | 1021550 | 57497 | N00027575 | [ "H6IN08210" ] |
||||||||||||
A000363 | Michael Arcuri | A000363 | 412224 | 20736 | Mike Arcuri | Q256130 | kg:/m/0g826p | Michael | Arcuri | 1959-06-11 | M | 8761 | A. | 01867 | 1021495 | 67657 | N00027890 | [ "H6NY24128" ] |
|||||||||||
B001256 | Michele Bachmann | B001256 | 412216 | 20728 | Michele Bachmann | Q160582 | kg:/m/06jm4y | Michele | Bachmann | 1956-04-06 | F | 10411 | Marie | Michele Bachmann | 01858 | 1021492 | 54675 | Michele Bachmann | N00027493 | [ "H6MN06074", "P20002978" ] |
701 | ||||||||
F000464 | John Faso | F000464 | 412719 | 21716 | John Faso | Q5856885 | kg:/m/0bgx6c | John | Faso | 1952-08-25 | M | John Faso | 1021406 | 4311 | John J. Faso | N00037288 | [ "H6NY19169" ] |
2231 | |||||||||||
M001168 | Patrick Murphy | M001168 | 412233 | 20745 | Patrick Murphy (Pennsylvania politician) | Q5997832 | kg:/m/085srz | Patrick | Murphy | 1973-10-19 | M | 18807 | J. | 01875 | 1021384 | 60031 | N00027594 | [ "H6PA08194" ] |
|||||||||||
P000593 | Ed Perlmutter | P000593 | 412192 | 20705 | Ed Perlmutter | Q331507 | kg:/m/07n9ns | Ed | Perlmutter | 1953-05-01 | M | 20024 | Ed Perlmutter | 01835 | 1021382 | 2653 | Ed Perlmutter | N00027510 | [ "H6CO07023" ] |
679 | |||||||||
C001069 | Joe Courtney | C001069 | 412193 | 20706 | Joe Courtney (politician) | Q434470 | kg:/m/0700nd | Joe | Courtney | 1953-04-06 | M | 11802 | Joe Courtney | 01836 | 1021284 | 30333 | Joe Courtney | N00024842 | [ "H2CT02112" ] |
680 | |||||||||
M001169 | Christopher Murphy | M001169 | 412194 | 20707 | Chris Murphy | Q1077594 | kg:/m/0cy_dh | Christopher | Murphy | 1973-08-03 | M | 18809 | S. | Christopher S. Murphy | 01837 | 1021270 | 17189 | S364 | Christopher Murphy | N00027566 | [ "H6CT05124", "S2CT00132" ] |
681 | |||||||
C001071 | Bob Corker | C001071 | 412248 | 40705 | Bob Corker | Q331719 | kg:/m/0d9fz3 | Bob | Corker | 1952-08-24 | M | Bob Corker | 01825 | 1021114 | 65905 | S310 | Bob Corker | N00027441 | [ "S6TN00216", "S4TN00187" ] |
729 | |||||||||
M001167 | Harry Mitchell | M001167 | 412187 | 20700 | Harry Mitchell | Q928861 | kg:/m/0c71k9 | Harry | Mitchell | 1940-07-18 | M | 18805 | E. | 01830 | 1021101 | 16369 | N00028162 | [ "H6AZ05067" ] |
|||||||||||
S001169 | Joe Sestak | S001169 | 412232 | 20744 | Joe Sestak | Q984183 | kg:/m/0bcy7w | Joe | Sestak | 1951-12-12 | M | 22594 | Joe Sestak | 01874 | 1020918 | 58333 | N00028049 | [ "H6PA07105" ] |
|||||||||||
E000293 | Elizabeth Esty | E000293 | 412524 | 21316 | Elizabeth Esty | Q3090454 | kg:/m/0l8ll7_ | Elizabeth | Esty | 1959-08-25 | F | 15032387067 | H. | Elzabeth Esty | 02114 | 1020906 | 72826 | Elizabeth H. Esty | N00033217 | [ "H2CT05131" ] |
1748 | ||||||||
J000288 | Henry Johnson | J000288 | 412199 | 20712 | Hank Johnson | Q983537 | kg:/m/0flgyy | Henry | Johnson | 1954-10-02 | M | 16065 | C. | Hank | Henry C. Johnson, Jr. | Jr. | 01843 | 1020576 | 68070 | Henry C. "Hank" Johnson, Jr. | N00027848 | [ "H6GA04129" ] |
686 | ||||||
B001301 | Jack Bergman | B001301 | 412709 | 21704 | Jack Bergman | Q6262116 | kg:/m/05b2l3v | Jack | Bergman | 1947-02-02 | M | Jack Bergman | 1020529 | 170172 | Jack Bergman | N00039533 | [ "H6MI01226" ] |
2221 | |||||||||||
B001259 | Bruce Braley | B001259 | 412208 | 20719 | Bruce Braley | Q966154 | kg:/m/07r9r0 | Bruce | Braley | 1957-10-30 | M | 10417 | L. | Bruce Braley | 01845 | 1020421 | 57382 | Bruce L. Braley | N00027464 | [ "H6IA01098", "S4IA00087" ] |
693 | ||||||||
J000285 | Timothy Johnson | J000285 | 400207 | 20116 | Tim Johnson (Illinois politician) | Q861115 | kg:/m/02570d | Timothy | Johnson | 1946-07-23 | M | 16059 | V. | 01648 | 1020365 | 6338 | Timothy V. Johnson | N00012890 | [ "H0IL15053" ] |
||||||||||
T000464 | Jon Tester | T000464 | 412244 | 40702 | Jon Tester | Q529351 | kg:/m/066cdp | Jon | Tester | 1956-08-21 | M | Jon Tester | 01829 | 1020176 | 20928 | S314 | Jon Tester | N00027605 | [ "S6MT00162" ] |
726 | |||||||||
R000584 | James Risch | R000584 | 412322 | 40902 | Jim Risch | Q721871 | kg:/m/06y9p0 | James | Risch | 1943-05-03 | M | E. | Jim Risch | 01896 | 1020034 | 2919 | S323 | James E. Risch | N00029441 | [ "S8ID00092" ] |
804 | ||||||||
W000800 | Peter Welch | W000800 | 412239 | 20750 | Peter Welch | Q1112656 | kg:/m/0db4gl | Peter | Welch | 1947-05-02 | M | 24183 | Peter Welch | 01879 | 1019990 | 51272 | Peter Welch | N00000515 | [ "H6VT00160", "H8VT00034" ] |
722 | |||||||||
C001098 | Ted Cruz | C001098 | 412573 | 41304 | Ted Cruz | Q2036942 | kg:/m/07j6ty | Ted | Cruz | 1970-12-22 | M | Ted Cruz | 02175 | 1019953 | 135705 | S355 | Ted Cruz | N00033085 | [ "S2TX00312" ] |
1797 | |||||||||
C001064 | John Campbell | C001064 | 412011 | 20539 | John B. T. Campbell III | Q478094 | kg:/m/07svs3 | John | Campbell | 1955-07-19 | M | 11792 | Bayard Taylor | III | 01816 | 1019004 | 29368 | John Campbell | N00027565 | [ "H6CA48039" ] |
671 | ||||||||
H001043 | Paul Hodes | H001043 | 412220 | 20732 | Paul Hodes | Q959262 | kg:/m/0d1mb3 | Paul | Hodes | 1951-03-21 | M | 15582 | W. | 01862 | 1018918 | 42473 | N00027048 | [ "H4NH02175" ] |
|||||||||||
H001075 | Kamala Harris | H001075 | 412678 | 41701 | Kamala Harris | Q10853588 | kg:/m/08sry2 | Kamala | Harris | 1964-10-20 | F | Kamala Harris | 1018696 | 120012 | S387 | Kamala D. Harris | N00036915 | [ "S6CA00584" ] |
2190 | ||||||||||
C001065 | Christopher Carney | C001065 | 412234 | 20746 | Chris Carney | Q5106098 | kg:/m/07zpt7 | Christopher | Carney | 1959-03-02 | M | 11794 | P. | 01876 | 1018516 | 60032 | N00027703 | [ "H6PA10109" ] |
|||||||||||
M001173 | Eric Massa | M001173 | 412299 | 20937 | Eric Massa | Q3365459 | kg:/m/02pcysb | Eric | Massa | 1959-09-16 | M | 18817 | J. J. | 01945 | 1018513 | 69120 | N00027550 | [ "H6NY29168" ] |
|||||||||||
W000799 | Timothy Walz | W000799 | 412214 | 20726 | Tim Walz | Q2434360 | kg:/m/06wntz | Timothy | Walz | 1964-04-06 | M | 24181 | James | Tim Walz | 01856 | 1018510 | 65443 | Timothy J. Walz | N00027467 | [ "H6MN01174" ] |
699 | ||||||||
S001164 | Jean Schmidt | S001164 | 412010 | 20540 | Jean Schmidt | Q465887 | kg:/m/06d450 | Jean | Schmidt | 1951-11-29 | F | 22585 | 01815 | 1017087 | 45475 | Jean Schmidt | N00027526 | [ "H6OH02086" ] |
|||||||||||
A000375 | Jodey Arrington | A000375 | 412726 | 21700 | Jodey Arrington | Q6207815 | kg:/m/0g9_f_1 | Jodey | Arrington | 1972-03-09 | M | C. | Jodey Arrington | 1016482 | 155685 | Jodey C. Arrington | N00038285 | [ "H6TX19099" ] |
2238 | ||||||||||
C001078 | Gerald Connolly | C001078 | 412272 | 20952 | Gerry Connolly | Q1514859 | kg:/m/04f40kn | Gerald | Connolly | 1950-03-30 | M | 11817 | E. | Gerald Connolly | 01959 | 1015936 | 95078 | Gerald E. Connolly | N00029891 | [ "H8VA11062" ] |
754 | ||||||||
S001176 | Steve Scalise | S001176 | 412261 | 20759 | Steve Scalise | Q1857141 | kg:/m/0br34c | Steve | Scalise | 1965-10-06 | M | 22608 | Joseph | Steve Scalise | 01892 | 1015311 | 9026 | Steve Scalise | N00009660 | [ "H0LA01087" ] |
742 | [ { "title": "House Majority Whip", "chamber": "house", "start": "2014-08-01", "end": "2015-01-03" }, { "title": "House Majority Whip", "chamber": "house", "start": "2015-01-06", "end": "2017-01-03" }, { "title": "House Majority Whip", "chamber": "house", "start": "2017-01-03", "end": "2019-01-03" }, { "title": "House Minority Whip", "chamber": "house", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "House Minority Whip", "chamber": "house", "start": "2021-01-03" } ] |
|||||||
R000575 | Mike Rogers | R000575 | 400341 | 20301 | Mike Rogers (Alabama politician) | Q693238 | kg:/m/024n_s | Mike | Rogers | 1958-07-16 | M | 20795 | Mike Rogers (Alabama) | 01704 | 1014740 | 5705 | Mike Rogers | N00024759 | [ "H2AL03032" ] |
433 | |||||||||
B001251 | George Butterfield | B001251 | 400616 | 20340 | G. K. Butterfield | Q983532 | kg:/m/03g_pq | George | Butterfield | 1947-04-27 | M | 10401 | Kenneth | G.K. | G.K. Butterfield | Jr. | 01761 | 1013540 | 41077 | G. K. Butterfield | N00027035 | [ "H4NC01046" ] |
624 | ||||||
G000556 | Alan Grayson | G000556 | 412276 | 20908 | Alan Grayson | Q1281084 | kg:/m/04gtp5n | Alan | Grayson | 1958-03-13 | M | 14271 | Alan Grayson | 01914 | 1013409 | 68184 | Alan Grayson | N00028418 | [ "H6FL08213" ] |
758 | |||||||||
R000578 | David Reichert | R000578 | 400660 | 20536 | Dave Reichert | Q456464 | kg:/m/03dllc | David | Reichert | 1950-08-29 | M | 20801 | G. | David Reichert | 01810 | 1013064 | 51346 | David G. Reichert | N00026885 | [ "H4WA08071" ] |
665 | ||||||||
M001159 | Cathy McMorris Rodgers | M001159 | 400659 | 20535 | Cathy McMorris Rodgers | Q293343 | kg:/m/03dlf3 | Cathy | McMorris Rodgers | 1969-05-22 | F | 18790 | Anne | Cathy McMorris Rodgers | 01809 | 1013063 | 3217 | Cathy McMorris Rodgers | N00026314 | [ "H4WA05077" ] |
664 | ||||||||
C001063 | Henry Cuellar | C001063 | 400657 | 20533 | Henry Cuellar | Q539562 | kg:/m/04clj6 | Henry | Cuellar | 1955-09-19 | M | 11790 | Henry Cuellar | 01807 | 1013062 | 5486 | Henry Cuellar | N00024978 | [ "H2TX23082" ] |
662 | |||||||||
M001158 | Kenny Marchant | M001158 | 400656 | 20532 | Kenny Marchant | Q368184 | kg:/m/04cvjb | Kenny | Marchant | 1951-02-23 | M | 18788 | Ewell | 01806 | 1013059 | 5549 | Kenny Marchant | N00026710 | [ "H4TX24094" ] |
661 | |||||||||
M001157 | Michael McCaul | M001157 | 400654 | 20530 | Michael McCaul | Q539509 | kg:/m/0492cz | Michael | McCaul | 1962-01-14 | M | 18786 | T. | Michael McCaul | 01804 | 1013056 | 49210 | Michael T. McCaul | N00026460 | [ "H4TX10093" ] |
659 | ||||||||
B001254 | Dan Boren | B001254 | 400645 | 20523 | Dan Boren | Q503580 | kg:/m/04bbc1 | Dan | Boren | 1973-08-02 | M | 10407 | 01796 | 1013053 | 46182 | Dan Boren | N00026481 | [ "H4OK02089" ] |
|||||||||||
F000450 | Virginia Foxx | F000450 | 400643 | 20521 | Virginia Foxx | Q458453 | kg:/m/02b5dz | Virginia | Foxx | 1943-06-29 | F | 13547 | Virginia Foxx | 01791 | 1013052 | 6051 | Virginia Foxx | N00026166 | [ "H4NC05146" ] |
649 | |||||||||
H001038 | Brian Higgins | H001038 | 400641 | 20519 | Brian Higgins | Q505581 | kg:/m/04fc7g | Brian | Higgins | 1959-10-06 | M | 15572 | M. | Brian Higgins | 01794 | 1013050 | 23127 | Brian Higgins | N00027060 | [ "H4NY27076" ] |
647 | ||||||||
F000449 | Jeff Fortenberry | F000449 | 400640 | 20518 | Jeff Fortenberry | Q1397331 | kg:/m/04fcch | Jeff | Fortenberry | 1960-12-27 | M | 13545 | Lane | Jeff Fortenberry | 01793 | 1013049 | 41929 | Jeff Fortenberry | N00026631 | [ "H4NE01064" ] |
646 | ||||||||
B001255 | Charles Boustany | B001255 | 400636 | 20514 | Charles Boustany | Q972735 | kg:/m/04wdx3 | Charles | Boustany | 1956-02-21 | M | 10409 | W. | Charles Boustany Jr. | Jr. | 01787 | 1013047 | 35514 | Charles W. Boustany Jr. | N00026595 | [ "H4LA07029" ] |
642 | |||||||
L000563 | Daniel Lipinski | L000563 | 400630 | 20508 | Dan Lipinski | Q518424 | kg:/m/0508fv | Daniel | Lipinski | 1966-07-15 | M | 17303 | William | Daniel Lipinski | 01781 | 1013046 | 33692 | Daniel Lipinski | N00027239 | [ "H4IL03077" ] |
636 | [ { "name": "William Oliver Lipinski", "relation": "son" } ] |
|||||||
W000796 | Lynn Westmoreland | W000796 | 400627 | 20506 | Lynn Westmoreland | Q505730 | kg:/m/04cmw9 | Lynn | Westmoreland | 1950-04-02 | M | 24175 | A. | Lynn A. Westmoreland | 01779 | 1013045 | 8001 | Lynn A. Westmoreland | N00026163 | [ "H4GA08067" ] |
633 | ||||||||
P000591 | Tom Price | P000591 | 400626 | 20505 | Tom Price (American politician) | Q1415243 | kg:/m/04z48c | Tom | Price | 1954-10-08 | M | 20020 | Tom Price (Georgia) | 01778 | 1013044 | 11853 | Tom Price | N00026160 | [ "H4GA06087" ] |
632 | |||||||||
M001155 | Connie Mack | M001155 | 400622 | 20503 | Connie Mack IV | Q973774 | kg:/m/04ffv_ | Connie | Mack | 1967-08-12 | M | 18782 | IV | 01776 | 1013040 | 53996 | Connie Mack | N00026425 | [ "H4FL14059" ] |
||||||||||
S001158 | John Salazar | S001158 | 400620 | 20502 | John Salazar | Q714956 | kg:/m/04cv8k | John | Salazar | 1953-07-21 | M | 22576 | Tony | 01775 | 1013039 | 29778 | N00026431 | [ "H4CO03167" ] |
|||||||||||
G000553 | Al Green | G000553 | 400653 | 20529 | Al Green (politician) | Q749039 | kg:/m/02kn0_ | Al | Green | 1947-09-01 | M | 14265 | Al Green | 01803 | 1012969 | 49680 | Al Green | N00026686 | [ "H4TX09095" ] |
658 | |||||||||
H001041 | Dean Heller | H001041 | 412218 | 20730 | Dean Heller | Q251763 | kg:/m/0g92xz | Dean | Heller | 1960-05-10 | M | 15578 | Dean Heller | 01863 | 1012368 | 2291 | S352 | Dean Heller | N00027522 | [ "H6NV02164", "S2NV00183" ] |
703 | ||||||||
B001252 | John Barrow | B001252 | 400628 | 20507 | John Barrow (American politician) | Q1699277 | kg:/m/056gyc | John | Barrow | 1955-10-31 | M | 10403 | John Barrow | 01780 | 1012025 | 31780 | John Barrow | N00026080 | [ "H4GA12010" ] |
634 | |||||||||
D000607 | Joe Donnelly | D000607 | 412205 | 20717 | Joe Donnelly | Q1691395 | kg:/m/0gmx64 | Joe | Donnelly | 1955-09-28 | M | 12588 | Joe Donnelly | 01850 | 1012000 | 34212 | S356 | Joe Donnelly | N00026586 | [ "H4IN02101", "S2IN00091" ] |
691 | ||||||||
M001161 | Charles Melancon | M001161 | 400635 | 20513 | Charlie Melançon | Q504241 | kg:/m/04lq4r | Charles | Melancon | 1947-10-03 | M | 18794 | J. | 01786 | 1011754 | 35601 | N00026840 | [ "H4LA03028" ] |
|||||||||||
K000393 | John Kennedy | K000393 | 412679 | 41703 | John Kennedy (Louisiana politician) | Q6250211 | kg:/m/0fl2sv | John | Kennedy | 1951-11-21 | M | Neely | John Neely Kennedy | 1011723 | 35496 | S389 | John Kennedy | N00026823 | [ "S4LA00065" ] |
2191 | |||||||||
D000603 | Geoff Davis | D000603 | 400633 | 20511 | Geoff Davis | Q546913 | kg:/m/04bb6_ | Geoff | Davis | 1958-10-26 | M | 12581 | 01784 | 1011405 | 35212 | N00024862 | [ "H2KY04071" ] |
||||||||||||
P000592 | Ted Poe | P000592 | 400652 | 20528 | Ted Poe | Q532661 | kg:/m/04928s | Ted | Poe | 1948-09-10 | M | 20022 | Ted Poe | 01802 | 1011398 | 49198 | Ted Poe | N00026457 | [ "H4TX02108" ] |
657 | |||||||||
D000604 | Charles Dent | D000604 | 400648 | 20526 | Charlie Dent | Q556034 | kg:/m/04fcm3 | Charles | Dent | 1960-05-24 | M | 12583 | W. | Charles W. Dent | 01799 | 1011395 | 9121 | Charles W. Dent | N00026171 | [ "H4PA15087" ] |
654 | ||||||||
G000552 | Louie Gohmert | G000552 | 400651 | 20527 | Louie Gohmert | Q532647 | kg:/m/0490h9 | Louie | Gohmert | 1953-08-18 | M | 14263 | B. | Louie Gohmert | Jr. | 01801 | 1011394 | 50029 | Louie Gohmert | N00026148 | [ "H4TX04039" ] |
656 | |||||||
N000182 | Randy Neugebauer | N000182 | 400441 | 20353 | Randy Neugebauer | Q539536 | kg:/m/03tn5k | Randy | Neugebauer | 1949-12-24 | M | 19060 | Randy Neugebauer | 01758 | 1010920 | 49522 | Randy Neugebauer | N00026043 | [ "H4TX19102" ] |
526 | |||||||||
C001058 | Ben Chandler | C001058 | 400442 | 20326 | Ben Chandler | Q816460 | kg:/m/02tvfc | Ben | Chandler | 1959-09-12 | M | 11780 | 01759 | 1007734 | 1891 | Ben Chandler | N00026591 | [ "H4KY06072" ] |
|||||||||||
C001045 | Ander Crenshaw | C001045 | 400086 | 20111 | Ander Crenshaw | Q490511 | kg:/m/0251y2 | Ander | Crenshaw | 1944-09-01 | M | 11758 | Ander Crenshaw | 01643 | 1007679 | 31130 | Ander Crenshaw | N00012739 | [ "H0FL04066" ] |
200 | |||||||||
M001156 | Patrick McHenry | M001156 | 400644 | 20522 | Patrick McHenry | Q2057809 | kg:/m/02b4rz | Patrick | McHenry | 1975-10-22 | M | 18784 | T. | Patrick T. McHenry | 01792 | 1007062 | 21031 | Patrick T. McHenry | N00026627 | [ "H4NC10047" ] |
650 | ||||||||
C001062 | K. Conaway | C001062 | 400655 | 20531 | Mike Conaway | Q538944 | kg:/m/04cmt7 | K. | Conaway | 1948-06-11 | M | 11788 | Michael | Mike Conaway | 01805 | 1004595 | 49935 | K. Michael Conaway | N00026041 | [ "H4TX19136", "H3TX19021" ] |
660 | ||||||||
C001051 | John Carter | C001051 | 400068 | 20356 | John Carter (Texas politician) | Q369814 | kg:/m/04m7rg | John | Carter | 1941-11-06 | M | 11770 | R. | John Carter | 01752 | 1004257 | 49296 | John R. Carter | N00025095 | [ "H2TX31044" ] |
185 | ||||||||
A000361 | Rodney Alexander | A000361 | 400006 | 90327 | Rodney Alexander | Q504508 | kg:/m/025jxc | Rodney | Alexander | 1946-12-05 | M | 8757 | M. | Rodney Alexander | 01727 | 1004256 | 4545 | Rodney Alexander | N00025464 | [ "H2LA05084" ] |
129 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [legislators] ( [id] TEXT PRIMARY KEY, [name] TEXT, [id_bioguide] TEXT, [id_govtrack] INTEGER, [id_icpsr] INTEGER, [id_wikipedia] TEXT, [id_wikidata] TEXT, [id_google_entity_id] TEXT, [name_first] TEXT, [name_last] TEXT, [bio_birthday] TEXT, [bio_gender] TEXT , [id_house_history] INTEGER, [name_middle] TEXT, [name_nickname] TEXT, [id_ballotpedia] TEXT, [name_suffix] TEXT, [id_bioguide_previous] TEXT, [id_house_history_alternate] INTEGER, [other_names] TEXT, [id_thomas] TEXT, [id_cspan] INTEGER, [id_votesmart] INTEGER, [id_lis] TEXT, [name_official_full] TEXT, [id_opensecrets] TEXT, [id_fec] TEXT, [id_maplight] INTEGER, [leadership_roles] TEXT, [family] TEXT);