Dataset: Civil Service List (Terminated)

About this Dataset

Civil Service List (Terminated)

A Civil Service List is considered terminated usually four years after the list has been established, unless it is extended at the Commissioner’s discretion. 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:04:50.209119
Tags: civil, dcas, exam, service

Tables

Table 1

@usgov.city_of_new_york_civil_service_list_terminated.table_1

7.97 MB
610910 rows
21 columns


CREATE TABLE table_1 (
  "exam_no" BIGINT,
  "list_no" DOUBLE,
  "first_name" VARCHAR,
  "mi" VARCHAR,
  "last_name" VARCHAR,
  "adj_fa" DOUBLE,
  "list_title_code" BIGINT,
  "list_title_desc" VARCHAR,
  "group_no" BIGINT,
  "list_agency_code" BIGINT,
  "list_agency_desc" VARCHAR,
  "list_div_code" VARCHAR,
  "published_date" TIMESTAMP,
  "established_date" TIMESTAMP,
  "anniversary_date" TIMESTAMP,
  "extension_date" TIMESTAMP,
  "termination_date" TIMESTAMP,
  "veteran_credit" VARCHAR,
  "parent_lgy_credit" VARCHAR,
  "sibling_lgy_credit" VARCHAR,
  "residency_credit" VARCHAR
);