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 other_names
This data as json, copyable, CSV (advanced)
id_fec (array) 16 ✖
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" ] |
||||||||||||
B001228 | Mary Bono Mack | B001228 | 400039 | 29775 | Mary Bono | Q459753 | kg:/m/024xmf | Mary | Bono Mack | 1961-10-24 | F | 10357 | Whitaker | [ { "last": "Bono", "end": "2007-12-17" } ] |
01465 | 1434 | Mary Bono Mack | N00007068 | [ "H8CA44034" ] |
||||||||||
L000420 | Jill Long Thompson | L000420 | 406920 | 15631 | Jill Long Thompson | Q514523 | kg:/m/0f4s6t | Jill | Long Thompson | 1952-07-15 | F | 17117 | Lynette | [ { "last": "Long", "end": "1995-09-03" } ] |
00705 | 34285 | |||||||||||||
L000035 | Blanche Lincoln | L000035 | 300068 | 29305 | Blanche Lincoln | Q237681 | kg:/m/01xb1j | Blanche | Lincoln | 1960-09-30 | F | 16621 | Lambert | [ { "middle": null, "last": "Lambert", "end": "1995-01-03" } ] |
01570 | 26202 | 26723 | S269 | N00008092 | [ "S8AR00112", "H2AR01022" ] |
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);