Annual Survey of Public Employment & Payroll (ASPEP) 1992-2016

The Annual Survey of Public Employment &amp; 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 &amp; 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>公共就业与薪资年度调查（Annual Survey of Public Employment & Payroll，简称ASPEP）是美国人口普查局的数据集，收录了公共部门（地方、州及联邦政府）雇员的相关信息。该数据集包含雇员总人数（划分为全职与兼职两类）、雇员总薪酬，以及兼职雇员的总工作时长，且按岗位类别细分，涵盖医院、公共福利、消防、警务等领域。 该数据集按年度提供三类数据：地方政府数据、州政府数据，以及州与地方政府合并数据。其中地方政府数据仅包含地方政府雇员信息，州政府数据仅包含州政府雇员信息，州与地方政府合并数据则整合了前两类数据。从美国人口普查局官网（https://www.census.gov/programs-surveys/apes/data/tables.html）下载的原始数据中，每一年对应一份独立文件。本数据集不仅提供了各年度的独立文件（含原始与清洗后版本），还提供了按数据类型整合所有年度数据的合并文件。 数据集覆盖的年份为1992年至1995年，以及1997年至2016年，1996年数据缺失。其中州政府数据不包含1994年至1995年的信息，地方政府数据及州与地方政府合并数据则不包含1992年数据。所有用于数据下载与清洗的代码均可在GitHub仓库获取：https://github.com/jacobkap/aspep。 可供下载的压缩包包含原始数据、清洗后数据、整合所有年度数据的合并数据集，以及对应合并数据集的代码手册。 原始数据即直接从美国人口普查局官网下载的未作任何修改的文件；清洗后数据对列名、州名及岗位类别进行了标准化处理，以保证各年度数据的一致性，其中州名的标准化处理是将全称替换为州缩写。 关于ASPEP的详细说明可访问：https://www.census.gov/programs-surveys/apes/about.html。 关于数据样本的重要说明如下： "1996年未开展公共就业与薪资年度调查。就业与薪资统计的基准报告期从10月调整为3月，该调整自1997年美国政府普查起生效。普查每五年开展一次（年份末位为2和7的年份）。在两次普查的间隔年份，通过抽取州与地方政府样本收集数据。样本每五年更新一次（年份末位为4和9的年份）。"