DOI: 10.3886/e101399v5-12591
title: Annual Survey of Public Employment & Payroll (ASPEP) 1992-2016

description: Version 5 release notes: <br>Fix bug in county-level data where missing data values (e.g. 99999999) were not replaced with NA.<br>Version 4:Adds a new data set which has aggregated county-level data for years 1993-2016. There is no data for 1996. These data combine all jurisdiction (e.g. cities, county government) in a county to get the sum values for all included variables. <br>Each jurisdiction includes a sample weight (the reciprocal of the "probability of selection" that is included in the data). I multiplied all values by this weight before aggregating to the county level. <br>According to the ASPEP documentation by the Census Bureau, "A census [of governments] is conducted every five years (years ending in â¿¿2â¿¿ and â¿¿7â¿¿). A sample of state and local governments is used to collect data in the intervening years. A new sample is selected every five years (years ending in â¿¿4â¿¿ and â¿¿9â¿¿)." https://www.census.gov/programs-surveys/apes/about.html<br>The variables included are the following (also included, but unlisted, are geographic and year identifier variables).<br>Government function (e.g. police, firefighters, waste management)Number of full-time employeesNumber of full-time equivalent employeesNumber of full-time hoursFull-time employee payroll (for a single month; October for 1992-1996, March otherwise)Number of part-time employeesNumber of part-time hoursPart-time employee payroll (for a single month; October for 1992-1996, March otherwise).Equivalent employees are defined by the Technical Documentation for 1992-2001 Survey Years file as "A computed statistic representing the number of full-time employees that could have been employed if the reported number of hours worked by part-time employees had been worked by full-time employees."<br>Version 3:Fixes a bug for years 1998 and 1999 where column names were not standardized properly. <br>The Annual Survey of Public Employment & Payroll (ASPEP) is a Census data set with information about public (local, state, and federal government) employees, This data includes the total number of employees (broken between full-time and part-time), their total pay, and the total number of hours part-time workers worked. This is broken by job categories such as Hospital, Public Welfare, Firefighters, and Police. <br><br>There are three types of data for each year: Local, State, State and Local. Local includes only local government employees, State includes only state employees, and State and Local combines the two. When the data is downloaded from the Census (https://www.census.gov/programs-surveys/apes/data/tables.html), each year is an individual file. The data here offers each year individually (cleaned and raw) as well as a file that combines all the years for each type.<br><br>Data is available for years 1992-1995 and 1997-2016. 1996 data is not available. The State data also does not include years 1994-1995. Local, and State and Local do not include 1992. All of the code for downloading and cleaning the data is available on GitHub here. https://github.com/jacobkap/aspep<br><br>The zip files available to download contain the raw data, the clean data, and combined data set (all years combined into one file) and a codebook for that combined data set.<br><br>The raw data is the file downloaded from the Census website with no changes. The clean data changes the column names, state names, and job categories to be consistent over the years. The change in state names is from the full name to the state abbreviation. <br><br>Details about the ASPEP are here. https://www.census.gov/programs-surveys/apes/about.html.<br><br>Important info about samples within the data:<br>"There was no Annual Survey of Public Employment & Payroll for 1996. The base reporting period for measuring employment and payrolls was changed from October to March. This change became effective with the 1997 Census of Governments. A census is conducted every five years (years ending in â¿¿2â¿¿ and â¿¿7â¿¿). A sample of state and local governments is used to collect data in the intervening years. A new sample is selected every five years (years ending in â¿¿4â¿¿ and â¿¿9â¿¿)."<br><br><br><br>
description: Public employees in the United States.<br>Smallest Geographic Unit: County