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
James C Hoff 420 2011-03-21 2014-12-19 1
Michael A Zubrensky 288 2011-03-29 2016-09-14 1
John C Thomas 202 2011-03-23 2015-05-20 1
JOSHUA L FREELY 200 2010-06-25 2011-03-18 1
Adam F Dietz 192 2011-04-28 2016-07-12 1
Jason K Sawyer 191 2011-07-14 2016-08-18 1
Sharon N Werner 190 2011-07-19 2015-09-30 1
Stephanie M Valencia 184 2013-10-08 2015-11-03 1
Gregorio A Millett 183 2011-03-21 2015-06-25 1
Meaghan K Muldoon 180 2013-02-26 2016-01-11 1
Stephanie R Sprow 173 2012-06-05 2016-09-01 1
ANDREW CONTRERAS 171 2009-10-09 2011-02-04 1
MICHAEL N HERZOG 170 2021-12-07 2024-08-16 1
Marisa R Lee 168 2011-04-11 2015-09-18 1
Lila C Boyd 167 2011-07-05 2015-08-30 1
Mark J Mazur 164 2011-03-28 2016-09-29 1
Kate M Josephs 162 2013-08-06 2016-06-30 1
MATILDA N KUKLISH 152 2021-03-29 2024-07-24 1
CONNIE C REVELL 142 2010-04-30 2011-01-11 1
VIRGINIA S MCQUADE 138 2021-05-07 2024-07-25 1
MICHAEL HILBURG 138 2010-12-13 2011-03-18 1
ELIZABETH VALE 137 2009-09-16 2010-12-03 1
PROTAZI M SEMINDU 130 2021-10-12 2024-08-16 1
Michael M Hash 130 2011-03-23 2014-04-17 1
Stephen R Brockelman 128 2011-04-05 2015-04-27 1
Jennifer A Urizar 127 2014-01-28 2015-12-09 1
Scarlett S Boyd 126 2013-04-02 2015-08-30 1
Janice C Eberly 122 2011-07-06 2013-04-24 1
Karin H McDonough 119 2011-07-23 2016-09-24 1
Anya O Kumar 119 2012-09-24 2014-10-02 1
Todd D Stern 117 2011-07-20 2016-05-13 1
Gregory M Witz 117 2013-02-14 2016-09-23 1
Karen E Dynan 116 2013-01-30 2016-07-06 1
Alastair M Fitzpayne 114 2011-04-28 2016-05-17 1
Janet G McCabe 112 2011-04-22 2016-09-07 1
James H Shelton 110 2011-03-24 2015-07-22 1
Dennis P Oneil 110 2012-02-17 2013-01-02 1
Elizabeth M Brown 109 2012-01-10 2016-02-24 1
Melanie A Kenderdine 106 2013-04-08 2016-03-11 1
Jennifer A Hunt 105 2013-02-06 2015-06-12 1
ELSIE N STECKER 105 2021-01-26 2021-05-07 1
RON BLOOM 103 2009-03-20 2010-03-30 1
LAURA DOWNING 102 2009-12-02 2011-03-04 1
Joseph M Goffman 102 2011-08-18 2016-09-07 1
BETHANY BLAKEY 102 2010-03-26 2011-03-15 1
AMY K LANASA 100 2021-04-05 2021-05-07 1
ADAM NEUFELD 99 2010-03-25 2015-12-14 1
Adam B Chepenik 98 2012-05-23 2016-09-19 1
JOHN THOMAS 97 2009-09-23 2011-03-18 1
Shoshana M Lew 96 2011-10-25 2015-09-16 1
Samia H Alshammaa 96 2011-03-25 2015-11-03 1
Mark C Appleton 96 2011-05-30 2016-01-13 1
CLAUDIA MCNAMARA 96 2009-09-17 2010-01-29 1
Andrew P Durrett 94 2014-05-28 2014-11-26 1
ALEXIS C GONZALUDO 94 2021-04-29 2024-07-29 1
Scott M Winslow 93 2012-02-22 2013-07-24 15:00 1
JAMES W LEVINGS 93 2021-02-26 2022-10-06 1
Michael E Ludwig 91 2012-08-30 2016-07-21 1
Michael A Stegman 91 2012-01-09 2015-05-25 1
Clive A Powell 91 2011-04-11 2016-09-20 1
Sylvia M Burwell 90 2011-10-04 2013-04-26 1
Shirlethia V Franklin 90 2013-11-07 2016-05-25 1
Matthew T McGuire 90 2011-03-28 2016-03-31 1
Liam G McDonough 90 2011-05-21 2016-06-29 1
Edward S McDonough 90 2011-05-21 2016-09-24 1
Mark E Doms 88 2011-03-28 2015-09-09 1
Marilyn n Tavenner 88 2011-04-27 2014-11-24 1
Kathy P Conrad 88 2011-08-09 2015-07-08 1
Ari A Matusiak 88 2011-03-18 2015-06-05 1
Sarah A Larson 87 2011-07-05 2016-01-28 1
JENNIFER A URIZAR 87 2015-06-29 2016-09-28 1
William B Schultz 86 2011-05-25 2016-05-23 1
Shauna L McCarty 86 2011-05-20 2016-09-30 1
Sharon I Block 86 2011-05-13 2015-04-06 1
ELAN STRAIT 86 2016-02-01 2016-08-05 1
CRAIG T JENNINGS 86 2009-12-15 2016-09-29 1
Randall J DeValk 85 2011-10-06 2016-08-03 1
Justin D Ferrell 85 2011-05-13 2015-12-20 1
Gerardo M Rangel 85 2014-07-14 2015-03-02 1
Benjamin R Bergersen 85 2012-05-17 2015-09-10 1
Timothy J Bowler 84 2011-03-30 2015-06-09 1
Michael D Smith 84 2011-07-14 2014-12-23 1
TANNI D NEWLIN 83 2015-08-20 2024-08-29 2
David R Case 83 2013-11-14 2015-11-30 1
Lawrence E Strickling 82 2011-03-29 2015-05-27 1
Jonathan M Levy 82 2011-07-18 2015-10-05 1
Jeffrey D Zients 82 2013-05-01 2014-01-24 1
Jamienne S Studley 82 2013-04-24 2015-10-29 1
Amos J Hochstein 82 2011-10-27 2016-07-31 1
SHAWN J VANDIVER 81 2021-11-17 2024-08-21 1
Richard L Miller 81 2012-02-17 2014-03-06 1
HUN S KIM 81 2010-04-26 2010-09-17 1
Emma L Tchen 81 2011-05-17 2016-06-22 1
KATE M JOSEPHS 80 2015-06-11 2016-08-22 1
ESHA N MATHEW 80 2021-10-28 2024-07-16 1
Peter L Levin 79 2011-04-12 2015-02-20 1
James M Daniel 79 2011-03-30 2015-05-22 1
Lynn D Overmann 78 2011-07-15 2015-07-31 1
DAVID M EVANS 78 2010-06-07 2011-02-04 1
julia a evans 77 2011-04-25 2015-05-09 1
Powered by Datasette · Queries took 1493.879ms