From a 500-row sample across 28 columns.
list_div_codeexam_nolist_title_code+1exam_nolist_title_codelist_agency_codelist_div_codeexam_nolist_title_code+1| title_description | o_c_or_prom | list_title_code | exam_no | list_agency_code | list_est_date | aac_cnt | aol_cnt | dce_cnt | dea_cnt | dlx_cnt | fra_cnt |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ACCOUNTANT | Open Competitive | 40510 | 8050 | 000 | 2019-07-03T00:00:00.000 | 0 | 0 | 0 | 10 | 0 | 0 |
| ADMINISTRATIVE CITY PLANNER | Open Competitive |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
title_description | text | A descriptive name that identifies a civil service title. | 0% | POLICE OFFICERTRAFFIC ENFORCEMENT AGEN…SCHOOL SAFETY AGENT |
o_c_or_prom | categorical | A descriptive name that identifies a civil service list type. | 0% | O/CPROMOpen Competitiveof 5 |
list_title_code | text | A five (5) digit number that corresponds to and represents a civil service title. | 0% | 702107165160817 |
exam_no | integer | A four (4) digit number that identifies a civil service examination. | 0% |
GET /api/datasets/qjzt-ytn9 GET /api/datasets/qjzt-ytn9/quality GET /api/datasets/qjzt-ytn9/related GET /api/columns?dataset=qjzt-ytn9
title_description| 10053 |
| 8058 |
| 000 |
| 2019-05-15T00:00:00.000 |
| 0 |
| 0 |
| 0 |
| 7 |
| 0 |
| 0 |
| ADMINISTRATIVE CITY PLANNER | Promotional | 10053 | 8538 | 030 | 2018-12-26T00:00:00.000 | 0 | 0 | 0 | 2 | 0 | 0 |
| ADMINISTRATIVE CITY PLANNER | Promotional | 10053 | 8538 | 806 | 2018-12-26T00:00:00.000 | 0 | 0 | 0 | 0 | 0 | 0 |
| ADMINISTRATIVE CITY PLANNER | Promotional | 10053 | 8538 | 826 | 2018-12-26T00:00:00.000 | 0 | 0 | 0 | 1 | 0 | 0 |
| ADMINISTRATIVE CITY PLANNER | Promotional | 10053 | 8538 | 841 | 2018-12-26T00:00:00.000 | 0 | 0 | 0 | 1 | 0 | 0 |
| ADMINISTRATIVE CITY PLANNER | Promotional | 10053 | 8538 | 846 | 2018-12-26T00:00:00.000 | 0 | 0 | 0 | 6 | 0 | 0 |
| ADMINISTRATIVE CITY PLANNER | Promotional | 10053 | 8538 | 868 | 2018-12-26T00:00:00.000 | 0 | 0 | 0 | 1 | 0 | 0 |
| ADMINISTRATIVE COMMUNITY RELATIONS SPECIALIST | Open Competitive | 10022 | 7011 | 000 | 2017-09-20T00:00:00.000 | 0 | 0 | 0 | 1 | 0 | 1 |
| ADMINISTRATIVE CONTRACT SPECIALIST | Open Competitive | 10095 | 8041 | 000 | 2019-10-09T00:00:00.000 | 0 | 0 | 0 | 16 | 0 | 0 |
Showing 12 of 28 columns. All of them are listed below.
331233043301list_agency_code | text | A three (3) digit number used to identify an agency | 0% | 056000 |
agency_desc | text | The name of the agency | 78% | POLICE DEPARTMENTN.Y.C. HOUSING AUTHORITYFIRE DEPARTMENT |
list_div_code | text | A three (3) digit number used to identify an agency (For Transit Promotion lists only). | 100% | — |
list_est_date | datetime | The date on which an eligible list is made available for certification to agencies to consider an eligible candidate for appointment. | 0% | 2023-04-12T00:00:00.0002023-03-29T00:00:00.0002023-10-18T00:00:00.000 |
aac_cnt | integer | # of candidates removed from list due to appointment from Agency Certification ("AAC") Pool | 1% | 0of 1 |
aol_cnt | categorical | # of candidates removed from list due to appointment from another promotion list or unique open competitive list | 1% | 012of 12 |
dce_cnt | categorical | # of candidates removed from list because they were deceased ("DCE") | 1% | 012of 3 |
dea_cnt | integer | # of candidates removed from list because they declined appointment ("DEA") | 1% | 012 |
dlx_cnt | categorical | # of candidates whose declination is based on location of the vacancy on the basis of borough ("DLX") | 1% | 01412of 3 |
fra_cnt | integer | # of candidates who were removed from list due to failing to report or who declined after accepting appointment ("FRA") | 1% | 012 |
frh_cnt | integer | # of candidates who were removed from list due to failing to report for physical ("FRH") | 1% | 014 |
fri_cnt | integer | # of candidates who were removed from list due to failing to report for investigation ("FRI") | 1% | 012 |
frm_cnt | integer | # of candidates who were removed from list due to failing to report for medical ("FRM") | 1% | 012 |
frp_cnt | integer | # of candidates who were removed from list due to failing to report for psychological exam ("FRP") | 1% | 0119 |
ftr_cnt | integer | # of candidates who were removed from list due to failing to report for interview ("FTR") | 1% | 012 |
nfp_cnt | integer | # of candidates who were removed from list due to undeliverable mailing address ("NFP") | 1% | 012 |
nle_cnt | integer | # of candidates who were removed from list due to no longer being employed/not employed in lower titles ("NLE") | 1% | 012 |
ova_cnt | categorical | # of candidates who were removed from list due to being overage for the position ("OVA") | 1% | 021of 16 |
rli_cnt | categorical | # of candidates who were removed from list due to reporting late for interview ("RLI") | 1% | 012of 5 |
tin_cnt | integer | # of candidates who were removed from list due to declination - temporary inability to accept ("TIN") | 1% | 0of 1 |
unf_cnt | categorical | # of candidates who were removed from list due to being underage at the time of filing ("UNF") | 1% | 012of 4 |
appt_cnt | integer | The number of persons appointed or promoted from each eligible list and the agencies to which such appointments or promotions were made | 1% | 012 |
cns_cnt | integer | The number of persons who, during the reporting year, were considered and not selected (CNS) three times from promotion lists | 1% | 012 |
cns_restored_cnt | categorical | The number of persons restored to lists, by the appointing agency, after having been removed and previously recorded as considered and not selected (CNS) | 1% | 012of 12 |
elig_restored_cnt | integer | The number of persons restored to a list following their removal from a list by their own action | 1% | 102 |