legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
384 rows where name_suffix = "Jr." sorted by bio_gender
This data as json, copyable, CSV (advanced)
Suggested facets: name_nickname, bio_birthday (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
C000591 | Peleg Coffin | C000591 | 402720 | 1906 | Peleg Coffin Jr. | Q2067932 | kg:/m/08vvd0 | Peleg | Coffin | 1756-11-03 | M | 11191 | Jr. | ||||||||||||||||
T000389 | Jonathan Trumbull | T000389 | 410958 | 9489 | Jonathan Trumbull Jr. | Q881004 | kg:/m/01rbqk | Jonathan | Trumbull | 1740-03-26 | M | 23110 | Jr. | ||||||||||||||||
F000365 | Nathaniel Freeman | F000365 | 404311 | 3358 | Nathaniel Freeman Jr. | Q1966740 | kg:/m/0260vht | Nathaniel | Freeman | 1766-05-01 | M | 13430 | Jr. | ||||||||||||||||
R000553 | John Rutledge | R000553 | 409509 | 8153 | John Rutledge Jr. | Q1701634 | kg:/m/0265r3z | John | Rutledge | M | 20761 | Jr. | |||||||||||||||||
A000282 | John Armstrong | A000282 | 400922 | 233 | John Armstrong Jr. | Q1381657 | kg:/m/02j18m | John | Armstrong | 1758-11-25 | M | 8656 | Jr. | ||||||||||||||||
S000805 | Joseph Stanton | S000805 | 410271 | 8845 | Joseph Stanton Jr. | Q431857 | kg:/m/03zx_l | Joseph | Stanton | 1739-07-19 | M | 22136 | Jr. | ||||||||||||||||
B000533 | John Blake | B000533 | 401508 | 773 | John Blake Jr. (politician) | Q1699352 | kg:/m/026hq8f | John | Blake | 1762-12-05 | M | 9461 | Jr. | ||||||||||||||||
M000864 | Daniel Montgomery | M000864 | 407837 | 6601 | Daniel Montgomery Jr. | Q5218178 | kg:/m/027lkc9 | Daniel | Montgomery | 1765-10-30 | M | 18419 | Jr. | ||||||||||||||||
M000633 | Return Meigs | M000633 | 407620 | 6408 | Return J. Meigs Jr. | Q744819 | kg:/m/0340r0 | Return | Meigs | 1764-11-17 | M | Jonathan | Jr. | ||||||||||||||||
P000330 | Benjamin Pickman | P000330 | 408727 | 7432 | Benjamin Pickman Jr. | Q817647 | kg:/m/02rhcnn | Benjamin | Pickman | 1763-09-30 | M | 19688 | Jr. | ||||||||||||||||
B000207 | Josiah Bartlett | B000207 | 401206 | 491 | Josiah Bartlett Jr. | Q1708618 | kg:/m/0d8v8f | Josiah | Bartlett | 1768-08-29 | M | 9040 | Jr. | ||||||||||||||||
P000146 | William Paulding | P000146 | 408551 | 7269 | William Paulding Jr. | Q82449 | kg:/m/026t9n6 | William | Paulding | 1770-03-07 | M | 19454 | Jr. | ||||||||||||||||
T000416 | Charles Turner | T000416 | 410985 | 9510 | Charles Turner Jr. | Q1066267 | kg:/m/02rhdk5 | Charles | Turner | 1760-06-20 | M | 23143 | Jr. | ||||||||||||||||
V000023 | Pierre Van Cortlandt | V000023 | 411076 | 9603 | Pierre Van Cortlandt Jr. | Q2093953 | kg:/m/026psf9 | Pierre | Van Cortlandt | 1762-08-29 | M | 20906 | Jr. | ||||||||||||||||
C000843 | William Coxe | C000843 | 402960 | 2122 | William Coxe Jr. | Q1570579 | kg:/m/02rtnnv | William | Coxe | 1762-05-03 | M | 11511 | Jr. | ||||||||||||||||
J000025 | Richard Jackson | J000025 | 405931 | 4862 | Richard Jackson Jr. | Q2149883 | kg:/m/02rjyc0 | Richard | Jackson | 1764-07-03 | M | 15721 | Jr. | ||||||||||||||||
P000455 | Jotham Post | P000455 | 408842 | 7546 | Jotham Post Jr. | Q168616 | kg:/m/02rktbn | Jotham | Post | 1771-04-04 | M | 19845 | Jr. | ||||||||||||||||
B000026 | George Baer | B000026 | 401031 | 332 | George Baer Jr. | Q1203647 | kg:/m/09jkw8 | George | Baer | M | 8807 | Jr. | |||||||||||||||||
G000150 | Thomas Gholson | G000150 | 412043 | 3552 | Thomas Gholson Jr. | Q138190 | kg:/m/02vp08h | Thomas | Gholson | M | 13750 | Jr. | |||||||||||||||||
L000290 | Joseph Lewis | L000290 | 406787 | 5645 | Joseph Lewis Jr. (Virginia politician) | Q1297559 | kg:/m/0280mxn | Joseph | Lewis | M | 16952 | Jr. | |||||||||||||||||
W000128 | Artemas Ward | W000128 | 411303 | 9809 | Artemas Ward Jr. | Q706555 | kg:/m/0cg1m4 | Artemas | Ward | 1762-01-09 | M | 23365 | Jr. | ||||||||||||||||
W000565 | Westel Willoughby | W000565 | 411721 | 10207 | Westel Willoughby Jr. | Q3661182 | kg:/m/02rkxp4 | Westel | Willoughby | 1769-11-20 | M | 23884 | Jr. | ||||||||||||||||
B000650 | John Boss | B000650 | 401614 | 870 | John Linscom Boss Jr. | Q1533882 | kg:/m/02rhkbk | John | Boss | 1780-09-07 | M | 9626 | Linscom | Jr. | |||||||||||||||
B001137 | James Burrill | B001137 | 402080 | 1305 | James Burrill Jr. | Q382718 | kg:/m/04rpwj | James | Burrill | 1772-04-25 | M | Jr. | |||||||||||||||||
T000031 | James Tallmadge | T000031 | 410620 | 9171 | James Tallmadge Jr. | Q1171061 | kg:/m/0200r9 | James | Tallmadge | 1778-01-28 | M | 22671 | Jr. | ||||||||||||||||
A000230 | Richard Anderson | A000230 | 400857 | 179 | Richard Clough Anderson Jr. | Q2149242 | kg:/m/07jm8p | Richard | Anderson | 1788-08-04 | M | 8586 | Clough | Jr. | |||||||||||||||
B001042 | Joseph Buffum | B001042 | 401992 | 1221 | Joseph Buffum Jr. | Q1706700 | kg:/m/02rjwcf | Joseph | Buffum | 1784-09-23 | M | 10119 | Jr. | ||||||||||||||||
F000242 | Walter Folger | F000242 | 404196 | 3252 | Walter Folger Jr. | Q1315384 | kg:/m/02rj_1p | Walter | Folger | 1765-06-12 | M | 13279 | Jr. | ||||||||||||||||
G000539 | James Guyon | G000539 | 404882 | 3886 | James Guyon Jr. | Q74972 | kg:/m/02rkr5b | James | Guyon | 1778-12-24 | M | 14240 | Jr. | ||||||||||||||||
H000006 | Aaron Hackley | H000006 | 404891 | 3896 | Aaron Hackley Jr. | Q3661160 | kg:/m/02rkln0 | Aaron | Hackley | 1783-05-06 | M | 14297 | Jr. | ||||||||||||||||
B000641 | Charles Borland | B000641 | 401606 | 864 | Charles Borland Jr. | Q892029 | kg:/m/02rkmtv | Charles | Borland | 1786-06-29 | M | 9612 | Jr. | ||||||||||||||||
M001115 | Thomas Murray | M001115 | 408078 | 6825 | Thomas Murray Jr. | Q7792626 | kg:/m/027hk6w | Thomas | Murray | M | 18719 | Jr. | |||||||||||||||||
H000410 | William Hayward | H000410 | 405277 | 4249 | William Hayward Jr. | Q2655576 | kg:/m/0dz3y6 | William | Hayward | M | 14787 | Jr. | |||||||||||||||||
P000394 | William Plumer | P000394 | 408788 | 7494 | William Plumer Jr. | Q1495084 | kg:/m/02rj_xj | William | Plumer | 1789-02-09 | M | 19765 | Jr. | ||||||||||||||||
S000694 | Richard Spaight | S000694 | 410165 | 8757 | Richard Dobbs Spaight Jr. | Q884075 | kg:/m/02j1nz | Richard | Spaight | M | 21995 | Dobbs | Jr. | ||||||||||||||||
W000505 | Isaac Williams | W000505 | 411662 | 10150 | Isaac Williams Jr. | Q2507394 | kg:/m/026_tvl | Isaac | Williams | 1777-04-05 | M | 23815 | Jr. | ||||||||||||||||
A000157 | James Allison | A000157 | 400812 | 138 | James Allison Jr. | Q6128654 | kg:/m/027gbjp | James | Allison | 1772-10-04 | M | 8473 | Jr. | ||||||||||||||||
H000932 | Daniel Hugunin | H000932 | 405777 | 4709 | Daniel Hugunin Jr. | Q5217548 | kg:/m/02rknkx | Daniel | Hugunin | 1790-02-06 | M | 15434 | Jr. | ||||||||||||||||
B000143 | David Barker | B000143 | 401144 | 435 | David Barker Jr. | Q1173652 | kg:/m/02rhf0n | David | Barker | 1797-01-08 | M | 8955 | Jr. | ||||||||||||||||
H000082 | John Hallock | H000082 | 404965 | 3964 | John Hallock Jr. | Q892023 | kg:/m/02rksdd | John | Hallock | M | 14389 | Jr. | |||||||||||||||||
H000110 | James Hamilton | H000110 | 404992 | 3991 | James Hamilton Jr. | Q549738 | kg:/m/0422bq | James | Hamilton | 1786-05-08 | M | 14421 | Jr. | ||||||||||||||||
O000105 | Robert Orr | O000105 | 408362 | 7088 | Robert Orr Jr. | Q7348159 | kg:/m/0276x4l | Robert | Orr | 1786-03-05 | M | 19195 | Jr. | ||||||||||||||||
W000345 | Thomas Whipple | W000345 | 411507 | 9999 | Thomas Whipple Jr. | Q475751 | kg:/m/02rk09y | Thomas | Whipple | M | 23627 | Jr. | |||||||||||||||||
E000011 | Jonas Earll | E000011 | 403707 | 2817 | Jonas Earll Jr. | Q6272064 | kg:/m/02rkt0p | Jonas | Earll | M | 12615 | Jr. | |||||||||||||||||
F000397 | Joseph Fry | F000397 | 404339 | 3384 | Joseph Fry Jr. | Q6283263 | kg:/m/026t8sc | Joseph | Fry | 1781-08-04 | M | 13470 | Jr. | ||||||||||||||||
J000112 | Kensey Johns | J000112 | 406013 | 4937 | Kensey Johns Jr. | Q1739010 | kg:/m/0d8qp7 | Kensey | Johns | 1791-12-10 | M | 15833 | Jr. | ||||||||||||||||
C000602 | Richard Coke | C000602 | 402731 | 1916 | Richard Coke Jr. | Q1680049 | kg:/m/027w8qd | Richard | Coke | 1790-11-16 | M | 11204 | Jr. | ||||||||||||||||
C000902 | William Creighton | C000902 | 403014 | 2172 | William Creighton Jr. | Q250272 | kg:/m/0d7qm5 | William | Creighton | 1778-10-29 | M | 11583 | Jr. | ||||||||||||||||
E000248 | Joshua Evans | E000248 | 403931 | 3014 | Joshua Evans Jr. | Q6289786 | kg:/m/026xqdm | Joshua | Evans | 1777-01-20 | M | 12906 | Jr. | ||||||||||||||||
I000006 | Peter Ihrie | I000006 | 405868 | 4795 | Peter Ihrie Jr. | Q7174825 | kg:/m/026t9gc | Peter | Ihrie | 1796-02-03 | M | 15625 | Jr. | ||||||||||||||||
N000078 | Thomas Newton | N000078 | 408165 | 6905 | Thomas Newton Jr. | Q2426306 | kg:/m/01mrzn | Thomas | Newton | 1768-11-21 | M | 18931 | Jr. | ||||||||||||||||
J000009 | Ebenezer Jackson | J000009 | 405916 | 4847 | Ebenezer Jackson Jr. | Q1278652 | kg:/m/02rhffq | Ebenezer | Jackson | 1796-01-31 | M | 15704 | Jr. | ||||||||||||||||
M000099 | Abijah Mann | M000099 | 407123 | 5955 | Abijah Mann Jr. | Q3388776 | kg:/m/02rklqf | Abijah | Mann | 1793-09-24 | M | 17453 | Jr. | ||||||||||||||||
M000223 | Moses Mason | M000223 | 407241 | 6060 | Moses Mason Jr. | Q1949197 | kg:/m/02rv9rt | Moses | Mason | 1789-06-02 | M | 17598 | Jr. | ||||||||||||||||
A000095 | James Alexander | A000095 | 400753 | 83 | James Alexander Jr. | Q6128502 | kg:/m/0269r6l | James | Alexander | 1789-10-17 | M | 8390 | Jr. | ||||||||||||||||
F000396 | Jacob Fry | F000396 | 404338 | 3383 | Jacob Fry Jr. | Q13219624 | kg:/m/0273xkv | Jacob | Fry | 1802-06-10 | M | 13469 | Jr. | ||||||||||||||||
G000451 | George Grennell | G000451 | 404797 | 3812 | George Grennell Jr. | Q1507439 | kg:/m/0c8wlp | George | Grennell | 1786-12-25 | M | 14135 | Jr. | ||||||||||||||||
K000269 | John Klingensmith | K000269 | 406427 | 5323 | John Klingensmith Jr. | Q6243282 | kg:/m/0277flx | John | Klingensmith | 1786-03-26 | M | 16414 | Jr. | ||||||||||||||||
H000617 | Solomon Hillen Solomon | H000617 | 405476 | 4432 | Solomon Hillen Jr. | Q1586483 | kg:/m/02rl44v | Solomon | Hillen Solomon | 1810-07-10 | M | 15047 | Jr. | ||||||||||||||||
R000353 | Thomas Robinson | R000353 | 409324 | 7991 | Thomas Robinson Jr. | Q2426872 | kg:/m/0ds4pr | Thomas | Robinson | M | 20518 | Jr. | |||||||||||||||||
T000221 | Waddy Thompson | T000221 | 410800 | 9342 | Waddy Thompson Jr. | Q2538676 | kg:/m/02ry1yx | Waddy | Thompson | 1798-01-08 | M | 22904 | Jr. | ||||||||||||||||
D000352 | Davis Dimock | D000352 | 403470 | 2602 | Davis Dimock Jr. | Q5241888 | kg:/m/026tbp6 | Davis | Dimock | 1801-09-17 | M | 12263 | Jr. | ||||||||||||||||
H000810 | Jacob Houck | H000810 | 405658 | 4599 | Jacob Houck Jr. | Q1383619 | kg:/m/02rkr1k | Jacob | Houck | 1801-01-14 | M | 15284 | Jr. | ||||||||||||||||
H000411 | William Haywood | H000411 | 405278 | 4250 | William Henry Haywood Jr. | Q5794515 | kg:/m/02kl5v | William | Haywood | 1801-10-23 | M | Henry | Jr. | ||||||||||||||||
W000770 | Silas Wright | W000770 | 411919 | 10398 | Silas Wright | Q777453 | kg:/m/02z5dk | Silas | Wright | 1795-05-24 | M | 24137 | Jr. | ||||||||||||||||
D000346 | Paul Dillingham | D000346 | 403464 | 2596 | Paul Dillingham | Q885200 | kg:/m/02r7h13 | Paul | Dillingham | 1799-08-10 | M | 12257 | Jr. | ||||||||||||||||
W000308 | James Westcott | W000308 | 411472 | 9966 | James Westcott | Q1681287 | kg:/m/08_y9c | James | Westcott | 1802-05-10 | M | Diament | Jr. | ||||||||||||||||
K000122 | William Kennon | K000122 | 406288 | 5192 | William Kennon Jr. | Q8013940 | kg:/m/02rm3ps | William | Kennon | 1802-06-12 | M | 16229 | Jr. | ||||||||||||||||
N000140 | Moses Norris | N000140 | 408224 | 6961 | Moses Norris Jr. | Q939960 | kg:/m/0d7mvf | Moses | Norris | 1799-11-08 | M | 19006 | Jr. | ||||||||||||||||
B000209 | Thomas Bartlett | B000209 | 401207 | 492 | Thomas Bartlett Jr. | Q2422254 | kg:/m/02rjznz | Thomas | Bartlett | 1808-06-18 | M | 9043 | Jr. | ||||||||||||||||
H000855 | Thomas Howe | H000855 | 405702 | 4641 | Thomas Y. Howe Jr. | Q7795367 | kg:/m/02rkxdk | Thomas | Howe | M | 15343 | Y. | Jr. | ||||||||||||||||
R000063 | Robert Rantoul | R000063 | 409043 | 7738 | Robert Rantoul Jr. | Q2158571 | kg:/m/0bffpr | Robert | Rantoul | 1805-08-13 | M | 20159 | Jr. | ||||||||||||||||
K000140 | John Kerr | K000140 | 406306 | 5206 | John Kerr Jr. (congressman) | Q1700699 | kg:/m/0bpl86 | John | Kerr | 1811-02-10 | M | 16254 | Jr. | ||||||||||||||||
P000236 | John Perkins | P000236 | 408639 | 7349 | John Perkins Jr. | Q519697 | kg:/m/02rv9g5 | John | Perkins | 1819-07-01 | M | 19572 | Jr. | ||||||||||||||||
C000094 | John Campbell | C000094 | 402249 | 1459 | John P. Campbell Jr. | Q1701286 | kg:/m/02rhkf_ | John | Campbell | 1820-12-08 | M | 10561 | Pierce | Jr. | |||||||||||||||
C000353 | Thomas Child | C000353 | 402492 | 1691 | Thomas Child Jr. | Q1193423 | kg:/m/02rkx0j | Thomas | Child | 1818-03-22 | M | 10897 | Jr. | ||||||||||||||||
W000281 | Daniel Wells | W000281 | 411446 | 9941 | Daniel Wells Jr. | Q938432 | kg:/m/02vrqv4 | Daniel | Wells | 1808-07-16 | M | 23556 | Jr. | ||||||||||||||||
C000429 | Ezra Clark | C000429 | 402567 | 1761 | Ezra Clark Jr. | Q534881 | kg:/m/02rhg2p | Ezra | Clark | 1813-09-12 | M | 10989 | Jr. | ||||||||||||||||
E000228 | George Eustis | E000228 | 403913 | 2999 | George Eustis Jr. | Q1507318 | kg:/m/0dd4bq | George | Eustis | 1828-09-28 | M | 12884 | Jr. | ||||||||||||||||
C000348 | James Chesnut | C000348 | 402487 | 1686 | James Chesnut Jr. | Q1680158 | kg:/m/09lvq5 | James | Chesnut | 1815-01-18 | M | Jr. | |||||||||||||||||
C000480 | Clement Clay | C000480 | 402618 | 1808 | Clement Claiborne Clay | Q928988 | kg:/m/03gcq7 | Clement | Clay | 1816-12-13 | M | Claiborne | Jr. | ||||||||||||||||
W000173 | Israel Washburn | W000173 | 411346 | 9851 | Israel Washburn Jr. | Q433008 | kg:/m/07rlbc | Israel | Washburn | 1813-06-06 | M | 23415 | Jr. | ||||||||||||||||
H000881 | Demas Hubbard | H000881 | 405727 | 4665 | Demas Hubbard Jr. | Q5255091 | kg:/m/02rknt3 | Demas | Hubbard | 1806-01-17 | M | 15373 | Jr. | ||||||||||||||||
T000174 | John Thomas | T000174 | 410755 | 9300 | John Lewis Thomas Jr. | Q724953 | kg:/m/0ghh6g | John | Thomas | 1835-05-20 | M | 22841 | Lewis | Jr. | |||||||||||||||
B000248 | James Bayard | B000248 | 401242 | 525 | James A. Bayard Jr. | Q1665539 | kg:/m/063vrc | James | Bayard | 1799-11-15 | M | Asheton | Jr. | ||||||||||||||||
M000109 | John Manning | M000109 | 407133 | 5963 | John Manning Jr. | Q1563302 | kg:/m/03c2jc4 | John | Manning | 1830-07-30 | M | 17465 | Jr. | ||||||||||||||||
M000784 | William Milnes | M000784 | 407762 | 6537 | William Milnes Jr. | Q2580007 | kg:/m/02874z9 | William | Milnes | 1827-12-08 | M | 18311 | Jr. | ||||||||||||||||
B000523 | Francis Blair | B000523 | 401499 | 764 | Francis Preston Blair Jr. | Q1350196 | kg:/m/034c_8 | Francis | Blair | 1821-02-19 | M | 9450 | Preston | Jr. | |||||||||||||||
C000421 | Amos Clark | C000421 | 402560 | 1753 | Amos Clark Jr. | Q183577 | kg:/m/02rw_hg | Amos | Clark | 1828-11-08 | M | 10978 | Jr. | ||||||||||||||||
L000481 | Lloyd Lowndes | L000481 | 406969 | 5813 | Lloyd Lowndes Jr. | Q881279 | kg:/m/047p6p | Lloyd | Lowndes | 1845-02-21 | M | 17193 | Jr. | ||||||||||||||||
P000380 | James Platt | P000380 | 408774 | 7480 | James H. Platt Jr. | Q1680497 | kg:/m/02rtnt_ | James | Platt | 1837-07-13 | M | 19749 | Henry | Jr. | |||||||||||||||
E000167 | Smith Ely | E000167 | 403858 | 2955 | Smith Ely Jr. | Q1193094 | kg:/m/02sbdv | Smith | Ely | 1825-04-17 | M | 12797 | Jr. | ||||||||||||||||
W000688 | Alan Wood | W000688 | 411840 | 10318 | Alan Wood Jr. | Q4708090 | kg:/m/0ksyx0 | Alan | Wood | 1834-07-06 | M | 24036 | Jr. | ||||||||||||||||
B000120 | Hiram Barber | B000120 | 401121 | 413 | Hiram Barber Jr. | Q4419865 | kg:/m/02rk9xx | Hiram | Barber | 1835-03-24 | M | 8926 | Jr. | ||||||||||||||||
G000277 | John Goode | G000277 | 404639 | 3666 | John Goode (Virginia politician) | Q968146 | kg:/m/07d7n9 | John | Goode | 1829-05-27 | M | 13913 | Jr. | ||||||||||||||||
O000145 | Edward Overton | O000145 | 408396 | 7125 | Edward Overton Jr. | Q5344707 | kg:/m/0ks_ry | Edward | Overton | 1836-02-04 | M | 19245 | Jr. | ||||||||||||||||
C000442 | John Clark | C000442 | 402580 | 1774 | John Bullock Clark Jr. | Q655809 | kg:/m/0g1h8w | John | Clark | 1831-01-14 | M | 11005 | Bullock | Jr. | |||||||||||||||
J000035 | Ferris Jacobs | J000035 | 405940 | 4870 | Ferris Jacobs Jr. | Q5445377 | kg:/m/02qlpsg | Ferris | Jacobs | 1836-03-20 | M | 15734 | Jr. | ||||||||||||||||
B000033 | John Bagley | B000033 | 401038 | 337 | John H. Bagley Jr. | Q3090731 | kg:/m/026gsj8 | John | Bagley | 1832-11-26 | M | 8817 | Holroyd | Jr. | |||||||||||||||
B000485 | Horatio Bisbee | B000485 | 401466 | 730 | Horatio Bisbee Jr. | Q238626 | kg:/m/02rhhnj | Horatio | Bisbee | 1839-05-01 | M | 9404 | Jr. |
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);