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_house_history
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
M000633 | Return Meigs | M000633 | 407620 | 6408 | Return J. Meigs Jr. | Q744819 | kg:/m/0340r0 | Return | Meigs | 1764-11-17 | M | Jonathan | Jr. | ||||||||||||||||
B001137 | James Burrill | B001137 | 402080 | 1305 | James Burrill Jr. | Q382718 | kg:/m/04rpwj | James | Burrill | 1772-04-25 | M | Jr. | |||||||||||||||||
H000411 | William Haywood | H000411 | 405278 | 4250 | William Henry Haywood Jr. | Q5794515 | kg:/m/02kl5v | William | Haywood | 1801-10-23 | M | Henry | Jr. | ||||||||||||||||
W000308 | James Westcott | W000308 | 411472 | 9966 | James Westcott | Q1681287 | kg:/m/08_y9c | James | Westcott | 1802-05-10 | M | Diament | Jr. | ||||||||||||||||
C000348 | James Chesnut | C000348 | 402487 | 1686 | James Chesnut Jr. | Q1680158 | kg:/m/09lvq5 | James | Chesnut | 1815-01-18 | M | Jr. | |||||||||||||||||
C000480 | Clement Clay | C000480 | 402618 | 1808 | Clement Claiborne Clay | Q928988 | kg:/m/03gcq7 | Clement | Clay | 1816-12-13 | M | Claiborne | Jr. | ||||||||||||||||
B000248 | James Bayard | B000248 | 401242 | 525 | James A. Bayard Jr. | Q1665539 | kg:/m/063vrc | James | Bayard | 1799-11-15 | M | Asheton | Jr. | ||||||||||||||||
M001090 | Edward Murphy | M001090 | 408054 | 6806 | Edward Murphy Jr. | Q945610 | kg:/m/09wnxg | Edward | Murphy | 1836-12-15 | M | Jr. | |||||||||||||||||
S000561 | James Smith | S000561 | 410043 | 8641 | James Smith Jr. | Q6143301 | kg:/m/0b35xd | James | Smith | 1851-06-12 | M | Jr. | |||||||||||||||||
P000141 | John Patton | P000141 | 408547 | 7263 | John Patton Jr. | Q1701353 | kg:/m/03ksgn | John | Patton | 1850-10-30 | M | Jr. | |||||||||||||||||
B000670 | Jonathan Bourne | B000670 | 401632 | 885 | Jonathan Bourne Jr. | Q374906 | kg:/m/0d8sqr | Jonathan | Bourne | 1855-02-23 | M | Jr. | |||||||||||||||||
H000919 | Charles Hughes | H000919 | 405764 | 4698 | Charles J. Hughes Jr. | Q1064997 | kg:/m/0b9yhl | Charles | Hughes | 1853-02-16 | M | James | Jr. | ||||||||||||||||
S000073 | Willard Saulsbury | S000073 | 409585 | 8224 | Willard Saulsbury Jr. | Q1394349 | kg:/m/07nwwm | Willard | Saulsbury | 1861-04-17 | M | Jr. | |||||||||||||||||
C000063 | Johnson Camden | C000063 | 402221 | 1433 | Johnson N. Camden Jr. | Q5601297 | kg:/m/09wb62 | Johnson | Camden | 1865-01-05 | M | Newlon | Jr. | ||||||||||||||||
B000252 | Thomas Bayard | B000252 | 401246 | 529 | Thomas F. Bayard Jr. | Q1691899 | kg:/m/06vw0f | Thomas | Bayard | 1868-06-04 | M | Francis | Jr. | ||||||||||||||||
B000053 | David Baird | B000053 | 401058 | 355 | David Baird Jr. | Q4454634 | kg:/m/0bcr0h | David | Baird | 1881-10-10 | M | Jr. | |||||||||||||||||
T000335 | John Townsend | T000335 | 410906 | 9439 | John G. Townsend Jr. | Q434691 | kg:/m/06vw4r | John | Townsend | 1871-05-31 | M | Gillis | Jr. | ||||||||||||||||
G000159 | Ernest Gibson | G000159 | 404526 | 3559 | Ernest W. Gibson Jr. | Q885614 | kg:/m/0cw1s9 | Ernest | Gibson | 1901-03-06 | M | William | Jr. | ||||||||||||||||
L000005 | Robert La Follette | L000005 | 406515 | 5402 | Robert M. La Follette Jr. | Q377506 | kg:/m/01sv50 | Robert | La Follette | 1895-02-06 | M | Marion | Jr. | ||||||||||||||||
L000394 | Henry Lodge | L000394 | 406886 | 5739 | Henry Cabot Lodge Jr. | Q450984 | kg:/m/013zk9 | Henry | Lodge | 1902-07-05 | M | Cabot | Jr. | ||||||||||||||||
F000356 | Joseph Frear | F000356 | 404303 | 3349 | J. Allen Frear Jr. | Q377842 | kg:/m/07nt00 | Joseph | Frear | 1903-03-07 | M | Allen | Jr. | ||||||||||||||||
H000665 | John Hoblitzell | H000665 | 405520 | 4473 | John D. Hoblitzell Jr. | Q1699723 | kg:/m/06ln04 | John | Hoblitzell | 1912-12-30 | M | Dempsey | Jr. | ||||||||||||||||
M001100 | Maurice Murphy | M001100 | 408064 | 10815 | Maurice J. Murphy Jr. | Q5997815 | kg:/m/08v652 | Maurice | Murphy | 1927-10-03 | M | J. | Jr. | ||||||||||||||||
S000739 | William Spong | S000739 | 410208 | 11206 | William Spong Jr. | Q6329296 | kg:/m/053s_8 | William | Spong | 1920-09-29 | M | Belser | Jr. | ||||||||||||||||
R000536 | Richard Russell | R000536 | 409493 | 8138 | Richard Russell Jr. | Q718415 | kg:/m/0268my | Richard | Russell | 1897-11-02 | M | Brevard | Jr. | ||||||||||||||||
B001209 | Harry Byrd | B001209 | 402149 | 10802 | Harry F. Byrd Jr. | Q3268711 | kg:/m/03667s | Harry | Byrd | 1914-12-20 | M | Flood | Jr. | 01300 | |||||||||||||||
H000675 | Kaneaster Hodges | H000675 | 405529 | 14514 | Kaneaster Hodges Jr. | Q457458 | kg:/m/05_6s3 | Kaneaster | Hodges | 1938-08-20 | M | Jr. | 01360 | ||||||||||||||||
H000953 | Hubert Humphrey | H000953 | 405797 | 4728 | Hubert Humphrey | Q209989 | kg:/m/0bq6m | Hubert | Humphrey | 1911-05-27 | M | Horatio | Jr. | 01366 | |||||||||||||||
B000063 | Howard Baker | B000063 | 401067 | 11200 | Howard Baker | Q1337643 | kg:/m/021kgt | Howard | Baker | 1925-11-15 | M | Henry | Jr. | 01275 | |||||||||||||||
D000259 | Jeremiah Denton | D000259 | 403397 | 14901 | Jeremiah Denton | Q731680 | kg:/m/036x4p | Jeremiah | Denton | 1924-07-15 | M | Andrew | Jr. | 01316 | |||||||||||||||
C000356 | Lawton Chiles | C000356 | 402495 | 13101 | Lawton Chiles | Q744098 | kg:/m/027165 | Lawton | Chiles | 1930-04-03 | M | Mainor | Jr. | 01304 | |||||||||||||||
J000189 | John Johnston | J000189 | 406084 | 14107 | J. Bennett Johnston | Q4889708 | kg:/m/03bfd1 | John | Johnston | 1932-06-10 | M | Bennett | Jr. | 01373 | S054 | ||||||||||||||
G000236 | John Glenn | G000236 | 404598 | 14304 | John Glenn | Q182642 | kg:/m/0g0yh | John | Glenn | 1921-07-18 | M | Herschel | Jr. | 01339 | S035 | ||||||||||||||
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" ] |
|||||||||
K000374 | Paul Kirk | K000374 | 412381 | 40912 | Paul G. Kirk | Q1363487 | kg:/m/0896g7 | Paul | Kirk | 1938-01-18 | M | G. | Jr. | 01972 | 116298 | S334 | N00031303 | ||||||||||||
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 | ||||||||
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 | ||||||
P000604 | Donald Payne | P000604 | 412506 | 31103 | Donald Payne Jr. | Q1240224 | kg:/m/0jwr2v8 | Donald | Payne | 1958-12-17 | M | M. | Donald Payne Jr. | Jr. | 02097 | 65639 | 90668 | Donald M. Payne, Jr. | N00034639 | [ "H2NJ10154" ] |
1687 | [ { "name": "Donald Milford Payne", "relation": "son" } ] |
|||||||
K000383 | Angus King | K000383 | 412545 | 41300 | Angus King | Q544464 | kg:/m/02hfx0 | Angus | King | 1944-03-31 | M | S. | Angus King | Jr. | 02185 | 37413 | 22381 | S363 | Angus S. King, Jr. | N00034580 | [ "S2ME00109" ] |
1769 | |||||||
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 | ||||||||
L000586 | Al Lawson | L000586 | 412693 | 21732 | Al Lawson | Q4723052 | kg:/m/03cg0sv | Al | Lawson | 1948-09-23 | M | Alfred Lawson | Jr. | 90480 | 24263 | Al Lawson, Jr. | N00030642 | [ "H0FL02086" ] |
2205 | ||||||||||
C001054 | Jerry Carl | C001054 | 456799 | Jerry Carl | Q102277702 | kg:/g/11j2j1brnb | Jerry | Carl | 1958-06-17 | M | Lee | Jr. | Jerry L. Carl | N00044245 | [ "H0AL01055" ] |
||||||||||||||
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 | |||||||
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. | |||||||||||||||
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. | |||||||||||||||
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 | ||||||||||||||
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. | ||||||||||||||||
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. | |||||||||||||||
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. | ||||||||||||||||
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 | |||||||
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 | ||||||||||||||
C000353 | Thomas Child | C000353 | 402492 | 1691 | Thomas Child Jr. | Q1193423 | kg:/m/02rkx0j | Thomas | Child | 1818-03-22 | M | 10897 | Jr. | ||||||||||||||||
C000421 | Amos Clark | C000421 | 402560 | 1753 | Amos Clark Jr. | Q183577 | kg:/m/02rw_hg | Amos | Clark | 1828-11-08 | M | 10978 | 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);