legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by id_bioguide_previous descending
This data as json, copyable, CSV (advanced)
id_fec (array) >30 ✖
- H0AR03055 1
- H0FL08208 1
- H0FL17068 1
- H0GA05301 1
- H0GA07133 1
- H0IL08090 1
- H0IN02190 1
- H0IN09070 1
- H0KS03137 1
- H0OR03026 1
- H2CA01045 1
- H2CA32099 1
- H2FL06109 1
- H2IN02295 1
- H2MD05361 1
- H2MO02102 1
- H2NC12021 1
- H2OH02085 1
- H2SC02059 1
- H2TN03052 1
- H2TX14149 1
- H2TX33040 1
- H4AR04048 1
- H4CA23011 1
- H4CA45097 1
- H4FL15114 1
- H4FL20023 1
- H4GA08067 1
- H4IA03115 1
- H4IL11096 1
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
W000052 | Freeman Walker | W000052 | 411231 | 9740 | Freeman Walker | Q1260033 | kg:/m/0bj08p | Freeman | Walker | 1780-10-25 | M | ||||||||||||||||||
W000053 | George Walker | W000053 | 411232 | 9741 | George Walker (Kentucky politician) | Q1508496 | kg:/m/0c16f2 | George | Walker | M | |||||||||||||||||||
W000054 | Gilbert Walker | W000054 | 411233 | 9742 | Gilbert Carlton Walker | Q667935 | kg:/m/05bybg | Gilbert | Walker | 1833-08-01 | M | 23279 | Carlton | ||||||||||||||||
W000055 | Isaac Walker | W000055 | 411234 | 9743 | Isaac P. Walker | Q576915 | kg:/m/091t32 | Isaac | Walker | 1815-11-02 | M | Pigeon | |||||||||||||||||
W000056 | James Walker | W000056 | 411235 | 9744 | James A. Walker | Q1679906 | kg:/m/0cwhmt | James | Walker | 1832-08-27 | M | 23282 | Alexander | ||||||||||||||||
W000057 | James Walker | W000057 | 411236 | 9745 | James D. Walker | Q1680245 | kg:/m/09sjcw | James | Walker | 1830-12-13 | M | David | |||||||||||||||||
W000058 | James Walker | W000058 | 411237 | 9746 | James P. Walker | Q1677076 | kg:/m/02rz6_y | James | Walker | 1851-03-14 | M | 23284 | Peter | ||||||||||||||||
W000059 | John Walker | W000059 | 411238 | 9747 | John Walker (Virginia politician) | Q450549 | kg:/m/03zy19 | John | Walker | 1744-02-13 | M | 23286 | |||||||||||||||||
W000060 | John Walker | W000060 | 411239 | 9748 | John Randall Walker | Q1701521 | kg:/m/026z798 | John | Walker | 1874-02-23 | M | 23287 | Randall | ||||||||||||||||
W000061 | John Walker | W000061 | 411240 | 9749 | John Williams Walker | Q512509 | kg:/m/03gb0x | John | Walker | 1783-08-12 | M | Williams | |||||||||||||||||
W000062 | Joseph Walker | W000062 | 411241 | 9750 | Joseph H. Walker | Q599362 | kg:/m/026n85j | Joseph | Walker | 1829-12-21 | M | 23290 | Henry | ||||||||||||||||
W000063 | Lewis Walker | W000063 | 411242 | 9751 | Lewis L. Walker | Q1724709 | kg:/m/02rjx1f | Lewis | Walker | 1873-02-15 | M | 23291 | Leavell | ||||||||||||||||
W000064 | Percy Walker | W000064 | 411243 | 9752 | Percy Walker | Q2070321 | kg:/m/0dtqnz | Percy | Walker | M | 23292 | ||||||||||||||||||
W000065 | Prentiss Walker | W000065 | 411244 | 10781 | Prentiss Walker | Q778666 | kg:/m/03s8d4 | Prentiss | Walker | 1917-08-23 | M | 23293 | Lafayette | ||||||||||||||||
W000066 | Robert Walker | W000066 | 411245 | 9754 | Robert Jarvis Cochran Walker | Q7346066 | kg:/m/0ks_rk | Robert | Walker | 1838-10-20 | M | 23294 | Jarvis Cochran | ||||||||||||||||
W000067 | Robert Walker | W000067 | 411246 | 9753 | Robert J. Walker | Q879106 | kg:/m/039kpr | Robert | Walker | 1801-07-19 | M | John | |||||||||||||||||
W000068 | Robert Walker | W000068 | 411247 | 14461 | Robert Smith Walker | Q7349894 | kg:/m/03vln1 | Robert | Walker | 1942-12-23 | M | 23297 | Smith | 01196 | |||||||||||||||
W000069 | Walter Walker | W000069 | 411248 | 9755 | Walter Walker (politician) | Q1438226 | kg:/m/0cvj70 | Walter | Walker | 1883-04-03 | M | ||||||||||||||||||
W000070 | William Walker | W000070 | 411249 | 9756 | William Adams Walker | Q1156088 | kg:/m/02rkxsy | William | Walker | 1805-06-05 | M | 23299 | Adams | ||||||||||||||||
W000071 | Garret Wall | W000071 | 411250 | 9757 | Garret D. Wall | Q1432382 | kg:/m/0csns5 | Garret | Wall | 1783-03-10 | M | Dorset | |||||||||||||||||
W000072 | James Wall | W000072 | 411251 | 9758 | James Walter Wall | Q6145105 | kg:/m/0b28lb | James | Wall | 1820-05-26 | M | Walter | |||||||||||||||||
W000073 | William Wall | W000073 | 411252 | 9759 | William Wall (New York politician) | Q759133 | kg:/m/02rlckk | William | Wall | 1800-03-20 | M | 23302 | |||||||||||||||||
W000074 | Alexander Wallace | W000074 | 411253 | 9760 | Alexander S. Wallace | Q1458662 | kg:/m/02vp018 | Alexander | Wallace | 1810-12-30 | M | 23303 | Stuart | ||||||||||||||||
W000075 | Daniel Wallace | W000075 | 411254 | 9761 | Daniel Wallace (politician) | Q174093 | kg:/m/02vp007 | Daniel | Wallace | 1801-05-09 | M | 23304 | |||||||||||||||||
W000076 | David Wallace | W000076 | 411255 | 9762 | David Wallace (Indiana politician) | Q1177056 | kg:/m/05xwcf | David | Wallace | 1799-04-24 | M | 23305 | |||||||||||||||||
W000078 | James Wallace | W000078 | 411257 | 9764 | James M. Wallace | Q6138596 | kg:/m/027kzw9 | James | Wallace | M | 23307 | M. | |||||||||||||||||
W000079 | John Wallace | W000079 | 411258 | 9765 | John Winfield Wallace | Q6264603 | kg:/m/0kt1k5 | John | Wallace | 1818-12-20 | M | 23308 | Winfield | ||||||||||||||||
W000080 | Jonathan Wallace | W000080 | 411259 | 9766 | Jonathan H. Wallace | Q1413237 | kg:/m/0bzvnv | Jonathan | Wallace | 1824-10-31 | M | 23309 | Hasson | ||||||||||||||||
W000081 | Nathaniel Wallace | W000081 | 411260 | 9767 | Nathaniel D. Wallace | Q1966728 | kg:/m/02rtmm3 | Nathaniel | Wallace | 1845-10-27 | M | 23310 | Dick | ||||||||||||||||
W000082 | Robert Wallace | W000082 | 411261 | 9768 | Robert M. Wallace | Q386136 | kg:/m/02rjyrd | Robert | Wallace | 1856-08-06 | M | 23311 | Minor | ||||||||||||||||
W000083 | Rodney Wallace | W000083 | 411262 | 9769 | Rodney Wallace (Massachusetts politician) | Q1537230 | kg:/m/02rlzk1 | Rodney | Wallace | 1823-12-21 | M | 23312 | |||||||||||||||||
W000084 | William Wallace | W000084 | 411263 | 9770 | William A. Wallace | Q176510 | kg:/m/08nzps | William | Wallace | 1827-11-28 | M | Andrew | |||||||||||||||||
W000085 | William Wallace | W000085 | 411264 | 9771 | William C. Wallace | Q404485 | kg:/m/02rkxw0 | William | Wallace | 1856-05-21 | M | 23314 | Copeland | ||||||||||||||||
W000086 | William Wallace | W000086 | 411265 | William H. Wallace | Q889378 | kg:/m/0d3mvd | William | Wallace | 1811-07-19 | M | 23315 | Henson | |||||||||||||||||
W000087 | Samuel Walley | W000087 | 411266 | 9773 | Samuel H. Walley | Q2218339 | kg:/m/02rjz4g | Samuel | Walley | 1805-08-31 | M | 23316 | Hurd | ||||||||||||||||
W000088 | Monrad Wallgren | W000088 | 411267 | 9774 | Monrad Wallgren | Q286243 | kg:/m/044kq1 | Monrad | Wallgren | 1891-04-17 | M | 23318 | Charles | ||||||||||||||||
W000089 | George Wallhauser | W000089 | 411268 | 9775 | George M. Wallhauser | Q647199 | kg:/m/0270zs2 | George | Wallhauser | 1900-02-10 | M | 23319 | Marvin | ||||||||||||||||
W000090 | Samuel Wallin | W000090 | 411269 | 9776 | Samuel Wallin | Q7412867 | kg:/m/02rkwc5 | Samuel | Wallin | 1856-07-31 | M | 23320 | |||||||||||||||||
W000091 | Ansel Walling | W000091 | 411270 | 9777 | Ansel T. Walling | Q4770576 | kg:/m/02rlzwq | Ansel | Walling | 1824-01-10 | M | 23321 | Tracy | ||||||||||||||||
W000092 | Malcolm Wallop | W000092 | 411271 | 14511 | Malcolm Wallop | Q984376 | kg:/m/05bz0l | Malcolm | Wallop | 1933-02-27 | M | 01451 | S119 | ||||||||||||||||
W000093 | Josiah Walls | W000093 | 411272 | 9778 | Josiah T. Walls | Q1708665 | kg:/m/06r8b9 | Josiah | Walls | 1842-12-30 | M | 23324 | Thomas | ||||||||||||||||
W000094 | Robert Waln | W000094 | 411273 | 9779 | Robert Waln | Q7350826 | kg:/m/0266468 | Robert | Waln | 1765-02-22 | M | 23325 | |||||||||||||||||
W000095 | Allan Walsh | W000095 | 411274 | 9780 | Allan B. Walsh | Q1448361 | kg:/m/02wy9b0 | Allan | Walsh | 1874-08-29 | M | 23326 | Bartholomew | ||||||||||||||||
W000096 | Arthur Walsh | W000096 | 411275 | 9781 | Arthur Walsh (U.S. senator) | Q711867 | kg:/m/079kwz | Arthur | Walsh | 1896-02-26 | M | ||||||||||||||||||
W000097 | David Walsh | W000097 | 411276 | 9782 | David I. Walsh | Q881431 | kg:/m/04n49b | David | Walsh | 1872-11-11 | M | Ignatius | |||||||||||||||||
W000098 | James Walsh | W000098 | 411277 | 9783 | James J. Walsh (New York politician) | Q1446745 | kg:/m/02rkr7d | James | Walsh | 1858-05-22 | M | 23330 | Joseph | ||||||||||||||||
W000099 | James Walsh | W000099 | 400420 | 15630 | James T. Walsh | Q6143987 | kg:/m/03tvmx | James | Walsh | 1947-06-19 | M | 23332 | T. | Jim | 01197 | 26990 | N00001261 | [ "H8NY27036" ] |
|||||||||||
W000100 | John Walsh | W000100 | 411278 | 9784 | John R. Walsh | Q183430 | kg:/m/02rkgx1 | John | Walsh | 1913-05-22 | M | 23333 | Richard | ||||||||||||||||
W000101 | Joseph Walsh | W000101 | 411279 | 9785 | Joseph Walsh (Massachusetts politician) | Q1708188 | kg:/m/0bw0sj | Joseph | Walsh | 1875-12-16 | M | 23334 | |||||||||||||||||
W000102 | Michael Walsh | W000102 | 411280 | 9786 | Michael Walsh (New York politician) | Q613554 | kg:/m/026m552 | Michael | Walsh | 1810-05-04 | M | 23335 | |||||||||||||||||
W000103 | Patrick Walsh | W000103 | 411281 | 9787 | Patrick Walsh (Southern U.S. politician) | Q2058022 | kg:/m/079qtb | Patrick | Walsh | 1840-01-01 | M | ||||||||||||||||||
W000104 | Thomas Walsh | W000104 | 411282 | 9788 | Thomas J. Walsh | Q1399488 | kg:/m/04syhc | Thomas | Walsh | 1859-06-12 | M | James | |||||||||||||||||
W000105 | Thomas Walsh | W000105 | 411283 | 9789 | Thomas Yates Walsh | Q1385209 | kg:/m/02rk0bm | Thomas | Walsh | M | 23338 | Yates | |||||||||||||||||
W000106 | William Walsh | W000106 | 411284 | 9790 | William Walsh (Maryland politician) | Q2386100 | kg:/m/08r6ff | William | Walsh | 1828-05-11 | M | 23339 | |||||||||||||||||
W000107 | William Walsh | W000107 | 411285 | 14061 | William F. Walsh | Q2578788 | kg:/m/0gmf5z | William | Walsh | 1912-07-11 | M | 23340 | Francis | 01198 | |||||||||||||||
W000108 | Francis Walter | W000108 | 411286 | 9791 | Francis E. Walter | Q5480815 | kg:/m/0dp886 | Francis | Walter | 1894-05-26 | M | 23341 | Eugene | ||||||||||||||||
W000109 | Anderson Walters | W000109 | 411287 | 9792 | Anderson Howell Walters | Q4754098 | kg:/m/0ft6nv | Anderson | Walters | 1862-05-18 | M | 23342 | Howell | ||||||||||||||||
W000110 | Herbert Walters | W000110 | 411288 | 10825 | Herbert S. Walters | Q376857 | kg:/m/042vsw | Herbert | Walters | 1891-11-17 | M | Sanford | |||||||||||||||||
W000111 | Edward Walthall | W000111 | 411289 | 9793 | Edward C. Walthall | Q369143 | kg:/m/0cy_l0 | Edward | Walthall | 1831-04-04 | M | Cary | |||||||||||||||||
W000112 | Charles Walton | W000112 | 411290 | 9794 | Charles W. Walton | Q1066368 | kg:/m/02rxxms | Charles | Walton | 1819-12-09 | M | 23345 | Wesley | ||||||||||||||||
W000113 | Eliakim Walton | W000113 | 411291 | 9795 | Eliakim Persons Walton | Q1328941 | kg:/m/02rhfwg | Eliakim | Walton | 1812-02-17 | M | 23346 | Persons | ||||||||||||||||
W000114 | George Walton | W000114 | 412123 | 9796 | George Walton | Q878512 | kg:/m/01mrl8 | George | Walton | M | 23348 | ||||||||||||||||||
W000116 | Matthew Walton | W000116 | 412115 | 9798 | Matthew Walton | Q1909622 | kg:/m/02rjx7z | Matthew | Walton | M | 23350 | ||||||||||||||||||
W000117 | William Walton | W000117 | 411293 | 9799 | William B. Walton | Q1505196 | kg:/m/02rj_7w | William | Walton | 1871-01-23 | M | 23351 | Bell | ||||||||||||||||
W000118 | Reuben Walworth | W000118 | 411294 | 9800 | Reuben H. Walworth | Q7317459 | kg:/m/0bylsx | Reuben | Walworth | 1788-10-26 | M | 23352 | Hyde | ||||||||||||||||
W000119 | Zach Wamp | W000119 | 400421 | 29567 | Zach Wamp | Q139389 | kg:/m/03tlrz | Zach | Wamp | 1957-10-28 | M | 23354 | 01199 | 36792 | 21995 | N00003159 | [ "H2TN03052" ] |
||||||||||||
W000120 | Fred Wampler | W000120 | 411295 | 9801 | Fred Wampler (politician) | Q1452544 | kg:/m/02rkfwd | Fred | Wampler | 1909-10-15 | M | 23356 | |||||||||||||||||
W000121 | William Wampler | W000121 | 411296 | 9802 | William C. Wampler | Q2578221 | kg:/m/0dbjnl | William | Wampler | 1926-04-21 | M | 23357 | Creed | 01200 | |||||||||||||||
W000122 | Irving Wanger | W000122 | 411297 | 9803 | Irving Price Wanger | Q6074742 | kg:/m/0gdqjz | Irving | Wanger | 1852-03-05 | M | 23359 | Price | ||||||||||||||||
W000123 | Herbert Warburton | W000123 | 411298 | 9804 | Herbert Warburton | Q1312076 | kg:/m/025xklk | Herbert | Warburton | 1916-09-21 | M | 23360 | Birchby | ||||||||||||||||
W000124 | Stanton Warburton | W000124 | 411299 | 9805 | Stanton Warburton | Q2331943 | kg:/m/02rmn5b | Stanton | Warburton | 1865-04-13 | M | 23361 | |||||||||||||||||
W000125 | Aaron Ward | W000125 | 411300 | 9806 | Aaron Ward (representative) | Q612451 | kg:/m/03cmws_ | Aaron | Ward | 1790-07-05 | M | 23362 | |||||||||||||||||
W000126 | Andrew Ward | W000126 | 411301 | 9807 | Andrew H. Ward | Q505016 | kg:/m/02rgwgv | Andrew | Ward | 1815-01-03 | M | 23363 | Harrison | ||||||||||||||||
W000127 | Artemas Ward | W000127 | 411302 | 9808 | Artemas Ward | Q321887 | kg:/m/01l7tx | Artemas | Ward | 1727-11-26 | M | 23364 | |||||||||||||||||
W000128 | Artemas Ward | W000128 | 411303 | 9809 | Artemas Ward Jr. | Q706555 | kg:/m/0cg1m4 | Artemas | Ward | 1762-01-09 | M | 23365 | Jr. | ||||||||||||||||
W000129 | Charles Ward | W000129 | 411304 | 9810 | Charles B. Ward | Q5075342 | kg:/m/02rkmst | Charles | Ward | 1879-04-27 | M | 23366 | Bonnell | ||||||||||||||||
W000130 | David Ward | W000130 | 411305 | 9811 | David Jenkins Ward | Q1174870 | kg:/m/06g0bq | David | Ward | 1871-09-17 | M | 23367 | Jenkins | ||||||||||||||||
W000131 | Elijah Ward | W000131 | 411306 | 9812 | Elijah Ward | Q983147 | kg:/m/078wpg | Elijah | Ward | 1816-09-16 | M | 23368 | |||||||||||||||||
W000132 | Hallett Ward | W000132 | 411307 | 9813 | Hallett Sydney Ward | Q1571669 | kg:/m/05ks7k | Hallett | Ward | 1870-08-31 | M | 23369 | Sydney | ||||||||||||||||
W000133 | Hamilton Ward | W000133 | 411308 | 9814 | Hamilton Ward Sr. | Q5645239 | kg:/m/0dgp44 | Hamilton | Ward | 1829-07-03 | M | 23370 | |||||||||||||||||
W000134 | James Ward | W000134 | 411309 | 9815 | James Hugh Ward | Q4420089 | kg:/m/02rkb3s | James | Ward | 1853-11-30 | M | 23371 | Hugh | ||||||||||||||||
W000135 | Jasper Ward | W000135 | 411310 | 9816 | Jasper D. Ward | Q4231891 | kg:/m/02rkzgy | Jasper | Ward | 1829-02-01 | M | 23372 | Delos | ||||||||||||||||
W000136 | Jonathan Ward | W000136 | 411311 | 9817 | Jonathan Ward (politician) | Q328440 | kg:/m/03cr187 | Jonathan | Ward | 1768-09-21 | M | 23373 | |||||||||||||||||
W000137 | Marcus Ward | W000137 | 411312 | 9818 | Marcus Lawrence Ward | Q354089 | kg:/m/07rl6k | Marcus | Ward | 1812-11-09 | M | 23374 | Lawrence | ||||||||||||||||
W000138 | Matthias Ward | W000138 | 411313 | 9819 | Matthias Ward | Q358916 | kg:/m/06ym7b | Matthias | Ward | 1805-10-13 | M | ||||||||||||||||||
W000139 | Michael Ward | W000139 | 411314 | 29526 | Mike Ward (American politician) | Q1933579 | kg:/m/08g466 | Michael | Ward | 1951-01-07 | M | 23377 | Delavan | 01201 | |||||||||||||||
W000141 | Thomas Ward | W000141 | 412183 | 9821 | Thomas Ward (New Jersey politician) | Q2428027 | kg:/m/02rtr1k | Thomas | Ward | M | 23379 | ||||||||||||||||||
W000142 | Thomas Ward | W000142 | 411316 | 9822 | Thomas B. Ward | Q2422180 | kg:/m/02rkhqw | Thomas | Ward | 1835-04-27 | M | 23380 | Bayless | ||||||||||||||||
W000143 | William Ward | W000143 | 411317 | 9823 | William Ward (Pennsylvania politician) | Q8020000 | kg:/m/0ksyw7 | William | Ward | 1837-01-01 | M | 23381 | |||||||||||||||||
W000144 | William Ward | W000144 | 411318 | 9824 | William L. Ward | Q3539740 | kg:/m/02rky60 | William | Ward | 1856-09-02 | M | 23382 | Lukens | ||||||||||||||||
W000145 | William Ward | W000145 | 411319 | 9825 | William Thomas Ward | Q1683770 | kg:/m/02r94sw | William | Ward | 1808-08-09 | M | 23383 | Thomas | ||||||||||||||||
W000146 | Daniel Wardwell | W000146 | 411320 | 9826 | Daniel Wardwell | Q3915859 | kg:/m/02rknly | Daniel | Wardwell | 1791-05-28 | M | 23384 | |||||||||||||||||
W000147 | John Ware | W000147 | 411321 | 12048 | John H. Ware III | Q6237135 | kg:/m/0dlrqk | John | Ware | 1908-08-29 | M | 23385 | Haines | III | 01202 | ||||||||||||||
W000148 | Nicholas Ware | W000148 | 411322 | 9827 | Nicholas Ware | Q372258 | kg:/m/0bj0dv | Nicholas | Ware | M | |||||||||||||||||||
W000149 | Orie Ware | W000149 | 411323 | 9828 | Orie Solomon Ware | Q1257406 | kg:/m/02rjxnp | Orie | Ware | 1882-05-11 | M | 23387 | Solomon | ||||||||||||||||
W000150 | Henry Warfield | W000150 | 411324 | 9829 | Henry Ridgely Warfield | Q895869 | kg:/m/02rh_zt | Henry | Warfield | 1774-09-14 | M | 23388 | Ridgely | ||||||||||||||||
W000151 | Adoniram Warner | W000151 | 411325 | 9830 | Adoniram J. Warner | Q4684523 | kg:/m/02rlzm3 | Adoniram | Warner | 1834-01-13 | M | 23389 | Judson | ||||||||||||||||
W000152 | Hiram Warner | W000152 | 411326 | 9831 | Hiram B. Warner | Q1620137 | kg:/m/03zvst | Hiram | Warner | 1802-10-29 | M | 23390 | |||||||||||||||||
W000153 | John Warner | W000153 | 411327 | 9832 | John De Witt Warner | Q2161525 | kg:/m/027lfg4 | John | Warner | 1851-10-30 | M | 23392 | De Witt | ||||||||||||||||
W000154 | John Warner | W000154 | 300099 | 14712 | John Warner | Q464810 | kg:/m/01w8b5 | John | Warner | 1927-02-18 | M | W. | 01452 | 53356 | S143 | N00002061 | [ "S8VA00107" ] |
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);