legislators

Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette

Custom SQL query returning 58 rows (hide)

Query parameters

This data as json, copyable, CSV

idnameid_bioguideid_govtrackid_icpsrid_wikipediaid_wikidataid_google_entity_idname_firstname_lastbio_birthdaybio_genderid_house_historyname_middlename_nicknameid_ballotpedianame_suffixid_bioguide_previousid_house_history_alternateother_namesid_thomasid_cspanid_votesmartid_lisname_official_fullid_opensecretsid_fecid_maplightleadership_rolesfamily
S001179 Aaron Schock S001179 412314 20914 Aaron Schock Q302659 kg:/m/0h6xzk Aaron Schock 1981-05-28 M 22614     Aaron Schock         01920 1030003 33428   Aaron Schock N00029273 
[
    "H8IL18043"
]
 796    
M001191 Patrick Murphy M001191 412527 21319 Patrick Murphy (Florida politician) Q3182011 kg:/m/0n47ttk Patrick Murphy 1983-03-30 M       Patrick Murphy (Florida)         02117 95348 137652   Patrick Murphy N00033091 
[
    "H2FL22072"
]
 1751    
C001107 Carlos Curbelo C001107 412621 21512 Carlos Curbelo Q18631533 kg:/m/0127nzmk Carlos Curbelo 1980-03-01 M                 02235 70472 137676   Carlos Curbelo N00035403 
[
    "H4FL26038"
]
 2077    
K000390 Ruben Kihuen K000390 412716 21729 Ruben Kihuen Q7375978 kg:/m/03hnv7g Ruben Kihuen 1980-04-25 M                   79707 66851   Ruben J. Kihuen N00033530 
[
    "H2NV00050"
]
 2228    
H001087 Katie Hill H001087 412756 21932 Katie Hill (politician) Q58416634 kg:/g/11gtgfywx0 Katie Hill 1987-08-25 F       Katie Hill             179354   Katie Hill N00040644 
[
    "H8CA25074"
]
      
A000367 Justin Amash A000367 412438 21143 Justin Amash Q1714165 kg:/m/0c00p_n Justin Amash 1980-04-18 M 8769     Justin Amash         02029 1033767 105566   Justin Amash N00031938 
[
    "H0MI03126"
]
 1449    
G000571 Tulsi Gabbard G000571 412532 21324 Tulsi Gabbard Q32620 kg:/m/0cnyrfq Tulsi Gabbard 1981-04-12 F 15032387167     Tulsi Gabbard         02122 1025291 129306   Tulsi Gabbard N00033281 
[
    "H2HI02508"
]
 1756    
K000379 Joseph Kennedy K000379 412543 21335 Joe Kennedy III Q1707784 kg:/m/0j28kl9 Joseph Kennedy 1980-10-04 M   P.   Joseph Kennedy III III       02172 79948 141275   Joseph P. Kennedy III N00034044 
[
    "H2MA04073"
]
 1767   
[
    {
        "name": "Joseph Patrick Kennedy II",
        "relation": "son"
    },
    {
        "name": "Edward Moore Kennedy",
        "relation": "great nephew"
    },
    {
        "name": "John Fitzgerald Kennedy",
        "relation": "great nephew"
    },
    {
        "name": "John Francis Fitzgerald",
        "relation": "great great grandson"
    },
    {
        "name": "Patrick Joseph Kennedy",
        "relation": "first cousin once removed"
    }
]
F000467 Abby Finkenauer F000467 412771 21918 Abby Finkenauer Q24435337 kg:/g/11cmg58r7d Abby Finkenauer 1988-12-27 F       Abby Finkenauer             151127   Abby Finkenauer N00040888 
[
    "H8IA01094"
]
      
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"
]
      
R000613 Max Rose R000613 412803 21958 Max Rose Q56046860 kg:/g/11fhr0yrwq Max Rose 1986-11-28 M       Max Rose             180409   Max Rose N00041588 
[
    "H8NY11113"
]
      
C001122 Joe Cunningham C001122 412814 21913 Joe Cunningham (American politician) Q58993183 kg:/g/11fglfpsvf Joe Cunningham 1982-05-26 M       Joe Cunningham             179601   Joe Cunningham N00041400 
[
    "H8SC01116"
]
      
S001193 Eric Swalwell S001193 412514 21306 Eric Swalwell Q3466996 kg:/m/0ncq55g Eric Swalwell 1980-11-16 M       Eric Swalwell         02104 79729 129529   Eric Swalwell N00033508 
[
    "H2CA15094"
]
 1738    
S001195 Jason Smith S001195 412596 21373 Jason Smith (politician) Q6163589 kg:/m/0g9yj_2 Jason Smith 1980-06-16 M   T.   Jason Smith (Missouri representative)         02191 71083 59318   Jason Smith N00035282 
[
    "H4MO08162"
]
 2047    
Z000017 Lee Zeldin Z000017 412646 21539 Lee Zeldin Q16221257 kg:/m/03h4jcq Lee Zeldin 1980-01-30 M   M.   Lee Zeldin         02261 61616 110252   Lee M. Zeldin N00029404 
[
    "H8NY01148"
]
 2102    
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"
    }
]
  
G000578 Matt Gaetz G000578 412690 21719 Matt Gaetz Q16221742 kg:/m/0s8w2_s Matt Gaetz 1982-05-07 M       Matt Gaetz           104528 117101   Matt Gaetz N00039503 
[
    "H6FL01119"
]
 2202    
M001199 Brian Mast M001199 412698 21735 Brian Mast Q27733854 kg:/g/11cs5xxx_f Brian Mast 1980-07-10 M   J.   Brian Mast           104540 166245   Brian J. Mast N00037269 
[
    "H6FL18097"
]
 2210    
H001074 Trey Hollingsworth H001074 412703 21725 Trey Hollingsworth Q27804536 kg:/g/11cnt8qr9t Trey Hollingsworth 1983-09-12 M       Trey Hollingsworth           104247 167423   Trey Hollingsworth N00038429 
[
    "H6IN09176"
]
 2215    
G000579 Mike Gallagher G000579 412731 21720 Mike Gallagher (American politician) Q27842981 kg:/g/11c5qns1cc Mike Gallagher 1984-03-03 M       Michael Gallagher (Wisconsin)           104067 171843   Mike Gallagher N00039330 
[
    "H6WI08155"
]
 2243    
L000588 Conor Lamb L000588 412744 21756 Conor Lamb Q43387164 kg:/g/11gdj36kt1 Conor Lamb 1984-06-27 M       Conor Lamb             177656   Conor Lamb N00041870 
[
    "H8PA18181"
]
      
H001090 Josh Harder H001090 412754 21930 Josh Harder Q58494468 kg:/g/11fhwknffg Josh Harder 1986-08-01 M       Josh Harder             179326   Josh Harder N00040853 
[
    "H8CA10126"
]
      
N000191 Joe Neguse N000191 412761 21948 Joe Neguse Q57242006 kg:/g/11gnsnch0m Joe Neguse 1984-05-13 M       Joe Neguse             151075   Joe Neguse N00041080 
[
    "H8CO02160"
]
      
S001204 Michael San Nicolas S001204 412770   Michael San Nicolas Q16221559 kg:/m/0wy0mjt Michael San Nicolas 1981-01-30 M   F. Q.                     Michael F. Q. San Nicolas N00042619 
[
    "H8GU01020"
]
      
U000040 Lauren Underwood U000040 412776 21979 Lauren Underwood Q48471874 kg:/g/11gfm73_1z Lauren Underwood 1986-10-04 F                     177001   Lauren Underwood N00041569 
[
    "H8IL14174"
]
      
D000629 Sharice Davids D000629 412780 21914 Sharice Davids Q58322868 kg:/g/11fgm1fq16 Sharice Davids 1980-05-22 F       Sharice Davids             181201   Sharice Davids N00042626 
[
    "H8KS03155"
]
      
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"
]
      
O000173 Ilhan Omar O000173 412791 21950 Ilhan Omar Q26436159 kg:/g/11c4wx5dm0 Ilhan Omar 1981-10-04 F       Ilhan Omar             171628   Ilhan Omar N00043581 
[
    "H8MN05239"
]
      
P000614 Chris Pappas P000614 412795 21951 Chris Pappas (politician) Q5107684 kg:/m/0nd3t8z Chris Pappas 1980-06-04 M       Chris Pappas             42635   Chris Pappas N00042161 
[
    "H8NH01210"
]
      
K000394 Andy Kim K000394 412797 21937 Andy Kim (politician) Q55639180 kg:/g/11f730yxds Andy Kim 1982-07-12 M       Andrew Kim (New Jersey)             179640   Andy Kim N00041370 
[
    "H8NJ03206"
]
      
O000172 Alexandria Ocasio-Cortez O000172 412804 21949 Alexandria Ocasio-Cortez Q55223040 kg:/g/11f6y3nqg6 Alexandria Ocasio-Cortez 1989-10-13 F       Alexandria Ocasio-Cortez             180416   Alexandria Ocasio-Cortez N00041162 
[
    "H8NY15148"
]
      
G000588 Anthony Gonzalez G000588 412807 21924 Anthony Gonzalez Q3487172 kg:/m/0gznlq Anthony Gonzalez 1984-09-19 M       Anthony Gonzalez             178867   Anthony Gonzalez N00041690 
[
    "H8OH16124"
]
      
R000610 Guy Reschenthaler R000610 412813 21956 Guy Reschenthaler Q22096097 kg:/g/11bwn3bsvm Guy Reschenthaler 1983-04-17 M       Guy Reschenthaler             166004   Guy Reschenthaler N00041871 
[
    "H8PA18199"
]
      
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"
]
      
C001120 Dan Crenshaw C001120 412820 21911 Dan Crenshaw Q58301995 kg:/g/11hcj7fy00 Dan Crenshaw 1984-03-14 M       Daniel Crenshaw             177270   Dan Crenshaw N00042224 
[
    "H8TX02166"
]
      
G000589 Lance Gooden G000589 412822 21925 Lance Gooden Q6483406 kg:/m/0jkx4bp Lance Gooden 1982-12-01 M       Lance Gooden             177282   Lance Gooden N00042237 
[
    "H8TX05144"
]
      
A000376 Colin Allred A000376 412828 21900 Colin Allred Q5144845   Colin Allred 1983-04-15 M   Z.   Colin Allred             177357   Colin Z. Allred N00040989 
[
    "H8TX32098"
]
      
S001213 Bryan Steil S001213 412836 21970 Bryan Steil Q58494431 kg:/g/11fhnfybnd Bryan Steil 1981-03-30 M       Bryan Steil             181289   Bryan Steil N00043379 
[
    "H8WI01156"
]
      
G000592 Jared Golden G000592 412842 21923 Jared Golden Q41694157 kg:/g/11f1224576 Jared Golden 1982-07-25 M   Forrest   Jared Golden             151420   Jared F. Golden N00041668 
[
    "H8ME02185"
]
      
J000305 Sara Jacobs J000305 456804   Sara Jacobs Q50825637 kg:/g/11ghs2x3tm Sara Jacobs 1989-02-01 F                         Sara Jacobs N00042081 
[
    "H8CA49074"
]
      
B000825 Lauren Boebert B000825 456805   Lauren Boebert Q96761544 kg:/g/11j2v06x6p Lauren Boebert 1986-12-15 F   Opal   Lauren Boebert                 Lauren Boebert N00045974 
[
    "H0CO03165"
]
      
C001039 Katherine Cammack C001039 456806   Kat Cammack Q98523243 kg:/g/11fsp_lppx Katherine Cammack 1988-02-16 F     Kat                   Kat Cammack N00045978 
[
    "H0FL03175"
]
      
H001091 Ashley Hinson H001091 456816   Ashley Hinson Q60713905 kg:/g/11fjq_fl2t Ashley Hinson 1983-06-27 F       Ashley Hinson             168783   Ashley Hinson N00044521 
[
    "H0IA01174"
]
      
L000266 Jacob LaTurner L000266 456824   Jake LaTurner Q16731273 kg:/m/0w32xrn Jacob LaTurner 1988-02-17 M     Jake                   Jake LaTurner N00044232 
[
    "H0KS02188"
]
      
A000148 Jake Auchincloss A000148 456825   Jake Auchincloss Q101196632 kg:/g/11f0xw2_p4 Jake Auchincloss 1988-01-29 M   Daniel                     Jake Auchincloss N00045506 
[
    "H0MA04192"
]
      
M001186 Peter Meijer M001186 456826   Peter Meijer Q96419165 kg:/g/11dxq0fr9x Peter Meijer 1988-01-10 M   James                     Peter Meijer N00044884 
[
    "H0MI03308"
]
      
G000597 Andrew Garbarino G000597 456836   Andrew Garbarino Q21257859 kg:/g/11bw8f4j8q Andrew Garbarino 1984-09-27 M   R.                     Andrew R. Garbarino N00046030 
[
    "H0NY02234"
]
      
M000317 Nicole Malliotakis M000317 456837   Nicole Malliotakis Q7030112 kg:/m/0g5817m Nicole Malliotakis 1980-11-11 F                         Nicole Malliotakis N00044040 
[
    "H0NY11078"
]
      
T000486 Ritchie Torres T000486 456838   Ritchie Torres Q16205227 kg:/m/0x11h9s Ritchie Torres 1988-03-12 M   John   Ritchie Torres                 Ritchie Torres N00044346 
[
    "H0NY15160"
]
      
J000306 Mondaire Jones J000306 456840   Mondaire Jones Q96781248 kg:/g/11fsfpp4wj Mondaire Jones 1987-05-18 M       Mondaire Jones                 Mondaire Jones N00044908 
[
    "H0NY17174"
]
      
G000594 Ernest Gonzales G000594 456849       kg:/g/11fs52clcr Ernest Gonzales 1980-10-10 M   Anthony Tony                   Tony Gonzales N00044592 
[
    "H0TX35015"
]
      
M001213 Blake Moore M001213 456851   Blake Moore Q101196971 kg:/g/11ftchfsgn Blake Moore 1980-06-22 M   David                     Blake D. Moore N00046598 
[
    "H0UT01205"
]
      
O000174 Jon Ossoff O000174 456857   Jon Ossoff Q28839536   Jon Ossoff 1987-02-16 M       Jon Ossoff               S414 Jon Ossoff N00040675 
[
    "H8GA06195",
    "S8GA00180"
]
      
L000595 Julia Letlow L000595 456859   Julia Letlow Q106089241   Julia Letlow 1981-03-16 F       Julia Letlow                 Julia Letlow N00047972 
[
    "H2LA05126"
]
      
F000473 Mayra Flores F000473 456867   Mayra Flores Q112577890   Mayra Flores 1986-01-01 F                         Mayra Flores N00048049 
[
    "H2TX34113"
]
      
R000579 Patrick Ryan R000579 456871   Pat Ryan (politician) Q113587887   Patrick Ryan 1982-03-28 M       Pat Ryan (New York)                 Patrick Ryan N00041165 
[
    "H8NY19223"
]
      
S001219 Joseph Sempolinski S001219 456872   Joe Sempolinski Q113588013   Joseph Sempolinski 1982-02-10 M       Joe Sempolinski                 Joseph Sempolinski N00048747 
[
    "H2NY23137"
]
      
Y000067 Rudy Yakym Y000067 456873   Rudy Yakym Q115137719   Rudy Yakym 1984-02-24 M       Rudy Yakym             210545       
[
    "H2IN02295"
]