legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by id_icpsr
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A000148 | Jake Auchincloss | A000148 | 456825 | Jake Auchincloss | Q101196632 | kg:/g/11f0xw2_p4 | Jake | Auchincloss | 1988-01-29 | M | Daniel | Jake Auchincloss | N00045506 | [ "H0MA04192" ] |
|||||||||||||||
A000192 | James Anderson | A000192 | 400847 | James Patton Anderson | Q1680958 | kg:/m/0gkv2p | James | Anderson | 1822-02-16 | M | 8522 | Patton | |||||||||||||||||
A000252 | William Andrews | A000252 | 400888 | William Henry Andrews | Q966483 | kg:/m/05yd23 | William | Andrews | 1846-01-14 | M | 8614 | Henry | |||||||||||||||||
A000283 | Moses Armstrong | A000283 | 400923 | Moses K. Armstrong | Q1949162 | kg:/m/01s_jt | Moses | Armstrong | 1832-09-19 | M | 8657 | Kimball | |||||||||||||||||
A000359 | Aníbal Acevedo-Vilá | A000359 | 400002 | Aníbal Acevedo Vilá | Q615126 | kg:/m/0337g0 | Aníbal | Acevedo-Vilá | 1962-02-13 | M | 8754 | 01679 | N00009825 | ||||||||||||||||
A000373 | Brad Ashford | A000373 | 412642 | Brad Ashford | Q4953782 | kg:/m/02pys5v | Brad | Ashford | 1949-11-10 | M | 02257 | 56766 | Brad Ashford | N00005293 | [ "H4NE02054" ] |
2098 | |||||||||||||
B000088 | Henry Baldwin | B000088 | 401090 | Henry Alexander Baldwin | Q1606418 | kg:/m/03njjt | Henry | Baldwin | 1871-01-12 | M | 8888 | Alexander | |||||||||||||||||
B000219 | Coles Bashford | B000219 | 401216 | Coles Bashford | Q882895 | kg:/m/037vjg | Coles | Bashford | 1816-01-24 | M | 9057 | ||||||||||||||||||
B000235 | James Bates | B000235 | 401230 | James Woodson Bates | Q692671 | kg:/m/0723j9 | James | Bates | 1788-08-25 | M | 9079 | Woodson | |||||||||||||||||
B000278 | Curtis Bean | B000278 | 401272 | Curtis Coe Bean | Q1145545 | kg:/m/02rhdxj | Curtis | Bean | 1828-01-04 | M | 9135 | Coe | |||||||||||||||||
B000362 | Jaime Benítez | B000362 | 401354 | Jaime Benítez Rexach | Q1862978 | kg:/m/0950h1 | Jaime | Benítez | 1908-10-29 | M | 9247 | 00075 | |||||||||||||||||
B000369 | Hiram Bennet | B000369 | 401361 | Hiram Pitt Bennet | Q1421481 | kg:/m/02rhhm4 | Hiram | Bennet | 1826-09-02 | M | 9254 | Pitt | |||||||||||||||||
B000374 | Granville Bennett | B000374 | 401366 | Granville G. Bennett | Q1543274 | kg:/m/01s_kh | Granville | Bennett | 1833-10-09 | M | 9262 | Gaylord | |||||||||||||||||
B000383 | Thomas Bennett | B000383 | 401374 | Thomas W. Bennett (territorial governor) | Q889361 | kg:/m/0d4c1t | Thomas | Bennett | 1831-02-16 | M | 9273 | Warren | |||||||||||||||||
B000412 | John Bernhisel | B000412 | 401399 | John Milton Bernhisel | Q446929 | kg:/m/0cszkx | John | Bernhisel | 1799-07-23 | M | 9311 | Milton | |||||||||||||||||
B000441 | John Biddle | B000441 | 401427 | John Biddle (Michigan politician) | Q665672 | kg:/m/0czw9w | John | Biddle | 1792-03-02 | M | 9346 | ||||||||||||||||||
B000551 | Ben Blaz | B000551 | 401526 | Vicente T. Blaz | Q2819706 | kg:/m/0fb9dc | Ben | Blaz | 1928-02-14 | M | 9489 | Garrido | 00096 | ||||||||||||||||
B000612 | Shadrack Bond | B000612 | 401579 | Shadrach Bond | Q734759 | kg:/m/0507rx | Shadrack | Bond | 1773-11-24 | M | 9572 | ||||||||||||||||||
B000668 | Cliff Bentz | B000668 | 456842 | Cliff Bentz | Q5132536 | kg:/m/0gfdsjb | Cliff | Bentz | 1952-01-12 | M | Stewart | Cliff Bentz | N00045773 | [ "H0OR02127" ] |
|||||||||||||||
B000737 | Allen Bradford | B000737 | 401697 | Allen Alexander Bradford | Q1525819 | kg:/m/02rgv3v | Allen | Bradford | 1815-07-23 | M | 9735 | Alexander | |||||||||||||||||
B000740 | Stephanie Bice | B000740 | 456841 | Stephanie Bice | Q60190894 | kg:/g/11h2hmkrv8 | Stephanie | Bice | 1973-11-11 | F | I. | Stephanie Bice | Stephanie I. Bice | N00044579 | [ "H0OK05205" ] |
||||||||||||||
B000806 | Thomas Brents | B000806 | 401763 | Thomas Hurley Brents | Q1500439 | kg:/m/02rjzsr | Thomas | Brents | 1840-12-24 | M | 9821 | Hurley | |||||||||||||||||
B000825 | Lauren Boebert | B000825 | 456805 | Lauren Boebert | Q96761544 | kg:/g/11j2v06x6p | Lauren | Boebert | 1986-12-15 | F | Opal | Lauren Boebert | Lauren Boebert | N00045974 | [ "H0CO03165" ] |
||||||||||||||
B001054 | Wingfield Bullock | B001054 | 412021 | Wingfield Bullock | Q2584413 | kg:/m/02rk0jg | Wingfield | Bullock | M | 10133 | |||||||||||||||||||
B001076 | Jocelyn Burdick | B001076 | 402022 | Jocelyn Burdick | Q453920 | kg:/m/04pn5n | Jocelyn | Burdick | 1922-02-06 | F | 10163 | Birch | 01296 | S220 | |||||||||||||||
B001108 | Walter Burleigh | B001108 | 402053 | Walter A. Burleigh | Q2543402 | kg:/m/01s_n3 | Walter | Burleigh | 1820-10-25 | M | 10204 | Atwood | |||||||||||||||||
B001127 | John Burns | B001127 | 402071 | John A. Burns | Q880606 | kg:/m/02kwtb | John | Burns | 1909-03-30 | M | 10226 | Anthony | |||||||||||||||||
B001169 | Vera Bushfield | B001169 | 402111 | Vera C. Bushfield | Q274513 | kg:/m/0bnwcv | Vera | Bushfield | 1889-08-09 | F | 10280 | Cahalan | |||||||||||||||||
B001223 | Jamaal Bowman | B001223 | 456839 | Jamaal Bowman | Q96419280 | kg:/g/11fsgvc0xx | Jamaal | Bowman | 1976-04-01 | M | Jamaal Bowman | Jamaal Bowman | N00044790 | [ "H0NY16143" ] |
|||||||||||||||
B001224 | Cori Bush | B001224 | 456829 | Cori Bush | Q98084800 | kg:/g/11cntkcbkt | Cori | Bush | 1976-07-21 | F | Cori Bush | Cori Bush | N00039373 | [ "H8MO01143" ] |
|||||||||||||||
B001245 | Madeleine Bordallo | B001245 | 400041 | Madeleine Bordallo | Q292988 | kg:/m/01s_xp | Madeleine | Bordallo | 1933-05-31 | F | 10389 | Z. | 01723 | 1003568 | 1751 | Madeleine Z. Bordallo | N00024866 | [ "H2GU00033" ] |
160 | ||||||||||
B001312 | Carolyn Bourdeaux | B001312 | 456812 | Carolyn Bourdeaux | Q58333638 | kg:/g/11fgm1glqj | Carolyn | Bourdeaux | 1970-06-03 | F | 178540 | Carolyn Bourdeaux | N00041791 | [ "H8GA07201" ] |
|||||||||||||||
B001313 | Shontel Brown | B001313 | 456863 | Shontel Brown | Q107863952 | Shontel | Brown | 1975-06-24 | F | M. | Shontel M. Brown | N00047875 | [ "H2OH11169" ] |
||||||||||||||||
C000023 | John Caine | C000023 | 402184 | John Thomas Caine | Q964884 | kg:/m/02rhkmh | John | Caine | 1829-01-08 | M | 10471 | Thomas | |||||||||||||||||
C000042 | Thomas Cale | C000042 | 402203 | Thomas Cale | Q1741474 | kg:/m/0drqr6 | Thomas | Cale | 1848-09-17 | M | 10494 | ||||||||||||||||||
C000050 | Richard Call | C000050 | 402210 | Richard K. Call | Q885835 | kg:/m/04bk4q | Richard | Call | 1792-10-24 | M | 10503 | Keith | |||||||||||||||||
C000053 | James Callahan | C000053 | 402212 | James Yancy Callahan | Q1681329 | kg:/m/0bjphs | James | Callahan | 1852-12-19 | M | 10508 | Yancy | |||||||||||||||||
C000092 | John Campbell | C000092 | 402247 | John G. Campbell | Q1700145 | kg:/m/02qfh3m | John | Campbell | 1827-06-25 | M | 10559 | Goulder | |||||||||||||||||
C000119 | George Cannon | C000119 | 402270 | George Q. Cannon | Q947083 | kg:/m/040jgk | George | Cannon | 1827-01-11 | M | 10597 | Quayle | |||||||||||||||||
C000309 | Bird Chapman | C000309 | 402451 | Bird Beers Chapman | Q865044 | kg:/m/02z38n3 | Bird | Chapman | 1821-08-24 | M | 10842 | Beers | |||||||||||||||||
C000318 | William Chapman | C000318 | 402460 | William W. Chapman | Q1415304 | kg:/m/02z4p8r | William | Chapman | 1808-08-11 | M | 10853 | Williams | |||||||||||||||||
C000337 | José Chaves | C000337 | 402477 | José Francisco Chaves | Q1360890 | kg:/m/02rlcmm | José | Chaves | 1833-06-27 | M | 10873 | Francisco | |||||||||||||||||
C000370 | Norton Chipman | C000370 | 402509 | Norton P. Chipman | Q2819666 | kg:/m/01s_tm | Norton | Chipman | 1834-03-07 | M | 10916 | Parker | |||||||||||||||||
C000380 | Donna Christensen | C000380 | 400073 | Donna Christian-Christensen | Q461604 | kg:/m/01t01l | Donna | Christensen | 1945-09-19 | F | 10930 | M. | Donna Christensen | 01474 | 48879 | 1032 | Donna M. Christensen | N00000133 | [ "H4VI00054" ] |
190 | |||||||||
C000400 | William Clagett | C000400 | 402539 | William H. Clagett | Q2579039 | kg:/m/02rpk_g | William | Clagett | 1838-09-21 | M | 10953 | Horace | |||||||||||||||||
C000426 | Daniel Clark | C000426 | 412141 | Daniel Clark (Louisiana politician) | Q1160345 | kg:/m/01t003 | Daniel | Clark | M | 10985 | |||||||||||||||||||
C000517 | Charles Clever | C000517 | 402652 | Charles P. Clever | Q215432 | kg:/m/02rhdf1 | Charles | Clever | 1830-02-23 | M | 11093 | P. | |||||||||||||||||
C000609 | George Cole | C000609 | 402738 | George Edward Cole | Q125387 | kg:/m/02rhghd | George | Cole | 1826-12-23 | M | 11212 | Edward | |||||||||||||||||
C000646 | Antonio Colorado | C000646 | 402774 | Antonio Colorado | Q2119871 | kg:/m/04960z | Antonio | Colorado | 1939-09-08 | M | 11261 | J. | 00223 | ||||||||||||||||
C000712 | Henry Conway | C000712 | 402836 | Henry Wharton Conway | Q1607403 | kg:/m/01smrm | Henry | Conway | 1793-03-18 | M | 11345 | Wharton | |||||||||||||||||
C000775 | Jorge Córdova Díaz | C000775 | 402895 | Jorge Luis Córdova | Q1778512 | kg:/m/02rjw8b | Jorge | Córdova Díaz | 1907-04-20 | M | Luis | ||||||||||||||||||
C000777 | William Corlett | C000777 | 402897 | William Wellington Corlett | Q1304958 | kg:/m/02rk06h | William | Corlett | 1842-04-10 | M | 11425 | Wellington | |||||||||||||||||
C000788 | Baltasar Corrada-del Río | C000788 | 402908 | Baltasar Corrada del Río | Q1973038 | kg:/m/045xcr | Baltasar | Corrada-del Río | 1935-04-10 | M | 11441 | 00237 | |||||||||||||||||
C000850 | John Cradlebaugh | C000850 | 402966 | John Cradlebaugh | Q989852 | kg:/m/0265pjz | John | Cradlebaugh | 1819-02-22 | M | 11519 | ||||||||||||||||||
C001039 | Katherine Cammack | C001039 | 456806 | Kat Cammack | Q98523243 | kg:/g/11fsp_lppx | Katherine | Cammack | 1988-02-16 | F | Kat | Kat Cammack | N00045978 | [ "H0FL03175" ] |
|||||||||||||||
C001054 | Jerry Carl | C001054 | 456799 | Jerry Carl | Q102277702 | kg:/g/11j2j1brnb | Jerry | Carl | 1958-06-17 | M | Lee | Jr. | Jerry L. Carl | N00044245 | [ "H0AL01055" ] |
||||||||||||||
C001099 | William Cowan | C001099 | 412586 | Mo Cowan | Q3915426 | kg:/m/0qftmjh | William | Cowan | 1969-04-04 | M | Mo | Mo Cowan | 02189 | 69395 | 144307 | S367 | William M. Cowan | N99999896 | 2044 | ||||||||||
C001100 | Jeffrey Chiesa | C001100 | 412597 | Jeffrey Chiesa | Q13420124 | kg:/m/0j266jc | Jeffrey | Chiesa | 1965-06-22 | M | Scott | Jeff Chiesa | 02192 | 64996 | 144672 | S368 | Jeff Chiesa | 2048 | |||||||||||
C001102 | Curtis Clawson | C001102 | 412604 | Curt Clawson | Q16728087 | kg:/m/03wphq2 | Curtis | Clawson | 1959-09-28 | M | Curt | 02200 | 75516 | 148899 | Curt Clawson | N00035854 | [ "H4FL19074" ] |
2060 | |||||||||||
C001104 | Madison Cawthorn | C001104 | 456833 | Madison Cawthorn | Q96633736 | kg:/g/11jcrrfg9t | Madison | Cawthorn | 1995-08-01 | M | Madison Cawthorn | Madison Cawthorn | N00046252 | [ "H0NC11233" ] |
|||||||||||||||
C001116 | Andrew Clyde | C001116 | 456813 | Andrew Clyde | Q102277679 | kg:/g/11j32tm4v4 | Andrew | Clyde | 1963-11-22 | M | S. | Andrew S. Clyde | N00046654 | [ "H0GA09246" ] |
|||||||||||||||
C001125 | Troy Carter | C001125 | 456860 | Troy Carter (politician) | Q7846787 | Troy | Carter | 1963-10-26 | M | Anthony | Troy Carter | Troy A. Carter | N00025766 | [ "H2LA02149" ] |
|||||||||||||||
C001126 | Mike Carey | C001126 | 456864 | Mike Carey (politician) | Q108010312 | Mike | Carey | 1971-03-13 | M | Mike Carey | N00048568 | [ "H2OH15228" ] |
|||||||||||||||||
C001127 | Sheila Cherfilus-McCormick | C001127 | 456865 | Sheila Cherfilus-McCormick | Q109560948 | Sheila | Cherfilus-McCormick | 1979-01-25 | F | Sheila Cherfilus-McCormick | N00043504 | [ "H8FL20032" ] |
|||||||||||||||||
C001128 | Connie Conway | C001128 | 456866 | Connie Conway | Q5161840 | Connie | Conway | 1950-09-25 | F | Connie Conway | Connie Conway | N00050064 | [ "H2CA22231" ] |
||||||||||||||||
D000006 | Samuel Daily | D000006 | 403150 | Samuel Gordon Daily | Q2218316 | kg:/m/02z38qj | Samuel | Daily | M | 11840 | Gordon | ||||||||||||||||||
D000032 | Byron Donalds | D000032 | 456808 | Byron Donalds | Q59726216 | kg:/g/11c1xk7pbn | Byron | Donalds | 1978-10-28 | M | Lowell | Byron Donalds | N00034016 | [ "H0FL19205" ] |
|||||||||||||||
D000090 | Félix Dávila | D000090 | 403227 | Félix Córdova Dávila | Q1385359 | kg:/m/026540r | Félix | Dávila | 1878-11-20 | M | Córdova | ||||||||||||||||||
D000196 | Federico Degetau | D000196 | 403352 | Federico Degetau | Q1400453 | kg:/m/055yz6 | Federico | Degetau | 1862-12-05 | M | 12074 | ||||||||||||||||||
D000209 | Ron de Lugo | D000209 | 403314 | Ron de Lugo | Q2819582 | kg:/m/01t028 | Ron | de Lugo | 1930-08-02 | M | 12092 | 00275 | |||||||||||||||||
D000218 | Francisco Delgado | D000218 | 403360 | Francisco Afan Delgado | Q2793511 | kg:/m/0ct0yl | Francisco | Delgado | 1886-01-25 | M | 12104 | Afan | |||||||||||||||||
D000230 | Edward De Nivernais | D000230 | 403318 | Edward | De Nivernais | M | 12117 | James | |||||||||||||||||||||
D000240 | William Denning | D000240 | 403378 | William Denning | Q82219 | kg:/m/026nzyl | William | Denning | M | 12128 | |||||||||||||||||||
D000247 | Arthur Denny | D000247 | 403385 | Arthur A. Denny | Q1595543 | kg:/m/0b82cd | Arthur | Denny | 1822-06-20 | M | 12136 | Armstrong | |||||||||||||||||
D000273 | Jean Destréhan | D000273 | 403408 | Jean Noël Destréhan | Q435963 | kg:/m/0b079s | Jean | Destréhan | M | Noel | |||||||||||||||||||
D000276 | Jaime De Veyra | D000276 | 403322 | Jaime C. de Veyra | Q2597955 | kg:/m/0chsjr | Jaime | De Veyra | 1873-11-04 | M | 12170 | Carlos | |||||||||||||||||
D000353 | Anthony Dimond | D000353 | 403471 | Anthony Dimond | Q573153 | kg:/m/068w4f | Anthony | Dimond | 1881-11-30 | M | 12264 | Joseph | |||||||||||||||||
D000470 | Stephen Downey | D000470 | 403580 | Stephen Wheeler Downey | Q1802144 | kg:/m/0df_x7 | Stephen | Downey | 1839-07-25 | M | 12420 | Wheeler | |||||||||||||||||
D000472 | Charles Downing | D000472 | 412035 | Charles Downing | Q1064151 | kg:/m/0b1q2r | Charles | Downing | M | 12422 | |||||||||||||||||||
D000531 | James Duncan | D000531 | 403639 | James Duncan (Pennsylvania politician) | Q6132921 | kg:/m/027gwqz | James | Duncan | M | 12490 | |||||||||||||||||||
E000015 | Manuel Earnshaw | E000015 | 403711 | Manuel Earnshaw | Q2514230 | kg:/m/0cg5vn | Manuel | Earnshaw | 1862-11-19 | M | 12621 | ||||||||||||||||||
E000022 | Rufus Easton | E000022 | 403718 | Rufus Easton | Q1300347 | kg:/m/02rz83p | Rufus | Easton | 1774-05-04 | M | 12628 | ||||||||||||||||||
E000071 | Jake Ellzey | E000071 | 456862 | Jake Ellzey | Q105061782 | Jake | Ellzey | 1970-01-24 | M | Jake Ellzey | Jake Ellzey | N00042243 | [ "H8TX06266" ] |
||||||||||||||||
E000108 | Joaquin Elizalde | E000108 | 403799 | Joaquín Miguel Elizalde | Q2613936 | kg:/m/0cvph9 | Joaquin | Elizalde | 1896-08-02 | M | 12728 | Miguel | |||||||||||||||||
E000220 | Experience Estabrook | E000220 | 403906 | Experience Estabrook | Q1384347 | kg:/m/02z38ph | Experience | Estabrook | 1813-04-30 | M | 12874 | ||||||||||||||||||
E000237 | David Evans | E000237 | 403921 | David Ellicott Evans | Q5233341 | kg:/m/03cg7p_ | David | Evans | 1788-03-19 | M | 12893 | Ellicott | |||||||||||||||||
E000254 | Melvin Evans | E000254 | 403936 | Melvin H. Evans | Q2819651 | kg:/m/01t03l | Melvin | Evans | 1917-08-07 | M | 12913 | Herbert | 00362 | ||||||||||||||||
F000010 | Eni Faleomavaega | F000010 | 400128 | Eni Faleomavaega | Q729199 | kg:/m/01s_hc | Eni | Faleomavaega | 1943-08-15 | M | 12977 | F. H. | 00367 | 6713 | 774 | Eni F. H. Faleomavaega | N00007632 | [ "H0AS00018" ] |
239 | ||||||||||
F000034 | Joseph Farrington | F000034 | 403995 | Joseph Rider Farrington | Q1263994 | kg:/m/036nhz | Joseph | Farrington | 1897-10-15 | M | 13005 | Rider | |||||||||||||||||
F000035 | Mary Farrington | F000035 | 403996 | Mary Elizabeth Pruett Farrington | Q1331285 | kg:/m/036nr7 | Mary | Farrington | 1898-05-30 | F | 13007 | Elizabeth Pruett | |||||||||||||||||
F000046 | Walter Fauntroy | F000046 | 404006 | Walter Fauntroy | Q2819659 | kg:/m/01s_tz | Walter | Fauntroy | 1933-02-06 | M | 13023 | Edward | 00372 | ||||||||||||||||
F000054 | Paul Fearing | F000054 | 404014 | Paul Fearing | Q1278451 | kg:/m/0czh91 | Paul | Fearing | 1762-02-28 | M | 13033 | ||||||||||||||||||
F000073 | Stephen Fenn | F000073 | 404031 | Stephen Southmyd Fenn | Q2345078 | kg:/m/02rjzjh | Stephen | Fenn | 1820-03-28 | M | 13058 | Southmyd | |||||||||||||||||
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 | ||||||||||||||||||
F000188 | Alvan Flanders | F000188 | 404143 | Alvan Flanders | Q448252 | kg:/m/02rgv4w | Alvan | Flanders | 1825-08-02 | M | 13207 | ||||||||||||||||||
F000226 | Dennis Flynn | F000226 | 404181 | Dennis Thomas Flynn | Q1189559 | kg:/m/027tb2d | Dennis | Flynn | 1861-02-13 | M | 13255 | Thomas | |||||||||||||||||
F000246 | Patrick Fallon | F000246 | 456845 | Pat Fallon | Q16196923 | kg:/m/0100nvdw | Patrick | Fallon | 1967-12-19 | M | Edward | Pat | Pat Fallon | N00047264 | [ "H0TX04219" ] |
||||||||||||||
F000257 | Michael Forbes | F000257 | 400582 | Michael Forbes | Q154049 | kg:/m/03tzft | Michael | Forbes | 1952-07-16 | M | 13297 | P. | 00398 | ||||||||||||||||
F000351 | Victor Frazer | F000351 | 404298 | Victor O. Frazer | Q2522517 | kg:/m/01t03y | Victor | Frazer | 1943-05-24 | M | 13416 | O. | 00412 |
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);