legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by id_wikidata
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
B001012 | Charles Buck | B001012 | 401962 | 1193 | Charles F. Buck | Q1064315 | kg:/m/02rv9l9 | Charles | Buck | 1841-11-05 | M | 10085 | Francis | ||||||||||||||||
M000095 | Charles Manderson | M000095 | 407119 | 5951 | Charles F. Manderson | Q1064321 | kg:/m/09n5n_ | Charles | Manderson | 1837-02-09 | M | Frederick | |||||||||||||||||
O000042 | Charles Ogden | O000042 | 408325 | 7030 | Charles F. Ogden | Q1064324 | kg:/m/02rhd65 | Charles | Ogden | 1873-02-04 | M | 19121 | Franklin | ||||||||||||||||
M000642 | Charles Mercer | M000642 | 407628 | 6415 | Charles F. Mercer | Q1064325 | kg:/m/0ks2qy | Charles | Mercer | 1778-06-16 | M | 18128 | Fenton | ||||||||||||||||
S000742 | Charles Sprague | S000742 | 410211 | 8801 | Charles F. Sprague | Q1064326 | kg:/m/02rhd6j | Charles | Sprague | 1857-06-10 | M | 22055 | Franklin | ||||||||||||||||
O000008 | Charles O’Brien | O000008 | 408259 | 6997 | Charles F. X. O'Brien | Q1064333 | kg:/m/0270zkx | Charles | O’Brien | 1879-03-07 | M | 19080 | Francis Xavier | ||||||||||||||||
F000130 | Charles Finley | F000130 | 404085 | 3152 | Charles Finley (politician) | Q1064356 | kg:/m/02qlh1k | Charles | Finley | 1865-03-26 | M | 13135 | |||||||||||||||||
F000144 | Charles Fisher | F000144 | 404099 | 3164 | Charles Fisher (congressman) | Q1064360 | kg:/m/03c2zfh | Charles | Fisher | 1789-10-20 | M | 13152 | |||||||||||||||||
J000124 | Charles Johnson | J000124 | 406023 | 4947 | Charles Fletcher Johnson | Q1064377 | kg:/m/0bpjtv | Charles | Johnson | 1859-02-14 | M | Fletcher | |||||||||||||||||
H000340 | Charles Hatcher | H000340 | 405209 | 14831 | Charles Floyd Hatcher | Q1064383 | kg:/m/0gsh09 | Charles | Hatcher | 1939-07-01 | M | 14702 | Floyd | 00514 | |||||||||||||||
J000274 | Charles Joy | J000274 | 406166 | 5079 | Charles Frederick Joy | Q1064442 | kg:/m/02rz5nx | Charles | Joy | 1849-12-11 | M | 16042 | Frederick | ||||||||||||||||
S000166 | Charles Scott | S000166 | 409673 | 8293 | Charles Frederick Scott | Q1064445 | kg:/m/02rmb1_ | Charles | Scott | 1860-09-07 | M | 21348 | Frederick | ||||||||||||||||
C000683 | Charles Conn | C000683 | 402809 | 1985 | Charles G. Conn | Q1064476 | kg:/m/02rkf4q | Charles | Conn | 1844-01-29 | M | 11310 | Gerard | ||||||||||||||||
O000004 | Charles Oakman | O000004 | 408316 | 6995 | Charles G. Oakman | Q1064484 | kg:/m/02q4x0r | Charles | Oakman | 1903-09-04 | M | 19073 | Gibb | ||||||||||||||||
W000171 | Charles Washburn | W000171 | 411344 | 9849 | Charles G. Washburn | Q1064486 | kg:/m/026n82f | Charles | Washburn | 1857-01-28 | M | 23413 | Grenfill | ||||||||||||||||
W000492 | Charles Williams | W000492 | 411649 | 10137 | Charles G. Williams | Q1064487 | kg:/m/02vrqww | Charles | Williams | 1829-10-18 | M | 23800 | Grandison | ||||||||||||||||
B001147 | Charles Burton | B001147 | 402090 | 1315 | Charles Germman Burton | Q1064531 | kg:/m/02rz5p7 | Charles | Burton | 1846-04-04 | M | 10252 | Germman | ||||||||||||||||
E000062 | Charles Edwards | E000062 | 403757 | 2861 | Charles Gordon Edwards | Q1064576 | kg:/m/026hxrf | Charles | Edwards | 1878-07-02 | M | 12676 | Gordon | ||||||||||||||||
R000436 | Charles Rose | R000436 | 409400 | 14048 | Charlie Rose (politician) | Q1064593 | kg:/m/0435xy | Charles | Rose | 1939-08-10 | M | 20626 | Grandison | III | 00986 | ||||||||||||||
B000466 | Charles Binderup | B000466 | 401449 | 713 | Charles Gustav Binderup | Q1064640 | kg:/m/09_0dv | Charles | Binderup | 1873-03-05 | M | 9379 | Gustav | ||||||||||||||||
E000160 | Charles Elston | E000160 | 403851 | 2948 | Charles H. Elston | Q1064657 | kg:/m/02rhd6w | Charles | Elston | 1891-08-01 | M | 12790 | Henry | ||||||||||||||||
B001087 | Charles Burke | B001087 | 402033 | 1261 | Charles H. Burke | Q1064658 | kg:/m/07wwxg | Charles | Burke | 1861-04-01 | M | 10179 | Henry | ||||||||||||||||
G000458 | Charles Griffin | G000458 | 404803 | 11065 | Charles H. Griffin | Q1064666 | kg:/m/02rtn6r | Charles | Griffin | 1926-05-09 | M | 14143 | Hudson | ||||||||||||||||
L000099 | Charles Larrabee | L000099 | 406606 | 5478 | Charles H. Larrabee | Q1064670 | kg:/m/02vrqg3 | Charles | Larrabee | 1820-11-09 | M | 16717 | Hathaway | ||||||||||||||||
M000172 | Charles Martin | M000172 | 407194 | 6018 | Charles H. Martin (North Carolina politician) | Q1064671 | kg:/m/03c2t69 | Charles | Martin | 1848-08-28 | M | 17537 | Henry | ||||||||||||||||
L000185 | Charles Leavy | L000185 | 406687 | 5549 | Charles H. Leavy | Q1064674 | kg:/m/02rmn0j | Charles | Leavy | 1884-02-16 | M | 16827 | Henry | ||||||||||||||||
P000015 | Charles Page | P000015 | 408426 | 7153 | Charles H. Page | Q1064675 | kg:/m/02rhd76 | Charles | Page | 1843-07-19 | M | 19301 | Harrison | ||||||||||||||||
P000173 | Charles Peaslee | P000173 | 408577 | 7291 | Charles H. Peaslee | Q1064684 | kg:/m/02rhd7k | Charles | Peaslee | 1804-02-06 | M | 19492 | Hazen | ||||||||||||||||
P000438 | Charles Porter | P000438 | 408829 | 7532 | Charles H. Porter | Q1064686 | kg:/m/02rtntn | Charles | Porter | 1833-06-21 | M | 19824 | Howell | ||||||||||||||||
P000222 | Charles Percy | P000222 | 408625 | 11205 | Charles H. Percy | Q1064692 | kg:/m/02hbd5 | Charles | Percy | 1919-09-27 | M | Harting | 01418 | ||||||||||||||||
T000067 | Charles Taylor | T000067 | 400398 | 29135 | Charles H. Taylor | Q1064695 | kg:/m/03g_xy | Charles | Taylor | 1941-01-23 | M | 22718 | H. | 01141 | N00002383 | ||||||||||||||
U000030 | Charles Upton | U000030 | 411053 | 9575 | Charles H. Upton | Q1064699 | kg:/m/0280ll0 | Charles | Upton | 1812-08-23 | M | 20866 | Horace | ||||||||||||||||
V000117 | Charles Voorhis | V000117 | 411171 | 9686 | Charles H. Voorhis | Q1064700 | kg:/m/02r7xy7 | Charles | Voorhis | 1833-03-13 | M | 21017 | Henry | ||||||||||||||||
W000259 | Charles Weisse | W000259 | 411427 | 9922 | Charles H. Weisse | Q1064707 | kg:/m/02vrqtt | Charles | Weisse | 1866-10-24 | M | 23529 | Herman | ||||||||||||||||
W000571 | Charles Wilson | W000571 | 411726 | 10640 | Charles H. Wilson | Q1064708 | kg:/m/09ty0b | Charles | Wilson | 1917-02-15 | M | 23892 | Herbert | 01233 | |||||||||||||||
D000348 | Charles Dillon | D000348 | 403466 | 2598 | Charles Hall Dillon | Q1064716 | kg:/m/02prlf9 | Charles | Dillon | 1853-12-18 | M | 12259 | Hall | ||||||||||||||||
H000020 | Charles Haight | H000020 | 404905 | 3908 | Charles Haight | Q1064718 | kg:/m/02wvl2j | Charles | Haight | 1838-01-04 | M | 14313 | |||||||||||||||||
B000908 | Charles Brown | B000908 | 401865 | 1103 | Charles Harrison Brown | Q1064752 | kg:/m/02rz6pz | Charles | Brown | 1920-10-22 | M | 9953 | Harrison | ||||||||||||||||
H000375 | Charles Hawks | H000375 | 405243 | 4218 | Charles Hawks Jr. | Q1064761 | kg:/m/026rqgc | Charles | Hawks | 1899-07-07 | M | 14743 | Jr. | ||||||||||||||||
H000402 | Charles Hays | H000402 | 405269 | 4241 | Charles Hays | Q1064770 | kg:/m/02rk1d_ | Charles | Hays | 1834-02-02 | M | 14778 | |||||||||||||||||
H000388 | Charles Hayes | H000388 | 405256 | 15079 | Charles Hayes (politician) | Q1064774 | kg:/m/0fq156 | Charles | Hayes | 1918-02-17 | M | 14760 | Arthur | 00516 | |||||||||||||||
Y000018 | Charles Yoakum | Y000018 | 411952 | 10425 | Charles Henderson Yoakum | Q1064793 | kg:/m/03c2zpb | Charles | Yoakum | 1849-07-10 | M | 21053 | Henderson | ||||||||||||||||
M000944 | Charles Morgan | M000944 | 407912 | 6672 | Charles Henry Morgan | Q1064811 | kg:/m/02rxcv9 | Charles | Morgan | 1842-07-05 | M | 18516 | Henry | ||||||||||||||||
S000491 | Charles Sloan | S000491 | 409979 | 8579 | Charles Henry Sloan | Q1064821 | kg:/m/09zfdh | Charles | Sloan | 1863-05-02 | M | 21751 | Henry | ||||||||||||||||
J000275 | Charles Joyce | J000275 | 406167 | 5080 | Charles Herbert Joyce | Q1064832 | kg:/m/02rhd98 | Charles | Joyce | 1830-01-30 | M | 16043 | Herbert | ||||||||||||||||
B000767 | Charles Brand | B000767 | 401726 | 976 | Charles Hillyer Brand | Q1064848 | kg:/m/026x907 | Charles | Brand | 1861-04-20 | M | 9768 | Hillyer | ||||||||||||||||
R000036 | Charles Randall | R000036 | 409017 | 7712 | Charles Hiram Randall | Q1064856 | kg:/m/08k9db | Charles | Randall | 1865-07-23 | M | 20120 | Hiram | ||||||||||||||||
H000761 | Charles Hooks | H000761 | 405612 | 4556 | Charles Hooks | Q1064868 | kg:/m/09yl7b | Charles | Hooks | 1768-02-20 | M | 15226 | |||||||||||||||||
H000907 | Charles Hudson | H000907 | 405753 | 4687 | Charles Hudson (American politician) | Q1064907 | kg:/m/02qxbzz | Charles | Hudson | 1795-11-14 | M | 15405 | |||||||||||||||||
A000324 | Charles Atherton | A000324 | 400972 | 279 | Charles Humphrey Atherton | Q1064921 | kg:/m/09l0f6 | Charles | Atherton | 1773-08-14 | M | 8707 | Humphrey | ||||||||||||||||
S000850 | Charles Stengle | S000850 | 410314 | 8882 | Charles I. Stengle | Q1064937 | kg:/m/02rkmxy | Charles | Stengle | 1869-12-05 | M | 22189 | Irwin | ||||||||||||||||
S000703 | Charles Sparks | S000703 | 410174 | 8766 | Charles I. Sparks | Q1064939 | kg:/m/02rmb5f | Charles | Sparks | 1872-12-20 | M | 22007 | Isaac | ||||||||||||||||
B000580 | Charles Boatner | B000580 | 401551 | 813 | Charles J. Boatner | Q1064982 | kg:/m/02rv9k8 | Charles | Boatner | 1849-01-23 | M | 9527 | Jahleal | ||||||||||||||||
F000044 | Charles Faulkner | F000044 | 404004 | 3080 | Charles J. Faulkner | Q1064984 | kg:/m/025t99y | Charles | Faulkner | 1806-07-06 | M | 13020 | James | ||||||||||||||||
C000164 | Charles Carney | C000164 | 402312 | 12044 | Charles J. Carney | Q1064987 | kg:/m/02rhd9m | Charles | Carney | 1913-04-17 | M | 10659 | Joseph | 00177 | |||||||||||||||
G000213 | Charles Gilman | G000213 | 404575 | 3608 | Charles J. Gilman | Q1064991 | kg:/m/02ry1p9 | Charles | Gilman | 1824-02-26 | M | 13835 | Jervis | ||||||||||||||||
H000919 | Charles Hughes | H000919 | 405764 | 4698 | Charles J. Hughes Jr. | Q1064997 | kg:/m/0b9yhl | Charles | Hughes | 1853-02-16 | M | James | Jr. | ||||||||||||||||
F000045 | Charles Faulkner | F000045 | 404005 | 3081 | Charles James Faulkner | Q1065023 | kg:/m/0cwlyd | Charles | Faulkner | 1847-09-21 | M | James | |||||||||||||||||
J000123 | Charles Johnson | J000123 | 412057 | 4946 | Charles Johnson (North Carolina politician) | Q1065087 | kg:/m/09v5w7 | Charles | Johnson | M | 15848 | ||||||||||||||||||
B000333 | Charles Bell | B000333 | 401325 | 599 | Charles K. Bell | Q1065136 | kg:/m/03c00cj | Charles | Bell | 1853-04-18 | M | 9209 | Keith | ||||||||||||||||
W000331 | Charles Wheeler | W000331 | 411493 | 9985 | Charles K. Wheeler | Q1065143 | kg:/m/02rhdb_ | Charles | Wheeler | 1863-04-18 | M | 23610 | Kennedy | ||||||||||||||||
K000227 | Charles Kinsey | K000227 | 406386 | 5284 | Charles Kinsey | Q1065174 | kg:/m/02vxpz | Charles | Kinsey | M | 16363 | ||||||||||||||||||
K000321 | Charles Kramer | K000321 | 406475 | 5363 | Charles Kramer (politician) | Q1065194 | kg:/m/03hn54r | Charles | Kramer | 1879-04-18 | M | 16485 | |||||||||||||||||
F000047 | Charles Faust | F000047 | 404007 | 3082 | Charles L. Faust | Q1065211 | kg:/m/02rz5q8 | Charles | Faust | 1879-04-24 | M | 13024 | Lee | ||||||||||||||||
G000169 | Charles Gifford | G000169 | 404536 | 3569 | Charles L. Gifford | Q1065220 | kg:/m/0bw0_f | Charles | Gifford | 1871-03-15 | M | 13778 | Laceille | ||||||||||||||||
H000503 | Charles Henry | H000503 | 405366 | 4329 | Charles L. Henry | Q1065221 | kg:/m/02rkf51 | Charles | Henry | 1849-07-01 | M | 14909 | Lewis | ||||||||||||||||
M001027 | Charles Moses | M001027 | 407994 | 6749 | Charles L. Moses | Q1065230 | kg:/m/02rk0pz | Charles | Moses | 1856-05-02 | M | 18615 | Leavell | ||||||||||||||||
R000211 | Charles Richards | R000211 | 409187 | 7866 | Charles L. Richards | Q1065231 | kg:/m/02730q5 | Charles | Richards | 1877-10-03 | M | 20344 | Lenmore | ||||||||||||||||
S000683 | Charles South | S000683 | 410154 | 8746 | Charles L. South | Q1065236 | kg:/m/03c2_2r | Charles | South | 1892-07-22 | M | 21982 | Lacy | ||||||||||||||||
S000167 | Charles Scott | S000167 | 409674 | 8294 | Charles L. Scott | Q1065238 | kg:/m/0bms22 | Charles | Scott | 1827-01-23 | M | 21349 | Lewis | ||||||||||||||||
U000006 | Charles Underhill | U000006 | 411030 | 9553 | Charles L. Underhill | Q1065240 | kg:/m/0bvd__ | Charles | Underhill | 1867-07-20 | M | 20833 | Lee | ||||||||||||||||
A000015 | Charles Abernethy | A000015 | 400677 | 12 | Charles Laban Abernethy | Q1065248 | kg:/m/04gpqm | Charles | Abernethy | 1872-03-18 | M | 8270 | Laban | ||||||||||||||||
B000199 | Charles Bartlett | B000199 | 401198 | 485 | Charles Lafayette Bartlett | Q1065249 | kg:/m/0gsgnh | Charles | Bartlett | 1853-01-31 | M | 9029 | Lafayette | ||||||||||||||||
B000635 | Charles Borchers | B000635 | 401600 | 859 | Charles M. Borchers | Q1065396 | kg:/m/02rk93t | Charles | Borchers | 1869-11-18 | M | 9604 | Martin | ||||||||||||||||
L000003 | Charles La Follette | L000003 | 406513 | 5400 | Charles M. La Follette | Q1065404 | kg:/m/04kswj | Charles | La Follette | 1898-02-27 | M | 16576 | Marion | ||||||||||||||||
T000109 | Charles Teague | T000109 | 410691 | 9240 | Charles M. Teague | Q1065410 | kg:/m/02rhdcp | Charles | Teague | 1909-09-18 | M | 22767 | McKevett | 01145 | |||||||||||||||
S000326 | Charles Shelley | S000326 | 409823 | 8436 | Charles M. Shelley | Q1065412 | kg:/m/02rk1fb | Charles | Shelley | 1833-12-28 | M | 21543 | Miller | ||||||||||||||||
C000703 | Charles Conrad | C000703 | 402828 | 2004 | Charles Magill Conrad | Q1065426 | kg:/m/05tvn8 | Charles | Conrad | 1804-12-24 | M | 11335 | Magill | ||||||||||||||||
S000827 | Charles Stedman | S000827 | 410291 | 8864 | Charles Manly Stedman | Q1065436 | kg:/m/02pn6q8 | Charles | Stedman | 1841-01-29 | M | 22163 | Manly | ||||||||||||||||
M000146 | Charles Marsh | M000146 | 407169 | 5993 | Charles Marsh (American politician) | Q1065454 | kg:/m/047hjh | Charles | Marsh | 1765-07-10 | M | 17506 | |||||||||||||||||
B000079 | Charles Bakewell | B000079 | 401082 | 376 | Charles Montague Bakewell | Q1065548 | kg:/m/01z_q3 | Charles | Bakewell | 1867-04-24 | M | 8875 | Montague | ||||||||||||||||
M001086 | Charles Murphey | M001086 | 408050 | 6803 | Charles Murphey | Q1065580 | kg:/m/0gmcss | Charles | Murphey | 1799-05-09 | M | 18685 | |||||||||||||||||
F000320 | Charles Fowler | F000320 | 404269 | 3322 | Charles N. Fowler | Q1065601 | kg:/m/02x181s | Charles | Fowler | 1852-11-02 | M | 13376 | Newell | ||||||||||||||||
F000068 | Charles Felton | F000068 | 404026 | 3098 | Charles N. Felton | Q1065605 | kg:/m/03sg_c | Charles | Felton | 1832-01-01 | M | 13052 | Norton | ||||||||||||||||
C000423 | Charles Clark | C000423 | 402562 | 1755 | Charles Nelson Clark | Q1065622 | kg:/m/02rz5qm | Charles | Clark | 1827-08-21 | M | 10981 | Nelson | ||||||||||||||||
P000508 | Charles Pray | P000508 | 408893 | 7598 | Charles Nelson Pray | Q1065626 | kg:/m/02rhddc | Charles | Pray | 1868-04-06 | M | 19908 | Nelson | ||||||||||||||||
L000385 | Charles Lobeck | L000385 | 406877 | 5730 | Charles O. Lobeck | Q1065664 | kg:/m/0b6q0l | Charles | Lobeck | 1852-04-06 | M | 17073 | Otto | ||||||||||||||||
A000244 | Charles Andrews | A000244 | 400874 | 193 | Charles O. Andrews | Q1065668 | kg:/m/0b1f0j | Charles | Andrews | 1877-03-07 | M | Oscar | |||||||||||||||||
P000439 | Charles Porter | P000439 | 408830 | 7533 | Charles O. Porter | Q1065674 | kg:/m/0fl3n5 | Charles | Porter | 1919-04-04 | M | 19825 | Orlando | ||||||||||||||||
W000419 | Charles Whitley | W000419 | 411578 | 14464 | Charles Orville Whitley | Q1065683 | kg:/m/05k3wg | Charles | Whitley | 1927-01-03 | M | 23711 | Orville | 01223 | |||||||||||||||
O000027 | Charles O’Connor | O000027 | 408275 | 7015 | Charles O'Connor (politician) | Q1065702 | kg:/m/04c7n3 | Charles | O’Connor | 1878-10-26 | M | 19102 | |||||||||||||||||
S000665 | Charles Snyder | S000665 | 410138 | 8732 | Charles P. Snyder | Q1065710 | kg:/m/03bypt3 | Charles | Snyder | 1847-06-09 | M | 21957 | Philip | ||||||||||||||||
N000031 | Charles Nelson | N000031 | 408122 | 6863 | Charles P. Nelson (congressman) | Q1065712 | kg:/m/02wyz1m | Charles | Nelson | 1907-07-02 | M | 18873 | Pembroke | ||||||||||||||||
P000097 | Charles Pashayan | P000097 | 408506 | 14652 | Chip Pashayan | Q1065727 | kg:/m/02qxl9v | Charles | Pashayan | 1941-03-27 | M | 19392 | Jr. | 00891 | |||||||||||||||
P000192 | Charles Pelham | P000192 | 408596 | 7310 | Charles Pelham (congressman) | Q1065743 | kg:/m/02rq9yz | Charles | Pelham | 1835-03-12 | M | 19513 | |||||||||||||||||
T000195 | Charles Thompson | T000195 | 410774 | 9317 | Charles Perkins Thompson | Q1065752 | kg:/m/02r313q | Charles | Thompson | 1827-07-30 | M | 22873 | Perkins | ||||||||||||||||
T000007 | Charles Taft | T000007 | 410597 | 9150 | Charles Phelps Taft | Q1065770 | kg:/m/07yny5 | Charles | Taft | 1843-12-21 | M | 22640 | Phelps | ||||||||||||||||
P000421 | Charles Pomeroy | P000421 | 408813 | 7517 | Charles Pomeroy | Q1065799 | kg:/m/02rk78b | Charles | Pomeroy | 1825-09-03 | M | 19802 | |||||||||||||||||
T000287 | Charles Tirrell | T000287 | 410860 | 9399 | Charles Q. Tirrell | Q1065818 | kg:/m/02rhdfd | Charles | Tirrell | 1844-12-10 | M | 22980 | Quincy | ||||||||||||||||
B001019 | Charles Buckalew | B001019 | 401969 | 1200 | Charles R. Buckalew | Q1065830 | kg:/m/08nq27 | Charles | Buckalew | 1821-12-28 | M | 10094 | Rollin |
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);