About this Dataset

Allegheny County Employee Salaries

This dataset includes annual salary, regular pay, incentive pay, and gross pay for employees under the County Executive and independently elected County officials for the years 2016 to the present, and is updated twice per year.

For December files, Annual Salary is the employee's annual salary or annualized wage as of the last pay period for the year, and the pay data fields (Regular Pay, Incentive Pay and Gross Pay) are payments made to the employee through the last pay period of the year. The June file contains the Annual Salary, and the pay data as of the last pay period in June. Note that the June file is replaced by the December file each year.

Union contracted salaries and wages which were not settled during the calendar year reflect the wage as of the end of the year. Regular Pay for these positions includes salaries and wages for the year it was paid, not the year it was earned.

In addition to salary or wages for days worked and retroactively settled contract payments, Regular Pay also includes pay for days such as holidays, sick days, and vacation days. Overtime Pay includes pay for extra work typically at a wage rate different from regular wages as set forth in a collective bargaining agreement. Incentive Pay includes such things as a wellness incentive and longevity pay.

Employee names are included in the dataset with the following exceptions permitted by the Pennsylvania Right to Know Law:

The names of individuals who were active sworn law enforcement officers during the year; and
Information that would disclose individually identifiable health information.

Additionally, records related to Court of Common Pleas employees would need to be requested from the Courts.

In March 2022, the salary data files prior to 2021 were updated so that all columns matched for consistent presentation.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:03:19.061022
Tags: local-government

Tables

December 2016 Employee Salaries

@usgov.allegheny_county_city_of_pitts_allegheny_county_employ_3e0270be.december_2016_employee_salaries

325.43 KB
6852 rows
16 columns


CREATE TABLE december_2016_employee_salaries (
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "department" VARCHAR,
  "job_title" VARCHAR,
  "elected_official" BIGINT,
  "date_started" TIMESTAMP,
  "sex" VARCHAR,
  "ethnicity" VARCHAR,
  "orig_start" TIMESTAMP,
  "date_term" TIMESTAMP,
  "pay_status" VARCHAR,
  "annual_salary" DOUBLE,
  "regular_pay" DOUBLE,
  "overtime_pay" DOUBLE,
  "incentive_pay" DOUBLE,
  "gross_pay" DOUBLE
);

December 2017 Employee Salaries

@usgov.allegheny_county_city_of_pitts_allegheny_county_employ_3e0270be.december_2017_employee_salaries

324.29 KB
6764 rows
16 columns


CREATE TABLE december_2017_employee_salaries (
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "department" VARCHAR,
  "job_title" VARCHAR,
  "elected_official" BIGINT,
  "date_started" TIMESTAMP,
  "sex" VARCHAR,
  "ethnicity" VARCHAR,
  "orig_start" TIMESTAMP,
  "date_term" TIMESTAMP,
  "pay_status" VARCHAR,
  "annual_salary" DOUBLE,
  "regular_pay" DOUBLE,
  "overtime_pay" DOUBLE,
  "incentive_pay" DOUBLE,
  "gross_pay" DOUBLE
);

December 2018 Employee Salaries

@usgov.allegheny_county_city_of_pitts_allegheny_county_employ_3e0270be.december_2018_employee_salaries

326.11 KB
6804 rows
16 columns


CREATE TABLE december_2018_employee_salaries (
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "department" VARCHAR,
  "job_title" VARCHAR,
  "elected_official" BIGINT,
  "date_started" TIMESTAMP,
  "sex" VARCHAR,
  "ethnicity" VARCHAR,
  "orig_start" TIMESTAMP,
  "date_term" TIMESTAMP,
  "pay_status" VARCHAR,
  "annual_salary" DOUBLE,
  "regular_pay" DOUBLE,
  "overtime_pay" DOUBLE,
  "incentive_pay" DOUBLE,
  "gross_pay" DOUBLE
);

December 2019 Employee Salaries

@usgov.allegheny_county_city_of_pitts_allegheny_county_employ_3e0270be.december_2019_employee_salaries

322.32 KB
6769 rows
16 columns


CREATE TABLE december_2019_employee_salaries (
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "department" VARCHAR,
  "job_title" VARCHAR,
  "elected_official" BIGINT,
  "date_started" TIMESTAMP,
  "sex" VARCHAR,
  "ethnicity" VARCHAR,
  "orig_start" TIMESTAMP,
  "date_term" TIMESTAMP,
  "pay_status" VARCHAR,
  "annual_salary" DOUBLE,
  "regular_pay" DOUBLE,
  "overtime_pay" DOUBLE,
  "incentive_pay" DOUBLE,
  "gross_pay" DOUBLE
);

December 2020 Employee Salaries

@usgov.allegheny_county_city_of_pitts_allegheny_county_employ_3e0270be.december_2020_employee_salaries

306.43 KB
6333 rows
16 columns


CREATE TABLE december_2020_employee_salaries (
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "department" VARCHAR,
  "job_title" VARCHAR,
  "elected_official" BIGINT,
  "date_started" TIMESTAMP,
  "sex" VARCHAR,
  "ethnicity" VARCHAR,
  "orig_start" TIMESTAMP,
  "date_term" TIMESTAMP,
  "pay_status" VARCHAR,
  "annual_salary" DOUBLE,
  "regular_pay" DOUBLE,
  "overtime_pay" DOUBLE,
  "incentive_pay" DOUBLE,
  "gross_pay" DOUBLE
);

December 2021 Employee Salaries

@usgov.allegheny_county_city_of_pitts_allegheny_county_employ_3e0270be.december_2021_employee_salaries

309.34 KB
6373 rows
16 columns


CREATE TABLE december_2021_employee_salaries (
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "department" VARCHAR,
  "job_title" VARCHAR,
  "elected_official" BIGINT,
  "date_started" TIMESTAMP,
  "sex" VARCHAR,
  "ethnicity" VARCHAR,
  "orig_start" TIMESTAMP,
  "date_term" TIMESTAMP,
  "pay_status" VARCHAR,
  "annual_salary" DOUBLE,
  "regular_pay" DOUBLE,
  "overtime_pay" DOUBLE,
  "incentive_pay" DOUBLE,
  "gross_pay" DOUBLE
);