Dark Mode
Executive Office Staff Pay Data
Data Science and Analytics
Tags and Keywords
Trusted By
"No reviews yet"
Free
About
Data details White House Office staff salaries, gender, and position titles spanning six presidential administrations from 1997 to 2020. This resource offers a meticulously cleaned and structured version of public data points, which were previously scattered and held in various formats. The primary source document used for assessment is the Annual Report to Congress on White House Office Staff, a report mandated since 1995.
Columns
The dataset contains 7 attributes, found in the file
wh_staff_dataset.csv:- year: The year of employment, listed as an integer, covering 1997 to 2020.
- name: The staffer’s name, formatted as [last name], [first name]. Suffixes (such as Jr. or III) are added last, separated by a comma.
- gender: The staffer’s recorded gender (Male, Female, or NA), which was primarily interpolated from the first name.
- status: The employment status, which can be Employee, Employee (part-time), Detailee, or NA.
- salary: The annual salary in nominal US Dollars, presented as an integer without currency symbols. Salaries observed range up to $240,000.
- pay_basis: The basis for payment, typically 'Per Annum' or 'Per Diem'.
- position_title: The name of the staffer’s position title. Note that these may require further normalization as administrations often use different naming conventions for similar roles.
Distribution
The information is provided in a single CSV file,
wh_staff_dataset.csv, with a size of approximately 1.02 MB. The dataset includes over 10.6 thousand valid records. The most frequent employment status is 'Employee', accounting for 94% of the records. The pay basis is almost exclusively 'Per Annum'. A small number of records have missing values for name, gender, salary, and position title, but the overall data validity is exceptionally high.Usage
This dataset is ideal for exploratory data analysis projects related to historical government staffing. Analysts can use this data to study US government income trends and salary progression over two decades. Researchers may compare staffing characteristics, pay scales, and title structures across the Clinton, Bush, Obama, and Trump administrations. Note that due to the reports being issued only once annually, the data captures a specific snapshot (mid-June to early July) and is not suitable for tracking precise staff turnover rates throughout the year.
Coverage
The data covers White House Office staff positions between 1997 and 2020. The scope specifically targets staff whose details are included in the Annual Report to Congress, covering positions within the White House Office, the Domestic Policy Council, and the National Economic Council. It explicitly excludes personnel from the Office of Management and Budget, household staff, military attaches, and all staff belonging to the Office of the Vice President.
License
CC0: Public Domain
Who Can Use It
- Academics and Historians: For longitudinal studies on US political administrative history and salary equity trends.
- Data Journalists: For creating visualisations and reports detailing shifts in government compensation and staffing levels.
- Policy Analysts: For benchmarking government pay scales and employment metrics across different administrations.
Dataset Name Suggestions
- US Presidential Staff Salaries and Titles (1997-2020)
- White House Office Personnel Records
- Executive Office Staff Pay Data
Attributes
Original Data Source: Executive Office Staff Pay Data
QUALITYLoading...