legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
78 rows where name_first = "Albert"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A000180 | Albert Anderson | A000180 | 400835 | 159 | Albert R. Anderson | Q225943 | kg:/m/02rk72h | Albert | Anderson | 1837-11-08 | M | 8508 | Raney | ||||||||||||||||
A000339 | Albert Austin | A000339 | 400989 | 293 | Albert E. Austin | Q116257 | kg:/m/02rgt_0 | Albert | Austin | 1877-11-15 | M | 8728 | Elmer | ||||||||||||||||
B000245 | Albert Baumhart | B000245 | 401239 | 521 | Albert David Baumhart Jr. | Q4710010 | kg:/m/027m6z7 | Albert | Baumhart | 1908-06-15 | M | 9096 | David | Jr. | |||||||||||||||
B000414 | Albert Berry | B000414 | 401401 | 670 | Albert S. Berry | Q700005 | kg:/m/02rgv0r | Albert | Berry | 1836-05-13 | M | 9314 | Seaton | ||||||||||||||||
B000429 | Albert Beveridge | B000429 | 401415 | 683 | Albert J. Beveridge | Q982853 | kg:/m/04sjby | Albert | Beveridge | 1862-10-06 | M | Jeremiah | |||||||||||||||||
B000535 | Albert Blakeney | B000535 | 401510 | 776 | Albert Blakeney | Q759154 | kg:/m/09166n | Albert | Blakeney | 1850-09-28 | M | 9464 | Alexander | ||||||||||||||||
B000646 | Albert Bosch | B000646 | 401610 | 868 | Albert H. Bosch | Q868566 | kg:/m/0kt22l | Albert | Bosch | 1908-10-30 | M | 9620 | Henry | ||||||||||||||||
B000900 | Albert Brown | B000900 | 401857 | 1095 | Albert G. Brown | Q880583 | kg:/m/0464h2 | Albert | Brown | 1813-05-31 | M | 9945 | Gallatin | ||||||||||||||||
B001110 | Albert Burleson | B001110 | 402055 | 1281 | Albert S. Burleson | Q724135 | kg:/m/02t3g3 | Albert | Burleson | 1863-06-07 | M | 10207 | Sidney | ||||||||||||||||
B001134 | Albert Burr | B001134 | 402078 | 1303 | Albert G. Burr | Q4710255 | kg:/m/02pvqkk | Albert | Burr | 1829-11-08 | M | 10234 | George | ||||||||||||||||
B001172 | Albert Bustamante | B001172 | 402114 | 15089 | Albert Bustamante | Q2637741 | kg:/m/027hzz4 | Albert | Bustamante | 1935-04-08 | M | 10284 | Garza | 00158 | |||||||||||||||
C000070 | Albert Camp | C000070 | 402228 | 1439 | Albert Sidney Camp | Q2638829 | kg:/m/0gr_pl | Albert | Camp | 1892-07-26 | M | 10532 | Sidney | ||||||||||||||||
C000074 | Albert Campbell | C000074 | 402231 | 1441 | Albert J. Campbell | Q1723385 | kg:/m/02rgv01 | Albert | Campbell | 1857-12-12 | M | 10538 | James | ||||||||||||||||
C000162 | Albert Carnahan | C000162 | 402310 | 1517 | A. S. J. Carnahan | Q279153 | kg:/m/03ycb1 | Albert | Carnahan | 1897-01-09 | M | 10657 | Sidney Johnson | ||||||||||||||||
C000195 | Albert Carter | C000195 | 402341 | 1545 | Albert E. Carter | Q1485451 | kg:/m/0dfqw_ | Albert | Carter | 1881-07-05 | M | 10697 | Edward | ||||||||||||||||
C000290 | Albert Chandler | C000290 | 402432 | 1634 | Happy Chandler | Q573029 | kg:/m/01s8l0 | Albert | Chandler | 1898-07-14 | M | Benjamin | Happy | ||||||||||||||||
C000606 | Albert Cole | C000606 | 402735 | 1920 | Albert M. Cole | Q1431467 | kg:/m/02rm9cn | Albert | Cole | 1901-10-13 | M | 11208 | McDonald | ||||||||||||||||
C000708 | Albert Constable | C000708 | 402832 | 2008 | Albert Constable | Q1726968 | kg:/m/02qw3s6 | Albert | Constable | 1805-06-03 | M | 11340 | |||||||||||||||||
C000905 | Albert Cretella | C000905 | 403017 | 2174 | Albert W. Cretella | Q2638987 | kg:/m/02rgv1f | Albert | Cretella | 1897-04-22 | M | 11588 | William | ||||||||||||||||
C000988 | Albert Cummins | C000988 | 403096 | 2252 | Albert B. Cummins | Q377161 | kg:/m/037fr0 | Albert | Cummins | 1850-02-15 | M | Baird | |||||||||||||||||
D000150 | Albert Dawson | D000150 | 403283 | 2425 | Albert F. Dawson | Q2637869 | kg:/m/02rk71t | Albert | Dawson | 1872-01-26 | M | 12018 | Foster | ||||||||||||||||
D000449 | Albert Douglas | D000449 | 403559 | 2685 | Albert Douglas | Q4710044 | kg:/m/02rlzmt | Albert | Douglas | 1852-04-25 | M | 12392 | |||||||||||||||||
E000087 | Albert Egbert | E000087 | 403780 | 2879 | Albert Gallatin Egbert | Q4710276 | kg:/m/0kt1n6 | Albert | Egbert | 1828-04-13 | M | 12705 | Gallatin | ||||||||||||||||
E000178 | Albert Engel | E000178 | 403868 | 2963 | Albert J. Engel | Q2638222 | kg:/m/027jzq8 | Albert | Engel | 1888-01-01 | M | 12813 | Joseph | ||||||||||||||||
E000218 | Albert Espy | E000218 | 403904 | 15411 | Mike Espy | Q1400332 | kg:/m/03br4v | Albert | Espy | 1953-11-30 | M | 12872 | Michael | Mike Espy | 00356 | ||||||||||||||
E000224 | Albert Estopinal | E000224 | 403910 | 2996 | Albert Estopinal | Q1404345 | kg:/m/0c3w42 | Albert | Estopinal | 1845-01-30 | M | 12878 | |||||||||||||||||
F000011 | Albert Fall | F000011 | 403973 | 3053 | Albert B. Fall | Q1397640 | kg:/m/02qbq6 | Albert | Fall | 1861-11-26 | M | Bacon | |||||||||||||||||
F000285 | Albert Forsythe | F000285 | 404235 | 3288 | Albert P. Forsythe | Q4710941 | kg:/m/02rk8st | Albert | Forsythe | 1830-05-24 | M | 13332 | Palaska | ||||||||||||||||
G000020 | Albert Gallatin | G000020 | 404397 | 3437 | Albert Gallatin | Q500046 | kg:/m/01p369 | Albert | Gallatin | 1761-01-29 | M | 13588 | |||||||||||||||||
G000028 | Albert Gallup | G000028 | 404404 | 3443 | Albert Gallup | Q1659364 | kg:/m/02rkly9 | Albert | Gallup | 1796-01-30 | M | 13599 | |||||||||||||||||
G000305 | Albert Goodwyn | G000305 | 404664 | 3690 | Albert Taylor Goodwyn | Q1326598 | kg:/m/02rk19x | Albert | Goodwyn | 1842-12-17 | M | 13949 | Taylor | ||||||||||||||||
G000320 | Albert Gore | G000320 | 404678 | 3704 | Albert Gore Sr. | Q577160 | kg:/m/025wp3 | Albert | Gore | 1907-12-26 | M | 13968 | Arnold | ||||||||||||||||
G000321 | Albert Gore | G000321 | 404679 | 14423 | Al Gore | Q19673 | kg:/m/0d05fv | Albert | Gore | 1948-03-31 | M | 13970 | Arnold | Al Gore | Jr. | 00449 | S170 | ||||||||||||
G000424 | Albert Greene | G000424 | 404771 | 3788 | Albert C. Greene | Q2622636 | kg:/m/0d2l_x | Albert | Greene | 1792-04-15 | M | Collins | |||||||||||||||||
H000042 | Albert Hall | H000042 | 404927 | 3930 | Albert R. Hall (Indiana politician) | Q2638611 | kg:/m/02rkdrn | Albert | Hall | 1884-08-27 | M | 14339 | Richardson | ||||||||||||||||
H000261 | Albert Harrison | H000261 | 405138 | 4122 | Albert Galliton Harrison | Q996927 | kg:/m/02rz5d9 | Albert | Harrison | 1800-06-26 | M | 14607 | Galliton | ||||||||||||||||
H000360 | Albert Hawes | H000360 | 405229 | 4205 | Albert Gallatin Hawes | Q2638001 | kg:/m/02vl9f4 | Albert | Hawes | 1804-04-01 | M | 14724 | Gallatin | ||||||||||||||||
H000365 | Albert Hawkes | H000365 | 405234 | 4210 | Albert W. Hawkes | Q1675301 | kg:/m/0csxvw | Albert | Hawkes | 1878-11-20 | M | Wahl | |||||||||||||||||
H000530 | Albert Herlong | H000530 | 405392 | 4354 | Syd Herlong | Q2638906 | kg:/m/02rgvx8 | Albert | Herlong | 1909-02-14 | M | 14941 | Sydney | Jr. | |||||||||||||||
H000769 | Albert Hopkins | H000769 | 405619 | 4563 | Albert Cole Hopkins | Q4709953 | kg:/m/0ksflw | Albert | Hopkins | 1837-09-15 | M | 15237 | Cole | ||||||||||||||||
H000770 | Albert Hopkins | H000770 | 405620 | 4564 | Albert J. Hopkins | Q436348 | kg:/m/08568c | Albert | Hopkins | 1846-08-15 | M | 15239 | Jarvis | ||||||||||||||||
H000850 | Albert Howe | H000850 | 405697 | 4637 | Albert R. Howe | Q1679207 | kg:/m/02rtnk1 | Albert | Howe | 1840-01-01 | M | 15337 | Richards | ||||||||||||||||
J000067 | Albert Jefferis | J000067 | 405972 | 4901 | Albert W. Jefferis | Q132424 | kg:/m/0b7553 | Albert | Jefferis | 1868-12-07 | M | 15777 | Webb | ||||||||||||||||
J000081 | Albert Jenkins | J000081 | 405984 | 4912 | Albert G. Jenkins | Q2484581 | kg:/m/0d9wfj | Albert | Jenkins | 1830-11-10 | M | 15796 | Gallatin | ||||||||||||||||
J000114 | Albert Johnson | J000114 | 406015 | 4939 | Albert Johnson (congressman) | Q477245 | kg:/m/02rqbw5 | Albert | Johnson | 1869-03-05 | M | 15836 | |||||||||||||||||
J000115 | Albert Johnson | J000115 | 406016 | 10598 | Albert W. Johnson | Q4711410 | kg:/m/0dxttk | Albert | Johnson | 1906-04-17 | M | 15838 | Walter | 00597 | |||||||||||||||
M000123 | Albert Marchand | M000123 | 407147 | 5975 | Albert Gallatin Marchand | Q4710278 | kg:/m/026tc94 | Albert | Marchand | 1811-02-27 | M | 17481 | Gallatin | ||||||||||||||||
M000935 | Albert Morano | M000935 | 407904 | 6664 | Albert P. Morano | Q2638558 | kg:/m/02rgv0d | Albert | Morano | 1908-01-18 | M | 18506 | Paul | ||||||||||||||||
P000164 | Albert Pearson | P000164 | 408569 | 7285 | Albert J. Pearson | Q4710544 | kg:/m/02rlznh | Albert | Pearson | 1846-05-20 | M | 19481 | Jackson | ||||||||||||||||
P000407 | Albert Polk | P000407 | 408800 | 7505 | Albert F. Polk | Q2637870 | kg:/m/0gf24n | Albert | Polk | 1869-10-11 | M | 19784 | Fawcett | ||||||||||||||||
P000435 | Albert Porter | P000435 | 408826 | 7529 | Albert G. Porter | Q2638594 | kg:/m/0bvybp | Albert | Porter | 1824-04-20 | M | 19821 | Gallatin | ||||||||||||||||
Q000010 | Albert Quie | Q000010 | 408973 | 7671 | Al Quie | Q888927 | kg:/m/01jf7h | Albert | Quie | 1923-09-18 | M | 20055 | Harold | 00936 | |||||||||||||||
R000018 | Albert Rains | R000018 | 409000 | 7695 | Albert Rains | Q534486 | kg:/m/02rk19k | Albert | Rains | 1902-03-11 | M | 20097 | McKinley | ||||||||||||||||
R000137 | Albert Reeves | R000137 | 409116 | 7803 | Albert L. Reeves Jr. | Q1668288 | kg:/m/02rz5dn | Albert | Reeves | 1906-05-31 | M | 20250 | Lee | Jr. | |||||||||||||||
R000238 | Albert Riddle | R000238 | 409214 | 7891 | Albert G. Riddle | Q1418938 | kg:/m/02rlzn4 | Albert | Riddle | 1816-05-28 | M | 20378 | Gallatin | ||||||||||||||||
R000457 | Albert Rossdale | R000457 | 409421 | 8079 | Albert B. Rossdale | Q4709674 | kg:/m/02rklxz | Albert | Rossdale | 1878-10-23 | M | 20647 | Berger | ||||||||||||||||
R000544 | Albert Rust | R000544 | 412093 | 8145 | Albert Rust | Q1532143 | kg:/m/01vy2p | Albert | Rust | M | 20752 | ||||||||||||||||||
R000546 | Albert Rutherford | R000546 | 409502 | 8146 | Albert G. Rutherford | Q4710266 | kg:/m/0f3c1t | Albert | Rutherford | 1879-01-03 | M | 20754 | Greig | ||||||||||||||||
S000302 | Albert Shaw | S000302 | 409801 | 8414 | Albert D. Shaw | Q4709999 | kg:/m/03c2zb1 | Albert | Shaw | 1841-12-21 | M | 21510 | Duane | ||||||||||||||||
S000420 | Albert Simms | S000420 | 409914 | 8519 | Albert G. Simms | Q2637990 | kg:/m/02ptyj9 | Albert | Simms | 1882-10-08 | M | 21660 | Gallatin | ||||||||||||||||
S000512 | Albert Smith | S000512 | 409998 | 8600 | Albert Smith (New York politician) | Q4711229 | kg:/m/02rl4gt | Albert | Smith | 1805-06-22 | M | 21776 | |||||||||||||||||
S000513 | Albert Smith | S000513 | 409997 | 8599 | Albert Smith (Maine politician) | Q2638849 | kg:/m/02rl4h4 | Albert | Smith | 1793-01-03 | M | 21777 | |||||||||||||||||
S000514 | Albert Smith | S000514 | 409999 | 14862 | Albert L. Smith Jr. | Q632825 | kg:/m/02qhvzf | Albert | Smith | 1931-08-31 | M | 21778 | Lee | Jr. | 01070 | ||||||||||||||
T000020 | Albert Talbott | T000020 | 410610 | 9162 | Albert G. Talbott | Q2637995 | kg:/m/02qft5z | Albert | Talbott | 1808-04-04 | M | 22656 | Gallatin | ||||||||||||||||
T000156 | Albert Thomas | T000156 | 410738 | 9284 | Albert Richard Thomas | Q2638644 | kg:/m/02w8dnl | Albert | Thomas | 1898-04-12 | M | 22820 | |||||||||||||||||
T000191 | Albert Thompson | T000191 | 410771 | 9314 | Albert C. Thompson | Q4709866 | kg:/m/02rlzmg | Albert | Thompson | 1842-01-23 | M | 22867 | Clifton | ||||||||||||||||
T000291 | Albert Todd | T000291 | 410864 | 9403 | Albert M. Todd | Q2638433 | kg:/m/053jrd | Albert | Todd | 1850-06-03 | M | 22987 | May | ||||||||||||||||
T000343 | Albert Tracy | T000343 | 410914 | 9447 | Albert H. Tracy | Q4710382 | kg:/m/02rkly_ | Albert | Tracy | 1793-06-17 | M | 23056 | Haller | ||||||||||||||||
U000004 | Albert Ullman | U000004 | 411028 | 9551 | Al Ullman | Q2620782 | kg:/m/036t36 | Albert | Ullman | 1914-03-09 | M | 20830 | Conrad | 01174 | |||||||||||||||
V000077 | Albert Vaughn | V000077 | 411134 | 9653 | Albert C. Vaughn | Q4709867 | kg:/m/0f1t5n | Albert | Vaughn | 1894-10-09 | M | 20967 | Clinton | Sr. | |||||||||||||||
V000092 | Albert Vestal | V000092 | 411147 | 9666 | Albert Henry Vestal | Q427202 | kg:/m/038ksv | Albert | Vestal | 1875-01-18 | M | 20986 | Henry | ||||||||||||||||
V000121 | Albert Vreeland | V000121 | 411175 | 9690 | Albert L. Vreeland | Q2638367 | kg:/m/02rytw_ | Albert | Vreeland | 1901-07-02 | M | 21021 | Lincoln | ||||||||||||||||
W000189 | Albert Watkins | W000189 | 411361 | 9864 | Albert Galiton Watkins | Q2637997 | kg:/m/0d9sh4 | Albert | Watkins | 1818-05-05 | M | 23440 | Galiton | ||||||||||||||||
W000197 | Albert Watson | W000197 | 411368 | 10634 | Albert Watson (South Carolina politician) | Q2639063 | kg:/m/03r8_r | Albert | Watson | 1922-08-30 | M | 23449 | William | ||||||||||||||||
W000351 | Albert White | W000351 | 411513 | 10005 | Albert Smith White | Q1720656 | kg:/m/05qqcq | Albert | White | 1803-10-24 | M | 23634 | Smith | ||||||||||||||||
W000485 | Albert Willford | W000485 | 411642 | 10130 | Albert C. Willford | Q1600446 | kg:/m/02rk71g | Albert | Willford | 1877-09-21 | M | 23793 | Clinton | ||||||||||||||||
W000557 | Albert Willis | W000557 | 411713 | 10199 | Albert S. Willis | Q2638694 | kg:/m/02rgv12 | Albert | Willis | 1843-01-22 | M | 23874 | Shelby | ||||||||||||||||
W000784 | Albert Wynn | W000784 | 400438 | 29355 | Albert Wynn | Q1619372 | kg:/m/025k3y | Albert | Wynn | 1951-09-10 | M | 24158 | Russell | 01251 | 26889 | N00001849 | [ "H2MD05361" ] |
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);