legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by id_lis
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
W000634 | Effiegene Wingo | W000634 | 411788 | 10273 | Effiegene Locke Wingo | Q1296186 | kg:/m/02rhfv2 | Effiegene | Wingo | 1883-04-13 | F | 23970 | Locke | ||||||||||||||||
W000635 | Otis Wingo | W000635 | 411789 | 10274 | Otis Wingo | Q2037052 | kg:/m/02rjxt4 | Otis | Wingo | 1877-06-18 | M | 23971 | Theodore | ||||||||||||||||
W000636 | Edward Winn | W000636 | 411790 | 11057 | Larry Winn | Q1689332 | kg:/m/027n4yt | Edward | Winn | 1919-08-22 | M | 23973 | Lawrence | Larry | Jr. | 01235 | |||||||||||||
W000637 | Richard Winn | W000637 | 411791 | 10275 | Richard Winn | Q2150938 | kg:/m/096sy7 | Richard | Winn | M | 23974 | ||||||||||||||||||
W000638 | Thomas Winn | W000638 | 411792 | 10276 | Thomas E. Winn | Q1459914 | kg:/m/02rk152 | Thomas | Winn | 1839-05-21 | M | 23975 | Elisha | ||||||||||||||||
W000639 | Samuel Winslow | W000639 | 411793 | 10277 | Samuel Winslow | Q1656667 | kg:/m/0bvdqh | Samuel | Winslow | 1862-04-11 | M | 23976 | Ellsworth | ||||||||||||||||
W000640 | Warren Winslow | W000640 | 411794 | 10278 | Warren Winslow | Q2549811 | kg:/m/02j1k9 | Warren | Winslow | 1810-01-01 | M | 23977 | |||||||||||||||||
W000641 | William Winstead | W000641 | 411795 | 10279 | W. Arthur Winstead | Q2536627 | kg:/m/02rtmzh | William | Winstead | 1904-01-06 | M | 23978 | Arthur | ||||||||||||||||
W000642 | Joseph Winston | W000642 | 411796 | 10280 | Joseph Winston | Q1306824 | kg:/m/0343_h | Joseph | Winston | 1746-06-17 | M | 23979 | |||||||||||||||||
W000643 | Charles Winter | W000643 | 411797 | 10281 | Charles E. Winter | Q1064235 | kg:/m/0265k3t | Charles | Winter | 1870-09-13 | M | 23980 | Edwin | ||||||||||||||||
W000644 | Elisha Winter | W000644 | 411798 | 10282 | Elisha I. Winter | Q2271338 | kg:/m/02rkp65 | Elisha | Winter | 1781-07-15 | M | 23981 | I. | ||||||||||||||||
W000645 | Thomas Winter | W000645 | 411799 | 10283 | Thomas Daniel Winter | Q1286350 | kg:/m/02rmb8j | Thomas | Winter | 1896-07-07 | M | 23982 | Daniel | ||||||||||||||||
W000646 | Robert Winthrop | W000646 | 411800 | 10284 | Robert Charles Winthrop | Q1375119 | kg:/m/02jnfg | Robert | Winthrop | 1809-05-12 | M | 23984 | Charles | ||||||||||||||||
W000648 | George Wise | W000648 | 411802 | 10285 | George D. Wise | Q1507189 | kg:/m/02vrppn | George | Wise | 1831-06-04 | M | 23988 | Douglas | ||||||||||||||||
W000649 | Henry Wise | W000649 | 411803 | 10286 | Henry A. Wise | Q878516 | kg:/m/038426 | Henry | Wise | 1806-12-03 | M | 23990 | Alexander | ||||||||||||||||
W000650 | James Wise | W000650 | 411804 | 10287 | James W. Wise | Q1320424 | kg:/m/02rk0yw | James | Wise | 1868-03-03 | M | 23991 | Walter | ||||||||||||||||
W000651 | John Wise | W000651 | 411805 | 10288 | John Sergeant Wise | Q1701724 | kg:/m/02svs2 | John | Wise | 1846-12-27 | M | 23992 | Sergeant | ||||||||||||||||
W000652 | Morgan Wise | W000652 | 411806 | 10289 | Morgan Ringland Wise | Q6911828 | kg:/m/0cdltz | Morgan | Wise | 1825-06-07 | M | 23993 | Ringland | ||||||||||||||||
W000653 | Richard Wise | W000653 | 411807 | 10290 | Richard Alsop Wise | Q1691166 | kg:/m/03c2_7d | Richard | Wise | 1843-09-02 | M | 23994 | Alsop | ||||||||||||||||
W000654 | Robert Wise | W000654 | 400614 | 15077 | Bob Wise | Q780398 | kg:/m/026b40 | Robert | Wise | 1948-01-06 | M | 23996 | E. | Jr. | 01237 | ||||||||||||||
W000656 | John Witcher | W000656 | 411809 | 10292 | John Witcher | Q1266476 | kg:/m/02pm261 | John | Witcher | 1839-07-15 | M | 23998 | Seashoal | ||||||||||||||||
W000657 | James Witherell | W000657 | 411810 | 10293 | James Witherell | Q1681320 | kg:/m/026kt04 | James | Witherell | 1759-06-16 | M | 23999 | |||||||||||||||||
W000658 | Garrett Withers | W000658 | 411811 | 10294 | Garrett Withers | Q1411163 | kg:/m/08h0jk | Garrett | Withers | 1884-06-21 | M | 24001 | Lee | ||||||||||||||||
W000659 | Robert Withers | W000659 | 411812 | 10295 | Robert E. Withers | Q1664315 | kg:/m/08kl1d | Robert | Withers | 1821-09-18 | M | Enoch | |||||||||||||||||
W000661 | Robert Witherspoon | W000661 | 411814 | 10297 | Robert Witherspoon | Q2159230 | kg:/m/02vn_y4 | Robert | Witherspoon | 1767-01-29 | M | 24004 | |||||||||||||||||
W000662 | Samuel Witherspoon | W000662 | 411815 | 10298 | Samuel Andrew Witherspoon | Q2217906 | kg:/m/02rtn8t | Samuel | Witherspoon | 1855-05-04 | M | 24005 | Andrew | ||||||||||||||||
W000663 | Gardner Withrow | W000663 | 411816 | 10299 | Gardner R. Withrow | Q658433 | kg:/m/0b6wcc | Gardner | Withrow | 1892-10-05 | M | 24007 | Robert | ||||||||||||||||
W000664 | William Witte | W000664 | 411817 | 10300 | William Henry Witte | Q8012219 | kg:/m/026fczm | William | Witte | 1817-10-04 | M | 24008 | Henry | ||||||||||||||||
W000666 | Thomas Wofford | W000666 | 411819 | 10301 | Thomas A. Wofford | Q433654 | kg:/m/0d060z | Thomas | Wofford | 1908-09-27 | M | Albert | |||||||||||||||||
W000667 | Edward Wolcott | W000667 | 411820 | 10302 | Edward O. Wolcott | Q1293143 | kg:/m/0bf33m | Edward | Wolcott | 1848-03-26 | M | Oliver | |||||||||||||||||
W000668 | Jesse Wolcott | W000668 | 411821 | 10303 | Jesse P. Wolcott | Q784436 | kg:/m/02pw4x1 | Jesse | Wolcott | 1893-03-03 | M | 24013 | Paine | ||||||||||||||||
W000669 | Josiah Wolcott | W000669 | 411822 | 10304 | Josiah O. Wolcott | Q1708654 | kg:/m/06vs0l | Josiah | Wolcott | 1877-10-31 | M | Oliver | |||||||||||||||||
W000671 | John Wold | W000671 | 411824 | 12034 | John S. Wold | Q1701666 | kg:/m/09mbsp | John | Wold | 1916-08-31 | M | 24016 | Schiller | ||||||||||||||||
W000672 | Frank Wolf | W000672 | 400435 | 14869 | Frank Wolf (politician) | Q1444483 | kg:/m/027zy9 | Frank | Wolf | 1939-01-30 | M | 24018 | R. | Frank Wolf | 01238 | 7508 | 27120 | Frank R. Wolf | N00002073 | [ "H6VA10050" ] |
520 | ||||||||
W000673 | George Wolf | W000673 | 411825 | 10306 | George Wolf | Q373221 | kg:/m/0293kh | George | Wolf | 1777-08-12 | M | 24019 | |||||||||||||||||
W000674 | Harry Wolf | W000674 | 411826 | 10307 | Harry Benjamin Wolf | Q1107875 | kg:/m/02qzs05 | Harry | Wolf | 1880-06-16 | M | 24020 | Benjamin | ||||||||||||||||
W000675 | Leonard Wolf | W000675 | 411827 | 10308 | Leonard G. Wolf | Q1818969 | kg:/m/02rk7xz | Leonard | Wolf | 1925-10-29 | M | 24021 | George | ||||||||||||||||
W000676 | William Wolf | W000676 | 411828 | 10309 | William P. Wolf | Q1302427 | kg:/m/02r72qn | William | Wolf | 1833-12-01 | M | 24022 | Penn | ||||||||||||||||
W000677 | Simeon Wolfe | W000677 | 411829 | 10310 | Simeon K. Wolfe | Q2287078 | kg:/m/02rkhph | Simeon | Wolfe | 1824-02-14 | M | 24024 | Kalfius | ||||||||||||||||
W000678 | James Wolfenden | W000678 | 411830 | 10311 | James Wolfenden | Q13219860 | kg:/m/0dhlry | James | Wolfenden | 1889-07-25 | M | 24025 | |||||||||||||||||
W000679 | Joseph Wolff | W000679 | 411831 | 10312 | J. Scott Wolff | Q1676403 | kg:/m/02rz6ny | Joseph | Wolff | 1878-06-14 | M | 24026 | Scott | ||||||||||||||||
W000680 | Lester Wolff | W000680 | 411832 | 10784 | Lester L. Wolff | Q1626737 | kg:/m/0gmd5l | Lester | Wolff | 1919-01-04 | M | 24027 | Lionel | 01239 | |||||||||||||||
W000681 | Frank Wolford | W000681 | 411833 | 10313 | Frank Lane Wolford | Q1443631 | kg:/m/02rhgbl | Frank | Wolford | 1817-09-02 | M | 24028 | Lane | ||||||||||||||||
W000682 | Howard Wolpe | W000682 | 411834 | 14673 | Howard Wolpe | Q995192 | kg:/m/04zr6n | Howard | Wolpe | 1939-11-03 | M | 24029 | Eliot | III | 01240 | ||||||||||||||
W000683 | Charles Wolverton | W000683 | 411835 | 10314 | Charles A. Wolverton | Q1063499 | kg:/m/0bp1mr | Charles | Wolverton | 1880-10-24 | M | 24030 | Anderson | ||||||||||||||||
W000684 | John Wolverton | W000684 | 411836 | 10315 | John M. Wolverton | Q1288108 | kg:/m/03c2_p6 | John | Wolverton | 1872-01-31 | M | 24031 | Marshall | ||||||||||||||||
W000685 | Simon Wolverton | W000685 | 411837 | 10316 | Simon Peter Wolverton | Q7519525 | kg:/m/0ksfpj | Simon | Wolverton | 1837-01-28 | M | 24033 | Peter | ||||||||||||||||
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 | ||||||||||||||||
W000687 | Abiel Wood | W000687 | 411839 | 10317 | Abiel Wood | Q320912 | kg:/m/02rgty9 | Abiel | Wood | 1772-07-22 | M | 24035 | |||||||||||||||||
W000688 | Alan Wood | W000688 | 411840 | 10318 | Alan Wood Jr. | Q4708090 | kg:/m/0ksyx0 | Alan | Wood | 1834-07-06 | M | 24036 | Jr. | ||||||||||||||||
W000689 | Amos Wood | W000689 | 411841 | 10319 | Amos E. Wood | Q4747854 | kg:/m/02rlzsm | Amos | Wood | 1810-01-02 | M | 24037 | Eastman | ||||||||||||||||
W000690 | Benjamin Wood | W000690 | 411842 | 10320 | Benjamin Wood (American politician) | Q211890 | kg:/m/085q05 | Benjamin | Wood | 1820-10-13 | M | 24038 | |||||||||||||||||
W000691 | Benson Wood | W000691 | 411843 | 10321 | Benson Wood | Q4890290 | kg:/m/02rk8zn | Benson | Wood | 1839-03-31 | M | 24040 | |||||||||||||||||
W000692 | Bradford Wood | W000692 | 411844 | 10322 | Bradford R. Wood | Q2514280 | kg:/m/02rkmky | Bradford | Wood | 1800-09-03 | M | 24041 | Ripley | ||||||||||||||||
W000693 | Ernest Wood | W000693 | 411845 | 10323 | Ernest E. Wood | Q1356294 | kg:/m/02rz5yh | Ernest | Wood | 1875-08-24 | M | 24042 | Edward | ||||||||||||||||
W000694 | Fernando Wood | W000694 | 411846 | 10324 | Fernando Wood | Q430443 | kg:/m/021zqn | Fernando | Wood | 1812-06-14 | M | 24044 | |||||||||||||||||
W000695 | Ira Wood | W000695 | 411847 | 10325 | Ira W. Wood | Q1612382 | kg:/m/02x2hx_ | Ira | Wood | 1856-06-19 | M | 24046 | Wells | ||||||||||||||||
W000696 | John Wood | W000696 | 411848 | 10326 | John Wood (congressman) | Q2729966 | kg:/m/0ktbvv | John | Wood | 1816-09-06 | M | 24047 | |||||||||||||||||
W000697 | John Wood | W000697 | 411849 | 10327 | John J. Wood | Q64485 | kg:/m/02rksj5 | John | Wood | 1784-02-16 | M | 24048 | Jacob | ||||||||||||||||
W000698 | John Wood | W000698 | 411850 | 10328 | John M. Wood | Q1590217 | kg:/m/02rtgrl | John | Wood | 1813-11-17 | M | 24049 | M. | ||||||||||||||||
W000699 | John Wood | W000699 | 411851 | 10329 | John Stephens Wood | Q1701821 | kg:/m/0384k1 | John | Wood | 1885-02-08 | M | 24050 | Stephens | ||||||||||||||||
W000700 | John Wood | W000700 | 411852 | 10330 | John Travers Wood | Q1701961 | kg:/m/07kl7n | John | Wood | 1878-11-25 | M | 24051 | Travers | ||||||||||||||||
W000702 | Reuben Wood | W000702 | 411854 | 10332 | Reuben T. Wood | Q652579 | kg:/m/02rx837 | Reuben | Wood | 1884-08-07 | M | 24053 | Terrell | ||||||||||||||||
W000703 | Silas Wood | W000703 | 411855 | 10333 | Silas Wood | Q74557 | kg:/m/02rkwj0 | Silas | Wood | 1769-09-14 | M | 24054 | |||||||||||||||||
W000704 | Thomas Wood | W000704 | 411856 | 10334 | Thomas Jefferson Wood | Q2425087 | kg:/m/03gx9jt | Thomas | Wood | 1844-09-30 | M | 24055 | Jefferson | ||||||||||||||||
W000705 | Walter Wood | W000705 | 411857 | 10335 | Walter A. Wood | Q3701873 | kg:/m/02rkxk0 | Walter | Wood | 1815-10-23 | M | 24056 | Abbott | ||||||||||||||||
W000706 | William Wood | W000706 | 411858 | 10336 | William R. Wood (Indiana politician) | Q2580380 | kg:/m/02rklh6 | William | Wood | 1861-01-05 | M | 24058 | Robert | ||||||||||||||||
W000707 | Frederick Woodard | W000707 | 411859 | 10337 | Frederick Augustus Woodard | Q946345 | kg:/m/05jzwx | Frederick | Woodard | 1854-02-12 | M | 24060 | Augustus | ||||||||||||||||
W000708 | Frederick Woodbridge | W000708 | 411860 | 10338 | Frederick E. Woodbridge | Q1452856 | kg:/m/02r5hs3 | Frederick | Woodbridge | 1818-08-29 | M | 24061 | Enoch | ||||||||||||||||
W000709 | William Woodbridge | W000709 | 411861 | 10339 | William Woodbridge | Q883246 | kg:/m/02nj2d | William | Woodbridge | 1780-08-20 | M | 24063 | |||||||||||||||||
W000710 | William Woodburn | W000710 | 411862 | 10340 | William Woodburn | Q2581113 | kg:/m/0g8fgn | William | Woodburn | 1838-04-14 | M | 24064 | |||||||||||||||||
W000711 | Levi Woodbury | W000711 | 411863 | 10341 | Levi Woodbury | Q579228 | kg:/m/01z7n4 | Levi | Woodbury | 1789-12-22 | M | ||||||||||||||||||
W000712 | David Woodcock | W000712 | 411864 | 10342 | David Woodcock | Q5241281 | kg:/m/02rknsf | David | Woodcock | M | 24066 | ||||||||||||||||||
W000713 | Stewart Woodford | W000713 | 411865 | 10343 | Stewart L. Woodford | Q428605 | kg:/m/0gm73p | Stewart | Woodford | 1835-09-03 | M | 24067 | Lyndon | ||||||||||||||||
W000714 | Chase Woodhouse | W000714 | 411866 | 10344 | Chase G. Woodhouse | Q1067999 | kg:/m/092_3k | Chase | Woodhouse | 1890-03-03 | F | 24069 | Going | ||||||||||||||||
W000715 | Charles Woodman | W000715 | 411867 | 10345 | Charles W. Woodman | Q5083277 | kg:/m/02rk96x | Charles | Woodman | 1844-03-11 | M | 24071 | Walhart | ||||||||||||||||
W000716 | George Woodruff | W000716 | 411868 | 10346 | George Catlin Woodruff | Q1507072 | kg:/m/02rtmkr | George | Woodruff | 1805-12-01 | M | 24072 | Catlin | ||||||||||||||||
W000717 | John Woodruff | W000717 | 411869 | 10347 | John Woodruff (representative) | Q1702220 | kg:/m/02rtmkd | John | Woodruff | 1826-02-12 | M | 24073 | |||||||||||||||||
W000718 | Roy Woodruff | W000718 | 411870 | 10348 | Roy O. Woodruff | Q2170872 | kg:/m/02q2fmd | Roy | Woodruff | 1876-03-14 | M | 24074 | Orchard | ||||||||||||||||
W000719 | Thomas Woodruff | W000719 | 411871 | 10349 | Thomas M. Woodruff | Q759140 | kg:/m/02rkx8f | Thomas | Woodruff | 1804-05-03 | M | 24075 | M. | ||||||||||||||||
W000720 | Clifton Woodrum | W000720 | 411872 | 10350 | Clifton A. Woodrum | Q265178 | kg:/m/02vp0j1 | Clifton | Woodrum | 1887-04-27 | M | 24077 | Alexander | ||||||||||||||||
W000721 | Frank Woods | W000721 | 411873 | 10351 | Frank P. Woods | Q1443925 | kg:/m/02rk7d3 | Frank | Woods | 1868-12-11 | M | 24078 | Plowman | ||||||||||||||||
W000722 | Henry Woods | W000722 | 411874 | 10352 | Henry Woods (Pennsylvania politician) | Q13219863 | kg:/m/0266hwb | Henry | Woods | M | 24079 | ||||||||||||||||||
W000723 | James Woods | W000723 | 411875 | 10353 | James P. Woods | Q1680946 | kg:/m/02x3_xj | James | Woods | 1868-02-04 | M | 24080 | Pleasant | ||||||||||||||||
W000724 | John Woods | W000724 | 411877 | 10355 | John Woods (Ohio politician) | Q1308540 | kg:/m/02rm4sv | John | Woods | 1794-10-18 | M | 24081 | |||||||||||||||||
W000725 | John Woods | W000725 | 411876 | 10354 | John Woods (Pennsylvania politician) | Q13219864 | kg:/m/0266h_g | John | Woods | M | 24082 | ||||||||||||||||||
W000726 | Samuel Woods | W000726 | 411878 | 10356 | Samuel D. Woods | Q1561398 | kg:/m/02rjz2d | Samuel | Woods | 1845-09-19 | M | 24084 | Davis | ||||||||||||||||
W000727 | William Woods | W000727 | 411879 | 10357 | William Woods (congressman) | Q8020549 | kg:/m/03cnssq | William | Woods | M | 24085 | ||||||||||||||||||
W000728 | Samuel Woodson | W000728 | 411881 | 10359 | Samuel H. Woodson (Missouri politician) | Q2218344 | kg:/m/02rl40c | Samuel | Woodson | 1815-10-24 | M | 24086 | Hughes | ||||||||||||||||
W000729 | Samuel Woodson | W000729 | 411880 | 10358 | Samuel H. Woodson (Kentucky politician) | Q1790082 | kg:/m/02rl40q | Samuel | Woodson | 1777-09-15 | M | 24087 | Hughes | ||||||||||||||||
W000730 | George Woodward | W000730 | 411882 | 10360 | George Washington Woodward | Q5546053 | kg:/m/0kt76p | George | Woodward | 1809-03-26 | M | 24088 | Washington | ||||||||||||||||
W000731 | Gilbert Woodward | W000731 | 411883 | 10361 | Gilbert M. Woodward | Q1524015 | kg:/m/02vrqxk | Gilbert | Woodward | 1835-12-25 | M | 24089 | Motier | ||||||||||||||||
W000732 | Joseph Woodward | W000732 | 411884 | 10362 | Joseph A. Woodward | Q1706395 | kg:/m/02vn_z5 | Joseph | Woodward | 1806-04-11 | M | 24090 | Addison | ||||||||||||||||
W000733 | William Woodward | W000733 | 412121 | 10363 | William Woodward (South Carolina politician) | Q2581116 | kg:/m/02vn_yv | William | Woodward | M | 24091 | ||||||||||||||||||
W000734 | James Woodworth | W000734 | 411885 | 10364 | James Hutchinson Woodworth | Q3246869 | kg:/m/03spql | James | Woodworth | 1804-12-04 | M | 24092 | Hutchinson | ||||||||||||||||
W000735 | Laurin Woodworth | W000735 | 411886 | 10365 | Laurin D. Woodworth | Q6501819 | kg:/m/02rm28r | Laurin | Woodworth | 1837-09-10 | M | 24093 | Dewey | ||||||||||||||||
W000736 | William Woodworth | W000736 | 411887 | 10366 | William W. Woodworth | Q1382969 | kg:/m/02rkycw | William | Woodworth | 1807-03-16 | M | 24094 | W. | ||||||||||||||||
W000737 | Harry Woodyard | W000737 | 411888 | 10367 | Harry C. Woodyard | Q1586423 | kg:/m/03b_ttf | Harry | Woodyard | 1867-11-13 | M | 24096 | Chapman | ||||||||||||||||
W000738 | Lynn Woolsey | W000738 | 400436 | 29309 | Lynn Woolsey | Q291157 | kg:/m/024shx | Lynn | Woolsey | 1937-11-03 | F | 24098 | C. | 01242 | 26132 | 26733 | Lynn C. Woolsey | N00007458 | [ "H2CA01045" ] |
||||||||||
W000739 | Ephraim Woomer | W000739 | 411889 | 10368 | Ephraim Milton Woomer | Q5382313 | kg:/m/0ksfdg | Ephraim | Woomer | 1844-01-14 | M | 24100 | Milton |
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);