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
Michael A Zubrensky 280 2011-03-29 2016-09-14 1
Sharon N Werner 183 2011-07-19 2015-09-30 1
Meaghan K Muldoon 179 2013-02-26 2016-01-11 1
Stephanie M Valencia 170 2013-10-08 2015-11-03 1
Stephanie R Sprow 168 2012-06-05 2016-09-01 1
Marisa R Lee 167 2011-04-11 2015-09-18 1
Mark J Mazur 163 2011-03-28 2016-09-29 1
VIRGINIA S MCQUADE 138 2021-05-07 2024-07-25 1
Michael M Hash 130 2011-03-23 2014-04-17 1
Janice C Eberly 122 2011-07-06 2013-04-24 1
Todd D Stern 117 2011-07-20 2016-05-13 1
Karen E Dynan 113 2013-01-30 2016-07-06 1
Janet G McCabe 110 2011-04-22 2016-09-07 1
Alastair M Fitzpayne 110 2011-04-28 2016-05-17 1
ELSIE N STECKER 105 2021-01-26 2021-05-07 1
James H Shelton 101 2011-03-24 2015-07-22 1
Joseph M Goffman 100 2011-08-18 2016-09-07 1
ADAM NEUFELD 99 2010-03-25 2015-12-14 1
Shoshana M Lew 96 2011-10-25 2015-09-16 1
CLAUDIA MCNAMARA 96 2009-09-17 2010-01-29 1
Sylvia M Burwell 90 2011-10-04 2013-04-26 1
Mark C Appleton 90 2011-05-30 2016-01-13 1
Matthew T McGuire 89 2011-03-28 2016-03-31 1
Marilyn n Tavenner 88 2011-04-27 2014-11-24 1
Kathy P Conrad 88 2011-08-09 2015-07-08 1
Mark E Doms 87 2011-03-28 2015-09-09 1
Ari A Matusiak 87 2011-03-18 2015-06-05 1
William B Schultz 84 2011-05-25 2016-05-23 1
Randall J DeValk 84 2011-10-06 2016-08-03 1
Shauna L McCarty 82 2011-05-20 2016-09-30 1
Sharon I Block 82 2011-05-13 2015-04-06 1
Peter L Levin 79 2011-04-12 2015-02-20 1
Jeffrey D Zients 79 2013-05-01 2014-01-24 1
Anne E Wall 77 2011-07-21 2016-03-11 1
Robert C Ryan 76 2011-03-22 2012-12-20 1
Jonathan M Levy 75 2011-07-18 2015-10-05 1
Christopher J Meade 75 2011-04-13 2015-06-01 1
MARSHALL L MILLER 72 2022-07-21 2024-07-25 1
Karl R Thompson 71 2011-08-18 2016-09-14 1
David L McClure 69 2011-03-24 2015-01-09 1
DAVID L MCCLURE 69 2009-09-17 2016-01-14 1
Charles J Appel 69 2011-04-26 2016-04-06 1
Sol J Ross 67 2011-10-07 2015-12-16 1
Joseph S Hezir 67 2011-05-16 2016-03-11 1
James Albino 67 2014-03-03 2015-09-03 1
Suzanne C Immerman 66 2011-05-04 2015-03-17 1
Robert F Bonnie 66 2011-05-05 2016-06-16 1
Regina A McCarthy 66 2011-04-01 2013-09-12 1
Phyllis C Borzi 66 2011-05-31 2016-02-09 1
MARK J MAZUR 66 2009-09-22 2016-08-24 1
Molly J Moran 65 2012-02-23 2016-06-29 1
Gregory M Darnieder 65 2012-06-05 2016-02-18 1
Elizabeth A Klein 65 2011-03-21 2016-03-23 1
William O Jawando 64 2011-03-30 2015-03-11 1
William N Jenkins 64 2011-04-14 2015-09-28 1
Walter A Looney 64 2011-07-21 2015-11-20 1
NEERA TANDEN 64 2009-04-28 2016-06-07 1
Lauren N Thompson 64 2012-06-05 2015-02-23 1
Kyla F Griffith 64 2012-03-14 2016-05-04 1
Ellen G Murray 64 2011-03-29 2015-05-28 1
Anne C MacMillan 64 2011-05-06 2015-01-16 1
Theodore R Mitchell 62 2013-05-07 2016-01-13 1
Stuart F Delery 61 2011-03-31 2015-09-16 1
Thomas R Frieden 60 2011-03-30 2015-11-19 1
Eric W Waldo 60 2011-05-02 2015-10-29 1
Samuel P Cornale 59 2011-04-04 2016-06-13 1
ROBERT N MALLEY 59 2021-02-15 2023-04-28 1
Kristin J Sheehy 58 2011-03-18 2014-07-11 1
Jonathan R Foley 58 2011-04-18 2016-05-09 1
Beatrice M Hidalgo 58 2011-03-21 2015-09-29 1
QUINN A CARRIGAN 57 2022-07-27 2024-06-18 1
Darron P Monteiro 57 2013-11-24 2016-07-07 1
Antonio F Weiss 57 2012-07-25 2016-07-25 1
AMOS N HOCHSTEIN 57 2021-07-22 2022-06-21 1
Mary P Smith 56 2011-04-28 2015-09-08 1
Esther M Olavarria 56 2012-11-15 2016-01-28 1
Vivek H Murthy 55 2011-08-29 2016-06-27 1
Sally A Howard 55 2011-03-29 2015-08-14 1
Neera Tanden 55 2011-05-06 2015-08-03 1
LOYCE L PACE 55 2021-08-02 2024-08-22 1
Jennifer S Lee 55 2011-07-12 2015-12-24 1
David N Sheets 55 2013-10-01 2015-02-23 1
Aryana C Khalid 55 2011-04-12 2015-04-24 1
Paul T Dioguardi 54 2011-04-28 2015-05-20 1
KAREN E SKELTON 54 2021-09-07 2024-05-23 1
MICHAEL A ZUBRENSKY 53 2010-01-11 2023-06-07 2
Dorinda A Salcido 53 2011-08-16 2014-05-14 1
Mandy K Cohen 52 2012-06-06 2016-07-27 1
Kirby L Bumpus 52 2012-04-02 2015-10-29 1
Daleep Singh 52 2012-06-01 2015-12-01 1
Andrea B Ambriz 52 2011-07-27 2016-05-18 1
Vikrum D Aiyer 51 2011-08-17 2016-07-08 1
Michele S Chang 51 2011-04-06 2014-04-21 1
Jonathan C Pershing 51 2012-02-13 2016-07-18 1
Joel C Beauvais 51 2011-10-21 2015-09-25 1
Donald B Verrilli 51 2012-06-27 2016-06-03 1
Roy L Austin 50 2012-06-21 2016-02-12 1
Eduardo Cisneros 50 2013-09-30 2016-04-27 1
John M Grunsfeld 49 2011-07-20 2015-07-22 1
Donald Y Yu 49 2011-05-02 2016-09-30 1
Powered by Datasette · Queries took 2522.084ms