Dataset: Civil Service List (Active)

About this Dataset

Civil Service List (Active)

A Civil Service List consists of all candidates who passed an exam, ranked in score order. An established list is considered active for no less than one year and no more than four years from the date of establishment. 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:05:50.133230
Tags: admin, cei, citywide-equity-and-inclusion, civil-service-list, construction-and-technical-services, cts, dcas, dem, department-of-citywide-administrative-services, department-of-energy-management, eal-estate-services, exam, facilities-management, fbm, fiscal-and-business-management, fleet, fm, hc, human-capital, name, ocp, office-of-citywide-procurement, office-of-general-counsel, ogc, rank, res, score

Tables

Table 1

@usgov.city_of_new_york_civil_service_list_active.table_1

8.74 MB
438201 rows
20 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,
  "veteran_credit" VARCHAR,
  "parent_lgy_credit" VARCHAR,
  "sibling_lgy_credit" VARCHAR,
  "residency_credit" VARCHAR
);