legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by id_house_history_alternate 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
- H2OH02085 1
- H2SC02059 1
- H2TX14149 1
- H2TX33040 1
- H4AR04048 1
- H4CA45097 1
- H4FL20023 1
- H4GA08067 1
- H4IA03115 1
- H4MI07103 1
- H4MT01041 1
- H4NC06052 1
- H4NJ12149 1
- H6AK00045 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
W000492 | Charles Williams | W000492 | 411649 | 10137 | Charles G. Williams | Q1064487 | kg:/m/02vrqww | Charles | Williams | 1829-10-18 | M | 23800 | Grandison | ||||||||||||||||
W000493 | Christopher Williams | W000493 | 411650 | 10138 | Christopher Harris Williams | Q1086715 | kg:/m/0cglr5 | Christopher | Williams | 1798-12-18 | M | 23801 | Harris | ||||||||||||||||
W000494 | Clyde Williams | W000494 | 411651 | 10139 | Clyde Williams (Missouri politician) | Q1103739 | kg:/m/02rz5sp | Clyde | Williams | 1873-10-13 | M | 23802 | |||||||||||||||||
W000495 | David Williams | W000495 | 411652 | 10140 | David Rogerson Williams | Q1176375 | kg:/m/0264v47 | David | Williams | 1776-03-08 | M | 23803 | Rogerson | ||||||||||||||||
W000496 | Elihu Williams | W000496 | 411653 | 10141 | Elihu S. Williams | Q5360861 | kg:/m/0czx4k | Elihu | Williams | 1835-01-24 | M | 23805 | Stephen | ||||||||||||||||
W000497 | George Williams | W000497 | 411654 | 10142 | George F. Williams | Q1507335 | kg:/m/02rhgjf | George | Williams | 1852-07-10 | M | 23806 | Fred | ||||||||||||||||
W000498 | George Williams | W000498 | 411655 | 10143 | George Henry Williams | Q725008 | kg:/m/03gjcr | George | Williams | 1823-03-26 | M | Henry | |||||||||||||||||
W000499 | George Williams | W000499 | 411656 | 10144 | George Howard Williams | Q595844 | kg:/m/0c894n | George | Williams | 1871-12-01 | M | Howard | |||||||||||||||||
W000500 | George Williams | W000500 | 411657 | 10145 | George S. Williams | Q1508225 | kg:/m/025xkbn | George | Williams | 1877-10-21 | M | 23809 | Short | ||||||||||||||||
W000501 | Guinn Williams | W000501 | 411658 | 10146 | Guinn Williams | Q1554136 | kg:/m/03c2zy7 | Guinn | Williams | 1871-04-22 | M | 23810 | |||||||||||||||||
W000502 | Harrison Williams | W000502 | 411659 | 10147 | Harrison A. Williams | Q1586255 | kg:/m/051d1d | Harrison | Williams | 1919-12-10 | M | 23812 | Arlington | Jr. | 01455 | ||||||||||||||
W000503 | Henry Williams | W000503 | 411660 | 10148 | Henry Williams (Massachusetts politician) | Q993376 | kg:/m/02rl4d1 | Henry | Williams | 1805-11-30 | M | 23813 | |||||||||||||||||
W000504 | Hezekiah Williams | W000504 | 411661 | 10149 | Hezekiah Williams | Q1617045 | kg:/m/02rxlqj | Hezekiah | Williams | 1798-07-28 | M | 23814 | |||||||||||||||||
W000505 | Isaac Williams | W000505 | 411662 | 10150 | Isaac Williams Jr. | Q2507394 | kg:/m/026_tvl | Isaac | Williams | 1777-04-05 | M | 23815 | Jr. | ||||||||||||||||
W000506 | James Williams | W000506 | 411663 | 10151 | James Williams (Delaware politician) | Q1681306 | kg:/m/034p3b | James | Williams | 1825-08-04 | M | 23816 | |||||||||||||||||
W000507 | James Williams | W000507 | 411664 | 10152 | James D. Williams | Q1484759 | kg:/m/0bpfrn | James | Williams | 1808-01-16 | M | 23817 | Douglas | ||||||||||||||||
W000508 | James Williams | W000508 | 411665 | 10153 | James R. Williams | Q6141762 | kg:/m/02rkb76 | James | Williams | 1850-12-27 | M | 23819 | Robert | ||||||||||||||||
W000509 | James Williams | W000509 | 411666 | 10154 | James Wray Williams | Q983225 | kg:/m/02rhjl4 | James | Williams | 1792-10-08 | M | 23820 | Wray | ||||||||||||||||
W000510 | Jared Williams | W000510 | 411667 | 10155 | Jared Williams (Virginia politician) | Q1683483 | kg:/m/03c2__k | Jared | Williams | 1766-03-04 | M | 23821 | |||||||||||||||||
W000511 | Jared Williams | W000511 | 411668 | 10156 | Jared W. Williams | Q884565 | kg:/m/086g1f | Jared | Williams | 1796-12-22 | M | 23823 | Warner | ||||||||||||||||
W000512 | Jeremiah Williams | W000512 | 411669 | 10157 | Jeremiah Norman Williams | Q1167064 | kg:/m/02rk1wf | Jeremiah | Williams | 1829-05-29 | M | 23824 | Norman | ||||||||||||||||
W000513 | John Williams | W000513 | 411671 | 10159 | John Williams (Salem, New York) | Q6264325 | kg:/m/0344_f | John | Williams | M | 23825 | ||||||||||||||||||
W000514 | John Williams | W000514 | 411673 | 10161 | John Williams (Rochester, New York) | Q13219191 | kg:/m/0345gw | John | Williams | 1807-01-07 | M | 23826 | |||||||||||||||||
W000516 | John Williams | W000516 | 411672 | 10160 | John Williams (Tennessee politician) | Q460926 | kg:/m/03458w | John | Williams | 1778-01-29 | M | ||||||||||||||||||
W000517 | John Williams | W000517 | 411674 | 10162 | John Bell Williams | Q518055 | kg:/m/01hj2n | John | Williams | 1918-12-04 | M | 23829 | Bell | ||||||||||||||||
W000518 | John Williams | W000518 | 411675 | 10163 | John J. Williams (politician) | Q1726940 | kg:/m/04pdkr | John | Williams | 1904-05-17 | M | James | |||||||||||||||||
W000519 | John Williams | W000519 | 411676 | 10164 | John M. S. Williams | Q1700931 | kg:/m/02rhkcl | John | Williams | 1818-08-13 | M | 23831 | McKeown Snow | ||||||||||||||||
W000520 | John Williams | W000520 | 411677 | 14672 | Pat Williams (Montana politician) | Q1701350 | kg:/m/0chy67 | John | Williams | 1937-10-30 | M | 23833 | Patrick | 01231 | |||||||||||||||
W000521 | John Williams | W000521 | 411678 | 10165 | John Sharp Williams | Q1701734 | kg:/m/02fqj3 | John | Williams | 1854-07-30 | M | 23835 | Sharp | ||||||||||||||||
W000522 | John Williams | W000522 | 411679 | 10166 | John Stuart Williams | Q6242827 | kg:/m/0b_nkg | John | Williams | 1818-07-10 | M | Stuart | |||||||||||||||||
W000523 | Jonathan Williams | W000523 | 411680 | Jonathan Williams (engineer) | Q6274789 | kg:/m/0631j1 | Jonathan | Williams | 1750-05-20 | M | 23837 | ||||||||||||||||||
W000524 | Joseph Williams | W000524 | 411681 | 10168 | Joseph Lanier Williams | Q1707473 | kg:/m/0cglpt | Joseph | Williams | 1810-10-23 | M | 23838 | Lanier | ||||||||||||||||
W000525 | Lawrence Williams | W000525 | 411682 | 11056 | Lawrence G. Williams | Q6504082 | kg:/m/0dp9zj | Lawrence | Williams | 1913-09-15 | M | 23839 | Gordon | 01229 | |||||||||||||||
W000526 | Lemuel Williams | W000526 | 411683 | 10169 | Lemuel Williams | Q1470256 | kg:/m/0261tjm | Lemuel | Williams | 1747-06-18 | M | 23840 | |||||||||||||||||
W000527 | Lewis Williams | W000527 | 411684 | 10170 | Lewis Williams | Q1822173 | kg:/m/05k3vf | Lewis | Williams | 1782-02-01 | M | 23841 | |||||||||||||||||
W000528 | Lyle Williams | W000528 | 411685 | 14671 | Lyle Williams | Q1878709 | kg:/m/0b_2wl | Lyle | Williams | 1942-08-23 | M | 23843 | 01230 | ||||||||||||||||
W000529 | Marmaduke Williams | W000529 | 411686 | 10171 | Marmaduke Williams | Q1311606 | kg:/m/04z0h0 | Marmaduke | Williams | 1774-04-06 | M | 23844 | |||||||||||||||||
W000530 | Morgan Williams | W000530 | 411687 | 10172 | Morgan B. Williams | Q6911580 | kg:/m/0ksf3t | Morgan | Williams | 1831-09-17 | M | 23845 | B. | ||||||||||||||||
W000531 | Nathan Williams | W000531 | 411688 | 10173 | Nathan Williams (politician) | Q2913186 | kg:/m/026kc77 | Nathan | Williams | 1773-12-19 | M | 23846 | |||||||||||||||||
W000532 | Reuel Williams | W000532 | 411689 | 10174 | Reuel Williams | Q6242897 | kg:/m/0bnwxz | Reuel | Williams | 1783-06-02 | M | ||||||||||||||||||
W000533 | Richard Williams | W000533 | 411690 | 10175 | Richard Williams (congressman) | Q2150925 | kg:/m/027l3d5 | Richard | Williams | 1836-11-15 | M | 23848 | |||||||||||||||||
W000534 | Robert Williams | W000534 | 412118 | 10176 | Robert Williams (Mississippi politician) | Q16859222 | kg:/m/04fs05 | Robert | Williams | M | 23849 | ||||||||||||||||||
W000535 | Seward Williams | W000535 | 411691 | 10177 | Seward H. Williams | Q7458175 | kg:/m/02rm325 | Seward | Williams | 1870-11-07 | M | 23850 | Henry | ||||||||||||||||
W000536 | Sherrod Williams | W000536 | 411692 | 10178 | Sherrod Williams | Q1315807 | kg:/m/02rjzb_ | Sherrod | Williams | M | 23851 | ||||||||||||||||||
W000537 | Thomas Williams | W000537 | 411694 | 10180 | Thomas Williams (Alabama politician) | Q2428183 | kg:/m/0h7j7g | Thomas | Williams | 1825-08-11 | M | 23852 | |||||||||||||||||
W000538 | Thomas Williams | W000538 | 411693 | 10179 | Thomas Williams (Pennsylvania politician) | Q13219857 | kg:/m/0h7hzx | Thomas | Williams | 1806-08-28 | M | 23854 | |||||||||||||||||
W000539 | Thomas Williams | W000539 | 411695 | 10181 | Thomas Hickman Williams | Q4355159 | kg:/m/0cytzg | Thomas | Williams | 1801-01-20 | M | Hickman | |||||||||||||||||
W000540 | Thomas Williams | W000540 | 411696 | 10182 | Thomas Hill Williams | Q2424740 | kg:/m/0cyt_v | Thomas | Williams | M | Hill | ||||||||||||||||||
W000541 | Thomas Williams | W000541 | 411697 | 10183 | Thomas Scott Williams | Q1740412 | kg:/m/02rk086 | Thomas | Williams | 1777-06-26 | M | 23857 | Scott | ||||||||||||||||
W000542 | Thomas Williams | W000542 | 411698 | 10184 | Thomas Sutler Williams | Q7794286 | kg:/m/02rl16y | Thomas | Williams | 1872-02-14 | M | 23858 | Sutler | ||||||||||||||||
W000543 | Thomas Williams | W000543 | 411699 | 10185 | Thomas Wheeler Williams | Q1761286 | kg:/m/02rk09l | Thomas | Williams | 1789-09-28 | M | 23859 | Wheeler | ||||||||||||||||
W000544 | William Williams | W000544 | 411702 | 10187 | William Williams (New York politician) | Q8020383 | kg:/m/02rl1r3 | William | Williams | 1815-09-06 | M | 23860 | |||||||||||||||||
W000545 | William Williams | W000545 | 411701 | 10188 | William Williams (Indiana politician) | Q1436876 | kg:/m/02rl1qs | William | Williams | 1821-05-11 | M | 23861 | |||||||||||||||||
W000547 | William Williams | W000547 | 411703 | 10189 | William B. Williams (politician) | Q1299993 | kg:/m/02ppm0y | William | Williams | 1826-07-28 | M | 23863 | Brewster | ||||||||||||||||
W000548 | William Williams | W000548 | 411704 | 10190 | William E. Williams | Q7870829 | kg:/m/02rkdc8 | William | Williams | 1857-05-05 | M | 23865 | Elza | ||||||||||||||||
W000549 | William Williams | W000549 | 411705 | 10191 | William R. Williams | Q8017310 | kg:/m/0kt25l | William | Williams | 1884-08-11 | M | 23866 | Robert | ||||||||||||||||
W000550 | Ben Williamson | W000550 | 411706 | 10192 | Ben M. Williamson | Q816552 | kg:/m/0b3cf8 | Ben | Williamson | 1864-10-16 | M | Mitchell | |||||||||||||||||
W000551 | Hugh Williamson | W000551 | 411707 | 10193 | Hugh Williamson | Q663151 | kg:/m/02pyy0 | Hugh | Williamson | 1735-12-05 | M | 23868 | |||||||||||||||||
W000552 | John Williamson | W000552 | 411708 | 10194 | John N. Williamson | Q1701190 | kg:/m/0280cgp | John | Williamson | 1855-11-08 | M | 23869 | Newton | ||||||||||||||||
W000553 | William Williamson | W000553 | 411709 | 10195 | William Williamson (politician) | Q1406704 | kg:/m/0b6m1w | William | Williamson | 1875-10-07 | M | 23870 | |||||||||||||||||
W000554 | William Williamson | W000554 | 411710 | 10196 | William D. Williamson | Q888199 | kg:/m/07wvng | William | Williamson | 1779-07-31 | M | 23871 | Durkee | ||||||||||||||||
W000555 | Asa Willie | W000555 | 411711 | 10197 | Asa H. Willie | Q720112 | kg:/m/02z26qh | Asa | Willie | 1829-10-11 | M | 23872 | Hoxie | ||||||||||||||||
W000557 | Albert Willis | W000557 | 411713 | 10199 | Albert S. Willis | Q2638694 | kg:/m/02rgv12 | Albert | Willis | 1843-01-22 | M | 23874 | Shelby | ||||||||||||||||
W000558 | Benjamin Willis | W000558 | 411714 | 10200 | Benjamin A. Willis | Q2114922 | kg:/m/02rkmgv | Benjamin | Willis | 1840-03-24 | M | 23875 | Albertson | ||||||||||||||||
W000559 | Edwin Willis | W000559 | 411715 | 10201 | Edwin E. Willis | Q1294506 | kg:/m/0bxz00 | Edwin | Willis | 1904-10-02 | M | 23876 | Edward | ||||||||||||||||
W000560 | Francis Willis | W000560 | 411716 | 10202 | Francis Willis (Representative) | Q1361138 | kg:/m/0265tn5 | Francis | Willis | 1745-01-05 | M | 23877 | |||||||||||||||||
W000561 | Frank Willis | W000561 | 411717 | 10203 | Frank B. Willis | Q881420 | kg:/m/033tyr | Frank | Willis | 1871-12-28 | M | 23879 | Bartlett | ||||||||||||||||
W000562 | Jonathan Willis | W000562 | 411718 | 10204 | Jonathan S. Willis | Q1703296 | kg:/m/02639pb | Jonathan | Willis | 1830-04-05 | M | 23881 | Spencer | ||||||||||||||||
W000563 | Raymond Willis | W000563 | 411719 | 10205 | Raymond E. Willis | Q2134139 | kg:/m/0cyn5v | Raymond | Willis | 1875-08-11 | M | Eugene | |||||||||||||||||
W000564 | Edwin Willits | W000564 | 411720 | 10206 | Edwin Willits | Q1295065 | kg:/m/027jhyh | Edwin | Willits | 1830-04-24 | M | 23883 | |||||||||||||||||
W000565 | Westel Willoughby | W000565 | 411721 | 10207 | Westel Willoughby Jr. | Q3661182 | kg:/m/02rkxp4 | Westel | Willoughby | 1769-11-20 | M | 23884 | Jr. | ||||||||||||||||
W000566 | David Wilmot | W000566 | 411722 | 10208 | David Wilmot | Q5241190 | kg:/m/0382rn | David | Wilmot | 1814-01-20 | M | 23886 | |||||||||||||||||
W000567 | William Wilshire | W000567 | 411723 | 10209 | William W. Wilshire | Q2580965 | kg:/m/02rk05t | William | Wilshire | 1830-09-08 | M | 23887 | Wallace | ||||||||||||||||
W000568 | Alexander Wilson | W000568 | 412119 | 10210 | Alexander Wilson (Virginia politician) | Q1535167 | kg:/m/03c2_h7 | Alexander | Wilson | M | 23888 | ||||||||||||||||||
W000569 | Benjamin Wilson | W000569 | 411724 | 10211 | Benjamin Wilson (congressman) | Q817744 | kg:/m/03bykdg | Benjamin | Wilson | 1825-04-30 | M | 23889 | |||||||||||||||||
W000570 | Charles Wilson | W000570 | 411725 | 14062 | Charlie Wilson (Texas politician) | Q333430 | kg:/m/01_rx2 | Charles | Wilson | 1933-06-01 | M | 23891 | 01232 | ||||||||||||||||
W000571 | Charles Wilson | W000571 | 411726 | 10640 | Charles H. Wilson | Q1064708 | kg:/m/09ty0b | Charles | Wilson | 1917-02-15 | M | 23892 | Herbert | 01233 | |||||||||||||||
W000572 | Earl Wilson | W000572 | 411727 | 10212 | Earl Wilson (politician) | Q1277195 | kg:/m/026gn1x | Earl | Wilson | 1906-04-18 | M | 23894 | |||||||||||||||||
W000573 | Edgar Wilson | W000573 | 411728 | 10213 | Edgar Wilson | Q1284215 | kg:/m/0d5zk7 | Edgar | Wilson | 1861-02-25 | M | 23896 | |||||||||||||||||
W000574 | Edgar Wilson | W000574 | 411729 | 10214 | Edgar C. Wilson | Q1283830 | kg:/m/03c2_mv | Edgar | Wilson | 1800-10-18 | M | 23897 | Campbell | ||||||||||||||||
W000575 | Emmett Wilson | W000575 | 411730 | 10215 | Emmett Wilson | Q1338739 | kg:/m/02q62fx | Emmett | Wilson | 1882-09-17 | M | 23898 | |||||||||||||||||
W000576 | Ephraim Wilson | W000576 | 411731 | 10216 | Ephraim King Wilson | Q434499 | kg:/m/057gx5 | Ephraim | Wilson | 1771-09-15 | M | 23899 | King | ||||||||||||||||
W000577 | Ephraim Wilson | W000577 | 411732 | 10217 | Ephraim King Wilson II | Q434526 | kg:/m/057gwv | Ephraim | Wilson | 1821-12-22 | M | 23901 | King | ||||||||||||||||
W000578 | Eugene Wilson | W000578 | 411733 | 10218 | Eugene McLanahan Wilson | Q1373151 | kg:/m/0dnd_m | Eugene | Wilson | 1833-12-25 | M | 23902 | McLanahan | ||||||||||||||||
W000579 | Francis Wilson | W000579 | 411734 | 10219 | Francis H. Wilson | Q404754 | kg:/m/02rkpd7 | Francis | Wilson | 1844-02-11 | M | 23904 | Henry | ||||||||||||||||
W000580 | Frank Wilson | W000580 | 411735 | 10220 | Frank E. Wilson | Q328146 | kg:/m/02rkpdy | Frank | Wilson | 1857-12-22 | M | 23906 | Eugene | ||||||||||||||||
W000581 | George Wilson | W000581 | 411736 | 10221 | George A. Wilson | Q382688 | kg:/m/0cvj7c | George | Wilson | 1884-04-01 | M | Allison | |||||||||||||||||
W000582 | George Wilson | W000582 | 411737 | 10222 | George H. Wilson | Q1507488 | kg:/m/02rr719 | George | Wilson | 1905-08-21 | M | 23909 | Howard | ||||||||||||||||
W000583 | George Wilson | W000583 | 411738 | 10223 | George W. Wilson | Q5545776 | kg:/m/02rm0tm | George | Wilson | 1840-02-22 | M | 23911 | Washington | ||||||||||||||||
W000584 | Henry Wilson | W000584 | 411740 | 10224 | Henry Wilson (Pennsylvania politician) | Q5730347 | kg:/m/027gxxs | Henry | Wilson | M | 23912 | ||||||||||||||||||
W000585 | Henry Wilson | W000585 | 411739 | 10225 | Henry Wilson | Q313302 | kg:/m/0m8k6 | Henry | Wilson | 1812-02-16 | M | ||||||||||||||||||
W000586 | Isaac Wilson | W000586 | 411741 | 10226 | Isaac Wilson (1780–1848) | Q6077328 | kg:/m/02rkqys | Isaac | Wilson | 1780-06-25 | M | 23914 | |||||||||||||||||
W000587 | James Wilson | W000587 | 411745 | 10229 | James Wilson II | Q1681312 | kg:/m/02rr76t | James | Wilson | 1797-03-18 | M | 23915 | |||||||||||||||||
W000588 | James Wilson | W000588 | 411744 | 10230 | James Wilson (Pennsylvania politician) | Q6145690 | kg:/m/027gv_k | James | Wilson | 1779-04-28 | M | 23916 | |||||||||||||||||
W000589 | James Wilson | W000589 | 411746 | 10231 | James Wilson (Indiana politician) | Q1265712 | kg:/m/02w2zzy | James | Wilson | 1825-04-09 | M | 23917 | |||||||||||||||||
W000590 | James Wilson | W000590 | 411747 | 10232 | James Wilson (Secretary of Agriculture) | Q373094 | kg:/m/02k6x3 | James | Wilson | 1835-08-16 | M | 23918 | |||||||||||||||||
W000592 | James Wilson | W000592 | 411743 | 10228 | James Wilson I (New Hampshire politician) | Q1681311 | kg:/m/02rr763 | James | Wilson | 1766-08-16 | M | 23920 | |||||||||||||||||
W000593 | James Wilson | W000593 | 411748 | 10233 | James Clifton Wilson | Q252399 | kg:/m/03c2zx6 | James | Wilson | 1874-06-21 | M | 23921 | Clifton | ||||||||||||||||
W000594 | James Wilson | W000594 | 411749 | 10234 | James F. Wilson | Q1124603 | kg:/m/02k6rc | James | Wilson | 1828-10-19 | M | 23923 | Falconer | ||||||||||||||||
W000595 | James Wilson | W000595 | 411750 | 10235 | James J. Wilson | Q1680626 | kg:/m/044ffj | James | Wilson | M | Jefferson |
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);