legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
400 rows where bio_gender = "F" sorted by leadership_roles
This data as json, copyable, CSV (advanced)
id_fec (array) 24 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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" ] |
||||||||||||
M001111 | Patty Murray | M001111 | 300076 | 49308 | Patty Murray | Q258825 | kg:/m/018qx5 | Patty | Murray | 1950-10-11 | F | 18715 | Patty Murray | 01409 | 25277 | 53358 | S229 | Patty Murray | N00007876 | [ "S2WA00189" ] |
596 | [ { "title": "Assistant Senate Minority Leader", "chamber": "senate", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "Assistant Senate Minority Leader", "chamber": "senate", "start": "2021-01-03", "end": "2021-01-20" }, { "title": "Assistant Senate Majority Leader", "chamber": "senate", "start": "2021-01-20" } ] |
|||||||
C001101 | Katherine Clark | C001101 | 412600 | 21375 | Katherine Clark | Q6376330 | kg:/m/0fpjc8b | Katherine | Clark | 1963-07-17 | F | 15032398493 | M. | Katherine Clark | 02196 | 73178 | 35858 | Katherine M. Clark | N00035278 | [ "H4MA05084" ] |
2053 | [ { "title": "Assistant Speaker of the House", "chamber": "house", "start": "2021-01-03" } ] |
|||||||
P000197 | Nancy Pelosi | P000197 | 400314 | 15448 | Nancy Pelosi | Q170581 | kg:/m/012v1t | Nancy | Pelosi | 1940-03-26 | F | 19519 | Nancy Pelosi | 00905 | 6153 | 26732 | Nancy Pelosi | N00007360 | [ "H8CA05035" ] |
408 | [ { "title": "House Minority Leader", "chamber": "house", "start": "2011-01-05", "end": "2013-01-03" }, { "title": "House Minority Leader", "chamber": "house", "start": "2013-01-03", "end": "2015-01-03" }, { "title": "House Minority Leader", "chamber": "house", "start": "2015-01-06", "end": "2017-01-03" }, { "title": "House Minority Leader", "chamber": "house", "start": "2017-01-03", "end": "2019-01-03" }, { "title": "Speaker of the House", "chamber": "house", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "Speaker of the House", "chamber": "house", "start": "2021-01-03" } ] |
[ { "name": "Thomas D'Alesandro Jr.", "relation": "daughter" } ] |
|||||||
C001109 | Liz Cheney | C001109 | 412732 | 21710 | Liz Cheney | Q5362573 | kg:/m/04slt0 | Liz | Cheney | 1966-07-28 | F | Liz Cheney | 86147 | 171319 | Liz Cheney | N00035504 | [ "H6WY00159" ] |
2244 | [ { "title": "House Republican Conference Chair", "chamber": "house", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "House Republican Conference Chair", "chamber": "house", "start": "2021-01-03", "end": "2021-05-14" } ] |
||||||||||
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" } ] |
|||||||
B001230 | Tammy Baldwin | B001230 | 400013 | 29940 | Tammy Baldwin | Q40628 | kg:/m/024v02 | Tammy | Baldwin | 1962-02-11 | F | 10361 | Tammy Baldwin | 01558 | 57884 | 3470 | S354 | Tammy Baldwin | N00004367 | [ "H8WI00018", "S2WI00219" ] |
136 | [ { "title": "Senate Democratic Caucus Secretary", "chamber": "senate", "start": "2021-01-03" } ] |
|||||||
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" } ] |
||||||
K000367 | Amy Klobuchar | K000367 | 412242 | 40700 | Amy Klobuchar | Q22237 | kg:/m/05fbpt | Amy | Klobuchar | 1960-05-25 | F | 16558 | Jean | Amy Klobuchar | 01826 | 83701 | 65092 | S311 | Amy Klobuchar | N00027500 | [ "S6MN00267" ] |
724 | [ { "title": "Senate Democratic Steering Committee Chair", "chamber": "senate", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "Senate Democratic Steering Committee Chair", "chamber": "senate", "start": "2021-01-03" } ] |
||||||
E000295 | Joni Ernst | E000295 | 412667 | 41502 | Joni Ernst | Q13475242 | kg:/m/0gg4wkg | Joni | Ernst | 1970-07-01 | F | 15032414877 | Joni Ernst | 02283 | 75342 | 128583 | S376 | Joni Ernst | N00035483 | [ "S4IA00129" ] |
2123 | [ { "title": "Senate Republican Conference Vice Chair", "chamber": "senate", "start": "2019-01-03", "end": "2021-01-03" }, { "title": "Senate Republican Conference Vice Chair", "chamber": "senate", "start": "2021-01-03" } ] |
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);