legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by id_icpsr
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
N000026 | Troy Nehls | N000026 | 456848 | Troy Nehls | Q96741441 | kg:/g/11c580_xf2 | Troy | Nehls | 1968-04-07 | M | E. | Troy Nehls | 188334 | Troy E. Nehls | N00046067 | [ "H0TX22302" ] |
|||||||||||||
N000147 | Eleanor Norton | N000147 | 400295 | Eleanor Holmes Norton | Q461649 | kg:/m/01s_vp | Eleanor | Norton | 1937-06-13 | F | 19016 | Holmes | 00868 | 882 | 775 | Eleanor Holmes Norton | N00001692 | [ "H0DC00058" ] |
390 | ||||||||||
N000166 | Stephen Nuckolls | N000166 | 408247 | Stephen Friel Nuckolls | Q2344723 | kg:/m/02rjzgf | Stephen | Nuckolls | 1825-08-16 | M | 19039 | Friel | |||||||||||||||||
N000192 | Marie Newman | N000192 | 456819 | Marie Newman | Q47960940 | kg:/g/11f4yffn3m | Marie | Newman | 1964-04-13 | F | Marie Newman | N00040891 | [ "H8IL03102" ] |
||||||||||||||||
O000019 | Jay Obernolte | O000019 | 456801 | Jay Obernolte | Q16849797 | kg:/m/02hpvtf | Jay | Obernolte | 1970-08-18 | M | Phillip | Jay Obernolte | Jay Obernolte | N00045377 | [ "H0CA08135" ] |
||||||||||||||
O000020 | Pablo Ocampo | O000020 | 408318 | Pablo Ocampo | Q1944880 | kg:/m/0cdxsp | Pablo | Ocampo | 1853-01-25 | M | 19093 | ||||||||||||||||||
O000086 | Clarence Owens | O000086 | 456852 | Burgess Owens | Q4998602 | kg:/m/0286z2f | Clarence | Owens | 1951-08-02 | M | Burgess | Burgess Owens | Burgess Owens | N00045812 | [ "H0UT04076" ] |
||||||||||||||
O000118 | Camilo Osias | O000118 | 408373 | Camilo Osías | Q117832 | kg:/m/0cqmby | Camilo | Osias | 1889-03-23 | M | 19211 | ||||||||||||||||||
O000124 | Mariano Otero | O000124 | 408377 | Mariano S. Otero | Q1897010 | kg:/m/02rjx56 | Mariano | Otero | 1844-08-29 | M | 19217 | Sabino | |||||||||||||||||
O000125 | Miguel Otero | O000125 | 408378 | Miguel Antonio Otero (born 1829) | Q1932568 | kg:/m/05yd_7 | Miguel | Otero | 1829-06-21 | M | 19218 | Antonio | |||||||||||||||||
O000135 | Granville Oury | O000135 | 408387 | Granville Henderson Oury | Q1543279 | kg:/m/06s5rb | Granville | Oury | 1825-03-12 | M | 19233 | Henderson | |||||||||||||||||
O000174 | Jon Ossoff | O000174 | 456857 | Jon Ossoff | Q28839536 | Jon | Ossoff | 1987-02-16 | M | Jon Ossoff | S414 | Jon Ossoff | N00040675 | [ "H8GA06195", "S8GA00180" ] |
|||||||||||||||
P000013 | Bolívar Pagán | P000013 | 408424 | Bolívar Pagán | Q1619179 | kg:/m/094x18 | Bolívar | Pagán | 1897-05-16 | M | 19298 | ||||||||||||||||||
P000048 | August Pfluger | P000048 | 456846 | August Pfluger | Q101196462 | kg:/g/11f3szpd4x | August | Pfluger | 1978-12-28 | M | Lee | II | August Pfluger | N00045421 | [ "H0TX11230" ] |
||||||||||||||
P000050 | Quintin Paredes | P000050 | 408460 | Quintín Paredes | Q161861 | kg:/m/0cv3k4 | Quintin | Paredes | 1884-09-09 | M | 19339 | ||||||||||||||||||
P000052 | Benjamin Parke | P000052 | 408462 | Benjamin Parke | Q817644 | kg:/m/09tr42 | Benjamin | Parke | 1777-09-22 | M | 19341 | ||||||||||||||||||
P000085 | Marcus Parrott | P000085 | 408495 | Marcus Junius Parrott | Q1894216 | kg:/m/0g2jvq | Marcus | Parrott | 1828-10-27 | M | 19377 | Junius | |||||||||||||||||
P000145 | Alejandro Padilla | P000145 | 456856 | Alex Padilla | Q4717593 | Alejandro | Padilla | 1973-03-22 | M | Alex | Alex Padilla | S413 | Alex Padilla | N00047888 | [ "S2CA00955" ] |
||||||||||||||
P000224 | Francisco Perea | P000224 | 408627 | Francisco Perea | Q1384732 | kg:/m/02rhg7h | Francisco | Perea | 1830-01-09 | M | 19555 | ||||||||||||||||||
P000225 | Pedro Perea | P000225 | 408628 | Pedro Perea | Q1727668 | kg:/m/02rjxz9 | Pedro | Perea | 1852-04-22 | M | 19556 | ||||||||||||||||||
P000249 | José Pesquera | P000249 | 408652 | José Lorenzo Pesquera | Q1457685 | kg:/m/02rlcl7 | José | Pesquera | 1882-08-10 | M | 19585 | Lorenzo | |||||||||||||||||
P000361 | Jesús Piñero | P000361 | 408757 | Jesús T. Piñero | Q331345 | kg:/m/03tphz | Jesús | Piñero | 1897-04-16 | M | 19726 | T. | |||||||||||||||||
P000405 | Santiago Polanco-Abreu | P000405 | 408798 | Santiago Polanco-Abreu | Q1726886 | kg:/m/02rlcll | Santiago | Polanco-Abreu | 1920-10-30 | M | 19781 | ||||||||||||||||||
P000432 | Nathaniel Pope | P000432 | 408823 | Nathaniel Pope | Q4098442 | kg:/m/04xhcd | Nathaniel | Pope | 1784-01-05 | M | 19818 | ||||||||||||||||||
P000456 | Morton Post | P000456 | 408843 | Morton Everel Post | Q1718292 | kg:/m/02rjxd2 | Morton | Post | 1840-12-25 | M | 19846 | Everel | |||||||||||||||||
P000458 | Charles Poston | P000458 | 408845 | Charles Debrille Poston | Q1064080 | kg:/m/02rhd3s | Charles | Poston | 1825-04-20 | M | 19849 | Debrille | |||||||||||||||||
P000493 | Julien Poydras | P000493 | 408878 | Julien de Lallande Poydras | Q1712278 | kg:/m/01t00g | Julien | Poydras | 1740-04-03 | M | 19890 | de Lallande | |||||||||||||||||
P000596 | Pedro Pierluisi | P000596 | 412306 | Pedro Pierluisi | Q2277878 | kg:/m/02r7csl | Pedro | Pierluisi | 1959-04-26 | M | 20030 | R. | 01953 | 1031305 | 110894 | Pedro R. Pierluisi | N00029168 | [ "H8PR00062" ] |
788 | ||||||||||
P000610 | Stacey Plaskett | P000610 | 412659 | Stacey Plaskett | Q18739104 | kg:/m/012844_c | Stacey | Plaskett | 1966-05-13 | F | 15032410230 | E. | 02274 | 79090 | 155929 | Stacey E. Plaskett | N00035000 | [ "H2VI00082" ] |
2115 | ||||||||||
P000619 | Mary Peltola | P000619 | 456870 | Mary Peltola | Q13562231 | Mary | Peltola | 1973-08-31 | F | Sattler | Mary Peltola | Mary Sattler Peltola | N00050780 | [ "H2AK01158" ] |
|||||||||||||||
Q000009 | Manuel Quezon | Q000009 | 408972 | Manuel L. Quezon | Q1503 | kg:/m/015865 | Manuel | Quezon | 1878-08-19 | M | 20053 | Luis | |||||||||||||||||
R000085 | John Raymond | R000085 | 409065 | John B. Raymond | Q764272 | kg:/m/01s_sy | John | Raymond | 1844-12-05 | M | 20187 | Baldwin | |||||||||||||||||
R000103 | Matthew Rosendale | R000103 | 456830 | Matt Rosendale | Q6791163 | kg:/m/0j260rd | Matthew | Rosendale | 1960-07-07 | M | Martin | Matthew Rosendale | Sr. | 120815 | Matthew M. Rosendale, Sr. | N00035517 | [ "H4MT00050" ] |
||||||||||||
R000210 | Gabriel Richard | R000210 | 409186 | Gabriel Richard | Q1489605 | kg:/m/08p9zy | Gabriel | Richard | 1767-10-15 | M | 20343 | ||||||||||||||||||
R000279 | Luis Rivera | R000279 | 409253 | Luis Muñoz Rivera | Q734445 | kg:/m/036jqd | Luis | Rivera | 1859-07-17 | M | 20429 | Muñoz | |||||||||||||||||
R000294 | Charles Roark | R000294 | 409267 | Charles W. Roark | Q1066360 | kg:/m/02rhdlk | Charles | Roark | 1887-01-22 | M | 20449 | Wickliffe | |||||||||||||||||
R000305 | Deborah Ross | R000305 | 456831 | Deborah K. Ross | Q5248285 | kg:/m/02b3x2 | Deborah | Ross | 1963-06-20 | F | Koff | Deborah Ross | Deborah K. Ross | N00038565 | [ "H0NC02125" ] |
||||||||||||||
R000372 | Bernard Rodey | R000372 | 409342 | Bernard Shandon Rodey | Q822703 | kg:/m/05ydhq | Bernard | Rodey | 1856-03-01 | M | 20542 | Shandon | |||||||||||||||||
R000416 | Trinidad Romero | R000416 | 409382 | Trinidad Romero | Q2453462 | kg:/m/02rk0dp | Trinidad | Romero | 1835-06-15 | M | 20601 | ||||||||||||||||||
R000417 | Carlos Romero-Barceló | R000417 | 400615 | Carlos Romero Barceló | Q2183412 | kg:/m/0p9vw | Carlos | Romero-Barceló | 1932-09-04 | M | 20602 | 00980 | |||||||||||||||||
R000419 | Carlos Romulo | R000419 | 409384 | Carlos P. Romulo | Q737664 | kg:/m/02_bfn | Carlos | Romulo | 1899-01-14 | M | 20605 | Peña | |||||||||||||||||
R000579 | Patrick Ryan | R000579 | 456871 | Pat Ryan (politician) | Q113587887 | Patrick | Ryan | 1982-03-28 | M | Pat Ryan (New York) | Patrick Ryan | N00041165 | [ "H8NY19223" ] |
||||||||||||||||
R000600 | Aumua Amata Radewagen | R000600 | 412664 | Amata Coleman Radewagen | Q18684027 | kg:/m/012964p3 | Aumua Amata | Radewagen | 1947-12-29 | F | 15032412349 | Coleman | Amata Radewagen | 02222 | 5188 | 128380 | Aumua Amata Coleman Radewagen | N00007635 | [ "H4AS00036" ] |
2120 | |||||||||
S000049 | John Sanford | S000049 | 409565 | John W. A. Sanford | Q1674403 | kg:/m/0279xfg | John | Sanford | 1798-08-28 | M | 21192 | W.A. | |||||||||||||||||
S000168 | Maria Salazar | S000168 | 456810 | Maria Elvira Salazar | Q6003715 | kg:/g/1hb_g7r18 | Maria | Salazar | 1961-11-01 | F | Elvira | 182300 | Maria Elvira Salazar | N00042810 | [ "H8FL27185" ] |
||||||||||||||
S000276 | Jacob Shafer | S000276 | 409775 | Jacob K. Shafer | Q1677538 | kg:/m/02rhj08 | Jacob | Shafer | 1823-12-26 | M | 21478 | K. | |||||||||||||||||
S000396 | Henry Sibley | S000396 | 409890 | Henry Hastings Sibley | Q880319 | kg:/m/01l6xh | Henry | Sibley | 1811-02-20 | M | 21631 | Hastings | |||||||||||||||||
S000400 | Solomon Sibley | S000400 | 409894 | Solomon Sibley | Q991360 | kg:/m/03pksm | Solomon | Sibley | 1769-10-07 | M | 21635 | ||||||||||||||||||
S000443 | Theodore Singiser | S000443 | 409937 | Theodore Frelinghuysen Singiser | Q1654434 | kg:/m/02rjzlk | Theodore | Singiser | 1845-03-15 | M | 21690 | Frelinghuysen | |||||||||||||||||
S000446 | Thomas Singleton | S000446 | 412096 | Thomas D. Singleton | Q2423319 | kg:/m/02w14gt | Thomas | Singleton | M | 21694 | Day | ||||||||||||||||||
S000587 | Linda Smith | S000587 | 410067 | Linda Smith (American politician) | Q435239 | kg:/m/04wysl | Linda | Smith | 1950-07-16 | F | 21861 | 01078 | |||||||||||||||||
S000736 | Solomon Spink | S000736 | 410205 | Solomon L. Spink | Q477194 | kg:/m/01s_t8 | Solomon | Spink | 1831-03-20 | M | 22047 | Lewis | |||||||||||||||||
S000840 | William Steele | S000840 | 410304 | William Randolph Steele | Q1393108 | kg:/m/02rj_yx | William | Steele | 1842-07-24 | M | 22178 | Randolph | |||||||||||||||||
S000862 | Benjamin Stephenson | S000862 | 412106 | Benjamin Stephenson (politician) | Q817696 | kg:/m/09jn0g | Benjamin | Stephenson | M | 22205 | |||||||||||||||||||
S000880 | Hiram Stevens | S000880 | 410342 | Hiram Sanford Stevens | Q1620134 | kg:/m/02rhhmh | Hiram | Stevens | 1832-03-20 | M | 22227 | Sanford | |||||||||||||||||
S000881 | Isaac Stevens | S000881 | 410343 | Isaac Stevens | Q888719 | kg:/m/029n3n | Isaac | Stevens | 1818-03-25 | M | 22228 | Ingalls | |||||||||||||||||
S000929 | Victoria Spartz | S000929 | 456822 | Victoria Spartz | Q44059867 | kg:/g/11h23hjb94 | Victoria | Spartz | 1978-10-06 | F | Victoria Spartz | N00046537 | [ "H0IN05326" ] |
||||||||||||||||
S001064 | Charles Sulzer | S001064 | 410518 | Charles August Sulzer | Q1063605 | kg:/m/0drqrk | Charles | Sulzer | 1879-02-24 | M | 22453 | August | |||||||||||||||||
S001077 | Fofó Sunia | S001077 | 410531 | Fofō Iosefa Fiti Sunia | Q3880333 | kg:/m/01s_jg | Fofó | Sunia | 1937-03-13 | M | 22470 | Iosefa Fiti | 01126 | ||||||||||||||||
S001079 | Daniel Sutherland | S001079 | 410532 | Daniel Sutherland | Q1162848 | kg:/m/05mgnm | Daniel | Sutherland | 1869-04-17 | M | 22473 | Alexander | |||||||||||||||||
S001135 | Michelle Steel | S001135 | 456803 | Michelle Steel | Q6837200 | kg:/m/028bz6v | Michelle | Steel | 1955-06-21 | F | Eunjoo | Michelle Steel | N00044501 | [ "H0CA48198" ] |
|||||||||||||||
S001159 | Marilyn Strickland | S001159 | 456854 | Marilyn Strickland | Q1898180 | kg:/m/0bhb38l | Marilyn | Strickland | 1962-09-25 | F | Marilyn Strickland | N00046320 | [ "H0WA10034" ] |
||||||||||||||||
S001177 | Gregorio Sablan | S001177 | 412312 | Gregorio Sablan | Q3116336 | kg:/m/04ycmvy | Gregorio | Sablan | 1955-01-19 | M | 22610 | Kilili Camacho | 01962 | 1031366 | 110903 | Gregorio Kilili Camacho Sablan | N00030418 | [ "H8MP00041" ] |
794 | ||||||||||
S001204 | Michael San Nicolas | S001204 | 412770 | Michael San Nicolas | Q16221559 | kg:/m/0wy0mjt | Michael | San Nicolas | 1981-01-30 | M | F. Q. | Michael F. Q. San Nicolas | N00042619 | [ "H8GU01020" ] |
|||||||||||||||
S001218 | Melanie Stansbury | S001218 | 456861 | Melanie Stansbury | Q96184996 | Melanie | Stansbury | 1979-01-31 | F | Ann | Melanie Ann Stansbury | Melanie A. Stansbury | N00047871 | [ "H2NM01144" ] |
|||||||||||||||
S001219 | Joseph Sempolinski | S001219 | 456872 | Joe Sempolinski | Q113588013 | Joseph | Sempolinski | 1982-02-10 | M | Joe Sempolinski | Joseph Sempolinski | N00048747 | [ "H2NY23137" ] |
||||||||||||||||
T000008 | Kingsley Taft | T000008 | 410598 | Kingsley A. Taft | Q1742148 | kg:/m/034tqb | Kingsley | Taft | 1903-07-19 | M | Arter | ||||||||||||||||||
T000130 | James Terrell | T000130 | 410712 | James C. Terrell | Q1471732 | kg:/m/0279xjk | James | Terrell | 1806-11-07 | M | 22791 | C. | |||||||||||||||||
T000165 | Thomas Tiffany | T000165 | 456791 | Tom Tiffany | Q7817838 | Thomas | Tiffany | 1957-12-30 | M | P. | Tom Tiffany | Thomas P. Tiffany | N00045307 | [ "H0WI07101" ] |
|||||||||||||||
T000258 | Samuel Thurston | T000258 | 410833 | Samuel Thurston | Q2218900 | kg:/m/03bcbl | Samuel | Thurston | 1816-04-15 | M | 22947 | Royal | |||||||||||||||||
T000278 | Tommy Tuberville | T000278 | 456796 | Tommy Tuberville | Q7819948 | kg:/m/04tmr4 | Tommy | Tuberville | 1954-09-18 | M | Hawley | Tommy Tuberville | 188306 | S412 | Tommy Tuberville | N00044434 | [ "S0AL00230" ] |
||||||||||||
T000292 | John Todd | T000292 | 410865 | John Blair Smith Todd | Q1699347 | kg:/m/09g52m | John | Todd | 1814-04-04 | M | 22988 | Blair Smith | |||||||||||||||||
T000312 | Joseph Toole | T000312 | 410885 | Joseph Toole | Q367760 | kg:/m/0bfps5 | Joseph | Toole | 1851-05-12 | M | 23012 | Kemp | |||||||||||||||||
T000438 | Selah Tuthill | T000438 | 411006 | Selah Tuthill | Q82465 | kg:/m/02rkwdy | Selah | Tuthill | 1771-10-26 | M | 23172 | ||||||||||||||||||
T000441 | John Tweedy | T000441 | 411009 | John Hubbard Tweedy | Q1700519 | kg:/m/0b6tnv | John | Tweedy | 1814-11-09 | M | 23175 | Hubbard | |||||||||||||||||
T000473 | Mark Takai | T000473 | 412626 | Mark Takai | Q16197299 | kg:/m/0yp0gs4 | Mark | Takai | 1967-07-01 | M | 02240 | Mark Takai | N00035535 | [ "H4HI01134" ] |
2082 | ||||||||||||||
T000486 | Ritchie Torres | T000486 | 456838 | Ritchie Torres | Q16205227 | kg:/m/0x11h9s | Ritchie | Torres | 1988-03-12 | M | John | Ritchie Torres | Ritchie Torres | N00044346 | [ "H0NY15160" ] |
||||||||||||||
U000014 | Robert Underwood | U000014 | 400516 | Robert A. Underwood | Q2156310 | kg:/m/01s_y0 | Robert | Underwood | 1948-07-13 | M | 20846 | A. | 01175 | ||||||||||||||||
V000115 | Charles Voorhees | V000115 | 411169 | Charles Stewart Voorhees | Q1066155 | kg:/m/02rhdjv | Charles | Voorhees | 1853-06-04 | M | 21014 | Stewart | |||||||||||||||||
V000134 | Beth Van Duyne | V000134 | 456850 | Beth Van Duyne | Q66309702 | kg:/m/0k1c6d8 | Beth | Van Duyne | 1970-11-16 | F | Ann | Beth Van Duyne | 79150 | Beth Van Duyne | N00045167 | [ "H0TX24209" ] |
|||||||||||||
W000086 | William Wallace | W000086 | 411265 | William H. Wallace | Q889378 | kg:/m/0d3mvd | William | Wallace | 1811-07-19 | M | 23315 | Henson | |||||||||||||||||
W000184 | Frank Waskey | W000184 | 411357 | Frank Hinman Waskey | Q1443435 | kg:/m/0drqqw | Frank | Waskey | 1875-04-20 | M | 23433 | Hinman | |||||||||||||||||
W000213 | John Watts | W000213 | 411382 | John Sebrie Watts | Q1701708 | kg:/m/02rhkjr | John | Watts | 1816-01-19 | M | 23471 | Sebrie | |||||||||||||||||
W000255 | Richard Weightman | W000255 | 411423 | Richard Hanson Weightman | Q2149708 | kg:/m/02rjy9_ | Richard | Weightman | 1816-12-28 | M | 23522 | Hanson | |||||||||||||||||
W000377 | James White | W000377 | 411538 | James White (North Carolina politician) | Q532708 | kg:/m/06t1db | James | White | 1749-06-16 | M | 23662 | ||||||||||||||||||
W000383 | Joseph White | W000383 | 411543 | Joseph M. White | Q1355238 | kg:/m/0b1pzj | Joseph | White | 1781-05-10 | M | 23669 | M. | |||||||||||||||||
W000414 | John Whitfield | W000414 | 411573 | John Wilkins Whitfield | Q1702157 | kg:/m/0g2jgz | John | Whitfield | 1818-03-11 | M | 23705 | Wilkins | |||||||||||||||||
W000438 | James Wickersham | W000438 | 411596 | James Wickersham | Q1681295 | kg:/m/05ghs8 | James | Wickersham | 1857-08-24 | M | 23735 | ||||||||||||||||||
W000459 | Robert Wilcox | W000459 | 411616 | Robert William Wilcox | Q1133170 | kg:/m/03d75x | Robert | Wilcox | 1855-02-15 | M | 23764 | William | |||||||||||||||||
W000523 | Jonathan Williams | W000523 | 411680 | Jonathan Williams (engineer) | Q6274789 | kg:/m/0631j1 | Jonathan | Williams | 1750-05-20 | M | 23837 | ||||||||||||||||||
W000599 | John Wilson | W000599 | 411754 | John Frank Wilson | Q1525522 | kg:/m/02rhk1z | John | Wilson | 1846-05-07 | M | 23927 | Frank | |||||||||||||||||
W000631 | Austin Wing | W000631 | 411785 | Austin Eli Wing | Q781074 | kg:/m/026vz6l | Austin | Wing | 1792-02-03 | M | 23965 | Eli | |||||||||||||||||
W000686 | Antonio Won Pat | W000686 | 411838 | Antonio Borja Won Pat | Q600957 | kg:/m/01s_z9 | Antonio | Won Pat | 1908-12-10 | M | 24034 | Borja | 01241 | ||||||||||||||||
W000788 | Nikema Williams | W000788 | 456811 | Nikema Williams | Q56486570 | kg:/g/11fctqx0jy | Nikema | Williams | 1978-07-30 | F | Natassha | Nikema Williams | Nikema Williams | N00047361 | [ "H0GA05301" ] |
||||||||||||||
W000790 | Raphael Warnock | W000790 | 456858 | Raphael Warnock | Q84146599 | Raphael | Warnock | 1969-07-23 | M | Gamaliel | Raphael Warnock | S415 | Raphael G. Warnock | N00046489 | [ "S0GA00559" ] |
||||||||||||||
W000818 | John Walsh | W000818 | 412602 | John Walsh (Montana politician) | Q6262874 | kg:/m/0nbx8tv | John | Walsh | 1960-11-03 | M | E. | 02198 | 73846 | 111027 | S371 | John E. Walsh | N00035686 | [ "S4MT00118" ] |
2055 | ||||||||||
Y000004 | Teodoro Yangco | Y000004 | 411938 | Teodoro R. Yangco | Q2308718 | kg:/m/0chrl_ | Teodoro | Yangco | 1861-11-09 | M | 21037 | Rafael | |||||||||||||||||
Y000067 | Rudy Yakym | Y000067 | 456873 | Rudy Yakym | Q115137719 | Rudy | Yakym | 1984-02-24 | M | Rudy Yakym | 210545 | [ "H2IN02295" ] |
|||||||||||||||||
Z000018 | Ryan Zinke | Z000018 | 412640 | Ryan Zinke | Q7384672 | kg:/m/0gkz1jg | Ryan | Zinke | 1961-11-01 | M | 02254 | 104073 | Ryan K. Zinke | N00035616 | [ "H4MT01041" ] |
2096 | |||||||||||||
A000001 | Fred Aandahl | A000001 | 400664 | 1 | Fred G. Aandahl | Q882579 | kg:/m/01grlf | Fred | Aandahl | 1897-04-09 | M | 8247 | George |
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);