legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by id_opensecrets
This data as json, copyable, CSV (advanced)
bio_birthday (date) >30 ✖
- 1958-06-17 3
- 1940-03-31 2
- 1941-09-06 2
- 1943-01-18 2
- 1943-06-14 2
- 1943-10-05 2
- 1947-01-23 2
- 1947-08-24 2
- 1950-07-18 2
- 1950-09-03 2
- 1951-05-04 2
- 1951-05-08 2
- 1951-07-05 2
- 1952-07-21 2
- 1952-09-02 2
- 1953-11-01 2
- 1954-10-24 2
- 1955-04-08 2
- 1955-10-20 2
- 1956-11-14 2
- 1957-08-04 2
- 1959-09-12 2
- 1959-10-24 2
- 1960-05-10 2
- 1960-05-28 2
- 1960-06-01 2
- 1960-10-16 2
- 1960-12-30 2
- 1961-05-08 2
- 1961-11-01 2
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
W000740 | Dudley Wooten | W000740 | 411890 | 10369 | Dudley G. Wooten | Q1263734 | kg:/m/03c2zsf | Dudley | Wooten | 1860-06-19 | M | 24101 | Goodall | ||||||||||||||||
W000741 | Samuel Worcester | W000741 | 411891 | 10370 | Samuel T. Worcester | Q7412740 | kg:/m/02rm314 | Samuel | Worcester | 1804-08-30 | M | 24102 | Thomas | ||||||||||||||||
W000742 | Thomas Word | W000742 | 412122 | 10371 | Thomas J. Word | Q747450 | kg:/m/02rtm_j | Thomas | Word | M | 24103 | Jefferson | |||||||||||||||||
W000743 | John Works | W000743 | 411892 | 10372 | John D. Works | Q478639 | kg:/m/03sgjz | John | Works | 1847-03-29 | M | Downey | |||||||||||||||||
W000744 | Francis Worley | W000744 | 411893 | 10373 | Eugene Worley | Q1373204 | kg:/m/03c2_0p | Francis | Worley | 1908-10-10 | M | 24105 | Eugene | ||||||||||||||||
W000745 | Ludwig Worman | W000745 | 411894 | 10374 | Ludwig Worman | Q6699374 | kg:/m/027hjjw | Ludwig | Worman | M | 24106 | ||||||||||||||||||
W000746 | Jacob Wortendyke | W000746 | 411895 | 10375 | Jacob R. Wortendyke | Q1677615 | kg:/m/02z16sp | Jacob | Wortendyke | 1818-11-27 | M | 24107 | Reynier | ||||||||||||||||
W000747 | Henry Worthington | W000747 | 411896 | 10376 | Henry G. Worthington | Q1606767 | kg:/m/0272zy1 | Henry | Worthington | 1828-02-09 | M | 24108 | Gaither | ||||||||||||||||
W000748 | John Worthington | W000748 | 411897 | 10377 | John Tolley Hood Worthington | Q983168 | kg:/m/02rhklg | John | Worthington | 1788-11-01 | M | 24109 | Tolley Hood | ||||||||||||||||
W000749 | Nicholas Worthington | W000749 | 411898 | 10378 | Nicholas E. Worthington | Q13218893 | kg:/m/02rkc53 | Nicholas | Worthington | 1836-03-30 | M | 24110 | Ellsworth | ||||||||||||||||
W000750 | Thomas Worthington | W000750 | 411899 | 10379 | Thomas Worthington (governor) | Q368387 | kg:/m/0340l5 | Thomas | Worthington | 1773-07-16 | M | ||||||||||||||||||
W000751 | Thomas Worthington | W000751 | 411900 | 10380 | Thomas Contee Worthington | Q1287817 | kg:/m/0284j3f | Thomas | Worthington | 1782-11-25 | M | 24112 | Contee | ||||||||||||||||
W000752 | George Wortley | W000752 | 411901 | 14870 | George C. Wortley | Q5537601 | kg:/m/0gkqrs | George | Wortley | 1926-12-08 | M | 24113 | Cornelius | 01243 | |||||||||||||||
W000753 | Thomas Wren | W000753 | 411902 | 10381 | Thomas Wren (Nevada politician) | Q1281091 | kg:/m/0272_1j | Thomas | Wren | 1826-01-02 | M | 24114 | |||||||||||||||||
W000754 | Ashley Wright | W000754 | 411903 | 10382 | Ashley B. Wright | Q725743 | kg:/m/081fzs | Ashley | Wright | 1841-05-25 | M | 24116 | Bascom | ||||||||||||||||
W000755 | Augustus Wright | W000755 | 411904 | 10383 | Augustus Romaldus Wright | Q770613 | kg:/m/0gk970 | Augustus | Wright | 1813-06-16 | M | 24117 | Romaldus | ||||||||||||||||
W000756 | Charles Wright | W000756 | 411905 | 10384 | Charles Frederick Wright | Q13219865 | kg:/m/0gdvc3 | Charles | Wright | 1856-05-03 | M | 24119 | Frederick | ||||||||||||||||
W000757 | Daniel Wright | W000757 | 411906 | 10385 | Daniel B. Wright | Q1159998 | kg:/m/02rtm_w | Daniel | Wright | 1812-02-17 | M | 24120 | Boone | ||||||||||||||||
W000758 | Edwin Wright | W000758 | 411907 | 10386 | Edwin R. V. Wright | Q178255 | kg:/m/02r918_ | Edwin | Wright | 1812-01-02 | M | 24121 | Ruthvin Vincent | ||||||||||||||||
W000759 | George Wright | W000759 | 411908 | 10387 | George G. Wright | Q1507398 | kg:/m/0cvhx6 | George | Wright | 1820-03-24 | M | Grover | |||||||||||||||||
W000760 | George Wright | W000760 | 411909 | 10388 | George Washington Wright | Q1508563 | kg:/m/09lb9_ | George | Wright | 1816-06-04 | M | 24123 | Washington | ||||||||||||||||
W000761 | Hendrick Wright | W000761 | 411910 | 10389 | Hendrick Bradley Wright | Q13219870 | kg:/m/0ksz34 | Hendrick | Wright | 1808-04-24 | M | 24124 | Bradley | ||||||||||||||||
W000762 | James Wright | W000762 | 411911 | 10390 | James A. Wright | Q6128332 | kg:/m/029vl0 | James | Wright | 1902-08-11 | M | 24125 | Assion | ||||||||||||||||
W000763 | James Wright | W000763 | 411912 | 10391 | Jim Wright | Q949514 | kg:/m/029yzb | James | Wright | 1922-12-22 | M | 24127 | Claude | Jr. | 01244 | ||||||||||||||
W000764 | John Wright | W000764 | 411913 | 10392 | John C. Wright (Ohio politician) | Q6224685 | kg:/m/02rm1kp | John | Wright | 1783-08-17 | M | 24128 | Crafts | ||||||||||||||||
W000765 | John Wright | W000765 | 411914 | 10393 | John Vines Wright | Q1702020 | kg:/m/0dc76r | John | Wright | 1828-06-28 | M | 24129 | Vines | ||||||||||||||||
W000766 | Joseph Wright | W000766 | 411915 | 10394 | Joseph A. Wright | Q830000 | kg:/m/061r4s | Joseph | Wright | 1810-04-17 | M | 24131 | Albert | ||||||||||||||||
W000767 | Myron Wright | W000767 | 411916 | 10395 | Myron Benjamin Wright | Q6948421 | kg:/m/0ksfmm | Myron | Wright | 1847-06-12 | M | 24132 | Benjamin | ||||||||||||||||
W000768 | Robert Wright | W000768 | 411917 | 10396 | Robert Wright (Maryland politician) | Q881032 | kg:/m/030p5v | Robert | Wright | 1752-11-20 | M | 24134 | |||||||||||||||||
W000769 | Samuel Wright | W000769 | 411918 | 10397 | Samuel G. Wright | Q2218298 | kg:/m/0bwwtz | Samuel | Wright | 1781-11-18 | M | 24135 | Gardiner | ||||||||||||||||
W000770 | Silas Wright | W000770 | 411919 | 10398 | Silas Wright | Q777453 | kg:/m/02z5dk | Silas | Wright | 1795-05-24 | M | 24137 | Jr. | ||||||||||||||||
W000772 | William Wright | W000772 | 411921 | 10400 | William Wright (New Jersey politician) | Q1522975 | kg:/m/0b341y | William | Wright | 1794-11-13 | M | 24140 | |||||||||||||||||
W000773 | William Wright | W000773 | 411922 | 10401 | William C. Wright | Q1394166 | kg:/m/02rk174 | William | Wright | 1866-01-06 | M | 24141 | Carter | ||||||||||||||||
W000774 | John Wurts | W000774 | 411923 | 10402 | John Wurts | Q6264997 | kg:/m/027bnw9 | John | Wurts | 1792-08-13 | M | 24142 | |||||||||||||||||
W000775 | Harry Wurzbach | W000775 | 411924 | 10403 | Harry M. Wurzbach | Q1586648 | kg:/m/0cfs_b | Harry | Wurzbach | 1874-05-19 | M | 24144 | McLeary | ||||||||||||||||
W000776 | Adam Wyant | W000776 | 411925 | 10404 | Adam Martin Wyant | Q4679453 | kg:/m/0fsctg | Adam | Wyant | 1869-09-15 | M | 24145 | Martin | ||||||||||||||||
W000777 | Joseph Wyatt | W000777 | 411926 | 14674 | Joseph P. Wyatt Jr. | Q201651 | kg:/m/02rvb24 | Joseph | Wyatt | 1941-10-12 | M | 24147 | Peyton | Jr. | 01245 | ||||||||||||||
W000778 | Wendell Wyatt | W000778 | 411927 | 10785 | Wendell Wyatt | Q434476 | kg:/m/027yh6f | Wendell | Wyatt | 1917-06-15 | M | 24148 | 01246 | ||||||||||||||||
W000780 | John Wydler | W000780 | 411928 | 10638 | John W. Wydler | Q723155 | kg:/m/0gmcw6 | John | Wydler | 1924-06-09 | M | 24151 | Waldemar | 01248 | |||||||||||||||
W000781 | Chalmers Wylie | W000781 | 411929 | 11058 | Chalmers Wylie | Q5069018 | kg:/m/06pgdr | Chalmers | Wylie | 1920-11-23 | M | 24153 | Pangburn | 01249 | |||||||||||||||
W000782 | Louis Wyman | W000782 | 411930 | 10639 | Louis C. Wyman | Q1772866 | kg:/m/07t883 | Louis | Wyman | 1917-03-16 | M | 24155 | Crosby | 01250 | |||||||||||||||
W000783 | Henry Wynkoop | W000783 | 411931 | 10405 | Henry Wynkoop | Q5730595 | kg:/m/03tpf2 | Henry | Wynkoop | 1737-03-02 | M | 24156 | |||||||||||||||||
W000785 | William Wynn | W000785 | 411932 | 10406 | William J. Wynn | Q2579475 | kg:/m/02rj_pn | William | Wynn | 1860-06-12 | M | 24159 | Joseph | ||||||||||||||||
W000786 | Thomas Wynns | W000786 | 411933 | 10407 | Thomas Wynns | Q1348731 | kg:/m/03t5tr | Thomas | Wynns | M | 24160 | ||||||||||||||||||
Y000001 | Bartlett Yancey | Y000001 | 411935 | 10409 | Bartlett Yancey | Q809453 | kg:/m/04wsvm | Bartlett | Yancey | 1785-02-19 | M | 21033 | |||||||||||||||||
Y000002 | Joel Yancey | Y000002 | 411936 | 10410 | Joel Yancey | Q1691758 | kg:/m/02r3m0_ | Joel | Yancey | 1773-10-21 | M | 21034 | |||||||||||||||||
Y000003 | William Yancey | Y000003 | 411937 | 10411 | William Lowndes Yancey | Q645216 | kg:/m/04hhn6 | William | Yancey | 1814-08-10 | M | 21036 | Lowndes | ||||||||||||||||
Y000004 | Teodoro Yangco | Y000004 | 411938 | Teodoro R. Yangco | Q2308718 | kg:/m/0chrl_ | Teodoro | Yangco | 1861-11-09 | M | 21037 | Rafael | |||||||||||||||||
Y000005 | George Yaple | Y000005 | 411939 | 10413 | George L. Yaple | Q1507725 | kg:/m/025ygg0 | George | Yaple | 1851-02-20 | M | 21038 | Lewis | ||||||||||||||||
Y000006 | Ralph Yarborough | Y000006 | 411940 | 10414 | Ralph Yarborough | Q2129881 | kg:/m/021nlp | Ralph | Yarborough | 1903-06-08 | M | Webster | |||||||||||||||||
Y000007 | Robert Yardley | Y000007 | 411941 | 10415 | Robert Morris Yardley | Q7347823 | kg:/m/0kslj9 | Robert | Yardley | 1850-10-09 | M | 21040 | Morris | ||||||||||||||||
Y000009 | John Yates | Y000009 | 411943 | 10417 | John B. Yates | Q2506478 | kg:/m/02rks22 | John | Yates | 1784-02-01 | M | 21042 | Barentse | ||||||||||||||||
Y000011 | Richard Yates | Y000011 | 411946 | 10420 | Richard Yates Jr. | Q363786 | kg:/m/0c51t2 | Richard | Yates | 1860-12-12 | M | 21044 | |||||||||||||||||
Y000012 | Richard Yates | Y000012 | 411945 | 10419 | Richard Yates (politician, born 1815) | Q880987 | kg:/m/0c51sr | Richard | Yates | 1815-01-18 | M | 21046 | |||||||||||||||||
Y000013 | Sidney Yates | Y000013 | 411947 | 10421 | Sidney R. Yates | Q2776506 | kg:/m/03t87r | Sidney | Yates | 1909-08-27 | M | 21048 | Richard | 01252 | |||||||||||||||
Y000014 | Gus Yatron | Y000014 | 411948 | 12035 | Gus Yatron | Q9282777 | kg:/m/0dls9p | Gus | Yatron | 1927-10-16 | M | 21049 | 01253 | ||||||||||||||||
Y000015 | George Yeaman | Y000015 | 411949 | 10422 | George Helm Yeaman | Q943159 | kg:/m/02rhgmj | George | Yeaman | 1829-11-01 | M | 21050 | Helm | ||||||||||||||||
Y000016 | Jesse Yeates | Y000016 | 411950 | 10423 | Jesse Johnson Yeates | Q613563 | kg:/m/04wsn9 | Jesse | Yeates | 1829-05-29 | M | 21051 | Johnson | ||||||||||||||||
Y000017 | Archibald Yell | Y000017 | 411951 | 10424 | Archibald Yell | Q364730 | kg:/m/01sk8t | Archibald | Yell | M | 21052 | ||||||||||||||||||
Y000018 | Charles Yoakum | Y000018 | 411952 | 10425 | Charles Henderson Yoakum | Q1064793 | kg:/m/03c2zpb | Charles | Yoakum | 1849-07-10 | M | 21053 | Henderson | ||||||||||||||||
Y000019 | Seth Yocum | Y000019 | 411953 | 10426 | Seth Hartman Yocum | Q7456501 | kg:/m/0kt0gq | Seth | Yocum | 1834-08-02 | M | 21054 | Hartman | ||||||||||||||||
Y000020 | Samuel Yoder | Y000020 | 411954 | 10427 | Samuel S. Yoder | Q7412559 | kg:/m/02rm2_s | Samuel | Yoder | 1841-08-16 | M | 21055 | S. | ||||||||||||||||
Y000021 | Thomas Yon | Y000021 | 411955 | 10428 | Tom Yon | Q2439459 | kg:/m/02rl0pr | Thomas | Yon | 1882-03-14 | M | 21056 | Alva | ||||||||||||||||
Y000022 | Tyre York | Y000022 | 411956 | 10429 | Tyre York | Q2463326 | kg:/m/04wsft | Tyre | York | 1836-05-04 | M | 21057 | |||||||||||||||||
Y000023 | Thomas Yorke | Y000023 | 411957 | 10430 | Thomas Jones Yorke | Q1478720 | kg:/m/027wxgb | Thomas | Yorke | 1801-03-25 | M | 21058 | Jones | ||||||||||||||||
Y000024 | Samuel Yorty | Y000024 | 411958 | 10431 | Sam Yorty | Q552548 | kg:/m/01z_tr | Samuel | Yorty | 1909-10-01 | M | 21059 | William | ||||||||||||||||
Y000025 | Jacob Yost | Y000025 | 411959 | 10432 | Jacob Yost (Virginia congressman) | Q1677675 | kg:/m/03m9trf | Jacob | Yost | 1853-04-01 | M | 21060 | |||||||||||||||||
Y000026 | Jacob Yost | Y000026 | 411960 | 10433 | Jacob Senewell Yost | Q13219872 | kg:/m/0fv_02 | Jacob | Yost | 1801-07-29 | M | 21061 | Senewell | ||||||||||||||||
Y000027 | Henry Youmans | Y000027 | 411961 | 10434 | Henry M. Youmans | Q1251770 | kg:/m/02px_6y | Henry | Youmans | 1832-05-15 | M | 21062 | Melville | ||||||||||||||||
Y000028 | Andrew Young | Y000028 | 411962 | 14063 | Andrew Young | Q959635 | kg:/m/018t4c | Andrew | Young | 1932-03-12 | M | 21064 | Jackson | Jr. | 01254 | ||||||||||||||
Y000029 | Augustus Young | Y000029 | 411963 | 10435 | Augustus Young (representative) | Q770669 | kg:/m/03c6bf8 | Augustus | Young | 1784-03-20 | M | 21065 | |||||||||||||||||
Y000030 | Bryan Young | Y000030 | 411964 | 10436 | Bryan Young (politician) | Q995099 | kg:/m/08w85l | Bryan | Young | 1800-01-14 | M | 21066 | Rust | ||||||||||||||||
Y000032 | Clarence Young | Y000032 | 411965 | 10437 | Clarence Clifton Young | Q1095387 | kg:/m/02730wp | Clarence | Young | 1922-11-07 | M | 21069 | Clifton | ||||||||||||||||
Y000034 | Ebenezer Young | Y000034 | 411966 | 10438 | Ebenezer Young | Q1278684 | kg:/m/02pyycw | Ebenezer | Young | 1783-12-25 | M | 21072 | |||||||||||||||||
Y000035 | Edward Young | Y000035 | 411967 | 14065 | Edward Lunn Young | Q1292910 | kg:/m/02vp040 | Edward | Young | 1920-09-07 | M | 21073 | Lunn | 01257 | |||||||||||||||
Y000036 | George Young | Y000036 | 411968 | 10439 | George M. Young | Q1420295 | kg:/m/02rhgsp | George | Young | 1870-12-11 | M | 21074 | Morley | ||||||||||||||||
Y000037 | Hiram Young | Y000037 | 411969 | 10440 | H. Casey Young | Q1562565 | kg:/m/0dj1dg | Hiram | Young | 1828-12-14 | M | 21075 | Casey | ||||||||||||||||
Y000038 | Horace Young | Y000038 | 411970 | 10441 | H. Olin Young | Q1432680 | kg:/m/02q6560 | Horace | Young | 1850-08-04 | M | 21076 | Olin | ||||||||||||||||
Y000039 | Isaac Young | Y000039 | 411971 | 10442 | Isaac D. Young | Q1673375 | kg:/m/02rmb96 | Isaac | Young | 1849-03-29 | M | 21077 | Daniel | ||||||||||||||||
Y000040 | James Young | Y000040 | 411972 | 10443 | James Young (congressman) | Q1557466 | kg:/m/03c2_vn | James | Young | 1866-07-18 | M | 21078 | |||||||||||||||||
Y000041 | James Young | Y000041 | 411973 | 10444 | James R. Young (Pennsylvania politician) | Q6141770 | kg:/m/0djcfw | James | Young | 1847-03-10 | M | 21080 | Rankin | ||||||||||||||||
Y000042 | John Young | Y000042 | 411974 | 10445 | John Young (governor) | Q444134 | kg:/m/030015 | John | Young | 1802-06-12 | M | 21081 | |||||||||||||||||
Y000043 | John Young | Y000043 | 411975 | 10446 | John Andrew Young | Q1333064 | kg:/m/03wvyl | John | Young | 1916-11-10 | M | 21082 | Andrew | 01258 | |||||||||||||||
Y000044 | John Young | Y000044 | 411976 | 10447 | John Duncan Young | Q178640 | kg:/m/02rhjyh | John | Young | 1823-09-22 | M | 21084 | Duncan | ||||||||||||||||
Y000045 | John Young | Y000045 | 411977 | 10448 | J. Smith Young | Q1676405 | kg:/m/02w433n | John | Young | 1834-11-04 | M | 21085 | Smith | ||||||||||||||||
Y000046 | Lafayette Young | Y000046 | 411978 | 10449 | Lafayette Young | Q1283683 | kg:/m/06q7sg | Lafayette | Young | 1848-05-10 | M | ||||||||||||||||||
Y000047 | Milton Young | Y000047 | 411979 | 10450 | Milton Young | Q436433 | kg:/m/07lfyf | Milton | Young | 1897-12-06 | M | Ruben | 01458 | ||||||||||||||||
Y000048 | Pierce Young | Y000048 | 411980 | 10451 | Pierce M. B. Young | Q2092744 | kg:/m/0dbcbz | Pierce | Young | 1836-11-15 | M | 21088 | Manning Butler | ||||||||||||||||
Y000049 | Richard Young | Y000049 | 411981 | 10452 | Richard Young (New York congressman) | Q808648 | kg:/m/02rldrc | Richard | Young | 1846-08-06 | M | 21089 | |||||||||||||||||
Y000050 | Richard Young | Y000050 | 411982 | 10453 | Richard M. Young | Q443156 | kg:/m/0854j3 | Richard | Young | 1798-02-20 | M | Montgomery | |||||||||||||||||
Y000051 | Robert Young | Y000051 | 411983 | 14465 | Robert A. Young | Q1570026 | kg:/m/09838w | Robert | Young | 1923-11-22 | M | 21091 | Anton | III | 01259 | ||||||||||||||
Y000052 | Samuel Young | Y000052 | 411984 | 14064 | Samuel H. Young | Q7411594 | kg:/m/02rkcw3 | Samuel | Young | 1922-12-26 | M | 21092 | Hollingsworth | 01260 | |||||||||||||||
Y000053 | Stephen Young | Y000053 | 411985 | 10454 | Stephen M. Young | Q957216 | kg:/m/034qvp | Stephen | Young | 1889-05-04 | M | 21094 | Marvin | ||||||||||||||||
Y000054 | Thomas Young | Y000054 | 411986 | 10455 | Thomas L. Young | Q370109 | kg:/m/033w8s | Thomas | Young | 1832-12-14 | M | 21096 | Lowry | ||||||||||||||||
Y000055 | Timothy Young | Y000055 | 411987 | 10456 | Timothy R. Young | Q4360776 | kg:/m/02rkd6g | Timothy | Young | 1811-11-19 | M | 21097 | Roberts | ||||||||||||||||
Y000056 | William Young | Y000056 | 411988 | 10457 | William Albin Young | Q2577806 | kg:/m/03c2_70 | William | Young | 1860-05-17 | M | 21098 | Albin | ||||||||||||||||
Y000057 | William Young | Y000057 | 411989 | 10458 | William Singleton Young | Q782243 | kg:/m/02rj__z | William | Young | 1790-04-10 | M | 21099 | Singleton | ||||||||||||||||
Y000058 | Harold Youngblood | Y000058 | 411990 | 10459 | Harold F. Youngblood | Q1585815 | kg:/m/02q62jn | Harold | Youngblood | 1907-08-07 | M | 21100 | Francis | ||||||||||||||||
Y000059 | Oscar Youngdahl | Y000059 | 411991 | 10460 | Oscar Youngdahl | Q2033020 | kg:/m/0268mfx | Oscar | Youngdahl | 1893-10-13 | M | 21101 | Ferdinand | ||||||||||||||||
Y000060 | Jesse Younger | Y000060 | 411992 | 10461 | J. Arthur Younger | Q525767 | kg:/m/04wgpp | Jesse | Younger | 1893-04-11 | M | 21102 | Arthur |
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);