About this Dataset

Civil Service List Certification

A List Certification includes the names of eligible candidates on an Active Civil Service List that has been established. The Certification may contain part of a list, the whole list, or multiple lists at the request of an appointing agency, to fill vacancies and/or replace provisionals. Eligible candidates on a Certification may be considered for probable appointment at the appointing Agency. For more information visit DCAS’ “Work for the City” webpage at: https://www1.nyc.gov/site/dcas/employment/take-an-exam.page
Organization: City of New York
Last updated: 2020-11-10T17:01:46.295540
Tags: admin, cei, certification, 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, facilities-management, fbm, fiscal-and-business-management, fleet, fm, hc, human-capital, list, ocp, office-of-citywide-procurement, office-of-general-counsel, ogc, res, title

Tables

Table 1

@usgov.city_of_new_york_civil_service_list_certification.table_1

90.7 MB
5,809,605 rows
21 columns

CREATE TABLE table_1 (
  "exam_no" BIGINT,
  "list_no" DOUBLE,
  "first_name" VARCHAR,
  "mi" VARCHAR,
  "last_name" VARCHAR,
  "list_agency_code" BIGINT,
  "list_agency_desc" VARCHAR,
  "list_title_desc" VARCHAR,
  "cert_seq_no" DOUBLE,
  "request_date" TIMESTAMP,
  "salary" DOUBLE,
  "cert_issue_no" BIGINT,
  "cert_date" TIMESTAMP,
  "reissue_date" VARCHAR,
  "cert_expiration_date" TIMESTAMP,
  "no_certified" BIGINT,
  "no_requested" BIGINT,
  "provisional_replacement" VARCHAR,
  "no_vacancies" BIGINT,
  "list_title_code" BIGINT,
  "sel_cert_description" VARCHAR
);