legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by name_first descending
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
S000634 | William Smith | S000634 | 410108 | 8703 | William Nathan Harrell Smith | Q1667529 | kg:/m/0bpk_6 | William | Smith | 1812-09-24 | M | 21918 | Nathan Harrell | ||||||||||||||||
S000635 | William Smith | S000635 | 410109 | 8704 | William Orlando Smith | Q8016369 | kg:/m/0gfl25 | William | Smith | 1859-06-13 | M | 21919 | Orlando | ||||||||||||||||
S000636 | William Smith | S000636 | 410110 | 8705 | William Robert Smith | Q1440371 | kg:/m/0gwx04 | William | Smith | 1863-08-18 | M | 21921 | Robert | ||||||||||||||||
S000637 | William Smith | S000637 | 410111 | 8706 | William Russell Smith | Q629554 | kg:/m/0g42th | William | Smith | 1815-03-27 | M | 21922 | Russell | ||||||||||||||||
S000638 | William Smith | S000638 | 410112 | 8707 | William Stephens Smith | Q8018789 | kg:/m/026_tbr | William | Smith | 1755-11-08 | M | 21923 | Stephens | ||||||||||||||||
S000648 | William Smyth | S000648 | 410122 | 8717 | William Smyth (congressman) | Q2580591 | kg:/m/02r6qll | William | Smyth | 1824-01-03 | M | 21933 | |||||||||||||||||
S000651 | William Sneed | S000651 | 410125 | 8720 | William Henry Sneed | Q1773281 | kg:/m/0dc6jn | William | Sneed | 1812-08-27 | M | 21936 | Henry | ||||||||||||||||
S000661 | William Snow | S000661 | 410135 | 8730 | William W. Snow | Q8019836 | kg:/m/02qr025 | William | Snow | 1812-04-27 | M | 21951 | W. | ||||||||||||||||
S000690 | William Southgate | S000690 | 410161 | 8753 | William Wright Southgate | Q2581122 | kg:/m/0fcm42 | William | Southgate | 1800-11-27 | M | 21990 | Wright | ||||||||||||||||
S000692 | William Sowden | S000692 | 410163 | 8755 | William Henry Sowden | Q8012165 | kg:/m/0ksrpy | William | Sowden | 1840-06-06 | M | 21993 | Henry | ||||||||||||||||
S000704 | William Sparks | S000704 | 410175 | 8767 | William A. J. Sparks | Q8003983 | kg:/m/02rkd9x | William | Sparks | 1828-11-19 | M | 22008 | Andrew Jackson | ||||||||||||||||
S000731 | William Spencer | S000731 | 410200 | 8791 | William B. Spencer | Q2577933 | kg:/m/02rv9f4 | William | Spencer | 1835-02-05 | M | 22039 | Brainerd | ||||||||||||||||
S000739 | William Spong | S000739 | 410208 | 11206 | William Spong Jr. | Q6329296 | kg:/m/053s_8 | William | Spong | 1920-09-29 | M | Belser | Jr. | ||||||||||||||||
S000745 | William Sprague | S000745 | 410215 | 8804 | William Sprague (Michigan politician) | Q1313504 | kg:/m/0504l7 | William | Sprague | 1809-02-23 | M | 22059 | |||||||||||||||||
S000746 | William Sprague | S000746 | 410214 | 8805 | William Sprague III | Q883991 | kg:/m/050cbv | William | Sprague | 1799-11-03 | M | 22060 | |||||||||||||||||
S000747 | William Sprague | S000747 | 410216 | 8806 | William Sprague IV | Q437963 | kg:/m/04z9v1 | William | Sprague | 1830-09-12 | M | ||||||||||||||||||
S000748 | William Sprague | S000748 | 410217 | 8807 | William P. Sprague | Q8016504 | kg:/m/02r35dc | William | Sprague | 1827-05-21 | M | 22062 | Peter | ||||||||||||||||
S000756 | William Springer | S000756 | 410223 | 8814 | William L. Springer | Q8014215 | kg:/m/02rkdk3 | William | Springer | 1909-04-12 | M | 22071 | Lee | ||||||||||||||||
S000757 | William Springer | S000757 | 410224 | 8815 | William McKendree Springer | Q6799284 | kg:/m/0dftrw | William | Springer | 1836-05-30 | M | 22073 | McKendree | ||||||||||||||||
S000759 | William Sproul | S000759 | 410226 | 8817 | William H. Sproul | Q2579093 | kg:/m/02rmb5s | William | Sproul | 1867-10-14 | M | 22075 | Henry | ||||||||||||||||
S000769 | William St. Onge | S000769 | 410236 | 10627 | William St. Onge | Q2580614 | kg:/m/02ppg4v | William | St. Onge | 1914-10-09 | M | 22088 | Leon | ||||||||||||||||
S000777 | William Stafford | S000777 | 410243 | 8823 | William H. Stafford | Q2579101 | kg:/m/0283f1_ | William | Stafford | 1869-10-12 | M | 22098 | Henry | ||||||||||||||||
S000781 | William Stahlnecker | S000781 | 410247 | 8826 | William G. Stahlnecker | Q1027372 | kg:/m/02rky16 | William | Stahlnecker | 1849-06-20 | M | 22104 | Griggs | ||||||||||||||||
S000788 | William Stanbery | S000788 | 410254 | 8831 | William Stanbery | Q8018711 | kg:/m/02rm3v7 | William | Stanbery | 1788-08-10 | M | 22114 | |||||||||||||||||
S000792 | William Stanfill | S000792 | 410258 | 8835 | William A. Stanfill | Q1725187 | kg:/m/08gz8h | William | Stanfill | 1892-01-16 | M | Abner | |||||||||||||||||
S000807 | William Stanton | S000807 | 410273 | 8847 | William Henry Stanton (congressman) | Q8012170 | kg:/m/0kt1lq | William | Stanton | 1843-07-28 | M | 22138 | Henry | ||||||||||||||||
S000811 | William Stark | S000811 | 410276 | 8850 | William Ledyard Stark | Q2579701 | kg:/m/09ytq5 | William | Stark | 1853-07-29 | M | 22144 | Ledyard | ||||||||||||||||
S000828 | William Stedman | S000828 | 410292 | 8865 | William Stedman | Q1457403 | kg:/m/02rk009 | William | Stedman | 1765-01-21 | M | 22164 | |||||||||||||||||
S000839 | William Steele | S000839 | 410303 | 8875 | William G. Steele | Q2578915 | kg:/m/02x6t6q | William | Steele | 1820-12-17 | M | 22177 | Gaston | ||||||||||||||||
S000840 | William Steele | S000840 | 410304 | William Randolph Steele | Q1393108 | kg:/m/02rj_yx | William | Steele | 1842-07-24 | M | 22178 | Randolph | |||||||||||||||||
S000847 | William Steiger | S000847 | 410311 | 11051 | William A. Steiger | Q2577330 | kg:/m/0b19c6 | William | Steiger | 1938-05-15 | M | 22186 | Albert | 01109 | |||||||||||||||
S000849 | William Stenger | S000849 | 410313 | 8881 | William Stenger | Q8018774 | kg:/m/0djq0t | William | Stenger | 1840-02-13 | M | 22188 | Shearer | ||||||||||||||||
S000861 | William Stephens | S000861 | 410324 | 8891 | William Stephens (American politician) | Q880618 | kg:/m/03ccc4 | William | Stephens | 1859-12-26 | M | 22204 | Dennison | ||||||||||||||||
S000895 | William Stevenson | S000895 | 410356 | 8923 | William Francis Stevenson | Q2578773 | kg:/m/02vrpg2 | William | Stevenson | 1861-11-23 | M | 22247 | Francis | ||||||||||||||||
S000896 | William Stevenson | S000896 | 410357 | 8924 | William H. Stevenson | Q1747892 | kg:/m/0dqq5n | William | Stevenson | 1891-09-23 | M | 22248 | Henry | ||||||||||||||||
S000921 | William Stewart | S000921 | 410381 | 8947 | William Stewart (Pennsylvania politician) | Q8018828 | kg:/m/0ktc17 | William | Stewart | 1810-09-10 | M | 22277 | |||||||||||||||||
S000922 | William Stewart | S000922 | 410382 | 8948 | William Morris Stewart | Q360401 | kg:/m/095vlb | William | Stewart | 1827-08-09 | M | Morris | |||||||||||||||||
S000923 | William Stigler | S000923 | 410383 | 8949 | William G. Stigler | Q2578917 | kg:/m/02rr6zx | William | Stigler | 1891-07-07 | M | 22280 | Grady | ||||||||||||||||
S000925 | William Stiles | S000925 | 410385 | 8951 | William Henry Stiles | Q2579248 | kg:/m/027b724 | William | Stiles | 1808-01-01 | M | 22283 | Henry | ||||||||||||||||
S000950 | William Stokes | S000950 | 410409 | 8972 | William Brickly Stokes | Q1790662 | kg:/m/0dk81f | William | Stokes | 1814-09-09 | M | 22314 | Brickly | ||||||||||||||||
S000965 | William Stone | S000965 | 410424 | 8986 | William Stone (Tennessee politician) | Q2580666 | kg:/m/02rldxw | William | Stone | 1791-01-26 | M | 22333 | |||||||||||||||||
S000966 | William Stone | S000966 | 410425 | 8987 | William A. Stone | Q883571 | kg:/m/0294sd | William | Stone | 1846-04-18 | M | 22335 | Alexis | ||||||||||||||||
S000967 | William Stone | S000967 | 410426 | 8988 | William Henry Stone | Q2579251 | kg:/m/02rz8kf | William | Stone | 1828-11-07 | M | 22337 | Henry | ||||||||||||||||
S000968 | William Stone | S000968 | 410427 | 8989 | William J. Stone | Q884118 | kg:/m/09svlz | William | Stone | 1848-05-07 | M | 22339 | Joel | ||||||||||||||||
S000969 | William Stone | S000969 | 410428 | 8990 | William Johnson Stone | Q1670203 | kg:/m/057xp27 | William | Stone | 1841-06-26 | M | 22341 | Johnson | ||||||||||||||||
S000977 | William Storrs | S000977 | 410436 | 8998 | William L. Storrs | Q2579639 | kg:/m/02rj_r0 | William | Storrs | 1795-03-25 | M | 22351 | Lucius | ||||||||||||||||
S000979 | William Stoughton | S000979 | 410438 | 9000 | William L. Stoughton | Q2579642 | kg:/m/0272r7v | William | Stoughton | 1827-03-20 | M | 22353 | Lewis | ||||||||||||||||
S000985 | William Stowell | S000985 | 410444 | 9006 | William Henry Harrison Stowell | Q1168008 | kg:/m/028by6h | William | Stowell | 1840-07-26 | M | 22359 | Henry Harrison | ||||||||||||||||
S000998 | William Stratton | S000998 | 410456 | 9018 | William Stratton | Q734810 | kg:/m/02z93b | William | Stratton | 1914-02-26 | M | 22373 | Grant | ||||||||||||||||
S001021 | William Strong | S001021 | 410479 | 9041 | William Strong (Pennsylvania judge) | Q2580679 | kg:/m/03hhw4 | William | Strong | 1808-05-06 | M | 22400 | |||||||||||||||||
S001022 | William Strong | S001022 | 410478 | 9040 | William Strong (Vermont politician) | Q1555437 | kg:/m/03nz2q | William | Strong | M | 22401 | ||||||||||||||||||
S001027 | William Strowd | S001027 | 410484 | 9046 | William Franklin Strowd | Q730358 | kg:/m/05kyjg | William | Strowd | 1832-12-07 | M | 22407 | Franklin | ||||||||||||||||
S001029 | William Strudwick | S001029 | 412181 | 9048 | William Francis Strudwick | Q2578868 | kg:/m/04f9hn | William | Strudwick | M | 22410 | Francis | |||||||||||||||||
S001062 | William Sullivan | S001062 | 410516 | 9077 | William V. Sullivan | Q2580850 | kg:/m/0cy_wb | William | Sullivan | 1857-12-18 | M | 22450 | Van Amberg | ||||||||||||||||
S001065 | William Sulzer | S001065 | 410519 | 9080 | William Sulzer | Q881099 | kg:/m/030pfr | William | Sulzer | 1863-03-18 | M | 22455 | |||||||||||||||||
S001086 | William Sutphin | S001086 | 410539 | 9098 | William H. Sutphin | Q997295 | kg:/m/0721_d | William | Sutphin | 1887-08-30 | M | 22482 | Halstead | ||||||||||||||||
S001104 | William Sweeney | S001104 | 410556 | 9114 | William N. Sweeney | Q1551193 | kg:/m/02rj_v3 | William | Sweeney | 1832-05-05 | M | 22501 | Northcut | ||||||||||||||||
S001126 | William Swoope | S001126 | 410577 | 9133 | William Irvin Swoope | Q13219840 | kg:/m/0fqr_3 | William | Swoope | 1862-10-03 | M | 22527 | Irvin | ||||||||||||||||
S001136 | William Symington | S001136 | 410586 | 9141 | Stuart Symington | Q962660 | kg:/m/03fj2d | William | Symington | 1901-06-26 | M | Stuart | Stuart | 01444 | |||||||||||||||
T000016 | William Talbert | T000016 | 410606 | 9158 | W. Jasper Talbert | Q1550838 | kg:/m/02rtqm3 | William | Talbert | 1846-10-06 | M | 22651 | Jasper | ||||||||||||||||
T000055 | William Taulbee | T000055 | 410643 | 9191 | William P. Taulbee | Q928242 | kg:/m/02rj_x5 | William | Taulbee | 1851-10-22 | M | 22700 | Preston | ||||||||||||||||
T000058 | William Tauzin | T000058 | 400397 | 14679 | Billy Tauzin | Q863238 | kg:/m/025jtz | William | Tauzin | 1943-06-14 | M | 22705 | J. | Billy | 01140 | N00005372 | |||||||||||||
T000103 | William Taylor | T000103 | 410686 | 9234 | William Taylor (New York politician) | Q8019203 | kg:/m/02rqbtt | William | Taylor | 1791-10-12 | M | 22760 | |||||||||||||||||
T000104 | William Taylor | T000104 | 410687 | 9235 | William Taylor (Virginia politician, born 1788) | Q2580723 | kg:/m/0288m9f | William | Taylor | 1788-04-05 | M | 22761 | |||||||||||||||||
T000105 | William Taylor | T000105 | 412111 | 9236 | William P. Taylor | Q225991 | kg:/m/027y450 | William | Taylor | M | 22762 | Penn | |||||||||||||||||
T000120 | William Temple | T000120 | 410702 | 9250 | William Temple (politician) | Q886868 | kg:/m/07szwm | William | Temple | 1814-02-28 | M | 22780 | |||||||||||||||||
T000132 | William Terrell | T000132 | 410714 | 9261 | William Terrell | Q2580742 | kg:/m/0crb7f | William | Terrell | M | 22793 | ||||||||||||||||||
T000136 | William Terry | T000136 | 410718 | 9264 | William Terry (congressman) | Q3205 | kg:/m/02pmnqn | William | Terry | 1824-08-14 | M | 22797 | |||||||||||||||||
T000137 | William Terry | T000137 | 410719 | 9265 | William L. Terry | Q788199 | kg:/m/02rj_rc | William | Terry | 1850-09-27 | M | 22799 | Leake | ||||||||||||||||
T000155 | William Thom | T000155 | 410737 | 9283 | William R. Thom | Q8017296 | kg:/m/02rj_yk | William | Thom | 1885-07-07 | M | 22818 | Richard | ||||||||||||||||
T000186 | William Thomas | T000186 | 410767 | 9310 | W. Aubrey Thomas | Q2536632 | kg:/m/02rm3bs | William | Thomas | 1866-06-07 | M | 22860 | Aubrey | ||||||||||||||||
T000187 | William Thomas | T000187 | 410768 | 9311 | William D. Thomas | Q8007521 | kg:/m/02r7vw5 | William | Thomas | 1880-03-22 | M | 22861 | David | ||||||||||||||||
T000188 | William Thomas | T000188 | 400401 | 14669 | Bill Thomas | Q132302 | kg:/m/024tf3 | William | Thomas | 1941-12-06 | M | 22863 | M. | Bill | 01148 | N00007256 | |||||||||||||
T000190 | William Thomasson | T000190 | 410770 | 9313 | William Thomasson | Q2580772 | kg:/m/02rk01p | William | Thomasson | 1797-10-08 | M | 22866 | Poindexter | ||||||||||||||||
T000223 | William Thompson | T000223 | 410802 | 9344 | William Thompson (Iowa politician) | Q2580776 | kg:/m/0988zm | William | Thompson | 1813-11-10 | M | 22906 | |||||||||||||||||
T000224 | William Thompson | T000224 | 410803 | 9345 | William George Thompson | Q1581134 | kg:/m/0d52ld | William | Thompson | 1830-01-17 | M | 22907 | George | ||||||||||||||||
T000225 | William Thompson | T000225 | 410804 | 9346 | William Henry Thompson | Q2579261 | kg:/m/09wyc7 | William | Thompson | 1853-12-14 | M | Henry | |||||||||||||||||
T000226 | William Thompson | T000226 | 410805 | 9347 | William Howard Thompson | Q6208747 | kg:/m/0cvscr | William | Thompson | 1871-10-14 | M | Howard | |||||||||||||||||
T000237 | William Thornberry | T000237 | 410816 | 9356 | Homer Thornberry | Q1626038 | kg:/m/06ktc0 | William | Thornberry | 1909-01-09 | M | 22920 | Homer | ||||||||||||||||
T000267 | William Tierney | T000267 | 410840 | 9379 | William L. Tierney | Q476893 | kg:/m/02rj_sr | William | Tierney | 1876-08-06 | M | 22958 | Laurence | ||||||||||||||||
T000318 | William Tou Velle | T000318 | 410890 | 9426 | William E. Tou Velle | Q8008323 | kg:/m/02rm4w7 | William | Tou Velle | 1862-11-23 | M | 23022 | Ellsworth | ||||||||||||||||
T000349 | William Traeger | T000349 | 410920 | 9453 | William I. Traeger | Q2579377 | kg:/m/0ksxyw | William | Traeger | 1880-02-26 | M | 23063 | Isham | ||||||||||||||||
T000360 | William Tredway | T000360 | 410930 | 9462 | William Tredway | Q2580801 | kg:/m/03c2_fj | William | Tredway | 1807-08-24 | M | 23075 | Marshall | ||||||||||||||||
T000363 | William Treloar | T000363 | 410933 | 9464 | William M. Treloar | Q2579830 | kg:/m/027lc_q | William | Treloar | 1850-09-21 | M | 23079 | Mitchellson | ||||||||||||||||
T000377 | William Trimble | T000377 | 410946 | 9477 | William A. Trimble | Q340200 | kg:/m/0351z0 | William | Trimble | 1786-04-04 | M | Allen | |||||||||||||||||
T000384 | William Troutman | T000384 | 410953 | 9484 | William I. Troutman | Q8012773 | kg:/m/09j24x | William | Troutman | 1905-01-13 | M | 23104 | Irvin | ||||||||||||||||
T000395 | William Tuck | T000395 | 410964 | 9494 | William M. Tuck | Q725740 | kg:/m/084myx | William | Tuck | 1896-09-28 | M | 23117 | Munford | ||||||||||||||||
T000439 | William Tuttle | T000439 | 411007 | 9532 | William E. Tuttle Jr. | Q1645378 | kg:/m/02x12y2 | William | Tuttle | 1870-12-10 | M | 23173 | Edgar | Jr. | |||||||||||||||
T000440 | William Tweed | T000440 | 411008 | 9533 | William M. Tweed | Q1353450 | kg:/m/01hfn | William | Tweed | 1823-04-03 | M | 23174 | Marcy | ||||||||||||||||
T000451 | William Tyndall | T000451 | 411019 | 9543 | William T. Tyndall | Q1416107 | kg:/m/02rz8mh | William | Tyndall | 1862-01-16 | M | 23188 | Thomas | ||||||||||||||||
T000480 | William Timmons | T000480 | 412815 | 21974 | William Timmons | Q28837296 | kg:/g/11g6ns21_f | William | Timmons | 1984-04-30 | M | R. | William Timmons | 168923 | William R. Timmons IV | N00042715 | [ "H8SC04250" ] |
||||||||||||
U000005 | William Umstead | U000005 | 411029 | 9552 | William B. Umstead | Q362840 | kg:/m/0281fg | William | Umstead | 1895-05-13 | M | 20832 | Bradley | ||||||||||||||||
U000025 | William Upham | U000025 | 411048 | 9570 | William Upham | Q2580835 | kg:/m/0cy1zc | William | Upham | 1792-08-05 | M | ||||||||||||||||||
U000026 | William Upshaw | U000026 | 411049 | 9571 | William David Upshaw | Q2578400 | kg:/m/08k6yl | William | Upshaw | 1866-10-15 | M | 20862 | David | ||||||||||||||||
U000029 | William Upson | U000029 | 411052 | 9574 | William H. Upson | Q8010633 | kg:/m/02r1kjd | William | Upson | 1823-01-11 | M | 20865 | Hanford | ||||||||||||||||
V000004 | William Vaile | V000004 | 411063 | 9585 | William N. Vaile | Q2580103 | kg:/m/02rj_vg | William | Vaile | 1876-06-22 | M | 20883 | Newell | ||||||||||||||||
V000007 | William Valk | V000007 | 411066 | 9587 | William Valk | Q129719 | kg:/m/0d80z4 | William | Valk | 1806-10-12 | M | 20887 | Weightman | ||||||||||||||||
V000031 | William Vandever | V000031 | 411124 | 9607 | William Vandever | Q2580869 | kg:/m/0f12q6 | William | Vandever | 1817-03-31 | M | 20915 | |||||||||||||||||
V000051 | William Van Pelt | V000051 | 411093 | 9627 | William Van Pelt | Q2580867 | kg:/m/02718z3 | William | Van Pelt | 1905-03-10 | M | 20936 | Kaiser | ||||||||||||||||
V000068 | William Van Wyck | V000068 | 411110 | 9644 | William W. Van Wyck | Q501765 | kg:/m/02rldkw | William | Van Wyck | 1777-08-09 | M | 20956 | William |
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);