legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by bio_birthday
This data as json, copyable, CSV (advanced)
bio_birthday (date) >30 ✖
- 1802-06-12 4
- 1818-10-08 4
- 1898-04-12 4
- 1786-12-25 3
- 1789-10-20 3
- 1807-02-17 3
- 1808-02-11 3
- 1808-06-18 3
- 1808-09-21 3
- 1811-01-06 3
- 1811-11-11 3
- 1813-10-13 3
- 1813-12-25 3
- 1815-01-18 3
- 1817-04-22 3
- 1819-01-22 3
- 1821-04-12 3
- 1825-04-17 3
- 1826-10-08 3
- 1828-12-16 3
- 1829-03-02 3
- 1829-08-07 3
- 1836-11-15 3
- 1840-01-01 3
- 1841-04-08 3
- 1844-08-01 3
- 1847-09-10 3
- 1848-10-04 3
- 1850-08-25 3
- 1851-02-07 3
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Y000017 | Archibald Yell | Y000017 | 411951 | 10424 | Archibald Yell | Q364730 | kg:/m/01sk8t | Archibald | Yell | M | 21052 | ||||||||||||||||||
S000349 | Roger Sherman | S000349 | 409845 | 8457 | Roger Sherman | Q354721 | kg:/m/01mp_3 | Roger | Sherman | 1721-04-19 | M | 21573 | |||||||||||||||||
C000418 | Abraham Clark | C000418 | 402557 | 1750 | Abraham Clark | Q329870 | kg:/m/01mpsy | Abraham | Clark | 1726-02-15 | M | 10975 | |||||||||||||||||
J000036 | Israel Jacobs | J000036 | 405941 | 4871 | Israel Jacobs | Q6087007 | kg:/m/09q5_d | Israel | Jacobs | 1726-06-09 | M | 15735 | |||||||||||||||||
J000182 | William Johnson | J000182 | 406077 | 4998 | William Samuel Johnson | Q182543 | kg:/m/02pyzk | William | Johnson | 1727-10-07 | M | 15927 | Samuel | ||||||||||||||||
W000127 | Artemas Ward | W000127 | 411302 | 9808 | Artemas Ward | Q321887 | kg:/m/01l7tx | Artemas | Ward | 1727-11-26 | M | 23364 | |||||||||||||||||
S000624 | William Smith | S000624 | 410099 | 8693 | William Smith (Maryland politician) | Q978343 | kg:/m/03nqjd | William | Smith | 1728-04-12 | M | 21907 | |||||||||||||||||
R000548 | Robert Rutherford | R000548 | 409504 | 8148 | Robert Rutherford (congressman) | Q2158678 | kg:/m/09w5n7 | Robert | Rutherford | 1728-10-20 | M | 20756 | |||||||||||||||||
L000246 | George Leonard | L000246 | 406749 | 5611 | George Leonard (Congressman) | Q1507754 | kg:/m/06g6vm | George | Leonard | 1729-07-04 | M | 16899 | |||||||||||||||||
B000739 | William Bradford | B000739 | 401699 | 951 | William Bradford (Rhode Island politician) | Q932530 | kg:/m/01htjz | William | Bradford | 1729-11-04 | M | ||||||||||||||||||
W000403 | John Whitehill | W000403 | 411563 | 10054 | John Whitehill | Q13219856 | kg:/m/026pxrx | John | Whitehill | 1729-12-11 | M | 23693 | |||||||||||||||||
C000187 | Daniel Carroll | C000187 | 402334 | 1538 | Daniel Carroll | Q674371 | kg:/m/02q22c | Daniel | Carroll | 1730-07-22 | M | 10687 | |||||||||||||||||
L000201 | Richard Lee | L000201 | 406704 | 5565 | Richard Henry Lee | Q725907 | kg:/m/06k58 | Richard | Lee | 1732-01-20 | M | 16846 | Henry | ||||||||||||||||
L000364 | Samuel Livermore | L000364 | 406856 | 5713 | Samuel Livermore | Q450568 | kg:/m/038l9k | Samuel | Livermore | 1732-05-14 | M | 17047 | |||||||||||||||||
R000091 | George Read | R000091 | 409071 | 7762 | George Read (American politician, born 1733) | Q471303 | kg:/m/01mrhw | George | Read | 1733-09-18 | M | 20195 | |||||||||||||||||
S000154 | Philip Schuyler | S000154 | 409661 | 8282 | Philip Schuyler | Q1115886 | kg:/m/01stsb | Philip | Schuyler | 1733-11-20 | M | 21330 | John | ||||||||||||||||
J000198 | Samuel Johnston | J000198 | 406093 | 5012 | Samuel Johnston | Q730149 | kg:/m/02j2g3 | Samuel | Johnston | 1733-12-15 | M | 15947 | |||||||||||||||||
M000985 | Robert Morris | M000985 | 407953 | 6712 | Robert Morris (financier) | Q464876 | kg:/m/01hh_b | Robert | Morris | 1734-01-20 | M | 18562 | |||||||||||||||||
S001073 | Thomas Sumter | S001073 | 410527 | 9088 | Thomas Sumter | Q328197 | kg:/m/02r_jv | Thomas | Sumter | 1734-08-14 | M | 22466 | |||||||||||||||||
F000224 | William Floyd | F000224 | 404179 | 3237 | William Floyd | Q1381060 | kg:/m/01mpvf | William | Floyd | 1734-12-17 | M | 13251 | |||||||||||||||||
F000297 | Abiel Foster | F000297 | 404246 | 3299 | Abiel Foster | Q320910 | kg:/m/03_fmd | Abiel | Foster | 1735-08-08 | M | 13346 | |||||||||||||||||
O000060 | Simeon Olcott | O000060 | 408335 | 7048 | Simeon Olcott | Q2287091 | kg:/m/0d4dhm | Simeon | Olcott | 1735-10-01 | M | ||||||||||||||||||
B001053 | Stephen Bullock | B001053 | 402001 | 1232 | Stephen Bullock | Q2344581 | kg:/m/0261t2h | Stephen | Bullock | 1735-10-10 | M | 10132 | |||||||||||||||||
W000551 | Hugh Williamson | W000551 | 411707 | 10193 | Hugh Williamson | Q663151 | kg:/m/02pyy0 | Hugh | Williamson | 1735-12-05 | M | 23868 | |||||||||||||||||
B000927 | John Brown | B000927 | 401882 | 1116 | John Brown (Rhode Island politician) | Q1661398 | kg:/m/033qzm | John | Brown | 1736-01-27 | M | 9976 | |||||||||||||||||
H000995 | Benjamin Huntington | H000995 | 405835 | 4766 | Benjamin Huntington | Q581141 | kg:/m/04vfjf | Benjamin | Huntington | 1736-04-19 | M | 15507 | |||||||||||||||||
M000873 | William Montgomery | M000873 | 407845 | 6608 | William Montgomery (Pennsylvania soldier) | Q8015749 | kg:/m/094hf8 | William | Montgomery | 1736-08-03 | M | 18428 | |||||||||||||||||
W000783 | Henry Wynkoop | W000783 | 411931 | 10405 | Henry Wynkoop | Q5730595 | kg:/m/03tpf2 | Henry | Wynkoop | 1737-03-02 | M | 24156 | |||||||||||||||||
M000031 | William Maclay | M000031 | 407058 | 5891 | William Maclay (Pennsylvania senator) | Q442393 | kg:/m/02d56c | William | Maclay | 1737-07-20 | M | ||||||||||||||||||
G000500 | Jonathan Grout | G000500 | 404845 | 3857 | Jonathan Grout | Q1703183 | kg:/m/08tx4v | Jonathan | Grout | 1737-07-23 | M | 14192 | |||||||||||||||||
C000185 | Charles Carroll | C000185 | 402332 | 1536 | Charles Carroll of Carrollton | Q466009 | kg:/m/01jtw2 | Charles | Carroll | 1737-09-19 | M | 10684 | of Carrollton | ||||||||||||||||
S000330 | William Shepard | S000330 | 409827 | 8440 | William Shepard | Q2580542 | kg:/m/0261t46 | William | Shepard | 1737-12-01 | M | 21547 | |||||||||||||||||
S000582 | Josiah Smith | S000582 | 410063 | 8662 | Josiah Smith | Q1708662 | kg:/m/0261kqs | Josiah | Smith | 1738-02-26 | M | 21854 | |||||||||||||||||
B000017 | John Bacon | B000017 | 401022 | 325 | John Bacon (Massachusetts politician) | Q1244688 | kg:/m/02pnldz | John | Bacon | 1738-04-05 | M | 8794 | |||||||||||||||||
H000661 | John Hobart | H000661 | 405516 | 4469 | John Sloss Hobart | Q437169 | kg:/m/067yvr | John | Hobart | 1738-05-06 | M | Sloss | |||||||||||||||||
D000013 | Tristram Dalton | D000013 | 403156 | 2307 | Tristram Dalton | Q1365791 | kg:/m/03ynvb | Tristram | Dalton | 1738-05-28 | M | ||||||||||||||||||
H000750 | Samuel Holten | H000750 | 405601 | 4546 | Samuel Holten | Q1716923 | kg:/m/04htnn | Samuel | Holten | 1738-06-09 | M | 15210 | |||||||||||||||||
W000404 | Robert Whitehill | W000404 | 411564 | 10055 | Robert Whitehill (Pennsylvania politician) | Q7351019 | kg:/m/026pxp4 | Robert | Whitehill | 1738-07-21 | M | 23694 | |||||||||||||||||
V000053 | Jeremiah Van Rensselaer | V000053 | 411095 | 9629 | Jeremiah Van Rensselaer | Q1687548 | kg:/m/0506gg | Jeremiah | Van Rensselaer | 1738-08-27 | M | 20938 | |||||||||||||||||
M001039 | James Mott | M001039 | 408006 | 6760 | James Mott (New Jersey politician) | Q1680861 | kg:/m/0262rs8 | James | Mott | 1739-01-18 | M | 18627 | |||||||||||||||||
C000538 | George Clymer | C000538 | 402671 | 1859 | George Clymer | Q708913 | kg:/m/01mpsj | George | Clymer | 1739-03-16 | M | 11120 | |||||||||||||||||
D000324 | Philemon Dickinson | D000324 | 403444 | 2576 | Philemon Dickinson | Q2702466 | kg:/m/03zxkh | Philemon | Dickinson | 1739-04-05 | M | 12231 | |||||||||||||||||
W000633 | Paine Wingate | W000633 | 411787 | 10272 | Paine Wingate | Q1638165 | kg:/m/03zy2r | Paine | Wingate | 1739-05-14 | M | 23968 | |||||||||||||||||
G000235 | Henry Glen | G000235 | 404597 | 3628 | Henry Glen | Q1281998 | kg:/m/091382 | Henry | Glen | 1739-07-13 | M | 13861 | |||||||||||||||||
S000805 | Joseph Stanton | S000805 | 410271 | 8845 | Joseph Stanton Jr. | Q431857 | kg:/m/03zx_l | Joseph | Stanton | 1739-07-19 | M | 22136 | Jr. | ||||||||||||||||
M000234 | George Mathews | M000234 | 407252 | 6071 | George Mathews (soldier) | Q887630 | kg:/m/0357nx | George | Mathews | 1739-08-30 | M | 17612 | |||||||||||||||||
B000488 | Phanuel Bishop | B000488 | 401469 | 733 | Phanuel Bishop | Q2084938 | kg:/m/0261t6m | Phanuel | Bishop | 1739-09-03 | M | 9408 | |||||||||||||||||
P000320 | Andrew Pickens | P000320 | 408719 | 7425 | Andrew Pickens (congressman) | Q506733 | kg:/m/01k1kl | Andrew | Pickens | 1739-09-13 | M | 19670 | |||||||||||||||||
G000311 | James Gordon | G000311 | 404669 | 3695 | James Gordon (New York politician) | Q868475 | kg:/m/09143y | James | Gordon | 1739-10-31 | M | 13956 | |||||||||||||||||
B000735 | Theophilus Bradbury | B000735 | 401695 | 947 | Theophilus Bradbury | Q2419098 | kg:/m/0csf02 | Theophilus | Bradbury | 1739-11-13 | M | 9733 | |||||||||||||||||
L000478 | Christian Lower | L000478 | 406967 | 5812 | Christian Lower | Q5109863 | kg:/m/026pyc4 | Christian | Lower | 1740-01-07 | M | 17189 | |||||||||||||||||
P000092 | George Partridge | P000092 | 408502 | 7224 | George Partridge | Q1508042 | kg:/m/06gh02 | George | Partridge | 1740-02-08 | M | 19385 | |||||||||||||||||
T000389 | Jonathan Trumbull | T000389 | 410958 | 9489 | Jonathan Trumbull Jr. | Q881004 | kg:/m/01rbqk | Jonathan | Trumbull | 1740-03-26 | M | 23110 | Jr. | ||||||||||||||||
P000493 | Julien Poydras | P000493 | 408878 | Julien de Lallande Poydras | Q1712278 | kg:/m/01t00g | Julien | Poydras | 1740-04-03 | M | 19890 | de Lallande | |||||||||||||||||
B000661 | Elias Boudinot | B000661 | 401623 | 878 | Elias Boudinot | Q51753 | kg:/m/02rjz | Elias | Boudinot | 1740-05-02 | M | 9640 | |||||||||||||||||
I000009 | Daniel Ilsley | I000009 | 405871 | 4798 | Daniel Ilsley | Q1161198 | kg:/m/02rhdz7 | Daniel | Ilsley | 1740-05-30 | M | 15628 | |||||||||||||||||
S001047 | Jonathan Sturges | S001047 | 410501 | 9062 | Jonathan Sturges | Q1703315 | kg:/m/06qk1k | Jonathan | Sturges | 1740-08-23 | M | 22432 | |||||||||||||||||
C000313 | John Chapman | C000313 | 402455 | 1655 | John Chapman (Pennsylvania politician) | Q2658986 | kg:/m/027lkyd | John | Chapman | 1740-10-18 | M | 10847 | |||||||||||||||||
R000350 | Moses Robinson | R000350 | 409321 | 7989 | Moses Robinson | Q888648 | kg:/m/05k_0t | Moses | Robinson | 1741-03-22 | M | ||||||||||||||||||
N000109 | Nathaniel Niles | N000109 | 408193 | 6932 | Nathaniel Niles (politician) | Q1966777 | kg:/m/09q65p | Nathaniel | Niles | 1741-04-03 | M | 18966 | |||||||||||||||||
A000272 | John Archer | A000272 | 400911 | 222 | John Archer (Maryland politician) | Q2119983 | kg:/m/08vgxp | John | Archer | 1741-05-05 | M | 8643 | |||||||||||||||||
M000029 | Samuel Maclay | M000029 | 407057 | 5890 | Samuel Maclay | Q2218628 | kg:/m/08nl9z | Samuel | Maclay | 1741-06-17 | M | 17363 | |||||||||||||||||
L000067 | John Langdon | L000067 | 406576 | 5449 | John Langdon (politician) | Q554454 | kg:/m/02ctc_ | John | Langdon | 1741-06-26 | M | 16671 | |||||||||||||||||
I000035 | William Irvine | I000035 | 405892 | 4820 | William Irvine (general) | Q3568725 | kg:/m/04vncx | William | Irvine | 1741-11-03 | M | 15660 | |||||||||||||||||
H000916 | Daniel Huger | H000916 | 405761 | 4695 | Daniel Huger | Q1161182 | kg:/m/04vc5n | Daniel | Huger | 1742-02-20 | M | 15416 | |||||||||||||||||
B000546 | Theodorick Bland | B000546 | 401521 | 786 | Theodorick Bland (congressman) | Q1749152 | kg:/m/033mf4 | Theodorick | Bland | 1742-03-21 | M | 9479 | |||||||||||||||||
C001026 | Manasseh Cutler | C001026 | 403133 | 2287 | Manasseh Cutler | Q1513958 | kg:/m/078n3h | Manasseh | Cutler | 1742-05-13 | M | 11733 | |||||||||||||||||
T000273 | Thomas Tillinghast | T000273 | 410846 | 9385 | Thomas Tillinghast | Q670919 | kg:/m/02pp9gj | Thomas | Tillinghast | 1742-08-21 | M | 22964 | |||||||||||||||||
T000361 | Thomas Tredwell | T000361 | 410931 | 9463 | Thomas Tredwell | Q2427741 | kg:/m/08z7z9 | Thomas | Tredwell | 1743-02-06 | M | 23076 | |||||||||||||||||
H000629 | William Hindman | H000629 | 405486 | 4441 | William Hindman | Q5806411 | kg:/m/04htg_ | William | Hindman | 1743-04-01 | M | 15063 | |||||||||||||||||
R000257 | Samuel Riker | R000257 | 409233 | 7907 | Samuel Riker | Q1508078 | kg:/m/0g6q17 | Samuel | Riker | 1743-04-08 | M | 20403 | |||||||||||||||||
P000018 | John Page | P000018 | 408429 | 7156 | John Page (Virginia politician) | Q732158 | kg:/m/03rvds | John | Page | 1743-04-17 | M | 19304 | |||||||||||||||||
B001086 | Aedanus Burke | B001086 | 402032 | 1260 | Aedanus Burke | Q380504 | kg:/m/03yccv | Aedanus | Burke | 1743-06-16 | M | 10177 | |||||||||||||||||
W000013 | Jeremiah Wadsworth | W000013 | 411192 | 9706 | Jeremiah Wadsworth | Q1687546 | kg:/m/04fv3k | Jeremiah | Wadsworth | 1743-07-12 | M | 23236 | |||||||||||||||||
G000394 | Edwin Gray | G000394 | 404744 | 3763 | Edwin Gray | Q1294603 | kg:/m/027_r9s | Edwin | Gray | 1743-07-18 | M | 14060 | |||||||||||||||||
H000488 | Thomas Henderson | H000488 | 405351 | 4315 | Thomas Henderson (New Jersey politician) | Q435140 | kg:/m/0265_d0 | Thomas | Henderson | 1743-08-15 | M | 14885 | |||||||||||||||||
H000090 | Silas Halsey | H000090 | 404972 | 3972 | Silas Halsey | Q3610119 | kg:/m/02682wd | Silas | Halsey | 1743-10-06 | M | 14398 | |||||||||||||||||
O000067 | Gideon Olin | O000067 | 408340 | 7055 | Gideon Olin | Q1523133 | kg:/m/026kz1l | Gideon | Olin | 1743-11-02 | M | 19150 | |||||||||||||||||
M000828 | Stephen Mitchell | M000828 | 407803 | 6574 | Stephen Mix Mitchell | Q369829 | kg:/m/057py6 | Stephen | Mitchell | 1743-12-09 | M | 18370 | Mix | ||||||||||||||||
W000059 | John Walker | W000059 | 411238 | 9747 | John Walker (Virginia politician) | Q450549 | kg:/m/03zy19 | John | Walker | 1744-02-13 | M | 23286 | |||||||||||||||||
K000246 | Aaron Kitchell | K000246 | 406405 | 5303 | Aaron Kitchell | Q302196 | kg:/m/08z7gq | Aaron | Kitchell | 1744-07-10 | M | 16384 | |||||||||||||||||
B001186 | Pierce Butler | B001186 | 402128 | 1346 | Pierce Butler | Q2530426 | kg:/m/02q24s | Pierce | Butler | 1744-07-11 | M | 10302 | |||||||||||||||||
G000139 | Elbridge Gerry | G000139 | 404507 | 3541 | Elbridge Gerry | Q219797 | kg:/m/02sp2 | Elbridge | Gerry | 1744-07-17 | M | 13737 | |||||||||||||||||
C000497 | Joshua Clayton | C000497 | 402634 | 1823 | Joshua Clayton | Q652987 | kg:/m/0886hv | Joshua | Clayton | 1744-07-20 | M | ||||||||||||||||||
M000622 | Alexander Mebane | M000622 | 407611 | 6401 | Alexander Mebane | Q2545396 | kg:/m/04f8w6 | Alexander | Mebane | 1744-11-26 | M | 18102 | |||||||||||||||||
S000448 | Thomas Sinnickson | S000448 | 409941 | 8544 | Thomas Sinnickson (merchant) | Q2427322 | kg:/m/079yl7 | Thomas | Sinnickson | 1744-12-21 | M | 21696 | |||||||||||||||||
B000942 | Robert Brown | B000942 | 401896 | 1132 | Robert Brown (Pennsylvania politician) | Q7342402 | kg:/m/0266j1w | Robert | Brown | 1744-12-25 | M | 7691 | |||||||||||||||||
T000183 | Richard Thomas | T000183 | 410764 | 9308 | Richard Thomas (Pennsylvania politician) | Q7329439 | kg:/m/0265_h3 | Richard | Thomas | 1744-12-30 | M | 22856 | |||||||||||||||||
W000216 | Anthony Wayne | W000216 | 411384 | 9885 | Anthony Wayne | Q574116 | kg:/m/0k2g0 | Anthony | Wayne | 1745-01-01 | M | 23476 | |||||||||||||||||
W000560 | Francis Willis | W000560 | 411716 | 10202 | Francis Willis (Representative) | Q1361138 | kg:/m/0265tn5 | Francis | Willis | 1745-01-05 | M | 23877 | |||||||||||||||||
S001009 | Caleb Strong | S001009 | 410466 | 9028 | Caleb Strong | Q546613 | kg:/m/03d7pr | Caleb | Strong | 1745-01-09 | M | ||||||||||||||||||
F000364 | Jonathan Freeman | F000364 | 404310 | 3357 | Jonathan Freeman (representative) | Q1703164 | kg:/m/0260vf1 | Jonathan | Freeman | 1745-03-21 | M | 13429 | |||||||||||||||||
B000226 | Richard Bassett | B000226 | 401222 | 507 | Richard Bassett (Delaware politician) | Q518823 | kg:/m/02pz46 | Richard | Bassett | 1745-04-02 | M | ||||||||||||||||||
H000573 | John Hiester | H000573 | 405435 | 4393 | John Hiester | Q6239222 | kg:/m/0492rz | John | Hiester | 1745-04-09 | M | 14994 | |||||||||||||||||
E000147 | Oliver Ellsworth | E000147 | 403838 | 2936 | Oliver Ellsworth | Q515858 | kg:/m/027xqz | Oliver | Ellsworth | 1745-04-29 | M | 12776 | Oliver Ellsworth | ||||||||||||||||
T000403 | Thomas Tucker | T000403 | 410972 | 9501 | Thomas Tudor Tucker | Q464466 | kg:/m/06rg8t | Thomas | Tucker | 1745-06-25 | M | 23126 | Tudor | ||||||||||||||||
P000324 | Timothy Pickering | P000324 | 408722 | 7428 | Timothy Pickering | Q435168 | kg:/m/02csxn | Timothy | Pickering | 1745-07-17 | M | 19677 | |||||||||||||||||
S000257 | John Sevier | S000257 | 409758 | 8374 | John Sevier | Q888391 | kg:/m/02mk1d | John | Sevier | 1745-09-23 | M | 21455 | |||||||||||||||||
E000155 | Jonathan Elmer | E000155 | 403846 | 2943 | Jonathan Elmer | Q929830 | kg:/m/03zxl_ | Jonathan | Elmer | 1745-11-29 | M | 12784 | |||||||||||||||||
J000254 | Walter Jones | J000254 | 406147 | 5064 | Walter Jones (Virginia politician) | Q2544969 | kg:/m/05516l | Walter | Jones | 1745-12-18 | M | 16013 |
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);