legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
12,598 rows sorted by bio_gender
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
S000770 | Debbie Stabenow | S000770 | 300093 | 29732 | Debbie Stabenow | Q241092 | kg:/m/01xh64 | Debbie | Stabenow | 1950-04-29 | F | 22090 | Ann | Debbie Stabenow | 01531 | 45451 | 515 | S284 | Debbie Stabenow | N00004118 | [ "S8MI00281", "H6MI08163" ] |
612 | [ { "title": "Senate Democratic Policy & Communications Committee Chair", "chamber": "senate", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "Senate Democratic Policy & Communications Committee Chair", "chamber": "senate", "start": "2021-01-03" } ] |
||||||
S000798 | Winifred Stanley | S000798 | 410264 | 8840 | Winifred C. Stanley | Q8025372 | kg:/m/026g501 | Winifred | Stanley | 1909-08-14 | F | 22127 | Claire | ||||||||||||||||
S000929 | Victoria Spartz | S000929 | 456822 | Victoria Spartz | Q44059867 | kg:/g/11h23hjb94 | Victoria | Spartz | 1978-10-06 | F | Victoria Spartz | N00046537 | [ "H0IN05326" ] |
||||||||||||||||
S001057 | Leonor Sullivan | S001057 | 410511 | 9072 | Leonor Sullivan | Q514368 | kg:/m/0852kx | Leonor | Sullivan | 1902-08-21 | F | 22444 | Kretzer | 01124 | |||||||||||||||
S001071 | Jessie Sumner | S001071 | 410525 | 9086 | Jessie Sumner | Q8236554 | kg:/m/02rkbb_ | Jessie | Sumner | 1898-07-17 | F | 22462 | |||||||||||||||||
S001135 | Michelle Steel | S001135 | 456803 | Michelle Steel | Q6837200 | kg:/m/028bz6v | Michelle | Steel | 1955-06-21 | F | Eunjoo | Michelle Steel | N00044501 | [ "H0CA48198" ] |
|||||||||||||||
S001145 | Janice Schakowsky | S001145 | 400360 | 29911 | Jan Schakowsky | Q440885 | kg:/m/0256nw | Janice | Schakowsky | 1944-05-26 | F | 22550 | D. | Jan | Jan Schakowsky | 01588 | 57874 | 6387 | Janice D. Schakowsky | N00004724 | [ "H8IL09067" ] |
452 | |||||||
S001153 | Hilda Solis | S001153 | 400384 | 20105 | Hilda Solis | Q50610 | kg:/m/024ttc | Hilda | Solis | 1957-10-20 | F | 22566 | L. | 01636 | 85603 | 3585 | N00009586 | [ "H0CA31087" ] |
|||||||||||
S001156 | Linda Sánchez | S001156 | 400355 | 20310 | Linda Sánchez | Q291143 | kg:/m/024xc7 | Linda | Sánchez | 1969-01-28 | F | 22572 | T. | Linda Sánchez | 01757 | 1003554 | 29674 | Linda T. Sánchez | N00024870 | [ "H2CA39078" ] |
448 | [ { "name": "Loretta Sanchez", "relation": "sister" } ] |
|||||||
S001159 | Marilyn Strickland | S001159 | 456854 | Marilyn Strickland | Q1898180 | kg:/m/0bhb38l | Marilyn | Strickland | 1962-09-25 | F | Marilyn Strickland | N00046320 | [ "H0WA10034" ] |
||||||||||||||||
S001162 | Allyson Schwartz | S001162 | 400647 | 20525 | Allyson Schwartz | Q202495 | kg:/m/04bbm6 | Allyson | Schwartz | 1948-10-03 | F | 22582 | Y. | Allyson Schwartz | 01798 | 57332 | 5239 | Allyson Y. Schwartz | N00001579 | [ "H4PA13124", "S8PA00163" ] |
653 | ||||||||
S001164 | Jean Schmidt | S001164 | 412010 | 20540 | Jean Schmidt | Q465887 | kg:/m/06d450 | Jean | Schmidt | 1951-11-29 | F | 22585 | 01815 | 1017087 | 45475 | Jean Schmidt | N00027526 | [ "H6OH02086" ] |
|||||||||||
S001166 | Shelley Sekula-Gibbs | S001166 | 412185 | 20541 | Shelley Sekula-Gibbs | Q2277934 | kg:/m/0gcngz | Shelley | Sekula-Gibbs | 1953-06-22 | F | 22589 | 01819 | N00028489 | |||||||||||||||
S001170 | Carol Shea-Porter | S001170 | 412219 | 20731 | Carol Shea-Porter | Q434112 | kg:/m/0fvcl4 | Carol | Shea-Porter | 1952-12-02 | F | 22596 | Carol Shea-Porter | 01861 | 1021773 | 65891 | Carol Shea-Porter | N00028091 | [ "H6NH01230" ] |
704 | |||||||||
S001174 | Betty Sutton | S001174 | 412228 | 20740 | Betty Sutton | Q436825 | kg:/m/0fzd66 | Betty | Sutton | 1963-07-31 | F | 22604 | 01870 | 8394 | Betty Sutton | N00027901 | [ "H6OH13133" ] |
||||||||||||
S001175 | Jackie Speier | S001175 | 412259 | 20762 | Jackie Speier | Q218544 | kg:/m/06k27l | Jackie | Speier | 1950-05-14 | F | 22606 | Jackie Speier | 01890 | 1027627 | 8425 | Jackie Speier | N00029649 | [ "H8CA12171" ] |
740 | |||||||||
S001181 | Jeanne Shaheen | S001181 | 412323 | 40906 | Jeanne Shaheen | Q270316 | kg:/m/01rrm2 | Jeanne | Shaheen | 1947-01-28 | F | 22618 | Jeanne Shaheen | 01901 | 22850 | 1663 | S324 | Jeanne Shaheen | N00024790 | [ "S0NH00219" ] |
805 | ||||||||
S001185 | Terri Sewell | S001185 | 412396 | 21102 | Terri Sewell | Q461621 | kg:/m/05pbszt | Terri | Sewell | 1965-01-01 | F | 22624 | A. | Terri Sewell | 01988 | 623257 | 121621 | Terri Sewell | N00030622 | [ "H0AL07086" ] |
1410 | ||||||||
S001191 | Kyrsten Sinema | S001191 | 412509 | 21300 | Kyrsten Sinema | Q1556541 | kg:/m/03qnndb | Kyrsten | Sinema | 1976-07-12 | F | 15032387755 | Kyrsten Sinema | 02099 | 68489 | 28338 | S403 | Kyrsten Sinema | N00033983 | [ "H2AZ09019", "S8AZ00197" ] |
1733 | ||||||||
S001196 | Elise Stefanik | S001196 | 412648 | 21541 | Elise Stefanik | Q18211057 | kg:/m/0110fjsf | Elise | Stefanik | 1984-07-02 | F | 15032411587 | M. | Elise Stefanik | 02263 | 76364 | 152539 | Elise M. Stefanik | N00035523 | [ "H4NY21079" ] |
2104 | [ { "title": "House Republican Conference Chair", "chamber": "house", "start": "2021-05-14" } ] |
|||||||
S001203 | Tina Smith | S001203 | 412742 | 41706 | Tina Smith | Q18631509 | kg:/m/0127xvy3 | Tina | Smith | 1958-03-04 | F | Flint | Tina Smith | 111313 | 152968 | S394 | Tina Smith | N00042353 | [ "S8MN00578" ] |
2253 | |||||||||
S001205 | Mary Scanlon | S001205 | 412750 | 21762 | Mary Gay Scanlon | Q54611716 | kg:/g/11gtg87gkn | Mary | Scanlon | 1959-08-30 | F | Gay | Mary Gay Scanlon | 178890 | Mary Gay Scanlon | N00042706 | [ "H8PA07200" ] |
||||||||||||
S001206 | Donna Shalala | S001206 | 412768 | 21963 | Donna Shalala | Q292569 | kg:/m/01v3vb | Donna | Shalala | 1941-02-14 | F | E. | Donna Shalala | 182301 | Donna E. Shalala | N00042811 | [ "H8FL27193" ] |
||||||||||||
S001207 | Mikie Sherrill | S001207 | 412799 | 21964 | Mikie Sherrill | Q47087146 | kg:/g/11f3r4x6x5 | Mikie | Sherrill | 1972-01-19 | F | Mikie Sherrill | 179651 | Mikie Sherrill | N00041154 | [ "H8NJ11142" ] |
|||||||||||||
S001208 | Elissa Slotkin | S001208 | 412784 | 21965 | Elissa Slotkin | Q30323721 | kg:/g/11dfr3z7r1 | Elissa | Slotkin | 1976-07-10 | F | Elissa Slotkin | 181080 | Elissa Slotkin | N00041357 | [ "H8MI08102" ] |
|||||||||||||
S001209 | Abigail Spanberger | S001209 | 412833 | 21966 | Abigail Spanberger | Q55603085 | kg:/g/11fgm1ffs7 | Abigail | Spanberger | 1979-08-07 | F | Davis | Abigail Spanberger | 179682 | Abigail Davis Spanberger | N00041418 | [ "H8VA07094" ] |
||||||||||||
S001215 | Haley Stevens | S001215 | 412786 | 21972 | Haley Stevens | Q58322563 | kg:/g/11fjw095g8 | Haley | Stevens | 1983-06-24 | F | M. | Haley Stevens | 181092 | Haley M. Stevens | N00040915 | [ "H8MI11254" ] |
||||||||||||
S001216 | Kim Schrier | S001216 | 412835 | 21962 | Kim Schrier | Q58333616 | kg:/g/11fk1mqvq7 | Kim | Schrier | 1968-08-23 | F | Kim Schrier | 181124 | Kim Schrier | N00041606 | [ "H8WA08189" ] |
|||||||||||||
S001218 | Melanie Stansbury | S001218 | 456861 | Melanie Stansbury | Q96184996 | Melanie | Stansbury | 1979-01-31 | F | Ann | Melanie Ann Stansbury | Melanie A. Stansbury | N00047871 | [ "H2NM01144" ] |
|||||||||||||||
T000057 | Ellen Tauscher | T000057 | 400396 | 29705 | Ellen Tauscher | Q459624 | kg:/m/024skq | Ellen | Tauscher | 1951-11-15 | F | 22703 | O. | 01533 | 94 | N00007422 | [ "H6CA10088" ] |
||||||||||||
T000178 | Lera Thomas | T000178 | 410759 | 10792 | Lera Millard Thomas | Q279351 | kg:/m/02vktpl | Lera | Thomas | 1900-08-03 | F | 22848 | Millard | ||||||||||||||||
T000216 | Ruth Thompson | T000216 | 410795 | 9338 | Ruth Thompson | Q515269 | kg:/m/02q1dn2 | Ruth | Thompson | 1887-09-15 | F | 22898 | |||||||||||||||||
T000253 | Karen Thurman | T000253 | 400509 | 29330 | Karen Thurman | Q516718 | kg:/m/06lj67 | Karen | Thurman | 1951-01-12 | F | 22942 | 01157 | ||||||||||||||||
T000465 | Niki Tsongas | T000465 | 412254 | 20754 | Niki Tsongas | Q440246 | kg:/m/02qn5w8 | Niki | Tsongas | 1946-04-26 | F | 23209 | S. | Niki Tsongas | 01884 | 21764 | 89417 | Niki Tsongas | N00029026 | [ "H8MA05143" ] |
735 | [ { "name": "Paul Tsongas", "relation": "wife" } ] |
|||||||
T000468 | Dina Titus | T000468 | 412318 | 20927 | Dina Titus | Q524440 | kg:/m/07hwl2 | Dina | Titus | 1950-05-23 | F | 23215 | Dina Titus | 01940 | 1021622 | 2629 | Dina Titus | N00030191 | [ "H8NV03036" ] |
800 | |||||||||
T000474 | Norma Torres | T000474 | 412617 | 21508 | Norma Torres | Q3343727 | kg:/m/03wd1hs | Norma | Torres | 1965-04-04 | F | 15032410409 | J. | Norma Torres | 02231 | 76129 | 71284 | Norma J. Torres | N00036107 | [ "H4CA35031" ] |
2073 | ||||||||
T000478 | Claudia Tenney | T000478 | 412720 | 21749 | Claudia Tenney | Q5129263 | kg:/m/0g5s72n | Claudia | Tenney | 1961-02-04 | F | Claudia Tenney | 103481 | 127668 | Claudia Tenney | N00036351 | [ "H4NY22051" ] |
2232 | |||||||||||
T000481 | Rashida Tlaib | T000481 | 412787 | 21975 | Rashida Tlaib | Q7294939 | kg:/m/059_x6c | Rashida | Tlaib | 1976-07-24 | F | Rashida Tlaib | 105368 | Rashida Tlaib | N00042649 | [ "H8MI13250" ] |
|||||||||||||
T000482 | Lori Trahan | T000482 | 412781 | 21977 | Lori Trahan | Q56486676 | kg:/g/11gtcg496z | Lori | Trahan | 1973-10-27 | F | Lori Trahan | 182310 | Lori Trahan | N00041808 | [ "H8MA03106" ] |
|||||||||||||
T000484 | Xochitl Torres Small | T000484 | 412801 | 21976 | Xochitl Torres Small | Q58399761 | kg:/g/11gtg88psh | Xochitl | Torres Small | 1984-11-15 | F | Xochitl Torres Small | 177978 | Xochitl Torres Small | N00042467 | [ "H8NM02248" ] |
|||||||||||||
U000017 | Jolene Unsoeld | U000017 | 411040 | 15629 | Jolene Unsoeld | Q518630 | kg:/m/0729__ | Jolene | Unsoeld | 1931-12-03 | F | 20851 | 01176 | ||||||||||||||||
U000040 | Lauren Underwood | U000040 | 412776 | 21979 | Lauren Underwood | Q48471874 | kg:/g/11gfm73_1z | Lauren | Underwood | 1986-10-04 | F | 177001 | Lauren Underwood | N00041569 | [ "H8IL14174" ] |
||||||||||||||
V000081 | Nydia Velázquez | V000081 | 400416 | 29378 | Nydia Velázquez | Q434890 | kg:/m/03sjbt | Nydia | Velázquez | 1953-03-28 | F | 20972 | M. | Nydia Velazquez | 01184 | 26160 | 26975 | Nydia M. Velázquez | N00001102 | [ "H2NY00010" ] |
501 | ||||||||
V000124 | Barbara Vucanovich | V000124 | 411178 | 15075 | Barbara Vucanovich | Q525363 | kg:/m/026yx3p | Barbara | Vucanovich | 1921-06-22 | F | 21026 | Farrell | 01190 | |||||||||||||||
V000134 | Beth Van Duyne | V000134 | 456850 | Beth Van Duyne | Q66309702 | kg:/m/0k1c6d8 | Beth | Van Duyne | 1970-11-16 | F | Ann | Beth Van Duyne | 79150 | Beth Van Duyne | N00045167 | [ "H0TX24209" ] |
|||||||||||||
W000187 | Maxine Waters | W000187 | 400422 | 29106 | Maxine Waters | Q461727 | kg:/m/024tyk | Maxine | Waters | 1938-08-15 | F | 23438 | Maxine Waters | 01205 | 1953 | 26759 | Maxine Waters | N00006690 | [ "H4CA23011" ] |
507 | |||||||||
W000256 | Jessica Weis | W000256 | 411424 | 9920 | Jessica M. Weis | Q6187332 | kg:/m/0h1mfg | Jessica | Weis | 1901-07-08 | F | 23524 | McCullough | ||||||||||||||||
W000634 | Effiegene Wingo | W000634 | 411788 | 10273 | Effiegene Locke Wingo | Q1296186 | kg:/m/02rhfv2 | Effiegene | Wingo | 1883-04-13 | F | 23970 | Locke | ||||||||||||||||
W000714 | Chase Woodhouse | W000714 | 411866 | 10344 | Chase G. Woodhouse | Q1067999 | kg:/m/092_3k | Chase | Woodhouse | 1890-03-03 | F | 24069 | Going | ||||||||||||||||
W000738 | Lynn Woolsey | W000738 | 400436 | 29309 | Lynn Woolsey | Q291157 | kg:/m/024shx | Lynn | Woolsey | 1937-11-03 | F | 24098 | C. | 01242 | 26132 | 26733 | Lynn C. Woolsey | N00007458 | [ "H2CA01045" ] |
||||||||||
W000788 | Nikema Williams | W000788 | 456811 | Nikema Williams | Q56486570 | kg:/g/11fctqx0jy | Nikema | Williams | 1978-07-30 | F | Natassha | Nikema Williams | Nikema Williams | N00047361 | [ "H0GA05301" ] |
||||||||||||||
W000789 | Heather Wilson | W000789 | 400434 | 29779 | Heather Wilson | Q459712 | kg:/m/024vql | Heather | Wilson | 1960-12-30 | F | 24163 | A. | 01539 | 22687 | N00006546 | [ "H8NM01174" ] |
||||||||||||
W000794 | Diane Watson | W000794 | 400423 | 20106 | Diane Watson | Q461497 | kg:/m/024twr | Diane | Watson | 1933-11-12 | F | 24171 | E. | 01682 | 4372 | 3587 | N00013744 | [ "H2CA32099" ] |
|||||||||||
W000797 | Debbie Wasserman Schultz | W000797 | 400623 | 20504 | Debbie Wasserman Schultz | Q50104 | kg:/m/04cmyw | Debbie | Wasserman Schultz | 1966-09-27 | F | 24177 | Debbie Wasserman Schultz | 01777 | 86882 | 24301 | Debbie Wasserman Schultz | N00026106 | [ "H4FL20023" ] |
631 | |||||||||
W000808 | Frederica Wilson | W000808 | 412412 | 21118 | Frederica Wilson | Q461504 | kg:/m/03cg3tv | Frederica | Wilson | 1942-11-05 | F | 24196 | S. | Frederica Wilson | 02004 | 87016 | 17319 | Frederica S. Wilson | N00030650 | [ "H0FL17068" ] |
1424 | ||||||||
W000812 | Ann Wagner | W000812 | 412548 | 21337 | Ann Wagner | Q3917251 | kg:/m/07q9w8 | Ann | Wagner | 1962-09-13 | F | 15032387908 | Ann Wagner | 02137 | 82702 | 136083 | Ann Wagner | N00033106 | [ "H2MO02102" ] |
1772 | |||||||||
W000813 | Jackie Walorski | W000813 | 412538 | 21330 | Jackie Walorski | Q3157413 | kg:/m/0ksf92 | Jackie | Walorski | 1963-08-17 | F | 15032387909 | Jackie Walorski | 02128 | 95005 | 34205 | Jackie Walorski | N00031226 | [ "H0IN02190" ] |
1762 | |||||||||
W000817 | Elizabeth Warren | W000817 | 412542 | 41301 | Elizabeth Warren | Q434706 | kg:/m/01qh39 | Elizabeth | Warren | 1949-06-22 | F | 15032390639 | Elizabeth Warren | 02182 | 1023023 | 141272 | S366 | Elizabeth Warren | N00033492 | [ "S2MA00170" ] |
1766 | ||||||||
W000820 | Mimi Walters | W000820 | 412618 | 21509 | Mimi Walters | Q6862199 | kg:/m/077r0l | Mimi | Walters | 1962-05-14 | F | 15032409970 | 02232 | 76141 | 29346 | Mimi Walters | N00035391 | [ "H4CA45097" ] |
2074 | ||||||||||
W000822 | Bonnie Watson Coleman | W000822 | 412644 | 21538 | Bonnie Watson Coleman | Q4942457 | kg:/m/08kj70 | Bonnie | Watson Coleman | 1945-02-06 | F | 15032409972 | 02259 | 79091 | 24799 | Bonnie Watson Coleman | N00036158 | [ "H4NJ12149" ] |
2100 | ||||||||||
W000825 | Jennifer Wexton | W000825 | 412834 | 21983 | Jennifer Wexton | Q16206735 | kg:/m/0_flt0x | Jennifer | Wexton | 1968-05-27 | F | Jennifer Wexton | 147013 | Jennifer Wexton | N00041002 | [ "H8VA10106" ] |
|||||||||||||
W000826 | Susan Wild | W000826 | 412751 | 21763 | Susan Wild | Q58323072 | kg:/g/11gtg86jn6 | Susan | Wild | 1957-06-07 | F | Ellis | Susan Wild | 178895 | Susan Wild | N00041997 | [ "H8PA15229" ] |
||||||||||||
A000001 | Fred Aandahl | A000001 | 400664 | 1 | Fred G. Aandahl | Q882579 | kg:/m/01grlf | Fred | Aandahl | 1897-04-09 | M | 8247 | George | ||||||||||||||||
A000002 | Watkins Abbitt | A000002 | 400665 | 2 | Watkins Abbitt | Q2552662 | kg:/m/02lhv3 | Watkins | Abbitt | 1908-05-21 | M | 8249 | Moorman | ||||||||||||||||
A000003 | Joel Abbott | A000003 | 400668 | 5 | Joel Abbot (politician) | Q1519100 | kg:/m/0f6gbs | Joel | Abbott | 1776-03-17 | M | 8250 | |||||||||||||||||
A000004 | Amos Abbott | A000004 | 400666 | 3 | Amos Abbott | Q474216 | kg:/m/02lhx9 | Amos | Abbott | 1786-09-10 | M | 8251 | |||||||||||||||||
A000005 | Jo Abbott | A000005 | 400667 | 4 | Joseph Abbott (Texas politician) | Q1706400 | kg:/m/0f6jdp | Jo | Abbott | 1840-01-15 | M | 8253 | Joseph | ||||||||||||||||
A000006 | Joseph Abbott | A000006 | 400669 | 6 | Joseph Carter Abbott | Q1763440 | kg:/m/02klbm | Joseph | Abbott | 1825-07-15 | M | Carter | |||||||||||||||||
A000007 | Josiah Abbott | A000007 | 400670 | 7 | Josiah Gardner Abbott | Q6869444 | kg:/m/02lhzl | Josiah | Abbott | 1814-11-01 | M | 8256 | Gardner | ||||||||||||||||
A000008 | Nehemiah Abbott | A000008 | 400671 | 8 | Nehemiah Abbott | Q1974497 | kg:/m/02lj0q | Nehemiah | Abbott | 1804-03-29 | M | 8257 | |||||||||||||||||
A000009 | James Abdnor | A000009 | 400672 | 14000 | James Abdnor | Q614868 | kg:/m/03vwqw | James | Abdnor | 1923-02-13 | M | 8259 | 00001 | ||||||||||||||||
A000011 | Homer Abele | A000011 | 400674 | 10568 | Pete Abele | Q7171818 | kg:/m/03q9hb | Homer | Abele | 1916-11-21 | M | 8263 | E. | ||||||||||||||||
A000012 | James Abercrombie | A000012 | 400675 | 10 | James Abercrombie (congressman) | Q1679917 | kg:/m/08t3mf | James | Abercrombie | M | 8264 | ||||||||||||||||||
A000013 | John Abercrombie | A000013 | 400676 | 11 | John Abercrombie (congressman) | Q1702161 | kg:/m/0f6w_j | John | Abercrombie | 1866-05-17 | M | 8266 | William | ||||||||||||||||
A000014 | Neil Abercrombie | A000014 | 400001 | 15245 | Neil Abercrombie | Q469689 | kg:/m/0255rj | Neil | Abercrombie | 1938-06-26 | M | 8268 | 00002 | 26827 | N00007665 | [ "H6HI01121" ] |
|||||||||||||
A000015 | Charles Abernethy | A000015 | 400677 | 12 | Charles Laban Abernethy | Q1065248 | kg:/m/04gpqm | Charles | Abernethy | 1872-03-18 | M | 8270 | Laban | ||||||||||||||||
A000016 | Thomas Abernethy | A000016 | 400678 | 13 | Thomas Abernethy (politician) | Q612202 | kg:/m/0f6yyl | Thomas | Abernethy | 1903-05-16 | M | 8272 | Gerstle | ||||||||||||||||
A000017 | James Abourezk | A000017 | 400679 | 13000 | James Abourezk | Q1366620 | kg:/m/03zkdz | James | Abourezk | 1931-02-24 | M | 8274 | George | 01268 | |||||||||||||||
A000019 | Ernest Acheson | A000019 | 400681 | 14 | Ernest F. Acheson | Q5393043 | kg:/m/0f7191 | Ernest | Acheson | 1855-09-19 | M | 8278 | Francis | ||||||||||||||||
A000020 | Ephraim Acker | A000020 | 400682 | 15 | Ephraim Leister Acker | Q5382300 | kg:/m/0kt5_d | Ephraim | Acker | 1827-01-11 | M | 8279 | Leister | ||||||||||||||||
A000021 | Ernest Ackerman | A000021 | 400683 | 16 | Ernest Robinson Ackerman | Q1356495 | kg:/m/02ryq4l | Ernest | Ackerman | 1863-06-17 | M | 8281 | Robinson | ||||||||||||||||
A000022 | Gary Ackerman | A000022 | 400003 | 15000 | Gary Ackerman | Q972029 | kg:/m/03rhdq | Gary | Ackerman | 1942-11-19 | M | 8283 | L. | 00004 | 1002061 | 26970 | Gary L. Ackerman | N00001143 | [ "H4NY07011" ] |
||||||||||
A000023 | Joseph Acklen | A000023 | 400684 | 17 | Joseph H. Acklen | Q1707149 | kg:/m/02rtmmt | Joseph | Acklen | 1850-05-20 | M | 8285 | Hayes | ||||||||||||||||
A000024 | Edwin Adair | A000024 | 400685 | 18 | E. Ross Adair | Q1273564 | kg:/m/02rkfks | Edwin | Adair | 1907-12-14 | M | 8287 | Ross | ||||||||||||||||
A000025 | Jackson Adair | A000025 | 400686 | 19 | J. Leroy Adair | Q6106352 | kg:/m/02rkb10 | Jackson | Adair | 1887-02-23 | M | 8288 | Leroy | ||||||||||||||||
A000026 | John Adair | A000026 | 400687 | 20 | John Adair | Q11595 | kg:/m/05d76r | John | Adair | 1757-01-09 | M | 8290 | |||||||||||||||||
A000027 | John Adair | A000027 | 400688 | 21 | John A. M. Adair | Q776226 | kg:/m/02rkgmg | John | Adair | 1864-12-22 | M | 8291 | Alfred McDowell | ||||||||||||||||
A000028 | Alva Adams | A000028 | 400689 | 22 | Alva B. Adams | Q742525 | kg:/m/050h4d | Alva | Adams | 1875-10-29 | M | Blanchard | |||||||||||||||||
A000030 | Benjamin Adams | A000030 | 400691 | 24 | Benjamin Adams (politician) | Q817371 | kg:/m/0gswk0 | Benjamin | Adams | 1764-12-16 | M | 8294 | |||||||||||||||||
A000031 | Brockman Adams | A000031 | 400692 | 10700 | Brock Adams | Q357718 | kg:/m/03vw3c | Brockman | Adams | 1927-01-13 | M | 8296 | Brock | 00005 | S180 | ||||||||||||||
A000032 | Charles Adams | A000032 | 400693 | 25 | Charles Francis Adams Sr. | Q75174 | kg:/m/01zxw2 | Charles | Adams | 1807-08-18 | M | 8298 | Francis | ||||||||||||||||
A000033 | Charles Adams | A000033 | 400694 | 26 | Charles H. Adams (New York politician) | Q3460936 | kg:/m/0269s2j | Charles | Adams | 1824-04-10 | M | 8300 | Henry | ||||||||||||||||
A000034 | George Adams | A000034 | 400695 | 27 | George E. Adams | Q5538700 | kg:/m/02rk9m8 | George | Adams | 1840-06-18 | M | 8301 | Everett | ||||||||||||||||
A000035 | George Adams | A000035 | 400696 | 28 | George Madison Adams | Q1264473 | kg:/m/02rhgt0 | George | Adams | 1837-12-20 | M | 8303 | Madison | ||||||||||||||||
A000036 | Green Adams | A000036 | 400697 | 29 | Green Adams | Q1536181 | kg:/m/0gt03p | Green | Adams | 1812-08-20 | M | 8305 | |||||||||||||||||
A000037 | Henry Adams | A000037 | 400698 | 30 | Henry Cullen Adams | Q1606644 | kg:/g/11r_pbs77 | Henry | Adams | 1850-11-28 | M | 8306 | Cullen | ||||||||||||||||
A000038 | John Adams | A000038 | 400700 | 32 | John Adams (New York politician) | Q1287735 | kg:/m/0gtgvd | John | Adams | 1778-08-26 | M | 8307 | |||||||||||||||||
A000040 | John Adams | A000040 | 400701 | 33 | John J. Adams | Q1193410 | kg:/m/026mmyk | John | Adams | 1848-09-16 | M | 8310 | Joseph | ||||||||||||||||
A000041 | John Adams | A000041 | 400702 | 34 | John Quincy Adams | Q11816 | kg:/m/03_nq | John | Adams | 1767-07-11 | M | 8312 | Quincy | ||||||||||||||||
A000042 | Parmenio Adams | A000042 | 400703 | 35 | Parmenio Adams | Q13219079 | kg:/m/0gtjx4 | Parmenio | Adams | 1776-09-09 | M | 8313 |
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);