Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

Civil Service List Certification

a9md-ynriCity Government21 columns
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’ “Why You Should Work for the City” webpage at: https://www.nyc.gov/site/dcas/employment/how-can-you-find-upcoming-exams.page. For any questions about the civil service list, the civil service process, exams, or this data please contact us at: https://a856-exams.nyc.gov/OASysWeb/contact.
View on NYC Open Data↗

Quality

A91.5 / 100

From a 500-row sample across 19 columns.

completeness97/ 25% weight
consistency66/ 20% weight
accuracy100/ 20% weight
timeliness100/ 15% weight
usability95/ 20% weight

Related datasets

  • Civil Service List (Active)0.61
    joins onlist_title_desclist_agency_desclist_agency_code+6
  • Civil Service List (Terminated)0.51
    joins onlist_title_desclist_agency_desclist_agency_code+6
  • Greenbook0.40
    joins onlast_namefirst_name
  • City Record Online0.38
  • Civil List0.38

Sample rows

exam_nolist_nofirst_namemilast_namelist_agency_codelist_agency_desclist_title_desccert_seq_norequest_datesalarycert_issue_no
061101KOWNWCHAN868DEPARTMENT OF CITYWIDE ADMINISTRATIVE SERVICESTHERMOSTAT REPAIRER12026-10-08T00:00:00.00066.0892306
06110

Columns

21 queryable · 21 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
exam_notextA four (4) digit number that identifies a civil service examination.0%011280119509011
list_nointegerAn eligible candidate’s placement on a given list as of the business day that the data set is populated.0%1.0002.0003
first_nametextAn eligible candidate’s first name as it appears on their application.0%MICHAELJOHNJOSEPH
mitextAn eligible candidate’s middle initial (MI) as it appears on their application.49%AMJ

Query this from your own app

GET /api/datasets/a9md-ynri
GET /api/datasets/a9md-ynri/quality
GET /api/datasets/a9md-ynri/related
GET /api/columns?dataset=a9md-ynri
Jobs NYC Postings
0.36
  • Citywide Payroll Data (Fiscal Year)0.35
    joins onlast_namefirst_name
  • Film Permits0.35
    • 2
    ASSIMIOU
    —
    YAYA
    868
    DEPARTMENT OF CITYWIDE ADMINISTRATIVE SERVICES
    THERMOSTAT REPAIRER
    2
    2026-10-08T00:00:00.000
    66.08
    92306
    061103PATRICKVDEGASPERIS868DEPARTMENT OF CITYWIDE ADMINISTRATIVE SERVICESTHERMOSTAT REPAIRER32026-10-08T00:00:00.00066.0892306
    061104ANDREWJSPINA868DEPARTMENT OF CITYWIDE ADMINISTRATIVE SERVICESTHERMOSTAT REPAIRER42026-10-08T00:00:00.00066.0892306
    061105PATRICK—MCKAY868DEPARTMENT OF CITYWIDE ADMINISTRATIVE SERVICESTHERMOSTAT REPAIRER52026-10-08T00:00:00.00066.0892306
    061106ALBAN—GJECI868DEPARTMENT OF CITYWIDE ADMINISTRATIVE SERVICESTHERMOSTAT REPAIRER62026-10-08T00:00:00.00066.0892306
    061107DAMOND—BROWN868DEPARTMENT OF CITYWIDE ADMINISTRATIVE SERVICESTHERMOSTAT REPAIRER72026-10-08T00:00:00.00066.0892306
    061108GAJRAJASANSARRAN868DEPARTMENT OF CITYWIDE ADMINISTRATIVE SERVICESTHERMOSTAT REPAIRER82026-10-08T00:00:00.00066.0892306
    061109ALBERT—GJECI868DEPARTMENT OF CITYWIDE ADMINISTRATIVE SERVICESTHERMOSTAT REPAIRER92026-10-08T00:00:00.00066.0892306
    0611010TREVORJWENZEL868DEPARTMENT OF CITYWIDE ADMINISTRATIVE SERVICESTHERMOSTAT REPAIRER102026-10-08T00:00:00.00066.0892306

    Showing 12 of 19 columns. All of them are listed below.

    last_nametextAn eligible candidate’s last name as it appears on their application.0%WILLIAMSRODRIGUEZJOHNSON
    list_agency_codetextA three (3) digit number used to identify an appointing agency (For Promotion List Only).0%056998069
    list_agency_desctextThe name of an appointing Agency.1%POLICE DEPARTMENTN.Y.C. TRANSIT AUTHORITYHRA/DEPARTMENT OF SOCIAL…
    list_title_desctextA descriptive name that identifies a civil service title.0%PRINCIPAL ADMINISTRATIVE…ADMINISTRATIVE MANAGERCOMPUTER SYSTEMS MANAGER
    cert_seq_nointegerA certification sequence number (“Cert Seq No”) indicates an eligible candidate’s placement on a Certification.0%1.0002.0003.000
    request_datedatetimeThe date on which an appointing Agency submits a request for a Certification.0%2017-01-23T00:00:00.0002020-06-29T00:00:00.0002018-02-23T00:00:00.000
    salaryfloatThe hiring salary for a title.0%58700.0047418.0068213
    cert_issue_nointegerA system generated identifier (number or “No”) that is unique to a specific Certification.0%658977314273551
    cert_datedatetimeThe date on which a Certification is created by the Certification Unit at the Department of Citywide Administrative Services.0%2018-01-10T00:00:00.0002018-02-26T00:00:00.0002020-07-01T00:00:00.000
    reissue_datedatetimeThe date on which a Certification will be extended beyond its original expiration date.100%—
    cert_expiration_datedatetimeThe date on which a Certification is scheduled to expire.0%2018-02-12T00:00:00.0002021-01-25T00:00:00.0002020-07-31T00:00:00.000
    no_certifiedintegerRepresents the number (“No”) of eligible candidates sent to an appointing agency as part of the Certification.0%155381553629945
    no_requestedintegerRepresents the number (“No”) of eligible candidates requested by an appointing Agency to fill vacancies.0%50100250
    provisional_replacementcategoricalIndicates if a Certification is being issued to replace a provisional (“Prov”) employee (not permanent)1%NYof 2
    no_vacanciesintegerRepresent the number (“No”) of vacancies an agency is approved to fill.0%125
    list_title_codetextA five (5) digit number that corresponds to and represents a civil service title.0%101241002510050
    sel_cert_descriptiontextA certification sequence number (“Cert Seq No”) indicates an eligible candidate’s placement on a Certification.100%—