legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by leadership_roles descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
D000158 | William Dawson | D000158 | 403290 | 2433 | William L. Dawson (politician) | Q2546135 | kg:/m/04f9b3 | William | Dawson | 1886-04-26 | M | 12028 | Levi | ||||||||||||||||
D000159 | Rowland Day | D000159 | 403291 | 2434 | Rowland Day | Q7372118 | kg:/m/02rkw5p | Rowland | Day | 1779-03-06 | M | 12029 | |||||||||||||||||
D000160 | Stephen Day | D000160 | 403292 | 2435 | Stephen A. Day | Q7608520 | kg:/m/02rkczk | Stephen | Day | 1882-07-13 | M | 12031 | Albion | ||||||||||||||||
D000161 | Timothy Day | D000161 | 403293 | 2436 | Timothy C. Day | Q281129 | kg:/m/02rm36n | Timothy | Day | 1819-01-08 | M | 12032 | Crane | ||||||||||||||||
D000162 | Charles Dayan | D000162 | 403294 | 2437 | Charles Dayan | Q1064073 | kg:/m/0gm6d3 | Charles | Dayan | 1792-07-08 | M | 12033 | |||||||||||||||||
D000163 | Alston Dayton | D000163 | 403295 | 2438 | Alston G. Dayton | Q432793 | kg:/m/05p3ld9 | Alston | Dayton | 1857-10-18 | M | 12035 | Gordon | ||||||||||||||||
D000165 | Jonathan Dayton | D000165 | 403297 | 2440 | Jonathan Dayton | Q461697 | kg:/m/01rc0c | Jonathan | Dayton | 1760-10-16 | M | 12038 | |||||||||||||||||
D000166 | William Dayton | D000166 | 403298 | 2441 | William L. Dayton | Q331182 | kg:/m/04pgrd | William | Dayton | 1807-02-17 | M | Lewis | |||||||||||||||||
D000167 | David De Armond | D000167 | 403299 | 2453 | David A. De Armond | Q1173500 | kg:/m/02rxb2l | David | De Armond | 1844-03-18 | M | 12041 | Albaugh | ||||||||||||||||
D000168 | Nathan Deal | D000168 | 400099 | 99342 | Nathan Deal | Q179732 | kg:/m/0255js | Nathan | Deal | 1942-08-25 | M | 12043 | 00277 | 26824 | N00002610 | [ "H2GA09036" ] |
|||||||||||||
D000169 | Joseph Deal | D000169 | 403331 | 2442 | Joseph T. Deal | Q1518005 | kg:/m/02vp0bx | Joseph | Deal | 1860-11-19 | M | 12044 | Thomas | ||||||||||||||||
D000170 | Benjamin Dean | D000170 | 403332 | 2443 | Benjamin Dean | Q817445 | kg:/m/0ks4bj | Benjamin | Dean | 1824-08-14 | M | 12045 | |||||||||||||||||
D000171 | Ezra Dean | D000171 | 403333 | 2444 | Ezra Dean | Q23949 | kg:/m/02rl_sz | Ezra | Dean | 1795-04-09 | M | 12046 | |||||||||||||||||
D000172 | Gilbert Dean | D000172 | 403334 | 2445 | Gilbert Dean | Q1382980 | kg:/m/026blc1 | Gilbert | Dean | 1819-08-14 | M | 12047 | |||||||||||||||||
D000173 | Josiah Dean | D000173 | 403335 | 2446 | Josiah Dean | Q1708627 | kg:/m/02rjwmp | Josiah | Dean | 1748-03-06 | M | 12048 | |||||||||||||||||
D000174 | Sidney Dean | D000174 | 403336 | 2447 | Sidney Dean | Q2281900 | kg:/m/02q1hp9 | Sidney | Dean | 1818-11-16 | M | 12049 | |||||||||||||||||
D000175 | Charles Deane | D000175 | 403337 | 2448 | Charles B. Deane | Q1063636 | kg:/m/03b_z72 | Charles | Deane | 1898-11-01 | M | 12050 | Bennett | ||||||||||||||||
D000177 | Cleveland Dear | D000177 | 403339 | 2450 | Cleveland Dear | Q1100740 | kg:/m/0ds8d9 | Cleveland | Dear | 1888-08-22 | M | 12052 | |||||||||||||||||
D000178 | Henry Dearborn | D000178 | 403340 | 2451 | Henry Dearborn | Q963349 | kg:/m/01jv0s | Henry | Dearborn | 1751-02-23 | M | 12053 | |||||||||||||||||
D000179 | Henry Dearborn | D000179 | 403341 | 2452 | Henry Alexander Scammell Dearborn | Q1606422 | kg:/m/02qbz0 | Henry | Dearborn | 1783-03-03 | M | 12054 | Alexander Scammell | ||||||||||||||||
D000180 | Rezin De Bolt | D000180 | 403300 | 2456 | Rezin A. De Bolt | Q1320252 | kg:/m/02rzb4d | Rezin | De Bolt | 1828-01-20 | M | 12055 | A. | ||||||||||||||||
D000181 | Edmund Deberry | D000181 | 403342 | 2454 | Edmund Deberry | Q1286166 | kg:/m/04fqn_ | Edmund | Deberry | 1787-08-14 | M | 12056 | |||||||||||||||||
D000182 | William Deboe | D000182 | 403343 | 2455 | William Joseph Deboe | Q1486004 | kg:/m/09_y27 | William | Deboe | 1849-06-30 | M | Joseph | |||||||||||||||||
D000183 | Huey Deckard | D000183 | 403344 | 14619 | H. Joel Deckard | Q1305216 | kg:/m/02rkg4b | Huey | Deckard | 1942-03-07 | M | 12058 | Joel | 00278 | |||||||||||||||
D000184 | Perl Decker | D000184 | 403345 | 2457 | Perl D. Decker | Q2071313 | kg:/m/02rz7sb | Perl | Decker | 1875-09-10 | M | 12059 | D. | ||||||||||||||||
D000185 | Dennis DeConcini | D000185 | 403346 | 14502 | Dennis DeConcini | Q1189069 | kg:/m/03mchy | Dennis | DeConcini | 1937-05-08 | M | Webster | 01315 | S102 | |||||||||||||||
D000186 | Elias Deemer | D000186 | 403347 | 2458 | Elias Deemer | Q5360478 | kg:/m/0gds1n | Elias | Deemer | 1838-01-03 | M | 12062 | |||||||||||||||||
D000187 | Braswell Deen | D000187 | 403348 | 2459 | Braswell Deen | Q899516 | kg:/m/02rk0pm | Braswell | Deen | 1893-06-28 | M | 12063 | Drue | ||||||||||||||||
D000188 | Nathaniel Deering | D000188 | 403349 | 2460 | Nathaniel Cobb Deering | Q1966730 | kg:/m/02rk812 | Nathaniel | Deering | 1827-09-02 | M | 12064 | Cobb | ||||||||||||||||
D000189 | Henry De Forest | D000189 | 403301 | 2461 | Henry S. De Forest | Q5727858 | kg:/m/02rlcg3 | Henry | De Forest | 1847-02-16 | M | 12065 | Schermerhorn | ||||||||||||||||
D000190 | Robert De Forest | D000190 | 403302 | 2462 | Robert E. De Forest | Q1424746 | kg:/m/02rl0pd | Robert | De Forest | 1845-02-20 | M | 12066 | Elliott | ||||||||||||||||
D000191 | Peter DeFazio | D000191 | 400100 | 15410 | Peter DeFazio | Q1758507 | kg:/m/033ttx | Peter | DeFazio | 1947-05-27 | M | 12068 | A. | Peter DeFazio | 00279 | 6068 | 27037 | Peter A. DeFazio | N00007781 | [ "H6OR04047", "S6OR00151" ] |
213 | ||||||||
D000192 | Joseph Defrees | D000192 | 403350 | 2463 | Joseph H. Defrees | Q1394758 | kg:/m/02rkh1x | Joseph | Defrees | 1812-05-13 | M | 12069 | Hutton | ||||||||||||||||
D000193 | John De Graff | D000193 | 403303 | 2466 | John I. De Graff | Q2045515 | kg:/m/02rlck6 | John | De Graff | 1783-10-02 | M | 12070 | Isaac | ||||||||||||||||
D000194 | Reese De Graffenreid | D000194 | 403304 | 2467 | Reese C. De Graffenreid | Q732497 | kg:/m/03c2_x0 | Reese | De Graffenreid | 1859-05-07 | M | 12071 | Calhoun | ||||||||||||||||
D000195 | Edward Degener | D000195 | 403351 | 2464 | Edward Degener | Q772876 | kg:/m/03c2zqq | Edward | Degener | 1809-10-20 | M | 12073 | |||||||||||||||||
D000196 | Federico Degetau | D000196 | 403352 | Federico Degetau | Q1400453 | kg:/m/055yz6 | Federico | Degetau | 1862-12-05 | M | 12074 | ||||||||||||||||||
D000197 | Diana DeGette | D000197 | 400101 | 29710 | Diana DeGette | Q437159 | kg:/m/024z95 | Diana | DeGette | 1957-07-29 | F | 12076 | L. | Diana DeGette | 01479 | 90293 | 561 | Diana DeGette | N00006134 | [ "H6CO01141" ] |
214 | ||||||||
D000198 | Edward deGraffenried | D000198 | 403353 | 2468 | Edward deGraffenried | Q1294190 | kg:/m/02rk1js | Edward | deGraffenried | 1899-06-30 | M | 12077 | |||||||||||||||||
D000200 | John De Haven | D000200 | 403306 | 2470 | John J. De Haven | Q1700568 | kg:/m/02rl0nc | John | De Haven | 1849-03-12 | M | 12079 | Jefferson | ||||||||||||||||
D000201 | Frederick Deitrick | D000201 | 403354 | 2471 | Frederick Simpson Deitrick | Q1377337 | kg:/m/02rhgfp | Frederick | Deitrick | 1875-04-09 | M | 12080 | Simpson | ||||||||||||||||
D000202 | Daniel De Jarnette | D000202 | 403307 | 2472 | Daniel Coleman DeJarnette Sr. | Q1160354 | kg:/m/025zc6s | Daniel | De Jarnette | 1822-10-18 | M | 12081 | Coleman | ||||||||||||||||
D000203 | Eligio de la Garza | D000203 | 403308 | 10716 | Kika de la Garza | Q1741192 | kg:/m/07kjdt | Eligio | de la Garza | 1927-09-22 | M | 12083 | II | Kika | 00276 | ||||||||||||||
D000204 | Gilbert De La Matyr | D000204 | 403309 | 2474 | Gilbert De La Matyr | Q938664 | kg:/m/02rl19c | Gilbert | De La Matyr | 1825-07-08 | M | 12084 | |||||||||||||||||
D000205 | James De La Montanya | D000205 | 403310 | 2475 | James De La Montanya | Q194795 | kg:/m/02rlchv | James | De La Montanya | 1798-03-20 | M | 12085 | |||||||||||||||||
D000206 | Emerson De Lacy | D000206 | 403311 | 2473 | Hugh De Lacy (politician) | Q1634282 | kg:/m/03ds2q | Emerson | De Lacy | 1910-05-09 | M | 12087 | Hugh | ||||||||||||||||
D000207 | Milton De Lano | D000207 | 403312 | 2480 | Milton De Lano | Q13219096 | kg:/m/02683f8 | Milton | De Lano | 1844-08-11 | M | 12088 | |||||||||||||||||
D000208 | Robert De Large | D000208 | 403313 | 2482 | Robert C. De Large | Q2156705 | kg:/m/04wygp | Robert | De Large | 1842-03-15 | M | 12090 | Carlos | ||||||||||||||||
D000209 | Ron de Lugo | D000209 | 403314 | Ron de Lugo | Q2819582 | kg:/m/01t028 | Ron | de Lugo | 1930-08-02 | M | 12092 | 00275 | |||||||||||||||||
D000210 | William Delahunt | D000210 | 400102 | 29731 | Bill Delahunt | Q862056 | kg:/m/028vt9 | William | Delahunt | 1941-07-18 | M | 12094 | D. | Bill | 01480 | 46620 | 1017 | N00000280 | [ "H2MA11060" ] |
||||||||||
D000211 | James Delaney | D000211 | 403355 | 2476 | James J. Delaney | Q1281904 | kg:/m/07700s | James | Delaney | 1901-03-19 | M | 12095 | Joseph | 00280 | |||||||||||||||
D000212 | John Delaney | D000212 | 403356 | 2477 | John J. Delaney | Q1700570 | kg:/m/026fnrn | John | Delaney | 1878-08-21 | M | 12096 | Joseph | ||||||||||||||||
D000213 | Charles Delano | D000213 | 403357 | 2478 | Charles Delano | Q179156 | kg:/m/02rhd43 | Charles | Delano | 1820-06-24 | M | 12097 | |||||||||||||||||
D000214 | Columbus Delano | D000214 | 403358 | 2479 | Columbus Delano | Q326150 | kg:/m/03c018 | Columbus | Delano | 1809-06-04 | M | 12098 | |||||||||||||||||
D000215 | Isaac Delaplaine | D000215 | 403359 | 2481 | Isaac C. Delaplaine | Q1383630 | kg:/m/02rkqx1 | Isaac | Delaplaine | 1817-10-27 | M | 12099 | Clason | ||||||||||||||||
D000216 | Rosa DeLauro | D000216 | 400103 | 29109 | Rosa DeLauro | Q434952 | kg:/m/024zn0 | Rosa | DeLauro | 1943-03-02 | F | 12101 | L. | Rosa DeLauro | 00281 | 19040 | 26788 | Rosa L. DeLauro | N00000615 | [ "H0CT03072" ] |
215 | ||||||||
D000217 | Thomas DeLay | D000217 | 400104 | 15094 | Tom DeLay | Q180390 | kg:/m/01fnd0 | Thomas | DeLay | 1947-04-08 | M | 12103 | Dale | Tom | 00282 | N00005892 | |||||||||||||
D000218 | Francisco Delgado | D000218 | 403360 | Francisco Afan Delgado | Q2793511 | kg:/m/0ct0yl | Francisco | Delgado | 1886-01-25 | M | 12104 | Afan | |||||||||||||||||
D000219 | Vincent Dellay | D000219 | 403361 | 2484 | Vincent J. Dellay | Q2526620 | kg:/m/02rytq4 | Vincent | Dellay | 1907-06-23 | M | 12105 | John | ||||||||||||||||
D000220 | John Dellenback | D000220 | 403362 | 11011 | John R. Dellenback | Q537088 | kg:/m/027861x | John | Dellenback | 1918-11-06 | M | 12106 | Richard | 00283 | |||||||||||||||
D000221 | James Dellet | D000221 | 403363 | 2485 | James Dellet | Q1680266 | kg:/m/0f80bc | James | Dellet | 1788-02-18 | M | 12107 | |||||||||||||||||
D000222 | Ronald Dellums | D000222 | 403364 | 13011 | Ron Dellums | Q1870154 | kg:/m/02p5rv | Ronald | Dellums | 1935-11-24 | M | 12109 | Vernie | 00284 | |||||||||||||||
D000223 | John De Mott | D000223 | 403315 | 2488 | John De Mott | Q6228976 | kg:/m/02rlcjw | John | De Mott | 1790-10-07 | M | 12110 | |||||||||||||||||
D000224 | Mark De Motte | D000224 | 403316 | 2489 | Mark L. De Motte | Q1900201 | kg:/m/02rl1cf | Mark | De Motte | 1832-12-28 | M | 12111 | Lindsey | ||||||||||||||||
D000225 | Peter De Muth | D000225 | 403317 | 2492 | Peter J. De Muth | Q7174860 | kg:/m/0fg6pv | Peter | De Muth | 1892-01-01 | M | 12112 | Joseph | ||||||||||||||||
D000226 | Benjamin Deming | D000226 | 403365 | 2486 | Benjamin F. Deming | Q817461 | kg:/m/02rhcm8 | Benjamin | Deming | M | 12113 | F. | |||||||||||||||||
D000227 | Henry Deming | D000227 | 403366 | 2487 | Henry C. Deming | Q1606562 | kg:/m/02rhhbk | Henry | Deming | 1815-05-23 | M | 12114 | Champion | ||||||||||||||||
D000228 | John Dempsey | D000228 | 403367 | 2490 | John J. Dempsey | Q882915 | kg:/m/02ptt6c | John | Dempsey | 1879-06-22 | M | 12115 | Joseph | ||||||||||||||||
D000229 | Stephen Dempsey | D000229 | 403368 | 2491 | S. Wallace Dempsey | Q7387978 | kg:/m/0gzqmw | Stephen | Dempsey | 1862-05-08 | M | 12116 | Wallace | ||||||||||||||||
D000230 | Edward De Nivernais | D000230 | 403318 | Edward | De Nivernais | M | 12117 | James | |||||||||||||||||||||
D000231 | Lawrence DeNardis | D000231 | 403369 | 14811 | Lawrence J. DeNardis | Q1809209 | kg:/m/078xg3 | Lawrence | DeNardis | 1938-03-18 | M | 12118 | Joseph | 00285 | |||||||||||||||
D000232 | Edwin Denby | D000232 | 403370 | 2493 | Edwin Denby (politician) | Q962646 | kg:/m/032d7y | Edwin | Denby | 1870-02-18 | M | 12119 | |||||||||||||||||
D000233 | Charles Deneen | D000233 | 403371 | 2494 | Charles S. Deneen | Q735351 | kg:/m/067w71 | Charles | Deneen | 1863-05-04 | M | Samuel | |||||||||||||||||
D000234 | Frank Denholm | D000234 | 403372 | 13012 | Frank E. Denholm | Q1443171 | kg:/m/0f8l90 | Frank | Denholm | 1923-11-29 | M | 12121 | Edward | 00286 | |||||||||||||||
D000235 | Charles Denison | D000235 | 403373 | 2495 | Charles Denison | Q5076826 | kg:/m/0kt9cy | Charles | Denison | 1818-01-23 | M | 12122 | |||||||||||||||||
D000236 | Dudley Denison | D000236 | 403374 | 2496 | Dudley Chase Denison | Q1263716 | kg:/m/028c6f6 | Dudley | Denison | 1819-09-13 | M | 12123 | Chase | ||||||||||||||||
D000237 | Edward Denison | D000237 | 403375 | 2497 | Edward E. Denison | Q5342692 | kg:/m/02rk9cq | Edward | Denison | 1873-08-28 | M | 12125 | Everett | ||||||||||||||||
D000238 | George Denison | D000238 | 403376 | 2498 | George Denison (American politician) | Q5538485 | kg:/m/027hjs2 | George | Denison | 1790-02-22 | M | 12126 | |||||||||||||||||
D000239 | Robert Denney | D000239 | 403377 | 11012 | Robert Vernon Denney | Q2159075 | kg:/m/0brdt8 | Robert | Denney | 1916-04-11 | M | 12127 | Vernon | ||||||||||||||||
D000240 | William Denning | D000240 | 403378 | William Denning | Q82219 | kg:/m/026nzyl | William | Denning | M | 12128 | |||||||||||||||||||
D000241 | David Dennis | D000241 | 403379 | 12012 | David W. Dennis | Q1177015 | kg:/m/0d9xzt | David | Dennis | 1912-06-07 | M | 12130 | Worth | 00287 | |||||||||||||||
D000242 | George Dennis | D000242 | 403380 | 2500 | George R. Dennis | Q433660 | kg:/m/05qx7d | George | Dennis | 1822-04-08 | M | Robertson | |||||||||||||||||
D000243 | John Dennis | D000243 | 403381 | 2501 | John Dennis (1771–1806) | Q2695487 | kg:/m/0cszwl | John | Dennis | 1771-12-17 | M | 12132 | |||||||||||||||||
D000244 | John Dennis | D000244 | 403382 | 2502 | John Dennis (1807–1859) | Q287533 | kg:/m/026ww0j | John | Dennis | M | 12133 | ||||||||||||||||||
D000245 | Littleton Dennis | D000245 | 403383 | 2503 | Littleton Purnell Dennis | Q250682 | kg:/m/026wvsz | Littleton | Dennis | 1786-07-21 | M | 12134 | Purnell | ||||||||||||||||
D000246 | David Dennison | D000246 | 403384 | 2504 | David S. Dennison Jr. | Q11100866 | kg:/m/03dn5m | David | Dennison | 1918-07-29 | M | 12135 | Short | ||||||||||||||||
D000247 | Arthur Denny | D000247 | 403385 | Arthur A. Denny | Q1595543 | kg:/m/0b82cd | Arthur | Denny | 1822-06-20 | M | 12136 | Armstrong | |||||||||||||||||
D000248 | Harmar Denny | D000248 | 403386 | 2506 | Harmar Denny | Q5659066 | kg:/m/0f6rwf | Harmar | Denny | 1794-05-13 | M | 12137 | |||||||||||||||||
D000249 | Harmar Denny | D000249 | 403387 | 2507 | Harmar D. Denny Jr. | Q5659063 | kg:/m/0f6r19 | Harmar | Denny | 1886-07-02 | M | 12138 | Denny | Jr. | |||||||||||||||
D000250 | James Denny | D000250 | 403388 | 2508 | James William Denny | Q1530669 | kg:/m/02rhjjs | James | Denny | 1838-11-20 | M | 12139 | William | ||||||||||||||||
D000251 | Walter Denny | D000251 | 403389 | 2509 | Walter M. Denny | Q2545459 | kg:/m/02x3_m7 | Walter | Denny | 1853-10-28 | M | 12141 | McKennon | ||||||||||||||||
D000252 | Peter Denoyelles | D000252 | 403390 | 2510 | Peter Denoyelles | Q328639 | kg:/m/0bv9v7 | Peter | Denoyelles | M | 12142 | ||||||||||||||||||
D000253 | William Denson | D000253 | 403391 | 2511 | William Henry Denson | Q2579199 | kg:/m/02rk2dm | William | Denson | 1846-03-04 | M | 12143 | Henry | ||||||||||||||||
D000254 | George Dent | D000254 | 403392 | 2512 | George Dent | Q219449 | kg:/m/08t7kg | George | Dent | M | 12144 | ||||||||||||||||||
D000255 | John Dent | D000255 | 403393 | 2513 | John Herman Dent | Q6239062 | kg:/m/0dpc1z | John | Dent | 1908-03-10 | M | 12146 | Herman | 00288 | |||||||||||||||
D000256 | Stanley Dent | D000256 | 403394 | 2514 | S. Hubert Dent Jr. | Q1592720 | kg:/m/02rk26s | Stanley | Dent | 1869-08-16 | M | 12147 | Hubert | Jr. | |||||||||||||||
D000257 | William Dent | D000257 | 403395 | 2515 | William Barton Wade Dent | Q602954 | kg:/m/027cqt9 | William | Dent | 1806-09-08 | M | 12148 | Barton Wade | ||||||||||||||||
D000258 | George Denton | D000258 | 403396 | 2516 | George K. Denton | Q1507685 | kg:/m/02rkf_w | George | Denton | 1864-11-17 | M | 12149 | Kirkpatrick | ||||||||||||||||
D000259 | Jeremiah Denton | D000259 | 403397 | 14901 | Jeremiah Denton | Q731680 | kg:/m/036x4p | Jeremiah | Denton | 1924-07-15 | M | Andrew | Jr. | 01316 | |||||||||||||||
D000260 | Winfield Denton | D000260 | 403398 | 2517 | Winfield K. Denton | Q2584140 | kg:/m/02rkll9 | Winfield | Denton | 1896-10-28 | M | 12151 | Kirkpatrick |
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);