legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by other_names descending
This data as json, copyable, CSV (advanced)
bio_birthday (date) >30 ✖
- 1812-02-17 2
- 1829-05-29 2
- 1836-11-15 2
- 1941-10-12 2
- 1727-11-26 1
- 1729-12-11 1
- 1735-12-05 1
- 1737-03-02 1
- 1738-07-21 1
- 1739-05-14 1
- 1744-02-13 1
- 1745-01-01 1
- 1745-01-05 1
- 1746-06-17 1
- 1747-06-18 1
- 1748-05-06 1
- 1749-06-16 1
- 1749-08-27 1
- 1750-04-06 1
- 1750-05-20 1
- 1751-01-01 1
- 1752-11-20 1
- 1753-07-19 1
- 1754-03-13 1
- 1758-12-23 1
- 1759-06-16 1
- 1762-01-09 1
- 1762-01-31 1
- 1763-04-25 1
- 1764-06-22 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
W000014 | Peleg Wadsworth | W000014 | 411193 | 9707 | Peleg Wadsworth | Q2067953 | kg:/m/04fv3x | Peleg | Wadsworth | 1748-05-06 | M | 23237 | |||||||||||||||||
W000015 | William Wadsworth | W000015 | 411194 | 9708 | William H. Wadsworth | Q2579106 | kg:/m/02rj_kj | William | Wadsworth | 1821-07-04 | M | 23238 | Henry | ||||||||||||||||
W000016 | David Wagener | W000016 | 411195 | 9709 | David Douglas Wagener | Q5233054 | kg:/m/0276y8c | David | Wagener | 1792-10-11 | M | 23239 | Douglas | ||||||||||||||||
W000017 | George Waggaman | W000017 | 411196 | 9710 | George A. Waggaman | Q1506810 | kg:/m/0d2s6n | George | Waggaman | M | Augustus | ||||||||||||||||||
W000018 | Joseph Waggonner | W000018 | 411197 | 10567 | Joe Waggonner | Q1691636 | kg:/m/0c16hw | Joseph | Waggonner | 1918-09-07 | M | 23241 | David | Jr. | 01191 | ||||||||||||||
W000019 | Earl Wagner | W000019 | 411198 | 9711 | Earl T. Wagner | Q1277178 | kg:/m/02rhff0 | Earl | Wagner | 1908-04-27 | M | 23242 | Thomas | ||||||||||||||||
W000020 | Peter Wagner | W000020 | 411199 | 9712 | Peter Joseph Wagner | Q2979322 | kg:/m/03c2zcf | Peter | Wagner | 1795-08-14 | M | 23243 | Joseph | ||||||||||||||||
W000021 | Robert Wagner | W000021 | 411200 | 9713 | Robert F. Wagner | Q213721 | kg:/m/031lwb | Robert | Wagner | 1877-06-08 | M | Ferdinand | |||||||||||||||||
W000022 | George Wagoner | W000022 | 411201 | 9714 | George Chester Robinson Wagoner | Q730379 | kg:/m/02rz65g | George | Wagoner | 1863-09-03 | M | 23245 | Chester Robinson | ||||||||||||||||
W000023 | Jonathan Wainwright | W000023 | 411202 | 9715 | J. Mayhew Wainwright | Q6106491 | kg:/m/02rkzcv | Jonathan | Wainwright | 1864-12-10 | M | 23246 | Mayhew | ||||||||||||||||
W000024 | Stuyvesant Wainwright | W000024 | 411203 | 9716 | Stuyvesant Wainwright | Q82221 | kg:/m/0kt21v | Stuyvesant | Wainwright | 1921-03-16 | M | 23247 | II | ||||||||||||||||
W000025 | John Wait | W000025 | 411204 | 9717 | John T. Wait | Q998852 | kg:/m/02rhklt | John | Wait | 1811-08-27 | M | 23248 | Turner | ||||||||||||||||
W000026 | James Wakefield | W000026 | 411205 | 9718 | James Wakefield | Q773436 | kg:/m/0dqq37 | James | Wakefield | 1825-03-21 | M | 23249 | Beach | ||||||||||||||||
W000027 | Abram Wakeman | W000027 | 411206 | 9719 | Abram Wakeman | Q1383679 | kg:/m/02rklwy | Abram | Wakeman | 1824-05-31 | M | 23250 | |||||||||||||||||
W000028 | Seth Wakeman | W000028 | 411207 | 9720 | Seth Wakeman | Q1385349 | kg:/m/02rkwf8 | Seth | Wakeman | 1811-01-15 | M | 23252 | |||||||||||||||||
W000029 | David Walbridge | W000029 | 411208 | 9721 | David S. Walbridge | Q1176473 | kg:/m/027m1w5 | David | Walbridge | 1802-07-30 | M | 23253 | Safford | ||||||||||||||||
W000030 | Henry Walbridge | W000030 | 411209 | 9722 | Henry S. Walbridge | Q5727916 | kg:/m/02rkqn4 | Henry | Walbridge | 1801-04-08 | M | 23254 | Sanford | ||||||||||||||||
W000031 | Hiram Walbridge | W000031 | 411210 | 9723 | Hiram Walbridge | Q390822 | kg:/m/02rkqsm | Hiram | Walbridge | 1821-02-02 | M | 23255 | |||||||||||||||||
W000032 | Frederic Walcott | W000032 | 411211 | 9724 | Frederic C. Walcott | Q1440568 | kg:/m/0bhs5m | Frederic | Walcott | 1869-02-19 | M | Collin | |||||||||||||||||
W000033 | Hiram Walden | W000033 | 411212 | 9725 | Hiram Walden | Q5769326 | kg:/m/02qrndr | Hiram | Walden | 1800-08-21 | M | 23257 | |||||||||||||||||
W000034 | Madison Walden | W000034 | 411213 | 9726 | Madison Miner Walden | Q1883379 | kg:/m/02rk7zp | Madison | Walden | 1836-10-06 | M | 23258 | Miner | ||||||||||||||||
W000035 | Jerome Waldie | W000035 | 411215 | 10793 | Jerome Waldie | Q1687753 | kg:/m/02rhjmj | Jerome | Waldie | 1925-02-15 | M | 23259 | Russell | 01193 | |||||||||||||||
W000036 | George Waldo | W000036 | 411216 | 9727 | George E. Waldo | Q808619 | kg:/m/02rkpls | George | Waldo | 1851-01-11 | M | 23260 | Ernest | ||||||||||||||||
W000037 | Loren Waldo | W000037 | 411217 | 9728 | Loren P. Waldo | Q1686911 | kg:/m/02rjx2t | Loren | Waldo | 1802-02-02 | M | 23261 | Pinckney | ||||||||||||||||
W000038 | Alton Waldon | W000038 | 411218 | 15244 | Alton Waldon | Q1027684 | kg:/m/0fq1cv | Alton | Waldon | 1936-12-21 | M | 23263 | R. | Jr. | 01194 | ||||||||||||||
W000039 | William Waldow | W000039 | 411219 | 9729 | William F. Waldow | Q8008890 | kg:/m/026g4wy | William | Waldow | 1882-08-26 | M | 23264 | Frederick | ||||||||||||||||
W000040 | Alfred Waldron | W000040 | 411220 | 9730 | Alfred M. Waldron | Q4723103 | kg:/m/0d_trg | Alfred | Waldron | 1865-09-21 | M | 23265 | Marpole | ||||||||||||||||
W000041 | Henry Waldron | W000041 | 411221 | 9731 | Henry Waldron | Q1602499 | kg:/m/026wlts | Henry | Waldron | 1819-10-11 | M | 23266 | |||||||||||||||||
W000042 | George Wales | W000042 | 411222 | 9732 | George Edward Wales | Q1507291 | kg:/m/02rhghr | George | Wales | 1792-05-13 | M | 23267 | Edward | ||||||||||||||||
W000043 | John Wales | W000043 | 411223 | 9733 | John Wales | Q1702088 | kg:/m/063kh1 | John | Wales | 1783-07-31 | M | ||||||||||||||||||
W000044 | Douglas Walgren | W000044 | 411224 | 14460 | Doug Walgren | Q5300982 | kg:/m/0dn6q2 | Douglas | Walgren | 1940-12-28 | M | 23269 | 01195 | ||||||||||||||||
W000045 | Amasa Walker | W000045 | 411225 | 9734 | Amasa Walker | Q455361 | kg:/m/0gtw1d | Amasa | Walker | 1799-05-04 | M | 23270 | |||||||||||||||||
W000046 | Benjamin Walker | W000046 | 411226 | 9735 | Benjamin Walker (New York soldier) | Q1446684 | kg:/m/02q6b7x | Benjamin | Walker | M | 23271 | ||||||||||||||||||
W000047 | Charles Walker | W000047 | 411227 | 9736 | Charles C. B. Walker | Q5075954 | kg:/m/02rkmv5 | Charles | Walker | 1824-06-27 | M | 23272 | Christopher Brainerd | ||||||||||||||||
W000048 | David Walker | W000048 | 412114 | 9737 | David Walker (Kentucky politician) | Q1177051 | kg:/m/02rt39b | David | Walker | M | 23273 | ||||||||||||||||||
W000049 | E. Walker | W000049 | 411228 | 10780 | E. S. Johnny Walker | Q1273565 | kg:/m/08g2c8 | E. | Walker | 1911-06-18 | M | 23275 | S. Johnny | ||||||||||||||||
W000050 | Felix Walker | W000050 | 411229 | 9738 | Felix Walker (American politician) | Q1403882 | kg:/m/05kybp | Felix | Walker | 1753-07-19 | M | 23276 | |||||||||||||||||
W000051 | Francis Walker | W000051 | 411230 | 9739 | Francis Walker (Virginia politician) | Q82431 | kg:/m/07vs28 | Francis | Walker | 1764-06-22 | M | 23277 | |||||||||||||||||
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 |
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);