legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by id descending
This data as json, copyable, CSV (advanced)
bio_birthday (date) >30 ✖
- 1818-10-08 4
- 1898-04-12 4
- 1786-12-25 3
- 1789-10-20 3
- 1802-06-12 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
- 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
- 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
- 1852-04-14 3
- 1854-01-20 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
W000707 | Frederick Woodard | W000707 | 411859 | 10337 | Frederick Augustus Woodard | Q946345 | kg:/m/05jzwx | Frederick | Woodard | 1854-02-12 | M | 24060 | Augustus | ||||||||||||||||
W000706 | William Wood | W000706 | 411858 | 10336 | William R. Wood (Indiana politician) | Q2580380 | kg:/m/02rklh6 | William | Wood | 1861-01-05 | M | 24058 | Robert | ||||||||||||||||
W000705 | Walter Wood | W000705 | 411857 | 10335 | Walter A. Wood | Q3701873 | kg:/m/02rkxk0 | Walter | Wood | 1815-10-23 | M | 24056 | Abbott | ||||||||||||||||
W000704 | Thomas Wood | W000704 | 411856 | 10334 | Thomas Jefferson Wood | Q2425087 | kg:/m/03gx9jt | Thomas | Wood | 1844-09-30 | M | 24055 | Jefferson | ||||||||||||||||
W000703 | Silas Wood | W000703 | 411855 | 10333 | Silas Wood | Q74557 | kg:/m/02rkwj0 | Silas | Wood | 1769-09-14 | M | 24054 | |||||||||||||||||
W000702 | Reuben Wood | W000702 | 411854 | 10332 | Reuben T. Wood | Q652579 | kg:/m/02rx837 | Reuben | Wood | 1884-08-07 | M | 24053 | Terrell | ||||||||||||||||
W000700 | John Wood | W000700 | 411852 | 10330 | John Travers Wood | Q1701961 | kg:/m/07kl7n | John | Wood | 1878-11-25 | M | 24051 | Travers | ||||||||||||||||
W000699 | John Wood | W000699 | 411851 | 10329 | John Stephens Wood | Q1701821 | kg:/m/0384k1 | John | Wood | 1885-02-08 | M | 24050 | Stephens | ||||||||||||||||
W000698 | John Wood | W000698 | 411850 | 10328 | John M. Wood | Q1590217 | kg:/m/02rtgrl | John | Wood | 1813-11-17 | M | 24049 | M. | ||||||||||||||||
W000697 | John Wood | W000697 | 411849 | 10327 | John J. Wood | Q64485 | kg:/m/02rksj5 | John | Wood | 1784-02-16 | M | 24048 | Jacob | ||||||||||||||||
W000696 | John Wood | W000696 | 411848 | 10326 | John Wood (congressman) | Q2729966 | kg:/m/0ktbvv | John | Wood | 1816-09-06 | M | 24047 | |||||||||||||||||
W000695 | Ira Wood | W000695 | 411847 | 10325 | Ira W. Wood | Q1612382 | kg:/m/02x2hx_ | Ira | Wood | 1856-06-19 | M | 24046 | Wells | ||||||||||||||||
W000694 | Fernando Wood | W000694 | 411846 | 10324 | Fernando Wood | Q430443 | kg:/m/021zqn | Fernando | Wood | 1812-06-14 | M | 24044 | |||||||||||||||||
W000693 | Ernest Wood | W000693 | 411845 | 10323 | Ernest E. Wood | Q1356294 | kg:/m/02rz5yh | Ernest | Wood | 1875-08-24 | M | 24042 | Edward | ||||||||||||||||
W000692 | Bradford Wood | W000692 | 411844 | 10322 | Bradford R. Wood | Q2514280 | kg:/m/02rkmky | Bradford | Wood | 1800-09-03 | M | 24041 | Ripley | ||||||||||||||||
W000691 | Benson Wood | W000691 | 411843 | 10321 | Benson Wood | Q4890290 | kg:/m/02rk8zn | Benson | Wood | 1839-03-31 | M | 24040 | |||||||||||||||||
W000690 | Benjamin Wood | W000690 | 411842 | 10320 | Benjamin Wood (American politician) | Q211890 | kg:/m/085q05 | Benjamin | Wood | 1820-10-13 | M | 24038 | |||||||||||||||||
W000689 | Amos Wood | W000689 | 411841 | 10319 | Amos E. Wood | Q4747854 | kg:/m/02rlzsm | Amos | Wood | 1810-01-02 | M | 24037 | Eastman | ||||||||||||||||
W000688 | Alan Wood | W000688 | 411840 | 10318 | Alan Wood Jr. | Q4708090 | kg:/m/0ksyx0 | Alan | Wood | 1834-07-06 | M | 24036 | Jr. | ||||||||||||||||
W000687 | Abiel Wood | W000687 | 411839 | 10317 | Abiel Wood | Q320912 | kg:/m/02rgty9 | Abiel | Wood | 1772-07-22 | M | 24035 | |||||||||||||||||
W000686 | Antonio Won Pat | W000686 | 411838 | Antonio Borja Won Pat | Q600957 | kg:/m/01s_z9 | Antonio | Won Pat | 1908-12-10 | M | 24034 | Borja | 01241 | ||||||||||||||||
W000685 | Simon Wolverton | W000685 | 411837 | 10316 | Simon Peter Wolverton | Q7519525 | kg:/m/0ksfpj | Simon | Wolverton | 1837-01-28 | M | 24033 | Peter | ||||||||||||||||
W000684 | John Wolverton | W000684 | 411836 | 10315 | John M. Wolverton | Q1288108 | kg:/m/03c2_p6 | John | Wolverton | 1872-01-31 | M | 24031 | Marshall | ||||||||||||||||
W000683 | Charles Wolverton | W000683 | 411835 | 10314 | Charles A. Wolverton | Q1063499 | kg:/m/0bp1mr | Charles | Wolverton | 1880-10-24 | M | 24030 | Anderson | ||||||||||||||||
W000682 | Howard Wolpe | W000682 | 411834 | 14673 | Howard Wolpe | Q995192 | kg:/m/04zr6n | Howard | Wolpe | 1939-11-03 | M | 24029 | Eliot | III | 01240 | ||||||||||||||
W000681 | Frank Wolford | W000681 | 411833 | 10313 | Frank Lane Wolford | Q1443631 | kg:/m/02rhgbl | Frank | Wolford | 1817-09-02 | M | 24028 | Lane | ||||||||||||||||
W000680 | Lester Wolff | W000680 | 411832 | 10784 | Lester L. Wolff | Q1626737 | kg:/m/0gmd5l | Lester | Wolff | 1919-01-04 | M | 24027 | Lionel | 01239 | |||||||||||||||
W000679 | Joseph Wolff | W000679 | 411831 | 10312 | J. Scott Wolff | Q1676403 | kg:/m/02rz6ny | Joseph | Wolff | 1878-06-14 | M | 24026 | Scott | ||||||||||||||||
W000678 | James Wolfenden | W000678 | 411830 | 10311 | James Wolfenden | Q13219860 | kg:/m/0dhlry | James | Wolfenden | 1889-07-25 | M | 24025 | |||||||||||||||||
W000677 | Simeon Wolfe | W000677 | 411829 | 10310 | Simeon K. Wolfe | Q2287078 | kg:/m/02rkhph | Simeon | Wolfe | 1824-02-14 | M | 24024 | Kalfius | ||||||||||||||||
W000676 | William Wolf | W000676 | 411828 | 10309 | William P. Wolf | Q1302427 | kg:/m/02r72qn | William | Wolf | 1833-12-01 | M | 24022 | Penn | ||||||||||||||||
W000675 | Leonard Wolf | W000675 | 411827 | 10308 | Leonard G. Wolf | Q1818969 | kg:/m/02rk7xz | Leonard | Wolf | 1925-10-29 | M | 24021 | George | ||||||||||||||||
W000674 | Harry Wolf | W000674 | 411826 | 10307 | Harry Benjamin Wolf | Q1107875 | kg:/m/02qzs05 | Harry | Wolf | 1880-06-16 | M | 24020 | Benjamin | ||||||||||||||||
W000673 | George Wolf | W000673 | 411825 | 10306 | George Wolf | Q373221 | kg:/m/0293kh | George | Wolf | 1777-08-12 | M | 24019 | |||||||||||||||||
W000672 | Frank Wolf | W000672 | 400435 | 14869 | Frank Wolf (politician) | Q1444483 | kg:/m/027zy9 | Frank | Wolf | 1939-01-30 | M | 24018 | R. | Frank Wolf | 01238 | 7508 | 27120 | Frank R. Wolf | N00002073 | [ "H6VA10050" ] |
520 | ||||||||
W000671 | John Wold | W000671 | 411824 | 12034 | John S. Wold | Q1701666 | kg:/m/09mbsp | John | Wold | 1916-08-31 | M | 24016 | Schiller | ||||||||||||||||
W000669 | Josiah Wolcott | W000669 | 411822 | 10304 | Josiah O. Wolcott | Q1708654 | kg:/m/06vs0l | Josiah | Wolcott | 1877-10-31 | M | Oliver | |||||||||||||||||
W000668 | Jesse Wolcott | W000668 | 411821 | 10303 | Jesse P. Wolcott | Q784436 | kg:/m/02pw4x1 | Jesse | Wolcott | 1893-03-03 | M | 24013 | Paine | ||||||||||||||||
W000667 | Edward Wolcott | W000667 | 411820 | 10302 | Edward O. Wolcott | Q1293143 | kg:/m/0bf33m | Edward | Wolcott | 1848-03-26 | M | Oliver | |||||||||||||||||
W000666 | Thomas Wofford | W000666 | 411819 | 10301 | Thomas A. Wofford | Q433654 | kg:/m/0d060z | Thomas | Wofford | 1908-09-27 | M | Albert | |||||||||||||||||
W000665 | Harris Wofford | W000665 | 411818 | 49104 | Harris Wofford | Q323511 | kg:/m/038445 | Harris | Wofford | 1926-04-09 | M | 01457 | S219 | ||||||||||||||||
W000664 | William Witte | W000664 | 411817 | 10300 | William Henry Witte | Q8012219 | kg:/m/026fczm | William | Witte | 1817-10-04 | M | 24008 | Henry | ||||||||||||||||
W000663 | Gardner Withrow | W000663 | 411816 | 10299 | Gardner R. Withrow | Q658433 | kg:/m/0b6wcc | Gardner | Withrow | 1892-10-05 | M | 24007 | Robert | ||||||||||||||||
W000662 | Samuel Witherspoon | W000662 | 411815 | 10298 | Samuel Andrew Witherspoon | Q2217906 | kg:/m/02rtn8t | Samuel | Witherspoon | 1855-05-04 | M | 24005 | Andrew | ||||||||||||||||
W000661 | Robert Witherspoon | W000661 | 411814 | 10297 | Robert Witherspoon | Q2159230 | kg:/m/02vn_y4 | Robert | Witherspoon | 1767-01-29 | M | 24004 | |||||||||||||||||
W000659 | Robert Withers | W000659 | 411812 | 10295 | Robert E. Withers | Q1664315 | kg:/m/08kl1d | Robert | Withers | 1821-09-18 | M | Enoch | |||||||||||||||||
W000658 | Garrett Withers | W000658 | 411811 | 10294 | Garrett Withers | Q1411163 | kg:/m/08h0jk | Garrett | Withers | 1884-06-21 | M | 24001 | Lee | ||||||||||||||||
W000657 | James Witherell | W000657 | 411810 | 10293 | James Witherell | Q1681320 | kg:/m/026kt04 | James | Witherell | 1759-06-16 | M | 23999 | |||||||||||||||||
W000656 | John Witcher | W000656 | 411809 | 10292 | John Witcher | Q1266476 | kg:/m/02pm261 | John | Witcher | 1839-07-15 | M | 23998 | Seashoal | ||||||||||||||||
W000654 | Robert Wise | W000654 | 400614 | 15077 | Bob Wise | Q780398 | kg:/m/026b40 | Robert | Wise | 1948-01-06 | M | 23996 | E. | Jr. | 01237 | ||||||||||||||
W000653 | Richard Wise | W000653 | 411807 | 10290 | Richard Alsop Wise | Q1691166 | kg:/m/03c2_7d | Richard | Wise | 1843-09-02 | M | 23994 | Alsop | ||||||||||||||||
W000652 | Morgan Wise | W000652 | 411806 | 10289 | Morgan Ringland Wise | Q6911828 | kg:/m/0cdltz | Morgan | Wise | 1825-06-07 | M | 23993 | Ringland | ||||||||||||||||
W000651 | John Wise | W000651 | 411805 | 10288 | John Sergeant Wise | Q1701724 | kg:/m/02svs2 | John | Wise | 1846-12-27 | M | 23992 | Sergeant | ||||||||||||||||
W000650 | James Wise | W000650 | 411804 | 10287 | James W. Wise | Q1320424 | kg:/m/02rk0yw | James | Wise | 1868-03-03 | M | 23991 | Walter | ||||||||||||||||
W000649 | Henry Wise | W000649 | 411803 | 10286 | Henry A. Wise | Q878516 | kg:/m/038426 | Henry | Wise | 1806-12-03 | M | 23990 | Alexander | ||||||||||||||||
W000648 | George Wise | W000648 | 411802 | 10285 | George D. Wise | Q1507189 | kg:/m/02vrppn | George | Wise | 1831-06-04 | M | 23988 | Douglas | ||||||||||||||||
W000647 | Timothy Wirth | W000647 | 411801 | 14282 | Tim Wirth | Q1027431 | kg:/m/0g8dy | Timothy | Wirth | 1939-09-22 | M | 23986 | E. | 01236 | S181 | ||||||||||||||
W000646 | Robert Winthrop | W000646 | 411800 | 10284 | Robert Charles Winthrop | Q1375119 | kg:/m/02jnfg | Robert | Winthrop | 1809-05-12 | M | 23984 | Charles | ||||||||||||||||
W000645 | Thomas Winter | W000645 | 411799 | 10283 | Thomas Daniel Winter | Q1286350 | kg:/m/02rmb8j | Thomas | Winter | 1896-07-07 | M | 23982 | Daniel | ||||||||||||||||
W000644 | Elisha Winter | W000644 | 411798 | 10282 | Elisha I. Winter | Q2271338 | kg:/m/02rkp65 | Elisha | Winter | 1781-07-15 | M | 23981 | I. | ||||||||||||||||
W000643 | Charles Winter | W000643 | 411797 | 10281 | Charles E. Winter | Q1064235 | kg:/m/0265k3t | Charles | Winter | 1870-09-13 | M | 23980 | Edwin | ||||||||||||||||
W000642 | Joseph Winston | W000642 | 411796 | 10280 | Joseph Winston | Q1306824 | kg:/m/0343_h | Joseph | Winston | 1746-06-17 | M | 23979 | |||||||||||||||||
W000641 | William Winstead | W000641 | 411795 | 10279 | W. Arthur Winstead | Q2536627 | kg:/m/02rtmzh | William | Winstead | 1904-01-06 | M | 23978 | Arthur | ||||||||||||||||
W000640 | Warren Winslow | W000640 | 411794 | 10278 | Warren Winslow | Q2549811 | kg:/m/02j1k9 | Warren | Winslow | 1810-01-01 | M | 23977 | |||||||||||||||||
W000639 | Samuel Winslow | W000639 | 411793 | 10277 | Samuel Winslow | Q1656667 | kg:/m/0bvdqh | Samuel | Winslow | 1862-04-11 | M | 23976 | Ellsworth | ||||||||||||||||
W000638 | Thomas Winn | W000638 | 411792 | 10276 | Thomas E. Winn | Q1459914 | kg:/m/02rk152 | Thomas | Winn | 1839-05-21 | M | 23975 | Elisha | ||||||||||||||||
W000637 | Richard Winn | W000637 | 411791 | 10275 | Richard Winn | Q2150938 | kg:/m/096sy7 | Richard | Winn | M | 23974 | ||||||||||||||||||
W000636 | Edward Winn | W000636 | 411790 | 11057 | Larry Winn | Q1689332 | kg:/m/027n4yt | Edward | Winn | 1919-08-22 | M | 23973 | Lawrence | Larry | Jr. | 01235 | |||||||||||||
W000635 | Otis Wingo | W000635 | 411789 | 10274 | Otis Wingo | Q2037052 | kg:/m/02rjxt4 | Otis | Wingo | 1877-06-18 | M | 23971 | Theodore | ||||||||||||||||
W000634 | Effiegene Wingo | W000634 | 411788 | 10273 | Effiegene Locke Wingo | Q1296186 | kg:/m/02rhfv2 | Effiegene | Wingo | 1883-04-13 | F | 23970 | Locke | ||||||||||||||||
W000633 | Paine Wingate | W000633 | 411787 | 10272 | Paine Wingate | Q1638165 | kg:/m/03zy2r | Paine | Wingate | 1739-05-14 | M | 23968 | |||||||||||||||||
W000632 | Joseph Wingate | W000632 | 411786 | 10271 | Joseph F. Wingate | Q1706955 | kg:/m/02ry1kw | Joseph | Wingate | 1786-06-29 | M | 23966 | Ferdinand | ||||||||||||||||
W000631 | Austin Wing | W000631 | 411785 | Austin Eli Wing | Q781074 | kg:/m/026vz6l | Austin | Wing | 1792-02-03 | M | 23965 | Eli | |||||||||||||||||
W000630 | Charles Winfield | W000630 | 411784 | 10269 | Charles H. Winfield | Q2114703 | kg:/m/02rkmxl | Charles | Winfield | 1822-04-22 | M | 23964 | Henry | ||||||||||||||||
W000629 | William Windom | W000629 | 411783 | 10268 | William Windom | Q1374474 | kg:/m/01l_4h | William | Windom | 1827-05-10 | M | 23963 | |||||||||||||||||
W000628 | Boyd Winchester | W000628 | 411782 | 10267 | Boyd Winchester | Q895944 | kg:/m/02qh6ym | Boyd | Winchester | 1836-09-23 | M | 23961 | |||||||||||||||||
W000627 | John Winans | W000627 | 411781 | 10266 | John Winans | Q924453 | kg:/m/02vrqx6 | John | Winans | 1831-09-27 | M | 23959 | |||||||||||||||||
W000626 | James Winans | W000626 | 411780 | 10265 | James J. Winans | Q12200803 | kg:/m/02rm1ch | James | Winans | 1818-06-07 | M | 23958 | January | ||||||||||||||||
W000625 | Edwin Winans | W000625 | 411779 | 10264 | Edwin B. Winans (politician) | Q670158 | kg:/m/03nrgv | Edwin | Winans | 1826-05-16 | M | 23957 | Baruch | ||||||||||||||||
W000624 | William Wilson | W000624 | 411778 | 10263 | William Warfield Wilson | Q2580919 | kg:/m/02rkdp7 | William | Wilson | 1868-03-02 | M | 23956 | Warfield | ||||||||||||||||
W000623 | William Wilson | W000623 | 411777 | 10262 | William Lyne Wilson | Q376232 | kg:/m/03836n | William | Wilson | 1843-05-03 | M | 23955 | Lyne | ||||||||||||||||
W000622 | William Wilson | W000622 | 411776 | 10261 | William H. Wilson | Q8010675 | kg:/m/0dj83n | William | Wilson | 1877-12-06 | M | 23953 | Henry | ||||||||||||||||
W000621 | William Wilson | W000621 | 411775 | 10260 | William E. Wilson (Indiana politician) | Q1665147 | kg:/m/02rkj15 | William | Wilson | 1870-03-09 | M | 23952 | Edward | ||||||||||||||||
W000620 | William Wilson | W000620 | 411774 | 10259 | William Bauchop Wilson | Q723828 | kg:/m/0382_j | William | Wilson | 1862-04-02 | M | 23951 | Bauchop | ||||||||||||||||
W000619 | William Wilson | W000619 | 411773 | 10258 | William Wilson (Ohio politician) | Q8020437 | kg:/m/02rm4y9 | William | Wilson | 1773-03-19 | M | 23949 | |||||||||||||||||
W000618 | William Wilson | W000618 | 412120 | 10257 | William Wilson (Pennsylvania politician) | Q8020438 | kg:/m/027hpmk | William | Wilson | M | 23948 | ||||||||||||||||||
W000617 | Thomas Wilson | W000617 | 411772 | 10256 | T. Webber Wilson | Q921315 | kg:/m/02rtn7s | Thomas | Wilson | 1893-01-24 | M | 23947 | Webber | ||||||||||||||||
W000616 | Thomas Wilson | W000616 | 411770 | 10254 | Thomas Wilson (Pennsylvania politician) | Q2428214 | kg:/m/027d0q2 | Thomas | Wilson | M | 23946 | ||||||||||||||||||
W000615 | Thomas Wilson | W000615 | 411769 | 10253 | Thomas Wilson (Virginia politician) | Q2428216 | kg:/m/03c2_z3 | Thomas | Wilson | 1765-09-11 | M | 23945 | |||||||||||||||||
W000614 | Thomas Wilson | W000614 | 411771 | 10255 | Thomas Wilson (Minnesota politician) | Q2428210 | kg:/m/0dqq48 | Thomas | Wilson | 1827-05-16 | M | 23944 | |||||||||||||||||
W000613 | Stephen Wilson | W000613 | 411768 | 10252 | Stephen Fowler Wilson | Q7609223 | kg:/m/0kt7kz | Stephen | Wilson | 1821-09-04 | M | 23943 | Fowler | ||||||||||||||||
W000612 | Stanyarne Wilson | W000612 | 411767 | 10251 | Stanyarne Wilson | Q1337534 | kg:/m/02vp02n | Stanyarne | Wilson | 1860-01-10 | M | 23942 | |||||||||||||||||
W000611 | Robert Wilson | W000611 | 411766 | 10250 | Robert Patterson Clark Wilson | Q2158457 | kg:/m/02rz80y | Robert | Wilson | 1834-08-08 | M | 23940 | Patterson Clark | ||||||||||||||||
W000610 | Robert Wilson | W000610 | 411765 | 10249 | Bob Wilson (politician) | Q888328 | kg:/m/0986w2 | Robert | Wilson | 1916-04-05 | M | 23939 | Carlton | Bob | 01234 | ||||||||||||||
W000609 | Robert Wilson | W000609 | 411764 | 10248 | Robert Wilson (Missouri politician) | Q2159228 | kg:/m/0d01f2 | Robert | Wilson | M | |||||||||||||||||||
W000608 | Riley Wilson | W000608 | 411763 | 10247 | Riley J. Wilson | Q139029 | kg:/m/026pwfl | Riley | Wilson | 1871-11-12 | M | 23937 | Joseph | ||||||||||||||||
W000607 | Pete Wilson | W000607 | 411762 | 14915 | Pete Wilson | Q714909 | kg:/m/01ychc | Pete | Wilson | 1933-08-23 | M | 01456 | S165 | ||||||||||||||||
W000606 | Nathan Wilson | W000606 | 411761 | 10246 | Nathan Wilson (politician) | Q2183101 | kg:/m/026kc4h | Nathan | Wilson | 1758-12-23 | M | 23935 | |||||||||||||||||
W000605 | Joseph Wilson | W000605 | 411760 | 10245 | Joseph G. Wilson | Q1707060 | kg:/m/0280c7g | Joseph | Wilson | 1826-12-13 | M | 23934 | Gardner | ||||||||||||||||
W000604 | Joseph Wilson | W000604 | 411759 | 10244 | Joseph Franklin Wilson | Q1385163 | kg:/m/02w673k | Joseph | Wilson | 1901-03-18 | M | 23933 | Franklin |
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);