wh_personnel_appointees

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

4,997 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: report_year, report_date, admin, name_suffix, status, source_file, source_page, report_date (date)

appointee_id ▼ report_year report_date admin name_full name_normalized name_last name_first name_middle name_suffix status salary_usd pay_basis position_title source_file source_page
1 2013 2013-07-01 obama Marie E Aberger MARIE E ABERGER Aberger Marie E   Employee 42000.0 Per Annum PRESS ASSISTANT 2013-wh-personnel.csv.zip  
2 2013 2013-07-01 obama Yohannes A Abraham YOHANNES A ABRAHAM Abraham Yohannes A   Employee 120000.0 Per Annum SPECIAL ASSISTANT TO THE PRESIDENT AND CHIEF OF STAFF FOR THE OFFICE OF PUBLIC ENGAGEMENT AND INTERGOVERNMENTAL AFFAIRS 2013-wh-personnel.csv.zip  
3 2013 2013-07-01 obama Caroline E Adler CAROLINE E ADLER Adler Caroline E   Employee 75000.0 Per Annum DEPUTY COMMUNICATIONS DIRECTOR 2013-wh-personnel.csv.zip  
4 2013 2013-07-01 obama David P Agnew DAVID P AGNEW Agnew David P   Employee 153500.0 Per Annum DEPUTY ASSISTANT TO THE PRESIDENT AND DIRECTOR OF INTERGOVERNMENTAL AFFAIRS 2013-wh-personnel.csv.zip  
5 2013 2013-07-01 obama Rita C Aguilar RITA C AGUILAR Aguilar Rita C   Employee 90000.0 Per Annum SENIOR CONFIRMATIONS ADVISOR 2013-wh-personnel.csv.zip  
6 2013 2013-07-01 obama Rumana A Ahmed RUMANA A AHMED Ahmed Rumana A   Employee 42565.0 Per Annum EXECUTIVE ASSISTANT TO THE DIRECTOR OF PUBLIC ENGAGEMENT 2013-wh-personnel.csv.zip  
7 2013 2013-07-01 obama James Albino JAMES ALBINO Albino James     Employee 93000.0 Per Annum SENIOR PROGRAM MANAGER 2013-wh-personnel.csv.zip  
8 2013 2013-07-01 obama Elias Alcantara ELIAS ALCANTARA Alcantara Elias     Employee 42000.0 Per Annum STAFF ASSISTANT 2013-wh-personnel.csv.zip  
9 2013 2013-07-01 obama Gabriel F Amo JR GABRIEL F AMO JR Amo Gabriel F JR Employee 42000.0 Per Annum STAFF ASSISTANT 2013-wh-personnel.csv.zip  
10 2013 2013-07-01 obama Amanda D Anderson AMANDA D ANDERSON Anderson Amanda D   Employee 102000.0 Per Annum SPECIAL ASSISTANT TO THE PRESIDENT FOR LEGISLATIVE AFFAIRS 2013-wh-personnel.csv.zip  
11 2013 2013-07-01 obama Paulette L Aniskoff PAULETTE L ANISKOFF Aniskoff Paulette L   Employee 153500.0 Per Annum DEPUTY ASSISTANT TO THE PRESIDENT AND DIRECTOR OF THE OFFICE OF PUBLIC ENGAGEMENT 2013-wh-personnel.csv.zip  
12 2013 2013-07-01 obama Adam J Arguelles ADAM J ARGUELLES Arguelles Adam J   Employee 102000.0 Per Annum SPECIAL ASSISTANT TO THE PRESIDENT FOR LEGISLATIVE AFFAIRS 2013-wh-personnel.csv.zip  
13 2013 2013-07-01 obama Jonathan D Asen JONATHAN D ASEN Asen Jonathan D   Employee 55000.0 Per Annum SPECIAL ASSISTANT TO THE DEPUTY CHIEF OF STAFF 2013-wh-personnel.csv.zip  
14 2013 2013-07-01 obama Caroline M Atkinson CAROLINE M ATKINSON Atkinson Caroline M   Employee 130500.0 Per Annum SPECIAL ASSISTANT TO THE PRESIDENT FOR INTERNATIONAL ECONOMIC AFFAIRS 2013-wh-personnel.csv.zip  
15 2013 2013-07-01 obama Hannah M August HANNAH M AUGUST August Hannah M   Employee 70000.0 Per Annum PRESS SECRETARY TO THE FIRST LADY 2013-wh-personnel.csv.zip  
16 2013 2013-07-01 obama Steven A Avila STEVEN A AVILA Avila Steven A   Employee 42000.0 Per Annum ANALYST 2013-wh-personnel.csv.zip  
17 2013 2013-07-01 obama Lindsay A Ayling LINDSAY A AYLING Ayling Lindsay A   Employee 50000.0 Per Annum SENIOR WRITER 2013-wh-personnel.csv.zip  
18 2013 2013-07-01 obama Lamar W Baker LAMAR W BAKER Baker Lamar W   Detailee 134999.0 Per Annum ASSOCIATE COUNSEL 2013-wh-personnel.csv.zip  
19 2013 2013-07-01 obama Desiree N Barnes DESIREE N BARNES Barnes Desiree N   Employee 42000.0 Per Annum PRESS ASSISTANT 2013-wh-personnel.csv.zip  
20 2013 2013-07-01 obama Alexis S Barrett ALEXIS S BARRETT Barrett Alexis S   Employee 78000.0 Per Annum SENIOR POLICY ADVISOR 2013-wh-personnel.csv.zip  
21 2013 2013-07-01 obama Kristen A Bartoloni KRISTEN A BARTOLONI Bartoloni Kristen A   Employee 55000.0 Per Annum ASSOCIATE RESEARCH DIRECTOR 2013-wh-personnel.csv.zip  
22 2013 2013-07-01 obama Mary E Baskerville MARY E BASKERVILLE Baskerville Mary E   Employee 47000.0 Per Annum ASSOCIATE DIRECTOR FOR TRAVEL PLANNING 2013-wh-personnel.csv.zip  
23 2013 2013-07-01 obama Andrew J Bates ANDREW J BATES Bates Andrew J   Employee 45000.0 Per Annum RESEARCHER 2013-wh-personnel.csv.zip  
24 2013 2013-07-01 obama Stephanie Beechem STEPHANIE BEECHEM Beechem Stephanie     Employee 45000.0 Per Annum RESEARCHER 2013-wh-personnel.csv.zip  
25 2013 2013-07-01 obama Brandon M Belford BRANDON M BELFORD Belford Brandon M   Employee 90000.0 Per Annum SENIOR POLICY ADVISOR 2013-wh-personnel.csv.zip  
26 2013 2013-07-01 obama Emmett S Beliveau EMMETT S BELIVEAU Beliveau Emmett S   Employee 158500.0 Per Annum DEPUTY ASSISTANT TO THE PRESIDENT AND DIRECTOR OF THE WHITE HOUSE MILITARY OFFICE 2013-wh-personnel.csv.zip  
27 2013 2013-07-01 obama Jeremy M Bernard JEREMY M BERNARD Bernard Jeremy M   Employee 118000.0 Per Annum SPECIAL ASSISTANT TO THE PRESIDENT AND WHITE HOUSE SOCIAL SECRETARY 2013-wh-personnel.csv.zip  
28 2013 2013-07-01 obama Jeremy W Bernton JEREMY W BERNTON Bernton Jeremy W   Employee 55000.0 Per Annum OUTREACH AND RECRUITMENT DIRECTOR (COMMUNITY ORGANIZATIONS) 2013-wh-personnel.csv.zip  
29 2013 2013-07-01 obama Elizabeth D Berrigan ELIZABETH D BERRIGAN Berrigan Elizabeth D   Detailee 152635.0 Per Annum ETHICS COUNSEL 2013-wh-personnel.csv.zip  
30 2013 2013-07-01 obama Mary U Binns MARY U BINNS Binns Mary U   Employee 72022.0 Per Annum SPECIAL ASSISTANT 2013-wh-personnel.csv.zip  
31 2013 2013-07-01 obama Patricia A Blair PATRICIA A BLAIR Blair Patricia A   Employee 96725.0 Per Annum CHIEF CALLIGRAPHER 2013-wh-personnel.csv.zip  
32 2013 2013-07-01 obama Jessica M Blakemore JESSICA M BLAKEMORE Blakemore Jessica M   Employee 60000.0 Per Annum SPECIAL ASSISTANT TO THE COUNSELOR TO THE PRESIDENT 2013-wh-personnel.csv.zip  
33 2013 2013-07-01 obama Antony J Blinken ANTONY J BLINKEN Blinken Antony J   Employee 172200.0 Per Annum ASSISTANT TO THE PRESIDENT AND DEPUTY NATIONAL SECURITY ADVISOR 2013-wh-personnel.csv.zip  
34 2013 2013-07-01 obama Kellyn H Blossom KELLYN H BLOSSOM Blossom Kellyn H   Employee 70000.0 Per Annum ASSOCIATE DIRECTOR OF INTERGOVERNMENTAL AFFAIRS 2013-wh-personnel.csv.zip  
35 2013 2013-07-01 obama Patricia H Blount PATRICIA H BLOUNT Blount Patricia H   Employee 51630.0 Per Annum RECORDS MANAGEMENT ANALYST 2013-wh-personnel.csv.zip  
36 2013 2013-07-01 obama Chelsea M Bollinger CHELSEA M BOLLINGER Bollinger Chelsea M   Employee 42000.0 Per Annum STAFF ASSISTANT 2013-wh-personnel.csv.zip  
37 2013 2013-07-01 obama Katherine Y Branch KATHERINE Y BRANCH Branch Katherine Y   Employee 70000.0 Per Annum DIRECTOR OF SPECIAL PROJECTS AND SPECIAL ASSISTANT TO THE SENIOR ADVISOR 2013-wh-personnel.csv.zip  
38 2013 2013-07-01 obama Kate E Brandt KATE E BRANDT Brandt Kate E   Detailee 92001.0 Per Annum ENERGY/ENVIRONMENT DIRECTOR FOR PRESIDENTIAL PERSONNEL 2013-wh-personnel.csv.zip  
39 2013 2013-07-01 obama Anita J Breckenridge ANITA J BRECKENRIDGE Breckenridge Anita J   Employee 120000.0 Per Annum SPECIAL ASSISTANT TO THE PRESIDENT AND PERSONAL AIDE TO THE PRESIDENT 2013-wh-personnel.csv.zip  
40 2013 2013-07-01 obama Kristina T Broadie KRISTINA T BROADIE Broadie Kristina T   Employee 45000.0 Per Annum TRAVEL PLANNER 2013-wh-personnel.csv.zip  
41 2013 2013-07-01 obama Mary J Brooke MARY J BROOKE Brooke Mary J   Employee 97936.0 Per Annum SUPERVISOR OF CORRESPONDENCE REVIEW 2013-wh-personnel.csv.zip  
42 2013 2013-07-01 obama Jordan A Brooks JORDAN A BROOKS Brooks Jordan A   Employee 50000.0 Per Annum SPECIAL ASSISTANT TO THE CHIEF OF STAFF TO THE FIRST LADY 2013-wh-personnel.csv.zip  
43 2013 2013-07-01 obama Debra S Brown DEBRA S BROWN Brown Debra S   Employee 85953.0 Per Annum CALLIGRAPHER 2013-wh-personnel.csv.zip  
44 2013 2013-07-01 obama Tramaine D Brown TRAMAINE D BROWN Brown Tramaine D   Employee 50000.0 Per Annum SCHEDULING ASSISTANT AND TRIP COORDINATOR 2013-wh-personnel.csv.zip  
45 2013 2013-07-01 obama Amy J Brundage AMY J BRUNDAGE Brundage Amy J   Employee 103000.0 Per Annum SPECIAL ASSISTANT TO THE PRESIDENT AND DEPUTY PRESS SECRETARY 2013-wh-personnel.csv.zip  
46 2013 2013-07-01 obama Michael P Brush MICHAEL P BRUSH Brush Michael P   Employee 102000.0 Per Annum SPECIAL ASSISTANT TO THE PRESIDENT AND DEPUTY DIRECTOR OF ADVANCE 2013-wh-personnel.csv.zip  
47 2013 2013-07-01 obama Scott E Buckhout SCOTT E BUCKHOUT Buckhout Scott E   Employee 45000.0 Per Annum POLICY ASSISTANT 2013-wh-personnel.csv.zip  
48 2013 2013-07-01 obama Jillian M Burger JILLIAN M BURGER Burger Jillian M   Employee 42000.0 Per Annum ANALYST 2013-wh-personnel.csv.zip  
49 2013 2013-07-01 obama Jordan M Burke JORDAN M BURKE Burke Jordan M   Employee 82500.0 Per Annum SPECIAL ASSISTANT TO THE PRESIDENT AND ASSISTANT COMMUNICATIONS DIRECTOR 2013-wh-personnel.csv.zip  
50 2013 2013-07-01 obama Tovah R Calderon TOVAH R CALDERON Calderon Tovah R   Detailee 155500.0 Per Annum SENIOR POLICY ADVISOR 2013-wh-personnel.csv.zip  
51 2013 2013-07-01 obama Frances L Campbell FRANCES L CAMPBELL Campbell Frances L   Employee 103872.0 Per Annum SUPERVISOR, DOCUMENT MANAGEMENT AND TRACKING UNIT 2013-wh-personnel.csv.zip  
52 2013 2013-07-01 obama David R Campos DAVID R CAMPOS Campos David R   Employee 42565.0 Per Annum SENIOR ANALYST 2013-wh-personnel.csv.zip  
53 2013 2013-07-01 obama Kristie A Canegallo KRISTIE A CANEGALLO Canegallo Kristie A   Employee 120000.0 Per Annum SPECIAL ASSISTANT TO THE PRESIDENT AND ADVISOR TO THE CHIEF OF STAFF 2013-wh-personnel.csv.zip  
54 2013 2013-07-01 obama Anne R Cardenas ANNE R CARDENAS Cardenas Anne R   Employee 42000.0 Per Annum ANALYST 2013-wh-personnel.csv.zip  
55 2013 2013-07-01 obama Evan S Carmen EVAN S CARMEN Carmen Evan S   Employee 42000.0 Per Annum ANALYST 2013-wh-personnel.csv.zip  
56 2013 2013-07-01 obama James F Carney JAMES F CARNEY Carney James F   Employee 172200.0 Per Annum ASSISTANT TO THE PRESIDENT AND PRESS SECRETARY 2013-wh-personnel.csv.zip  
57 2013 2013-07-01 obama Bradley W Carroll BRADLEY W CARROLL Carroll Bradley W   Employee 78000.0 Per Annum COMMUNICATIONS DIRECTOR OF THE DOMESTIC POLICY COUNCIL AND OFFICE OF NATIONAL AIDS POLICY 2013-wh-personnel.csv.zip  
58 2013 2013-07-01 obama Kinsey E Casey KINSEY E CASEY Casey Kinsey E   Employee 55000.0 Per Annum NATIONAL SECURITY DIRECTOR FOR PRESIDENTIAL PERSONNEL 2013-wh-personnel.csv.zip  
59 2013 2013-07-01 obama Teresa R Chaurand TERESA R CHAURAND Chaurand Teresa R   Employee 113000.0 Per Annum SPECIAL ASSISTANT TO THE PRESIDENT FOR PRESIDENTIAL PERSONNEL 2013-wh-personnel.csv.zip  
60 2013 2013-07-01 obama Mark B Childress MARK B CHILDRESS Childress Mark B   Employee 172200.0 Per Annum ASSISTANT TO THE PRESIDENT AND DEPUTY CHIEF OF STAFF FOR PLANNING 2013-wh-personnel.csv.zip  
61 2013 2013-07-01 obama Theodore A Chiodo THEODORE A CHIODO Chiodo Theodore A   Employee 90000.0 Per Annum CHIEF OF STAFF, OFFICE OF THE STAFF SECRETARY 2013-wh-personnel.csv.zip  
62 2013 2013-07-01 obama Ronnie S Cho RONNIE S CHO Cho Ronnie S   Employee 65000.0 Per Annum ASSOCIATE DIRECTOR OF PUBLIC ENGAGEMENT 2013-wh-personnel.csv.zip  
63 2013 2013-07-01 obama Melanca D Clark MELANCA D CLARK Clark Melanca D   Detailee 140259.0 Per Annum SENIOR POLICY ADVISOR 2013-wh-personnel.csv.zip  
64 2013 2013-07-01 obama Lilia H Claude LILIA H CLAUDE Claude Lilia H   Employee 60232.0 Per Annum INFORMATION SERVICES OPERATOR 2013-wh-personnel.csv.zip  
65 2013 2013-07-01 obama John S Click JOHN S CLICK Click John S   Employee 45024.0 Per Annum INFORMATION SERVICES OPERATOR 2013-wh-personnel.csv.zip  
66 2013 2013-07-01 obama Kwesi A Cobbina KWESI A COBBINA Cobbina Kwesi A   Employee 95000.0 Per Annum SPECIAL ASSISTANT TO THE PRESIDENT AND POLICY ADVISOR TO THE OFFICE OF THE CHIEF OF STAFF 2013-wh-personnel.csv.zip  
67 2013 2013-07-01 obama Kasie M Coccaro KASIE M COCCARO Coccaro Kasie M   Employee 47500.0 Per Annum ASSOCIATE DIRECTOR OF ONLINE OUTREACH AND OPERATIONS 2013-wh-personnel.csv.zip  
68 2013 2013-07-01 obama David Z Cohen DAVID Z COHEN Cohen David Z   Employee 50000.0 Per Annum ASSISTANT DIRECTOR FOR CABINET AFFAIRS OPERATIONS 2013-wh-personnel.csv.zip  
69 2013 2013-07-01 obama Elyse Cohen ELYSE COHEN Cohen Elyse     Employee 0.0 Per Annum DEPUTY DIRECTOR, LET'S MOVE! 2013-wh-personnel.csv.zip  
70 2013 2013-07-01 obama Evan N Cohen EVAN N COHEN Cohen Evan N   Employee 42000.0 Per Annum ANALYST 2013-wh-personnel.csv.zip  
71 2013 2013-07-01 obama Ilona R Cohen ILONA R COHEN Cohen Ilona R   Employee 130500.0 Per Annum SPECIAL ASSISTANT TO THE PRESIDENT AND ASSOCIATE COUNSEL TO THE PRESIDENT 2013-wh-personnel.csv.zip  
72 2013 2013-07-01 obama Nora E Cohen NORA E COHEN Cohen Nora E   Employee 55000.0 Per Annum SPECIAL ASSISTANT AND ADVANCE LEAD 2013-wh-personnel.csv.zip  
73 2013 2013-07-01 obama Pamela D Coleman PAMELA D COLEMAN Coleman Pamela D   Employee 55000.0 Per Annum OUTREACH AND RECRUITMENT DIRECTOR 2013-wh-personnel.csv.zip  
74 2013 2013-07-01 obama Grant N Colfax GRANT N COLFAX Colfax Grant N   Employee 100000.0 Per Annum DIRECTOR OF THE OFFICE OF NATIONAL AIDS POLICY 2013-wh-personnel.csv.zip  
75 2013 2013-07-01 obama Matthew V Compton MATTHEW V COMPTON Compton Matthew V   Employee 67500.0 Per Annum DEPUTY DIRECTOR OF DIGITAL CONTENT 2013-wh-personnel.csv.zip  
76 2013 2013-07-01 obama Tara C Corrigan TARA C CORRIGAN Corrigan Tara C   Employee 65000.0 Per Annum ASSOCIATE DIRECTOR OF INTERGOVERNMENTAL AFFAIRS 2013-wh-personnel.csv.zip  
77 2013 2013-07-01 obama Caroline M Coscia CAROLINE M COSCIA Coscia Caroline M   Employee 50000.0 Per Annum SPECIAL ASSISTANT AND PRESS LEAD 2013-wh-personnel.csv.zip  
78 2013 2013-07-01 obama Francesca-Maria L Covey FRANCESCA-MARIA L COVEY Covey Francesca-Maria L   Employee 42000.0 Per Annum PUBLIC ENGAGEMENT LIAISON 2013-wh-personnel.csv.zip  
79 2013 2013-07-01 obama Alexandra M Crabtree ALEXANDRA M CRABTREE Crabtree Alexandra M   Employee 47000.0 Per Annum ASSOCIATE DIRECTOR OF WHITE HOUSE PERSONNEL 2013-wh-personnel.csv.zip  
80 2013 2013-07-01 obama Steven P Croley STEVEN P CROLEY Croley Steven P   Employee 158500.0 Per Annum DEPUTY ASSISTANT TO THE PRESIDENT AND DEPUTY COUNSEL TO THE PRESIDENT 2013-wh-personnel.csv.zip  
81 2013 2013-07-01 obama Danielle M Crutchfield DANIELLE M CRUTCHFIELD Crutchfield Danielle M   Employee 172200.0 Per Annum ASSISTANT TO THE PRESIDENT AND DIRECTOR OF SCHEDULING AND ADVANCE 2013-wh-personnel.csv.zip  
82 2013 2013-07-01 obama Patrick J Cunnane PATRICK J CUNNANE Cunnane Patrick J   Employee 42000.0 Per Annum PRESS ASSISTANT 2013-wh-personnel.csv.zip  
83 2013 2013-07-01 obama Chase M Cushman CHASE M CUSHMAN Cushman Chase M   Employee 68000.0 Per Annum DEPUTY DIRECTOR OF SCHEDULING 2013-wh-personnel.csv.zip  
84 2013 2013-07-01 obama Casey R Davis-Van Atta CASEY R DAVIS-VAN ATTA Davis-Van Atta Casey R   Employee 50000.0 Per Annum SENIOR WRITER 2013-wh-personnel.csv.zip  
85 2013 2013-07-01 obama Christopher J Dawe CHRISTOPHER J DAWE Dawe Christopher J   Detailee 136134.0 Per Annum POLICY ADVISOR FOR HEALTH CARE 2013-wh-personnel.csv.zip  
86 2013 2013-07-01 obama Laura A Dean LAURA A DEAN Dean Laura A   Employee 50000.0 Per Annum ASSISTANT SPEECHWRITER 2013-wh-personnel.csv.zip  
87 2013 2013-07-01 obama Brian K DeGuzman BRIAN K DEGUZMAN DeGuzman Brian K   Employee 56791.0 Per Annum DIRECTOR OF INFORMATION SERVICES 2013-wh-personnel.csv.zip  
88 2013 2013-07-01 obama Danilo DeGuzman JR DANILO DEGUZMAN JR DeGuzman Danilo   JR Employee 74958.0 Per Annum PRESIDENTIAL SUPPORT SPECIALIST 2013-wh-personnel.csv.zip  
89 2013 2013-07-01 obama Stacie I Dennis STACIE I DENNIS Dennis Stacie I   Employee 42000.0 Per Annum ANALYST 2013-wh-personnel.csv.zip  
90 2013 2013-07-01 obama David R Dietz DAVID R DIETZ Dietz David R   Employee 42000.0 Per Annum SPECIAL ASSISTANT TO THE CHIEF OF STAFF FOR THE OFFICE OF PUBLIC ENGAGEMENT AND INTERGOVERNMENTAL AFFAIRS 2013-wh-personnel.csv.zip  
91 2013 2013-07-01 obama Daniel J Dominguez DANIEL J DOMINGUEZ Dominguez Daniel J   Employee 114000.0 Per Annum SPECIAL ASSISTANT TO THE PRESIDENT AND ASSOCIATE COUNSEL TO THE PRESIDENT 2013-wh-personnel.csv.zip  
92 2013 2013-07-01 obama Thomas E Donilon THOMAS E DONILON Donilon Thomas E   Employee 172200.0 Per Annum ASSISTANT TO THE PRESIDENT AND NATIONAL SECURITY ADVISOR 2013-wh-personnel.csv.zip  
93 2013 2013-07-01 obama Michael W Donovan MICHAEL W DONOVAN Donovan Michael W   Employee 64000.0 Per Annum SENIOR SCHEDULER 2013-wh-personnel.csv.zip  
94 2013 2013-07-01 obama Monique Dorsainvil MONIQUE DORSAINVIL Dorsainvil Monique     Employee 50000.0 Per Annum DEPUTY DIRECTOR OF ADVANCE AND SPECIAL EVENTS FOR THE OFFICE OF PUBLIC ENGAGEMENT AND INTERGOVERNMENTAL AFFAIRS 2013-wh-personnel.csv.zip  
95 2013 2013-07-01 obama Mark A Doumet MARK A DOUMET Doumet Mark A   Employee 68500.0 Per Annum CHIEF OF STAFF TO THE WHITE HOUSE COUNSEL 2013-wh-personnel.csv.zip  
96 2013 2013-07-01 obama Philip C Droege PHILIP C DROEGE Droege Philip C   Employee 140259.0 Per Annum DIRECTOR OF RECORDS MANAGEMENT 2013-wh-personnel.csv.zip  
97 2013 2013-07-01 obama Katherine I Duceman KATHERINE I DUCEMAN Duceman Katherine I   Employee 42000.0 Per Annum STAFF ASSISTANT 2013-wh-personnel.csv.zip  
98 2013 2013-07-01 obama Clay A Dumas CLAY A DUMAS Dumas Clay A   Employee 60000.0 Per Annum SPECIAL ASSISTANT TO THE SENIOR ADVISOR AND THE DEPUTY CHIEF OF STAFF 2013-wh-personnel.csv.zip  
99 2013 2013-07-01 obama Julia L Duncan JULIA L DUNCAN Duncan Julia L   Employee 42000.0 Per Annum EXECUTIVE ASSISTANT TO THE DIRECTOR OF THE PRESIDENTIAL PERSONNEL OFFICE 2013-wh-personnel.csv.zip  
100 2013 2013-07-01 obama Joseph T Durheim JOSEPH T DURHEIM Durheim Joseph T   Employee 42565.0 Per Annum SENIOR ANALYST 2013-wh-personnel.csv.zip  

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE wh_personnel_appointees (
    appointee_id     INTEGER PRIMARY KEY AUTOINCREMENT,
    report_year      INTEGER NOT NULL,
    report_date      TEXT,                       -- ISO YYYY-MM-DD
    admin            TEXT NOT NULL,              -- obama | trump-1 | biden | trump-2
    name_full        TEXT,                       -- as printed
    name_normalized  TEXT,                       -- UPPER, no punctuation, "FIRST LAST"
    name_last        TEXT,
    name_first       TEXT,
    name_middle      TEXT,                       -- middle initial or "" if absent
    name_suffix      TEXT,                       -- JR | SR | II | III | "" if absent
    status           TEXT,                       -- Employee | Detailee | (etc.)
    salary_usd       REAL,                       -- 0.0 for unpaid
    pay_basis        TEXT,                       -- Per Annum | Per Diem | ...
    position_title   TEXT,
    source_file      TEXT,
    source_page      INTEGER
);
CREATE INDEX idx_whpa_year ON wh_personnel_appointees(report_year);
CREATE INDEX idx_whpa_admin ON wh_personnel_appointees(admin);
CREATE INDEX idx_whpa_name ON wh_personnel_appointees(name_last, name_first);
CREATE INDEX idx_whpa_norm ON wh_personnel_appointees(name_normalized);