legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by name_suffix descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
B000252 | Thomas Bayard | B000252 | 401246 | 529 | Thomas F. Bayard Jr. | Q1691899 | kg:/m/06vw0f | Thomas | Bayard | 1868-06-04 | M | Francis | Jr. | ||||||||||||||||
B000272 | John Beall | B000272 | 401266 | 12002 | J. Glenn Beall Jr. | Q325914 | kg:/m/05f_9c | John | Beall | 1927-06-19 | M | 9128 | Glenn | Jr. | 01278 | ||||||||||||||
B000280 | Robin Beard | B000280 | 401274 | 14004 | Robin Beard | Q963419 | kg:/m/03z10z | Robin | Beard | 1939-08-21 | M | 9139 | Leo | Jr. | 00069 | ||||||||||||||
B000363 | Adam Benjamin | B000363 | 401355 | 14406 | Adam Benjamin Jr. | Q348740 | kg:/m/09jxd5 | Adam | Benjamin | 1935-08-06 | M | 9248 | Jr. | 00076 | |||||||||||||||
B000401 | Lloyd Bentsen | B000401 | 401391 | 660 | Lloyd Bentsen | Q455401 | kg:/m/01rpmr | Lloyd | Bentsen | 1921-02-11 | M | 9296 | Millard | Jr. | 01282 | S009 | |||||||||||||
B000422 | Edwin Bethune | B000422 | 401408 | 14606 | Ed Bethune | Q1282285 | kg:/m/02rhfgr | Edwin | Bethune | 1935-12-19 | M | 9324 | Ruthvin | Jr. | 00083 | ||||||||||||||
B000444 | Joseph Biden | B000444 | 300008 | 14101 | Joe Biden | Q6279 | kg:/m/012gx2 | Joseph | Biden | 1942-11-20 | M | R. | Joe Biden | Jr. | 01284 | 34 | 53279 | S010 | N00001669 | [ "S8DE00012" ] |
|||||||||
B000451 | Edward Biester | B000451 | 401436 | 11001 | Edward G. Biester Jr. | Q5343029 | kg:/m/0dp9wd | Edward | Biester | 1931-01-05 | M | 9358 | George | Jr. | 00086 | ||||||||||||||
B000485 | Horatio Bisbee | B000485 | 401466 | 730 | Horatio Bisbee Jr. | Q238626 | kg:/m/02rhhnj | Horatio | Bisbee | 1839-05-01 | M | 9404 | Jr. | ||||||||||||||||
B000490 | Sanford Bishop | B000490 | 400030 | 29339 | Sanford Bishop | Q983428 | kg:/m/02554k | Sanford | Bishop | 1947-02-04 | M | 7697 | D. | Sanford Bishop Jr. | Jr. | 00091 | 26194 | 26817 | Sanford D. Bishop, Jr. | N00002674 | [ "H2GA02031" ] |
148 | |||||||
B000505 | Loring Black | B000505 | 401484 | 749 | Loring M. Black Jr. | Q866845 | kg:/m/02r7x0q | Loring | Black | 1886-05-17 | M | 9427 | Milton | Jr. | |||||||||||||||
B000523 | Francis Blair | B000523 | 401499 | 764 | Francis Preston Blair Jr. | Q1350196 | kg:/m/034c_8 | Francis | Blair | 1821-02-19 | M | 9450 | Preston | Jr. | |||||||||||||||
B000533 | John Blake | B000533 | 401508 | 773 | John Blake Jr. (politician) | Q1699352 | kg:/m/026hq8f | John | Blake | 1762-12-05 | M | 9461 | Jr. | ||||||||||||||||
B000588 | John Boehne | B000588 | 401557 | 820 | John W. Boehne Jr. | Q1702030 | kg:/m/02rl1c2 | John | Boehne | 1895-03-02 | M | 9536 | William | Jr. | |||||||||||||||
B000641 | Charles Borland | B000641 | 401606 | 864 | Charles Borland Jr. | Q892029 | kg:/m/02rkmtv | Charles | Borland | 1786-06-29 | M | 9612 | Jr. | ||||||||||||||||
B000650 | John Boss | B000650 | 401614 | 870 | John Linscom Boss Jr. | Q1533882 | kg:/m/02rhkbk | John | Boss | 1780-09-07 | M | 9626 | Linscom | Jr. | |||||||||||||||
B000670 | Jonathan Bourne | B000670 | 401632 | 885 | Jonathan Bourne Jr. | Q374906 | kg:/m/0d8sqr | Jonathan | Bourne | 1855-02-23 | M | Jr. | |||||||||||||||||
B000716 | Allen Boyd | B000716 | 400044 | 29713 | Allen Boyd | Q2600908 | kg:/m/0251w9 | Allen | Boyd | 1945-06-06 | M | 9711 | Jr. | 01467 | 46164 | 729 | N00002743 | [ "H6FL00046" ] |
|||||||||||
B000910 | Clarence Brown | B000910 | 401867 | 10786 | Bud Brown (politician) | Q4983802 | kg:/m/03ldwb | Clarence | Brown | 1927-06-18 | M | 9956 | J. | Jr. | 00131 | ||||||||||||||
B000918 | George Brown | B000918 | 400572 | 10573 | George Brown Jr. | Q1507018 | kg:/m/09lbhn | George | Brown | 1920-03-06 | M | 9965 | E. | Jr. | 00134 | ||||||||||||||
B000949 | William Brown | B000949 | 401902 | 1138 | William Gay Brown Jr. | Q1743263 | kg:/m/03c1s6n | William | Brown | 1856-04-07 | M | 10001 | Gay | Jr. | |||||||||||||||
B000979 | Stephen Brundidge | B000979 | 401931 | 1164 | Stephen Brundidge Jr. | Q1434311 | kg:/m/02rjzf1 | Stephen | Brundidge | 1857-01-01 | M | 10043 | Jr. | ||||||||||||||||
B001008 | John Buchanan | B001008 | 401958 | 10706 | John Hall Buchanan Jr. | Q999881 | kg:/m/02qj8c1 | John | Buchanan | 1928-03-19 | M | 10078 | Hall | Jr. | 00143 | ||||||||||||||
B001042 | Joseph Buffum | B001042 | 401992 | 1221 | Joseph Buffum Jr. | Q1706700 | kg:/m/02rjwcf | Joseph | Buffum | 1784-09-23 | M | 10119 | Jr. | ||||||||||||||||
B001137 | James Burrill | B001137 | 402080 | 1305 | James Burrill Jr. | Q382718 | kg:/m/04rpwj | James | Burrill | 1772-04-25 | M | Jr. | |||||||||||||||||
B001209 | Harry Byrd | B001209 | 402149 | 10802 | Harry F. Byrd Jr. | Q3268711 | kg:/m/03667s | Harry | Byrd | 1914-12-20 | M | Flood | Jr. | 01300 | |||||||||||||||
B001218 | Joseph Byrns | B001218 | 402157 | 1373 | Joseph W. Byrns Jr. | Q1708157 | kg:/m/043ftm | Joseph | Byrns | 1903-08-15 | M | 10345 | Wellington | Jr. | |||||||||||||||
B001235 | Henry Brown | B001235 | 400049 | 20137 | Henry E. Brown Jr. | Q962919 | kg:/m/03tpvc | Henry | Brown | 1935-12-20 | M | 10370 | E. | Jr. | 01669 | 1000221 | 3993 | N00002428 | [ "H0SC01071" ] |
||||||||||
B001238 | Frank Ballance | B001238 | 400014 | 20339 | Frank Ballance | Q1442909 | kg:/m/02bx4c | Frank | Ballance | 1942-02-15 | M | 10375 | W. | Jr. | 01734 | N00025005 | |||||||||||||
B001251 | George Butterfield | B001251 | 400616 | 20340 | G. K. Butterfield | Q983532 | kg:/m/03g_pq | George | Butterfield | 1947-04-27 | M | 10401 | Kenneth | G.K. | G.K. Butterfield | Jr. | 01761 | 1013540 | 41077 | G. K. Butterfield | N00027035 | [ "H4NC01046" ] |
624 | ||||||
B001255 | Charles Boustany | B001255 | 400636 | 20514 | Charles Boustany | Q972735 | kg:/m/04wdx3 | Charles | Boustany | 1956-02-21 | M | 10409 | W. | Charles Boustany Jr. | Jr. | 01787 | 1013047 | 35514 | Charles W. Boustany Jr. | N00026595 | [ "H4LA07029" ] |
642 | |||||||
B001262 | Paul Broun | B001262 | 412252 | 20753 | Paul Broun | Q2059020 | kg:/m/02vzlfc | Paul | Broun | 1946-05-14 | M | 10422 | C. | Paul C. Broun | Jr. | 01882 | 1025092 | 70001 | Paul C. Broun | N00028986 | [ "H8GA10049", "S6GA00101", "H0GA03017" ] |
733 | |||||||
B001292 | Donald Beyer | B001292 | 412657 | 21554 | Don Beyer | Q3036086 | kg:/m/053g16 | Donald | Beyer | 1950-06-20 | M | S. | Don Beyer | Jr. | 02272 | 21141 | 1707 | Donald S. Beyer, Jr. | N00036018 | [ "H4VA08224" ] |
2113 | ||||||||
C000063 | Johnson Camden | C000063 | 402221 | 1433 | Johnson N. Camden Jr. | Q5601297 | kg:/m/09wb62 | Johnson | Camden | 1865-01-05 | M | Newlon | Jr. | ||||||||||||||||
C000079 | Carroll Campbell | C000079 | 402235 | 14609 | Carroll A. Campbell Jr. | Q11672 | kg:/m/050vw3 | Carroll | Campbell | 1940-07-24 | M | 10545 | Ashmore | Jr. | 00169 | ||||||||||||||
C000094 | John Campbell | C000094 | 402249 | 1459 | John P. Campbell Jr. | Q1701286 | kg:/m/02rhkf_ | John | Campbell | 1820-12-08 | M | 10561 | Pierce | Jr. | |||||||||||||||
C000110 | Ezekiel Candler | C000110 | 402262 | 1473 | Ezekiel S. Candler Jr. | Q675971 | kg:/m/02x2r2_ | Ezekiel | Candler | 1862-01-18 | M | 10584 | Samuel | Jr. | |||||||||||||||
C000321 | William Chappell | C000321 | 402463 | 12007 | Bill Chappell | Q999912 | kg:/m/02rk020 | William | Chappell | 1922-02-03 | M | 10856 | Venroe | Jr. | 00191 | ||||||||||||||
C000348 | James Chesnut | C000348 | 402487 | 1686 | James Chesnut Jr. | Q1680158 | kg:/m/09lvq5 | James | Chesnut | 1815-01-18 | M | Jr. | |||||||||||||||||
C000353 | Thomas Child | C000353 | 402492 | 1691 | Thomas Child Jr. | Q1193423 | kg:/m/02rkx0j | Thomas | Child | 1818-03-22 | M | 10897 | Jr. | ||||||||||||||||
C000356 | Lawton Chiles | C000356 | 402495 | 13101 | Lawton Chiles | Q744098 | kg:/m/027165 | Lawton | Chiles | 1930-04-03 | M | Mainor | Jr. | 01304 | |||||||||||||||
C000421 | Amos Clark | C000421 | 402560 | 1753 | Amos Clark Jr. | Q183577 | kg:/m/02rw_hg | Amos | Clark | 1828-11-08 | M | 10978 | Jr. | ||||||||||||||||
C000429 | Ezra Clark | C000429 | 402567 | 1761 | Ezra Clark Jr. | Q534881 | kg:/m/02rhg2p | Ezra | Clark | 1813-09-12 | M | 10989 | Jr. | ||||||||||||||||
C000442 | John Clark | C000442 | 402580 | 1774 | John Bullock Clark Jr. | Q655809 | kg:/m/0g1h8w | John | Clark | 1831-01-14 | M | 11005 | Bullock | Jr. | |||||||||||||||
C000480 | Clement Clay | C000480 | 402618 | 1808 | Clement Claiborne Clay | Q928988 | kg:/m/03gcq7 | Clement | Clay | 1816-12-13 | M | Claiborne | Jr. | ||||||||||||||||
C000523 | William Clinger | C000523 | 402657 | 14612 | William F. Clinger Jr. | Q8008766 | kg:/m/0dlrhm | William | Clinger | 1929-04-04 | M | 11101 | Floyd | Jr. | 00207 | ||||||||||||||
C000555 | William Cobey | C000555 | 402688 | 15091 | Bill Cobey | Q862019 | kg:/m/02fppy | William | Cobey | 1939-05-13 | M | 11143 | Wilfred | Jr. | 00210 | ||||||||||||||
C000586 | Robert Coffey | C000586 | 402715 | 1901 | Robert L. Coffey | Q7346534 | kg:/m/0dp81_ | Robert | Coffey | 1918-10-21 | M | 11185 | Lewis | Jr. | |||||||||||||||
C000591 | Peleg Coffin | C000591 | 402720 | 1906 | Peleg Coffin Jr. | Q2067932 | kg:/m/08vvd0 | Peleg | Coffin | 1756-11-03 | M | 11191 | Jr. | ||||||||||||||||
C000602 | Richard Coke | C000602 | 402731 | 1916 | Richard Coke Jr. | Q1680049 | kg:/m/027w8qd | Richard | Coke | 1790-11-16 | M | 11204 | Jr. | ||||||||||||||||
C000616 | William Cole | C000616 | 402745 | 1930 | William Purington Cole Jr. | Q808708 | kg:/m/0916k3 | William | Cole | 1889-05-11 | M | 11220 | Purington | Jr. | |||||||||||||||
C000654 | George Combs | C000654 | 402781 | 1959 | George H. Combs Jr. | Q1396513 | kg:/m/02rz6dp | George | Combs | 1899-05-02 | M | 11274 | Hamilton | Jr. | |||||||||||||||
C000666 | Barber Conable | C000666 | 402793 | 10712 | Barber Conable | Q443631 | kg:/m/05xwtx | Barber | Conable | 1922-11-02 | M | 11287 | Benjamin | Jr. | 00225 | ||||||||||||||
C000694 | William Connery | C000694 | 402819 | 1996 | William P. Connery Jr. | Q2580184 | kg:/m/0dwtz5 | William | Connery | 1888-08-24 | M | 11324 | Patrick | Jr. | |||||||||||||||
C000714 | John Conyers | C000714 | 400080 | 10713 | John Conyers | Q1370968 | kg:/m/02hy5d | John | Conyers | 1929-05-16 | M | 11348 | John Conyers, Jr. | Jr. | 00229 | 1824 | 26904 | John Conyers, Jr. | N00004029 | [ "H6MI01028" ] |
195 | ||||||||
C000804 | Frederic Coudert | C000804 | 402923 | 2089 | Frederic René Coudert Jr. | Q3893468 | kg:/m/02btc7 | Frederic | Coudert | 1898-05-07 | M | 11462 | René | Jr. | |||||||||||||||
C000836 | John Cox | C000836 | 402953 | 29116 | John W. Cox Jr. | Q6262204 | kg:/m/0dnv7x | John | Cox | 1947-07-10 | M | 11502 | W. | Jr. | 00243 | ||||||||||||||
C000843 | William Coxe | C000843 | 402960 | 2122 | William Coxe Jr. | Q1570579 | kg:/m/02rtnnv | William | Coxe | 1762-05-03 | M | 11511 | Jr. | ||||||||||||||||
C000866 | Nathaniel Craley | C000866 | 402981 | 10714 | Nathaniel N. Craley Jr. | Q6969784 | kg:/m/0dn3v6 | Nathaniel | Craley | 1927-11-17 | M | 11539 | Neiman | Jr. | |||||||||||||||
C000868 | Robert Cramer | C000868 | 400084 | 29100 | Robert E. Cramer | Q1368460 | kg:/m/024p0g | Robert | Cramer | 1947-08-22 | M | 11542 | E. | Bud | Jr. | 00247 | 26714 | N00003042 | [ "H0AL05049" ] |
||||||||||
C000902 | William Creighton | C000902 | 403014 | 2172 | William Creighton Jr. | Q250272 | kg:/m/0d7qm5 | William | Creighton | 1778-10-29 | M | 11583 | Jr. | ||||||||||||||||
C000919 | George Crockett | C000919 | 403031 | 14681 | George Crockett Jr. | Q1508429 | kg:/m/0fq0s3 | George | Crockett | 1909-08-10 | M | 11605 | William | Jr. | 00252 | ||||||||||||||
C000960 | Shepard Crumpacker | C000960 | 403072 | 2227 | Shepard J. Crumpacker Jr. | Q2800593 | kg:/m/02rkhp4 | Shepard | Crumpacker | 1917-02-13 | M | 11652 | J. | Jr. | |||||||||||||||
C000997 | William Curlin | C000997 | 403104 | 13051 | William P. Curlin Jr. | Q635447 | kg:/m/02rj_w4 | William | Curlin | 1933-11-30 | M | 11699 | Prather | Jr. | |||||||||||||||
C001001 | Charles Curry | C001001 | 403108 | 2262 | Charles F. Curry Jr. | Q1064307 | kg:/m/02rl0mb | Charles | Curry | 1893-08-13 | M | 11704 | Forrest | Jr. | |||||||||||||||
C001049 | Wm. Clay | C001049 | 400074 | 20147 | Lacy Clay | Q959455 | kg:/m/024vjr | Wm. | Clay | 1956-07-27 | M | 11766 | Lacy | William Lacy Clay | Jr. | 01654 | 88332 | 8967 | Wm. Lacy Clay | N00012460 | [ "H0MO01066" ] |
191 | [ { "name": "William Lacy Clay Sr.", "relation": "son" } ] |
||||||
C001054 | Jerry Carl | C001054 | 456799 | Jerry Carl | Q102277702 | kg:/g/11j2j1brnb | Jerry | Carl | 1958-06-17 | M | Lee | Jr. | Jerry L. Carl | N00044245 | [ "H0AL01055" ] |
||||||||||||||
C001070 | Robert Casey | C001070 | 412246 | 40703 | Bob Casey Jr. | Q887841 | kg:/m/047ymw | Robert | Casey | 1960-04-13 | M | P. | Bob | Bob Casey, Jr. | Jr. | 01828 | 47036 | 2541 | S309 | Robert P. Casey, Jr. | N00027503 | [ "S6PA00217" ] |
727 | ||||||
C001073 | Donald Cazayoux | C001073 | 412260 | 20760 | Don Cazayoux | Q1239044 | kg:/m/03m9xkc | Donald | Cazayoux | 1964-01-17 | M | 11807 | J. | Jr. | 01891 | 35272 | N00029680 | [ "H8LA06022" ] |
|||||||||||
D000007 | Thomas D’Alesandro | D000007 | 403141 | 2304 | Thomas D'Alesandro Jr. | Q1156152 | kg:/m/028qh5 | Thomas | D’Alesandro | 1903-08-01 | M | 11841 | Jr. | ||||||||||||||||
D000037 | Robert Daniel | D000037 | 403177 | 14013 | Robert Daniel | Q1356455 | kg:/m/09dbt_ | Robert | Daniel | 1936-03-17 | M | 11875 | Williams | Jr. | 00260 | ||||||||||||||
D000050 | Colgate Darden | D000050 | 403189 | 2335 | Colgate Darden | Q880393 | kg:/m/05nnw0 | Colgate | Darden | 1897-02-11 | M | 11891 | Whitehead | Jr. | |||||||||||||||
D000249 | Harmar Denny | D000249 | 403387 | 2507 | Harmar D. Denny Jr. | Q5659063 | kg:/m/0f6r19 | Harmar | Denny | 1886-07-02 | M | 12138 | Denny | Jr. | |||||||||||||||
D000256 | Stanley Dent | D000256 | 403394 | 2514 | S. Hubert Dent Jr. | Q1592720 | kg:/m/02rk26s | Stanley | Dent | 1869-08-16 | M | 12147 | Hubert | Jr. | |||||||||||||||
D000259 | Jeremiah Denton | D000259 | 403397 | 14901 | Jeremiah Denton | Q731680 | kg:/m/036x4p | Jeremiah | Denton | 1924-07-15 | M | Andrew | Jr. | 01316 | |||||||||||||||
D000267 | Butler Derrick | D000267 | 403403 | 14212 | Butler Derrick | Q745814 | kg:/m/0265rj1 | Butler | Derrick | 1936-09-30 | M | 12159 | Carson | Jr. | 00289 | ||||||||||||||
D000338 | Martin Dies | D000338 | 403456 | 2588 | Martin Dies Jr. | Q1903625 | kg:/m/03s76b | Martin | Dies | 1900-11-05 | M | 12246 | Jr. | ||||||||||||||||
D000344 | Charles Diggs | D000344 | 403462 | 2594 | Charles Diggs | Q1064126 | kg:/m/0dx37n | Charles | Diggs | 1922-12-02 | M | 12254 | Coles | Jr. | 00298 | ||||||||||||||
D000346 | Paul Dillingham | D000346 | 403464 | 2596 | Paul Dillingham | Q885200 | kg:/m/02r7h13 | Paul | Dillingham | 1799-08-10 | M | 12257 | Jr. | ||||||||||||||||
D000352 | Davis Dimock | D000352 | 403470 | 2602 | Davis Dimock Jr. | Q5241888 | kg:/m/026tbp6 | Davis | Dimock | 1801-09-17 | M | 12263 | Jr. | ||||||||||||||||
D000356 | Nelson Dingley | D000356 | 403473 | 2606 | Nelson Dingley Jr. | Q370284 | kg:/m/045191 | Nelson | Dingley | 1832-02-15 | M | 12270 | Jr. | ||||||||||||||||
D000440 | John Dorsey | D000440 | 403550 | 2677 | John Lloyd Dorsey Jr. | Q1700869 | kg:/m/055hg7 | John | Dorsey | 1891-08-10 | M | 12382 | Lloyd | Jr. | |||||||||||||||
D000533 | John Duncan | D000533 | 400116 | 15455 | Jimmy Duncan (politician) | Q653994 | kg:/m/0450rl | John | Duncan | 1947-07-21 | M | 12493 | J. | Jimmy | Jr. | 00322 | 6114 | 27069 | John J. Duncan, Jr. | N00003209 | [ "H8TN02069" ] |
228 | [ { "name": "John James Duncan", "relation": "son" } ] |
||||||
D000564 | Allan Durborow | D000564 | 403667 | 2785 | Allan C. Durborow Jr. | Q4476222 | kg:/m/02rk8th | Allan | Durborow | 1857-11-10 | M | 12529 | Cathcart | Jr. | |||||||||||||||
D000625 | Daniel Donovan | D000625 | 412672 | 21560 | Dan Donovan (politician) | Q5217998 | kg:/m/0c036qd | Daniel | Donovan | 1956-11-06 | M | M. | Daniel Donovan (New York) | Jr. | 02293 | 74763 | 127760 | Daniel M. Donovan, Jr. | N00036928 | [ "H6NY11174" ] |
2161 | ||||||||
E000011 | Jonas Earll | E000011 | 403707 | 2817 | Jonas Earll Jr. | Q6272064 | kg:/m/02rkt0p | Jonas | Earll | M | 12615 | Jr. | |||||||||||||||||
E000093 | Robert Ehrlich | E000093 | 400523 | 29529 | Bob Ehrlich | Q888007 | kg:/m/027_zq | Robert | Ehrlich | 1957-11-25 | M | 12713 | L. | Jr. | 00340 | N00001925 | |||||||||||||
E000167 | Smith Ely | E000167 | 403858 | 2955 | Smith Ely Jr. | Q1193094 | kg:/m/02sbdv | Smith | Ely | 1825-04-17 | M | 12797 | Jr. | ||||||||||||||||
E000184 | Glenn English | E000184 | 403873 | 14219 | Glenn English | Q1313130 | kg:/m/07v5gv | Glenn | English | 1940-11-30 | M | 12822 | Lee | Jr. | 00345 | ||||||||||||||
E000211 | Samuel Ervin | E000211 | 403898 | 2987 | Sam Ervin | Q322911 | kg:/m/02kly2 | Samuel | Ervin | 1896-09-27 | M | 12860 | James | Jr. | 01326 | ||||||||||||||
E000228 | George Eustis | E000228 | 403913 | 2999 | George Eustis Jr. | Q1507318 | kg:/m/0dd4bq | George | Eustis | 1828-09-28 | M | 12884 | Jr. | ||||||||||||||||
E000248 | Joshua Evans | E000248 | 403931 | 3014 | Joshua Evans Jr. | Q6289786 | kg:/m/026xqdm | Joshua | Evans | 1777-01-20 | M | 12906 | Jr. | ||||||||||||||||
E000258 | Thomas Evans | E000258 | 403939 | 14417 | Thomas B. Evans Jr. | Q2422171 | kg:/m/06t6k4 | Thomas | Evans | 1931-11-05 | M | 12918 | Beverley | Jr. | 00363 | ||||||||||||||
F000053 | Victor Fazio | F000053 | 404013 | 14624 | Vic Fazio | Q2522387 | kg:/m/09lysg | Victor | Fazio | 1942-10-11 | M | 13032 | Herbert | Jr. | 00374 | ||||||||||||||
F000111 | Jack Fields | F000111 | 404068 | 14822 | Jack Fields | Q743157 | kg:/m/0dygxz | Jack | Fields | 1952-02-03 | M | 13114 | Milton | Jr. | 00380 | ||||||||||||||
F000141 | Hamilton Fish | F000141 | 404097 | 12013 | Hamilton Fish IV | Q5644938 | kg:/m/078y88 | Hamilton | Fish | 1926-06-03 | M | 13149 | Jr. | 00384 | |||||||||||||||
F000191 | John Flannagan | F000191 | 404146 | 3207 | John W. Flannagan Jr. | Q1698689 | kg:/m/02qdbkj | John | Flannagan | 1885-02-20 | M | 13211 | William | Jr. | |||||||||||||||
F000229 | John Flynt | F000229 | 404184 | 3242 | John Flynt | Q1700604 | kg:/m/0ksgv_ | John | Flynt | 1914-11-08 | M | 13259 | James | Jr. | 00394 | ||||||||||||||
F000242 | Walter Folger | F000242 | 404196 | 3252 | Walter Folger Jr. | Q1315384 | kg:/m/02rj_1p | Walter | Folger | 1765-06-12 | M | 13279 | Jr. | ||||||||||||||||
F000252 | Wallace Foote | F000252 | 404206 | 3261 | Wallace T. Foote Jr. | Q7962904 | kg:/m/02rkxjb | Wallace | Foote | 1864-04-07 | M | 13292 | Turner | Jr. |
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);