legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by id_wikidata descending
This data as json, copyable, CSV (advanced)
Suggested facets: bio_gender, id_bioguide_previous (array), id_fec (array)
bio_birthday (date) >30 ✖
- 1802-06-12 4
- 1818-10-08 4
- 1898-04-12 4
- 1786-12-25 3
- 1789-10-20 3
- 1807-02-17 3
- 1808-02-11 3
- 1808-06-18 3
- 1808-09-21 3
- 1811-01-06 3
- 1811-11-11 3
- 1813-10-13 3
- 1813-12-25 3
- 1815-01-18 3
- 1817-04-22 3
- 1819-01-22 3
- 1821-04-12 3
- 1825-04-17 3
- 1826-10-08 3
- 1828-12-16 3
- 1829-03-02 3
- 1829-08-07 3
- 1836-11-15 3
- 1840-01-01 3
- 1841-04-08 3
- 1844-08-01 3
- 1847-09-10 3
- 1848-10-04 3
- 1850-08-25 3
- 1851-02-07 3
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
C000321 | William Chappell | C000321 | 402463 | 12007 | Bill Chappell | Q999912 | kg:/m/02rk020 | William | Chappell | 1922-02-03 | M | 10856 | Venroe | Jr. | 00191 | ||||||||||||||
B001008 | John Buchanan | B001008 | 401958 | 10706 | John Hall Buchanan Jr. | Q999881 | kg:/m/02qj8c1 | John | Buchanan | 1928-03-19 | M | 10078 | Hall | Jr. | 00143 | ||||||||||||||
W000025 | John Wait | W000025 | 411204 | 9717 | John T. Wait | Q998852 | kg:/m/02rhklt | John | Wait | 1811-08-27 | M | 23248 | Turner | ||||||||||||||||
J000047 | Craig James | J000047 | 405952 | 15608 | Craig James (politician) | Q998327 | kg:/m/026j721 | Craig | James | 1941-05-05 | M | 15749 | T. | 00590 | |||||||||||||||
S001086 | William Sutphin | S001086 | 410539 | 9098 | William H. Sutphin | Q997295 | kg:/m/0721_d | William | Sutphin | 1887-08-30 | M | 22482 | Halstead | ||||||||||||||||
F000152 | Ovie Fisher | F000152 | 404107 | 3171 | O. C. Fisher | Q996971 | kg:/m/047m_j | Ovie | Fisher | 1903-11-22 | M | 13160 | Clark | 00386 | |||||||||||||||
H000261 | Albert Harrison | H000261 | 405138 | 4122 | Albert Galliton Harrison | Q996927 | kg:/m/02rz5d9 | Albert | Harrison | 1800-06-26 | M | 14607 | Galliton | ||||||||||||||||
C000803 | James Cottrell | C000803 | 402922 | 2088 | James La Fayette Cottrell | Q995891 | kg:/m/02rkzfk | James | Cottrell | 1808-08-25 | M | 11461 | La Fayette | ||||||||||||||||
C000218 | William Cary | C000218 | 402364 | 1567 | William J. Cary | Q995498 | kg:/m/02vrq0q | William | Cary | 1865-03-22 | M | 10727 | Joseph | ||||||||||||||||
D000574 | John Durkin | D000574 | 403677 | 14310 | John A. Durkin | Q995271 | kg:/m/061wy0 | John | Durkin | 1936-03-29 | M | Anthony | 01322 | ||||||||||||||||
W000682 | Howard Wolpe | W000682 | 411834 | 14673 | Howard Wolpe | Q995192 | kg:/m/04zr6n | Howard | Wolpe | 1939-11-03 | M | 24029 | Eliot | III | 01240 | ||||||||||||||
C000240 | Bryant Castellow | C000240 | 402385 | 1589 | Bryant Thomas Castellow | Q995149 | kg:/m/0gt6dw | Bryant | Castellow | 1876-07-29 | M | 10756 | Thomas | ||||||||||||||||
Y000030 | Bryan Young | Y000030 | 411964 | 10436 | Bryan Young (politician) | Q995099 | kg:/m/08w85l | Bryan | Young | 1800-01-14 | M | 21066 | Rust | ||||||||||||||||
O000162 | Bryan Owsley | O000162 | 408412 | 7140 | Bryan Owsley | Q995078 | kg:/m/02qhbt4 | Bryan | Owsley | 1798-08-19 | M | 19266 | Young | ||||||||||||||||
M000061 | Bryan Mahan | M000061 | 407089 | 5920 | Bryan F. Mahan | Q994997 | kg:/m/02rhcx6 | Bryan | Mahan | 1856-05-01 | M | 17403 | Francis | ||||||||||||||||
C000479 | Brutus Clay | C000479 | 402617 | 1807 | Brutus J. Clay | Q994860 | kg:/m/02rhcwj | Brutus | Clay | 1808-07-01 | M | 11046 | Junius | ||||||||||||||||
S000408 | Eugene Siler | S000408 | 409902 | 8508 | Eugene Siler | Q994369 | kg:/m/0gc_7j | Eugene | Siler | 1900-06-26 | M | 21645 | |||||||||||||||||
W000503 | Henry Williams | W000503 | 411660 | 10148 | Henry Williams (Massachusetts politician) | Q993376 | kg:/m/02rl4d1 | Henry | Williams | 1805-11-30 | M | 23813 | |||||||||||||||||
K000041 | Frank Keefe | K000041 | 406211 | 5119 | Frank Bateman Keefe | Q992779 | kg:/m/02719l1 | Frank | Keefe | 1887-09-23 | M | 16129 | Bateman | ||||||||||||||||
R000119 | James Reed | R000119 | 409099 | 7787 | James B. Reed | Q992633 | kg:/m/02rhj3c | James | Reed | 1881-01-02 | M | 20228 | Byron | ||||||||||||||||
W000448 | Charles Wiggins | W000448 | 411605 | 11055 | Charles E. Wiggins | Q992029 | kg:/m/02rhd5v | Charles | Wiggins | 1927-12-03 | M | 23749 | Edward | 01228 | |||||||||||||||
S000723 | George Spencer | S000723 | 410192 | 8783 | George E. Spencer | Q991879 | kg:/m/03glvz | George | Spencer | 1836-11-01 | M | Eliphaz | |||||||||||||||||
M000992 | Bruce Morrison | M000992 | 407960 | 15045 | Bruce Morrison | Q991746 | kg:/m/098ypx | Bruce | Morrison | 1944-10-08 | M | 18570 | Andrew | 00835 | |||||||||||||||
S000565 | John Smith | S000565 | 410049 | 8648 | John Smith (Vermont politician) | Q991529 | kg:/m/02pv19v | John | Smith | 1789-08-12 | M | 21834 | |||||||||||||||||
A000106 | Bruce Alger | A000106 | 400764 | 93 | Bruce Alger | Q991452 | kg:/m/0c4v9n | Bruce | Alger | 1918-06-12 | M | 8406 | Reynolds | ||||||||||||||||
S000400 | Solomon Sibley | S000400 | 409894 | Solomon Sibley | Q991360 | kg:/m/03pksm | Solomon | Sibley | 1769-10-07 | M | 21635 | ||||||||||||||||||
E000095 | Anthony Eickhoff | E000095 | 403786 | 2885 | Anthony Eickhoff | Q99070 | kg:/m/0cym63 | Anthony | Eickhoff | 1827-09-11 | M | 12715 | |||||||||||||||||
C000850 | John Cradlebaugh | C000850 | 402966 | John Cradlebaugh | Q989852 | kg:/m/0265pjz | John | Cradlebaugh | 1819-02-22 | M | 11519 | ||||||||||||||||||
C000181 | Chester Carrier | C000181 | 402328 | 1532 | Chester O. Carrier | Q989723 | kg:/m/02rhdnm | Chester | Carrier | 1897-05-05 | M | 10679 | Otto | ||||||||||||||||
C000474 | David Classon | C000474 | 402612 | 1804 | David G. Classon | Q989536 | kg:/m/02vrq1r | David | Classon | 1870-09-27 | M | 11040 | Guy | ||||||||||||||||
C001039 | Katherine Cammack | C001039 | 456806 | Kat Cammack | Q98523243 | kg:/g/11fsp_lppx | Katherine | Cammack | 1988-02-16 | F | Kat | Kat Cammack | N00045978 | [ "H0FL03175" ] |
|||||||||||||||
L000084 | William Lanning | L000084 | 406593 | 5466 | William M. Lanning | Q985191 | kg:/m/02vn_cz | William | Lanning | 1849-01-01 | M | 16697 | Mershon | ||||||||||||||||
S001168 | John Sarbanes | S001168 | 412212 | 20724 | John Sarbanes | Q984509 | kg:/m/08_r8n | John | Sarbanes | 1962-05-22 | M | 22592 | P. | John Sarbanes | 01854 | 1022884 | 66575 | John P. Sarbanes | N00027751 | [ "H6MD03292" ] |
697 | [ { "name": "Senator Paul Sarbanes", "relation": "son" } ] |
|||||||
W000092 | Malcolm Wallop | W000092 | 411271 | 14511 | Malcolm Wallop | Q984376 | kg:/m/05bz0l | Malcolm | Wallop | 1933-02-27 | M | 01451 | S119 | ||||||||||||||||
C000121 | Joseph Cannon | C000121 | 402272 | 1483 | Joseph Gurney Cannon | Q984248 | kg:/m/04472 | Joseph | Cannon | 1836-05-07 | M | 10600 | Gurney | ||||||||||||||||
S001169 | Joe Sestak | S001169 | 412232 | 20744 | Joe Sestak | Q984183 | kg:/m/0bcy7w | Joe | Sestak | 1951-12-12 | M | 22594 | Joe Sestak | 01874 | 1020918 | 58333 | N00028049 | [ "H6PA07105" ] |
|||||||||||
H000114 | Lee Hamilton | H000114 | 404996 | 10732 | Lee H. Hamilton | Q984174 | kg:/m/02sg9x | Lee | Hamilton | 1931-04-20 | M | 14426 | Herbert | 00489 | |||||||||||||||
L000083 | James Lanman | L000083 | 406592 | 5465 | James Lanman | Q984116 | kg:/m/05g9y6 | James | Lanman | 1767-06-14 | M | ||||||||||||||||||
G000415 | Robert Green | G000415 | 404763 | 3781 | Robert A. Green | Q984102 | kg:/m/02rjyhh | Robert | Green | 1892-02-10 | M | 14093 | Alexis | Lex | |||||||||||||||
P000523 | David Price | P000523 | 400326 | 15438 | David Price (American politician) | Q984010 | kg:/m/034dxn | David | Price | 1940-08-17 | M | 19927 | E. | David Price | 00930 | 6748 | 119 | David E. Price | N00002260 | [ "H6NC04037" ] |
420 | ||||||||
G000596 | Marjorie Greene | G000596 | 456814 | Marjorie Taylor Greene | Q98380406 | kg:/g/11fscs046n | Marjorie | Greene | 1974-05-27 | F | Taylor | Marjorie Taylor Greene | Marjorie Taylor Greene | N00044701 | [ "H0GA06192" ] |
||||||||||||||
C000826 | Charles Cowles | C000826 | 402944 | 2107 | Charles H. Cowles | Q983787 | kg:/m/027pd6l | Charles | Cowles | 1875-07-16 | M | 11490 | Holden | ||||||||||||||||
J000288 | Henry Johnson | J000288 | 412199 | 20712 | Hank Johnson | Q983537 | kg:/m/0flgyy | Henry | Johnson | 1954-10-02 | M | 16065 | C. | Hank | Henry C. Johnson, Jr. | Jr. | 01843 | 1020576 | 68070 | Henry C. "Hank" Johnson, Jr. | N00027848 | [ "H6GA04129" ] |
686 | ||||||
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 | ||||||
L000419 | Jefferson Long | L000419 | 406910 | 5759 | Jefferson F. Long | Q983531 | kg:/m/0fp_zh | Jefferson | Long | 1836-03-03 | M | 17115 | Franklin | ||||||||||||||||
S000948 | Louis Stokes | S000948 | 410407 | 12030 | Louis Stokes | Q983528 | kg:/m/035fy1 | Louis | Stokes | 1925-02-23 | M | 22311 | 01115 | ||||||||||||||||
W000207 | Melvin Watt | W000207 | 400424 | 29383 | Mel Watt | Q983446 | kg:/m/025kl3 | Melvin | Watt | 1945-08-26 | M | 23463 | L. | Mel | Melvin L. Watt | 01207 | 25889 | 26997 | Melvin L. Watt | N00002328 | [ "H2NC12021" ] |
509 | |||||||
J000070 | William Jefferson | J000070 | 400201 | 29120 | William J. Jefferson | Q983443 | kg:/m/025jsy | William | Jefferson | 1947-03-14 | M | 15783 | J. | 00592 | N00005353 | [ "H0LA02119" ] |
|||||||||||||
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 | |||||||
C001085 | Hansen Clarke | C001085 | 412440 | 21145 | Hansen Clarke | Q983425 | kg:/m/02py41_ | Hansen | Clarke | 1957-03-02 | M | 11827 | 02030 | 19913 | Hansen Clarke | N00031945 | [ "H0MI13398" ] |
||||||||||||
K000366 | Ron Klein | K000366 | 412198 | 20711 | Ron Klein | Q983253 | kg:/m/08cv1r | Ron | Klein | 1957-07-10 | M | 16556 | 01842 | 55563 | 24261 | N00027515 | [ "H6FL22040" ] |
||||||||||||
W000509 | James Williams | W000509 | 411666 | 10154 | James Wray Williams | Q983225 | kg:/m/02rhjl4 | James | Williams | 1792-10-08 | M | 23820 | Wray | ||||||||||||||||
H000126 | Edward Hammond | H000126 | 405008 | 4005 | Edward Hammond (politician) | Q983175 | kg:/m/02qw0t8 | Edward | Hammond | 1812-03-17 | M | 14441 | |||||||||||||||||
V000057 | Joshua Van Sant | V000057 | 411099 | 9633 | Joshua Van Sant | Q983173 | kg:/m/02rj060 | Joshua | Van Sant | 1803-12-31 | M | 20942 | |||||||||||||||||
W000311 | John Wethered | W000311 | 411475 | 9969 | John Wethered | Q983170 | kg:/m/02rj0bv | John | Wethered | 1809-05-08 | M | 23587 | |||||||||||||||||
W000748 | John Worthington | W000748 | 411897 | 10377 | John Tolley Hood Worthington | Q983168 | kg:/m/02rhklg | John | Worthington | 1788-11-01 | M | 24109 | Tolley Hood | ||||||||||||||||
S000258 | Charles Sewall | S000258 | 409759 | 8375 | Charles S. Sewall | Q983165 | kg:/m/0f0lp5 | Charles | Sewall | M | 21456 | S. | |||||||||||||||||
S000920 | Thomas Stewart | S000920 | 410380 | 8946 | Thomas E. Stewart | Q983149 | kg:/m/02rkx1x | Thomas | Stewart | 1824-09-22 | M | 22276 | Elliott | ||||||||||||||||
W000131 | Elijah Ward | W000131 | 411306 | 9812 | Elijah Ward | Q983147 | kg:/m/078wpg | Elijah | Ward | 1816-09-16 | M | 23368 | |||||||||||||||||
W000314 | Robert Wexler | W000314 | 400430 | 29715 | Robert Wexler | Q983116 | kg:/m/02530r | Robert | Wexler | 1961-01-02 | M | 23591 | 01537 | 882 | N00002905 | [ "H6FL19038" ] |
|||||||||||||
R000409 | Dana Rohrabacher | R000409 | 400343 | 15621 | Dana Rohrabacher | Q983055 | kg:/m/02gtr | Dana | Rohrabacher | 1947-06-21 | M | 20593 | T. | 00979 | 5590 | 26763 | Dana Rohrabacher | N00007151 | [ "H8CA42061" ] |
436 | |||||||||
B000429 | Albert Beveridge | B000429 | 401415 | 683 | Albert J. Beveridge | Q982853 | kg:/m/04sjby | Albert | Beveridge | 1862-10-06 | M | Jeremiah | |||||||||||||||||
M001120 | John Murtha | M001120 | 400286 | 14072 | John Murtha | Q982347 | kg:/m/02_hqc | John | Murtha | 1932-06-17 | M | 18726 | P. | 00844 | 27048 | N00001408 | [ "H6PA12030" ] |
||||||||||||
R000576 | C. Ruppersberger | R000576 | 400349 | 20329 | Dutch Ruppersberger | Q981559 | kg:/m/025k36 | C. | Ruppersberger | 1946-01-31 | M | 20797 | A. Dutch | Dutch Ruppersberger | 01728 | 49155 | 36130 | C. A. Dutch Ruppersberger | N00025482 | [ "H2MD02160" ] |
442 | ||||||||
G000548 | Scott Garrett | G000548 | 400145 | 20336 | Scott Garrett | Q981424 | kg:/m/033f6x | Scott | Garrett | 1959-07-09 | M | 14255 | Scott Garrett | 01737 | 1003601 | 4430 | Scott Garrett | N00000743 | [ "H8NJ05052" ] |
254 | |||||||||
S000522 | Christopher Smith | S000522 | 400380 | 14863 | Chris Smith (New Jersey politician) | Q981167 | kg:/m/033f4d | Christopher | Smith | 1953-03-04 | M | 21787 | H. | Chris | Chris Smith (New Jersey) | 01071 | 6411 | 26952 | Christopher H. Smith | N00009816 | [ "H8NJ04014" ] |
469 | |||||||
B000881 | James Brooks | B000881 | 401838 | 1078 | James Brooks (politician) | Q981166 | kg:/m/02rkr4n | James | Brooks | 1810-11-10 | M | ||||||||||||||||||
W000337 | John Wheeler | W000337 | 411499 | 9991 | John Wheeler (New York politician) | Q981158 | kg:/m/03cnsnk | John | Wheeler | 1823-02-11 | M | 23617 | |||||||||||||||||
M000488 | William McKaig | M000488 | 407483 | 6283 | William McMahon McKaig | Q980963 | kg:/m/0dz8g5 | William | McKaig | 1845-07-29 | M | 17936 | McMahon | ||||||||||||||||
J000007 | David Jackson | J000007 | 405914 | 4845 | David S. Jackson | Q980850 | kg:/m/02rknqq | David | Jackson | M | 15701 | Sherwood | |||||||||||||||||
B001224 | Cori Bush | B001224 | 456829 | Cori Bush | Q98084800 | kg:/g/11cntkcbkt | Cori | Bush | 1976-07-21 | F | Cori Bush | Cori Bush | N00039373 | [ "H8MO01143" ] |
|||||||||||||||
C000680 | Frederick Conkling | C000680 | 402806 | 1983 | Frederick A. Conkling | Q980833 | kg:/m/026c2nv | Frederick | Conkling | 1816-08-22 | M | 11305 | Augustus | ||||||||||||||||
A000210 | Robert Andrews | A000210 | 400008 | 29132 | Rob Andrews | Q980649 | kg:/m/032mpy | Robert | Andrews | 1957-08-04 | M | 8551 | E. | Rob | 00021 | 19670 | 26949 | Robert E. Andrews | N00000826 | [ "H0NJ01066", "S8NJ00392" ] |
131 | ||||||||
C000105 | William Campbell | C000105 | 402258 | 1469 | William W. Campbell (New York politician) | Q980587 | kg:/m/05_dlt | William | Campbell | 1806-06-10 | M | 10576 | W. | ||||||||||||||||
C001052 | Chris Chocola | C001052 | 400072 | 20324 | Chris Chocola | Q980183 | kg:/m/025772 | Chris | Chocola | 1962-02-24 | M | 11772 | 01726 | 34186 | N00012586 | ||||||||||||||
M001069 | Frederick Mulkey | M001069 | 408035 | 6787 | Frederick W. Mulkey | Q979758 | kg:/m/0d4xvw | Frederick | Mulkey | 1874-01-06 | M | William | |||||||||||||||||
M000436 | John McFall | M000436 | 407436 | 6240 | John J. McFall | Q979566 | kg:/m/05clmw | John | McFall | 1918-02-20 | M | 17872 | Joseph | 00770 | |||||||||||||||
K000079 | William Kelly | K000079 | 406248 | 5155 | William Kelly (Alabama politician) | Q979510 | kg:/m/03gb28 | William | Kelly | 1786-09-22 | M | ||||||||||||||||||
W000362 | Compton White | W000362 | 411524 | 10637 | Compton I. White Jr. | Q979283 | kg:/m/06bjv9 | Compton | White | 1920-12-19 | M | 23645 | Ignatius | Jr. | |||||||||||||||
W000798 | Tim Walberg | W000798 | 412213 | 20725 | Tim Walberg | Q978618 | kg:/m/0d7n3m | Tim | Walberg | 1951-04-12 | M | 24179 | Tim Walberg | 01855 | 1022844 | 8618 | Tim Walberg | N00026368 | [ "H4MI07103" ] |
698 | |||||||||
J000083 | Edgar Jenkins | J000083 | 405985 | 14429 | Ed Jenkins (politician) | Q978380 | kg:/m/026jstk | Edgar | Jenkins | 1933-01-04 | M | 15799 | Lanier | Ed | 00595 | ||||||||||||||
L000572 | George LeMieux | L000572 | 412380 | 40911 | George LeMieux | Q978350 | kg:/m/04m_msl | George | LeMieux | 1969-05-21 | M | S. | 01971 | 46456 | 17431 | S333 | N00031304 | [ "S2FL00227" ] |
|||||||||||
S000624 | William Smith | S000624 | 410099 | 8693 | William Smith (Maryland politician) | Q978343 | kg:/m/03nqjd | William | Smith | 1728-04-12 | M | 21907 | |||||||||||||||||
M001147 | Thaddeus McCotter | M001147 | 400260 | 20332 | Thaddeus McCotter | Q977920 | kg:/m/03tkzz | Thaddeus | McCotter | 1965-08-22 | M | 18766 | G. | Thad | 01732 | 19847 | N00013808 | [ "H2MI00037" ] |
|||||||||||
M000092 | Robert Maloney | M000092 | 407116 | 5948 | Robert S. Maloney | Q977821 | kg:/m/0bvdwr | Robert | Maloney | 1881-02-03 | M | 17444 | Sarsfield | ||||||||||||||||
B001149 | Dan Burton | B001149 | 400055 | 15014 | Dan Burton | Q977717 | kg:/m/022r4p | Dan | Burton | 1938-06-21 | M | 10255 | L. | 00154 | 26855 | Dan Burton | N00000010 | [ "H2IN06023" ] |
|||||||||||
M000250 | Spark Matsunaga | M000250 | 407268 | 10605 | Spark Matsunaga | Q977134 | kg:/m/02n9wf | Spark | Matsunaga | 1916-10-08 | M | 17633 | Masayuki | 00749 | S104 | ||||||||||||||
J000295 | David Joyce | J000295 | 412566 | 21353 | David Joyce (politician) | Q976778 | kg:/m/0ktwnp_ | David | Joyce | 1957-03-17 | M | P. | David Joyce | 02154 | 68561 | 143052 | David P. Joyce | N00035007 | [ "H2OH14064" ] |
1790 | |||||||||
R000586 | James Renacci | R000586 | 412462 | 21164 | Jim Renacci | Q976676 | kg:/m/025v2hb | James | Renacci | 1958-12-03 | M | 20813 | B. | Jim Renacci | 02048 | 62686 | 120678 | James B. Renacci | N00031127 | [ "H0OH16097" ] |
1468 | ||||||||
C000641 | Patrick Collins | C000641 | 402769 | 1948 | Patrick Collins (mayor) | Q976524 | kg:/m/06y0qj | Patrick | Collins | 1844-03-12 | M | 11255 | Andrew | ||||||||||||||||
P000111 | Edward Patterson | P000111 | 408519 | 7238 | Edward White Patterson | Q976506 | kg:/m/02rm9zx | Edward | Patterson | 1895-10-04 | M | 19410 | White | ||||||||||||||||
M000485 | Mike McIntyre | M000485 | 400266 | 29746 | Mike McIntyre | Q976487 | kg:/m/03g_v8 | Mike | McIntyre | 1956-08-06 | M | 17932 | Mike McIntyre | 01505 | 45960 | 153 | Mike McIntyre | N00002356 | [ "H8NC07044" ] |
362 | |||||||||
B001281 | Joyce Beatty | B001281 | 412565 | 21352 | Joyce Beatty | Q976417 | kg:/m/03lcwb | Joyce | Beatty | 1950-03-12 | F | 15032386867 | Joyce Beatty | 02153 | 67294 | 2427 | Joyce Beatty | N00033904 | [ "H2OH03125" ] |
1789 | |||||||||
F000194 | Frederick Fleetwood | F000194 | 404149 | 3210 | Frederick G. Fleetwood | Q976409 | kg:/m/02rhgd9 | Frederick | Fleetwood | 1868-09-27 | M | 13214 | Gleed | ||||||||||||||||
C000066 | Ralph Cameron | C000066 | 402224 | 1436 | Ralph H. Cameron | Q976300 | kg:/m/07sgkx | Ralph | Cameron | 1863-10-21 | M | 10525 | Henry | ||||||||||||||||
A000364 | John Adler | A000364 | 412264 | 20928 | John Adler | Q976160 | kg:/m/05jzss | John | Adler | 1959-08-23 | M | 8763 | H. | 01935 | 1030767 | 4171 | N00000812 | [ "H8NJ03156" ] |
|||||||||||
H000943 | Merlin Hull | H000943 | 405788 | 4720 | Merlin Hull | Q975922 | kg:/m/0262sqj | Merlin | Hull | 1870-12-18 | M | 15449 | |||||||||||||||||
C000272 | James Chalmers | C000272 | 402415 | 1617 | James Ronald Chalmers | Q975506 | kg:/m/0gpr3d | James | Chalmers | 1831-01-12 | M | 10799 | Ronald | ||||||||||||||||
G000196 | James Gillespie | G000196 | 412152 | 3594 | James Gillespie (politician) | Q974466 | kg:/m/04glyk | James | Gillespie | M | 13812 | ||||||||||||||||||
R000312 | Herbert Roberts | R000312 | 409283 | 10550 | Ray Roberts | Q974316 | kg:/m/0g387k | Herbert | Roberts | 1913-03-28 | M | 20471 | Ray | 00969 |
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);