legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
384 rows where name_suffix = "Jr." sorted by id
This data as json, copyable, CSV (advanced)
Suggested facets: name_nickname, bio_birthday (date), id_fec (array)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A000044 | Robert Adams | A000044 | 400705 | 36 | Robert Adams Jr. | Q7341350 | kg:/m/0dhs2_ | Robert | Adams | 1849-02-26 | M | 8315 | Jr. | ||||||||||||||||
A000095 | James Alexander | A000095 | 400753 | 83 | James Alexander Jr. | Q6128502 | kg:/m/0269r6l | James | Alexander | 1789-10-17 | M | 8390 | Jr. | ||||||||||||||||
A000103 | William Alexander | A000103 | 400761 | 12000 | William Vollie Alexander Jr. | Q861905 | kg:/m/08j19v | William | Alexander | 1934-01-16 | M | 8401 | Vollie | Bill | Jr. | 00010 | |||||||||||||
A000133 | John Allen | A000133 | 400789 | 116 | John J. Allen Jr. | Q1700644 | kg:/m/0ktcpm | John | Allen | 1899-11-27 | M | 8445 | Joseph | Jr. | |||||||||||||||
A000157 | James Allison | A000157 | 400812 | 138 | James Allison Jr. | Q6128654 | kg:/m/027gbjp | James | Allison | 1772-10-04 | M | 8473 | Jr. | ||||||||||||||||
A000163 | James Almond | A000163 | 400818 | 144 | J. Lindsay Almond | Q777975 | kg:/m/04hsqf | James | Almond | 1898-06-15 | M | 8482 | Lindsay | Jr. | |||||||||||||||
A000170 | Jerome Ambro | A000170 | 400825 | 14200 | Jerome Ambro | Q499875 | kg:/m/04mq5_ | Jerome | Ambro | 1928-06-27 | M | 8492 | Anthony | Jr. | 00014 | ||||||||||||||
A000213 | Beryl Anthony | A000213 | 400898 | 14601 | Beryl Anthony Jr. | Q829269 | kg:/m/02pv4nd | Beryl | Anthony | 1938-02-21 | M | 8556 | Franklin | Jr. | 00024 | ||||||||||||||
A000230 | Richard Anderson | A000230 | 400857 | 179 | Richard Clough Anderson Jr. | Q2149242 | kg:/m/07jm8p | Richard | Anderson | 1788-08-04 | M | 8586 | Clough | Jr. | |||||||||||||||
A000240 | Abram Andrew | A000240 | 400869 | 189 | A. Piatt Andrew | Q331023 | kg:/m/0b7sbq | Abram | Andrew | 1873-02-12 | M | 8599 | Piatt | Jr. | |||||||||||||||
A000261 | Daniel Anthony | A000261 | 400899 | 211 | Daniel Read Anthony Jr. | Q1162274 | kg:/m/06dtzs | Daniel | Anthony | 1870-08-22 | M | 8629 | Read | Jr. | |||||||||||||||
A000282 | John Armstrong | A000282 | 400922 | 233 | John Armstrong Jr. | Q1381657 | kg:/m/02j18m | John | Armstrong | 1758-11-25 | M | 8656 | Jr. | ||||||||||||||||
A000301 | John Arnot | A000301 | 400943 | 253 | John Arnot Jr. | Q6219444 | kg:/m/02rkr_p | John | Arnot | 1831-03-11 | M | 8679 | Jr. | ||||||||||||||||
B000026 | George Baer | B000026 | 401031 | 332 | George Baer Jr. | Q1203647 | kg:/m/09jkw8 | George | Baer | M | 8807 | Jr. | |||||||||||||||||
B000033 | John Bagley | B000033 | 401038 | 337 | John H. Bagley Jr. | Q3090731 | kg:/m/026gsj8 | John | Bagley | 1832-11-26 | M | 8817 | Holroyd | Jr. | |||||||||||||||
B000045 | Joseph Bailey | B000045 | 401050 | 348 | Joseph Weldon Bailey Jr. | Q1708222 | kg:/m/02w93dd | Joseph | Bailey | 1892-12-15 | M | 8831 | Weldon | Jr. | |||||||||||||||
B000053 | David Baird | B000053 | 401058 | 355 | David Baird Jr. | Q4454634 | kg:/m/0bcr0h | David | Baird | 1881-10-10 | M | Jr. | |||||||||||||||||
B000063 | Howard Baker | B000063 | 401067 | 11200 | Howard Baker | Q1337643 | kg:/m/021kgt | Howard | Baker | 1925-11-15 | M | Henry | Jr. | 01275 | |||||||||||||||
B000092 | John Baldwin | B000092 | 401094 | 387 | John F. Baldwin Jr. | Q1700005 | kg:/m/02rhj_6 | John | Baldwin | 1915-06-28 | M | 8893 | Finley | Jr. | |||||||||||||||
B000120 | Hiram Barber | B000120 | 401121 | 413 | Hiram Barber Jr. | Q4419865 | kg:/m/02rk9xx | Hiram | Barber | 1835-03-24 | M | 8926 | Jr. | ||||||||||||||||
B000129 | John Barbour | B000129 | 401130 | 422 | John S. Barbour Jr. | Q5565647 | kg:/m/04ld0m | John | Barbour | 1820-12-29 | M | 8936 | Strode | Jr. | |||||||||||||||
B000141 | Walter Baring | B000141 | 401142 | 433 | Walter S. Baring Jr. | Q1716012 | kg:/m/02730wb | Walter | Baring | 1911-09-09 | M | 8952 | Stephan | Jr. | |||||||||||||||
B000143 | David Barker | B000143 | 401144 | 435 | David Barker Jr. | Q1173652 | kg:/m/02rhf0n | David | Barker | 1797-01-08 | M | 8955 | Jr. | ||||||||||||||||
B000153 | Druie Barnard | B000153 | 401155 | 14404 | Doug Barnard Jr. | Q1251700 | kg:/m/026jt6m | Druie | Barnard | 1922-03-20 | M | 8967 | Douglas | Jr. | 00054 | ||||||||||||||
B000207 | Josiah Bartlett | B000207 | 401206 | 491 | Josiah Bartlett Jr. | Q1708618 | kg:/m/0d8v8f | Josiah | Bartlett | 1768-08-29 | M | 9040 | Jr. | ||||||||||||||||
B000209 | Thomas Bartlett | B000209 | 401207 | 492 | Thomas Bartlett Jr. | Q2422254 | kg:/m/02rjznz | Thomas | Bartlett | 1808-06-18 | M | 9043 | Jr. | ||||||||||||||||
B000245 | Albert Baumhart | B000245 | 401239 | 521 | Albert David Baumhart Jr. | Q4710010 | kg:/m/027m6z7 | Albert | Baumhart | 1908-06-15 | M | 9096 | David | Jr. | |||||||||||||||
B000248 | James Bayard | B000248 | 401242 | 525 | James A. Bayard Jr. | Q1665539 | kg:/m/063vrc | James | Bayard | 1799-11-15 | M | Asheton | Jr. | ||||||||||||||||
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. |
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);