About this Dataset

Civil List

The Civil List reports the agency code (DPT), first initial and last name (NAME), agency name (ADDRESS), title code (TTL #), pay class (PC), and salary (SAL-RATE) of individuals who were employed by the City of New York at any given time during the indicated year.
Organization: City of New York
Last updated: 2020-11-10T17:06:21.911244
Tags: admin, cei, citywide-equity-and-inclusion, civil-service, construction-and-technical-services, cts, dcas, dem, department-of-citywide-administrative-services, department-of-energy-management, eal-estate-services, employees, facilities-management, fbm, fiscal-and-business-management, fleet, fm, hc, human-capital, ocp, office-of-citywide-procurement, office-of-general-counsel, ogc, pay, payroll, res, salary

Tables

Table 1

@usgov.city_of_new_york_civil_list.table_1

43.65 MB
2,947,774 rows
7 columns

CREATE TABLE table_1 (
  "calendar_year" BIGINT,
  "agency_code" BIGINT,
  "employee_name" VARCHAR,
  "agency_name" VARCHAR,
  "title_code" VARCHAR,
  "pay_class" VARCHAR,
  "salary_rate" VARCHAR
);