From a 500-row sample across 11 columns.
agencyexam_no| acronym | agency | appeal_type | appeal_subtype | date_filed | date_closed | exam_no | expiration | status | title |
|---|---|---|---|---|---|---|---|---|---|
| NYPD | Police Department - NYPD | Section 50 | Psych | 2014-01-02T00:00:00.000 | 2014-10-07T00:00:00.000 | 311 | 2016-06-29T00:00:00.000 | Closed | Police Officer |
| DOC | Department of Correction - DOC | Section 50 | Medical | 2014-01-02T00:00:00.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
acronym | text | Indicates the agency acronym/abbreviation | 0% | DCASNYPDDOC |
agency | text | Indicates which agency made the underlying determination from which Appellant has filed an appeal | 0% | Department of Citywide A…Police Department - NYPDDepartment of Correction… |
appeal_type | categorical | Indicates under which section of the Civil Service Law the appeal was brought. CSL Section 50 refers to disqualification appeals. CSL Section 72 refers to medical separation-related appeals. CSL Section 76 refers to disciplinary appeals. Jurisdictional issue appeals, indicates that the Commission finds that the appeal presents an issue as to whether the Commission has jurisdiction. Other appeals, indicates miscellaneous or infrequent agency determinations that are subject to the Commission's | 0% | Section 50Waiting for DQSection 76 |
GET /api/datasets/axvu-zc97 GET /api/datasets/axvu-zc97/quality GET /api/datasets/axvu-zc97/related GET /api/columns?dataset=axvu-zc97
exam_no| 2015-03-17T00:00:00.000 |
| 1301 |
| 2017-04-03T00:00:00.000 |
| Closed |
| CORRECTION OFFICER |
| DCAS | Department of Citywide Administrative Services - DCAS | Section 50 | Eligibility | 2014-01-02T00:00:00.000 | 2015-06-16T00:00:00.000 | 3533 | 2018-01-15T00:00:00.000 | Closed | Prom. to Supervisor of Stock Wkrs. |
| FDNY | Fire Department - FDNY | Section 50 | Medical | 2014-01-03T00:00:00.000 | 2014-06-05T00:00:00.000 | 2500 | 2016-12-19T00:00:00.000 | Closed | FIREFIGHTER |
| DOC | Department of Correction - DOC | Section 50 | Medical | 2014-01-06T00:00:00.000 | 2014-06-17T00:00:00.000 | 1307 | 2017-04-04T00:00:00.000 | Closed | CORRECTION OFFICER |
| DCAS | Department of Citywide Administrative Services - DCAS | Section 50 | Character | 2014-01-06T00:00:00.000 | 2014-06-24T00:00:00.000 | 149 | 2015-02-09T00:00:00.000 | Closed | SPECIAL OFFICER |
| DCAS | Department of Citywide Administrative Services - DCAS | Section 50 | Education and Experience | 2014-01-06T00:00:00.000 | 2014-09-17T00:00:00.000 | 2042 | — | Closed | City Tax Auditor |
| NYPD | Police Department - NYPD | Section 50 | Medical | 2014-01-06T00:00:00.000 | 2014-12-02T00:00:00.000 | 1315 | 2016-07-09T00:00:00.000 | Closed | POLICE OFFICER |
| NYPD | Police Department - NYPD | Section 50 | Character | 2014-01-06T00:00:00.000 | 2014-12-03T00:00:00.000 | 8132 | 2016-05-30T00:00:00.000 | Closed | POLICE OFFICER |
| NYPD | Police Department - NYPD | Section 50 | Psych | 2014-01-06T00:00:00.000 | 2014-12-08T00:00:00.000 | 1302 | 2016-07-01T00:00:00.000 | Closed | POLICE OFFICER |
appeal_subtype | text | In CSL Section 50 appeals, indicates the agency’s basis for disqualifying the candidate. In CSL Section 76 appeals, indicates the disciplinary penalty imposed by the employing agency. In jurisdictional issue appeals, indicates that the Commission finds that the appeal presents an issue as to whether the Commission has jurisdiction. | 8% | Education and ExperiencePsychCharacter |
date_filed | datetime | Indicates the date that the Civil Service Commission received Appellant’s appeal. | 0% | 2018-06-08T00:00:00.0002020-05-27T00:00:00.0002024-08-14T00:00:00.000 |
date_closed | datetime | Indicates the date that the Civil Service Commission made a final determination regarding the appeal. | 2% | 2016-02-17T00:00:00.0002016-05-24T00:00:00.0002015-11-27T00:00:00.000 |
exam_no | integer | In CSL Section 50 appeals, indicates the civil service examination number to which Appellant applied. Does not apply to CSL Section 76 appeals and will appear blank. | 10% | 732383392000 |
expiration | datetime | In CSL Section 50 appeals, indicates the date on which the list established for the corresponding civil service examination is set to expire. Does not apply to CSL Section 76 appeals and will appear blank. | 30% | 2017-06-26T00:00:00.0002023-08-28T00:00:00.0002025-01-13T00:00:00.000 |
extension | datetime | In CSL Section 50 appeals, indicates the extended date on which the list established for the corresponding civil service examination is set to expire. Does not apply to CSL Section 76 appeals and will appear blank. | 98% | 2016-02-20T00:00:00.0002025-05-27T00:00:00.0002017-09-19T00:00:00.000 |
status | categorical | Indicates the status of the appeal as of the date of the creation of this record, which occurs on an annual basis. Appeals are either closed, meaning the appeal has ended, or remain active, meaning the appeal is still open as of the annual date of creation of this record. | 0% | ClosedActiveof 2 |
title | text | In CSL Section 50 appeals, indicates the civil service examination title for which Appellant applied. In CSL Section 76 appeals, indicates the civil service title Appellant held at the time the disciplinary penalty was imposed. | 6% | Police OfficerCorrection OfficerFirefighter |