legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
55 rows where name_first = "Harry"
This data as json, copyable, CSV (advanced)
Suggested facets: name_suffix, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
B000086 | Harry Baldwin | B000086 | 401088 | 381 | Harry Streett Baldwin | Q808689 | kg:/m/09jss_ | Harry | Baldwin | 1894-08-21 | M | 8886 | Streett | ||||||||||||||||
B000204 | Harry Bartlett | B000204 | 401203 | 15002 | Steve Bartlett | Q185480 | kg:/m/02fhlw | Harry | Bartlett | 1947-09-19 | M | 9037 | Stephen | Steve | 00061 | ||||||||||||||
B000274 | Harry Beam | B000274 | 401268 | 548 | Harry P. Beam | Q5671414 | kg:/m/02rk9vv | Harry | Beam | 1892-11-23 | M | 9130 | Peter | ||||||||||||||||
B001208 | Harry Byrd | B001208 | 402148 | 1365 | Harry F. Byrd | Q775382 | kg:/m/035rl7 | Harry | Byrd | 1887-06-10 | M | Flood | |||||||||||||||||
B001209 | Harry Byrd | B001209 | 402149 | 10802 | Harry F. Byrd Jr. | Q3268711 | kg:/m/03667s | Harry | Byrd | 1914-12-20 | M | Flood | Jr. | 01300 | |||||||||||||||
C000018 | Harry Cage | C000018 | 412022 | 1392 | Harry Cage | Q1250644 | kg:/m/02rtm_5 | Harry | Cage | M | 10464 | ||||||||||||||||||
C000021 | Harry Cain | C000021 | 402182 | 1395 | Harry P. Cain | Q1586688 | kg:/m/0bdj65 | Harry | Cain | 1906-01-10 | M | Pulliam | |||||||||||||||||
C000114 | Harry Canfield | C000114 | 402266 | 1477 | Harry C. Canfield | Q1586419 | kg:/m/02rkg50 | Harry | Canfield | 1875-11-22 | M | 10589 | Clifford | ||||||||||||||||
C000582 | Harry Coffee | C000582 | 402711 | 1897 | Harry B. Coffee | Q1425417 | kg:/m/09yg08 | Harry | Coffee | 1890-03-16 | M | 11179 | Buffington | ||||||||||||||||
C000805 | Harry Coudrey | C000805 | 402924 | 2090 | Harry M. Coudrey | Q1586656 | kg:/m/02rz6j3 | Harry | Coudrey | 1867-02-28 | M | 11464 | Marcy | ||||||||||||||||
D000008 | Harry Dale | D000008 | 403151 | 2301 | Harry H. Dale | Q657245 | kg:/m/02rkq71 | Harry | Dale | 1868-12-03 | M | 11842 | Howard | ||||||||||||||||
D000048 | Harry Darby | D000048 | 403187 | 2333 | Harry Darby | Q1586459 | kg:/m/0c3nk_ | Harry | Darby | 1895-01-23 | M | ||||||||||||||||||
D000071 | Harry Davenport | D000071 | 403209 | 2353 | Harry J. Davenport | Q13219596 | kg:/m/0f6ydr | Harry | Davenport | 1902-08-22 | M | 11919 | James | ||||||||||||||||
E000182 | Harry Englebright | E000182 | 403871 | 2966 | Harry Lane Englebright | Q691422 | kg:/m/03bpny | Harry | Englebright | 1884-01-02 | M | 12819 | Lane | ||||||||||||||||
E000221 | Harry Estep | E000221 | 403907 | 2993 | Harry Allison Estep | Q5666887 | kg:/m/0fslv5 | Harry | Estep | 1884-02-01 | M | 12875 | Allison | ||||||||||||||||
G000004 | Harry Gahn | G000004 | 404381 | 3422 | Harry C. Gahn | Q1586421 | kg:/m/02rm0v_ | Harry | Gahn | 1880-04-26 | M | 13570 | Conrad | ||||||||||||||||
G000037 | Harry Gandy | G000037 | 404413 | 3450 | Harry Gandy | Q1292556 | kg:/m/0dv5rf | Harry | Gandy | 1881-08-13 | M | 13610 | Luther | ||||||||||||||||
G000484 | Harry Griswold | G000484 | 404829 | 3842 | Harry W. Griswold | Q203965 | kg:/m/0262tbg | Harry | Griswold | 1886-05-19 | M | 14174 | Wilbur | ||||||||||||||||
H000026 | Harry Haines | H000026 | 404911 | 3914 | Harry L. Haines | Q5670384 | kg:/m/0f94pn | Harry | Haines | 1880-02-01 | M | 14321 | Luther | ||||||||||||||||
H000143 | Harry Hanbury | H000143 | 405025 | 4022 | Harry A. Hanbury | Q655518 | kg:/m/02rkq6q | Harry | Hanbury | 1863-01-01 | M | 14460 | Alfred | ||||||||||||||||
H000318 | Harry Haskell | H000318 | 405191 | 4172 | Harry G. Haskell Jr. | Q1586506 | kg:/m/025xkw4 | Harry | Haskell | 1921-05-27 | M | 14675 | Garner | Jr. | |||||||||||||||
H000362 | Harry Hawes | H000362 | 405231 | 4207 | Harry B. Hawes | Q1237268 | kg:/m/07dsyg | Harry | Hawes | 1869-11-15 | M | 14727 | Bartow | ||||||||||||||||
H000557 | Harry Hibbard | H000557 | 405419 | 4380 | Harry Hibbard | Q1586561 | kg:/m/02ppcqg | Harry | Hibbard | 1816-06-01 | M | 14973 | |||||||||||||||||
H000941 | Harry Hull | H000941 | 405786 | 4718 | Harry E. Hull | Q1586461 | kg:/m/02rk7jl | Harry | Hull | 1864-03-12 | M | 15446 | Edward | ||||||||||||||||
J000073 | Harry Jeffrey | J000073 | 405976 | 4905 | Harry P. Jeffrey | Q5671426 | kg:/m/0d3kxn | Harry | Jeffrey | 1901-12-26 | M | 15787 | Palmer | ||||||||||||||||
J000187 | Harry Johnston | J000187 | 406082 | 15609 | Harry Johnston (American politician) | Q947893 | kg:/m/026x6gs | Harry | Johnston | 1931-12-02 | M | 15933 | A. | II | 00606 | ||||||||||||||
L000059 | Harry Lane | L000059 | 406568 | 5441 | Harry Lane | Q1586625 | kg:/m/0d2wy0 | Harry | Lane | 1855-08-28 | M | ||||||||||||||||||
L000298 | Harry Libbey | L000298 | 406793 | 5653 | Harry Libbey | Q1586639 | kg:/m/02vrpkj | Harry | Libbey | 1843-11-22 | M | 16963 | |||||||||||||||||
M000214 | Harry Mason | M000214 | 407232 | 6051 | Harry H. Mason | Q5669362 | kg:/m/02rk9vh | Harry | Mason | 1873-12-16 | M | 17587 | Howland | ||||||||||||||||
M000283 | Harry Maynard | M000283 | 407300 | 6111 | Harry L. Maynard | Q1586615 | kg:/m/02x405t | Harry | Maynard | 1861-06-08 | M | 17672 | Lee | ||||||||||||||||
M001122 | Harry Musselwhite | M001122 | 408084 | 6832 | Harry W. Musselwhite | Q1586857 | kg:/m/02q1cyd | Harry | Musselwhite | 1868-05-23 | M | 18728 | Webster | ||||||||||||||||
M001167 | Harry Mitchell | M001167 | 412187 | 20700 | Harry Mitchell | Q928861 | kg:/m/0c71k9 | Harry | Mitchell | 1940-07-18 | M | 18805 | E. | 01830 | 1021101 | 16369 | N00028162 | [ "H6AZ05067" ] |
|||||||||||
N000006 | Harry Narey | N000006 | 408100 | 6842 | Harry E. Narey | Q1586464 | kg:/m/02rq9z_ | Harry | Narey | 1885-05-15 | M | 18843 | Elsworth | ||||||||||||||||
N000059 | Harry New | N000059 | 408147 | 6887 | Harry Stewart New | Q1586757 | kg:/m/039gqz | Harry | New | 1858-12-31 | M | Stewart | |||||||||||||||||
O000095 | Harry O’Neill | O000095 | 408304 | 7078 | Harry P. O'Neill | Q13219745 | kg:/m/0f2gb2 | Harry | O’Neill | 1889-02-10 | M | 19182 | Patrick | ||||||||||||||||
P000500 | Harry Pratt | P000500 | 408885 | 7590 | Harry H. Pratt | Q5669371 | kg:/m/02rkq7d | Harry | Pratt | 1864-11-11 | M | 19898 | Hayt | ||||||||||||||||
R000061 | Harry Ransley | R000061 | 409041 | 7736 | Harry C. Ransley | Q5667726 | kg:/m/0dj99z | Harry | Ransley | 1863-02-05 | M | 20156 | Clay | ||||||||||||||||
R000146 | Harry Reid | R000146 | 300082 | 15054 | Harry Reid | Q314459 | kg:/m/0204x1 | Harry | Reid | 1939-12-02 | M | 20266 | M. | Harry Reid | 00952 | 1683 | 53320 | S198 | Harry Reid | N00009922 | [ "S6NV00028" ] |
601 | [ { "title": "Senate Majority Leader", "chamber": "senate", "start": "2007-01-04", "end": "2009-01-06" }, { "title": "Senate Majority Leader", "chamber": "senate", "start": "2009-01-06", "end": "2011-01-05" }, { "title": "Senate Majority Leader", "chamber": "senate", "start": "2011-01-05", "end": "2013-01-03" }, { "title": "Senate Majority Leader", "chamber": "senate", "start": "2013-01-03", "end": "2015-01-03" }, { "title": "Senate Minority Leader", "chamber": "senate", "start": "2015-01-03", "end": "2017-01-03" } ] |
||||||
R000221 | Harry Richardson | R000221 | 409197 | 7876 | Harry A. Richardson | Q1586362 | kg:/m/07nwzr | Harry | Richardson | 1853-01-01 | M | Alden | |||||||||||||||||
R000470 | Harry Routzohn | R000470 | 409431 | 8086 | Harry N. Routzohn | Q10854092 | kg:/m/0d379t | Harry | Routzohn | 1881-11-04 | M | 20666 | Nelson | ||||||||||||||||
R000474 | Harry Rowbottom | R000474 | 409435 | 8090 | Harry E. Rowbottom | Q1586462 | kg:/m/02rkg5q | Harry | Rowbottom | 1884-11-03 | M | 20671 | Emerson | ||||||||||||||||
R000516 | Harry Rusk | R000516 | 409474 | 8119 | Harry Welles Rusk | Q1108107 | kg:/m/02qh_qv | Harry | Rusk | 1852-10-17 | M | 20723 | Welles | ||||||||||||||||
S000031 | Harry Sandager | S000031 | 409549 | 8194 | Harry Sandager | Q1586761 | kg:/m/02rhh6s | Harry | Sandager | 1887-04-12 | M | 21169 | |||||||||||||||||
S000079 | Harry Sauthoff | S000079 | 409591 | 8229 | Harry Sauthoff | Q1248838 | kg:/m/09kw8f | Harry | Sauthoff | 1879-06-03 | M | 21232 | |||||||||||||||||
S000234 | Harry Seldomridge | S000234 | 409738 | 8355 | Harry H. Seldomridge | Q749913 | kg:/m/02rhh62 | Harry | Seldomridge | 1864-10-01 | M | 21425 | Hunter | ||||||||||||||||
S000335 | Harry Sheppard | S000335 | 409832 | 8444 | Harry R. Sheppard | Q1586714 | kg:/m/02rhh6f | Harry | Sheppard | 1885-01-10 | M | 21553 | Richard | ||||||||||||||||
S000468 | Harry Skinner | S000468 | 409958 | 8560 | Harry Skinner (politician) | Q1454561 | kg:/m/02vn_hr | Harry | Skinner | 1855-05-25 | M | 21723 | |||||||||||||||||
T000146 | Harry Thayer | T000146 | 410728 | 9274 | Harry Irving Thayer | Q1586579 | kg:/m/0ksm5r | Harry | Thayer | 1869-09-10 | M | 22809 | Irving | ||||||||||||||||
T000320 | Harry Towe | T000320 | 410892 | 9427 | Harry Lancaster Towe | Q1586620 | kg:/m/02vrjym | Harry | Towe | 1898-11-03 | M | 23026 | Lancaster | ||||||||||||||||
T000387 | Harry Truman | T000387 | 410956 | 9487 | Harry S. Truman | Q11613 | kg:/m/09bg4l | Harry | Truman | 1884-05-08 | M | S. | |||||||||||||||||
T000466 | Harry Teague | T000466 | 412316 | 20931 | Harry Teague | Q1586830 | kg:/m/04y921x | Harry | Teague | 1949-06-29 | M | 23211 | Harry Teague | 01938 | 1030431 | 102408 | N00029556 | [ "H8NM02032" ] |
|||||||||||
W000373 | Harry White | W000373 | 411534 | 10026 | Harry White (Pennsylvania politician) | Q5673338 | kg:/m/0kt0fk | Harry | White | 1834-01-12 | M | 23658 | |||||||||||||||||
W000674 | Harry Wolf | W000674 | 411826 | 10307 | Harry Benjamin Wolf | Q1107875 | kg:/m/02qzs05 | Harry | Wolf | 1880-06-16 | M | 24020 | Benjamin | ||||||||||||||||
W000737 | Harry Woodyard | W000737 | 411888 | 10367 | Harry C. Woodyard | Q1586423 | kg:/m/03b_ttf | Harry | Woodyard | 1867-11-13 | M | 24096 | Chapman | ||||||||||||||||
W000775 | Harry Wurzbach | W000775 | 411924 | 10403 | Harry M. Wurzbach | Q1586648 | kg:/m/0cfs_b | Harry | Wurzbach | 1874-05-19 | M | 24144 | McLeary |
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);