legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by id_ballotpedia
This data as json, copyable, CSV (advanced)
bio_birthday (date) >30 ✖
- 1758-12-23 2
- 1763-02-09 2
- 1776-03-08 2
- 1789-08-20 2
- 1802-06-12 2
- 1812-02-17 2
- 1814-11-09 2
- 1818-11-27 2
- 1821-09-04 2
- 1826-01-17 2
- 1829-05-29 2
- 1835-04-27 2
- 1836-11-15 2
- 1857-12-22 2
- 1928-07-16 2
- 1941-02-14 2
- 1941-09-06 2
- 1941-10-12 2
- 1943-01-18 2
- 1947-08-24 2
- 1948-05-10 2
- 1951-07-05 2
- 1954-10-24 2
- 1955-04-08 2
- 1955-10-20 2
- 1956-11-14 2
- 1958-06-17 2
- 1959-10-24 2
- 1960-05-10 2
- 1960-12-30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
T000108 | Littleton Tazewell | T000108 | 410690 | 9239 | Littleton Waller Tazewell | Q682902 | kg:/m/03gf7d | Littleton | Tazewell | 1774-12-17 | M | 22766 | Waller | ||||||||||||||||
T000109 | Charles Teague | T000109 | 410691 | 9240 | Charles M. Teague | Q1065410 | kg:/m/02rhdcp | Charles | Teague | 1909-09-18 | M | 22767 | McKevett | 01145 | |||||||||||||||
T000110 | Olin Teague | T000110 | 410692 | 9241 | Olin E. Teague | Q2019871 | kg:/m/0f3t2w | Olin | Teague | 1910-04-06 | M | 22769 | Earl | 01146 | |||||||||||||||
T000111 | Frederick Teese | T000111 | 410693 | 9242 | Frederick Halstead Teese | Q1450330 | kg:/m/02vn_6g | Frederick | Teese | 1823-10-21 | M | 22770 | Halstead | ||||||||||||||||
T000112 | Henry Teigan | T000112 | 410694 | 9243 | Henry Teigan | Q677621 | kg:/m/0fqlr3 | Henry | Teigan | 1881-08-07 | M | 22771 | George | ||||||||||||||||
T000113 | Frank Tejeda | T000113 | 410695 | 39303 | Frank Tejeda | Q737918 | kg:/m/09v83j | Frank | Tejeda | 1945-10-02 | M | 22773 | Mariano | 01147 | |||||||||||||||
T000115 | Thomas Telfair | T000115 | 410697 | 9245 | Thomas Telfair | Q587576 | kg:/m/0g6hcr | Thomas | Telfair | 1780-03-02 | M | 22775 | |||||||||||||||||
T000116 | Henry Teller | T000116 | 410698 | 9246 | Henry M. Teller | Q1575475 | kg:/m/03p_4g | Henry | Teller | 1830-05-23 | M | Moore | |||||||||||||||||
T000117 | Isaac Teller | T000117 | 410699 | 9247 | Isaac Teller | Q2377091 | kg:/m/02rqb0q | Isaac | Teller | 1799-02-07 | M | 22777 | |||||||||||||||||
T000118 | Ludwig Teller | T000118 | 410700 | 9248 | Ludwig Teller | Q6699348 | kg:/m/078wtb | Ludwig | Teller | 1911-06-22 | M | 22778 | |||||||||||||||||
T000119 | Henry Temple | T000119 | 410701 | 9249 | Henry Wilson Temple | Q5730372 | kg:/m/0fkwwm | Henry | Temple | 1864-03-31 | M | 22779 | Wilson | ||||||||||||||||
T000120 | William Temple | T000120 | 410702 | 9250 | William Temple (politician) | Q886868 | kg:/m/07szwm | William | Temple | 1814-02-28 | M | 22780 | |||||||||||||||||
T000121 | Thomas Templeton | T000121 | 410703 | 9251 | Thomas W. Templeton | Q7794791 | kg:/m/0fzbd0 | Thomas | Templeton | 1867-11-08 | M | 22781 | Weir | ||||||||||||||||
T000122 | John Ten Eyck | T000122 | 410705 | 9255 | John C. Ten Eyck | Q1699512 | kg:/m/0csny3 | John | Ten Eyck | 1814-03-12 | M | Conover | |||||||||||||||||
T000123 | John Tener | T000123 | 410707 | 9252 | John K. Tener | Q889250 | kg:/m/03p_jn | John | Tener | 1863-07-25 | M | 22784 | Kinley | ||||||||||||||||
T000124 | Rudolph Tenerowicz | T000124 | 410708 | 9253 | Rudolph G. Tenerowicz | Q132218 | kg:/m/026zk25 | Rudolph | Tenerowicz | 1890-06-14 | M | 22785 | Gabriel | ||||||||||||||||
T000125 | Egbert Ten Eyck | T000125 | 410704 | 9254 | Egbert Ten Eyck | Q5347719 | kg:/m/0ddg8b | Egbert | Ten Eyck | 1779-04-18 | M | 22786 | |||||||||||||||||
T000126 | Peter Ten Eyck | T000126 | 410706 | 9256 | Peter G. Ten Eyck | Q7174141 | kg:/m/026mwcj | Peter | Ten Eyck | 1873-11-07 | M | 22787 | Gansevoort | ||||||||||||||||
T000127 | Samuel Tenney | T000127 | 410709 | 9257 | Samuel Tenney | Q2218893 | kg:/m/0260vqc | Samuel | Tenney | 1748-11-27 | M | 22788 | |||||||||||||||||
T000128 | Herbert Tenzer | T000128 | 410710 | 10775 | Herbert Tenzer | Q866788 | kg:/m/078wrl | Herbert | Tenzer | 1905-11-01 | M | 22789 | |||||||||||||||||
T000129 | George Terrell | T000129 | 410711 | 9258 | George B. Terrell | Q1506918 | kg:/m/03c2_1q | George | Terrell | 1862-12-05 | M | 22790 | Butler | ||||||||||||||||
T000130 | James Terrell | T000130 | 410712 | James C. Terrell | Q1471732 | kg:/m/0279xjk | James | Terrell | 1806-11-07 | M | 22791 | C. | |||||||||||||||||
T000131 | Joseph Terrell | T000131 | 410713 | 9260 | Joseph M. Terrell | Q356786 | kg:/m/0crb38 | Joseph | Terrell | 1861-06-06 | M | Meriwether | |||||||||||||||||
T000132 | William Terrell | T000132 | 410714 | 9261 | William Terrell | Q2580742 | kg:/m/0crb7f | William | Terrell | M | 22793 | ||||||||||||||||||
T000133 | David Terry | T000133 | 410715 | 9262 | David D. Terry | Q1174229 | kg:/m/02rhf0_ | David | Terry | 1881-01-31 | M | 22794 | Dickson | ||||||||||||||||
T000134 | John Terry | T000134 | 410716 | 13044 | John H. Terry | Q6237114 | kg:/m/0ksnd6 | John | Terry | 1924-11-14 | M | 22795 | Hart | ||||||||||||||||
T000135 | Nathaniel Terry | T000135 | 410717 | 9263 | Nathaniel Terry | Q1264526 | kg:/m/0fltcs | Nathaniel | Terry | 1768-01-30 | M | 22796 | |||||||||||||||||
T000136 | William Terry | T000136 | 410718 | 9264 | William Terry (congressman) | Q3205 | kg:/m/02pmnqn | William | Terry | 1824-08-14 | M | 22797 | |||||||||||||||||
T000137 | William Terry | T000137 | 410719 | 9265 | William L. Terry | Q788199 | kg:/m/02rj_rc | William | Terry | 1850-09-27 | M | 22799 | Leake | ||||||||||||||||
T000138 | John Test | T000138 | 410720 | 9266 | John Test | Q749837 | kg:/m/02rkgyf | John | Test | 1771-11-12 | M | 22800 | |||||||||||||||||
T000139 | Donald Tewes | T000139 | 410721 | 9267 | Donald Edgar Tewes | Q182484 | kg:/m/0gz997 | Donald | Tewes | 1916-08-04 | M | 22802 | Edgar | ||||||||||||||||
T000140 | Thomas Thacher | T000140 | 410722 | 9269 | Thomas Chandler Thacher | Q2422949 | kg:/m/02rjzp_ | Thomas | Thacher | 1858-07-20 | M | 22803 | Chandler | ||||||||||||||||
T000141 | George Thatcher | T000141 | 410723 | 9268 | George Thatcher | Q961579 | kg:/m/06dfhc | George | Thatcher | 1754-04-12 | M | 22804 | |||||||||||||||||
T000142 | Maurice Thatcher | T000142 | 410724 | 9270 | Maurice Thatcher | Q885888 | kg:/m/01wr1j | Maurice | Thatcher | 1870-08-15 | M | 22805 | Hudson | ||||||||||||||||
T000143 | Samuel Thatcher | T000143 | 410725 | 9271 | Samuel Thatcher | Q1558755 | kg:/m/0kt6ym | Samuel | Thatcher | 1776-07-01 | M | 22806 | |||||||||||||||||
T000144 | Andrew Thayer | T000144 | 410726 | 9272 | Andrew J. Thayer | Q505322 | kg:/m/027lqct | Andrew | Thayer | 1818-11-27 | M | 22807 | Jackson | ||||||||||||||||
T000145 | Eli Thayer | T000145 | 410727 | 9273 | Eli Thayer | Q1328873 | kg:/m/08svk0 | Eli | Thayer | 1819-06-11 | M | 22808 | |||||||||||||||||
T000146 | Harry Thayer | T000146 | 410728 | 9274 | Harry Irving Thayer | Q1586579 | kg:/m/0ksm5r | Harry | Thayer | 1869-09-10 | M | 22809 | Irving | ||||||||||||||||
T000147 | John Thayer | T000147 | 410729 | 9275 | John A. Thayer | Q1699080 | kg:/m/0ckcf1 | John | Thayer | 1857-12-22 | M | 22810 | Alden | ||||||||||||||||
T000148 | John Thayer | T000148 | 410730 | 9276 | John Milton Thayer | Q365679 | kg:/m/08jcc2 | John | Thayer | 1820-01-24 | M | Milton | |||||||||||||||||
T000149 | John Thayer | T000149 | 410731 | 9277 | John R. Thayer | Q1638624 | kg:/m/0ckcd0 | John | Thayer | 1845-03-09 | M | 22812 | Randolph | ||||||||||||||||
T000150 | Martin Thayer | T000150 | 410732 | 9278 | Martin Russell Thayer | Q6776496 | kg:/m/0kt97f | Martin | Thayer | 1819-01-27 | M | 22813 | Russell | ||||||||||||||||
T000151 | Thomas Theaker | T000151 | 410733 | 9279 | Thomas Clarke Theaker | Q7788446 | kg:/m/0278bmf | Thomas | Theaker | 1812-02-01 | M | 22814 | Clarke | ||||||||||||||||
T000152 | Bannon Thibodeaux | T000152 | 410734 | 9280 | Bannon Goforth Thibodeaux | Q806900 | kg:/m/0ddqtr | Bannon | Thibodeaux | 1812-12-22 | M | 22815 | Goforth | ||||||||||||||||
T000153 | Lewis Thill | T000153 | 410735 | 9281 | Lewis D. Thill | Q1434645 | kg:/m/02vrqtg | Lewis | Thill | 1903-10-18 | M | 22816 | Dominic | ||||||||||||||||
T000154 | Napoleon Thistlewood | T000154 | 410736 | 9282 | Napoleon B. Thistlewood | Q6965014 | kg:/m/02rkc4s | Napoleon | Thistlewood | 1837-03-30 | M | 22817 | Bonaparte | ||||||||||||||||
T000155 | William Thom | T000155 | 410737 | 9283 | William R. Thom | Q8017296 | kg:/m/02rj_yk | William | Thom | 1885-07-07 | M | 22818 | Richard | ||||||||||||||||
T000156 | Albert Thomas | T000156 | 410738 | 9284 | Albert Richard Thomas | Q2638644 | kg:/m/02w8dnl | Albert | Thomas | 1898-04-12 | M | 22820 | |||||||||||||||||
T000157 | Benjamin Thomas | T000157 | 410739 | 9285 | Benjamin Thomas (politician) | Q817713 | kg:/m/02q4p4b | Benjamin | Thomas | 1813-02-12 | M | 22821 | Franklin | ||||||||||||||||
T000158 | Charles Thomas | T000158 | 410740 | 9286 | Charles R. Thomas (1827–1891) | Q1065857 | kg:/m/0ksm29 | Charles | Thomas | 1827-02-07 | M | 22822 | Randolph | ||||||||||||||||
T000159 | Charles Thomas | T000159 | 410741 | 9287 | Charles R. Thomas (1861–1931) | Q1065860 | kg:/m/0kt7ff | Charles | Thomas | 1861-08-21 | M | 22823 | Randolph | ||||||||||||||||
T000160 | Charles Thomas | T000160 | 410742 | 9288 | Charles S. Thomas | Q888144 | kg:/m/0bf2wj | Charles | Thomas | 1849-12-06 | M | Spalding | |||||||||||||||||
T000161 | Christopher Thomas | T000161 | 410743 | 9289 | Christopher Thomas | Q1087070 | kg:/m/02pnxyc | Christopher | Thomas | 1818-03-24 | M | 22825 | Yancy | ||||||||||||||||
T000162 | Craig Thomas | T000162 | 300097 | 15633 | Craig L. Thomas | Q1138576 | kg:/m/021phv | Craig | Thomas | 1933-02-17 | M | 22827 | 01149 | S246 | N00006246 | [ "S4WY00055", "H8WY00106" ] |
|||||||||||||
T000163 | David Thomas | T000163 | 410744 | 9290 | David Thomas (New York politician) | Q1107804 | kg:/m/0260xlw | David | Thomas | 1762-06-11 | M | 22828 | |||||||||||||||||
T000164 | Elbert Thomas | T000164 | 410745 | 9291 | Elbert D. Thomas | Q5353701 | kg:/m/03jl76 | Elbert | Thomas | 1883-06-17 | M | Duncan | |||||||||||||||||
T000166 | Francis Thomas | T000166 | 410747 | 9292 | Francis Thomas | Q629285 | kg:/m/08rrnw | Francis | Thomas | 1799-02-03 | M | 22831 | |||||||||||||||||
T000167 | George Thomas | T000167 | 410748 | 9293 | George M. Thomas (American politician) | Q1507822 | kg:/m/02rhgrn | George | Thomas | 1828-11-23 | M | 22832 | Morgan | ||||||||||||||||
T000168 | Henry Thomas | T000168 | 410749 | 9294 | Henry F. Thomas | Q1606727 | kg:/m/028bnff | Henry | Thomas | 1843-12-17 | M | 22834 | Franklin | ||||||||||||||||
T000169 | Isaac Thomas | T000169 | 410750 | 9295 | Isaac Thomas | Q1593249 | kg:/m/0cgl8p | Isaac | Thomas | 1784-11-04 | M | 22835 | |||||||||||||||||
T000170 | James Thomas | T000170 | 410751 | 9296 | James Houston Thomas | Q1680581 | kg:/m/0d998k | James | Thomas | 1808-09-22 | M | 22836 | Houston | ||||||||||||||||
T000171 | Jesse Thomas | T000171 | 410752 | 9297 | Jesse B. Thomas | Q443081 | kg:/m/085302 | Jesse | Thomas | M | 22838 | Burgess | |||||||||||||||||
T000172 | John Thomas | T000172 | 410753 | 9298 | John W. Thomas | Q1702077 | kg:/m/0bg3__ | John | Thomas | 1874-01-04 | M | ||||||||||||||||||
T000173 | John Thomas | T000173 | 410754 | 9299 | John Chew Thomas | Q577114 | kg:/m/0glxmt | John | Thomas | 1764-10-15 | M | 22840 | Chew | ||||||||||||||||
T000174 | John Thomas | T000174 | 410755 | 9300 | John Lewis Thomas Jr. | Q724953 | kg:/m/0ghh6g | John | Thomas | 1835-05-20 | M | 22841 | Lewis | Jr. | |||||||||||||||
T000175 | John Thomas | T000175 | 410756 | 9301 | J. Parnell Thomas | Q1676374 | kg:/m/06tp75 | John | Thomas | 1895-01-16 | M | 22843 | Parnell | ||||||||||||||||
T000176 | John Thomas | T000176 | 410757 | 9302 | John R. Thomas | Q6254023 | kg:/m/02rkbsd | John | Thomas | 1846-10-11 | M | 22844 | Robert | ||||||||||||||||
T000177 | John Thomas | T000177 | 410758 | 9303 | Elmer Thomas | Q1332996 | kg:/m/07f7r8 | John | Thomas | 1876-09-08 | M | 22846 | William Elmer | ||||||||||||||||
T000178 | Lera Thomas | T000178 | 410759 | 10792 | Lera Millard Thomas | Q279351 | kg:/m/02vktpl | Lera | Thomas | 1900-08-03 | F | 22848 | Millard | ||||||||||||||||
T000179 | Lot Thomas | T000179 | 410760 | 9304 | Lot Thomas | Q1870735 | kg:/m/02rk7y_ | Lot | Thomas | 1843-10-17 | M | 22850 | |||||||||||||||||
T000180 | Ormsby Thomas | T000180 | 410761 | 9305 | Ormsby B. Thomas | Q224631 | kg:/m/02rvb9q | Ormsby | Thomas | 1832-08-21 | M | 22852 | Brunson | ||||||||||||||||
T000181 | Philemon Thomas | T000181 | 410762 | 9306 | Philemon Thomas | Q1415721 | kg:/m/0ddqnx | Philemon | Thomas | 1763-02-09 | M | 22853 | |||||||||||||||||
T000182 | Phillip Thomas | T000182 | 410763 | 9307 | Philip Francis Thomas | Q529914 | kg:/m/03hbt4 | Phillip | Thomas | 1810-09-12 | M | 22855 | Francis | ||||||||||||||||
T000183 | Richard Thomas | T000183 | 410764 | 9308 | Richard Thomas (Pennsylvania politician) | Q7329439 | kg:/m/0265_h3 | Richard | Thomas | 1744-12-30 | M | 22856 | |||||||||||||||||
T000184 | Robert Thomas | T000184 | 410765 | 15069 | Lindsay Thomas (politician) | Q1497921 | kg:/m/026gs8q | Robert | Thomas | 1943-11-20 | M | 22857 | Lindsay | 01150 | |||||||||||||||
T000185 | Robert Thomas | T000185 | 410766 | 9309 | Robert Y. Thomas Jr. | Q2159247 | kg:/m/02rjyx6 | Robert | Thomas | 1855-07-13 | M | 22858 | Young | Jr. | |||||||||||||||
T000186 | William Thomas | T000186 | 410767 | 9310 | W. Aubrey Thomas | Q2536632 | kg:/m/02rm3bs | William | Thomas | 1866-06-07 | M | 22860 | Aubrey | ||||||||||||||||
T000187 | William Thomas | T000187 | 410768 | 9311 | William D. Thomas | Q8007521 | kg:/m/02r7vw5 | William | Thomas | 1880-03-22 | M | 22861 | David | ||||||||||||||||
T000188 | William Thomas | T000188 | 400401 | 14669 | Bill Thomas | Q132302 | kg:/m/024tf3 | William | Thomas | 1941-12-06 | M | 22863 | M. | Bill | 01148 | N00007256 | |||||||||||||
T000189 | Robert Thomason | T000189 | 410769 | 9312 | R. Ewing Thomason | Q1314053 | kg:/m/0fhxdl | Robert | Thomason | 1879-05-30 | M | 22865 | Ewing | ||||||||||||||||
T000190 | William Thomasson | T000190 | 410770 | 9313 | William Thomasson | Q2580772 | kg:/m/02rk01p | William | Thomasson | 1797-10-08 | M | 22866 | Poindexter | ||||||||||||||||
T000191 | Albert Thompson | T000191 | 410771 | 9314 | Albert C. Thompson | Q4709866 | kg:/m/02rlzmg | Albert | Thompson | 1842-01-23 | M | 22867 | Clifton | ||||||||||||||||
T000192 | Benjamin Thompson | T000192 | 410772 | 9315 | Benjamin Thompson (politician) | Q817714 | kg:/m/02rhcpb | Benjamin | Thompson | 1798-08-05 | M | 22868 | |||||||||||||||||
T000194 | Charles Thompson | T000194 | 410773 | 9316 | Charles J. Thompson | Q5079390 | kg:/m/02rl_60 | Charles | Thompson | 1862-01-24 | M | 22872 | James | ||||||||||||||||
T000195 | Charles Thompson | T000195 | 410774 | 9317 | Charles Perkins Thompson | Q1065752 | kg:/m/02r313q | Charles | Thompson | 1827-07-30 | M | 22873 | Perkins | ||||||||||||||||
T000196 | Charles Thompson | T000196 | 410775 | 9318 | Charles Winston Thompson | Q1066478 | kg:/m/061pbh | Charles | Thompson | 1860-12-30 | M | 22874 | Winston | ||||||||||||||||
T000197 | Chester Thompson | T000197 | 410776 | 9319 | Chester C. Thompson | Q5093485 | kg:/m/0fz274 | Chester | Thompson | 1893-09-19 | M | 22875 | Charles | ||||||||||||||||
T000198 | Clark Thompson | T000198 | 410777 | 9320 | Clark W. Thompson (Texas politician) | Q1095752 | kg:/m/0gy1m0 | Clark | Thompson | 1896-08-06 | M | 22876 | Wallace | ||||||||||||||||
T000199 | Fountain Thompson | T000199 | 410778 | 9321 | Fountain L. Thompson | Q1439904 | kg:/m/0cv_rk | Fountain | Thompson | 1854-11-18 | M | Land | |||||||||||||||||
T000200 | Frank Thompson | T000200 | 410779 | 9322 | Frank Thompson | Q913444 | kg:/m/08gl3w | Frank | Thompson | 1918-07-26 | M | 22878 | Jr. | 01152 | |||||||||||||||
T000201 | George Thompson | T000201 | 410780 | 9323 | George W. Thompson | Q129756 | kg:/m/02ph_9t | George | Thompson | 1806-05-14 | M | 22879 | Western | ||||||||||||||||
T000202 | Hedge Thompson | T000202 | 410781 | 9324 | Hedge Thompson | Q1593248 | kg:/m/02z3r_x | Hedge | Thompson | 1780-01-28 | M | 22880 | |||||||||||||||||
T000203 | Jacob Thompson | T000203 | 410782 | 9325 | Jacob Thompson | Q928119 | kg:/m/04b_2s | Jacob | Thompson | 1810-05-15 | M | 22881 | |||||||||||||||||
T000204 | James Thompson | T000204 | 410783 | 9326 | James Thompson (jurist) | Q1343059 | kg:/m/03nvnf | James | Thompson | 1806-10-01 | M | 22882 | |||||||||||||||||
T000205 | Joel Thompson | T000205 | 410784 | 9327 | Joel Thompson (politician) | Q2947709 | kg:/m/026_tpd | Joel | Thompson | 1760-10-03 | M | 22883 | |||||||||||||||||
T000206 | John Thompson | T000206 | 410785 | 9328 | John Thompson (1749–1823) | Q868823 | kg:/m/0266hsj | John | Thompson | 1749-03-20 | M | 22884 | |||||||||||||||||
T000207 | John Thompson | T000207 | 410786 | 9329 | John Thompson (1809–90) | Q868832 | kg:/m/02rqbv4 | John | Thompson | 1809-07-04 | M | 22885 | |||||||||||||||||
T000208 | John Thompson | T000208 | 410787 | 9330 | John Burton Thompson | Q1699467 | kg:/m/0b_nv2 | John | Thompson | 1810-12-14 | M | 22887 | Burton | ||||||||||||||||
T000209 | John Thompson | T000209 | 410788 | 9331 | John McCandless Thompson | Q6247438 | kg:/m/0kt0mm | John | Thompson | 1829-01-04 | M | 22888 | McCandless | ||||||||||||||||
T000210 | Joseph Thompson | T000210 | 410789 | 9332 | Joseph Bryan Thompson | Q615121 | kg:/m/02rr708 | Joseph | Thompson | 1871-04-29 | M | 22890 | Bryan |
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);