home / openregs

WH top policy visitors (named)

Most-frequent White House visitors for official/policy meetings (non-tour).

Custom SQL query returning 100 rows (hide)

SELECT visitor_name_full, COUNT(*) AS n_visits,
    MIN(appt_start_iso) AS first_visit, MAX(appt_start_iso) AS last_visit,
    COUNT(DISTINCT admin) AS administrations
FROM wh_visits
WHERE visitor_is_tour = 0 AND visitor_name_full IS NOT NULL
GROUP BY visitor_name_full
ORDER BY n_visits DESC
LIMIT 100

Edit SQL

This data as json, CSV

visitor_name_fulln_visitsfirst_visitlast_visitadministrations
CLAUDIA MCNAMARA 96 2009-09-17 2010-01-29 1
James Albino 67 2014-03-03 2015-09-03 1
William N Jenkins 66 2011-04-14 2015-09-28 1
NEERA TANDEN 64 2009-04-28 2016-06-07 1
Thomas H Reynolds 59 2011-03-31 2016-03-31 1
QUINN A CARRIGAN 57 2022-07-27 2024-06-18 1
Esther M Olavarria 56 2012-11-15 2016-01-28 1
Neera Tanden 55 2011-05-06 2015-08-03 1
Andrea J Palm 53 2011-10-25 2016-08-26 1
Daleep Singh 52 2012-06-01 2015-12-01 1
Roy L Austin 50 2012-06-21 2016-02-12 1
Eduardo Cisneros 50 2013-09-30 2016-04-27 1
Rodin A Mehrbani 48 2011-07-11 2016-05-02 1
Anne Harkavy 48 2013-08-07 2016-08-31 1
Kiran A Ahuja 45 2011-08-09 2015-11-18 1
Adewale O Adeyemo 45 2011-10-06 2015-09-02 1
Adam M Neufeld 44 2013-05-29 2015-09-22 1
Seth F Wheeler 42 2013-01-09 2013-12-04 1
MICHAEL MUNDACA 42 2009-09-29 2011-03-10 1
David B Sandalow 42 2011-03-24 2015-06-16 1
Daniel Cohen 42 2012-05-04 2016-08-31 1
Alise D Marshall 41 2012-03-01 2016-04-16 1
ALISE D MARSHALL 41 2015-07-09 2023-03-01 2
Xochitl Hinojosa 40 2013-08-28 2015-05-22 1
Krishanti Vignarajah 40 2012-04-09 2015-05-04 1
CHRISTOPHER J DODD 40 2012-06-13 2024-08-13 2
Mary E Maxwell 39 2012-04-05 2015-10-01 1
Jenni R LeCompte 39 2011-04-01 2014-11-13 1
Tommy P Beaudreau 38 2011-04-06 2015-02-12 1
SETHURAMAN N PANCHANATHAN 38 2021-03-05 2024-08-09 1
Norah A Deluhery 38 2011-05-03 2016-03-08 1
MARK CHILDRESS 38 2009-12-22 2016-04-26 1
Charles Schumer 38 2011-10-04 2016-02-09 1
Brian A Donnelly 38 2015-04-22 2015-06-15 1
Marie J Williams 37 2011-03-29 2014-04-29 1
Lyle D Canceko 36 2012-06-05 2015-04-03 1
Nancy E Lindborg 35 2011-04-26 2015-10-06 1
BRIAN A DONNELLY 35 2015-06-03 2015-08-05 1
Tanya J Bradsher 34 2011-05-16 2016-02-05 1
Genger Charles 32 2012-04-18 2016-03-30 1
ALICE P ALBRIGHT 32 2010-01-20 2024-08-14 2
Jane Oates 31 2011-03-31 2013-01-11 1
Adewale Adeyemo 31 2011-08-15 2015-08-21 1
ALI C KELLEY 31 2009-10-22 2011-01-18 1
Michael Jones 30 2011-04-01 2013-12-17 1
Mark A Kaufman 30 2012-05-07 2015-10-23 1
Jim R Esquea 30 2011-04-11 2015-07-09 1
Michael A Fitzpatrick 29 2012-03-07 2015-09-02 1
Robert F Greenblum 28 2014-10-17 2016-02-23 1
MICHAEL ZUBRENSKY 28 2010-08-11 2016-07-21 1
Kristen M Kulinowski 28 2012-02-27 2015-07-09 1
John R Sandweg 28 2011-04-07 2013-12-06 1
JANE OATES 28 2009-09-18 2012-07-19 1
Betsaida Alcantara 28 2012-05-09 2015-06-25 1
SARAH KING 27 2015-10-30 2015-11-30 1
DAVID KATZ 27 2009-11-05 2016-05-10 1
Ann M Norris 27 2012-03-14 2016-05-26 1
ALASTAIR FITZPAYNE 27 2009-09-25 2016-08-05 1
Sarah E Feinberg 26 2013-03-12 2015-01-15 1
SARAH MILBY 26 2010-01-19 2010-07-28 1
KIRAN A AHUJA 26 2009-11-24 2021-07-12 2
Alice P Albright 26 2011-03-24 2015-08-12 1
TODD STERN 25 2009-09-16 2011-03-11 1
NOAH A KROLOFF 25 2009-09-28 2011-03-16 1
James A Williams 25 2012-02-01 2016-05-06 1
Rohit Chopra 24 2011-08-12 2016-03-11 1
Marilyn Tavenner 24 2012-01-18 2015-02-26 1
Kevin T Knobloch 24 2012-02-16 2016-06-13 1
ADITI S HARDIKAR 24 2011-07-25 2024-06-24 2
David M Michaels 23 2011-07-27 2015-11-10 1
Vanita Gupta 22 2014-09-05 2016-07-13 1
Tonya T Robinson 22 2011-10-24 2016-08-31 1
PAUL KIM 22 2010-10-18 2011-02-04 1
Linda K Smith 22 2012-02-23 2015-08-06 1
Kathy J Greenlee 22 2011-04-01 2015-06-16 1
JUSTIN JOHNSON 22 2009-10-02 2010-12-21 1
Daniel A Leistikow 22 2011-03-19 2014-11-25 1
BRANDON HURLBUT 22 2009-10-05 2016-01-06 1
Karen F Kornbluh 21 2011-04-12 2015-09-08 1
Jon I Monger 21 2011-04-12 2014-01-28 1
Edward E Kaufman 21 2011-03-31 2016-09-06 1
Devon Wardlow 21 2012-05-28 2015-03-18 1
Adriana D Kugler 21 2011-08-03 2012-12-05 1
THOMAS S ZIMMERMAN 20 2022-02-04 2024-07-26 1
ROBERT BONNIE 20 2009-11-13 2015-12-18 1
MARK MAZUR 20 2009-10-01 2011-02-23 1
MALA ADIGA 20 2009-10-01 2011-03-16 1
DAVID M MARCHICK 20 2010-02-11 2024-01-03 2
BRUCE REED 20 2009-09-25 2011-01-24 1
Alan B Krueger 20 2011-07-27 2016-03-16 1
ANDREA J PALM 20 2010-06-23 2021-03-18 2
ADRIANA D KUGLER 20 2011-10-13 2024-08-19 2
William Samuel 19 2011-05-18 2014-10-16 1
Parita S Selfridge 19 2011-04-26 2016-08-11 1
PAUL PIQUADO 19 2011-03-26 2016-09-28 1
Matthew J McAllister 19 2014-03-05 2015-12-02 1
Mala Adiga 19 2011-05-25 2016-02-19 1
Laura H Hogshead 19 2012-06-27 2015-04-17 1
Joshua Gotbaum 19 2011-05-13 2014-06-12 1
JOHN D PORCARI 19 2009-09-21 2024-04-01 2
Powered by Datasette · Queries took 2575.629ms