legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
46 rows where name_middle = "Lee"
This data as json, copyable, CSV (advanced)
Suggested facets: bio_gender, name_suffix, bio_birthday (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
B000103 | William Ball | B000103 | 401105 | 398 | William Lee Ball | Q2579712 | kg:/m/027wtyq | William | Ball | 1781-01-02 | M | 8906 | Lee | ||||||||||||||||
B000971 | Terry Bruce | B000971 | 401923 | 15088 | Terry L. Bruce | Q7704641 | kg:/m/02rkc_7 | Terry | Bruce | 1944-03-25 | M | 10033 | Lee | 00140 | |||||||||||||||
B001056 | Alfred Bulwinkle | B001056 | 402003 | 1235 | Alfred L. Bulwinkle | Q2544441 | kg:/m/02vn_qm | Alfred | Bulwinkle | 1883-04-21 | M | 10136 | Lee | ||||||||||||||||
C000071 | Dave Camp | C000071 | 400058 | 29124 | Dave Camp | Q182551 | kg:/m/03l8yr | Dave | Camp | 1953-07-09 | M | 10534 | Lee | Dave Camp | 00166 | 23039 | 26911 | Dave Camp | N00008086 | [ "H0MI10071" ] |
176 | ||||||||
C000201 | Tim Carter | C000201 | 402347 | 10710 | Tim Lee Carter | Q2434127 | kg:/m/026_hkr | Tim | Carter | 1910-09-02 | M | 10706 | Lee | 00181 | |||||||||||||||
C000581 | Anthony Coelho | C000581 | 402710 | 14613 | Tony Coelho | Q2442506 | kg:/m/03wy8h4 | Anthony | Coelho | 1942-06-15 | M | 11178 | Lee | 00214 | |||||||||||||||
C001054 | Jerry Carl | C001054 | 456799 | Jerry Carl | Q102277702 | kg:/g/11j2j1brnb | Jerry | Carl | 1958-06-17 | M | Lee | Jr. | Jerry L. Carl | N00044245 | [ "H0AL01055" ] |
||||||||||||||
D000129 | Robert Davis | D000129 | 403264 | 2406 | Robert Lee Davis | Q7346803 | kg:/m/0fn3jn | Robert | Davis | 1893-10-29 | M | 11993 | Lee | ||||||||||||||||
D000448 | Robert Doughton | D000448 | 403558 | 2684 | Robert L. Doughton | Q1260497 | kg:/m/06cjkm | Robert | Doughton | 1863-11-07 | M | 12391 | Lee | ||||||||||||||||
E000184 | Glenn English | E000184 | 403873 | 14219 | Glenn English | Q1313130 | kg:/m/07v5gv | Glenn | English | 1940-11-30 | M | 12822 | Lee | Jr. | 00345 | ||||||||||||||
E000233 | Billy Evans | E000233 | 403918 | 14418 | Billy Lee Evans | Q863165 | kg:/m/09zy0r | Billy | Evans | 1941-11-10 | M | 12890 | Lee | 00357 | |||||||||||||||
F000047 | Charles Faust | F000047 | 404007 | 3082 | Charles L. Faust | Q1065211 | kg:/m/02rz5q8 | Charles | Faust | 1879-04-24 | M | 13024 | Lee | ||||||||||||||||
F000375 | Burton French | F000375 | 404320 | 3367 | Burton L. French | Q255721 | kg:/m/0d3hrg | Burton | French | 1875-08-01 | M | 13444 | Lee | ||||||||||||||||
F000441 | Ernest Fletcher | F000441 | 400135 | 29917 | Ernie Fletcher | Q881233 | kg:/m/026fb9 | Ernest | Fletcher | 1952-11-12 | M | 13532 | Lee | Ernie | 01563 | 115 | N00003430 | ||||||||||||
F000458 | Stephen Fincher | F000458 | 412479 | 21181 | Stephen Fincher | Q2344713 | kg:/m/0ddgg4w | Stephen | Fincher | 1973-02-07 | M | 13562 | Lee | 02064 | 9268967 | 124659 | Stephen Lee Fincher | N00031141 | [ "H0TN08246" ] |
1484 | |||||||||
G000094 | Percy Gassaway | G000094 | 404466 | 3502 | Percy Lee Gassaway | Q2070265 | kg:/m/02rr6sc | Percy | Gassaway | 1885-08-30 | M | 13680 | Lee | ||||||||||||||||
G000165 | Randall Gibson | G000165 | 404532 | 3565 | Randall L. Gibson | Q2130610 | kg:/m/045t08 | Randall | Gibson | 1832-09-10 | M | 13774 | Lee | ||||||||||||||||
G000262 | Phillips Goldsborough | G000262 | 404624 | 3653 | Phillips Lee Goldsborough | Q648130 | kg:/m/047nz_ | Phillips | Goldsborough | 1865-08-06 | M | Lee | |||||||||||||||||
G000338 | Ed Gossett | G000338 | 404694 | 3719 | Ed Gossett | Q1282355 | kg:/m/02vrpjh | Ed | Gossett | 1902-01-27 | M | 13989 | Lee | ||||||||||||||||
G000401 | Oscar Gray | G000401 | 404751 | 3770 | Oscar Lee Gray | Q2032813 | kg:/m/02rk251 | Oscar | Gray | 1865-07-02 | M | 14070 | Lee | ||||||||||||||||
H000073 | Tim Hall | H000073 | 404957 | 14228 | Tim Lee Hall | Q7803822 | kg:/m/02rkd5s | Tim | Hall | 1925-06-11 | M | 14377 | Lee | 00486 | |||||||||||||||
H000301 | Jesse Hartman | H000301 | 405174 | 4158 | Jesse Lee Hartman | Q6186577 | kg:/m/0g7y1v | Jesse | Hartman | 1853-06-18 | M | 14656 | Lee | ||||||||||||||||
H000516 | Robert Henry | H000516 | 405379 | 4341 | Robert Lee Henry | Q2158001 | kg:/m/02647w2 | Robert | Henry | 1864-05-12 | M | 14923 | Lee | ||||||||||||||||
H000666 | David Hobson | H000666 | 400180 | 29136 | Dave Hobson | Q5228974 | kg:/m/039rtp | David | Hobson | 1936-10-17 | M | 15108 | Lee | Dave | 00545 | 27014 | N00003725 | [ "H0OH07021" ] |
|||||||||||
H000690 | Earl Hogan | H000690 | 405543 | 4494 | Earl Hogan | Q174949 | kg:/m/02rkfl3 | Earl | Hogan | 1920-03-13 | M | 15137 | Lee | ||||||||||||||||
H000875 | Roman Hruska | H000875 | 405721 | 4660 | Roman Hruska | Q2164620 | kg:/m/0521s5 | Roman | Hruska | 1904-08-16 | M | 15367 | Lee | 01362 | |||||||||||||||
J000163 | Nancy Johnson | J000163 | 400205 | 15028 | Nancy Johnson | Q519074 | kg:/m/024zsd | Nancy | Johnson | 1935-01-05 | F | 15901 | Lee | 00602 | N00000561 | ||||||||||||||
J000273 | Henry Jost | J000273 | 406165 | 5078 | Henry L. Jost | Q1606967 | kg:/m/02ry4c9 | Henry | Jost | 1873-12-06 | M | 16040 | Lee | ||||||||||||||||
L000519 | Georgia Lusk | L000519 | 407004 | 5842 | Georgia Lee Lusk | Q1509299 | kg:/m/07vzds | Georgia | Lusk | 1893-05-12 | F | 17242 | Lee | ||||||||||||||||
M000283 | Harry Maynard | M000283 | 407300 | 6111 | Harry L. Maynard | Q1586615 | kg:/m/02x405t | Harry | Maynard | 1861-06-08 | M | 17672 | Lee | ||||||||||||||||
M000914 | Robert Moore | M000914 | 407886 | 6648 | Robert Lee Moore (Georgia politician) | Q1348856 | kg:/m/0274b4c | Robert | Moore | 1867-11-27 | M | 18479 | Lee | ||||||||||||||||
M000943 | Henry Morey | M000943 | 407911 | 6671 | Henry Lee Morey | Q5724806 | kg:/m/0d0kvj | Henry | Morey | 1841-04-08 | M | 18515 | Lee | ||||||||||||||||
M001129 | Henry Myers | M001129 | 408091 | 6837 | Henry L. Myers | Q1392618 | kg:/m/0crvbm | Henry | Myers | 1862-10-09 | M | Lee | |||||||||||||||||
O000034 | Wilbert O’Daniel | O000034 | 408281 | 7021 | W. Lee O'Daniel | Q676664 | kg:/m/02wv_6 | Wilbert | O’Daniel | 1890-03-11 | M | Lee | Pappy | ||||||||||||||||
P000048 | August Pfluger | P000048 | 456846 | August Pfluger | Q101196462 | kg:/g/11f3szpd4x | August | Pfluger | 1978-12-28 | M | Lee | II | August Pfluger | N00045421 | [ "H0TX11230" ] |
||||||||||||||
P000125 | LaFayette Patterson | P000125 | 408533 | 7250 | LaFayette L. Patterson | Q1656270 | kg:/m/0btspw | LaFayette | Patterson | 1888-08-23 | M | 19430 | Lee | ||||||||||||||||
P000513 | Larry Pressler | P000513 | 408898 | 14268 | Larry Pressler | Q518447 | kg:/m/039zzw | Larry | Pressler | 1942-03-29 | M | 19914 | Lee | 00927 | S141 | ||||||||||||||
R000137 | Albert Reeves | R000137 | 409116 | 7803 | Albert L. Reeves Jr. | Q1668288 | kg:/m/02rz5dn | Albert | Reeves | 1906-05-31 | M | 20250 | Lee | Jr. | |||||||||||||||
S000434 | Milward Simpson | S000434 | 409928 | 10820 | Milward Simpson | Q881641 | kg:/m/08cchp | Milward | Simpson | 1897-11-12 | M | Lee | |||||||||||||||||
S000514 | Albert Smith | S000514 | 409999 | 14862 | Albert L. Smith Jr. | Q632825 | kg:/m/02qhvzf | Albert | Smith | 1931-08-31 | M | 21778 | Lee | Jr. | 01070 | ||||||||||||||
S000756 | William Springer | S000756 | 410223 | 8814 | William L. Springer | Q8014215 | kg:/m/02rkdk3 | William | Springer | 1909-04-12 | M | 22071 | Lee | ||||||||||||||||
U000002 | Stewart Udall | U000002 | 411026 | 9549 | Stewart Udall | Q1347844 | kg:/m/036sz1 | Stewart | Udall | 1920-01-31 | M | 20827 | Lee | ||||||||||||||||
U000006 | Charles Underhill | U000006 | 411030 | 9553 | Charles L. Underhill | Q1065240 | kg:/m/0bvd__ | Charles | Underhill | 1867-07-20 | M | 20833 | Lee | ||||||||||||||||
V000112 | Harold Volkmer | V000112 | 411166 | 14459 | Harold Volkmer | Q1585941 | kg:/m/085b9y | Harold | Volkmer | 1931-04-04 | M | 21010 | Lee | 01189 | |||||||||||||||
W000410 | Basil Whitener | W000410 | 411570 | 10060 | Basil Lee Whitener | Q810032 | kg:/m/04p1j2 | Basil | Whitener | 1915-05-14 | M | 23701 | Lee | ||||||||||||||||
W000658 | Garrett Withers | W000658 | 411811 | 10294 | Garrett Withers | Q1411163 | kg:/m/08h0jk | Garrett | Withers | 1884-06-21 | M | 24001 | Lee |
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);