legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by name_middle
This data as json, copyable, CSV (advanced)
id_fec (array) >30 ✖
- H0AL01055 1
- H0AL02087 1
- H0AL05049 1
- H0AL07086 1
- H0AR01083 1
- H0AR02107 1
- H0AR03055 1
- H0AR04038 1
- H0AS00018 1
- H0AZ01184 1
- H0AZ01259 1
- H0AZ03362 1
- H0CA08135 1
- H0CA10149 1
- H0CA11022 1
- H0CA14042 1
- H0CA15148 1
- H0CA25105 1
- H0CA27085 1
- H0CA31087 1
- H0CA32101 1
- H0CA48024 1
- H0CA48198 1
- H0CA49055 1
- H0CO03165 1
- H0CO04122 1
- H0CT03072 1
- H0DC00058 1
- H0DE01017 1
- H0FL02086 1
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
E000248 | Joshua Evans | E000248 | 403931 | 3014 | Joshua Evans Jr. | Q6289786 | kg:/m/026xqdm | Joshua | Evans | 1777-01-20 | M | 12906 | Jr. | ||||||||||||||||
E000252 | Lynden Evans | E000252 | 403934 | 3017 | Lynden Evans | Q6708639 | kg:/m/02rkc0n | Lynden | Evans | 1858-06-28 | M | 12910 | |||||||||||||||||
E000255 | Nathan Evans | E000255 | 403937 | 3019 | Nathan Evans (Ohio politician) | Q6969044 | kg:/m/02rm2md | Nathan | Evans | 1804-06-24 | M | 12914 | |||||||||||||||||
E000257 | Thomas Evans | E000257 | 412146 | 3021 | Thomas Evans (Virginia politician) | Q2423731 | kg:/m/07wkyn | Thomas | Evans | M | 12917 | ||||||||||||||||||
E000260 | Walter Evans | E000260 | 403941 | 3022 | Walter Evans (American politician) | Q2544154 | kg:/m/02rl43g | Walter | Evans | 1842-09-18 | M | 12921 | |||||||||||||||||
E000264 | Edward Everett | E000264 | 403944 | 3026 | Edward Everett | Q434905 | kg:/m/01s7xf | Edward | Everett | 1794-04-11 | M | 12926 | |||||||||||||||||
E000265 | Horace Everett | E000265 | 403945 | 3027 | Horace Everett | Q1627855 | kg:/m/026h15f | Horace | Everett | 1779-07-17 | M | 12927 | |||||||||||||||||
E000268 | Terry Everett | E000268 | 400127 | 29300 | Terry Everett | Q965794 | kg:/m/024n_f | Terry | Everett | 1937-02-15 | M | 12931 | 00364 | 26711 | N00003083 | [ "H2AL02067" ] |
|||||||||||||
E000269 | William Everett | E000269 | 403948 | 3030 | William Everett | Q1419918 | kg:/m/026hqwb | William | Everett | 1839-10-10 | M | 12933 | |||||||||||||||||
E000271 | William Everhart | E000271 | 403950 | 3032 | William Everhart | Q8008710 | kg:/m/0kss02 | William | Everhart | 1785-05-17 | M | 12935 | |||||||||||||||||
E000275 | Andrew Ewing | E000275 | 403954 | 3036 | Andrew Ewing | Q504593 | kg:/m/0d9tvp | Andrew | Ewing | 1813-06-17 | M | 12941 | |||||||||||||||||
E000277 | John Ewing | E000277 | 403956 | 3038 | John Ewing (Indiana politician) | Q1699997 | kg:/m/02w533c | John | Ewing | 1789-05-19 | M | 12943 | |||||||||||||||||
E000280 | Thomas Ewing | E000280 | 403960 | 3042 | Thomas Ewing Jr. | Q3525101 | kg:/m/0d3f7f | Thomas | Ewing | 1829-08-07 | M | 12946 | |||||||||||||||||
E000281 | Thomas Ewing | E000281 | 403959 | 3041 | Thomas Ewing | Q1335443 | kg:/m/0351xv | Thomas | Ewing | 1789-12-28 | M | ||||||||||||||||||
E000287 | Rahm Emanuel | E000287 | 400120 | 20323 | Rahm Emanuel | Q298443 | kg:/m/0256f7 | Rahm | Emanuel | 1959-11-29 | M | 12955 | 01725 | 26079 | 33530 | N00024813 | [ "H2IL05092" ] |
||||||||||||
E000289 | Brad Ellsworth | E000289 | 412206 | 20718 | Brad Ellsworth | Q528991 | kg:/m/09fhjx | Brad | Ellsworth | 1958-09-11 | M | 12959 | 01851 | 1021550 | 57497 | N00027575 | [ "H6IN08210" ] |
||||||||||||
E000294 | Tom Emmer | E000294 | 412639 | 21531 | Tom Emmer | Q7815723 | kg:/m/06w2w3l | Tom | Emmer | 1961-03-03 | M | Tom Emmer | 02253 | 75567 | 38894 | Tom Emmer | N00035440 | [ "H4MN06087" ] |
2095 | ||||||||||
E000295 | Joni Ernst | E000295 | 412667 | 41502 | Joni Ernst | Q13475242 | kg:/m/0gg4wkg | Joni | Ernst | 1970-07-01 | F | 15032414877 | Joni Ernst | 02283 | 75342 | 128583 | S376 | Joni Ernst | N00035483 | [ "S4IA00129" ] |
2123 | [ { "title": "Senate Republican Conference Vice Chair", "chamber": "senate", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "Senate Republican Conference Vice Chair", "chamber": "senate", "start": "2021-01-03" } ] |
|||||||
E000296 | Dwight Evans | E000296 | 412677 | 21566 | Dwight Evans (politician) | Q5318148 | kg:/m/03y8h6m | Dwight | Evans | 1954-05-16 | M | Dwight Evans | 56729 | 9128 | Dwight Evans | N00038450 | [ "H6PA02171" ] |
2167 | |||||||||||
E000297 | Adriano Espaillat | E000297 | 412718 | 21715 | Adriano Espaillat | Q4685569 | kg:/m/06nfs2 | Adriano | Espaillat | 1954-09-27 | M | Adriano Espaillat | 68413 | 14379 | Adriano Espaillat | N00034549 | [ "H2NY13096" ] |
2230 | |||||||||||
E000298 | Ron Estes | E000298 | 412735 | 21750 | Ron Estes | Q7363747 | kg:/m/0gfgsrm | Ron | Estes | 1956-07-19 | M | 15032448694 | Ron Estes (U.S. House representative) | 107963 | 125031 | Ron Estes | N00040712 | [ "H8KS04112" ] |
2246 | ||||||||||
E000299 | Veronica Escobar | E000299 | 412825 | 21917 | Veronica Escobar | Q52274267 | kg:/g/11ghdw9g9p | Veronica | Escobar | 1969-09-15 | F | Veronica Escobar | 99345 | Veronica Escobar | N00041702 | [ "H8TX16109" ] |
|||||||||||||
F000006 | John Fairfield | F000006 | 403969 | 3049 | John Fairfield | Q370652 | kg:/m/0bnxdy | John | Fairfield | 1797-01-30 | M | 12972 | |||||||||||||||||
F000015 | Leonard Farbstein | F000015 | 403977 | 3056 | Leonard Farbstein | Q6525278 | kg:/m/078y1c | Leonard | Farbstein | 1902-10-12 | M | 12983 | |||||||||||||||||
F000022 | Dudley Farlin | F000022 | 403984 | 3063 | Dudley Farlin | Q2514208 | kg:/m/02rknv4 | Dudley | Farlin | 1777-09-02 | M | 12991 | |||||||||||||||||
F000030 | Sam Farr | F000030 | 400129 | 29313 | Sam Farr | Q675348 | kg:/m/024t9w | Sam | Farr | 1941-07-04 | M | 13001 | 00368 | 30645 | 26745 | Sam Farr | N00007312 | [ "H4CA17021" ] |
240 | ||||||||||
F000032 | Patrick Farrelly | F000032 | 403993 | 3070 | Patrick Farrelly | Q7146481 | kg:/m/026fcn9 | Patrick | Farrelly | M | 13003 | ||||||||||||||||||
F000033 | James Farrington | F000033 | 403994 | 3071 | James Farrington | Q1680373 | kg:/m/02pkl3_ | James | Farrington | 1791-10-01 | M | 13004 | |||||||||||||||||
F000036 | Samuel Farrow | F000036 | 403997 | 3074 | Samuel Farrow | Q2218231 | kg:/m/02ry1xj | Samuel | Farrow | M | 13008 | ||||||||||||||||||
F000043 | Chaka Fattah | F000043 | 400130 | 29559 | Chaka Fattah | Q1059265 | kg:/m/03dsph | Chaka | Fattah | 1956-11-21 | M | 13018 | Chaka Fattah | 00371 | 36763 | 21850 | Chaka Fattah | N00001746 | [ "H2PA02055" ] |
241 | |||||||||
F000052 | John Fay | F000052 | 404012 | 3086 | John Fay (politician) | Q2654905 | kg:/m/02rks77 | John | Fay | 1773-02-10 | M | 13030 | |||||||||||||||||
F000054 | Paul Fearing | F000054 | 404014 | Paul Fearing | Q1278451 | kg:/m/0czh91 | Paul | Fearing | 1762-02-28 | M | 13033 | ||||||||||||||||||
F000062 | Dianne Feinstein | F000062 | 300043 | 49300 | Dianne Feinstein | Q230733 | kg:/m/01gqws | Dianne | Feinstein | 1933-06-22 | F | 13044 | Dianne Feinstein | 01332 | 13061 | 53273 | S221 | Dianne Feinstein | N00007364 | [ "S0CA00199" ] |
567 | ||||||||
F000063 | Alpheus Felch | F000063 | 404021 | 3093 | Alpheus Felch | Q373179 | kg:/m/02w3th | Alpheus | Felch | 1804-09-28 | M | ||||||||||||||||||
F000066 | Frank Fellows | F000066 | 404024 | 3096 | Frank Fellows (politician) | Q1443235 | kg:/m/02rtmyg | Frank | Fellows | 1889-11-07 | M | 13048 | |||||||||||||||||
F000074 | James Fenner | F000074 | 404032 | 3104 | James Fenner | Q880519 | kg:/m/0bjmgh | James | Fenner | 1771-01-22 | M | ||||||||||||||||||
F000080 | Fenner Ferguson | F000080 | 404038 | Fenner Ferguson | Q1404772 | kg:/m/02z38p4 | Fenner | Ferguson | 1814-04-25 | M | 13068 | ||||||||||||||||||
F000087 | Antonio Fernós-Isern | F000087 | 404045 | Antonio Fernós-Isern | Q1674186 | kg:/m/0408jr | Antonio | Fernós-Isern | 1895-05-10 | M | 13079 | ||||||||||||||||||
F000091 | Scott Ferris | F000091 | 404048 | 3119 | Scott Ferris | Q1447788 | kg:/m/02rr6rb | Scott | Ferris | 1877-11-03 | M | 13085 | |||||||||||||||||
F000093 | Orange Ferriss | F000093 | 404050 | 3121 | Orange Ferriss | Q3461183 | kg:/m/02rkv4n | Orange | Ferriss | 1814-11-26 | M | 13088 | |||||||||||||||||
F000100 | William Few | F000100 | 404057 | 3128 | William Few | Q664099 | kg:/m/02pz57 | William | Few | 1748-06-08 | M | 13100 | |||||||||||||||||
F000102 | Bobbi Fiedler | F000102 | 404059 | 14821 | Bobbi Fiedler | Q512163 | kg:/m/08v5_h | Bobbi | Fiedler | 1937-04-22 | F | 13103 | 00378 | ||||||||||||||||
F000107 | Scott Field | F000107 | 404064 | 3134 | Scott Field (politician) | Q1656798 | kg:/m/03hlgrx | Scott | Field | 1847-01-26 | M | 13108 | |||||||||||||||||
F000110 | Cleo Fields | F000110 | 404067 | 29354 | Cleo Fields | Q1100451 | kg:/m/09930w | Cleo | Fields | 1962-11-22 | M | 13112 | 00379 | ||||||||||||||||
F000115 | Millard Fillmore | F000115 | 404072 | 3140 | Millard Fillmore | Q12306 | kg:/m/04_13 | Millard | Fillmore | 1800-01-07 | M | 13119 | |||||||||||||||||
F000116 | Bob Filner | F000116 | 400133 | 29325 | Bob Filner | Q388356 | kg:/m/024xqt | Bob | Filner | 1942-09-04 | M | 13121 | 00381 | 26133 | 26774 | Bob Filner | N00007033 | [ "H2CA50034" ] |
|||||||||||
F000117 | Isaac Finch | F000117 | 404073 | 3141 | Isaac Finch | Q4260285 | kg:/m/02rkqxd | Isaac | Finch | 1783-10-13 | M | 13122 | |||||||||||||||||
F000119 | James Findlay | F000119 | 404075 | 3143 | James Findlay (Cincinnati mayor) | Q1680382 | kg:/m/0fk1by | James | Findlay | 1770-10-12 | M | 13123 | |||||||||||||||||
F000120 | John Findlay | F000120 | 404076 | 3144 | John Findlay (U.S. politician) | Q6233139 | kg:/m/027gw9x | John | Findlay | 1766-03-31 | M | 13124 | |||||||||||||||||
F000122 | William Findlay | F000122 | 404078 | 3146 | William Findlay (governor) | Q731215 | kg:/m/0293dd | William | Findlay | 1768-06-20 | M | ||||||||||||||||||
F000123 | Paul Findley | F000123 | 404079 | 10517 | Paul Findley | Q1780222 | kg:/m/08n5lc | Paul | Findley | 1921-06-23 | M | 13128 | 00382 | ||||||||||||||||
F000124 | William Findley | F000124 | 412125 | 3147 | William Findley | Q8009047 | kg:/m/094j87 | William | Findley | M | 13129 | ||||||||||||||||||
F000125 | John Fine | F000125 | 404080 | 3148 | John Fine (politician) | Q2688681 | kg:/m/02rldn8 | John | Fine | 1794-08-26 | M | 13130 | |||||||||||||||||
F000130 | Charles Finley | F000130 | 404085 | 3152 | Charles Finley (politician) | Q1064356 | kg:/m/02qlh1k | Charles | Finley | 1865-03-26 | M | 13135 | |||||||||||||||||
F000139 | Hamilton Fish | F000139 | 404095 | 3161 | Hamilton Fish II | Q1228083 | kg:/m/09gwtl | Hamilton | Fish | 1849-04-17 | M | 13146 | |||||||||||||||||
F000140 | Hamilton Fish | F000140 | 404094 | 3160 | Hamilton Fish | Q685992 | kg:/m/021yzd | Hamilton | Fish | 1808-08-03 | M | 13148 | |||||||||||||||||
F000141 | Hamilton Fish | F000141 | 404097 | 12013 | Hamilton Fish IV | Q5644938 | kg:/m/078y88 | Hamilton | Fish | 1926-06-03 | M | 13149 | Jr. | 00384 | |||||||||||||||
F000142 | Hamilton Fish | F000142 | 404096 | 3162 | Hamilton Fish III | Q1573501 | kg:/m/01bq5d | Hamilton | Fish | 1888-12-07 | M | 13150 | |||||||||||||||||
F000144 | Charles Fisher | F000144 | 404099 | 3164 | Charles Fisher (congressman) | Q1064360 | kg:/m/03c2zfh | Charles | Fisher | 1789-10-20 | M | 13152 | |||||||||||||||||
F000145 | David Fisher | F000145 | 404100 | 3165 | David Fisher (politician) | Q1174434 | kg:/m/02rl_f8 | David | Fisher | 1794-12-03 | M | 13153 | |||||||||||||||||
F000146 | George Fisher | F000146 | 404101 | 3166 | George Fisher (New York politician) | Q5539288 | kg:/m/03c2_tz | George | Fisher | 1788-03-17 | M | 13154 | |||||||||||||||||
F000150 | John Fisher | F000150 | 404105 | 3170 | John Fisher (North American politician) | Q6233234 | kg:/m/070v5j | John | Fisher | 1806-03-13 | M | 13158 | |||||||||||||||||
F000154 | James Fisk | F000154 | 404109 | 3173 | James Fisk (politician) | Q1336285 | kg:/m/0cvw_t | James | Fisk | 1763-10-04 | M | 13163 | |||||||||||||||||
F000155 | Jonathan Fisk | F000155 | 404110 | 3174 | Jonathan Fisk | Q912318 | kg:/m/026p6x0 | Jonathan | Fisk | 1778-09-26 | M | 13164 | |||||||||||||||||
F000156 | Asa Fitch | F000156 | 404111 | 3175 | Asa Fitch (politician) | Q868276 | kg:/m/07p_ty | Asa | Fitch | 1765-11-10 | M | 13165 | |||||||||||||||||
F000159 | Thomas Fitch | F000159 | 404114 | 3178 | Thomas Fitch (politician) | Q2423887 | kg:/m/0272zwp | Thomas | Fitch | 1838-01-27 | M | 13170 | |||||||||||||||||
F000167 | Thomas Fitzgerald | F000167 | 404122 | 3185 | Thomas Fitzgerald (American politician) | Q1587977 | kg:/m/02wqbg | Thomas | Fitzgerald | 1796-04-10 | M | ||||||||||||||||||
F000168 | William Fitzgerald | F000168 | 404123 | 3186 | William Fitzgerald (Tennessee politician) | Q2578824 | kg:/m/0cgll0 | William | Fitzgerald | 1799-08-06 | M | 13183 | |||||||||||||||||
F000171 | John Fitzgibbons | F000171 | 404126 | 3189 | John Fitzgibbons | Q6233335 | kg:/m/026hc9_ | John | Fitzgibbons | 1868-07-10 | M | 13186 | |||||||||||||||||
F000172 | Louis Fitzhenry | F000172 | 404127 | 3190 | Louis FitzHenry | Q6687174 | kg:/m/05p0rd6 | Louis | Fitzhenry | 1870-06-13 | M | 13187 | |||||||||||||||||
F000174 | Benjamin Fitzpatrick | F000174 | 404129 | 3192 | Benjamin Fitzpatrick | Q817483 | kg:/m/03f3xz | Benjamin | Fitzpatrick | 1802-06-30 | M | ||||||||||||||||||
F000178 | Thomas Fitzsimons | F000178 | 404133 | 3196 | Thomas Fitzsimons | Q671958 | kg:/m/021h9p | Thomas | Fitzsimons | M | 13194 | ||||||||||||||||||
F000188 | Alvan Flanders | F000188 | 404143 | Alvan Flanders | Q448252 | kg:/m/02rgv4w | Alvan | Flanders | 1825-08-02 | M | 13207 | ||||||||||||||||||
F000201 | Isaac Fletcher | F000201 | 404156 | 3217 | Isaac Fletcher | Q1673387 | kg:/m/026knfq | Isaac | Fletcher | 1784-11-22 | M | 13223 | |||||||||||||||||
F000202 | Loren Fletcher | F000202 | 404157 | 3218 | Loren Fletcher | Q1765596 | kg:/m/0flbd3 | Loren | Fletcher | 1833-04-10 | M | 13225 | |||||||||||||||||
F000203 | Richard Fletcher | F000203 | 404158 | 3219 | Richard Fletcher (American politician) | Q679414 | kg:/m/02pnknx | Richard | Fletcher | 1788-01-08 | M | 13226 | |||||||||||||||||
F000204 | Thomas Fletcher | F000204 | 404159 | 3220 | Thomas Fletcher (American politician) | Q1748929 | kg:/m/02rt38_ | Thomas | Fletcher | 1779-10-21 | M | 13227 | |||||||||||||||||
F000213 | Elias Florence | F000213 | 404168 | 3228 | Elias Florence | Q5360495 | kg:/m/02rl_pj | Elias | Florence | 1797-02-15 | M | 13237 | |||||||||||||||||
F000218 | Walter Flowers | F000218 | 404173 | 12014 | Walter Flowers | Q373825 | kg:/m/02qhdcb | Walter | Flowers | 1933-04-12 | M | 13245 | 00393 | ||||||||||||||||
F000220 | John Floyd | F000220 | 404176 | 3233 | John Floyd (Georgia politician) | Q1572340 | kg:/m/07t05p | John | Floyd | 1769-10-03 | M | 13247 | |||||||||||||||||
F000221 | John Floyd | F000221 | 404175 | 3234 | John Floyd (Virginia politician) | Q669087 | kg:/m/07szvy | John | Floyd | 1783-04-24 | M | 13248 | |||||||||||||||||
F000224 | William Floyd | F000224 | 404179 | 3237 | William Floyd | Q1381060 | kg:/m/01mpvf | William | Floyd | 1734-12-17 | M | 13251 | |||||||||||||||||
F000225 | Edwin Flye | F000225 | 404180 | 3238 | Edwin Flye | Q1294559 | kg:/m/02r2p3d | Edwin | Flye | 1817-03-04 | M | 13253 | |||||||||||||||||
F000242 | Walter Folger | F000242 | 404196 | 3252 | Walter Folger Jr. | Q1315384 | kg:/m/02rj_1p | Walter | Folger | 1765-06-12 | M | 13279 | Jr. | ||||||||||||||||
F000248 | Solomon Foot | F000248 | 404201 | 3256 | Solomon Foot | Q1424080 | kg:/m/0855fn | Solomon | Foot | 1802-11-19 | M | 13287 | |||||||||||||||||
F000259 | George Ford | F000259 | 404211 | 3267 | George Ford (American politician) | Q1507350 | kg:/m/02rkfzh | George | Ford | 1846-01-11 | M | 13299 | |||||||||||||||||
F000263 | James Ford | F000263 | 404214 | 3269 | James Ford (Pennsylvania politician) | Q6134046 | kg:/m/026t8p8 | James | Ford | 1783-05-04 | M | 13306 | |||||||||||||||||
F000266 | Nicholas Ford | F000266 | 404217 | 3272 | Nicholas Ford | Q1455445 | kg:/m/02rz7n6 | Nicholas | Ford | 1833-06-21 | M | 13309 | |||||||||||||||||
F000276 | Joseph Fornance | F000276 | 404226 | 3279 | Joseph Fornance | Q6283158 | kg:/m/026tbyt | Joseph | Fornance | 1804-10-18 | M | 13322 | |||||||||||||||||
F000279 | Peter Forney | F000279 | 404229 | 3282 | Peter Forney | Q937708 | kg:/m/09ykfq | Peter | Forney | 1756-04-21 | M | 13325 | |||||||||||||||||
F000281 | Thomas Forrest | F000281 | 404231 | 3284 | Thomas Forrest | Q6148166 | kg:/m/0crwqv | Thomas | Forrest | M | 13327 | ||||||||||||||||||
F000282 | Uriah Forrest | F000282 | 404232 | 3285 | Uriah Forrest | Q868551 | kg:/m/04cjt9 | Uriah | Forrest | M | 13328 | ||||||||||||||||||
F000284 | John Forsyth | F000284 | 404234 | 3287 | John Forsyth (politician) | Q730958 | kg:/m/02l6kj | John | Forsyth | 1780-10-22 | M | 13331 | |||||||||||||||||
F000289 | Tomlinson Fort | F000289 | 404239 | 3291 | Tomlinson Fort (congressman) | Q177217 | kg:/m/0ghy59 | Tomlinson | Fort | 1787-07-14 | M | 13336 | |||||||||||||||||
F000290 | Chauncey Forward | F000290 | 404240 | 3292 | Chauncey Forward | Q5088223 | kg:/m/026t8tr | Chauncey | Forward | 1793-02-04 | M | 13337 | |||||||||||||||||
F000291 | Walter Forward | F000291 | 404241 | 3293 | Walter Forward | Q1605667 | kg:/m/039wv_ | Walter | Forward | 1786-01-24 | M | 13338 | |||||||||||||||||
F000292 | Nicoll Fosdick | F000292 | 404242 | 3294 | Nicoll Fosdick | Q7030289 | kg:/m/02rkv0w | Nicoll | Fosdick | 1785-11-09 | M | 13339 | |||||||||||||||||
F000297 | Abiel Foster | F000297 | 404246 | 3299 | Abiel Foster | Q320910 | kg:/m/03_fmd | Abiel | Foster | 1735-08-08 | M | 13346 | |||||||||||||||||
F000299 | Charles Foster | F000299 | 404248 | 3301 | Charles Foster (Ohio politician) | Q720584 | kg:/m/033w5_ | Charles | Foster | 1828-04-12 | M | 13348 | |||||||||||||||||
F000301 | Dwight Foster | F000301 | 404250 | 3303 | Dwight Foster (politician, born 1757) | Q456298 | kg:/m/08w9bc | Dwight | Foster | 1757-12-07 | M | 13352 |
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);